Welcome to 3045 W Celeste Ave, a warm and inviting 4-bedroom, 2-bathroom home with 2,048 sq. ft. of comfortable living space. Thoughtfully remodeled, this home offers not just one but two spacious living rooms, giving plenty of room to gather with loved ones or enjoy quiet evenings at home. The kitchen and living areas flow easily, making everyday living both functional and welcoming.
Set on a generous 10,200 sq. ft. lot, the backyard is a true retreat with mature landscaping and fruit treesperfect for morning coffee, family barbecues, or simply enjoying Fresno's sunny days. Recent upgrades include a brand-new HVAC system and water heater, ensuring comfort and peace of mind for years to come.
With its charming curb appeal, updated finishes, and cozy atmosphere, this move-in ready home is the perfect place to create lasting memories.
Sold for $525,000
$525,000
3045 W Celeste Ave, Fresno, CA 93711
4beds
2baths
2,048sqft
Residential, Single Family Residence
Built in 1975
10,201.75 Square Feet Lot
$522,900 Zestimate®
$256/sqft
$2,566 Estimated rent
Home value
$522,900
$476,000 - $575,000
$2,566/mo
Zestimate® history
Owner options
List your home for rent
$2,566/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,566/mo
Rent Zestimate®
Refinance and save
$3,339/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,339/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Rosalva Lara DRE #02186414 559-296-4704,
Western Pioneer Properties,
Freddy Corona DRE #02084326 559-668-1761,
Western Pioneer Properties
Bought with:
Steven E. Rivas, DRE #01747709
Real Broker
Source: Fresno MLS,MLS#: 645417Originating MLS: Fresno MLS
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
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
Bathroom
- Features: Tub/Shower, Shower
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
- Included: F/S Range/Oven, Electric Appliances, Disposal, Dishwasher
- Laundry: In Garage, Electric Dryer Hookup
Features
- Flooring: Laminate, Tile
- Windows: Double Pane Windows
- Number of fireplaces: 1
Interior area
- Total structure area: 2,048
- Total interior livable area: 2,048 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered
- Fencing: Fenced
Lot
- Size: 10,201 sqft
- Dimensions: 85 x 120
- Features: Urban, Corner Lot, Sprinklers In Front, Sprinklers In Rear, Mature Landscape, Fruit/Nut Trees
Details
- Parcel number: 41538224
- Zoning: RS4
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Residential, Single Family Residence
Materials
- Stucco, Wood Siding, Brick
- Foundation: Wood Subfloor
- Roof: Composition
Condition
- Year built: 1975
Utilities & green energy
- Electric: On
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities
Community & neighborhood
Location
- Region: Fresno
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Government,Conventional,Cash,1031 Exchange
Price history
| Date | Event | Price |
|---|---|---|
| 4/1/2026 | Sold | $525,000-4.4%$256/sqft |
Source: Fresno MLS #645417 Report a problem | ||
| 3/16/2026 | Pending sale | $549,000+3.8%$268/sqft |
Source: Fresno MLS #645417 Report a problem | ||
| 2/6/2026 | Listing removed | $529,000$258/sqft |
Source: Fresno MLS #637421 Report a problem | ||
| 1/8/2026 | Price change | $529,000-2.9%$258/sqft |
Source: Fresno MLS #637421 Report a problem | ||
| 11/7/2025 | Price change | $544,900-4.2%$266/sqft |
Source: Fresno MLS #637421 Report a problem | ||
| 9/22/2025 | Listed for sale | $569,000$278/sqft |
Source: Fresno MLS #637421 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $2,556 +3.9% | $195,898 +2% |
| 2024 | $2,459 +1.9% | $192,058 +2% |
| 2023 | $2,412 +1.4% | $188,293 +2% |
| 2022 | $2,379 +2.8% | $184,602 +2% |
| 2021 | $2,314 +0.4% | $180,983 +1% |
| 2020 | $2,304 +4% | $179,128 +2% |
| 2019 | $2,216 +2.2% | $175,616 +2% |
| 2018 | $2,168 +1.7% | $172,174 +2% |
| 2017 | $2,131 +3.4% | $168,799 +2% |
| 2016 | $2,061 +1.5% | $165,490 +1.5% |
| 2015 | $2,029 +2% | $163,005 +2% |
| 2014 | $1,989 | $159,813 +0.5% |
| 2013 | -- | $159,092 +2% |
| 2012 | -- | $155,974 +2% |
| 2011 | -- | $152,917 +0.8% |
| 2010 | -- | $151,776 -0.2% |
| 2009 | -- | $152,138 +2% |
| 2008 | -- | $149,156 +2% |
| 2007 | -- | $146,233 +2% |
| 2006 | -- | $143,367 +2% |
| 2005 | -- | $140,557 +2% |
| 2004 | -- | $137,802 +1.9% |
| 2003 | -- | $135,277 +2% |
| 2002 | -- | $132,625 +2% |
| 2001 | $1,579 | $130,025 |
Find assessor info on the county website
Neighborhood: Bullard
Nearby schools
GreatSchools rating
- 4/10Figarden Elementary SchoolGrades: K-6Distance: 1.1 mi
- 3/10Tenaya Middle SchoolGrades: 7-8Distance: 1.8 mi
- 6/10Bullard High SchoolGrades: 9-12Distance: 1.9 mi
Schools provided by the listing agent
- Elementary: Figarden
- Middle: Tenaya
- High: Bullard
Source: Fresno MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$522,900
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$522,900
- California
- Fresno County
- Fresno
- 93711
- Bullard
- 3045 W Celeste Ave
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Fresno Topics
