Skip main navigation
Accepting backups
  • Price cut: $200K (5/21)
    $1,800,000

    4748 W Alluvial Ave, Fresno, CA 93722

    5beds
    4baths
    4,000sqft
    : 
    $11,214/mo
    Get pre-qualified
    Residential, Single Family Residence
    Built in 2024
    0.91 Acres Lot
    $1,732,400 Zestimate®
    $450/sqft
    $-- HOA

    What's special

    Beautiful fireplaceOversized four-car garageExpansive backyardDedicated wine captainPrivate guest suiteOwned solarSweeping river views
    **Brand-New Custom Living Without the Wait, Without the Worry**Imagine moving into a stunning, brand-new custom home built by the renowned Image Homes no years of construction delays, no nail-biting budget surprises, and absolutely none of the headaches that come with remodeling an aging property. This is move-in-ready perfection, where every detail has already been meticulously crafted for you.Situated on an exceptionally rare and coveted bluff lot spanning nearly a full acre, this extraordinary residence delivers sweeping river views that most homeowners only dream about. Large bluff view lots of this caliber simply do not come along often this is a truly exclusive opportunity. The sheer scale of this property is remarkable approximately four thousand square feet of thoughtfully designed living space featuring five bedrooms and three and a half bathrooms, all wrapped in the quality construction that Image Homes is celebrated for.Step inside to discover a large formal living room anchored by a beautiful fireplace, setting the tone for elegant entertaining. The chef's kitchen is outfitted with premium Zephyr and KitchenAid appliances, a striking sixty-six-inch built-in refrigerator, and a dedicated wine captain for the connoisseur in you. A central vacuum system adds everyday convenience throughout.The private guest suite offers a welcoming retreat for visitors, while the fifth bedroom features charming French doors and flexes effortlessly as a home office or bonus room. An oversized four-car garage provides space for vehicles, hobbies, and storage without compromise.Outside, the expansive backyard is brimming with potential a blank canvas waiting for your dream outdoor oasis, all set against those breathtaking bluff views that make this lot so extraordinarily rare. Owned solar keeps energy costs in check, a forward-thinking feature already built into this impressive package.The neighborhood offers wonderful convenience with Koligian Park just a short stroll away and a nearby shopping center for everyday essentials striking that perfect balance between peaceful retreat and accessible living.Why endure the uncertainty and surprises of renovating someone else's vision? This is your chance to own a flawless, brand-new custom home ready for your life today. Schedule your private tour now.
    137 days
    |
    111
    |
    1
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Layla Granata DRE #02086336 559-776-8812,

    SME Real Estate,

    Nader A. Assemi DRE #01962277 559-705-2121,

    SME Real Estate

    Source: Fresno MLS,MLS#: 645803Originating MLS: Fresno MLS

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 5
      • Bathrooms: 4
      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, Tub
      Dining room
      • Area: 0
      • Dimensions: 0 x 0
      Family room
      • Area: 0
      • Dimensions: 0 x 0
      Kitchen
      • Features: Breakfast Bar, Pantry
      • 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, Gas Appliances, Disposal, Dishwasher, Microwave, Refrigerator, Wine Refrigerator
      • Laundry: Inside
      Features
      • Flooring: Tile
      • Number of fireplaces: 2
      Interior area
      • Total structure area: 4,000
      • Total interior livable area: 4,000 sqft

      Property

      Parking
      • Total spaces: 4
      • Parking features: Garage - Attached
      • Attached garage spaces: 4
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered, Concrete
      • Has view: Yes
      • View description: Bluff View
      Lot
      • Size: 0.91 Acres
      • Dimensions: 90 x 439
      • Features: Urban, Sprinklers In Front, Sprinklers Auto
      Details
      • Parcel number: 50232015
      • Zoning: RS3

      Construction

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

      Utilities & green energy

      • Electric: On
      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Public Utilities
      Green energy
      • Energy generation: Solar

      Community & HOA

      Location
      • Region: Fresno

      Financial & listing details

      • Price per square foot: $450/sqft
      • Tax assessed value: $1,651,560
      • Annual tax amount: $20,690
      • Date on market: 3/21/2026
      • Cumulative days on market: 137 days
      • Listing agreement: Exclusive Right To Sell

        Estimated market value

        $1,732,400

        $1.65M - $1.82M

        $4,500/mo

        Price history

        DateEventPrice
        7/1/2026Pending sale$1,800,000$450/sqft
        Source: Fresno MLS #645803 Report a problem
        5/21/2026Price change$1,800,000-10%$450/sqft
        Source: Fresno MLS #645803 Report a problem
        3/22/2026Listed for sale$1,999,950-4.8%$500/sqft
        Source: Fresno MLS #645803 Report a problem
        7/16/2025Listing removed$2,100,000$525/sqft
        Source: Fresno MLS #621549 Report a problem
        4/8/2025Price change$2,100,000-8.5%$525/sqft
        Source: Fresno MLS #621549 Report a problem
        11/16/2024Listed for sale$2,295,000$574/sqft
        Source: Fresno MLS #621549 Report a problem
        11/14/2024Listing removed$2,295,000$574/sqft
        Source: Fresno MLS #612490 Report a problem
        8/26/2024Price change$2,295,000-8%$574/sqft
        Source: Fresno MLS #612490 Report a problem
        5/15/2024Listed for sale$2,495,000+11.1%$624/sqft
        Source: Fresno MLS #612490 Report a problem
        10/3/2023Listing removed--
        Source: Owner Report a problem
        7/6/2023Price change$2,245,000+2%$561/sqft
        Source: Owner Report a problem
        7/4/2023Listed for sale$2,200,000+457%$550/sqft
        Source: Owner Report a problem
        8/18/2020Sold$395,000$99/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$20,690 +12%$1,651,560 +14.8%
        2024$18,466 +246.2%$1,439,177 +250.2%
        2023$5,333 +5.9%$410,958 +2%
        2022$5,036 -0.7%$402,900 +2%
        2021$5,074 +25.8%$395,000 +21.5%
        2020$4,034 +1.5%$325,007 +2%
        2019$3,974 +2.3%$318,635 +2%
        2018$3,884 -0.4%$312,388 +2%
        2017$3,899 +8.4%$306,263 +2%
        2016$3,598 +0.4%$300,258 +1.5%
        2015$3,583 -0.2%$295,748 +2%
        2014$3,588 $289,955 +0.5%
        2013-- $288,645 +2%
        2012-- $282,986 +2%
        2011-- $277,438 +0.8%
        2010-- $275,365 -0.2%
        2009-- $276,020 +2%
        2008-- $270,608 +2%
        2007-- $265,302 +2%
        2006-- $260,100
        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.

        Climate risks

        Neighborhood: Bullard

        Getting around

        37 / 100
        Car-Dependent
        24 / 100
        Minimal Transit
        45 / 100
        Somewhat Bikeable

        Nearby schools

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

        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