Beautiful Home in Northwest Fresno2468 SF Living Space on a 6500 SF Spacious LotLocated 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.
For sale
Price cut: $5K (11/1)
$515,000
4712 W Celeste Ave, Fresno, CA 93722
4beds
3baths
2,468sqft
Est.:
Residential, Single Family Residence
Built in 2005
6,499.15 Square Feet Lot
$514,900 Zestimate®
$209/sqft
$-- HOA
What's special
Rv parkingDual-sided fireplaceSpacious lotPrivate downstairs mother-in-law suiteLarge backyardLuxurious master suitePlenty of storage
- 98 days |
- 317 |
- 11 |
Zillow last checked: 8 hours ago
Listing updated: November 01, 2025 at 12:08am
Listed by:
Khushvinder Kaur DRE #01949837 559-385-5427,
RE/MAX Gold,
Taj Randhawa DRE #01495361 559-394-9000,
RE/MAX Gold
Source: Fresno MLS,MLS#: 636696Originating MLS: Fresno MLS
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
Primary bedroom
- Area: 0
- Dimensions: 0 x 0
Bedroom 1
- Area: 0
- Dimensions: 0 x 0
Bedroom 2
- Area: 0
- Dimensions: 0 x 0
Bedroom 3
- Area: 0
- Dimensions: 0 x 0
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Dining room
- Area: 0
- Dimensions: 0 x 0
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Area: 0
- Dimensions: 0 x 0
Living room
- Area: 0
- Dimensions: 0 x 0
Basement
- Area: 0
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Laundry: Inside
Features
- Number of fireplaces: 1
Interior area
- Total structure area: 2,468
- Total interior livable area: 2,468 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
Lot
- Size: 6,499.15 Square Feet
- Features: Urban
Details
- Parcel number: 509320046
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Residential, Single Family Residence
Materials
- Wood Siding, Other
- Foundation: Concrete
- Roof: Composition
Condition
- Year built: 2005
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities
Community & HOA
Location
- Region: Fresno
Financial & listing details
- Price per square foot: $209/sqft
- Tax assessed value: $296,876
- Date on market: 9/7/2025
- Cumulative days on market: 59 days
- Listing agreement: Exclusive Right To Sell
- Total actual rent: 0
Estimated market value
$514,900
$489,000 - $541,000
$2,744/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 11/1/2025 | Price change | $515,000-1%$209/sqft |
Source: Fresno MLS #636696 Report a problem | ||
| 9/16/2025 | Price change | $520,000-2.8%$211/sqft |
Source: Fresno MLS #636696 Report a problem | ||
| 9/8/2025 | Listed for sale | $535,000+54.2%$217/sqft |
Source: Fresno MLS #636696 Report a problem | ||
| 7/16/2020 | Listing removed | $347,000$141/sqft |
Source: eXp Realty of California Inc #534970 Report a problem | ||
| 4/5/2020 | Price change | $347,000+2.1%$141/sqft |
Source: eXp Realty of California Inc #534970 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $296,876 +2% |
| 2024 | $3,780 +2.3% | $291,056 +2% |
| 2023 | $3,695 +1.6% | $285,350 +2% |
Find assessor info on the county website
BuyAbility℠ payment
Est. payment
$3,186/mo
Principal & interest
$2487
Property taxes
$519
Home insurance
$180
Climate risks
Neighborhood: Bullard
Nearby schools
GreatSchools rating
- 5/10Lawless Elementary SchoolGrades: K-6Distance: 0.8 mi
- 5/10Tenaya Middle SchoolGrades: 7-8Distance: 3.6 mi
- 6/10Bullard High SchoolGrades: 9-12Distance: 3.8 mi
Schools provided by the listing agent
- Elementary: Lawless
- Middle: Tenaya
- High: Bullard
Source: Fresno MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- Loading
- Loading
