Discover the epitome of mid-century charm and modern convenience. This remarkable property combines timeless architectural design with updated amenities (INCLUDING OWNED SOLAR), offering a truly exceptional living experience. The spacious layout features 2 expansive living areas, where large windows bathe the space in natural light, creating a warm and inviting ambiance. The kitchen boasts ample counter space, and a convenient layout, making meal preparation a breeze. Step outside to discover your own private paradise, where an oversized lot offers endless opportunities for outdoor enjoyment. Additionally, the property boasts nine varieties of fruit trees, allowing you to indulge in farm-to-table living right in your own backyard. With 3 large bedrooms and 2 1/2 bathrooms, this home offers plenty of space for rest and relaxation. Each bedroom is thoughtfully designed to provide comfort and privacy, ensuring a peaceful retreat for every member of the household. Located in a desirable neighborhood with convenient access to shopping, dining, and entertainment, this home offers the perfect blend of tranquility and convenience. Don't miss the opportunity to make this mid-century masterpiece your own - schedule a tour today!
Sold
$499,999
1034 W Celeste Ave, Fresno, CA 93711
3beds
3baths
2,224sqft
Residential, Single Family Residence
Built in 1960
0.34 Acres lot
$513,400 Zestimate®
$225/sqft
$-- HOA
What's special
Zillow last checked: 7 hours ago
Listing updated: April 02, 2024 at 10:30am
Listed by:
Amanda Miller DRE #02090628 559-579-3450,
Gentile Real Estate,
Martina N. Miller DRE #02103377 559-213-4697,
Gentile Real Estate
Bought with:
Brandon Scott Bottoms, DRE #01932760
Tafoya Real Estate
Source: Fresno MLS,MLS#: 607452Originating MLS: Fresno MLS
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
Primary bedroom
- Area: 0
- Dimensions: 0 x 0
Bedroom 1
- Area: 0
- Dimensions: 0 x 0
Bedroom 2
- Area: 0
- Dimensions: 0 x 0
Bedroom 3
- Area: 0
- Dimensions: 0 x 0
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Dining room
- Area: 0
- Dimensions: 0 x 0
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Area: 0
- Dimensions: 0 x 0
Living room
- Area: 0
- Dimensions: 0 x 0
Basement
- Area: 0
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Laundry: Inside
Features
- Number of fireplaces: 2
Interior area
- Total structure area: 2,224
- Total interior livable area: 2,224 sqft
Property
Parking
- Parking features: Garage - Attached
- Has attached garage: Yes
Features
- Levels: One
- Stories: 1
Lot
- Size: 0.34 Acres
- Dimensions: 112 x 133
- Features: Urban
Details
- Parcel number: 41608314
- Zoning: R1AH
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Foundation: Concrete
- Roof: Composition
Condition
- Year built: 1960
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities
Community & neighborhood
Location
- Region: Fresno
HOA & financial
Other financial information
- Total actual rent: 0
Other
Other facts
- Listing agreement: Exclusive Right To Sell
Services availability

Get pre-qualified for a loan
At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.An equal housing lender. NMLS #10287.