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 = '231' ORDER BY orderid1 ASC, id1 DESC LIMIT 1SELECT photo1 FROM listings_photos WHERE listing_id1 = '264' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
1184 Cummings Avenue
$1550
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 = '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 = '196' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
SELECT photo1 FROM listings_photos WHERE listing_id1 = '265' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
6331 Tealwood Place
$299,900