SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and type ='L'
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Land / Acres page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:INCREDIBLE VIEWS OF MASCOMA LAKE - This enchanting property has it all, brooks and streams and meadows and forests! Build your secluded Upper Valley dream home, subdivide and fulfill many family's dreams, or start that cross country equestrian center you've always dreamed of. The historic barn is an incredible resource for massive beams and boards. Situated close to Dartmouth Hitchcock Medical Center, Dartmouth College, Vermont Law School, Colby-Sawyer College, Green Mountain Horse Association, shopping, skiing.
Description:MIXED USE ZONING, UTILITIES AT SITE, Residential at 13 UNITS/AC @ $8000/UNIT. Retail - BEST AND POSSIBLE ONLY feasible RETAIL SITE FOR MARKET AREA. Neighborhood retail underserved. Upper valley and few Industrial sites within 20 miles. Only area business park is sold out. Ongoing demand from Dartmouth start ups. TIF district FOR ON/OFF SITE UPGRADES, quick town approvals. Adjacent add on of 200 acres in Canaan available. No zoning. 20 minute drive to Medical Center or Campus via I-89 or back country roads. Adjacent is Hanover, with few housing options. Lot prices exceed $300,000. Bargain price for additional 5 minutes drive. Most regional recreation amenities are in Enfield. Ski slope, world class golf course, clean lake Mascoma, 1000 acre open space, rail trail. High ground south sloping with mountain views. Several access points. Road front outparcels available.