R
Seller's Agent in 2026
Rosalva Lara
Western Pioneer Properties
(559) 296-4704
2 in this area
25 Total Sales
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.
Last Agent to Sell the Property
Western Pioneer Properties License #02186414 Listed on: 03/15/2026
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Grant Deed | $525,000 | Placer Title Company | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available |
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 04/01/2026 04/01/26 | Sold | $525,000 | -4.4% | $256 / Sq Ft |
| 03/15/2026 03/15/26 | Pending | -- | -- | -- |
| 03/15/2026 03/15/26 | For Sale | $549,000 | -- | $268 / Sq Ft |
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $2,556 | $195,898 | $55,173 | $140,725 |
| 2023 | $2,412 | $188,293 | $53,032 | $135,261 |
| 2022 | $2,379 | $184,602 | $51,993 | $132,609 |
| 2021 | $2,314 | $180,983 | $50,974 | $130,009 |
| 2020 | $2,304 | $179,128 | $50,452 | $128,676 |
| 2019 | $2,216 | $175,616 | $49,463 | $126,153 |
| 2018 | $2,168 | $172,174 | $48,494 | $123,680 |
| 2017 | $2,131 | $168,799 | $47,544 | $121,255 |
| 2016 | $2,061 | $165,490 | $46,612 | $118,878 |
| 2015 | $2,029 | $163,005 | $45,912 | $117,093 |
| 2014 | $1,989 | $159,813 | $45,013 | $114,800 |
R
Seller's Agent in 2026
Rosalva Lara
Western Pioneer Properties
(559) 296-4704
2 in this area
25 Total Sales
Seller Co-Listing Agent in 2026
Freddy Corona
Western Pioneer Properties
(559) 668-1761
2 in this area
45 Total Sales
S
Buyer's Agent in 2026
Steven Rivas
Real Broker
(559) 360-4434
1 in this area
19 Total Sales
Source: Fresno MLS
MLS Number: 645417
APN: 415-382-24
Ask me questions while you tour the home.