Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/crmls/41149570/17580-Wild-Oak-Dr/Jamestown/https://www.londonproperties.com/images/props/crmls/full/41149570.jpgLondon Properties Jamestown Real Estate | 17580 Wild Oak Dr
Rolling Hills Charmer! A welcoming front porch invites you into this light-filled, single-story home in Jamestown. Inside, an open floor plan and fireplace create an easy place to gather, while graceful arches add character to the formal dining room. With 3 bedrooms, 2.5 baths, and 1,775 square feet, there's room to make it your own. A fenced backyard, large driveway, and detached two-car garage add to the appeal. Bring your vision and choose the new carpet and paint that will make 17580 Wild Oak Dr feel like home.
Property Sub Type
Single Family Residence
Year Built
1999
Levels
One
Price Per Square Foot
$225
Days On London
0
Cumulative Days On London
3
County Or Parish
Tuolumne
New Construction Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Campo Seco.
Architectural Style
Contemporary
Heating
Forced Air
Cooling
Central Air
Roof
Shingle
Construction Materials
Wood Siding
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Eating Area
Breakfast Nook
Appliances Y/N
Yes
Flooring
Tile, Carpet, Laminate
Fireplace Y/N
Yes
Fireplace Features
Gas, Family Room
Pool Features
None
Pool Private Y/N
No
Patio Y/N
Yes
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Level with Street, Back Yard
Lot Size Area
7800.0000
Lot Size Units
Square Feet
Parcel Number
003350031000
Association Amenities
Other
Association Y/N
Yes
Association Fee
40.00
Association Fee Frequency
Monthly
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 379050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 418950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1525 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2025 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1781614 OR `props-main`.`id` = 1728856 OR `props-main`.`id` = 1776161 OR `props-main`.`id` = 1732335 OR `props-main`.`id` = 1729503 OR `props-main`.`id` = 1780473 OR `props-main`.`id` = 1739085 OR `props-main`.`id` = 1773787 OR `props-main`.`id` = 1783633 OR `props-main`.`id` = 1745673 OR `props-main`.`id` = 1747150 OR `props-main`.`id` = 1738743 OR `props-main`.`id` = 1760791 OR `props-main`.`id` = 1728062 OR `props-main`.`id` = 1760270 OR `props-main`.`id` = 1721983 OR `props-main`.`id` = 1779001 OR `props-main`.`id` = 1779594 OR `props-main`.`id` = 1728855 OR `props-main`.`id` = 1781543 OR `props-main`.`id` = 1763178 OR `props-main`.`id` = 1738332 OR `props-main`.`id` = 1766255 OR `props-main`.`id` = 1765361 OR `props-main`.`id` = 1765362 OR `props-main`.`id` = 1729214 OR `props-main`.`id` = 1736935 OR `props-main`.`id` = 1758814 OR `props-main`.`id` = 1736932 OR `props-main`.`id` = 1729169 OR `props-main`.`id` = 1737390 OR `props-main`.`id` = 1745730 OR `props-main`.`id` = 1755207 OR `props-main`.`id` = 1755812 OR `props-main`.`id` = 1766354 OR `props-main`.`id` = 1780597 OR `props-main`.`id` = 1757061 OR `props-main`.`id` = 1782524 OR `props-main`.`id` = 1736933 OR `props-main`.`id` = 1736886 OR `props-main`.`id` = 1771244 OR `props-main`.`id` = 1773146 OR `props-main`.`id` = 1758815 OR `props-main`.`id` = 1734590 OR `props-main`.`id` = 1758253 OR `props-main`.`id` = 1772016 OR `props-main`.`id` = 1768310)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls41149570' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-29' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
