[2026-04-13T02:40:01+00:00] INFO Starting property sync {"start":"2026-04-13T02:19:43+00:00","end":"2026-04-13T05:19:43+00:00","offset_fetch_duration_ms":1,"page_size":100,"expand":["Media","OpenHouse","Unit","Room"],"statuses":["Active","Coming Soon","Active Under Contract"],"property_types":["Residential"]}
[2026-04-13T02:40:01+00:00] INFO Spark filter constructed {"filter":"ModificationTimestamp gt 2026-04-13T02:19:43Z and ModificationTimestamp lt 2026-04-13T05:19:43Z and (StandardStatus eq 'Active' or StandardStatus eq 'Coming Soon' or StandardStatus eq 'Active Under Contract') and (PropertyType eq 'Residential')"}
[2026-04-13T02:40:01+00:00] INFO Spark initial request {"url":"https://replication.sparkapi.com/Version/3/Reso/OData/Property?%24filter=ModificationTimestamp+gt+2026-04-13T02%3A19%3A43Z+and+ModificationTimestamp+lt+2026-04-13T05%3A19%3A43Z+and+%28StandardStatus+eq+%27Active%27+or+StandardStatus+eq+%27Coming+Soon%27+or+StandardStatus+eq+%27Active+Under+Contract%27%29+and+%28PropertyType+eq+%27Residential%27%29&%24orderby=ModificationTimestamp+asc%2CListingKey+asc&%24top=100&%24expand=Media%2COpenHouse%2CUnit%2CRoom"}
[2026-04-13T02:40:03+00:00] INFO Spark API response {"status":200,"url":"https://replication.sparkapi.com/Version/3/Reso/OData/Property?%24filter=ModificationTimestamp+gt+2026-04-13T02%3A19%3A43Z+and+ModificationTimestamp+lt+2026-04-13T05%3A19%3A43Z+and+%28StandardStatus+eq+%27Active%27+or+StandardStatus+eq+%27Coming+Soon%27+or+StandardStatus+eq+%27Active+Under+Contract%27%29+and+%28PropertyType+eq+%27Residential%27%29&%24orderby=ModificationTimestamp+asc%2CListingKey+asc&%24top=100&%24expand=Media%2COpenHouse%2CUnit%2CRoom","count":18,"duration_ms":1673}
[2026-04-13T02:40:03+00:00] INFO Processing page {"count":18,"has_next":false}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260406223706372093000000","duration_ms":21}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260406223706372093000000","PhotosChangeTimestamp":"2026-04-13 02:18:51","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260406223706372093000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260406223706372093000000","duration_ms":24}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20251010222653396605000000","duration_ms":5}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20251010222653396605000000","PhotosChangeTimestamp":"2026-01-22 12:53:19","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO History recorded {"listing_id":"20251010222653396605000000","event":"Status Active","price_change":"","price_change_ts":"2026-02-19 16:23:05","last_update":"2026-04-13T02:22:02Z","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20251010222653396605000000","duration_ms":10}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260201025009135039000000","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260201025009135039000000","PhotosChangeTimestamp":"2026-03-01 04:26:07","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260201025009135039000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260201025009135039000000","duration_ms":6}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260318174736337489000000","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Photos saved {"listing_id":"20260318174736337489000000","count":15,"duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260318174736337489000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260318174736337489000000","duration_ms":8}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260312153828419255000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260312153828419255000000","PhotosChangeTimestamp":"2026-04-03 15:40:54","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260312153828419255000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260312153828419255000000","duration_ms":5}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20240816192538170623000000","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20240816192538170623000000","PhotosChangeTimestamp":"2026-04-07 20:43:20","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20240816192538170623000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20240816192538170623000000","duration_ms":5}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20250701184425261211000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20250701184425261211000000","PhotosChangeTimestamp":"2025-07-03 07:15:42","duration_ms":0}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20250701184425261211000000","duration_ms":0}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20250701184425261211000000","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260318180136524251000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260318180136524251000000","PhotosChangeTimestamp":"2026-03-25 02:46:01","duration_ms":0}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260318180136524251000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260318180136524251000000","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260410213404333826000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260410213404333826000000","PhotosChangeTimestamp":"2026-04-10 23:58:13","duration_ms":0}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260410213404333826000000","duration_ms":0}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260410213404333826000000","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260117173805560613000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260117173805560613000000","PhotosChangeTimestamp":"2026-03-24 16:58:34","duration_ms":0}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260117173805560613000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260117173805560613000000","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260408021709020446000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos saved {"listing_id":"20260408021709020446000000","count":9,"duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260408021709020446000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260408021709020446000000","duration_ms":6}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260306173756610996000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260306173756610996000000","PhotosChangeTimestamp":"2026-03-06 18:00:11","duration_ms":0}
[2026-04-13T02:40:03+00:00] INFO History recorded {"listing_id":"20260306173756610996000000","event":"Price Decreased","price_change":"Price Decreased","price_change_ts":"2026-04-13 02:34:37","last_update":"2026-04-13T02:34:37Z","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260306173756610996000000","duration_ms":7}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260113231542747377000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos saved {"listing_id":"20260113231542747377000000","count":48,"duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260113231542747377000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260113231542747377000000","duration_ms":8}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260102145901211937000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260102145901211937000000","PhotosChangeTimestamp":"2026-02-10 03:27:09","duration_ms":0}
[2026-04-13T02:40:03+00:00] INFO History recorded {"listing_id":"20260102145901211937000000","event":"Price Decreased","price_change":"Price Decreased","price_change_ts":"2026-04-13 02:35:41","last_update":"2026-04-13T02:35:41Z","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260102145901211937000000","duration_ms":7}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260313020140385910000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260313020140385910000000","PhotosChangeTimestamp":"2026-04-02 16:42:43","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260313020140385910000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260313020140385910000000","duration_ms":5}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20251118163346881259000000","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20251118163346881259000000","PhotosChangeTimestamp":"2025-11-18 19:14:58","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20251118163346881259000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20251118163346881259000000","duration_ms":6}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20251119190514547268000000","duration_ms":3}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20251119190514547268000000","PhotosChangeTimestamp":"2026-04-08 17:43:54","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20251119190514547268000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20251119190514547268000000","duration_ms":5}
[2026-04-13T02:40:03+00:00] INFO Listing upserted {"id":"20260120024046262889000000","duration_ms":4}
[2026-04-13T02:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260120024046262889000000","PhotosChangeTimestamp":"2026-03-29 16:46:00","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260120024046262889000000","duration_ms":1}
[2026-04-13T02:40:03+00:00] INFO Listing processed {"listing_id":"20260120024046262889000000","duration_ms":6}
[2026-04-13T02:40:03+00:00] INFO Spark nextLink {"nextLink":null}
[2026-04-13T02:40:03+00:00] INFO Offset updated {"script":"Listing","raw":"2026-04-13 02:39:49.000","adjusted":true}
[2026-04-13T02:40:03+00:00] INFO Property sync complete {"last_modification":"2026-04-13T02:39:49+00:00"}
[2026-04-13T02:40:03+00:00] INFO Property sync finished {"status":"ok","duration_ms":2341}