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:Nestled in the heart of Hanover, just a short walk from Dartmouth College and downtown amenities, 126 Brook Hollow offers the perfect blend of convenience, comfort, and community. This desirable second-floor, three-bedroom, two-bathroom condo features an open-concept layout designed for effortless living. Fresh paint and new flooring throughout. The inviting living room, complete with a cozy wood-burning stove, overlooks Girl Brook, creating a serene space to relax and unwind. Enjoy direct access to scenic walking and recreational trails, perfect for outdoor enthusiasts. Additional highlights include reserved parking, ample interior and exterior storage, and shared community amenities, including a clubhouse and pool. Whether you're seeking a full-time residence, a Hanover pied-ŕ-terre, or a prime investment property, this Brook Hollow gem is an opportunity not to be missed. A one-time buy-in fee of 0.75% of the purchase price paid by the buyer applies at closing.