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;

1 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: $2,895,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Real Estate eBroker
Agency Phone: (760) 722-3222

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 140 acre(s)
Property Type: Land-Other
Year Built: --
Notes: EXCEPTIONAL - Prime 140 acres Ranch in heart of Paso Robles AVA. Panoramic view of city lights and iconic vineyard properties. Situated in the mecca of Ultra Premium wine producers with ideal limestone conditions. Water & Soil conditions are completely tested and engineered. Newly AG Well (400 GPM) already in place with PG & E main power lines on the property. - This South Facing 140 acres is 90% suitable for planting premium vines.(Buyer to check with SLO County for current ordinance.) This ranch is what dreams are made of. Fabulous residential view sights, certificates of compliance granted. Uncluttered views of vineyard acreage, horses and good water. 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 140 acres open out onto simply miles of vineyards and views to the city lights. Neighboring to the South is the Celebrity Owned, prestigious-World class 'Villa San Juliette' Vineyard and Winery! - This property is consists of 2-Legal Parcels (APN: 019-051-051 & 019-051-052) - (SALE SUBJECT TO LOT LINE ADJUSTMENT ON PARCEL 019-051052) - Also available for purchase, the entire ranch for 160 acres (80+80), sold together or separate, including 2-homes, 2 barns and some horse facilities. - Come and visit this awesome ranch. A must see property to see the difference!<br /> *** A CONCEPTUAL DESIGN is in process & available for entire ranch, (80 + 80) acres combined. For an exclusive high-end Vineyard Resort, <br /> including Accommodations, Golf Course, Vineyard, Winery, including Multiple Private Estate Residences & Vineyard Villas.***
MlsNumber: --
ListingId: NS24147278


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