London Properties Fresno Real Estate

4188 N Contessa Ave

Fresno, CA 93723

Copy Link Get Directions

Photo Gallery

$775,000

5 bd

3.5 ba

3,058 sq ft

0.18 acre

4188 N Contessa Ave

Fresno, CA 93723

Get Directions

Listed On: 04/24/2026

Status: Active

Listing Number: 647741 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

London Properties, Ltd. 559.436.4071 Email Agent

Property Description

OWNED SOLAR! Spacious 5-bedroom home in a prime location near top-rated schools and neighborhood parks.

This well-designed two-story home features the popular Davis floor plan by Wathen-Castanos, offering a functional layout with a large loft, gourmet kitchen, and an expansive great room ideal for everyday living and entertaining.

The floor plan includes a downstairs bedroom and full bathroom, providing flexibility for guests, extended family, or a home office setup. Upstairs, the owner's suite overlooks the backyard and includes a spacious walk-in closet, dual vanities, and a fully tiled shower.

Interior features include Beechwood cabinetry, a butler's pantry, and modern finishes throughout. The owned solar system adds long-term energy efficiency and cost savings.

Located in a quiet neighborhood near a community park and adjacent to the Central Unified School complex, including Justin Garza High School, Glacier Middle School, and Harvest Elementary.

Additional highlights include easy freeway access and close proximity to shopping, dining, and everyday amenities.

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

2023

Region

Urban

# of Stories

Two

Price Per Square Foot

$253

Price Per Acre

$4,341,737

Days On London

Cumulative Days On London

231

County

Fresno

Special Features

Water Filter

REO / Bank Owned

Cross Street Address

Bryan/Gettysburg

Directions

South on Bryan, East on Holland, South on Swift, house on corner of Contessa.

Heating & Cooling

Central Heat & Cool

Laundry

Inside, On Upper Level

Roofing

Tile

Foundation

Concrete

Kitchen

Gas Appliances, Disposal, Dishwasher, Microwave, Pantry

Primary Bedroom Level

Upper

Bath Features

Tub/Shower, Tub

Extra Rooms

Loft

Exterior

Stucco

Pool

Spa

Yard

Sprinklers Front, Drip System

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

Park View

APN

512 261 11 S [PARCEL MAP]

Zoning

Tract / Builder

Wathen-Castanos

School District

Central Unified

School Type 1

High School

School Name 1

Justin Garza High

School Type 2

Junior High School

School Name 2

Glacier Point

School Type 3

Grade School

School Name 3

Harvest

Seller Will Consider

Conventional, Cash

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 736250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 813750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2808 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3308 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` = 1721956 OR `props-main`.`id` = 1722939 OR `props-main`.`id` = 160601 OR `props-main`.`id` = 1701302 OR `props-main`.`id` = 1717390 OR `props-main`.`id` = 1665977 OR `props-main`.`id` = 1717342 OR `props-main`.`id` = 1696403 OR `props-main`.`id` = 1718531 OR `props-main`.`id` = 1722484 OR `props-main`.`id` = 985326 OR `props-main`.`id` = 249079 OR `props-main`.`id` = 1711243 OR `props-main`.`id` = 1719156 OR `props-main`.`id` = 1708197 OR `props-main`.`id` = 1718851 OR `props-main`.`id` = 1722404 OR `props-main`.`id` = 1717032 OR `props-main`.`id` = 1722617 OR `props-main`.`id` = 1706015 OR `props-main`.`id` = 230296 OR `props-main`.`id` = 858027 OR `props-main`.`id` = 1714024 OR `props-main`.`id` = 1722205 OR `props-main`.`id` = 1714022 OR `props-main`.`id` = 283623 OR `props-main`.`id` = 1698470 OR `props-main`.`id` = 1717072 OR `props-main`.`id` = 1719727 OR `props-main`.`id` = 1722721 OR `props-main`.`id` = 1722198 OR `props-main`.`id` = 1705639 OR `props-main`.`id` = 1723176 OR `props-main`.`id` = 1718964 OR `props-main`.`id` = 1710280 OR `props-main`.`id` = 1722339 OR `props-main`.`id` = 1723774 OR `props-main`.`id` = 1723430 OR `props-main`.`id` = 1723425 OR `props-main`.`id` = 1716158 OR `props-main`.`id` = 1688794 OR `props-main`.`id` = 1716428 OR `props-main`.`id` = 1719468 OR `props-main`.`id` = 1703809 OR `props-main`.`id` = 1703621 OR `props-main`.`id` = 1691506 OR `props-main`.`id` = 1703640 OR `props-main`.`id` = 1688199 OR `props-main`.`id` = 1718822 OR `props-main`.`id` = 1720601 OR `props-main`.`id` = 1721517 OR `props-main`.`id` = 1712629 OR `props-main`.`id` = 1700030 OR `props-main`.`id` = 1720487 OR `props-main`.`id` = 1714834 OR `props-main`.`id` = 1677783 OR `props-main`.`id` = 1699177 OR `props-main`.`id` = 1706840 OR `props-main`.`id` = 1713562 OR `props-main`.`id` = 280658 OR `props-main`.`id` = 1718476 OR `props-main`.`id` = 1691819 OR `props-main`.`id` = 1713567 OR `props-main`.`id` = 1708388 OR `props-main`.`id` = 1693937 OR `props-main`.`id` = 1723518 OR `props-main`.`id` = 1716816 OR `props-main`.`id` = 1716822 OR `props-main`.`id` = 1702793 OR `props-main`.`id` = 1703327 OR `props-main`.`id` = 1702452 OR `props-main`.`id` = 1720752 OR `props-main`.`id` = 1713579 OR `props-main`.`id` = 1623993 OR `props-main`.`id` = 1624007 OR `props-main`.`id` = 1624009 OR `props-main`.`id` = 1665944 OR `props-main`.`id` = 1665945 OR `props-main`.`id` = 1545586 OR `props-main`.`id` = 1716953 OR `props-main`.`id` = 1696600 OR `props-main`.`id` = 1666343 OR `props-main`.`id` = 1721346 OR `props-main`.`id` = 1718475 OR `props-main`.`id` = 1694431 OR `props-main`.`id` = 1669960 OR `props-main`.`id` = 1665855 OR `props-main`.`id` = 1717546 OR `props-main`.`id` = 1723076 OR `props-main`.`id` = 1712638 OR `props-main`.`id` = 1717497 OR `props-main`.`id` = 1720902 OR `props-main`.`id` = 1719155 OR `props-main`.`id` = 166957 OR `props-main`.`id` = 1717545 OR `props-main`.`id` = 1723682 OR `props-main`.`id` = 1678847)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647741' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-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();

Courtesy of Lovepreet Chandi, Iron Key Real Estate - [email protected]
Last modified 5 hours ago
Fresno MLS last checked for updates 11 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

4188 N Contessa Ave

Fresno, CA 93723

Photo Gallery

$775,000

4188 N Contessa Ave

Fresno, CA 93723

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

4188 N Contessa Ave

Fresno, CA 93723

Photo Gallery

$775,000

4188 N Contessa Ave

Fresno, CA 93723

Schedule a Tour

Contact Info

Presented By:

Loading...

Saving...

Deleting...

Searching...