Property search · The Consumer Protection Brokerage
Every listing shows your estimated rebate.
The green number on each home is what could come back to you: the buyer-broker fee (typically 2 to 3%) minus our flat $9,750. No other search shows you this, because no other brokerage gives it back.
1264 W CelesteFresno, CA 93711




Welcome to 1264 W. Celeste Ave a stunning, light-filled Mid-Century Modern home nestled in one of Fresno's most sought-after neighborhoods. Offering 2,675 square feet, 4 bedrooms, and 2.75 baths, this exceptional property has been thoughtfully updated while preserving its timeless architectural charm. Beamed tongue-and-groove ceilings, skylights, and expansive walls of glass create a seamless connection between indoor and outdoor living. Step inside to a grand living space bathed in natural light, featuring oversized picture windows, a natural gas fireplace, and serene views in every direction. Designed to be the heart of the home, the spacious kitchen offers a breakfast bar, modern appliances, open shelving, a walk-in pantry, and original Old Fresno'' tile. From here, you'll enjoy a bird's-eye view of both living areas and the sparkling pool beyond. The dining room provides a warm and inviting setting to gather and unwind, complete with a wood-burning fireplace and built-in shelving.Retreat to the expansive primary suite, where a spa-like ambiance awaits. This private sanctuary features a beautifully updated bath, multiple closets, French doors leading to the backyard, and its own split-unit heating and cooling system for personalized comfort. Additional generously sized bedrooms offer ample closet space and picturesque views of the outdoor landscape. Outside, your California lifestyle comes to life. Take a refreshing dip in the large pool beneath mature shade trees, host dinners al fresco on the patio, or cultivate your farm-to-table dreams with a raised garden bed and fruit from multiple trees, including: orange, tangelo, grapefruit, meyer lemon, lime, guava, mandarinquat, loquat, nectarine, peach, pomegranate (landscape maps are included with the sale). Situated on a spacious lot in a premier Fresno location, this home perfectly captures the essence of relaxed, sophisticated California living.
| 6 days ago | Listing updated with changes from the MLS® | |
| 6 days ago | Status changed to Active Under Contract | |
| a month ago | Price changed to $699,000 | |
| 5 months ago | Listing first seen on site |
This information is deemed reliable but not guaranteed. You should rely on this information only to decide whether or not to further investigate a particular property. BEFORE MAKING ANY OTHER DECISION, YOU SHOULD PERSONALLY INVESTIGATE THE FACTS (e.g. square footage and lot size) with the assistance of an appropriate professional. You may use this information only to identify properties you may be interested in investigating further. All uses except for personal, non-commercial use in accordance with the foregoing purpose are prohibited. Redistribution or copying of this information, any photographs or video tours is strictly prohibited. This information is derived from the Internet Data Exchange (IDX) service provided by San Diego MLS®. Displayed property listings may be held by a brokerage firm other than the broker and/or agent responsible for this display. The information and any photographs and video tours and the compilation from which they are derived is protected by copyright. Copyright © 2026 San Diego MLS®.
Last checked 2026
*Estimate only. Actual rebate may vary based on final price, lender requirements, MLS rules, and broker policies.
Found a home you love?
Schedule a free consultation to lock in your rebate before you offer.
Calls and texts are answered by Amy, our AI assistant, who can answer questions and help you book.
Did you know? You can invite friends and family to your search. They can join your search, rate and discuss listings with you.