SELECT Id FROM new_searchtable where (water_body like 'Mascoma%') and type ='T' and subdivision like'%Shaker Landing Condominium Association' and subdivision like'%Shaker Landing Condominium Association' AND list_price BETWEEN '0' AND '30000000' ORDER BY list_price Desc Mascoma Lake Real Estate NH Condos page 0