SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and type ='M'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Multi Family Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Prime Commercial & Residential Opportunity. This versatile three-unit property offers an exceptional investment opportunity in a highly sought-after area. The first floor is a fully equipped beauty salon featuring 6 workstations, a tanning room, kitchen, half bath, office space, and ample storage including basement access. The second floor boasts two attractive apartments. Apartment 1 is a spacious 2-bedroom unit with a three-quarter bath, new windows, and abundant natural light. Apartment 2 is a cozy 1-bedroom unit with an enclosed porch, pantry, and beautiful wood floors. Enjoy unbeatable proximity to the Lebanon Green and vibrant Thursday Farmers Market. You'll also be close to restaurants, public library, Dartmouth College and Medical center, convenient access to Interstate 89. Direct access to the Rail Trail offers fantastic hiking and biking adventures, and public transportation is just steps away! This is an ideal opportunity for investors or owner-occupiers seeking income potential and a fantastic lifestyle. Don't miss out on this unique property! *Leb City to start the round about construction April 1, 2026. Leb City will be responsible for rebuilding the stone wall, new paving and relining the parking spots.
Description:Prime location! Discover this charming classic New Englander, perfectly positioned in the heart of town. Enjoy the convenience of being just a short walk—approximately 6 minutes to Dartmouth College and the lively downtown scene, with its array of shops, restaurants, and cultural attractions. Currently set up as an income-producing duplex, this property provides fantastic versatility— with possibilities of transforming it into a spacious single-family residence, where you can bring your creativity to life. Or, keep the duplex setup for owner-occupied living with built-in rental potential to offset costs while enjoying the best of both worlds. Don't miss this opportunity—schedule a tour today and start envisioning the possibilities!