Share This Listing

Message

961 characters remaining

Hmm, there seems to have been an error sending your message. Please try again.

Your email has been sent.

Still interested?

Contact the broker for more information about this property

15516 N Friant Rd 6,362 SF Specialty Building Offered at $7,189,000 CAD in Friant, CA 93626

Save this listing!

Favourite this listing to get notified of price updates, new media and more

INVESTMENT HIGHLIGHTS

  • Seize the chance to own a one-of-a-kind estate with panoramic views of Table Mountain, the Sierra Foothills, Friant Dam, and the San Joaquin Valley.
  • Impeccably designed with intricate details, like Saltillo tile flooring, hand-troweled walls, lofty ceilings, custom cabinetry, and picture windows.
  • Ample indoor and outdoor space to enjoy, the home features a chef's kitchen, home theater, resort-style pool, wine cellar, sports courts, and more.
  • Nearby Lost Lake Park, and a 20-minute drive to Fresno, Friant boasts a sought-after small-town feel with quick access to the bustle of the big city.
  • Surrounded by an affluent population of 61,613 households in a 10-mile radius, bringing in an average household income of $127,299.

EXECUTIVE SUMMARY

A masterpiece of craftsmanship, 15516 N Friant Road seamlessly blends timeless finishes with refined architectural details. This extraordinary estate offers 360-degree views of Table Mountain, the Sierra Foothills, Friant Dam, and the San Joaquin Valley.

Saltillo tile flooring, hand-troweled walls, and soaring ceilings enhance the ambiance of this stunning homestead. The living room features a gas fireplace, custom cabinetry, and double sliders opening to a resort-style pool. The formal dining room features a built-in buffet embellished with glass doors that lead outside. The chef's kitchen boasts travertine counters, a Wolf range with six burners, three ovens, a warming drawer, a Sub-Zero fridge, dual copper sinks, a mini wine fridge, an ice maker, and two pantries. The primary suite features a fireplace, sauna, steam shower, jetted tub, cedar-lined closets, and double sliders that open to the outdoors. A flexible living space serves as a soundproofed home theater, office, or guest quarters, with access to a courtyard. There is a 1,600-bottle wine cellar with a tasting area that is accessible by elevator. The laundry room houses a second Sub-Zero fridge and freezer, as well as a dog-friendly yard. The 3,000-square-foot garage accommodates up to 14 vehicles, with additional overhead parking available.

Outside the residence on the 7.25-acre lot, amenities include tennis, pickleball, and basketball courts, an in-ground jacuzzi, an outdoor fireplace, a BBQ, a putting green, and an observation deck. Additionally, there are two independent guest homes, each featuring a gym and workshop. Secured by reinforced fencing, the estate also features its own solar panels, generators, a 5,000-gallon water tank, and a helipad.

Nestled just 1.5 miles from Lost Lake Park, this property offers the perfect blend of tranquility and convenience. A short four-minute drive will take you into the charming town of Friant, located in California's Central Valley and in the scenic foothills of the Sierra Nevada, right at the base of Friant Dam and Millerton Lake. For those seeking more urban amenities, Fresno is just under 20 miles away, offering ample opportunities for shopping and dining. Experience a rare retreat that combines luxury, privacy, and premier amenities, all within proximity to outdoor adventures and conveniences at 15516 N Friant Road.

TAXES & OPERATING EXPENSES (ACTUAL - 2025) Click Here to Access

ANNUAL (CAD) ANNUAL PER SF (CAD)
Taxes - -
Operating Expenses - -

TAXES & OPERATING EXPENSES (ACTUAL - 2025) Click Here to Access

Taxes (CAD)
Annual -
Annual Per SF -
Operating Expenses (CAD)
Annual -
Annual Per SF -
Total Expenses (CAD)
Annual $99,999
Annual Per SF $9.99

PROPERTY FACTS

Price $7,189,000 CAD
Price Per SF $1,129.99 CAD
Sale Type Owner User
Property Type Specialty
Property Subtype Residential Income
Building Class B
Lot Size 7.25 AC
Building Size 6,362 SF
No. Stories 1
Year Built 1997
Zoning AE20
  • Listing ID: 37726978

  • Date on Market: 2025-06-06

  • Last Updated:

  • Address: 15516 N Friant Rd, Friant, CA 93626

Link copied
Your LoopNet account has been created!

Please Share Your Feedback

We welcome any feedback on how we can improve LoopNet to better serve your needs.
X
{{ getErrorText(feedbackForm.starRating, "rating") }}
255 character limit ({{ remainingChars() }} charactercharacters remainingover)
{{ getErrorText(feedbackForm.msg, "rating") }}
{{ getErrorText(feedbackForm.fname, "first name") }}
{{ getErrorText(feedbackForm.lname, "last name") }}
{{ getErrorText(feedbackForm.phone, "phone number") }}
{{ getErrorText(feedbackForm.phonex, "phone extension") }}
{{ getErrorText(feedbackForm.email, "email address") }}