Please provide the following information and Edgar Gomez will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/16820/edgar-gomez/property/link/crmls/ML81963238/17997-Del-Puerto-Canyon-Rd/Patterson/https://www.londonproperties.com/images/props/crmls/full/ML81963238.jpgLondon Properties Patterson Real Estate | 17997 Del Puerto Canyon Rd
Listing Agent: Julie Baird, California Outdoor Properties, Inc.
NEW PRICE ALERT! The 38+/- acreage near Frank Raines Regional Park offers not only stunning sunrise and mountain views but also a range of amenities tailored for comfortable living. The 2006 manufactured home, customized for the owner, with large walk-in pantry, mudroom, and a kitchen with an island. Custom desk/hobby area off the living room. The versatility of the space is evident with one bedroom doubling as an office, complete with French doors and bunk beds for added utility. The main suite offers privacy with its own bath featuring a soaking tub and separate shower Outdoor living is enhanced with a large covered deck area and an enclosed swim spa room. The lower portion of the property features a spacious 30'X60' insulated shop. RV cover with solar hookups adds practicality for outdoor enthusiasts, although the RV itself is not included. Overall, this property seems to offer a blend of comfort, functionality, and natural beauty, making it an appealing retreat for anyone seeking a serene lifestyle close to nature. Williamson Act.
Property Sub Type
Single Family Residence
Year Built
2006
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Price Per Square Foot
$434
Days On Market
546
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
Cross Street: Highway 5
Architectural Style
Ranch
Heating
Central
Cooling
Evaporative Cooling
Roof
Composition, Metal
Construction Materials
Other
Foundation Details
Concrete Perimeter
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Room Kitchen Features
Kitchen Island
Appliances Y/N
Yes
Appliances
Dishwasher, Vented Exhaust Fan
Common Walls
No Common Walls
Fireplace Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Deck
Parking Y/N
Yes
Parking Total
8.00
Parking Features
Off Street
Attached Garage Y/N
No
Lot Features
Agricultural
Lot Size Area
1687514.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Hills, Mountain(s), Valley
Fencing
Partial
Parcel Number
025008047000
Zoning
A260
Association Y/N
No
High School District
Patterson Joint Unified
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 660250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 729750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1350 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1850 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` = 1588392)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsML81963238' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-25' 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.