For Sale212d on market
4712 W Celeste Ave
Fresno, CA, 93722 • Bullard • Fresno County
$515,000
$209/sqft
-$5,000 since Nov 1, 2025
Down payment assistance available
4Beds
3Baths
2,468Sqft
0.15 acLot
2005Built
Property DNA
1 Fireplace
Cozy heat source
This home is getting attention
Listed 212 days ago · 546 views · 13 saves
Market activity
Demand and pricing signals for this listing
546 views
People checking out this listing
13 saves
Buyers have saved this home
212 days on market
Established listing
$209/sqft
Price per square foot
About this home
Single Family · Built 2005
<div><div>Beautiful Home in Northwest Fresno</div><div> </div><div>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.</div><div> Open Living Spaces - A large living room, an isolated room with a dual-sided fireplace, and a bright, airy loft.</div><div> Chef's Kitchen - Complete with a pantry, high ceilings, and two skylights that bring in natural light.</div><div> Luxurious Master Suite - Featuring an oval soaking tub and spacious layout.</div><div> Convenience - Indoor laundry room and plenty of storage throughout. 🌳 Outdoor Highlights:</div><div> Large backyard with extended concrete and a covered patio, perfect for entertaining.</div><div> Potential RV parking and space for a sparkling pool. This home blends style and practicality with plenty of room for family and guests. </div></div>
Standout features identified
Our analysis highlights high ceilings, multiple walk-in closets, and indoor laundry room as key attractions of this home.
Estimated monthly payment
Based on current rates
$3,215/month
Principal & Interest$2,528
Property Tax$515
Insurance$172
Down payment20% ($103,000)
3%50%
Est. 6.22% rate · 30yr fixed · $412,000 loan
Full calculator →At a glance
Key facts and listing details
TypeResidential, Single Family Residence
Year Built2005
HeatingHas Heating (Unspecified Type)
CoolingCentral Air
Parking2 Attached Garage spaces
Lot6,499 sqft
Days on Zillow212 Days
Price/sqft$209
Property
Home typeSingle Family
Sub-typeResidential, Single Family Residence
Year built2005
Stories2
Systems
HeatingHas Heating (Unspecified Type)
CoolingCentral Air
RoofComposition
ConstructionWood Siding, Other
Water / SewerPublic / Public Sewer
Parking & Outdoor
ParkingGarage - Attached
Garage2 spaces
Fireplaces1
Lot6,499 sqft
Location & Tax
NeighborhoodBullard
Annual tax$4,121
Parcel50932046
Features & details
7 categories of property features
Interior Features
Heating
Has Heating (Unspecified Type)
Cooling
Central Air
Laundry
Inside
Exterior Features
Parking
Garage - Attached
Construction
Wood Siding
Other
Lot Features
Urban
Utilities
Public Utilities
Room details
10 rooms detailed
Master Bedroom
00
Bedroom1
00
Bedroom2
00
Bedroom3
00
Bedroom4
00
Dining Room
00
Listing insights
Market data and value estimates
StatusFor Sale
Days on market212
Est. value$513,600
Est. rent$3,057/mo
Tax rate1.21%
Price/sqft$209
On marketSep 7, 2025
PostedSep 7, 2025
Last sold$295,093
MLS updatedMar 29, 2026
Tour days9
Views546
Favorites13
How are the schools in Fresno?
3 schools rated nearby
Location
Fresno, CA, 93722
Price history
20 events
DateEventPrice$/sqftSource
Nov 1, 2025Price Change$515,000$209Fresno MLS
Sep 16, 2025Price Change$520,000$211Fresno MLS
Sep 8, 2025Listed For Sale$535,000$217Fresno MLS
Jul 16, 2020Listing Removed$347,000$141eXp Realty of California Inc
Apr 5, 2020Price Change$347,000$141eXp Realty of California Inc
Dec 6, 2019Price Change$340,000$138Movoto Inc
Oct 29, 2019Listed For Sale$345,000$140Movoto Inc
Aug 5, 2019Listing Removed$339,900$138CENTURY 21 C. Watson
Jul 12, 2019Price Change$339,900$138CENTURY 21 C. Watson
May 21, 2019Price Change$339,000$137Opulent Realty & Financial
Apr 12, 2019Listed For Sale$344,900$140Opulent Realty & Financial
Mar 1, 2019Listing Removed$349,000$141CENTURY 21 C. Watson
Dec 12, 2018Price Change$349,000$141CENTURY 21 C. Watson
Aug 29, 2018Listed For Sale$344,900$140RE/MAX Gold
Jul 13, 2015Listing Removed$289,000$117Century 21 C Watson
Mar 12, 2015Listed For Sale$289,000$117Century 21 C. Watson
Jul 3, 2010Listing Removed$246,000$100foreclosure.com
May 21, 2010Listed For Sale$246,000$100foreclosure.com
May 10, 2010Sold$295,093$120Public Record
May 20, 2005Sold$344,500$140Public Record
Price Change$515,000
Nov 1, 2025•$209/sqft•Fresno MLS
Price Change$520,000
Sep 16, 2025•$211/sqft•Fresno MLS
Listed For Sale$535,000
Sep 8, 2025•$217/sqft•Fresno MLS
Listing Removed$347,000
Jul 16, 2020•$141/sqft•eXp Realty of California Inc
Price Change$347,000
Apr 5, 2020•$141/sqft•eXp Realty of California Inc
Price Change$340,000
Dec 6, 2019•$138/sqft•Movoto Inc
Listed For Sale$345,000
Oct 29, 2019•$140/sqft•Movoto Inc
Listing Removed$339,900
Aug 5, 2019•$138/sqft•CENTURY 21 C. Watson
Price Change$339,900
Jul 12, 2019•$138/sqft•CENTURY 21 C. Watson
Price Change$339,000
May 21, 2019•$137/sqft•Opulent Realty & Financial
Listed For Sale$344,900
Apr 12, 2019•$140/sqft•Opulent Realty & Financial
Listing Removed$349,000
Mar 1, 2019•$141/sqft•CENTURY 21 C. Watson
Price Change$349,000
Dec 12, 2018•$141/sqft•CENTURY 21 C. Watson
Listed For Sale$344,900
Aug 29, 2018•$140/sqft•RE/MAX Gold
Listing Removed$289,000
Jul 13, 2015•$117/sqft•Century 21 C Watson
Listed For Sale$289,000
Mar 12, 2015•$117/sqft•Century 21 C. Watson
Listing Removed$246,000
Jul 3, 2010•$100/sqft•foreclosure.com
Listed For Sale$246,000
May 21, 2010•$100/sqft•foreclosure.com
Sold$295,093
May 10, 2010•$120/sqft•Public Record
Sold$344,500
May 20, 2005•$140/sqft•Public Record
Tax history
20 years of records
YearTax paidAssessed value
Apr 7, 2025$4,121$296,876
Apr 7, 2024$3,780$291,056
Apr 7, 2023$3,695$285,350
Apr 7, 2022$3,636$279,756
Apr 7, 2021$3,537$274,271
Apr 7, 2020$3,475$271,459
Apr 7, 2019$3,376$266,137
Apr 7, 2018$3,283$260,920
Apr 7, 2017$3,197$255,805
Apr 7, 2016$3,089$250,791
Apr 7, 2015$3,046$247,025
Apr 7, 2014$2,989$242,187
Apr 7, 2013—$227,600
Apr 7, 2012—$207,000
Apr 7, 2011—$231,731
Apr 7, 2010—$197,100
Apr 7, 2009—$197,100
Apr 7, 2008—$280,000
Apr 7, 2007—$357,897
Apr 7, 2006—$350,880
Nearby homes
Neighborhood details
Local context around this listing
Fresno, CA • Fresno County
Nearby neighborhoods
BullardCentralEdisonFresno High RoedingHooverMclaneRooseveltSoutheast Growth AreaWestWoodward Park
Nearby cities
ClovisCoalingaFirebaughFresnoKermanKingsburgParlierReedley
Nearby zip codes
93702937039370593706937109371193720937229372693727
Similar homes
No obligation · Same-day response