Beautiful Home in Northwest Fresno
2468 SF Living Space on a 6500 SF Spacious Lot
Located near The Marketplace, Hwy 99, and Herndon, this spacious 2-story home offers comfort, functionality, and room to grow.
✨ Features include:
4 Bedrooms, 3 Bathrooms – Multiple walk-in closets, plus a private downstairs mother-in-law suite with its own bath, shower, and direct backyard access.
Located near The Marketplace, Hwy 99, and Herndon, this spacious 2-story home offers comfort, functionality, and room to grow.
✨ Features include:
4 Bedrooms, 3 Bathrooms – Multiple walk-in closets, plus a private downstairs mother-in-law suite with its own bath, shower, and direct backyard access.
Open Living Spaces – A large living room, an isolated room with a dual-sided fireplace, and a bright, airy loft.
Chef’s Kitchen – Complete with a pantry, high ceilings, and two skylights that bring in natural light.
Luxurious Master Suite – Featuring an oval soaking tub and spacious layout.
Convenience – Indoor laundry room and plenty of storage throughout.
🌳 Outdoor Highlights:
Large backyard with extended concrete and a covered patio, perfect for entertaining.
Potential RV parking and space for a sparkling pool.
This home blends style and practicality with plenty of room for family and guests.
Property Details
Price:
$515,000
MLS #:
636696
Status:
Active
Beds:
4
Baths:
3
Type:
Single Family
Subtype:
Single Family Residence
Neighborhood:
722
Listed Date:
Sep 7, 2025
Finished Sq Ft:
2,468
Lot Size:
6,500 sqft / 0.15 acres (approx)
Year Built:
2005
See this Listing
Schools
School District:
Fresno Unified
Interior
Exterior
Financial
Map
Community
- Address4712 W Celeste Avenue Fresno CA
- CityFresno
- CountyFresno
- Zip Code93722
Market Summary
Current real estate data for Single Family in Fresno as of Apr 23, 2026
1,322
Single Family Listed
74
Avg DOM
267
Avg $ / SqFt
$522,334
Avg List Price
Property Summary
- 4712 W Celeste Avenue Fresno CA is a Single Family for sale in Fresno, CA, 93722. It is listed for $515,000 and features 4 beds, 3 baths, and has approximately 2,468 square feet of living space, and was originally constructed in 2005. The current price per square foot is $209. The average price per square foot for Single Family listings in Fresno is $267. The average listing price for Single Family in Fresno is $522,334.
Similar Listings Nearby

4712 W Celeste Avenue
Fresno, CA
