| Create Account |
| Login |
| Home |
| Buying |
| Selling |
| About |
|
Contact
|
| Create Account | Login |
Photo Gallery
$799,000
3 bd
| 3.25 ba
| 2,795 sq ft
| 0.31 acre
3782 W Locust Ave
Fresno, CA 93711
Get DirectionsListed On: 10/30/2025
Status: Active
Listing Number: 639248 (Fresno MLS)
Schedule a Tour
Contact Info
Property Description
Gorgeous, absolutely stunning custom home located in the highly desirable San Joaquin Estates offering a wonderful mix of modern amenities with traditional charm. Upon arrival, you are greeted with a picturesque front yard, complete with mature landscaping, large professionally trimmed trees, lush green grass, flowers, cement steps, and even a stone walkway. The interior begins with a double-door entrance to the foyer. The living room, located to the left, features a large masonry fireplace and expansive picture windows providing natural light, adjacent to the dining room. The large great room hosts the second masonry fireplace, sponge painted, a stand-alone bar and entertainment area, wood flooring, soaring beam ceiling with ample natural light, large windows, a glass sliding door overlooking the gorgeous backyard and more. The kitchen has tiled floor and is equipped with stainless steel appliances, including a five-burner gas stove, wine refrigerator, and EcoWater purification system (under the stainless-steel dual sink), along with a separate entry to the dining room for ease when entertaining. The breakfast bar and eating area, complete with beautiful wood flooring and a solarium-style breakfast nook with windows and shades, provides natural light, making this kitchen area a great way to start your day. Beyond the kitchen, you find a renovated bathroom, utility room with an entrance to the tandem garage, and a storage area. The bedrooms are accessed to the right of the foyer. The hall bathroom features a tub and shower, dual sinks and separate counter prep area. Bedrooms 1 and 2 are large and have newer fan lights. The primary bedroom is unforgettable with its grandeur: a reading area in this very large primary bedroom, the third masonry sponge-painted fireplace, a walk-in closet remodeled and redesigned California Closets with installed shelving. The primary bathroom features dual sinks, tiled floors, granite countertops, and the large shower is expansive, with rain showerheads with intricate tile work. The backyard continues to impress with a beautiful inground pool and waterfall, landscaping, a fantastic gazebo, covered patio, seating areas near the pool and banana tree, a storage shed, and more. This home is a pleasure to view.
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
2
Cumulative Days On Market
2
County
Fresno
Reports Available
Pest, NHD
Special Features
Built In Cabinets, Water Softener, Water Filter, Wet/Dry Bar
REO / Bank Owned
No
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
3
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
No
Parking Features
Potential RV Parking, Drive Thru, Auto Opener, Street, Tandem Garage
Garage Type
Attached
Garage Spaces
2
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
Courtesy of Nada Stijovic, Pro Mr. Z Realty Madera - [email protected]
Last modified 1 day ago
Fresno MLS last checked for updates 1 hour 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.
Copyright © 2025 London Properties, Ltd. All rights reserved.
