array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29767884 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1433703"
+post_author: 1
+"ListingKey": "29767884"
+"ListingId": "X13141514"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-19T19:05:48Z"
+"RFModificationTimestamp": "2026-05-19T19:15:39Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2339.0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1C3"
+"UnparsedAddress": "166 HWY, Hamilton (Stoney Creek), Ontario L8G1C3"
+"Coordinates": array:2 [
0 => -76.53402
1 => 44.249911
]
+"Latitude": 44.249911
+"Longitude": -76.53402
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Second-floor commercial space available in a high-exposure plaza located along busy Highway 8 in Stoney Creek. This 2,339 SF unit is currently configured as a martial arts/fitness studio and offers an excellent opportunity for a wide range of permitted uses including fitness, wellness, medical, professional office, educational, studio, or service-based businesses.The unit features an open-concept layout with large front-facing windows providing excellent natural light and visibility onto Highway 8. Located above established ground-floor retail tenants, the space benefits from steady daily traffic, strong surrounding demographics, and excellent signage exposure within a well-known neighbourhood plaza.Convenient access from both Highway 8 and Gray Road, with ample surface parking available directly in front of the plaza, plus additional parking at the rear of the building for staff and customers. Surrounded by national and service-oriented tenants including Shoppers Drug Mart, CIBC, A&W, and LCBO in neighbouring plazas, this location offers strong accessibility and a built-in customer base. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2026-05-19T06:49:13.816475+00:00"
+"Directions": "Cross Streets: Hwy 8 & Gray Rd. ** Directions: Southeast corner of Hwy 8 and Gray Rd."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2198428"
+"ListOfficeKey": "285824"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-05-19T06:29:32Z"
+"PhotosCount": 6
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-19T18:57:22Z"
+"StreetName": "Hwy 8"
+"StreetNumber": "166"
+"TaxAnnualAmount": "7.68"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29767884/166-hwy-8-hamilton-stoney-creek-stoney-creek"
+"CoListAgentKey": "2148644"
+"CoListAgentKey2": "2256389"
+"CoListOfficeKey": "285824"
+"GeocodeManualYN": false
+"TotalActualRent": 12
+"CoListOfficeKey2": "285824"
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "Mixed Use"
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-05-19T06:29:32.38Z"
+"ListAgentNationalAssociationId": "1447206"
+"ListOfficeNationalAssociationId": "1355085"
+"CoListAgentNationalAssociationId": "1399694"
+"CoListAgentNationalAssociationId2": "1495474"
+"CoListOfficeNationalAssociationId": "1355085"
+"CoListOfficeNationalAssociationId2": "1355085"
+"Media": array:6 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29767884_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29767884/4d2d918c9d9f24fc193b105e4adad970.webp"
"MediaSize" => 223772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29767884/thumbnail-4d2d918c9d9f24fc193b105e4adad970.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13141514"
"ResourceRecordKey" => "29767884"
"ModificationTimestamp" => "2026-05-19T06:29:32.38Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29767884_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29767884/7eeb6fad2652f88f413d97c9456529b0.webp"
"MediaSize" => 175451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29767884/thumbnail-7eeb6fad2652f88f413d97c9456529b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13141514"
"ResourceRecordKey" => "29767884"
"ModificationTimestamp" => "2026-05-19T06:29:32.38Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29767884_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29767884/0d8e3ad0663457922698953c9113507f.webp"
"MediaSize" => 119207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29767884/thumbnail-0d8e3ad0663457922698953c9113507f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13141514"
"ResourceRecordKey" => "29767884"
"ModificationTimestamp" => "2026-05-19T06:29:32.38Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29767884_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29767884/b3bdea38b6d537307400aefa73d16778.webp"
"MediaSize" => 143266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29767884/thumbnail-b3bdea38b6d537307400aefa73d16778.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13141514"
"ResourceRecordKey" => "29767884"
"ModificationTimestamp" => "2026-05-19T06:29:32.38Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29767884_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29767884/1cf74528752a5488eacda960411f6304.webp"
"MediaSize" => 77232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29767884/thumbnail-1cf74528752a5488eacda960411f6304.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13141514"
"ResourceRecordKey" => "29767884"
"ModificationTimestamp" => "2026-05-19T06:29:32.38Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29767884_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29767884/2bb7c501da240b812185ba9b0342fd10.webp"
"MediaSize" => 150538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29767884/thumbnail-2bb7c501da240b812185ba9b0342fd10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13141514"
"ResourceRecordKey" => "29767884"
"ModificationTimestamp" => "2026-05-19T06:29:32.38Z"
]
]
+"DaysOnMarket": 38
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29767884')"
+"ID": "1433703"
}
]
+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=OfficeMlsId eq 285824" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24733
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2198428" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24728
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29767884'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25191
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29767884'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25207
+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 '29767884' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Commercial Lease' AND geo.distance(Coordinates, POINT(-76.53402 44.249911)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25276
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: "985452"
+post_author: 1
+"ListingKey": "29131785"
+"ListingId": "X12571946"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T03:50:45Z"
+"RFModificationTimestamp": "2026-01-10T03:55:09Z"
+"ListPrice": 30.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 3.24
+"LivingArea": 1400.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A0C3"
+"UnparsedAddress": "C2 - 873 FAIRWAY STREET N, Kitchener, Ontario N2A0C3"
+"Coordinates": array:2 [
0 => -76.533749
1 => 44.233381
]
+"Latitude": 44.233381
+"Longitude": -76.533749
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 873 Fairway Road, Unit C-2 Kitchener, offering an exceptional opportunity to establish your business in a brand new, professionally designed commercial plaza. Strategically located directly across from Chicopee Hills Public School, the plaza benefits from strong daily traffic counts and excellent community visibility, making it an ideal destination for a wide range of business types. With unit sizes starting around 1300 SF, the plaza can accommodate everything from small operations to larger-scale enterprises. The space is perfectly suited for many businesses. The development offers ample on-site parking for both customers and staff. It is also well-connected via GRT public transit and situated just minutes from key transportation routes including Highway 8, Highway 401, and the Waterloo Regional Airport. Additionally, exceptional pylon and fascia signage opportunities are available, providing tenants with premium exposure and visibility to passing traffic. Note: The unit may not be used for any purposes involving toxic materials, activities causing nuisance (e.g., noise, odours, vibrations), or any use deemed offensive or non-compliant with bylaws. Prohibited uses include: adult entertainment, massage parlours, fireworks sales, auctions, pawn shops, bingo or betting establishments, arcades, places of worship, group homes, car washes, vehicle dealerships, or auto repair facilities. Uses that may increase insurance premiums or pose risk to occupants are also restricted. This space is ideally suited for a diverse range of uses. We're actively seeking & promoting tenants in high-demand sectors such as: Pet Stores and Grooming Services (e.g., Pet Valu, boutique grooming salons), Nail and Beauty Salons, Quick-Serve Restaurants and many more. Book your showing today & explore the opportunity to invest in a thriving, high-potential commercial location. (id:62650)"
+"Cooling": array:1 [
0 => "Fully air conditioned"
]
+"CreationDate": "2025-11-24T19:04:34.780119+00:00"
+"Directions": "Cross Streets: Lackner Boulevard. ** Directions: Fairway Road and Lackner Boulevard."
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "Unit=575.52 FT"
+"PhotosChangeTimestamp": "2025-11-24T17:56:13Z"
+"PhotosCount": 10
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T03:39:06Z"
+"StreetDirSuffix": "North"
+"StreetName": "Fairway"
+"StreetNumber": "873"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3000"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29131785/c2-873-fairway-street-n-kitchener"
+"LeaseAmount": 30
+"LeasePerUnit": "square feet"
+"GeocodeManualYN": false
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "COM - 2"
+"FrontageLengthNumeric": 575.6
+"OriginalEntryTimestamp": "2025-11-24T17:56:13.82Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:10 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6337590114"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/0334d37c66fedb074b19aa4c441cb3d7.webp"
"MediaSize" => 163838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-0334d37c66fedb074b19aa4c441cb3d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6337590122"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/da7a91e43b91fd82dacc09914235ff53.webp"
"MediaSize" => 148970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-da7a91e43b91fd82dacc09914235ff53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6337590130"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/97e03112538c7c61b73ead186885cca2.webp"
"MediaSize" => 295323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-97e03112538c7c61b73ead186885cca2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6337590140"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/2be5ffe87cd77c18336b876d2034b7cd.webp"
"MediaSize" => 142390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-2be5ffe87cd77c18336b876d2034b7cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6337590154"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/cdbde04e203ea458d040cbb87786d294.webp"
"MediaSize" => 83951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-cdbde04e203ea458d040cbb87786d294.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6337590155"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/f097b1fdac7a5b492489a16c86980091.webp"
"MediaSize" => 142062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-f097b1fdac7a5b492489a16c86980091.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6337590187"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/6e1bdb642c22362e83847a5aa606ff96.webp"
"MediaSize" => 344750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-6e1bdb642c22362e83847a5aa606ff96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6337590196"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/773e9eecc6962c2df1d945b2d7d05a8e.webp"
"MediaSize" => 156984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-773e9eecc6962c2df1d945b2d7d05a8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6337590217"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/0ad3d9fbc9017f37a0f81afacd19d9be.webp"
"MediaSize" => 204734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-0ad3d9fbc9017f37a0f81afacd19d9be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6337590242"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131785/2ae84a8adf2ec83f107eeb0eb31a2653.webp"
"MediaSize" => 82935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131785/thumbnail-2ae84a8adf2ec83f107eeb0eb31a2653.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12571946"
"ResourceRecordKey" => "29131785"
"ModificationTimestamp" => "2025-11-24T17:56:13.83Z"
]
]
+"DaysOnMarket": 213
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29131785')"
+"ID": "985452"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
]