SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') and (type = 'R' or type ='O')
and (createtime >='2024-05-09 22:58:44') and (createtime >='2024-05-09 22:58:44')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:What a great location!!! This is a corner lot with frontage on Route 120 and Perkins Road. It has a nice country setting. Easily accessable to the Upper Valley and the Claremont area. The house ia a fixer upper in need of work. The house has 2 bedrooms and 1 bath. The property is being sold "AS IS." The property will not be cleaned out. The property will not qualify for FHA or VA loans. Showings will start at the Open House on Saturday, May 18 10:00 AM to 12 Noon!!!
Description:"Waterfront Retreat on Post Pond: A Hidden Gem Nestled in the town of Lyme, New Hampshire, this waterfront camp offers an idyllic escape. Post Pond, a spectacular body of water, beckons with its serene beauty, inviting you to swim, kayak, and fish year-round on this 114 Acre lake with average depth of 23' and maximum depth 38'. Accessed only by boat, this camp promises seclusion and simplicity. Schedule your boat ride across the pond, where you’ll discover pure beauty as you sit on the porch and listen to the birds and enjoy the water views. Whether you’re an angler seeking trout and bass or an ice fishing enthusiast, this spot won’t disappoint. What sets this retreat apart? Electricity! Unlike most homes in the area, this camp boasts power. Delayed Showing until 5/25/24.
Description:A true taste of New Hampshire! This 4 bedroom 1.5 bath home sits on 4.2 acres on a paved road in Cornish. Attached 2 car garage with walk-up storage above, breezeway, wonderful 1st floor layout with Kitchen, dining, living room, den and a sun room! The second floor has 4 generous bedrooms and the full bathroom. Fenced back yard for dogs, which will be great to keep them out of the brook! Very private lower level with open field runs along Mill Brook and leads up to a hidden covered bridge! Cross the beautiful covered bridge and enjoy miles of walking trails. Showings begin Thursday 5/16.
Description:Welcome to your lakeside retreat, this single-family home offers not just a residence, but a lifestyle embraced by the tranquil beauty of Lake Mascoma. Wake up to breathtaking views of the pristine waters and spend leisurely days lounging by your private dock, perfect for boating, fishing, or simply soaking up the sun. Built in 2005, this home embodies modern elegance with its seamless blend of comfort and sophistication. With 4 bedrooms and 3 bathrooms, including a primary suite, there's ample space for residents and guests to unwind. The main level features an open concept design, ideal for entertaining, with hardwood floors throughout creating a warm and inviting atmosphere. A newly renovated finished basement provides additional living space for recreation, hobbies, or movie nights. The gourmet kitchen is a chef's dream, equipped with modern appliances, abundant counter space, and a center island. Step outside to your new backyard patio, perfect for al fresco dining, and barbecues. With updated amenities including mini splits, a newer roof, and a recent paint, this home offers peace of mind and low maintenance living for years to come. Within commuting distance of Dartmouth College, and Dartmouth Health, schedule your private tour today! The adjacent lot is included in the sale can be used to build a garage or keep for privacy and space. OPEN HOUSE on Saturday, May 19th from 10-12.
Description:Looking for a quiet, rural home but still close to amenities of the city? Look no further. This beautifully thought out home in Cornish is just what you need. 3 beds, 3 1/2 baths on 21 acres to explore, this could be your next home! Hosting company is a breeze with the versatility of the open floor plan between the living room, dining area, and kitchen. From the bottom to the top, this home has been carefully thought out and built with quality materials and comfort in mind. Insulated concrete form foundation, Renewaire full home air exchanger, hardwood finishes, 9 ft ceilings (including the basement) and cathedral ceiling in the primary bedroom make this home feel spacious and warm no matter where you are. Enjoy sitting on the Ipe wood front porch while music softly plays through the Sonos individual room controlled built in speakers, or inside by the fireplace on a snowy day. Stone veneer on the foundation is coupled with rot resistant trim boards to help keep this home in good condition. A heated mudroom and garage await to accommodate your year round activities. Come see what makes this home special! Delayed showings until Open House 5/18/24 12pm-2:30pm
Description:Combining traditional New England charm with an urban loft appeal, this gorgeous post and beam home blends luxury and creative artistic expression. The 15+/- ac property has extensive gardens, brick walkways, five decks and porches. Fabulous 28' vaulted ceiling in living room is highlighted by a towering fieldstone fireplace and a surrounding balcony library. Superb chef's kitchen with concrete counters and deep soapstone sink. Floor-to-ceiling southwest-facing windows. Three gorgeous bedroom suites. 1200 sq ft one bedroom in-law apartment above garage with separate entry. Bonus barn on lower property can be additional storage space or a quiet studio. This home is a magical work of art that will make your heart sing!
Description:Perched gracefully on the shores of Mascoma Lake, this exquisite and unique property offers a serene 3.26-acre private oasis with a sweeping 280 feet of direct waterfront. This meticulously updated home invites relaxation and enjoyment, whether gathering around a cozy fire at the water's edge or soaking in spectacular sunsets from the roof deck overlooking the lake. The house itself is a testament to superior craftsmanship and architectural thoughtfulness, featuring gorgeous oak flooring that adds warmth and elegance throughout. The kitchen is a chef’s dream, equipped with high-end Wolf appliances and granite countertops that meld functionality with luxury. Outdoor living is elevated to an art form here, with amenities that include a charming greenhouse, an invigorating outdoor shower, and a relaxing hot tub, all designed to enhance your connection with nature. The handcrafted wood and wrought iron staircase is a centerpiece and an art piece, exemplifying the bespoke detail evident in every corner of the home. Perfect for hosting and entertaining, the house includes three bedrooms and three bathrooms. The primary suite is a retreat within a retreat, with its beautifully tiled floors in the calming colors of the ocean and a large, walk-in tiled shower that promises a spa-like experience. The first-floor suite allows for comfortable living at every stage of life. This property was recently fully transformed with love and care, designed for life’s finest moments.