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 = 2952 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 = 2952 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 = 2952 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;

300 W Sid Snyder Dr
Long Beach, WA 98631
Amanda Tardio with John L. Scott Market Center, original listing - (503) 359-9100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: John L. Scott Market Center
Agency Phone: (503) 359-9100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Land-Mixed Use
Year Built: --
Notes: Welcome to this rare opportunity on just over 2 acres of pristine, vacant land right in the heart of Long Beach, Washington. This property offers a coveted location perfectly suited for tourists seeking sun-soaked adventure with an inviting beach access less than a quarter-mile away. Nestled in a high-density tourist hub, your vision here will captivate those in search of an unforgettable experience, year-round. Beachside bliss and a world of attractions await at your doorstep. This property offers versatile zoning - S3 and OTW (Old Town West) - the zoning opens doors to a multitude of creative ventures. Embrace the chance to curate indoor amusements, artisan galleries, a charming bed and breakfast, lodging, bustling retail haven or bring to life the next must-visit culinary destination. The only limit is your imagination. Enjoy all Long Beach has to offer including the vibrant festivals, like the iconic kite festival, that infuse the area with joy and celebration year-round. With an array of permissible uses, water, electricity, and sewer readily available at the street. You have the infrastructure and freedom to create your ideal establishment. The canvas is primed, the location is optimal. Tax parcels included: 1. 73035000001 (101x98) 2. 73035000002 (100x101) 3. 73035000003 (100x100) 5. 73035000005 (100x100) 6. 73035000006 (100x100) 7. 10111633329 (460x100)
MlsNumber: --
ListingId: 24090895


Listing Provided By: John L. Scott Market Center, original listing
Phone: (503) 359-9100
Office Phone: (503) 359-9100
Agent Name: Amanda Tardio
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