array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29185243/Property?$select=ALL&$top=20&$filter=ListingKey eq 29185243&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29185243/Property?$select=ALL&$top=20&$filter=ListingKey eq 29185243&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23632
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23634
+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 [
"RoomKey" => "1548529903"
"RoomType" => "Kitchen"
"ListingId" => "X12632142"
"RoomLevel" => "Main level"
"RoomWidth" => 3.57
"ListingKey" => "29185243"
"RoomLength" => 2.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-13T20:22:38.47Z"
]
1 => array:11 [
"RoomKey" => "1548529904"
"RoomType" => "Living room"
"ListingId" => "X12632142"
"RoomLevel" => "Main level"
"RoomWidth" => 2.96
"ListingKey" => "29185243"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-13T20:22:38.47Z"
]
2 => array:11 [
"RoomKey" => "1548529905"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12632142"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29185243"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-13T20:22:38.47Z"
]
3 => array:11 [
"RoomKey" => "1548529906"
"RoomType" => "Bathroom"
"ListingId" => "X12632142"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "29185243"
"RoomLength" => 1.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-13T20:22:38.47Z"
]
4 => array:11 [
"RoomKey" => "1548529907"
"RoomType" => "Laundry room"
"ListingId" => "X12632142"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29185243"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-13T20:22:38.47Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6367639373"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/171b105b5d12d552f1cfc27a4a3a5aa9.webp"
"MediaSize" => 179916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-171b105b5d12d552f1cfc27a4a3a5aa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6367639377"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/094d2d841e766f759a1e684ad4e73e9c.webp"
"MediaSize" => 194350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-094d2d841e766f759a1e684ad4e73e9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6367639383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/e6a51b8132a1f3c1df666551c99dee6c.webp"
"MediaSize" => 151758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-e6a51b8132a1f3c1df666551c99dee6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6367639390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/4c0ae98069391b9617cc33b3a4a17ed7.webp"
"MediaSize" => 131604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-4c0ae98069391b9617cc33b3a4a17ed7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6367639396"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/f377a8d741ebd70bcabc338d647e5dc9.webp"
"MediaSize" => 150691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-f377a8d741ebd70bcabc338d647e5dc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6367639402"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/bf55b2c3478563dcdca231f1be3faeb9.webp"
"MediaSize" => 181704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-bf55b2c3478563dcdca231f1be3faeb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6367639411"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/fca4bc4f2a17b8d4f2135af0cecccc72.webp"
"MediaSize" => 137033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-fca4bc4f2a17b8d4f2135af0cecccc72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6367639419"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/7a50851d61ac39c9aaf931f3255eba00.webp"
"MediaSize" => 149050
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-7a50851d61ac39c9aaf931f3255eba00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6367639427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/194c629dd9bfe1c5d24ee8e4595ce2c9.webp"
"MediaSize" => 209836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-194c629dd9bfe1c5d24ee8e4595ce2c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6367639434"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/3aecb2810e87020dedd9221465e20c57.webp"
"MediaSize" => 113817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-3aecb2810e87020dedd9221465e20c57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6367639440"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/a156b53c4cc13be16e4e4bdaab7d937b.webp"
"MediaSize" => 100683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-a156b53c4cc13be16e4e4bdaab7d937b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6367639447"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/7ffc12c517fff3a679b5a51e0a38ee85.webp"
"MediaSize" => 100569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-7ffc12c517fff3a679b5a51e0a38ee85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6367639458"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/5e19badb2c514720ad89fcd97aa77a0b.webp"
"MediaSize" => 110890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-5e19badb2c514720ad89fcd97aa77a0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6367639465"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/0f269ec7249fc27c5cebfdb54462fd02.webp"
"MediaSize" => 93622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-0f269ec7249fc27c5cebfdb54462fd02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6367639469"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/9860f42a3e1fd852b6138c69e40de75a.webp"
"MediaSize" => 86705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-9860f42a3e1fd852b6138c69e40de75a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6367639477"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/79b6ce37ef843eed83fe8250f081437f.webp"
"MediaSize" => 101635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-79b6ce37ef843eed83fe8250f081437f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6367639482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/79e50adedcf07d1951bf8a17c23eeed5.webp"
"MediaSize" => 79910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-79e50adedcf07d1951bf8a17c23eeed5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6367639487"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/d9c326106ac290d415de01c40d5df98e.webp"
"MediaSize" => 79737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-d9c326106ac290d415de01c40d5df98e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6367639492"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/ed216bb7cbdf3d2e7e03ffabba559100.webp"
"MediaSize" => 163881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-ed216bb7cbdf3d2e7e03ffabba559100.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6367639497"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/10a8c6122f15ae695cdbde090120070d.webp"
"MediaSize" => 65588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-10a8c6122f15ae695cdbde090120070d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6367639501"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/b65e3d115c2cfe07b0817e07e54c36bd.webp"
"MediaSize" => 119660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-b65e3d115c2cfe07b0817e07e54c36bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6367639505"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/c049c6ab734f135979f297159f19b256.webp"
"MediaSize" => 170077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-c049c6ab734f135979f297159f19b256.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6367639510"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/80715fff6845bd10ad40f088502f457b.webp"
"MediaSize" => 160045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-80715fff6845bd10ad40f088502f457b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6367639515"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/d9bc26f5e600b0351af181cd02db55aa.webp"
"MediaSize" => 190127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-d9bc26f5e600b0351af181cd02db55aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6367639519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/10afd40103710207affbff5c0e9031ed.webp"
"MediaSize" => 104758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-10afd40103710207affbff5c0e9031ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6367639525"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/c22e3366117e75202201c82e63882cd5.webp"
"MediaSize" => 169339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-c22e3366117e75202201c82e63882cd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6367639529"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/d42a240b501a13bc2676da83d7e301c1.webp"
"MediaSize" => 150652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-d42a240b501a13bc2676da83d7e301c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6367639531"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/a87ade5965f5585c5188f56139f63f4b.webp"
"MediaSize" => 220131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-a87ade5965f5585c5188f56139f63f4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6367639535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/7734b82403503df018c1c881c79f99b2.webp"
"MediaSize" => 146833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-7734b82403503df018c1c881c79f99b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6367639540"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/969c89145efd5b071ac41093abfae571.webp"
"MediaSize" => 147411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-969c89145efd5b071ac41093abfae571.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6367639544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/5ada4015287e10d825d1a09f743e4f93.webp"
"MediaSize" => 186820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-5ada4015287e10d825d1a09f743e4f93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6367639548"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/ab058146bb5b8b019cfcfcbe35ef4109.webp"
"MediaSize" => 155013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-ab058146bb5b8b019cfcfcbe35ef4109.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6367639551"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/c9d069a055b5bd98f5ff5868c219f784.webp"
"MediaSize" => 174061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-c9d069a055b5bd98f5ff5868c219f784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6367639555"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/e98c3a97bed0d4addc62f8d0dd61ccb5.webp"
"MediaSize" => 168521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-e98c3a97bed0d4addc62f8d0dd61ccb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6367639567"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/681a95787ab4e6b75aab8ae44c655690.webp"
"MediaSize" => 202340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-681a95787ab4e6b75aab8ae44c655690.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6367639570"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/f96348e4c6af21bbb7b1bb1fb299c261.webp"
"MediaSize" => 194441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-f96348e4c6af21bbb7b1bb1fb299c261.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6367639573"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29185243/0953425bda9f9fae12eaebd7ea9af740.webp"
"MediaSize" => 327445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29185243/thumbnail-0953425bda9f9fae12eaebd7ea9af740.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12632142"
"ResourceRecordKey" => "29185243"
"ModificationTimestamp" => "2025-12-13T20:22:38.41Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "HARUJJAL SIDHU"
"MemberFirstName" => "HARUJJAL"
"MemberLastName" => "SIDHU"
"MemberMlsId" => "9598889"
"OriginatingSystemName" => 26
"MemberKey" => "2088809"
"ModificationTimestamp" => "2025-12-15T10:07:53Z"
"MemberStatus" => "Active"
"OfficeKey" => "293791"
"MemberAOR" => "Toronto"
"JobTitle" => "Broker"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:3 [ …3]
"MemberOfficePhone" => "905-952-2055"
"MemberTollFreePhone" => "647-916-3300"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2020-02-25T23:12:00Z"
"MemberNationalAssociationId" => "1362130"
"OfficeNationalAssociationId" => "1431518"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "PONTIS REALTY INC."
"OfficePhone" => "905-952-2055"
"OfficeMlsId" => "427100"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "293791"
"ModificationTimestamp" => "2025-11-01T02:52:32Z"
"OfficeAddress1" => "7275 RAPISTAN COURT"
"OfficeCity" => "MISSISSAUGA"
"OfficePostalCode" => "L5N5Z"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2023-01-06T22:17:00Z"
"OfficeNationalAssociationId" => "1431518"
"FranchiseNationalAssociationId" => "1230730"
"OfficeBrokerNationalAssociationId" => "1114355"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29185243')"
+"ID": "481615"
}
]
+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 293791/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293791&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293791/Office?$select=ALL&$top=10&$filter=OfficeKey eq 293791&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25471
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25473
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "PONTIS REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-952-2055"
+"OfficeMlsId": "427100"
+"ModificationTimestamp": "2025-11-01T02:52:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293791"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "7275 RAPISTAN COURT"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5N5Z"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1431518"
+"OriginalEntryTimestamp": "2023-01-06T22:17:00Z"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "262013"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "293791"
"SocialMediaUrlOrId" => "http://www.pontisrealty.com/"
"ModificationTimestamp" => "2025-10-31T22:41:00Z"
]
]
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1114355"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('293791')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2088809/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2088809&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2088809/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2088809&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25476
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29185243" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25091
+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 29185243/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29185243&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29185243/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29185243&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25071
+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 29185243 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521297 43.510381)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29185243 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521297 43.510381)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29185243 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521297 43.510381)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29185243 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.521297 43.510381)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25008
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25025
+post_id: "487319"
+post_author: 1
+"ListingKey": "29192639"
+"ListingId": "40794242"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T21:15:21Z"
+"RFModificationTimestamp": "2025-12-17T22:55:16Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 854.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "255 NORTHFIELD Drive E Unit# 407, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5212228
1 => 43.511129
]
+"Latitude": 43.511129
+"Longitude": -80.5212228
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover modern living at its finest at Blackstone Condos in Waterloo East! Built in 2020, this stunning 2-bed, 2-bath unit offers over 850 sqft of open-concept space with 9' ceilings, large windows, and a private balcony that fills the home with beautiful natural light. The sleek kitchen features white cabinetry, quartz countertops, stainless steel appliances, and a subway tile backsplash, complemented by premium laminate flooring throughout. The spacious layout includes a primary bedroom with ensuite and a second bedroom with a nicely sized closet, plus in-suite laundry for added convenience. Enjoy upscale amenitiesfitness center, co-working space, event lounge, bike storage, and a rooftop terrace with BBQs, fire pit, and courtyard views. Steps to Browns Socialhouse, shops, transit, and minutes to St. Jacobs Market, trails, and highways. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "648"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T22:54:59.167978+00:00"
+"Directions": "Bridge St W and Northfield Dr E"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130012"
+"ListOfficeKey": "283981"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-17T21:08:23Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T21:08:23Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3754"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1550530082"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.57Z"
]
1 => array:11 [
"RoomKey" => "1550530083"
"RoomType" => "Living room"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.57Z"
]
2 => array:11 [
"RoomKey" => "1550530084"
"RoomType" => "Bedroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.58Z"
]
3 => array:11 [
"RoomKey" => "1550530085"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.58Z"
]
4 => array:11 [
"RoomKey" => "1550530086"
"RoomType" => "Primary Bedroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.58Z"
]
5 => array:11 [
"RoomKey" => "1550530087"
"RoomType" => "Kitchen"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29192639/255-northfield-drive-e-unit-407-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 854
+"OriginalEntryTimestamp": "2025-12-17T21:08:23.47Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:36 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6373648973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/54e8234adabc58cb794640760e93d88f.webp"
"MediaSize" => 82637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-54e8234adabc58cb794640760e93d88f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6373649047"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/bdda557086f5387924a5f87982914e68.webp"
"MediaSize" => 57635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-bdda557086f5387924a5f87982914e68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6373649116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/2d4d9abd26c5de9b8c0d04d966fe174a.webp"
"MediaSize" => 67357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-2d4d9abd26c5de9b8c0d04d966fe174a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6373649170"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/5698c9a2abc85ab90dd489184241f2fa.webp"
"MediaSize" => 76614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-5698c9a2abc85ab90dd489184241f2fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6373649236"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/9e0675e6bd61be97733bd5ad7e3ecd08.webp"
"MediaSize" => 80226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-9e0675e6bd61be97733bd5ad7e3ecd08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6373649291"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/f7a86e5501cedb42130368e5d183e028.webp"
"MediaSize" => 51074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-f7a86e5501cedb42130368e5d183e028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6373649325"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/c2d2dda3e09b050a03d82b5374ef6d10.webp"
"MediaSize" => 81686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-c2d2dda3e09b050a03d82b5374ef6d10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6373649365"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/5989be1d441fddae3ba311ba75ee6089.webp"
"MediaSize" => 68522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-5989be1d441fddae3ba311ba75ee6089.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6373649427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/ddbb99f02add7fee2300d88188a17eaf.webp"
"MediaSize" => 99731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-ddbb99f02add7fee2300d88188a17eaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6373649472"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/f2dc0e65cbe1ca18fa2d1b2f7ef7b990.webp"
"MediaSize" => 117274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-f2dc0e65cbe1ca18fa2d1b2f7ef7b990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6373649518"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/e8c30fcfb6c70d8fcd636c042b719591.webp"
"MediaSize" => 131386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-e8c30fcfb6c70d8fcd636c042b719591.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6373649551"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/93a396c5c622a6e87ccd3e58272f61e9.webp"
"MediaSize" => 119226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-93a396c5c622a6e87ccd3e58272f61e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6373649582"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/49792e6f7fe7336d7097612bd44eaf44.webp"
"MediaSize" => 69998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-49792e6f7fe7336d7097612bd44eaf44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6373649637"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/aaaf3b0bcc99b720c93e20bdd2f8eb6c.webp"
"MediaSize" => 51117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-aaaf3b0bcc99b720c93e20bdd2f8eb6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6373649656"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/86ab1f26ed325821c4fb362a255b3b5f.webp"
"MediaSize" => 53194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-86ab1f26ed325821c4fb362a255b3b5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6373649673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/97698dd279280612e64fe189932ac9e1.webp"
"MediaSize" => 81557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-97698dd279280612e64fe189932ac9e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6373649695"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/5e3cdf94f20a612fee249ccfa776bee3.webp"
"MediaSize" => 68539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-5e3cdf94f20a612fee249ccfa776bee3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6373649709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/72ff187b55b2b9d350edbbe7f5c7e1d3.webp"
"MediaSize" => 153986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-72ff187b55b2b9d350edbbe7f5c7e1d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6373649767"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/b2855cb20d3965ef1abfa11ef8dd3530.webp"
"MediaSize" => 122229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-b2855cb20d3965ef1abfa11ef8dd3530.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6373649816"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/acedb223354cf37960f1bc66e7b72ddf.webp"
"MediaSize" => 61861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-acedb223354cf37960f1bc66e7b72ddf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6373649859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/5ce5f81c6c838c3a760be1847311d9ab.webp"
"MediaSize" => 61850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-5ce5f81c6c838c3a760be1847311d9ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6373649896"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/9861abf58362ff18728f9e0278be5d25.webp"
"MediaSize" => 48751
"MediaType" => "webp"
…8
]
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:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192639')"
+"ID": "487319"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24955
+post_id: "487320"
+post_author: 1
+"ListingKey": "29192761"
+"ListingId": "X12639498"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T21:55:21Z"
+"RFModificationTimestamp": "2025-12-17T22:39:26Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "407 - 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": "Discover modern living at its finest at Blackstone Condos in Waterloo East! Built in 2020, this stunning 2-bed, 2-bath unit offers over 850 sqft of open-concept space with 9' ceilings, large windows, and a private balcony that fills the home with beautiful natural light. The sleek kitchen features white cabinetry, quartz countertops, stainless steel appliances, and a subway tile backsplash, complemented by premium laminate flooring throughout. The spacious layout includes a primary bedroom with ensuite and a second bedroom with a nicely sized closet, plus in-suite laundry for added convenience. Enjoy upscale amenitiesfitness center, co-working space, event lounge, bike storage, and a rooftop terrace with BBQs, fire pit, and courtyard views. Steps to Browns Socialhouse, shops, transit, and minutes to St. Jacobs Market, trails, and highwaysthis is contemporary comfort in the perfect location! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "648"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T22:39:25.446373+00:00"
+"Directions": "Bridge St W and Northfield Dr E"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967928"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-17T21:48:46Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T21:48:46Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3754"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29192761/407-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Separate Heating Controls"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-12-17T21:48:46.68Z"
+"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:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192761')"
+"ID": "487320"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25006
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …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:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29188535')"
+"ID": "484067"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25024
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25015
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"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 [ …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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29179982')"
+"ID": "475760"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23646
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24994
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25013
+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"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 65
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]