# Source Drift Review - 90 Madison Ave Albany, NY 12202

- Generated at: `2026-07-04T22:44:43.105640+00:00`
- Resolution: `manual_compare_before_merge`
- Approval gate: `manual_compare_required`
- Policy: `review-only per-property source-drift packet; publishing does not move, trash, delete, upload, or pull Dropbox files`
- Property page: https://properties.earlco.in/properties/90-madison-ave-albany-ny-12202.html

## Decision Required

Compare local-only and API-only rows for this property/root, then choose the source of truth before uploading, pulling, archiving, or moving files.

## Counts

- Root queue rows: `1`
- Local-only detail rows: `160`
- API-only detail rows: `2`
- Same-root content drift rows: `1`

## Root Queue Rows

| Class / Category | Path / Root | Hash / Counts | Action |
| --- | --- | --- | --- |
| same_root_content_drift | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/01 - appraisal - 90 madison ave albany ny - cma and opinion of value - 2026-06-25 - 90 madison ave albany, ny 12202.md | 162 | compare local-only and API-only rows for this normalized property root; hashes differ, so decide source of truth before upload/pull/archive |

## Local-Only Detail Rows

| Class / Category | Path / Root | Hash / Counts | Action |
| --- | --- | --- | --- |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/01 - appraisal - 90 madison ave albany ny - cma and opinion of value - 2026-06-25 - 90 madison ave albany, ny 12202.md | b87ea2f0edad2919519fada2e92ed44cf4b8ac2c3826fb39e4d93621663e398c | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/07 - p&l & owner statements - financials.backup-20260630-035448 - 90 madison ave albany, ny 12202.md | 42cc0a738d8ee0cf46b64a4973523aeeeecb5d0b4439a0ef122b6db4f5fb6cf3 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/07 - p&l & owner statements - reconciliation report - 90 madison ave, albany, ny 12202 - 90 madison ave albany, ny 12202.md | d23ead7b0303fe049a9eeb97041f9452e85b7b91e56748b912571f6368c39442 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/14 - utilities - arcadia power - readme - 90 madison ave albany, ny 12202.md | 919f4e2855b3a40ba77123570286369379955a23e56530f135f6fbf0b6f0fc6a | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/2026-06-financials-approved.md | 7bc0de18ac52ee699c6a7c3f7d5624876f8cc6ef5ce0c029a5cae329ffc675b8 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/2026-06-owner-update-approved.superseded-20260702t192010z.md | cac2ff54a703128222208defd650510ca089ed0b096d0418034bd88f311a1a9a | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/2026-06-owner-update-checkin-draft.md | b811b487261d1256f664a7d4ce1bca92f9910d3548bf18e866d487a14e61541a | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/2026-06-owner-update-checkin-review-checklist.md | f833a63c4c907588e24922c74dc2883e353cdad4a6a9d46699f2d7fc85ef9f69 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/financial summary - 90 madison ave albany, ny 12202.md | 6339e8d65e1ec0535a1c1d84343ecd1ce5555bfdda8968dfbf9ca3e6d474bb1b | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/00 - readme & property snapshot/financials.md | db56676c0974943048775cc03c8b1940fed4d59648d66d5a0a15bedabe0d96e9 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/01 - appraisal/90 madison ave albany ny - cma and opinion of value - 2026-06-25.pdf | dbe9f4bf0546db40502248e871220a29e2cd1c4af60af179ab1af46a422f0f27 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/01 - appraisal/appraisal - 90 madison ave, albany, ny 12202.pdf | 8ead4ff31179c2540d55d4071274486306b26b8bf3d56a5b228539b37a9fea1c | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/01 - appraisal/housecanary valuation - 2024-05 - 90 madison ave, albany, ny 12202.pdf | 827cb006e2fedb28286417492269c07ce4f27d06b829cc56cdb2ec356e2d239a | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/01 - appraisal/housecanary valuation - 2024-06 - 90 madison ave, albany, ny 12202.pdf | a68282d6cb3fe5c70dbb7ce0010c1201d73d556b4f2ee7a491be5ad608ca08e9 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/03 - llc documents/articles of organization - 90 madison ave, albany, ny 12202.pdf | e532258c4a2a81be7e6f1b24647d715e874aebc0192484f8ecdbbf9a5f484add | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/03 - llc documents/certificate of good standing - 2025-12-11 - 90 madison ave, albany, ny 12202.pdf | 2937c96d8890909e791f1ad994f45abdd37ffa7a0b088cfc7dfc6bd46d8af017 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/03 - llc documents/certificate of good standing - 90 madison ave, albany, ny 12202.pdf | 80874599364dd06458dc75ce184f8d851e1b0bb5d9439335f5b9ca21eaec53c4 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/03 - llc documents/governance/90 madison ave refinance proposal.pdf | f853a2f357cfc0a1a553a3d97e265d935fcb12f178688eed86aa12488b449297 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/03 - llc documents/llc annual report - 2025 - 90 madison ave, albany, ny 12202.pdf | 094c99eab37d21123742041ae61e49754b89ea98f3a840b45aa62cdb960279ae | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/03 - llc documents/operating agreement - 90 madison ave, albany, ny 12202.pdf | ea0ac1f90cfa24170861a4eda15d565175b49a14ad74e4eb1fb1b47d3450cffb | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2021/2021-05-17 mortgage statement 90 madison.pdf | f392af16577ce9902f589b4853a8be6383a8f1f8c69a9370d089cb6504213f87 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2021/2021-06-01 mortgage statement 90 madison.pdf | 712685cea0fbc4894954f61b57c607d1c54f1589b0d52b9ad4b28dea0af72bc9 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2021/2021-07-01 mortgage statement 90 madison.pdf | a3db818776a359b04c09161566e4ea636abba6615beb376fbc802a73d63d79cc | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2021/2021-08-01 mortgage statement 90 madison.pdf | f4d1602a1ffbd0d839c9879a4571b8ab59a771a0aeb27bd9d8dab906b13c7b61 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2021/2021-09-01 mortgage statement 90 madison.pdf | 1c5356e6d04aaf009ef2f495b25977fe84cc9da156f5f27e43f75a088bd06cb1 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2021/2021-10-01 mortgage statement 90 madison.pdf | 707ad7e8e9e228cf1ec2bb8fd76ecb03db6c6e1584a44e0b7b1d6fdc5ff76fa4 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2021/2021-11-01 mortgage statement 90 madison.pdf | e89729eb9a44e9af245dc58358311fd8fcc7a3af6bed8a5345e625ad1f926f30 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2021/2021-12-01 mortgage statement 90 madison.pdf | 4675a2c12ea646def95695411b34dafa58d50ba4ae9a2c9a76d54604ecdab97d | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-01-01 mortgage statement 90 madison.pdf | bc6c2d9e960a4d5ac6ba4d15a161f4f7d07903bc7622097acae55bced0400b34 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-02-01 mortgage statement 90 madison.pdf | c3c871ff4c9a650c51a3852a97db36f01bf4b56fec1686c6516754ecebcf88e0 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-03-01 mortgage statement 90 madison.pdf | 881bab3972fa3cad244cf87b4d8f4abef8f4abe45d3cfc059f091903698445d2 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-04-01 mortgage statement 90 madison.pdf | 15734b5b433bf4ef34256d85a5d036e1002edecf09f34743711928a7f8796769 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-05-02 mortgage statement 90 madison.pdf | ad899e840de74a312ab5798019c8d2caff9679106dbd2726b599d88328bae7b2 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-06-01 mortgage statement 90 madison.pdf | d9bcb07e13d48b3b7af6e63a685fa9101ad70634312ac6e61a20c917b29e91b3 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-07-01 mortgage statement 90 madison.pdf | 0112ce7f6a2f7042a573363c9b0dfeefe82b7e869b189ecbe991a8a72ae3e79b | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-08-01 mortgage statement 90 madison.pdf | e967d24c60f126d117fbfcb9af6ab6a960e5302d3a41c1d325cf61ead9ca48ea | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-09-01 mortgage statement 90 madison.pdf | 7396cc6c1cd98fd8304e52207f075fb064e833798085f67033fae89c980fd21d | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-10-01 mortgage statement 90 madison.pdf | 3fee9d1bab2fa9cb8ed0e134fbb44ed48a2fb25708711a82e9715ecb202c0fe1 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/2022-11-01 mortgage statement 90 madison.pdf | a1f15ee94cb8b256b4a42174216922af22de04f903496643a71c7d8ae8d26ca0 | review same-root API-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_local_only | /real estate/ny/90 madison ave albany, ny 12202/public/04 - loan documents/2022/90 madison mortgage statement 2022-12.pdf | f5ea328fd5fd6fe44630139c93f9dd70319cad29b572ea8c553333ef8ef2a2c2 | review same-root API-only rows; hashes differ, so do not auto-move |
| ... | 120 additional rows in JSON packet |  |  |

## API-Only Detail Rows

| Class / Category | Path / Root | Hash / Counts | Action |
| --- | --- | --- | --- |
| same_root_content_drift_api_only | /real estate/ny/90 madison ave albany, ny 12202/public/07 - p&l & owner statements/bank statements/2024/alternate version - bank statement - 2024-12 - 90 madison ave, albany, ny 12202 - 2.pdf | 7dd2a3462df42bf2bbea3ecee66e1446524228e7c2e69428856572e1be6f5efa | review same-root local-only rows; hashes differ, so do not auto-move |
| same_root_content_drift_api_only | /real estate/ny/90 madison ave albany, ny 12202/public/07 - p&l & owner statements/bank statements/2024/alternate version - bank statement - 2024-12 - 90 madison ave, albany, ny 12202 - 3.pdf | 32403b8317f317e9571840320e3798a6aa6d5a89f0f104206d9559e3e671c0b2 | review same-root local-only rows; hashes differ, so do not auto-move |

## Same-Root Content Drift Rows

| Class / Category | Path / Root | Hash / Counts | Action |
| --- | --- | --- | --- |
| same normalized property/root has unmatched local-only and API-only content; review as source drift, not an automatic move | /real estate/ny/90 madison ave albany, ny 12202/public | local  / API | same normalized property/root has unmatched local-only and API-only content; review as source drift, not an automatic move |