Image is missing
280 W 1st, Preston, ID
Single Family, Bed:3, Bath:2
Sqft:3000

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report
Image is missing
210 S 200, Preston, ID
Single Family, Bed:2, Bath:1
Sqft:1564

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report
Image is missing
210 S 2nd, Preston, ID
Single Family, Bed:2, Bath:1
Sqft:2208

Map | Schools & Index | Direction | Street | Bird's
Nearby | Mortgage | Share | Crime Report

 
SELECT sqft,state,detaillink,city,bath,type,region,selling,basement,lot,bed,value,address,sindex,yearbuilt,imagelink,lat,longt,source as ID FROM allhomes WHERE (city="Preston") and state="ID" and selling>=5000 and selling <=50000000 and bed>=0 and status<>"D" and type<>"L" ORDER by sindex, sellingtotalCount=48