[2026-04-18T20:40:01+00:00] INFO Starting property sync {"start":"2026-04-18T20:20:02+00:00","end":"2026-04-18T23:20:02+00:00","offset_fetch_duration_ms":0,"page_size":100,"expand":["Media","OpenHouse","Unit","Room"],"statuses":["Active","Coming Soon","Active Under Contract"],"property_types":["Residential"]}
[2026-04-18T20:40:01+00:00] INFO Spark filter constructed {"filter":"ModificationTimestamp gt 2026-04-18T20:20:02Z and ModificationTimestamp lt 2026-04-18T23:20:02Z and (StandardStatus eq 'Active' or StandardStatus eq 'Coming Soon' or StandardStatus eq 'Active Under Contract') and (PropertyType eq 'Residential')"}
[2026-04-18T20:40:01+00:00] INFO Spark initial request {"url":"https://replication.sparkapi.com/Version/3/Reso/OData/Property?%24filter=ModificationTimestamp+gt+2026-04-18T20%3A20%3A02Z+and+ModificationTimestamp+lt+2026-04-18T23%3A20%3A02Z+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-18T20: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-18T20%3A20%3A02Z+and+ModificationTimestamp+lt+2026-04-18T23%3A20%3A02Z+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":31,"duration_ms":1199}
[2026-04-18T20:40:03+00:00] INFO Processing page {"count":31,"has_next":false}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260413185654489170000000","duration_ms":13}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20260413185654489170000000","count":23,"duration_ms":6}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260413185654489170000000","duration_ms":0}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260413185654489170000000","duration_ms":21}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260401170226924784000000","duration_ms":5}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20260401170226924784000000","count":68,"duration_ms":11}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260401170226924784000000","duration_ms":0}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260401170226924784000000","duration_ms":17}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260409162348705916000000","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260409162348705916000000","PhotosChangeTimestamp":"2026-04-09 19:02:27","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"20260409162348705916000000","event":"Price Decreased","price_change":"Price Decreased","price_change_ts":"2026-04-18 20:22:24","last_update":"2026-04-18T20:22:24Z","duration_ms":8}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260409162348705916000000","duration_ms":14}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260324004649677169000000","duration_ms":13}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20260324004649677169000000","count":72,"duration_ms":111}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260324004649677169000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260324004649677169000000","duration_ms":126}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"601481371","duration_ms":48}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"601481371","count":99,"duration_ms":5}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"601481371","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"601481371","duration_ms":55}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"597077579","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"597077579","PhotosChangeTimestamp":"2025-11-12 04:54:57","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"597077579","event":"Status Active Under Contract","price_change":"","price_change_ts":"2026-04-04 16:38:24","last_update":"2026-04-18T20:24:47Z","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"597077579","duration_ms":8}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"609910943","duration_ms":9}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"609910943","PhotosChangeTimestamp":"2026-02-12 14:20:29","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"609910943","event":"Status Active Under Contract","price_change":"","price_change_ts":"2026-04-08 22:09:36","last_update":"2026-04-18T20:25:29Z","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"609910943","duration_ms":14}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"603557422","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"603557422","PhotosChangeTimestamp":"2026-03-31 19:14:58","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"603557422","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"603557422","duration_ms":6}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20251212015950194349000000","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20251212015950194349000000","count":42,"duration_ms":9}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20251212015950194349000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20251212015950194349000000","duration_ms":15}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260411014459890589000000","duration_ms":10}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260411014459890589000000","PhotosChangeTimestamp":"2026-04-11 05:02:49","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260411014459890589000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260411014459890589000000","duration_ms":12}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260413230241091234000000","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260413230241091234000000","PhotosChangeTimestamp":"2026-04-14 00:10:13","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260413230241091234000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260413230241091234000000","duration_ms":6}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"604638385","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"604638385","PhotosChangeTimestamp":"2025-11-04 19:32:39","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"604638385","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"604638385","duration_ms":5}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260312194013699076000000","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260312194013699076000000","PhotosChangeTimestamp":"2026-03-23 15:24:16","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260312194013699076000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260312194013699076000000","duration_ms":5}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260404183816324708000000","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260404183816324708000000","PhotosChangeTimestamp":"2026-04-09 21:08:12","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260404183816324708000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260404183816324708000000","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260418181510886177000000","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20260418181510886177000000","count":60,"duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"20260418181510886177000000","event":"Status Coming Soon","price_change":"","price_change_ts":null,"last_update":"2026-04-18T20:32:13Z","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260418181510886177000000","duration_ms":10}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260418001457280521000000","duration_ms":7}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20260418001457280521000000","count":46,"duration_ms":8}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"20260418001457280521000000","event":"Status Coming Soon","price_change":"","price_change_ts":null,"last_update":"2026-04-18T20:32:17Z","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260418001457280521000000","duration_ms":19}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260418191114978159000000","duration_ms":6}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260418191114978159000000","PhotosChangeTimestamp":"2026-04-18 19:38:31","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260418191114978159000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260418191114978159000000","duration_ms":7}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"610383160","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"610383160","count":63,"duration_ms":14}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"610383160","duration_ms":2}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"610383160","duration_ms":21}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"604293108","duration_ms":41}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"604293108","PhotosChangeTimestamp":"2026-02-28 15:40:56","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"604293108","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"604293108","duration_ms":43}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260417201658990708000000","duration_ms":5}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260417201658990708000000","PhotosChangeTimestamp":"2026-04-18 19:54:51","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260417201658990708000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260417201658990708000000","duration_ms":7}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260418170733202923000000","duration_ms":5}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20260418170733202923000000","count":7,"duration_ms":2}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"20260418170733202923000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-18T20:35:00Z","duration_ms":2}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260418170733202923000000","duration_ms":10}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20250423165538917542000000","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20250423165538917542000000","PhotosChangeTimestamp":"2026-01-01 23:51:08","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"20250423165538917542000000","event":"Price Decreased","price_change":"Price Decreased","price_change_ts":"2026-04-18 20:35:40","last_update":"2026-04-18T20:35:40Z","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20250423165538917542000000","duration_ms":10}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260417185447791997000000","duration_ms":6}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260417185447791997000000","PhotosChangeTimestamp":"2026-04-17 20:07:57","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260417185447791997000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260417185447791997000000","duration_ms":8}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"605441372","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"605441372","PhotosChangeTimestamp":"2026-01-12 21:13:03","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"605441372","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"605441372","duration_ms":6}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260413142859701209000000","duration_ms":5}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260413142859701209000000","PhotosChangeTimestamp":"2026-04-17 17:35:13","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260413142859701209000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260413142859701209000000","duration_ms":7}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260404204606123565000000","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260404204606123565000000","PhotosChangeTimestamp":"2026-04-05 00:11:36","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260404204606123565000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260404204606123565000000","duration_ms":5}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260413141519970058000000","duration_ms":6}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20260413141519970058000000","count":38,"duration_ms":75}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"20260413141519970058000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-18T20:39:04Z","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260413141519970058000000","duration_ms":85}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260403194322489863000000","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20260403194322489863000000","count":16,"duration_ms":2}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"20260403194322489863000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-18T20:39:17Z","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260403194322489863000000","duration_ms":10}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260106202918775418000000","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260106202918775418000000","PhotosChangeTimestamp":"2026-01-21 22:59:57","duration_ms":2}
[2026-04-18T20:40:03+00:00] INFO History recorded {"listing_id":"20260106202918775418000000","event":"Price Decreased","price_change":"Price Decreased","price_change_ts":"2026-04-18 20:39:24","last_update":"2026-04-18T20:39:24Z","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260106202918775418000000","duration_ms":9}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260121204238634947000000","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260121204238634947000000","PhotosChangeTimestamp":"2026-04-08 16:23:15","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260121204238634947000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260121204238634947000000","duration_ms":4}
[2026-04-18T20:40:03+00:00] INFO Listing upserted {"id":"20260413001131320579000000","duration_ms":3}
[2026-04-18T20:40:03+00:00] INFO Photos saved {"listing_id":"20260413001131320579000000","count":41,"duration_ms":8}
[2026-04-18T20:40:03+00:00] INFO History unchanged, skipping {"listing_id":"20260413001131320579000000","duration_ms":1}
[2026-04-18T20:40:03+00:00] INFO Listing processed {"listing_id":"20260413001131320579000000","duration_ms":13}
[2026-04-18T20:40:03+00:00] INFO Spark nextLink {"nextLink":null}
[2026-04-18T20:40:04+00:00] INFO Offset updated {"script":"Listing","raw":"2026-04-18 20:40:01.000","adjusted":true}
[2026-04-18T20:40:04+00:00] INFO Property sync complete {"last_modification":"2026-04-18T20:40:01+00:00"}
[2026-04-18T20:40:04+00:00] INFO Property sync finished {"status":"ok","duration_ms":2537}