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 list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Showings begin at the open house on Saturday, March 8th, 10 am - 2 pm. Nestled in the heart of Hanover, just a short walk from Dartmouth College and downtown amenities, 107 Brook Hollow offers the perfect blend of convenience, comfort, and community. This desirable first-floor, three-bedroom, two-bathroom condo features an open-concept layout designed for effortless living. The inviting living room, complete with a cozy wood-burning stove, opens to a sunny deck overlooking 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 such as 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. Showings begin at the open house on Saturday, March 8th, 10 am - 2 pm.
Description:Enjoy the convenience of this lovely bright 2 bedroom 2 bath LEED-certified single level condo. Located within walking distance of Dartmouth Health and close to all the upper valley has to offer. Open living, dining, kitchen with bamboo and tile flooring, granite countertops and a mini-split. Amenities include covered parking with a locked storage unit close to the condo entry and one additional parking space. Delayed showings starting Saturday April 12 for open house - 12:00-2:00.