Skip main navigation
For sale
    • Price cut: $505K (5/8)
    $3,995,000

    15516 N Friant Rd, Friant, CA 93626

    6beds
    6baths
    6,363sqft
    : 
    $26,435/mo
    Get pre-qualified
    Residential, Single Family Residence
    Built in 1997
    6.44 Acres Lot
    $3,647,200 Zestimate®
    $628/sqft
    $-- HOA

    What's special

    There are good homes, great homes, and then there's the extraordinary. Perched atop an elevated six-acre bluff, the home captures breathtaking 360-degree views---river, mountain, and valley vistas on one side, and sweeping pasture on the other. A living canvas that evolves with every hour. Spanning approx. 5,300sf, this expansive single-story features 4 bedrooms, 4 baths, plus two detached one-bedroom guest suites---ideal for multi-generational living or private accommodations. The primary suite is a true retreat with stunning views, a spa-inspired bath, spa tub, walk-in shower, dual vanities, and generous closets. Throughout the house, rich Saltillo tile and handcrafted woodwork create warmth and timeless character. The open layout flows between living room, oversized family room, and a chef's kitchen with a six-burner Wolf range, triple ovens, warming drawer, Sub-Zero refrigeration, freezer drawers, and dual copper sinks. Designed for both entertaining and everyday comfort, the home also includes a sunken sitting room, media room, and a large laundry room with additional Sub-Zero fridge. An elevator leads to a 3000sf 14-car underground garage and 1,600-bottle, temp.-controlled wine cellar with tasting area. Thoughtfully concealed, the garage maintains the estate's pristine aesthetic while offering seamless access. Resort-style grounds feature a pool, outdoor living spaces, built-in BBQ, lighted tennis court, sport court, putting green, and rooftop deck. A private helipad offers effortless access to business, entertainment, and nearby coastal and national park destinations. Bed, bath, and sq. ft is different than tax records, if important, buyer to verify.
    109 days
    |
    1,169
    |
    68
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Joe Sciarrone DRE #01509897 559-269-9413,

    London Properties, Ltd.

    Source: Fresno MLS,MLS#: 647302Originating MLS: Fresno MLS

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 6
      • Bathrooms: 6
      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
      • Features: Formal
      • Area: 0
      • Dimensions: 0 x 0
      Family room
      • Area: 0
      • Dimensions: 0 x 0
      Kitchen
      • Features: Pantry
      • Area: 0
      • Dimensions: 0 x 0
      Living room
      • Area: 0
      • Dimensions: 0 x 0
      Basement
      • Area: 3000
      Heating
      • Has Heating (Unspecified Type)
      Cooling
      • Central Air
      Appliances
      • Included: Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Refrigerator, Wine Refrigerator
      • Laundry: Inside, Utility Room
      Features
      • Isolated Bedroom, Isolated Bathroom, Built-in Features, Wine Room
      • Flooring: Tile
      • Windows: Double Pane Windows
      • Number of fireplaces: 5
      • Fireplace features: Masonry, Gas
      Interior area
      • Total structure area: 6,363
      • Total interior livable area: 6,363 sqft
      Video & virtual tour

      Property

      Parking
      • Total spaces: 14
      • Parking features: Potential RV Parking, Work/Shop Area, Garage Door Opener, Circular Driveway
      • Attached garage spaces: 14
      • Has uncovered spaces: Yes
      Features
      • Levels: One
      • Stories: 1
      • Patio & porch: Covered, Concrete
      • Exterior features: Tennis Court(s)
      • Has private pool: Yes
      • Pool features: Gunite, Private, In Ground
      • Has spa: Yes
      • Spa features: In Ground
      • Fencing: Cross Fenced,Fenced
      • Has view: Yes
      • View description: Bluff View
      Lot
      • Size: 6.44 Acres
      • Features: Urban, Pasture, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape
      Details
      • Additional structures: Workshop, Shed(s), Other, Accessory Dwelling Unit
      • Parcel number: 30031045S

      Construction

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

      Utilities & green energy

      • Electric: No Electric Meter, On
      • Gas: No Gas Meter
      • Sewer: Septic Tank
      • Water: Private
      • Utilities for property: Propane
      Green energy
      • Energy generation: Solar

      Community & HOA

      Community
      • Security: Security System, Security Gate
      Location
      • Region: Friant

      Financial & listing details

      • Price per square foot: $628/sqft
      • Tax assessed value: $1,015,503
      • Annual tax amount: $11,854
      • Date on market: 4/16/2026
      • Cumulative days on market: 427 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Government,Conventional,Cash

        Estimated market value

        $3,647,200

        $3.46M - $3.83M

        $6,413/mo

        Price history

        DateEventPrice
        5/8/2026Price change$3,995,000-11.2%$628/sqft
        Source: Fresno MLS #647302 Report a problem
        4/17/2026Listed for sale$4,500,000$707/sqft
        Source: Fresno MLS #647302 Report a problem
        3/13/2026Listing removed$4,500,000$707/sqft
        Source: Fresno MLS #639256 Report a problem
        10/31/2025Listed for sale$4,500,000-22.1%$707/sqft
        Source: Fresno MLS #639256 Report a problem
        9/14/2025Listing removed$5,774,000+11%$907/sqft
        Source: SDMLS #SC25061273 Report a problem
        8/19/2025Price change$5,200,000-9.9%$817/sqft
        Source: Fresno MLS #626185 Report a problem
        6/5/2025Price change$5,774,000-4.2%$907/sqft
        Source: Fresno MLS #626185 Report a problem
        3/14/2025Listed for sale$6,024,500$947/sqft
        Source: Fresno MLS #626185 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$11,854 +2%$1,015,503 +2%
        2024$11,623 +2%$995,592 +2%
        2023$11,399 +1.4%$976,072 +2%
        2022$11,245 +2.9%$956,934 +2%
        2021$10,927 +0.4%$938,172 +1%
        2020$10,884 +2%$928,553 +2%
        2019$10,670 +2.3%$910,347 +2%
        2018$10,434 +1.8%$892,498 +2%
        2017$10,253 +3.5%$874,999 +2%
        2016$9,902 +1.6%$857,843 +1.5%
        2015$9,749 +1.9%$844,958 +2%
        2014$9,566 $828,408 +0.5%
        2013-- $824,665 +2%
        2012-- $808,496 +2%
        2011-- $792,644 +14.1%
        2010-- $694,643 -0.2%
        2009-- $696,294 +5.8%
        2008-- $658,356 +2%
        2007-- $645,448 +2%
        2006-- $632,793 +2%
        2005-- $620,386 +2%
        2004-- $608,222 +1.9%
        2003-- $597,075 +2%
        2002-- $585,369 +2%
        2001$6,789 $573,892
        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: 93626

        Getting around

        0 / 100
        Car-Dependent
        9 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Liberty
        • Middle: Kastner
        • High: Clovis West

        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.

        Browse local experts

        Similar homes

            • Local buyer's agents are ready to help

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Friant Topics

                Search
                Updates
                Favorites
                Plan
                Inbox