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:With beautiful views of Mascoma Lake, this 4 bedroom home is ready to move in! 5.5 acres, zoned Community/Business, this property has frontage on 2 roads. Very sunny and bright, and quite convenient to all the amenities of the Upper Valley. Only 16 minutes from DHMC.
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:REDUCED PRICE, RECENT UPGRADES, MOTIVATED SELLERS Roomy colonial home in a developed quiet neighborhood conveniently located to town, yet just off the main highway enough to allow for peaceful living. Quality wood cabinets in the kitchen. Spacious mud room with ample closet space. Sizable closets in all bedrooms. Huge master bedroom. This home has storage space. Nice, private back yard. Comfortable front porch overlooking the local scenery. Walking distance to a 9 hole golf course. Minutes to major shopping, gas, town offices, theaters, civic events, employment, Dartmouth College and Dartmouth Medical Hospital, 2 highway interstates, local skiing, local ski jump, rail trails, community centers, Lebanon Municipal Airport, lakes, ponds, and rivers, woods, fields, and hill tops.
Description:Envision the exclusive pleasure of owning 1.5 acres of property complete with your very own swimming pond, located in the desirable town of Hanover. This contemporary, a mere 6 minutes from Hanover, Main Street and 15 minutes from I-89, offers both privacy and convenience. Historically owned by a family, the home has been cleverly configured to included two separate rental units with their own kitchens, providing potential income opportunities or accomodations for guests. The primary living space, used by the owners, features modern updates and expansive windows that frame captivating views of the serene pond. For those inclined towards customization, the rental units can be seamlessly integrated into the main living area to create a spacious single-family home. Alternatively, maintaining the current layout offers continued benefits as a rental property. With Mink Brook gracefully meandering through the landscape, this property is not only a peaceful retreat but also a promising investment. There is all new wiring, new carpet, new energy efficient boiler, new chimney liner, new baseboards, new toilets and has had a septic inspection. This property has unique features and a prime location, making it an exceptional opportunity for both personal enjoyment and financial growth.
Description:Discover a rare gem in the heart of Lebanon—this expansive single level 4-bedroom, 4-bathroom home is nestled on 43 picturesque acres. Enjoy stunning westerly views, ample living space, and the perfect blend of privacy and convenience. This unique property offers the tranquility of country living with all the benefits of being close to town. With several acres of open pasture land and a barn/stable the property would be well suited for horses or other grazing animals. The 10 KW solar array reduces current power demands with room for future expansion. A fantastic opportunity to create your ultimate dream home. Imagine snowshoeing, and cross-country skiing on your own land in the winter while enjoying the pollinator flowers and organic vegetable gardens by the half basketball court. The downstairs includes a library, bar, and a large space to create what you want. In addition, the property benefits from easy access to downtown Lebanon, Dartmouth College, Dartmouth-Hitchcock, I89 and I91, Lebanon Airport, and Dartmouth Coach goes to New York or Boston. Don’t miss out on this exceptional opportunity located at the end of a dead-end road! Home is being sold as is.
Description:A wonderful opportunity to live within the Hanover community! This 4 bedroom, 3 bathroom property boasts spacious floor plans in both the main home and guest house. The main house includes a large primary en-suite, 2 additional bedrooms, a study (which could be easily set-up as a 4th bedroom), an open concept kitchen, living and dining area, a walk-in pantry, a family room, and an exercise area. The guest house is a perfectly appointed space with a kitchen, living room, bedroom, full bath, laundry and storage. The main house and guest house are connected by an oversized deck, and if desired, both structures could be connected to create one larger space. This property provides comfortable indoor and outdoor living and is situated on over 3 1/2 acres of land with beautifully manicured upper and lower yards for endless outdoor entertaining. The property is surrounded by abundant trails for hiking, biking and cross-country skiing. The solar trackers are an added bonus and provide a significant reduction in annual utility expenses. Only 15 minutes to DH, 10-15 minutes to the Hanover schools and the Dartmouth campus, 15 minutes to I-89 and I-91. Showings start tomorrow at the public open house, Saturday 10/26/24 from 10 AM - 1 PM.
Description:Fabulous 4 bedroom, 4 bathroom 2006 Colonial located a short walk to Dartmouth College, Hanover Main Street and lovely walking trails! The main floor has a flexible open floor plan with a large kitchen, dining room with fireplace, living room that opens to the back deck, generous mud room and half bath. Beautiful Australian cypress wood floors throughout. The second floor has the primary bedroom suite with walk in closet and en-suite bathroom, two additional bedrooms that share a full bathroom, laundry room and office area. The third floor has a bedroom, full bathroom and a large bonus room with hardwood floors. Great additional space in the basement perfect for a game room, tv room or workout area! Complete with a detached two car garage and large yard. The perfect spot to call home! Open house Saturday 2-4pm.
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. Showings begin at the open house Sat 9/21, 10a-12p. (virtual staging used)