NOT LISTED FOR SALE

Estimated Value: $529,356

4 Beds
2 Baths
2,048 Sq Ft
$258/Sq Ft Est. Value

Sale Details

Date Sold: April 1, 2026

Last sale price $525,000 $256 Per Sq Ft

Est. 1% increase in value since last sale

Current estimated payment $3,119 / mo

Highlights

  • Fruit Trees
  • Corner Lot
  • Covered Patio or Porch
  • 1 Fireplace
  • Mature Landscaping
  • Fenced Yard

About This Home

As of April 2026

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

Rosalva Lara

Western Pioneer Properties License #02186414 Listed on: 03/15/2026

Co-Listed By

Freddy Corona

Western Pioneer Properties License #02084326

Last Buyer's Agent

Steven Rivas

Real Brokerage Technologies License #01747709

Real Brokerage Technologies
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1975

Lot Details

  • 10,200 Sq Ft Lot
  • Lot Dimensions are 85x120
  • Fenced Yard
  • Mature Landscaping
  • Corner Lot
  • Front and Back Yard Sprinklers
  • Fruit Trees
  • Property is zoned RS4

Home Design

  • Brick Exterior Construction
  • Wood Foundation
  • Composition Roof
  • Wood Siding
  • Stucco

Interior Spaces

  • 2,048 Sq Ft Home
  • 1-Story Property
  • 1 Fireplace
  • Double Pane Windows

Kitchen

  • Oven or Range
  • Dishwasher
  • Disposal

Flooring

  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 2 Bathrooms
  • Bathtub with Shower
  • Separate Shower

Laundry

  • Laundry in Garage
  • Electric Dryer Hookup

Additional Features

  • Covered Patio or Porch
  • Central Heating and Cooling System

Home Details

Home Type

Single Family

Year Built

Built in 1975

Lot Details

10,200 Sq Ft Lot

Listing Details

  • Type: Residential
  • Property Sub Type: Single Family Residence
  • Price Per Square Foot: 256.35
  • Year Built Exception: 0
  • Unique Conditions: 1031 Exchange
  • Number Of Stories: Single Story
  • Special Features: None
  • Stories: 1
  • Year Built: 1975

Interior Features

  • Number Of Fireplaces: 1
  • Flooring: Laminate, Tile
  • Bathrooms: 2.00
  • Bedrooms: 4
  • Bathroom Features: Tub/Shower, Shower
  • Kitchen: F/S Range/Oven, Electric Appliances, Disposal, Dishwasher
  • Laundry: In Garage, Electric Hook Up
  • Square Footage: 2048.00

Exterior Features

  • Yard: Sprinklers Front, Sprinklers Back, Fenced, Mature Landscape, Fruit/Nut Trees
  • Roofing: Composition
  • Exterior: Stucco, Wood, Brick
  • Foundation: Wood Subfloor
  • Patio: Covered
  • Pool: No

Utilities

  • Heating And Cooling: Central Heat & Cool
  • Gas And Electric: Public Utilities
  • Sewer/Water: Public Water, Public Sewer

Condo/Co-op/Association

  • Association: Fresno MLS

Association/Amenities

  • Site Amenities: Corner

Lot Info

  • Acres: 0.2342
  • Lot Dimensions: 85X120
  • Lot Measurement: Square Feet
  • Lot Size Sq Ft: 10200.00
  • Price Per Acre: 2241673.78

Green Features

  • Energy Efficiency: Dual Pane Windows

Building Info

  • Year Built: 1975

MLS Schools

  • School District 2: Fresno Unified
  • School Type: High School
  • School Name: Bullard
  • School Type: Junior High School
  • School Name: Tenaya
  • School Type: Grade School
  • School Name: Figarden

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 15, 2026
Closed on
Mar 25, 2026
Sold by
Bought by
Seller's Agent
Rosalva Lara
Western Pioneer Properties
Buyer's Agent
Steven Rivas
Real Brokerage Technologies
List Price
$549,000
Sold Price
$525,000
Premium/Discount to List
-$24,000
-4.37%
Views
4
Current Estimated Value
$529,356

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$4,356
Avg. Annual Appreciation
2.46%

Purchase Details

Closed on
Aug 28, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 27, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 26, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 25, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 24, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 23, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 22, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 21, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 20, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 19, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 18, 2011
Sold by
Bought by

Purchase Details

Closed on
Aug 16, 2011
Sold by
Bought by
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Fig Garden Loop, CA

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$525,000 Placer Title Company
-- None Available
-- None Available
-- None Available
-- None Available
-- None Available
-- None Available
-- None Available
-- None Available
-- None Available
-- None Available
-- None Available
-- None Available
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
Source: Fresno MLS

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Fresno MLS

MLS Number: 645417

Fresno MLS

APN: 415-382-24

Your Personal Tour Guide

Ask me questions while you tour the home.