Property Details
Property not found...
))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='201004642' 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.
|
|
|
|
