[2026-04-16T02:40:01+00:00] INFO Starting property sync {"start":"2026-04-16T02:19:39+00:00","end":"2026-04-16T05:19:39+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-16T02:40:01+00:00] INFO Spark filter constructed {"filter":"ModificationTimestamp gt 2026-04-16T02:19:39Z and ModificationTimestamp lt 2026-04-16T05:19:39Z and (StandardStatus eq 'Active' or StandardStatus eq 'Coming Soon' or StandardStatus eq 'Active Under Contract') and (PropertyType eq 'Residential')"}
[2026-04-16T02:40:01+00:00] INFO Spark initial request {"url":"https://replication.sparkapi.com/Version/3/Reso/OData/Property?%24filter=ModificationTimestamp+gt+2026-04-16T02%3A19%3A39Z+and+ModificationTimestamp+lt+2026-04-16T05%3A19%3A39Z+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-16T02:40:02+00:00] INFO Spark API response {"status":200,"url":"https://replication.sparkapi.com/Version/3/Reso/OData/Property?%24filter=ModificationTimestamp+gt+2026-04-16T02%3A19%3A39Z+and+ModificationTimestamp+lt+2026-04-16T05%3A19%3A39Z+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":33,"duration_ms":1209}
[2026-04-16T02:40:02+00:00] INFO Processing page {"count":33,"has_next":false}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260416010312181983000000","duration_ms":12}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260416010312181983000000","PhotosChangeTimestamp":"2026-04-16 01:28:33","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260416010312181983000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260416010312181983000000","duration_ms":14}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260416012121842110000000","duration_ms":11}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260416012121842110000000","PhotosChangeTimestamp":"2026-04-16 02:05:27","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260416012121842110000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260416012121842110000000","duration_ms":13}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260416012924772203000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260416012924772203000000","PhotosChangeTimestamp":"2026-04-16 02:06:20","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260416012924772203000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260416012924772203000000","duration_ms":5}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260416014059154724000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260416014059154724000000","PhotosChangeTimestamp":"2026-04-16 02:04:50","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260416014059154724000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260416014059154724000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260415014433485233000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260415014433485233000000","PhotosChangeTimestamp":"2026-04-16 01:48:02","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260415014433485233000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260415014433485233000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260413024717300872000000","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260413024717300872000000","PhotosChangeTimestamp":"2026-04-16 01:27:43","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260413024717300872000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260413024717300872000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260414114111553334000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260414114111553334000000","PhotosChangeTimestamp":"2026-04-16 02:08:10","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260414114111553334000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260414114111553334000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260414140803496160000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260414140803496160000000","PhotosChangeTimestamp":"2026-04-16 01:48:44","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260414140803496160000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260414140803496160000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260415031135920275000000","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260415031135920275000000","PhotosChangeTimestamp":"2026-04-16 02:02:38","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260415031135920275000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260415031135920275000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20251031010125487282000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20251031010125487282000000","PhotosChangeTimestamp":"2026-03-21 21:10:47","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20251031010125487282000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20251031010125487282000000","duration_ms":6}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260407180553179079000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260407180553179079000000","PhotosChangeTimestamp":"2026-04-07 20:42:43","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260407180553179079000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260407180553179079000000","duration_ms":6}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20250925180009557671000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20250925180009557671000000","PhotosChangeTimestamp":"2025-09-25 18:03:29","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20250925180009557671000000","event":"Price Decreased","price_change":"Price Decreased","price_change_ts":"2026-04-16 02:23:50","last_update":"2026-04-16T02:23:50Z","duration_ms":8}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20250925180009557671000000","duration_ms":13}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260331210459560620000000","duration_ms":5}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20260331210459560620000000","count":116,"duration_ms":16}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260331210459560620000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260331210459560620000000","duration_ms":22}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260125155528230484000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260125155528230484000000","PhotosChangeTimestamp":"2026-01-29 13:07:37","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260125155528230484000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260125155528230484000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260304213203340689000000","duration_ms":5}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260304213203340689000000","PhotosChangeTimestamp":"2026-03-05 10:52:47","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20260304213203340689000000","event":"Status Active Under Contract","price_change":"","price_change_ts":"2026-03-31 16:00:23","last_update":"2026-04-16T02:24:20Z","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260304213203340689000000","duration_ms":12}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20251001141645255455000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20251001141645255455000000","PhotosChangeTimestamp":"2026-04-02 03:30:38","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20251001141645255455000000","event":"Price Decreased","price_change":"Price Decreased","price_change_ts":"2026-04-16 02:28:02","last_update":"2026-04-16T02:28:02Z","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20251001141645255455000000","duration_ms":8}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"605264780","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"605264780","PhotosChangeTimestamp":"2026-02-24 21:08:22","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"605264780","duration_ms":8}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"605264780","duration_ms":13}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260416014259199965000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20260416014259199965000000","count":1,"duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20260416014259199965000000","event":"Status Coming Soon","price_change":"","price_change_ts":null,"last_update":"2026-04-16T02:31:53Z","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260416014259199965000000","duration_ms":8}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260415210920119382000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20260415210920119382000000","count":1,"duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20260415210920119382000000","event":"Status Coming Soon","price_change":"","price_change_ts":null,"last_update":"2026-04-16T02:32:45Z","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260415210920119382000000","duration_ms":8}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260414125451431285000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260414125451431285000000","PhotosChangeTimestamp":"2026-04-16 02:03:08","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260414125451431285000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260414125451431285000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260415231052228324000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260415231052228324000000","PhotosChangeTimestamp":"2026-04-16 00:49:41","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260415231052228324000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260415231052228324000000","duration_ms":5}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260407165129806933000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260407165129806933000000","PhotosChangeTimestamp":"2026-04-15 17:09:04","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260407165129806933000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260407165129806933000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260409180658919390000000","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260409180658919390000000","PhotosChangeTimestamp":"2026-04-09 19:24:11","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260409180658919390000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260409180658919390000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260415183523515409000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260415183523515409000000","PhotosChangeTimestamp":"2026-04-15 20:04:19","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260415183523515409000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260415183523515409000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260414224853725561000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20260414224853725561000000","count":32,"duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20260414224853725561000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-16T02:38:27Z","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260414224853725561000000","duration_ms":7}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260416014125283736000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20260416014125283736000000","count":33,"duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20260416014125283736000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-16T02:38:36Z","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260416014125283736000000","duration_ms":7}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20251204173810232724000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20251204173810232724000000","count":57,"duration_ms":9}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20251204173810232724000000","event":"Price Increased","price_change":"Price Increased","price_change_ts":"2026-04-16 02:39:09","last_update":"2026-04-16T02:39:09Z","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20251204173810232724000000","duration_ms":17}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260416001805342395000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20260416001805342395000000","count":33,"duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20260416001805342395000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-16T02:39:09Z","duration_ms":21}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260416001805342395000000","duration_ms":28}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260416013428652316000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20260416013428652316000000","count":46,"duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20260416013428652316000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-16T02:39:39Z","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260416013428652316000000","duration_ms":8}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260416020354362223000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20260416020354362223000000","count":24,"duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO History recorded {"listing_id":"20260416020354362223000000","event":"Status Active","price_change":"","price_change_ts":null,"last_update":"2026-04-16T02:39:39Z","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260416020354362223000000","duration_ms":9}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"606666657","duration_ms":2}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"606666657","PhotosChangeTimestamp":"2025-11-18 02:41:01","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"606666657","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"606666657","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260324042918573191000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos unchanged, skipping save {"listing_id":"20260324042918573191000000","PhotosChangeTimestamp":"2026-04-15 15:09:56","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260324042918573191000000","duration_ms":0}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260324042918573191000000","duration_ms":4}
[2026-04-16T02:40:02+00:00] INFO Listing upserted {"id":"20260407232151699580000000","duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO Photos saved {"listing_id":"20260407232151699580000000","count":48,"duration_ms":3}
[2026-04-16T02:40:02+00:00] INFO History unchanged, skipping {"listing_id":"20260407232151699580000000","duration_ms":1}
[2026-04-16T02:40:02+00:00] INFO Listing processed {"listing_id":"20260407232151699580000000","duration_ms":8}
[2026-04-16T02:40:02+00:00] INFO Spark nextLink {"nextLink":null}
[2026-04-16T02:40:03+00:00] INFO Offset updated {"script":"Listing","raw":"2026-04-16 02:40:00.000","adjusted":true}
[2026-04-16T02:40:03+00:00] INFO Property sync complete {"last_modification":"2026-04-16T02:40:00+00:00"}
[2026-04-16T02:40:03+00:00] INFO Property sync finished {"status":"ok","duration_ms":1938}