SELECT dl.id,dl.listingid, dl.bathstotal, dl.bedrooms,dl.lotsize,dl.streetaddress,dl.SizeInterior,dl.street_number, dl.street_name, dl.street_type, dl.city, dl.province, dl.postalcode, dl.Country,dl.ribbon,dl.LeasePerTime,dl.lease,dl.listprice_2, dl.listingtype,dl.Type, dl.remarks,dl.agenntarray,dl.lat, dl.lng,dl.logo_image,dl.img_awss3,dl.agent_id,b.reoffice as brokerage_name FROM listings_ontario dl left join realtyterminus_agent b on b.agent_id=dl.agent_id WHERE dl.mls_status='active' AND dl.city IN ('Ajax','Aurora','Brampton','Brockville','Burlington','Caledon','Georgina','Markham','Milton','Mississauga','Newmarket','Oakville','Oshawa','Pickering','Richmond Hill','Toronto','Uxbridge','Vaughan','Whitney') AND dl.Type IN ('Apartment') AND dl.listprice_2!=0 ORDER BY dl.listprice_2 DESC LIMIT 0,15