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 '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley Area NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Showings begin at the open house on Saturday, March 8th, 10 am - 2 pm. Nestled in the heart of Hanover, just a short walk from Dartmouth College and downtown amenities, 107 Brook Hollow offers the perfect blend of convenience, comfort, and community. This desirable first-floor, three-bedroom, two-bathroom condo features an open-concept layout designed for effortless living. The inviting living room, complete with a cozy wood-burning stove, opens to a sunny deck overlooking Girl Brook, creating a serene space to relax and unwind. Enjoy direct access to scenic walking and recreational trails, perfect for outdoor enthusiasts. Additional highlights include reserved parking, ample interior and exterior storage, and shared community amenities such as a clubhouse and pool. Whether you're seeking a full-time residence, a Hanover pied-ŕ-terre, or a prime investment property, this Brook Hollow gem is an opportunity not to be missed. Showings begin at the open house on Saturday, March 8th, 10 am - 2 pm.
Description:Enjoy the convenience of this lovely bright 2 bedroom 2 bath LEED-certified single level condo. Located within walking distance of Dartmouth Health and close to all the upper valley has to offer. Open living, dining, kitchen with bamboo and tile flooring, granite countertops and a mini-split. Amenities include covered parking with a locked storage unit close to the condo entry and one additional parking space. Delayed showings starting Saturday April 12 for open house - 12:00-2:00.
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!
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.