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

29843 Royce Ln
Hermiston, OR 97838
Tracy Hunter with eXp Realty, LLC, original listing - (888) 814-9613

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $769,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 3326 Square Feet
Agency: eXp Realty, LLC
Agency Phone: (888) 814-9613

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1984
Notes: Custom built home, only 1 owner sitting on 0.91ac! As you step inside, the living room greets you with floor-to-ceiling windows that showcase views across the Umatilla River and Riverfront Park. The double-decker decks along the full backside of the home also take advantage of the views and are great for relaxation or entertaining guests. The main level flows seamlessly between the living room, kitchen, and dining area. A distinctive walk-around brick wall provides a unique space for displaying cherished items and books. The kitchen features Corian countertops, an eating bar, a large pantry, hardwood floors, and an adjacent dining room with sliding doors leading to the upper deck. Next to the living room, is a room you could use as an office, reading nook, or workout room. The primary bedroom offers private deck access, generous closet space, and a spacious bathroom equipped with a double sink vanity, quartz counters, a separate room with a toilet, a walk-in shower, and a soaking tub. The walk-out basement is where you’ll find a family room with a gas fireplace, built-in cabinets and shelving, and a door leading to the lower deck. Three additional bedrooms on this level provide privacy and share a full bath, making it perfect for guests. The laundry room is equipped with cabinets, a storage closet, a furnace, and a tankless water heater. An extra storage room, along with an adjoining space featuring a door to the lower deck, is perfect for seasonal items or outdoor equipment. The oversized 2-car garage is attached with space beside the home for RV or toy parking. Reach out to your favorite Realtor today to arrange a tour of this remarkable property!
MlsNumber: --
ListingId: 293070205


Listing Provided By: eXp Realty, LLC, original listing
Phone: (888) 814-9613
Office Phone: (888) 814-9613
Agent Name: Tracy Hunter
Disclaimer: Copyright © 2025 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