Sign In

Close

x
Showing 1 of 0
X
Save
1740 W Celeste Avenue Fresno CA 93711US3 Bed, 3.00 Bath (3 Full Bath), 2,891 square feet654955
1740 W Celeste Avenue FresnoCA93711
549000.0000 1/1/1900 12:00:00 AM
Century 21 Select Real Estate
1 /

Courtesy of: Myron Emerzian, Century 21 Select Real Estate, c21cwatsoncdm@gmail.com

1740 W Celeste Avenue
Fresno CA 93711 US

Save
1 /

Courtesy of: Myron Emerzian, Century 21 Select Real Estate, c21cwatsoncdm@gmail.com

Get more info about this property

1740 W Celeste Avenue
Fresno CA 93711 US

$549,000

Active Listing ID 654955
bed icon
3 bed
rule icon
2,891 square feet
bath icon
3.00 Bath (3 Full)
lot icon
Lot: 0.29 Acres
home icon
Single Family Residence

$549,000

Active Listing ID 654955
Save
3d icon
Maps

1740 W Celeste Avenue 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!

Collapse all

Property Features

  • Facts
  • Lot Size: 0.29 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 3
  • Exterior Finish: Stucco, Block
  • Floor Covering: Hardwood, Tile, Carpet, Vinyl
  • Roof Type: Composition
  • Additional Features
  • Fireplace
  • Pool

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 549000
  • unparsedaddress: 1740 W Celeste Avenue
  • postalcity: Fresno
  • stateorprovince: CA
  • country: US
  • postalcode: 93711
  • bathroomsfull: 3
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.2925
  • lotsizeunits: Acres
  • lotsizearea: 0.2925
  • livingarea: 2891
  • livingareaunits: Square Feet
  • latitude: 36.821194
  • longitude: -119.825009
  • listagentfullname: Myron Emerzian
  • listagentemail: c21cwatsoncdm@gmail.com
  • listagentkey: 3yd-FARCA-16790
  • listagentmlsid: 16790
  • listagentpreferredphone: (559) 970-6634
  • listofficekey: 3yd-FARCA-90
  • listofficemlsid: 90
  • disclaimer: Copyright © 2026 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: FARCA
  • yearbuilt: 1966
  • listingcontractdate: 2026-09-08
  • listagenturl: https://century21Fresno.com
  • countyorparish: Fresno
  • parcelnumber: 41605304
  • highschooldistrict: Fresno Unified
  • flooring: Hardwood, Tile, Carpet, Vinyl
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • parkingfeatures: Open
  • roof: Composition
  • waterfrontyn: False
  • franchiseaffiliation: Century 21 Real Estate
  • exteriorfeatures: Stucco, Block
  • architecturalstyle: Ranch
  • rooms: Bathroom 1, Bedroom 3, Family Room, Bedroom 2, Bathroom 3, Bedroom 1, Bathroom 2
  • dock: False
  • poolprivateyn: True
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -119.82501, 36.821194
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Century 21 C Watson", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"c21cwatsoncdm@gmail.com", "ListBrokerageCity":"Fresno", "ListBrokerageCountry":"US", "ListBrokerageEmail":"c21cwatsoncdm@gmail.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Century 21 C Watson", "ListBrokeragePhone":"(559) 970-6634", "ListBrokeragePostalCode":"93711", "ListBrokerageStateOrProvince":"CA", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"7520 North Palm Suite 102", "ListBrokerageWebsiteUrl":"https://century21Fresno.com", "ListOfficeAddress1":"7520 N PALM AVE STE 102 ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"90", "ListOfficeCity":"Fresno", "ListOfficeCountry":"US", "ListOfficeEmail":"c21cwatsoncdm@gmail.com", "ListOfficePostalCode":"93711", "ListOfficeStateOrProvince":"CA", "ListPriceCurrencyType":"USD", "ListingTitle":"Residential, Fresno, CA", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/1740-W-Celeste-Ave_Fresno_CA_93711_M12024-34506?f=listhub&s=FARCA&m=654955&c=rexren", "MLSModificationTimestamp":"2026-09-08 13:15:37", "Neighborhoods":[{"Description":null, "Name":"711"}], "PostalCode":null, "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 9/11/2026 7:25:59 PM GMT
Source Updated Date: 9/13/2026 12:45:22 AM GMT

Courtesy of: Myron Emerzian, Century 21 Select Real Estate, c21cwatsoncdm@gmail.com

Copyright © 2026 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact