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 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Stunning New Hampshire Lakefront! Beautiful water views, mountain views, bald eagle sightings and the haunting call of the loons are just a few of the things you will experience from this rustic camp perched on 94 feet of waterfront on the eastern bank of Mascoma Lake. Camp out in the existing cottage and enjoy the raised detached deck area, sandy beach bottom and private dock. What could be more delightful than summers boating with friends and family, fishing and swimming from your private dock or just watching the passing sailboats. This magical location can be used just as it is or it could be the site of your new Lakefront Dream House! Much of the preliminary leg work has been completed with survey and perking information available. This is a must see property just in time for summer fun! Open House Sat 4/12 9-11 and Sun 4/13 11-1
Description:Move-in ready and fully remodeled, this 3-bedroom, 2-bathroom Raised Ranch offers modern comfort with thoughtful upgrades. Recent improvements include a new asphalt roof (2024), mini-splits (2023), and custom kitchen with quartz countertops, ample cabinetry, and a spacious island. Additional upgrades include luxury vinyl plank flooring, a new PEX plumbing, a new hot water heater, relined chimney, and refurbished pellet stoves. The main level has three bedrooms and an updated full bathroom, while the lower level offers three flexible rooms—ideal for an office, playroom, or gym—plus a newly updated bathroom. OPEN HOUSE Tuesday April 1 4-6pm.
Description:So, you're probably wondering about the whole "location, location, location" thing in real estate, right? Well, this place totally nails it! Just a hop, skip, and a 15-minute drive away from Dartmouth University and Dartmouth Hitchcock Hospital, this sweet home is calling out for someone to make it their own. It's like it's sitting there waiting for you to throw some elbow grease and love into it, and boom, you've got yourself a real gem. Now, imagine a house with an open layout that's begging for a little bit of your creative flair. Picture big ol' bedrooms that could fit a king-sized bed with room to spare, and windows that offer views that'll make you want to sit back with a cup of joe and just take it all in. Oh, and let's not forget about that monster of a barn! It's like the ultimate man cave/she shed/playhouse for the kids/party spot all rolled into one. Plus, it comes with some extra outbuildings, so you'll have enough space to store all your toys, tools, or whatever else you can think of. You're looking at over 6 acres of pure fun. You can roam around outside, build some forts, throw a frisbee, or just kick back and enjoy the fresh air. If you're feeling adventurous, you can strap on your hiking boots or fire up the ATV/snowmobile and hit the trails, which are just a 2-minute stroll from your doorstep.
Description:Charming 3 bedroom, 2 bathroom Gambrel in West Lebanon. This light and bright home offers the perfect blend of modern updates and classic charm. The first floor has a spacious layout with hardwood floors throughout, a generous foyer, living room with a pellet stove, dining room and updated kitchen. The kitchen opens to the screened porch that overlooks the back yard, a perfect spot to enjoy freshly picked raspberries and blueberries from your backyard! The second floor has three bedrooms and the full bathroom. The lower level has a large playroom, office/den and a 3/4 bathroom. A level 0.45 acre lot with a fully fenced side yard there is plenty of space for outdoor living - the perfect spot to call home! Showings by appointment Friday 3.30-5.30pm and Saturday 12-2pm
Description:Beautiful 2+ acres landscaped lot with this 3-bedroom, 2 baths cape style home that has had many recent renovations tastefully done for this owner. There's a new kitchen with granite counter tops and a breakfast bar that is open to the dining room that features new cabinets with a beverage cooler and coffee bar. The large living room was created from two smaller rooms and has a new stone hearth and woodstove. Upstairs has 3 bedrooms and a modern full bath. There is a full basement with pine walls and a bar area to enjoy as a rec room or a family room. New doors exit the living room and kitchen to the beautiful modern deck to sit back and relax on. There's a wonderful yard with a garden space, sheds and plenty of room to add a garage. Excellent location that is just a quick walk to the Village or a short commute to Lebanon. Showings begin at the Open house Saturday April 12th, 11 am to 1 pm
Description:Motivated Seller! Offers Deadline Sunday 6pm. This well maintained 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.
Description:Great house! Great Location! And Energy Efficient to boot! This sun drenched contemporary raised ranch makes living in the Upper Valley simple and easy. The thoughtfully designed interior offers an option of one floor living that capitalizes on the bank of western facing windows capturing not only the warmth of the sun but also stunning lake and mountain views. The home is turnkey and ready to move into with a beautifully renovated open kitchen/ dining /living area outfitted with new appliances and new windows, as well as, 2 generous bedrooms, an office, and full bath and laundry all on the main level. The lower level is complete with a bright and airy family room with Woodstock Soapstone wood stove, a bonus/bedroom, full bath, workshop and plenty of storage. This floor walks directly out to your own private oasis of lovely gardens, prolific blueberry bushes and views of Mascoma Lake. Additionally, the home includes an oversized 2 car garage with EV plug, 2 decks and is equipped with new central AC and solar panels installed on the roof with net metered electricity providing maximum energy efficiency.. The property can be purchased alone or in combination with the lakefront camp across the road providing for a wonderful year round lakefront experience. Open House Sat 4/12 9-11 and Sun 4/13 11-1
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: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, move-in-ready home at 68 Buckingham Place, nestled in the heart of Lebanon, NH. This delightful 3-bedroom, 2-bathroom house, serviced by town water and sewer, offers character and potential with the option for single-floor living. Located in a peaceful, quiet neighborhood, it strikes the perfect balance between tranquility and convenience, with easy access to essential amenities. The home is just minutes from DHMC, I-89 and I-91, grocery stores, and the Northern Rail Trail. Inside, you'll find a spacious, inviting layout, including a bright and airy 3-season sunroom (with a new roof!)—ideal for relaxation or enjoying your morning coffee. The kitchen flows seamlessly into the living room, where you can cozy up next to the gas fireplace. The two-car garage provides ample parking and storage, while the finished basement offers additional living space perfect for a home office, guests, or a cozy retreat. The basement also features generous storage and an oversized laundry room. The home's layout and design exude warmth and charm, blending comfort with style. It’s move-in ready and waiting for you to make it your own. Don’t miss the opportunity to call this welcoming property home!