Most desirable Atherton Plan 4 home with so many upgrades that it's better than new! In addition to a premium lot size and no rear neighbors, this beautiful home has been perfectly maintained by the original owners. This 5 bedroom floor plan comes with private in law quarters. This area of the house comes with its own bedroom/bathroom suite, attached to its own living room. This home has low maintenance landscpaing including a spa, RV access, 12x12 shed, and stunning gazebo. The backyard is also pre-wired and plumbed for you to put the finishing touches on an outdoor kitchen. The long list of upgrades include (but not limited to); oak floors, 220 in garage for EV, USB outlets in every room, double oven, fire sprinklers, alarm system/cameras, rain shower, and whole house fan. On top of all of that, the home comes equipped with OWNED SOLAR. Keep those energy costs low while you enjoy this home! Don't miss out and come see all this home has to offer!
Single-familyProperty Type
2017Year Built
9,187 sq ftLot Size
$304Est. Price/Sq.Ft.
2 car garageParking
Listed by Mike Piccirilli•DRE #02036346• RE/MAX Executive
Listed by Brandon Joaquin•DRE #01747005• RE/MAX Executive
Bought with Lonnie Terrell•DRE #02083023• GNN Real Estate
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Permits
Beds
5
Baths
4
Stories
1
Lot width
—
Lot depth
—
Lot size
9,186 Sq. Ft.
Year renovated
—
Sq. Ft.
3,052
Year built
2017
Style
Single Family Residential
County
San Joaquin County
APN
22638036
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 6, 2026.
R1
One-Family Dwelling District
This designation allows for substantial flexibility in selecting dwelling unit types and parcel configurations to suit site conditions and housing needs. The types of dwelling units include small lots and clustered lots as well as conventional large-lot detached residences.
Permitted uses
Include but are not limited to:
Livestock production
Garden center
Housing-Single unit
Housing-Senior
Housing-Other
Infrastructure
Educational/school
Communications tower
Park & open space
Oct 31, 2024 • Final
Solar
Install a roof-mounted solar system on a residential building. The project includes adding new panels to an existing system.
Electrical
Solar
Oct 31, 2024 • Final
Residential new construction or remodel or adu
Construct a new residential building.
New construction
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking & Garage Information
Garage Spaces: 2
Parking Features: Attached, Garage Door Opener, Garage Facing Front
Interior
Bathroom Information
# of Bathrooms (Full): 4
Other Bathroom Features: Double Sinks, Jetted Tub, Tub, Tub w/Shower Over, Marble
Bedroom Information
# of Bedrooms (Total): 5
# of Bedrooms (Possible): 6
Heating & Cooling
Cooling: Ceiling Fan(s), Central, Whole House Fan
Heating: Central
Interior Features
Appliances: Built-In Gas Range, Dishwasher, Microwave, Double Oven
Flooring: Carpet, Tile, Wood
Laundry Features: Cabinets, Sink, Inside Room
# of Stories: 1
Room Information
Living Room Features: Cathedral/Vaulted
Kitchen Features: Pantry Closet, Granite Counter, Island w/Sink, Kitchen/Family Combo
Dining Room Features: Space in Kitchen, Formal Area
Main Level: Bedroom(s), Living Room, Dining Room, Family Room, Master Bedroom, Full Bath(s), Garage, Kitchen
Exterior
Exterior Features
Allows Horses: No
Roof: Tile
Pool Information
Has Private Pool: No
Has Spa: Yes
Spa Features: Spa/Hot Tub Personal
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Subtype Description: Detached
Year Built: 2,017
Lot Information
Lot Features: Auto Sprinkler F&R, Low Maintenance
Lot Size Square Feet: 9,187
Lot Size Acres: 0.2109
Utilities
Utility Information
Utilities: Solar
Electric: 220 Volts in Laundry
Sewer: Public Sewer
Irrigation Source: Public District
Water Source: Public
Location
HOA Information
Association YN: No
School Information
School District County: San Joaquin
Elementary School District: Ripon Unified
Middle Or Junior School District: Ripon Unified
High School District: Ripon Unified
Location Information
Postal Code: 95337
County Or Parish: San Joaquin
CrossStreet: Mono
Directions: 120 Main St exit heading south. Left turn on Woodward. Right turn on Pillbury. Left turn on Mono. Stay right onto Freestone. Property on right side.
State Or Province: CA
Street Number Numeric: 1424
Unparsed Address: 1424 Freestone Rd, Manteca, CA 95337
Street Address Filtered: 1424 Freestone Rd
Community Information
Senior Community YN: No
Public facts
Beds: 5
Baths: 4.0
Sq. Ft.: 3,052
Stories: 1.0
Lot Size: 9,186 square feet
Style: Single Family Residential
Year Built: 2017
Year Renovated: —
County: San Joaquin County
APN: 22638036
Home facts updated by county records on Aug 6, 2026
Other
Selling Agent
Buyer Agent Full Name: Lonnie P Terrell
Around this home
Schools
Park View Elementary School
Public K-8 • Assigned • 3.4mi
10/10
Ripon High School
Public 9-12 • Assigned • 3.8mi
9/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
7/10 Heat Factor
7 days above 102° expected this year, 16 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
30 unhealthy days expected this year, 31 days in 30 years
Provided by First Street
Historical weather
Manteca, CA • 95337
Average low and high temperatures (°F)
59
40
64
45
72
50
73
50
82
56
89
59
90
60
93
63
89
61
79
56
64
47
55
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 12.8 hours in
June and 4.6 hours in December, placing it above the
U.S. average for solar exposure.
12.8 hrs
4.6 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$882,000 – $1.07M
Reach more buyers when you sell with Redfin. Save up to $9,281 in fees.3 minutes to get started.