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 50
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to this beautifully updated Cape-style home featuring a two car garage and a level, landscaped yard-perfect for relaxing or entertaining. Thoughtfully designed, this home offers abundant space for family gatherings and special occasions. The stunning kitchen is a chef's dream, complete with stone countertops, a large center island the comfortably seats four, and new stainless steel appliances. Just off the kitchen, the expansive dining room provides ample space for hosting large family dinners. Sunlight pours into the inviting living room, which flows seamlessly into a den with a charming fireplace. A stylish renovated 3/4 bath completes the first floor. Upstairs, you'll find two comfortable guest bedrooms, and a private suite featuring a walk-in closet, private sauna and direst access to a remodeled 3/4 bath. The finished walkout basement offers even more living space with two additional rooms, a generous family room and a third 3/4 bath. With plenty of updates this house is ready for you to make it your home!
Description:What a gem situated within the big little city of Lebanon, NH. Built during the Eastlake Architectural movement in 1860 this Victorian home has all the features one expects to see for the time period including ornate floral carvings that adorn the exterior. Tastefully updated by the few owners who have appreciated her history, this home provides ample space for cohabitation of one or more generations of occupants. Off the rear of the home, where you will find ample parking, is a separate entrance that could be used as a home based office complete with kitchenette and bathroom. It can even serve as quarters for an in home assistant to the residents or good friend or family member. From the front or side covered porch you enter the main home and appreciate the history that flows from its rooms. Two options for a first floor bedroom are available for those who desire or need single level living. A three season sunroom on the second floor could function as a game room, exercise space or a space to entertain or hang 10; the possibilities abound. Combine this with ample sized sleeping rooms including an impressive primary suite, the second floor fosters a feeling of home with its comfort and warmth. The basement would make for an impressive home based gym essential for the winter months when we feel somewhat trapped by the weather or perhaps even a daycare as I understand it once was. Walking distance to the Marsh Brothers Deli, Lucky's Coffee House, Village Pizzeria, Salthill Irish pub, Three Tomatoes Italian Restaurant and Lebanon Opera House means the property is near the Lebanon Green famous for its outdoor concerts, farmers markets and festivals. Perhaps you're interested in an investment property vs. a single family dwelling? This home and layout provides many opportunities.
Description:Your NH retreat awaits! Set on 5.5 private acres in a quiet rural setting, this well-built 2008 log home offers the warmth and character so many buyers are looking for. With 3 bedrooms and soaring cathedral ceilings, cherry and red oak hardwood flooring, the home feels open, comfortable, and connected to its natural surroundings. Recent improvements include a new heating system, adding efficiency and peace of mind. A large wraparound deck creates great outdoor living space for relaxing, entertaining, or taking in the peaceful setting. The property abuts conservation land with established trails, giving you direct access to hiking, snowshoeing, and year-round outdoor recreation right from the backyard. The location offers a nice balance of privacy and convenience, with close proximity to Dartmouth/Hanover Center, Mt Sunapee, Whaleback, DH Medical Center and all Upper Valley amenities. Close to Mascoma Lake town beach, Crystal Lake and boat dock. Access to four ponds near property. Whether you're looking for a year-round home or a getaway in New Hampshire, this property captures the classic feel of log home living in a beautiful Enfield setting.
Description:Set quietly on 8.3 acres of rolling lawn and woods, 25 Pinneo Hill Road offers a wonderful combination of privacy, flexibility, and natural beauty in a true Upper Valley setting. Tucked into a clearing surrounded by mature trees, the property feels peaceful and wonderfully removed, with a broad open yard, wooded edges, and room to roam in every season. The 4-bedroom main house is accompanied by a 1-bedroom ADU, offering uncommon versatility for guests, extended family, or a separate work-from-home space. Inside, the home offers generous proportions, substantial gathering spaces, a wood stove, and a warm, welcoming layout that opens naturally to the outdoors. Long decks and a screened porch extend the living space and create an easy connection to the landscape. The home does need updating, but the fundamentals are here: scale, utility, flexibility, a recently replaced roof, and a newer pellet boiler to keep the home warm. What makes this property especially compelling is the land itself. The broad lawn is ideal for backyard baseball or soccer, with plenty of space to run, play, and gather. Along the side of the property, a shallow, babbling brook adds another layer of charm, inviting hours of simple outdoor fun: splashing, exploring, turning over stones, or just cooling off on a warm afternoon. The setting feels made for muddy boots, summer dinners on the deck, and evenings spent listening to peepers and owls as the light fades. This is not a polished, perfect box, but something more unique: a home with soul, acreage, and enduring spaces that have been truly lived in and loved. For the current owner, it was the backdrop to raising five children, and that history is easy to feel in the generous layout, the welcoming outdoor spaces, and the sense that life unfolds easily here. A special opportunity for the next owner to update and reimagine a property with strong bones, natural beauty, and the kind of privacy and playability that are so special. BEING SOLD AS-IS.
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.