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:Escape to your own slice of paradise with this cozy 3-bedroom, 2-bath log cabin nestled on 34 pristine acres. Featuring an open floor plan, the living space is bathed in natural light, highlighting the beautiful pine and hardwood floors throughout. Step outside to enjoy a new expansive deck. The front porch provides the perfect spot to enjoy your morning coffee as you unwind while soaking in breathtaking mountain views and the serene ambiance of your very own pond. The property boasts ample garden space, perfect for cultivating your green thumb, and is an ideal setting for a potential barn and horses, making it a dream for equestrian enthusiasts. A detached 2-car garage provides extra storage or workshop space. Located just a short drive from Dartmouth College and Dartmouth Hitchcock Medical Center, this retreat offers the perfect blend of tranquility and convenience. Don’t miss your chance to own this unique property—schedule your showing today! Open House November 3, 2024 11-2.
Description:This 3 bedroom ranch sits on 6.2 remote acres out in the rural stretches of the Hanover School District. With a large shop space and expansive gardening space, this is a wonderful location to enjoy. This property is a part of the Rennie Road Value Assurance Program provided by Dartmouth College. For more information, please ask the agent or your buyer's agent!
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.