Title Page Background
DEBUG FN args: Array ( [0] => 2963 [1] => [2] => [3] => agent ) BEFORE: Site: 2963 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2963 Igate: njhud LocID: 2963 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2963 AND i.igate IN ('wahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2963 [1] => [2] => [3] => lender ) BEFORE: Site: 2963 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2963 Igate: njhud LocID: 2963 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2963 AND i.igate IN ('wahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2963 [1] => [2] => [3] => other ) BEFORE: Site: 2963 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2963 Igate: njhud LocID: 2963 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2963 AND i.igate IN ('wahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'wahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

562 W Sunset Drive
Burbank, WA 99323
Tyson Jones with Kenmore Team, original listing - (509) 987-4544

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $825,000
Beds: 5
Baths: Full: 1, ¾: 1
Status: Active
SqFt: 2900 Square Feet
Agency: Kenmore Team
Agency Phone: (509) 987-4544

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Other
Year Built: 1962
Notes: MLS# 282697 Welcome to your dream riverfront retreat with stunning views and relaxed luxury! This fully updated 5 BR 2 BA rambler with basement in Burbank offers commanding Snake River views and direct river access from your backyard—an unbeatable combination of natural beauty and modern comfort. Plus, with Corps-owned property to the east, you’ll enjoy extra privacy with no neighbors on that side—a rare and coveted perk! Inside, every detail has been carefully considered to create a home that feels both sophisticated and inviting. The main level features LVP flooring throughout the living areas, leading to a stunning great room where the kitchen truly shines. Designed for both style and function, it features an oversized prep island with a dining bar, sleek countertops, stainless steel appliances, and a pantry—all finished with high-end fixtures and gorgeous cabinetry that elevates the space. The formal dining room is positioned perfectly to take in the river views, with a slider opening to the deck, making indoor-outdoor living effortless. Three spacious bedrooms and a spa-like main bathroom with designer touches complete the main level. Downstairs, the lower level is all about comfort and ambiance. The large second living area features an electric fireplace, creating a warm and inviting atmosphere. Thoughtful additions like a flex space (perfect office area, rec room, or even bar area), a convenient laundry room, and slider leading to a covered patio add to the home’s functionality. The primary suite is a true escape, featuring a luxurious en-suite with a tiled walk-in shower, dual sink vanity, and a spacious walk-in closet—all designed with premium finishes that make everyday life feel like a getaway. Sitting on a generous .59-acre lot, this property has an incredible 154 feet of riverfront—a rare find that provides unparalleled access to the Snake River. The home also includes an attached two-car garage and plenty of outdoor space to take in the expansive river views. Peaceful riverfront country living meets modern luxury, with easy access to the highway for convenience. Come experience it for yourself!
MlsNumber: --
ListingId: 282697


Listing Provided By: Kenmore Team, original listing
Phone: (509) 987-4544
Office Phone: (509) 987-4544
Agent Name: Tyson Jones
Disclaimer: Copyright © 2025 PACMLS. 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