singerislandproperties.com

SELECT * FROM LISTINGS WHERE ML_Number_w_letter_prefix LIKE '%%' AND Liv_Area_SqFt >= 0 AND Bedrooms >= 0 AND Full_Baths >= 0 AND List_Price <= 900000 AND List_Price >= 800000 AND City LIKE '%%' AND List_Office_ID LIKE '%%' AND List_Agent_ID LIKE '%%' AND Sub_Type LIKE '%%' AND Address LIKE '%%' AND Legal_1 LIKE '%%' AND Area_Number LIKE '%5240%' AND Zip_Code LIKE '%%' AND Waterfront_YN LIKE '%%' ORDER BY `List_Price` DESC LIMIT 50

4 Singer Island Properties For Sale Found

---

---

---

---