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 Nickel Creek Road
San Miguel, CA 93451
Dan Koosh with Real Estate eBroker, original listing - (760) 722-3222

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,495,000
Beds: --
Baths: --
Status: Active
SqFt: 500 Square Feet
Agency: Real Estate eBroker
Agency Phone: (760) 722-3222

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Commercial Sale-Other
Year Built: --
Notes: PRIVACY - VIEW!! -- Spectacular 80 acres view ranch in heart of Paso Robles wine country, one of the top Central Coast Wine regions! - Located in prestigious "Pleasant Valley Wine Trails", with view of iconic vineyard properties. Situated in the mecca of Ultra Premium wine producers with ideal limestone conditions. This South Facing 80 acres is 90% suitable for planting Premium Vines. (Buyer to check with SLO County for current ordinance.) - Water and Soil conditions are completely tested, suitable for planting premium wine grapes. - This property is what dreams are made of, with complete privacy, fabulous residential view sights with certificates of compliance granted. Uncluttered views of vineyard acreage, vistas, horses. Good water, and easy travel to town. Only five (5)miles from Paso Robles Regional Airport, and then a stone throw to town. There are few drives in the world that rival the pastoral ambiance here! The views from the 80 acres open out onto simply miles of vineyards and views to the city lights. World class, celebrity owned "Villa San Juliette Vineyard and Winery" is the neighbor to the south. - ALSO AVAILABLE FOR PURCHASE, the Adjacent 80 acres on Southern Boundary (APN -019-051-052) with 2 homes and 400 GPM Ag Well, 2 barns & some horse facilities. - A must see property to appreciate the value and characteristics! --- *** A CONCEPTUAL DESIGN is in process & available for both 80 acres combined. For an exclusive high-end Vineyard Resort, including Accommodations, Golf Course, Vineyard, Winery, Multiple Private Estate Residences & Vineyard Villas. ***
MlsNumber: --
ListingId: NS23190096


Listing Provided By: Real Estate eBroker, original listing
Phone: (760) 722-3222
Office Phone: (760) 722-3222
Agent Name: Dan Koosh
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