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 '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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: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:PRICE IMPROVEMENT! This 3 bedroom/2 bathroom home is ready for its next owners! Located in one of Lebanon's most desirable locations, the King's Grant neighborhood, it's close to shopping, dining, and schools, and backs up to Carter Country Club. The first floor features a mudroom or bonus room, office, and utility/laundry room and also connects to the garage. Upstairs, you'll find a large living room with high ceilings, a kitchen featuring brand new stainless steel appliances, and a dining area leading to a large, private deck. A primary bedroom with en-suite 3/4 bath and 2 other bedrooms which share a full bath complete the space. Hanover, Dartmouth Hitchcock Medical Center, and West Lebanon shopping are all within a 15 minute drive. You'll love living in the heart of the Upper Valley!