|
|
Central Oregon Featured Listings
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='2810903'
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.
|
|
Karolyn DuBois
Real Estate Broker
Duke Warner Realty
541-390-7863
Search Real Estate
MLS Certified
|
|
