SOLD NOVEMBER 2014 FOR $183,000

$483,256

LeadCruncher Estimate

The LeadCruncher Estimate is based on what we currently know about this home and nearby market.

The LeadCruncher Estimate is not a formal appraisal or substitute for the in-person expertise of a real estate agent or professional appraiser.

Have feedback on the LeadCruncher Estimate? .

$300K since sold in November 2014
  • 3 beds
  • 1 baths
  • 1,956 sqft

174 W Celeste AVE, Fresno, California 93704

Map showing the location of this property

About This Home

174 W Celeste AVE sits in Fresno, California, 93704 and is classified as a Single Family Residential property. It offers 3 bedrooms and 1 bathroom across 1,956 square feet of living space. The structure dates to 1956 and occupies a 9,288 square foot parcel.

The last recorded transaction for 174 W Celeste AVE, Fresno, California 93704 was $183,000, dated November 25, 2014. The county assessor places its assessed value at $224,327. The parcel is identified by APN 416-102-15. Continue below for the LeadCruncher value estimate, the recorded sale history and comparable properties in the area.

Single Family Residential

Property Type

1956

Year Built

9288

Lot Size

$247.06

Est. Price/Sq.Ft.

416-102-15

APN

$224,327

Assessed Value

LeadCruncher data coverage

There is a lot more on record for 174 W Celeste AVE

Everything above comes from the public sale and assessment file. LeadCruncher subscribers also see who owns the home today, who is set to inherit it, and whether the loan is falling behind, for this address and every other one in Fresno, CA.

8 public fields on this page 100+ fields inside LeadCruncher
174 W Celeste AVESuccessors Data record
Property address
174 W Celeste AVE
Property type
Single Family Residential
Deceased owner name
Available with a LeadCruncher subscription
Date of death
Available with a LeadCruncher subscription
Successor or heir name
Available with a LeadCruncher subscription
Heir mailing address
Available with a LeadCruncher subscription
Relationship to owner
Available with a LeadCruncher subscription
Transfer deed type
Available with a LeadCruncher subscription

Field list is representative of what we carry. Actual availability varies by county and record type.

Reach the heir before this Fresno home reaches the market

Title at 174 W Celeste AVE last changed hands in November 2014, and the owner on that deed is still the owner of record. When an owner passes away the home moves to an heir long before any court filing, and we flag that transfer within about a week.

  • 4M+ pre-probate records nationwide
  • Heir names and mailing addresses
  • New records every Tuesday
From $125/mo1,000 records upfront, 200 new records every month

CRM, Triple Dialer, Owner Verification and E-File Drop are included free with every plan.

  • All 50 states covered
  • Daily and weekly refreshes
  • Export or API access
  • No contract, cancel anytime

LeadCruncher Value Estimation

Value estimation chart preview
Tap or Hover To View Chart

Filter Estimates

Filter the above estimates based on the options below.

0.5
1
1.5
2

Similar Properties

1041 E Alamos AVEFresno, California 93704
Last sold07/28/2026
Last sold price$500,000
2 beds2 baths1791 sqft
654 W Celeste AVEFresno, California 93704
Last sold08/17/2026
Last sold price$485,000
3 beds2 baths1850 sqft
6413 N Arthur AVEFresno, California 93711
Last sold05/18/2026
Last sold price$490,000
3 beds2 baths1866 sqft
442 W Mesa AVEFresno, California 93704
Last sold05/07/2026
Last sold price$510,000
4 beds2 baths1898 sqft
539 E Sample AVEFresno, California 93710
Last sold05/08/2026
Last sold price$472,000
3 beds1 baths1904 sqft
Loading Map...

Frequently asked questions

174 W Celeste AVE, Fresno, California 93704 last sold for $183,000 on November 25, 2014, according to public county records.

174 W Celeste AVE, Fresno, California 93704 has 3 bedrooms and 1 bathroom.

174 W Celeste AVE, Fresno, California 93704 has 1,956 sq ft of living space on a 9,288 sq ft lot.

174 W Celeste AVE, Fresno, California 93704 was built in 1956.

The county assessed value of 174 W Celeste AVE, Fresno, California 93704 is $224,327.

The Assessor's Parcel Number (APN) for 174 W Celeste AVE, Fresno, California 93704 is 416-102-15.

174 W Celeste AVE, Fresno, California 93704 is a Single Family Residential property.