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:An absolute delight this sun filled 3 bedroom, 2 bath home located on a corner lot in peaceful neighborhood. Built in 1997 and recently updated this home centers around a renovated eat in kitchen that opens to a dining area with a full glass door to the deck overlooking the surrounding trees and backyard. The pantry located off the kitchen allows ample room for extra supplies and laundry with an office/den and living room to complete the main floor. The second floor with remodeled full bath, primary bedroom and two additional bedrooms makes for a cozy lifestyle. The lower level provides a family room with woodstove, storage and mechanicals. From the walkout basement to large driveway area that has plenty of room for vehicles and play with a detached 2 car garage and large storage above. With additional out buildings there's plenty of room to store equipment without taking room from the 24 x 24 garage. This home sits on a private half acre corner lot with plenty of open lawn and tons of sunshine. Delayed showings until the Open House scheduled for Saturday April 5th from 11a-1:30p.
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:Ideal Hanover location! Less than 10 minutes to Dartmouth's campus, Dartmouth Health, and all of the fantastic amenities both Hanover and Lebanon have to offer. Fully renovated in 2018, this warm and inviting 2 bedroom, 2 bathroom home offers the ease of low maintenance condominium-like living, without the HOA fees. The main floor includes a spacious, vaulted ceiling living/dining area that opens to the kitchen (fully equipped with stainless steel appliances and soapstone countertops), bedroom/office, full bathroom, and laundry. On the second floor you'll find a large, loft-style, primary en-suite bedroom with an oversized closet. Renovation upgrades include, but are not limited to: windows, flooring, heating system, kitchen, baths and insulation. The full, unfinished basement and attached exterior shed offer ample storage space. During the warmer months, enjoy entertaining on the deck while overlooking lovely views of the Vermont mountains. Icing on the cake - despite it's wonderful, private setting, it's still on town sewer! Furnishings are digitally staged.
Description: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:Very convenient location to all the amenities of the Upper Valley!! If you have horses and animals, or if you are thinking of getting animals, this property is for you! With open fields, a 7 stall barn (32' x 49'), a large private pond (20' deep at its deepest point), you can enjoy the sunsets and the view of your own farm from the rear deck, or the gazebo on the pond. The home has 2 bedrooms and 2 baths, with an open kitchen, dining, and living area. The kitchen has granite counter tops with a spacious island. The walkout lower level is fully finished with a large family room, one bedroom and a bath. There is a large detached 2 car garage (20'x36') with storage above, and an additional bay (28'x32') off the back. There are several garden spaces and established blueberry bushes. What a great property to call home. Come and turn your dreams into an address!! Delayed Showings. Showings will start at the public Open House on Saturday, March 8th from 10:00 AM to 12:00 Noon.
Description:Welcome to your brand-new home in Hanover! This beautifully designed new construction features a spacious open floor plan, ideal for both entertaining and enjoying peaceful nights at home. With convenient first-floor laundry hookups and a maintenance-free lifestyle, this home offers all the modern amenities you need. Hardwood floors, masterfully designed bathrooms with custom tile showers, a spectacular kitchen with Quartz countertops, fully appliances kitchens, and tile back splash. Primary Suite is stunning and offers lots of privacy from the rest of the home. Located just minutes from Dartmouth College, Dartmouth-Hitchcock Medical Center, and several ski resorts, it provides unmatched convenience and accessibility. Whether you're working on campus or exploring the vibrant Hanover area, this location can't be beat. Don't miss the chance to make this your new home—ready for immediate occupancy! Schedule a showing today and start imagining your life in this dream home. Home is complete and move-in ready! Last unit left! The seller is a licensed New Hampshire real estate broker.
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 brand new home offers 3 bedroom, 2.5 bath home. Open concept living with hardwood floors, granite countertops, tiled baths and flexible floor plan. Share the community garden, enjoy socials at the Farmhouse, and the privileges that an HOA provides. Close to I89, DHMC, Dartmouth College, Lebanon 6 Movie Theater, Downtown and plenty of shopping. House is currently under construction with an estimated completion date of April 30th. All showings must be after 4pm weekdays or weekend, this is an active construction area please no unsupervised visits. Pictures in MLS are a facsimile of house being built.
Description:Country living at its best! Stunning log, cape-style home located on 5+ acres. Park-like grounds with a beautiful view! Enjoy the sunsets from your private back deck. There's a fenced in area for the dogs and a pasture field beyond. This home is a true New England log home with 3 bedrooms and 2 bathrooms. The open living area has a beautiful brick and granite hearth with a woodstove and cathedral ceilings. Upstairs there is a loft office area, a large bedroom and bath. The full unfinished basement has a woodstove and lots of storage. Recently the farmers porched was enclosed with new windows and insulated for additional living space. The 3 bay garage is finished and heated with a woodstove. There is hot and cold water with a shop area. Upstairs is additional storage. Also included is a barn that is 24 x 50 with 13' clearance. Plenty of wildlife and trails on the property. Enjoy snowmobiling, X country skiing and horseback riding access. Also apple trees and raspberry bushes. Close to Crystal Lake too.
Description:Beautiful Colonial in a quiet country setting with your own private pond. This 3-bedroom, 2.5-bath home is on 3 level acres with 2 car- attached garage. The exterior has had a makeover with all new paint, 3 new decks and all new doors. The interior was painted in 2024 with some new flooring, a new water filter system, new water heater and more. Plus, lots of landscaping. Enjoy country living with a short drive into town. Ideal location with being 15 min to DHMC, 10 min drive to the center of Lebanon and a 25-minute commute to Claremont, NH. Open House Saturday, April 5th 10 am to Noon.
Description:This 3 bedroom, 2 bath home may need some cosmetic updates but you will fall in love with the natural light and open floor plan! Light streams into the sunroom making it a cozy place to read a book or relax with your morning coffee. The living room features a big bay window to take in the Moose Mountain ridge line through the trees and has a a wonderful propane gas fireplace for those chilly nights. The kitchen/dining area is spacious with access to a deck and you will love the walk in pantry off the laundry room. The primary bedroom has an en suite bath and there is a second bedroom and full bath as well. Downstairs you have your third bedroom or office, a nice big storage room and a mudroom attached to the 2 car garage. Don't miss the big outbuilding which is perfect for all your toys and a workshop! The land is beautiful with it's own apple orchard (110 tress!) and a big garden plot. A wonderful spot walking distance to the Hanover Center Green in Etna where we have a summer fair and walking trails nearby. A wonderful community just 15 minutes to DHMC and Dartmouth College! Delayed showings start on Saturday, March 29 from 2-4.