Title Page Background
DEBUG FN args: Array ( [0] => 185 [1] => [2] => [3] => agent ) BEFORE: Site: 185 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 185 Igate: njhud LocID: 185 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 185 AND i.igate IN ('cahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 185 [1] => [2] => [3] => lender ) BEFORE: Site: 185 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 185 Igate: njhud LocID: 185 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 185 AND i.igate IN ('cahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 185 [1] => [2] => [3] => other ) BEFORE: Site: 185 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 185 Igate: njhud LocID: 185 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 185 AND i.igate IN ('cahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

13320 Oakstream Road
Plymouth, CA 95669
Ed Perry with California Outdoor Properties, Inc - Vacaville, original listing - (707) 455-4444

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,600,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3950 Square Feet
Agency: California Outdoor Properties, Inc - Vacaville
Agency Phone: (707) 455-4444

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 48 acre(s)
Property Type: Residential-Other
Year Built: --
Notes: Welcome to this exquisite luxury vineyard estate, where the essence of California's finest grape varietals flourish, consistently earning multi-year awards for their excellence. Perched majestically, this estate offers breathtaking views of the picturesque Shenandoah Valley vineyards, the majestic Sierras, and the sprawling Sacramento Valley.<br /> <br /> Step into the meticulously crafted 3950 square foot home, where every detail reflects elegance and comfort. With 4 bedrooms, 3 1/2 baths, and 4 fireplaces, this residence exudes warmth and sophistication. Entertain with style in the formal living and dining rooms, or retreat to the large wine cellar for intimate gatherings.<br /> <br /> This estate also includes additional expansion acreage, separate from the main residence, providing endless possibilities. Whether you envision a charming bed and breakfast, a captivating wedding venue, or a refined tasting room and processing facility, this property offers the perfect canvas for your dreams to flourish.<br /> <br /> Property Highlights:<br /> Luxury Estate Vineyard<br /> 48.79 beautifully manicured, fully fenced, acres<br /> 10 acres of multi-award winning, income producing grapes (3 Petit Syrah, 7 Syrah) on drip irrigation, with acres for expansion.<br /> Wired for backup generator<br /> Wrought Iron entry gate with security features<br /> 3950 sqft home with 3+ bedrooms and 2/1 bath<br /> Expansive kitchen w/granite counters and island; double ovens; microwave; 6 burner gas cooktop; warming oven; trash compactor<br /> 9x4 Walk-in Pantry<br /> Breakfast Nook with Bar seating<br /> Owner's Bathroom with large, jetted tub, walk-in shower, two-sided fireplace; oversized walk-in closet<br /> Living Room with 14-foot vaulted ceilings, french doors that lead to Veranda, with expansive views.<br /> 4 indoor fireplaces (Family Room, Living Room, Owner's Suite/Bath, and Office)<br /> Two heating/cooling systems<br /> Whole house fan<br /> Two 50gallon, high efficiency water heaters<br /> Home security system<br /> Wired speakers inside and outside<br /> ±2000 soft basement with enlarged, three car garage; 12x14 wine cellar; full bath; generous storage<br /> Covered Veranda approximately 500sqft<br /> Beautiful brick patios and walkways surrounding home with many rose varieties in bloom<br /> Water fountains in front and back of home<br /> Outdoor gas fire pit<br /> Rock walls around property approx. 4215 sqft built from rock collected off property<br /> Custom landscaping with hybrid tea roses garden and carpet roses abound<br /> Fruit trees: Apricots, Peaches, Apples, Figs, Cherries and Blueberry garden.<br /> 4 operational wells. Tested at 3GPM, 10GPM, 60GPM (20hp 10,000-gallon tank), and a 120GPM (30hp, with 5,000-gallon tank)<br /> 60x20 Equipment Shed<br /> Building Pad for possible shop with septic line and power nearby.<br /> 12 fenced acres across the road from main residence for possible tasting room/processing facility.
MlsNumber: --
ListingId: 224044301


Listing Provided By: California Outdoor Properties, Inc - Vacaville, original listing
Office Phone: (707) 455-4444
Agent Name: Ed Perry
Disclaimer: Copyright © 2024 LandLeader. 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