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 = 2211 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 = 2211 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 = 2211 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;

6150 Nw Kingwood Ave
Redmond, OR 97756
Lindsay Taylor with Keller Williams Realty Portland Elite, original listing - (503) 744-0000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,195,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2756 Square Feet
Agency: Keller Williams Realty Portland Elite
Agency Phone: (503) 744-0000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: This extraordinary property blends modern amenities w/rustic charm, set on a sprawling 10.16 acres & featuring not one, but TWO legal dwellings! The estate offers breathtaking views of 4 majestic nearby mountains & includes 4.83 acres of COID Irrigation, w/rare easement granting 24/7 access to water. The primary residence is a custom-built masterpiece w/spacious, thoughtfully designed layout w/new luxury vinyl plank flooring & a vaulted ceiling. The kitchen is a highlight, featuring elegant granite countertops, high-end appliances including a premium Wolf stove, an oversized island & a custom bar ideal for entertaining. The primary suite serves as a luxurious retreat w/high ceilings, a private slider leading to the patio, heated tile flooring, a custom tile shower w/dual shower heads & an impressive walk-in closet. Each additional bedroom is designed w/premium carpet, built-in features & walk-in closets. The exterior of the property is equally enchanting. Brown rock landscaping, sand-finished concrete & a custom-built pond. The covered patio, fire pit & stunning mtn views provide perfect spots for relaxation. Adjacent to the main house is a stunning 42x56 custom-built shop w/ concrete floors, power, built-in cabinets & heater. Shop includes two 12x41 paddocks for livestock, along w/dedicated spaces for lawn equipment & firewood storage. Second residence w/3 bedrooms, 2 bathrooms, 2,400 sq ft, private driveway entrance, a garage & mtn views! Ideal for multigenerational living or rental income opportunity! Barn features 6 stalls (3 fully matted), 12x24 paddocks, hay storage & tack room. Also includes a living space, bedroom & full bathroom. 220x120 outdoor riding arena equipped w/Red River roping chutes, round pen & 4 fenced pastures. Bonus features include a 72x22 storage/shop, a potato shed, custom dog kennel, pump house w/instant HW, 12 raised garden beds w/drip system & ample parking for trailers & equipment. The perfect blend of rural charm & modern convenience!
MlsNumber: --
ListingId: 24093968


Listing Provided By: Keller Williams Realty Portland Elite, original listing
Phone: (503) 744-0000
Office Phone: (503) 744-0000
Agent Name: Lindsay Taylor
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.


Local Real Estate Expert

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 = 2211 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;
Real Estate Expert Photo for Stephanie Stovall Broker
Stephanie Stovall Broker
ASCIIeXp Realty
Call Today!: (541) 588-0509

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App