08 Fremont Twp 2023 - 2024 C-5 and Better Residential ECF Analysis.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Fremont Twp 2024 ECF Analysis C-5 and Better Neighborhoods 4003 & 4004
2
3	Parcel Number	Street Address	Sale Date	Sale Price	Instr.	Terms of Sale	Adj. Sale $	Asd. when Sold	Asd/Adj. Sale	Cur. Appraisal	Land + Yard	Bldg. Residual	Cost Man. $	E.C.F.	ECF Area	Dev. by Mean (%)	Building Style	Land Value	Land Table	Property Class	Building Depr.
4	15-11-2-01-3002-004	2627 S FORDNEY	44701	135000	WD	03-ARM'S LENGTH	135000	71800	53.185	150280	15843	119157	141961	0.839	4003	18.584	MODULAR	15843	FREMONT RESIDENTIAL LAND RATES	401	73
5	15-11-2-02-1004-002	2386 S FORDNEY	44372	376000	WD	03-ARM'S LENGTH	376000	155600	41.383	287606	57074	318926	352495	0.905	4004	12.044	RANCH	33248	FREMONT RESIDENTIAL LAND RATES	401	71
6	15-11-2-03-3007-001	2795 S HEMLOCK	44589	242000	WD	03-ARM'S LENGTH	242000	91100	37.645	216343	60829	181171	164218	1.103	4003	7.803	RANCH	43471	FREMONT RESIDENTIAL LAND RATES	401	62
7	15-11-2-04-2001-012	12 CLEAR LAKE	44292	395000	WD	03-ARM'S LENGTH	395000	234200	59.291	444200	101345	293655	524243	0.560	4004	46.505	1.50 STORY	83463	FREMONT RESIDENTIAL LAND RATES	401	83
8	15-11-2-04-3009-000	2851 S BRENNAN	44361	196900	WD	03-ARM'S LENGTH	196900	83800	42.560	200168	44118	152782	164784	0.927	4003	9.804	1.75 STORY	40779	FREMONT RESIDENTIAL LAND RATES	401	65
9	15-11-2-04-3010-000	16964 SWAN CREEK	44467	287000	WD	03-ARM'S LENGTH	287000	89000	31.010	210972	59503	227497	159946	1.422	4003	39.713	1.75 STORY	45327	FREMONT RESIDENTIAL LAND RATES	401	65
10	15-11-2-08-2001-004	17655 SWAN CREEK	44456	360000	WD	03-ARM'S LENGTH	360000	144100	40.028	345682	43707	316293	318875	0.992	4003	3.330	2.0 STORY	43707	FREMONT RESIDENTIAL LAND RATES	401	86
11	15-11-2-08-4003-001	17278 ROOSEVELT	44403	179900	WD	03-ARM'S LENGTH	179900	66900	37.187	183568	39320	140580	152321	0.923	4003	10.228	RANCH	22726	FREMONT RESIDENTIAL LAND RATES	401	62
12	15-11-2-10-1003-000	15395 SWAN CREEK	44886	230000	WD	03-ARM'S LENGTH	230000	78700	34.217	167707	54060	175940	120007	1.466	4003	44.087	RANCH	44654	FREMONT RESIDENTIAL LAND RATES	401	62
13	15-11-2-13-4003-006	4800 S ORR	44309	310000	WD	03-ARM'S LENGTH	310000	133400	43.032	317880	107087	202913	222590	0.912	4003	11.361	TRI-LEVEL	87369	FREMONT RESIDENTIAL LAND RATES	401	63
14	15-11-2-17-2002-004	17711 ROOSEVELT RD	44565	232000	WD	03-ARM'S LENGTH	232000	81500	35.129	195774	15421	216579	190447	1.137	4003	11.201	RANCH	15421	FREMONT RESIDENTIAL LAND RATES	401	62
15	15-11-2-17-3006-000	4747 S IVA	44823	138000	WD	03-ARM'S LENGTH	138000	53600	38.841	111698	18791	119209	98107	1.215	4003	18.989	RANCH	14938	FREMONT RESIDENTIAL LAND RATES	401	59
16	15-11-2-18-1001-002	18085 ROOSEVELT	44540	250000	WD	03-ARM'S LENGTH	250000	121800	48.720	294432	26308	223692	283130	0.790	4003	23.514	1.50 STORY	26308	FREMONT RESIDENTIAL LAND RATES	401	82
17	15-11-2-19-1001-010	5278 S IVA	44502	310000	WD	03-ARM'S LENGTH	310000	121100	39.065	292474	64798	245202	240418	1.020	4003	0.531	RANCH	55830	FREMONT RESIDENTIAL LAND RATES	401	76
18	15-11-2-22-2002-000	15575 LAKEFIELD	44706	145000	WD	03-ARM'S LENGTH	145000	70900	48.897	147578	16289	128711	138637	0.928	4003	9.680	1.75 STORY	13145	FREMONT RESIDENTIAL LAND RATES	401	57
19	15-11-2-26-4005-000	6460 S FORDNEY	44634	217000	WD	03-ARM'S LENGTH	217000	92000	42.396	213377	68185	148815	153318	0.971	4003	5.457	RANCH	47441	FREMONT RESIDENTIAL LAND RATES	401	62
20	15-11-2-27-4003-002	15122 S GRABOWSKI RD	44820	625000	WD	03-ARM'S LENGTH	625000	181300	29.008	416029	189004	435996	347133	1.256	4004	23.079	RANCH	162195	FREMONT RESIDENTIAL LAND RATES	401	94
21	15-11-2-29-3004-000	17720 GRABOWSKI	44519	261000	WD	03-ARM'S LENGTH	261000	78500	30.077	187438	25636	235364	170857	1.378	4003	35.234	1.25 STORY	25636	FREMONT RESIDENTIAL LAND RATES	401	64
22	15-11-2-30-3006-000	18690 GRABOWSKI	44742	215000	WD	03-ARM'S LENGTH	215000	73800	34.326	155717	29058	185942	133748	1.390	4003	36.504	2.0 STORY	24044	FREMONT RESIDENTIAL LAND RATES	401	80
23	15-11-2-31-2004-000	18699 GRABOWSKI	44428	226000	WD	03-ARM'S LENGTH	226000	97400	43.097	234244	36980	189020	208304	0.907	4003	11.778	RANCH	36980	FREMONT RESIDENTIAL LAND RATES	401	71
24	15-11-2-34-4005-000	15240 W TOWNLINE	44974	113400	WD	03-ARM'S LENGTH	113400	49200	43.386	102438	8604	104796	99086	1.058	4003	3.243	RANCH	8604	FREMONT RESIDENTIAL LAND RATES	401	53
25	15-11-2-35-1001-001	14180 GRABOWSKI	44399	195000	WD	03-ARM'S LENGTH	195000	110900	56.872	268618	13438	181562	269461	0.674	4003	35.141	RANCH	13438	FREMONT RESIDENTIAL LAND RATES	401	76
26	15-11-2-36-1004-000	13105 BEAVER	44830	271600	WD	03-ARM'S LENGTH	271600	135200	49.779	301453	100628	170972	212064	0.806	4003	21.898	RANCH	97500	FREMONT RESIDENTIAL LAND RATES	401	73
27			Totals:	5910800			5910800	2415800		5445676		4714774	4866150			5.631
28								Sale. Ratio =>	40.871				E.C.F. =>	0.969
29								Std. Dev. =>	8.158957214				Ave. E.C.F. =>	1.025
30	Use the indicated ECF of .969 for residential homes, use the indiacted ECF of .717 for mobile homes from the mobile home analysis
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100