SELECT photo1 FROM listings_photos WHERE listing_id1 = '212' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
768 Island Park drive
$999,888
SELECT photo1 FROM listings_photos WHERE listing_id1 = '249' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
SELECT photo1 FROM listings_photos WHERE listing_id1 = '256' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
12 Metropole Pvt
$729,900
SELECT photo1 FROM listings_photos WHERE listing_id1 = '259' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
134 York Street #1106
$344,900
SELECT photo1 FROM listings_photos WHERE listing_id1 = '196' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
SELECT photo1 FROM listings_photos WHERE listing_id1 = '207' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
878 Ivanhoe Avenue
$1,050,000
SELECT photo1 FROM listings_photos WHERE listing_id1 = '190' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
201 Parkdale Ave #705
$295,000
SELECT photo1 FROM listings_photos WHERE listing_id1 = '231' ORDER BY orderid1 ASC, id1 DESC LIMIT 1