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

13000 Ne 238th Ct
Brush Prairie, WA 98606
Ed Anishchenko with Better Homes and Gardens Real Estate Realty Partners, original listing - (360) 567-0475

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,300,000
Beds: 3
Baths: Full: 4
Status: Active
SqFt: 3533 Square Feet
Agency: Better Homes and Gardens Real Estate Realty Partners
Agency Phone: (360) 567-0475

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Other
Year Built: 2020
Notes: Welcome to the master piece worthy to be called your home! Located in the serene tranquility of 380 (approx) acres in the coveted Summer Hills Preserve, this custom built residence is awe-inspiring! The lot backs to acres of greenbelt & the home is designed to encompass the outdoors, affording you abundance of natural light with a sense of complete privacy. From the entrance w/up to 2-story high ceiling, to an open concept great room/dining room/gourmet kitchen w/large Andersen Windows, spaciousness & brightness follow you throughout the home. Great room with fireplace & vaulted ceiling extends to a spacious deck. Formal dining w/dry-bar and built-in wine cooler. The office w/vaulted ceiling is currently used as guest bedroom. Primary bedroom on main level seamlessly extends to a large covered deck. Primary bathroom w/ double sinks & huge walk-in shower. Gourmet kitchen with up to ceiling custom cabinets by NW Line of Style w/high gloss finish, cook-top, hood with screen, built in Bosh Espresso Machine, built in microwave/oven, granite island with eat bar, black stainless steel appliances. The chef's kitchen w/range, hood, sink, cabinets, & counters, is specifically designed as additional space to cook when hosting large parties. Spacious walk-in pantry. Laundry with built-ins on main level & laundry space on the lower. Custom height interior doors and hickory high gloss luxury flooring on the main level. Lower level is accessed either from the inside or through a separate entrance door on the side. The two bedrooms and family room w/wet-bar on the lower level provide an ideal space for multi generational living. Both bedrooms w/own bathrooms, & one w/slider to deck is ideal for fitness/bonus room. Mudroom w/dog grooming station. Driveway large enough to fit a fleet of cars. 3-car oversized garage w/coated floors, black aluminum w/satin glass garage doors, & Tesla charging system. Miles of trails & creeks at your steps. Minutes of picturesque drive from the city!
MlsNumber: --
ListingId: 24206037


Listing Provided By: Better Homes and Gardens Real Estate Realty Partners, original listing
Phone: (503) 888-1504
Office Phone: (360) 567-0475
Agent Name: Ed Anishchenko
Disclaimer: Copyright © 2024 Better Homes and Gardens Real Estate. 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 = 3280 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 John Bishop
John Bishop
ASCIIPremiere Property Group, LLC
Call Today!: (360) 909-1179

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App