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

New Search

Back

Listings Engine Powered by Matrix Digital Media, Inc.

Julie Fincher

ABR, SFR Principal Broker

REMAX Sunset Realty
Sunriver, Oregon.
Village Mall, Building 2 Sunriver, OR 97707

Direct: (541) 420-1051
Office: (541) 536-0117
Toll Free: (888) 868-2052
Fax Toll Free: (866) 929-1028