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

5401 Upper Five Mile Rd
The Dalles, OR 97058

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,699,000
Beds: 3
Baths: 3
Status: Active
SqFt: 3950
Agency: Real Broker, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 13 acre(s)
Property Type: Residential
Year Built: 2006
Notes: Discover the perfect blend of country charm and modern luxury with this captivating 13.36-acre estate in The Dalles, OR. This custom-built home offers 3 bedrooms, 3 bathrooms, and an expansive 3,950 square feet of living space. This property provides the ideal balance of convenience and serene, nature-filled living.As you enter, you?re greeted by a spacious and cozy living room that boasts large windows overlooking the beautiful in-ground pool, creating a seamless connection between indoor comfort and outdoor leisure. A wood panel accent against the window adds a touch of rustic elegance, while the floating staircase adds a contemporary flair. The heart of the home is the modern kitchen, featuring striking dark countertops, light wood cabinetry, and a central island with an additional sink, perfect for culinary enthusiasts.The main floor houses the luxurious primary bedroom, offering stunning views of the pool and yard. This private retreat is designed for relaxation and comfort. The home also includes a versatile utility room and a 2-car garage for added convenience.Entertaining is a delight in the fully finished basement, complete with a built-in bar and room for a pool table, ideal for hosting gatherings with family and friends. Upstairs, natural light floods the cozy loft area, creating a warm and inviting space for reading or relaxation.Step outside to your own private paradise. The expansive grounds feature an outdoor bar, a seasonal creek, an in-ground pool, and a hot tub, making it the perfect setting for outdoor entertaining and relaxation. The private driveway ensures peace and seclusion.A highlight of this property is the 900 sqft shop, half of which has been converted into a comfortable guest residence, offering flexible accommodation options and the other half has plenty of room for all your toys. Alternatively, it can be easily converted back into a full workshop tailored to your needs.
MlsNumber: 24559659


Listing Provided By: Real Broker, LLC, original listing
Name: Real Broker, LLC
Phone: (503) 740-9768
Office Name: Real Broker
Office Phone: (541) 645-4499
Agent Name: Jennifer Dillard
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