No properties found.
select listingtype as type,listings.listingid as ln,listprice as price,type as propetype,
listingarea as area,bathstotal as ba,bedrooms as br,publicremarks,listings.livingarea as sqft,locationinfo.city as city,locationinfo.subdivision as subdivision,realtorinfo.agemail,
officeinfo.office,officeinfo.bkrcity,officeinfo.bkrcode,favorites.userid
from listings,officeinfo,favorites,locationinfo,extinfo,realtorinfo
where locationinfo.subdivision in ('The Highlands at Broken Top') and
officeinfo.bkrcode=listings.officeid
and extinfo.listingid=listings.listingid
and realtorinfo.agcode=*listings.agentid
and (listingstatus='A' or listingstatus='C')
and favorites.userid=-1
and listings.listingid*=favorites.ln
and locationinfo.listingid=listings.listingid
and listings.officeid in ('SIRSR','SIR')
and (idx='y' or listings.officeid in ('SIRSR','SIR'))
order by listprice DESC |
|
|
