London Properties Fresno Real Estate

Leo Estrada

REALTOR^®

Leo Estrada | 559.260.1856 | lestrada@londonproperties.com | LIC #01798316

Leo Estrada

(559) 260-1856

Home Buying Selling About Contact

Create Account

Fields marked with * are required. However, providing more information will allow us to better serve your needs.
* First Name:
* Last Name:
* Email Address:
* Password:
* Confirm Password:
Street Address:
City:
State:
Zip:
Cell Phone:
Other Phone:

Home

Buying

Selling

Home Value Calculator

About

Create Account | Login

Fresno Bee People's Choice Award Winner - #1 Best Real Estate Company

3520 W Buena Vista

Fresno, CA 93711

Copy Link Get Directions

Photo Gallery

$3,300,000

3 bd

2.5 ba

3,629 sq ft

0.57 acre

3520 W Buena Vista

Fresno, CA 93711

Get Directions

Listed On: 09/07/2025

Status: Active

Listing Number: 636679 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

Leo Estrada 559.260.1856 Email Agent

Property Description

Fresno's PREMIER Country Club View! An Extraordinary Setting OverlookingThe Signature 11th Fairway at San Joaquin Country Club! Lakeview, Vine covered Bluffs and Breathtaking Vistas will give you a feeling of a Vacation Home in Carmel. Grand Opulence in this Ultra-Custom Home, featuring Light Oak Hardwood floors, 8 ft. solid wood doors, Beveled glass French doors, and a Wall of Windows to absorb the Spectacular Views. Modern Expansive Open Floor plan! Culinary Kitchen offers Quartz counters, Dining Bar, High-end Appliances, Dining Area with Stone Fireplace and A Mesmerizing View, Formal Living and Dining Rooms. Owner's Suite is Spectacular with Luxury Bath featuring glass block, soothing bathtub, spacious shower and a closet full of reflections. Flagstone Beauty accents the exterior featuring massive Fireplace, secondary outdoor dining area. Tennis/Sport court, Set on Over a half Acre that can accommodate additions. Three car garage with work area and additional cooking ovens, Play area for children including an outdoor playroom. This property cannot be duplicated, offering Views and Serenity that all will Appreciate and Envy!

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

1999

Region

Urban

# of Stories

Single Story

Price Per Square Foot

$909

Price Per Acre

$5,750,131

Days On Market

Cumulative Days On Market

361

County

Fresno

REO / Bank Owned

Cross Street Address

N/Alluvial

Directions

N/Alluvial Marks Follow GPS

Heating & Cooling

Central Heat & Cool

Laundry

Inside

Roofing

Tile

Foundation

Wood Subfloor

Primary Bedroom Level

Lower

# of Fireplaces

Exterior

Stucco, Stone

Pool

Yes

Pool

Yes

Pool Type

In Ground

Yard

Sprinklers Front, Sprinklers Back, Sprinklers Auto, Fenced, Mature Landscape

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Energy Efficiency

Dual Pane Windows

Solar

Yes

Solar Type

Owned

Garage Type

Attached

Garage Spaces

Lot Dimensions

125X200

Site Amenities

Bluff View, Golf Course

APN

500 080 36 [PARCEL MAP]

Zoning

R1B

School District

Fresno Unified

School Type 1

High School

School Name 1

Bullard

School Type 2

Junior High School

School Name 2

Tenaya

School Type 3

Grade School

School Name 3

Forkner

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 3135000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 3465000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3379 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3879 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` = 37604 OR `props-main`.`id` = 1671193 OR `props-main`.`id` = 1680256 OR `props-main`.`id` = 1683042 OR `props-main`.`id` = 1673935 OR `props-main`.`id` = 1642532 OR `props-main`.`id` = 1682165 OR `props-main`.`id` = 1683256 OR `props-main`.`id` = 1679101 OR `props-main`.`id` = 1668886 OR `props-main`.`id` = 1680121 OR `props-main`.`id` = 1683326 OR `props-main`.`id` = 1667419 OR `props-main`.`id` = 1671765 OR `props-main`.`id` = 1678802 OR `props-main`.`id` = 1674286 OR `props-main`.`id` = 1679434 OR `props-main`.`id` = 1668113 OR `props-main`.`id` = 1684445 OR `props-main`.`id` = 1673162 OR `props-main`.`id` = 1680654 OR `props-main`.`id` = 364614 OR `props-main`.`id` = 1673438 OR `props-main`.`id` = 1664173 OR `props-main`.`id` = 1684797 OR `props-main`.`id` = 1674361 OR `props-main`.`id` = 1683659 OR `props-main`.`id` = 1681104 OR `props-main`.`id` = 1678587 OR `props-main`.`id` = 1678273 OR `props-main`.`id` = 1663498 OR `props-main`.`id` = 1681515 OR `props-main`.`id` = 1663892 OR `props-main`.`id` = 1684108 OR `props-main`.`id` = 1683039 OR `props-main`.`id` = 1666470 OR `props-main`.`id` = 1655500 OR `props-main`.`id` = 1674827 OR `props-main`.`id` = 1684639 OR `props-main`.`id` = 1673569 OR `props-main`.`id` = 1681217 OR `props-main`.`id` = 1681262 OR `props-main`.`id` = 1681969 OR `props-main`.`id` = 1674730 OR `props-main`.`id` = 1673449 OR `props-main`.`id` = 1666468 OR `props-main`.`id` = 1666459 OR `props-main`.`id` = 1683974 OR `props-main`.`id` = 228969 OR `props-main`.`id` = 1678800 OR `props-main`.`id` = 1646128 OR `props-main`.`id` = 1683915 OR `props-main`.`id` = 1638688 OR `props-main`.`id` = 325803 OR `props-main`.`id` = 1679526 OR `props-main`.`id` = 1675014 OR `props-main`.`id` = 1656601 OR `props-main`.`id` = 1658853 OR `props-main`.`id` = 1662322 OR `props-main`.`id` = 1670983 OR `props-main`.`id` = 1635613 OR `props-main`.`id` = 1675440 OR `props-main`.`id` = 1666287 OR `props-main`.`id` = 1677865 OR `props-main`.`id` = 1673595 OR `props-main`.`id` = 1682031 OR `props-main`.`id` = 1679322 OR `props-main`.`id` = 1684631 OR `props-main`.`id` = 1656335 OR `props-main`.`id` = 1665664 OR `props-main`.`id` = 1681949 OR `props-main`.`id` = 1668005 OR `props-main`.`id` = 1673338 OR `props-main`.`id` = 1677874 OR `props-main`.`id` = 1679638 OR `props-main`.`id` = 195780 OR `props-main`.`id` = 1650193 OR `props-main`.`id` = 698805 OR `props-main`.`id` = 1628966 OR `props-main`.`id` = 1677181 OR `props-main`.`id` = 231417 OR `props-main`.`id` = 258175 OR `props-main`.`id` = 1673869 OR `props-main`.`id` = 1684128 OR `props-main`.`id` = 1680600 OR `props-main`.`id` = 244747 OR `props-main`.`id` = 1682193 OR `props-main`.`id` = 1682996 OR `props-main`.`id` = 1657669 OR `props-main`.`id` = 37607 OR `props-main`.`id` = 1684390 OR `props-main`.`id` = 1679500 OR `props-main`.`id` = 1679789 OR `props-main`.`id` = 1656029 OR `props-main`.`id` = 1655947 OR `props-main`.`id` = 1684472 OR `props-main`.`id` = 311276 OR `props-main`.`id` = 1655615 OR `props-main`.`id` = 1655626 OR `props-main`.`id` = 1675414 OR `props-main`.`id` = 211531 OR `props-main`.`id` = 1650844 OR `props-main`.`id` = 1680406 OR `props-main`.`id` = 1673794 OR `props-main`.`id` = 1673201 OR `props-main`.`id` = 1652709 OR `props-main`.`id` = 1671563)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636679' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-09' 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();

Courtesy of Rod Aluisi, Rod Aluisi Real Estate - rod@aluisi.com
Last modified 2 days ago
Fresno MLS last checked for updates 27 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.

Get More Info

Print A Flyer

Get A Home Loan

Share

3520 W Buena Vista

Fresno, CA 93711

Photo Gallery

$3,300,000

3520 W Buena Vista

Fresno, CA 93711

Schedule a Tour

Contact Info

Presented By: