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 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Bright, modern ranch-style condo in The Falls at Rivers Edge. This single-level home features an open-concept living, dining and kitchen area perfect for everyday living and entertaining, two comfortable bedrooms, two full bathrooms, a private office for remote work, and a handy storage room. Gleaming, contemporary finishes and a fresh décor create a stylish, move-in-ready atmosphere. An attached two-car garage offers generous storage and convenience. The PUD community includes an in-ground pool and quiet, well-maintained grounds, with easy access to Lebanon, Hanover and White River Junction. Perfect for downsizers, professionals, or anyone seeking streamlined, modern living in a desirable setting.
Description:One of the most desirable locations in the Falls at Rivers Edge! Sited at the end of the dead end road, this well-maintained home offers comfortable living with the convenience of a primary living space on the main level and additional rooms upstairs for guests or extended family. The sun-filled living room features hardwood flooring, a propane fireplace framed by built-in bookcases, and expansive windows that bring in abundant natural light while showcasing views of the private yard and striking natural ledge. The kitchen is both functional and inviting with granite countertops and flows easily to the dining and living areas. The spacious first-floor primary suite includes a large en suite bath and two walk-in closets. A dedicated office/study and half bath complete the main level. Upstairs, guests will appreciate their own private retreat with a loft area, bedroom and bathroom. Additional features include central air conditioning, hardwood floors in the main living spaces, a propane fireplace, granite countertops in the kitchen, and a roof that is approximately five years old. Recent improvements include a Trex deck with railings and new slider to the back deck, fresh interior paint throughout, new carpet, new gutters, new storm door, updated window treatments, new dishwasher, microwave and washer, new tile in two bathrooms. Ideally located near Dartmouth Hitchcock Medical Center, Dartmouth College, Boston Lot for hiking, shopping, restaurants and major highways.
Description:Move right in to this immaculate contemporary condo located within a mile of Dartmouth Hitchcock Hospital, and walking distance to the revered Coop grocery store, River Valley Fitness Center and just a short drive to downtown Hanover. With 2 bedrooms and 2 bathrooms, open kitchen/living/dining room and an outdoor patio, this is a very easy option. Washer/dryer in your unit. Heat pumps provide heating and cooling. 2 assigned parking spaces. A great one!
Description:Convenient, private and stand alone, this is a delightful unit at the end of the road at Pinewood Village. The inviting entry vestibule leads to a warm and cozy living room and dining room. Abundant windows and skylights provide great light throughout the unit. This level is completed by a spacious kitchen, a ground-floor primary bedroom with an attached bathroom, and a really cool den which backs up to the woods. A gas fireplace in both the living room and den adds to the warmth and coziness of these spaces. And you have a deck, accessible from the living room which also backs up to the woods- and is completely private. Upstairs you have another bathroom and a second very spacious bedroom. Downstairs there is plenty of storage and another bathroom. The unit has a one car garage with a second parking space outside if needed.
Description:Conveniently located just minutes from downtown Hanover, Dartmouth College, and Dartmouth Hitchcock Medical Center, this well-maintained townhouse at The Commons at Silent Brook offers comfortable, low-maintenance living in a beautiful setting. The bright, open floor plan features hardwood floors, a kitchen with granite countertops, and a private deck. Upstairs, you'll find two bedrooms plus a versatile loft space ideal for a home office or reading nook. The finished lower level provides additional living space for a family room, office, gym, or hobby area. Additional features include a heated garage with direct entry, thoughtful storage throughout, and access to beautifully landscaped common areas and nearby walking trails. Enjoy the convenience of Hanover living with the comfort and flexibility to make this home your own. Open house on Saturday from 1-3 and Sunday from 10-12.