1740 W Celeste Avenue, Fresno, CA 93711

Local realty services provided by:Better Homes and Gardens Real Estate GoldLeaf
1740 W Celeste Avenue,Fresno, CA 93711
$549,000
  • 3 Beds
  • - Baths
  • 2,891 sq. ft.
  • Single family
  • Active
Listed by: myron emerzian
Office: century 21 select real estate
MLS#:654955
Source:CA_FMLS

Price summary

  • Price:$549,000
  • Price per sq. ft.:$189.9

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!

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with a BHGRE®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a BHGRE®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (CENTURY 21® , Coldwell Banker® , Corcoran® , ERA® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:1966
  • Listing ID #:654955
  • Added:1 day(s) ago
  • Updated:September 08, 2026 at 10:44 PM

Rooms and interior

  • Bedrooms:3
  • Flooring:Carpet, Hardwood, Tile, Vinyl
  • Kitchen Description:Built In Range/Oven, Dishwasher, Electric Appliances
  • Living area:2,891 sq. ft.

Heating and cooling

  • Cooling:Central Heat & Cool

Structure and exterior

  • Roof:Composition
  • Year built:1966
  • Building area:2,891 sq. ft.
  • Architectural Style:Ranch
  • Construction Materials:Block, Stucco
  • Exterior Features:Concrete, Covered
  • Foundation Description:Concrete
  • Levels:1 Story

Schools

  • High school:Bullard
  • Middle school:Tenaya
  • Elementary school:Gibson

Utilities

  • Water:Public
  • Sewer:Public Sewer

Finances and disclosures

  • Price:$549,000
  • Price per sq. ft.:$189.9

Features and amenities

  • Laundry features:Inside, Utility Room

Parking

  • Parking description:Garage Door Opener, On Street
MLS LogoBased on information from the Fresno Association of REALTORS® (alternatively, from the Fresno MLS)as of (September 8, 2026). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy.Properties may or may not be listed by the office/agent presenting theinformation.