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='1') and (bedrooms='1')
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:Enjoy effortless living in this charming 1-bedroom, 1-bath Ivy Place condominium, offering both affordability and convenience in a prime location near DHMC, Dartmouth College, and I-89. Featuring brand-new carpet in the bedroom and essential utilities—trash, heat, water, and sewer—included in the monthly fee, this home is perfect for anyone seeking a low-maintenance lifestyle. Plus, take advantage of fantastic association amenities, including an outdoor pool and fitness center, adding to your comfort and lifestyle. Whether you're a first-time buyer, downsizing, or looking for an investment opportunity, this condo is a must-see!
Description:One bedroom condominium at The Greens in Hanover: a small, private condo association with 28 homes. This unit is lovely and bright and has a south facing deck for warm weather use. The community offers fine dining every day at noon, as well as many activities such as exercise classes, movie nights, art classes, weekly happy hour, and frequent lectures and entertainment. Located in the vibrant small town of Hanover, NH, home of Dartmouth College. Buyer to pay one time $2700 buy in fee at closing. Open House Sunday, April 12 from 10-12am
Description:Stylish and efficient, this 1-bed, 1-bath condo at Treetops offers 826 sq ft of comfortable living just minutes from Dartmouth and DHMC. Built in 2019 with high-quality steel and concrete construction, the unit features wood floors, stainless appliances, and oversized windows for great natural light. Enjoy underground parking, elevator access, a rooftop terrace, fitness room, gym and more. With high-efficiency insulation and a modern ventilation system, this pet-friendly condo is ideal for low-maintenance, Upper Valley living.