 |
 |
 |
 |
 |
 |
 |
 |
 |
||||
 |
 |
 |
 |
 |
|
 |
|||||
Homes, Condominiums and Homesites For Sale
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='201001711' 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.
Each office independently owned and operated and All information is deemed reliable, but in not warranted by Coldwell Banker Reed Bros. Realty, its employees, sales associates or persons doing business on behalf of CBRBR.