SELECT Id FROM new_searchtable
where town = 'Plainfield' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Plainfield NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Combining traditional New England charm with an urban loft appeal, this gorgeous post and beam home blends luxury and creative artistic expression. The 15+/- ac property has extensive gardens, brick walkways, five decks and porches. Fabulous 28' vaulted ceiling in living room is highlighted by a towering fieldstone fireplace and a surrounding balcony library. Superb chef's kitchen with concrete counters and deep soapstone sink. Floor-to-ceiling southwest-facing windows. Three gorgeous bedroom suites. 1200 sq ft one bedroom in-law apartment above garage with separate entry. Bonus barn on lower property can be additional storage space or a quiet studio. This home is a magical work of art that will make your heart sing!