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

3470 Ranchita Cyn Rd
San Miguel, CA 93451

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,495,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2600
Agency: Real Estate eBroker Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 6,969,600 sqft
Property Type: Residential
Year Built: 1935
Notes: NICKEL CREEK RANCH, A spectacular 160 Acres Prime View Ranch in heart of Paso Robles Wine Country, one of the top Central Coast wine regions in California. If you are looking for privacy and tranquility, look no more!...This could be your dream ranch / future vineyard! - Located in prestigious "Pleasant Valley Wine Trails". Overlooking at vista of iconic Vineyards & Wineries - This unique ranch presents the opportunity for planting 140 acres of Premium Vines. (Buyer to check with SLO County for current ordinance) - Excellent Soil & Water, including Ag Well (400 GPM) - 2 Quaint Homes 3 bed + 3 Bath, combined 2600 sqft, (Both Homes are 100% Remodeled), 2 barns and multiple corrals for horses / livestock and, a seasonal creek too!! - The vast frontage on Ranchita Canyon Road have great exposure and is suitable for Winery & Tasting Room. Panoramic vistas, rolling hills, South Facing with view of city lights! - Soil & water is completely engineered, tested, suitable for Premium Vines. Property has 3 wells. (Two Domestics, One Ag Well) - This ranch is only 5 miles distance 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 large guest house is suitable and could be used as a Unique Tasting Room with road front visibility. Neighbor to the South is the Celebrity Owned, prestigious-World class "Villa San Juliette Vineyard & Winery". - A CONCEPTUAL DESIGN is in process, available for an exclusive high-end Vineyard Resort, including Accommodations, Golf Course, Vineyard, Winery. Including Multiple Private Estate Residences & Vineyard Villas. This property is consists of 2 legal parcels 80+80 acres, sold together or separate. (2-Certificate of Compliance granted) - A must see property to appreciate the value & the characteristics!
MlsNumber: NS24095554


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