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 (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This property is a prime opportunity for rehab investors and buyers seeking a project with significant upside. With 11 rooms, including 5 bedrooms, situated on nearly half an acre and connected to public utilities, the potential for transformation is immense. While this home requires substantial renovations, its size and location make it a compelling investment. Located a short distance from I-89 and downtown Lebanon. Sold as-is, this property is ideally suited for cash buyers or those qualified for rehab loans.
Description:Charming 1840 cape nestled in the heart of town, exuding historic allure and character. Situated in a quaint neighborhood with a picturesque common nearby. This property boasts a potential spacious backyard, perfect for outdoor activities or gardening. Savor the sounds of flowing water right in your back yard with the Grant Brook that abuts the property. Enjoy the convenience of walking to school, the library, and restaurants. Only minutes away from Dartmouth Skiway, Interstate 91, Dartmouth College, and Dartmouth-Hitchcock Medical Center. One of the many perks to living in this community is Lyme kids through their school years ski for free at Dartmouth Skiway. Immerse yourself in a vibrant cultural scene with an abundance of community events and concerts on the common. Benefit from school choice for high school and embrace the warmth of a close-knit community. This home is ideal for hosting gatherings, with plenty of spacious areas to accommodate guests and create memorable moments. Check the list of maintenance/repairs on the Property Disclosure under documents.
Description:HUGE PRICE REDUCTION! Abundant Sunshine fills this 2017 Colonial situated on 1.75 acres offering 4 bedrooms, open concept layout, sunshine galore makes your living space bright and inviting, gleaming hardwood floors, convenient 1st floor living w/laundry, 3/4 bath & bedroom, 2nd floor offers 3 bedrooms, a full bath and great closet space everywhere. The attached oversized 2 car garage flows seamlessly into the heated entry room with abundant storage affording ease with the comings and goings that your busy day entails. The lower level is impressive with it's high ceilings, easy expansion possibilities, Buderus propane boiler and spray foamed for add'l heat efficiency. The detached barn screams quintessential New England and offers two levels for game room, "toy" storage, third car garage or hey, why not rent the bay for seasonal storage and extra income. All this and a commuters dream! A hop & a skip to Mascoma Lake and only 1 mile to I-89 for easy access to Dartmouth Hitchcock Hospital and all Upper Valley Amenities.
Description:Gorgeous Lakefront! Sail, canoe, kayak or boat from your dock in the summer and skate, ski, or snowshoe in the winter. This property has it all! Lake views, mountain views, enchanting sunsets, bald eagle sightings and the haunting call of the loons. From the moment you enter this newly renovated contemporary home, you will be greeted with views and sunshine. The easy open flow and abundant windows framing the exquisite views are sure to impress you, while the quality craftsmanship can be observed in every room from the two center stone fireplaces to the custom Dana Robes built cherry shelving. Recent renovations include a high end designer chef's kitchen with Induction Wolf Range, double ovens and built-in microwave, Sub Zero Refrigerator, Bosch Dishwasher, elegant wine cooler and gorgeous counters opening to the sun filled dining area. Not only do you have a light bright open floor plan with a wrap around deck overlooking the water but there are also 4 bedroom and home office options complimented by 4 recently renovated custom bathrooms including the primary suite bath with sumptuous sauna. The Village abuts acres of conserved land for you to explore and the local rail trail is nearby for hiking and biking pleasure. This little piece of paradise also includes an attached two car garage, beautiful stonewalls and is located only minutes from Dartmouth Health, Dartmouth College and Mt. Cardigan. (virtual staging used)
Description:Mastlands, named for the towering Eastern white pines once used as ship masts, is a historic Cornish Art Colony estate nestled among trees, farmland, and exquisite gardens. Once the summer home of Dr. Arthur Nichols and his family, it carries a rich legacy, with his daughter, Rose Nichols - a prominent landscape architect - designing the walled garden off the piazza, inspired by her uncle Augustus Saint-Gaudens and architect Charles Platt. The estate's 24 acres feature revived gardens, seasonal blooms, restored fountains, and peaceful retreats like Pine Tree Alley and a firepit. The property offers great outdoor opportunities, with access to a nearby Class 4 road connecting to the scenic River Road, ideal for walks, and additional paths around the cornfields for leisurely strolls. The grand living spaces featuring high ceilings and intricate moldings, including a ballroom wing with elements salvaged from a European chateau, combine historic charm with modern comforts and is crafted for sharing with loved ones. A versatile one-bedroom apartment offers independent living or rental potential, making Mastlands a perfect home for those who cherish history and seek to continue its stewardship. Showings begin 9/3.
Description:A breath of fresh air on the in-town Hanover real estate market, this very pretty house is located close to the end of a cul-de-sac and also close to an access for the Appalachian Trail. With a large 1.89+/-ac lot, the open floor plan makes the kitchen/dining room/living room/sunroom a truly welcoming space and wonderful for entertaining. Newer primary suite is spacious and has privacy and quiet. 3-4 additional bedrooms and 2.5 additional bathrooms complete the picture. First floor laundry. Two potential offices. Sunset views. Two car attached garage. A great one!
Description:A special opportunity to acquire a generously proportioned, privately situated, carefully maintained home in Hanover, NH. In 1989, a business owner and Dartmouth alum collaborated with a noted architect to construct a thoughtful residence on over 3 acres — just short of the cul-de-sac in a quiet neighborhood, roughly halfway between the Lyme Green and Dartmouth Green. Offered for the first time. This 5-bedroom, 5-bath lends itself to a multiplicity of shared living arrangements. The stucco-clad section of the house centers on a courtyard defined by stone walls. The potential large quarters above the oversized three-car garage might be ideal as an independently accessible space for in-laws or teenagers. There is a further space on the lowest walkout level of the house that has historically been used as an attractive office space. Fireplaces, rarely used in the 35 years, anchor the two separate living rooms. The atriums on each flanking end of the house help to define the unusual aspects of this home. The more dramatic atrium, accessed via the front door, floods, the house with light. The entire interior and exterior were recently painted, and newly installed hardwood floors add a fresh glow to the house. Generous storage space and closets abound. This uncluttered house is entirely appropriate for rapid occupancy and yet lends itself to possible re-imagination by new owners. Enjoy privacy and main highway access to Hanover and Lyme, and I-91 from this singular home.
Description:Nestled on one of the most serene roads in Lyme, this stunning 1988 colonial reproduction farmhouse seamlessly blends with the picturesque countryside. Lovingly maintained and thoughtfully upgraded over the years, the property features a notable 2009 addition by Vermont Vernacular, including a spacious dining room, mudroom, laundry room, garage, and an inviting in-law suite above the garage. The home exudes warmth with its hickory flooors, abundant natural light, and cozy, welcoming spaces. The heart of the house is the expansive, functional kitchen, where you can gather around the pellet stove for a warm, comforting ambiance. The dining room, with its large windows, offers stunning views of the gardens and the rolling hills beyond, creating a perfect setting for meals with a view. Trout Brook, meandering below the property, provides a soothing soundtrack year-round, enhancing the tranquility of the setting. The large, heated garage, with a versatile guest suite above, is perfect for guests or an artist’s studio. The architectural details, including archways inspired by those on the carriage sheds at the historic Lyme Congregational Church, add to the home's unique character. Set on 21 acres and conveniently close to the Dartmouth Skiway, Post Pond, and an extensive network of hiking trails, this property offers an exceptional opportunity to embrace the great outdoors right at your doorstep. Open House Friday 9/6/24 5-7pm Cocktail Hour and Saturday 10-12n Mimosa Bar