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

6626 Se Riverside Dr
Vancouver, WA 98661

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,588,000
Beds: 4
Baths: 4
Status: Active
SqFt: 3148
Agency: Keller Williams Premier Partners

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2021
Notes: Welcome to your luxurious retreat with breathtaking views of the Columbia River & Portland lights! Relax as you witness 4th of July fireworks, Christmas ships, colorful sailboat spinnakers, & majestic cruise ships. On clear days, catch a glimpse of Mt Jefferson, while evenings treat you to the radiant hues of sunset. This custom-built masterpiece boasts 4 beds, 4 baths, over 3,148 sqft on a sprawling 1/3 acre in the prestigious Evergreen Hwy area. Indulge in the epitome of luxury living in this stunning open-concept home, featuring engineered hardwood flooring, gorgeous gas fireplace w/stone surrounding, built in cabinetry, & floor-to-ceiling windows that flood the family, dining, and kitchen areas with natural light, offering panoramic views! The kitchen is a culinary delight, featuring top-of-the-line Bosch appliances, complemented by under-cabinet lighting, soft close cabinets & pull-out shelves, hidden plugs for a sleek finish & large pantry w/room for a second refrigerator! Delight in the spacious primary suite on the main floor, complete with a luxurious bathroom boasting heated floors, dual sinks, toe kick lighting, walk-in tile shower, spacious custom walk-in closet & full-size stacked washer/dryer for easy laundering! Enjoy the large balcony that extends the front side of the home, equipped with a natural gas bbq & plenty of seating space for entertaining while the homes natural gas furnace & tankless hot water system ensure comfort & efficiency year-round. Smart home integration & a comprehensive security system w/outdoor cameras provide peace of mind. Constructed in 2021 with meticulous attention to detail, this home offers modern amenities including extra electrical features, solar landscape lighting, outdoor hose bib w/hot & cold, solar & EV ready, & an elevator for convenience. Dont miss the opportunity to own this extraordinary home with easy access to I-5, 205, HWY14, and the Tidewater walking trail. No HOA fees. Home warranty included.
MlsNumber: 24296935


Listing Provided By: Keller Williams Premier Partners, original listing
Name: Keller Williams Premier Partners
Phone: (360) 693-3336
Office Name: Keller Williams Realty
Office Phone: (360) 693-3336
Agent Name: Amy Asivido
Disclaimer: Copyright © 2024 Regional Multiple Listing Services. 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