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 30
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:PRICE IMPROVEMENT! This 3 bedroom/2 bathroom home is ready for its next owners! Located in one of Lebanon's most desirable locations, the King's Grant neighborhood, it's close to shopping, dining, and schools, and backs up to Carter Country Club. The first floor features a mudroom or bonus room, office, and utility/laundry room and also connects to the garage. Upstairs, you'll find a large living room with high ceilings, a kitchen featuring brand new stainless steel appliances, and a dining area leading to a large, private deck. A primary bedroom with en-suite 3/4 bath and 2 other bedrooms which share a full bath complete the space. Hanover, Dartmouth Hitchcock Medical Center, and West Lebanon shopping are all within a 15 minute drive. You'll love living in the heart of the Upper Valley!
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:This charming, secluded 2000 cape has 18+/- acres of land and delightful views of Mt Ascutney. With hardwood floors upstairs and down, good bathrooms, 3 bedrooms, and a lovely open floorplan on the first floor, this is a great home! There's a two car garage plus a very large, detached barn. Plenty of room for gardens and chickens as well as trails. A great one! Private road maintenance fee: $25 per month.
Description:Envision the exclusive pleasure of owning 1.5 acres of property complete with your very own swimming pond, located in the desirable town of Hanover. This contemporary, a mere 6 minutes from Hanover, Main Street and 15 minutes from I-89, offers both privacy and convenience. Historically owned by a family, the home has been cleverly configured to included two separate rental units with their own kitchens, providing potential income opportunities or accomodations for guests. The primary living space, used by the owners, features modern updates and expansive windows that frame captivating views of the serene pond. For those inclined towards customization, the rental units can be seamlessly integrated into the main living area to create a spacious single-family home. Alternatively, maintaining the current layout offers continued benefits as a rental property. With Mink Brook gracefully meandering through the landscape, this property is not only a peaceful retreat but also a promising investment. There is all new wiring, new carpet, new energy efficient boiler, new chimney liner, new baseboards, new toilets and has had a septic inspection. This property has unique features and a prime location, making it an exceptional opportunity for both personal enjoyment and financial growth.
Description:Nestled along the shores of Mascoma Lake and surrounded by the historic Shaker Museum you’ll find the community of North Village. A unique cluster of lovely homes, stylized with a hint of day’s gone by yet very modern on the interior. That’s exactly what you’ll find at 51 Chosen Vale Lane, built in 2002 and lovingly cared for this home has many features not found in the others. The large primary suite consists of vaulted ceilings, a separate dressing/sitting room with fireplace and spacious bath. The additional second floor suite again boasts a private bath, and a loft for those adventurous ones in the family. The main level is perfect for entertaining with an open concept living room, kitchen and dining room with built-ins and hardwood floors throughout. Red Birch & Mahogany cabinets, granite countertops and plenty of room for the best of cooks. The living room center piece is a fireplace mantel hand crafted by Dana Robes. A first-floor bedroom with a full bath rounds off the main level. A fully covered 3 season porch allows for lovely views of the lake, all within a short walk to the private Association beach. The lower level has a wonderful family room complete with bar, workshop, storage and laundry. The systems include two Air conditioning units one for each floor, a Buderus heating system, and a whole house sprinkler system. The Association maintains the roads, landscaping and beaches. Easy commute to Dartmouth College and the Dartmouth Medical Center.