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
------------------------------