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 ='M'
and subdivision like'%Hillcrest Acres' and subdivision like'%Hillcrest Acres'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Multi Family Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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.