|
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='201001094'
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
|
|
|
|
|
