Off Market4180d on market
4788 W Celeste Ave
Fresno, CA, 93722 • Bullard • Fresno County
$516,400
$183/sqft
4Beds
3Baths
2,815Sqft
0.14 acLot
2005Built
Property DNA
Tile Floors
Quality flooring throughout
Market activity
Demand and pricing signals for this listing
1 views
People checking out this listing
4180 days on market
Established listing
$183/sqft
Price per square foot
About this home
Single Family · Built 2005
Beautiful 2 story, 4bd, 3ba home in great NW Fresno neighborhood.Formal living room, formal dining room,family room,with beautiful Fireplace. Master bedroom and huge guest room are downstairs, all other bedrooms are upstairs.kitchen has full granite countertop and middle Island. Built-in microwave, and Butlers pantry with glass cabinet doors to display your decor.Family room is huge and has double story high ceiling. Nook, Master bedroom and master bath has very high ceiling. Beautiful open Loft area upstairs with closet overlooking family room which can be a 5th bedroom. Front of the home has big covered porch, Backyard has large covered patio and large open patio.home has two car garage and downstairs laundry room.Central air & heating.All bedrooms,patio outside and all other rooms including kitchen has Fan. Total 10 fans in home.Kitchen,laundry room,bathrooms and entry foyer has tiles, all other arera has carpet.Master closet has entry to the huge attic area.
Estimated monthly payment
Based on current rates
$3,220/month
Principal & Interest$2,531
Property Tax$516
Insurance$172
Down payment20% ($103,280)
3%50%
Est. 6.20% rate · 30yr fixed · $413,120 loan
Full calculator →At a glance
Key facts and listing details
TypeSingleFamily
Year Built2005
HeatingForced air, Gas
CoolingRefrigerator, Central
Parking2 Parking spaces
Lot6,120 sqft
Property
Home typeSingle Family
Year built2005
Systems
HeatingForced air, Gas
CoolingRefrigerator, Central
Constructionwood frame
Parking & Outdoor
ParkingCarport, Garage - Attached
BasementNone
Lot6,120 sqft
Location & Tax
NeighborhoodBullard
Annual tax$4,878
Parcel50937006
Features & details
7 categories of property features
Interior Features
Appliances
Dishwasher
Dryer
Garbage disposal
Microwave
Range / Oven
Refrigerator
Washer
Flooring
Tile
Carpet
Heating
Forced air
Gas
Cooling
Refrigerator
Central
Exterior Features
Exterior
Shingle
Stucco
Parking
Carport
Garage - Attached
Construction
wood frame
Room details
8 rooms detailed
Walk In Closet
Breakfast Nook
Dining Room
Family Room
Laundry Room
Master Bath
Listing insights
Market data and value estimates
StatusOff Market
Days on market4180
Est. value$516,400
Est. rent$2,733/mo
Tax rate1.21%
Price/sqft$183
Last sold$290,000
Tour days6
Views1
How are the schools in Fresno?
3 schools rated nearby
Location
Fresno, CA, 93722
Price history
9 events
DateEventPrice$/sqftSource
Mar 24, 2021Listing Removed——Owner
Oct 27, 2014Sold$290,000$103Public Record
Dec 3, 2013Listing Removed$320,000$114Owner
Sep 5, 2013Listed For Sale$320,000$114Owner
Jun 19, 2013Listing Removed$2,500$1Owner
Apr 12, 2013Listed For Rent$2,500$1Owner
Feb 18, 2010Listing Removed$320,000$114Realty World Northern California Inc.
Jan 23, 2010Listed For Sale$320,000$114Realty World Northern California Inc.
Feb 15, 2005Sold$358,500$127Public Record
Listing Removed—
Mar 24, 2021•Owner
Sold$290,000
Oct 27, 2014•$103/sqft•Public Record
Listing Removed$320,000
Dec 3, 2013•$114/sqft•Owner
Listed For Sale$320,000
Sep 5, 2013•$114/sqft•Owner
Listing Removed$2,500
Jun 19, 2013•$1/sqft•Owner
Listed For Rent$2,500
Apr 12, 2013•$1/sqft•Owner
Listing Removed$320,000
Feb 18, 2010•$114/sqft•Realty World Northern California Inc.
Listed For Sale$320,000
Jan 23, 2010•$114/sqft•Realty World Northern California Inc.
Sold$358,500
Feb 15, 2005•$127/sqft•Public Record
Tax history
20 years of records
YearTax paidAssessed value
Apr 8, 2025$4,878$348,524
Apr 8, 2024$4,510$341,691
Apr 8, 2023$4,412$334,993
Apr 8, 2022$4,346$328,425
Apr 8, 2021$4,229$321,987
Apr 8, 2020$4,165$318,686
Apr 8, 2019$4,041$312,438
Apr 8, 2018$3,935$306,313
Apr 8, 2017$3,839$300,308
Apr 8, 2016$3,712$294,421
Apr 8, 2015$3,660$290,000
Apr 8, 2014$3,364$265,700
Apr 8, 2013—$229,100
Apr 8, 2012—$208,400
Apr 8, 2011—$219,500
Apr 8, 2010—$219,500
Apr 8, 2009—$219,500
Apr 8, 2008—$311,900
Apr 8, 2007—$372,463
Apr 8, 2006—$365,160
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