New photos added in with new paint & kitchen! Experience waterfront living on the St. Clair River in this beautifully maintained 3-bedroom, 1.5-bath bungalow available for lease. Offering the convenience of main-floor living, this home is situated on a deep, landscaped lot with breathtaking river views. Enjoy watching boats pass by from the kitchen, dining, and living areas, or relax
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:6 [ "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29927188 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474 +post_id: "1547490" +post_author: 1 +"ListingKey": "29927188" +"ListingId": "26014514" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-03T13:45:02Z" +"RFModificationTimestamp": "2026-07-03T14:03:53Z" +"ListPrice": 0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Sombra" +"PostalCode": "N0P2H0" +"UnparsedAddress": "2995 ST. CLAIR PARKWAY, Sombra, Ontario N0P2H0" +"Coordinates": array:2 [ 0 => -82.472336 1 => 42.742374 ] +"Latitude": 42.742374 +"Longitude": -82.472336 +"YearBuilt": 1962 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Sarnia-Lambton Association of REALTORS®" +"PublicRemarks": "New photos added in with new paint & kitchen! Experience waterfront living on the St. Clair River in this beautifully maintained 3-bedroom, 1.5-bath bungalow available for lease. Offering the convenience of main-floor living, this home is situated on a deep, landscaped lot with breathtaking river views. Enjoy watching boats pass by from the kitchen, dining, and living areas, or relax on the newer dock overlooking the water with boat and seadoo lift. The inviting front sitting area is perfect for morning coffee, while the 32' deep double garage provides ample space for vehicles, storage, hobbies, or a workshop. A wall-mounted Mitsubishi air conditioning unit ensures comfort throughout the warmer months. Recently painted bedrooms & kitchen, new kitchen countertop, new stainless steel washer and dryer. Available furnished or unfurnished to suit your needs. Lease price is plus utilities. (id:62650)" +"Appliances": array:5 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"BathroomsPartial": 1 +"CreationDate": "2026-06-19T16:14:41.630987+00:00" +"ExteriorFeatures": array:1 [ 0 => "Aluminum/Vinyl" ] +"FireplaceFeatures": array:2 [ 0 => "Gas" 1 => "Direct vent" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:3 [ 0 => "Hardwood" 1 => "Ceramic/Porcelain" 2 => "Cushion/Lino/Vinyl" ] +"FoundationDetails": array:1 [ 0 => "Block" ] +"Heating": array:3 [ 0 => "Forced air" 1 => "Natural gas" 2 => "Furnace" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2156370" +"ListOfficeKey": "283922" +"LotFeatures": array:2 [ 0 => "Front Driveway" 1 => "Gravel Driveway" ] +"LotSizeDimensions": "44.33 X 321.19/322.99" +"ParkingFeatures": array:2 [ 0 => "Attached Garage" 1 => "Garage" ] +"PhotosChangeTimestamp": "2026-07-03T13:40:12Z" +"PhotosCount": 43 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-07-03T13:40:12Z" +"Stories": "1.0" +"StreetName": "ST. CLAIR" +"StreetNumber": "2995" +"StreetSuffix": "Parkway" +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=3Gd4cbcx2no" +"Rooms": array:10 [ 0 => array:11 [ "RoomKey" => "1674090946" "RoomType" => "4pc Bathroom" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.65Z" ] 1 => array:11 [ "RoomKey" => "1674090947" "RoomType" => "2pc Bathroom" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.66Z" ] 2 => array:11 [ "RoomKey" => "1674090948" "RoomType" => "Laundry room" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => "7.4 x 12.7" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.66Z" ] 3 => array:11 [ "RoomKey" => "1674090949" "RoomType" => "Mud room" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => "9.11 x 8.3" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.66Z" ] 4 => array:11 [ "RoomKey" => "1674090950" "RoomType" => "Living room" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => "15.4 x 12.3" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.66Z" ] 5 => array:11 [ "RoomKey" => "1674090951" "RoomType" => "Primary Bedroom" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => "9.10 x 12.2" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.66Z" ] 6 => array:11 [ "RoomKey" => "1674090952" "RoomType" => "Bedroom" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => "8.9 x 11.2" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.66Z" ] 7 => array:11 [ "RoomKey" => "1674090953" "RoomType" => "Bedroom" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => "7.11 x 12.2" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.66Z" ] 8 => array:11 [ "RoomKey" => "1674090954" "RoomType" => "Family room" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => "12.5 x 15.11" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.66Z" ] 9 => array:11 [ "RoomKey" => "1674090955" "RoomType" => "Kitchen/Dining room" "ListingId" => "26014514" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29927188" "RoomLength" => null "RoomDimensions" => "19.7 x 12.9" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-07-03T13:40:12.66Z" ] ] +"ListAOR": "Sarnia" +"TaxYear": 2026 +"ListAORKey": "95" +"ListingURL": "www.realtor.ca/real-estate/29927188/2995-st-clair-parkway-sombra" +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "2081429" +"CommonInterest": "Freehold" +"CoListOfficeKey": "283922" +"GeocodeManualYN": false +"TotalActualRent": 2600 +"ZoningDescription": "RS" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 0 +"WaterfrontFeatures": array:1 [ 0 => "Waterfront on river" ] +"LeaseAmountFrequency": "Monthly" +"OriginalEntryTimestamp": "2026-06-19T13:02:24.23Z" +"ListAgentNationalAssociationId": "1407739" +"ListOfficeNationalAssociationId": "1336852" +"CoListAgentNationalAssociationId": "1356233" +"CoListOfficeNationalAssociationId": "1336852" +"Media": array:43 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29927188_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/6cade7dbca1b102dab695d2001f3ac35.webp" "MediaSize" => 191581 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-6cade7dbca1b102dab695d2001f3ac35.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.54Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29927188_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/a97283c53964a67b0ff4384f82711cde.webp" "MediaSize" => 150769 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-a97283c53964a67b0ff4384f82711cde.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-06-19T13:02:24.24Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29927188_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/d6e179ae24ab82aea1ca087aec9c36d4.webp" "MediaSize" => 153097 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-d6e179ae24ab82aea1ca087aec9c36d4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-06-19T13:02:24.24Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29927188_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/d16261a5da7149833d7fdc5c4cadc050.webp" "MediaSize" => 77194 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-d16261a5da7149833d7fdc5c4cadc050.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29927188_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/f15cac5fbd01b975cada3feaa175aac9.webp" "MediaSize" => 80431 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-f15cac5fbd01b975cada3feaa175aac9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29927188_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/4fb183d6e484277821f043516fb3eda6.webp" "MediaSize" => 100069 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-4fb183d6e484277821f043516fb3eda6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.73Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29927188_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/8464c71eb9d0416f33f02ea3623ef8b0.webp" "MediaSize" => 109883 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-8464c71eb9d0416f33f02ea3623ef8b0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.53Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29927188_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/e3e9959bc274292a625eba2e4a0f8992.webp" "MediaSize" => 83614 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-e3e9959bc274292a625eba2e4a0f8992.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.57Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29927188_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/15f8ad05f9012f21ea616619a21953de.webp" "MediaSize" => 92318 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-15f8ad05f9012f21ea616619a21953de.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29927188_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/ed0784ce423c4c52370930bf27ec997f.webp" "MediaSize" => 86764 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-ed0784ce423c4c52370930bf27ec997f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.53Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29927188_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/251d82c78b1d1b6643b6e22f950db5e7.webp" "MediaSize" => 81795 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-251d82c78b1d1b6643b6e22f950db5e7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29927188_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/b536cebd3d36d84465b9c1f1dd24be24.webp" "MediaSize" => 86026 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-b536cebd3d36d84465b9c1f1dd24be24.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29927188_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/51dd15a129d393a15170771a4bf55752.webp" "MediaSize" => 65610 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-51dd15a129d393a15170771a4bf55752.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.72Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29927188_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/21f43d907e41d3dbb166c95b2ae2d252.webp" "MediaSize" => 90334 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-21f43d907e41d3dbb166c95b2ae2d252.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29927188_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/820140536a82fe08615b27d73ec674fa.webp" "MediaSize" => 85130 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-820140536a82fe08615b27d73ec674fa.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.72Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29927188_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/012b01381789662a2d76c1e222aa2d70.webp" "MediaSize" => 92465 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-012b01381789662a2d76c1e222aa2d70.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29927188_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/ed8148f98a41990130b13024a3f5692a.webp" "MediaSize" => 99922 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-ed8148f98a41990130b13024a3f5692a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.72Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29927188_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/2fd28aa85df27b8eb0a57362871313e8.webp" "MediaSize" => 103505 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-2fd28aa85df27b8eb0a57362871313e8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-06-19T13:02:24.24Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29927188_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/f1e9520a4339edb94a530f5816700012.webp" "MediaSize" => 70377 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-f1e9520a4339edb94a530f5816700012.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-06-19T13:02:24.24Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29927188_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/1190fa25c0e80e85a47497afbbb2bc4d.webp" "MediaSize" => 60183 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-1190fa25c0e80e85a47497afbbb2bc4d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29927188_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/48fae9d115905bc558abe3e914dafc98.webp" "MediaSize" => 56859 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-48fae9d115905bc558abe3e914dafc98.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.74Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29927188_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/9c6d9d467bd628015c23831a54a6d43d.webp" "MediaSize" => 29989 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-9c6d9d467bd628015c23831a54a6d43d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.5Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29927188_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/cff47f9386a5e7c4abd35a2c320a6b16.webp" "MediaSize" => 31637 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-cff47f9386a5e7c4abd35a2c320a6b16.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.74Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29927188_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/868f9af172a87306794ee8c06d7e7662.webp" "MediaSize" => 59713 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-868f9af172a87306794ee8c06d7e7662.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.5Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29927188_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/45a56631c95a8fbb2dd9dab99a9a142d.webp" "MediaSize" => 46503 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-45a56631c95a8fbb2dd9dab99a9a142d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.72Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29927188_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/d887e438b9f31f4dc9dd7a23c8fcfa1d.webp" "MediaSize" => 106556 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-d887e438b9f31f4dc9dd7a23c8fcfa1d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.54Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29927188_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/d1f5f48966c7beada34b9fb2cfe7f3f5.webp" "MediaSize" => 100350 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-d1f5f48966c7beada34b9fb2cfe7f3f5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.74Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29927188_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/7c6628fdfdb9b4d1cd3e4b7e45ed08cd.webp" "MediaSize" => 92446 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-7c6628fdfdb9b4d1cd3e4b7e45ed08cd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.53Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29927188_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/5722796b0ce79aee186dc0f774de2fe8.webp" "MediaSize" => 92503 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-5722796b0ce79aee186dc0f774de2fe8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-06-19T13:02:24.24Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29927188_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/175afc28b10d00a72cbc9e94827a769e.webp" "MediaSize" => 104106 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-175afc28b10d00a72cbc9e94827a769e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-06-19T13:02:24.24Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "29927188_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/c9cfa6e2b2b43e88eba888ceb646b175.webp" "MediaSize" => 111768 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-c9cfa6e2b2b43e88eba888ceb646b175.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-06-19T13:02:24.24Z" ] 31 => array:13 [ "Order" => 32 "MediaKey" => "29927188_4890_32" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/2c0165b79d5ff0d8a712983b32dba965.webp" "MediaSize" => 138313 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-2c0165b79d5ff0d8a712983b32dba965.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 32 => array:13 [ "Order" => 33 "MediaKey" => "29927188_4890_33" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/221fb28d8e0cddd43ca3ddebb2d9c7d2.webp" "MediaSize" => 129719 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-221fb28d8e0cddd43ca3ddebb2d9c7d2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.75Z" ] 33 => array:13 [ "Order" => 34 "MediaKey" => "29927188_4890_34" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/cbdc318d65ef3cc8be383437d46a37c7.webp" "MediaSize" => 129567 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-cbdc318d65ef3cc8be383437d46a37c7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:55.72Z" ] 34 => array:13 [ "Order" => 35 "MediaKey" => "29927188_4890_35" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/0d1c4df84c9306af97d58e92f1375404.webp" "MediaSize" => 131132 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-0d1c4df84c9306af97d58e92f1375404.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 35 => array:13 [ "Order" => 36 "MediaKey" => "29927188_4890_36" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/943a226068efc3bc7cb580d5ab468458.webp" "MediaSize" => 148863 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-943a226068efc3bc7cb580d5ab468458.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.56Z" ] 36 => array:13 [ "Order" => 37 "MediaKey" => "29927188_4890_37" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/6fe4c78bc9c306c535fe840c8da5b550.webp" "MediaSize" => 210528 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-6fe4c78bc9c306c535fe840c8da5b550.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.53Z" ] 37 => array:13 [ "Order" => 38 "MediaKey" => "29927188_4890_38" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/e16bf57bc44c181585c1c68151821e17.webp" "MediaSize" => 226132 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-e16bf57bc44c181585c1c68151821e17.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.54Z" ] 38 => array:13 [ "Order" => 39 "MediaKey" => "29927188_4890_39" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/f7016830ce4af6e8f58b528f0bc36b28.webp" "MediaSize" => 226859 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-f7016830ce4af6e8f58b528f0bc36b28.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.53Z" ] 39 => array:13 [ "Order" => 40 "MediaKey" => "29927188_4890_40" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/1cd4aa8a649ef39d2e869c4f27416581.webp" "MediaSize" => 214367 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-1cd4aa8a649ef39d2e869c4f27416581.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.54Z" ] 40 => array:13 [ "Order" => 41 "MediaKey" => "29927188_4890_41" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/c5b7a3b80560bac601df348361155d3e.webp" "MediaSize" => 226697 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-c5b7a3b80560bac601df348361155d3e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.56Z" ] 41 => array:13 [ "Order" => 42 "MediaKey" => "29927188_4890_42" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/11f853dccc55e4d6418f73817b0817d1.webp" "MediaSize" => 223237 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-11f853dccc55e4d6418f73817b0817d1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:56.57Z" ] 42 => array:13 [ "Order" => 43 "MediaKey" => "29927188_4890_43" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29927188/6dc77f7bd2d8c50452cfba609b5e581e.webp" "MediaSize" => 176176 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29927188/thumbnail-6dc77f7bd2d8c50452cfba609b5e581e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "26014514" "ResourceRecordKey" => "29927188" "ModificationTimestamp" => "2026-07-03T13:30:57.53Z" ] ] +"DaysOnMarket": 28 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927188')" +"ID": "1547490" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.15 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283922" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24997 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24913 +post_id: ? mixed +post_author: ? mixed +"OfficeName": "Coldwell Banker Southwest Realty" +"OfficeEmail": null +"OfficePhone": "519-331-8335" +"OfficeMlsId": "SLC0164" +"ModificationTimestamp": "2026-03-03T12:05:49Z" +"OriginatingSystemName": "CREA" +"OfficeKey": "283922" +"IDXOfficeParticipationYN": null +"MainOfficeKey": null +"MainOfficeMlsId": null +"OfficeAddress1": "780 Exmouth Street" +"OfficeAddress2": null +"OfficeBrokerKey": null +"OfficeCity": "Sarnia" +"OfficePostalCode": "N7T5P8" +"OfficePostalCodePlus4": null +"OfficeStateOrProvince": "Ontario" +"OfficeStatus": "Active" +"OfficeAOR": "Sarnia" +"OfficeType": "Firm" +"OfficePhoneExt": null +"OfficeNationalAssociationId": "1336852" +"OriginalEntryTimestamp": "2018-09-07T20:10:00Z" +"OfficeAORKey": "95" +"FranchiseNationalAssociationId": "1230688" +"OfficeBrokerNationalAssociationId": "1068694" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('283922')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2156370" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24981 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24941 +post_id: ? mixed +post_author: ? mixed +"MemberMlsId": "2156370" +"ModificationTimestamp": "2026-03-05T15:53:06Z" +"OriginatingSystemName": "CREA" +"MemberKey": "2156370" +"MemberPreferredPhoneExt": null +"MemberMlsSecurityClass": null +"MemberNationalAssociationId": null +"MemberAddress1": null +"MemberType": null +"MemberDesignation": null +"MemberCity": null +"MemberStateOrProvince": null +"MemberPostalCode": null +"OriginalEntryTimestamp": null +"MemberOfficePhone": null +"MemberOfficePhoneExt": null +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('2156370')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29927188'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25313 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29927188' AND OpenHouseDate ge '2026-07-16'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25329 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29927188' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential+Lease' AND geo.distance(Coordinates, POINT(-82.472336 42.742374)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25396 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] ]