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 (createtime >='2024-12-13 4:19:33') and (createtime >='2024-12-13 4:19:33')
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:Just completed and ready to move into! Begin the new year in this 2024 new energy efficient split entry on a paved dead end street within walking distance to the village. This new home will check all your boxes with granite counters, breakfast island, under counter lighting, and stainless steel appliances. Mini Split in the open area kitchen/dining/living room. Slider to the rear yard private deck. South facing & sun filled foyer with oak stairs to the living area and lower finished level. Wood look flooring through out. A 25x13 primary bedroom will wow you with a 9x9 walk in closet and 9' ceilings. Baths on the first floor and lower level with closets. Bedroom with closet & utility/storage room on the lower level. Multi zone FHW Viessmann heating system plus mini split. Relax on your back deck or go for a walk on the nearby Northern Rail Trail. Cell phones work here and cable is available. Be the first to see this new home! 15 minutes to Lebanon, Dartmouth Medical facility, I -89 & I-91. You will love the location!
Description:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.