))0(( select realtorinfo.agcode as agcode, listingtype as type,listings.listingid as ln,listprice as price, type as propetype,listingarea as area,bathstotal as ba,bedrooms as br,area as acs,livingarea as sqft, publicremarks,extinfo.style, listings.officeid as bkrcode, officeinfo.bkrcity,officeinfo.office,officeinfo.bkraddress,officeinfo.bkrphone, officeinfo.bkrweb,officeinfo.showinfo as officeshowinfo, realtorinfo.firstname,realtorinfo.lastname,realtorinfo.agweb,realtorinfo.agemail, realtorinfo.phone,realtorinfo.phone_type,realtorinfo.phone2, realtorinfo.phone_type2,realtorinfo.phone3,realtorinfo.phone_type3, realtorinfo.bio,realtorinfo.photo,realtorinfo.showinfo, streetnumber+' '+ streetdirprefix+' '+streetname+' '+streetsuffix as ad, locationinfo.city,favorites.userid from listings,extinfo,officeinfo,locationinfo,realtorinfo,favorites where listings.listingid='201000617' and extinfo.listingid=*listings.listingid and officeinfo.bkrcode=*listings.officeid and locationinfo.listingid=*listings.listingid and realtorinfo.agcode=*listings.agentid and favorites.ln=*listings.listingid

Listings Engine Powered by Matrix Digital Media, Inc.