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

4712 W Celeste Ave

Fresno, CA 93722

Copy Link Get Directions

Photo Gallery

$535,000

4 bd

3 ba

2,468 sq ft

0.15 acre

4712 W Celeste Ave

Fresno, CA 93722

Get Directions

Listed On: 09/07/2025

Status: Active

Listing Number: 636696 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

Leo Estrada 559.260.1856 Email Agent

Property Description

Beautiful Home in Northwest Fresno2468 SF Living Space on a 6500 SF Spacious LotLocated near The Marketplace, Hwy 99, and Herndon, this spacious 2-story home offers comfort, functionality, and room to grow.✨ Features include: 4 Bedrooms, 3 Bathrooms - Multiple walk-in closets, plus a private downstairs mother-in-law suite with its own bath, shower, and direct backyard access. Open Living Spaces - A large living room, an isolated room with a dual-sided fireplace, and a bright, airy loft. Chef's Kitchen - Complete with a pantry, high ceilings, and two skylights that bring in natural light. Luxurious Primary Suite - Featuring an oval soaking tub and spacious layout. Convenience - Indoor laundry room and plenty of storage throughout.🌳 Outdoor Highlights: Large backyard with extended concrete and a covered patio, perfect for entertaining. Potential RV parking and space for a sparkling pool.This home blends style and practicality with plenty of room for family and guests.

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

2005

Region

Urban

# of Stories

Two

Price Per Square Foot

$217

Price Per Acre

$3,585,791

Days On Market

Cumulative Days On Market

County

Fresno

REO / Bank Owned

Cross Street Address

W Bullard/N Cornelia

Directions

North on Bullard, North on Milburn, Right on Celeste, House is on Right Side with For Sale Sign.

Heating & Cooling

Central Heat & Cool

Laundry

Inside

Roofing

Composition

Foundation

Concrete

Primary Bedroom Level

Upper

# of Fireplaces

Exterior

Wood, Other

Pool

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Solar

Garage Type

Attached

Garage Spaces

APN

509 320 046 [PARCEL MAP]

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

Lawless

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 508250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 561750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2218 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2718 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` = 230296 OR `props-main`.`id` = 858027 OR `props-main`.`id` = 1681946 OR `props-main`.`id` = 1646642 OR `props-main`.`id` = 283623 OR `props-main`.`id` = 1684602 OR `props-main`.`id` = 1680229 OR `props-main`.`id` = 1679183 OR `props-main`.`id` = 1684383 OR `props-main`.`id` = 1683179 OR `props-main`.`id` = 1681950 OR `props-main`.`id` = 1676791 OR `props-main`.`id` = 1677783 OR `props-main`.`id` = 1666027 OR `props-main`.`id` = 280658 OR `props-main`.`id` = 1684526 OR `props-main`.`id` = 1677730 OR `props-main`.`id` = 1679373 OR `props-main`.`id` = 1681659 OR `props-main`.`id` = 1675238 OR `props-main`.`id` = 1676686 OR `props-main`.`id` = 1676687 OR `props-main`.`id` = 1666265 OR `props-main`.`id` = 1671617 OR `props-main`.`id` = 1673395 OR `props-main`.`id` = 1682574 OR `props-main`.`id` = 1654765 OR `props-main`.`id` = 1623993 OR `props-main`.`id` = 1624007 OR `props-main`.`id` = 1674638 OR `props-main`.`id` = 1624009 OR `props-main`.`id` = 1665944 OR `props-main`.`id` = 1665945 OR `props-main`.`id` = 1545586 OR `props-main`.`id` = 1652461 OR `props-main`.`id` = 1654674 OR `props-main`.`id` = 1666343 OR `props-main`.`id` = 1674570 OR `props-main`.`id` = 1677263 OR `props-main`.`id` = 1665855 OR `props-main`.`id` = 1680552 OR `props-main`.`id` = 1679108 OR `props-main`.`id` = 1678947 OR `props-main`.`id` = 1675371 OR `props-main`.`id` = 1657743 OR `props-main`.`id` = 1678381 OR `props-main`.`id` = 1613712 OR `props-main`.`id` = 1683284 OR `props-main`.`id` = 1629374 OR `props-main`.`id` = 1638439 OR `props-main`.`id` = 1638440 OR `props-main`.`id` = 1638442 OR `props-main`.`id` = 1684754 OR `props-main`.`id` = 1684727 OR `props-main`.`id` = 1679271 OR `props-main`.`id` = 1679701 OR `props-main`.`id` = 37604 OR `props-main`.`id` = 1683532 OR `props-main`.`id` = 1683647 OR `props-main`.`id` = 1679719 OR `props-main`.`id` = 1683734 OR `props-main`.`id` = 1671193 OR `props-main`.`id` = 1677691 OR `props-main`.`id` = 1684501 OR `props-main`.`id` = 1683781 OR `props-main`.`id` = 1674315 OR `props-main`.`id` = 1680256 OR `props-main`.`id` = 1678847 OR `props-main`.`id` = 1678446 OR `props-main`.`id` = 1683042 OR `props-main`.`id` = 1642532 OR `props-main`.`id` = 1683004 OR `props-main`.`id` = 1682200 OR `props-main`.`id` = 1682165 OR `props-main`.`id` = 1682228 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` = 1683293 OR `props-main`.`id` = 1679550 OR `props-main`.`id` = 1681748 OR `props-main`.`id` = 1683939 OR `props-main`.`id` = 1683818 OR `props-main`.`id` = 1668113 OR `props-main`.`id` = 1684445 OR `props-main`.`id` = 1673162 OR `props-main`.`id` = 1678663 OR `props-main`.`id` = 1680654 OR `props-main`.`id` = 364614 OR `props-main`.`id` = 1673438 OR `props-main`.`id` = 1674361 OR `props-main`.`id` = 1675210 OR `props-main`.`id` = 1683659 OR `props-main`.`id` = 1681104 OR `props-main`.`id` = 166342 OR `props-main`.`id` = 1680539 OR `props-main`.`id` = 1678587 OR `props-main`.`id` = 1678273 OR `props-main`.`id` = 1681515 OR `props-main`.`id` = 1663892 OR `props-main`.`id` = 1684108 OR `props-main`.`id` = 1683039 OR `props-main`.`id` = 1678120 OR `props-main`.`id` = 1265238 OR `props-main`.`id` = 1655500 OR `props-main`.`id` = 1674827 OR `props-main`.`id` = 1684639 OR `props-main`.`id` = 1673569 OR `props-main`.`id` = 1681262 OR `props-main`.`id` = 1667684 OR `props-main`.`id` = 1678800 OR `props-main`.`id` = 1683915 OR `props-main`.`id` = 1657510 OR `props-main`.`id` = 1679526 OR `props-main`.`id` = 1675014 OR `props-main`.`id` = 1658853 OR `props-main`.`id` = 1662322 OR `props-main`.`id` = 1683123 OR `props-main`.`id` = 1658376 OR `props-main`.`id` = 1684587 OR `props-main`.`id` = 1677886 OR `props-main`.`id` = 1673999 OR `props-main`.`id` = 272846 OR `props-main`.`id` = 1666287 OR `props-main`.`id` = 1677865 OR `props-main`.`id` = 187711 OR `props-main`.`id` = 1682031 OR `props-main`.`id` = 1679322 OR `props-main`.`id` = 1675054 OR `props-main`.`id` = 1659350 OR `props-main`.`id` = 1677240 OR `props-main`.`id` = 1668005 OR `props-main`.`id` = 1677874 OR `props-main`.`id` = 1679638 OR `props-main`.`id` = 195780 OR `props-main`.`id` = 1650193 OR `props-main`.`id` = 1677181 OR `props-main`.`id` = 231417 OR `props-main`.`id` = 258175 OR `props-main`.`id` = 1663877 OR `props-main`.`id` = 1673869 OR `props-main`.`id` = 1684128 OR `props-main`.`id` = 1676739 OR `props-main`.`id` = 1684390 OR `props-main`.`id` = 1679500 OR `props-main`.`id` = 1655615 OR `props-main`.`id` = 1655626 OR `props-main`.`id` = 1675414 OR `props-main`.`id` = 1680406 OR `props-main`.`id` = 1652709)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636696' 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();

Similar Properties

$540,000

6
3.25
2,456
0.14

6583 N State Ave

Fresno, CA 93722

$515,000

4
3
2,400
0.14

6001 W Alluvial Ave

Fresno, CA 93722

$512,000

4
3
2,455
0.10

4422 W Langden Dr #Lot14

Fresno, CA 93722

Courtesy of Khushvinder Kaur, RE/MAX Gold - expcaone@gmail.com
Last modified 1 day ago
Fresno MLS last checked for updates 18 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

4712 W Celeste Ave

Fresno, CA 93722

Photo Gallery

$535,000

4712 W Celeste Ave

Fresno, CA 93722

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$540,000

$515,000

$512,000