Skip main navigation
Off market
  • $608,400

    3171 W Celeste Ave, Fresno, CA 93711

    4beds
    2baths
    2,654sqft
    SingleFamily
    Built in 1975
    10,201 Square Feet Lot
    $608,400 Zestimate®
    $229/sqft
    $3,099 Estimated rent

    Home value

    $608,400

    $572,000 - $651,000

    $3,099/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $3,099/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $3,099/mo

    Rent Zestimate®

    Refinance and save

    $3,943/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $3,943/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 started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Honey Stop the Car! This fantastic Bullard High home with 4 bedrooms 2.5 baths approximately 2654sf sits on a large corner lot and is REMODELED from top to bottom! This stunning home is an entertainers delight with a spacious kitchen that opens to a large great room perfect for family and friends. There's an isolated bedroom & half bath, separate living room, gorgeous backyard with a sparkling pool & covered patio perfect for those Summertime parties! From the moment you enter this fabulous home, you're sure to be impressed with the warm colors, elegant touches throughout giving a welcoming & airy feel. The elegant master bedroom features a luxurious master bath with a large spa tub & separate shower. Gorgeous home!

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 4
    • Bathrooms: 2.5
    Heating
    • Forced air
    Cooling
    • Central
    Features
    • Flooring: Tile, Carpet, Hardwood
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 2,654 sqft

    Property

    Parking
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stucco, Brick
    Lot
    • Size: 10,201 Square Feet
    Details
    • Parcel number: 41538213

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • wood frame
    • Roof: Other
    Condition
    • Year built: 1975

    Community & HOA

    Location
    • Region: Fresno

    Financial & listing details

    • Price per square foot: $229/sqft
    • Tax assessed value: $399,235
    • Annual tax amount: $5,091

    Price history

    DateEventPrice
    7/29/2016Sold$344,000-1.7%$130/sqft
    Source: Public Record Report a problem
    5/4/2016Listed for sale$349,900+11.4%$132/sqft
    Source: RE/MAX Gold #462966 Report a problem
    8/3/2015Sold$314,000-4.4%$118/sqft
    Source: Public Record Report a problem
    5/21/2015Listed for sale$328,500+36.9%$124/sqft
    Source: London Properties, Ltd. #445187 Report a problem
    7/18/2012Sold$240,000+0%$90/sqft
    Source: Public Record Report a problem
    5/22/2012Price change$239,900-4%$90/sqft
    Source: London Properties #388685 Report a problem
    3/6/2012Listed for sale$249,900$94/sqft
    Source: London Properties, Ltd. #388685 Report a problem
    10/9/2011Listing removed$249,900$94/sqft
    Source: London Properties Ltd #371362 Report a problem
    8/5/2011Price change$249,900-2%$94/sqft
    Source: London Properties #371362 Report a problem
    7/2/2011Price change$254,900-1.9%$96/sqft
    Source: London Properties #371362 Report a problem
    4/6/2011Listed for sale$259,900+66.6%$98/sqft
    Source: London Properties, Ltd. #371362 Report a problem
    5/25/1999Sold$156,000$59/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$5,091 +4%$399,235 +2%
    2024$4,896 +2%$391,408 +2%
    2023$4,800 +1.4%$383,734 +2%
    2022$4,733 +2.9%$376,211 +2%
    2021$4,601 +0.5%$368,835 +1%
    2020$4,580 +4.1%$365,054 +2%
    2019$4,402 +2.3%$357,897 +2%
    2018$4,304 +1.8%$350,880 +2%
    2017$4,229 +8.8%$344,000 +9.6%
    2016$3,887 +27.8%$314,000 +28%
    2015$3,042 +2%$245,392 +2%
    2014$2,983 $240,586 +0.5%
    2013-- $239,500 +21.1%
    2012-- $197,835 +2%
    2011-- $193,957 +0.8%
    2010-- $192,509 -0.2%
    2009-- $192,967 +2%
    2008-- $189,184 +2%
    2007-- $185,476 +2%
    2006-- $181,840 +3.7%
    2005-- $175,334 +2%
    2004-- $171,897 +1.9%
    2003-- $168,748 +2%
    2002-- $165,440 +2%
    2001$1,881 $162,197
    Find assessor info on the county website

    Neighborhood: Bullard

    Nearby schools

    GreatSchools rating
    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
    $608,400
    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
    $608,400