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 '150000' AND '250000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Located on a large corner lot in the beautiful village of Meriden. Close to KUA, short drive to Lebanon or Claremont for shopping, entertainment and hospitals. The single wide mobile home with 924 square feet, has 2 bedrooms, an office 1 3/4 bathrooms and an open concept Livingroom/eat in Kitchen. features central AC and has a lovely garden shed. Lots of space on both sides of home allow for privacy. Drainage pipe has water coming off the hill in a waterfall type look and feel. Peaceful area, lovely park on a hill.
Description:Be the first to live in this brand-new, 2-bedroom, 2-bath manufactured home overlooking Mascoma Lake. Enjoy an open-concept layout with a modern kitchen featuring stainless steel appliances, a spacious stainless steel farmhouse sink, and washer/dryer hookups.Surrounded by nature and just steps from the rail trail, this home offers the best of both worlds—peaceful lakeside living with easy access to Lebanon’s amenities, including Dartmouth Health, highway access, restaurants, and shopping. This home should be complete by early December 2025 - just in time to settle in before the holidays!
Description:Brand-new 2-bedroom, 2-bath manufactured home located in desirable Currier Park with easy access to Upper Valley amenities. Open-concept layout featuring a modern kitchen with stainless steel appliances, farmhouse sink, and washer/dryer hookups. Located minutes from Lebanon’s amenities, including Dartmouth Health, highway access, restaurants, and shopping. Listing agent is related to Seller.
Description:Welcome home to this brand-new, 2-bedroom, 2-bath manufactured home overlooking Mascoma Lake. The open-concept layout features a modern kitchen with stainless steel appliances, a spacious farmhouse sink, and convenient washer/dryer hookups. Enjoy peaceful lakeside living surrounded by nature, just steps from the scenic rail trail. Located minutes from Lebanon’s amenities, including Dartmouth Health, highway access, restaurants, and shopping.