Off Market1659d on market
150 W Celeste Ave
Fresno, CA, 93704 • Bullard • Fresno County
$412,900
$210/sqft
3Beds
1.5Baths
1,962Sqft
0.21 acLot
1956Built
This home is getting attention
Listed 1659 days ago
Market activity
Demand and pricing signals for this listing
1659 days on market
Established listing
$210/sqft
Price per square foot
Selling Soon Prediction
HighThis home ranks in the top 11% of listings most likely to go under contract soon, based on market activity and demand signals.
Likelihood score
Want the full market analysis?
Get the detailed selling prediction score, comparable sales data, and price trend forecast for this property.
Free · Delivered to your inbox in minutes
About this home
Single Family · Built 1956
This 1962 square foot single family home has 3 bedrooms and 1.5 bathrooms. This home is located at 150 W Celeste Ave, Fresno, CA 93704.
Standout features identified
Our analysis highlights backyard and open floor plan as key attractions of this home.
Estimated monthly payment
Based on current rates
$2,572/month
Principal & Interest$2,021
Property Tax$413
Insurance$138
Down payment20% ($82,580)
3%50%
Est. 6.19% rate · 30yr fixed · $330,320 loan
Full calculator →At a glance
Key facts and listing details
TypeSingleFamily
Year Built1956
HeatingForced air
CoolingCentral
Parking2 Parking spaces
Lot9,286 sqft
Property
Home typeSingle Family
Year built1956
Systems
HeatingForced air
CoolingCentral
RoofComposition
Constructionwood frame
Parking & Outdoor
ParkingGarage - Attached
Lot9,286 sqft
Location & Tax
NeighborhoodBullard
Annual tax$4,954
Parcel41610213
Features & details
8 categories of property features
Interior Features
Appliances
Dishwasher
Garbage disposal
Microwave
Range / Oven
Flooring
Concrete
Heating
Forced air
Cooling
Central
Laundry
Inside
Exterior Features
Exterior
Stucco
Brick
Parking
Garage - Attached
Construction
wood frame
Listing insights
Market data and value estimates
StatusOff Market
Days on market1659
Est. value$412,900
Est. rent$2,226/mo
Tax rate1.21%
Price/sqft$210
Last sold$360,000
Tour days6
How are the schools in Fresno?
3 schools rated nearby
Location
Fresno, CA, 93704
Price history
11 events
DateEventPrice$/sqftSource
Sep 20, 2021Sold$360,000$183Public Record
Aug 13, 2021Pending Sale$360,000$183Fresno MLS
Aug 12, 2021Listing Removed——Fresno MLS
Jul 30, 2021Listed For Sale$360,000$183Fresno MLS
Mar 9, 2018Sold$277,000$141Public Record
Feb 2, 2018Pending Sale$278,900$142CENTURY 21 C. Watson
Jan 29, 2018Price Change$278,900$142CENTURY 21 C. Watson
Dec 26, 2017Listed For Sale$279,900$143C-21 C Watson Real Estate Inc.
Sep 21, 2017Sold$180,000$92Public Record
Sep 6, 2017Price Change$199,500$102Realty Concepts, Ltd
Aug 15, 2017Listed For Sale$215,000$110Realty Concepts, Ltd
Sold$360,000
Sep 20, 2021•$183/sqft•Public Record
Pending Sale$360,000
Aug 13, 2021•$183/sqft•Fresno MLS
Listing Removed—
Aug 12, 2021•Fresno MLS
Listed For Sale$360,000
Jul 30, 2021•$183/sqft•Fresno MLS
Sold$277,000
Mar 9, 2018•$141/sqft•Public Record
Pending Sale$278,900
Feb 2, 2018•$142/sqft•CENTURY 21 C. Watson
Price Change$278,900
Jan 29, 2018•$142/sqft•CENTURY 21 C. Watson
Listed For Sale$279,900
Dec 26, 2017•$143/sqft•C-21 C Watson Real Estate Inc.
Sold$180,000
Sep 21, 2017•$92/sqft•Public Record
Price Change$199,500
Sep 6, 2017•$102/sqft•Realty Concepts, Ltd
Listed For Sale$215,000
Aug 15, 2017•$110/sqft•Realty Concepts, Ltd
Tax history
25 years of records
YearTax paidAssessed value
Apr 7, 2025$4,954$382,034
Apr 7, 2024$4,765$374,544
Apr 7, 2023$4,674$367,200
Apr 7, 2022$4,610$360,000
Apr 7, 2021$3,702$291,175
Apr 7, 2020$3,686$288,190
Apr 7, 2019$3,544$282,540
Apr 7, 2018$2,260$180,000
Apr 7, 2017$809$63,192
Apr 7, 2016$782$61,954
Apr 7, 2015$771$61,024
Apr 7, 2014$757$59,829
Apr 7, 2013—$59,560
Apr 7, 2012—$58,393
Apr 7, 2011—$57,249
Apr 7, 2010—$56,822
Apr 7, 2009—$56,958
Apr 7, 2008—$55,842
Apr 7, 2007—$54,748
Apr 7, 2006—$53,676
Apr 7, 2005—$49,193
Apr 7, 2004—$48,230
Apr 7, 2003—$47,347
Apr 7, 2002—$46,420
Apr 7, 2001$482$45,511
Nearby homes
Neighborhood details
Local context around this listing
Fresno, CA • Fresno County
Nearby neighborhoods
BullardCentralEdisonFresno High RoedingHooverMclaneRooseveltSoutheast Growth AreaWestWoodward Park
Nearby cities
ClovisCoalingaFirebaughFresnoKermanKingsburgParlierReedley
Nearby zip codes
93702937039370593706937109371193720937229372693727
Similar homes
No obligation · Same-day response