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 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.