SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and type ='L'
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Land / Acres page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Located at the strategic intersection of RT 89 Southbound Exit 13 and RT 10 South, this expansive 13.4-acre tract offers an unparalleled opportunity for development. Previously engineered for a 100-room hotel, the site includes detailed plans and drawings, showcasing its potential. Situated directly across from Sawyer Brook Plaza and a Mobil station, the property benefits from substantial daily traffic, with AADT counts reaching 6,794 on RT 10 South and 18,701 on I89 South. This commercial land is zoned for versatile use, allowing for a variety of development projects subject to approval. Key features include a high-yield well and necessary provisions for a bridge to maximize access and utilization. Just 20 minutes from Dartmouth Hitchcock Medical Center and Mount Sunapee Resort, and a two-hour drive from Boston, MA, the site is ideally positioned to cater to both local and tourist traffic. Don’t miss out on this prime piece of real estate, ready for a visionary development.
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.