array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 28624583/Property?$select=ALL&$top=20&$filter=ListingKey eq 28624583&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 28624583/Property?$select=ALL&$top=20&$filter=ListingKey eq 28624583&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23657
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23659
+post_id: "162038"
+post_author: 1
+"ListingKey": "28624583"
+"ListingId": "40752709"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-07-18T16:36:02Z"
+"RFModificationTimestamp": "2025-07-18T19:13:35Z"
+"ListPrice": 1999000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 22680.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L1T4"
+"UnparsedAddress": "525 WILSON Street, Hamilton, Ontario L8L1T4"
+"Coordinates": array:2 [
0 => -79.846883
1 => 43.254237
]
+"Latitude": 43.254237
+"Longitude": -79.846883
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone - Hamilton-Burlington"
+"PublicRemarks": "Prime Downtown opportunity! Discover the perfect blend of space, location and potential at 525 Wilson Street. This 22,680 sq. ft. property, featuring approximately 20,000 sq. ft. of warehouse and 1,452 sq. ft. of office space, is a rare find in Hamilton's bustling downtown core. Zoned L-MR-2 Planned Development, this site offers boundless opportunities for redevelopment. Positioned just 350 meters from the future LRT stop, the property ensures exceptional connectivity and adds significant value for future growth. The site includes 15 parking spaces, a 16' clearance height and impressive frontage of approximately 198', making it a standout asset in a neighbourhood experiencing revitalization. Join the wave of innovation and development transforming this vibrant area. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-07-18T19:12:57.946623+00:00"
+"Directions": "From Wentworth turn East on Wilson St"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1945262"
+"ListOfficeKey": "294490"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-07-18T16:29:38Z"
+"PhotosCount": 16
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-07-18T16:29:38Z"
+"Stories": "2.0"
+"StreetName": "WILSON"
+"StreetNumber": "525"
+"StreetSuffix": "Street"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "17418.86"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"OriginalEntryTimestamp": "2025-07-18T16:29:38.16Z"
+"CoListOfficeKey": "55053"
+"CommonInterest": "Freehold"
+"ListingURL": "www.realtor.ca/real-estate/28624583/525-wilson-street-hamilton"
+"ZoningDescription": "L-MR-2"
+"FrontageLengthNumeric": 199.0
+"CoListAgentKey": "1523893"
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ParkingTotal": 15
+"ListAORKey": "14"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:16 [
0 => array:13 [
"Order" => 0
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/eb011071b5c87d419edbdc94ff027ea7.webp"
"MediaSize" => 169251
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-eb011071b5c87d419edbdc94ff027ea7.webp"
"MediaKey" => "6089435327"
"PreferredPhotoYN" => true
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
1 => array:13 [
"Order" => 1
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/8f893e60df84a4b2993eda92f8f14b10.webp"
"MediaSize" => 171142
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-8f893e60df84a4b2993eda92f8f14b10.webp"
"MediaKey" => "6089435366"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
2 => array:13 [
"Order" => 2
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/f21e31d0ec183d35233972b5220eb650.webp"
"MediaSize" => 172019
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-f21e31d0ec183d35233972b5220eb650.webp"
"MediaKey" => "6089435394"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
3 => array:13 [
"Order" => 3
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/550f316bb4a0b09781c0ad5222dc8be7.webp"
"MediaSize" => 177805
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-550f316bb4a0b09781c0ad5222dc8be7.webp"
"MediaKey" => "6089435411"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
4 => array:13 [
"Order" => 4
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/8d4270905933ea174fe00a1d020ab75b.webp"
"MediaSize" => 180607
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-8d4270905933ea174fe00a1d020ab75b.webp"
"MediaKey" => "6089435454"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
5 => array:13 [
"Order" => 5
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/f32a37a15c9512e2fe4dfa6e38b1261c.webp"
"MediaSize" => 176246
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-f32a37a15c9512e2fe4dfa6e38b1261c.webp"
"MediaKey" => "6089435533"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
6 => array:13 [
"Order" => 6
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/eb729e792dd3ff8992e0be07251bbcbb.webp"
"MediaSize" => 163341
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-eb729e792dd3ff8992e0be07251bbcbb.webp"
"MediaKey" => "6089435571"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
7 => array:13 [
"Order" => 7
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/ce7893f235c0834e593d8220cc87b90d.webp"
"MediaSize" => 200348
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-ce7893f235c0834e593d8220cc87b90d.webp"
"MediaKey" => "6089435614"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
8 => array:13 [
"Order" => 8
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/ceaa6eeb3634f5bb092c30d7e6a413cd.webp"
"MediaSize" => 209220
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-ceaa6eeb3634f5bb092c30d7e6a413cd.webp"
"MediaKey" => "6089435689"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
9 => array:13 [
"Order" => 9
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/93d713b1d6c99a24d0215ab170719213.webp"
"MediaSize" => 210722
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-93d713b1d6c99a24d0215ab170719213.webp"
"MediaKey" => "6089435722"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
10 => array:13 [
"Order" => 10
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/f641f2495b139314add606433d4f0a84.webp"
"MediaSize" => 206997
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-f641f2495b139314add606433d4f0a84.webp"
"MediaKey" => "6089435752"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
11 => array:13 [
"Order" => 11
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/101039ab66cabb612cc92cdd9caa1a51.webp"
"MediaSize" => 184511
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-101039ab66cabb612cc92cdd9caa1a51.webp"
"MediaKey" => "6089435773"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
12 => array:13 [
"Order" => 12
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/23e208ea175a553726f9d1bed7f67f5a.webp"
"MediaSize" => 167334
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-23e208ea175a553726f9d1bed7f67f5a.webp"
"MediaKey" => "6089435807"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
13 => array:13 [
"Order" => 13
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/d37fc0078ce057248ba0d31ede554290.webp"
"MediaSize" => 184346
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-d37fc0078ce057248ba0d31ede554290.webp"
"MediaKey" => "6089435859"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
14 => array:13 [
"Order" => 14
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/36091d7501becb77e0ff0278ceacd417.webp"
"MediaSize" => 181691
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-36091d7501becb77e0ff0278ceacd417.webp"
"MediaKey" => "6089435944"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
15 => array:13 [
"Order" => 15
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28624583/2c54b7dc4614eda6e4d156f5c0509687.webp"
"MediaSize" => 174659
"ResourceRecordKey" => "28624583"
"ResourceName" => "Property"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28624583/thumbnail-2c54b7dc4614eda6e4d156f5c0509687.webp"
"MediaKey" => "6089435968"
"PreferredPhotoYN" => false
"LongDescription" => null
"MediaType" => "webp"
"ResourceRecordId" => "40752709"
"ModificationTimestamp" => "2025-07-18T16:29:38.17Z"
"MediaCategory" => "Property Photo"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28624583')"
+"ID": "162038"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 294490/Office?$select=ALL&$top=10&$filter=OfficeKey eq 294490&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 294490/Office?$select=ALL&$top=10&$filter=OfficeKey eq 294490&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25461
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25463
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage State Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-662-6666"
+"OfficeMlsId": "HBRLPSTATE2"
+"ModificationTimestamp": "2025-07-09T19:37:07Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "294490"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "115 Highway 8 Unit 102"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Stoney Creek"
+"OfficePostalCode": "L8G1C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1439453"
+"OriginalEntryTimestamp": "2023-05-02T14:32:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439682"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "294490"
"SocialMediaUrlOrId" => "https://www.royallepagestate.ca/"
"ModificationTimestamp" => "2025-07-09T19:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1063185"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('294490')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1945262/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1945262&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1945262/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1945262&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25466
+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 28624583" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25082
+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 28624583/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28624583&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28624583/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28624583&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25062
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28624583 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Other' AND geo.distance(Coordinates, POINT(-79.846883 43.254237)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28624583 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Other' AND geo.distance(Coordinates, POINT(-79.846883 43.254237)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28624583 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Other' AND geo.distance(Coordinates, POINT(-79.846883 43.254237)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28624583 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Other' AND geo.distance(Coordinates, POINT(-79.846883 43.254237)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24944
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24947
+post_id: "456877"
+post_author: 1
+"ListingKey": "29150159"
+"ListingId": "40791353"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T00:35:47Z"
+"RFModificationTimestamp": "2025-12-05T00:36:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1257.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N1K7"
+"UnparsedAddress": "504 MAIN Street E Unit# 2, Hamilton, Ontario L8N1K7"
+"Coordinates": array:2 [
0 => -79.8492511
1 => 43.2503678
]
+"Latitude": 43.2503678
+"Longitude": -79.8492511
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "All Inclusive Commercial Space Available Immediately. This Storefront / Office space is PERFECT for any Beauty Related Businesses, Office Business, Sales or Retail. Mixed use means plenty of options! This unit is located on two incredibly busy streets (Main St E and Wentworth St S) offering Walk-In traffic potential, advertising visibility and much more! This Space is already renovated and Turn-Key; built out to presently include 4 private rooms, two open spaces, a kitchen and bathroom as well as a Main Entrance Area. This unit is on the second floor and there is parking in the rear. (id:62650)"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Electricity"
2 => "Water"
3 => "Other, See Remarks"
]
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-12-01T17:20:39.453708+00:00"
+"Directions": "Corner of Wentworth St S & Main St E"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2206042"
+"ListOfficeKey": "292301"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2025-12-01T14:31:12Z"
+"PhotosCount": 7
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T00:19:36Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "MAIN"
+"StreetNumber": "504"
+"StreetSuffix": "Street"
+"SubdivisionName": "143 - Stinson"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29150159/504-main-street-e-unit-2-hamilton"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1950
+"ExistingLeaseType": array:1 [
0 => "Net"
]
+"ZoningDescription": "H"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 61.0
+"OriginalEntryTimestamp": "2025-12-01T14:31:12.7Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:7 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6349615572"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150159/a67d6d62b2c41916d6c77b3b3dbfde61.webp"
"MediaSize" => 55779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150159/thumbnail-a67d6d62b2c41916d6c77b3b3dbfde61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with a paneled ceiling and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791353"
"ResourceRecordKey" => "29150159"
"ModificationTimestamp" => "2025-12-01T14:31:12.71Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6349615597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150159/f613411082420e29c0e68c9ada844d76.webp"
"MediaSize" => 64453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150159/thumbnail-f613411082420e29c0e68c9ada844d76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance to property with stucco siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791353"
"ResourceRecordKey" => "29150159"
"ModificationTimestamp" => "2025-12-01T14:31:12.71Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6349615618"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150159/f2f5ab824094e0c225602ec6b68cd548.webp"
"MediaSize" => 55309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150159/thumbnail-f2f5ab824094e0c225602ec6b68cd548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring radiator and light wood-type flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791353"
"ResourceRecordKey" => "29150159"
"ModificationTimestamp" => "2025-12-01T14:31:12.71Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6349615638"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150159/b9f96f7a329151d25d31cf2772b77fa7.webp"
"MediaSize" => 123340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150159/thumbnail-b9f96f7a329151d25d31cf2772b77fa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of uncovered parking lot"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791353"
"ResourceRecordKey" => "29150159"
"ModificationTimestamp" => "2025-12-01T14:31:12.71Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6349615659"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150159/3c154e07261ed1d895e48438efc88f76.webp"
"MediaSize" => 46191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150159/thumbnail-3c154e07261ed1d895e48438efc88f76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement featuring radiator heating unit, light wood-type flooring, a drop ceiling, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791353"
"ResourceRecordKey" => "29150159"
"ModificationTimestamp" => "2025-12-01T14:31:12.71Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6349615736"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150159/2fef9537017ddc1dc1ce2dfae9874532.webp"
"MediaSize" => 49386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150159/thumbnail-2fef9537017ddc1dc1ce2dfae9874532.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring a drop ceiling, radiator heating unit, and light wood-type flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791353"
"ResourceRecordKey" => "29150159"
"ModificationTimestamp" => "2025-12-01T14:31:12.71Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6349615757"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29150159/93440903fa4a16815b1b516992bc5a12.webp"
"MediaSize" => 34249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29150159/thumbnail-93440903fa4a16815b1b516992bc5a12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity and dark tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791353"
"ResourceRecordKey" => "29150159"
"ModificationTimestamp" => "2025-12-01T14:31:12.71Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29150159')"
+"ID": "456877"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+post_id: "414253"
+post_author: 1
+"ListingKey": "29096235"
+"ListingId": "40787115"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-12T20:25:47Z"
+"RFModificationTimestamp": "2025-11-13T01:25:41Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2000.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L3R5"
+"UnparsedAddress": "122 BURTON Street Unit# 1, Hamilton, Ontario L8L3R5"
+"Coordinates": array:2 [
0 => -79.84645
1 => 43.263429
]
+"Latitude": 43.263429
+"Longitude": -79.84645
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Looking for a place to store your vehicles this winter, work materials, or just want an industrial style office for your business? Look no further than this heated garage/office/storage/warehouse space. A small storage room and two-piece washroom are also in the unit. The garage door enables you easy access into the space for loading and unloading, or just for some fresh air. Flexible lease term, but looking for minimum 1 year commitment. 2nd floor office and other garage bay are occupied. NO CAR DETAILING USE. Flat monthly rent which includes the electric heating, water, and use of 1 parking spot. Inquire today! (id:62650)"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Electricity"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "Industrial Park"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"CreationDate": "2025-11-13T01:25:25.903885+00:00"
+"Directions": "Wentworth St N to Burton St"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2214378"
+"ListOfficeKey": "262629"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-12T20:19:34Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-12T20:19:34Z"
+"Stories": "2.0"
+"StreetName": "BURTON"
+"StreetNumber": "122"
+"StreetSuffix": "Street"
+"SubdivisionName": "133 - Keith"
+"Utilities": array:1 [
0 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29096235/122-burton-street-unit-1-hamilton"
+"ParkingTotal": 1
+"CommonInterest": "Freehold"
+"TotalActualRent": 2600
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ExistingLeaseType": array:1 [
0 => "Gross"
]
+"ZoningDescription": "Light Industrial (M6, 375) Zone"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 66.0
+"OriginalEntryTimestamp": "2025-11-12T20:19:33.88Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:17 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6319849175"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/48b483c6bbcbd0570764fd24f05cbe57.webp"
"MediaSize" => 48952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-48b483c6bbcbd0570764fd24f05cbe57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6319849200"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/d54ba1dd2a479ff54adfea74168ae732.webp"
"MediaSize" => 46503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-d54ba1dd2a479ff54adfea74168ae732.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6319849214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/9f3c6e668cc10b3c4c653b0eed0fa00b.webp"
"MediaSize" => 54283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-9f3c6e668cc10b3c4c653b0eed0fa00b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6319849243"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/89639a94c7dad8fac95939af89583d6d.webp"
"MediaSize" => 47757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-89639a94c7dad8fac95939af89583d6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6319849272"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/d36199beec356d8cf5144f5998e5bfab.webp"
"MediaSize" => 39977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-d36199beec356d8cf5144f5998e5bfab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6319849292"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/238f28e6e5f461646bbe116cc3572c9c.webp"
"MediaSize" => 41081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-238f28e6e5f461646bbe116cc3572c9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6319849355"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/daa1b8d3e5b5ea7cea8d654dfaa72d31.webp"
"MediaSize" => 39911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-daa1b8d3e5b5ea7cea8d654dfaa72d31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6319849398"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/868eac299be9f7d367cc91d558cc27c5.webp"
"MediaSize" => 40753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-868eac299be9f7d367cc91d558cc27c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6319849433"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/fa4e5f9be955d7d337943441ec46f5cc.webp"
"MediaSize" => 36398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-fa4e5f9be955d7d337943441ec46f5cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6319849460"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/ead88afdf875c2ed8765ff5d649ae336.webp"
"MediaSize" => 142509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-ead88afdf875c2ed8765ff5d649ae336.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6319849488"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/a3acb30c3cd692d73578db479050a3e6.webp"
"MediaSize" => 145161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-a3acb30c3cd692d73578db479050a3e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6319849508"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/12d6f2d905e7d22f6cbc6b4498932415.webp"
"MediaSize" => 154524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-12d6f2d905e7d22f6cbc6b4498932415.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6319849545"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/99f09477b8f0ad7653e1f1bb25ff3ae0.webp"
"MediaSize" => 98231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-99f09477b8f0ad7653e1f1bb25ff3ae0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6319849571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/e6822215c557b836c07a85c46adecdf5.webp"
"MediaSize" => 193638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-e6822215c557b836c07a85c46adecdf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6319849589"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/f9bc47c1052100ef5375768607065f4d.webp"
"MediaSize" => 186276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-f9bc47c1052100ef5375768607065f4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6319849610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/a92bfad6524cc1b370ca695b8bbf9ebe.webp"
"MediaSize" => 179407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-a92bfad6524cc1b370ca695b8bbf9ebe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6319849636"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29096235/9e52a90232335dc24269a20314a7e410.webp"
"MediaSize" => 192188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29096235/thumbnail-9e52a90232335dc24269a20314a7e410.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787115"
"ResourceRecordKey" => "29096235"
"ModificationTimestamp" => "2025-11-12T20:19:33.89Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29096235')"
+"ID": "414253"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24978
+post_id: "415131"
+post_author: 1
+"ListingKey": "29008351"
+"ListingId": "40780458"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-12T20:40:55Z"
+"RFModificationTimestamp": "2025-11-13T01:10:21Z"
+"ListPrice": 1.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 85344.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N1E3"
+"UnparsedAddress": "547 KING Street E, Hamilton, Ontario L8N1E3"
+"Coordinates": array:2 [
0 => -79.8524307
1 => 43.2528093
]
+"Latitude": 43.2528093
+"Longitude": -79.8524307
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 547 King Street East, Hamilton — an exceptional, site-approved development opportunity in the heart of downtown. This rare and fully approved project spans 8 storeys and is designed for 172 residential condo units with 66 parking spaces, offering a highly efficient and modern layout that fits perfectly into Hamilton’s growing urban landscape. The property represents a carefully executed land assembly of 5 total pins — saving the next developer invaluable time, cost, and red tape associated with zoning, design, and municipal approvals. With all the groundwork complete, you can move directly into the next stage of construction and bring your vision to life. Located along one of Hamilton’s most active development corridors, this address is surrounded by major residential and commercial growth, top transit routes, and minutes to downtown amenities, and restaurants. This is your chance to build a legacy project and create the next landmark residence in Hamilton’s revitalized core. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-11-13T01:10:07.473103+00:00"
+"Directions": "King St. E west of Wentworth"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2164830"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-10-20T11:49:41Z"
+"PhotosCount": 6
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-12T20:20:29Z"
+"StreetDirSuffix": "East"
+"StreetName": "KING"
+"StreetNumber": "547"
+"StreetSuffix": "Street"
+"SubdivisionName": "231 - Homeside"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/9fqq9F3eNQo?si=9tfyNeAR5isH0kEP"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29008351/547-king-street-e-hamilton"
+"CoListAgentKey": "2067042"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "294394"
+"ZoningDescription": "TOC1"
+"FrontageLengthNumeric": 90.0
+"OriginalEntryTimestamp": "2025-10-20T11:49:41.04Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:6 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6319919832"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29008351/625458816b005b670d68bd37a3576f3f.webp"
"MediaSize" => 134057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29008351/thumbnail-625458816b005b670d68bd37a3576f3f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40780458"
"ResourceRecordKey" => "29008351"
"ModificationTimestamp" => "2025-10-20T11:49:41.05Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6319919899"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29008351/ce8e35156047f7d1db5a37cbeeb0f83e.webp"
"MediaSize" => 186224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29008351/thumbnail-ce8e35156047f7d1db5a37cbeeb0f83e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view of property's location"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40780458"
"ResourceRecordKey" => "29008351"
"ModificationTimestamp" => "2025-10-20T11:49:41.05Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6319919921"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29008351/97f7ce2de70491e21bf6f421d602e6ca.webp"
"MediaSize" => 171652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29008351/thumbnail-97f7ce2de70491e21bf6f421d602e6ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view of property's location"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40780458"
"ResourceRecordKey" => "29008351"
"ModificationTimestamp" => "2025-10-20T11:49:41.05Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6319919988"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29008351/260a54d356c10b6aa9475075a534ebb6.webp"
"MediaSize" => 167467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29008351/thumbnail-260a54d356c10b6aa9475075a534ebb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property location with nearby urban area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40780458"
"ResourceRecordKey" => "29008351"
"ModificationTimestamp" => "2025-10-20T11:49:41.05Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6319920053"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29008351/04b744e9e38eb3614732945bb28c002f.webp"
"MediaSize" => 160296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29008351/thumbnail-04b744e9e38eb3614732945bb28c002f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial view of property's location with nearby urban area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40780458"
"ResourceRecordKey" => "29008351"
"ModificationTimestamp" => "2025-10-20T11:49:41.05Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6319920113"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29008351/075f0635e2694c3cad2e1dd0115ec325.webp"
"MediaSize" => 157330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29008351/thumbnail-075f0635e2694c3cad2e1dd0115ec325.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property location featuring nearby urban area and a nearby body of water"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40780458"
"ResourceRecordKey" => "29008351"
"ModificationTimestamp" => "2025-10-20T11:49:41.05Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29008351')"
+"ID": "415131"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25331
+post_id: "397867"
+post_author: 1
+"ListingKey": "29077271"
+"ListingId": "40786274"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-19T21:55:55Z"
+"RFModificationTimestamp": "2025-11-19T21:57:17Z"
+"ListPrice": 388888.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 3021.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L2Y8"
+"UnparsedAddress": "474 BARTON Street E, Hamilton, Ontario L8L2Y8"
+"Coordinates": array:2 [
0 => -79.845333
1 => 43.258972
]
+"Latitude": 43.258972
+"Longitude": -79.845333
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Excellent investment opportunity in a high-traffic location! This versatile commercial property features a main-level storefront with great street visibility—ideal for any business. The basement includes a separate unit, perfect for owner use or an additional tenant. The upper level offers a spacious two-bedroom apartment with a bright sunroom, providing comfortable living with plenty of natural light. Separate hydro meters for the main and upper levels offer flexibility for tenants. Recent updates ensure this property is move-in ready. A great opportunity for investors or owner-operators seeking multiple income streams in a prime area! (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-11-07T03:26:09.901179+00:00"
+"Directions": "Take Main to North on Wentworth St East on Barton St"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-11-06T21:29:26Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-19T21:38:59Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "BARTON"
+"StreetNumber": "474"
+"StreetSuffix": "Street"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "4500"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29077271/474-barton-street-e-hamilton"
+"CommonInterest": "Freehold"
+"ZoningDescription": "C5"
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2025-11-06T21:29:26.46Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:30 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6299619867"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/5a95f684ea81c8de79b04faf25ac6529.webp"
"MediaSize" => 120239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-5a95f684ea81c8de79b04faf25ac6529.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6299619940"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/d79e3f677ebf3583942dd6a6216b32dd.webp"
"MediaSize" => 113843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-d79e3f677ebf3583942dd6a6216b32dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6299619952"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/26e12a70ef69cdc75e4b59da455bbe74.webp"
"MediaSize" => 67087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-26e12a70ef69cdc75e4b59da455bbe74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6299619956"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/e75e8eb94bbd306b9419146315b286eb.webp"
"MediaSize" => 77139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-e75e8eb94bbd306b9419146315b286eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6299619975"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/8a372d81da4bf3de5c017c6a9aac1349.webp"
"MediaSize" => 59607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-8a372d81da4bf3de5c017c6a9aac1349.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6299619989"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/7b0dd0caa87ada45cef8b76e9f18aa0c.webp"
"MediaSize" => 56939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-7b0dd0caa87ada45cef8b76e9f18aa0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6299620013"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/922adb4a4ed5d3550215f0e075ee9496.webp"
"MediaSize" => 64846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-922adb4a4ed5d3550215f0e075ee9496.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6299620017"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/4a9124357b554d2d94254d5cd3a64a1a.webp"
"MediaSize" => 66411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-4a9124357b554d2d94254d5cd3a64a1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6299620034"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/60d43b1884e0544d4a89981e87086ec8.webp"
"MediaSize" => 81546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-60d43b1884e0544d4a89981e87086ec8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6299620043"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/c55bfe598703163df94e24528078ef1e.webp"
"MediaSize" => 45691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-c55bfe598703163df94e24528078ef1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6299620054"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/9f2487fb710f44012bf824967000416d.webp"
"MediaSize" => 41270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-9f2487fb710f44012bf824967000416d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6299620072"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/ff493504dd65c42e6914eb2150f4fbfd.webp"
"MediaSize" => 43397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-ff493504dd65c42e6914eb2150f4fbfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6299620088"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/1e501134074b26c10b999e87d165bf6a.webp"
"MediaSize" => 52076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-1e501134074b26c10b999e87d165bf6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6299620102"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/f7973fc6fead14b600a5f25b20bec382.webp"
"MediaSize" => 44767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-f7973fc6fead14b600a5f25b20bec382.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6299620107"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/0a815f5795489ba13d417d3882de53b2.webp"
"MediaSize" => 36466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-0a815f5795489ba13d417d3882de53b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6299620117"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/2e77d4a428ae954b191b3f0af2e0e4f1.webp"
"MediaSize" => 29303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-2e77d4a428ae954b191b3f0af2e0e4f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6299620127"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/96083447fb16231ce8520becd72f5e61.webp"
"MediaSize" => 61146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-96083447fb16231ce8520becd72f5e61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6299620160"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/e54ce4130cbe79f1477e707ca7c5e875.webp"
"MediaSize" => 59359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-e54ce4130cbe79f1477e707ca7c5e875.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6299620170"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/eea1ffdd6fbf47e50a5c0f88f4b0a202.webp"
"MediaSize" => 50239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-eea1ffdd6fbf47e50a5c0f88f4b0a202.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6299620185"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/d6c9a41269a66f8fdec7562c00333057.webp"
"MediaSize" => 48445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-d6c9a41269a66f8fdec7562c00333057.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6299620200"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/411137f2c2ccc613bb3da73ac3dbbafc.webp"
"MediaSize" => 38511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-411137f2c2ccc613bb3da73ac3dbbafc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6299620209"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/d9685fb6a814cd3698d7c991b2559433.webp"
"MediaSize" => 35591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-d9685fb6a814cd3698d7c991b2559433.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6299620224"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/014d67085927ed67132669db2c1528dc.webp"
"MediaSize" => 53004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-014d67085927ed67132669db2c1528dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6299620234"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/acbb08eccad02f1646dbc3fc8ea8f412.webp"
"MediaSize" => 57453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-acbb08eccad02f1646dbc3fc8ea8f412.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6299620243"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/d2fc6c16f5828b67aab4f71508e8d31d.webp"
"MediaSize" => 62355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-d2fc6c16f5828b67aab4f71508e8d31d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6299620252"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/1b8682f4824e3ea57c6df38d9bf24668.webp"
"MediaSize" => 149299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-1b8682f4824e3ea57c6df38d9bf24668.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6299620271"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/d6f2249a539c146b2a32614964b7a5b2.webp"
"MediaSize" => 173100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-d6f2249a539c146b2a32614964b7a5b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6299620291"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/75ba6ab784d74ff8dea540bad629c9c1.webp"
"MediaSize" => 129324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-75ba6ab784d74ff8dea540bad629c9c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6299620296"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/6e7c697edd165633e0acece72e46cc25.webp"
"MediaSize" => 156431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-6e7c697edd165633e0acece72e46cc25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6299620303"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29077271/94f22a69303beef6cd8751365a5a22b3.webp"
"MediaSize" => 165431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29077271/thumbnail-94f22a69303beef6cd8751365a5a22b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40786274"
"ResourceRecordKey" => "29077271"
"ModificationTimestamp" => "2025-11-06T21:29:26.46Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29077271')"
+"ID": "397867"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
+post_id: "394839"
+post_author: 1
+"ListingKey": "29074623"
+"ListingId": "40785766"
+"PropertyType": "Other"
+"PropertySubType": "Hospitality"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-06T17:00:10Z"
+"RFModificationTimestamp": "2025-11-06T17:25:22Z"
+"ListPrice": 2999999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 7140.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N3Y6"
+"UnparsedAddress": "33 BOWEN Street, Hamilton, Ontario L8N3Y6"
+"Coordinates": array:2 [
0 => -79.866158
1 => 43.253923
]
+"Latitude": 43.253923
+"Longitude": -79.866158
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 33 Bowen Street, a historic gem in downtown Hamilton's vibrant restaurant and nightlife scene for decades. Originally built as a carriage house in the 1800's and later converted into a hotel in the early 1900's, this property offers over 7,100 sqft. of prime commercial space. Recent updates include modernized washrooms, refreshed upholstery, and modernized interior decoration. The upstairs portion features an immaculate bar imported from Dublin, perfect for hosting events. Seize the opportunity to make your mark on this iconic building and continue its legacy. (id:62650)"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-11-06T17:25:09.025769+00:00"
+"Directions": "Main Street to Bowen"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525198"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-11-06T15:51:50Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-06T16:48:56Z"
+"Stories": "1.0"
+"StreetName": "BOWEN"
+"StreetNumber": "33"
+"StreetSuffix": "Street"
+"SubdivisionName": "142 - Corktown"
+"TaxAnnualAmount": "26000"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29074623/33-bowen-street-hamilton"
+"CommonInterest": "Freehold"
+"ZoningDescription": "D3"
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2025-11-06T15:49:03.51Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:13 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6298997277"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/c44eb676eb72238bf871ccbae5950c10.webp"
"MediaSize" => 153661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-c44eb676eb72238bf871ccbae5950c10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of home featuring roof with shingles, stone siding, board and batten siding, and a chimney"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.88Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6298997341"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/c4097c4cc131c48a969746f6f5e2cf2c.webp"
"MediaSize" => 99889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-c4097c4cc131c48a969746f6f5e2cf2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.85Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6298997358"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/cd0b1a0bfe99178f0871a1495007350c.webp"
"MediaSize" => 114696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-cd0b1a0bfe99178f0871a1495007350c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.54Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6298997393"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/f91e800e100ea6340286584979533b67.webp"
"MediaSize" => 117968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-f91e800e100ea6340286584979533b67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.86Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6298997426"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/ae6fef8d14c1f39a0124160ec6ffa228.webp"
"MediaSize" => 79589
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-ae6fef8d14c1f39a0124160ec6ffa228.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.85Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6298997473"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/7cb38d57b6fe9bbb16bf11d559fc2104.webp"
"MediaSize" => 105139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-7cb38d57b6fe9bbb16bf11d559fc2104.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.85Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6298997542"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/ce70d1d712a6aa0e8ec41a3b347b0637.webp"
"MediaSize" => 106325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-ce70d1d712a6aa0e8ec41a3b347b0637.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.86Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6298997568"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/301e97d81c8f5227d2c61cfcc32b9364.webp"
"MediaSize" => 71451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-301e97d81c8f5227d2c61cfcc32b9364.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.85Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6298997636"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/2df5f36f37c7f272c424d561f4803fcb.webp"
"MediaSize" => 96770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-2df5f36f37c7f272c424d561f4803fcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.89Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6298997692"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/e5a54c16f1031eae2add04aba36bc743.webp"
"MediaSize" => 81678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-e5a54c16f1031eae2add04aba36bc743.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.88Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6298997770"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/045b67b5ca0fe4829b3a8a6e993035cf.webp"
"MediaSize" => 92073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-045b67b5ca0fe4829b3a8a6e993035cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.85Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6298997814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/6c3fc7a5c573d0adae7fd24d36b0e453.webp"
"MediaSize" => 108263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-6c3fc7a5c573d0adae7fd24d36b0e453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.85Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6298997860"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29074623/f224808771328a7f0f0002b92eec39b2.webp"
"MediaSize" => 89468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29074623/thumbnail-f224808771328a7f0f0002b92eec39b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785766"
"ResourceRecordKey" => "29074623"
"ModificationTimestamp" => "2025-11-06T15:51:50.87Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29074623')"
+"ID": "394839"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24991
+post_id: "391016"
+post_author: 1
+"ListingKey": "29070411"
+"ListingId": "40785780"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-11T22:35:37Z"
+"RFModificationTimestamp": "2025-11-17T12:03:24Z"
+"ListPrice": 665000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 1308.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N2C5"
+"UnparsedAddress": "175 JOHN Street S, Hamilton, Ontario L8N2C5"
+"Coordinates": array:2 [
0 => -79.86824844
1 => 43.25140387
]
+"Latitude": 43.25140387
+"Longitude": -79.86824844
+"YearBuilt": 1900
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 175 John St S, a rare mixed-use opportunity in the heart of Hamilton’s vibrant Corktown—just a one-minute walk to the GO Station on James St S. This distinctive live-work property combines flexibility, visibility, and income potential in one of the city’s most walkable neighbourhoods. Main Level - Commercial (638 sq ft): high-traffic exposure with storefront display, roughed-in kitchen, and separate utilities, ideal for a café, studio, boutique retail, or professional office. The open layout adapts easily to a variety of business uses, and with vacant possession, it’s ready for immediate occupancy. Upper Level - Residential (670 sq ft): bright 2-bedroom apartment with a full bath, balcony, in-suite laundry, separate entrance, and dedicated parking. Also vacant, offering the option to live above your business or lease for steady income. Corktown blends historic charm with modern energy—steps to parks, dining, and transit. Whether you’re an entrepreneur seeking convenience, an investor building a portfolio, or a business owner envisioning a signature space, this property delivers urban lifestyle and long-term value in one unbeatable location. (id:62650)"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-11-05T19:42:07.527644+00:00"
+"Directions": "Located on the East side of John Street S at corner of Augusta St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1560098"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2025-11-11T22:30:14Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-11T22:30:14Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "JOHN"
+"StreetNumber": "175"
+"StreetSuffix": "Street"
+"SubdivisionName": "142 - Corktown"
+"TaxAnnualAmount": "8162"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://www.propertypanorama.com/instaview/itso/40785780"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29070411/175-john-street-s-hamilton"
+"ParkingTotal": 1
+"CoListAgentKey": "1866948"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Security system"
]
+"ZoningDescription": "C5"
+"FrontageLengthNumeric": 16.0
+"OriginalEntryTimestamp": "2025-11-05T17:38:37.49Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:47 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6308078378"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/7a570850e54e9fccfaae1ffb0d3e3d1b.webp"
"MediaSize" => 125825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-7a570850e54e9fccfaae1ffb0d3e3d1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:51.66Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6308078424"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/b028bf5f3eca614957d34f91a85281ed.webp"
"MediaSize" => 115227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-b028bf5f3eca614957d34f91a85281ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:52.25Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6308078448"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/6eed3d8d6de561028d1c194e23cadf86.webp"
"MediaSize" => 90499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-6eed3d8d6de561028d1c194e23cadf86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Property entrance featuring brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:52.26Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6308078479"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/e7065d85e051b0db696f1a7c1c35931b.webp"
"MediaSize" => 111205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-e7065d85e051b0db696f1a7c1c35931b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of house featuring brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:52.27Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6308078519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/03a0695529dfb4b819c58e3222869524.webp"
"MediaSize" => 38050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-03a0695529dfb4b819c58e3222869524.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:51.66Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6308078593"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/7e33709988f070a2c25ae49242e09228.webp"
"MediaSize" => 92323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-7e33709988f070a2c25ae49242e09228.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.66Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6308078620"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/0120be134c79f3c61c5c9d024e7e84ab.webp"
"MediaSize" => 153919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-0120be134c79f3c61c5c9d024e7e84ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining space featuring hardwood / wood-style floors and floor to ceiling windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:52.25Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6308078642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/0a39bc73532121059637aea8def91ba2.webp"
"MediaSize" => 93057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-0a39bc73532121059637aea8def91ba2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining room featuring wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:51.67Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6308078677"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/06a605969b5d2c213a1854bc3abe1426.webp"
"MediaSize" => 58149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-06a605969b5d2c213a1854bc3abe1426.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:51.69Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6308078716"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/55a67b02305e69ea5884b31749c758be.webp"
"MediaSize" => 100279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-55a67b02305e69ea5884b31749c758be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of bar area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.66Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6308078772"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/3849df0ba23666b0d2ad7ecd70b0c0ed.webp"
"MediaSize" => 62752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-3849df0ba23666b0d2ad7ecd70b0c0ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Community lobby featuring a wall of windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.66Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6308078836"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/f438bbd1aea770f8336ffac2584ae476.webp"
"MediaSize" => 164513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-f438bbd1aea770f8336ffac2584ae476.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.65Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6308078859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/b7be0328fa25361e0693c3f648396837.webp"
"MediaSize" => 164195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-b7be0328fa25361e0693c3f648396837.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:51.72Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6308078875"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/0a2f8ae8ca36661d3b7541983515f106.webp"
"MediaSize" => 153919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-0a2f8ae8ca36661d3b7541983515f106.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.65Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6308078888"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/9b3193e8ba30e06cad9cc982de534a08.webp"
"MediaSize" => 173157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-9b3193e8ba30e06cad9cc982de534a08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Indoor dry bar featuring a city view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:52.33Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6308078974"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/ac861d4ac2512655394b0f9675b3583a.webp"
"MediaSize" => 143414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-ac861d4ac2512655394b0f9675b3583a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.69Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6308079020"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/6bddafe26db8371a26a49a426930cf61.webp"
"MediaSize" => 152882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-6bddafe26db8371a26a49a426930cf61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of snow covered back of property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:51.69Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6308079053"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/0ee2889e1f2f6571663d831553940e1f.webp"
"MediaSize" => 164195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-0ee2889e1f2f6571663d831553940e1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:51.73Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6308079104"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/21262354af0dd5b7e7cb4126f8ac3b6d.webp"
"MediaSize" => 98748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-21262354af0dd5b7e7cb4126f8ac3b6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bar area with hardwood / wood-style floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.65Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6308079175"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/9b737a9fd5a097477dd28994676807e1.webp"
"MediaSize" => 131901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-9b737a9fd5a097477dd28994676807e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.71Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6308079255"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/595afdcdc452cc9d476ceda211ccdd70.webp"
"MediaSize" => 94369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-595afdcdc452cc9d476ceda211ccdd70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.66Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6308079326"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/058e7fd9e151a83b64d81cfcbe536bfe.webp"
"MediaSize" => 82487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-058e7fd9e151a83b64d81cfcbe536bfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40785780"
"ResourceRecordKey" => "29070411"
"ModificationTimestamp" => "2025-11-11T02:11:50.69Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6308079396"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29070411/0b56422948eec4b5ae5120996348dfca.webp"
"MediaSize" => 147319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29070411/thumbnail-0b56422948eec4b5ae5120996348dfca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of recreation room"
…4
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29070411')"
+"ID": "391016"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23671
+post_id: "368881"
+post_author: 1
+"ListingKey": "29041886"
+"ListingId": "40779405"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-28T23:00:45Z"
+"RFModificationTimestamp": "2025-10-29T06:31:15Z"
+"ListPrice": 1295000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 4387.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N2J4"
+"UnparsedAddress": "120 CATHARINE Street S, Hamilton, Ontario L8N2J4"
+"Coordinates": array:2 [
0 => -79.86723073
1 => 43.25142735
]
+"Latitude": 43.25142735
+"Longitude": -79.86723073
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "OFFICE opportunity in Hamilton’s Corktown. Corner location, lots of parking, 10+ offices, kitchen & 2 bathrooms. This mixed-use property on Augusta Street is zoned E-3 (High Density Multiple Dwellings), offering incredible potential for future development or redevelopment. Take advantage of this prime location and strong zoning flexibility — build new, expand, or continue to use the existing office building. The current building can also be leased to generate income while you plan your next project. A rare chance to secure a property in one of Hamilton’s most vibrant, fast-growing communities, steps from downtown, transit, restaurants, and amenities. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-10-29T06:30:55.032602+00:00"
+"Directions": "Main St to Catharine St South"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1999167"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-10-28T22:46:37Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-28T22:46:37Z"
+"Stories": "3.0"
+"StreetDirSuffix": "South"
+"StreetName": "CATHARINE"
+"StreetNumber": "120"
+"StreetSuffix": "Street"
+"SubdivisionName": "142 - Corktown"
+"TaxAnnualAmount": "21432"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone - Hamilton-Burlington"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29041886/120-catharine-street-s-hamilton"
+"ParkingTotal": 8
+"CoListAgentKey": "2177968"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284639"
+"ZoningDescription": "E-3"
+"FrontageLengthNumeric": 97.0
+"OriginalEntryTimestamp": "2025-10-28T22:46:37.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:25 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29041886')"
+"ID": "368881"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+post_id: "354976"
+post_author: 1
+"ListingKey": "29032460"
+"ListingId": "40782210"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-03T15:20:32Z"
+"RFModificationTimestamp": "2025-12-03T15:23:35Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 275.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N2B9"
+"UnparsedAddress": "57 JOHN Street S Unit# 2, Hamilton, Ontario L8N2B9"
+"Coordinates": array:2 [
0 => -79.86713326
1 => 43.25406805
]
+"Latitude": 43.25406805
+"Longitude": -79.86713326
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Class A commercial space available in the heart of downtown Hamilton. This commercial unit is located on the top floor of 57-B John St S, offering convenience to its tenants and a blend of modern renovations with the charm of its historic past. With 24-hour access and a range of amenities such as an updated kitchen, 2-pc bathroom, & a 3-pc bathroom with shower facilities. Impress clients with a dedicated waiting area and host meetings in the common area glass boardroom. Located in the downtown core, this location offers accessibility to transit, including future LRT, many cafes, restaurants, and amenities. Simplify your budget with the convenience of a gross lease structure that covers your hydro, water, heat, common area maintenance, and internet. With everything taken care of, you can focus on growing your business and achieving your goals. Schedule a viewing today and unlock the potential of this prime commercial space. Single-vehicle parking space is included within the rent. (id:62650)"
+"AssociationFeeIncludes": array:7 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Electricity"
5 => "Water"
6 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"CreationDate": "2025-10-26T06:06:21.218642+00:00"
+"Directions": "Main Street East, South onto John Street South"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2042306"
+"ListOfficeKey": "293983"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"PhotosChangeTimestamp": "2025-10-25T16:19:51Z"
+"PhotosCount": 19
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-03T15:09:52Z"
+"Stories": "1.0"
+"StreetDirSuffix": "South"
+"StreetName": "JOHN"
+"StreetNumber": "57"
+"StreetSuffix": "Street"
+"SubdivisionName": "142 - Corktown"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29032460/57-john-street-s-unit-2-hamilton"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1250
+"ExistingLeaseType": array:1 [
0 => "Gross"
]
+"ZoningDescription": "D3"
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 16.0
+"OriginalEntryTimestamp": "2025-10-25T16:19:51.75Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:19 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29032460')"
+"ID": "354976"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "289769"
+post_author: 1
+"ListingKey": "28957632"
+"ListingId": "40776652"
+"PropertyType": "Other"
+"PropertySubType": "Other"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T21:25:21Z"
+"RFModificationTimestamp": "2025-11-20T21:28:47Z"
+"ListPrice": 1249900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 2208.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L4J5"
+"UnparsedAddress": "577 BURLINGTON Street E, Hamilton, Ontario L8L4J5"
+"Coordinates": array:2 [
0 => -79.839099
1 => 43.267369
]
+"Latitude": 43.267369
+"Longitude": -79.839099
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "EXCELLENT MULTI USE OFFICE/TIRE/AUTO/SHOP OPPORTUNITY IN HIGH TRAFFIC AREA. Modern open concept 1,500 sqft showroom/office, renovated within the last 2 years with high end finishes. Heated 2 car, 708 sqft bay with 2x 12X10 door and 2 new car lifts. Zoned Industrial (M5) allows for many opportunities and multiple uses. Great tire shop location or other auto uses including car sales. Fenced secure lot. Storage containers if needed. Lot can accommodate 15+ cars. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BuildingAreaUnits": "square feet"
+"CreationDate": "2025-10-06T21:02:55.063165+00:00"
+"Directions": "NIKOLA TESLA BLVD TO BURLINGTON STREET"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1999167"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T21:10:44Z"
+"PhotosCount": 14
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-20T21:10:44Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "BURLINGTON"
+"StreetNumber": "577"
+"StreetSuffix": "Street"
+"SubdivisionName": "210 - North Sherman"
+"TaxAnnualAmount": "3294"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28957632/577-burlington-street-e-hamilton"
+"ParkingTotal": 17
+"CoListAgentKey": "2177968"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284639"
+"ZoningDescription": "INDUSTRIAL (M5) ZONE"
+"FrontageLengthNumeric": 64.0
+"OriginalEntryTimestamp": "2025-10-06T20:19:19.39Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"Media": array:14 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28957632')"
+"ID": "289769"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 35
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]