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

787 S Edgewood St
Seaside, OR 97138

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $440,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1425
Agency: Windermere Realty Trust

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1991
Notes: Reclaim your work-life balance ? all within a few hours' drive from your main home. Ever wish you didn't have to drive home after a day at the beach? This light, bright, spacious 3BR/3BA home is big enough, modern enough, and nearby enough to enjoy the relaxed comfort of the beach on a regular basis, capturing that vacation vibe with a quick weekend turnaround. Instead of starting or ending a workday with loud traffic noise, listen to the tide coming in at the Prom 4 blocks away, or watch the ever-changing Necanicum River wildlife show a mere few feet from your deck as you enjoy your morning coffee or happy hour local brew. This property also has the only remaining dock on the river, and it?s right outside your lower back door. Second homes aren't just for vacations anymore -- you can now easily live one life in two places. And splitting time between two homes increases a sense of community that just visiting doesn't have. Imagine the gratification of being on a first-name basis at nearby shops and local restaurants just 7 blocks away in iconic Seaside, home of pristine sandy beaches and peaceful coastal living. The kitchen? A chef's delight, with modern appliances, ample storage space, and an eating bar that invites casual conversations. Each bedroom has its own full bath, offering tranquility and privacy, and the primary suite has vaulted ceilings and a big river view. Leave your cars in the 2-car garage (plenty of guest parking, too) and explore: the close-by Promenade boardwalk stretches along the beach; the lively downtown is filled with quaint shops, delicious eateries, and family-friendly entertainment; and plenty of hiking trails dot the area. This condo offers an affordable chance to embrace the idyllic Seaside lifestyle, with room and privacy for everyone. Come experience the joy of the Oregon coast, where every day feels like a vacation. Leased rental of 30 days or more is allowed.
MlsNumber: 23459938


Listing Provided By: Windermere Realty Trust, original listing
Name: Windermere Realty Trust
Phone: (503) 220-1144
Office Name: Windermere Realty Trust
Office Phone: (503) 220-1144
Agent Name: Anne Yoo
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