Skip main navigation
Pending
    • $484,900

    645 W Celeste Ave, Fresno, CA 93704

    4beds
    3baths
    2,174sqft
    : 
    Loading
    Get pre-qualified
    Residential, Single Family Residence
    Built in 1963
    0.3 Acres Lot
    $484,700 Zestimate®
    $223/sqft
    $-- HOA

    What's special

    Exceptional lot sizeGenerous floor planClassic architectural character
    Discover the opportunity to create something truly special at 645 W Celeste Avenue in one of Fresno's most desirable established neighborhoods off Palm Avenue and Bullard Avenue. This spacious 4-bedroom, 2.5-bath Mid-Century Ranch offers 2,174 square feet of living space on an impressive 13,132 square foot lotproviding the kind of outdoor space that's increasingly difficult to find in newer homes today.Whether you're dreaming of designing the ultimate Mid-Century Modern showpiece or simply looking for a home with room to grow, this property offers endless possibilities. The oversized lot provides ample space for entertaining, gardening, future enhancements, and even potential boat or small RV parking.This incredible home offers convenient access to shopping, dining, and entertainment at both River Park and Campus Pointe at Fresno State. With its classic architectural character, generous floor plan, and exceptional lot size, this is a rare opportunity for buyers to personalize a home while building equity in a highly sought-after location. Bring your vision and unlock the incredible potential this property has to offer.
    33 days
    |
    1,174
    |
    55
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    David Todd Mitchell DRE #01948429 559-281-6493,

    Gate12 Real Estate,

    Lydia Mitchell DRE #01902398 559-272-9193,

    Gate12 Real Estate

    Source: Fresno MLS,MLS#: 650376Originating MLS: Fresno MLS

      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
      Bathroom
      • Features: Tub/Shower, Shower
      Dining room
      • Area: 0
      • Dimensions: 0 x 0
      Family room
      • Area: 0
      • Dimensions: 0 x 0
      Kitchen
      • Features: Eat-in 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
      • Included: Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave
      • Laundry: Inside
      Features
      • Flooring: Carpet, Vinyl
      • Windows: Double Pane Windows
      • Number of fireplaces: 1
      • Fireplace features: Masonry
      Interior area
      • Total structure area: 2,174
      • Total interior livable area: 2,174 sqft

      Property

      Parking
      • Total spaces: 2
      • Parking features: Potential RV Parking
      • Attached garage spaces: 2
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered, Screened
      Lot
      • Size: 0.3 Acres
      • Dimensions: 98 x 134
      • Features: Urban, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto
      Details
      • Parcel number: 41615303
      • Zoning: RA

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Ranch
      • Property subtype: Residential, Single Family Residence
      Materials
      • Stucco
      • 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: $223/sqft
      • Tax assessed value: $227,290
      • Annual tax amount: $2,800
      • Date on market: 6/12/2026
      • Cumulative days on market: 20 days
      • Listing agreement: Exclusive Right To Sell

        Estimated market value

        $484,700

        $460,000 - $509,000

        $2,892/mo

        Price history

        DateEventPrice
        7/5/2026Pending sale$484,900$223/sqft
        Source: Fresno MLS #650376 Report a problem
        7/1/2026Listed for sale$484,900$223/sqft
        Source: Fresno MLS #650376 Report a problem
        6/17/2026Pending sale$484,900$223/sqft
        Source: Fresno MLS #650376 Report a problem
        6/12/2026Listed for sale$484,900+234.4%$223/sqft
        Source: Fresno MLS #650376 Report a problem
        8/28/1998Sold$145,000$67/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$2,800 +4.1%$227,290 +2%
        2024$2,690 +2%$222,835 +2%
        2023$2,637 +1.4%$218,467 +2%
        2022$2,600 +2.9%$214,184 +2%
        2021$2,527 +0.5%$209,985 +1%
        2020$2,515 +4.1%$207,833 +2%
        2019$2,416 +2.3%$203,759 +2%
        2018$2,362 +1.8%$199,764 +2%
        2017$2,320 +3.5%$195,848 +2%
        2016$2,241 +1.6%$192,009 +1.5%
        2015$2,205 +2.1%$189,126 +2%
        2014$2,161 $185,422 +0.5%
        2013-- $184,585 +2%
        2012-- $180,966 +2%
        2011-- $177,419 +0.8%
        2010-- $176,094 -0.2%
        2009-- $176,514 +2%
        2008-- $173,054 +2%
        2007-- $169,662 +2%
        2006-- $166,336 +2%
        2005-- $163,076 +2%
        2004-- $159,879 +1.9%
        2003-- $156,950 +2%
        2002-- $153,873 +2%
        2001$1,698 $150,857
        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

        53 / 100
        Somewhat Walkable
        32 / 100
        Some Transit
        45 / 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

          1. Local buyer's agents are ready to help

            Nearby cities

            Nearby neighborhoods

            Nearby zip codes

            Other Fresno Topics

              Search
              Updates
              Favorites
              Plan
              Inbox