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 = 2207 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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 = 2207 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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 = 2207 AND i.igate IN ('usahud','orhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'orhud', 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;

55051 Fullerton Rd
Warren, OR 97053
Ruthann Hewgley with Realty Pro Oregon LLC., original listing - (503) 224-7444

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,999,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4400 Square Feet
Agency: Realty Pro Oregon LLC.
Agency Phone: (503) 224-7444

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Step foot into your very own tranquil oasis. Welcome to O Maha Nui! Translated, this means Place of Great Joy. Behind your private gated entry, lies over 6 pristine acres surrounded by secluded forest. This property truly has it all and more. This beautifully built 4400sqft custom home with wraparound deck, overlooks the stunning and secluded property while still being only minutes from shopping & restaurants in downtown Portland. The gourmet kitchen features a newer Wolf gas range, pot filler above the stove, custom cabinets, large side-by-side refrigerator, and a beautiful island which overlooks the expansive great room with its vaulted ceilings and carefully crafted, custom gas fireplace. The large screened-in porch overlooking fields and woods is perfect for year round enjoyment. In the spacious primary bedroom, you will find a generously sized en-suite with clawfoot tub, large walk-in closet, and a private porch for you to soak in the views. The expansive lower level has all new updated flooring with potential for multi-gen living, theater room, or whatever bonus space you can dream up. On the lower level you will also find a cold storage pantry fantastic for stocking up, or could be converted into a wine cellar. New lighting, interior paint, and ample storage throughout the entire home. The immaculately landscaped park-like property contains many different fruit trees, gardens, pond, and so much more. This property also boasts an oversized 2 bay shop, fully livable cottage/ADU with its own private detached garage, 2 covered RV carports, a chicken coop, plus a huge barn with horse stables and a potting room. This property is perfect for animals, toys, and all of your hobbies. You need to see this one to believe it!
MlsNumber: --
ListingId: 24018777


Listing Provided By: Realty Pro Oregon LLC., original listing
Phone: (503) 224-7444
Office Phone: (503) 224-7444
Agent Name: Ruthann Hewgley
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