array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29999876 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1600731"
+post_author: 1
+"ListingKey": "29999876"
+"ListingId": "X13533044"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:00:07Z"
+"RFModificationTimestamp": "2026-07-07T19:22:00Z"
+"ListPrice": 599999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1Z9"
+"UnparsedAddress": "151 ESSON STREET, Waterloo, Ontario N2L1Z9"
+"Coordinates": array:2 [
0 => -80.521502
1 => 43.45716
]
+"Latitude": 43.45716
+"Longitude": -80.521502
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to **151 Esson Street**, a charming 1920s home nestled in one of Uptown Waterloo's most sought-after neighbourhoods. Full of timeless character and warmth, this home offers the perfect opportunity for first-time buyers, young professionals, or anyone looking to enjoy the unbeatable lifestyle that comes with living just steps from everything Uptown has to offer. Walk to Belmont Village, boutique shops, cafés, restaurants, parks, schools, trails, and public transit-all while enjoying the charm of a mature, tree-lined street in an established neighbourhood. Inside, you'll find a home that blends classic character with thoughtful modern updates. The spacious primary suite is a rare find for a home of this era, featuring its own **walk-in closet and private ensuite**, complemented by a second full bathroom for added convenience. The finished attic provides valuable additional living space and is perfect as a children's bedroom, home office, creative studio, or cozy retreat. While there's still room to personalize and add your own finishing touches, many of the major improvements have already been completed, including a **brand-new kitchen (2026), new roof (2025), new front porch decking (2026), new cold room windows (2025), furnace and air conditioner (2019), and water softener (2024). Whether you're looking to put down roots in an incredible neighbourhood or invest in a home with character, charm, and outstanding walkability, **151 Esson Street** is a rare opportunity to own in one of Waterloo's most desirable locations. Offering character that newer homes simply can't replicate, modern updates where they matter most, and a flexible floor plan with the bonus finished attic, this is a home you'll be proud to call your own. Homes in this neighbourhood don't come along often-don't miss your chance to make it yours. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T19:21:21.555559+00:00"
+"Directions": "Cross Streets: Allen. ** Directions: Allen st W to Esson."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2190830"
+"ListOfficeKey": "205041"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T16:55:06Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:55:06Z"
+"Stories": "2.5"
+"StreetName": "Esson"
+"StreetNumber": "151"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5192"
+"VirtualTourURLUnbranded": "https://youriguide.com/vDI4NDFD5V8DD1/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1677448678"
"RoomType" => "Dining room"
"ListingId" => "X13533044"
"RoomLevel" => "Main level"
"RoomWidth" => 10.1
"ListingKey" => "29999876"
"RoomLength" => 12.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:55:06.8Z"
]
1 => array:11 [
"RoomKey" => "1677448679"
"RoomType" => "Kitchen"
"ListingId" => "X13533044"
"RoomLevel" => "Main level"
"RoomWidth" => 14.9
"ListingKey" => "29999876"
"RoomLength" => 9.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:55:06.8Z"
]
2 => array:11 [
"RoomKey" => "1677448680"
"RoomType" => "Foyer"
"ListingId" => "X13533044"
"RoomLevel" => "Main level"
"RoomWidth" => 8.1
"ListingKey" => "29999876"
"RoomLength" => 8.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:55:06.8Z"
]
3 => array:11 [
"RoomKey" => "1677448681"
"RoomType" => "Bathroom"
"ListingId" => "X13533044"
"RoomLevel" => "Second level"
"RoomWidth" => 6.9
"ListingKey" => "29999876"
"RoomLength" => 6.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:55:06.8Z"
]
4 => array:11 [
"RoomKey" => "1677448682"
"RoomType" => "Bathroom"
"ListingId" => "X13533044"
"RoomLevel" => "Second level"
"RoomWidth" => 5.4
"ListingKey" => "29999876"
"RoomLength" => 10.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:55:06.8Z"
]
5 => array:11 [
"RoomKey" => "1677448683"
"RoomType" => "Bedroom"
"ListingId" => "X13533044"
"RoomLevel" => "Second level"
"RoomWidth" => 13.7
"ListingKey" => "29999876"
"RoomLength" => 11.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:55:06.8Z"
]
6 => array:11 [
"RoomKey" => "1677448684"
"RoomType" => "Bedroom 2"
"ListingId" => "X13533044"
"RoomLevel" => "Second level"
"RoomWidth" => 10.1
"ListingKey" => "29999876"
"RoomLength" => 11.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:55:06.8Z"
]
7 => array:11 [
"RoomKey" => "1677448685"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13533044"
"RoomLevel" => "Second level"
"RoomWidth" => 10.11
"ListingKey" => "29999876"
"RoomLength" => 11.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:55:06.8Z"
]
8 => array:11 [
"RoomKey" => "1677448686"
"RoomType" => "Other"
"ListingId" => "X13533044"
"RoomLevel" => "Third level"
"RoomWidth" => 9.6
"ListingKey" => "29999876"
"RoomLength" => 2.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T16:55:06.8Z"
]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2025
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29999876/151-esson-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-07-07T16:55:06.72Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1439873"
+"ListOfficeNationalAssociationId": "1192170"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29999876_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/4eb4dabdfce73bf36036c5f9b44f3c9e.webp"
"MediaSize" => 510304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-4eb4dabdfce73bf36036c5f9b44f3c9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29999876_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/8d985665fba6b484a18d78b189607a43.webp"
"MediaSize" => 502575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-8d985665fba6b484a18d78b189607a43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29999876_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/ca3f3fa4ee8cefa8fd2936b39d2aa8d6.webp"
"MediaSize" => 323717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-ca3f3fa4ee8cefa8fd2936b39d2aa8d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29999876_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/4a2ad2b42738b909635b750c717266b8.webp"
"MediaSize" => 300516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-4a2ad2b42738b909635b750c717266b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29999876_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/4dadf33bb880e375a137f39c362074bf.webp"
"MediaSize" => 154120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-4dadf33bb880e375a137f39c362074bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29999876_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/217fcd77f41e79278f127c70b67e9cc3.webp"
"MediaSize" => 173624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-217fcd77f41e79278f127c70b67e9cc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29999876_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/11f4a091c793160b202322cfa45354fb.webp"
"MediaSize" => 192682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-11f4a091c793160b202322cfa45354fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29999876_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/5a5d5078a9b9c755c1c578eee1efa73b.webp"
"MediaSize" => 174077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-5a5d5078a9b9c755c1c578eee1efa73b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29999876_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/7509273b825127760b3d403a3e85879b.webp"
"MediaSize" => 192081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-7509273b825127760b3d403a3e85879b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29999876_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/725a35b16df9fb7396b0650a1a8fcc3c.webp"
"MediaSize" => 189804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-725a35b16df9fb7396b0650a1a8fcc3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29999876_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/835d40f495e081ffbf1a9fd236b01ea9.webp"
"MediaSize" => 191121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-835d40f495e081ffbf1a9fd236b01ea9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29999876_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/d5571476298814dffafbbe4a8bdbb8a8.webp"
"MediaSize" => 148473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-d5571476298814dffafbbe4a8bdbb8a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29999876_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/914cc30ef7f18c4ed280488c1e9fb6c5.webp"
"MediaSize" => 129936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-914cc30ef7f18c4ed280488c1e9fb6c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29999876_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/c7aca8fa5fa4c5d9f35059efa6521307.webp"
"MediaSize" => 186740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-c7aca8fa5fa4c5d9f35059efa6521307.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29999876_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/dac92ac868993fc7057feaedea341205.webp"
"MediaSize" => 177795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-dac92ac868993fc7057feaedea341205.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29999876_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/0f06cc8e7b27edd37a9cdabf6febeed6.webp"
"MediaSize" => 169776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-0f06cc8e7b27edd37a9cdabf6febeed6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29999876_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/9c7f273792370fb1c59f498bc2898926.webp"
"MediaSize" => 122715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-9c7f273792370fb1c59f498bc2898926.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29999876_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/5fef3844b5acab82c5067f1886d0a978.webp"
"MediaSize" => 143518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-5fef3844b5acab82c5067f1886d0a978.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29999876_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/ad800c7c7a6d07d50b7d2c717bafe8fa.webp"
"MediaSize" => 126243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-ad800c7c7a6d07d50b7d2c717bafe8fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29999876_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/1580f0ebdc3d49bd8b5d7c524da98e7b.webp"
"MediaSize" => 88835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-1580f0ebdc3d49bd8b5d7c524da98e7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29999876_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/44bf4d39413507c12727b0418efd4f09.webp"
"MediaSize" => 116028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-44bf4d39413507c12727b0418efd4f09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29999876_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/71ed3706076d282e0e98db4487b1f53b.webp"
"MediaSize" => 123812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-71ed3706076d282e0e98db4487b1f53b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29999876_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/3fdf4f35d8762ff9ef003d1bd96d96bc.webp"
"MediaSize" => 107062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-3fdf4f35d8762ff9ef003d1bd96d96bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29999876_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/59e459efb5fe78fdf5eac3ed12b5a3cb.webp"
"MediaSize" => 441013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-59e459efb5fe78fdf5eac3ed12b5a3cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29999876_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/c98b9e27cd5298dadac00fac233a248f.webp"
"MediaSize" => 403935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-c98b9e27cd5298dadac00fac233a248f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29999876_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/0811fdd7cc7a7ca59abdd674b9e8906a.webp"
"MediaSize" => 417467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-0811fdd7cc7a7ca59abdd674b9e8906a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29999876_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/083796a244420ab846b8ce68d573a7e8.webp"
"MediaSize" => 321743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-083796a244420ab846b8ce68d573a7e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29999876_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/e65fa13901eaf53b44584d2b6ecd58fc.webp"
"MediaSize" => 195956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-e65fa13901eaf53b44584d2b6ecd58fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29999876_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/096f6682f1a95fb38e70497b9d11d14e.webp"
"MediaSize" => 95418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-096f6682f1a95fb38e70497b9d11d14e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29999876_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/2c0becf24edff7a03f9b4841d1952f21.webp"
"MediaSize" => 113431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-2c0becf24edff7a03f9b4841d1952f21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29999876_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/21683003afc9cc83727ee961124421b4.webp"
"MediaSize" => 85655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-21683003afc9cc83727ee961124421b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29999876_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999876/ceec7e666715cd771274f0fec6967f48.webp"
"MediaSize" => 97409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999876/thumbnail-ceec7e666715cd771274f0fec6967f48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13533044"
"ResourceRecordKey" => "29999876"
"ModificationTimestamp" => "2026-07-07T16:55:06.73Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999876')"
+"ID": "1600731"
}
]
+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 205041" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24892
+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 2190830" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24861
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29999876'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25244
+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 '29999876'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25260
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29999876' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521502 43.45716)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25313
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "1602353"
+post_author: 1
+"ListingKey": "30002794"
+"ListingId": "X13535388"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T23:20:02Z"
+"RFModificationTimestamp": "2026-07-08T00:56:55Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2Y2"
+"UnparsedAddress": "901 - 160 KING STREET N, Waterloo, Ontario N2J2Y2"
+"Coordinates": array:2 [
0 => -80.523733
1 => 43.471876
]
+"Latitude": 43.471876
+"Longitude": -80.523733
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The unit is located at 160 King St N, Unit 901.It has unbeatable views.The unit is close to schools, parks, Uptown Waterloo, and amenities.The primary bedroom features floor-to-ceiling windows and an en-suite.The second bedroom has wrap-around windows and a panoramic view.The kitchen includes quartz countertops and stainless steel appliances.Maintenance fees cover heat, water, an exercise facility, a business/study centre, and a party room. (id:62650)"
+"AssociationFee": "408"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T00:56:49.771220+00:00"
+"Directions": "JAMES ST & KING ST N"
+"ExteriorFeatures": array:1 [
0 => "Concrete Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2140739"
+"ListOfficeKey": "50003"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T23:09:35Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T23:09:35Z"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "160"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3984"
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30002794/901-160-king-street-n-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-07T23:09:35.54Z"
+"ListAgentNationalAssociationId": "1392531"
+"ListOfficeNationalAssociationId": "1284999"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30002794_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/37a5c08807318080437b818b92825a1c.webp"
"MediaSize" => 139191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-37a5c08807318080437b818b92825a1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30002794_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/f2760496f91b65618717af47a99e33b0.webp"
"MediaSize" => 106359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-f2760496f91b65618717af47a99e33b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30002794_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/f4398c153c83eb563915a722da181dcd.webp"
"MediaSize" => 132689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-f4398c153c83eb563915a722da181dcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30002794_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/7ca27fd9a37a016616a56c8cf19a2b68.webp"
"MediaSize" => 89509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-7ca27fd9a37a016616a56c8cf19a2b68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30002794_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/1aab821e64723db2a410af60f81075d1.webp"
"MediaSize" => 104614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-1aab821e64723db2a410af60f81075d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30002794_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/8e034820b975aeef3fc6ca4f46d5ac45.webp"
"MediaSize" => 115041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-8e034820b975aeef3fc6ca4f46d5ac45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30002794_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/c051af616b5338c35e297593c5b67447.webp"
"MediaSize" => 93362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-c051af616b5338c35e297593c5b67447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30002794_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/6d93cc16cb359218675746a39f84d5a0.webp"
"MediaSize" => 113182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-6d93cc16cb359218675746a39f84d5a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30002794_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/1bb3e1647bc9c9fcc2466a1eb51d2f48.webp"
"MediaSize" => 116096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-1bb3e1647bc9c9fcc2466a1eb51d2f48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30002794_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/5f231f66176bebf170115f5f8142f2f9.webp"
"MediaSize" => 83167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-5f231f66176bebf170115f5f8142f2f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30002794_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/63b0ae804324fa96fef07a69ae99430c.webp"
"MediaSize" => 45552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-63b0ae804324fa96fef07a69ae99430c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30002794_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/f39f762d9ba61499b116488e1789c6dd.webp"
"MediaSize" => 82128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-f39f762d9ba61499b116488e1789c6dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30002794_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/60abf08dd123dda5f766fd540d38a284.webp"
"MediaSize" => 102266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-60abf08dd123dda5f766fd540d38a284.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30002794_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/00b2a0e69ca04f4ddd1f6e93819c173b.webp"
"MediaSize" => 68652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-00b2a0e69ca04f4ddd1f6e93819c173b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30002794_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/4a1e04a0cc120e7f09cbab72b20eecc3.webp"
"MediaSize" => 180071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-4a1e04a0cc120e7f09cbab72b20eecc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30002794_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/e2a980f28284982a32d5692ddfbef946.webp"
"MediaSize" => 74257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-e2a980f28284982a32d5692ddfbef946.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30002794_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/83400b95d32d9766b2e2c40a2de4f54a.webp"
"MediaSize" => 71037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-83400b95d32d9766b2e2c40a2de4f54a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30002794_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/6cd36f4b21ad8834d3aa6067a2641d72.webp"
"MediaSize" => 94460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-6cd36f4b21ad8834d3aa6067a2641d72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30002794_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/e34322d2903afb0d4963d32a8f7857fd.webp"
"MediaSize" => 90978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-e34322d2903afb0d4963d32a8f7857fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30002794_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30002794/572809cd4a3a40de43897b43cda76dac.webp"
"MediaSize" => 64144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30002794/thumbnail-572809cd4a3a40de43897b43cda76dac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13535388"
"ResourceRecordKey" => "30002794"
"ModificationTimestamp" => "2026-07-07T23:09:35.55Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30002794')"
+"ID": "1602353"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1601200"
+post_author: 1
+"ListingKey": "30001167"
+"ListingId": "40844851"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T21:05:16Z"
+"RFModificationTimestamp": "2026-07-07T21:13:54Z"
+"ListPrice": 635000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1584.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2H3V6"
+"UnparsedAddress": "126 WATERLOO Street Unit# 1, Kitchener, Ontario N2H3V6"
+"Coordinates": array:2 [
0 => -80.5010259
1 => 43.4582838
]
+"Latitude": 43.4582838
+"Longitude": -80.5010259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to “The Matrix By Duke”. This is your opportunity to own a brand new corner unit in a well-established neighbourhood in Midtown. Halfway between Downtown Kitchener and Uptown Waterloo, close proximity to Google, the train station and all of the amenities offered by both Kitchener and Waterloo. The majority of other new builds in Kitchener are on the far edge of the city, and this one is right in the middle of all the action. Each generously sized unit offers 1,584sqft (all above grade), 3 spacious bedrooms, 2.5 bathrooms (1 is an en suite) and not 1 but 2 parking spots, which is very rare in this price point. BONUS! Bright and cheerful sun room on top floor, off the primary bedroom, offering lovely views of mature trees, sunrises and sunsets. Price includes $10,000 in your choice of upgrades. It also includes a professional interior decor consultation to help you make this home your own. Click on the attached link for more renderings, floor plans and further information. Move on this quickly, as it won’t last. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "253.27"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Other, See Remarks"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T21:13:37.852987+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Insulated Concrete Forms"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1867305"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-07T19:18:29Z"
+"PhotosCount": 2
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T20:59:36Z"
+"Stories": "3.0"
+"StreetName": "WATERLOO"
+"StreetNumber": "126"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4161.76"
+"VirtualTourURLUnbranded": "https://theredcarpetcrew.com/properties/the-matrix-by-duke/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1677628764"
"RoomType" => "Sunroom"
"ListingId" => "40844851"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.87Z"
]
1 => array:11 [
"RoomKey" => "1677628765"
"RoomType" => "Storage"
"ListingId" => "40844851"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.87Z"
]
2 => array:11 [
"RoomKey" => "1677628766"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844851"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.88Z"
]
3 => array:11 [
"RoomKey" => "1677628767"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844851"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.88Z"
]
4 => array:11 [
"RoomKey" => "1677628768"
"RoomType" => "Laundry room"
"ListingId" => "40844851"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "2'10'' x 3'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.89Z"
]
5 => array:11 [
"RoomKey" => "1677628769"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844851"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.89Z"
]
6 => array:11 [
"RoomKey" => "1677628770"
"RoomType" => "Bedroom"
"ListingId" => "40844851"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.89Z"
]
7 => array:11 [
"RoomKey" => "1677628771"
"RoomType" => "Bedroom"
"ListingId" => "40844851"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.89Z"
]
8 => array:11 [
"RoomKey" => "1677628772"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844851"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.89Z"
]
9 => array:11 [
"RoomKey" => "1677628773"
"RoomType" => "Living room"
"ListingId" => "40844851"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.89Z"
]
10 => array:11 [
"RoomKey" => "1677628774"
"RoomType" => "Kitchen"
"ListingId" => "40844851"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.89Z"
]
11 => array:11 [
"RoomKey" => "1677628775"
"RoomType" => "Dining room"
"ListingId" => "40844851"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30001167"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T20:59:36.89Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30001167/126-waterloo-street-unit-1-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1950229"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76840"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1584
+"OriginalEntryTimestamp": "2026-07-07T19:18:29.11Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1203626"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1244423"
+"CoListOfficeNationalAssociationId": "1004363"
+"Media": array:2 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30001167_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001167/d47aa2acd71e6c2974888ff6e54cb9bb.webp"
"MediaSize" => 170652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001167/thumbnail-d47aa2acd71e6c2974888ff6e54cb9bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844851"
"ResourceRecordKey" => "30001167"
"ModificationTimestamp" => "2026-07-07T19:18:29.11Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30001167_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30001167/798e780371bac2bc8e2a8d360eeb7e23.webp"
"MediaSize" => 114058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30001167/thumbnail-798e780371bac2bc8e2a8d360eeb7e23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844851"
"ResourceRecordKey" => "30001167"
"ModificationTimestamp" => "2026-07-07T19:18:29.11Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001167')"
+"ID": "1601200"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1599794"
+post_author: 1
+"ListingKey": "29999286"
+"ListingId": "40845902"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T17:35:12Z"
+"RFModificationTimestamp": "2026-07-07T17:35:42Z"
+"ListPrice": 499888.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1043.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1Y2"
+"UnparsedAddress": "148 WATERLOO Street, Waterloo, Ontario N2J1Y2"
+"Coordinates": array:2 [
0 => -80.5052241
1 => 43.461645
]
+"Latitude": 43.461645
+"Longitude": -80.5052241
+"YearBuilt": 1938
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 148 Waterloo Street, a charming and well-maintained home situated on a large lot in a desirable Waterloo neighbourhood. One of the property's standout features is its private setting with no rear neighbours, backing directly onto a scenic trail that provides a peaceful backdrop and easy access to outdoor recreation. Boasting excellent curb appeal, this home offers an attached garage, ample parking, and a fully fenced backyard—perfect for entertaining, gardening, or enjoying time with family and pets. Inside, you'll find bright and inviting living spaces filled with natural light, updated vinyl flooring, and beautiful hardwood floors in excellent condition. The kitchen features stainless steel appliances and a convenient eat-in dining area, while the spacious living room and generously sized bedrooms provide comfort and functionality throughout. Additional highlights include an insulated attic for improved energy efficiency, a basement complete with a sauna, laundry area, and ample storage space, as well as an attached garage offering flexibility for hobbies, a workshop, or extra storage. Complete with a large yard and storage shed, this character-filled home presents a wonderful opportunity to enjoy privacy, convenience, and outdoor living in a sought-after Waterloo location close to schools, parks, shopping, and everyday amenities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Sauna"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T16:45:38.938390+00:00"
+"Directions": "WATERLOO&ROGER ST"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958128"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T15:59:34Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:59:55Z"
+"Stories": "1.5"
+"StreetName": "WATERLOO"
+"StreetNumber": "148"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "3938.71"
+"VirtualTourURLUnbranded": "https://youriguide.com/148_waterloo_st_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1677455727"
"RoomType" => "Storage"
"ListingId" => "40845902"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "3'10'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.47Z"
]
1 => array:11 [
"RoomKey" => "1677455728"
"RoomType" => "Utility room"
"ListingId" => "40845902"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.47Z"
]
2 => array:11 [
"RoomKey" => "1677455729"
"RoomType" => "Storage"
"ListingId" => "40845902"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 5'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.47Z"
]
3 => array:11 [
"RoomKey" => "1677455730"
"RoomType" => "Laundry room"
"ListingId" => "40845902"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.47Z"
]
4 => array:11 [
"RoomKey" => "1677455731"
"RoomType" => "Bedroom"
"ListingId" => "40845902"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.48Z"
]
5 => array:11 [
"RoomKey" => "1677455732"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845902"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.48Z"
]
6 => array:11 [
"RoomKey" => "1677455733"
"RoomType" => "Bedroom"
"ListingId" => "40845902"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.48Z"
]
7 => array:11 [
"RoomKey" => "1677455734"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845902"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.48Z"
]
8 => array:11 [
"RoomKey" => "1677455735"
"RoomType" => "Dining room"
"ListingId" => "40845902"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.48Z"
]
9 => array:11 [
"RoomKey" => "1677455736"
"RoomType" => "Living room"
"ListingId" => "40845902"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.48Z"
]
10 => array:11 [
"RoomKey" => "1677455737"
"RoomType" => "Kitchen"
"ListingId" => "40845902"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29999286"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 6'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T16:59:55.48Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29999286/148-waterloo-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "GR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1043
+"OriginalEntryTimestamp": "2026-07-07T15:59:34.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1249296"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29999286_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999286/03b8109f80e053728da70ab9938aa4f9.webp"
"MediaSize" => 137043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999286/thumbnail-03b8109f80e053728da70ab9938aa4f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845902"
"ResourceRecordKey" => "29999286"
"ModificationTimestamp" => "2026-07-07T15:59:34.5Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29999286_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999286/0eb2b93ad95f3ed5df00d60cfbf78c9e.webp"
"MediaSize" => 138911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999286/thumbnail-0eb2b93ad95f3ed5df00d60cfbf78c9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845902"
"ResourceRecordKey" => "29999286"
"ModificationTimestamp" => "2026-07-07T15:59:34.5Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29999286_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999286/d2c1de191825cf5fc699119dccc8b9b5.webp"
"MediaSize" => 72437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999286/thumbnail-d2c1de191825cf5fc699119dccc8b9b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845902"
"ResourceRecordKey" => "29999286"
"ModificationTimestamp" => "2026-07-07T15:59:34.5Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29999286_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999286/74f10efe3b1e7943fd6c9ab8e3792a20.webp"
"MediaSize" => 76256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999286/thumbnail-74f10efe3b1e7943fd6c9ab8e3792a20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845902"
"ResourceRecordKey" => "29999286"
"ModificationTimestamp" => "2026-07-07T15:59:34.5Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29999286_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999286/86fe935911c1f290d37545bfdb2e6dc7.webp"
"MediaSize" => 77926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999286/thumbnail-86fe935911c1f290d37545bfdb2e6dc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999286')"
+"ID": "1599794"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "1596587"
+post_author: 1
+"ListingKey": "29994075"
+"ListingId": "40845094"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T17:35:33Z"
+"RFModificationTimestamp": "2026-07-06T19:11:42Z"
+"ListPrice": 359800.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 754.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6L7"
+"UnparsedAddress": "133 PARK Street Unit# 101, Waterloo, Ontario N2L6L7"
+"Coordinates": array:2 [
0 => -80.5209868
1 => 43.4589135
]
+"Latitude": 43.4589135
+"Longitude": -80.5209868
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 101-133 Park Street, a bright and well-designed 1-bedroom, 1-bathroom condo in the heart of Uptown Waterloo. This open-concept, high ceiling layout seamlessly connects the living and kitchen areas, creating a comfortable and functional space for everyday living and entertaining. Large windows bring in plenty of natural light, while the spacious bedroom with an en-suite bathroom offers a quiet retreat with ample room to unwind. The unit is complete with in-suite laundry and a clean, well-appointed 4-piece bath. Step outside from the front or the back and find yourself walking to morning coffee at Princess Café, picking up fresh ingredients at Vincenzo’s, or an evening stroll through Waterloo Park, all just minutes from your front door, with the ION LRT close by to keep everything within easy reach. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "359.19"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T19:11:35.026312+00:00"
+"Directions": "Allen St. W."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080806"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Shared Driveway"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-07-06T17:18:35Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T17:18:35Z"
+"Stories": "1.0"
+"StreetName": "PARK"
+"StreetNumber": "133"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "2850"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29994075/133-park-street-unit-101-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "I"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 754
+"OriginalEntryTimestamp": "2026-07-06T17:18:35.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1355621"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:18 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29994075')"
+"ID": "1596587"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25308
+post_id: "1596034"
+post_author: 1
+"ListingKey": "29993272"
+"ListingId": "40845495"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T15:55:41Z"
+"RFModificationTimestamp": "2026-07-06T16:55:31Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2W5"
+"UnparsedAddress": "16 MCDOUGALL Road, Waterloo, Ontario N2L2W5"
+"Coordinates": array:2 [
0 => -80.5411618
1 => 43.4581692
]
+"Latitude": 43.4581692
+"Longitude": -80.5411618
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PREMIUM build opportunity in the heart of Waterloo! Watch listing video to see different options! Rarely does a lot (51’ x 120’) with a forest view so close to all Uptown Waterloo amenities come available. Steps away from universities, restaurants, Waterloo Park, Waterloo Rec Center, Westmount Golf & Country Club, and so much more! Great development opportunity in a highly sought after area! Land only for sale. Lot has not been serviced but it will be municipal water and sewer. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-06T16:55:02.535151+00:00"
+"Directions": "Located between Erb St W & Keats Way"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091826"
+"ListOfficeKey": "289541"
+"PhotosChangeTimestamp": "2026-07-06T15:48:14Z"
+"PhotosCount": 2
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T15:48:14Z"
+"StreetName": "MCDOUGALL"
+"StreetNumber": "16"
+"StreetSuffix": "Road"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3018"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/H60f5zq_MX8?si=knXeEgCPNopmmisx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29993272/16-mcdougall-road-waterloo"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R-1"
+"FrontageLengthNumeric": 51.0
+"OriginalEntryTimestamp": "2026-07-06T15:48:14.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1364413"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:2 [
0 => array:13 [ …13]
1 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29993272')"
+"ID": "1596034"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1595889"
+post_author: 1
+"ListingKey": "29993330"
+"ListingId": "40845154"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T16:55:15Z"
+"RFModificationTimestamp": "2026-07-07T17:00:06Z"
+"ListPrice": 479900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1546.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G2G5"
+"UnparsedAddress": "3 GLASGOW Street, Kitchener, Ontario N2G2G5"
+"Coordinates": array:2 [
0 => -80.5085701
1 => 43.4547686
]
+"Latitude": 43.4547686
+"Longitude": -80.5085701
+"YearBuilt": 1921
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An incredible opportunity awaits first-time homebuyers and savvy investors in a highly sought-after Midtown location! This classic 1921 century home seamlessly blends historic character with endless potential, offering a spacious 2+1 bedroom, 2 bathroom layout ready for your personal touch. Officially recognized as a legal duplex, this versatile property with a generous layout, and premier urban location, presents a rare opportunity for buyers looking to confidently break into the market. Location is everything, and here you are just a short stroll from trendy Belmont Village, with boutique shopping, exceptional dining, and vibrant community atmosphere. Enjoy effortless walkability to the downtown core, local parks, transit, great schools, and close proximity to the Grand River Hospital and regional health network. Schedule your private viewing today and unlock the massive potential of this Midtown gem! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-07-06T16:48:30.395770+00:00"
+"Directions": "Heading towards Victoria St on King St W, turn right onto Green St. Then left onto Park St and then left onto Glasgow St. After Gruhn St, before the bend, the house will be on the right."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1830296"
+"ListOfficeKey": "156381"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-06T15:59:27Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:48:38Z"
+"Stories": "1.5"
+"StreetName": "GLASGOW"
+"StreetNumber": "3"
+"StreetSuffix": "Street"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "4527.32"
+"VirtualTourURLUnbranded": "https://youriguide.com/3_glasgow_st_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29993330/3-glasgow-street-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1750055"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289634"
+"GeocodeManualYN": true
+"ZoningDescription": "R2B"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 1302
+"BelowGradeFinishedArea": 244
+"OriginalEntryTimestamp": "2026-07-06T15:59:26.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1195691"
+"ListOfficeNationalAssociationId": "1003914"
+"CoListAgentNationalAssociationId": "1066154"
+"CoListOfficeNationalAssociationId": "1379718"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29993330')"
+"ID": "1595889"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1595326"
+post_author: 1
+"ListingKey": "29991823"
+"ListingId": "40844396"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T11:55:10Z"
+"RFModificationTimestamp": "2026-07-06T14:09:44Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2191.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1G4"
+"UnparsedAddress": "181 RODNEY Street, Waterloo, Ontario N2J1G4"
+"Coordinates": array:2 [
0 => -80.5070862
1 => 43.4653938
]
+"Latitude": 43.4653938
+"Longitude": -80.5070862
+"YearBuilt": 1954
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 181 Rodney Street - a beautifully maintained all-brick bungalow tucked into one of Waterloo's most desirable pockets. From here, you're just minutes from Uptown Waterloo's beloved cafes, boutique shops, and restaurants, with quick highway access for an easy commute.This spacious 5-bedroom home strikes the perfect balance of classic charm and thoughtful updates. The main floor features 3 generous bedrooms and gleaming hardwood flooring installed in 2016, all set against professionally landscaped grounds that make a lasting first impression.Upstairs, a versatile loft bedroom offers flexible space - perfect as a guest suite, home yoga studio, or a blank canvas to make your own.Downstairs, the fully finished basement adds a 5th bedroom and a cozy gas fireplace, creating a warm retreat for cooler months.The kitchen was professionally redesigned in 2020 with elegant quartz countertops, and both bathrooms were tastefully renovated in 2017. Outside, enjoy an exposed aggregate walkway in the backyard, a detached garage, a 10' x 10' workshop, and additional sheds - offering exceptional storage and workspace for hobbies, tools, or projects.Major mechanicals have been well maintained throughout: furnace and A/C (2018, recently serviced), an owned hot water tank (2024), and a Napoleon fireplace serviced in 2025 - giving you true peace of mind for years to come. This is Uptown Waterloo living at its finest - walkable charm, everyday convenience, and a home that's been genuinely loved. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T14:09:42.494650+00:00"
+"Directions": "Weber Street"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2159234"
+"ListOfficeKey": "294047"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T11:48:59Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T11:48:59Z"
+"Stories": "1.0"
+"StreetName": "RODNEY"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "3531"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/181_rodney_st_waterloo_on"
+"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/29991823/181-rodney-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 54.0
+"AboveGradeFinishedArea": 1550
+"BelowGradeFinishedArea": 641
+"OriginalEntryTimestamp": "2026-07-06T11:48:59.15Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1410495"
+"ListOfficeNationalAssociationId": "1435346"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29991823')"
+"ID": "1595326"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+post_id: "1595328"
+post_author: 1
+"ListingKey": "29991945"
+"ListingId": "X13525212"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T13:15:26Z"
+"RFModificationTimestamp": "2026-07-06T13:40:32Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1G4"
+"UnparsedAddress": "181 RODNEY STREET, Waterloo, Ontario N2J1G4"
+"Coordinates": array:2 [
0 => -80.507104
1 => 43.465359
]
+"Latitude": 43.465359
+"Longitude": -80.507104
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 181 Rodney Street - a beautifully maintained all-brick bungalow tucked into one of Waterloo's most desirable pockets. From here, you're just minutes from Uptown Waterloo's beloved cafes, boutique shops, and restaurants, with quick highway access for an easy commute.This spacious 5-bedroom home strikes the perfect balance of classic charm and thoughtful updates. The main floor features 3 generous bedrooms and gleaming hardwood flooring installed in 2016, all set against professionally landscaped grounds that make a lasting first impression.Upstairs, a versatile loft bedroom offers flexible space - perfect as a guest suite, home yoga studio, or a blank canvas to make your own.Downstairs, the fully finished basement adds a 5th bedroom and a cozy gas fireplace, creating a warm retreat for cooler months.The kitchen was professionally redesigned in 2020 with elegant quartz countertops, and both bathrooms were tastefully renovated in 2017. Outside, enjoy an exposed aggregate walkway in the backyard, a detached garage, a 10' x 10' workshop, and additional sheds - offering exceptional storage and workspace for hobbies, tools, or projects.Major mechanicals have been well maintained throughout: furnace and A/C (2018, recently serviced), an owned hot water tank (2024), and a Napoleon fireplace serviced in 2025 - giving you true peace of mind for years to come. This is Uptown Waterloo living at its finest - walkable charm, everyday convenience, and a home that's been genuinely loved. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T13:40:24.713129+00:00"
+"Directions": "Cross Streets: Rodney & Weber. ** Directions: Weber to Rodney."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235403"
+"ListOfficeKey": "294121"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Flat site"
2 => "Carpet Free"
]
+"LotSizeDimensions": "54.6 x 117.5 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T12:14:52Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T13:09:30Z"
+"Stories": "1.0"
+"StreetName": "Rodney"
+"StreetNumber": "181"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3531"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/181_rodney_st_waterloo_on"
+"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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29991945/181-rodney-street-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 54.7
+"OriginalEntryTimestamp": "2026-07-06T12:14:52.31Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1473266"
+"ListOfficeNationalAssociationId": "1435796"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29991945')"
+"ID": "1595328"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+post_id: "1593723"
+post_author: 1
+"ListingKey": "29990279"
+"ListingId": "X13523606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T21:45:04Z"
+"RFModificationTimestamp": "2026-07-04T22:34:16Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2G0E2"
+"UnparsedAddress": "1502 - 108 GARMENT STREET, Kitchener, Ontario N2G0E2"
+"Coordinates": array:2 [
0 => -80.501976
1 => 43.450163
]
+"Latitude": 43.450163
+"Longitude": -80.501976
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Live the Good Life at Garment Street Condos! Luxury 2-bedroom, 2-bath corner unit in Kitchener's Innovation District. Freshly painted.Approx. 976 sq. ft. with open-concept layout, engineered hardwood floors, quartz counters, and stainless steel appliances. Enjoy top amenities-rooftop pool, BBQs, gym, yoga studio, urban park, and 24-hour concierge. (id:62650)"
+"Appliances": array:7 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"AssociationFee": "863.19"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T22:34:05.477477+00:00"
+"Directions": "Victoria/Garment"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1598400"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-04T21:39:14Z"
+"PhotosCount": 31
+"PoolFeatures": array:1 [
0 => "Outdoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T21:39:14Z"
+"StreetName": "Garment"
+"StreetNumber": "108"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3988.58"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29990279/1502-108-garment-street-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Security/Concierge"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-04T21:39:14.48Z"
+"ListAgentNationalAssociationId": "1157212"
+"ListOfficeNationalAssociationId": "1461559"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29990279')"
+"ID": "1593723"
}
]
+success: true
+page_size: 9
+page_count: 33
+count: 295
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]