London Properties Fresno Real Estate

4712 W Celeste Ave

Fresno, CA 93722

Copy Link Get Directions

Photo Gallery

$515,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:

London Properties, Ltd. 559.436.4071 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

$209

Price Per Acre

$3,451,743

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) >= 489250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 540750 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` = 1695489 OR `props-main`.`id` = 230296 OR `props-main`.`id` = 858027 OR `props-main`.`id` = 283623 OR `props-main`.`id` = 1696491 OR `props-main`.`id` = 1679183 OR `props-main`.`id` = 1693938 OR `props-main`.`id` = 1688565 OR `props-main`.`id` = 1694851 OR `props-main`.`id` = 1694718 OR `props-main`.`id` = 1677783 OR `props-main`.`id` = 1666027 OR `props-main`.`id` = 1690049 OR `props-main`.`id` = 280658 OR `props-main`.`id` = 1691605 OR `props-main`.`id` = 1694911 OR `props-main`.`id` = 1695947 OR `props-main`.`id` = 1688960 OR `props-main`.`id` = 1694449 OR `props-main`.`id` = 1691819 OR `props-main`.`id` = 1693937 OR `props-main`.`id` = 1690592 OR `props-main`.`id` = 1666265 OR `props-main`.`id` = 1685672 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` = 1696600 OR `props-main`.`id` = 1692591 OR `props-main`.`id` = 1666343 OR `props-main`.`id` = 1677263 OR `props-main`.`id` = 1694431 OR `props-main`.`id` = 1686085 OR `props-main`.`id` = 1686156 OR `props-main`.`id` = 1686122 OR `props-main`.`id` = 1665855 OR `props-main`.`id` = 1697286 OR `props-main`.`id` = 1688072 OR `props-main`.`id` = 1680552 OR `props-main`.`id` = 1687875 OR `props-main`.`id` = 1693401 OR `props-main`.`id` = 1697185 OR `props-main`.`id` = 1675371 OR `props-main`.`id` = 1657743 OR `props-main`.`id` = 1687289 OR `props-main`.`id` = 1689659 OR `props-main`.`id` = 1689448 OR `props-main`.`id` = 1613712 OR `props-main`.`id` = 1697695 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` = 1695427 OR `props-main`.`id` = 1684754 OR `props-main`.`id` = 1690780 OR `props-main`.`id` = 1696778 OR `props-main`.`id` = 1691748 OR `props-main`.`id` = 1691749 OR `props-main`.`id` = 1691753 OR `props-main`.`id` = 1679271 OR `props-main`.`id` = 1697235 OR `props-main`.`id` = 1694472 OR `props-main`.`id` = 37604 OR `props-main`.`id` = 1695268 OR `props-main`.`id` = 1685846 OR `props-main`.`id` = 1687821 OR `props-main`.`id` = 1686584 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` = 1695383 OR `props-main`.`id` = 1680256 OR `props-main`.`id` = 1688605 OR `props-main`.`id` = 1678847 OR `props-main`.`id` = 1692234 OR `props-main`.`id` = 1695059 OR `props-main`.`id` = 1687194 OR `props-main`.`id` = 1691333 OR `props-main`.`id` = 1693979 OR `props-main`.`id` = 1668886 OR `props-main`.`id` = 1679434 OR `props-main`.`id` = 1679550 OR `props-main`.`id` = 1683939 OR `props-main`.`id` = 1683818 OR `props-main`.`id` = 1696675 OR `props-main`.`id` = 1697338 OR `props-main`.`id` = 1697736 OR `props-main`.`id` = 1692015 OR `props-main`.`id` = 1673162 OR `props-main`.`id` = 1697223 OR `props-main`.`id` = 1697228 OR `props-main`.`id` = 1696193 OR `props-main`.`id` = 1680654 OR `props-main`.`id` = 364614 OR `props-main`.`id` = 1697171 OR `props-main`.`id` = 1696257 OR `props-main`.`id` = 1684797 OR `props-main`.`id` = 1688691 OR `props-main`.`id` = 1696662 OR `props-main`.`id` = 166342 OR `props-main`.`id` = 1694104 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` = 1678800 OR `props-main`.`id` = 1696716 OR `props-main`.`id` = 1689147 OR `props-main`.`id` = 1697801 OR `props-main`.`id` = 272846 OR `props-main`.`id` = 1666287 OR `props-main`.`id` = 1677865 OR `props-main`.`id` = 187711 OR `props-main`.`id` = 1696715 OR `props-main`.`id` = 1696684 OR `props-main`.`id` = 1697813 OR `props-main`.`id` = 1696109 OR `props-main`.`id` = 195780 OR `props-main`.`id` = 1695965 OR `props-main`.`id` = 1696219 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` = 1684128 OR `props-main`.`id` = 1696443 OR `props-main`.`id` = 1655626 OR `props-main`.`id` = 1696869 OR `props-main`.`id` = 1696876 OR `props-main`.`id` = 1691239)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636696' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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.75
2,535
0.10

4430 W Langden Dr

Fresno, CA 93722

$515,000

4
3.5
2,630
0.11

4473 W Langden Dr

Fresno, CA 93722

$502,000

4
3
2,455
0.10

4422 W Langden Dr #Lot14

Fresno, CA 93722

Courtesy of Khushvinder Kaur, RE/MAX Gold - [email protected]
Last modified 1 month ago
Fresno MLS last checked for updates 28 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

4712 W Celeste Ave

Fresno, CA 93722

Photo Gallery

$515,000

4712 W Celeste Ave

Fresno, CA 93722

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$540,000

$515,000

$515,000

$502,000

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

4712 W Celeste Ave

Fresno, CA 93722

Photo Gallery

$515,000

4712 W Celeste Ave

Fresno, CA 93722

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$540,000

$515,000

$515,000

$502,000

Loading...

Saving...

Deleting...

Searching...