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

183 Snake River Drive
Burbank, WA 99323

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: 3
Baths: 4
Status: Active
SqFt: 3186
Agency: Brian Shymatta & Associates LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2006
Notes: MLS# 273533 MLS# 269445 Gorgeous Riverfront 1 story Custom Built Stucco Luxury home with over 3100 square feet. This home includes a private boat owners association dock and is located on the majestic Snake River in Burbank, Washington. Spectacular Views ,Amazing Sunsets, Quiet and serene neighborhood, highly rated schools, and a bright and open floor plan, are just a few of the reasons that make this home an exceptional find.From the moment you pull up to the rod iron gates, and long driveway, it becomes evident this home is truly special. From the motor court, walking in the main entrance, you are welcomed by a large foyer’ with soaring ceilings. You will also find a large Formal Dining area, adjacent from a wine bar and serving counter. Rich hardwood flooring and custom tiles you will find throughout the residence. The expansive great room, features a beam ceiling, floor to ceiling rock fireplace with hearth and huge windows that take advantage of the breathtaking views of the River. The Gourmet Kitchen is amazing, with rich wood cabinetry and an abundance of cabinet and counter space, stainless steel appliances, dual ovens, an island with storage, walk-in pantry, granite counters, and a large breakfast nook, that also features a bay window type set-up for those terrific views! Plus radiant heated kitchen floors. This home has a split bedroom design, with two spacious bedrooms on one side of the home that have jack and jill style baths with radiant heated floors that share a gigantic walk in shower. The enormous Master Suite is a retreat within itself, enter through double doors and once again featuring big windows that take in that view! The Master Bedroom w/ensuite also features 2 closets, a garden air tub, dual vanities, an immense spa-like walk in shower with dual shower heads, including rain head, and bench. Also radiant heated floors, and a fireplace next to the tub.In addition you will find a laundry room with ample cabinetry and counter space, and a deep sink, as well as a 1800 sq ft FIVE car garage, attic space and electrical RV hook up, detached 10x12 vaulted ceiling, storage shed. The yard includes a 1084 sq ft covered patio, lawn edge curbing and and automatic underground sprinkler system with 11 zones, provide an almost maintenance free yard with an 80 ft deep private Well for Water, and new septic system on the property. And this just scratches the surface of the many amenities this home has to offer. You owe it to yourself to see it in person./Brian Shymatta/CELL: 509-460-8567/Brian Shymatta & Associates LLC//
MlsNumber: 273533


Listing Provided By: Brian Shymatta & Associates LLC, original listing
Name: Brian Shymatta & Associates LLC
Phone: (509) 460-8567
Office Name: Brian Shymatta & Associates LLC
Office Phone: (509) 460-8567
Agent Name: Brian Shymatta
Disclaimer: Copyright © 2024 PACMLS. 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 = 94 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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;
Shantel Williams
ASCIILOAN DEPOT
Call Today!: (520) 954-2275

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App