London Properties Fresno Real Estate

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

Surf Inn at Gualala, CA

Buying

Selling

Home Value Calculator

About

Create Account | Login

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

3782 W Locust Ave

Fresno, CA 93711

Copy Link Get Directions

Photo Gallery

$799,000

3 bd

3.25 ba

2,795 sq ft

0.31 acre

3782 W Locust Ave

Fresno, CA 93711

Get Directions

Listed On: 10/30/2025

Status: Active

Listing Number: 639248 (Fresno MLS)

Open House

Sun, Nov 30
1:00pm - 4:00pm
Courtesy of Pro Mr. Z Realty Madera

Schedule a Tour

Contact Info

Presented By:

Eric R. Cogdill 559.917.3246 Email Agent

Property Description

Welcome to this stunning custom home located in the highly-desirable area of San Joaquin Estates. From the moment you step through the double-door entry into the spacious foyer, you'll be impressed. To the left is a large living room with a masonry fireplace and expansive picture windows creating natural light, flowing seamlessly into the formal dining room. The home's great room is equally breathtaking- featuring its second masonry fireplace, a stand-alone bar and entertainment area, wood flooring, soaring beam ceiling, large windows, a glass sliding door overlooking the gorgeous backyard and more. The kitchen is designed for both style and function: tiled flooring, stainless steel appliances, including a five-burner gas stove, wine refrigerator, and EcoWater purification system under the stainless-steel sink. A breakfast bar and a separate eating area with beautiful wood flooring and a solarium-style nook allow for bright morning light-making this a great place to start your day. Beyond the kitchen, is a renovated bathroom, utility room with direct access to the tandem garage and a storage area. The bedrooms are accessed to the right of the foyer. The hall bath features dual sinks, separate counter-prep area, and tub/shower. Bedrooms 1 and 2 are generously sized and include newer fan lights. The primary suite is unforgettable: a large reading area, the third masonry fireplace, a walk-in closet remodeled and redesigned California Closets with installed shelving. The primary bathroom features dual sinks, tiled floors, granite countertops, and and a large shower with dual rain showerheads and intricate tile work. Outside, the backyard continues to impress-featuring an inground pool with waterfall, mature landscaping, a large gazebo, covered patio with seating area, 2 storage sheds, and more with plenty of room for relaxation and recreation. This home truly offers the lifestyle you've been looking for-luxury, comfort, and design.

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

1980

Region

Urban

# of Stories

Single Story

Price Per Square Foot

$286

Price Per Acre

$2,578,251

Days On Market

Cumulative Days On Market

County

Fresno

Reports Available

Pest, NHD

Special Features

Built In Cabinets, Water Softener, Water Filter, Wet/Dry Bar

REO / Bank Owned

Cross Street Address

Herndon/Brawley

Directions

Herndon Ave and Brawley Ave- go North on Brawley Ave Left on Locust Ave to the property

Unit Description

Ground Floor

Style

Contemporary

Heating & Cooling

Central Heat & Cool

Laundry

Inside, Utility Room

Roofing

Composition

Foundation

Concrete

Detached Structures

Shed, Other/See Remarks

Kitchen

F/S Range/Oven, Disposal, Dishwasher, Microwave, Trash Compactor, Eating Area, Breakfast Bar, Pantry, Refrigerator, Wine Refrigerator

Dining Room Features

Formal

Primary Bedroom Level

Main

Bath Features

Tub/Shower, Shower

Extra Rooms

Great Room

Basement

None

Disabled Features

One Level Floor

Flooring

Carpet, Tile, Hardwood

# of Fireplaces

Fireplace Type

Masonry

Exterior

Stucco

Pool

Yes

Pool

Yes

Pool Type

In Ground

Patio Features

Covered

Yard

Sprinklers Auto, Fenced, Mature Landscape, Garden Area

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Energy Efficiency

Dual Pane Windows

Solar

Parking Features

Potential RV Parking, Drive Thru, Auto Opener, Street, Tandem Garage

Garage Type

Attached

Garage Spaces

Lot Dimensions

108X125

APN

501 123 02 S [PARCEL MAP]

Zoning

RS4

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

Seller Will Consider

Government, Conventional, Cash

1st Loan Type

Non-Assumable

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 759050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 838950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2545 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3045 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` = 1688072 OR `props-main`.`id` = 1680552 OR `props-main`.`id` = 1687875 OR `props-main`.`id` = 1693401 OR `props-main`.`id` = 1690504 OR `props-main`.`id` = 1689965 OR `props-main`.`id` = 1675371 OR `props-main`.`id` = 1657743 OR `props-main`.`id` = 1687289 OR `props-main`.`id` = 1695520 OR `props-main`.`id` = 1695550 OR `props-main`.`id` = 1689659 OR `props-main`.`id` = 1694885 OR `props-main`.`id` = 1689448 OR `props-main`.`id` = 1613712 OR `props-main`.`id` = 1694413 OR `props-main`.`id` = 1688680 OR `props-main`.`id` = 1629374 OR `props-main`.`id` = 1695156 OR `props-main`.`id` = 1688787 OR `props-main`.`id` = 1684754 OR `props-main`.`id` = 1690780 OR `props-main`.`id` = 1691748 OR `props-main`.`id` = 1691749 OR `props-main`.`id` = 1691753 OR `props-main`.`id` = 1694472 OR `props-main`.`id` = 37604 OR `props-main`.`id` = 1695268 OR `props-main`.`id` = 1685846 OR `props-main`.`id` = 1686584 OR `props-main`.`id` = 1693794 OR `props-main`.`id` = 1688902 OR `props-main`.`id` = 1684501 OR `props-main`.`id` = 1694205 OR `props-main`.`id` = 1687471 OR `props-main`.`id` = 1696283 OR `props-main`.`id` = 1680256 OR `props-main`.`id` = 1688605 OR `props-main`.`id` = 1696164 OR `props-main`.`id` = 1692234 OR `props-main`.`id` = 1695059 OR `props-main`.`id` = 1691462 OR `props-main`.`id` = 1691259 OR `props-main`.`id` = 1687194 OR `props-main`.`id` = 1693979 OR `props-main`.`id` = 1668886 OR `props-main`.`id` = 1695451 OR `props-main`.`id` = 1691874 OR `props-main`.`id` = 1678802 OR `props-main`.`id` = 1679434 OR `props-main`.`id` = 1679550 OR `props-main`.`id` = 1683939 OR `props-main`.`id` = 1683818 OR `props-main`.`id` = 1684445 OR `props-main`.`id` = 1692015 OR `props-main`.`id` = 1673162 OR `props-main`.`id` = 1696193 OR `props-main`.`id` = 1680654 OR `props-main`.`id` = 364614 OR `props-main`.`id` = 1696257 OR `props-main`.`id` = 1684797 OR `props-main`.`id` = 1693767 OR `props-main`.`id` = 1688691 OR `props-main`.`id` = 1663498 OR `props-main`.`id` = 1690182 OR `props-main`.`id` = 1692276 OR `props-main`.`id` = 1694104 OR `props-main`.`id` = 1685580 OR `props-main`.`id` = 1666470 OR `props-main`.`id` = 1694741 OR `props-main`.`id` = 1265238 OR `props-main`.`id` = 1655500 OR `props-main`.`id` = 1684639 OR `props-main`.`id` = 1673569 OR `props-main`.`id` = 1689574 OR `props-main`.`id` = 1681969 OR `props-main`.`id` = 1686041 OR `props-main`.`id` = 1667684 OR `props-main`.`id` = 1673449 OR `props-main`.`id` = 228969 OR `props-main`.`id` = 1678800 OR `props-main`.`id` = 1695131 OR `props-main`.`id` = 1638688 OR `props-main`.`id` = 325803 OR `props-main`.`id` = 1694786 OR `props-main`.`id` = 1688096 OR `props-main`.`id` = 1687420 OR `props-main`.`id` = 1675014 OR `props-main`.`id` = 1670983 OR `props-main`.`id` = 1689147 OR `props-main`.`id` = 272846 OR `props-main`.`id` = 1695898 OR `props-main`.`id` = 1666287 OR `props-main`.`id` = 1692032 OR `props-main`.`id` = 1677865 OR `props-main`.`id` = 187711 OR `props-main`.`id` = 1688434 OR `props-main`.`id` = 1695724 OR `props-main`.`id` = 1685317 OR `props-main`.`id` = 1696109 OR `props-main`.`id` = 1696298 OR `props-main`.`id` = 1691689 OR `props-main`.`id` = 1691692 OR `props-main`.`id` = 1692104 OR `props-main`.`id` = 1692586 OR `props-main`.`id` = 195780 OR `props-main`.`id` = 1695965 OR `props-main`.`id` = 1694187 OR `props-main`.`id` = 1688225 OR `props-main`.`id` = 698805 OR `props-main`.`id` = 1628966 OR `props-main`.`id` = 231417 OR `props-main`.`id` = 258175 OR `props-main`.`id` = 1663877 OR `props-main`.`id` = 1691363 OR `props-main`.`id` = 1691779 OR `props-main`.`id` = 1690309 OR `props-main`.`id` = 1690900 OR `props-main`.`id` = 1684128 OR `props-main`.`id` = 244747 OR `props-main`.`id` = 37607 OR `props-main`.`id` = 1696273 OR `props-main`.`id` = 1692048 OR `props-main`.`id` = 1679500 OR `props-main`.`id` = 1684967 OR `props-main`.`id` = 1686044 OR `props-main`.`id` = 1664283 OR `props-main`.`id` = 1688883 OR `props-main`.`id` = 1688407 OR `props-main`.`id` = 311276 OR `props-main`.`id` = 1655615 OR `props-main`.`id` = 1655626 OR `props-main`.`id` = 1675414 OR `props-main`.`id` = 256897 OR `props-main`.`id` = 1696194 OR `props-main`.`id` = 211531 OR `props-main`.`id` = 1691239 OR `props-main`.`id` = 1671563 OR `props-main`.`id` = 1681817)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639248' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-29' 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 Nada Stijovic, Pro Mr. Z Realty Madera - nstijovic1@gmail.com
Last modified 2 days ago
Fresno MLS last checked for updates 15 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

3782 W Locust Ave

Fresno, CA 93711

Photo Gallery

$799,000

3782 W Locust Ave

Fresno, CA 93711

Open House

Schedule a Tour

Contact Info

Presented By: