SELECT Id FROM new_searchtable
where town = 'Plainfield' and state='NH' and (type = 'R' or type ='O')
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Plainfield NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:2 bedroom, 1 bath log home with family room in basement on 8.14 acres of land. Home needs some TLC to the flooring & deck. There is a second heat source, an outdoor wood boiler that needs some repair. Close to KUA, short drive to shopping, lakes and mountains for outdoor fun. Septic system is for a 3 bedroom home. The family room in the basement could easily be used as a bedroom.