Skip main navigation
For sale
    • $515,000

    4712 W Celeste Ave, Fresno, CA 93722

    4beds
    3baths
    2,468sqft
    : 
    Loading
    Get pre-qualified
    Residential, Single Family Residence
    Built in 2005
    6,499 Square Feet Lot
    $511,400 Zestimate®
    $209/sqft
    $-- HOA

    What's special

    Don't miss this spacious two-story Cambridge home offering 2,468 sq. ft. of comfortable living space! Featuring 4 bedrooms, 3 full bathrooms, a dedicated office, an upstairs loft, and a 2-car garage, this home provides a flexible layout perfect for growing families or those who work from home.The open kitchen is equipped with gas appliances, tile countertops, and ample cabinet space, flowing into both the inviting family room and separate living roomideal for everyday living and entertaining. The generous backyard offers ample concrete patio space for outdoor furniture, gatherings, and potential RV parking.With a little TLC, this home has incredible potential to truly shine. Conveniently located in a desirable Fresno neighborhood close to schools, parks, shopping, and everyday amenities, this is an excellent opportunity to add your personal touch and build instant equity.Come see the possibilitiesschedule your private showing today!
    10 days
    |
    115
    |
    1
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Mona Fnu Meenakshi DRE #02097374 209-817-7693,

    Realty One Group Action

    Source: Fresno MLS,MLS#: 651984Originating 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
      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
      • Number of fireplaces: 1
      • Fireplace features: Gas
      Interior area
      • Total structure area: 2,468
      • Total interior livable area: 2,468 sqft

      Property

      Parking
      • Total spaces: 2
      • Parking features: Garage - Attached
      • Attached garage spaces: 2
      Features
      • Levels: Two
      • Stories: 2
      Lot
      • Size: 6,499 Square Feet
      • Dimensions: 65 x 100
      • Features: Urban
      Details
      • Parcel number: 50932046
      • Zoning: RS5

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Residential, Single Family Residence
      Materials
      • Stucco
      • Foundation: Concrete
      • Roof: Composition
      Condition
      • Year built: 2005

      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: $209/sqft
      • Tax assessed value: $296,876
      • Annual tax amount: $4,121
      • Date on market: 7/10/2026
      • Cumulative days on market: 10 days
      • Listing agreement: Exclusive Right To Sell

        Estimated market value

        $511,400

        $486,000 - $537,000

        $2,714/mo

        Price history

        DateEventPrice
        7/13/2026Listed for sale$515,000+3.2%$209/sqft
        Source: Fresno MLS #651984 Report a problem
        5/19/2026Listing removed$499,000$202/sqft
        Source: Fresno MLS #648138 Report a problem
        5/2/2026Price change$499,000-3.1%$202/sqft
        Source: Fresno MLS #648138 Report a problem
        11/1/2025Price change$515,000-1%$209/sqft
        Source: Fresno MLS #636696 Report a problem
        9/16/2025Price change$520,000-2.8%$211/sqft
        Source: Fresno MLS #636696 Report a problem
        9/8/2025Listed for sale$535,000+54.2%$217/sqft
        Source: Fresno MLS #636696 Report a problem
        7/16/2020Listing removed$347,000$141/sqft
        Source: eXp Realty of California Inc #534970 Report a problem
        4/5/2020Price change$347,000+2.1%$141/sqft
        Source: eXp Realty of California Inc #534970 Report a problem
        12/6/2019Price change$340,000-1.4%$138/sqft
        Source: Movoto Inc #532814 Report a problem
        10/29/2019Listed for sale$345,000+1.5%$140/sqft
        Source: Movoto Inc #532814 Report a problem
        8/5/2019Listing removed$339,900$138/sqft
        Source: CENTURY 21 C. Watson #526676 Report a problem
        7/12/2019Price change$339,900+0.3%$138/sqft
        Source: CENTURY 21 C. Watson #526676 Report a problem
        5/21/2019Price change$339,000-1.7%$137/sqft
        Source: Opulent Realty & Financial #521197 Report a problem
        4/12/2019Listed for sale$344,900-1.2%$140/sqft
        Source: Opulent Realty & Financial #521197 Report a problem
        3/1/2019Listing removed$349,000$141/sqft
        Source: CENTURY 21 C. Watson #514801 Report a problem
        12/12/2018Price change$349,000+1.2%$141/sqft
        Source: CENTURY 21 C. Watson #514801 Report a problem
        8/29/2018Listed for sale$344,900+19.3%$140/sqft
        Source: RE/MAX Gold #509320 Report a problem
        7/13/2015Listing removed$289,000$117/sqft
        Source: Century 21 C Watson #441049 Report a problem
        3/12/2015Listed for sale$289,000+17.5%$117/sqft
        Source: Century 21 C. Watson #441049 Report a problem
        7/3/2010Listing removed$246,000$100/sqft
        Source: foreclosure.com Report a problem
        5/21/2010Listed for sale$246,000-16.6%$100/sqft
        Source: foreclosure.com Report a problem
        5/10/2010Sold$295,093-14.3%$120/sqft
        Source: Public Record Report a problem
        5/20/2005Sold$344,500$140/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$4,121 +9%$296,876 +2%
        2024$3,780 +2.3%$291,056 +2%
        2023$3,695 +1.6%$285,350 +2%
        2022$3,636 +2.8%$279,756 +2%
        2021$3,537 +1.8%$274,271 +1%
        2020$3,475 +2.9%$271,459 +2%
        2019$3,376 +2.8%$266,137 +2%
        2018$3,283 +2.7%$260,920 +2%
        2017$3,197 +3.5%$255,805 +2%
        2016$3,089 +1.4%$250,791 +1.5%
        2015$3,046 +1.9%$247,025 +2%
        2014$2,989 $242,187 +6.4%
        2013-- $227,600 +10%
        2012-- $207,000 -10.7%
        2011-- $231,731 +17.6%
        2010-- $197,100
        2009-- $197,100 -29.6%
        2008-- $280,000 -21.8%
        2007-- $357,897 +2%
        2006-- $350,880
        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

        42 / 100
        Car-Dependent
        28 / 100
        Some Transit
        51 / 100
        Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: River Bluff
        • Middle: Rio Vista
        • High: Central

        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