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 '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This well-maintained and beautifully updated two-level condominium offers comfortable, stylish living with convenient access to downtown Hanover. The main floor features a spacious living and dining area that opens onto a covered balcony, providing scenic views of Girl Brook and the surrounding woodland. The light-filled, efficient galley kitchen includes a large pantry closet for ample storage. A versatile main-level bedroom can easily serve as a home office, guest room, or den. Upstairs, you will find two additional bedrooms, one with a walk-in closet, a full bath, and a laundry room. Enjoy direct access to local walking and cross-country ski trails right from your doorstep. The proximity to downtown Hanover and Dartmouth College ensures easy access to shops, restaurants, and cultural events. Residents also benefit from a recently renovated in-ground pool and clubhouse. This condo offers a perfect blend of comfort, convenience, and direct trail access in the heart of Hanover.
Description:Welcome to this charming and well-cared-for 3-bedroom, 1.5-bath home, featuring a thoughtfully designed simple floor plan ideal for comfortable everyday living. Bathed in natural light thanks to its southern exposure, the home offers warmth and brightness throughout the year. The main living areas boast gleaming hardwood floors, while all three bedrooms are carpeted for a cozy retreat. The 1st floor has the kitchen, dining/living room, and one bedroom. There is even an inviting sunroom, perfect for relaxing or entertaining. The 2nd floor has two bedrooms and a convenient second-floor laundry area adds ease to your daily routine. Enjoy ample storage and future potential with the spacious unfinished basement, and protect your vehicles from the elements in the attached two-car garage. Set on a sloping lot, the yard doubles as a fantastic sledding hill—perfect for winter fun. This home is move-in ready, well-maintained, and offers a wonderful combination of comfort, charm, and year-round enjoyment.
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: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:Charming 2-bedroom Bungalow, thoughtfully updated, and ideally located near Dartmouth Hitchcock Medical Center and downtown Hanover. This home is perfect for those seeking a low-maintenance lifestyle with a small footprint, offering the benefits of single-family living. Situated in a desirable Hanover neighborhood, you'll enjoy your own backyard space featuring a firepit and a small patio, perfect for outdoor dining in the summer. A small back deck provides space for a grill, while a lovely three-season room overlooks the yard. Inside, the beautifully updated kitchen boasts cherry countertops, plenty of storage, a farmhouse sink, and a two-seat peninsula bar. The open living and dining area flow seamlessly from the kitchen, and there are two comfortable bedrooms and a tastefully appointed full bath. The basement offers versatile space for storage, utilities, a workbench, and laundry, plus room for one small car to park. It's been spray foamed for improved energy efficiency. This home has served as both a full-time residence and a reliable source of rental income for the owners over the years. Showings begin Saturday, April 19th at the open house 9:30am-12pm.
Description:Post Pond Possibilities!! One of a small number of lots that have pond access. Don't miss the opportunity to be a Post Pond resident. Camp/Cottage with rustic character overlooks the pond in a wooded setting. Most of the land already in current use and building envelope is ready for your personal touches. Septic installed new in 2007 with power and a drilled well onsite. Outbuildings for boat storage and more. Come and imagine life on the pond minutes from Hanover, Dartmouth College, and DHMC. All the amenities of the Upper Valley minutes away from your quiet access to nature and wooded serenity.
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!!!
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.