SELECT Id FROM new_searchtable where town like 'Springfield%' and state='VT' and type='R' AND list_price BETWEEN '0' AND '3000000' ORDER BY list_price Desc Springfield VT Homes page 0