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:Brand new 2023 single wide home! Located in the desirable Currier Park with an easy commute to all the amenities the Upper Valley has to offer. There's a nice layout with a bedroom and bath on each end with the living area in the middle. The kitchen has a tile back splash and all new appliances. Open concept affordable living at its best. New decks on the front and rear of the home. Super easy commute into town. Located on the bus route also.
Description:New construction 16x60 mobile home to be place on lot on concrete slab, with insulated skirting ready to move in. 2 bedrooms, primary bedroom with a bath, other bedroom on the other end of home with a full second bath. Kitchen, Living and dining room in center of the home. Access the community from Chellis Road or Route 120. Minutes to Meriden Village and KUA. Taxes have not been assessed. Park $500 per month park rent includes trash, sewer, water, land taxes, and plowing of the main road. This is a very small community park with only 9 lots. 20 minutes to DHMC or Dartmouth. Home is available to tour.
Description:This property is a prime opportunity for rehab investors and buyers seeking a project with significant upside. With 11 rooms, including 5 bedrooms, situated on nearly half an acre and connected to public utilities, the potential for transformation is immense. While this home requires substantial renovations, its size and location make it a compelling investment. Located a short distance from I-89 and downtown Lebanon. Sold as-is, this property is ideally suited for cash buyers or those qualified for rehab loans.