SELECT Id FROM new_searchtable
where town = 'Lyme' and state='NH' and (type = 'R' or type ='O')
and (bedrooms='3' and baths >='2') and (bedrooms='3' and baths >='2')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Lyme NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Terrific location next to the Pinnacle Trail and just a minute walk to lovely Lyme village, popular restaurants, the Lyme Village Store and the elementary school. Classic cape stye home offers plenty of possibilities for everyone. Three bedrooms, two baths, cheerful living spaces, and cozy family room with wood stove. Beautiful, private, fenced rear yard for gardening and fun. Two car garage all on 1.7 acres.