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 '500000' AND '1000000'
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:Tucked into a desirable residential neighborhood, this versatile property offers a rare opportunity for multi-generational living, owner-occupancy with rental income, or investment potential. The main home is warm and inviting, featuring hardwood floors, 3 bedrooms, a spacious kitchen and bath, a welcoming living room with a wood-burning fireplace, and a finished lower level with family room, 3/4 bath, and laundry area. Outdoor spaces are equally appealing, with a sunny 3-season porch, back deck, and hot tub overlooking a beautifully landscaped yard that gently abuts the woods for added privacy and a peaceful natural setting. A major highlight of the property is the detached accessory dwelling unit built in 2021. This thoughtfully designed 1-bedroom, 1-bath bungalow includes its own laundry and private deck, offering excellent flexibility for rental income, guests, extended family, or a private work-from-home setup. A new septic system was also installed in 2021. Conveniently located just one mile from the Lebanon Green, restaurants, the Opera House, library, and post office, with easy access to the Northern Rail Trail, city pool, and Lebanon Middle School.
Description:Investment property, Great income stream from Laundromat and tenants. Fantastic location close to public transportation and local amenities.