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

508 3rd Ave
Dallesport, WA 98617
Angie Jaggers with Kelly Right Real Estate Vancouver, original listing - (503) 719-6056

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,999
Beds: 6
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4594 Square Feet
Agency: Kelly Right Real Estate Vancouver
Agency Phone: (503) 719-6056

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: Spacious 6-bedroom home with a mother-in-law apartment and mountain view, perfect for families or multi generation living. Welcome to your dream home! This stunning 6-bedroom, 5-bathroom residence offers the perfect blend of comfort, style, and functionality. A standout feature is the fully equipped mother-in-law apartment, complete with its own kitchen, living area, bedroom, and bathroom. This space is ideal for extended family, guests, or potential rental income. Nestled in a peaceful neighborhood with breathtaking views, this home is ideal for growing families and those who love to entertain. Generous living space with six spacious bedrooms, there's plenty of room for everyone. Each bedroom is designed to provide privacy and comfort, making it easy to accommodate family members and guests. The open concept living and dining areas are perfect for family gatherings. Large windows fill the space with natural light, highlighting the beautiful views. The heart of the home features a fully equipped kitchen with high-end appliances, quartz countertops, and ample cabinet space. It's perfect for preparing meals while staying connected with family and friends in the adjoining living area. No more morning rush! With five well-appointed bathrooms, convenience is guaranteed for everyone in the household. A bonus feature of this property is the spacious fully insulated and sheet rocked shop, perfect for hobbies, storage, or even a home business. Whether you're a DIY enthusiast or need extra space for your projects, this shop will meet all your needs. Enjoy the beauty of nature from your own backyard. The property offers ample space for to play, garden, swim in your above ground pool or simply relax while soaking in the stunning views. Located in a friendly community with top-rated schools, and amenities nearby, this home is perfect for families who value both tranquility and convenience. Don’t miss the opportunity to make this house your forever home!
MlsNumber: --
ListingId: 24593652


Listing Provided By: Kelly Right Real Estate Vancouver, original listing
Phone: (503) 719-6056
Office Phone: (503) 719-6056
Agent Name: Angie Jaggers
Disclaimer: Copyright © 2025 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