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 35
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Charming 1949 lakeside ranch offers a rare blend of classic character just steps from Crystal Lake, known for its clear waters, recreation, and year-round beauty. Set directly across the street from the lake, the home is paired with an additional attached parcel on the water. Inside, the home features three bedrooms and two baths, with a warm, functional layout that reflects its mid-century roots. A partially finished basement adds valuable flexible space, ideal for a family room, home office, or guest overflow. Large windows invite in natural light, while the setting provides stunning lake views and a peaceful atmosphere.
Description:Timeless 1820 Brick Colonial on 15 Stunning Acres. Step back in time while enjoying modern comfort in this beautifully maintained 1820 classic brick Colonial set on 15 picturesque acres of open fields. Rich with historic charm and character, this exceptional property features wood floors, elegant crown molding, and multiple fireplaces that create warmth and sophistication throughout. The spacious main home offers gracious living areas filled with natural light and period details, perfect for gathering and entertaining. A separate in-law apartment provides flexibility for extended family, guests, rental income, or a private home office. Outside, the possibilities are endless with a large traditional barn, two separate garages, and expansive open land ideal for gardening, horses, farming, recreation, or simply enjoying the beauty and privacy of the countryside. This rare offering combines historic craftsmanship, versatile living space, and breathtaking acreage—a property with endless potential and timeless appeal.
Description:Some homes are just houses. This one has been a home. Filled with the laughter and memories of a large family, 6 Orcutt Avenue carries a warmth that is hard to manufacture. The owner has brought a special eye for design to every corner of this property. Go ahead and search the market. You will be hard pressed to find a home with a more thoughtfully executed interior design and layout at this price point. Tucked away on a quiet street yet completely walkable to elementary school, the location checks every box for families looking for the perfect balance of privacy and convenience. And when you step into the backyard, you will immediately understand the love that has been poured into this property. A tremendous patio, a fully fenced yard, and the kind of outdoor space that is ready for the next family to make memories of their own. Don't miss your chance to own a home with great bones, an unbeatable West Lebanon location, and a backyard that was built for living.
Description:Spacious and full of character, this 5-bedroom home offers a flexible layout with generous living space. Enjoy a beautifully updated kitchen featuring new appliances and marble countertops, along with hardwood floors that add warmth and timeless appeal throughout much of the home. Bathrooms include an updated tile shower, adding a modern touch to the home’s character. Conveniently located just minutes from downtown Lebanon, Dartmouth Health, Dartmouth College, shopping, dining, and Interstate 89. A standout feature is the large detached barn, perfect for storage, a workshop, hobbies, or additional workspace. With tasteful updates and endless possibilities, this unique Upper Valley property offers exceptional versatility.
Description:Experience the timeless charm of this classic 1903 Victorian with a beautiful carriage shed, ideally situated on a generous half-acre lot just minutes from the heart of Enfield and a short drive to Mascoma Lake. Rich in character and architectural detail, this four-bedroom, one-and-a-half-bath home has beautiful wood floors throughout, soaring ceilings, an elegant staircase with a stunning stained-glass window, a living room with fireplace and a formal dining room perfect for entertaining. The third floor offers unique additional space featuring beautiful wainscoted ceiling and walls and period charm. Outside, a carriage shed provides endless possibilities for storage, hobbies, or workshop space or convert into living space! Conveniently located walking distance to town for coffee or dinner or hop on the rail trail just a block away! Don't miss the grand home! Super location just 20 mins to Dartmouth Health! Showings by appointment.