Celebrating 10 years: fixed fees, full service, fast responses

Property search · The Consumer Protection Brokerage

Every listing shows your estimated rebate.

The green number on each home is what could come back to you: the buyer-broker fee (typically 2 to 3%) minus our flat $9,750. No other search shows you this, because no other brokerage gives it back.

Save
Ask
Tour
Hide
Share
$3,995,000
102 Days On Site

15516 N Friant Road
Friant, CA 93626

For Sale|Single Family Residence|Active
6
Beds
5
Total Baths
6,363
SqFt
$628
/SqFt
1997
Built
County:
Fresno
Listing courtesy of Do not Delet zzzSystem Default of London Properties LTD | Agent Phone:
Call Now: (408) 868-2620
Is this the listing for you? We can help make it yours.
(408) 868-2620
Save
Ask
Tour
Hide
Share

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$3,995,000
Days On Site 
102 Days
Bedrooms 
6
Inside Area (SqFt) 
6,363 sqft
Total Baths 
5
Full Baths 
N/A
Partial Baths 
N/A
Lot Size 
6.44 Acres
Year Built 
1997
MLS® Number 
226600780
Status 
Active
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
Appraiser
Friends & Family
Recent Activity
2 months agoListing updated with changes from the MLS®
3 months agoStatus changed to Active
3 months agoListing first seen on site
General Features
Acres 
6.44
Attached Garage 
Yes
Cross Street 
Friant/Willow
Garage 
Yes
Garage Spaces 
14
Green Energy Efficient 
Windows
Levels 
One
Parking 
Workshop in GarageGarage Door OpenerAttached
Property Sub Type 
Single Family Residence
Sewer 
Holding Tank
SqFt Total 
6363
Style 
Spanish
Water Source 
PrivateWell
Interior Features
Appliances 
Wine RefrigeratorMicrowaveDisposalDishwasher
Cooling 
Central Air
Fireplace 
Yes
Fireplace Features 
Insert
Fireplaces 
5
Flooring 
Tile
Heating 
Fireplace InsertCentral
Laundry Features 
Inside
Spa 
Yes
Bathroom 1 
Description - Shower Stall(s),Tub w/Shower Over
Dining Room 
Description - Formal Room
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
Stucco
Pool Features 
GuniteIn Ground
Roof 
Tile
Spa 
Yes
Community Features
Financing Terms Available 
ConventionalCash
MLS Area 
24000
School District 
Clovis Unified
Schools
School District
Clovis Unified
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Do not Delet zzzSystem Default of London Properties LTD | Agent Phone:



Listing information is provided by Participants of the San Francisco Association of Realtors MLS. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Copyright 2026, San Francisco Association of Realtors MLS.
Last checked: 2026-07-27 05:20 AM UTC

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

*Estimate only. Actual rebate may vary based on final price, lender requirements, MLS rules, and broker policies.

Found a home you love?

Schedule a free consultation to lock in your rebate before you offer.

Calls and texts are answered by Amy, our AI assistant, who can answer questions and help you book.