Skip main navigation
For sale
  • Price cut: $250.5K (6/3)
    $5,774,000

    15516 N Friant Rd, Friant, CA 93626

    6beds
    6baths
    6,362sqft
    : 
    Residential, Single Family Residence
    Built in 1997
    6.44 Acres Lot
    $-- Zestimate®
    $908/sqft
    $-- HOA

    What's special

    Gas fireplaceOutdoor fireplaceTimeless finishesDog-friendly yardSubzero fridgeIn-ground jacuzziWolf range
    This extraordinary estate offers 360-degree views of Table Mountain, Sierra foothills, Friant Dam, & the San Joaquin Valley. A masterpiece of craftsmanship, it blends timeless finishes w/refined architectural detail. Saltillo tile flooring, hand-troweled walls, & soaring ceilings enhance the space. The living room features a gas fireplace, custom cabinetry, & double sliders opening to a resort-style pool. The formal dining rm has a built-in buffet & glass doors leading outside.The chef's kitchen boasts travertine counters, a Wolf range w/six burners, three ovens, a warming drawer, Subzero fridge, dual copper sinks, a mini wine fridge, ice maker, & two pantries. The primary suite offers a fireplace, sauna/steam shower, jetted tub, cedar-lined closets, & double sliders to the outdoors.A flexible living space serves as a soundproofed home theater/office/guest quarters w/courtyard access.A 1,600-bottle wine cellar w/a tasting area is accessible by elevator. The laundry room includes a Subzero fridge/freezer & a dog-friendly yard. The 3,000 sq. ft. garage holds up to 14 vehicles w/additional overhead parking. Amenities include tennis, pickleball, basketball, an in-ground jacuzzi, outdoor fireplace, BBQ, putting green, observation deck, & two independent guest homes w/a gym/shop. Secured by reinforced fencing, the estate also features owned solar, generators, a 5,000-gallon water tank, & a helipad. A rare retreat offering luxury, privacy, & premier amenities.
    149 days
    on Zillow
    |
    1,624
    |
    95
    |

    Zillow last checked: 7 hours ago

    Listing updated: June 05, 2025 at 10:33am

    Listed by:

    Sarah Hedrick DRE #01371742 559-681-2111,

    Realty Concepts, Ltd. - Fresno

    Source: Fresno MLS,MLS#: 626185Originating MLS: Fresno MLS
    Travel times

    Tour with a buyer's agent

    We'll find a local expert to take you on a private tour of 15516 N Friant Rd.

    Next available tour time:Today at 11am

    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: Other
    • Area: 0
    • Dimensions: 0 x 0
    Living room
    • Area: 0
    • Dimensions: 0 x 0
    Basement
    • Area: 0
    Heating
    • Ductless or Split
    Cooling
    • Central Air, Ductless or Split
    Appliances
    • Included: Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Refrigerator, Wine Refrigerator
    • Laundry: Inside, Utility Room
    Features
    • Isolated Bedroom, Isolated Bathroom, Built-in Features, Great Room, Office, Family Room, Den/Study, Game Room, Wine Room
    • Flooring: Tile
    • Windows: Double Pane Windows
    • Number of fireplaces: 5
    Interior area
    • Total structure area: 6,362
    • Total interior livable area: 6,362 sqft
    Video & virtual tour

    Property

    Parking
    • Total spaces: 14
    • Parking features: RV Access/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
    • Exterior features: Tennis Court(s)
    • Has private pool: Yes
    • Pool features: Private, In Ground
    • Spa features: Bath, In Ground
    • Fencing: Fenced
    • Has view: Yes
    • View description: Bluff View
    Lot
    • Size: 6.44 Acres
    • Dimensions: 320 x 988
    • Features: Rural, Pasture, Horses Allowed, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape, Garden, Drip System
    Details
    • Additional structures: Workshop, Shed(s)
    • Parcel number: 30031045S
    • Zoning: A1
    • Horses can be raised: Yes

    Construction

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

    Utilities & green energy

    • Electric: Electric Meter
    • Gas: Gas Meter
    • Sewer: Septic Tank
    • Water: Private
    • Utilities for property: Public Utilities, Propane

    Community & HOA

    Community
    • Security: Security System
    Location
    • Region: Friant

    Financial & listing details

    • Price per square foot: $908/sqft
    • Tax assessed value: $995,592
    • Annual tax amount: $11,623
    • Date on market: 3/13/2025
    • Listing agreement: Exclusive Right To Sell
    • Listing terms: Conventional,Cash,Owner May Carry
    • Total actual rent: 0
    • Loading
    • Loading