Skip main navigation
For sale
    • $490,000

    654 W Celeste Ave, Fresno, CA 93704

    3beds
    3baths
    1,850sqft
    : 
    Loading
    Get pre-qualified
    Residential, Single Family Residence
    Built in 1963
    0.27 Acres Lot
    $482,500 Zestimate®
    $265/sqft
    $-- HOA

    What's special

    Swimming poolMature landscapingBackyard oasisCovered patioInviting kitchen
    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!
    22 days
    |
    3,415
    |
    223
    |

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Joseph Haydock DRE #02013076 559-392-5283,

    Haydock Real Estate, Inc.

    Source: Fresno MLS,MLS#: 650873Originating MLS: Fresno MLS

    Loading...

      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: $265/sqft
      • Tax assessed value: $345,245
      • Annual tax amount: $4,373
      • Date on market: 6/25/2026
      • Cumulative days on market: 22 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Government,Conventional,Cash

        Estimated market value

        $482,500

        $458,000 - $507,000

        $2,893/mo

        Price history

        DateEventPrice
        6/25/2026Listed for sale$490,000+58.3%$265/sqft
        Source: Fresno MLS #650873 Report a problem
        9/27/2018Sold$309,500-1.1%$167/sqft
        Source: Public Record Report a problem
        8/15/2018Price change$312,900-1.4%$169/sqft
        Source: Michael Dowdy Realty #506551 Report a problem
        8/6/2018Price change$317,500-0.8%$172/sqft
        Source: Michael Dowdy Realty #506551 Report a problem
        7/12/2018Price change$319,950+1.6%$173/sqft
        Source: Owner Report a problem
        6/18/2018Listed for sale$315,000+37%$170/sqft
        Source: Owner Report a problem
        5/27/2010Sold$230,000$124/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        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

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: Bullard

        Getting around

        55 / 100
        Somewhat Walkable
        30 / 100
        Some Transit
        44 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        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.

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts

        Similar homes

            • Local buyer's agents are ready to help

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Fresno Topics

                Search
                Updates
                Favorites
                Plan
                Inbox