London Properties Fresno Real Estate

2788 W Bluff Ave

Fresno, CA 93711

Copy Link Get Directions

Photo Gallery

$1,795,000

6 bd

5.5 ba

5,141 sq ft

0.34 acre

2788 W Bluff Ave

Fresno, CA 93711

Get Directions

Listed On: 03/26/2026

Status: Active

Listing Number: 646115 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

Alex Cetti 559.301.7930 Visit Website Email Agent

Property Description

Located on the Bluff in the highly sought after Van Ness Extension, this contemporary estate offers luxury living with exceptional design and scale.

Soaring ceilings, skylights, and statement stone flooring create a light-filled interior, complemented by multiple living spaces, fireplaces, and seamless indoor-outdoor flow. The updated kitchen features granite countertops, a large center island, premium appliances including Miele and Sub-Zero, and a spacious walk-in pantry.

Upstairs, hardwood floors lead to a versatile loft, multiple bedrooms, and a private sauna. The expansive primary suite offers a sitting area, fireplace, dual walk-in closets, and access to a private deck overlooking the backyard.

Designed for entertaining, the resort-style backyard features a pebble-tech pool and spa, mature landscaping, and an oversized covered patio. Situated on a large corner lot with a 3-car garage and 74 owned solar panels, all just minutes from top Fresno dining and shopping.

A rare Bluff opportunity with modern upgrades and timeless appeal. Schedule your private tour today.

Bed, bath and sq ft are different than tax records if important buyer to verify.

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

1983

Region

Urban

# of Stories

Two

Price Per Square Foot

$349

Price Per Acre

$5,318,519

Days On London

Cumulative Days On London

County

Fresno

Special Features

Isolated Bedroom, Isolated Bathroom, Skylight

REO / Bank Owned

Cross Street Address

Alluvial/Van Ness

Directions

From Herndon and Van Ness, head north on Van Ness, left at Bluff, property will be on the right

Heating & Cooling

Central Heat & Cool

Laundry

Inside, On Lower Level

Roofing

Tile

Foundation

Concrete

Kitchen

Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator, Other

Primary Bedroom Level

Upper

Flooring

Tile, Hardwood

# of Fireplaces

Exterior

Stucco

Pool

Yes

Pool

Yes

Pool Type

In Ground

Patio Features

Covered

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Energy Efficiency

Dual Pane Windows

Solar

Yes

Solar Type

Owned

Are there garage spaces?

Yes

Garage Type

Attached

Garage Spaces

Site Amenities

Bluff View

APN

500 360 36 S [PARCEL MAP]

Association / Park Amenities

Other/None

HOA Dues

135.00

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

Tatarian

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1705250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1884750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '6' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4891 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 5391 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` = 1716422 OR `props-main`.`id` = 1713257 OR `props-main`.`id` = 1707213 OR `props-main`.`id` = 1716285 OR `props-main`.`id` = 1716474 OR `props-main`.`id` = 1707125 OR `props-main`.`id` = 1679434 OR `props-main`.`id` = 1717033 OR `props-main`.`id` = 305398 OR `props-main`.`id` = 1697338 OR `props-main`.`id` = 1704539 OR `props-main`.`id` = 1713827 OR `props-main`.`id` = 364614 OR `props-main`.`id` = 1684797 OR `props-main`.`id` = 1709510 OR `props-main`.`id` = 1696662 OR `props-main`.`id` = 1705983 OR `props-main`.`id` = 1709930 OR `props-main`.`id` = 1709958 OR `props-main`.`id` = 1718268 OR `props-main`.`id` = 1704748 OR `props-main`.`id` = 1713804 OR `props-main`.`id` = 1704718 OR `props-main`.`id` = 1715977 OR `props-main`.`id` = 1705414 OR `props-main`.`id` = 1715531 OR `props-main`.`id` = 1681969 OR `props-main`.`id` = 228969 OR `props-main`.`id` = 1709254 OR `props-main`.`id` = 1717426 OR `props-main`.`id` = 1704188 OR `props-main`.`id` = 1638688 OR `props-main`.`id` = 325803 OR `props-main`.`id` = 1703779 OR `props-main`.`id` = 1717479 OR `props-main`.`id` = 1712682 OR `props-main`.`id` = 1709629 OR `props-main`.`id` = 1717464 OR `props-main`.`id` = 1689147 OR `props-main`.`id` = 1708400 OR `props-main`.`id` = 1666287 OR `props-main`.`id` = 1677865 OR `props-main`.`id` = 1701249 OR `props-main`.`id` = 1698451 OR `props-main`.`id` = 1704086 OR `props-main`.`id` = 1716453 OR `props-main`.`id` = 1695724 OR `props-main`.`id` = 1717341 OR `props-main`.`id` = 1717084 OR `props-main`.`id` = 1704902 OR `props-main`.`id` = 1712589 OR `props-main`.`id` = 1715475 OR `props-main`.`id` = 195780 OR `props-main`.`id` = 1714843 OR `props-main`.`id` = 698805 OR `props-main`.`id` = 1702051 OR `props-main`.`id` = 1713973 OR `props-main`.`id` = 1703313 OR `props-main`.`id` = 1690778 OR `props-main`.`id` = 244747 OR `props-main`.`id` = 1707020 OR `props-main`.`id` = 1707036 OR `props-main`.`id` = 248378 OR `props-main`.`id` = 37607 OR `props-main`.`id` = 1717593 OR `props-main`.`id` = 1713837 OR `props-main`.`id` = 1716654 OR `props-main`.`id` = 1686044 OR `props-main`.`id` = 1702495 OR `props-main`.`id` = 311276 OR `props-main`.`id` = 211531 OR `props-main`.`id` = 1705340 OR `props-main`.`id` = 1711188 OR `props-main`.`id` = 1718461 OR `props-main`.`id` = 1687966)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno646115' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-27' 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 Alexandra Cetti, London Properties, Ltd. - [email protected]
Last modified 4 hours ago
Fresno MLS last checked for updates 5 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.

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

2788 W Bluff Ave

Fresno, CA 93711

Photo Gallery

$1,795,000

2788 W Bluff Ave

Fresno, CA 93711

Schedule a Tour

Contact Info

Presented By:

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

2788 W Bluff Ave

Fresno, CA 93711

Photo Gallery

$1,795,000

2788 W Bluff Ave

Fresno, CA 93711

Schedule a Tour

Contact Info

Presented By:

Loading...

Saving...

Deleting...

Searching...