Title Page Background
DEBUG FN args: Array ( [0] => 2938 [1] => [2] => [3] => agent ) BEFORE: Site: 2938 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2938 Igate: njhud LocID: 2938 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 = 2938 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] => 2938 [1] => [2] => [3] => lender ) BEFORE: Site: 2938 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2938 Igate: njhud LocID: 2938 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 = 2938 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] => 2938 [1] => [2] => [3] => other ) BEFORE: Site: 2938 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2938 Igate: njhud LocID: 2938 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 = 2938 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;

4516 Nw Commons Dr
Pasco, WA 99301

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $514,900
Beds: 3
Baths:
Status: Active
SqFt: 2390 Square Feet
Agency: Brian Shymatta & Associates LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Other
Year Built: 2010
Notes: MLS# 276854 Don't miss out on this stunning West Pasco gem! This expansive 2,390 sqft home is designed for comfort and modern living, featuring three spacious bedrooms, two and a half bathrooms, and an inviting bonus room upstairs perfect for an office, playroom, or extra living space. The master suite is a true retreat with its luxurious soaking tub, walk-in shower, and LED-lit faucets, providing a spa-like experience every day.The heart of this home is the kitchen, boasting stainless steel appliances, a large pantry, and abundant cabinet space, making it perfect for both everyday meals and entertaining. The convenience continues upstairs with a dedicated laundry room and ample storage throughout.Step outside to your own private oasis. The beautifully landscaped, fully fenced backyard includes a garden bed area, and a full-length covered patio, ideal for summer gatherings and relaxation. The insulated and finished three-car garage with openers offers plenty of space for vehicles and projects, with potential for a shop or boat/RV parking.Recent updates enhance the appeal and functionality of this home, including Pergo waterproof flooring, newer carpet, fresh interior paint, updated plumbing fixtures, ceiling fans, lighting fixtures, gutters, and stylish Board and Batten siding.Conveniently located near top-rated schools, community parks, medical offices, grocery stores, and a variety of dining options, this home offers the perfect blend of tranquility and accessibility.This home is a must-see! Schedule your viewing today and seize the opportunity to make this incredible property your own./Brian Shymatta/CELL: 509-460-8567/Brian Shymatta & Associates LLC//
MlsNumber: --


Listing Provided By: Brian Shymatta & Associates LLC, original listing
Phone: (509) 460-8567
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App