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='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 30
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Experience lake life at its best! Offering 67 feet of direct Mascoma Lake frontage in Lebanon, NH, this 3-bedroom, 3-bathroom home delivers a combination of modern updates, exceptional outdoor living, and true waterfront enjoyment. Inside, the bright, renovated kitchen sets the tone with updated finishes, great natural light, and an easy flow into the main living areas. The home’s layout is designed for both relaxation and entertaining, culminating in a walkout finished basement complete with a bar - perfect for hosting year-round. Step outside and the property becomes a true retreat. Listen to loon songs, sun on the floating dock, and grill on the deck. Multiple deck spaces overlook the water, offering room for dining, lounging, and taking in the views. Enjoy the convenience of an outdoor shower, ideal after a swim or a day on the lake. A 24’ private dock provides direct access for boating, kayaking, and fishing. With its combination of updated interior spaces, standout outdoor amenities, and prime lake frontage, this property is an exceptional opportunity to own a piece of Mascoma Lake. Showings to begin at Open Houses Friday 8/7 3-6pm and Saturday 8/8 1-3pm.
Description:Quiet contemporary cape nestled next to a peaceful brook. The location is only 2 minutes from the Dartmouth Skiway and Appalachian Trail, 4 minutes from the Lyme Green, and 20 minutes from Hanover. The spacious main floor is filled with light from large windows that overlook the backyard where blue birds, swallows, grossbeaks, and hummingbirds nest. The warm living room provides access to a private office, a bright mudroom, the dining room, and opens to a large cedar deck including a fully screened area perfect for outdoor dining. A master bedroom with full bath, a den, and a newly remodeled kitchen complete the first floor. Upstairs is a cozy bedroom with 3/4 bath and four skylights that offer nighttime views of the Milky Way. The basement includes a private entrance, mudroom, bedroom, and full bath. Unfinished spaces in the basement include a large workroom and a laundry room. A 2-car garage has direct access to the laundry room and stairs leading to the 1st floor mudroom. Built-in shelves, nooks, and crannies can be found throughout the house, and there are a multitude of closets and storage spaces. Open land on three sides of the 1.1-acre property provides a genuine sense of privacy and seclusion. The creek has a private swimming and fishing hole, and a large, fenced yard contains a sand box and numerous gardens and flower beds. Mature blueberry bushes, prolific raspberry patches, productive asparagus and rhubarb plants, and strawberries provide an annual summer bounty. 201 Dorchester isn't simply a home - it's a private refuge from the hustle and bustle of everyday life.
Description:Gorgeous New Hampshire Lakefront! Wake up to breathtaking unobstructed views of Mascoma Lake in this beautifully situated Shaker Village home. Located across from the peaceful Shaker Museum walking grounds, this end-lot offers privacy while still being part of the sought-after Chosen Vale community. Outdoor enthusiasts will love the easy access to boating, swimming, ice fishing, skating, sledding, snowshoeing, hiking trails in the Lower Shaker Wildlife Management Area, and nearby skiing at Whaleback Mountain. This home boasts direct access to a dock slip and is just a short walk to two shared beaches. Additional features include heat pumps, Powerwall backup battery system, electric vehicle charger, and recently installed on-demand boiler. Conveniently located just 15–20 minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, and White River Junction, this property offers the perfect balance of lakeside tranquility and accessibility. Open house: Sat 8/29 12noon-2:00pm
Description:Located just a half mile south of the Dartmouth Green, this beautifully updated raised ranch offers the perfect blend of comfort, flexibility, and convenience. Tucked on a level, landscaped lot with lawn space and landscaping, the home provides an easy lifestyle in a truly exceptional location, walkable to downtown, schools, dining, and recreation. The thoughtfully designed main level features three bedrooms--one ensuite with a 3/4 bath and two that share an additional full bath. Sunlight fills the welcoming living room, while the adjoining dining area opens seamlessly onto a deck - ideal for morning coffee or summer BBQs. The updated kitchen offers both style and functionality, creating a warm central gathering space for everyday living. The finished lower level adds remarkable versatility, with a large family room centered around a cozy wood stove, perfect for relaxing evenings or casual entertaining. A full bath, laundry room, dedicated office, and smaller bonus room provide flexible spaces to work, create, or host guests with ease. Direct access to the attached one-car garage adds everyday convenience, especially during New England winters. With recent updates, abundant usable space, and an unbeatable in-town setting, this move-in-ready home offers the rare opportunity to enjoy comfort, character, and walkability in the heart of Hanover. Furnished photos are virtually staged.
Description:This beautifully renovated 3-bedroom, 3-bath split-level home offers the perfect blend of modern updates and an unbeatable Hanover location. Thoughtfully redesigned from top to bottom, the property features all-new siding, roof, windows, central air conditioning, and stylishly updated kitchen and baths. Bright, comfortable living spaces and a versatile floor plan make everyday living and entertaining effortless. Set in a sought-after neighborhood within easy walking distance to the highly acclaimed Hanover elementary and middle schools, this turnkey home combines quality, convenience, and timeless appeal.