When we saw 1784 W. Celeste Ave for the first time we were BLOWN away! The upscale designer features of this Mid-Century home are exquisite. The careful attention to detail, nothing was missed. When you walk through the doors of this home, you will see for yourself. From the quality of the windows, kitchen, handmade fireplace mantel, and barn doors throughout, to the detail of the kitchen tile backsplash, this is a designer showpiece. And, don't forget the simply gorgeous GE Caf appliances, this is a home even the most discerning would be proud of. Everything has been updated, from the flooring, kitchen and bathroom cabinets, and quartz counters throughout to light fixtures and water fixtures. The backyard is set for entertaining with parking on the West side for a boat, utility trailer, or additional cars as well as parking on the East side accessed via an electric gate. Schedule your showing right away on this exclusive home. It's Time to Stop Searching and Start Living the GoodLife!
Sold for $645,000
$645,000
1784 W Celeste Ave, Fresno, CA 93711
5beds
3baths
2,350sqft
Residential, Single Family Residence
Built in 1967
0.28 Acres Lot
$659,100 Zestimate®
$274/sqft
$2,988 Estimated rent
Home value
$659,100
$626,000 - $692,000
$2,988/mo
Zestimate® history
Owner options
List your home for rent
$2,988/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$2,988/mo
Rent Zestimate®
Refinance and save
$4,183/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$4,183/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:
Lydia Mitchell DRE #01902398 559-272-9193,
Gate12 Real Estate,
David Todd Mitchell DRE #01948429 559-281-6493,
Gate12 Real Estate
Bought with:
Lucy Salazar, DRE #01269446
RE/MAX Gold
Alexander E. Salazar, DRE #01723956
RE/MAX Gold
Source: Fresno MLS,MLS#: 610049Originating MLS: Fresno MLS
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
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
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
- Laundry: Inside
Features
- Isolated Bedroom, Isolated Bathroom
- Flooring: Carpet, Tile, Vinyl
- Windows: Double Pane Windows
- Number of fireplaces: 1
- Fireplace features: Masonry
Interior area
- Total structure area: 2,350
- Total interior livable area: 2,350 sqft
Property
Parking
- Parking features: Garage - Attached
- Has attached garage: Yes
Features
- Levels: One
- Stories: 1
- Patio & porch: Covered
- Fencing: Fenced
Lot
- Size: 0.28 Acres
- Features: Urban, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape, Drip System
Details
- Additional structures: Shed(s)
- Parcel number: 41605301
- Zoning: RS4
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Mid-Century Modern
- Property subtype: Residential, Single Family Residence
Materials
- Stucco, Wood Siding
- Foundation: Wood Subfloor
- Roof: Composition
Condition
- Year built: 1967
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities
Community & HOA
Location
- Region: Fresno
Financial & listing details
- Price per square foot: $274/sqft
- Tax assessed value: $657,900
- Annual tax amount: $8,522
- Date on market: 3/28/2024
- Cumulative days on market: 33 days
- Listing agreement: Exclusive Right To Sell
Price history
| Date | Event | Price |
|---|---|---|
| 6/5/2024 | Sold | $645,000-0.8%$274/sqft |
Source: Fresno MLS #610049 Report a problem | ||
| 5/1/2024 | Pending sale | $649,900$277/sqft |
Source: Fresno MLS #610049 Report a problem | ||
| 3/28/2024 | Listed for sale | $649,900+0.8%$277/sqft |
Source: Fresno MLS #610049 Report a problem | ||
| 8/20/2021 | Sold | $645,000-0.8%$274/sqft |
Source: Public Record Report a problem | ||
| 7/8/2021 | Pending sale | $649,900$277/sqft |
Source:  Fresno MLS #560011 Report a problem | ||
| 7/7/2021 | Price change | $649,900-0.8%$277/sqft |
Source: Fresno MLS #560011 Report a problem | ||
| 6/16/2021 | Listed for sale | $655,000-2.9%$279/sqft |
Source: Fresno MLS #560011 Report a problem | ||
| 6/5/2021 | Listing removed | -- |
Source: Fresno MLS Report a problem | ||
| 5/26/2021 | Listed for sale | $674,900+95.6%$287/sqft |
Source: Fresno MLS #560011 Report a problem | ||
| 4/13/2018 | Sold | $345,000-1.4%$147/sqft |
Source: Public Record Report a problem | ||
| 2/28/2018 | Listed for sale | $349,999$149/sqft |
Source: Guarantee Real Estate #493943 Report a problem | ||
| 2/28/2018 | Pending sale | $349,999$149/sqft |
Source: Guarantee Real Estate #493943 Report a problem | ||
| 2/13/2018 | Price change | $349,999-2.8%$149/sqft |
Source: Guarantee Real Estate #493943 Report a problem | ||
| 1/9/2018 | Price change | $359,900-2.2%$153/sqft |
Source: Guarantee Real Estate #493943 Report a problem | ||
| 12/20/2017 | Listed for sale | $367,950+8.5%$157/sqft |
Source: Guarantee Real Estate #493943 Report a problem | ||
| 5/23/2017 | Listing removed | $339,000$144/sqft |
Source: Guarantee Real Estate #482331 Report a problem | ||
| 5/10/2017 | Price change | $339,000-1.7%$144/sqft |
Source: Guarantee Real Estate #482331 Report a problem | ||
| 2/15/2017 | Price change | $345,000-1.4%$147/sqft |
Source: Guarantee Real Estate #474094 Report a problem | ||
| 1/17/2017 | Price change | $350,000-4%$149/sqft |
Source: Guarantee Real Estate-Flex #474094 Report a problem | ||
| 1/3/2017 | Price change | $364,500-1.7%$155/sqft |
Source: Guarantee Real Estate-Flex #474094 Report a problem | ||
| 12/2/2016 | Listed for sale | $370,950+30.2%$158/sqft |
Source: Guarantee Real Estate-Flex #474094 Report a problem | ||
| 8/23/2013 | Sold | $285,000$121/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $8,522 -0.1% | $657,900 -2% |
| 2024 | $8,527 +2% | $671,058 +2% |
| 2023 | $8,363 +1.4% | $657,900 +2% |
| 2022 | $8,248 +78.9% | $645,000 +77.9% |
| 2021 | $4,611 +0.4% | $362,655 +1% |
| 2020 | $4,591 +4% | $358,937 +2% |
| 2019 | $4,414 +17.4% | $351,900 +14.6% |
| 2018 | $3,759 -44.8% | $307,047 +2% |
| 2017 | $6,816 +1.9% | $301,027 +2% |
| 2016 | $6,692 +0.7% | $295,126 +1.5% |
| 2015 | $6,646 +94.2% | $290,694 +2% |
| 2014 | $3,423 | $285,000 +155.8% |
| 2013 | -- | $111,400 +2% |
| 2012 | -- | $109,217 +2% |
| 2011 | -- | $107,077 +0.8% |
| 2010 | -- | $106,278 -0.2% |
| 2009 | -- | $106,532 +2% |
| 2008 | -- | $104,444 +2% |
| 2007 | -- | $102,397 +2% |
| 2006 | -- | $100,390 +2% |
| 2005 | -- | $98,422 +2% |
| 2004 | -- | $96,493 +1.9% |
| 2003 | -- | $94,725 +2% |
| 2002 | -- | $92,868 +2% |
| 2001 | $1,029 | $91,048 |
Find assessor info on the county website
Neighborhood: Bullard
Nearby homes
- $560,0003 bd2 ba2k sqft1770 W Celeste Ave, Fresno, CA 93711Sold
- $422,0003 bd2 ba1.7k sqft5740 N West Ave APT 107, Fresno, CA 93711Sold
- $567,5003 bd2 ba2.2k sqft1756 W Celeste Ave, Fresno, CA 93711Off Market
- $360,0003 bd2 ba1.7k sqft5740 N West Ave APT 109, Fresno, CA 93711Sold
- $497,3003 bd1 ba2k sqft1783 W Celeste Ave, Fresno, CA 93711Off Market
- $529,6003 bd2 ba2.1k sqft1767 W Celeste Ave, Fresno, CA 93711Off Market
- $349,1003 bd1 ba1.7k sqft5740 N West Ave APT 108, Fresno, CA 93711Off Market
- $327,3002 bd1 ba1.7k sqft5740 N West Ave APT 106, Fresno, CA 93711Off Market
Nearby schools
GreatSchools rating
- 6/10Gibson Elementary SchoolGrades: K-6Distance: 0.8 mi
- 3/10Tenaya Middle SchoolGrades: 7-8Distance: 0.7 mi
- 6/10Bullard High SchoolGrades: 9-12Distance: 0.9 mi
Schools provided by the listing agent
- Elementary: Gibson
- 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
$659,100
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
$659,100
- California
- Fresno County
- Fresno
- 93711
- Bullard
- 1784 W Celeste Ave
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Fresno Topics
