Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/655708/Fresno/Woodward-Park/https://www.londonproperties.com/images/props/fresno/full/655708.jpgLondon Properties Fresno Real Estate
Courtesy of Brian Finegan, Brian Finegan, Broker - [email protected]
A rare opportunity to own one of Via Alicante's most extraordinary private estates, where remarkable scale, privacy and resort-style living come together in a truly one-of-a-kind setting. Spanning more than 8,900 square feet, this exceptional residence features 5 bedrooms, 6.5 baths and two additional flex rooms ideal for a private office, fitness studio, wellness space or additional guest accommodations. A dedicated game room, wine cellar and generous storage add to the home's exceptional functionality.At the heart of the residence is a spectacular culinary kitchen anchored by a statement La Cornue range, combining serious functionality with showpiece design. A striking 400-gallon saltwater aquarium creates another unforgettable focal point within the home.Beyond the residence, the fully gated and secure grounds unfold into a private resort designed for entertaining on an impressive scale. The expansive outdoor setting features a dramatic resort-style pool, beautifully landscaped grounds, putting greens and multiple gathering areas. A large covered outdoor living pavilion is complete with a full kitchen and TVs, while a second outdoor living space provides additional flexibility for dining, entertaining or relaxation.A removable pickleball court, koi pond, private sauna and two fire pits including one designed for both gas and traditional wood burning create endless opportunities for recreation and enjoyment.For the automotive enthusiast or serious collector, an extraordinary 13+ car garage provides exceptional capacity for vehicles, recreational equipment, storage and more. Owned solar further complements the estate's extensive infrastructure and efficiency.Every element of this property has been thoughtfully created around lifestyle offering privacy when desired, entertainment on a grand scale and amenities rarely found together in a single residence. From the dramatic arrival and expansive grounds to its culinary kitchen, recreation spaces and remarkable garage capacity, this is more than a home it is a private resort and an offering without equal in Via Alicante.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built Exception
New Construction
Region
Urban
# of Stories
Two
Price Per Square Foot
$1,300
Price Per Acre
$6,827,727
Days On London
1
Cumulative Days On London
1
County
Fresno
Reports Available
CC&Rs, Other HOA Documents
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, Security Gate, Built In Cabinets, Central Vac, Wet/Dry Bar, High Tech Cable
REO / Bank Owned
No
Cross Street Address
COPPER/MAPLE
Directions
Enter Via Alicante off Maple/Copper Avenue. Agent to provide gate code when requested.
Special Disclosure
Agent/Owner Related
Style
Mediterranean
Heating & Cooling
Central Heat & Cool, Ductless or Split
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Detached Structures
Other/See Remarks
Kitchen
Built In Range/Oven, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator, Wine Refrigerator
Dining Room Features
Formal, Living Room/Area, Family Room/Area
Primary Bedroom Level
Lower
Extra Rooms
Great Room, Office, Family Room, Den/Study, Game Room, Wine Room
Green Area, Security Guard, Landscape Maint, Gated Community
HOA Dues
430.00
School District
Clovis Unified
School Type 1
High School
School Name 1
Clovis North
School Type 2
Junior High School
School Name 2
Granite Ridge
School Type 3
Grade School
School Name 3
Fugman
Seller Will Consider
Conventional, Cash, Owner Carry
1st Loan Type
Free & Clear
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 10998888.15 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 12156665.85 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '6' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 8654 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 9154 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1760746 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1751500 OR `props-main`.`id` = 1762249 OR `props-main`.`id` = 1780409 OR `props-main`.`id` = 1755005 OR `props-main`.`id` = 1755025 OR `props-main`.`id` = 1755078 OR `props-main`.`id` = 1779479 OR `props-main`.`id` = 1778236 OR `props-main`.`id` = 1742074 OR `props-main`.`id` = 1742687 OR `props-main`.`id` = 1763415 OR `props-main`.`id` = 1721908 OR `props-main`.`id` = 1764008 OR `props-main`.`id` = 1744266 OR `props-main`.`id` = 1745685 OR `props-main`.`id` = 717214 OR `props-main`.`id` = 1747608 OR `props-main`.`id` = 1770926 OR `props-main`.`id` = 1770448 OR `props-main`.`id` = 1723071 OR `props-main`.`id` = 37606 OR `props-main`.`id` = 1769011 OR `props-main`.`id` = 1716328 OR `props-main`.`id` = 1716322 OR `props-main`.`id` = 1748465 OR `props-main`.`id` = 1775932 OR `props-main`.`id` = 1759440 OR `props-main`.`id` = 1762665 OR `props-main`.`id` = 1774974 OR `props-main`.`id` = 1775407 OR `props-main`.`id` = 1774868 OR `props-main`.`id` = 1765044 OR `props-main`.`id` = 1758739 OR `props-main`.`id` = 1725154 OR `props-main`.`id` = 1777814 OR `props-main`.`id` = 1780359 OR `props-main`.`id` = 1730638 OR `props-main`.`id` = 1742900 OR `props-main`.`id` = 1774924 OR `props-main`.`id` = 1760981 OR `props-main`.`id` = 1734226 OR `props-main`.`id` = 1747337 OR `props-main`.`id` = 1766249 OR `props-main`.`id` = 1751643 OR `props-main`.`id` = 1751634 OR `props-main`.`id` = 1770534 OR `props-main`.`id` = 981418 OR `props-main`.`id` = 1752465 OR `props-main`.`id` = 1774565 OR `props-main`.`id` = 1726419 OR `props-main`.`id` = 1726361 OR `props-main`.`id` = 1752170 OR `props-main`.`id` = 1721479 OR `props-main`.`id` = 1761750 OR `props-main`.`id` = 1762477 OR `props-main`.`id` = 1777813 OR `props-main`.`id` = 1701497 OR `props-main`.`id` = 1773758 OR `props-main`.`id` = 1755155 OR `props-main`.`id` = 1746581 OR `props-main`.`id` = 102873 OR `props-main`.`id` = 1725917 OR `props-main`.`id` = 1761023 OR `props-main`.`id` = 1758156 OR `props-main`.`id` = 1743401 OR `props-main`.`id` = 1727157 OR `props-main`.`id` = 1764664 OR `props-main`.`id` = 1757635 OR `props-main`.`id` = 1762742 OR `props-main`.`id` = 1752225 OR `props-main`.`id` = 1765654 OR `props-main`.`id` = 1753037 OR `props-main`.`id` = 1779952 OR `props-main`.`id` = 1725339 OR `props-main`.`id` = 1713572 OR `props-main`.`id` = 1725511 OR `props-main`.`id` = 1725026 OR `props-main`.`id` = 1749676 OR `props-main`.`id` = 1726492 OR `props-main`.`id` = 1735331 OR `props-main`.`id` = 1774275 OR `props-main`.`id` = 1780816 OR `props-main`.`id` = 1779311 OR `props-main`.`id` = 1779970 OR `props-main`.`id` = 1758195 OR `props-main`.`id` = 1705384 OR `props-main`.`id` = 1769517 OR `props-main`.`id` = 1725048 OR `props-main`.`id` = 1765274 OR `props-main`.`id` = 1765315 OR `props-main`.`id` = 1750746 OR `props-main`.`id` = 1768475 OR `props-main`.`id` = 1779075 OR `props-main`.`id` = 1748931 OR `props-main`.`id` = 1733252 OR `props-main`.`id` = 1761824 OR `props-main`.`id` = 1761518 OR `props-main`.`id` = 1779560 OR `props-main`.`id` = 1765371 OR `props-main`.`id` = 1724531 OR `props-main`.`id` = 1747692 OR `props-main`.`id` = 1757547 OR `props-main`.`id` = 227897 OR `props-main`.`id` = 1736892 OR `props-main`.`id` = 1728553 OR `props-main`.`id` = 1733417 OR `props-main`.`id` = 1733470 OR `props-main`.`id` = 1779561 OR `props-main`.`id` = 1732392 OR `props-main`.`id` = 1747382 OR `props-main`.`id` = 1747383 OR `props-main`.`id` = 1747380 OR `props-main`.`id` = 1665744 OR `props-main`.`id` = 1665747)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655708' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-24' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
Last modified 30 minutes ago Fresno MLS last checked for updates 24 minutes ago
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
