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 '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Adorable updated two bedroom ranch, two bathroom ranch in Etna! On a quiet country road, set on three private acres bordered by a stream. Open concept living spaces, office and 3/4 bathroom upstairs. Two bedroom and full bathroom in walkout lower level. Poured concrete pad in the driveway ready for a garage! Sunny and bright - this is such a happy spot!
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:Spectacular yard that gently slopes down to the Brook. With 273' along the brook, this is a special property. Ample space for large gatherings, camp fires or garden space. This light and bright 3 bedroom ranch has been updated over the years, with a modern kitchen and hardwood flooring. Relax by the woodstove in the family room or sit back and enjoy a book in the sunroom. Plenty of rooms for everyone to enjoy. There is a full unfinished basement, a wonderful back deck with a 2024 hot tub. Did I mention the oversized garage? 28 x 60' for parking, workshop area or just extra storage for all the fun toys you may acquire. In 2007 the septic was updated. 2.7 acres of land to enjoy. Located conveniently to shopping and just 15 Minutes to DHMC.
Description:A hard to find 4-bedroom home offering direct backyard access to Farnum Hill Preserve. Explore 5.7 miles of scenic trails across 864 acres right from your doorstep. This home features a stunning new kitchen with granite countertops, tile flooring, a Wolf propane range, and a spacious center island – perfect for cooking and entertaining. The open-concept dining area provides ample room for hosting family and friends. The main level features a large living room with hardwood flooring and a cozy corner hearth featuring a wood stove insert, creating a warm and inviting atmosphere. A first-floor bedroom and full bath offer the convenience of single-level living. Upstairs, you'll find three additional bedrooms, a full bath, and a generously sized walk-in closet. The full basement provides endless potential for expansion, including home office or exercise spaces. Situated on a 3.9± acre lot, this property includes a detached 2-car garage and two sheds for storing garden tools and outdoor gear. Enjoy the peace and privacy of this wooded retreat while being just minutes from I-89, shopping, dining, recreation, and all Upper Valley employment opportunities. This home is a must-see for nature lovers and those seeking comfort and convenience.
Description:Welcome to your brand-new home in Hanover! This beautifully designed new construction features a spacious open floor plan, ideal for both entertaining and enjoying peaceful nights at home. With convenient first-floor laundry hookups and a maintenance-free lifestyle, this home offers all the modern amenities you need. Hardwood floors, masterfully designed bathrooms with custom tile showers, a spectacular kitchen with Quartz countertops, fully appliances kitchens, and tile back splash. Primary Suite is stunning and offers lots of privacy from the rest of the home. Located just minutes from Dartmouth College, Dartmouth-Hitchcock Medical Center, and several ski resorts, it provides unmatched convenience and accessibility. Whether you're working on campus or exploring the vibrant Hanover area, this location can't be beat. Don't miss the chance to make this your new home—ready for immediate occupancy! Schedule a showing today and start imagining your life in this dream home. Home is complete and move-in ready! Last unit left! The seller is a licensed New Hampshire real estate broker.