Fullscreen
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113517&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113517&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113517&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113517&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14237 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14231 +post_id: "151414" +post_author: 1 +"ListingKey": "X10850094" +"ListingId": "X10850094" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:23:40Z" +"RFModificationTimestamp": "2025-04-26T02:57:27Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 665.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 313, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:20.647861+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:23:40Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-05-25T16:34:10Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591575" +"ParcelNumber": "0" +"ParkingFeatures": "Other" +"PhotosChangeTimestamp": "2024-12-16T14:23:40Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "313" +"Utilities": "Unknown" +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150035152" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:23:40Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10850094')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"RetailArea": 665.0 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-220820b812ee074c0abcfd5ac0e5f100.webp" "ShortDescription" => "" "MediaKey" => "06ce213d-814c-414f-9bc4-aef00480e2e9" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/220820b812ee074c0abcfd5ac0e5f100.webp" "MediaSize" => 88285 "SourceSystemMediaKey" => "150290752" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => "" "ImageHeight" => null ] 1 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-242fa9047253e4567369469a5c0c23bf.webp" "ShortDescription" => "" "MediaKey" => "4c58ebf7-fcb2-45c1-b04a-95522ff46668" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/242fa9047253e4567369469a5c0c23bf.webp" "MediaSize" => 107232 "SourceSystemMediaKey" => "150290753" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 2 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-4a77df9aa91b357242980c5b6bbf8202.webp" "ShortDescription" => "" "MediaKey" => "3aba3de2-1e43-4c22-8a31-6d39e0adfe57" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/4a77df9aa91b357242980c5b6bbf8202.webp" "MediaSize" => 81029 "SourceSystemMediaKey" => "150290754" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 3 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-d6b49dc6efebffc0b5d4797845bb00ee.webp" "ShortDescription" => "" "MediaKey" => "610db8e3-0cec-4373-a1e7-69d65705f6d9" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/d6b49dc6efebffc0b5d4797845bb00ee.webp" "MediaSize" => 81216 "SourceSystemMediaKey" => "150290755" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 4 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-536fcdc1a17baee58636e1f365affedc.webp" "ShortDescription" => "" "MediaKey" => "5c4c2391-6e5d-4839-b83c-0445ee8a76dc" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/536fcdc1a17baee58636e1f365affedc.webp" "MediaSize" => 77896 "SourceSystemMediaKey" => "150290756" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 5 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-7f1a209107431d69079954095fea54ef.webp" "ShortDescription" => "" "MediaKey" => "3dbb16ee-16cc-419d-bb19-f646e50c29f8" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/7f1a209107431d69079954095fea54ef.webp" "MediaSize" => 73290 "SourceSystemMediaKey" => "150290757" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 6 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-79a4461376a1479eb161b0d956b152fa.webp" "ShortDescription" => "" "MediaKey" => "352deb3b-f71b-412f-87e4-c20c73789d51" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/79a4461376a1479eb161b0d956b152fa.webp" "MediaSize" => 85317 "SourceSystemMediaKey" => "150290758" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 7 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-7e6bba5d06a453e034383b5305702815.webp" "ShortDescription" => "" "MediaKey" => "62e3882d-c321-4280-bdaf-a0991e96922c" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/7e6bba5d06a453e034383b5305702815.webp" "MediaSize" => 95299 "SourceSystemMediaKey" => "150290759" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 8 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-965b9ea96492c1d55a8b6be6e86850fa.webp" "ShortDescription" => "" "MediaKey" => "3aaefbfe-2692-494b-bfca-3522a244a171" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 8 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/965b9ea96492c1d55a8b6be6e86850fa.webp" "MediaSize" => 68289 "SourceSystemMediaKey" => "150290760" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 9 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-c2b7263d2468b87e5bb2b749794e62a9.webp" "ShortDescription" => "" "MediaKey" => "86af0190-543e-4425-830e-41041d3cea10" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 9 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/c2b7263d2468b87e5bb2b749794e62a9.webp" "MediaSize" => 78819 "SourceSystemMediaKey" => "150290761" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 10 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-6d39834065c41cc0373dccea9534701d.webp" "ShortDescription" => "" "MediaKey" => "74e47aa9-c9cd-486a-a03a-318c88c72bf6" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 10 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/6d39834065c41cc0373dccea9534701d.webp" "MediaSize" => 71105 "SourceSystemMediaKey" => "150290762" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 11 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-b5c346855d8c77fd6eca4397fb4552e9.webp" "ShortDescription" => "" "MediaKey" => "86dc0522-1325-4425-bf37-68ec117983fd" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 11 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/b5c346855d8c77fd6eca4397fb4552e9.webp" "MediaSize" => 68814 "SourceSystemMediaKey" => "150290763" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 12 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-feb9f6dfd9270c9030a1fa3916360090.webp" "ShortDescription" => "" "MediaKey" => "ecf82fc5-4399-4ef3-b3f1-449161416633" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 12 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/feb9f6dfd9270c9030a1fa3916360090.webp" "MediaSize" => 99014 "SourceSystemMediaKey" => "150290764" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 13 => array:26 [ "ResourceRecordKey" => "X10850094" "MediaModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10850094/thumbnail-d5e20650cffedb065430ed4ffe3fddc8.webp" "ShortDescription" => "" "MediaKey" => "754c63be-9da5-4d28-af54-ca13c733479a" "ImageWidth" => null "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-16T14:23:40.198937Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 13 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10850094/d5e20650cffedb065430ed4ffe3fddc8.webp" "MediaSize" => 74895 "SourceSystemMediaKey" => "150290765" "SourceSystemID" => "ragbos" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] ] +"ID": "151414" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14233 +post_id: "151415" +post_author: 1 +"ListingKey": "X10431841" +"ListingId": "X10431841" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:23:19Z" +"RFModificationTimestamp": "2025-04-27T00:25:55Z" +"ListPrice": 1750.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 429.0 +"City": "Hamilton" +"PostalCode": "L8P 0C6" +"UnparsedAddress": "15 Queen St S S Street Unit 1505, Hamilton, On L8p 0c6" +"Coordinates": array:2 [ 0 => -79.8810928 1 => 43.2535589 ] +"Latitude": 43.2535589 +"Longitude": -79.8810928 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Key Location, amazing views, with public access right at your door steps! Perfect for someone who studies and works at Mc Master or nearby area, this relatively newly built 1-Bedroom 1-Bath condo unit on the 15th floor is located directly on King St. W and Queen St. S. This amazing unit features an open concept layout with a modern kitchen complete with stainless steel appliances (including dishwasher), full bath and in-suite laundry. Lots of natural light, a private large balcony, 9 foot ceilings and lavish finishes. Conveniently located walking distance to Hess Village (shops, restaurants and cafes), minutes to Hamilton Go or West Harbour Go, QEW and 403, Bus Routes to Mc Master University or Columbia International College. Amenities include: lobby concierge, gym, yoga deck, party room and rooftop terrace with BBQs, and storage locker. Tenants are responsible for hydro and water. (Some photos are virtually staged)" +"ArchitecturalStyle": "Other" +"AssociationAmenities": array:4 [ 0 => "Gym" 1 => "Concierge" 2 => "Rooftop Deck/Garden" 3 => "Party Room/Meeting Room" ] +"AssociationFeeIncludes": array:1 [ 0 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "Unknown" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Central" +"CloseDate": "2024-12-09" +"ConstructionMaterials": array:2 [ 0 => "Concrete" 1 => "Metal/Steel Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-24T03:25:18.237725+00:00" +"CrossStreet": "Right on the corner of King St. West and Queen St. S" +"DaysOnMarket": 248 +"DirectionFaces": "West" +"ExpirationDate": "2025-02-01" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": "Air Exchanger" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListingContractDate": "2024-11-13" +"LotSizeDimensions": "x" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-12-16T14:23:19Z" +"MlsStatus": "Sold" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-11-15T11:19:10Z" +"OriginalListPrice": 1800.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40678011" +"ParcelNumber": "186250561" +"ParkingFeatures": "Other" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2024-11-20T09:05:04Z" +"PoolFeatures": "None" +"PreviousListPrice": 1800.0 +"PriceChangeTimestamp": "2024-11-23T07:34:07Z" +"PropertyAttachedYN": true +"RentIncludes": array:1 [ 0 => "Common Elements" ] +"Roof": "Flat" +"RoomsTotal": "4" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "QUEEN ST S" +"StreetNumber": "15" +"StreetSuffix": "Street" +"TaxBookNumber": "251802012101854" +"TaxLegalDescription": "UNIT 5, LEVEL 15, WENTWORTH STANDARD CONDOMINIUM PLAN NO. 625 AND ITS APPURTENANT INTEREST SUBJECT TO EASEMENTS AS SET OUT IN SCHEDULE A AS IN WE1639521 CITY OF HAMILTON" +"TransactionBrokerCompensation": "Half Month's Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "1505" +"Zoning": "D2" +"Water": "Municipal" +"RoomsAboveGrade": 4 +"PropertyManagementCompany": "City Towers Property Mana" +"Locker": "Exclusive" +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "None" ] +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "0-499" +"HeatSource": "Gas" +"ContractStatus": "Unavailable" +"ListPriceUnit": "Month" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"PortionPropertyLease": array:1 [ 0 => "Unknown" ] +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10431841')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"LegalApartmentNumber": "Call LBO" +"SoldEntryTimestamp": "2024-12-16T14:23:19Z" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"provider_name": "TRREB" +"LegalStories": "Call LBO" +"PossessionDetails": "Immediate" +"ParkingType1": "Unknown" +"LockerNumber": "173 4th Floor" +"GarageType": "Street" +"BalconyType": "Terrace" +"MediaListingKey": "155565563" +"Exposure": "East" +"PriorMlsStatus": "New" +"BedroomsAboveGrade": 1 +"SquareFootSource": "Builder" +"ApproximateAge": "0-5" +"PaymentMethod": "Direct Withdrawal" +"KitchensTotal": 1 +"Media": array:16 [ 0 => array:26 [ "ResourceRecordKey" => "X10431841" "MediaModificationTimestamp" => "2024-11-20T09:03:38Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10431841/thumbnail-c28303b7d7a13d7cdeea55ccf314da11.webp" "ShortDescription" => "Kitchen featuring appliances with stainless steel " "MediaKey" => "77860948-fd77-4a73-9fb2-f334eac12205" "ImageWidth" => null "ClassName" => "ResidentialCondo" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-20T09:03:38Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X10431841/c28303b7d7a13d7cdeea55ccf314da11.webp" "MediaSize" => 81338 "SourceSystemMediaKey" => "155566081" "SourceSystemID" => "omdreb" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => "Kitchen featuring appliances with stainless steel finishes, backsplash, sink, dark hardwood / wood-style floors, and white cabinetry" "ImageHeight" => null ] 1 => array:26 [ "ResourceRecordKey" => "X10431841" "MediaModificationTimestamp" => "2024-11-20T09:03:38Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X10431841/thumbnail-80dee008cdc76808a0c66f45ebb58667.webp" "ShortDescription" => "Kitchen featuring dark hardwood / wood-style floor" "MediaKey" => "7d7a8e9a-5588-4d34-a988-160d5974afec" …19 ] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] ] +"ID": "151415" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14230 +post_id: "151416" +post_author: 1 +"ListingKey": "X10849982" +"ListingId": "X10849982" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:23:09Z" +"RFModificationTimestamp": "2025-04-27T00:25:55Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 524.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 312, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:27.793946+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:23:09Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-05-26T22:03:13Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591574" +"ParcelNumber": "0" +"ParkingFeatures": "Other" +"PhotosChangeTimestamp": "2024-12-16T14:23:09Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "312" +"Utilities": "Unknown" +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150035100" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:23:09Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10849982')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"RetailArea": 524.0 +"provider_name": "TRREB" +"Media": array:8 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] ] +"ID": "151416" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14234 +post_id: "151417" +post_author: 1 +"ListingKey": "X10850087" +"ListingId": "X10850087" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:22:41Z" +"RFModificationTimestamp": "2025-04-30T09:34:49Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 665.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 311, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:18.761209+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:22:41Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-05-26T22:08:10Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591573" +"ParcelNumber": "0" +"ParkingFeatures": "Other" +"PhotosChangeTimestamp": "2024-12-16T14:22:41Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "311" +"Utilities": "Unknown" +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150035041" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:22:41Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10850087')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"RetailArea": 665.0 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] +"ID": "151417" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14232 +post_id: "151419" +post_author: 1 +"ListingKey": "X10850068" +"ListingId": "X10850068" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:22:01Z" +"RFModificationTimestamp": "2025-04-30T09:40:47Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3672.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 615, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloos University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: caf, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:17.204756+00:00" +"CrossStreet": "Corner of Albert St. and Columbia St." +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "0 x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:22:01Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-25T16:49:11Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591548" +"ParcelNumber": "0" +"PhotosChangeTimestamp": "2024-12-16T14:22:01Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "615" +"Utilities": "Unknown" +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150033282" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:22:01Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10850068')" +"HoldoverDays": 90 +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"ElevatorType": "None" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"RetailArea": 3672.0 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] +"ID": "151419" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14229 +post_id: "151421" +post_author: 1 +"ListingKey": "X10849935" +"ListingId": "X10849935" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:21:31Z" +"RFModificationTimestamp": "2025-04-30T09:40:47Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 6260.0 +"City": "Waterloo" +"PostalCode": "N2L 0G6" +"UnparsedAddress": "365 Albert Street Unit 511, Waterloo, On N2l 0g6" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:27.082929+00:00" +"CrossStreet": "Columbia St W and Albert St" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:21:31Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-26T22:32:05Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591546" +"ParcelNumber": "0" +"PhotosChangeTimestamp": "2024-12-16T14:21:31Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "511" +"Utilities": "Unknown" +"Zoning": "Retail" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150033248" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:21:31Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10849935')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:7 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] ] +"ID": "151421" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14228 +post_id: "151423" +post_author: 1 +"ListingKey": "X10850042" +"ListingId": "X10850042" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:20:57Z" +"RFModificationTimestamp": "2025-04-30T09:48:13Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1380.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 612, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:15:59.943337+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:20:57Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-26T22:14:59Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591540" +"ParcelNumber": "0" +"ParkingFeatures": "Other" +"PhotosChangeTimestamp": "2024-12-16T14:20:57Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% YEAR 1, 2% REMAINING YEARS" +"TransactionType": "For Lease" +"UnitNumber": "612" +"Utilities": "Unknown" +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150032868" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:20:57Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10850042')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] +"ID": "151423" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14235 +post_id: "151424" +post_author: 1 +"ListingKey": "X10849977" +"ListingId": "X10849977" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:20:27Z" +"RFModificationTimestamp": "2025-04-27T00:25:55Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1110.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 613, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloos University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: caf, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:15:58.805619+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:20:27Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-25T16:57:59Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591539" +"ParcelNumber": "0" +"ParkingFeatures": "Other" +"PhotosChangeTimestamp": "2024-12-16T14:20:27Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "613" +"Utilities": "Unknown" +"Zoning": "Commercial" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150032867" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:20:27Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10849977')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] +"ID": "151424" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14236 +post_id: "151425" +post_author: 1 +"ListingKey": "X10848860" +"ListingId": "X10848860" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:19:56Z" +"RFModificationTimestamp": "2025-05-02T14:55:23Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 777.0 +"City": "Waterloo" +"PostalCode": "N2L 0G6" +"UnparsedAddress": "130 Columbia W Street Unit 815, Waterloo, On N2l 0g6" +"Coordinates": array:2 [ 0 => -80.5372258 1 => 43.4787484 ] +"Latitude": 43.4787484 +"Longitude": -80.5372258 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T06:48:05.146603+00:00" +"CrossStreet": "Columbia St W and Albert St" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:19:56Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-25T16:05:11Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591535" +"ParcelNumber": "0" +"PhotosChangeTimestamp": "2024-12-16T14:19:56Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Sewer" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "COLUMBIA" +"StreetNumber": "130" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "815" +"Utilities": "Unknown" +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150032850" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:19:56Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10848860')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:24 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] ] +"ID": "151425" } ] +success: true +page_size: 9 +page_count: 13815 +count: 124329 +after_key: "" } "RF Response Time" => "0.28 seconds" ] "RF Cache Key: 6e69f7841cb47c7a690a5a2dba4b877985272096a3fe828a8c9a6327707bb3b8" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14464 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14252 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10850094" +"ListingId": "X10850094" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:23:40Z" +"RFModificationTimestamp": "2025-04-26T02:57:27Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 665.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 313, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:20.647861+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:23:40Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-05-25T16:34:10Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591575" +"ParcelNumber": "0" +"ParkingFeatures": array:1 [ 0 => "Other" ] +"PhotosChangeTimestamp": "2024-12-16T14:23:40Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "313" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150035152" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:23:40Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10850094')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"RetailArea": 665.0 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14215 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10431841" +"ListingId": "X10431841" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:23:19Z" +"RFModificationTimestamp": "2025-04-27T00:25:55Z" +"ListPrice": 1750.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 429.0 +"City": "Hamilton" +"PostalCode": "L8P 0C6" +"UnparsedAddress": "15 Queen St S S Street Unit 1505, Hamilton, On L8p 0c6" +"Coordinates": array:2 [ 0 => -79.8810928 1 => 43.2535589 ] +"Latitude": 43.2535589 +"Longitude": -79.8810928 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Key Location, amazing views, with public access right at your door steps! Perfect for someone who studies and works at Mc Master or nearby area, this relatively newly built 1-Bedroom 1-Bath condo unit on the 15th floor is located directly on King St. W and Queen St. S. This amazing unit features an open concept layout with a modern kitchen complete with stainless steel appliances (including dishwasher), full bath and in-suite laundry. Lots of natural light, a private large balcony, 9 foot ceilings and lavish finishes. Conveniently located walking distance to Hess Village (shops, restaurants and cafes), minutes to Hamilton Go or West Harbour Go, QEW and 403, Bus Routes to Mc Master University or Columbia International College. Amenities include: lobby concierge, gym, yoga deck, party room and rooftop terrace with BBQs, and storage locker. Tenants are responsible for hydro and water. (Some photos are virtually staged)" +"ArchitecturalStyle": array:1 [ 0 => "Other" ] +"AssociationAmenities": array:4 [ 0 => "Gym" 1 => "Concierge" 2 => "Rooftop Deck/Garden" 3 => "Party Room/Meeting Room" ] +"AssociationFeeIncludes": array:1 [ 0 => "Building Insurance Included" ] +"Basement": array:1 [ 0 => "Unknown" ] +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Central" +"CloseDate": "2024-12-09" +"ConstructionMaterials": array:2 [ 0 => "Concrete" 1 => "Metal/Steel Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-24T03:25:18.237725+00:00" +"CrossStreet": "Right on the corner of King St. West and Queen St. S" +"DaysOnMarket": 248 +"DirectionFaces": "West" +"ExpirationDate": "2025-02-01" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"Inclusions": "Built-in Microwave, Dishwasher, Dryer, Refrigerator, Stove, Washer" +"InteriorFeatures": array:1 [ 0 => "Air Exchanger" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListingContractDate": "2024-11-13" +"LotSizeDimensions": "x" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-12-16T14:23:19Z" +"MlsStatus": "Sold" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-11-15T11:19:10Z" +"OriginalListPrice": 1800.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40678011" +"ParcelNumber": "186250561" +"ParkingFeatures": array:1 [ 0 => "Other" ] +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2024-11-20T09:05:04Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 1800.0 +"PriceChangeTimestamp": "2024-11-23T07:34:07Z" +"PropertyAttachedYN": true +"RentIncludes": array:1 [ 0 => "Common Elements" ] +"Roof": array:1 [ 0 => "Flat" ] +"RoomsTotal": "4" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "QUEEN ST S" +"StreetNumber": "15" +"StreetSuffix": "Street" +"TaxBookNumber": "251802012101854" +"TaxLegalDescription": "UNIT 5, LEVEL 15, WENTWORTH STANDARD CONDOMINIUM PLAN NO. 625 AND ITS APPURTENANT INTEREST SUBJECT TO EASEMENTS AS SET OUT IN SCHEDULE A AS IN WE1639521 CITY OF HAMILTON" +"TransactionBrokerCompensation": "Half Month's Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "1505" +"Zoning": "D2" +"Water": "Municipal" +"RoomsAboveGrade": 4 +"PropertyManagementCompany": "City Towers Property Mana" +"Locker": "Exclusive" +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "None" ] +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "0-499" +"HeatSource": "Gas" +"ContractStatus": "Unavailable" +"ListPriceUnit": "Month" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"PortionPropertyLease": array:1 [ 0 => "Unknown" ] +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10431841')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"LegalApartmentNumber": "Call LBO" +"SoldEntryTimestamp": "2024-12-16T14:23:19Z" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"provider_name": "TRREB" +"LegalStories": "Call LBO" +"PossessionDetails": "Immediate" +"ParkingType1": "Unknown" +"LockerNumber": "173 4th Floor" +"GarageType": "Street" +"BalconyType": "Terrace" +"MediaListingKey": "155565563" +"Exposure": "East" +"PriorMlsStatus": "New" +"BedroomsAboveGrade": 1 +"SquareFootSource": "Builder" +"ApproximateAge": "0-5" +"PaymentMethod": "Direct Withdrawal" +"KitchensTotal": 1 +"Media": array:16 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14226 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10849982" +"ListingId": "X10849982" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:23:09Z" +"RFModificationTimestamp": "2025-04-27T00:25:55Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 524.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 312, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:27.793946+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:23:09Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-05-26T22:03:13Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591574" +"ParcelNumber": "0" +"ParkingFeatures": array:1 [ 0 => "Other" ] +"PhotosChangeTimestamp": "2024-12-16T14:23:09Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "312" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150035100" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:23:09Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10849982')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"RetailArea": 524.0 +"provider_name": "TRREB" +"Media": array:8 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14225 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10850087" +"ListingId": "X10850087" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:22:41Z" +"RFModificationTimestamp": "2025-04-30T09:34:49Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 665.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 311, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:18.761209+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:22:41Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-05-26T22:08:10Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591573" +"ParcelNumber": "0" +"ParkingFeatures": array:1 [ 0 => "Other" ] +"PhotosChangeTimestamp": "2024-12-16T14:22:41Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "311" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150035041" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:22:41Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10850087')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"RetailArea": 665.0 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#11416 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10850068" +"ListingId": "X10850068" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:22:01Z" +"RFModificationTimestamp": "2025-04-30T09:40:47Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3672.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 615, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloos University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: caf, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:17.204756+00:00" +"CrossStreet": "Corner of Albert St. and Columbia St." +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "0 x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:22:01Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-25T16:49:11Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591548" +"ParcelNumber": "0" +"PhotosChangeTimestamp": "2024-12-16T14:22:01Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "615" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150033282" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:22:01Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10850068')" +"HoldoverDays": 90 +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"ElevatorType": "None" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"RetailArea": 3672.0 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14248 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10849935" +"ListingId": "X10849935" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:21:31Z" +"RFModificationTimestamp": "2025-04-30T09:40:47Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 6260.0 +"City": "Waterloo" +"PostalCode": "N2L 0G6" +"UnparsedAddress": "365 Albert Street Unit 511, Waterloo, On N2l 0g6" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:16:27.082929+00:00" +"CrossStreet": "Columbia St W and Albert St" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:21:31Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-26T22:32:05Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591546" +"ParcelNumber": "0" +"PhotosChangeTimestamp": "2024-12-16T14:21:31Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "511" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "Retail" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150033248" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:21:31Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10849935')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:7 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14249 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10850042" +"ListingId": "X10850042" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:20:57Z" +"RFModificationTimestamp": "2025-04-30T09:48:13Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1380.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 612, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:15:59.943337+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:20:57Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-26T22:14:59Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591540" +"ParcelNumber": "0" +"ParkingFeatures": array:1 [ 0 => "Other" ] +"PhotosChangeTimestamp": "2024-12-16T14:20:57Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% YEAR 1, 2% REMAINING YEARS" +"TransactionType": "For Lease" +"UnitNumber": "612" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150032868" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:20:57Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10850042')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14250 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10849977" +"ListingId": "X10849977" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:20:27Z" +"RFModificationTimestamp": "2025-04-27T00:25:55Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1110.0 +"City": "Waterloo" +"PostalCode": "N2L 0G7" +"UnparsedAddress": "365 Albert Street Unit 613, Waterloo, On N2l 0g7" +"Coordinates": array:2 [ 0 => -80.5359138 1 => 43.47911 ] +"Latitude": 43.47911 +"Longitude": -80.5359138 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "PARKING INCLUDED. GREAT TENANT PACKAGES. 600+ RESIDENTIAL UNITS ABOVE. AVAILABLE IMMEDIATELY. Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloos University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: caf, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T05:15:58.805619+00:00" +"CrossStreet": "Corner of University and Albert" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:20:27Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-25T16:57:59Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591539" +"ParcelNumber": "0" +"ParkingFeatures": array:1 [ 0 => "Other" ] +"PhotosChangeTimestamp": "2024-12-16T14:20:27Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Brokerage" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "ALBERT" +"StreetNumber": "365" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "613" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "Commercial" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150032867" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:20:27Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10849977')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14251 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10848860" +"ListingId": "X10848860" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-12-16T14:19:56Z" +"RFModificationTimestamp": "2025-05-02T14:55:23Z" +"ListPrice": 18.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 777.0 +"City": "Waterloo" +"PostalCode": "N2L 0G6" +"UnparsedAddress": "130 Columbia W Street Unit 815, Waterloo, On N2l 0g6" +"Coordinates": array:2 [ 0 => -80.5372258 1 => 43.4787484 ] +"Latitude": 43.4787484 +"Longitude": -80.5372258 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover the HUB, an exceptional development strategically located in the vibrant heart of Waterloo’s University District. This premier property features over 600 upscale residential units complemented by an array of versatile commercial spaces designed to cater to a thriving community. Multiple unit configurations, sizes and uses allowed including: café, child care center, retail store, recreational uses, grocery store, pharmacy, medical clinic, office space, barbershop, restaurant, and convenience store. With ample parking, a dynamic commercial promenade, and a community-centric design, The HUB is within walking distance of Waterloo University. Thrive in this vibrant, accessible location." +"BuildingAreaUnits": "Square Feet" +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Waterloo" +"CreationDate": "2024-11-25T06:48:05.146603+00:00" +"CrossStreet": "Columbia St W and Albert St" +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "GBOS" +"ListingContractDate": "2024-05-24" +"LotSizeDimensions": "x 0" +"MainOfficeKey": "558000" +"MajorChangeTimestamp": "2024-12-16T14:19:56Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-05-25T16:05:11Z" +"OriginalListPrice": 18.0 +"OriginatingSystemID": "ragbos" +"OriginatingSystemKey": "40591535" +"ParcelNumber": "0" +"PhotosChangeTimestamp": "2024-12-16T14:19:56Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "ragbos" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "W" +"StreetName": "COLUMBIA" +"StreetNumber": "130" +"StreetSuffix": "Street" +"TransactionBrokerCompensation": "4% year 1, 2% remaining years" +"TransactionType": "For Lease" +"UnitNumber": "815" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "RMU-40" +"Water": "Municipal" +"PossessionDetails": "Immediate" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "150032850" +"ContractStatus": "Available" +"ListPriceUnit": "Other" +"MediaChangeTimestamp": "2024-12-16T14:19:56Z" +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10848860')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"Media": array:24 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] ] } ] +success: true +page_size: 9 +page_count: 13815 +count: 124329 +after_key: "" } ] ]
