Address and Property

I am noticing some property assessments  in the Prop Attribute assessment data showing sale amount and tax amounts resulting in tax percent > 50%. I need someone to check this dataset out and let me know if my tax calculation is wrong . If the sale amount is around 300K can the tax amount be in millions? Take 50 Fetterman Rd, Palm, PA 18070 | Trulia

The tax amount is only 900$ , why is it that the downloaded data is showing  tax amount of 2,809,227.55 for a 200K property. i checked to make sure it is not our parsing logic fault, owing to some null fields or something. We are actually receiving this dataset like this. Also can a 2M property have a 1.5M tax amount on it? please clarify

SELECT paid, sale_amt ,tax_amt , tax_yr , round(tax_amt*100/sale_amt) as tax_pct , tax_addr, tax_city, tax_State,prop_cat FROM prop_attr_assessment_2022 paa2 where sale_amt>100000 and prop_cat = 'R' and tax_amt*100/sale_amt > 50 limit 10
paid	sale_amt	tax_amt	tax_yr	tax_pct	tax_addr	tax_city	tax_state	prop_cat
A000PK758GL3	2,125,000	1,562,023.72	2021	74	156 W 56TH ST FL 6	NEW YORK	NY	R

And the result i am noticing is like 

SELECT paid, sale_amt ,tax_amt , tax_yr , round(tax_amt*100/sale_amt) as tax_pct , tax_addr, tax_city, tax_State,prop_cat FROM prop_attr_assessment_ms paa where sale_amt>100000 and prop_cat = 'R' and tax_amt*100/sale_amt > 50 limit 10
paid	sale_amt	tax_amt	tax_yr	tax_pct	tax_addr	tax_city	tax_state	prop_cat
A000PK7PDHYP	266,000	2,809,227.55	2023	1,056	50 FETTERMAN RD	PALM	PA	R
A000PK7O6EHA	320,000	4,270,750.17	2023	1,335	3068 SEISHOLTZVILLE RD	MACUNGIE	PA	R
A000PK7JV4RO	500,000	5,020,912.22	2023	1,004	1271 HUFFS CHURCH RD	BARTO	PA	R
A000PK7J4TQG	162,500	3,290,365.97	2023	2,025	175 GREENHOUSE LN	BARTO	PA	R
A000PK7O0VUG	124,000	1,940,074.28	2023	1,565	162 DALE RD	BARTO	PA	R
A000PK8ANTBE	120,000	63,605	2023	53	3 LEDGEWOOD BLVD	NORTH DARTMOUTH	MA	R
A000PK7JRWIT	154,000	2,620,393.65	2023	1,702	53 DALE RD	BARTO	PA	R
A000PK7J1QEQ	121,900	3,140,333.56	2023	2,576	144 DALE RD	BARTO	PA	R
A000PK7MRN60	132,000	1,834,016.88	2023	1,389	55 SAINT PETERS RD	MACUNGIE	PA	R
A000PK7O692P	255,000	3,593,017.56	2023	1,409	7988 CROW RD	ZIONSVILLE	PA	R

------------------------------
Padma Kunde
Keller Williams Realty INTL
AUSTIN TX
------------------------------

Hello Padma,

It appears that the Assessor has made an error in the mill rate which is used to calculate the tax amount. The County offices have been made aware of the error.

------------------------------
Amy Metz, PMP, PMC-III
Product Manager - Address Data
Pitney Bowes
White River Junction, VT
802-698-3571
https://www.linkedin.com/feed/?trk=
------------------------------

Original Message:
Sent: 02-13-2024 23:04
From: Padma Kunde
Subject: Property Attribute assessment has tax_pct > 50%

I am noticing some property assessments  in the Prop Attribute assessment data showing sale amount and tax amounts resulting in tax percent > 50%. I need someone to check this dataset out and let me know if my tax calculation is wrong . If the sale amount is around 300K can the tax amount be in millions? Take 50 Fetterman Rd, Palm, PA 18070 | Trulia

The tax amount is only 900$ , why is it that the downloaded data is showing  tax amount of 2,809,227.55 for a 200K property. i checked to make sure it is not our parsing logic fault, owing to some null fields or something. We are actually receiving this dataset like this. Also can a 2M property have a 1.5M tax amount on it? please clarify

SELECT paid, sale_amt ,tax_amt , tax_yr , round(tax_amt*100/sale_amt) as tax_pct , tax_addr, tax_city, tax_State,prop_cat FROM prop_attr_assessment_2022 paa2 where sale_amt>100000 and prop_cat = 'R' and tax_amt*100/sale_amt > 50 limit 10
paid	sale_amt	tax_amt	tax_yr	tax_pct	tax_addr	tax_city	tax_state	prop_cat
A000PK758GL3	2,125,000	1,562,023.72	2021	74	156 W 56TH ST FL 6	NEW YORK	NY	R

SELECT paid, sale_amt ,tax_amt , tax_yr , round(tax_amt*100/sale_amt) as tax_pct , tax_addr, tax_city, tax_State,prop_cat

FROM prop_attr_assessment_ms paa

where sale_amt>100000 

and prop_cat = 'R'

and tax_amt*100/sale_amt > 50 limit 10

And the result i am noticing is like 

SELECT paid, sale_amt ,tax_amt , tax_yr , round(tax_amt*100/sale_amt) as tax_pct , tax_addr, tax_city, tax_State,prop_cat FROM prop_attr_assessment_ms paa where sale_amt>100000 and prop_cat = 'R' and tax_amt*100/sale_amt > 50 limit 10
paid	sale_amt	tax_amt	tax_yr	tax_pct	tax_addr	tax_city	tax_state	prop_cat
A000PK7PDHYP	266,000	2,809,227.55	2023	1,056	50 FETTERMAN RD	PALM	PA	R
A000PK7O6EHA	320,000	4,270,750.17	2023	1,335	3068 SEISHOLTZVILLE RD	MACUNGIE	PA	R
A000PK7JV4RO	500,000	5,020,912.22	2023	1,004	1271 HUFFS CHURCH RD	BARTO	PA	R
A000PK7J4TQG	162,500	3,290,365.97	2023	2,025	175 GREENHOUSE LN	BARTO	PA	R
A000PK7O0VUG	124,000	1,940,074.28	2023	1,565	162 DALE RD	BARTO	PA	R
A000PK8ANTBE	120,000	63,605	2023	53	3 LEDGEWOOD BLVD	NORTH DARTMOUTH	MA	R
A000PK7JRWIT	154,000	2,620,393.65	2023	1,702	53 DALE RD	BARTO	PA	R
A000PK7J1QEQ	121,900	3,140,333.56	2023	2,576	144 DALE RD	BARTO	PA	R
A000PK7MRN60	132,000	1,834,016.88	2023	1,389	55 SAINT PETERS RD	MACUNGIE	PA	R
A000PK7O692P	255,000	3,593,017.56	2023	1,409	7988 CROW RD	ZIONSVILLE	PA	R

------------------------------
Padma Kunde
Keller Williams Realty INTL
AUSTIN TX
------------------------------