SEARCH LISTINGS SEARCH LISTINGS › 1740 W Celeste Avenue SAVE SAVE SAVED Rate this listing SHARE Print Facebook X Email SMS PendingResidential Property listed by Century 21 Select Real Estate, Myron Emerzian, 1740 W Celeste Avenue Fresno, CA 93711 Beds3Square Ft.2,891 $549,000 Listing Snapshot Days Online3Last UpdatedSep 11, 2026Property TypeSingle Family ResidenceBeds3Square Ft.2,891Lot Size0.29 AcresYear Built1966MLS Number654955 30 Days Snapshot Of 93711 $505k -21% (avg) sold price 29 -9% homes sold 66 -25% (avg) days on market SnapshotArea Map Additional Details Appliances & EquipmentBuilt In Range/Oven, Electric Appliances, Dishwasher, Other equipment: Satellite DishBuildingBuilt in 1966, Living area: 2,891, Architectural style: Ranch, Construction materials: Stucco, Block, Levels: One, 1 story, Other structures: Shed(s)CoolingCentral Heat & CoolDining RoomDining room features: FormalFenceFencedFireplacesMasonry, Zero ClearanceGarage2 spacesInterior FeaturesBuilt-in Features, Great Room, Family RoomLaundryInside, Utility RoomLot0.2925 acres, 12,741 square feet, Urban, Cul-De-Sac, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape, Fruit/Nut Trees, GardenParking2 total parkings, Garage Door Opener, On StreetPoolGunite, Grassy Area, Private, In GroundPropertyPatio and porch features: Covered, ConcreteRoofCompositionSecurity FeaturesSecurity SystemSewerPublic SewerSpaBathUtilitiesElectric: On, Public Utilities Find The Perfect Home'VIP' Listing SearchWhenever a listing hits the market that matches your criteria you will be immediately notified.Join The List Mortgage Calculator Selling priceDown paymentTerm (years)Interest rate (%)Monthly Payment$0 Cancel bookingBook a showing date Send to agent Thank you for reaching out! I will be able to read this shortly and get ahold of you so we can chat. ~ASAPSun13SepMon14SepTue15SepWed16SepThu17SepFri18SepSat19SepSun20SepMon21SepTue22SepWed23SepThu24SepFri25SepSat26SepPlease Select DateTour in personTour VirtuallyPlease Select Type Schedule A Tour Contact Myron Emerzian Schools In The Area Check out nearby schools with ratings and contact info. top rated top rated preschool elementary school middle school high school Gibson Elementary School 559-451-4500 Public KG-6 Tenaya Middle School 559-451-4570 Public 7-8 Bullard High School 559-451-4320 Public 9-12 Gibson Elementary School 559-451-4500 Public KG-6 Gibson Elementary School 559-451-4500 Public KG-6 Gibson Elementary School 559-451-4500 Public KG-6 Tenaya Middle School 559-451-4570 Public 7-8 Bullard High School 559-451-4320 Public 9-12 Similar Listings View More Listings $595,000 1335 W Celeste AvenueFresno, CA 3 Beds 2,544 Sqft $519,900 6386 N Durant AvenueFresno, CA 3 Beds 2,177 Sqft $674,500 6257 N Capri CourtFresno, CA 4 Beds 2,327 Sqft $510,000 146 W Portland AvenueFresno, CA 4 Beds 2,121 Sqft $699,000 2555 W Bluff Avenue Unit 101Fresno, CA 3 Beds 2,366 Sqft $550,000 6758 N Hazel AvenueFresno, CA 3 Beds 2,034 Sqft $475,000 6487 N Arthur AvenueFresno, CA 3 Beds 1,649 Sqft $489,000 6152 N Gentry AvenueFresno, CA 3 Beds 2,137 Sqft $609,900 5644 N Hazel AvenueFresno, CA 4 Beds 2,441 Sqft $430,000 2710 W Roberts AvenueFresno, CA 3 Beds 1,652 Sqft Listing Information © 2026 Fresno Association of REALTORS®. All Rights Reserved. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended. Confirm your time Fill in your details and we will contact you to confirm a time. Name *FirstLast Email address * Phone number What times are best for you? *MorningAfternoonEvening Feel free to leave me any additional comments or message me directly Name *FirstLast Email * Phone Comments, Questions? * Find My Dream Home Put an experts eye on your home search! You’ll receive personalized matches of results delivered direct to you. 1. Neighborhoods 2. Home Type 3. Send Preferred neighborhoods * *Property type *HomeCondoLandInvestmentCommercialOther*Bedrooms1+2+3+4+5+Bathrooms1+2+3+4+5+ First Name * Last Name * Email * Phone Import This Listing × Name This Listing I confirm that I have explicit permission, as per my contract, to import and use the data from this MLS listing. I acknowledge that I am solely responsible for any misuse of this data. Import Listing Import Completed To view your listing, click one of the options below. Try Again View Listing All Listings
