SELECT photo1 FROM listings_photos WHERE listing_id1 = '106' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
483 Evered Avenue
$875,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 = '205' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
1200 Bethamy Lane
$228,000
SELECT photo1 FROM listings_photos WHERE listing_id1 = '193' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
SELECT photo1 FROM listings_photos WHERE listing_id1 = '197' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
200 INLET PVT #208
$339,900
SELECT photo1 FROM listings_photos WHERE listing_id1 = '194' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
SELECT photo1 FROM listings_photos WHERE listing_id1 = '195' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
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 = '203' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
273 Topaze Cresecent
$469,800
SELECT photo1 FROM listings_photos WHERE listing_id1 = '207' ORDER BY orderid1 ASC, id1 DESC LIMIT 1
