[2026-04-18T12:20:02+00:00] INFO Starting property sync {"start":"2026-04-18T11:59:15+00:00","end":"2026-04-18T14:59:15+00:00","offset_fetch_duration_ms":11,"page_size":100,"expand":["Media","OpenHouse","Unit","Room"],"statuses":["Active","Coming Soon","Active Under Contract"],"property_types":["Residential"]}
[2026-04-18T12:20:02+00:00] INFO Spark filter constructed {"filter":"ModificationTimestamp gt 2026-04-18T11:59:15Z and ModificationTimestamp lt 2026-04-18T14:59:15Z and (StandardStatus eq 'Active' or StandardStatus eq 'Coming Soon' or StandardStatus eq 'Active Under Contract') and (PropertyType eq 'Residential')"}
[2026-04-18T12:20:02+00:00] INFO Spark initial request {"url":"https://replication.sparkapi.com/Version/3/Reso/OData/Property?%24filter=ModificationTimestamp+gt+2026-04-18T11%3A59%3A15Z+and+ModificationTimestamp+lt+2026-04-18T14%3A59%3A15Z+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-18T12:20:03+00:00] INFO Spark API response {"status":200,"url":"https://replication.sparkapi.com/Version/3/Reso/OData/Property?%24filter=ModificationTimestamp+gt+2026-04-18T11%3A59%3A15Z+and+ModificationTimestamp+lt+2026-04-18T14%3A59%3A15Z+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":34,"duration_ms":1184}
[2026-04-18T12:20:03+00:00] INFO Processing page {"count":34,"has_next":false}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260322104912961040000000","duration_ms":209}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260322104912961040000000","PhotosChangeTimestamp":"2026-03-29 12:44:32","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO History recorded {"listing_id":"20260322104912961040000000","event":"Status Active Under Contract","price_change":"","price_change_ts":null,"last_update":"2026-04-18T12:03:12Z","duration_ms":116}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260322104912961040000000","duration_ms":326}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"603299201","duration_ms":17}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"603299201","PhotosChangeTimestamp":"2025-09-02 17:08:19","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"603299201","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"603299201","duration_ms":19}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"605105941","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"605105941","PhotosChangeTimestamp":"2025-10-11 00:23:21","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO History recorded {"listing_id":"605105941","event":"Price Increased","price_change":"Price Increased","price_change_ts":"2026-04-18 12:04:05","last_update":"2026-04-18T12:04:05Z","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"605105941","duration_ms":9}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260403233406620607000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260403233406620607000000","PhotosChangeTimestamp":"2026-04-04 11:57:29","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO History recorded {"listing_id":"20260403233406620607000000","event":"Status Active Under Contract","price_change":"","price_change_ts":null,"last_update":"2026-04-18T12:05:29Z","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260403233406620607000000","duration_ms":9}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260407180553179079000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260407180553179079000000","PhotosChangeTimestamp":"2026-04-07 20:42:43","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260407180553179079000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260407180553179079000000","duration_ms":6}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20250818212040942902000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20250818212040942902000000","PhotosChangeTimestamp":"2026-03-06 08:19:42","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20250818212040942902000000","duration_ms":2}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20250818212040942902000000","duration_ms":6}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260129194333688585000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260129194333688585000000","PhotosChangeTimestamp":"2026-03-18 23:31:07","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260129194333688585000000","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260129194333688585000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260414114111553334000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260414114111553334000000","count":27,"duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260414114111553334000000","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260414114111553334000000","duration_ms":7}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20250905135643732655000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20250905135643732655000000","count":66,"duration_ms":6}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20250905135643732655000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20250905135643732655000000","duration_ms":10}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20251027121054906541000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20251027121054906541000000","count":59,"duration_ms":5}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20251027121054906541000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20251027121054906541000000","duration_ms":10}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260417213052901915000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260417213052901915000000","PhotosChangeTimestamp":"2026-04-18 11:27:28","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260417213052901915000000","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260417213052901915000000","duration_ms":5}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"610916391","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"610916391","PhotosChangeTimestamp":"2026-03-06 19:02:31","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"610916391","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"610916391","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20251220220816833472000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20251220220816833472000000","PhotosChangeTimestamp":"2025-12-27 18:51:09","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20251220220816833472000000","duration_ms":2}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20251220220816833472000000","duration_ms":6}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260402200554295331000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260402200554295331000000","count":56,"duration_ms":5}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260402200554295331000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260402200554295331000000","duration_ms":9}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260412235436659264000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260412235436659264000000","count":42,"duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO History recorded {"listing_id":"20260412235436659264000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-18T12:11:19Z","duration_ms":2}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260412235436659264000000","duration_ms":9}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260321155704792554000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260321155704792554000000","count":33,"duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260321155704792554000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260321155704792554000000","duration_ms":9}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260410024210046955000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260410024210046955000000","count":9,"duration_ms":2}
[2026-04-18T12:20:03+00:00] INFO History recorded {"listing_id":"20260410024210046955000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-18T12:12:57Z","duration_ms":2}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260410024210046955000000","duration_ms":7}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20240812152538680062000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20240812152538680062000000","PhotosChangeTimestamp":"2025-08-19 06:22:57","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20240812152538680062000000","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20240812152538680062000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20250913154425994110000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20250913154425994110000000","PhotosChangeTimestamp":"2025-09-17 20:59:43","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20250913154425994110000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20250913154425994110000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260401131909372610000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260401131909372610000000","count":27,"duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260401131909372610000000","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260401131909372610000000","duration_ms":7}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260329133006156215000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260329133006156215000000","count":76,"duration_ms":5}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260329133006156215000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260329133006156215000000","duration_ms":9}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260313013246461001000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260313013246461001000000","PhotosChangeTimestamp":"2026-03-13 02:46:04","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260313013246461001000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260313013246461001000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260215202921405533000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260215202921405533000000","PhotosChangeTimestamp":"2026-02-15 20:46:45","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260215202921405533000000","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260215202921405533000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260228014705900891000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260228014705900891000000","count":26,"duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260228014705900891000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260228014705900891000000","duration_ms":9}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260328174504163475000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260328174504163475000000","PhotosChangeTimestamp":"2026-04-02 15:43:19","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260328174504163475000000","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260328174504163475000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260402235324281538000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260402235324281538000000","PhotosChangeTimestamp":"2026-04-03 01:28:18","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260402235324281538000000","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260402235324281538000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260406234909108960000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260406234909108960000000","count":77,"duration_ms":5}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260406234909108960000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260406234909108960000000","duration_ms":8}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260207190613879089000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260207190613879089000000","PhotosChangeTimestamp":"2026-02-18 13:46:13","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260207190613879089000000","duration_ms":2}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260207190613879089000000","duration_ms":6}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260417020228461214000000","duration_ms":3}
[2026-04-18T12:20:03+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260417020228461214000000","PhotosChangeTimestamp":"2026-04-17 02:47:29","duration_ms":0}
[2026-04-18T12:20:03+00:00] INFO History unchanged, skipping {"listing_id":"20260417020228461214000000","duration_ms":1}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260417020228461214000000","duration_ms":5}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260418113451202667000000","duration_ms":4}
[2026-04-18T12:20:03+00:00] INFO Photos saved {"listing_id":"20260418113451202667000000","count":13,"duration_ms":2}
[2026-04-18T12:20:03+00:00] INFO History recorded {"listing_id":"20260418113451202667000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-18T12:18:36Z","duration_ms":2}
[2026-04-18T12:20:03+00:00] INFO Listing processed {"listing_id":"20260418113451202667000000","duration_ms":9}
[2026-04-18T12:20:03+00:00] INFO Listing upserted {"id":"20260418001658482006000000","duration_ms":4}
[2026-04-18T12:20:04+00:00] INFO Photos saved {"listing_id":"20260418001658482006000000","count":65,"duration_ms":3}
[2026-04-18T12:20:04+00:00] INFO History recorded {"listing_id":"20260418001658482006000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-18T12:19:31Z","duration_ms":2}
[2026-04-18T12:20:04+00:00] INFO Listing processed {"listing_id":"20260418001658482006000000","duration_ms":10}
[2026-04-18T12:20:04+00:00] INFO Listing upserted {"id":"20260418025354915831000000","duration_ms":3}
[2026-04-18T12:20:04+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260418025354915831000000","PhotosChangeTimestamp":"2026-04-18 03:39:26","duration_ms":0}
[2026-04-18T12:20:04+00:00] INFO History unchanged, skipping {"listing_id":"20260418025354915831000000","duration_ms":1}
[2026-04-18T12:20:04+00:00] INFO Listing processed {"listing_id":"20260418025354915831000000","duration_ms":5}
[2026-04-18T12:20:04+00:00] INFO Listing upserted {"id":"20260204172359925254000000","duration_ms":4}
[2026-04-18T12:20:04+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260204172359925254000000","PhotosChangeTimestamp":"2026-04-07 11:34:47","duration_ms":1}
[2026-04-18T12:20:04+00:00] INFO History recorded {"listing_id":"20260204172359925254000000","event":"Status Active Under Contract","price_change":"","price_change_ts":"2026-03-23 20:19:25","last_update":"2026-04-18T12:19:32Z","duration_ms":3}
[2026-04-18T12:20:04+00:00] INFO Listing processed {"listing_id":"20260204172359925254000000","duration_ms":8}
[2026-04-18T12:20:04+00:00] INFO Listing upserted {"id":"20251011014453261474000000","duration_ms":4}
[2026-04-18T12:20:04+00:00] INFO Photos unchanged, skipping save {"listing_id":"20251011014453261474000000","PhotosChangeTimestamp":"2025-11-08 00:49:13","duration_ms":1}
[2026-04-18T12:20:04+00:00] INFO History unchanged, skipping {"listing_id":"20251011014453261474000000","duration_ms":1}
[2026-04-18T12:20:04+00:00] INFO Listing processed {"listing_id":"20251011014453261474000000","duration_ms":5}
[2026-04-18T12:20:04+00:00] INFO Spark nextLink {"nextLink":null}
[2026-04-18T12:20:04+00:00] INFO Offset updated {"script":"Listing","raw":"2026-04-18 12:19:55.000","adjusted":true}
[2026-04-18T12:20:04+00:00] INFO Property sync complete {"last_modification":"2026-04-18T12:19:55+00:00"}
[2026-04-18T12:20:04+00:00] INFO Property sync finished {"status":"ok","duration_ms":2513}