10
$379,900
3 bd · 1 ba · 1,146 sqft
4208 Esmail Ave, Keyes, CA
Demetrio Robles · Casa Robles R.E. Inc.
School ratings (A+ to F) from HJN community data.
Keyes Elementary School
KG-5 · Regular · Keyes Union Elementary School District
477 students · 20.7:1 student–teacher
Keyes to Learning Charter
KG-12 · Regular · Keyes Union Elementary School District
348 students · 27.8:1 student–teacher
Barbara Spratling Middle School
6-8 · Regular · Keyes Union Elementary School District
239 students · 21.0:1 student–teacher
Whitmore Charter School of Art & Technology
KG-8 · Regular · Ceres Unified School District
435 students · 19.6:1 student–teacher
Whitmore Charter High School
9-12 · Regular · Ceres Unified School District
96 students · 19.4:1 student–teacher
Ceres Christian Preschool
PK-TKG · Early Childhood Program/Child Care Center
42 students · 9.8:1 student–teacher
La Rosa Elementary School
KG-6 · Regular · Ceres Unified School District
516 students · 23.6:1 student–teacher
Hidahl Elementary School
KG-6 · Regular · Ceres Unified School District
393 students · 24.6:1 student–teacher
MetroListThis content last refreshed on 2026-10-10 14:14:41 UTC. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.

Within 2 miles of this home: 7 restaurants and cafés, 2 parks and green spaces, and 1 transit stop.
Place data from OpenStreetMap.
La Sonorense
Mexican restaurant · Martha Avenue
Carmelita's Taqueria
Mexican restaurant · Martha Avenue
Tacos El Granero #2
Mexican restaurant · 7th Street
Hidalguense 21-A
Mexican restaurant · 7th Street
Tacos El Wero
Mexican restaurant · Christine Avenue
El Hidalguense 21
Mexican restaurant · 7th Street
Grizzly Rock Cafe
Bonita Ranch
Hatch Park
Faith Home Rd & Hollywood Dr
Rings at ½ mile and 1 mile. Basemap © OpenMapTiles © OpenStreetMap contributors.
Open the Keyes camera map1 license-plate reader mapped within 1 mile of this home, identified as a Flock Safety device. None within ½ mile. Nearest: 0.7 mi southwest.
| Device type | Within ½ mi | Within 1 mi |
|---|---|---|
| License-plate readers | 0 | 1 |
| of which Flock Safety | 0 | 1 |
Community-reported via OpenStreetMap; may be incomplete. Data as of . © OpenStreetMap contributors (ODbL)
License-plate readers (ALPR) are fixed cameras that photograph passing vehicles and read their plates. Records are typically shared with the agency or association that operates the camera.
Flock Safety is a company whose plate-reader cameras are used by police departments, cities, HOAs and businesses. Its devices are usually solar-powered and pole-mounted.
Est. $3,119/mo$328/sqft · 52 days on Realty
3
Beds
2
Baths
1,418
Sqft
2026
Built
Come take a look at this stunning brand-new custom home located in the charming community of Keyes! Ideally situated between Ceres and Turlock, this beautiful home offers convenient access to Hwy 99 and is just minutes from shopping, restaurants, schools, medical facilities, parks, and Stanislaus State University. From the moment you arrive, you'll love the inviting curb appeal, fresh landscaping, and striking blue front door. Step inside to soaring 13' vaulted ceilings at the great room and 9'ceilings t/o, wide-plank luxury vinyl flooring, and a bright, open floor plan designed for comfortable everyday living and entertaining. The beautiful kitchen features white maple cabinetry, quartz countertops, brand-new stainless steel appliances, and a charming bay window in the dining nook overlooking the front yard. The spacious Great Room offers plenty of room for oversized furniture and entertainment, complemented by recessed lighting and an impressive oversized ceiling fan. Both secondary bedrooms are generously sized and share a hall bathroom featuring a shower over tub, single-sink vanity, and quartz countertop. The spacious primary suite offers another oversized ceiling fan, a large walk-in closet, and a private bathroom complete with a dual-sink vanity, quartz countertops, generous linen storage, and shower over tub. Additional features include a fire suppression system, which may provide insurance benefits depending on the carrier, plus a large backyard with an alley-access vehicle gate offering excellent potential for RV, boat, or recreational vehicle storage. Enjoy the benefits of a brand-new custom home with stylish finishes, a functional floor plan, and a convenient Central Valley location. Move-in ready and waiting for its first owner come take a look today!
Listing agent
Bethany J Mendoza
Courtesy of PMZ Real Estate
bethany@teamresultsinc.com
MetroList · Listing 226104815
$93,000
Estimated monthly payment
$3,119/mo
Loan amount $372,000. Estimate only — your actual rate and payment depend on credit, location, and lender.