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.lat, dl.lng,dl.logo_image,dl.img_awss3,dl.agent_id,b.reoffice as brokerage_name,dl.openhouses FROM ddf_listings dl left join realtyterminus_agent b on b.agent_id=dl.agent_id WHERE dl.mls_status='active' AND province in('British Columbia','Manitoba','Ontario') AND dl.city IN ('Squamish') AND dl.ribbon IN ('For sale') AND dl.listprice_2!=0 GROUP BY dl.id ORDER BY dl.id DESC LIMIT 0,32British Columbia - Squamish - Listings For Sale
