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

2613 Morris Ave
Richland, WA 99352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $900,000
Beds: 5
Baths: 4
Status: Active
SqFt: 3622
Agency: Realty One Group Ignite

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2022
Notes: MLS# 275826 Welcome to your dream home built in 2022! This stunning 2-story New Traditions LaCrosse floor plan is designed for modern living with a versatile multi-gen setup and luxurious amenities throughout. This home was custom designed with functionality, storage and elegance in mind. You'll find custom built in cabinets and bookshelves throughout the home. Main level features a fully-equipped multi-gen area complete with a cozy living space, a full bath, and a bedroom, perfect for accommodating guests or extended family members. The den has custom-built cabinets and bookshelves, offering the ideal space for work or relaxation. Spacious dining area, and an oversized kitchen island with granite countertops and ample storage. The design of the kitchen was that of storage and functionality. The main living area features is adjacent to the kitchen providing for endless opportunities to entertain with the areas flowing throughout. Enter from the garage to find a built-in storage mud area, keeping your entryway organized and clutter-free. The upper level features 4 bedrooms and laundry room. Spacious 15x16 primary suite, boasting a special custom office room with a windows to bring in natural light—a must-see feature for anyone in need of a tranquil workspace. The master bath offers dual sinks and an oversized closet, providing both functionality and elegance. Each additional bedroom offers ample space for rest and relaxation. The laundry room is conveniently located on this level and comes complete with a washer, dryer, utility sink, built-in cabinets, and a folding table, making laundry day a breeze. Step outside to enjoy a pickleball court and playset, perfect for outdoor fun with family and friends. Relax and entertain on the covered patio area while admiring the fully landscaped yard, creating a serene outdoor retreat. The solar panels included with the home provide for energy efficiency and low utility costs. All appliances stay too - including washer and dryer Seller financing is an option as well!/Dana Siegel/CELL: 509-987-7381/Realty One Group Ignite//
MlsNumber: 275826


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