Celebrating 10 years: fixed fees, full service, fast responses

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.

Save
Ask
Tour
Hide
Share
$699,000
157 Days On Site

1264 W Celeste
Fresno, CA 93711

For Sale|Single Family Residence|Active Under Contract
4
Beds
3
Total Baths
3
Full Baths
2,675
SqFt
$261
/SqFt
1958
Built
County:
Fresno
Listed by Megan Thompson of Hyatt Real Estate (559) 313-1617
Call Now: (408) 868-2620
Is this the listing for you? We can help make it yours.
(408) 868-2620
1264 W Celeste1264 W Celeste1264 W Celeste1264 W Celeste
Save
Ask
Tour
Hide
Share

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$699,000
Days On Site 
157 Days
Bedrooms 
4
Inside Area (SqFt) 
2,675 sqft
Total Baths 
3
Full Baths 
3
Partial Baths 
N/A
Lot Size 
0.3168 Acres
Year Built 
1958
MLS® Number 
FR26038825
Status 
Active Under Contract
Property Tax 
N/A
HOA/Condo/Coop Fees 
N/A
Sq Ft Source 
N/A
Friends & Family
Recent Activity
6 days agoListing updated with changes from the MLS®
6 days agoStatus changed to Active Under Contract
a month agoPrice changed to $699,000
5 months agoListing first seen on site
General Features
Garage 
Yes
Garage Spaces 
2
Number Of Stories 
1
Parking Spaces 
2
Property Sub Type 
Single Family Residence
Sewer 
Public Sewer
Special Circumstances 
Standard
SqFt Total 
2675
Water Source 
Public
Interior Features
Appliances 
DishwasherDisposalMicrowaveElectric Oven
Cooling 
Central Air
Fireplace Features 
Dining RoomFamily Room
Flooring 
CarpetTile
Heating 
Forced Air
Laundry Features 
Washer Hookup
Save
Ask
Tour
Hide
Share
Exterior Features
Pool Features 
Private
Private Pool 
Yes
Community Features
Financing Terms Available 
CashConventionalFHAVA Loan
Listed by Megan Thompson of Hyatt Real Estate (559) 313-1617



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

Neighborhood & Commute
Source: Walkscore
Disclosure: Community information and market data powered by Constellation Data Labs. Information is deemed reliable but not guaranteed.
Save
Ask
Tour
Hide
Share

*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.