London Properties Fresno Real Estate

Ernie Manuel

REALTOR^®

Ernie Manuel | 559.213.2816 | ernie@londonproperties.com | LIC #01325895

Ernie Manuel

(559) 213-2816

Home Resources 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

Resources

Neighborhood Information

US $ to Philippine Pesos Conversion

Buying

Buying a Home

How to Buy a HUD/VA Home

Buyer's Guide

New Construction

Selling

Sell Your Home

Home Value Calculator

Home Seller's Guide

Home Insurance

How to Save on Commission

About

Create Account | Login

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

6640 W Celeste Ave

Fresno, CA 93723

Copy Link Get Directions

Photo Gallery

$599,000

4 bd

3 ba

2,900 sq ft

0.18 acre

6640 W Celeste Ave

Fresno, CA 93723

Get Directions

Listed On: 09/03/2025

Status: Active

Listing Number: 636470 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

Ernie Manuel 559.213.2816 Email Agent

Property Description

Step into comfort and style in this beautifully maintained 4-bedroom, 3rd -bath Granville home, featuring an open-concept layout perfect for modern living. The spacious living room seamlessly flows into a bright and airy kitchen, complete with ample counter space, modern appliances, and a large island ideal for entertaining or everyday family life. Natural light fills the living space, highlighting the thoughtful design and warm finishes throughout. The primary suite offers a peaceful retreat with a private bath and generous closet space, while the additional three bedrooms are perfect for guests, a home office, or growing families. Enjoy outdoor living in the spacious backyard perfect for summer barbecues, gardening, or simply relaxing. Located in a quiet, friendly neighborhood with easy access to schools, shopping, and major commuting routes, this home combines convenience with cozy charm. Don't miss your chance to make this beautiful property your new home!

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

2006

Region

Urban

# of Stories

Two

Price Per Square Foot

$207

Price Per Acre

$3,401,476

Days On Market

Cumulative Days On Market

County

Fresno

REO / Bank Owned

Cross Street Address

Bullard & Grantland

Directions

From Grantland, East on Bullard, South on La Paz, East on Celeste.

Heating & Cooling

Central Heat & Cool

Laundry

Inside, Utility Room

Roofing

Tile

Foundation

Concrete

Kitchen

Built In Range/Oven, Disposal, Dishwasher, Microwave, Pantry, Refrigerator

Dining Room Features

Formal

Primary Bedroom Level

Upper

Bath Features

Tub/Shower, Shower, Oval Tub

Extra Rooms

Great Room, Loft

Basement

None

Flooring

Carpet, Tile

# of Fireplaces

Fireplace Type

Gas Insert

Exterior

Stucco, Stone

Pool

Spa

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Solar

Yes

Solar Type

Owned

Garage Type

Attached

Garage Spaces

Lot Dimensions

65X118

APN

505 184 13 [PARCEL MAP]

Zoning

RS3

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

Herndon-Barstow

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 569050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 628950 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) >= 2650 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3150 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` = 1684056 OR `props-main`.`id` = 1684546 OR `props-main`.`id` = 1678272 OR `props-main`.`id` = 1678791 OR `props-main`.`id` = 1677232 OR `props-main`.`id` = 1677235 OR `props-main`.`id` = 1671521 OR `props-main`.`id` = 1677246 OR `props-main`.`id` = 1678826 OR `props-main`.`id` = 1679148 OR `props-main`.`id` = 1669974 OR `props-main`.`id` = 1683179 OR `props-main`.`id` = 1657535 OR `props-main`.`id` = 1683999 OR `props-main`.`id` = 1679416 OR `props-main`.`id` = 1679718 OR `props-main`.`id` = 1680765 OR `props-main`.`id` = 1683211 OR `props-main`.`id` = 1664325 OR `props-main`.`id` = 1681950 OR `props-main`.`id` = 1676791 OR `props-main`.`id` = 1679218 OR `props-main`.`id` = 1669847 OR `props-main`.`id` = 280658 OR `props-main`.`id` = 1684526 OR `props-main`.`id` = 1677730 OR `props-main`.`id` = 1679373 OR `props-main`.`id` = 1675238 OR `props-main`.`id` = 1681699 OR `props-main`.`id` = 1666265 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` = 1657011 OR `props-main`.`id` = 1545586 OR `props-main`.`id` = 1666343 OR `props-main`.`id` = 1674570 OR `props-main`.`id` = 1677263 OR `props-main`.`id` = 1669960 OR `props-main`.`id` = 1665855 OR `props-main`.`id` = 1684086 OR `props-main`.`id` = 1671895 OR `props-main`.`id` = 1635364 OR `props-main`.`id` = 1683789 OR `props-main`.`id` = 1683749 OR `props-main`.`id` = 1683761 OR `props-main`.`id` = 1680552 OR `props-main`.`id` = 1679108 OR `props-main`.`id` = 1657743 OR `props-main`.`id` = 1683284 OR `props-main`.`id` = 1660910 OR `props-main`.`id` = 166957 OR `props-main`.`id` = 1679271 OR `props-main`.`id` = 1679701 OR `props-main`.`id` = 1673822 OR `props-main`.`id` = 1683532 OR `props-main`.`id` = 1683647 OR `props-main`.`id` = 1679719 OR `props-main`.`id` = 1683734 OR `props-main`.`id` = 1676682 OR `props-main`.`id` = 1680524 OR `props-main`.`id` = 1684501 OR `props-main`.`id` = 1671093 OR `props-main`.`id` = 1683781 OR `props-main`.`id` = 1674315 OR `props-main`.`id` = 1678847 OR `props-main`.`id` = 1678446 OR `props-main`.`id` = 1683004 OR `props-main`.`id` = 1682200 OR `props-main`.`id` = 1682228 OR `props-main`.`id` = 1667419 OR `props-main`.`id` = 1678802 OR `props-main`.`id` = 1674286 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` = 1673162 OR `props-main`.`id` = 1678663 OR `props-main`.`id` = 1675210 OR `props-main`.`id` = 166342 OR `props-main`.`id` = 1680539 OR `props-main`.`id` = 1683039 OR `props-main`.`id` = 1678120 OR `props-main`.`id` = 1265238 OR `props-main`.`id` = 1655500 OR `props-main`.`id` = 1667684 OR `props-main`.`id` = 1657510 OR `props-main`.`id` = 1680198 OR `props-main`.`id` = 1680166 OR `props-main`.`id` = 1680181 OR `props-main`.`id` = 1680195 OR `props-main`.`id` = 1680197 OR `props-main`.`id` = 1683123 OR `props-main`.`id` = 1676738 OR `props-main`.`id` = 1680164 OR `props-main`.`id` = 1658376 OR `props-main`.`id` = 1684587 OR `props-main`.`id` = 1680059 OR `props-main`.`id` = 1640971 OR `props-main`.`id` = 1677886 OR `props-main`.`id` = 1673999 OR `props-main`.`id` = 272846 OR `props-main`.`id` = 187711 OR `props-main`.`id` = 1675054 OR `props-main`.`id` = 1681637 OR `props-main`.`id` = 1659350 OR `props-main`.`id` = 1677240 OR `props-main`.`id` = 1676132 OR `props-main`.`id` = 1663877 OR `props-main`.`id` = 1674868 OR `props-main`.`id` = 1674925 OR `props-main`.`id` = 1684407 OR `props-main`.`id` = 1676739 OR `props-main`.`id` = 1664283 OR `props-main`.`id` = 1633816)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636470' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-08' 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

$619,000

4
3.5
2,777
0.24

6840 W Lucas Dr

Fresno, CA 93722

$599,900

5
3
2,863
0.16

6632 W Dovewood Ln

Fresno, CA 93723

$599,000

5
3
2,753
0.14

4542 N Casey Ave

Fresno, CA 93723

$599,000

5
3
3,141
0.18

5929 N La Paz Ave

Fresno, CA 93723

Courtesy of Layla Granata, SME Real Estate - layla@smere.com
Last modified 5 days 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

6640 W Celeste Ave

Fresno, CA 93723

Photo Gallery

$599,000

6640 W Celeste Ave

Fresno, CA 93723

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$619,000

$599,900

$599,000

$599,000