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 '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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:* PRICE IMPROVED + BUYER INCENTIVES OFFERED* Welcome to easy living in this spacious and bright 3-bedroom, 3-bath condo located in a desirable 55+ community. Set within a duplex of the Quail Cottages association, a division of the Quail Hollow community this inviting unit offers a comfortable layout with plenty of room to relax, entertain, and make it your own. Enjoy the popular sun porch, a one-car garage, and the convenience of a shared paved driveway. The roughed-in basement provides separate space for the utilities, excellent potential for future living space, or hobby area, while the partially finished second floor adds even more flexibility for guests, storage, or a home office. A wonderful opportunity to enjoy low-maintenance living with space to personalize; especially with the additional seller concession of $5,000!!
Description:Beautifully renovated 2 bedroom, 2 bath home all on one level. Spectacular three season porch with sliding door from the heated living space, useable even on a sunny winter day, and fabulous in spring and summer. Exceptional primary bathroom, beautiful cook's kitchen. Solar energy provides the heat, hot water, and cooling. 2 car garage. Refinished with great flair! Light and bright throughout. The best! One time buy-in fee is 1.5% of the sale price. OPEN HOUSE SATURDAY, JULY 25TH, 10-12.
Description:FRESHLY PAINTED WITH NEW FLOORING IN SEVERAL ROOMS - Welcome to Quail Hollow, a well-loved age 55+ community in the heart of the Hanover/Lebanon, NH, area of the Upper Valley. This 3-bedroom, 3-bathroom property offers over 2,600 square feet of finished space and is just minutes from both the Dartmouth College Campus and Dartmouth Health Medical Center. The main floor includes a kitchen, dining room, living room, sun porch, primary bedroom en-suite with a full bath, laundry, and second bedroom and 3/4 bathroom. The upper level offers a secondary primary en-suite with a full bathroom. The walk-out basement has over 1,100 square feet of newly finished space perfectly suited for a recreation room, office and exercise room. The living room has a vaulted ceiling with floor-to-ceiling windows, and natural light fills every space, including the basement. Several photos are digitally staged. This is a must see.
Description:Tucked away in West Lebanon just minutes from downtown Hanover and Dartmouth College, this spacious and immaculately kept condominium offers a blend of elegance and everyday convenience. The impressive great room boasts soaring cathedral ceilings and connects seamlessly to a warm, welcoming kitchen and a bright sunroom just off the dining area. Designed for comfort and longevity, the main floor features a primary suite with a large bathroom and walk in closet, along with a secondary bedroom and additional bath. Upstairs, a substantial flexible area with its own bath works exceptionally well for guests, a home office, or a media room. The basement adds even more square footage, featuring a finished space ideal for hobbies or recreation alongside generous storage and workshop areas. Complete with an attached one-car garage that opens directly into the kitchen, this functional layout delivers easy Upper Valley living in a prime location.