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_british_columbia dl left join realtyterminus_agent b on b.agent_id=dl.agent_id WHERE dl.mls_status='active'   AND dl.Type IN ('House')  AND dl.listprice_2 BETWEEN 400000 AND 500000 AND dl.listprice_2!=0 ORDER BY dl.id DESC LIMIT 0,15