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 >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Charming 4 bedroom, 1 bathroom Cape located on a dead end road close to the walking trail to Lebanon High School, and just a short walk to the Lebanon Green, Lebanon Opera House, restaurants and the Post Office. Extensively renovated in 2019 the home is move-in ready with updated kitchen, bathroom, paint and flooring, 8 year old heating system, and stabilization foundation work in full walk-out basement with lifetime warranty. One car detached garage with storage space below. The house is currently rented until 5/1/2025. Showings by appointment.
Description:161 BANK STREET EXTENSION- This recently renovated 4 bedroom, 2 bath cape is ideally located with close proximity to the Lebanon Green, Middle and High Schools, Dartmouth Hitchcock, Hypertherm and the Rail Trail. The first floor features a newly renovated kitchen and updated first floor bathroom, a comfortable dining and living space, the primary bedroom and a second bedroom which is currently being used as a home office. Upstairs has newly installed flooring, a 3/4 bath and two nice sized bedrooms. A bright three-season porch opens into a recently landscaped backyard with new patio, while the full basement provides ample storage space and potential for additional living area. Additional updates include a new roof, and new front and back doors. A wonderful home in a fantastic location!
Description:This charming Cape home is nestled on a beautiful lot in a highly sought-after neighborhood in the heart of West Lebanon. As you step inside, you're greeted by a warm and inviting atmosphere that extends throughout every room. The first floor features an open-concept kitchen and dining area, seamlessly flowing into a bright and airy family/living room, along with a convenient half-bath. Upstairs, you'll find four bedrooms and a full bath, providing ample space for family, guests, or a home office. Beautifully maintained hardwood floors enhance the home's charm and character. On warm summer days, relax in the enclosed porch or step outside to enjoy the beautifully landscaped backyard. The spacious mudroom, located off the back entrance, leads to both the two-car garage and the backyard oasis. Whether you have a green thumb, enjoy outdoor activities, or simply want to unwind on the patio while listening to the gentle sounds of the man-made fountain, this space offers endless possibilities. The large basement provides plenty of storage and potential for future expansion—transform it into a home gym, private workshop, or additional finished living space. Situated in a prime location, this home is close to the Little League Field, shopping centers, and offers quick access to Hanover and surrounding amenities. A rare find, this move-in-ready home is perfect for full-time living. Showings will start back May 7th!
Description:Classic West Lebanon new englander in great location! This house has SO much to offer! Great spaces - including eat-in kitchen, playroom with slider to the deck and renovated 3/4 bathroom, den and formal living room combination. Upstairs you will find 3-4 bedrooms and a renovated full bathroom including a gorgeous primary bedroom with new wood floors and walk in closet. Attic is finished and would be great for a playroom, office or guest bedroom. House has had lots of updates - new roof, renovated laundry room, newer appliances, refinished wood floors, newly paved driveway - and more! Showings start with Open House Saturday, April 5th 10:00-12:30 and Sunday, April 6th 1:00-3:30.
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:PRICE JUST IMPROVED!! OPEN HOUSE SATURDAY 4/26/25 10-12n Step into history at The Treetops, an extraordinary 4-bedroom, 2-bath home that was once part of the original Saint-Gaudens estate. This stunning property carries the spirit of the famed Cornish Art Colony, where master sculptor Augustus Saint-Gaudens and his creative circle found inspiration in the rolling hills of New Hampshire. Perched on a scenic private lot, this home offers a tranquil retreat surrounded by nature. A gentle stream winds through the property, adding to the peaceful ambiance, while garden spaces provide the perfect setting for cultivating beauty—just as artists once did in this very landscape. From the sun-drenched rooms to the charming historic details, The Treetops is a timeless escape that seamlessly blends past and present. Located just minutes from the Upper Valley, with easy access to both sides of the Connecticut River, this home offers the perfect balance of seclusion and convenience—close to Dartmouth College, world-class healthcare, vibrant arts, and year-round outdoor recreation. This is more than just a home; it's a living piece of history in one of New Hampshire’s most picturesque and storied communities. Opportunities like this are rare—don’t miss your chance to own a legacy!
Description:Embrace the vibrant heart of Hanover with this newly renovated home on Lebanon St, offering the ultimate in downtown living within walking distance to the CoOp and the bus line. Perfectly situated between Dartmouth College and DHMC, this property boasts a walk-out basement providing extra storage. The first floor showcases a contemporary touch with brand new hardwood floors, a renovated kitchen and 3bedrooms, one with a 3/4 bath. Upstairs, the second floor introduces an in-law suite with hardwood floors, new kitchen, 2 bedrooms and a bath with private washer and dryer all with a private exterior entrance. Take advantage of the prime location and the properties surrounding walking trails and Mink Brook. Welcome to Hanover!
Description:Welcome to 36 Dartmouth Avenue, a spacious and beautifully maintained home just minutes from DHMC, top schools, and local trails. Located in a desirable Lebanon neighborhood, this property blends comfort, convenience, and expansion potential. The light-filled open-concept layout features hardwood floors, a cozy pellet stove, and a large living area ideal for relaxing or entertaining. The kitchen offers cherry cabinetry, a center island with seating, and stainless steel appliances. The adjacent dining space flows seamlessly into the living room for an easy, connected feel. Upstairs, the primary suite includes a private bath with dual sinks and ample closet space. Additional bedrooms are roomy and bright, perfect for guests, family, or home office setups. the main office with a pleasent glass door adds work-from-home flexibility or the 4th bedroom. The lower level is already framed and wired, offering the exciting potential for even more finished living space, whether a media room, gym, or space to spread out. Outside, enjoy a fenced-in backyard with a large deck, and ample space to gather. The oversized two-car garage adds storage and style with a barn-inspired facade. With its convenient location and room to grow, this home offers the best of Upper Valley living.
Description:Possibly one of the most spectacular locations on Mascoma Lake you'll ever find. The "Lovett Cottage" has not been offered for sale since 1971 and boast direct Southwesterly exposure with 125 feet of private lake frontage. The original cottage built circa 1940 then remodeled and expanded in 2005 with a second floor addition which included a new kitchen, dining room, living room and bedroom/balcony. The house along with an extensive deck and dock system is grandfathered into is current location making it extremely unique and a rare find that will most certainly never be found again. The deck and dock system feel almost like they are vaulted out over the lake. The privacy here is amazing, imagine sitting by the shore on some quiet summer evening, with your feet in the water, sipping on a cool drink, listening to the waves gently slapping the rocky shore line. Nothing else to do but watch the sun slowly setting behind Shaker Mountain while your children or grandchildren are at play. The crackle of the firepit as tales from the past are being spun, and then your the grandchild runs over and whacks you in the face with a sun fish. Look what we caught Grampa! This is not a house, it's a lifetime of memories that we are selling, make them yours, call for a private showing today, you'll be glad you did.
Description:"The Rock Ridge Community" Offering 326 pristine acres of nature, trails, and riverfront access to all that the Upper Valley has to offer. The Upper Valley's Premier Neighborhood, all New Construction. This new home offers 4 bedroom, 3.5 bath home with extra living space above garage and unfinished full basement. Open concept living with hardwood floors, granite counter tops, tiled baths, flexible floor plan and many other upgrades. Share the community garden, enjoy socials at the Farmhouse and the privileges that HOA provides. Close to I-89, DHMC and Dartmouth College, Lebanon 6 Theater, Downtown, and plenty of shopping. Photos show current construction status completion date June 30, 2025.