array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29905623 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23380
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23382
+post_id: "1531875"
+post_author: 1
+"ListingKey": "29905623"
+"ListingId": "40838864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T20:00:14Z"
+"RFModificationTimestamp": "2026-06-18T20:10:42Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1086.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H3Y6"
+"UnparsedAddress": "427 W DUKE Street W, Kitchener, Ontario N2H3Y6"
+"Coordinates": array:2 [
0 => -80.4991474
1 => 43.458489
]
+"Latitude": 43.458489
+"Longitude": -80.4991474
+"YearBuilt": 1902
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Attention Investors, Flippers & Families! Rare Midtown Corner Lot with massive potential available for the first time in 40+ years! This 1902 detached home sits on a premium 40’ x 119’ corner lot in a rapidly appreciating Midtown pocket near DTK, transit, and the Spur Line Trail. Surrounded by $1M+ redevelopments, this property offers ultimate flexibility for a high-end family renovation or a high-yield investment project. The existing 2-bed, 1.5-bath character home features great bones and excellent holding value. Major mechanical updates offer immediate peace of mind, including a furnace replaced in 2025 and a newer main roof from 2020. Move in, rent out, or renovate while finalizing your permits. The high density RES-5 zoning and dual street exposure are perfectly primed for intensification under Kitchener’s Growing Together framework. Capitalize on the corner configuration for separate unit entrances and streamlined parking logistics to build cluster townhouses, a multi-unit conversion, or an accessory dwelling. Best of all, leverage the 10 unit threshold for an expedited Zoning Certificate process, bypassing complex site plans. Whether you want to restore a piece of history or build a multi-unit legacy project, this prime piece of Midtown’s future is a must-see! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Satellite Dish"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-15T21:51:23.154049+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1988200"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Corner Site"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T19:51:30Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:51:30Z"
+"Stories": "2.0"
+"StreetDirPrefix": "West"
+"StreetDirSuffix": "West"
+"StreetName": "DUKE"
+"StreetNumber": "427"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "3488"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1662375200"
"RoomType" => "Mud room"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T19:51:30.95Z"
]
1 => array:11 [
"RoomKey" => "1662375201"
"RoomType" => "Office"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T19:51:30.95Z"
]
2 => array:11 [
"RoomKey" => "1662375202"
"RoomType" => "Dining room"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T19:51:30.95Z"
]
3 => array:11 [
"RoomKey" => "1662375203"
"RoomType" => "Living room"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T19:51:30.95Z"
]
4 => array:11 [
"RoomKey" => "1662375204"
"RoomType" => "Kitchen"
"ListingId" => "40838864"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T19:51:30.95Z"
]
5 => array:11 [
"RoomKey" => "1662375205"
"RoomType" => "Bedroom"
"ListingId" => "40838864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T19:51:30.95Z"
]
6 => array:11 [
"RoomKey" => "1662375206"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T19:51:30.95Z"
]
7 => array:11 [
"RoomKey" => "1662375207"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838864"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T19:51:30.96Z"
]
8 => array:11 [
"RoomKey" => "1662375208"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838864"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29905623"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T19:51:30.96Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905623/427-w-duke-street-w-kitchener"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-5/ Light Industrial"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1086
+"OriginalEntryTimestamp": "2026-06-15T18:50:32.09Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1272354"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:39 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905623_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/3755f498f36c429a3581ded2bc7fb1ac.webp"
"MediaSize" => 125191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-3755f498f36c429a3581ded2bc7fb1ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905623_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/7cf926968d3edee281f1fd02e6ad575b.webp"
"MediaSize" => 148839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-7cf926968d3edee281f1fd02e6ad575b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.62Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905623_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/fbd7e68d2364a215889144bb39681227.webp"
"MediaSize" => 138690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-fbd7e68d2364a215889144bb39681227.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.61Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905623_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/5ff787643ad9913bd0a67541ef94b985.webp"
"MediaSize" => 143181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-5ff787643ad9913bd0a67541ef94b985.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.59Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905623_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/0ede187f1da6c1d0f0eb1f6a9a22589c.webp"
"MediaSize" => 114884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-0ede187f1da6c1d0f0eb1f6a9a22589c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905623_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/7e504ca892250bad931aa8a771198e47.webp"
"MediaSize" => 71961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-7e504ca892250bad931aa8a771198e47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.25Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29905623_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/61cd0384d9e2681645100b0b4c271e10.webp"
"MediaSize" => 90352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-61cd0384d9e2681645100b0b4c271e10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.59Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29905623_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/e2a3935068086d758c0f5854fd1a071c.webp"
"MediaSize" => 70251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-e2a3935068086d758c0f5854fd1a071c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.62Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29905623_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/4ea43b012e287128b4b8574ff720c1ef.webp"
"MediaSize" => 79310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-4ea43b012e287128b4b8574ff720c1ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.45Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29905623_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/925a2e8d012a8a3907c3d95b0428dc56.webp"
"MediaSize" => 117716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-925a2e8d012a8a3907c3d95b0428dc56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.59Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29905623_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/d17d67bcba5ab4a9b7f8e067b5983b54.webp"
"MediaSize" => 86820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-d17d67bcba5ab4a9b7f8e067b5983b54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.02Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29905623_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/962553a93c61dfcda243616367cf340f.webp"
"MediaSize" => 79206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-962553a93c61dfcda243616367cf340f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.59Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29905623_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/a90bf5558f020373cd16c7512554253d.webp"
"MediaSize" => 91031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-a90bf5558f020373cd16c7512554253d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.6Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29905623_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/038e491f081db4b162c0a4183c363f37.webp"
"MediaSize" => 48748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-038e491f081db4b162c0a4183c363f37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.99Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29905623_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/6d05d82be737a40722486a1ab3447691.webp"
"MediaSize" => 119452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-6d05d82be737a40722486a1ab3447691.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.66Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29905623_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/fe08f84c9d1a1ee7bb359fda71a252d3.webp"
"MediaSize" => 56312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-fe08f84c9d1a1ee7bb359fda71a252d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.59Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29905623_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/c197c142d71801280559abcae3f63b05.webp"
"MediaSize" => 98635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-c197c142d71801280559abcae3f63b05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.99Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29905623_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/ca73cef15385fea7509b47e61331c947.webp"
"MediaSize" => 81652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-ca73cef15385fea7509b47e61331c947.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.99Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29905623_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/91be96a4552e4b9aa8717d9e0feea039.webp"
"MediaSize" => 62401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-91be96a4552e4b9aa8717d9e0feea039.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.61Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29905623_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/818e64a556b3ac5f93982d64b8f69868.webp"
"MediaSize" => 77022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-818e64a556b3ac5f93982d64b8f69868.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.04Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29905623_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/6ff441240a9dc47d56a8c7ff079085d3.webp"
"MediaSize" => 113648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-6ff441240a9dc47d56a8c7ff079085d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.99Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29905623_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/a711678a4cbfc066d349881421e9ee11.webp"
"MediaSize" => 111538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-a711678a4cbfc066d349881421e9ee11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.99Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29905623_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/c9634a5b86288321b28bbb37783814e4.webp"
"MediaSize" => 117032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-c9634a5b86288321b28bbb37783814e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.77Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29905623_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/363943cc0a8c0609bc4bc9a84da6047f.webp"
"MediaSize" => 86709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-363943cc0a8c0609bc4bc9a84da6047f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.59Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29905623_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/2c98b2a2444cfbc86caaa3cc91939539.webp"
"MediaSize" => 133294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-2c98b2a2444cfbc86caaa3cc91939539.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.35Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29905623_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/0295237034ce0a3bb324554e6f6ad863.webp"
"MediaSize" => 128659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-0295237034ce0a3bb324554e6f6ad863.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.99Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29905623_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/a3f7b85d1ee66c965ec8907901dbf64e.webp"
"MediaSize" => 127548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-a3f7b85d1ee66c965ec8907901dbf64e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.02Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29905623_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/4abac5cef523f72e213f958d9a2854e6.webp"
"MediaSize" => 120230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-4abac5cef523f72e213f958d9a2854e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.35Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29905623_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/fce9c159752072db346eaaea45a31819.webp"
"MediaSize" => 132563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-fce9c159752072db346eaaea45a31819.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.77Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29905623_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/4d3b480ae70fb6031e3d816d826a4e5b.webp"
"MediaSize" => 131040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-4d3b480ae70fb6031e3d816d826a4e5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.61Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29905623_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/8ce349aae74c846b3ce6d07fcda296bb.webp"
"MediaSize" => 159896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-8ce349aae74c846b3ce6d07fcda296bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.59Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29905623_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/f9c432e5368f86764c7ed9e354905765.webp"
"MediaSize" => 158997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-f9c432e5368f86764c7ed9e354905765.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:19.77Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29905623_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/312054ff79f289f385ed012ea12bbd34.webp"
"MediaSize" => 136008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-312054ff79f289f385ed012ea12bbd34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.64Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29905623_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/b4c1d54a39e9cda9592ebba7dd969361.webp"
"MediaSize" => 147154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-b4c1d54a39e9cda9592ebba7dd969361.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.57Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29905623_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/12890f4482578245ddcf7e78c7b3a844.webp"
"MediaSize" => 140061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-12890f4482578245ddcf7e78c7b3a844.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.54Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29905623_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/6b7dbf57dec088612e03a932a65f0f41.webp"
"MediaSize" => 145873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-6b7dbf57dec088612e03a932a65f0f41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.81Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29905623_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/870609995e6e4361425a2b5f3b5f286f.webp"
"MediaSize" => 157634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-870609995e6e4361425a2b5f3b5f286f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-15T18:51:20.95Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29905623_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/6e23b392a69c7545229bd36b7a460e4e.webp"
"MediaSize" => 199208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-6e23b392a69c7545229bd36b7a460e4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-18T19:51:21.89Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29905623_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905623/0e112b7194acda7ebac17bc2d7560d93.webp"
"MediaSize" => 38767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905623/thumbnail-0e112b7194acda7ebac17bc2d7560d93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838864"
"ResourceRecordKey" => "29905623"
"ModificationTimestamp" => "2026-06-18T19:51:19.94Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905623')"
+"ID": "1531875"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24764
+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 1988200" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24769
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29905623'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25226
+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 '29905623'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25242
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29905623' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4991474 43.458489)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25302
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "1546119"
+post_author: 1
+"ListingKey": "29925586"
+"ListingId": "40840968"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:20:17Z"
+"RFModificationTimestamp": "2026-06-19T01:19:23Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2000.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G1M1"
+"UnparsedAddress": "50 THERESA Street, Kitchener, Ontario N2G1M1"
+"Coordinates": array:2 [
0 => -80.5010189
1 => 43.4483228
]
+"Latitude": 43.4483228
+"Longitude": -80.5010189
+"YearBuilt": 1903
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Attention investors, contractors, flippers, and savvy first-time buyers! This spacious, multi-level home offers a rare layout brimming with potential to manufacture your own equity in any market. The unique, highly versatile layout features five total bedrooms and three bathrooms spread across four distinct levels: a 1-bed, 1-bath (with shower) basement; a 1-bed, 1-bath (with tub) main floor; a second floor hosting 3 additional bedrooms and another full bath; plus a fully finished bonus attic space above perfect for an office or playroom. Situated in a highly desirable, great location close to local amenities, this property is the ultimate canvas for a high-yield flip, a multi-generational setup, or a rental investment. Bring your vision and toolbelt to unlock massive upside—opportunities with this much space and flexibility don't last long, so book your showing today! (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T01:19:16.151600+00:00"
+"Directions": "Victoria St. to Park St. which turns into Jubilee Dr. to Theresa St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2128817"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T22:10:35Z"
+"PhotosCount": 8
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T22:10:35Z"
+"Stories": "2.5"
+"StreetName": "THERESA"
+"StreetNumber": "50"
+"StreetSuffix": "Street"
+"SubdivisionName": "313 - Downtown Kitchener/W. Ward"
+"TaxAnnualAmount": "4477"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1662486299"
"RoomType" => "Kitchen"
"ListingId" => "40840968"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.82Z"
]
1 => array:11 [
"RoomKey" => "1662486300"
"RoomType" => "Kitchen"
"ListingId" => "40840968"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.83Z"
]
2 => array:11 [
"RoomKey" => "1662486301"
"RoomType" => "Attic"
"ListingId" => "40840968"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.83Z"
]
3 => array:11 [
"RoomKey" => "1662486302"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840968"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.83Z"
]
4 => array:11 [
"RoomKey" => "1662486303"
"RoomType" => "Bedroom"
"ListingId" => "40840968"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.83Z"
]
5 => array:11 [
"RoomKey" => "1662486304"
"RoomType" => "Bedroom"
"ListingId" => "40840968"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.83Z"
]
6 => array:11 [
"RoomKey" => "1662486305"
"RoomType" => "Bedroom"
"ListingId" => "40840968"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.83Z"
]
7 => array:11 [
"RoomKey" => "1662486306"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840968"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.83Z"
]
8 => array:11 [
"RoomKey" => "1662486307"
"RoomType" => "Bedroom"
"ListingId" => "40840968"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.83Z"
]
9 => array:11 [
"RoomKey" => "1662486308"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840968"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.84Z"
]
10 => array:11 [
"RoomKey" => "1662486309"
"RoomType" => "Bedroom"
"ListingId" => "40840968"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29925586"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:10:35.84Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29925586/50-theresa-street-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 1500
+"BelowGradeFinishedArea": 500
+"OriginalEntryTimestamp": "2026-06-18T22:10:35.72Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1381911"
+"ListOfficeNationalAssociationId": "1349002"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29925586_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925586/178e8c5183fbd42c1a4ce3239753e29a.webp"
"MediaSize" => 107098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925586/thumbnail-178e8c5183fbd42c1a4ce3239753e29a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story traditional exterior featuring yellow brick and horizontal siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840968"
"ResourceRecordKey" => "29925586"
"ModificationTimestamp" => "2026-06-18T22:10:35.73Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29925586_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925586/531b63cf38aa4f0b23a412edf01fa928.webp"
"MediaSize" => 94907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925586/thumbnail-531b63cf38aa4f0b23a412edf01fa928.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a double window, built-in cabinetry, and a countertop with an integrated sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840968"
"ResourceRecordKey" => "29925586"
"ModificationTimestamp" => "2026-06-18T22:10:35.73Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29925586_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925586/0c2118519a688bc28d3533199fb05fed.webp"
"MediaSize" => 95837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925586/thumbnail-0c2118519a688bc28d3533199fb05fed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living space featuring wood-finish flooring, light neutral wall paint, and a window with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840968"
"ResourceRecordKey" => "29925586"
"ModificationTimestamp" => "2026-06-18T22:10:35.73Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29925586_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925586/df1c6b6dc51d80bcf149f5777d12e115.webp"
"MediaSize" => 48574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925586/thumbnail-df1c6b6dc51d80bcf149f5777d12e115.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a pedestal sink, toilet, and bathtub"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840968"
"ResourceRecordKey" => "29925586"
"ModificationTimestamp" => "2026-06-18T22:10:35.73Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29925586_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925586/eda3f83e65e104e1d30d8c4ecd17448e.webp"
"MediaSize" => 74042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925586/thumbnail-eda3f83e65e104e1d30d8c4ecd17448e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840968"
"ResourceRecordKey" => "29925586"
"ModificationTimestamp" => "2026-06-18T22:10:35.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29925586_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925586/0bcef90d04c802dac0534a5611359a4f.webp"
"MediaSize" => 115033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925586/thumbnail-0bcef90d04c802dac0534a5611359a4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with paneled wainscoting and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840968"
"ResourceRecordKey" => "29925586"
"ModificationTimestamp" => "2026-06-18T22:10:35.73Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29925586_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925586/a90ff7f9682a2c87144d20d1a1214c13.webp"
"MediaSize" => 83580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925586/thumbnail-a90ff7f9682a2c87144d20d1a1214c13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white toilet, vanity with a light yellow countertop and integrated sink, white louvered-door cabinetry, and a mirrored wall cabinet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840968"
"ResourceRecordKey" => "29925586"
"ModificationTimestamp" => "2026-06-18T22:10:35.73Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29925586_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925586/8433bd49718433f1dbd5cc741a91d595.webp"
"MediaSize" => 42646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925586/thumbnail-8433bd49718433f1dbd5cc741a91d595.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840968"
"ResourceRecordKey" => "29925586"
"ModificationTimestamp" => "2026-06-18T22:10:35.73Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925586')"
+"ID": "1546119"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+post_id: "1545949"
+post_author: 1
+"ListingKey": "29926106"
+"ListingId": "X13464704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T00:25:03Z"
+"RFModificationTimestamp": "2026-06-19T00:28:51Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G1M1"
+"UnparsedAddress": "50 THERESA STREET, Kitchener, Ontario N2G1M1"
+"Coordinates": array:2 [
0 => -80.501229
1 => 43.448638
]
+"Latitude": 43.448638
+"Longitude": -80.501229
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Attention investors, contractors, flippers, and savvy first-time buyers! This spacious, multi-level home offers a rare layout brimming with potential to manufacture your own equity in any market. The unique, highly versatile layout features five total bedrooms and three bathrooms spread across four distinct levels: a 1-bed, 1-bath (with shower) basement; a 1-bed, 1-bath (with tub) main floor; a second floor hosting 3 additional bedrooms and another full bath; plus a fully finished bonus attic space above perfect for an office or playroom. Situated in a highly desirable, great location close to local amenities, this property is the ultimate canvas for a high-yield flip, a multi-generational setup, or a rental investment. Bring your vision and toolbelt to unlock massive upside-opportunities with this much space and flexibility don't last long, so book your showing today! (id:62783)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T00:28:30.337789+00:00"
+"Directions": "Cross Streets: Linden Ave. ** Directions: Victoria St. to Park St. which turns into Jubilee Dr. to Theresa St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241148"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Guest Suite"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "44 x 93 FT ; 44 x 93"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T23:48:19Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T00:17:50Z"
+"Stories": "2.5"
+"StreetName": "Theresa"
+"StreetNumber": "50"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4477"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1662587791"
"RoomType" => "Bedroom"
"ListingId" => "X13464704"
"RoomLevel" => "Basement"
"RoomWidth" => 9.0
"ListingKey" => "29926106"
"RoomLength" => 9.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.85Z"
]
1 => array:11 [
"RoomKey" => "1662587792"
"RoomType" => "Bathroom"
"ListingId" => "X13464704"
"RoomLevel" => "Basement"
"RoomWidth" => 5.0
"ListingKey" => "29926106"
"RoomLength" => 7.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.85Z"
]
2 => array:11 [
"RoomKey" => "1662587793"
"RoomType" => "Kitchen"
"ListingId" => "X13464704"
"RoomLevel" => "Second level"
"RoomWidth" => 2.0
"ListingKey" => "29926106"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.85Z"
]
3 => array:11 [
"RoomKey" => "1662587794"
"RoomType" => "Bedroom"
"ListingId" => "X13464704"
"RoomLevel" => "Main level"
"RoomWidth" => 9.0
"ListingKey" => "29926106"
"RoomLength" => 9.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.85Z"
]
4 => array:11 [
"RoomKey" => "1662587795"
"RoomType" => "Bathroom"
"ListingId" => "X13464704"
"RoomLevel" => "Main level"
"RoomWidth" => 5.0
"ListingKey" => "29926106"
"RoomLength" => 7.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.85Z"
]
5 => array:11 [
"RoomKey" => "1662587796"
"RoomType" => "Bedroom"
"ListingId" => "X13464704"
"RoomLevel" => "Second level"
"RoomWidth" => 9.0
"ListingKey" => "29926106"
"RoomLength" => 9.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.85Z"
]
6 => array:11 [
"RoomKey" => "1662587797"
"RoomType" => "Bedroom"
"ListingId" => "X13464704"
"RoomLevel" => "Second level"
"RoomWidth" => 9.0
"ListingKey" => "29926106"
"RoomLength" => 9.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.85Z"
]
7 => array:11 [
"RoomKey" => "1662587798"
"RoomType" => "Bedroom"
"ListingId" => "X13464704"
"RoomLevel" => "Second level"
"RoomWidth" => 9.0
"ListingKey" => "29926106"
"RoomLength" => 9.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.85Z"
]
8 => array:11 [
"RoomKey" => "1662587799"
"RoomType" => "Bathroom"
"ListingId" => "X13464704"
"RoomLevel" => "Second level"
"RoomWidth" => 5.0
"ListingKey" => "29926106"
"RoomLength" => 7.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.86Z"
]
9 => array:11 [
"RoomKey" => "1662587800"
"RoomType" => "Other"
"ListingId" => "X13464704"
"RoomLevel" => "Upper Level"
"RoomWidth" => 9.0
"ListingKey" => "29926106"
"RoomLength" => 9.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.86Z"
]
10 => array:11 [
"RoomKey" => "1662587801"
"RoomType" => "Kitchen"
"ListingId" => "X13464704"
"RoomLevel" => "Main level"
"RoomWidth" => 2.0
"ListingKey" => "29926106"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T00:17:50.86Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29926106/50-theresa-street-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"OriginalEntryTimestamp": "2026-06-18T23:48:19.81Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1479314"
+"ListOfficeNationalAssociationId": "1336772"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29926106_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29926106/a8ad7265781b61981be15b86039992f4.webp"
"MediaSize" => 134414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29926106/thumbnail-a8ad7265781b61981be15b86039992f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13464704"
"ResourceRecordKey" => "29926106"
"ModificationTimestamp" => "2026-06-18T23:48:19.82Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29926106')"
+"ID": "1545949"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24845
+post_id: "1545794"
+post_author: 1
+"ListingKey": "29926036"
+"ListingId": "40841297"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T00:00:16Z"
+"RFModificationTimestamp": "2026-06-19T00:09:59Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.13
+"LivingArea": 2263.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G3M5"
+"UnparsedAddress": "40 MADISON Avenue S, Kitchener, Ontario N2G3M5"
+"Coordinates": array:2 [
0 => -80.483285
1 => 43.4457424
]
+"Latitude": 43.4457424
+"Longitude": -80.483285
+"YearBuilt": 1921
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Perched on a hill overlooking the city, this charming 3-bedroom, 2-bathroom century home pairs original character with thoughtful, extensive updates. Thick brick walls quiet the outside world, while large windows and high ceilings keep the main floor bright and open. The kitchen was fully renovated in 2021, alongside new main level flooring and a new furnace and A/C. Since then, the home has continued to be cared for with the same attention: new windows in 2023, a renovated basement bathroom that same year, an updated patio and landscaping in 2022, a deck and pergola added in 2024, and new basement flooring and steps completed in 2026. On the second level you'll find a completely remodeled 5-piece bathroom with freestanding soaker tub, completed in 2025. The layout is well-suited to a variety of living arrangements, with no shortage of storage throughout. Outside, the lot is generous for its downtown setting - a rare find this close to the core. The neighbourhood is friendly, you're walking distance to both primary and high schools, close to the Iron Horse Trail and nearby parks, and just steps from an LRT stop. The surrounding area has seen a steady arrival of great restaurants, bakeries, and grocery stores, all within an easy walk, while highway access remains close by. A home with history, well-maintained and ready for its next chapter. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T00:09:54.245233+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058694"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Visual exposure"
]
+"LotSizeDimensions": "0.13"
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T23:31:55Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T23:51:19Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "MADISON"
+"StreetNumber": "40"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "311 - Downtown/Rockway/S. Ward"
+"TaxAnnualAmount": "3529"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/40-Madison-Ave-S"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1662570493"
"RoomType" => "Storage"
"ListingId" => "40841297"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29926036"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T23:51:19.59Z"
]
1 => array:11 [
"RoomKey" => "1662570494"
"RoomType" => "Laundry room"
"ListingId" => "40841297"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29926036"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 14'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T23:51:19.59Z"
]
2 => array:11 [
"RoomKey" => "1662570495"
"RoomType" => "Living room"
"ListingId" => "40841297"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29926036"
"RoomLength" => null
"RoomDimensions" => "17'6'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T23:51:19.6Z"
]
3 => array:11 [
"RoomKey" => "1662570496"
"RoomType" => "Office"
"ListingId" => "40841297"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29926036"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T23:51:19.6Z"
]
4 => array:11 [
"RoomKey" => "1662570497"
"RoomType" => "Bedroom"
"ListingId" => "40841297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29926036"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 6'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T23:51:19.61Z"
]
5 => array:11 [
"RoomKey" => "1662570498"
"RoomType" => "Bedroom"
"ListingId" => "40841297"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29926036"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T23:51:19.61Z"
]
6 => array:11 [
"RoomKey" => "1662570499"
"RoomType" => "Recreation room"
"ListingId" => "40841297"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29926036"
"RoomLength" => null
"RoomDimensions" => "29'1'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T23:51:19.61Z"
]
7 => array:11 [
"RoomKey" => "1662570500"
"RoomType" => "Bedroom"
…9
]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29926036/40-madison-avenue-s-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 1559
+"BelowGradeFinishedArea": 704
+"OriginalEntryTimestamp": "2026-06-18T23:31:55.35Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1333806"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29926036')"
+"ID": "1545794"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1545599"
+post_author: 1
+"ListingKey": "29924889"
+"ListingId": "40841106"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:00:18Z"
+"RFModificationTimestamp": "2026-06-18T23:10:44Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2024.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2K4"
+"UnparsedAddress": "154 BRIDGEPORT Road E, Waterloo, Ontario N2J2K4"
+"Coordinates": array:2 [
0 => -80.5087041
1 => 43.4716521
]
+"Latitude": 43.4716521
+"Longitude": -80.5087041
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A 50 x 150 ft lot two blocks from Uptown Waterloo — and the market hasn't priced it as it should. This updated all-brick 2-bed, 2.5-bath home with a private 3-season sunroom puts you within walking distance of every major festival, patio, and coffee shop in the city — with updated windows (2018) that make it completely whisper-quiet the moment you close the door. To get this lot size and these finishings, two blocks deeper into the Uptown core would cost you $50–70K more. You're trading a bit of front-facing visibility for immense equity and a lifestyle where your car stays in the driveway all weekend. Mornings: Walk to Midnight Run Cafe or Poppy's Bagels, then through Waterloo Park. Evenings: Minutes from the best patios on King Street, craft breweries, and cultural draws like the Waterloo Jazz Festival, Cruising King, and Ribfest & Craft Beer Show. Saturdays: 7 minutes north to the world-famous St. Jacobs Farmers' Market, then along the Walter Bean Grand River Trail. Walk, cycle, drive, or hop on transit — this home covers every mode. A GRT bus stop is steps from your front door with a direct connection to the ION rapid transit line. Quick drive to U of W & Laurier, Highway 85, and the 401. Inside: quartz kitchen with tile backsplash, living room with office nook, 2pc main floor bath, sunroom walkout to backyard, 2 large bedrooms with walk-in closets, 4pc upper bath, and a bright finished basement with a stunning 4pc bath and glass shower. The detached garage is a blank canvas — creative studio, workshop, or home gym. If you live here, you walk to everything that matters. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T23:10:39.011285+00:00"
+"Directions": "From Weber Street N, head east onto Bridgeport Road E and continue to 154 Bridgeport Road E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2056335"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T20:51:06Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:51:06Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "BRIDGEPORT"
+"StreetNumber": "154"
+"StreetSuffix": "Road"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "4110.23"
+"VirtualTourURLUnbranded": "https://youriguide.com/154BridgeportRdEWaterloo"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924889/154-bridgeport-road-e-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1894210"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156288"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1375
+"BelowGradeFinishedArea": 649
+"OriginalEntryTimestamp": "2026-06-18T20:51:06.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1331680"
+"ListOfficeNationalAssociationId": "1349002"
+"CoListAgentNationalAssociationId": "1213379"
+"CoListOfficeNationalAssociationId": "1112493"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924889')"
+"ID": "1545599"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "1545513"
+post_author: 1
+"ListingKey": "29924953"
+"ListingId": "X13463758"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:05:06Z"
+"RFModificationTimestamp": "2026-06-18T22:57:16Z"
+"ListPrice": 249900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H0C7"
+"UnparsedAddress": "3005 - 60 FREDERICK STREET, Kitchener, Ontario N2H0C7"
+"Coordinates": array:2 [
0 => -80.487078
1 => 43.450672
]
+"Latitude": 43.450672
+"Longitude": -80.487078
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to DTK Condos at 60 Frederick Street, Unit 3005, a stylish 30th-floor, 1-bedroom residence in the heart of Downtown Kitchener. This ultra-chic, carpet-free suite features modern finishes, stainless steel kitchen appliances, in-suite washer and dryer, window coverings, and a private balcony showcasing outstanding city views. A storage locker is included for added convenience. Designed for contemporary urban living, the building offers exceptional amenities including a full-time concierge, fitness centre and yoga studio, party room with catering kitchen, rooftop terrace with BBQs and panoramic views, community garden, dog terrace, and bicycle storage. This unbeatable location places you steps from the ION Light Rail Transit and major bus routes, with easy access to the Kitchener GO Station. Walk to Google, Communitech, The Tannery, D2L, Conestoga College Downtown Campus (directly across the street), University of Waterloo School of Pharmacy and School of Medicine, Victoria Park, Kitchener Market, and an exciting mix of restaurants, cafés, and nightlife. Experience the energy and innovation of the Kitchener Innovation District right outside your door. An excellent opportunity for first-time buyers, professionals, or investors seeking refined downtown living with unbeatable connectivity. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "412.58"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:57:05.838435+00:00"
+"Directions": "Cross Streets: Weber. ** Directions: Weber to Frederick."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T20:59:21Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:59:20Z"
+"StreetName": "Frederick"
+"StreetNumber": "60"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2711"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/3005_60_frederick_st_kitchener_on/"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29924953/3005-60-frederick-street-kitchener"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Onyx"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T20:59:20.92Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924953')"
+"ID": "1545513"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24853
+post_id: "1545600"
+post_author: 1
+"ListingKey": "29925506"
+"ListingId": "X13464128"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:05:19Z"
+"RFModificationTimestamp": "2026-06-18T22:48:31Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2K4"
+"UnparsedAddress": "154 BRIDGEPORT ROAD E, Waterloo, Ontario N2J2K4"
+"Coordinates": array:2 [
0 => -80.5087037
1 => 43.471648
]
+"Latitude": 43.471648
+"Longitude": -80.5087037
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A 50 x 150 ft lot two blocks from Uptown Waterloo - and the market hasn't priced it as it should. This updated all-brick 2-bed, 2.5-bath home with a private 3-season sunroom puts you within walking distance of every major festival, patio, and coffee shop in the city - with updated windows (2018) that make it completely whisper-quiet the moment you close the door. To get this lot size and these finishings, two blocks deeper into the Uptown core would cost you $50-70K more. You're trading a bit of front-facing visibility for immense equity and a lifestyle where your car stays in the driveway all weekend. Mornings: Walk to Midnight Run Cafe or Poppy's Bagels, then through Waterloo Park. Evenings: Minutes from the best patios on King Street, craft breweries, and cultural draws like the Waterloo Jazz Festival, Cruising King, and Ribfest & Craft Beer Show. Saturdays: 7 minutes north to the world-famous St. Jacobs Farmers' Market, then along the Walter Bean Grand River Trail. Walk, cycle, drive, or hop on transit - this home covers every mode. A GRT bus stop is steps from your front door with a direct connection to the ION rapid transit line. Quick drive to U of W & Laurier, Highway 85, and the 401. Inside: quartz kitchen with tile backsplash, living room with office nook, 2pc main floor bath, sunroom walkout to backyard, 2 large bedrooms with walk-in closets, 4pc upper bath, and a bright finished basement with a stunning 4pc bath and glass shower. The detached garage is a blank canvas - creative studio, workshop, or home gym. If you live here, you walk to everything that matters. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:48:21.437587+00:00"
+"Directions": "Cross Streets: Ellis Crescent N and Bridgeport Road E. ** Directions: From Weber Street N, head east onto Bridgeport Road E and continue to 154 Bridgeport Road E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2056387"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50.1 x 151.4 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T21:59:13Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T21:59:13Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "Bridgeport"
+"StreetNumber": "154"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4110.23"
+"VirtualTourURLUnbranded": "https://youriguide.com/154BridgeportRdEWaterloo/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29925506/154-bridgeport-road-e-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 50.1
+"OriginalEntryTimestamp": "2026-06-18T21:59:13.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1331642"
+"ListOfficeNationalAssociationId": "1336772"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925506')"
+"ID": "1545600"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23394
+post_id: "1545601"
+post_author: 1
+"ListingKey": "29924270"
+"ListingId": "40840744"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:40:12Z"
+"RFModificationTimestamp": "2026-06-18T22:41:09Z"
+"ListPrice": 629900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 997.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1R1"
+"UnparsedAddress": "191 KING Street S Unit# 506, Waterloo, Ontario N2J1R1"
+"Coordinates": array:2 [
0 => -80.5187715
1 => 43.4595457
]
+"Latitude": 43.4595457
+"Longitude": -80.5187715
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Suite 506 at the Bauer Lofts! Offering something virtually unheard of in Uptown condo living: TWO OWNED UNDERGROUND PARKING SPACES. In a highly coveted building like the Bauer Lofts, a second parking spot is an absolute game-changer and a true rarity. Featuring soaring ceilings and iconic loft-style windows, there is no shortage of natural sunlight inside this beautiful suite. The large kitchen provides plenty of space to cook and entertain, with ample cupboard and counter space, opening seamlessly to a living room that easily accommodates a dining area or a dedicated work-from-home desk setup. Step outside to your sizeable private balcony to relax and enjoy vibrant views of Uptown Waterloo. The primary bedroom features double closets, plenty of space for a king bed, and a luxurious 5-piece ensuite with double sinks, a soaker tub, a standup shower, and a linen closet. The second bedroom is also large and bright, serving perfectly as a bedroom, study, or office to flexibly meet your needs. An in-suite laundry room with a stackable washer/dryer, extra storage, and a second full bath complete this flawless layout. A storage locker is included for added convenience. The Bauer Lofts premium building amenities include a Fitness Centre, a Rooftop Patio and BBQ Terrace, and a Party Room with a full Kitchen. Located in the vibrant Bauer district, you can enjoy all that Uptown Waterloo has to offer, including exclusive underground access to Vincenzo's and the Bauer Kitchen, while stepping right outside to the Allen St. ION LRT Station. With condo fees including all utilities, this building makes upsizing, downsizing, or first-time buying incredibly affordable, especially with the added value of two rare parking spaces. Come see how great condo living can be today. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "754.49"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:40:58.247930+00:00"
+"Directions": "King St S and John St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2167367"
+"ListOfficeKey": "246041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-18T19:31:17Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:31:17Z"
+"Stories": "5.0"
+"StreetDirSuffix": "South"
+"StreetName": "KING"
+"StreetNumber": "191"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "5299.37"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=S1pxx3SNs49"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924270/191-king-street-s-unit-506-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "C2-25"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 997
+"OriginalEntryTimestamp": "2026-06-18T19:31:17.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1418165"
+"ListOfficeNationalAssociationId": "1202898"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924270')"
+"ID": "1545601"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1545356"
+post_author: 1
+"ListingKey": "29924418"
+"ListingId": "40838430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T20:00:16Z"
+"RFModificationTimestamp": "2026-06-18T22:07:46Z"
+"ListPrice": 249900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 527.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H0C7"
+"UnparsedAddress": "60 FREDERICK Street Unit# 3005, Kitchener, Ontario N2H0C7"
+"Coordinates": array:2 [
0 => -80.4866052
1 => 43.4511626
]
+"Latitude": 43.4511626
+"Longitude": -80.4866052
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to DTK Condos at 60 Frederick Street, Unit 3005, a stylish 30th-floor, 1-bedroom residence in the heart of Downtown Kitchener. This ultra-chic, carpet-free suite features modern finishes, stainless steel kitchen appliances, in-suite washer and dryer, window coverings, and a private balcony showcasing outstanding city views. A storage locker is included for added convenience. Designed for contemporary urban living, the building offers exceptional amenities including a full-time concierge, fitness centre and yoga studio, party room with catering kitchen, rooftop terrace with BBQs and panoramic views, community garden, dog terrace, and bicycle storage. This unbeatable location places you steps from the ION Light Rail Transit and major bus routes, with easy access to the Kitchener GO Station. Walk to Google, Communitech, The Tannery, D2L, Conestoga College Downtown Campus (directly across the street), University of Waterloo School of Pharmacy and School of Medicine, Victoria Park, Kitchener Market, and an exciting mix of restaurants, cafés, and nightlife. Experience the energy and innovation of the Kitchener Innovation District right outside your door. An excellent opportunity for first-time buyers, professionals, or investors seeking refined downtown living with unbeatable connectivity. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFee": "412.58"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:07:37.713928+00:00"
+"Directions": "Weber to Frederick"
+"ExteriorFeatures": array:1 [
0 => "Metal"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-18T19:51:36Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:51:36Z"
+"Stories": "1.0"
+"StreetName": "FREDERICK"
+"StreetNumber": "60"
+"StreetSuffix": "Street"
+"SubdivisionName": "212 - Downtown Kitchener/East Ward"
+"TaxAnnualAmount": "2711"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/3005_60_frederick_st_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924418/60-frederick-street-unit-3005-kitchener"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2171138"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "D-4"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 527
+"OriginalEntryTimestamp": "2026-06-18T19:51:36.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1421648"
+"CoListOfficeNationalAssociationId": "1380559"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924418')"
+"ID": "1545356"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1542715"
+post_author: 1
+"ListingKey": "29921327"
+"ListingId": "40840930"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T15:00:08Z"
+"RFModificationTimestamp": "2026-06-18T15:45:15Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G2G8"
+"UnparsedAddress": "57 GLASGOW Street, Kitchener, Ontario N2G2G8"
+"Coordinates": array:2 [
0 => -80.510904
1 => 43.4538386
]
+"Latitude": 43.4538386
+"Longitude": -80.510904
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This inviting solid brick duplex offers a unique blend of charm, functionality, and opportunity. The upper unit features a total of 3 bedrooms and 2 bathrooms, including a spacious main floor layout with 2 bedrooms, a beautifully updated 4-piece bathroom, and an open-concept living and dining area. The kitchen walks out to a large deck overlooking a fully fenced, expansive backyard—perfect for entertaining or relaxing. Upstairs, you’ll find a private loft-style primary bedroom with hardwood floors and a convenient 2-piece ensuite. The lower level boasts a separate entrance leading to a fully finished 1-bedroom, 1-bathroom unit—ideal as a mortgage helper or in-law suite. Recent updates, including a new roof and furnace in 2022, provide added peace of mind. With a wide driveway offering parking for up to 4 vehicles and no parking restrictions, convenience is key. Located within walking distance to Uptown Waterloo, Downtown Kitchener, Grand River Hospital, Sun Life, and more, this property is perfectly positioned for urban living. Zoned SGA-3 (High Rise Limited) under Kitchener's ‘Growing Together’ Strategic Plan, this lot is part of the city’s bold vision for increased density and sustainable growth. A rare opportunity for developers and investors to be part of a vibrant, transit-oriented community. Opportunities like this are few and far between—don’t miss your chance! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-18T15:45:12.157060+00:00"
+"Directions": "Glasgow St and Park St"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1688209"
+"ListOfficeKey": "296447"
+"PhotosChangeTimestamp": "2026-06-18T14:52:52Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:52:52Z"
+"StreetName": "GLASGOW"
+"StreetNumber": "57"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "3964.91"
+"Utilities": array:1 [
0 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921327/57-glasgow-street-kitchener"
+"CoListAgentKey": "2099327"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"ZoningDescription": "SGA3"
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-18T14:52:52.35Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1173922"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1369514"
+"CoListOfficeNationalAssociationId": "1328541"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921327')"
+"ID": "1542715"
}
]
+success: true
+page_size: 9
+page_count: 50
+count: 443
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]