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: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:What a spot, hidden in plain sight, the location and setting will not get better than this one. A nice floor plan includes an entry area with closet, two bedrooms with ample sized closets, full bath, a half bath and a laundry area all on one level. The River Ridge Condominium complex is nicely set back from the street and attractively landscaped. Unit 8 includes two parking spaces, one in the carport, and it affords ease of access via a covered walkway to the entry of your home as well as to your storage unit. All the amenities that Hanover has to offer are just around the corner!!
Description:Views and energy efficiency - two wonderful attributes of this Green Built contemporary condominium located in Hanover, NH and a short walk to Dartmouth Health. This 2008 open concept unit features local views from almost every window, stainless appliances, granite counters, tiled baths, bamboo flooring, a mini split for heating and cooling and a covered deck. This unit also comes with 2 parking spaces, one is in a covered spot with a good size storage closet. Don't miss this opportunity to be conveniently located, near public bus transit and walking distance to Boston Lot for hiking and biking.