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='2') and (bedrooms='2')
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:Great Nature Walk unit - Upper Valley living at its best! Located on the quiet lower level, 2 bedroom, 2 bathroom condo with open concept living/dining/kitchen. Covered deck, private storage closet, designated parking spot, elevator, and exercise gym - a few of the great amenities. Huge hiking trail system right out your door and located perfectly to get everywhere you need to go!
Description:Sunny energy efficient condo has been well maintained by its original owner. Enjoy this upper level unit with elevator access, if you don't want to take the stairs. Open concept kitchen, dining and living area with hardwood flooring. Granite countertops in kitchen and two baths. Front deck off the living room. Features central air, security entrance foyer, fitness facility and large assigned storage space in the basement. Extensive trail system to Boston Lot trails next door and conveniently located to all Upper Valley employment, shopping and entertainment. Pets are allowed.
Description:Fall in Love with History and Location™ Discover the best of village living in this Lyme Green Gem! This unique and charming first 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™