Please provide the following information and Cheryl Ventura will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.agentventura.com/agent/866/cheryl-ventura/property/link/fresno/641787/4689-N-Van-Ness-Blvd/Fresno/Bullard-High-Fig-Garden/https://www.agentventura.com/images/props/fresno/full/641787.jpgLondon Properties Fresno Real Estate | 4689 N Van Ness Blvd
Experience timeless elegance and exceptional living in this completely remodeled and updated estate on iconic Van Ness Boulevard. Nestled in the prestigious Old Fig Garden area, this expansive 5,789 sq ft residence sits on nearly an acre of impeccably manicured grounds, offering rare privacy, sophistication, and space.
Thoughtfully reimagined with today's modern comforts, this home features 4 spacious bedrooms and 5.5 bathrooms, a basement, and three stately fireplaces. The grand formal living and dining rooms flow effortlessly into a oversized beautifully updated kitchen and welcoming family areasideal for both lavish entertaining and refined everyday living.
Large sliding doors open to a resort-style backyard retreat, complete with mature landscaping, a sparkling pool, and multiple patios perfect for alfresco dining and outdoor gatherings. An oversized garage provides ample storage and convenience.
From its graceful architectural detailing to its top-to-bottom upgrades and prime location, this one-of-a-kind property blends historic charm with modern luxury in one of Fresno's most coveted neighborhoods. A rare opportunity to own a true Central Valley estate.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1940
Region
Urban
# of Stories
Two
Price Per Square Foot
$553
Price Per Acre
$4,089,980
Days On Market
0
Cumulative Days On Market
166
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, Built In Cabinets, High Tech Cable
REO / Bank Owned
No
Cross Street Address
Van Ness/ Rialto
Directions
South West corner of Van Ness Blvd & Rialto. Garage is on Rialto. Front door on Van Ness Blvd.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Upper Level, On Lower Level
Roofing
Tile
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Wine Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 3040000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 3360000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 5539 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 6039 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` = 1701150 OR `props-main`.`id` = 1691589 OR `props-main`.`id` = 1698218 OR `props-main`.`id` = 1702839 OR `props-main`.`id` = 1636534 OR `props-main`.`id` = 1698886 OR `props-main`.`id` = 1702469 OR `props-main`.`id` = 1701795 OR `props-main`.`id` = 1701876 OR `props-main`.`id` = 1682199 OR `props-main`.`id` = 1680888 OR `props-main`.`id` = 1667573 OR `props-main`.`id` = 1585117 OR `props-main`.`id` = 1702565 OR `props-main`.`id` = 1703792 OR `props-main`.`id` = 1703799 OR `props-main`.`id` = 1693730 OR `props-main`.`id` = 1703432 OR `props-main`.`id` = 1699054 OR `props-main`.`id` = 1697246 OR `props-main`.`id` = 1701794 OR `props-main`.`id` = 1701255 OR `props-main`.`id` = 1701253 OR `props-main`.`id` = 1701835 OR `props-main`.`id` = 1685102 OR `props-main`.`id` = 1701252 OR `props-main`.`id` = 1637299 OR `props-main`.`id` = 1696832 OR `props-main`.`id` = 1696260 OR `props-main`.`id` = 1702999 OR `props-main`.`id` = 1696035 OR `props-main`.`id` = 1689479 OR `props-main`.`id` = 1689505 OR `props-main`.`id` = 1689529 OR `props-main`.`id` = 1689481 OR `props-main`.`id` = 1689491 OR `props-main`.`id` = 1689478 OR `props-main`.`id` = 1689504 OR `props-main`.`id` = 1689485 OR `props-main`.`id` = 1702304 OR `props-main`.`id` = 1702306 OR `props-main`.`id` = 1702030 OR `props-main`.`id` = 1641625 OR `props-main`.`id` = 1695567 OR `props-main`.`id` = 1698859 OR `props-main`.`id` = 1612822 OR `props-main`.`id` = 1698084 OR `props-main`.`id` = 1689769 OR `props-main`.`id` = 1701395 OR `props-main`.`id` = 1698870 OR `props-main`.`id` = 1692254 OR `props-main`.`id` = 1684173 OR `props-main`.`id` = 1699074 OR `props-main`.`id` = 1704027 OR `props-main`.`id` = 1704199 OR `props-main`.`id` = 1701765 OR `props-main`.`id` = 1694714 OR `props-main`.`id` = 1697981 OR `props-main`.`id` = 1703707 OR `props-main`.`id` = 1695804 OR `props-main`.`id` = 1687392 OR `props-main`.`id` = 1687383 OR `props-main`.`id` = 1696099 OR `props-main`.`id` = 1702903 OR `props-main`.`id` = 1678451 OR `props-main`.`id` = 1702882 OR `props-main`.`id` = 1702292 OR `props-main`.`id` = 1702483 OR `props-main`.`id` = 1677679 OR `props-main`.`id` = 1703437 OR `props-main`.`id` = 1696160 OR `props-main`.`id` = 1683022 OR `props-main`.`id` = 1639054 OR `props-main`.`id` = 1694761 OR `props-main`.`id` = 1698715 OR `props-main`.`id` = 1689666 OR `props-main`.`id` = 1689669 OR `props-main`.`id` = 1695105 OR `props-main`.`id` = 1694309 OR `props-main`.`id` = 1694238 OR `props-main`.`id` = 1702420 OR `props-main`.`id` = 1702406 OR `props-main`.`id` = 1703938 OR `props-main`.`id` = 1688797 OR `props-main`.`id` = 1695143 OR `props-main`.`id` = 1702794 OR `props-main`.`id` = 1696806 OR `props-main`.`id` = 1689513 OR `props-main`.`id` = 1701246 OR `props-main`.`id` = 1683081 OR `props-main`.`id` = 1676595 OR `props-main`.`id` = 37605 OR `props-main`.`id` = 1695812 OR `props-main`.`id` = 1690449 OR `props-main`.`id` = 1702867 OR `props-main`.`id` = 1665766 OR `props-main`.`id` = 1669870 OR `props-main`.`id` = 1698164 OR `props-main`.`id` = 1695630 OR `props-main`.`id` = 1704181 OR `props-main`.`id` = 1693524 OR `props-main`.`id` = 1684839 OR `props-main`.`id` = 1684826 OR `props-main`.`id` = 1684834 OR `props-main`.`id` = 1691020 OR `props-main`.`id` = 1700060 OR `props-main`.`id` = 1701501 OR `props-main`.`id` = 1702442 OR `props-main`.`id` = 166956 OR `props-main`.`id` = 1702188 OR `props-main`.`id` = 1702006 OR `props-main`.`id` = 1691261 OR `props-main`.`id` = 1695528 OR `props-main`.`id` = 1703478 OR `props-main`.`id` = 1686892 OR `props-main`.`id` = 1702168 OR `props-main`.`id` = 1649781 OR `props-main`.`id` = 1700924 OR `props-main`.`id` = 1690305 OR `props-main`.`id` = 1685935 OR `props-main`.`id` = 1688703 OR `props-main`.`id` = 1689138 OR `props-main`.`id` = 161024 OR `props-main`.`id` = 1698065 OR `props-main`.`id` = 1684087 OR `props-main`.`id` = 1683979 OR `props-main`.`id` = 1686077 OR `props-main`.`id` = 1657930 OR `props-main`.`id` = 1691533 OR `props-main`.`id` = 1703688 OR `props-main`.`id` = 1702027 OR `props-main`.`id` = 1678394 OR `props-main`.`id` = 1703581 OR `props-main`.`id` = 1685264 OR `props-main`.`id` = 1677923 OR `props-main`.`id` = 102280 OR `props-main`.`id` = 1703751 OR `props-main`.`id` = 1695440 OR `props-main`.`id` = 1678113 OR `props-main`.`id` = 265423 OR `props-main`.`id` = 1691835 OR `props-main`.`id` = 1703401 OR `props-main`.`id` = 1702890 OR `props-main`.`id` = 1695738 OR `props-main`.`id` = 1679663 OR `props-main`.`id` = 1679070 OR `props-main`.`id` = 1704257 OR `props-main`.`id` = 1704053 OR `props-main`.`id` = 1694435 OR `props-main`.`id` = 1701818 OR `props-main`.`id` = 1702555 OR `props-main`.`id` = 1688334 OR `props-main`.`id` = 1702059 OR `props-main`.`id` = 1694020 OR `props-main`.`id` = 1701171 OR `props-main`.`id` = 1696727 OR `props-main`.`id` = 1702745 OR `props-main`.`id` = 1702634 OR `props-main`.`id` = 1690889 OR `props-main`.`id` = 1694568 OR `props-main`.`id` = 1698884 OR `props-main`.`id` = 1687193 OR `props-main`.`id` = 1701661 OR `props-main`.`id` = 1689906 OR `props-main`.`id` = 1694936 OR `props-main`.`id` = 1648930 OR `props-main`.`id` = 1685997 OR `props-main`.`id` = 1703451 OR `props-main`.`id` = 1704050 OR `props-main`.`id` = 1678405 OR `props-main`.`id` = 1700029 OR `props-main`.`id` = 1703850 OR `props-main`.`id` = 217382 OR `props-main`.`id` = 1696083 OR `props-main`.`id` = 1689192 OR `props-main`.`id` = 1689729 OR `props-main`.`id` = 1698753 OR `props-main`.`id` = 1701388 OR `props-main`.`id` = 1702378)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641787' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-25' 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
Courtesy of Robert Zimmerman, Pismo Coast Realty - rob.zimm@gmail.com Last modified 1 day ago Fresno MLS last checked for updates 28 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.
