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.
Property Type
ResidentialCounty
FresnoStyle
ResidentialAD ID
49038856
Sell a home like this and save $360,971 Find Out How
Property Details
-
Interior Features
Bedroom Information
- Total Bedrooms : 6
Bathroom Information
- Total Baths: 6
- Full Baths: 5
- Half Baths: 1
Water/Sewer
- Water Source : Private
- Sewer : Septic Type Unknown
Interior Features
- Property Appliances: Built-In Range,Dishwasher,Disposal,Gas Range,Microwave,Refrigerator
- Fireplace: Bonus Room,Living Room,Primary Bedroom
Cooling Features
- Central Air
- Air Conditioning
Heating Source
- Central
- Has Heating
Fireplace
- Fireplace Features: Bonus Room,Living Room,Primary Bedroom
- Has Fireplace: 1
-
Exterior Features
Building Information
- Year Built: 1997
Pool Features
- Private
Laundry Features
- Inside,Laundry Room
-
Property / Lot Details
Lot Details
- Lot Dimensions Source: Vendor Enhanced
- Lot Size Acres: 7.258
- Lot Size Source: Assessor
- Lot Size Square Feet: 316160
-
Listing Information
Listing Price Information
- Original List Price: 6,024,500
- Listing Contract Date: 2025-03-13
Lease Information
- Listing Agreement: Exclusive Right To Sell
-
Taxes / Assessments
Tax Information
- Parcel Number: 30031045S
-
Virtual Tour, Parking, Multi-Unit Information & Homeowners Association
Garage and Parking
- Attached Garage: Yes
Homeowners Association
Rental Info
- Lease Term: Negotiable
-
School, Utilities & Location Details
Other Property Info
- Source Listing Status: Active
- Source Neighborhood:
- Directions: From Friant Rd. and Willow, continue on Friant to property. Private Gate.
- Zoning: AE20
- Source Property Type: Residential
- Property SubType: Single Family Residence
Building and Construction
- Property Age: 28
- Common Walls: No Common Walls
- Structure Type: Single Family Residence
- Year Built Source: Assessor
- Total Square Feet Living: 6362
- Entry Level: 1
- Entry Location: front
- Levels or Stories: One
- Building Total Stories: 1
- Structure Type: House
Statistics Bottom Ads 2

Sidebar Ads 1

Learn More about this Property
Sidebar Ads 2

Sidebar Ads 2

Copyright © 2025 by the Multiple Listing Service of the California Regional MLS®. This information is believed to be accurate but is not guaranteed. Subject to verification by all parties. This data is copyrighted and may not be transmitted, retransmitted, copied, framed, repurposed, or altered in any way for any other site, individual and/or purpose without the express written permission of the Multiple Listing Service of the California Regional MLS®. Information Deemed Reliable But Not Guaranteed. Any use of search facilities of data on this site, other than by a consumer looking to purchase real estate, is prohibited.
BuyOwner last updated this listing 04/09/2025 @ 02:35
- MLS: SC25061273
- LISTING PROVIDED COURTESY OF: ,
- SOURCE: CRMLS
is a Home, with 6 bedrooms which is for sale, it has 6,362 sqft, 316,160 sized lot, and 14 parking. are nearby neighborhoods.