x
Showing 1 of 0
X
Save

4712 W Celeste Avenue
Fresno CA 93722 US

$515,000

Active Listing ID 636696
bed icon
4 bed
bath icon
3.00 Bath (3 Full)
lot icon
Lot: 0.15 Acres
home icon
Single Family Residence

$515,000

Active Listing ID 636696
Save

4712 W Celeste Avenue

Beautiful Home in Northwest Fresno

2468 SF Living Space on a 6500 SF Spacious Lot

Located 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 Master 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.15 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • Cooling System: Central Air
  • Exterior Finish: Wood, Other
  • Roof Type: Composition
  • Heating Fuels: Central

School Information

  • School
  • Lawless(Elementary)
  • Tenaya(MiddleSchool)
  • Bullard(HighSchool)

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 515000
  • unparsedaddress: 4712 W Celeste Avenue
  • postalcity: Fresno
  • stateorprovince: CA
  • country: US
  • postalcode: 93722
  • bathroomsfull: 3
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.1492
  • lotsizeunits: Acres
  • lotsizearea: 0.1492
  • livingarea: 2468
  • livingareaunits: Square Feet
  • latitude: 36.82094
  • longitude: -119.878408
  • listagentfullname: Khushvinder Kaur
  • listagentemail: marketing@remaxgold.com
  • listagentkey: 3yd-FARCA-19868
  • listagentmlsid: 19868
  • listagentpreferredphone: (916) 218-6700
  • listofficekey: 3yd-FARCA-2124
  • listofficemlsid: 2124
  • disclaimer: Copyright © 2025 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: FARCA
  • yearbuilt: 2005
  • listingcontractdate: 2025-09-07
  • listagenturl: http://remax.net
  • countyorparish: Fresno
  • parcelnumber: 509320046
  • highschooldistrict: Fresno Unified
  • cooling: Central Air
  • heating: Central
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 0
  • roof: Composition
  • waterfrontyn: False
  • franchiseaffiliation: RE/MAX International
  • exteriorfeatures: Wood
  • rooms: Bathroom 1, Bedroom 1, Bathroom 3, Bedroom 3, Bedroom 2, Bathroom 2, Bedroom 4
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -119.87841, 36.82094
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"RE/MAX Gold", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"marketing@remaxgold.com", "ListBrokerageCity":null, "ListBrokerageCountry":null, "ListBrokerageEmail":"marketing@remaxgold.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/FARCA/a00d45e0d8cb11e09b5800219b9aa4d8/20160802201759587.png", "ListBrokerageName":"RE/MAX Gold", "ListBrokeragePhone":"(916) 218-6700", "ListBrokeragePostalCode":null, "ListBrokerageStateOrProvince":null, "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":null, "ListBrokerageWebsiteUrl":"http://remax.net", "ListOfficeAddress1":"7815 N PALM AVE Suite 120 ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"2124", "ListOfficeCity":"Fresno", "ListOfficeCountry":"USA", "ListOfficeEmail":"marketing@remaxgold.com", "ListOfficePostalCode":"93711", "ListOfficeStateOrProvince":"CA", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Fresno, CA", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/4712-W-Celeste-Ave_Fresno_CA_93722_M19324-64200?f=listhub&s=FARCA&m=636696&c=rexren", "MLSModificationTimestamp":"2025-10-31 19:00:49", "Neighborhoods":[{"Description":null, "Name":"722"}], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 12/11/2025 4:16:52 PM GMT
Source Updated Date: 12/17/2025 1:04:02 PM GMT

Courtesy of: Khushvinder Kaur, RE/MAX Gold, marketing@remaxgold.com

Copyright © 2025 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.