$484,900
PENDING

Estimated payment $2,837/month

Total Views 1,022
4 Beds
2.5 Baths
2,174 Sq Ft
$223 Price per Sq Ft

Highlights

  • Ranch Style House
  • Eat-In Kitchen
  • Bathtub with Shower
  • Covered Patio or Porch
  • Double Pane Windows
  • Central Heating and Cooling System

About This Home

Discover the opportunity to create something truly special at 645 W Celeste Avenue in one of Fresno's most desirable established neighborhoods off Palm Avenue and Bullard Avenue. This spacious 4-bedroom, 2.5-bath Mid-Century Ranch offers 2,174 square feet of living space on an impressive 13,132 square foot lotproviding the kind of outdoor space that's increasingly difficult to find in newer homes today.Whether you're dreaming of designing the ultimate Mid-Century Modern showpiece or simply looking for a home with room to grow, this property offers endless possibilities. The oversized lot provides ample space for entertaining, gardening, future enhancements, and even potential boat or small RV parking.This incredible home offers convenient access to shopping, dining, and entertainment at both River Park and Campus Pointe at Fresno State. With its classic architectural character, generous floor plan, and exceptional lot size, this is a rare opportunity for buyers to personalize a home while building equity in a highly sought-after location. Bring your vision and unlock the incredible potential this property has to offer.

Listing Agent

David Mitchell

Gate12 Real Estate License #01948429 Listed on: 06/12/2026

Co-Listing Agent

Linda Mitchell

Gate12 Real Estate License #01902398

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1963

Lot Details

  • 13,132 Sq Ft Lot
  • Lot Dimensions are 98x134
  • Front and Back Yard Sprinklers
  • Property is zoned RA

Home Design

  • Ranch Style House
  • Wood Foundation
  • Composition Roof
  • Stucco

Interior Spaces

  • 2,174 Sq Ft Home
  • Fireplace Features Masonry
  • Double Pane Windows
  • Laundry in unit

Kitchen

  • Eat-In Kitchen
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Carpet
  • Vinyl

Bedrooms and Bathrooms

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

Additional Features

  • Covered Patio or Porch
  • Central Heating and Cooling System

Home Details

Home Type

Single Family

Year Built

Built in 1963

Lot Details

0.3 Acres

Listing Details

  • Type: Residential
  • Property Sub Type: Single Family Residence
  • Style: Ranch
  • Price Per Square Foot: 223.05
  • Year Built Exception: 0
  • Number Of Stories: Single Story
  • Special Features: None
  • Stories: 1
  • Year Built: 1963

Interior Features

  • Fireplace Type: Masonry
  • Number Of Fireplaces: 1
  • Flooring: Carpet, Vinyl
  • Bathrooms: 2.25
  • Bedrooms: 4
  • Bathroom Features: Tub/Shower, Shower
  • Kitchen: Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area
  • Laundry: Inside
  • Square Footage: 2174.00

Exterior Features

  • Yard: Sprinklers Front, Sprinklers Back, Sprinklers Auto
  • Roofing: Composition
  • Exterior: Stucco
  • Foundation: Wood Subfloor
  • Patio: Covered, Screened
  • Pool: No

Garage/Parking

  • Parking Features: Potential RV Parking

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

Lot Info

  • Acres: 0.3015
  • Lot Dimensions: 98X134
  • Lot Measurement: Square Feet
  • Lot Size Sq Ft: 13132.00
  • Price Per Acre: 1608291.87

Green Features

  • Energy Efficiency: Dual Pane Windows

Building Info

  • Year Built: 1963

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: Kratt

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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 Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

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,800 $227,290 $65,829 $161,461
2023 $2,637 $218,467 $63,274 $155,193
2022 $2,600 $214,184 $62,034 $152,150
2021 $2,527 $209,985 $60,818 $149,167
2020 $2,515 $207,833 $60,195 $147,638
2019 $2,416 $203,759 $59,015 $144,744
2018 $2,362 $199,764 $57,858 $141,906
2017 $2,320 $195,848 $56,724 $139,124
2016 $2,241 $192,009 $55,612 $136,397
2015 $2,205 $189,126 $54,777 $134,349
2014 $2,161 $185,422 $53,704 $131,718
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
07/05/2026 07/05/26 Pending -- -- --
07/01/2026 07/01/26 For Sale $484,900 0.0% $223 / Sq Ft
06/17/2026 06/17/26 Pending -- -- --
06/12/2026 06/12/26 For Sale $484,900 -- $223 / Sq Ft
Source: Fresno MLS

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 Type Sale Price Title Company
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Interfamily Deed Transfer -- None Available
Grant Deed $145,000 Stewart Title
Source: Public Records

Mortgage 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 Status Loan Amount Loan Type
Open $116,000 No Value Available
Source: Public Records

Source: Fresno MLS

MLS Number: 650376

Fresno MLS

APN: 416-153-03

Your Personal Tour Guide

Ask me questions while you tour the home.