SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and subdivision like'%Olde Farms' and subdivision like'%Olde Farms'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Ranch-style home in the Olde Farms subdivision in Grantham, NH offers one level living. Set on 5+ acres with a landscaped yard and stone walls. This 4-bedroom, 2.5-bath home features a kitchen with quartz countertops and stainless steel appliances flowing into an open dining area with slider to the back deck. Front door enters into the formal living room with a propane fireplace. The main level includes a primary bedroom with an en-suite bath, and all other bedrooms and baths. A spacious first-floor laundry/mudroom competes the main level. The finished walkout lower level offers additional living space with a family room, plus a workshop and utility room. Exterior highlights include a front farmer’s porch, patio with built-in fire pit, hot tub, garden shed, and a generous yard. An attached two-car garage provides added convenience. Easy access to I-89 and only 20 minutes from Dartmouth-Hitchcock Medical Center.