Luxury Estate with Stunning Views, Pool, Wine Cellar, and Extensive Amenities in Friant

Active Commercial Special purpose

15516 North Friant Road, Friant, California, 93626, USA

USD $5,200,000

Listed by Realty Concepts, Ltd.

Contact

Reference ID: 631539 Web ID: e380d

Property Highlights

360-degree views of Table Mountain
3,000 sq. ft. garage for 14 vehicles
1,600-bottle wine cellar with elevator
Two independent guest homes with gym
Owned solar and helipad onsite

Description

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.

Detail & Features

Transaction Type: Commercial
Property Type: Special purpose
Status: Active
Area: 6,362 sf

Map

Area Features

Businesses Nearby

Pizza Factory

(2 miles away)

Eagles Landing Steakhouse

(5 miles away)

Table Mountain Casino

(5 miles away)

777 Tacos

(5 miles away)

Corner Bakery Cafe

(8 miles away)

Heirloom

(8 miles away)

Applebee's Grill + Bar

(8 miles away)

Lazy Dog Restaurant & Bar

(9 miles away)

Public Transportation

Fresno State University (Shaw and Cedar)

(11 miles away)

Fresno Handy Ride

(12 miles away)

Fresno Yosemite International Airport

(13 miles away)

Fresno

(16 miles away)

Amtrak/Greyhound

(16 miles away)

Greyhound: Bus Station

(16 miles away)

Fresno Area Express

(16 miles away)

Fresno County Rural Transit Agency

(16 miles away)

Costa de Oro/Latinos Bus Line

(16 miles away)

Airports

Sierra Sky Park Airport

(12 miles away)

Fresno Yosemite International Airport

(13 miles away)

Fresno Chandler Executive Airport

(17 miles away)

Madera Municipal Airport

(21 miles away)

Nearby Special purpose Properties

Fresno, California, USA

9 miles away

Restaurant Location for Sale with Equipment, Lease Transfer, and License in Palm & Nees Ave

USD $125,000

Details

Fresno, California, USA

14 miles away

Established Vietnamese Pho Restaurant in Mayfair Center with Turnkey Operation

USD $210,000

Details

Tucson, Arizona, USA

586 miles away

Commercial Investment Property with Long-term Tenant in Oro Valley/catalina Corridor

USD $990,000

Details

Grand Junction, Colorado, USA

624 miles away

Car Wash Business for Sale in Orchard Mesa with High Traffic Exposure and Growth Potential

USD $781,440

Details

Contact Realty Concepts, Ltd.

DISCLAIMER: Listing data provided to the Site by third parties. Reliance Relocation Services, Inc. and subsidiary companies do not warrant or make representations regarding the listings and other information displayed on the page, including the reliability, accuracy, or currency of any information, content, or service displayed on this page. Listings may be withdrawn from the market at any time and are subject to errors, omissions, and prior sale or rental without notice.

360-degree views of Table Mountain
3,000 sq. ft. garage for 14 vehicles
1,600-bottle wine cellar with elevator
Two independent guest homes with gym
Owned solar and helipad onsite

Nearby Special purpose Properties

Fresno, California, USA

9 miles away

Restaurant Location for Sale with Equipment, Lease Transfer, and License in Palm & Nees Ave

USD $125,000

Details

Fresno, California, USA

14 miles away

Established Vietnamese Pho Restaurant in Mayfair Center with Turnkey Operation

USD $210,000

Details

Tucson, Arizona, USA

586 miles away

Commercial Investment Property with Long-term Tenant in Oro Valley/catalina Corridor

USD $990,000

Details

Grand Junction, Colorado, USA

624 miles away

Car Wash Business for Sale in Orchard Mesa with High Traffic Exposure and Growth Potential

USD $781,440

Details

OFFICE

INDUSTRIAL

MULTIFAMILY

RETAIL

MIXED-USE

HOSPITALITY

LAND

SPECIAL PURPOSE

Choose Your Preferences

Luxury Estate with Stunning Views, Pool, Wine Cellar, and Extensive Amenities in Friant

15516 North Friant Road, Friant, California, 93626, USA

Businesses Nearby

Public Transportation

Airports

Restaurant Location for Sale with Equipment, Lease Transfer, and License in Palm & Nees Ave

Established Vietnamese Pho Restaurant in Mayfair Center with Turnkey Operation

Commercial Investment Property with Long-term Tenant in Oro Valley/catalina Corridor

Car Wash Business for Sale in Orchard Mesa with High Traffic Exposure and Growth Potential

Property Highlights

Nearby Special purpose Properties

Restaurant Location for Sale with Equipment, Lease Transfer, and License in Palm & Nees Ave

Established Vietnamese Pho Restaurant in Mayfair Center with Turnkey Operation

Commercial Investment Property with Long-term Tenant in Oro Valley/catalina Corridor

Car Wash Business for Sale in Orchard Mesa with High Traffic Exposure and Growth Potential