array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29829837 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1477911"
+post_author: 1
+"ListingKey": "29829837"
+"ListingId": "40834781"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:21:09Z"
+"RFModificationTimestamp": "2026-06-02T16:49:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 752.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H4"
+"UnparsedAddress": "251 NORTHFIELD Drive Unit# 419, Waterloo, Ontario N2K3H4"
+"Coordinates": array:2 [
0 => -80.5219761
1 => 43.5102218
]
+"Latitude": 43.5102218
+"Longitude": -80.5219761
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 251 Northfield Drive, Unit 419, a beautifully designed 2-bedroom, 2-bathroom condo now available for lease in the highly sought-after Sentral – Blackstone Modern Condominiums in Waterloo. Located just minutes from restaurants, shopping, entertainment, and transit, with easy access to scenic biking trails, the Grand River, and peaceful rural landscapes, it’s an ideal setting for professionals or small families seeking upscale living with modern comforts. Inside, the open-concept layout is enhanced by large windows and sliding doors that fill the space with natural light and lead to a private balcony—perfect for relaxing or entertaining. The primary bedroom features a walk-in closet and en-suite bathroom, while the second bedroom offers great flexibility for use as a guest room, office, or additional living space. Enjoy a modern kitchen equipped with quartz countertops and stainless steel appliances, along with the added convenience of in-suite laundry. Building amenities include: Fully equipped fitness centre, Stylish co-working space and great room, Bike room and secure bike storage, Dog wash station, Keyless entry and 24/7 on-site security, A stunning second-floor outdoor terrace in the Nord building with BBQs, a gas fire pit, and elegant seating for outdoor dining and socializing. Situated near RIM Park, Grey Silo Golf Club, St. Jacobs Farmers’ Market, and close to both University of Waterloo and Wilfrid Laurier University, this location offers both lifestyle and convenience. Highways 85 and 401 are easily accessible, making commuting a breeze. Don't miss the opportunity to lease in one of Waterloo’s most vibrant and amenity-rich communities. Book your private tour today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-30T22:36:35.304913+00:00"
+"Directions": "Corner of Bridge Street and Northfield Drive - Enter off of Bridge Street"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Industrial mall/subdivision"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-02T01:19:47Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:12:44Z"
+"Stories": "1.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1649781706"
"RoomType" => "4pc Bathroom"
"ListingId" => "40834781"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29829837"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:12:44.22Z"
]
1 => array:11 [
"RoomKey" => "1649781707"
"RoomType" => "Bedroom"
"ListingId" => "40834781"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29829837"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:12:44.22Z"
]
2 => array:11 [
"RoomKey" => "1649781708"
"RoomType" => "Full bathroom"
"ListingId" => "40834781"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29829837"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:12:44.22Z"
]
3 => array:11 [
"RoomKey" => "1649781709"
"RoomType" => "Primary Bedroom"
"ListingId" => "40834781"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29829837"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:12:44.22Z"
]
4 => array:11 [
"RoomKey" => "1649781710"
"RoomType" => "Living room"
"ListingId" => "40834781"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29829837"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 1510'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:12:44.22Z"
]
5 => array:11 [
"RoomKey" => "1649781711"
"RoomType" => "Kitchen"
"ListingId" => "40834781"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29829837"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:12:44.22Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29829837/251-northfield-drive-unit-419-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2150
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-05-30T21:31:28.57Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29829837_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/33ed95754ea69b1fe6a3d04c2be61cfe.webp"
"MediaSize" => 136361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-33ed95754ea69b1fe6a3d04c2be61cfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-05-30T21:31:28.57Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29829837_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/5160370db1758d2d52b02abf412b465e.webp"
"MediaSize" => 40641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-5160370db1758d2d52b02abf412b465e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:13.97Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29829837_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/39ed1dde2dbb134fc2e1f18faab101e0.webp"
"MediaSize" => 49604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-39ed1dde2dbb134fc2e1f18faab101e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:13.89Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29829837_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/9a84a812d9b44d5e7eab23be587d0bfc.webp"
"MediaSize" => 42569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-9a84a812d9b44d5e7eab23be587d0bfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:13.89Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29829837_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/b6052faf296d362643e3d29442b5e9bf.webp"
"MediaSize" => 42973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-b6052faf296d362643e3d29442b5e9bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:13.89Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29829837_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/b3ee4c24058672fadaaa323b5586cb01.webp"
"MediaSize" => 38770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-b3ee4c24058672fadaaa323b5586cb01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:13.89Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29829837_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/381b5ba1fbb494bdef620c6fe4ae2d94.webp"
"MediaSize" => 43561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-381b5ba1fbb494bdef620c6fe4ae2d94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:11.98Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29829837_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/c592213cd89b2f9e278a3904855f943a.webp"
"MediaSize" => 40508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-c592213cd89b2f9e278a3904855f943a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:17.65Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29829837_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/6f3b61323e94e453e4c262f6685657f0.webp"
"MediaSize" => 97805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-6f3b61323e94e453e4c262f6685657f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:11.98Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29829837_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/e3168853a69a0de6913caeb313f6402b.webp"
"MediaSize" => 123450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-e3168853a69a0de6913caeb313f6402b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:15.81Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29829837_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/ebb9f667b34a7446c191b6513f794fee.webp"
"MediaSize" => 97751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-ebb9f667b34a7446c191b6513f794fee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:15.72Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29829837_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/798763d3ba0596838d96f5aea11d92f2.webp"
"MediaSize" => 84541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-798763d3ba0596838d96f5aea11d92f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:15.79Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29829837_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/8adb53aa03fa20cdb8a04da11418891c.webp"
"MediaSize" => 107209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-8adb53aa03fa20cdb8a04da11418891c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:13.89Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29829837_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/2ed216967aaa5e8c768334e9384ceb17.webp"
"MediaSize" => 79951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-2ed216967aaa5e8c768334e9384ceb17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:13.89Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29829837_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/5076f429cdeb6e84c2281911a64ef45b.webp"
"MediaSize" => 90382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-5076f429cdeb6e84c2281911a64ef45b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:15.83Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29829837_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/9f98a213f65b0bba4bbd6038ae02fb09.webp"
"MediaSize" => 95426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-9f98a213f65b0bba4bbd6038ae02fb09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:15.72Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29829837_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/c8b765f747f28ae2dd429d08246d0074.webp"
"MediaSize" => 94146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-c8b765f747f28ae2dd429d08246d0074.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:13.97Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29829837_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/9a77a4837de77efb15315a9019dc318b.webp"
"MediaSize" => 87797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-9a77a4837de77efb15315a9019dc318b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:15.72Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29829837_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/e9d54ec408000c827425d805bb04aa0d.webp"
"MediaSize" => 77077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-e9d54ec408000c827425d805bb04aa0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:15.72Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29829837_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/e748b4f505eb16207cfa1309f7fefd22.webp"
"MediaSize" => 124402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-e748b4f505eb16207cfa1309f7fefd22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:17.65Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29829837_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29829837/72786d18461946fb12cfb0a8708cdd58.webp"
"MediaSize" => 153906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29829837/thumbnail-72786d18461946fb12cfb0a8708cdd58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40834781"
"ResourceRecordKey" => "29829837"
"ModificationTimestamp" => "2026-06-02T01:11:17.69Z"
]
]
+"DaysOnMarket": 18
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29829837')"
+"ID": "1477911"
}
]
+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=OfficeMlsId eq 289722" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24824
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564507" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24797
+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 '29829837'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25119
+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 '29829837'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25135
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29829837' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential Lease' AND geo.distance(Coordinates, POINT(-80.5219761 43.5102218)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25153
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25147
+post_id: "1542700"
+post_author: 1
+"ListingKey": "29921325"
+"ListingId": "40840984"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T15:00:08Z"
+"RFModificationTimestamp": "2026-06-18T15:44:38Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2067.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G3"
+"UnparsedAddress": "765 CHESAPEAKE Drive, Waterloo, Ontario N2K4G3"
+"Coordinates": array:2 [
0 => -80.5142526
1 => 43.510149
]
+"Latitude": 43.510149
+"Longitude": -80.5142526
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 3 bedroom, 2 bathroom detached backsplit home offering approximately 2,067 sq. ft. of comfortable living space in the highly sought after East Bridge neighbourhood. Designed with an inviting open concept layout, this home features a formal dining room, a spacious family room with soaring vaulted ceilings and a cozy gas fireplace, as well as a separate kitchen and breakfast area. The bright living room provides direct access to a peaceful walkout deck, creating the perfect space for relaxing or entertaining. Step outside to enjoy the fully fenced backyard, surrounded by mature trees that provide exceptional privacy and a tranquil setting. Ideally located just minutes from the University of Waterloo, Wilfred Laurier University, RIM Park, Waterloo Public Library, Conestoga Mall, the ION transit hub, Grey Silo Golf Club, major highways, and the renowned St. Jacobs Market, this home offers both convenience and an outstanding lifestyle. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T15:44:35.448751+00:00"
+"Directions": "Bridge St to Chesapeake Drive"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060436"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T14:52:51Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:52:51Z"
+"Stories": "3.0"
+"StreetName": "CHESAPEAKE"
+"StreetNumber": "765"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6494"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1662092681"
"RoomType" => "Other"
"ListingId" => "40840984"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "34'3'' x 36'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
1 => array:11 [
"RoomKey" => "1662092682"
"RoomType" => "Family room"
"ListingId" => "40840984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "22'10'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
2 => array:11 [
"RoomKey" => "1662092683"
"RoomType" => "Laundry room"
"ListingId" => "40840984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
3 => array:11 [
"RoomKey" => "1662092684"
"RoomType" => "Bedroom"
"ListingId" => "40840984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
4 => array:11 [
"RoomKey" => "1662092685"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 4'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
5 => array:11 [
"RoomKey" => "1662092686"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840984"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 17'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
6 => array:11 [
"RoomKey" => "1662092687"
"RoomType" => "Bedroom"
"ListingId" => "40840984"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
7 => array:11 [
"RoomKey" => "1662092688"
"RoomType" => "5pc Bathroom"
"ListingId" => "40840984"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
8 => array:11 [
"RoomKey" => "1662092689"
"RoomType" => "Living room"
"ListingId" => "40840984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "17'0'' x 24'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
9 => array:11 [
"RoomKey" => "1662092690"
"RoomType" => "Kitchen"
"ListingId" => "40840984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
10 => array:11 [
"RoomKey" => "1662092691"
"RoomType" => "Dining room"
"ListingId" => "40840984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
11 => array:11 [
"RoomKey" => "1662092692"
"RoomType" => "Breakfast"
"ListingId" => "40840984"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921325"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T14:52:51.64Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921325/765-chesapeake-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3450
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 2067
+"OriginalEntryTimestamp": "2026-06-18T14:52:51.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1335580"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29921325_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/901403240bcd5f0f683f746fe4efcbd9.webp"
"MediaSize" => 188219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-901403240bcd5f0f683f746fe4efcbd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29921325_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/053e292f5c27326ac3830b9690af3773.webp"
"MediaSize" => 246096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-053e292f5c27326ac3830b9690af3773.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29921325_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/4b738d7dfed53d0116e259dd7e909a7f.webp"
"MediaSize" => 226155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-4b738d7dfed53d0116e259dd7e909a7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29921325_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/d3d1676da9f5e95524de89006d9b9fed.webp"
"MediaSize" => 253693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-d3d1676da9f5e95524de89006d9b9fed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29921325_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/c2c4a5c22251e987b1fdfc436c6c5582.webp"
"MediaSize" => 104976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-c2c4a5c22251e987b1fdfc436c6c5582.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29921325_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/594079445f30c28f881175ab037fa97c.webp"
"MediaSize" => 92870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-594079445f30c28f881175ab037fa97c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29921325_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/09a85c91c2aa45784fa45ddc70539b0b.webp"
"MediaSize" => 116121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-09a85c91c2aa45784fa45ddc70539b0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29921325_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/cf05cbcf41fd620e2d625ea5a2839e07.webp"
"MediaSize" => 112195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-cf05cbcf41fd620e2d625ea5a2839e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29921325_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/678575d9010a9b8f43b49ef545461589.webp"
"MediaSize" => 85743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-678575d9010a9b8f43b49ef545461589.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29921325_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/ffc831de17ade3136f068c6ad95c70e5.webp"
"MediaSize" => 125628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-ffc831de17ade3136f068c6ad95c70e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29921325_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/7b6f8190fdaaa0bba9a3da008470096a.webp"
"MediaSize" => 108276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-7b6f8190fdaaa0bba9a3da008470096a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29921325_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/6d5d9d634a05e75f7013ecc80da41ab0.webp"
"MediaSize" => 117394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-6d5d9d634a05e75f7013ecc80da41ab0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29921325_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/33deeaa39ecc8103093f14baedb09e6a.webp"
"MediaSize" => 107705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-33deeaa39ecc8103093f14baedb09e6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29921325_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/265f96f29598374b68ef279068c92768.webp"
"MediaSize" => 86935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-265f96f29598374b68ef279068c92768.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29921325_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/5209b5910e4963c24fbda90efe08dd91.webp"
"MediaSize" => 109391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-5209b5910e4963c24fbda90efe08dd91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29921325_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/8ad3aba698d19e3d03d85b8bee41d77c.webp"
"MediaSize" => 101344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-8ad3aba698d19e3d03d85b8bee41d77c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29921325_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/64c3781a781039954713052841edda4b.webp"
"MediaSize" => 82552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-64c3781a781039954713052841edda4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29921325_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/d4d4d5ad64383d6c9080dd69363bf1c1.webp"
"MediaSize" => 89169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-d4d4d5ad64383d6c9080dd69363bf1c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29921325_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/01140d5306f11b2624d25ef7ca92d931.webp"
"MediaSize" => 138848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-01140d5306f11b2624d25ef7ca92d931.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29921325_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/3ccfbd912109fd3393858d22bf6e5d45.webp"
"MediaSize" => 97074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-3ccfbd912109fd3393858d22bf6e5d45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29921325_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/ea96e6a4593899df548bd94e5c8754a3.webp"
"MediaSize" => 93414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-ea96e6a4593899df548bd94e5c8754a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29921325_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/a9f0ac39ef9d60bc9b37598acc38b061.webp"
"MediaSize" => 97593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-a9f0ac39ef9d60bc9b37598acc38b061.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29921325_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/a81c6b2216b411e02d92f07e7ee81bea.webp"
"MediaSize" => 283781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-a81c6b2216b411e02d92f07e7ee81bea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29921325_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921325/f08deb5a379eedebeade30ba0d0ead3d.webp"
"MediaSize" => 289137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921325/thumbnail-f08deb5a379eedebeade30ba0d0ead3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840984"
"ResourceRecordKey" => "29921325"
"ModificationTimestamp" => "2026-06-18T14:52:51.62Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921325')"
+"ID": "1542700"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25149
+post_id: "1541147"
+post_author: 1
+"ListingKey": "29919011"
+"ListingId": "X13458748"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T14:55:06Z"
+"RFModificationTimestamp": "2026-06-18T15:05:45Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "508B - 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. This 581 Sqft Carina Model At Blackstone Features 1 Bedroom + Den, 1 Bath, 9 Foot Ceilings. Upgraded Kitchen & Bathroom. Kitchen Comes Finished With Quartz Countertop, Modern Backsplash & Stainless Steel Appliances. Laminate Flooring Throughout The Unit. Den Is Perfect For Office Or Extra Storage Space. Close To Shops, Schools, Highways & Public Transport (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T22:39:27.621016+00:00"
+"Directions": "Northfield Dr E & Bridge St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1995514"
+"ListOfficeKey": "292627"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T14:48:53Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T14:48:53Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1661543507"
"RoomType" => "Living room"
"ListingId" => "X13458748"
"RoomLevel" => "Flat"
"RoomWidth" => 3.12
"ListingKey" => "29919011"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:10.13Z"
]
1 => array:11 [
"RoomKey" => "1661543508"
"RoomType" => "Dining room"
"ListingId" => "X13458748"
"RoomLevel" => "Flat"
"RoomWidth" => 3.12
"ListingKey" => "29919011"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:10.13Z"
]
2 => array:11 [
"RoomKey" => "1661543509"
"RoomType" => "Kitchen"
"ListingId" => "X13458748"
"RoomLevel" => "Flat"
"RoomWidth" => 3.12
"ListingKey" => "29919011"
"RoomLength" => 3.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:10.13Z"
]
3 => array:11 [
"RoomKey" => "1661543510"
"RoomType" => "Bedroom"
"ListingId" => "X13458748"
"RoomLevel" => "Flat"
"RoomWidth" => 3.3
"ListingKey" => "29919011"
"RoomLength" => 3.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:10.13Z"
]
4 => array:11 [
"RoomKey" => "1661543511"
"RoomType" => "Den"
"ListingId" => "X13458748"
"RoomLevel" => "Flat"
"RoomWidth" => 1.68
"ListingKey" => "29919011"
"RoomLength" => 1.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T21:55:10.14Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29919011/508b-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "MF Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-17T21:55:10.08Z"
+"ListAgentNationalAssociationId": "1278379"
+"ListOfficeNationalAssociationId": "1414835"
+"Media": array:18 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29919011_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/1cf037ef85d6678ed3ecee4c6e89d548.webp"
"MediaSize" => 178406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-1cf037ef85d6678ed3ecee4c6e89d548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29919011_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/fe7521e79a93df551f4c75083931efd9.webp"
"MediaSize" => 66953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-fe7521e79a93df551f4c75083931efd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29919011_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/9d46e68e6c1cda832179b320de1e3f21.webp"
"MediaSize" => 68825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-9d46e68e6c1cda832179b320de1e3f21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29919011_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/9b7705135eb5cd9e3a36b13518abe918.webp"
"MediaSize" => 36106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-9b7705135eb5cd9e3a36b13518abe918.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29919011_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/8e81b32ccc810f739bd9e2fbf14cc866.webp"
"MediaSize" => 103467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-8e81b32ccc810f739bd9e2fbf14cc866.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29919011_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/1aab05495a7bb305efc928b4a45b224d.webp"
"MediaSize" => 53185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-1aab05495a7bb305efc928b4a45b224d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29919011_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/15652db27886aaf9b860bb4472ec21d4.webp"
"MediaSize" => 82490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-15652db27886aaf9b860bb4472ec21d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29919011_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/208b9e7ee2a63cfb6e8d5fe18222ad1d.webp"
"MediaSize" => 98191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-208b9e7ee2a63cfb6e8d5fe18222ad1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29919011_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/be00aaeef2d25808d74132c3dfd84ea6.webp"
"MediaSize" => 107345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-be00aaeef2d25808d74132c3dfd84ea6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29919011_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/958875879ed4e2c127e5e0e441550814.webp"
"MediaSize" => 135607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-958875879ed4e2c127e5e0e441550814.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29919011_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/7796c79a4cccd366705f82e9d0155ea3.webp"
"MediaSize" => 67509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-7796c79a4cccd366705f82e9d0155ea3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29919011_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/aedef9fe63b110455001319449a0d6c5.webp"
"MediaSize" => 67294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-aedef9fe63b110455001319449a0d6c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29919011_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/571dcb01d3fec8379345ba1284c4117b.webp"
"MediaSize" => 59827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-571dcb01d3fec8379345ba1284c4117b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29919011_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/c64792599ef70a29529c683b230387ee.webp"
"MediaSize" => 72918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-c64792599ef70a29529c683b230387ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29919011_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/f72425c045212f7cd95644b3873fc47d.webp"
"MediaSize" => 65639
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-f72425c045212f7cd95644b3873fc47d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29919011_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/79dca58501ac042fa52e1d145a85d873.webp"
"MediaSize" => 67096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-79dca58501ac042fa52e1d145a85d873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29919011_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/ad2e3d4b259d5ccf2b19e43efa858e73.webp"
"MediaSize" => 215190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-ad2e3d4b259d5ccf2b19e43efa858e73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29919011_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919011/5f886bd887e832857ff4be7aac560077.webp"
"MediaSize" => 134155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919011/thumbnail-5f886bd887e832857ff4be7aac560077.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13458748"
"ResourceRecordKey" => "29919011"
"ModificationTimestamp" => "2026-06-17T21:55:10.09Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919011')"
+"ID": "1541147"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25146
+post_id: "1532426"
+post_author: 1
+"ListingKey": "29902978"
+"ListingId": "40839142"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:00:13Z"
+"RFModificationTimestamp": "2026-06-15T21:11:00Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 580.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "251 NORTHFIELD Drive E Unit# 108, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5216073
1 => 43.5103851
]
+"Latitude": 43.5103851
+"Longitude": -80.5216073
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stylish, Scandinavian-inspired condo offering a bright open-concept layout, 9-foot ceilings, and impressive outdoor living space with an open terrace plus an additional approximately 300 sq. ft. second balcony. Thoughtfully finished throughout, the unit features upgraded kitchen and bathroom cabinetry, quartz countertops, stainless steel appliances, upgraded doors and hardware, and a beautifully finished bathroom with Marmo Calcatta 12 x 24 tile in the bathroom and shower. Enjoy modern condo living in a fantastic location with excellent building amenities, including concierge with 24/7 security, fitness centre, rooftop terrace and lounge with outdoor kitchen and BBQs, event/party room, dog wash station, keyless entry, bicycle storage, and more. Conveniently situated near transit, shopping, retail corridors, highway access, biking trails, and walking paths. Includes one surface-level parking space and is available for immediate occupancy. (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Central Vacuum"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T21:10:56.186140+00:00"
+"Directions": "Northfield Drive East / Bridge Street West"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060007"
+"ListOfficeKey": "152170"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-15T13:50:29Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T14:51:49Z"
+"Stories": "1.0"
+"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 [
"RoomKey" => "1659852856"
"RoomType" => "Laundry room"
"ListingId" => "40839142"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902978"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:49.06Z"
]
1 => array:11 [
"RoomKey" => "1659852857"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839142"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902978"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T14:51:49.07Z"
]
2 => array:11 [
"RoomKey" => "1659852858"
"RoomType" => "Bedroom"
"ListingId" => "40839142"
"RoomLevel" => "Main level"
…7
]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902978/251-northfield-drive-e-unit-108-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1800
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 580
+"OriginalEntryTimestamp": "2026-06-15T13:50:29.63Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1335157"
+"ListOfficeNationalAssociationId": "1179396"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902978')"
+"ID": "1532426"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25150
+post_id: "1522393"
+post_author: 1
+"ListingKey": "29893148"
+"ListingId": "40838875"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:40:11Z"
+"RFModificationTimestamp": "2026-06-12T15:43:02Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 580.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "251 NORTHFIELD Drive E Unit# 218, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.52208
1 => 43.5100525
]
+"Latitude": 43.5100525
+"Longitude": -80.52208
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to BLAKSTONE'S stunning condo apartments in Waterloo North! Unit 218 at 251 Northfield Dr E is bright and designed for comfortable, modern living. The PELLE floor plan is offering 580 sqft of living space + a 62 sqft private balcony. The suite features a contemporary eat-in kitchen with ample cabinetry and workspace, seamlessly flowing into a sun-filled living area, perfect for hosting guests or just unwinding after a busy day. The Primary bedroom is a generous size and has a large walk-in closet. One underground parking spot & keyless entry for your convenience! You will enjoy living in this open-concept setup with quartz countertops, a stylish backsplash, stainless steel appliances, and a stackable washer and dryer inside the unit. It is ideal for a professional, couple, or mature student. This thoughtfully designed space offers both style and practicality in a peaceful setting. As a resident you will have access to all building amenities: bike storage, gym/exercise room, luxurious event room with bar, dining and seating areas & double-sided fireplace, co-working space, rooftop terrace, and courtyard BBQs & fire pit. Rogers Ignite high-speed internet is included in the rent. You will also be pleased with the close proximity to shopping amenities, Conestoga Mall, restaurants, walking trails, sports fields, RIM Park, the Walter Bean trail system, and the Grand River. Popular schools nearby, UW and WLU. Hop on the LRT and explore the whole Kitchener-Waterloo Region, or take the quick highway access to the surrounding communities: St Jacob's, Guelph, Elora, and Conestogo! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
]
+"AssociationFeeIncludes": array:3 [
0 => "Exterior Maintenance"
1 => "Property Management"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T02:06:38.440870+00:00"
+"ExteriorFeatures": array:1 [
0 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562711"
+"ListOfficeKey": "299731"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-12T00:30:50Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:31:42Z"
+"Stories": "1.0"
+"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/29893148/251-northfield-drive-e-unit-218-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1750
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 580
+"OriginalEntryTimestamp": "2026-06-12T00:30:50.5Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1148656"
+"ListOfficeNationalAssociationId": "1476052"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893148')"
+"ID": "1522393"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25148
+post_id: "1517456"
+post_author: 1
+"ListingKey": "29886106"
+"ListingId": "40837904"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T01:00:05Z"
+"RFModificationTimestamp": "2026-06-13T01:11:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1532.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4A5"
+"UnparsedAddress": "596 SPINNAKER Crescent, Waterloo, Ontario N2K4A5"
+"Coordinates": array:2 [
0 => -80.5178999
1 => 43.5094879
]
+"Latitude": 43.5094879
+"Longitude": -80.5178999
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "MOVE-IN READY! Very well maintained 3 beds and 2.5 baths freehold townhome with beautifully landscaped backyard and parking for 3 vehicles. Open concept main floor features updated kitchen, gas fireplace in living room with hardwood flooring, 2 pc powder room and walkout from dining room to amazing stamped concrete patio and landscaped backyard. The upper floor has 3 sizable bedrooms and 2 full bathrooms. The primary bedroom offers 4 pc en-suite bath and walk-in closet, 2nd bedroom also offers a walk-in closet. Partially finished lower level with cozy rec-room, a spacious laundry room, and lots of storage spaces. Conveniently located with easy access to expressway, shopping, schools, Rim Park, Conestoga Mall, St. Jacobs Farmer's Market, public transit and walking trails. (Furniture can be included or removed) (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T00:56:17.401584+00:00"
+"Directions": "BRIDGE AND CHESAPEAKE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T00:50:33Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T00:50:33Z"
+"Stories": "2.0"
+"StreetName": "SPINNAKER"
+"StreetNumber": "596"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4178"
+"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/29886106/596-spinnaker-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3000
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1532
+"OriginalEntryTimestamp": "2026-06-10T23:01:01.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1257707"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29886106')"
+"ID": "1517456"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25143
+post_id: "1512895"
+post_author: 1
+"ListingKey": "29879176"
+"ListingId": "X13422908"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T22:05:35Z"
+"RFModificationTimestamp": "2026-06-09T22:26:57Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "410 - 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": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "One Bedroom Condo with Garage Parking. Available: July 1, 2026Size: 580 SF + 67 SF Balcony / One Bedroom, One BathroomLease Term: Minimum One Year. Scandinavian inspired, luxury modern condominium within the Blackstone Condos "Nord" building of Waterloo! Suite includes the following UPGRADES:- Specially selected UNDERGROUND parking spot- Personal storage locker- High quality laminate flooring throughout- Upgraded washer & dryer- Shower grab handleWith the following items standard:- Quartz countertops- Stainless steel appliances- Fitness center- Bike room- 24/7 security- Keyless entry- Dog washing station- Co-working space and "The Terrace"- 9 FT ceilings- In-suite energy recovery ventilator- Plenty of visitor parking- Rogers Ignite 500 fast internet package included! Location:- Easy access to highway- Multiple bus routes- Walk to LRT station at Conestoga Mall, Blackberry Technology Park, grocery stores, etc.Tenant is responsible for Hydro, Water, Tenant Insurance and Water heater rental (id:62783)"
+"Appliances": array:2 [
0 => "Intercom"
1 => "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": "2026-06-09T22:26:54.988556+00:00"
+"Directions": "Northfield & Bridge St W"
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2059512"
+"ListOfficeKey": "204997"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T21:56:35Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T21:56:35Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29879176/410-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "LCM Property Services"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Separate Heating Controls"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Controlled entry"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-09T21:56:35.71Z"
+"ListAgentNationalAssociationId": "1334662"
+"ListOfficeNationalAssociationId": "1245785"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29879176')"
+"ID": "1512895"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1482674"
+post_author: 1
+"ListingKey": "29831524"
+"ListingId": "X13220004"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:05:03Z"
+"RFModificationTimestamp": "2026-06-16T19:09:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "201 - 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 this stylish and upgraded 2-bedroom, 2-bathroom condo located in one of Waterloo's most sought-after communities. Offering over 1,000 sq. ft. of thoughtfully designed living space, this suite features a private balcony with stunning sunset views and a bright, open-concept layout ideal for modern living.The contemporary kitchen is finished with quartz countertops, a waterfall island, designer lighting, and sleek matte black fixtures, creating a polished space for both everyday use and entertaining. The living and dining areas flow seamlessly together, while both spacious bedrooms include their own walk-in closets for excellent storage and convenience.Residents can enjoy premium building amenities, including a fitness centre, rooftop terrace with BBQs and lounge areas, and a party room. Ideally situated near Hwy 7/8, Conestoga Mall, public transit, RIM Park, Grey Silo Golf Course, and scenic walking trails, this location offers a great blend of comfort, convenience, and lifestyle.Additional features include underground parking and in-suite laundry. Storage locker included as well (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T18:19:45.364975+00:00"
+"Directions": "Cross Streets: Bridge St / Northfield Drive. ** Directions: South of Bridge on the East side of Northfield."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2044407"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-01T12:30:28Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:57:45Z"
+"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/29831524/201-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "MF Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2450
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-01T12:30:28.11Z"
+"ListAgentNationalAssociationId": "1320279"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 17
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29831524')"
+"ID": "1482674"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25151
+post_id: "1470054"
+post_author: 1
+"ListingKey": "29816845"
+"ListingId": "40833851"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:25:57Z"
+"RFModificationTimestamp": "2026-06-02T16:35:41Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 752.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "251 NORTHFIELD Drive E Unit# 317, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.521941
1 => 43.5104504
]
+"Latitude": 43.5104504
+"Longitude": -80.521941
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience modern condo living at Blackstone Modern Condominiums in the highly sought-after Sentral community. Perfectly situated in Waterloo, this stylish residence offers the best of urban convenience with easy access to scenic biking trails and nearby rural escapes for weekend relaxation. Inspired by Scandinavian design and modern farmhouse comfort, residents enjoy an impressive collection of premium amenities throughout all Blackstone buildings — all connected through a beautiful indoor lobby, so you never need to step outside during colder months. Building amenities include: Fully equipped fitness centre, Co-working space, Elegant great room and event spaces, Keyless entry and 24/7 security, Bike storage and dog wash station, Access to the stunning 2nd-floor terrace at Nord featuring: Landscaped gardens, Modern outdoor lounge furniture, Stainless steel BBQs, Gas fire pit, Loungers and dining areas perfect for entertaining. This carpet-free Eline model offers: 2 spacious bedrooms, 2 full bathrooms, Quartz countertops, Stainless steel appliances, 1 surface parking space, 1 storage locker. A fantastic opportunity to lease in one of Waterloo’s most desirable condo communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFeeIncludes": array:1 [
0 => "Heat"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-28T17:38:10.339823+00:00"
+"Directions": "Corner of Bridge St and Northfield Dr"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564166"
+"ListOfficeKey": "246041"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-05-28T13:50:14Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:14:58Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"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/29816845/251-northfield-drive-e-unit-317-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2199
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-05-28T13:50:14.71Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1113692"
+"ListOfficeNationalAssociationId": "1202898"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29816845')"
+"ID": "1470054"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25152
+post_id: "1467944"
+post_author: 1
+"ListingKey": "29814426"
+"ListingId": "X13202952"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-27T21:00:36Z"
+"RFModificationTimestamp": "2026-05-27T21:26:12Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "322 - 251 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.521738
1 => 43.509974
]
+"Latitude": 43.509974
+"Longitude": -80.521738
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into the realm of contemporary sophistication with this stylish 2-bedroom, 2-bathroom condominium, ideally positioned near all conveniences and mere moments from the highway, catering perfectly to commuters. This modern space exudes an irresistible charm, accentuated by its underground parking, ensuring ease and safety for residents. Meticulously crafted, this unit offers not just a residence but a lifestyle. The sleek kitchen and bathroom are adorned with the latest fixtures and finishes, evoking an ambiance of refined elegance. The bedroom serves as a tranquil sanctuary, while the impeccably designed bathroom boasts contemporary elements. Adding to the appeal, the unit includes both an underground parking spot and an extra storage locker. The balcony provides a secluded outdoor retreat, ideal for relishing morning coffee or captivating sunsets. Moreover, revel in the convenience of an in-suite laundry, simplifying day-to-day living. Stay fit in the well equipped gym, unwind in the stylish lounge area, or boost productivity in the dedicated office space - all within the comfort of your own residence. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-27T21:26:02.481121+00:00"
+"Directions": "Northfield Dr E & Bridge St W"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080076"
+"ListOfficeKey": "286296"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-27T20:51:58Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-27T20:51:58Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29814426/322-251-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2141698"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Waterloo Standard Condominium Corporation"
+"CoListAgentKey2": "2182290"
+"CoListOfficeKey": "286296"
+"GeocodeManualYN": false
+"TotalActualRent": 2200
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Visitor Parking"
]
+"CoListOfficeKey2": "286296"
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-05-27T20:51:58.08Z"
+"ListAgentNationalAssociationId": "1354968"
+"ListOfficeNationalAssociationId": "1359609"
+"CoListAgentNationalAssociationId": "1393480"
+"CoListAgentNationalAssociationId2": "1432120"
+"CoListOfficeNationalAssociationId": "1359609"
+"CoListOfficeNationalAssociationId2": "1359609"
+"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]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29814426')"
+"ID": "1467944"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 14
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]