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

0 Lot 3 Wisteria Lane
Paso Robles, CA 93446
Gwen Erskine with Country Real Estate, Inc., original listing - (805) 239-9566

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,600,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Country Real Estate, Inc.
Agency Phone: (805) 239-9566

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Land-Other
Year Built: --
Notes: The ONLY Brand-New Commercial C-3 parcels in a premier Paso Robles location! Situated on the NEW Airport Road, just off Highway 46 East, this is the best location for your business! One of only three C-3 Zoned parcels in the heart of the upcoming Union Road interchange! Maximize your exposure with convenient access to the adjacent Highway 46 East and nearby Highway 101 with the Paso Robles Public Airport just a few miles down the road. Expansive surrounding area oak tree and mountain views from the property! Paved roads, City water, and all utilities available as soon as construction is complete in the next 60 days. Buy now and be ready to build your new building soon! <br /> <br /> A preferred location for local wine production, storage, and shipping for the adjacent neighbors such as the newest 110,000sf JUSTIN Wine Facility and the showcase Riboli-San Antonio Winery production facility & event center. Also, home to international top high tech software companies such as DELMIAwork, a global ERP software company. Location, Lifestyle, Access, and Convenience is the key for potential owners not to mention spectacular surrounding area views! <br /> <br /> C-3 Zoning offers business location opportunities for Hotels, Motels, Wineries, Car Dealerships, Food & Beverage Sales, Gyms, General Merchandise, Financial Businesses, Service Stations, Contract Serices, Grocery stores, Medical offices, Professional offices, Manufacturing, Personal service and so much more! (All desired uses can be verified with the City of Paso Robles.) This parcel would be an excellent investment property due to location!<br /> <br /> Premier location! Unlimited uses! First time on the market! Catch your opportunity NOW! Three parcels available ranging from 2.20+/-acres to 4.72+/- acres. This is Lot 3 of Tract Map 3069. Additional fourth parcel available for Planned Industrial uses at 3.46+/- acres. <br /> <br /> THIS IS PASO ROBLES! LOCATION! OPPORTUNITY! PATH OF GROWTH!
MlsNumber: --
ListingId: NS23168912


Listing Provided By: Country Real Estate, Inc., original listing
Phone: (805) 239-9566
Office Phone: (805) 239-9566
Agent Name: Gwen Erskine
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. 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