SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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:A sportsman's Paradise! 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 Mascoma Lake, Mt Sunapee, Whaleback, DH Medical Center and all Upper Valley amenities. 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:Nestled along the waterfront of Anderson Pond within the sought-after Eastman Community, this fully renovated home offers an exceptional blend of modern comfort and four-season recreation. Thoughtfully updated throughout, the home features all new windows and doors, spray foam insulation for outstanding efficiency, a heated bonus room over the garage, a standing seam metal roof and a beautifully redesigned kitchen with new appliances and striking Dekton countertops. The focal point beyond the water view is the stone fireplace. As for the community, enjoy the unmatched lifestyle of Eastman’s 3,700-acre residential community surrounding a 345-acre lake, featuring six beaches, championship golf, tennis and pickleball courts, a fitness center, indoor pool, and miles of walking and hiking trails. Whether spending summer days on the water, golfing a scenic round, or enjoying year-round recreation, this property offers waterfront living paired with resort-style amenities in one of New Hampshire’s premier four-season communities.
Description:Fabulous location in highly desirable Hanover, NH! This charming Cape offers the perfect blend of character, comfort, and convenience, just minutes to downtown Main Street, the Co-op, Hanover Elementary, Middle, and High School, Dartmouth College, and with easy access to Dartmouth-Hitchcock Medical Center. Featuring 4 bedrooms, a flexible bonus room, and 3 bathrooms, highlighted by a generous primary suite with dual closets and a private 3/4 bath, this warm and inviting home is filled with classic charm. Cozy up by the wood-burning fireplace with an insert or enjoy relaxing summer evenings on the screened porch overlooking a beautiful yard, perfect for playing or entertaining. Beautiful wood floors flow throughout the main living areas, adding warmth and timeless appeal. The first floor offers a functional layout with an eat-in kitchen, pantry, and mudroom area, along with a comfortable family room and a dining space with a wood-burning stove. A bonus room provides flexibility for a home office or spare bedroom, along with a full bathroom on the main level. Upstairs, you’ll find four bedrooms, including a primary suite with its own private 3/4 bath, along with an additional 3/4 bath. Additional features include a partially finished basement, ideal for a quiet workspace, workout area, or extra storage; and easy access to everything Hanover has to offer. Located in a top-rated school district, with school bus pickup steps away, this home offers both convenience and community. A truly sweet Cape in an unbeatable location; walkable, welcoming, and ready to call home. Don’t miss out! Showings begin at the open houses on Saturday, May 9th from 11:30 AM–1:00 PM and Sunday from 11:30 AM–1:00 PM. Experience the perfect blend of timeless charm and modern comfort, your Hanover home awaits.
Description:This 3 bedroom 2.5 bath home with attached 2 car garage is situated very privately on a beautifully landscaped 3.86 acres in the desirable community of Eastman! The interior is light and bright with many windows throughout. The very spacious primary suite has custom built-ins and an attached laundry room. With a generous den/office, working from home is a fabulous option and the two decks and a sunroom make for lovely areas to enjoy the outdoors and wildlife during your breaks. Two more bedrooms and a full bath up with tons of storage overlooking the living room below, and an additional sitting room in the loft for reading and watching the birds out the windows. Passive Solar and energy efficient! The additional 3 car garage with workshop and massive storage overhead is awaiting your antique cars. This one is calling your name!
Description:The sun streams in to this delightfully bright home set on a gorgeous 3.45 ac site in Lebanon. Spacious great room with beautiful outlook. 2648 sq ft home is currently set up as 1 bedroom, 2.5 bath, with large first floor master suite. Upstairs has a large family/game room and a full bath. Seller will give credit of builder's estimate to add two more bedrooms to the second floor. (House has a 4 bedroom septic system). Full basement provides great space for workshop or more finished space. 2 car garage. Open house Sunday, May 31 from 1--3pm.
Description:Spacious, move-in-ready, contemporary home with 3 bedrooms plus a bonus room, 4.5 baths and over 3,000 SF. Ideally situated on 2+ acres with privacy and views of the meadow and pond. Property abuts Grantham Recreational Park and conservation land. You’ll absolutely love the state-of-the-art kitchen featuring granite countertops, a large island, walk-in pantry, professional-grade gas range, custom tile backsplash, and two dishwashers. The open layout flows into a dining area and continues to an expansive living room with vaulted ceilings and a beautiful fireplace as the focal point. The first-floor primary suite offers a generous walk-in closet and two separate baths for convenience. Two more bedrooms, each with its own bath, and a bonus room are on the lower level. You'll also find a family room filled with natural light in the walkout lower level. Additional highlights include a home office, whole-house generator, direct entry from the 2-car garage, a screened porch, and large wraparound deck. Located just minutes from I-89, this property provides easy access to the Upper Valley and Dartmouth-Lake Sunapee Region. The area offers year-round opportunities for outdoor recreation including kayaking, fishing, skiing, ice skating, and more. All this in a lovely country setting.
Description:This stunning Yankee Barn home is a masterpiece of design and craftsmanship, featuring architecturally inspired improvements throughout. The spacious, open-concept kitchen is the heart of the home, offering stainless steel appliances, granite countertops, a large island with gas cooking, and seamless flow into the dining and sitting areas—perfect for entertaining or everyday living. The dramatic two-story stone fireplace creates a breathtaking focal point and fills the home with warmth and character. The sun-filled primary suite is generously sized and offers direct access to the expansive western-facing deck, where you'll enjoy spectacular sunsets and peaceful outdoor living. Every bathroom has been thoughtfully customized with beautiful cabinetry and tile work, while the lower-level bath includes a built-in sauna for the ultimate retreat. Step outside to discover an extraordinary garden sanctuary featuring multi-tiered hardscaping, a fire pit, ambient lighting, and beautifully landscaped spaces designed for relaxation and entertaining. Situated on a double lot, the property provides exceptional privacy and a tranquil setting. Additional features include high-efficiency heating, on-demand hot water, air conditioning, heated towel bars, and numerous quality upgrades throughout. Located in the Eastman community, this home offers access to year-round recreation and amenities for every lifestyle, including a 345-acre lake with 6 beaches, championship golf, tennis and pickleball courts, a fitness center, heated indoor pool, cross-country skiing, hiking and biking trails, and countless opportunities to enjoy the outdoors. Whether you're seeking an active lifestyle or a peaceful retreat, this exceptional property offers the best of both worlds.
Description:Welcome to this beautifully updated 4-bedroom, 3-bath home tucked into one of Lebanon’s most convenient and scenic neighborhoods. Located adjacent to the stunning trails and open spaces of the 864 acre Farnum Hill Reserve, this property offers the perfect balance of nature, comfort, and accessibility. Step inside to discover a thoughtfully updated interior with bright, welcoming living spaces designed for everyday living and entertaining. The home features a modernized kitchen, spacious bedrooms, and three well-appointed bathrooms, providing flexibility for owners, guests, or home office needs. Recent upgrades include a brand-new heating and air conditioning system, ensuring year-round comfort and energy efficiency. The Tesla power wall with 2 batteries provides back up support during storms or power outages. Outside, the professionally landscaped yard creates a peaceful setting for relaxing, gardening, or enjoying the surrounding natural beauty. The slate patio provides a private area that is surrounded by perennial gardens. Move-in ready and beautifully maintained, 41 Foliage View Road is a rare opportunity to enjoy updated living in an exceptional location. Seller is a licensed NH Real Estate Broker.
Description:This West Lebanon gem combines classic comfort with a versatile, modern layout. At the heart of the home, a bright eat-in kitchen with a large island flows naturally into a spacious living room anchored by a cozy fireplace. The second floor offers four bedrooms, including a primary suite with a private bath. For added flexibility, a separate suite above the two-car garage features a kitchenette and built-ins—perfect for guests, a home office, or recreation. Outside, enjoy the quiet neighborhood from the deck or the level, tree-lined backyard. Ideally located, you’re just a quick bike ride from Hanover’s Main Street with easy Advance Transit access to the rest of the Upper Valley. Showings to begin at the Open House on Sunday, March 29th from 1pm to 3pm.