array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29179982/Property?$select=ALL&$top=20&$filter=ListingKey eq 29179982&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29179982/Property?$select=ALL&$top=20&$filter=ListingKey eq 29179982&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23633
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23635
+post_id: "475760"
+post_author: 1
+"ListingKey": "29179982"
+"ListingId": "40793510"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T16:50:04Z"
+"RFModificationTimestamp": "2025-12-11T19:29:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 835.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "251 NORTHFIELD Drive Unit# 415B, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5213246
1 => 43.5104707
]
+"Latitude": 43.5104707
+"Longitude": -80.5213246
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the modern and sought after Blackstone Condos, inspired by Scandinavian living and located in Colonial Acres in North Waterloo! This beautiful open concept 2BR/2BA unit is in exceptional condition with several upgrades.\u{A0} The unit features high ceilings, spacious dining/living area with access to an oversized balcony.\u{A0} The kitchen has been upgraded with quality stainless steel appliances, quartz countertops, subway tile backsplash, tall dishwasher and double undermount stainless steel sink.. Extra upgrades with under the cabinets lights and media charging station. The primary bedroom has a very sizeable walk-in closet and the upgraded all around tiled ensuite.\u{A0} The second bedroom/bathroom can also function as a second suite. There is a lot being offered with the many community amenities, which include a fitness center, a firepit area, outdoor kitchens with BBQs, a co-working space, 1-dedicated underground parking space and a 2,000 sqft event room! The complex also offers bicycle storage, keyless entry, parking garage elevators, close to restaurants and convenience stores, shopping malls, highways, St. Jacobs Farmers Market, entertainment, and so much more! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T19:29:10.453555+00:00"
+"Directions": "Northfield Dr E and Bridge St W"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2025-12-11T16:41:05Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-11T16:41:05Z"
+"Stories": "1.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1547418772"
"RoomType" => "Primary Bedroom"
"ListingId" => "40793510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179982"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T16:38:17.75Z"
]
1 => array:11 [
"RoomKey" => "1547418773"
"RoomType" => "Living room"
"ListingId" => "40793510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179982"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T16:38:17.75Z"
]
2 => array:11 [
"RoomKey" => "1547418774"
"RoomType" => "Kitchen"
"ListingId" => "40793510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179982"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T16:38:17.75Z"
]
3 => array:11 [
"RoomKey" => "1547418775"
"RoomType" => "Bedroom"
"ListingId" => "40793510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179982"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T16:38:17.75Z"
]
4 => array:11 [
"RoomKey" => "1547418776"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179982"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T16:38:17.75Z"
]
5 => array:11 [
"RoomKey" => "1547418777"
"RoomType" => "Full bathroom"
"ListingId" => "40793510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179982"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T16:38:17.76Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29179982/251-northfield-drive-unit-415b-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2250
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 835
+"OriginalEntryTimestamp": "2025-12-11T16:38:17.64Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:16 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6364250590"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/f3fcba489fe1e51656e99d8576046919.webp"
"MediaSize" => 118834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-f3fcba489fe1e51656e99d8576046919.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.95Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6364250605"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/39752cecf2e792f7fbbd900963058d7f.webp"
"MediaSize" => 133232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-39752cecf2e792f7fbbd900963058d7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.96Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6364250621"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/6e2fcaa8202d6b0f98db1a99b0cf03fa.webp"
"MediaSize" => 91941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-6e2fcaa8202d6b0f98db1a99b0cf03fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.93Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6364250633"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/7c3b99687018be7fb6c742b977f0123c.webp"
"MediaSize" => 101341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-7c3b99687018be7fb6c742b977f0123c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.96Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6364250659"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/e1fa6d0d140c9bdf1c8de2ca12fba072.webp"
"MediaSize" => 99237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-e1fa6d0d140c9bdf1c8de2ca12fba072.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.96Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6364250680"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/ecb7e25cd072da5ad55511d657b5172c.webp"
"MediaSize" => 83742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-ecb7e25cd072da5ad55511d657b5172c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.96Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6364250704"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/ebc6d6322638f2eaab1893e22b27cc0f.webp"
"MediaSize" => 51818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-ebc6d6322638f2eaab1893e22b27cc0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.97Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6364250721"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/67e539e81bdd88ebf65130f6f93073ad.webp"
"MediaSize" => 66664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-67e539e81bdd88ebf65130f6f93073ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.96Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6364250741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/d2b5105a603445143a3b47ea3eb08067.webp"
"MediaSize" => 60279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-d2b5105a603445143a3b47ea3eb08067.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.93Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6364250771"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/df51660685276004f469b2d0328bcb40.webp"
"MediaSize" => 58181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-df51660685276004f469b2d0328bcb40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.96Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6364250809"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/3479e14b11c78379628dc81630e5fa37.webp"
"MediaSize" => 80897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-3479e14b11c78379628dc81630e5fa37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.96Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6364250832"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/47c7b3d0ac2dc874a81dd02ca38356e8.webp"
"MediaSize" => 64583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-47c7b3d0ac2dc874a81dd02ca38356e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.95Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6364250848"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/779d4b1b86dc7f9c0cff3b987f9ba728.webp"
"MediaSize" => 141588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-779d4b1b86dc7f9c0cff3b987f9ba728.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.95Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6364250877"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/5d492b2e57abc24ed2b00a1da2d863c3.webp"
"MediaSize" => 41681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-5d492b2e57abc24ed2b00a1da2d863c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.96Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6364250900"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/988f3817dde66f5c056390110488e30d.webp"
"MediaSize" => 36784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-988f3817dde66f5c056390110488e30d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:05.23Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6364250909"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179982/387675efdcd2abe0d02f19488ca43ae4.webp"
"MediaSize" => 27888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179982/thumbnail-387675efdcd2abe0d02f19488ca43ae4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793510"
"ResourceRecordKey" => "29179982"
"ModificationTimestamp" => "2025-12-11T16:41:02.96Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "William Prokopowicz"
"MemberFirstName" => "William"
"MemberLastName" => "Prokopowicz"
"MemberMlsId" => "KWkw1968"
"OriginatingSystemName" => 26
"MemberKey" => "2180308"
"ModificationTimestamp" => "2025-12-11T01:31:05Z"
"MemberStatus" => "Active"
"OfficeKey" => "283397"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Waterloo"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-897-3019"
"MemberSocialMedia" => array:3 [ …3]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2022-12-06T13:44:00Z"
"MemberNationalAssociationId" => "1430151"
"OfficeNationalAssociationId" => "1328541"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "Chestnut Park Realty Southwestern Ontario Ltd., Brokerage"
"OfficePhone" => "519-804-7200"
"OfficeMlsId" => "KW37"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "283397"
"ModificationTimestamp" => "2025-11-25T18:19:52Z"
"OfficeAddress1" => "75 King Street South Unit 50"
"OfficeCity" => "Waterloo"
"OfficePostalCode" => "N2J1P"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"OfficeFax" => "519-885-1251"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:3 [ …3]
"OriginalEntryTimestamp" => "2018-04-25T19:05:00Z"
"OfficeNationalAssociationId" => "1328541"
"OfficeBrokerNationalAssociationId" => "1173922"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29179982')"
+"ID": "475760"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283397/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283397&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283397/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283397&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25432
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25434
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Chestnut Park Realty Southwestern Ontario Ltd., Brokerage"
+"OfficeEmail": null
+"OfficePhone": "519-804-7200"
+"OfficeMlsId": "KW37"
+"ModificationTimestamp": "2025-11-25T18:19:52Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283397"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "75 King Street South Unit 50"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2J1P"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1328541"
+"OriginalEntryTimestamp": "2018-04-25T19:05:00Z"
+"OfficeFax": "519-885-1251"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:3 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "277320"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283397"
"SocialMediaUrlOrId" => "http://www.chestnutparkwest.com/"
"ModificationTimestamp" => "2025-11-25T17:07:00Z"
]
1 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "446747"
"SocialMediaType" => "FaceBook"
"ResourceRecordKey" => "283397"
"SocialMediaUrlOrId" => "https://www.facebook.com/ChestnutParkWest"
"ModificationTimestamp" => "2025-11-25T17:07:00Z"
]
2 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "340834"
"SocialMediaType" => "Instagram"
"ResourceRecordKey" => "283397"
"SocialMediaUrlOrId" => "https://www.instagram.com/chestnutprkwest/"
"ModificationTimestamp" => "2025-11-25T17:07:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1173922"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('283397')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2180308/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2180308&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2180308/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2180308&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25437
+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 29179982" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25073
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29179982/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29179982&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29179982/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29179982&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25053
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29179982 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5213246 43.5104707)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29179982 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5213246 43.5104707)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29179982 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5213246 43.5104707)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29179982 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5213246 43.5104707)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25287
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24971
+post_id: "484067"
+post_author: 1
+"ListingKey": "29188535"
+"ListingId": "40794079"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T21:40:39Z"
+"RFModificationTimestamp": "2025-12-16T21:43:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.076
+"LivingArea": 2400.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2Y7"
+"UnparsedAddress": "486B KINGSCOURT Drive, Waterloo, Ontario N2K2Y7"
+"Coordinates": array:2 [
0 => -80.5215279
1 => 43.4953314
]
+"Latitude": 43.4953314
+"Longitude": -80.5215279
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into the welcoming space at 486B Kingscourt Drive, situated in the vibrant community of Waterloo. This delightful 3+1-bedroom, 2-bathroom home invites you to experience comfort and convenience in a prime location. As you step inside, you'll be greeted by an inviting living space, perfect for both relaxation and entertaining guests. The kitchen comes fully equipped with everything you need, while ample natural light floods the space, creating a warm and inviting atmosphere. Kitchen appliances include Stove, Built-in microwave and Refrigerator. This house comes with pristine hardwood floors on all levels and laundry in the basement. The bedrooms are spacious with plenty of storage space and offer a serene retreat. The bathroom is modern and well-appointed, ensuring your comfort and convenience. Step outside onto your fully fenced private yard, where you can enjoy your morning coffee or soak up the sunshine in peace. Store your extras in the garden shed and large storage room in the basement. There are shopping, dining, and entertainment options just moments away, everything you need is within easy reach. Get ready to experience the charm of this home. It is close to Conestoga Mall, University of Waterloo and Wifrid Laurier University, KidsAbility, Schools, Parks, Golf Course & other Amenities. Schedule a viewing today and discover your new home in Waterloo. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-16T03:28:56.687586+00:00"
+"Directions": "From Lexington Road turn left on Davenport Road and left on Kingscourt Drive"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072201"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.076"
+"PhotosChangeTimestamp": "2025-12-16T02:28:48Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-16T21:38:25Z"
+"Stories": "1.0"
+"StreetName": "KINGSCOURT"
+"StreetNumber": "486"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3494"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1550079882"
"RoomType" => "Storage"
"ListingId" => "40794079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.93Z"
]
1 => array:11 [
"RoomKey" => "1550079883"
"RoomType" => "Bedroom"
"ListingId" => "40794079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.94Z"
]
2 => array:11 [
"RoomKey" => "1550079884"
"RoomType" => "Bedroom"
"ListingId" => "40794079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.94Z"
]
3 => array:11 [
"RoomKey" => "1550079885"
"RoomType" => "Bedroom"
"ListingId" => "40794079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.95Z"
]
4 => array:11 [
"RoomKey" => "1550079886"
"RoomType" => "3pc Bathroom"
"ListingId" => "40794079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.95Z"
]
5 => array:11 [
"RoomKey" => "1550079887"
"RoomType" => "Laundry room"
"ListingId" => "40794079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.95Z"
]
6 => array:11 [
"RoomKey" => "1550079888"
"RoomType" => "Bedroom"
"ListingId" => "40794079"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
7 => array:11 [
"RoomKey" => "1550079889"
"RoomType" => "3pc Bathroom"
"ListingId" => "40794079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
8 => array:11 [
"RoomKey" => "1550079890"
"RoomType" => "Recreation room"
"ListingId" => "40794079"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 25'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
9 => array:11 [
"RoomKey" => "1550079891"
"RoomType" => "Kitchen"
"ListingId" => "40794079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
10 => array:11 [
"RoomKey" => "1550079892"
"RoomType" => "Living room/Dining room"
"ListingId" => "40794079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 24'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29188535/486b-kingscourt-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2999
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1300
+"BelowGradeFinishedArea": 1100
+"OriginalEntryTimestamp": "2025-12-16T02:28:48.18Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"Media": array:33 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6371135802"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/f351d75a58213cf3aab556205df57383.webp"
"MediaSize" => 95826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-f351d75a58213cf3aab556205df57383.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of property featuring brick siding and driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6371135803"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/c0fbd8747164f4d4bec337e93bfa4718.webp"
"MediaSize" => 37575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-c0fbd8747164f4d4bec337e93bfa4718.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room with stairway and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6371135805"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/466e96ad6f75d4008855110504093ba3.webp"
"MediaSize" => 72032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-466e96ad6f75d4008855110504093ba3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen view of electric stove and light stone countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6371135807"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/cfe648557cc05b203e471f0e7e761219.webp"
"MediaSize" => 44812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-cfe648557cc05b203e471f0e7e761219.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Below grade area featuring light wood finished floors, recessed lighting, and stairway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6371135809"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/c9f3f4ec5cdb4516ab87cd55eed61fdd.webp"
"MediaSize" => 43835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-c9f3f4ec5cdb4516ab87cd55eed61fdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished basement featuring baseboards and dark wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6371135811"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/eef7764171e21988ea8a6a0fafbff88d.webp"
"MediaSize" => 30716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-eef7764171e21988ea8a6a0fafbff88d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of storage area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6371135813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/1a14fe6da7b54eb2bf146b2600b88104.webp"
"MediaSize" => 71837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-1a14fe6da7b54eb2bf146b2600b88104.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with stove, dark cabinetry, refrigerator, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6371135815"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/d5f17063a294a4dacbdbc958cc38d9f2.webp"
"MediaSize" => 35665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-d5f17063a294a4dacbdbc958cc38d9f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring light wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6371135817"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/c5c75daa6e7607a3a646fe28a6e6779b.webp"
"MediaSize" => 40666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-c5c75daa6e7607a3a646fe28a6e6779b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase featuring baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6371135819"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/fb06696facf506589203828136d4564b.webp"
"MediaSize" => 44190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-fb06696facf506589203828136d4564b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room with stairway, wood-type flooring, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6371135820"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/ee7976945b59af2b9dd429d63043a79c.webp"
"MediaSize" => 37450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-ee7976945b59af2b9dd429d63043a79c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room featuring wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6371135821"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/c14681a69dffd16ef849ba2a0f4e4dbb.webp"
"MediaSize" => 31201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-c14681a69dffd16ef849ba2a0f4e4dbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring baseboards and dark wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6371135822"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/420a487262a63d8fff0c9842796943c7.webp"
"MediaSize" => 31245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-420a487262a63d8fff0c9842796943c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom with a closet and dark wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6371135823"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/e031bb4a62e36e1e2d9aacefdb658aa6.webp"
"MediaSize" => 29877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-e031bb4a62e36e1e2d9aacefdb658aa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6371135824"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/6b62c01fd19d4c3a30451b0966cda675.webp"
"MediaSize" => 63885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-6b62c01fd19d4c3a30451b0966cda675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with light tile patterned flooring, shower / bathtub combination with curtain, and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6371135825"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/a6785c317aaac0df38d88a5c4536784e.webp"
"MediaSize" => 46711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-a6785c317aaac0df38d88a5c4536784e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom view of tiled shower"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6371135826"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/6a81526df526f3d057e7e200b96f9271.webp"
"MediaSize" => 38832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-6a81526df526f3d057e7e200b96f9271.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with dark wood-type flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6371135827"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/437d09249caf90d31722b19e0e2307c5.webp"
"MediaSize" => 33655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-437d09249caf90d31722b19e0e2307c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with dark wood-type flooring and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6371135828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/c794b9e226cfd20894cdabca7c54c4b8.webp"
"MediaSize" => 33150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-c794b9e226cfd20894cdabca7c54c4b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring shower combination, vanity, and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6371135829"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/187bcc7a76f3804cc6e2b2b62d0ec4be.webp"
"MediaSize" => 29552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-187bcc7a76f3804cc6e2b2b62d0ec4be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with a stall shower and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6371135830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/304b1c35d62b76013469426c7305d624.webp"
"MediaSize" => 62681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-304b1c35d62b76013469426c7305d624.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen view of stainless steel appliances, dark countertops, and tasteful backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6371135831"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/236de7719d1dd15e6480d3b8132d0c30.webp"
"MediaSize" => 32051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-236de7719d1dd15e6480d3b8132d0c30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with toilet and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6371135832"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/c0b95f79d1a61c86c1937cfc435e03c2.webp"
"MediaSize" => 38375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-c0b95f79d1a61c86c1937cfc435e03c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6371135833"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/d644866af23ce52f68106e7ddf4dcaf3.webp"
"MediaSize" => 42466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-d644866af23ce52f68106e7ddf4dcaf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6371135834"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/d27916b1b6ca64880f1911d9178ab973.webp"
"MediaSize" => 57782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-d27916b1b6ca64880f1911d9178ab973.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6371135835"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/54c241aca0f6c7a8472150de03e143ab.webp"
"MediaSize" => 64913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-54c241aca0f6c7a8472150de03e143ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring dark cabinets, light tile patterned flooring, fridge, and dark countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6371135836"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/c92c8fec1209c561c8a7581d449e60d5.webp"
"MediaSize" => 39718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-c92c8fec1209c561c8a7581d449e60d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with light wood-style floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6371135837"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/506b090520c13910f9f45070b3d3a062.webp"
"MediaSize" => 35939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-506b090520c13910f9f45070b3d3a062.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6371135838"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/7a18febbad12ae8ce6f93db578290e08.webp"
"MediaSize" => 59316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-7a18febbad12ae8ce6f93db578290e08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom featuring hardwood / wood-style floors, a drop ceiling, and a closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6371135839"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/80a41fce3e59cef395ade974ef28e12f.webp"
"MediaSize" => 104022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-80a41fce3e59cef395ade974ef28e12f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard with a storage shed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6371135840"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/0924b180c3f42f64ccee6fc3b18f9bb6.webp"
"MediaSize" => 32005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-0924b180c3f42f64ccee6fc3b18f9bb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Corridor with light wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6371135841"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/cdf6a88ffd32b50b1656da152f55833b.webp"
"MediaSize" => 30609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-cdf6a88ffd32b50b1656da152f55833b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Half bath featuring vanity and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6371135842"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/8aa0ed1114821cf9b1ab0b2138493cf4.webp"
"MediaSize" => 52258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-8aa0ed1114821cf9b1ab0b2138493cf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry area with water heater, independent washer and dryer, and concrete flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "Sunanda Sachdev"
"MemberFirstName" => "Sunanda"
"MemberLastName" => "Sachdev"
"MemberMlsId" => "KWkw1026"
"OriginatingSystemName" => 26
"MemberKey" => "2072201"
"ModificationTimestamp" => "2024-09-27T19:10:01Z"
"MemberStatus" => "Active"
"OfficeKey" => "86262"
"JobTitle" => "Salesperson"
"MemberAOR" => "Waterloo Region"
"MemberCity" => "KITCHENER"
"MemberType" => "Salesperson"
"MemberAORKey" => "16"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-503-5689"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2019-04-17T13:01:00Z"
"MemberNationalAssociationId" => "1347350"
"OfficeNationalAssociationId" => "1004415"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "KELLER WILLIAMS INNOVATION REALTY"
"OfficePhone" => "519-570-4447"
"OfficeMlsId" => "KW261"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "86262"
"ModificationTimestamp" => "2025-08-19T15:50:12Z"
"OfficeAddress1" => "640 RIVERBEND DR."
"OfficeCity" => "KITCHENER"
"OfficePostalCode" => "N2K3S"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
…3
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29188535')"
+"ID": "484067"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24952
+post_id: "481615"
+post_author: 1
+"ListingKey": "29185243"
+"ListingId": "X12632142"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T20:35:04Z"
+"RFModificationTimestamp": "2025-12-13T22:47:01Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "413 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.521297
1 => 43.510381
]
+"Latitude": 43.510381
+"Longitude": -80.521297
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "~ WELCOME TO BLACKSTONE CONDOS ~~ Stylish 1-Bedroom & 1 Bath Suite on the 4th Floor offering almost 600 SQFT with UNOBSTRUCTED 180 SKY VIEWS ~ enjoy your morning coffee or sunsets! Open-Concept Layout ~ Functional & Elegant Kitchen with Quartz Countertops, Subway Tile Backsplash, Stainless Steel Appliances & Undermount Sink Bright Living Area flowing seamlessly to Balcony Spacious Walk-In Closet + In-Suite Laundry + Front Hall Closet Modern 3-Pc Bath 1 Surface Parking Space Included~ LUXURY AMENITIES ~ Designer Lounge w/ Bar & Fireplace Fitness & Study Rooms Secure Bike Storage + Repair Station Pet Wash Station 2 Outdoor Lounges with BBQs & Hot Tub ~ Perfect for Entertaining!~ Bakery, Salon, Restaurants, Pub & Dental Office ~ All Just Steps Away!Minutes to Conestoga Mall, Public Library, RIM Park (sports & rec), Golf, Conservation Areas & Miles of Trails for Walking & Cycling. ~ Don't Miss This Opportunity! AVAILABLE IMMEDIATELY ~ (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-13T22:46:50.369270+00:00"
+"Directions": "Northfield & Bridge St W"
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Stone"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088809"
+"ListOfficeKey": "293791"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-13T20:22:38Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T20:22:38Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29185243/413-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2156054"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FIVE RIVERS PROPERTY MANAGEMENT GROUP INC."
+"CoListOfficeKey": "293791"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"BuildingFeatures": array:5 [
0 => "Exercise Centre"
1 => "Separate Electricity Meters"
2 => "Separate Heating Controls"
3 => "Party Room"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Controlled entry"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-13T20:22:38.4Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:37 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29185243')"
+"ID": "481615"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24964
+post_id: "478869"
+post_author: 1
+"ListingKey": "29183515"
+"ListingId": "X12630486"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T19:55:38Z"
+"RFModificationTimestamp": "2025-12-12T23:40:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "415 - 247 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.521945
1 => 43.509547
]
+"Latitude": 43.509547
+"Longitude": -80.521945
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and modern one-bedroom, one-bathroom corner unit on the 4th floor with large windows overlooking a serene landscaped courtyard. This stylish apartment features quality white cabinetry, sleek gray floors, in-unit laundry, and a private balcony. Located steps from a park with walking trails, a playground & a dog wash station, perfect for pet lovers and outdoor enthusiasts. Enjoy premium amenities, including a chic party room with a bar/lounge, a fitness room, a study/meeting room, an outdoor entertainment area & a rooftop terrace. Underground parking is included for your convenience. Easy access to the highway, RIM Park, Grey Silo Golf Club & more! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T23:39:50.467805+00:00"
+"Directions": "Cross Streets: Bridge St. W. ** Directions: Northfield E Drive and Bridge Street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101285"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-12-12T19:49:56Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T19:49:56Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29183515/415-247-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five River"
+"GeocodeManualYN": false
+"TotalActualRent": 1795
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-12T19:49:56.83Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29183515')"
+"ID": "478869"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24918
+post_id: "477497"
+post_author: 1
+"ListingKey": "29183318"
+"ListingId": "40793559"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T19:10:22Z"
+"RFModificationTimestamp": "2025-12-12T19:37:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 644.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "247 NORTHFIELD Drive E Unit# 415, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.5218345
1 => 43.5102257
]
+"Latitude": 43.5102257
+"Longitude": -80.5218345
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and modern one-bedroom, one-bathroom corner unit on the 4th floor with large windows overlooking a serene landscaped courtyard. This stylish apartment features quality white cabinetry, sleek gray floors, in-unit laundry, and a private balcony. Located steps from a park with walking trails, a playground & a dog wash station, perfect for pet lovers and outdoor enthusiasts. Enjoy premium amenities, including a chic party room with a bar/lounge, a fitness room, a study/meeting room, an outdoor entertainment area & a rooftop terrace. Underground parking is included for your convenience. Easy access to the highway, RIM Park, Grey Silo Golf Club & more! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "521"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T19:37:13.615169+00:00"
+"Directions": "Northfield E Drive and Bridge Street"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564314"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2025-12-12T19:00:28Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T19:00:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29183318/247-northfield-drive-e-unit-415-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1795
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 644
+"OriginalEntryTimestamp": "2025-12-12T19:00:27.37Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29183318')"
+"ID": "477497"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "475761"
+post_author: 1
+"ListingKey": "29180619"
+"ListingId": "40793474"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T19:05:43Z"
+"RFModificationTimestamp": "2025-12-11T19:19:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3R5"
+"UnparsedAddress": "455 KINGSCOURT Drive Unit# 3, Waterloo, Ontario N2K3R5"
+"Coordinates": array:2 [
0 => -80.5228476
1 => 43.4940991
]
+"Latitude": 43.4940991
+"Longitude": -80.5228476
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this cozy and spacious 2-bedroom, 2-bath townhome located in a quiet, family-friendly community in the heart of Waterloo’s highly desirable Lexington area. With bright living spaces, modern finishes, and convenient access to schools, parks, shopping, and transit, this home is perfect for young professionals, families, or anyone seeking comfort and convenience. Contact us today to see this rental unit! 2 Spacious Bedrooms (Master has walk-in closet) 2 Bathrooms 5 Appliances Included – Fridge, Stove, Dishwasher, Washer, and Dryer Ensuite Laundry – Enjoy private in-unit laundry Water Softener Included Eat-In Kitchen Large Bedrooms Google Smart thermostat Ample Natural Light – Bright and welcoming atmosphere Private Backyard patio 3 Parking Spots (1 in garage, 2 in driveway - Tandem) Snow & Lawn Maintenance are included ** Rent: $2500.00 Plus Utilities Available December 15th, 2025!! ** ***See sales brochure below below for showing instructions*** (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T19:19:00.425762+00:00"
+"Directions": "Lexington/Davenport"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T18:58:24Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-11T18:58:24Z"
+"Stories": "2.0"
+"StreetName": "KINGSCOURT"
+"StreetNumber": "455"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29180619/455-kingscourt-drive-unit-3-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2500
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 15.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2025-12-11T18:58:24.33Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:22 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29180619')"
+"ID": "475761"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24893
+post_id: "472969"
+post_author: 1
+"ListingKey": "29176263"
+"ListingId": "40793134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T03:35:53Z"
+"RFModificationTimestamp": "2025-12-10T04:33:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 581.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "251 NORTHFIELD Drive E Unit# 410, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.52132
1 => 43.5105097
]
+"Latitude": 43.5105097
+"Longitude": -80.52132
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience this exquisite one-bedroom condo in Waterloo's vibrant center, where contemporary design meets sophisticated living. The south west facing orientation captures abundant sunlight throughout the day, enhancing the already stunning open-concept space. Entertain with ease in the living area where expansive windows bathe the room in natural light, creating a refreshing and spacious ambiance. The kitchen stands as a culinary masterpiece with its premium stainless steel appliances, elegant quartz countertops, stylish backsplash, and generous workspace that transforms meal preparation into a pleasure. Throughout the unit, high-end finishes and meticulous attention to detail showcase the numerous quality upgrades. The spacious balcony overlooks a serene courtyard, providing the perfect retreat for unwinding and savoring beautiful sunset views thanks to its southwestern exposure. Inside, the bedroom combines practicality with elegance, featuring an impressive walk-in closet that addresses all storage requirements. The luxurious bathroom complements the space with its inviting soaker tub and extensive counter area for added functionality. This residence embodies the perfect blend of luxury, accessibility, and refined style in an ideal Waterloo location. Enjoy proximity to Dining, Conestoga Mall, St. Jacobs Farmers Market, Rim Park and numerous other attractions, making this sophisticated condo the perfect place to call home. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"AssociationFee": "477"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T04:33:32.103850+00:00"
+"Directions": "Northfield Drive and Bridge Street"
+"ExteriorFeatures": array:2 [
0 => "Metal"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2082150"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-10T03:29:23Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T03:29:23Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ZR9waXEZVbw"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29176263/251-northfield-drive-e-unit-410-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2180308"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"TotalActualRent": 1950
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 581
+"OriginalEntryTimestamp": "2025-12-10T03:29:23.27Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:33 [
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]
]
+"Member": array:1 [
0 => array:25 [ …25]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29176263')"
+"ID": "472969"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23647
+post_id: "468750"
+post_author: 1
+"ListingKey": "29170241"
+"ListingId": "40791913"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T14:40:52Z"
+"RFModificationTimestamp": "2025-12-08T14:43:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1559.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4A2"
+"UnparsedAddress": "447 BRIGANTINE Drive, Waterloo, Ontario N2K4A2"
+"Coordinates": array:2 [
0 => -80.5109197
1 => 43.5063641
]
+"Latitude": 43.5063641
+"Longitude": -80.5109197
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Perfect for families or professionals, this full-home rental is set within one of Waterloo’s most sought-after neighbourhoods. The thoughtfully designed floor plan includes 3 above-grade bedrooms, including a generous primary suite featuring a walk-in closet and private ensuite, with a second full bathroom completing the upper level. The main floor offers a bright, functional layout with a dining room, living room, kitchen, and a convenient powder room. The large front hallway closet provides exceptional storage for all your family’s needs, and the kitchen offers ample cabinetry, including a convenient pantry. Skylights bring in abundant natural light, creating a warm and inviting atmosphere, and a walkout leads to a deck overlooking a beautifully maintained garden and fully fenced backyard—ideal for relaxing, barbecuing, or entertaining. The finished basement enhances the home’s versatility with a fourth bedroom or flex room, a full bathroom, a wet bar, a laundry area, and a generous family room with a cozy gas fireplace—perfect for guests, a home office, or additional recreational space. Located close to top-rated schools, RIM Park, golf courses, trails, the river, shopping, dining, Conestoga Mall, Uptown Waterloo, and convenient public transit, this home also offers quick access to Hwy 7/8 and both universities, combining comfort, convenience, and an unbeatable location to create an exceptional place to call home. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Freezer"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T14:43:19.127196+00:00"
+"Directions": "Bridge St. W., to Chesapeake Drive, to Brigantine Drive"
+"ExteriorFeatures": array:3 [
0 => "Vinyl siding"
1 => "Shingles"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101905"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Skylight"
3 => "Sump Pump"
4 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T12:58:33Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T14:30:00Z"
+"Stories": "2.0"
+"StreetName": "BRIGANTINE"
+"StreetNumber": "447"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4822"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/447_brigantine_dr_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/29170241/447-brigantine-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1908292"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 1559
+"OriginalEntryTimestamp": "2025-12-08T12:58:32.94Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:42 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29170241')"
+"ID": "468750"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: "467668"
+post_author: 1
+"ListingKey": "29169156"
+"ListingId": "40792688"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T20:45:06Z"
+"RFModificationTimestamp": "2025-12-06T22:44:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 584.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "251 E NORTHFIELD Drive E Unit# 504, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5214174
1 => 43.5105266
]
+"Latitude": 43.5105266
+"Longitude": -80.5214174
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Lief / Lamont model at 251 Northfield Dr E, Waterloo. One bedroom + den in a Sentral building with a practical layout, private balcony, and modern finishes. The den is suitable for a small office or storage. In-suite stacked washer/dryer combo included. Tenants have access to amenities including a gym, party lounge, bike storage room, and a furnished outdoor terrace with BBQs and a gas fire pit for summer use. Unit includes 1 underground parking spot + 1 locker. Internet included. Convenient location with close proximity to St. Jacob’s Farmers Market, Conestoga Mall, LRT, RIM Park, Grey Silo Golf Course, and nearby walking/biking trails, as well as access to everyday necessities. Available for rent February 1, 2026. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T22:44:37.045568+00:00"
+"Directions": "Bridge St. W & Northfield Drive E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213806"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-06T20:38:24Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T20:38:24Z"
+"Stories": "1.0"
+"StreetDirPrefix": "East"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29169156/251-e-northfield-drive-e-unit-504-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2000
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 584
+"OriginalEntryTimestamp": "2025-12-06T20:38:24.19Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:18 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29169156')"
+"ID": "467668"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "462847"
+post_author: 1
+"ListingKey": "29163523"
+"ListingId": "X12601812"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T20:05:03Z"
+"RFModificationTimestamp": "2025-12-04T20:24:54Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G6"
+"UnparsedAddress": "559 CHESAPEAKE DRIVE, Waterloo, Ontario N2K4G6"
+"Coordinates": array:2 [
0 => -80.5057891
1 => 43.5095071
]
+"Latitude": 43.5095071
+"Longitude": -80.5057891
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning, custom-built by Cameo Homes, 3 bedroom, 3 bathroom home located across from two of Waterloo's highly rated schools in Prime Eastbridge, best family neighbourhood! Exterior is all stone and brick with a grand entrance and impressive street curb appeal. Upon entering you will be greeted by the 2 storey open foyer with glass panel staircase and a sun-filled contemporary main floor that offers 9' ceilings and a unique open design featuring large Living Rom with gas fireplace, Dining Room, Family Room with vaulted ceiling open to above, and sliders to a large pool-sized backyard with gas line for BBQ. The large maple Kitchen seamlessly blends with the open area and is equipped with Stainless Steel appliances, ample cabinets, pantry, centre island and lots of counter space. It's a great open main floor to entertain family and friends. The upper level features 3 generous sized Bedrooms including large Primary with walk-in closet, 4 piece luxury Ensuite with corner Whirlpool tub and stand-up shower. Recent updates include roof (2018), water heater owned (2020) & sump pump (2025). Internet cabling (CAT-5-E) throughout the house and COAX cabling (6-R-G). Located minutes to RIM Park, Conestoga Mall, Grey Silo Golf course, Grand River trails, soccer fields and quick access to major highways. (id:62650)"
+"Appliances": array:16 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Range"
7 => "Dryer"
8 => "Microwave"
9 => "Freezer"
10 => "Oven - Built-In"
11 => "Hood Fan"
12 => "Blinds"
13 => "Garage door opener"
14 => "Garage door opener remote(s)"
15 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T20:24:46.041627+00:00"
+"Directions": "Cross Streets: New Bedford Drive. ** Directions: University Avenue East to New Bedford Drive to Chesapeake Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2244502"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "40.9 x 41 FT ; 132.26 x 40.08 x 139.68 x 40.97 feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T19:57:18Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T19:57:18Z"
+"Stories": "2.0"
+"StreetName": "Chesapeake"
+"StreetNumber": "559"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5995"
+"VirtualTourURLUnbranded": "https://milkmanmedia.hd.pics/559-Chesapeake-Dr"
+"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": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29163523/559-chesapeake-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.1
+"OriginalEntryTimestamp": "2025-12-04T19:57:18.88Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29163523')"
+"ID": "462847"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 62
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]