array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29817972 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1468519"
+post_author: 1
+"ListingKey": "29817972"
+"ListingId": "X13208248"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:35:07Z"
+"RFModificationTimestamp": "2026-06-12T15:39:10Z"
+"ListPrice": 645000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N8"
+"UnparsedAddress": "465 COLT STREET, Waterloo, Ontario N2K4N8"
+"Coordinates": array:2 [
0 => -80.491281
1 => 43.498604
]
+"Latitude": 43.498604
+"Longitude": -80.491281
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "SPACIOUS OPEN CONCEPT FREEHOLD TOWNHOME! Welcome to this beautifully maintained townhome in one of Waterloo's most desirable and family-friendly neighbourhoods! Located on a quiet stretch of Colt Street, this move-in-ready home offers the perfect combination of space, comfort, and long-term value-with no condo fees. Boasting approximately 1,461 sq ft, this bright and freshly painted home features 3 spacious bedrooms and 2.5 bathrooms, ideal for families, professionals, or investors. The main floor offers a functional open-concept layout with abundant natural light, creating a warm and inviting atmosphere perfect for everyday living and entertaining. Upstairs, you'll find generously sized bedrooms, including a comfortable primary retreat with an ensuite bath, along with ample closet space throughout. The unfinished basement provides a blank canvas-ready for your personal touch, whether you envision a recreation room, home gym, or additional living space. Step outside to a rare deep lot (152 ft) offering a private backyard with endless potential for outdoor enjoyment, gardening, or future enhancements. Parking is a standout feature with 1 garage space (with inside entry to home) plus additional driveway parking, accommodating families with multiple vehicles with ease. Additional highlights include: Freehold ownership (no monthly fees) Fresh paint throughout (2026) New, never used, washer and dryer Clean, vacant, and ready for immediate possession Conveniently located close to schools - including both U of W & WLU - parks, shopping, and major routes, this home delivers both lifestyle and investment appeal in a high-demand area of Waterloo. Don't miss your opportunity to own a turn-key home with exceptional value and future potential! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-28T16:20:26.372115+00:00"
+"Directions": "Cross Streets: University Ave E. ** Directions: University Ave E to Colt St."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2128374"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.3 x 152.1 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-05-28T15:59:34Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:29:12Z"
+"Stories": "2.0"
+"StreetName": "Colt"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4641"
+"VirtualTourURLUnbranded": "https://youriguide.com/465_colt_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1657758028"
"RoomType" => "Bathroom"
"ListingId" => "X13208248"
"RoomLevel" => "Main level"
"RoomWidth" => 1.02
"ListingKey" => "29817972"
"RoomLength" => 2.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:29:12.44Z"
]
1 => array:11 [
"RoomKey" => "1657758030"
"RoomType" => "Dining room"
"ListingId" => "X13208248"
"RoomLevel" => "Main level"
"RoomWidth" => 2.78
"ListingKey" => "29817972"
"RoomLength" => 3.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:29:12.45Z"
]
2 => array:11 [
"RoomKey" => "1657758031"
"RoomType" => "Kitchen"
"ListingId" => "X13208248"
"RoomLevel" => "Main level"
"RoomWidth" => 3.12
"ListingKey" => "29817972"
"RoomLength" => 3.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:29:12.45Z"
]
3 => array:11 [
"RoomKey" => "1657758032"
"RoomType" => "Living room"
"ListingId" => "X13208248"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "29817972"
"RoomLength" => 5.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:29:12.45Z"
]
4 => array:11 [
"RoomKey" => "1657758033"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13208248"
"RoomLevel" => "Second level"
"RoomWidth" => 3.75
"ListingKey" => "29817972"
"RoomLength" => 412.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:29:12.45Z"
]
5 => array:11 [
"RoomKey" => "1657758034"
"RoomType" => "Bathroom"
"ListingId" => "X13208248"
"RoomLevel" => "Second level"
"RoomWidth" => 2.08
"ListingKey" => "29817972"
"RoomLength" => 2.22
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:29:12.45Z"
]
6 => array:11 [
"RoomKey" => "1657758035"
"RoomType" => "Bedroom 2"
"ListingId" => "X13208248"
"RoomLevel" => "Second level"
"RoomWidth" => 3.09
"ListingKey" => "29817972"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:29:12.46Z"
]
7 => array:11 [
"RoomKey" => "1657758036"
"RoomType" => "Bedroom 3"
"ListingId" => "X13208248"
"RoomLevel" => "Second level"
"RoomWidth" => 2.72
"ListingKey" => "29817972"
"RoomLength" => 3.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:29:12.46Z"
]
8 => array:11 [
"RoomKey" => "1657758037"
"RoomType" => "Bathroom"
"ListingId" => "X13208248"
"RoomLevel" => "Second level"
"RoomWidth" => 2.48
"ListingKey" => "29817972"
"RoomLength" => 2.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T15:29:12.46Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29817972/465-colt-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.3
+"OriginalEntryTimestamp": "2026-05-28T15:59:34.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1381523"
+"ListOfficeNationalAssociationId": "1381521"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29817972_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/415b70d842cdcf3b92266934baec6071.webp"
"MediaSize" => 270775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-415b70d842cdcf3b92266934baec6071.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29817972_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/3527df43c389ab664c5a540e25cc22cf.webp"
"MediaSize" => 120594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-3527df43c389ab664c5a540e25cc22cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer with tile floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29817972_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/a757d558c9cd57856b53a8f1cf808869.webp"
"MediaSize" => 173839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-a757d558c9cd57856b53a8f1cf808869.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright open concept layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29817972_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/9d2be00d3bb7f25d2da5667b43b605a3.webp"
"MediaSize" => 155966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-9d2be00d3bb7f25d2da5667b43b605a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Appliances Inclued"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29817972_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/d41b4dd834b7a93682ecb786bdd1006b.webp"
"MediaSize" => 140620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-d41b4dd834b7a93682ecb786bdd1006b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29817972_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/703c4f1f67a20d53a8b3e9712a32a26f.webp"
"MediaSize" => 152056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-703c4f1f67a20d53a8b3e9712a32a26f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29817972_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/1d97fc6d8d546d9568d9c053b468a8bc.webp"
"MediaSize" => 112768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-1d97fc6d8d546d9568d9c053b468a8bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29817972_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/06cf069675db4575740fe7b0302446af.webp"
"MediaSize" => 148178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-06cf069675db4575740fe7b0302446af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29817972_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/a0405265dc8bce9e0ddf653f92f65946.webp"
"MediaSize" => 134826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-a0405265dc8bce9e0ddf653f92f65946.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29817972_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/0f3a9a33eb296f1c76b1ec629ba80021.webp"
"MediaSize" => 172602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-0f3a9a33eb296f1c76b1ec629ba80021.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29817972_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/122425cba1687bf3a5878e010d82dbcb.webp"
"MediaSize" => 161306
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-122425cba1687bf3a5878e010d82dbcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29817972_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/a0996791321f71a948abf19a4a60b30e.webp"
"MediaSize" => 192075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-a0996791321f71a948abf19a4a60b30e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29817972_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/0b9c78329e8ff93187064be997cf6d17.webp"
"MediaSize" => 164109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-0b9c78329e8ff93187064be997cf6d17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-out to large deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29817972_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/6a5fc6aad22cc2f464c0afb21e0ff2e4.webp"
"MediaSize" => 56452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-6a5fc6aad22cc2f464c0afb21e0ff2e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2 pc powder room on the main floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29817972_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/309c82b408f78e4c9e0eb21cd04fbc62.webp"
"MediaSize" => 184047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-309c82b408f78e4c9e0eb21cd04fbc62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious Primary Bedroom with 3 pc ensuite bath"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29817972_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/0b78019fe4bb0399a25ce67c83124a36.webp"
"MediaSize" => 148435
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-0b78019fe4bb0399a25ce67c83124a36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29817972_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/a2b88c188c326badb22cf187ffb9fddd.webp"
"MediaSize" => 71373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-a2b88c188c326badb22cf187ffb9fddd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite Bath"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29817972_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/72df2f599acea50b7cd839dc75b65145.webp"
"MediaSize" => 57620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-72df2f599acea50b7cd839dc75b65145.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite Bath"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29817972_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/eb87d444af2008cb2bd24237598931d7.webp"
"MediaSize" => 129578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-eb87d444af2008cb2bd24237598931d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "2nd bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29817972_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/de1ceb6c706e15840b445c7fa51efe35.webp"
"MediaSize" => 123233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-de1ceb6c706e15840b445c7fa51efe35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "3rd Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29817972_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/b1337607d1265f86ea6c1644f3c016f6.webp"
"MediaSize" => 108898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-b1337607d1265f86ea6c1644f3c016f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upper-level laundry with new washer & dryer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29817972_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/96600dbb8b3417648fd3cc84734bc7f7.webp"
"MediaSize" => 112699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-96600dbb8b3417648fd3cc84734bc7f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29817972_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/3a631157c94d44afa8641038ce9966be.webp"
"MediaSize" => 197639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-3a631157c94d44afa8641038ce9966be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large w"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29817972_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/36c4fb259422e314186c2b021a2e54ac.webp"
"MediaSize" => 178838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-36c4fb259422e314186c2b021a2e54ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29817972_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/a618692d189ba37e1aabf6376b524996.webp"
"MediaSize" => 312037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-a618692d189ba37e1aabf6376b524996.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29817972_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/a0b2f4f0d3a5a86c79faad75a1b3a7ec.webp"
"MediaSize" => 281011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-a0b2f4f0d3a5a86c79faad75a1b3a7ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29817972_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/54a127c237531ca44bd78450d832616f.webp"
"MediaSize" => 257079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-54a127c237531ca44bd78450d832616f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29817972_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/d850aea85d4f2cfcc366c355c57e58b7.webp"
"MediaSize" => 369321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-d850aea85d4f2cfcc366c355c57e58b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "L"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29817972_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/43654434594810fe02d044ecebe6fdb0.webp"
"MediaSize" => 97189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-43654434594810fe02d044ecebe6fdb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29817972_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/6f686ddcbea804a4c201f7ff1a28123a.webp"
"MediaSize" => 117779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-6f686ddcbea804a4c201f7ff1a28123a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29817972_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29817972/fc75883db2c0d985d7e4d49dfb1cda18.webp"
"MediaSize" => 87663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29817972/thumbnail-fc75883db2c0d985d7e4d49dfb1cda18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13208248"
"ResourceRecordKey" => "29817972"
"ModificationTimestamp" => "2026-05-28T15:59:34.74Z"
]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29817972')"
+"ID": "1468519"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Cache Key: 678a470cebc810d4907ffc6020b3431986944184e7445d55e18301344af6fefb" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24472
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2128374" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24786
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29817972'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25092
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29817972'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25105
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25108
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31223215"
+"ListingKey": "29817972"
+"ListingId": "X13208248"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-01T02:56:27Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31223215')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25110
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31329534"
+"ListingKey": "29817972"
+"ListingId": "X13208248"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-06"
+"OpenHouseStartTime": "2026-06-06T14:00:00Z"
+"OpenHouseEndTime": "2026-06-06T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-07T05:19:40Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31329534')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25107
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31372251"
+"ListingKey": "29817972"
+"ListingId": "X13208248"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-08T04:02:42Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31372251')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25111
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31431700"
+"ListingKey": "29817972"
+"ListingId": "X13208248"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T13:20:21Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31431700')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25109
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31445189"
+"ListingKey": "29817972"
+"ListingId": "X13208248"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T14:00:00Z"
+"OpenHouseEndTime": "2026-06-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T22:34:28Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31445189')"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25106
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31445190"
+"ListingKey": "29817972"
+"ListingId": "X13208248"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T22:34:28Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31445190')"
}
]
+success: true
+page_size: 6
+page_count: 1
+count: 6
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29817972' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.491281 43.498604)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25193
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25167
+post_id: "1521904"
+post_author: 1
+"ListingKey": "29890891"
+"ListingId": "40835701"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T19:10:10Z"
+"RFModificationTimestamp": "2026-06-12T01:46:04Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2787.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0C1"
+"UnparsedAddress": "518 PREAKNESS Street, Waterloo, Ontario N2K0C1"
+"Coordinates": array:2 [
0 => -80.4832054
1 => 43.4948702
]
+"Latitude": 43.4948702
+"Longitude": -80.4832054
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in Waterloo East’s exclusive Woolwich Estates, this spotless, high-end home sits in one of the area’s most desirable pockets, surrounded by beautiful homes, mature streetscapes, parks and trails. Walking distance to Kiwanis Park, Grand View Trails, excellent schools and amenities, with easy access to the expressway, Rim Park, Grey Silo Golf Course, St. Jacobs, Conestoga Mall and Guelph. Impressive curb appeal starts with the brick and stucco exterior, interlock driveway, meticulous landscaping and oversized rich espresso front door. Exterior lighting on timers and an app-enabled in-ground sprinkler system make the outdoor care feel thoughtful and polished. Inside, the grand foyer features a vaulted ceiling and tiled floor, opening to a beautifully maintained main level with engineered hardwood flooring throughout. The kitchen offers stainless appliances, extensive cabinetry, a large island with breakfast bar seating and a servery with glass-front cabinetry, pantry, wine fridge and extra prep space. The kitchen flows into the bright living room with stone-surround fireplace, while the formal dining area offers great space for entertaining. A statement staircase leads to the second floor, where the soaring open-to-below design adds impressive detail. A bonus family room provides valuable extra living space for family, work-from-home needs or a cozy lounge area. The spacious primary bedroom features coffered ceilings, custom window treatments, a walk-in closet and well-appointed ensuite with double sinks and large frameless glass shower. Two additional bedrooms and a full 4-piece bath complete this level. Sliding doors off the kitchen lead to the fully fenced backyard, set on a pie-shaped lot offering more outdoor space than many lots in the area. Beautifully landscaped and lined with trees for added privacy, the yard features a large composite deck, pergola and backyard shed. Added bonus...the garage is fully drywalled and painted with a custom epoxy floor! (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Central Vacuum - Roughed In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:45:53.425914+00:00"
+"Directions": "Woolwich Street to Carriage Way to Preakness"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1769740"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:00:41Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:00:41Z"
+"Stories": "2.0"
+"StreetName": "PREAKNESS"
+"StreetNumber": "518"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "9209.43"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/518_preakness_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1657258144"
"RoomType" => "Primary Bedroom"
"ListingId" => "40835701"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => "15'4'' x 22'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.38Z"
]
1 => array:11 [
"RoomKey" => "1657258145"
"RoomType" => "Family room"
"ListingId" => "40835701"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => "23'10'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.38Z"
]
2 => array:11 [
"RoomKey" => "1657258146"
"RoomType" => "Bedroom"
"ListingId" => "40835701"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.38Z"
]
3 => array:11 [
"RoomKey" => "1657258147"
"RoomType" => "Bedroom"
"ListingId" => "40835701"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.38Z"
]
4 => array:11 [
"RoomKey" => "1657258148"
"RoomType" => "4pc Bathroom"
"ListingId" => "40835701"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.38Z"
]
5 => array:11 [
"RoomKey" => "1657258149"
"RoomType" => "4pc Bathroom"
"ListingId" => "40835701"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.38Z"
]
6 => array:11 [
"RoomKey" => "1657258150"
"RoomType" => "Living room"
"ListingId" => "40835701"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.38Z"
]
7 => array:11 [
"RoomKey" => "1657258151"
"RoomType" => "Laundry room"
"ListingId" => "40835701"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.38Z"
]
8 => array:11 [
"RoomKey" => "1657258152"
"RoomType" => "Kitchen"
"ListingId" => "40835701"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => "18'9'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.38Z"
]
9 => array:11 [
"RoomKey" => "1657258153"
"RoomType" => "Dining room"
"ListingId" => "40835701"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.39Z"
]
10 => array:11 [
"RoomKey" => "1657258154"
"RoomType" => "2pc Bathroom"
"ListingId" => "40835701"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890891"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-11T18:52:41.39Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29890891/518-preakness-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2203749"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2787
+"OriginalEntryTimestamp": "2026-06-11T18:52:41.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1186018"
+"ListOfficeNationalAssociationId": "1458684"
+"CoListAgentNationalAssociationId": "1452339"
+"CoListOfficeNationalAssociationId": "1328541"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29890891_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/7d38d2cc3387f2bc36d375e2af8d0e97.webp"
"MediaSize" => 146201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-7d38d2cc3387f2bc36d375e2af8d0e97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.48Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29890891_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/d2a458ceae94c1b7d18b44116cca84f9.webp"
"MediaSize" => 148068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-d2a458ceae94c1b7d18b44116cca84f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.48Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29890891_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/d5c69931e21c0bf074c30371babc16c4.webp"
"MediaSize" => 176878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-d5c69931e21c0bf074c30371babc16c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.48Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29890891_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/d1aa525ab3c4dcbd2c0f3f2bff61fa19.webp"
"MediaSize" => 72966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-d1aa525ab3c4dcbd2c0f3f2bff61fa19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.53Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29890891_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/376abe95ee27588d0f35159fa028f6a3.webp"
"MediaSize" => 144012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-376abe95ee27588d0f35159fa028f6a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29890891_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/96ca7cca39ba4b03d2849d501fe3bb56.webp"
"MediaSize" => 53864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-96ca7cca39ba4b03d2849d501fe3bb56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.48Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29890891_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/c14fdd9b9b312e3922abdeb6e7b28838.webp"
"MediaSize" => 73836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-c14fdd9b9b312e3922abdeb6e7b28838.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.48Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29890891_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/32559dd1d5a6983a9c78f435a45b1b6e.webp"
"MediaSize" => 101350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-32559dd1d5a6983a9c78f435a45b1b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.47Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29890891_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/3b09420ed62f99049bb5a75bf8e4ee33.webp"
"MediaSize" => 97287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-3b09420ed62f99049bb5a75bf8e4ee33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.47Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29890891_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/22d44f363de94680d27bcf584c6a9048.webp"
"MediaSize" => 46279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-22d44f363de94680d27bcf584c6a9048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.47Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29890891_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890891/8728f19a96676077ccbf05d89b9730b0.webp"
"MediaSize" => 87821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890891/thumbnail-8728f19a96676077ccbf05d89b9730b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835701"
"ResourceRecordKey" => "29890891"
"ModificationTimestamp" => "2026-06-11T19:00:40.58Z"
]
11 => array:13 [
"Order" => 12
…12
]
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]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890891')"
+"ID": "1521904"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25169
+post_id: "1521275"
+post_author: 1
+"ListingKey": "29891441"
+"ListingId": "X13433564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:48:57Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0C1"
+"UnparsedAddress": "518 PREAKNESS STREET, Waterloo, Ontario N2K0C1"
+"Coordinates": array:2 [
0 => -80.483088
1 => 43.494859
]
+"Latitude": 43.494859
+"Longitude": -80.483088
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in Waterloo East's exclusive Woolwich Estates, this spotless, high-end home sits in one of the area's most desirable pockets, surrounded by beautiful homes, mature streetscapes, parks and trails. Walking distance to Kiwanis Park, Grand View Trails, excellent schools and amenities, with easy access to the expressway, Rim Park, Grey Silo Golf Course, St. Jacobs, Conestoga Mall and Guelph. Impressive curb appeal starts with the brick and stucco exterior, interlock driveway, meticulous landscaping and oversized rich espresso front door. Exterior lighting on timers and an app-enabled in-ground sprinkler system make the outdoor care feel thoughtful and polished. Inside, the grand foyer features a vaulted ceiling and tiled floor, opening to a beautifully maintained main level with engineered hardwood flooring throughout. The kitchen offers stainless appliances, extensive cabinetry, a large island with breakfast bar seating and a servery with glass-front cabinetry, pantry, wine fridge and extra prep space. The kitchen flows into the bright living room with stone-surround fireplace, while the formal dining area offers great space for entertaining. A statement staircase leads to the second floor, where the soaring open-to-below design adds impressive detail. A bonus family room provides valuable extra living space for family, work-from-home needs or a cozy lounge area. The spacious primary bedroom features coffered ceilings, custom window treatments, a walk-in closet and well-appointed ensuite with double sinks and large frameless glass shower. Two additional bedrooms and a full 4-piece bath complete this level. Sliding doors off the kitchen lead to the fully fenced backyard, set on a pie-shaped lot offering more outdoor space than many lots in the area. Beautifully landscaped and lined with trees for added privacy, the yard features a large composite deck, pergola and backyard shed. Added bonus...the garage is fully drywalled and painted with a custom epoxy floor! (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-11T21:48:52.710792+00:00"
+"Directions": "Cross Streets: Woolwich Street. ** Directions: Woolwich Street to Carriage Way to Preakness."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2250801"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Flat site"
2 => "Sump Pump"
]
+"LotSizeDimensions": "40.2 x 116.5 FT ; 40.17 x 109.12 x 71.30 x 116.53"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:53Z"
+"Stories": "2.0"
+"StreetName": "Preakness"
+"StreetNumber": "518"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9209.43"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/518_preakness_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891441/518-preakness-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.2
+"OriginalEntryTimestamp": "2026-06-11T19:54:53.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1489710"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:50 [
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]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891441')"
+"ID": "1521275"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: "1519775"
+post_author: 1
+"ListingKey": "29889315"
+"ListingId": "40838920"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T21:30:09Z"
+"RFModificationTimestamp": "2026-06-11T21:34:17Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1559.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3S4"
+"UnparsedAddress": "465 WOOLWICH Street, Waterloo, Ontario N2K3S4"
+"Coordinates": array:2 [
0 => -80.4927797
1 => 43.4997029
]
+"Latitude": 43.4997029
+"Longitude": -80.4927797
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "O.H. SUN JUN 14th (3-5). Welcome to 8-465 Woolwich St., an exceptional value condo-townhouse in Waterloo's desirable Kiwanis Park/Lexington neighbourhood. Move-in ready and welcoming, this home offers a smart, spacious layout with quality laminate and hardwood flooring throughout the main floor and clean carpet upstairs. The efficient galley kitchen connects to the dining area and offers ample counter and cupboard space. The living room opens to your private deck and green space, creating an easy indoor-outdoor flow for summer BBQs, morning coffee, or relaxed entertaining. Upstairs, you'll find two generously sized bedrooms, each with double closets. The finished basement adds versatility and can easily serve as a family room, home office, fitness area, hobby space, or guest retreat. An additional 4-piece bathroom adds convenience and flexibility. The location is a true lifestyle highlight. Just minutes from Kiwanis Park, you'll enjoy playgrounds, picnic areas, trails and one of Waterloo's favourite public pools. Nearby RIM Park offers year-round recreation with arenas, indoor sports fields, walking tracks, fitness facilities, community programs, and Grey Silo Golf Course. Nature lovers will appreciate the close proximity to the Grand River and the Walter Bean Grand River Trail, offering kilometres of scenic pathways through beautiful natural landscapes. Enjoy walking, cycling, birdwatching, and outdoor recreation right at your doorstep. Shopping, restaurants, groceries, schools, and everyday amenities are nearby, while quick access to Highway 85 and the Conestoga Parkway makes commuting throughout Waterloo Region easy. Set in a well-managed condominium community with updates including windows, exterior doors & deck, this home is an excellent opportunity for first-time buyers, downsizers, families, or investors seeking an affordable entry into one of Waterloo's most sought-after neighbourhoods. Call your REALTOR® today and come see for yourself. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFee": "483.12"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:19:05.284312+00:00"
+"Directions": "University St. to Woolwich St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564736"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-11T20:04:26Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T21:20:57Z"
+"Stories": "2.0"
+"StreetName": "WOOLWICH"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3113.4"
+"VirtualTourURLUnbranded": "https://youriguide.com/465-_woolwich_st_waterloo_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/29889315/465-woolwich-street-unit-8-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1060
+"BelowGradeFinishedArea": 499
+"OriginalEntryTimestamp": "2026-06-11T16:32:56.11Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1126313"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889315')"
+"ID": "1519775"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1519349"
+post_author: 1
+"ListingKey": "29889117"
+"ListingId": "40838881"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T16:20:12Z"
+"RFModificationTimestamp": "2026-06-11T16:57:15Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.23
+"LivingArea": 2169.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1K8"
+"UnparsedAddress": "135 BRIDGE Street W, Waterloo, Ontario N2K1K8"
+"Coordinates": array:2 [
0 => -80.4900781
1 => 43.4863491
]
+"Latitude": 43.4863491
+"Longitude": -80.4900781
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Cottage Living in the City! Rare 66' x 153' Walk-Out Bungalow Backing onto Bechtel Park! Welcome to 135 Bridge Street West, a rare gem featuring a massive, ultra-private 66 ft by 153 ft lot that makes you feel like you're at the cottage while living right in Waterloo. Parking is a breeze with a large concrete driveway accommodating four cars. Inside, the main floor features a unique primary retreat encompassing two full rooms—the second seamlessly utilized as an expansive dream walk-in closet—complete with ensuite privilege. The fully finished lower level features a family room, 3pc bathroom, and an additional bedroom. Because it is a full walk-out with large above-grade windows, the space floods with natural light and offers incredible potential for an in-law suite with direct yard access. Step outside to your large raised deck overlooking a sprawling yard that backs DIRECTLY onto Bechtel Park, giving you instant access to hiking trails, forested wetlands, sports fields, and a dog park. Incredible convenience with a grocery plaza just down the street, quick transit access, and universities just minutes away. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T16:57:12.511408+00:00"
+"Directions": "University to Bridge St W"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915409"
+"ListOfficeKey": "156381"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.23"
+"PhotosChangeTimestamp": "2026-06-11T16:11:00Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T16:11:00Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "BRIDGE"
+"StreetNumber": "135"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4492.58"
+"VirtualTourURLUnbranded": "https://youriguide.com/55ebg_135_bridge_st_w_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29889117/135-bridge-street-w-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1152
+"BelowGradeFinishedArea": 1017
+"OriginalEntryTimestamp": "2026-06-11T16:11:00.39Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1224446"
+"ListOfficeNationalAssociationId": "1003914"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889117')"
+"ID": "1519349"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25168
+post_id: "1516367"
+post_author: 1
+"ListingKey": "29884556"
+"ListingId": "X13427330"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T19:45:05Z"
+"RFModificationTimestamp": "2026-06-10T21:20:27Z"
+"ListPrice": 1525000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0C5"
+"UnparsedAddress": "158 EAGLECREST STREET, Waterloo, Ontario N2K0C5"
+"Coordinates": array:2 [
0 => -80.473869
1 => 43.499215
]
+"Latitude": 43.499215
+"Longitude": -80.473869
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To This Exquisite Family Home In The Much Sought After Neighbourhood Of Kiwanis Park. Offering Over 3,500 Square Feet Of Luxurious Living Space, This Stunning Residence Combines Elegance With Functionality, Perfect For Growing Families Or Those Who Love To Entertain. Step Inside The Expansive Open-Concept Design Featuring High Ceilings And Abundant Natural Light That Pours Through Oversized Windows. The Gourmet Kitchen With Top-Of-The-Line Stainless Steel Appliances, A Huge Island With Stone Countertops, And Ample Cabinetry Overlook The Grand Living Room With Vaulted Ceilings And Natural Gas Fireplace. The Main Floor Also Includes A Beautiful Dining Room Perfect For Hosting Dinner Parties, A Private Office And A Large Mudroom Off The Two Car Garage With Epoxied Flooring. Retreat Up The Grand Staircase To Find Spacious Bedrooms Including An Opulent Master Suite Boasting A Spa-Like En-Suite Bath And Generous Walk-In Closet. Two Additional Large Bedrooms Share An Oversized Jack & Jill Bathroom. The Upper Level Also Features A Sizable Laundry Room. The Finished Basement Has High Ceilings, A Natural Gas Fireplace And Plenty Of Space For A Gym, Gaming And Whatever Else Your Family Has In Mind. This Level Is Also Roughed In For An Additional Bedroom And Boasts Another Full Bathroom. Outside, Enjoy Your Private Backyard Oasis Ideal For Summer Barbecues Or Quiet Evenings Under The Stars. Professionally Hardscaped And Landscaped And Backing Directly Onto Kiwanis Park, This Serene Setting Is Tough To Beat. Conveniently Located Near Great Schools, Parks, Shopping Centres, And Major Highways. Don't Miss The Chance To Make This Your Forever Home! (id:62783)"
+"Appliances": array:4 [
0 => "Hot Tub"
1 => "Wine Fridge"
2 => "Window Coverings"
3 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T21:20:25.764384+00:00"
+"Directions": "Falconridge Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1998221"
+"ListOfficeKey": "50441"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Sauna"
]
+"LotSizeDimensions": "45 x 98 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T19:32:36Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T19:32:36Z"
+"Stories": "2.0"
+"StreetName": "Eaglecrest"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8995"
+"View": "View"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/158_eaglecrest_street_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29884556/158-eaglecrest-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "Res"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-10T19:32:36.48Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1280647"
+"ListOfficeNationalAssociationId": "1112107"
+"Media": array:50 [
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]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884556')"
+"ID": "1516367"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25163
+post_id: "1514962"
+post_author: 1
+"ListingKey": "29880685"
+"ListingId": "40823911"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T18:00:10Z"
+"RFModificationTimestamp": "2026-06-10T18:01:18Z"
+"ListPrice": 545000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1210.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2G4"
+"UnparsedAddress": "435A LEE Avenue, Waterloo, Ontario N2K2G4"
+"Coordinates": array:2 [
0 => -80.5067851
1 => 43.4965407
]
+"Latitude": 43.4965407
+"Longitude": -80.5067851
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming, lovingly maintained semi-detached home, proudly offered by its second owner and located in the highly desirable Lincoln Village neighbourhood. The bright eat-in kitchen features an attractive accent wall, ample cabinetry, and plenty of space for everyday family meals. The spacious open-concept living room is filled with natural light from the large bay window and offers room for both comfortable living and dining. This thoughtfully designed home boasts three generously sized bedrooms, two full bathrooms, and a functional layout that has been lovingly cared for over the years. The basement offers excellent potential for additional living space and includes a full bathroom, laundry area, and abundant storage. Adding to the appeal are the often-overlooked benefits of wonderful neighbours, a large lot, and the only carport on the street. Step outside to the covered deck overlooking the fully fenced backyard, which backs directly onto lush, park greenspace—providing added privacy and a beautiful setting for relaxing, entertaining, or enjoying family time outdoors. Ideally located close to the expressway, schools, shopping, and all amenities, this exceptional property presents a fantastic opportunity for families, first-time buyers, and investors alike. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T16:48:04.415942+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908536"
+"ListOfficeKey": "274404"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-10T17:53:18Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T17:53:18Z"
+"Stories": "2.0"
+"StreetName": "LEE"
+"StreetNumber": "435"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3220"
+"VirtualTourURLUnbranded": "https://youriguide.com/a_435_lee_avenue_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29880685/435a-lee-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1210
+"OriginalEntryTimestamp": "2026-06-10T11:52:28.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1221358"
+"ListOfficeNationalAssociationId": "1254957"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880685')"
+"ID": "1514962"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1511560"
+post_author: 1
+"ListingKey": "29876857"
+"ListingId": "40837970"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T17:30:48Z"
+"RFModificationTimestamp": "2026-06-09T18:44:17Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3341.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K4J3"
+"UnparsedAddress": "210 HAWKSWOOD Drive, Kitchener, Ontario N2K4J3"
+"Coordinates": array:2 [
0 => -80.4765068
1 => 43.4979765
]
+"Latitude": 43.4979765
+"Longitude": -80.4765068
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fully Renovated & Backing onto Parkland in Kiwanis Park! Welcome to 210 Hawkswood, a stunning modern residence beautifully positioned in the highly sought-after Kiwanis Park neighbourhood. From the moment you step through the private entrance, the grand foyer impresses with soaring two-storey ceilings and seamless access to a dedicated main-floor office. The heart of the home opens up into a bright family room anchored by a natural gas fireplace, offering views of your fully fenced yard with deck, hot tub and the lush parkland beyond. The gourmet kitchen is a chef’s dream, completely refreshed with a sleek premium cabinets and countertops, copious storage, and a sunlit dinette. Upstairs, discover four generous bedrooms, a beautifully updated main bath, and a luxurious primary ensuite complete with a jet tub. The fully finished lower level is an entertainer's paradise, boasting an open-concept theatre area with pre-wired AV connections, a dedicated home gym space, a full bathroom, and an additional bedroom. Best of all? You back directly onto River Ridge Community Park, with trails to Kiwanis Park and the Grand River just steps from your front door. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T18:44:10.844677+00:00"
+"Directions": "Woolwich St. to Hawkswood Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1914828"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:20:52Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T17:20:51Z"
+"Stories": "2.0"
+"StreetName": "HAWKSWOOD"
+"StreetNumber": "210"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "6756"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://propertyvision.ca/tour/17223"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29876857/210-hawkswood-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "RES-3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2284
+"BelowGradeFinishedArea": 1057
+"OriginalEntryTimestamp": "2026-06-09T17:20:51.04Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1224120"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:50 [
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]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876857')"
+"ID": "1511560"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25191
+post_id: "1510602"
+post_author: 1
+"ListingKey": "29875364"
+"ListingId": "40838072"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T14:20:04Z"
+"RFModificationTimestamp": "2026-06-11T14:24:14Z"
+"ListPrice": 625000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.06
+"LivingArea": 1304.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3X7"
+"UnparsedAddress": "243 AUBURN Drive, Waterloo, Ontario N2K3X7"
+"Coordinates": array:2 [
0 => -80.4909041
1 => 43.4896522
]
+"Latitude": 43.4896522
+"Longitude": -80.4909041
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 243 Auburn Drive, a freehold townhome in the highly sought-after University Downs neighbourhood, offering an exceptional combination of location, privacy, and lifestyle. Attached only at the garage with direct access to rear yard and no shared interior walls, this home provides the feel of a detached property while remaining affordable with absolutely no condo fees. Situated on a beautifully landscaped lot, this home offers exceptional outdoor living with a welcoming covered front porch and a private backyard deck, creating the perfect setting for relaxing, entertaining and outdoor dining. The bright, open-concept main floor is designed for modern living, featuring a spacious kitchen with ample cabinetry and a seamless flow into the dining and living areas. Large windows and patio door fill the home with natural light while providing beautiful views of the backyard. A convenient main floor powder room adds to the home's functionality. Upstairs, you'll find three generously sized bedrooms, including a spacious primary retreat featuring a large walk-in closet and abundant natural light. The additional bedrooms offer flexibility for growing families, guests, or a home office. The unfinished basement with 3 pc rough in provides excellent potential for future living space. Location is truly what sets this property apart. University Downs is one of Waterloo's most desirable family-friendly communities, you'll enjoy convenient access to excellent schools, parks, trails, sports fields, libraries, shopping, restaurants, public transit, and every daily amenity imaginable. Commuters will appreciate being just minutes from highway access, Uptown Waterloo, Downtown Kitchener, RIM Park and both universities. Whether you're a first-time buyer, young family, professional, or investor, this is an outstanding opportunity to own a well-maintained freehold home in a prime Waterloo location where convenience, community, and lifestyle come together perfectly. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T17:22:23.243840+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563431"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.06"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T14:39:58Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T14:10:31Z"
+"Stories": "2.0"
+"StreetName": "AUBURN"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3637.94"
+"VirtualTourURLUnbranded": "https://youriguide.com/243_auburn_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29875364/243-auburn-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 1304
+"OriginalEntryTimestamp": "2026-06-09T14:39:58.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1069710"
+"ListOfficeNationalAssociationId": "1380559"
+"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('29875364')"
+"ID": "1510602"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25192
+post_id: "1510405"
+post_author: 1
+"ListingKey": "29876050"
+"ListingId": "X13419624"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T16:05:08Z"
+"RFModificationTimestamp": "2026-06-11T16:33:23Z"
+"ListPrice": 625000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3X7"
+"UnparsedAddress": "243 AUBURN DRIVE, Waterloo, Ontario N2K3X7"
+"Coordinates": array:2 [
0 => -80.491011
1 => 43.489598
]
+"Latitude": 43.489598
+"Longitude": -80.491011
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 243 Auburn Drive, a freehold townhome in the highly sought-after University Downs neighbourhood, offering an exceptional combination of location, privacy, and lifestyle. Attached only at the garage with direct access to rear yard and no shared interior walls, this home provides the feel of a detached property while remaining affordable with absolutely no condo fees. Situated on a beautifully landscaped lot, this home offers exceptional outdoor living with a welcoming covered front porch and a private backyard deck, creating the perfect setting for relaxing, entertaining and outdoor dining. The bright, open-concept main floor is designed for modern living, featuring a spacious kitchen with ample cabinetry and a seamless flow into the dining and living areas. Large windows and patio door fill the home with natural light while providing beautiful views of the backyard. A convenient main floor powder room adds to the home's functionality. Upstairs, you'll find three generously sized bedrooms, including a spacious primary retreat featuring a large walk-in closet and abundant natural light. The additional bedrooms offer flexibility for growing families, guests, or a home office. The unfinished basement with 3 pc rough in provides excellent potential for future living space. Location is truly what sets this property apart. University Downs is one of Waterloo's most desirable family-friendly communities, you'll enjoy convenient access to excellent schools, parks, trails, sports fields, libraries, shopping, restaurants, public transit, and every daily amenity imaginable. Commuters will appreciate being just minutes from highway access, Uptown Waterloo, Downtown Kitchener, RIM Park and both universities. Whether you're a first-time buyer, young family, professional, or investor, this is an outstanding opportunity to own a well-maintained freehold home in a prime Waterloo location where convenience, community, and lifestyle come together perfectly. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:23:24.076012+00:00"
+"Directions": "Cross Streets: University. ** Directions: University to Auburn."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2133582"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24 x 105 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T15:54:04Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T15:58:56Z"
+"Stories": "2.0"
+"StreetName": "Auburn"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3637.94"
+"VirtualTourURLUnbranded": "https://youriguide.com/243_auburn_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29876050/243-auburn-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.0
+"OriginalEntryTimestamp": "2026-06-09T15:54:04.67Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1386021"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876050')"
+"ID": "1510405"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 83
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]