This is your invitation to a life of comfort and peace in the heart of Fresno's cherished Browning Heights Neighborhood. Your love for this charming home will grow from the moment you step through the dramatic double entry front doors until you reach the backyard oasis, complete with a covered patio and a swimming pool that beckons you to cool off on a hot summer day. The details matter: the mature landscaping, the abundance of natural light throughout the home, the dramatic curved stone fireplace with a gas insert, the inviting kitchen, the indoor laundry room with its own half-bathroom, and the large primary bedroom with a walk-in closet that will make you swoon! Two refrigerators and the washer and dryer are included in this sale, with no value and without warranty. This home is conveniently located near schools (Bullard High School, Baird Middle School, St. Anthony's, Tenaya Middle School, Kratt Elementary), beloved restaurants (Max's Bistro, Mama Mia Pizzeria, Elbow Room), and shopping (Fig Garden Village, Save Mart, Food Maxx, Target). Come see for 654 W Celeste Avenue for yourself and prepare to live your best life in this neighborhood that is one of Fresno's hidden gems!
Sold for $485,000
Zestimate®
$485,000
654 W Celeste Ave, Fresno, CA 93704
3beds
3baths
1,850sqft
Residential, Single Family Residence
Built in 1963
0.27 Acres Lot
$485,000 Zestimate®
$262/sqft
$3,100 Estimated rent
Home value
$485,000
$446,000 - $529,000
$3,100/mo
Zestimate® history
Owner options
List your home for rent
$3,100/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,100/mo
Rent Zestimate®
Refinance and save
$3,146/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,146/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Swimming poolMature landscapingBackyard oasisCovered patioInviting kitchen
Zillow last checked:
Listing updated:
Listed by:
Joseph Haydock DRE #02013076 559-392-5283,
Haydock Real Estate, Inc.
Bought with:
Melissa F. Blake, DRE #02017316
Realty Concepts, Ltd. - Fresno
Source: Fresno MLS,MLS#: 650873Originating MLS: Fresno MLS
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- 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
- Flooring: Carpet, Laminate
- Number of fireplaces: 1
- Fireplace features: Gas
Interior area
- Total structure area: 1,850
- Total interior livable area: 1,850 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered, Concrete
- Has private pool: Yes
- Pool features: Fenced, Private, In Ground
- Fencing: Fenced
Lot
- Size: 0.27 Acres
- Dimensions: 89 x 130
- Features: Urban, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape
Details
- Parcel number: 41609027
- Zoning: R1C
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Residential, Single Family Residence
Materials
- Stucco, Brick
- Foundation: Wood Subfloor
- Roof: Composition
Condition
- Year built: 1963
Utilities & green energy
- Electric: On
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities
Community & HOA
Location
- Region: Fresno
Financial & listing details
- Price per square foot: $262/sqft
- Tax assessed value: $352,149
- Date on market: 6/25/2026
- Cumulative days on market: 23 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Government,Conventional,Cash
Price history
| Date | Event | Price |
|---|---|---|
| 8/17/2026 | Sold | $485,000-1%$262/sqft |
Source: Fresno MLS #650873 Report a problem | ||
| 7/18/2026 | Pending sale | $490,000$265/sqft |
Source: Fresno MLS #650873 Report a problem | ||
| 6/25/2026 | Listed for sale | $490,000+58.3%$265/sqft |
Source: Fresno MLS #650873 Report a problem | ||
| 9/27/2018 | Sold | $309,500-1.1%$167/sqft |
Source: Public Record Report a problem | ||
| 8/15/2018 | Price change | $312,900-1.4%$169/sqft |
Source: Michael Dowdy Realty #506551 Report a problem | ||
| 8/6/2018 | Price change | $317,500-0.8%$172/sqft |
Source: Michael Dowdy Realty #506551 Report a problem | ||
| 7/12/2018 | Price change | $319,950+1.6%$173/sqft |
Source: Owner Report a problem | ||
| 6/18/2018 | Listed for sale | $315,000+37%$170/sqft |
Source: Owner Report a problem | ||
| 5/27/2010 | Sold | $230,000$124/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | -- | $352,149 +2% |
| 2025 | $4,373 +4% | $345,245 +2% |
| 2024 | $4,204 +1.9% | $338,477 +2% |
| 2023 | $4,124 +1.4% | $331,842 +2% |
| 2022 | $4,068 +2.8% | $325,337 +2% |
| 2021 | $3,955 +0.4% | $318,959 +1% |
| 2020 | $3,939 +4.1% | $315,690 +2% |
| 2019 | $3,785 +22% | $309,500 +18.6% |
| 2018 | $3,103 +2.1% | $260,920 +2.3% |
| 2017 | $3,038 +4.9% | $255,000 +3.4% |
| 2016 | $2,896 +1.6% | $246,704 +1.5% |
| 2015 | $2,850 +6.9% | $243,000 +6.8% |
| 2014 | $2,666 | $227,600 |
| 2013 | -- | $227,600 +10% |
| 2012 | -- | $207,000 -10.7% |
| 2011 | -- | $231,731 +129.6% |
| 2010 | -- | $100,908 -0.2% |
| 2009 | -- | $101,149 +2% |
| 2008 | -- | $99,167 +2% |
| 2007 | -- | $97,223 +2% |
| 2006 | -- | $95,317 +2% |
| 2005 | -- | $93,449 +2% |
| 2004 | -- | $91,617 +1.9% |
| 2003 | -- | $89,939 +2% |
| 2002 | -- | $88,176 +2% |
| 2001 | $948 | $86,448 |
Find assessor info on the county website
Neighborhood: Bullard
Nearby homes
- $463,5003 bd2 ba2k sqft668 W Celeste Ave, Fresno, CA 93704Off Market
- $440,2004 bd2 ba2k sqft640 W Celeste Ave, Fresno, CA 93704Off Market
- $573,9004 bd3 ba2.7k sqft655 W Morris Ave, Fresno, CA 93704Off Market
- $468,0004 bd2 ba2.1k sqft667 W Morris Ave, Fresno, CA 93704Off Market
- $517,1003 bd1 ba2.1k sqft682 W Celeste Ave, Fresno, CA 93704Off Market
- $415,3003 bd1 ba1.8k sqft639 W Morris Ave, Fresno, CA 93704Off Market
- $484,9004 bd3 ba2.1k sqft645 W Celeste Ave, Fresno, CA 93704Sold
- $424,1003 bd2 ba2k sqft659 W Celeste Ave, Fresno, CA 93704Off Market
Nearby schools
GreatSchools rating
- 6/10Kratt Elementary SchoolGrades: K-6Distance: 0.7 mi
- 3/10Tenaya Middle SchoolGrades: 7-8Distance: 0.5 mi
- 6/10Bullard High SchoolGrades: 9-12Distance: 0.4 mi
Schools provided by the listing agent
- Elementary: Kratt
- 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.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$485,000
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$485,000
- California
- Fresno County
- Fresno
- 93704
- Bullard
- 654 W Celeste Ave
