x
Showing 1 of 0
X
Save

4712 Celeste Avenue W
Fresno CA 93722 US

$520,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

$520,000

Active Listing ID 636696
Save

4712 Celeste Avenue W 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 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

School Information

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

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 520000
  • unparsedaddress: 4712 Celeste Avenue W
  • 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: 0
  • longitude: 0
  • listagentfullname: Khushvinder Kaur
  • listagentemail: expcaone@gmail.com
  • listagentkey: 3yd-FARCA-19868
  • listagentmlsid: 19868
  • listagentpreferredphone: 3855427
  • listagentofficephone: 5593670200
  • 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
  • elementaryschool: Lawless
  • highschool: Bullard
  • elementaryschooldistrict: Fresno Unified
  • middleorjuniorschooldistrict: Fresno Unified
  • highschooldistrict: Fresno Unified
  • cooling: Central Air
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 2
  • parkingfeatures: Garage, Garage - Attached
  • roof: Composition
  • waterfrontyn: False
  • franchiseaffiliation: RE/MAX International
  • exteriorfeatures: Wood, Other
  • architecturalstyle: Other
  • rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Kitchen, Living Room
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: 0, 0
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"RE/MAX Gold", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"expcaone@gmail.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":null, "ListOfficeCity":"Fresno", "ListOfficeCountry":"US", "ListOfficeEmail":"marketing@remaxgold.com", "ListOfficePostalCode":"93711", "ListOfficeStateOrProvince":"CA", "ListPriceCurrencyType":"USD", "ListingTitle":"Single Family Residence - 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-12T13:17:59Z", "Neighborhoods":[], "PostalCode":null, "RawPropertySubType":"Single Family Residence", "RawPropertyType":"Residential", "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 10/12/2025 8:02:30 PM GMT
Source Updated Date: 12/5/2025 6:45:57 AM GMT

Courtesy of: Khushvinder Kaur, RE/MAX Gold, expcaone@gmail.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.