SEARCH LISTINGS Next open house › Jul 19th from 1PM to 4PM SAVE SAVE SAVED Rate this listing SHARE Print Facebook X Email SMS ActiveResidential Property listed by Realty Concepts, Ltd. - Fresno, Gregory Kosareff, 2315 W Celeste Avenue Fresno, CA 93711 Beds3Square Ft.3,090 $889,900 Listing Snapshot Days Online77Last UpdatedJul 17, 2025Property TypeSingle Family ResidenceBeds3Square Ft.3,090Lot Size0.43 AcresYear Built1965MLS Number629475 30 Days Snapshot Of 93711 $552k 0% (avg) sold price 38 +15% homes sold 63 -1% (avg) days on market SnapshotArea Map Additional Details Windows"Skylight(s)", "Double Pane Windows"Appliances & Equipment"Built In Range/Oven", "Gas Appliances", "Electric Appliances", "Disposal", "Dishwasher", "Microwave", "Refrigerator", "Wine Refrigerator"BuildingBuilt in 1965, Living area: 3,090, Construction materials: "Stucco", Levels: "One", 1 story, Other structures: "Shed(s)"Cooling"Central Heat & Cool"Dining RoomDining room features: "Formal"Fence"Fenced"Fireplaces"Masonry", "Gas"Garage2 spacesInterior Features"Isolated Bathroom", "Office", "Family Room"Laundry"Inside", "Utility Room"Lot0.429 acres, 18,687 square feet, "Urban", "Corner Lot", "Sprinklers In Front", "Sprinklers In Rear", "Sprinklers Auto"Parking"Potential RV Parking", "Garage Door Opener", "Circular Driveway"Pool"Gunite", "Heated", "Private", "In Ground"PropertyPatio and porch features: "Covered", "Concrete", Zoning: R1BRoof"Tile"Security Features"Security System"Sewer"On", "Public Sewer"Spa"In Ground"UtilitiesElectric: "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$5,479 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. ~PreviousASAPFri18JulSat19JulSun20JulMon21JulTue22JulWed23JulThu24JulFri25JulSat26JulSun27JulMon28JulTue29JulWed30JulThu31JulNextPlease Select DateTour in personTour VirtuallyPlease Select Type Schedule A Tour Contact Gregory Kosareff Schools In The Area Check out nearby schools with ratings and contact info. top rated top rated preschool elementary school middle school high school Malloch Elementary School 559-451-4530 Public PK-6 Tenaya Middle School 559-451-4570 Public 7-8 Bullard High School 559-451-4320 Public 9-12 Malloch Elementary School 559-451-4530 Public PK-6 Malloch Elementary School 559-451-4530 Public PK-6 Malloch Elementary School 559-451-4530 Public PK-6 Tenaya Middle School 559-451-4570 Public 7-8 Bullard High School 559-451-4320 Public 9-12 Similar Listings View More Listings $869,500 2331 W Celeste AvenueFresno, CA 3 Beds 2,780 Sqft $741,000 3715 W Birch AvenueFresno, CA 3 Beds 2 Baths 2,456 Sqft $799,900 5309 N Parrish WayFresno, CA 3 Beds 2,722 Sqft $950,000 7664 N Kavanagh AvenueFresno, CA 6 Beds 4,395 Sqft $750,000 2555 W Bluff Avenue Unit 132Fresno, CA 3 Beds 2,528 Sqft $795,000 2805 W Spruce AvenueFresno, CA 4 Beds 2,830 Sqft $829,000 3767 W Spruce AvenueFresno, CA 3 Beds 2,741 Sqft $869,000 2640 W Tenaya WayFresno, CA 4 Beds 2,844 Sqft $869,000 2640 Tenaya WayFresno, CA 4 Beds 2 Baths 2,844 Sqft $825,000 3547 W Locust AvenueFresno, CA 4 Beds 3,565 Sqft $869,500 2331 W Celeste AvenueFresno, CA 3 Beds 2,780 Sqft $741,000 3715 W Birch AvenueFresno, CA 3 Beds 2 Baths 2,456 Sqft $799,900 5309 N Parrish WayFresno, CA 3 Beds 2,722 Sqft $950,000 7664 N Kavanagh AvenueFresno, CA 6 Beds 4,395 Sqft $750,000 2555 W Bluff Avenue Unit 132Fresno, CA 3 Beds 2,528 Sqft $795,000 2805 W Spruce AvenueFresno, CA 4 Beds 2,830 Sqft $829,000 3767 W Spruce AvenueFresno, CA 3 Beds 2,741 Sqft $869,000 2640 W Tenaya WayFresno, CA 4 Beds 2,844 Sqft $869,000 2640 Tenaya WayFresno, CA 4 Beds 2 Baths 2,844 Sqft $825,000 3547 W Locust AvenueFresno, CA 4 Beds 3,565 Sqft $869,500 2331 W Celeste AvenueFresno, CA 3 Beds 2,780 Sqft $741,000 3715 W Birch AvenueFresno, CA 3 Beds 2 Baths 2,456 Sqft $799,900 5309 N Parrish WayFresno, CA 3 Beds 2,722 Sqft Listing Information © 2025 Fresno Association of REALTORS®. All Rights Reserved. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended. 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 Want to take a tour of this property? You won't want to miss touring this property! Register today to receive updates and reminders. 1 Days 18 Hours 22 Minutes *07/19 - Saturday - at 1:00PM to 4:00PM Your name * Email address * Feel free to leave me any additional comments... I want to receive reminders via email and SMS about attending this open house.