array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29651282 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1355199"
+post_author: 1
+"ListingKey": "29651282"
+"ListingId": "26009088"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T15:20:15Z"
+"RFModificationTimestamp": "2026-06-17T15:48:42Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7S6L9"
+"UnparsedAddress": "142 Madison D'Andrea AVENUE, Sarnia, Ontario N7S6L9"
+"Coordinates": array:2 [
0 => -82.3486121
1 => 42.9614929
]
+"Latitude": 42.9614929
+"Longitude": -82.3486121
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Sarnia-Lambton Association of REALTORS®"
+"PublicRemarks": "Stunning 5-Bedroom, 3-Bathroom Brick Home in Sherwood Village Nestled at the end of a quiet cul-de-sac with no backyard neighbors, this beautiful home is sure to impress. Featuring 5 spacious bedrooms and 3 full bathrooms, it offers comfort, style, and functionality for the whole family. Step inside to a grand foyer with 9-foot ceilings and a bright hallway leading to an open-concept great room and kitchen, highlighted by soaring 12-foot cathedral ceilings. Some notable upgrades include Granite counters, gas hook up for a Barbeque, Dryer and Stove. The lower level boasts a large rec room complete with a wet bar and wired-in surround sound speakers — perfect for entertaining. This entire home has been freshly painted throughout. Enjoy outdoor living in the generous backyard, large enough to accommodate a pool, with a deck for gatherings and a storage shed for convenience. Additional features include an insulated 2-car garage, concrete slab and wiring for a hot tub, and plenty of room to relax and play. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Range Hood Combo"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-24T15:04:01.086225+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum/Vinyl"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic/Porcelain"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Furnace"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2066618"
+"ListOfficeKey": "293763"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Concrete Driveway"
]
+"LotSizeDimensions": "36.68 X 107.9/116.57 / 0 AC"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-24T12:42:58Z"
+"PhotosCount": 30
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:12:46Z"
+"Stories": "1.0"
+"StreetName": "Madison D'Andrea"
+"StreetNumber": "142"
+"StreetSuffix": "Avenue"
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1661180096"
"RoomType" => "Bedroom"
"ListingId" => "26009088"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "13.7 x 14.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.58Z"
]
1 => array:11 [
"RoomKey" => "1661180097"
"RoomType" => "Bedroom"
"ListingId" => "26009088"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "9.6 x 11"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.58Z"
]
2 => array:11 [
"RoomKey" => "1661180098"
"RoomType" => "Recreation room"
"ListingId" => "26009088"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "25.2 x 29.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.58Z"
]
3 => array:11 [
"RoomKey" => "1661180099"
"RoomType" => "Dining room"
"ListingId" => "26009088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "10.6 x 12.6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.59Z"
]
4 => array:11 [
"RoomKey" => "1661180100"
"RoomType" => "Living room/Fireplace"
"ListingId" => "26009088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "15 x 16"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.59Z"
]
5 => array:11 [
"RoomKey" => "1661180101"
"RoomType" => "Primary Bedroom"
"ListingId" => "26009088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "12.9 x 14"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.59Z"
]
6 => array:11 [
"RoomKey" => "1661180102"
"RoomType" => "Bedroom"
"ListingId" => "26009088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "13.7 x 14.5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.59Z"
]
7 => array:11 [
"RoomKey" => "1661180103"
"RoomType" => "Bedroom"
"ListingId" => "26009088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "10 x 10.2"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.6Z"
]
8 => array:11 [
"RoomKey" => "1661180104"
"RoomType" => "Foyer"
"ListingId" => "26009088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "5 x 9.2"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.6Z"
]
9 => array:11 [
"RoomKey" => "1661180105"
"RoomType" => "Kitchen"
"ListingId" => "26009088"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29651282"
"RoomLength" => null
"RoomDimensions" => "10 x 14.7"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T15:12:46.6Z"
]
]
+"ListAOR": "Sarnia"
+"TaxYear": 2026
+"ListAORKey": "95"
+"ListingURL": "www.realtor.ca/real-estate/29651282/142-madison-dandrea-avenue-sarnia"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"ZoningDescription": "RES"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"OriginalEntryTimestamp": "2026-04-24T12:42:58.14Z"
+"ListAgentNationalAssociationId": "1341742"
+"ListOfficeNationalAssociationId": "1431027"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6624141874"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/4094f79380fd9a791c4c80350796adef.webp"
"MediaSize" => 141357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-4094f79380fd9a791c4c80350796adef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6624141908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/8024f1e8a74daecd968654da2b4ae130.webp"
"MediaSize" => 146629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-8024f1e8a74daecd968654da2b4ae130.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6624141924"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/5bafff7eac3a080e361e6467c5620a8b.webp"
"MediaSize" => 128989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-5bafff7eac3a080e361e6467c5620a8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6624141992"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/48351b8c1d5d1091a73e20306f39150e.webp"
"MediaSize" => 148651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-48351b8c1d5d1091a73e20306f39150e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6624142045"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/c2bff91177a18f171c7dfa3aacd5e52a.webp"
"MediaSize" => 75298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-c2bff91177a18f171c7dfa3aacd5e52a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6624142094"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/53265501dfa994b8c7516173837cabb2.webp"
"MediaSize" => 89594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-53265501dfa994b8c7516173837cabb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6624142146"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/49de50015adb2f667faf9976a41ab7be.webp"
"MediaSize" => 86555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-49de50015adb2f667faf9976a41ab7be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6624142211"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/91afc4f611a5d31a5b62f4afa963a876.webp"
"MediaSize" => 87533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-91afc4f611a5d31a5b62f4afa963a876.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6624142229"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/fcdecf01f8748933247a25cc1b5cbfed.webp"
"MediaSize" => 62386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-fcdecf01f8748933247a25cc1b5cbfed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6624142272"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/5507442e5d7a5b20ae43a09a671de117.webp"
"MediaSize" => 84608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-5507442e5d7a5b20ae43a09a671de117.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6624142344"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/3ac75e3149dded28a64795e68e9e3f96.webp"
"MediaSize" => 71603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-3ac75e3149dded28a64795e68e9e3f96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6624142368"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/9bb6a4ba52c49d9300d7615c9cb9e854.webp"
"MediaSize" => 63779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-9bb6a4ba52c49d9300d7615c9cb9e854.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6624142399"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/015703d6f33d690c3b87d3634427f9b0.webp"
"MediaSize" => 62722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-015703d6f33d690c3b87d3634427f9b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6624142448"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/5a436b35629343954c3f43eb114e505c.webp"
"MediaSize" => 95402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-5a436b35629343954c3f43eb114e505c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6624142465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/1010462f3566d05906dba9c8b0ca9e51.webp"
"MediaSize" => 75764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-1010462f3566d05906dba9c8b0ca9e51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6624142492"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/899863b2a209fee5bfde2407b6cc6190.webp"
"MediaSize" => 62410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-899863b2a209fee5bfde2407b6cc6190.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6624142540"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/a8e101ddc6c556c9d2d73830bdc5e1ae.webp"
"MediaSize" => 68972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-a8e101ddc6c556c9d2d73830bdc5e1ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6624142560"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/a46b94a517c516a226184c1b617b834c.webp"
"MediaSize" => 50537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-a46b94a517c516a226184c1b617b834c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6624142586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/629da3f0e6957a21d20997bfea0474c3.webp"
"MediaSize" => 40250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-629da3f0e6957a21d20997bfea0474c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6624142625"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/b6edee880fcd5b9bdb120063747faaec.webp"
"MediaSize" => 64941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-b6edee880fcd5b9bdb120063747faaec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6624142665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/925c7785e8c1e59ab6ccc68850242249.webp"
"MediaSize" => 51526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-925c7785e8c1e59ab6ccc68850242249.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6624142705"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/ba76c18269da6faf38c324ce96753c20.webp"
"MediaSize" => 61268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-ba76c18269da6faf38c324ce96753c20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6624142732"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/7e4865e4049b0db1a9382119d0f8a42c.webp"
"MediaSize" => 73827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-7e4865e4049b0db1a9382119d0f8a42c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6624142770"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/754da79ccfc96b682d3afd0edf9001c3.webp"
"MediaSize" => 123461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-754da79ccfc96b682d3afd0edf9001c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6624142782"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/80cd0640e44d915c08d3455accff02ef.webp"
"MediaSize" => 151972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-80cd0640e44d915c08d3455accff02ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6624142834"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/3ab1e370f8a686a0c3ebaa0f965c2163.webp"
"MediaSize" => 147163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-3ab1e370f8a686a0c3ebaa0f965c2163.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6624142855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/c29aede40bffbde0268fcb176efa3abd.webp"
"MediaSize" => 150993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-c29aede40bffbde0268fcb176efa3abd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6624142908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/aae198796265ed4372b703f84d2ec45c.webp"
"MediaSize" => 161683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-aae198796265ed4372b703f84d2ec45c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6624142943"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/5754b14600e78bbee57c5722b0515900.webp"
"MediaSize" => 151263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-5754b14600e78bbee57c5722b0515900.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6624142958"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29651282/c952c493c07c961fa894bac7aa3e90ea.webp"
"MediaSize" => 162003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29651282/thumbnail-c952c493c07c961fa894bac7aa3e90ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26009088"
"ResourceRecordKey" => "29651282"
"ModificationTimestamp" => "2026-04-24T12:42:58.15Z"
]
]
+"DaysOnMarket": 75
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29651282')"
+"ID": "1355199"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293763" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24942
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24886
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "INITIA REAL ESTATE (ONTARIO) LTD."
+"OfficeEmail": null
+"OfficePhone": "416-402-3809"
+"OfficeMlsId": "SLC0182"
+"ModificationTimestamp": "2026-03-03T12:05:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293763"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "795 Exmouth Street"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Sarnia"
+"OfficePostalCode": "N7T7B7"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Sarnia"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1431027"
+"OriginalEntryTimestamp": "2022-12-23T18:11:00Z"
+"OfficeAORKey": "95"
+"OfficeBrokerNationalAssociationId": "1368708"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('293763')"
}
]
+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 2066618" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24896
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29651282'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25232
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29651282' AND OpenHouseDate ge '2026-07-08'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25248
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29651282' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-82.3486121 42.9614929)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25301
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "1606572"
+post_author: 1
+"ListingKey": "30003971"
+"ListingId": "26016058"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T13:30:02Z"
+"RFModificationTimestamp": "2026-07-08T17:55:41Z"
+"ListPrice": 435000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7S2S3"
+"UnparsedAddress": "97 Grey CRESCENT, Sarnia, Ontario N7S2S3"
+"Coordinates": array:2 [
0 => -82.367883
1 => 42.972252
]
+"Latitude": 42.972252
+"Longitude": -82.367883
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Sarnia-Lambton Association of REALTORS®"
+"PublicRemarks": "Located on a quiet, family-friendly crescent close to schools, grocery, dining, shopping, this move-in-ready bungalow offers a premium location paired with an incredible backyard. Step outside into your fully fenced, private retreat featuring a massive 18' x 36' heated inground pool, a deck with a gazebo for lounging, a gas BBQ hookup, and handy storage sheds. It’s the ultimate setup for morning coffee by the pool, hosting or unwinding. Inside, this bright bungalow keeps delivering. The main floor features durable vinyl flooring and an oversized kitchen of nearly 400 sq ft, a rare find for the neighbourhood, complete with a central island, a pantry, and tons of cabinet space. With 3+1 bedrooms and 2 full bathrooms, there is plenty of room to grow or downsize without compromising space. A separate side entrance leads to the main floor and a fully finished basement with a spacious rec room, bedroom, full bath, and a rough-in for a wet bar, offering great potential for an in-law suite. This home also features mechanical updates New pool lines and chlorinator, Pool sand filter (2025), Pool heater, fridge, dishwasher (2023), Advance basement systems french drain waterproofing (2022), Kitchen windows (2021), High Efficiency Furnace & AC (2020). (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
5 => "Cooktop"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T17:55:35.527679+00:00"
+"Directions": "In Coronation Park off Preston: From Murphy Road turn onto Preston Ave, first left on Grey Crescent, continue to 97 Grey Crescent."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Insert"
1 => "Electric"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Cushion/Lino/Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Furnace"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2189758"
+"ListOfficeKey": "293763"
+"LotFeatures": array:1 [
0 => "Concrete Driveway"
]
+"LotSizeDimensions": "50.13 X 120.31"
+"PhotosChangeTimestamp": "2026-07-08T13:11:38Z"
+"PhotosCount": 31
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T13:25:04Z"
+"Stories": "1.0"
+"StreetName": "Grey"
+"StreetNumber": "97"
+"StreetSuffix": "Crescent"
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1678069734"
"RoomType" => "3pc Bathroom"
"ListingId" => "26016058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.02Z"
]
1 => array:11 [
"RoomKey" => "1678069735"
"RoomType" => "4pc Bathroom"
"ListingId" => "26016058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
2 => array:11 [
"RoomKey" => "1678069736"
"RoomType" => "Laundry room"
"ListingId" => "26016058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => "5 x 5"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
3 => array:11 [
"RoomKey" => "1678069737"
"RoomType" => "Utility room"
"ListingId" => "26016058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => "11 x 12"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
4 => array:11 [
"RoomKey" => "1678069738"
"RoomType" => "Bedroom"
"ListingId" => "26016058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => "10 x 14.6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
5 => array:11 [
"RoomKey" => "1678069739"
"RoomType" => "Recreation room"
"ListingId" => "26016058"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => "11.6 x 31.6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
6 => array:11 [
"RoomKey" => "1678069740"
"RoomType" => "Bedroom"
"ListingId" => "26016058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => "8.6 x 10"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
7 => array:11 [
"RoomKey" => "1678069741"
"RoomType" => "Bedroom"
"ListingId" => "26016058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => "10 x 11.6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
8 => array:11 [
"RoomKey" => "1678069742"
"RoomType" => "Primary Bedroom"
"ListingId" => "26016058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => "11 x 15"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
9 => array:11 [
"RoomKey" => "1678069743"
"RoomType" => "Kitchen"
"ListingId" => "26016058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => "17 x 22.6"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
10 => array:11 [
"RoomKey" => "1678069744"
"RoomType" => "Living room"
"ListingId" => "26016058"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30003971"
"RoomLength" => null
"RoomDimensions" => "13 x 17"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-08T13:25:04.03Z"
]
]
+"ListAOR": "Sarnia"
+"TaxYear": 2025
+"ListAORKey": "95"
+"ListingURL": "www.realtor.ca/real-estate/30003971/97-grey-crescent-sarnia"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-08T13:09:48.77Z"
+"ListAgentNationalAssociationId": "1438864"
+"ListOfficeNationalAssociationId": "1431027"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30003971_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/e42e7571aa01c9b2411dfcd06130af1d.webp"
"MediaSize" => 148412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-e42e7571aa01c9b2411dfcd06130af1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.77Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30003971_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/655a51044f476e11915f93e027b2d1ed.webp"
"MediaSize" => 163708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-655a51044f476e11915f93e027b2d1ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.47Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30003971_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/ea5b9e9da17e7a476bcbe49a265fb09d.webp"
"MediaSize" => 90792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-ea5b9e9da17e7a476bcbe49a265fb09d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.97Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30003971_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/c8ea447713a3a9d5f903166123da2221.webp"
"MediaSize" => 96085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-c8ea447713a3a9d5f903166123da2221.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.46Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30003971_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/a494eda23beac40fb441871bc1e79c1d.webp"
"MediaSize" => 73613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-a494eda23beac40fb441871bc1e79c1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.75Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30003971_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/1bed8f35fb68788fefc1fe7ef57b1ee2.webp"
"MediaSize" => 86934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-1bed8f35fb68788fefc1fe7ef57b1ee2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.78Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30003971_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/a1785486776e169e33fff588cfa91624.webp"
"MediaSize" => 79916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-a1785486776e169e33fff588cfa91624.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.77Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30003971_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/77e222bacfd0d5e20a9a82a22cda6a0f.webp"
"MediaSize" => 65469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-77e222bacfd0d5e20a9a82a22cda6a0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.75Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30003971_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/b957fb6ef5a48f4754d29cbcce384c02.webp"
"MediaSize" => 81675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-b957fb6ef5a48f4754d29cbcce384c02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.31Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30003971_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/709ef5ac144f5751406a82bf1f7901ed.webp"
"MediaSize" => 78860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-709ef5ac144f5751406a82bf1f7901ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.78Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30003971_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/42e7dfffcab918c3ba2b0170d7c65b9e.webp"
"MediaSize" => 86130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-42e7dfffcab918c3ba2b0170d7c65b9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.46Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30003971_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/c2dab8d241be85e573fa080eb4752652.webp"
"MediaSize" => 77329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-c2dab8d241be85e573fa080eb4752652.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.78Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30003971_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/fbdfffeb00fb7a955c532f833852f925.webp"
"MediaSize" => 75089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-fbdfffeb00fb7a955c532f833852f925.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.76Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30003971_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/3ad341237aadc6d8ffc6c9c58503640f.webp"
"MediaSize" => 84856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-3ad341237aadc6d8ffc6c9c58503640f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.44Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30003971_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/fce870eddc6de87674578d8a1e7cc3fa.webp"
"MediaSize" => 90566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-fce870eddc6de87674578d8a1e7cc3fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.46Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30003971_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/ceaa9265550acac17aab9d97758451e4.webp"
"MediaSize" => 75163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-ceaa9265550acac17aab9d97758451e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30003971_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/8b6cd38b8678dcb7272c4eb2e52a3476.webp"
"MediaSize" => 68413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-8b6cd38b8678dcb7272c4eb2e52a3476.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.84Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30003971_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/2da50c6927fc80df62c59b7efbf668c3.webp"
"MediaSize" => 59183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-2da50c6927fc80df62c59b7efbf668c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.46Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30003971_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/bce047679ceb73d1e7008ce4f57aab62.webp"
"MediaSize" => 57173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-bce047679ceb73d1e7008ce4f57aab62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.76Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30003971_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/de0fd066567fff0f80e3077b03bb215b.webp"
"MediaSize" => 92097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-de0fd066567fff0f80e3077b03bb215b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.76Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30003971_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/c3b8746330fbf0f63b552650082ce08d.webp"
"MediaSize" => 84371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-c3b8746330fbf0f63b552650082ce08d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:38.25Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30003971_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/3a74da067f2934d19f2c5e13a7b567c2.webp"
"MediaSize" => 88544
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-3a74da067f2934d19f2c5e13a7b567c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:33.78Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30003971_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/ef2f9efd30a0e1f10e571c56cabd7c20.webp"
"MediaSize" => 58156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-ef2f9efd30a0e1f10e571c56cabd7c20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.48Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30003971_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30003971/883ec9ccf93cf37251997871cc7b56d9.webp"
"MediaSize" => 41067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30003971/thumbnail-883ec9ccf93cf37251997871cc7b56d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "26016058"
"ResourceRecordKey" => "30003971"
"ModificationTimestamp" => "2026-07-08T13:11:35.48Z"
]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30003971')"
+"ID": "1606572"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "1601678"
+post_author: 1
+"ListingKey": "30001633"
+"ListingId": "X13534694"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T13:30:01Z"
+"RFModificationTimestamp": "2026-07-08T13:30:17Z"
+"ListPrice": 435000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7S2S3"
+"UnparsedAddress": "97 GREY CRESCENT, Sarnia, Ontario N7S2S3"
+"Coordinates": array:2 [
0 => -82.367883
1 => 42.972252
]
+"Latitude": 42.972252
+"Longitude": -82.367883
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Located on a quiet, family-friendly crescent close to schools, grocery, dining, shopping, this move-in-ready bungalow offers a premium location paired with an incredible backyard. Step outside into your fully fenced, private retreat featuring a massive 18' x 36' heated inground pool, a deck with a gazebo for lounging, a gas BBQ hookup, and handy storage sheds. It's the ultimate setup for morning coffee by the pool, hosting or unwinding. Inside, this bright bungalow keeps delivering. The main floor features durable vinyl flooring and an oversized kitchen of nearly 400 sq ft-a rare find for this neighbourhood-complete with a central island, a pantry, and tons of cabinet space. With 3+1 bedrooms and 2 full bathrooms, there is plenty of room to grow or downsize without compromising space. A separate side entrance leads to the main floor and a fully finished basement with a spacious rec room, bedroom, full bath, and a rough-in for a wet bar, offering great potential for an in-law suite. This home also features mechanical updates New pool lines and chlorinator, Pool sand filter (2025), Pool heater, fridge, dishwasher (2023), Advance basement systems french drain waterproofing (2022), Kitchen windows (2021), High Efficiency Furnace & AC (2020). (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Cooktop"
6 => "Blinds"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T21:05:18.467021+00:00"
+"Directions": "Cross Streets: Athlone Street. ** Directions: In Coronation Park off Preston: From Murphy Road turn onto Preston Ave, first left on Grey Crescent, continue to 97 Grey Crescent."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2243819"
+"ListOfficeKey": "293778"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "50 x 120 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T20:21:30Z"
+"PhotosCount": 30
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T13:20:46Z"
+"Stories": "1.0"
+"StreetName": "Grey"
+"StreetNumber": "97"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3103"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "London and St. Thomas"
+"CityRegion": "Sarnia"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/30001633/97-grey-crescent-sarnia-sarnia"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-07T20:21:30.15Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1482352"
+"ListOfficeNationalAssociationId": "1433270"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001633')"
+"ID": "1601678"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1599610"
+post_author: 1
+"ListingKey": "29998953"
+"ListingId": "X13532142"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T18:30:03Z"
+"RFModificationTimestamp": "2026-07-08T18:31:30Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7W0B1"
+"UnparsedAddress": "401 RODRIGUEZ DRIVE, Sarnia, Ontario N7W0B1"
+"Coordinates": array:2 [
0 => -82.337117
1 => 42.961282
]
+"Latitude": 42.961282
+"Longitude": -82.337117
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning custom-built 5-bedroom, 3-bath home designed with comfort, functionality, and flexibility in mind. Featuring a smart split-bedroom layout and exceptional multigenerational living potential, this home is ideal for growing families, entertainers, or those seeking spacious, versatile living. The beautifully appointed kitchen and primary ensuite showcase elegant quartz countertops, while the luxurious primary retreat offers a 5-piece in-floor heated bath and walk-in closet. A newly added sunroom expands the main floor living and entertainment space, creating the perfect setting for gatherings year-round. Additional highlights include a massive 33 x 25.4 in-floor heated garage with room for a hoist, a finished lower level, new RO Culligan water and whole-home dechlorination system, door cameras with A1 security system, and thoughtfully designed main floor entertaining areas. Step outside to enjoy apple and pear fruit trees in the backyard, plus the convenience of being within walking distance to two large private parks and scenic trails. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:12:02.284871+00:00"
+"Directions": "Cross Streets: RONALD BLOOR DRIVE. ** Directions: HEADING EAST ON CONFEDERATION, PASS MODELAND AND TURN LEFT ONTO RONALD BLOOR DRIVE. RODRIGUEZ IS THE SECOND STREET ON THE RIGHT."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2153879"
+"ListOfficeKey": "292934"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "78.9 x 104 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T15:21:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T18:21:13Z"
+"Stories": "1.0"
+"StreetName": "Rodriguez"
+"StreetNumber": "401"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7992"
+"VirtualTourURLUnbranded": "https://youtu.be/1xVV92zEMzs?si=aQd51rrRssneA6vs"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "London and St. Thomas"
+"TaxYear": 2025
+"CityRegion": "Sarnia"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/29998953/401-rodriguez-drive-sarnia-sarnia"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RES"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 78.1
+"OriginalEntryTimestamp": "2026-07-07T15:21:53.63Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1410099"
+"ListOfficeNationalAssociationId": "1419719"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998953')"
+"ID": "1599610"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+post_id: "1595572"
+post_author: 1
+"ListingKey": "29993310"
+"ListingId": "26015817"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T19:35:24Z"
+"RFModificationTimestamp": "2026-07-08T19:49:30Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7S5R9"
+"UnparsedAddress": "118 FINCH DRIVE, Sarnia, Ontario N7S5R9"
+"Coordinates": array:2 [
0 => -82.350431
1 => 42.969066
]
+"Latitude": 42.969066
+"Longitude": -82.350431
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Sarnia-Lambton Association of REALTORS®"
+"PublicRemarks": "Welcome to 118 Finch Drive in Sarnia's desirable Sherwood Village neighbourhood! This well-maintained raised ranch offers 3+1 bedrooms, 2 full bathrooms, and a functional layout perfect for families. The bright upper level features a spacious living room, dining area, updated kitchen, three bedrooms, and a 5-piece bathroom. The finished lower level adds valuable living space with a large family room complete with a cozy fireplace, an additional bedroom or rec-room, a 3-piece bathroom, and a utility/laundry area. Step outside to the spacious wooden deck and greenhouse with beautifully finished landscapes. Recent updates include the furnace (2022), kitchen (2023), and roof (2013), providing added peace of mind. Conveniently located close to parks, schools, and everyday amenities, this move-in-ready home is an excellent opportunity in one of Sarnia's most sought-after family neighbourhoods. Book your showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Range Hood Combo"
]
+"ArchitecturalStyle": array:2 [
0 => "Other"
1 => "Raised ranch"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T16:33:33.588710+00:00"
+"Directions": "HEAD SOUTH ON FINCH FROM WELLINGTON ST"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Concrete/Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
3 => "Cushion/Lino/Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Furnace"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2084364"
+"ListOfficeKey": "296491"
+"LotFeatures": array:2 [
0 => "Double width or more driveway"
1 => "Concrete Driveway"
]
+"LotSizeDimensions": "52.49 X 114 / 0.138 AC"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T16:24:30Z"
+"PhotosCount": 47
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T19:28:05Z"
+"StreetName": "FINCH"
+"StreetNumber": "118"
+"StreetSuffix": "Drive"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=VwPEGAciAJc&mls=1"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Sarnia"
+"TaxYear": 2025
+"ListAORKey": "95"
+"ListingURL": "www.realtor.ca/real-estate/29993310/118-finch-drive-sarnia"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2062288"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283922"
+"GeocodeManualYN": false
+"ZoningDescription": "UR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-07-06T15:55:32.18Z"
+"ListAgentNationalAssociationId": "1477699"
+"ListOfficeNationalAssociationId": "1459181"
+"CoListAgentNationalAssociationId": "1337334"
+"CoListOfficeNationalAssociationId": "1336852"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29993310')"
+"ID": "1595572"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "1585344"
+post_author: 1
+"ListingKey": "29977031"
+"ListingId": "26015229"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T12:40:01Z"
+"RFModificationTimestamp": "2026-07-02T18:26:20Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1708.0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7W0B5"
+"UnparsedAddress": "621 MEAD COURT, Sarnia, Ontario N7W0B5"
+"Coordinates": array:2 [
0 => -82.336247
1 => 42.960491
]
+"Latitude": 42.960491
+"Longitude": -82.336247
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Sarnia-Lambton Association of REALTORS®"
+"PublicRemarks": "Welcome to 621 Mead Court; a 1708 sqft luxury home developed by Iacobelli Homes — where modern design meets everyday functionality in a quiet, family-friendly setting. This beautifully finished home boasts 9 ft ceilings, offering a bright open-concept main floor, highlighted by a stunning kitchen featuring high-end appliances, luxury finishes, a walk-in pantry, and even a built-in coffee maker for your morning routine. The kitchen flows seamlessly into the spacious living room, with direct access to the backyard—perfect for entertaining or relaxing at home. Complete with main floor laundry and 3 generous bedrooms, including a spacious primary suite complete with a luxurious 5-piece ensuite. The fully finished basement expands your living space with two additional bedrooms, a large rec room, a 3-piece bathroom, plus ample utility and storage areas—ideal for growing families or hosting guests. Step outside to enjoy a beautifully landscaped backyard featuring a spacious patio, and plenty of green space. Located close to local amenities and access to highway 402, this home delivers the perfect balance of comfort, style, and convenience. This home won’t last long! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T18:26:09.506403+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Aluminum/Vinyl"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Direct vent"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Carpeted"
1 => "Ceramic/Porcelain"
2 => "Cushion/Lino/Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Forced air"
1 => "Heat Recovery Ventilation (HRV)"
2 => "Natural gas"
3 => "Furnace"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238599"
+"ListOfficeKey": "283922"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Double width or more driveway"
2 => "Concrete Driveway"
]
+"LotSizeDimensions": "44.79 X 101 IRR / 0.132 AC"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T12:30:51Z"
+"PhotosCount": 50
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T12:30:51Z"
+"Stories": "1.0"
+"StreetName": "MEAD"
+"StreetNumber": "621"
+"StreetSuffix": "Court"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=BHVDNDyzrBq&mls=1"
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Sarnia"
+"TaxYear": 2025
+"ListAORKey": "95"
+"ListingURL": "www.realtor.ca/real-estate/29977031/621-mead-court-sarnia"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"ZoningDescription": "UR4-15"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1708
+"OriginalEntryTimestamp": "2026-07-02T12:30:51.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1476415"
+"ListOfficeNationalAssociationId": "1336852"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977031')"
+"ID": "1585344"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "1573420"
+post_author: 1
+"ListingKey": "29962442"
+"ListingId": "26015396"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T14:50:18Z"
+"RFModificationTimestamp": "2026-06-27T16:42:44Z"
+"ListPrice": 365000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7S4E4"
+"UnparsedAddress": "854 Lanark CRESCENT, Sarnia, Ontario N7S4E4"
+"Coordinates": array:2 [
0 => -82.366066
1 => 42.964165
]
+"Latitude": 42.964165
+"Longitude": -82.366066
+"YearBuilt": 1976
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Sarnia-Lambton Association of REALTORS®"
+"PublicRemarks": "Welcome to 854 Lanark Crescent, a spacious 2-storey semi-detached home offering 4 bedrooms, exceptional storage, and a large fenced corner lot in central Sarnia. Located in a well-established neighbourhood, this home is within walking distance to St. Clair Secondary School and just minutes from Lambton College, shopping, parks, and playgrounds. The main floor features an updated kitchen complete with a coffee bar, a bright and comfortable living room, and a convenient 2-piece powder room for guests. Upstairs offers 4 bedrooms, ideal for a growing family, work-from-home setup, or extra guest space, along with a full 4-piece bathroom. Outside, the fully fenced backyard includes a covered porch perfect for morning coffee or relaxing evenings, while the welcoming front porch adds curb appeal from the moment you arrive. Parking and storage are a standout feature here, with a double-wide concrete driveway, detached single-car garage with its own side driveway, and an attached insulated storage room converted from the original garage, perfect for tools, bikes, seasonal items, or hobby space. The basement includes a partially finished rec room ready to become a playroom, media room, gym, or flex space to suit your lifestyle. No condo fees is a bonus. Call or text to schedule a viewing. (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-27T16:41:35.725702+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum/Vinyl"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Flooring": array:3 [
0 => "Carpeted"
1 => "Ceramic/Porcelain"
2 => "Cushion/Lino/Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Furnace"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156370"
+"ListOfficeKey": "283922"
+"LotFeatures": array:2 [
0 => "Double width or more driveway"
1 => "Concrete Driveway"
]
+"LotSizeDimensions": "37.2 X 100.17 / 0.094 AC"
+"ParkingFeatures": array:1 [
0 => "Other"
]
+"PhotosChangeTimestamp": "2026-06-27T14:40:44Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T14:40:43Z"
+"Stories": "2.0"
+"StreetName": "Lanark"
+"StreetNumber": "854"
+"StreetSuffix": "Crescent"
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Sarnia"
+"TaxYear": 2026
+"ListAORKey": "95"
+"ListingURL": "www.realtor.ca/real-estate/29962442/854-lanark-crescent-sarnia"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1930500"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283922"
+"GeocodeManualYN": false
+"ZoningDescription": "UR4-8"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-27T14:40:43.67Z"
+"ListAgentNationalAssociationId": "1407739"
+"ListOfficeNationalAssociationId": "1336852"
+"CoListAgentNationalAssociationId": "1231340"
+"CoListOfficeNationalAssociationId": "1336852"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29962442')"
+"ID": "1573420"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1542886"
+post_author: 1
+"ListingKey": "29920607"
+"ListingId": "26014453"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T20:20:03Z"
+"RFModificationTimestamp": "2026-07-04T20:33:30Z"
+"ListPrice": 529900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7S6H2"
+"UnparsedAddress": "10 D'Andrea TRAIL, Sarnia, Ontario N7S6H2"
+"Coordinates": array:2 [
0 => -82.359044
1 => 42.963187
]
+"Latitude": 42.963187
+"Longitude": -82.359044
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Sarnia-Lambton Association of REALTORS®"
+"PublicRemarks": "Welcome to 10 D’Andrea Trail, a beautifully maintained and move-in ready home located in the highly desirable Sherwood Village community of Sarnia. This property offers an excellent combination of comfort, functionality, natural light, and strong investment potential, making it ideal for families, first-time buyers, and investors alike. Perfectly positioned on a quiet corner lot at D’Andrea Trail and Trudeau Drive, this home enjoys added privacy, extra natural light exposure, and a more open streetscape compared to typical interior lots. The neighbourhood is well known for its peaceful residential environment, family-friendly atmosphere, and excellent access to everyday amenities. From the moment you arrive, you will appreciate the pride of ownership and the practical design of this home. The exterior is well maintained, and the property sits in a location that balances quiet residential living with unmatched convenience. The home is just minutes from Lambton College, making it highly attractive for student rental demand or staff accommodation opportunities. The nearby YMCA provides excellent access to fitness facilities, swimming, sports programs, and community activities for all age groups. Public transit is extremely convenient, as the property is located directly on a bus route, offering easy access across the city without the need for a vehicle. The main Sarnia Bus Terminal is also nearby, further enhancing transportation connectivity. Everyday amenities are within close reach, including restaurants, stores, and retail services. Popular food options such as McDonald’s, KFC, Pizza Pizza, and other local dining establishments are all just minutes away. This level of convenience adds significant long-term value for both homeowners and tenants. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Dryer"
2 => "Two stoves"
3 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised ranch"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T13:56:28.390231+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum/Vinyl"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Direct vent"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Cushion/Lino/Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Furnace"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068395"
+"ListOfficeKey": "296491"
+"LotFeatures": array:1 [
0 => "Concrete Driveway"
]
+"LotSizeDimensions": "44.18 X 124 /90 / 0.16 AC"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T12:40:12Z"
+"PhotosCount": 47
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T20:11:04Z"
+"StreetName": "D'Andrea"
+"StreetNumber": "10"
+"StreetSuffix": "Trail"
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Sarnia"
+"TaxYear": 2026
+"ListAORKey": "95"
+"ListingURL": "www.realtor.ca/real-estate/29920607/10-dandrea-trail-sarnia"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2129076"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283922"
+"GeocodeManualYN": false
+"ZoningDescription": "UR-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"OriginalEntryTimestamp": "2026-06-18T12:40:12.22Z"
+"ListAgentNationalAssociationId": "1343632"
+"ListOfficeNationalAssociationId": "1459181"
+"CoListAgentNationalAssociationId": "1382165"
+"CoListOfficeNationalAssociationId": "1336852"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 20
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920607')"
+"ID": "1542886"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1540568"
+post_author: 1
+"ListingKey": "29915772"
+"ListingId": "26014144"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T17:30:20Z"
+"RFModificationTimestamp": "2026-07-08T19:16:14Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7S4Z1"
+"UnparsedAddress": "403 HUXLEY AVENUE, Sarnia, Ontario N7S4Z1"
+"Coordinates": array:2 [
0 => -82.365845
1 => 42.970188
]
+"Latitude": 42.970188
+"Longitude": -82.365845
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Sarnia-Lambton Association of REALTORS®"
+"PublicRemarks": "Totally updated living awaits you at 403 Huxley, conveniently located in central Sarnia just a short walk or drive from everywhere. With everything from Real Canadian Superstore, to Starbucks, Clearwater Arena and Great Lakes Secondary all within 1.5km. Updates here include flooring, trim, lower rec room fully renovated, all windows & front door (2025), furnace (2025), central air (2025), exterior siding (2025), hot water tank owned (2025). This home has plenty of room for the whole family inside and out with the fenced backyard, large storage shed and attached garage. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "4 Level"
]
+"CreationDate": "2026-06-17T16:33:56.369207+00:00"
+"ExteriorFeatures": array:1 [
0 => "Aluminum/Vinyl"
]
+"Flooring": array:3 [
0 => "Carpeted"
1 => "Ceramic/Porcelain"
2 => "Cushion/Lino/Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1902835"
+"ListOfficeKey": "296491"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Concrete Driveway"
]
+"LotSizeDimensions": "54.62 X 100.36 / 0.127 AC"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T21:42:56Z"
+"PhotosCount": 49
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T17:09:25Z"
+"StreetName": "HUXLEY"
+"StreetNumber": "403"
+"StreetSuffix": "Avenue"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=u3Wi_RllM_o"
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Sarnia"
+"TaxYear": 2026
+"ListAORKey": "95"
+"ListingURL": "www.realtor.ca/real-estate/29915772/403-huxley-avenue-sarnia"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"ZoningDescription": "UR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-17T15:43:21.83Z"
+"ListAgentNationalAssociationId": "1218391"
+"ListOfficeNationalAssociationId": "1459181"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915772')"
+"ID": "1540568"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1538694"
+post_author: 1
+"ListingKey": "29915348"
+"ListingId": "26014139"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T11:40:02Z"
+"RFModificationTimestamp": "2026-07-06T11:49:28Z"
+"ListPrice": 329900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Sarnia"
+"PostalCode": "N7S4C7"
+"UnparsedAddress": "431 Cardiff PLACE, Sarnia, Ontario N7S4C7"
+"Coordinates": array:2 [
0 => -82.361458
1 => 42.965698
]
+"Latitude": 42.965698
+"Longitude": -82.361458
+"YearBuilt": 1976
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Chatham Kent Association of REALTORS®"
+"PublicRemarks": "Welcome to 431 Cardiff Place! Perfect for growing families or investors. This large multi-level townhouse features four bedrooms on the upstairs level, one on the main level, and a self-contained granny suite in the basement (ideal for extended family or rental income) Massive outdoor space with mature trees is perfect for entertaining, activities or relaxing. Conveniently located near parks, schools, shopping, and dining, as well as having easy access to public transit. Townhouse is in close proximity of Lambton College, making it highly attractive to students. Nearby YMCA offers programs for all ages, including fitness facilities, swimming, and community activities. Oversized refrigerator temporarily being used, new refrigerator ordered to fit kitchen opening, to be installed prior to closing. Please allow 24hr notice of showing, as granny suite is currently rented till the end of July. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Dryer"
3 => "Two stoves"
4 => "Two Refrigerators"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T15:45:15.642125+00:00"
+"Directions": "From Wellington, turn south on Cardiff Drive, then right onto Cardiff Place."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum/Vinyl"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Cushion/Lino/Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156458"
+"ListOfficeKey": "277514"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Double width or more driveway"
2 => "Paved driveway"
]
+"LotSizeDimensions": "27 X / 0.1 AC"
+"PhotosChangeTimestamp": "2026-06-17T14:53:32Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T11:32:23Z"
+"Stories": "2.0"
+"StreetName": "Cardiff"
+"StreetNumber": "431"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "1890"
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Chatham Kent"
+"TaxYear": 2025
+"ListAORKey": "32"
+"ListingURL": "www.realtor.ca/real-estate/29915348/431-cardiff-place-sarnia"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"ZoningDescription": "RES"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-17T14:53:32.61Z"
+"ListAgentNationalAssociationId": "1407869"
+"ListOfficeNationalAssociationId": "1284462"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915348')"
+"ID": "1538694"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 17
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]