SELECT Id FROM new_searchtable
where (water_body like '%Pine River Pond%') and type='R'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Copyright © 2018 New England Real Estate Network, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of NEREN. The information being provided is for consumers´ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated July 21st, 2018 Designed by BSC DATA