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 = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Classic Cape With Spacious Garage & Paved Driveway. Front Screened Porch, Rear Screened Porch/Entrance Room. Kitchen Leads To Dining/Living Room W/Ceiling Fans & Entrance To Front Screened Porch. 1st Floor Den/Office Can Be A Bedroom. Full Bath W/Washer & Dryer. 3 Bedrooms & 1/2 Bath on 2nd Floor. This In Town Home Allows Walking To Conveniences, Employment & Recreation.
Description:Welcome home to this lovingly maintained 1940 Cape offering 3 bedrooms and 1.5 bathrooms. This charming home blends classic character with thoughtful updates, including an updated kitchen, beautiful hardwood floors, and a convenient first-floor primary bedroom. The inviting mudroom provides the perfect transition from the attached one-car garage into the home, while the finished walk-out basement offers additional living space for a family room, home office, or recreation area. Step outside to enjoy a spacious backyard designed for relaxing and entertaining. Cool off in the above-ground pool, or let the kids enjoy the playground area. A large barn provides plenty of storage for recreational vehicles, equipment, hobbies, or all your outdoor toys. This well loved Cape is ready to welcome its next owners. Super location.
Description:MOTIVATED SELLER: Plainfield: This property features stunning mountain views and sunsets, which can be enjoyed from a spacious private back deck overlooking a sloping yard and pond. The grounds include pear trees, blueberry bushes, and apple trees. Inside, the home offers several updates, including newly painted bedrooms, a new kitchen floor, and a newer kitchen range, washer, and dryer. Additional highlights include Attached oversized two-car garage with built-in shelving, a workbench, and newer doors with auto-openers. An attached shed for extra storage. Several new windows throughout the home. Convenient location just 15 minutes from Lebanon and Claremont. 4 bedroom, 2-bath home is situated on 6.28 acres.
Description:Lovely, updated two-bedroom ranch offering easy one-level living with exciting potential for expansion! Ideally located just minutes from I-89, this move-in-ready home provides convenient access to everything the Upper Valley has to offer while enjoying wonderful privacy and quiet. The beautiful open lot features usable, level land, abundant sunshine, a greenhouse, gazebo, and plenty of room for gardening. Green thumbs welcome! Inside, the open-concept kitchen, dining, and living areas are filled with natural light from large windows. The elegant updated kitchen features quartz countertops, a new tile backsplash, and new appliances. One bedroom includes an ensuite three-quarter bath, while a second bright bedroom and full bath with tub complete the main level. The owners have made numerous thoughtful improvements, including expanding a half bath to add a new shower. The heated, full walkout basement features windows on three sides and currently provides substantial space for a home gym and hobbies, with tremendous potential to transition into additional finished living space. Outside, the front porch and stairs have just been rebuilt. A two-car attached garage and separate shed provide excellent storage. Whether you are a first-time buyer, empty nester, or simply looking for a well-maintained home at an attractive price point, this is an outstanding opportunity. Open House Saturday, August 15, from noon–3 PM. Come see all this wonderful Upper Valley home has to offer!
Description:Welcome to 34 Dogford Rd, a 3-bedroom, 1-bath, two-story home offering 1,352 sq ft of living space on a 0.60-acre lot. The property features gas heating, a durable metal roof, a brand-new entrance door, and a new hot water tank. The home needs updating, including flooring, ceilings, paint, kitchen finishes and countertops, windows, and siding. With its generous lot and solid footprint, this property offers an excellent opportunity for renovation and personalization.