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

386 Columbia Point Drive #302
Richland, WA 99352

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,050,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2957
Agency: KENMORE TEAM LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2006
Notes: Welcome to a sophisticated and comfortable lifestyle in The Moorings at Columbia Point! This luxury riverfront top-floor condo boasts 3 BR and 3 BR offering a perfect blend of elegance and practicality. The convenient elevator leads you effortlessly to the front door. Beautiful open layout features raised ceilings and a great room with a gas fireplace, creating a warm and inviting atmosphere, while a wet bar and wine fridge enhance the entertainment possibilities and make it an ideal space for social gatherings. The gourmet kitchen is a chef's dream, equipped with stainless steel appliances, granite tile counters, full tile back splash, a gas range, cherry wood cabinetry, a convenient walk-in pantry, and a large island with a dining bar. The spacious formal dining room is adjacent to kitchen, adding practicality to the space. A private primary suite is a sanctuary of comfort and boasts a slider to the large 432 square foot balcony overlooking the river, allowing you to unwind in tranquility. An oversize primary suite bathroom features a spacious walk-in shower and a Bain Ultra air jet tub as well as a large walk-in closet with custom organization. Enjoy breathtaking views from the balcony and spacious open patios that overlook the marina and Columbia River. An oversize two-car garage is located on the lower level for additional storage options. This condo is perfectly situated for those who appreciate the finer things in life, with the convenience of walking to nearby restaurants, golf courses, and shopping. Additionally, being next door to the Richland Yacht Club adds a touch of exclusivity to your lifestyle. Experience the luxury of riverfront living with this meticulously designed condo at The Moorings. Welcome home to comfort, convenience, and captivating views!/Alex Burden/CELL: 509-438-7414/Kenmore Team//
MlsNumber: 274513


Listing Provided By: KENMORE TEAM LLC, original listing
Name: KENMORE TEAM LLC
Phone: (509) 987-4544
Office Name: Kenmore Team
Office Phone: (509) 987-4544
Agent Name: Alex Burden
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