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 '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Fall in Love with History and Location™ Discover the best of village living in this Lyme Green Gem! This unique and charming ground floor end unit boasts a second floor primary bedroom suite as well as a spacious first floor bedroom. Enhanced by stunning 1825 wide pine floors, original beams and custom built-ins throughout, this unit exudes warmth and and comfort. A nicely updated kitchen with sparkling new stainless appliances and a relaxing 4 season sunporch overlooking a spacious backyard complete the package! Ideally located across from the Village Green, you'll find yourself just steps away from the country store, post office, banks and hardware store...and just around the corner from the Lyme School and town library. Delight in dining in the popular restaurants just outside your door! And....enjoy endless recreational activities in the hiking trails, ponds, river and the Dartmouth Skiway! This is your opportunity to experience the vibrant and welcoming community of Lyme, in a historic setting, where location is prized ! * Seller is offering a "TURN KEY" option which would include valuable furnishings for $825,000. Details available upon request. Fall in Love with History and Location™