array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29937664 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1554581"
+post_author: 1
+"ListingKey": "29937664"
+"ListingId": "X13475368"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T23:25:12Z"
+"RFModificationTimestamp": "2026-06-22T23:31:26Z"
+"ListPrice": 369900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W5"
+"UnparsedAddress": "607 - 280 LESTER STREET, Waterloo, Ontario N2L3W5"
+"Coordinates": array:2 [
0 => -80.535648
1 => 43.475678
]
+"Latitude": 43.475678
+"Longitude": -80.535648
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "LOCATION LOCATION LOCATION!! Granite countertops, centre Island in Kitchen, open concept to living/dining room. Good size bedroom with sliding door leading to balcony. Ensuite Laundry, Stainless Appliances, walking distance to University of Waterloo and Wilfred Laurier University Close to all other ammenities. Make this affordable condo yours today!! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T19:22:08.570145+00:00"
+"Directions": "Cross Streets: University AV & King Street. ** Directions: University Ave & King St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2147194"
+"ListOfficeKey": "283372"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Other"
]
+"PhotosChangeTimestamp": "2026-06-22T23:19:25Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T23:19:25Z"
+"StreetName": "Lester"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3279.88"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1665569013"
"RoomType" => "Kitchen"
"ListingId" => "X13475368"
"RoomLevel" => "Main level"
"RoomWidth" => 4.38
"ListingKey" => "29937664"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T19:24:07.73Z"
]
1 => array:11 [
"RoomKey" => "1665569014"
"RoomType" => "Living room"
"ListingId" => "X13475368"
"RoomLevel" => "Main level"
"RoomWidth" => 3.08
"ListingKey" => "29937664"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T19:24:07.74Z"
]
2 => array:11 [
"RoomKey" => "1665569015"
"RoomType" => "Bedroom"
"ListingId" => "X13475368"
"RoomLevel" => "Main level"
"RoomWidth" => 4.41
"ListingKey" => "29937664"
"RoomLength" => 2.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T19:24:07.74Z"
]
3 => array:11 [
"RoomKey" => "1665569016"
"RoomType" => "Bathroom"
"ListingId" => "X13475368"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29937664"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T19:24:07.75Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29937664/607-280-lester-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-22T18:51:16.57Z"
+"ListAgentNationalAssociationId": "1398305"
+"ListOfficeNationalAssociationId": "1328417"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29937664_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937664/dd09e4a6a4a402b85215dd47d3861a18.webp"
"MediaSize" => 128251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937664/thumbnail-dd09e4a6a4a402b85215dd47d3861a18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13475368"
"ResourceRecordKey" => "29937664"
"ModificationTimestamp" => "2026-06-22T19:00:07.36Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29937664_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937664/8eeef55de7d56b5e15344c664fa5ca4d.webp"
"MediaSize" => 244040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937664/thumbnail-8eeef55de7d56b5e15344c664fa5ca4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475368"
"ResourceRecordKey" => "29937664"
"ModificationTimestamp" => "2026-06-22T19:00:07.36Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29937664_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937664/c20a8ee78de147ae0ea14fda77096dc6.webp"
"MediaSize" => 14976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937664/thumbnail-c20a8ee78de147ae0ea14fda77096dc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475368"
"ResourceRecordKey" => "29937664"
"ModificationTimestamp" => "2026-06-22T19:00:07.36Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29937664_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937664/80e888deaa366ce4e03e6cfcbd78d15b.webp"
"MediaSize" => 14095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937664/thumbnail-80e888deaa366ce4e03e6cfcbd78d15b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475368"
"ResourceRecordKey" => "29937664"
"ModificationTimestamp" => "2026-06-22T19:00:07.36Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29937664_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937664/17bd943e1fb0779f683716cf642d6e19.webp"
"MediaSize" => 9373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937664/thumbnail-17bd943e1fb0779f683716cf642d6e19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475368"
"ResourceRecordKey" => "29937664"
"ModificationTimestamp" => "2026-06-22T19:00:07.36Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29937664_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937664/c2b6a32b0866a4834898253b6e0ebb38.webp"
"MediaSize" => 14919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937664/thumbnail-c2b6a32b0866a4834898253b6e0ebb38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475368"
"ResourceRecordKey" => "29937664"
"ModificationTimestamp" => "2026-06-22T19:00:07.36Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29937664_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937664/300380f496cfd29b39cb5ed7220a3514.webp"
"MediaSize" => 8946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937664/thumbnail-300380f496cfd29b39cb5ed7220a3514.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475368"
"ResourceRecordKey" => "29937664"
"ModificationTimestamp" => "2026-06-22T19:00:07.36Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29937664_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29937664/8bf924575b0b1192a7dc92134c5473c9.webp"
"MediaSize" => 65496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29937664/thumbnail-8bf924575b0b1192a7dc92134c5473c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475368"
"ResourceRecordKey" => "29937664"
"ModificationTimestamp" => "2026-06-22T19:00:07.36Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29937664')"
+"ID": "1554581"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283372" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24757
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2147194" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24844
+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 '29937664'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25127
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29937664'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25143
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29937664' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.535648 43.475678)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25196
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1555317"
+post_author: 1
+"ListingKey": "29938299"
+"ListingId": "X13475910"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T01:05:18Z"
+"RFModificationTimestamp": "2026-06-23T01:10:03Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E9"
+"UnparsedAddress": "703 - 128 KING STREET N, Waterloo, Ontario N2J0E9"
+"Coordinates": array:2 [
0 => -80.523425
1 => 43.47038
]
+"Latitude": 43.47038
+"Longitude": -80.523425
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to One28 Condos, perfectly situated in one of Waterloo's most desirable and vibrant locations. This bright, modern one-bedroom plus den suite features soaring nine-foot ceilings and an open-concept layout that seamlessly integrates the kitchen, dining, and living areas. The versatile and spacious den serves as an ideal home office or study space. Enjoy unobstructed views and plenty of natural light from the private balcony, accessible directly from the main living area. The prime location offers unparalleled convenience, placing you just minutes from Uptown Waterloo, the University of Waterloo, Wilfrid Laurier University, and the Technology Park. With boutique shops, fine dining, and the ION LRT transit system just steps away, commuting and daily living are effortless. Residents enjoy premium indoor and outdoor building amenities, including 24-hour security surveillance, a fully equipped fitness centre, a yoga studio, a steam room, a dedicated party and study room, a green roof, and an outdoor terrace with BBQ facilities.The unit is equipped with stainless steel appliances (stove, fridge, dishwasher, microwave) and an in-suite washer and dryer. One underground parking space and one storage locker are included. This turn-key home is completely move-in ready. Book your private showing today. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"AssociationFee": "422"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T22:12:17.976834+00:00"
+"Directions": "Cross Streets: King st N. ** Directions: East."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239952"
+"ListOfficeKey": "289134"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T00:55:55Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T00:55:55Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4014.65"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1665683952"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13475910"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29938299"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:32.61Z"
]
1 => array:11 [
"RoomKey" => "1665683953"
"RoomType" => "Den"
"ListingId" => "X13475910"
"RoomLevel" => "Main level"
"RoomWidth" => 1.65
"ListingKey" => "29938299"
"RoomLength" => 2.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:32.61Z"
]
2 => array:11 [
"RoomKey" => "1665683954"
"RoomType" => "Laundry room"
"ListingId" => "X13475910"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29938299"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:32.61Z"
]
3 => array:11 [
"RoomKey" => "1665683955"
"RoomType" => "Kitchen"
"ListingId" => "X13475910"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "29938299"
"RoomLength" => 6.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:32.61Z"
]
4 => array:11 [
"RoomKey" => "1665683956"
"RoomType" => "Living room"
"ListingId" => "X13475910"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "29938299"
"RoomLength" => 6.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:32.61Z"
]
5 => array:11 [
"RoomKey" => "1665683957"
"RoomType" => "Bathroom"
"ListingId" => "X13475910"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29938299"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:32.61Z"
]
6 => array:11 [
"RoomKey" => "1665683958"
"RoomType" => "Dining room"
"ListingId" => "X13475910"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "29938299"
"RoomLength" => 6.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T22:24:32.61Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29938299/703-128-king-street-n-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Onix property management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "MR25"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-22T20:19:37.2Z"
+"ListAgentNationalAssociationId": "1477884"
+"ListOfficeNationalAssociationId": "1374946"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29938299_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/9022faf0310ca2c2dfad372691a62fef.webp"
"MediaSize" => 314931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-9022faf0310ca2c2dfad372691a62fef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:30.97Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29938299_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/8baa4038e88600ae162cc9e039c68d99.webp"
"MediaSize" => 223713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-8baa4038e88600ae162cc9e039c68d99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:35.93Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29938299_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/48c3bb2295f5bd74bb13bd46d4d927f9.webp"
"MediaSize" => 42477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-48c3bb2295f5bd74bb13bd46d4d927f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:35.09Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29938299_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/05a59e258aad17cc4bbd2edc99f72674.webp"
"MediaSize" => 90188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-05a59e258aad17cc4bbd2edc99f72674.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:37.48Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29938299_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/7f14ab93174dd4a31148af1f67125ca7.webp"
"MediaSize" => 106798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-7f14ab93174dd4a31148af1f67125ca7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:35.91Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29938299_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/2c564c7f1086af500f36e266421e184f.webp"
"MediaSize" => 116480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-2c564c7f1086af500f36e266421e184f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:36.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29938299_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/849c4d5a0315d2581e7dbe17f455fe10.webp"
"MediaSize" => 97288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-849c4d5a0315d2581e7dbe17f455fe10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:39.66Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29938299_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/557fff0db25f75424eb7fb0d822575ca.webp"
"MediaSize" => 83559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-557fff0db25f75424eb7fb0d822575ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:36.31Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29938299_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/d37a0282c71da436d878ec3c4741937e.webp"
"MediaSize" => 100631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-d37a0282c71da436d878ec3c4741937e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:39.44Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29938299_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/d70f2b6c4a995a65730733c2b9b2acfe.webp"
"MediaSize" => 103145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-d70f2b6c4a995a65730733c2b9b2acfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:35.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29938299_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/6ce88e64849a6ace9c9afb6109e4d4ac.webp"
"MediaSize" => 120776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-6ce88e64849a6ace9c9afb6109e4d4ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:30.8Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29938299_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/3a53558eed78cfd70c82cb0e7d0e80b4.webp"
"MediaSize" => 97302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-3a53558eed78cfd70c82cb0e7d0e80b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:35.46Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29938299_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/819a90d255d10a43fe015d098c392246.webp"
"MediaSize" => 95582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-819a90d255d10a43fe015d098c392246.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:31.27Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29938299_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/4b6378a736a277569a67d8d947e7b3d6.webp"
"MediaSize" => 93024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-4b6378a736a277569a67d8d947e7b3d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:35.41Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29938299_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/a24b95353307a2d846a991ad10c5a5d5.webp"
"MediaSize" => 92889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-a24b95353307a2d846a991ad10c5a5d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:32.63Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29938299_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/ed23aeeafbe099845b123185737062fb.webp"
"MediaSize" => 272469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-ed23aeeafbe099845b123185737062fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:37.03Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29938299_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938299/1374129437bae7f3c8305c48ffca8a03.webp"
"MediaSize" => 47251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938299/thumbnail-1374129437bae7f3c8305c48ffca8a03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475910"
"ResourceRecordKey" => "29938299"
"ModificationTimestamp" => "2026-06-22T23:17:32.61Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938299')"
+"ID": "1555317"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25192
+post_id: "1555027"
+post_author: 1
+"ListingKey": "29938065"
+"ListingId": "X13475756"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T01:00:04Z"
+"RFModificationTimestamp": "2026-06-23T01:04:28Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "1001 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The unit is located at 160 King St N, Unit 1001. With Great views, close to schools, parks, Uptown Waterloo, and amenities. The primary bedroom features floor-to-ceiling windows and an en-suite. The second bedroom has wrap-around windows and a panoramic view. The kitchen includes quartz countertops and stainless steel appliances. Maintenance fees cover heat, water, an exercise facility, a business/study centre, and a party room. Great investment property, or live in space! If you have a child going to school at UWO, opportunity to have them live and sublet the room to offset costs! (id:62650)"
+"AssociationFee": "451.97"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T21:00:27.391232+00:00"
+"Directions": "Cross Streets: Corner of King & James St. ** Directions: 158 King ST N Tower 2."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1987836"
+"ListOfficeKey": "293241"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-23T00:55:13Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T00:55:13Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3275"
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29938065/1001-158-king-street-n-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-22T19:49:30.84Z"
+"ListAgentNationalAssociationId": "1272066"
+"ListOfficeNationalAssociationId": "1424184"
+"Media": array:12 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29938065_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/5fccaad64e647b4f358db69d6ddf4293.webp"
"MediaSize" => 45883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-5fccaad64e647b4f358db69d6ddf4293.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:20:48.76Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29938065_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/3cccb293afa988ee932fb0423e5d375b.webp"
"MediaSize" => 123404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-3cccb293afa988ee932fb0423e5d375b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:20:47.66Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29938065_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/423b1fc8b46b3c5e3223151e7d70997a.webp"
"MediaSize" => 22515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-423b1fc8b46b3c5e3223151e7d70997a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:21:07.53Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29938065_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/3dbc21c9b11c4f3d904f98206fe63493.webp"
"MediaSize" => 23663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-3dbc21c9b11c4f3d904f98206fe63493.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:20:47.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29938065_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/06a0a83e61cdbfe9093f4fc8821490de.webp"
"MediaSize" => 25397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-06a0a83e61cdbfe9093f4fc8821490de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:21:07.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29938065_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/8186652774aae1d8eae3a9367bb1d534.webp"
"MediaSize" => 20015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-8186652774aae1d8eae3a9367bb1d534.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:20:47.73Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29938065_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/1291f41c76ad8a196db08bc4e1837937.webp"
"MediaSize" => 17967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-1291f41c76ad8a196db08bc4e1837937.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:21:07.56Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29938065_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/bf66b5f07e68a34153b2fc471a155bc4.webp"
"MediaSize" => 40562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-bf66b5f07e68a34153b2fc471a155bc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:20:47.09Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29938065_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/4d453c6b98d006c7aa0fa3481255d4bb.webp"
"MediaSize" => 21626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-4d453c6b98d006c7aa0fa3481255d4bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:21:07.17Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29938065_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/3455ef5d097092731e20f9e6b35b68b0.webp"
"MediaSize" => 34841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-3455ef5d097092731e20f9e6b35b68b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:21:07.89Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29938065_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/41ed400deafdffdea3362d779ffc7bf7.webp"
"MediaSize" => 33468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-41ed400deafdffdea3362d779ffc7bf7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:20:49.62Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29938065_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29938065/1186f60294fb404e1c31f94e049d6ba3.webp"
"MediaSize" => 159582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29938065/thumbnail-1186f60294fb404e1c31f94e049d6ba3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13475756"
"ResourceRecordKey" => "29938065"
"ModificationTimestamp" => "2026-06-22T23:21:08.28Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29938065')"
+"ID": "1555027"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1554239"
+post_author: 1
+"ListingKey": "29936784"
+"ListingId": "40841223"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T17:35:20Z"
+"RFModificationTimestamp": "2026-06-22T18:58:38Z"
+"ListPrice": 2425000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 6105.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6M5"
+"UnparsedAddress": "248 THE LION'S Gate, Waterloo, Ontario N2L6M5"
+"Coordinates": array:2 [
0 => -80.5522568
1 => 43.4660801
]
+"Latitude": 43.4660801
+"Longitude": -80.5522568
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A rare offering in Beechwood, this distinguished executive residence occupies one of the community's most desirable lots on a quiet cul-de-sac, backing onto mature greenery and just steps from the amenities of the Beechwood Park Homes Association. Custom-built by Bob Loebsack and meticulously maintained by its original owners, the home showcases exceptional craftsmanship, custom millwork, and timeless architectural design. The grand foyer opens to a dramatic double-height living room featuring soaring windows, French doors, and a fireplace. The custom kitchen is appointed with antique-white cabinetry, granite countertops, premium appliances, dual islands, and a distinctive breakfast area surrounded by windows. An elegant dining room with coffered ceilings and custom wainscoting provides the perfect setting for formal entertaining. A stunning main-floor library, inspired by traditional English manor homes, features floor-to-ceiling custom cabinetry, a rolling library ladder, coffered ceilings, and a fireplace, creating an exceptional home office. Upstairs, four spacious bedrooms are complemented by three full bathrooms. The luxurious primary suite offers a gas fireplace, walk-in closet, spa-inspired ensuite, and a private loft of approximately 450 sq. ft., ideal as a sitting area, or family lounge. Professionally finished by Country Lane Builders, the lower level features a family room with fireplace, bar area, fitness room, and flexible multi-purpose space. Set on approximately one-third of an acre, the backyard is designed for both recreation and entertaining, featuring a fully equipped outdoor kitchen, gas fireplace, in-ground hot tub, basketball court, and professional landscaping. Beechwood residents enjoy access to top-rated schools, extensive trails, recreation facilities, shopping, and close proximity to everyday amenities. A rare opportunity to own a home of exceptional quality, and enduring craftsmanship in one of Waterloo's premier communities. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Oven - Built-In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T18:58:32.761073+00:00"
+"Directions": "Columbia St W / Westmount Rd N / The Lions Gate"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005428"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T17:10:33Z"
+"PhotosCount": 45
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T17:10:33Z"
+"Stories": "2.0"
+"StreetName": "THE LION'S"
+"StreetNumber": "248"
+"StreetSuffix": "Gate"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "13749.7"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/248_the_lions_gate_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:26 [
0 => array:11 [
"RoomKey" => "1665474076"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841223"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.12Z"
]
1 => array:11 [
"RoomKey" => "1665474077"
"RoomType" => "Utility room"
"ListingId" => "40841223"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.12Z"
]
2 => array:11 [
"RoomKey" => "1665474078"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841223"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.12Z"
]
3 => array:11 [
"RoomKey" => "1665474079"
"RoomType" => "Storage"
"ListingId" => "40841223"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 5'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.12Z"
]
4 => array:11 [
"RoomKey" => "1665474080"
"RoomType" => "Bedroom"
"ListingId" => "40841223"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "18'8'' x 20'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.12Z"
]
5 => array:11 [
"RoomKey" => "1665474081"
"RoomType" => "Other"
"ListingId" => "40841223"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.12Z"
]
6 => array:11 [
"RoomKey" => "1665474082"
"RoomType" => "Family room"
"ListingId" => "40841223"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 28'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.12Z"
]
7 => array:11 [
"RoomKey" => "1665474083"
"RoomType" => "Cold room"
"ListingId" => "40841223"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.13Z"
]
8 => array:11 [
"RoomKey" => "1665474084"
"RoomType" => "Bedroom"
"ListingId" => "40841223"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.13Z"
]
9 => array:11 [
"RoomKey" => "1665474085"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841223"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.13Z"
]
10 => array:11 [
"RoomKey" => "1665474086"
"RoomType" => "Bedroom"
"ListingId" => "40841223"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.13Z"
]
11 => array:11 [
"RoomKey" => "1665474087"
"RoomType" => "Bedroom"
"ListingId" => "40841223"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.13Z"
]
12 => array:11 [
"RoomKey" => "1665474088"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841223"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.13Z"
]
13 => array:11 [
"RoomKey" => "1665474089"
"RoomType" => "Bedroom"
"ListingId" => "40841223"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
14 => array:11 [
"RoomKey" => "1665474090"
"RoomType" => "Full bathroom"
"ListingId" => "40841223"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 19'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
15 => array:11 [
"RoomKey" => "1665474091"
"RoomType" => "Sitting room"
"ListingId" => "40841223"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "17'9'' x 25'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
16 => array:11 [
"RoomKey" => "1665474092"
"RoomType" => "Other"
"ListingId" => "40841223"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
17 => array:11 [
"RoomKey" => "1665474093"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841223"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "23'7'' x 19'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
18 => array:11 [
"RoomKey" => "1665474094"
"RoomType" => "Mud room"
"ListingId" => "40841223"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 4'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
19 => array:11 [
"RoomKey" => "1665474095"
"RoomType" => "Laundry room"
"ListingId" => "40841223"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
20 => array:11 [
"RoomKey" => "1665474096"
"RoomType" => "Dining room"
"ListingId" => "40841223"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
21 => array:11 [
"RoomKey" => "1665474097"
"RoomType" => "Breakfast"
"ListingId" => "40841223"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
22 => array:11 [
"RoomKey" => "1665474098"
"RoomType" => "Kitchen"
"ListingId" => "40841223"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "23'3'' x 16'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.14Z"
]
23 => array:11 [
"RoomKey" => "1665474099"
"RoomType" => "Living room"
"ListingId" => "40841223"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "30'3'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.15Z"
]
24 => array:11 [
"RoomKey" => "1665474100"
"RoomType" => "Office"
"ListingId" => "40841223"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.15Z"
]
25 => array:11 [
"RoomKey" => "1665474101"
"RoomType" => "Foyer"
"ListingId" => "40841223"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936784"
"RoomLength" => null
"RoomDimensions" => "20'7'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T17:10:33.15Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29936784/248-the-lions-gate-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2190750"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 4185
+"BelowGradeFinishedArea": 1920
+"OriginalEntryTimestamp": "2026-06-22T17:10:33.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1287777"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1439796"
+"CoListOfficeNationalAssociationId": "1004370"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29936784_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/0d52ac1d67167ff7ff06b11a62c683ef.webp"
"MediaSize" => 112704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-0d52ac1d67167ff7ff06b11a62c683ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29936784_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/3148309ee130d98848efdb5c933ca7ee.webp"
"MediaSize" => 131246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-3148309ee130d98848efdb5c933ca7ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29936784_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/30b2b0aab29197eaf40fc77174221b7e.webp"
"MediaSize" => 141000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-30b2b0aab29197eaf40fc77174221b7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29936784_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/792d272ed9e310281e2b5452d314627a.webp"
"MediaSize" => 69767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-792d272ed9e310281e2b5452d314627a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29936784_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/47f0a3e1876ff104c0187394f1c288cf.webp"
"MediaSize" => 107388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-47f0a3e1876ff104c0187394f1c288cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29936784_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/2203ada199e00f620286ec38a5e836e8.webp"
"MediaSize" => 118871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-2203ada199e00f620286ec38a5e836e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29936784_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/6e5672169126079c16a449adab1aeaaf.webp"
"MediaSize" => 102210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-6e5672169126079c16a449adab1aeaaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29936784_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/c6c5ce5bc75733200efd6986d51fccad.webp"
"MediaSize" => 103642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-c6c5ce5bc75733200efd6986d51fccad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29936784_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/469021a8d6065023acfb5f9b2772c8d5.webp"
"MediaSize" => 105387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-469021a8d6065023acfb5f9b2772c8d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29936784_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/1ee6584a8500b9ccd86a46e924162316.webp"
"MediaSize" => 92193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-1ee6584a8500b9ccd86a46e924162316.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29936784_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/a6adf7fcd1d09c8cff67047b055c2c32.webp"
"MediaSize" => 105885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-a6adf7fcd1d09c8cff67047b055c2c32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29936784_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/e7096974a03839481baf148467f7c6e1.webp"
"MediaSize" => 108934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-e7096974a03839481baf148467f7c6e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29936784_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/cf3b4b9dba1d2d0e630991ecae38feba.webp"
"MediaSize" => 152950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-cf3b4b9dba1d2d0e630991ecae38feba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29936784_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/e812b239456682383939047355755dcc.webp"
"MediaSize" => 136782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-e812b239456682383939047355755dcc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29936784_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/94dcc2dea2458085b987c34ee485a175.webp"
"MediaSize" => 69305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-94dcc2dea2458085b987c34ee485a175.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29936784_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/b4068023609db365d31bc3288bee3540.webp"
"MediaSize" => 89857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-b4068023609db365d31bc3288bee3540.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29936784_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936784/b8d703b6fb38002ae7bff7c87bef821b.webp"
"MediaSize" => 67697
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936784/thumbnail-b8d703b6fb38002ae7bff7c87bef821b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841223"
"ResourceRecordKey" => "29936784"
"ModificationTimestamp" => "2026-06-22T17:10:33.09Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29936784_4890_18"
…11
]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936784')"
+"ID": "1554239"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25193
+post_id: "1553959"
+post_author: 1
+"ListingKey": "29936704"
+"ListingId": "X13474352"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T23:20:05Z"
+"RFModificationTimestamp": "2026-06-22T23:24:28Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2J3"
+"UnparsedAddress": "9 - 12 BRIDGEPORT ROAD E, Waterloo, Ontario N2J2J3"
+"Coordinates": array:2 [
0 => -80.522235
1 => 43.467941
]
+"Latitude": 43.467941
+"Longitude": -80.522235
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "FULLY VACANT!! Exceptional investment opportunity with strong rental appeal. This unique property offers a spacious multi-level layout featuring 4 bedrooms, a bathroom on each level, and a shared kitchen configuration ideal for student housing or multi-tenant occupancy. Freshly painted throughout and enhanced with new waterproof vinyl flooring on the upper level, the unit combines modern updates with character-rich design. Originally a 1900s industrial building converted to residential use in 2002, the property showcases soaring ceilings, exposed beams, exposed brick, and stone accents that create a distinctive urban loft aesthetic. Residents enjoy access to secured bike storage, a media lounge/hangout area, and onsite laundry facilities in the building. Ideally situated within walking distance to University of Waterloo, Wilfred Laurier University, public transit including the ION LRT, grocery stores, restaurants, and everyday amenities, with an impressive Walk Score of 94. A proven income-generating property with a strong rental history and consistently high occupancy. Book your private showing today! (id:62650)"
+"AssociationFee": "571.31"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-22T17:35:42.551827+00:00"
+"Directions": "Bridgeport Rd E And King St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036658"
+"ListOfficeKey": "293284"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T23:13:05Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T23:13:05Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Bridgeport"
+"StreetNumber": "12"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3099.74"
+"VirtualTourURLUnbranded": "https://youtu.be/NT8oDHOsHqU"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29936704/9-12-bridgeport-road-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2145943"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"CoListOfficeKey": "293284"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "C8"
+"BedroomsAboveGrade": 4
+"OriginalEntryTimestamp": "2026-06-22T16:57:34.02Z"
+"ListAgentNationalAssociationId": "1313160"
+"ListOfficeNationalAssociationId": "1469475"
+"CoListAgentNationalAssociationId": "1397346"
+"CoListOfficeNationalAssociationId": "1469475"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936704')"
+"ID": "1553959"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25191
+post_id: "1553480"
+post_author: 1
+"ListingKey": "29935363"
+"ListingId": "X13473054"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T00:00:18Z"
+"RFModificationTimestamp": "2026-06-23T00:05:32Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0G3"
+"UnparsedAddress": "112 - 253 ALBERT STREET, Waterloo, Ontario N2L0G3"
+"Coordinates": array:2 [
0 => -80.533259
1 => 43.47544
]
+"Latitude": 43.47544
+"Longitude": -80.533259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Excellent Opportunity in the Heart of Waterloo! Welcome to this spacious and well-maintained 2-bedroom, 2 full washroom condo offering approximately 950 sq. ft. of modern open-concept living. Ideally located in one of Waterloo's most sought-after neighbourhoods, this unit is perfect for investors, students, young professionals, or parents looking to secure housing near the universities. Situated on the main floor, enjoy the convenience of no stairs or elevators while benefiting from two separate entrances to the unit. The bright and functional layout features high ceilings, spacious principal rooms, and a well-designed open-concept kitchen overlooking the living and dining area. Step outside to a large private balcony/terrace facing Albert Street, providing an excellent space to relax and enjoy the outdoors. This well-cared-for unit includes 1 owned parking space and offers comfortable, low-maintenance living in a highly desirable location. Just steps to the University of Waterloo, Wilfrid Laurier University, shopping, restaurants, public transit, and all major amenities. The strong rental demand and exceptional location make this an outstanding investment opportunity with excellent long-term potential. Well priced for immediate action and offering a flexible closing date. Whether you're looking for a personal residence or an income-producing property, this condo checks all the boxes.Don't miss this fantastic opportunity to own in Waterloo's thriving University District! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "804.21"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T17:20:22.289001+00:00"
+"Directions": "University/Albert"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1406450"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T23:07:06Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T23:49:28Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4841.04"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29935363/112-253-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-22T13:49:44.95Z"
+"ListAgentNationalAssociationId": "1117373"
+"ListOfficeNationalAssociationId": "1375388"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935363')"
+"ID": "1553480"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1553031"
+post_author: 1
+"ListingKey": "29934788"
+"ListingId": "40841744"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T18:00:15Z"
+"RFModificationTimestamp": "2026-06-22T18:07:08Z"
+"ListPrice": 369900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 549.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W5"
+"UnparsedAddress": "280 LESTER Street, Waterloo, Ontario N2L3W5"
+"Coordinates": array:2 [
0 => -80.5362181
1 => 43.4762835
]
+"Latitude": 43.4762835
+"Longitude": -80.5362181
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "LOCATION LOCATION LOCATION!! Granite Countertops, centre Island in kitchen, Open concept to Living/Dining room. Good sized bedroom with sliding door leading to balcony. ensuite Laundry, stainless steel appliances, walking distance to University of Waterloo and Wilfred Laurier Uiversity. Close to all amenities as well. Make this sought after location your home today! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "398.03"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
5 => "Parking"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T03:32:44.540860+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533906"
+"ListOfficeKey": "283362"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-22T01:09:51Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T17:51:29Z"
+"Stories": "1.0"
+"StreetName": "LESTER"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3279.88"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29934788/280-lester-street-unit-607-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 549
+"OriginalEntryTimestamp": "2026-06-22T01:09:50.95Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1143482"
+"ListOfficeNationalAssociationId": "1328262"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29934788')"
+"ID": "1553031"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1551552"
+post_author: 1
+"ListingKey": "29932856"
+"ListingId": "X13470720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T14:25:13Z"
+"RFModificationTimestamp": "2026-06-20T16:53:32Z"
+"ListPrice": 498999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W6"
+"UnparsedAddress": "206 - 251 LESTER STREET, Waterloo, Ontario N2L3W6"
+"Coordinates": array:2 [
0 => -80.534834
1 => 43.473527
]
+"Latitude": 43.473527
+"Longitude": -80.534834
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Incredible Turnkey Investment In The Heart Of Waterloo's University District! This Purpose-Built 5-Bedroom, 2-Bathroom Condo At 253 Lester St Has The Potential To Generate Positive Monthly Cash Flow. Just Steps To Wilfrid Laurier University And The University Of Waterloo, This High-Demand Location Ensures Consistent Tenancy. Features Include A Spacious Open-Concept Living Area, Two Full Baths, Included Furniture, And Professional Property Management Options For A Completely Hands-Off Experience. Condo Fees Include Heat And Water, And The Building Offers Parking, Shared Laundry, Elevator Access, And Proximity To Transit, Shops, And Amenities. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
]
+"AssociationFee": "790.49"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T16:53:26.043009+00:00"
+"Directions": "University Ave W / Lester St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2045015"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T14:17:13Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T14:17:13Z"
+"StreetName": "Lester"
+"StreetNumber": "251"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4059"
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932856/206-251-lester-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2022731"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"CoListOfficeKey": "278195"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 5
+"OriginalEntryTimestamp": "2026-06-20T14:17:13.57Z"
+"ListAgentNationalAssociationId": "1320619"
+"ListOfficeNationalAssociationId": "1268183"
+"CoListAgentNationalAssociationId": "1302336"
+"CoListOfficeNationalAssociationId": "1290805"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932856')"
+"ID": "1551552"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25194
+post_id: "1551452"
+post_author: 1
+"ListingKey": "29932781"
+"ListingId": "40837095"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T13:20:16Z"
+"RFModificationTimestamp": "2026-06-20T14:55:03Z"
+"ListPrice": 350000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1223.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5G6"
+"UnparsedAddress": "65 WESTMOUNT Road N Unit# 910, Waterloo, Ontario N2L5G6"
+"Coordinates": array:2 [
0 => -80.5393732
1 => 43.4615946
]
+"Latitude": 43.4615946
+"Longitude": -80.5393732
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Perched on the 9th floor with bright south-east-facing exposure, Unit 910 at Westmount Towers II offers space, light, and one of the best vantage points in the building. This is one of Waterloo’s most convenient addresses, within walking distance of Uptown Waterloo, Waterloo Park, both universities, transit, shopping, and everyday amenities. Inside, a functional 2-bedroom, 2-bathroom layout spans roughly 1,223 square feet, with hardwood floors through the living and kitchen areas, maple cabinetry, a separate dining space, a primary bedroom with a private 2-piece ensuite, a second bedroom, a main bathroom, and an enclosed balcony that adds comfortable year-round living space. The unit includes one owned underground parking space, an exclusive storage locker, and access to the building’s common laundry. Residents enjoy a full set of amenities, including an elevator, exercise room, games room, party room, workshop, bike storage, and visitor parking. The monthly fee is simple and predictable, covering property taxes along with heat, hydro, water, parking, insurance, building maintenance, management, snow removal, and more. Prefer something turnkey? A number of the furnishings can stay with the unit. Best of all, Westmount Towers II is currently in the process of converting to a standard condominium, a transition expected to open the door to conventional financing and added long-term value. A rare opportunity to own a bright, top-floor home in one of Waterloo’s most sought-after locations, with real upside ahead as the conversion progresses. (id:62783)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Garage door opener"
4 => "Microwave Built-in"
]
+"AssociationFee": "1140"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:9 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Electricity"
5 => "Water"
6 => "Insurance"
7 => "Other, See Remarks"
8 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-20T14:55:01.817463+00:00"
+"Directions": "University to Westmount"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2246706"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Laundry- Coin operated"
3 => "No Pet Home"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-20T13:10:29Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T13:10:29Z"
+"Stories": "9.0"
+"StreetDirSuffix": "North"
+"StreetName": "WESTMOUNT"
+"StreetNumber": "65"
+"StreetSuffix": "Road"
+"SubdivisionName": "417 - Beechwood/University"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_910_65_westmount_rd_n_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29932781/65-westmount-road-n-unit-910-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1563569"
+"CoListAgentKey2": "1600603"
+"CoListOfficeKey": "290620"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"CoListOfficeKey2": "76826"
+"ZoningDescription": "RMU-60"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1223
+"OriginalEntryTimestamp": "2026-06-20T13:10:29.24Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1485557"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1109914"
+"CoListAgentNationalAssociationId2": "1145016"
+"CoListOfficeNationalAssociationId": "1389824"
+"CoListOfficeNationalAssociationId2": "1004387"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932781')"
+"ID": "1551452"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25195
+post_id: "1551131"
+post_author: 1
+"ListingKey": "29932555"
+"ListingId": "X13470380"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T04:25:12Z"
+"RFModificationTimestamp": "2026-06-20T05:34:29Z"
+"ListPrice": 760000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3H6"
+"UnparsedAddress": "806 - 8 HICKORY STREET W, Waterloo, Ontario N2L3H6"
+"Coordinates": array:2 [
0 => -80.5261878
1 => 43.4782103
]
+"Latitude": 43.4782103
+"Longitude": -80.5261878
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Great investment opportunity in huge 5 bedrooms and 5 bathrooms luxury suite in high rise condominium building. 8 Hickory Street West is a high-end student condo building located within walking distance to the University of Waterloo, Wilfrid Laurier University, restaurants, shopping &situated right on the LRT route. Unit 806 has a total of 2077 SQFT living space and one underground parking space. It features 5 large bedrooms, 5 full bathrooms, 9 ft ceilings, open concept layout, in-suit laundry, modern kitchen with stainless steel appliances, granite countertops, and central island, and overlooks spacious living room. Amazing unobstructed city view through the balcony. Furnished. Internet is included. (id:62783)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"AssociationFee": "924.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T05:34:17.704632+00:00"
+"Directions": "Cross Streets: King Street to Hickory. ** Directions: Hickory St W/King St N."
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1959006"
+"ListOfficeKey": "291350"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-20T04:17:51Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T04:17:51Z"
+"StreetDirSuffix": "West"
+"StreetName": "HICKORY"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7604"
+"View": "City view"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932555/806-8-hickory-street-w-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-20T04:17:51.62Z"
+"ListAgentNationalAssociationId": "1249681"
+"ListOfficeNationalAssociationId": "1396878"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932555')"
+"ID": "1551131"
}
]
+success: true
+page_size: 9
+page_count: 44
+count: 391
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]