$549,000

1740 W Celeste Ave Fresno, CA 93711

Bullard Neighborhood

Estimated payment $3,217/month

3 Beds
3 Baths
2,891 Sq Ft
$190 Price per Sq Ft

Highlights

  • In Ground Pool
  • Ranch Style House
  • Jetted Tub in Primary Bathroom
  • Fruit Trees
  • Wood Flooring
  • 2 Fireplaces

About This Home

A quiet cul-de-sac street in a desired Northwest Fresno neighborhood is ready for its next owner! Large ranch style home with 3BD, 3BA, 2 living areas with fireplaces, built-in cabinets, formal dining room, gorgeous hardwood floors, inside laundry and lots of storage. A large bonus room with separate entrance could be used as an office, game room, or hobby/art studio. Outside features a serene front courtyard, backyard covered patio & swimming pool, beautiful mature landscaping with fruit trees & bottle-brush loved by hummingbirds. An attached 2 car garage provides potential for additional storage. Located near dining, shopping, medical, and more! Home has been refreshed and priced to sell. Shown by APPOINTMENT ONLY to Qualified Buyers. Call today to schedule an appointment!

Listing Agent

Myron Emerzian

Century 21 Select Real Estate License #01871587 Listed on: 09/08/2026

Century 21 Select Real Estate

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1966

Lot Details

  • 12,740 Sq Ft Lot
  • Cul-De-Sac
  • Fenced Yard
  • Mature Landscaping
  • Front and Back Yard Sprinklers
  • Fruit Trees
  • Garden

Home Design

  • Ranch Style House
  • Concrete Foundation
  • Composition Roof
  • Block Exterior
  • Stucco

Interior Spaces

  • 2,891 Sq Ft Home
  • 2 Fireplaces
  • Zero Clearance Fireplace
  • Fireplace Features Masonry
  • Great Room
  • Family Room
  • Formal Dining Room
  • Laundry in Utility Room

Kitchen

  • Eat-In Kitchen
  • Dishwasher

Flooring

  • Wood
  • Carpet
  • Tile
  • Vinyl

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3 Bathrooms
  • Jetted Tub in Primary Bathroom
  • Bathtub with Shower
  • Separate Shower

Parking

  • Automatic Garage Door Opener
  • On-Street Parking

Pool

  • In Ground Pool
  • Gunite Pool

Additional Features

  • Covered Patio or Porch
  • Central Heating and Cooling System

Home Details

Home Type

Single Family

Year Built

Built in 1966

Lot Details

0.29 Acres

Listing Details

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

Interior Features

  • Fireplace Type: Masonry, Zero Clearance
  • Number Of Fireplaces: 2
  • Flooring: Carpet, Tile, Vinyl, Hardwood
  • Bathrooms: 3.00
  • Bedrooms: 3
  • Bathroom Features: Tub/Shower, Shower, Other, Jetted Tub
  • Dining Room Features: Formal
  • Kitchen: Built In Range/Oven, Electric Appliances, Dishwasher, Eating Area
  • Laundry: Inside, Utility Room
  • Extra Rooms: Great Room, Family Room
  • Square Footage: 2891.00

Exterior Features

  • Yard: Sprinklers Front, Sprinklers Back, Sprinklers Auto, Fenced, Mature Landscape, Fruit/Nut Trees, Garden Area
  • Roofing: Composition
  • Pool Type: In Ground
  • Exterior: Stucco, Block
  • Detached Structures: Shed
  • Foundation: Concrete
  • Patio: Covered, Concrete
  • Pool: Yes
  • Pool Features: Gunite, Grassy Area

Garage/Parking

  • Parking Features: Auto Opener, Street

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: Cul De Sac

Lot Info

  • Acres: 0.2925
  • Lot Measurement: Square Feet
  • Lot Size Sq Ft: 12740.00
  • Price Per Acre: 1876923.08

Building Info

  • Year Built: 1966

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

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
2026 $2,252 $182,950 $24,942 $158,008
2025 $2,252 $179,363 $24,453 $154,910
2023 $2,122 $172,400 $23,504 $148,896
2022 $2,092 $169,021 $23,044 $145,977
2021 $2,033 $165,708 $22,593 $143,115
2020 $2,023 $164,010 $22,362 $141,648
2019 $1,944 $160,795 $21,924 $138,871
2018 $1,900 $157,644 $21,495 $136,149
2017 $1,866 $154,554 $21,074 $133,480
2016 $1,803 $151,524 $20,661 $130,863
2015 $1,774 $149,249 $20,351 $128,898
2014 $1,717 $146,327 $19,953 $126,374
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
09/08/2026 09/08/26 For Sale $549,000 -- $190 / 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
Source: Public Records

Source: Fresno MLS

MLS Number: 654955

Fresno MLS

APN: 416-053-04

California Fresno County Fresno 93711 Bullard

1740 W Celeste Ave, Fresno, CA

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Fresno MLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes
Listing Agent
Myron Emerzian
Section Image
Century 21 Select Real Estate
(209) 885-6272
Your Personal Tour Guide

Ask me questions while you tour the home.