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;

4102 Phoenix Lane
Pasco, WA 99301

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $559,000
Beds: 5
Baths:
Status: Active
SqFt: 2815 Square Feet
Agency: Realty One Group Ignite

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: MLS# 276197 If you are looking for a home that checks all the boxes, has room for everyone including MULTI-GENERATIONAL living, PLUS room to grow, this is it!  This LIKE NEW 2016, 5 bedroom, + Den/Living rm, 4 bath, 2815 sq. ft., open concept home has TWO Master suites, including 1 on the main floor, walk-in closets galore, large 3 car garage, and has been well maintained! NEW hard surface flooring 2024, extended back patio 2021, additional parking with space for recreational vehicles in 2021, enhanced HVAC in 2019, and curbing in 2022. As you enter find the Den/Living rm. and a beautiful staircase perfect for decorating for the holidays! A half bathroom, landing area, entry closet, and garage entrance provide convenient spaces to keep ORGANIZED. The kitchen is wonderfully sized, with an excellent and functional layout, including beautiful high-quality cabinetry, a window over the sink, an island with additional cabinet storage & seating, and a perfectly sized pantry. Just off the kitchen enjoy all the natural light in the large dining room, that’s ACTUALLY big enough for your good-sized table to seat all your guests, as well as being a perfect entertainment space with the large extended patio, and perfect sized yard within view! The main family room is very large and will provide plenty of space for large furniture, as well as gatherings, with this highly sought out open floorplan. Don’t forget the first of TWO Master bedroom suites, on the MAIN FLOOR. This good-sized master is plenty large, boasts a walk-in closet, an additional closet for all your storage needs, an attached on-suite bathroom including separate walk-in shower & soaking tub, double sink vanity, and linen closet! Heading upstairs you’ll find 3 more bedrooms, a laundry room with sink, a full bathroom with double sink vanity, and the second MASTER SUITE. A large Oasis, this Master Suite has an on-suite Master Bath with walk-in shower, soaking tub, double sinks, and a walk-in closet. Outdoors find the perfect sized fully fenced yard with plenty of space, extended patio, large pull-through gate, RV parking with 30-amp plug in, w/additional parking in front, wood storage shed, UGS, and beautifully maintained grass. Close to shopping, beautiful parks, Elementary & Middle Schools you don’t want to miss out on this one. Call today for more information! /Richelle Davis/Cell: 509-212-9945/Realty One Group Ignite//
MlsNumber: --


Listing Provided By: Realty One Group Ignite, original listing
Phone: (509) 212-9945
Office Phone: (509) 581-1911
Agent Name: Richelle Davis
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