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 ='T'
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to your brand-new home in Hanover! This beautifully designed new construction features a spacious open floor plan, ideal for both entertaining and enjoying peaceful nights at home. With convenient first-floor laundry hookups and a maintenance-free lifestyle, this home offers all the modern amenities you need. Hardwood floors, masterfully designed bathrooms with custom tile showers, a spectacular kitchen with Quartz countertops, fully appliances kitchens, and tile back splash. Primary Suite is stunning and offers lots of privacy from the rest of the home. Located just minutes from Dartmouth College, Dartmouth-Hitchcock Medical Center, and several ski resorts, it provides unmatched convenience and accessibility. Whether you're working on campus or exploring the vibrant Hanover area, this location can't be beat. Don't miss the chance to make this your new home—ready for immediate occupancy! Schedule a showing today and start imagining your life in this dream home. Home is complete and move-in ready! The seller is a licensed New Hampshire real estate broker.