Gorgeous - Gorgeous - Gorgeous! Great opportunity to purchase this 3,750 square foot home with fabulous curbview - along with beautiful built in pool (Pebble Sheen - Water Scuppers!!) 5 bedrooms 3 baths - close to Pitman High, Turlock Jr. High! Great access to shopping and freeway access on 99.
Single-familyProperty Type
2003Year Built
5,663 sq ftLot Size
$173Est. Price/Sq.Ft.
2 car garageParking
Listed by Pamela Easton•DRE #01228861• Century 21 MM
Bought with Fabio Garcia•DRE #01063767• Lombard Realty
*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
Beds
5
Baths
3
Stories
—
Lot width
—
Lot depth
—
Lot size
5,800 Sq. Ft.
Year renovated
—
Sq. Ft.
3,750
Year built
2003
Style
Single Family Residential
County
Stanislaus County
APN
087015023000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 13, 2026.
RL
Low Density Residential District
Provide appropriately located areas for single-family dwellings that are consistent with the General Plan and with standards of public health and safety established by the Turlock Municipal Code; Provide adequate light, air, privacy, and open space for each dwelling unit and protect residents from the harmful effects of excessive noise, population density, traffic congestion and other adverse environmental impacts; Achieve design compatibility through the use of site development standards.
Permitted uses
Include but are not limited to:
Housing-Group
Housing-Single unit
Housing-Other
Agriculture-Cropland
Property details
Parking
Parking & Garage Information
Garage Spaces: 2
Parking Features: Attached, Garage Door Opener, Garage Facing Front
Room Type: Baths Other, Family Room, Great Room, Loft, Master Bathroom, Master Bedroom, Downstairs Bedroom
Kitchen Features: Tile Counter, Island, Pantry Cabinet
Dining Room Features: Formal Area, Formal Room
Exterior
Exterior Features
Exterior Features: Dog Run, Uncovered Courtyard
Fencing: Back Yard
Allows Horses: No
Roof: Tile
Pool Information
Pool Features: Built-In, On Lot, See Remarks
Has Private Pool: Yes
Has Spa: No
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Subtype Description: Detached, Semi-Custom
Year Built: 2,003
Lot Information
Lot Features: Auto Sprinkler F&R, Low Maintenance, Shape Regular
Lot Size Square Feet: 5,663
Lot Size Acres: 0.13
Lot Size Dimensions: 100 x 58
Other Structures: Gazebo
Utilities
Utility Information
Utilities: Cable Available, Dish Antenna, Internet Available
Electric: 220 Volts, 220 Volts in Laundry
Sewer: In & Connected
Water Source: Meter on Site, Public
Location
HOA Information
Association YN: No
School Information
School District County: Stanislaus
Elementary School District: Turlock Unified
Middle Or Junior School District: Turlock Unified
High School District: Turlock Unified
Location Information
Postal Code Plus 4: 7386
Postal Code: 95382
County Or Parish: Stanislaus
CrossStreet: Paseo Entrada
Directions: W. Christofferson to Mt. View (north) to Sandstone (west) to Limestone (north). No viewings withOUT your REALTOR and prior appointment arranged!
State Or Province: CA
Street Number Numeric: 4023
Subdivision Name: Claremont Meadow #2
Unparsed Address: 4023 Limestone Rd, Turlock, CA 95382-7386
Street Address Filtered: 4023 Limestone Rd
Community Information
Senior Community YN: No
Public facts
Beds: 5
Baths: 3.0
Sq. Ft.: 3,750
Stories: —
Lot Size: 5,800 square feet
Style: Single Family Residential
Year Built: 2003
Year Renovated: —
County: Stanislaus County
APN: 087015023000
Home facts updated by county records on Jul 13, 2026
Other
Selling Agent
Buyer Agent Full Name: Fabio B Garcia
Around this home
Schools
Sandra Tovar Medeiros Elementary School
Public K-6 • Assigned • 1.5mi
7/10
Turlock Junior High School
Public 7-8 • Assigned • 0.9mi
5/10
John H. Pitman High School
Public 9-12 • Assigned • 0.3mi
7/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
33 unhealthy days expected this year, 35 days in 30 years
Provided by First Street
Historical weather
Turlock, CA • 95382
Average low and high temperatures (°F)
58
40
65
45
72
49
75
50
84
56
92
61
92
61
95
65
90
63
80
56
64
48
55
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13 hours in
June and 4.5 hours in December, placing it above the
U.S. average for solar exposure.
13 hrs
4.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$616,000 – $745,000
Sell confidently with a local market expert in Turlock. 3 minutes to get started.