array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29484073 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1231344"
+post_author: 1
+"ListingKey": "29484073"
+"ListingId": "40813093"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T00:00:53Z"
+"RFModificationTimestamp": "2026-06-10T00:03:22Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1420.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G2"
+"UnparsedAddress": "545 CHESAPEAKE Crescent, Waterloo, Ontario N2K4G2"
+"Coordinates": array:2 [
0 => -80.5132353
1 => 43.5114623
]
+"Latitude": 43.5114623
+"Longitude": -80.5132353
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don’t miss out this great opportunity, it won’t last. Recently renovated. well maintained, single detached home, located at desirable East Bridge, on a premium, private lot. Family friendly neighbourhood. Over 2000 sqft. of living space. Close to Conestoga mall, shopping centres, public transportation, Schools, Highway 85, minutes to the university of Waterloo/ Laurier. Finished top to bottom. Main floor with welcoming entry, great size open concept, dining room with hardwood flooring. Spacious kitchen and dinette area leads to deep fenced private back yard. Second floor with 3 good size bedrooms. All Appliances are included (fridge, stove, dishwasher, washer, dryer, microwave). A/C and water softener). No Pets and no smoking allowed. Finished rec room in the basement with full bath. Professionally; just installed high quality vinyl and sub-floor. Tenant is responsible for their own insurance, Snow removal, grass mowing and all utilities (Hot water tank rental, gas, hydro, water) (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-03-18T06:44:07.844989+00:00"
+"Directions": "Chesapeake Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750740"
+"ListOfficeKey": "156288"
+"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-03-18T05:29:25Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T23:50:50Z"
+"Stories": "2.0"
+"StreetName": "CHESAPEAKE"
+"StreetNumber": "545"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1655995350"
"RoomType" => "4pc Bathroom"
"ListingId" => "40813093"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29484073"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:50:50.56Z"
]
1 => array:11 [
"RoomKey" => "1655995351"
"RoomType" => "5pc Bathroom"
"ListingId" => "40813093"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29484073"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:50:50.56Z"
]
2 => array:11 [
"RoomKey" => "1655995352"
"RoomType" => "Bedroom"
"ListingId" => "40813093"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29484073"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:50:50.56Z"
]
3 => array:11 [
"RoomKey" => "1655995353"
"RoomType" => "Bedroom"
"ListingId" => "40813093"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29484073"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:50:50.56Z"
]
4 => array:11 [
"RoomKey" => "1655995354"
"RoomType" => "Bedroom"
"ListingId" => "40813093"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29484073"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:50:50.56Z"
]
5 => array:11 [
"RoomKey" => "1655995355"
"RoomType" => "2pc Bathroom"
"ListingId" => "40813093"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29484073"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:50:50.56Z"
]
6 => array:11 [
"RoomKey" => "1655995356"
"RoomType" => "Kitchen"
"ListingId" => "40813093"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29484073"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:50:50.56Z"
]
7 => array:11 [
"RoomKey" => "1655995357"
"RoomType" => "Dining room"
"ListingId" => "40813093"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29484073"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:50:50.56Z"
]
8 => array:11 [
"RoomKey" => "1655995358"
"RoomType" => "Living room"
"ListingId" => "40813093"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29484073"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 21'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-09T23:50:50.56Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29484073/545-chesapeake-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2995
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1420
+"OriginalEntryTimestamp": "2026-03-18T05:29:25.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1131090"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:24 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6525246869"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/c9162898daa39b1e334ed0b93b85862a.webp"
"MediaSize" => 13123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-c9162898daa39b1e334ed0b93b85862a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6525246882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/c584ff71353d6d1b23f989ab4f1f2489.webp"
"MediaSize" => 13744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-c584ff71353d6d1b23f989ab4f1f2489.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6525246962"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/4a8f6bb42053220076cc97c172e42213.webp"
"MediaSize" => 6454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-4a8f6bb42053220076cc97c172e42213.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6525247070"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/44df6f61e285724ac3028fe6b0da37ac.webp"
"MediaSize" => 6177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-44df6f61e285724ac3028fe6b0da37ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6525247081"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/386b0b8d719437a09bc5590510dacae7.webp"
"MediaSize" => 7020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-386b0b8d719437a09bc5590510dacae7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6525247143"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/7a790daef7e438d50e674ff0fbf981de.webp"
"MediaSize" => 12283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-7a790daef7e438d50e674ff0fbf981de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6525247195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/68672e065beb288cd8db9588666d7741.webp"
"MediaSize" => 14218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-68672e065beb288cd8db9588666d7741.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6525247210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/a3e345d8ad366612b869beea9b6e438f.webp"
"MediaSize" => 15176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-a3e345d8ad366612b869beea9b6e438f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6525247267"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/5e7fdd6b1bd73515236c51c201419167.webp"
"MediaSize" => 9115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-5e7fdd6b1bd73515236c51c201419167.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6525247295"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/664a3dfd44cb5fd544752539313b05d9.webp"
"MediaSize" => 9239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-664a3dfd44cb5fd544752539313b05d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6525247347"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/09dca736575e46379604d93393249c9a.webp"
"MediaSize" => 8483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-09dca736575e46379604d93393249c9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6525247401"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/2440dd80b7325f8e0a965cac11b21bd0.webp"
"MediaSize" => 10286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-2440dd80b7325f8e0a965cac11b21bd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6525247447"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/bfb9618f2d0920ee6b219bee1dac589f.webp"
"MediaSize" => 10248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-bfb9618f2d0920ee6b219bee1dac589f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6525247475"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/f06a258aa3235e22219b27fa662b0e0d.webp"
"MediaSize" => 8899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-f06a258aa3235e22219b27fa662b0e0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6525247497"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/cdab998502c926cc1ba1fd7ba5720bfd.webp"
"MediaSize" => 9884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-cdab998502c926cc1ba1fd7ba5720bfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6525247530"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/6292bc6792be489b9de633b2cdf8dcfe.webp"
"MediaSize" => 6692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-6292bc6792be489b9de633b2cdf8dcfe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6525247554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/c2cfa19708a4d5a5b2d2fb18276ffcf9.webp"
"MediaSize" => 7568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-c2cfa19708a4d5a5b2d2fb18276ffcf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6525247584"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/a2d9d550f904f403deeda5d76f13f97d.webp"
"MediaSize" => 44195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-a2d9d550f904f403deeda5d76f13f97d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6525247610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/1d10744e9891d8c21ec72907bf339c54.webp"
"MediaSize" => 40463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-1d10744e9891d8c21ec72907bf339c54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6525247692"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/e6bf7bd23571f06d914d401e2d202c71.webp"
"MediaSize" => 6760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-e6bf7bd23571f06d914d401e2d202c71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6525247708"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/441f4c432e4c9505e9c4621a595433f8.webp"
"MediaSize" => 6091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-441f4c432e4c9505e9c4621a595433f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6525247751"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/5700fbdec3c4835cdf92c71d8c13226c.webp"
"MediaSize" => 6246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-5700fbdec3c4835cdf92c71d8c13226c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6525247824"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/a516fa6d6428930bca1669442c267ee6.webp"
"MediaSize" => 6328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-a516fa6d6428930bca1669442c267ee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6525247870"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29484073/c562acbe3a66c4f571cbb97f69557538.webp"
"MediaSize" => 7779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29484073/thumbnail-c562acbe3a66c4f571cbb97f69557538.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40813093"
"ResourceRecordKey" => "29484073"
"ModificationTimestamp" => "2026-03-18T05:29:25.22Z"
]
]
+"DaysOnMarket": 120
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29484073')"
+"ID": "1231344"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 156288" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24955
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24899
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX REAL ESTATE CENTRE INC., BROKERAGE"
+"OfficeEmail": null
+"OfficePhone": "519-623-6200"
+"OfficeMlsId": "CA558"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "156288"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "766 OLD HESPELER RD"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "CAMBRIDGE"
+"OfficePostalCode": "N3H5L"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1112493"
+"OriginalEntryTimestamp": "2008-03-03T22:46:00Z"
+"OfficeFax": "519-623-3541"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1066257"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('156288')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1750740" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24909
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29484073'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25239
+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 '29484073' AND OpenHouseDate ge '2026-07-15'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25255
+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 '29484073' 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.5132353 43.5114623)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25307
+items: array:8 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: "1627448"
+post_author: 1
+"ListingKey": "30037313"
+"ListingId": "40847546"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T18:25:16Z"
+"RFModificationTimestamp": "2026-07-15T18:51:09Z"
+"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# 408, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5215172
1 => 43.5103944
]
+"Latitude": 43.5103944
+"Longitude": -80.5215172
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "WELCOME TO BLACKSTONE MODERN CONDOMINIUMS IN WATERLOO! 1 Bedroom & 1 Bathroom unit available for rent as of September 1st, 2026 at $1,750/month + Utilities. This PELLE floorplan is 580 SQFT + 62 SQFT balcony. Interior features include quartz counter tops, backsplash, kitchen island with breakfast bar (room for 2 stools), stainless steel appliances & stackable Washer and Dryer inside the unit. The bedroom is a generous side and has a large walk-in closet. One parking spot is included & also a basement Storage locker. As a tenant you will have access to all building amenities: Bike storage, Gym/exercise room, event/party room, co-working space, Roof top terrace (on the 2nd floor of the NORD building), courtyard with hot-tub, BBQs & firepit. No smoking in unit & building. No Pets preferred. Conveniently located on a bus route and just minutes from Conestoga Mall & the LRT line, parks, and Grey Silo Golf Course. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T18:50:58.687290+00:00"
+"Directions": "NORTHFIELD DR. TO BRIDGE ST."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564290"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-15T18:22:55Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T18:22:55Z"
+"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:6 [
0 => array:11 [
"RoomKey" => "1685144039"
"RoomType" => "Storage"
"ListingId" => "40847546"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "30037313"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T18:18:29.2Z"
]
1 => array:11 [
"RoomKey" => "1685144040"
"RoomType" => "Laundry room"
"ListingId" => "40847546"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037313"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T18:18:29.2Z"
]
2 => array:11 [
"RoomKey" => "1685144041"
"RoomType" => "Primary Bedroom"
"ListingId" => "40847546"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037313"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T18:18:29.2Z"
]
3 => array:11 [
"RoomKey" => "1685144042"
"RoomType" => "4pc Bathroom"
"ListingId" => "40847546"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037313"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T18:18:29.2Z"
]
4 => array:11 [
"RoomKey" => "1685144043"
"RoomType" => "Living room"
"ListingId" => "40847546"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037313"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T18:18:29.2Z"
]
5 => array:11 [
"RoomKey" => "1685144044"
"RoomType" => "Eat in kitchen"
"ListingId" => "40847546"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30037313"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-15T18:18:29.2Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30037313/251-northfield-drive-e-unit-408-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2127439"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76840"
+"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-07-15T18:18:29.18Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1108797"
+"ListOfficeNationalAssociationId": "1378680"
+"CoListAgentNationalAssociationId": "1380670"
+"CoListOfficeNationalAssociationId": "1004363"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30037313_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/300caceb8aa999234a17d534098799c8.webp"
"MediaSize" => 76579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-300caceb8aa999234a17d534098799c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space with wood-finish flooring, light-toned walls, and a recessed ceiling feature"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:48.69Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30037313_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/f4d9c304e91cf6f857cb2ff89859922b.webp"
"MediaSize" => 63211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-f4d9c304e91cf6f857cb2ff89859922b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry and a substantial island with countertop seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:46.82Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30037313_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/11dc98d1afaa30a73360a06ff78a9fb0.webp"
"MediaSize" => 139663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-11dc98d1afaa30a73360a06ff78a9fb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:55.79Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30037313_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/b72c5a9c896ddcd31abfc177435ef922.webp"
"MediaSize" => 72941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-b72c5a9c896ddcd31abfc177435ef922.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with a large window, offering ample natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:48.74Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30037313_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/f4682eed5183ce8a11b3956676995576.webp"
"MediaSize" => 56727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-f4682eed5183ce8a11b3956676995576.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light neutral wall paint, walk-in closet with built-in shelving, and wood-finish flooring extending from the doorway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:48.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30037313_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/c87dac6d76130f3431a385c43ae76ce1.webp"
"MediaSize" => 56723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-c87dac6d76130f3431a385c43ae76ce1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White enamel bathtub with chrome fixtures and light grey tile surround"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:48.69Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30037313_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/522ec20e1c0620fb701f442d6b774fe4.webp"
"MediaSize" => 28168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-522ec20e1c0620fb701f442d6b774fe4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry closet featuring a white stackable washer and dryer unit, wood-finish flooring, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:48.69Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30037313_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/8a301d3e7515983bd40eef1450fbf0f1.webp"
"MediaSize" => 108244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-8a301d3e7515983bd40eef1450fbf0f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:46.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30037313_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/2aff0e970607518cde522a492b17102c.webp"
"MediaSize" => 101962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-2aff0e970607518cde522a492b17102c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:46.82Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30037313_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/b5114b9ced6fff08954e2769472c9da0.webp"
"MediaSize" => 92410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-b5114b9ced6fff08954e2769472c9da0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary common area featuring a stone-clad fireplace with built-in media, exposed bulb pendant lighting, wood slat ceiling accents, and large format floor tiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:48.73Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30037313_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/7c687a5991e0560cfbfd298d8f2a782c.webp"
"MediaSize" => 128253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-7c687a5991e0560cfbfd298d8f2a782c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:48.73Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30037313_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/637902932fd6da37e5db968d9b558810.webp"
"MediaSize" => 84144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-637902932fd6da37e5db968d9b558810.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated fitness room featuring rubber flooring, a mirrored wall, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:46.76Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30037313_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/27f40b80a3b70aae59b6f65afde75f50.webp"
"MediaSize" => 147045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-27f40b80a3b70aae59b6f65afde75f50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern multi-story building featuring stone veneer and dark horizontal siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:46.93Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30037313_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30037313/39569b90716544df6a49e766953b8f91.webp"
"MediaSize" => 119880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30037313/thumbnail-39569b90716544df6a49e766953b8f91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40847546"
"ResourceRecordKey" => "30037313"
"ModificationTimestamp" => "2026-07-15T18:22:48.68Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30037313')"
+"ID": "1627448"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1617764"
+post_author: 1
+"ListingKey": "30017900"
+"ListingId": "X13549268"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T17:10:01Z"
+"RFModificationTimestamp": "2026-07-10T17:51:23Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "505 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.521363
1 => 43.510427
]
+"Latitude": 43.510427
+"Longitude": -80.521363
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums, one of Waterloo's premier communities, where contemporary style, exceptional amenities, and an outstanding location come together. This beautifully maintained 2-bedroom, 2-bathroom suite offers over 800 sq. ft. of bright, open-concept living space designed for comfort and convenience. The modern kitchen features quartz countertops, stainless steel appliances, a subway tile backsplash, generous cabinetry, and a large island overlooking the spacious living area. Expansive windows flood the suite with natural light, while the private balcony provides the perfect place to enjoy your morning coffee or relax at the end of the day. The primary bedroom offers a private ensuite, while the second bedroom and full bathroom provide ideal space for guests, or a dedicated home office. In-suite laundry, and designated surface parking space, complete the package. Heat and Rogers high-speed internet are included, adding even greater value and convenience. Residents enjoy an exceptional collection of amenities, including a fully equipped fitness centre, co-working lounge, large party, games and media rooms, rooftop terrace with BBQs, landscaped outdoor spaces, bike storage, pet wash station, secure keyless entry, and 24-hour security. Ideally located just steps from Browns SocialHouse, shopping, public transit, and scenic walking trails, and only minutes to Conestoga Mall, RIM Park, St. Jacobs Farmers' Market, Waterloo & Laurier Universities, Conestoga College, and major highways, this is an exceptional opportunity to enjoy maintenance-free living in one of Waterloo's most desirable condominium communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T17:51:03.057292+00:00"
+"Directions": "NORTHFIELD/BRIDGE"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1899457"
+"ListOfficeKey": "292096"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Elevator"
3 => "Balcony"
4 => "Dry"
5 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T16:54:36Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T16:54:36Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1680160083"
"RoomType" => "Kitchen"
"ListingId" => "X13549268"
"RoomLevel" => "Main level"
"RoomWidth" => 3.28
"ListingKey" => "30017900"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T16:54:36.04Z"
]
1 => array:11 [
"RoomKey" => "1680160084"
"RoomType" => "Living room"
"ListingId" => "X13549268"
"RoomLevel" => "Main level"
"RoomWidth" => 3.28
"ListingKey" => "30017900"
"RoomLength" => 5.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T16:54:36.05Z"
]
2 => array:11 [
"RoomKey" => "1680160085"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13549268"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "30017900"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T16:54:36.05Z"
]
3 => array:11 [
"RoomKey" => "1680160086"
"RoomType" => "Bedroom 2"
"ListingId" => "X13549268"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "30017900"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T16:54:36.05Z"
]
4 => array:11 [
"RoomKey" => "1680160087"
"RoomType" => "Bathroom"
"ListingId" => "X13549268"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "30017900"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-10T16:54:36.05Z"
]
]
+"ListAOR": "Oakville-Milton"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/30017900/505-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2059475"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five River Prop Mgrs"
+"CoListAgentKey2": "1834162"
+"CoListOfficeKey": "292096"
+"GeocodeManualYN": false
+"TotalActualRent": 2200
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Security/Concierge"
3 => "Visitor Parking"
]
+"CoListOfficeKey2": "293196"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-10T16:54:36.02Z"
+"ListAgentNationalAssociationId": "1216506"
+"ListOfficeNationalAssociationId": "1408169"
+"CoListAgentNationalAssociationId": "1334623"
+"CoListAgentNationalAssociationId2": "1196633"
+"CoListOfficeNationalAssociationId": "1408169"
+"CoListOfficeNationalAssociationId2": "1423680"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30017900_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017900/45ee08d5c5189e6af92de3671f09a7f2.webp"
"MediaSize" => 85669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017900/thumbnail-45ee08d5c5189e6af92de3671f09a7f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13549268"
"ResourceRecordKey" => "30017900"
"ModificationTimestamp" => "2026-07-10T16:54:36.03Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30017900_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017900/174f62c8c79bdb07994f61a61b45aefe.webp"
"MediaSize" => 55051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017900/thumbnail-174f62c8c79bdb07994f61a61b45aefe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549268"
"ResourceRecordKey" => "30017900"
"ModificationTimestamp" => "2026-07-10T16:54:36.03Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30017900_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017900/bab9549d0f15361de7f133db0ee914ac.webp"
"MediaSize" => 49077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017900/thumbnail-bab9549d0f15361de7f133db0ee914ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549268"
"ResourceRecordKey" => "30017900"
"ModificationTimestamp" => "2026-07-10T16:54:36.03Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30017900_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017900/7302cfe80a4f656603fc1a006fd3f2b3.webp"
"MediaSize" => 50868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017900/thumbnail-7302cfe80a4f656603fc1a006fd3f2b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549268"
"ResourceRecordKey" => "30017900"
"ModificationTimestamp" => "2026-07-10T16:54:36.03Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30017900_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017900/9ed90baade2c1d750800de8fd12a6d94.webp"
"MediaSize" => 48058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017900/thumbnail-9ed90baade2c1d750800de8fd12a6d94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549268"
"ResourceRecordKey" => "30017900"
"ModificationTimestamp" => "2026-07-10T16:54:36.03Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30017900_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017900/5cff13e1fff81d013febb561d23f1895.webp"
"MediaSize" => 57885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017900/thumbnail-5cff13e1fff81d013febb561d23f1895.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549268"
"ResourceRecordKey" => "30017900"
"ModificationTimestamp" => "2026-07-10T16:54:36.03Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30017900_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017900/12d6a2b93250b9c674e4277704814f66.webp"
"MediaSize" => 58247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017900/thumbnail-12d6a2b93250b9c674e4277704814f66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549268"
"ResourceRecordKey" => "30017900"
"ModificationTimestamp" => "2026-07-10T16:54:36.03Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30017900_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017900/38eb2442d347dcba3b4033dc2fc8d0fa.webp"
"MediaSize" => 74273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017900/thumbnail-38eb2442d347dcba3b4033dc2fc8d0fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549268"
"ResourceRecordKey" => "30017900"
"ModificationTimestamp" => "2026-07-10T16:54:36.03Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017900')"
+"ID": "1617764"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1617765"
+post_author: 1
+"ListingKey": "30017467"
+"ListingId": "40845991"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T16:30:04Z"
+"RFModificationTimestamp": "2026-07-10T17:02:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 7.26
+"LivingArea": 801.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "255 NORTHFIELD Drive E Unit# 505, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.521855
1 => 43.5104204
]
+"Latitude": 43.5104204
+"Longitude": -80.521855
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone Condominiums, one of Waterloo's premier communities, where contemporary style, exceptional amenities, and an outstanding location come together. This beautifully maintained 2-bedroom, 2-bathroom suite offers over 800 sq. ft. of bright, open-concept living space designed for comfort and convenience. The modern kitchen features quartz countertops, stainless steel appliances, a subway tile backsplash, generous cabinetry, and a large island overlooking the spacious living area. Expansive windows flood the suite with natural light, while the private balcony provides the perfect place to enjoy your morning coffee or relax at the end of the day. The primary bedroom offers a private ensuite, while the second bedroom and full bathroom provide ideal space for guests, or a dedicated home office. In-suite laundry, and designated surface parking space, complete the package. Heat and Rogers high-speed internet are included, adding even greater value and convenience. Residents enjoy an exceptional collection of amenities, including a fully equipped fitness centre, co-working lounge, large party, games and media rooms, rooftop terrace with BBQs, landscaped outdoor spaces, bike storage, pet wash station, secure keyless entry, and 24-hour security. Ideally located just steps from Browns SocialHouse, shopping, public transit, and scenic walking trails, and only minutes to Conestoga Mall, RIM Park, St. Jacobs Farmers' Market, Waterloo & Laurier Universities, Conestoga College, and major highways, this is an exceptional opportunity to enjoy maintenance-free living in one of Waterloo's most desirable condominium communities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T17:02:19.167977+00:00"
+"Directions": "NORTHFIELD TO BRIDGE ST"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238484"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"LotSizeDimensions": "7.26"
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-10T16:18:31Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T16:18:31Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1680126194"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845991"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017467"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T16:18:31.6Z"
]
1 => array:11 [
"RoomKey" => "1680126195"
"RoomType" => "Full bathroom"
"ListingId" => "40845991"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017467"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T16:18:31.6Z"
]
2 => array:11 [
"RoomKey" => "1680126196"
"RoomType" => "Bedroom"
"ListingId" => "40845991"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017467"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T16:18:31.6Z"
]
3 => array:11 [
"RoomKey" => "1680126197"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845991"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017467"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T16:18:31.6Z"
]
4 => array:11 [
"RoomKey" => "1680126198"
"RoomType" => "Living room"
"ListingId" => "40845991"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017467"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T16:18:31.6Z"
]
5 => array:11 [
"RoomKey" => "1680126199"
"RoomType" => "Kitchen"
"ListingId" => "40845991"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017467"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T16:18:31.6Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30017467/255-northfield-drive-e-unit-505-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2059475"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292003"
+"GeocodeManualYN": true
+"TotalActualRent": 2200
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 158.0
+"AboveGradeFinishedArea": 801
+"OriginalEntryTimestamp": "2026-07-10T16:18:31.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1476314"
+"ListOfficeNationalAssociationId": "1407357"
+"CoListAgentNationalAssociationId": "1334623"
+"CoListOfficeNationalAssociationId": "1407357"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30017467_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017467/9ee7ac135283f2d5e061c9d97170874a.webp"
"MediaSize" => 80547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017467/thumbnail-9ee7ac135283f2d5e061c9d97170874a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845991"
"ResourceRecordKey" => "30017467"
"ModificationTimestamp" => "2026-07-10T16:18:31.57Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30017467_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017467/b5329a86990a641c9a2587fc2cc2a121.webp"
"MediaSize" => 53177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017467/thumbnail-b5329a86990a641c9a2587fc2cc2a121.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845991"
"ResourceRecordKey" => "30017467"
"ModificationTimestamp" => "2026-07-10T16:18:31.57Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30017467_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017467/26bc0dc330bd0456a3658c07bd699527.webp"
"MediaSize" => 48842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017467/thumbnail-26bc0dc330bd0456a3658c07bd699527.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845991"
"ResourceRecordKey" => "30017467"
"ModificationTimestamp" => "2026-07-10T16:18:31.57Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30017467_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017467/d10dbd0fd5570e44800bcbe53ce211f9.webp"
"MediaSize" => 46887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017467/thumbnail-d10dbd0fd5570e44800bcbe53ce211f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845991"
"ResourceRecordKey" => "30017467"
"ModificationTimestamp" => "2026-07-10T16:18:31.57Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30017467_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017467/31d1ff91338402e2454faa70e4050563.webp"
"MediaSize" => 45602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017467/thumbnail-31d1ff91338402e2454faa70e4050563.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845991"
"ResourceRecordKey" => "30017467"
"ModificationTimestamp" => "2026-07-10T16:18:31.57Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30017467_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017467/0fe5f040d4cc67f43ef183f1d09c13d1.webp"
"MediaSize" => 56129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017467/thumbnail-0fe5f040d4cc67f43ef183f1d09c13d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845991"
"ResourceRecordKey" => "30017467"
"ModificationTimestamp" => "2026-07-10T16:18:31.57Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30017467_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017467/a07609a686586ca36eda91a4681da75f.webp"
"MediaSize" => 56207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017467/thumbnail-a07609a686586ca36eda91a4681da75f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845991"
"ResourceRecordKey" => "30017467"
"ModificationTimestamp" => "2026-07-10T16:18:31.57Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30017467_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017467/8c5417d020264ceb347c742222ee5cc9.webp"
"MediaSize" => 72288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017467/thumbnail-8c5417d020264ceb347c742222ee5cc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845991"
"ResourceRecordKey" => "30017467"
"ModificationTimestamp" => "2026-07-10T16:18:31.57Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017467')"
+"ID": "1617765"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1590681"
+post_author: 1
+"ListingKey": "29986040"
+"ListingId": "40845068"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:25:13Z"
+"RFModificationTimestamp": "2026-07-03T19:52:33Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1901.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0E9"
+"UnparsedAddress": "271 GREY SILO Road Unit# 74, Waterloo, Ontario N2K0E9"
+"Coordinates": array:2 [
0 => -80.4960123
1 => 43.5232676
]
+"Latitude": 43.5232676
+"Longitude": -80.4960123
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience contemporary living in this beautifully maintained like new executive townhome, perfectly situated in one of the area's most desirable communities. Offering 4 spacious bedrooms and 3.5 bathrooms, this exceptional home delivers the perfect combination of luxury, comfort, and functionality. A spacious main-floor bedroom with a private ensuite offers exceptional flexibility, providing the perfect accommodation for aging parents, extended family, guests, or young adults who value their own privacy and independence. Second floor: discover a bright, open-concept floor plan filled with natural light from oversized windows. Stylish chef-inspired kitchen showcases premium stainless steel appliances, elegant granite countertops, abundant cabinetry, and generous workspace—perfect for preparing family meals or hosting friends. Upstairs, you'll find three well-appointed bedrooms, including a spacious primary retreat with a luxurious ensuite bathroom and ample closet space, creating the perfect place to relax and unwind. Additional highlights include: Like-new home with contemporary finishes throughout 4 generous bedrooms & 3.5 bathrooms Bright open-concept layout with abundant natural light Gourmet kitchen with granite countertops & stainless steel appliances Spacious primary suite with private ensuite Fully finished basement with bedroom & full bath Ideal for multi-generational living or extended family Located in a welcoming, family-friendly neighborhood close to RIM Park, Grey Silo Golf Course, shopping mall, schools, and everyday amenities. Tenants need to remove snow from their porch and steps to the house. The condo corperation is responsible for snow removal and lawn. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:52:28.834136+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-07-03T18:18:23Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:18:23Z"
+"Stories": "3.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "271"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1674297095"
"RoomType" => "3pc Bathroom"
"ListingId" => "40845068"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.71Z"
]
1 => array:11 [
"RoomKey" => "1674297096"
"RoomType" => "Bedroom"
"ListingId" => "40845068"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.71Z"
]
2 => array:11 [
"RoomKey" => "1674297097"
"RoomType" => "Bedroom"
"ListingId" => "40845068"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.71Z"
]
3 => array:11 [
"RoomKey" => "1674297098"
"RoomType" => "Full bathroom"
"ListingId" => "40845068"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.71Z"
]
4 => array:11 [
"RoomKey" => "1674297099"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845068"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.72Z"
]
5 => array:11 [
"RoomKey" => "1674297100"
"RoomType" => "2pc Bathroom"
"ListingId" => "40845068"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.72Z"
]
6 => array:11 [
"RoomKey" => "1674297101"
"RoomType" => "Dining room"
"ListingId" => "40845068"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.72Z"
]
7 => array:11 [
"RoomKey" => "1674297102"
"RoomType" => "Kitchen"
"ListingId" => "40845068"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.72Z"
]
8 => array:11 [
"RoomKey" => "1674297103"
"RoomType" => "Living room"
"ListingId" => "40845068"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.72Z"
]
9 => array:11 [
"RoomKey" => "1674297104"
"RoomType" => "Utility room"
"ListingId" => "40845068"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.72Z"
]
10 => array:11 [
"RoomKey" => "1674297105"
"RoomType" => "Full bathroom"
"ListingId" => "40845068"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.72Z"
]
11 => array:11 [
"RoomKey" => "1674297106"
"RoomType" => "Bedroom"
"ListingId" => "40845068"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986040"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:23.72Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986040/271-grey-silo-road-unit-74-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 3400
+"ZoningDescription": "MR-4/MD3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1901
+"OriginalEntryTimestamp": "2026-07-03T18:18:23.63Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1413428"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986040_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/d232457f8ea223358b2b44dfc4940d5d.webp"
"MediaSize" => 125046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-d232457f8ea223358b2b44dfc4940d5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern multi-level townhome featuring a mixed-material facade with brick, siding, and stucco"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986040_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/4d3dff45b81183c366ba5233937fcfc2.webp"
"MediaSize" => 98292
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-4d3dff45b81183c366ba5233937fcfc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986040_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/7edd95fed9841f77b4bda2b466909165.webp"
"MediaSize" => 78312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-7edd95fed9841f77b4bda2b466909165.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a contemporary kitchen with dark cabinetry and a central island, and a sliding glass door with horizontal blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986040_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/2e5e1d6005d2ca68341c7244560d0878.webp"
"MediaSize" => 79732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-2e5e1d6005d2ca68341c7244560d0878.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a central island with dual sinks, dark wood cabinetry, and speckled countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986040_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/f3547c17b8b493a75070a10d14dd1e54.webp"
"MediaSize" => 97578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-f3547c17b8b493a75070a10d14dd1e54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring rich dark wood-finish cabinetry, stainless steel appliances, granite countertops, a white subway tile backsplash, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986040_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/d762555de814951b7527053a1ddedf08.webp"
"MediaSize" => 54746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-d762555de814951b7527053a1ddedf08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry closet featuring a new front-loading washer and dryer, finished with a neutral wall color and white bi-fold doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986040_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/93fce54ee451c8bab9940ceb796577e1.webp"
"MediaSize" => 67307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-93fce54ee451c8bab9940ceb796577e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white tub with subway tile surround, recessed lighting, and a vanity with an integrated sink and wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986040_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/727782afb8aef45a0f8eb680c34be8cf.webp"
"MediaSize" => 74258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-727782afb8aef45a0f8eb680c34be8cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary exterior featuring a two-car garage with frosted glass inserts, a second-story balcony with glass railings, and a striking combination of wood-look siding, light gray horizontal siding, a"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29986040_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/c7e5e477d96e79a1e9a84c58f3954f82.webp"
"MediaSize" => 76308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-c7e5e477d96e79a1e9a84c58f3954f82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern multi-level townhome featuring a mixed material facade, a glass-paneled balcony, a grey sectional garage door with horizontal glass inserts, black brick accents, and contemporary exterior light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29986040_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/573aae1a87aac9d462f612809f85c5ab.webp"
"MediaSize" => 74096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-573aae1a87aac9d462f612809f85c5ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29986040_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/2654ef4908f28df03b14e000ae699271.webp"
"MediaSize" => 84061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986040/thumbnail-2654ef4908f28df03b14e000ae699271.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern townhomes featuring brick and wood-finish siding with integrated garage doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845068"
"ResourceRecordKey" => "29986040"
"ModificationTimestamp" => "2026-07-03T18:18:23.64Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29986040_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986040/314242b591e4550c01b608395f5f2393.webp"
"MediaSize" => 76787
"MediaType" => "webp"
…8
]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986040')"
+"ID": "1590681"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1553134"
+post_author: 1
+"ListingKey": "29934803"
+"ListingId": "X13472536"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T23:10:15Z"
+"RFModificationTimestamp": "2026-06-22T23:15:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "314 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.519898
1 => 43.5104862
]
+"Latitude": 43.5104862
+"Longitude": -80.519898
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience contemporary living in the vibrant Blackstone Condos with this spacious 2-bedroom, 2-bathroom carpet-free unit. The modern kitchen, complete with quartz countertops, flows into an open living space that extends to a generous balcony that is perfect for enjoying your morning coffee or relaxing in the evening. The primary bedroom features a walk-in closet and private ensuite, while in-suite laundry adds extra convenience. The Blackstone Condos offer exceptional amenities, including a lounge to host your gatherings, a gym, co-working space, bike storage, rooftop terrace with an outdoor kitchen and fireplace, and a second terrace with a hot tub! Situated close to shopping, restaurants, bakeries, highways, and schools, this location is as convenient as it is stylish. **Available August 1,2026.** The rent includes heat, air conditioning, high-speed internet, one parking spot, and an exclusive locker for seasonal storage.** (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T03:31:57.126853+00:00"
+"Directions": "Northfield Drive and Bridge Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Concrete Block"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239619"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T23:05:04Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T23:05:04Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29934803/314-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2093834"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "MF Property Management"
+"CoListOfficeKey": "294392"
+"GeocodeManualYN": true
+"TotalActualRent": 2199
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"SecurityFeatures": array:1 [
0 => "Controlled entry"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-22T01:46:21.76Z"
+"ListAgentNationalAssociationId": "1477575"
+"ListOfficeNationalAssociationId": "1438599"
+"CoListAgentNationalAssociationId": "1366291"
+"CoListOfficeNationalAssociationId": "1438599"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 24
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29934803')"
+"ID": "1553134"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+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 [ …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/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 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
]
+"DaysOnMarket": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919011')"
+"ID": "1541147"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+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": 49
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29814426')"
+"ID": "1467944"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1313633"
+post_author: 1
+"ListingKey": "29599023"
+"ListingId": "X12993512"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T20:20:45Z"
+"RFModificationTimestamp": "2026-06-02T20:31:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G6"
+"UnparsedAddress": "107 - 245 GREY SILO ROAD, Waterloo, Ontario N2K0G6"
+"Coordinates": array:2 [
0 => -80.497634
1 => 43.521881
]
+"Latitude": 43.521881
+"Longitude": -80.497634
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "*Large Outdoor Patio* Welcome Home! This bright CORNER unit in the sought-after Carriage Crossing community features a carpet-free, open-concept layout with stylish upgrades throughout. Enjoy a spacious living area filled with natural light and a modern kitchen complete with quartz countertops, subway tile backsplash, KitchenAid stainless steel appliances, and a large island with a sit up breakfast bar. Step outside to your impressive wraparound balcony offering nearly 650 sq ft of private outdoor space, plus access to an incredible rooftop terrace which features: a fire table and lounging area, BBQ area, planter gardens, and stunning views. Conveniently located near amenities, highways, universities, and colleges, it offers easy access to public transit, Blackberry, Conestoga Mall, St. Jacobs Farmers Market, and beautiful walking and biking trails. Plus, it's just a quick walk to RIM Park & Grey Silo Golf Course. This home is a perfect combination of comfort, convenience, style, and indoor-outdoor living! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-14T05:25:36.397539+00:00"
+"Directions": "Cross Streets: University Ave and Millennium Blvd. ** Directions: North on University Ave E then east on Millennium Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1640509"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-04-14T00:15:41Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T20:12:59Z"
+"StreetName": "Grey Silo"
+"StreetNumber": "245"
+"StreetSuffix": "Road"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29599023/107-245-grey-silo-road-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2800
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-04-14T00:15:41.36Z"
+"ListAgentNationalAssociationId": "1164837"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:14 [
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]
]
+"DaysOnMarket": 93
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29599023')"
+"ID": "1313633"
}
]
+success: true
+page_size: 8
+page_count: 1
+count: 8
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]