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 (createtime >='2025-03-24 17:40:39') and (createtime >='2025-03-24 17:40:39')
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:What a delight ! A great price for a 2 bedroom condo in Lebanon! The layout offers a continuous flow, with plank flooring in living and bedroom areas. Enjoy a sunny and bright location with updated windows, and interior sliding doors. Newer rear decks installed, with staining scheduled for 2025. Washer and dryer in unit, with an area within the building for alternative storage.
Description:Discover this stunning home in a lakefront community, perfect for year-around or vacation living. Enjoy sunny, open-concept spaces with cathedral ceilings & all new Marvin windows. Relax on porches overlooking a serene garden, stream & waterfall, or dine on the charming dining porch. The sunny kitchen features granite countertops & center island. Stay comfortable year-round with a mini-split cooling system. Move-in ready with a new roof, four skylights, & an optional in-home gym. Mascoma Lake, hiking trails, & a dog park are just steps away, offering endless outdoor adventures. A perfect home for embracing lake life living. Showings begin on 04/05/25. Open house: 04/05 & 04/06 11:00 - 1:00. Please leave shoes on porch. Owner is a licensed NH Real Estate Broker.
Description:Spring is coming! Enjoy a pleasant walk to downtown Hanover and the Dartmouth campus from this three bedroom, two bath lower model Brook Hollow condominium. Many upgrades throughout - kitchen, baths, lighting, flooring. Direct street level access easily affords one level living. Two mini splits for your comfortable and efficient heating/cooling needs. Lovely, private views from the new balcony overlooking Girl Brook and the landscaped grounds. Just a few steps to access walking/cross-country ski trail. Get ready for summer fun in the new inground pool. Clubhouse with gathering room, full kitchen and bath can be reserved for your special events and parties. July 2nd occupancy. Come take a look! All showings begin with the Open House on Saturday, April 5 from 11:00 to 1:00 p.m.
Description:Light filled, well appointed 2 bedroom condo with open floor plan, built in cabinetry flanking propane firepalce, beadboard wainscoating, wide pine flooring and ample closet space. Gararge space with loft. Basement locked storage area. Small gardening plot for vegetables or perenials. Shared herb garden just outside the door. Owner rides his bike to work in Hanover, 30 mins!
Description:No. 1 COLLEGE HILL- Spectacular, updated end unit in ideal location within College Hill Townhouses. There is incredible light within the spacious interiors. Upgrades include a new kitchen with stylish counters, cabinets, & newer appliances, hardwood floors, carpet in basement & on stairs, primary bathroom, washer & dryer, and 2 Mitsubishi mini splits for effective cooling & heating. The living room has a cozy wood-burning fireplace and hearth. Within the nearly 1,900 square feet of living space are 3 bedrooms and 3 bathrooms. The Primary Bedroom has an incredible loft bedroom above it, also cooled for year-round usage. The lower level is large and versatile. Enjoy the private deck at the back and access to nearby trail networks. Some of the windows have also been replaced. Walk to Hanover Town, walk to the Co-Op for groceries. The unit is nicely furnished and furnishings are negotiable. SHOWINGS BEGIN with OPEN HOUSE SATURDAY, 4/5 10am-12pm.