Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3303 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3303 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3303 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

21728 Highway 99e
Aurora, OR 97002

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $635,000
Beds: 4
Baths: 3
Status: Active
SqFt: 3020
Agency: Living Room Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1927
Notes: The Best of Town & Country! Perched atop a large pastoral lot, you'll feel welcome & secure from the moment you enter this classic, yet modern-living bungalow home, located in the heart of historic Aurora! Updated, while original in all the right ways, this stylish property exudes vintage charm and has benefitted from thoughtful renovations carried out by several of its most recent caretakers. The large list of upgrades starts with modern electrical & plumbing, fresh kitchen & bathroom finishes, newer windows, roof, gutters, furnace & efficient heat pump with AC. Fireplace, fencing & sewer have all been brought up to fine standard as well. Outstanding lower-level studio apartment could be viewed as a 5th bedroom, yet creative owners might consider the use of this nicely appointed area for multi-family, recreational & more! Investment-minded buyers would also be well advised to investigate the income producing viability of this space, if that is a goal. Tons of storage available in the partially finished basement zones; or use as home gym or (???) you name it! Tuck under garage currently utilized as laundry, gardening, and workshop space, with new cabinetry & countertops installed. Dual entrance driveway has been freshly graveled & provides ample parking. And don't forget to explore the spacious grounds, where the gardener in you can finally bloom! Amazing soil supports a healthy ecosystem with fruit trees & bushes bearing walnuts, plums, blueberries, loganberries, apples, pears, grapes & various other flora. Elevated high above road level, with no neighbors in direct view, a fence lined driveway, plus a touch of white noise from traffic below, all contribute to a real sense of privacy at this property. Close to a vibrant and fun community, near shops, eateries, nature, parks & just a stone's throw from ye olde local pub :^) All this, plus an easy commute to Portland or Salem. Check out the 3D Tour. This may just become the place where your heart feels most at home!
MlsNumber: 24005591


Listing Provided By: Living Room Realty, original listing
Name: Living Room Realty
Phone: (503) 719-5588
Office Name: Living Room Realty
Office Phone: (503) 719-5588
Agent Name: Chad Meier
Disclaimer: Copyright © 2024 Regional Multiple Listing Services. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App