array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29180619/Property?$select=ALL&$top=20&$filter=ListingKey eq 29180619&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29180619/Property?$select=ALL&$top=20&$filter=ListingKey eq 29180619&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23632
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23634
+post_id: "475761"
+post_author: 1
+"ListingKey": "29180619"
+"ListingId": "40793474"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T19:05:43Z"
+"RFModificationTimestamp": "2025-12-11T19:19:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3R5"
+"UnparsedAddress": "455 KINGSCOURT Drive Unit# 3, Waterloo, Ontario N2K3R5"
+"Coordinates": array:2 [
0 => -80.5228476
1 => 43.4940991
]
+"Latitude": 43.4940991
+"Longitude": -80.5228476
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this cozy and spacious 2-bedroom, 2-bath townhome located in a quiet, family-friendly community in the heart of Waterloo’s highly desirable Lexington area. With bright living spaces, modern finishes, and convenient access to schools, parks, shopping, and transit, this home is perfect for young professionals, families, or anyone seeking comfort and convenience. Contact us today to see this rental unit! 2 Spacious Bedrooms (Master has walk-in closet) 2 Bathrooms 5 Appliances Included – Fridge, Stove, Dishwasher, Washer, and Dryer Ensuite Laundry – Enjoy private in-unit laundry Water Softener Included Eat-In Kitchen Large Bedrooms Google Smart thermostat Ample Natural Light – Bright and welcoming atmosphere Private Backyard patio 3 Parking Spots (1 in garage, 2 in driveway - Tandem) Snow & Lawn Maintenance are included ** Rent: $2500.00 Plus Utilities Available December 15th, 2025!! ** ***See sales brochure below below for showing instructions*** (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T19:19:00.425762+00:00"
+"Directions": "Lexington/Davenport"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T18:58:24Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-11T18:58:24Z"
+"Stories": "2.0"
+"StreetName": "KINGSCOURT"
+"StreetNumber": "455"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1547494755"
"RoomType" => "Recreation room"
"ListingId" => "40793474"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29180619"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T18:58:24.47Z"
]
1 => array:11 [
"RoomKey" => "1547494756"
"RoomType" => "Bedroom"
"ListingId" => "40793474"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29180619"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T18:58:24.47Z"
]
2 => array:11 [
"RoomKey" => "1547494757"
"RoomType" => "Bedroom"
"ListingId" => "40793474"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29180619"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T18:58:24.47Z"
]
3 => array:11 [
"RoomKey" => "1547494758"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793474"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29180619"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T18:58:24.47Z"
]
4 => array:11 [
"RoomKey" => "1547494759"
"RoomType" => "Living room"
"ListingId" => "40793474"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29180619"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 18'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T18:58:24.47Z"
]
5 => array:11 [
"RoomKey" => "1547494760"
"RoomType" => "Kitchen"
"ListingId" => "40793474"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29180619"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T18:58:24.47Z"
]
6 => array:11 [
"RoomKey" => "1547494761"
"RoomType" => "2pc Bathroom"
"ListingId" => "40793474"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29180619"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-11T18:58:24.48Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29180619/455-kingscourt-drive-unit-3-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2500
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 15.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2025-12-11T18:58:24.33Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:22 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6364474166"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/14df2bc1a9e692e8a700f921d27853cf.webp"
"MediaSize" => 88176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-14df2bc1a9e692e8a700f921d27853cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of property featuring asphalt driveway, an attached garage, roof with shingles, and a front lawn"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6364474215"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/5795a3464902a73161e1b8509492d329.webp"
"MediaSize" => 127224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-5795a3464902a73161e1b8509492d329.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of house featuring a patio area, entry steps, brick siding, and a lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6364474259"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/fa93e15c0aa770fca0bf4caa536eb026.webp"
"MediaSize" => 124143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-fa93e15c0aa770fca0bf4caa536eb026.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back of house with a patio and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6364474351"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/66ea82325e85c72bffe69edde84b0577.webp"
"MediaSize" => 133511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-66ea82325e85c72bffe69edde84b0577.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of yard with a patio area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6364474421"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/c8fdafb5b80b57bd72b8a125cd086d79.webp"
"MediaSize" => 107100
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-c8fdafb5b80b57bd72b8a125cd086d79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6364474448"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/5e9263195d308cc63d739ea668fc17f5.webp"
"MediaSize" => 85360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-5e9263195d308cc63d739ea668fc17f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6364474509"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/c5cbeef56e28ff49b02818abe8ad7526.webp"
"MediaSize" => 84104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-c5cbeef56e28ff49b02818abe8ad7526.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with freestanding refrigerator, a desk, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6364474580"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/454719802a10cb37a8b54e9ba11dc81e.webp"
"MediaSize" => 33503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-454719802a10cb37a8b54e9ba11dc81e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious closet featuring carpet floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6364474630"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/9ca0f07dbe9d6e643fe6eb88967ac799.webp"
"MediaSize" => 43188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-9ca0f07dbe9d6e643fe6eb88967ac799.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted spare room featuring baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6364474676"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/7fa5d058062b31a76d13f9003d53d958.webp"
"MediaSize" => 47044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-7fa5d058062b31a76d13f9003d53d958.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom with a spacious closet and light carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6364474744"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/8fe404ebe2bf51560d2b09a09455c978.webp"
"MediaSize" => 47727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-8fe404ebe2bf51560d2b09a09455c978.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom with a closet and carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6364474808"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/ce7bda1691d4b4223e8e075ceaf8cc7d.webp"
"MediaSize" => 42908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-ce7bda1691d4b4223e8e075ceaf8cc7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity and shower / bath combination"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6364474823"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/8531f906e0237482d0dee4e66a48b0d3.webp"
"MediaSize" => 32593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-8531f906e0237482d0dee4e66a48b0d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity and toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6364474865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/f450c2e640c3b01a9257caa88bb4c9fe.webp"
"MediaSize" => 53908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-f450c2e640c3b01a9257caa88bb4c9fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6364474911"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/39606e770ee70b07bfee4830db63299d.webp"
"MediaSize" => 44532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-39606e770ee70b07bfee4830db63299d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Doorway featuring baseboards and stairway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6364474921"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/260b11c3f7b049d6a4ca74381fba254b.webp"
"MediaSize" => 60011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-260b11c3f7b049d6a4ca74381fba254b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring stairs and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6364474971"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/c428a84761bf6e15d527a558c897fc73.webp"
"MediaSize" => 30968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-c428a84761bf6e15d527a558c897fc73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring baseboards and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6364474987"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/d7e856c5780aa789ab10ddb4575cb7fb.webp"
"MediaSize" => 37720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-d7e856c5780aa789ab10ddb4575cb7fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room featuring baseboards and dark wood-type flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6364475006"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/9946ac897c67da474e25bba9e6add5d8.webp"
"MediaSize" => 47757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-9946ac897c67da474e25bba9e6add5d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring wood-type flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6364475035"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/d798a0f7263e3d87917118a378cfb3d4.webp"
"MediaSize" => 52220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-d798a0f7263e3d87917118a378cfb3d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room featuring baseboards and dark wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6364475055"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/53d895b14f63bf067cc6a79ccb2d3969.webp"
"MediaSize" => 47104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-53d895b14f63bf067cc6a79ccb2d3969.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light countertops, light tile patterned floors, and white appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6364475123"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180619/324400311b49c7d429dc53f674a639e4.webp"
"MediaSize" => 37954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180619/thumbnail-324400311b49c7d429dc53f674a639e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Half bathroom featuring vanity and toilet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793474"
"ResourceRecordKey" => "29180619"
"ModificationTimestamp" => "2025-12-11T18:58:24.34Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "Corry Van Iersel"
"MemberFirstName" => "Corry"
"MemberLastName" => "Van Iersel"
"MemberMlsId" => "CA5984"
"OriginatingSystemName" => 26
"MemberKey" => "1834563"
"ModificationTimestamp" => "2025-10-28T23:28:48Z"
"MemberMiddleName" => "Christopher"
"MemberStatus" => "Active"
"OfficeKey" => "300202"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Broker of Record"
"MemberCity" => "Cambridge"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-242-0277"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2009-04-07T20:41:00Z"
"MemberNationalAssociationId" => "1196776"
"OfficeNationalAssociationId" => "1484182"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "Vancor Realty Inc."
"OfficePhone" => "519-242-0277"
"OfficeMlsId" => "WR50949"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "300202"
"ModificationTimestamp" => "2025-11-21T15:46:40Z"
"OfficeAddress1" => "1425 Bishop St. N. Unit 1"
"OfficeCity" => "Cambridge"
"OfficePostalCode" => "N1R6J"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2025-06-16T18:10:00Z"
"OfficeNationalAssociationId" => "1484182"
"OfficeBrokerNationalAssociationId" => "1196776"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29180619')"
+"ID": "475761"
}
]
+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 300202/Office?$select=ALL&$top=10&$filter=OfficeKey eq 300202&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 300202/Office?$select=ALL&$top=10&$filter=OfficeKey eq 300202&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25443
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Vancor Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "519-242-0277"
+"OfficeMlsId": "WR50949"
+"ModificationTimestamp": "2025-11-21T15:46:40Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "300202"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1425 Bishop St. N. Unit 1"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Cambridge"
+"OfficePostalCode": "N1R6J"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1484182"
+"OriginalEntryTimestamp": "2025-06-16T18:10:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "434736"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "300202"
"SocialMediaUrlOrId" => "http://www.vancorgroup.com/"
"ModificationTimestamp" => "2025-11-21T13:58:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1196776"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('300202')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1834563/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1834563&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1834563/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1834563&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25446
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29180619" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25076
+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 29180619/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29180619&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29180619/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29180619&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25056
+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 29180619 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5228476 43.4940991)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29180619 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5228476 43.4940991)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29180619 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5228476 43.4940991)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29180619 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5228476 43.4940991)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24889
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "487319"
+post_author: 1
+"ListingKey": "29192639"
+"ListingId": "40794242"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T21:15:21Z"
+"RFModificationTimestamp": "2025-12-17T22:55:16Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 854.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "255 NORTHFIELD Drive E Unit# 407, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5212228
1 => 43.511129
]
+"Latitude": 43.511129
+"Longitude": -80.5212228
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover modern living at its finest at Blackstone Condos in Waterloo East! Built in 2020, this stunning 2-bed, 2-bath unit offers over 850 sqft of open-concept space with 9' ceilings, large windows, and a private balcony that fills the home with beautiful natural light. The sleek kitchen features white cabinetry, quartz countertops, stainless steel appliances, and a subway tile backsplash, complemented by premium laminate flooring throughout. The spacious layout includes a primary bedroom with ensuite and a second bedroom with a nicely sized closet, plus in-suite laundry for added convenience. Enjoy upscale amenitiesfitness center, co-working space, event lounge, bike storage, and a rooftop terrace with BBQs, fire pit, and courtyard views. Steps to Browns Socialhouse, shops, transit, and minutes to St. Jacobs Market, trails, and highways. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "648"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T22:54:59.167978+00:00"
+"Directions": "Bridge St W and Northfield Dr E"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130012"
+"ListOfficeKey": "283981"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-17T21:08:23Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T21:08:23Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3754"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1550530082"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.57Z"
]
1 => array:11 [
"RoomKey" => "1550530083"
"RoomType" => "Living room"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.57Z"
]
2 => array:11 [
"RoomKey" => "1550530084"
"RoomType" => "Bedroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.58Z"
]
3 => array:11 [
"RoomKey" => "1550530085"
"RoomType" => "4pc Bathroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.58Z"
]
4 => array:11 [
"RoomKey" => "1550530086"
"RoomType" => "Primary Bedroom"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.58Z"
]
5 => array:11 [
"RoomKey" => "1550530087"
"RoomType" => "Kitchen"
"ListingId" => "40794242"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29192639"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T21:08:23.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29192639/255-northfield-drive-e-unit-407-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 854
+"OriginalEntryTimestamp": "2025-12-17T21:08:23.47Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:36 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6373648973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/54e8234adabc58cb794640760e93d88f.webp"
"MediaSize" => 82637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-54e8234adabc58cb794640760e93d88f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6373649047"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/bdda557086f5387924a5f87982914e68.webp"
"MediaSize" => 57635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-bdda557086f5387924a5f87982914e68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6373649116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/2d4d9abd26c5de9b8c0d04d966fe174a.webp"
"MediaSize" => 67357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-2d4d9abd26c5de9b8c0d04d966fe174a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6373649170"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/5698c9a2abc85ab90dd489184241f2fa.webp"
"MediaSize" => 76614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-5698c9a2abc85ab90dd489184241f2fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6373649236"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/9e0675e6bd61be97733bd5ad7e3ecd08.webp"
"MediaSize" => 80226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-9e0675e6bd61be97733bd5ad7e3ecd08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6373649291"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/f7a86e5501cedb42130368e5d183e028.webp"
"MediaSize" => 51074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-f7a86e5501cedb42130368e5d183e028.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6373649325"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/c2d2dda3e09b050a03d82b5374ef6d10.webp"
"MediaSize" => 81686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-c2d2dda3e09b050a03d82b5374ef6d10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6373649365"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/5989be1d441fddae3ba311ba75ee6089.webp"
"MediaSize" => 68522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-5989be1d441fddae3ba311ba75ee6089.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6373649427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/ddbb99f02add7fee2300d88188a17eaf.webp"
"MediaSize" => 99731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-ddbb99f02add7fee2300d88188a17eaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6373649472"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/f2dc0e65cbe1ca18fa2d1b2f7ef7b990.webp"
"MediaSize" => 117274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-f2dc0e65cbe1ca18fa2d1b2f7ef7b990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6373649518"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/e8c30fcfb6c70d8fcd636c042b719591.webp"
"MediaSize" => 131386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-e8c30fcfb6c70d8fcd636c042b719591.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6373649551"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/93a396c5c622a6e87ccd3e58272f61e9.webp"
"MediaSize" => 119226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-93a396c5c622a6e87ccd3e58272f61e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6373649582"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/49792e6f7fe7336d7097612bd44eaf44.webp"
"MediaSize" => 69998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-49792e6f7fe7336d7097612bd44eaf44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6373649637"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/aaaf3b0bcc99b720c93e20bdd2f8eb6c.webp"
"MediaSize" => 51117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-aaaf3b0bcc99b720c93e20bdd2f8eb6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6373649656"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/86ab1f26ed325821c4fb362a255b3b5f.webp"
"MediaSize" => 53194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-86ab1f26ed325821c4fb362a255b3b5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6373649673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/97698dd279280612e64fe189932ac9e1.webp"
"MediaSize" => 81557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-97698dd279280612e64fe189932ac9e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6373649695"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/5e3cdf94f20a612fee249ccfa776bee3.webp"
"MediaSize" => 68539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-5e3cdf94f20a612fee249ccfa776bee3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6373649709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/72ff187b55b2b9d350edbbe7f5c7e1d3.webp"
"MediaSize" => 153986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-72ff187b55b2b9d350edbbe7f5c7e1d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6373649767"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/b2855cb20d3965ef1abfa11ef8dd3530.webp"
"MediaSize" => 122229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-b2855cb20d3965ef1abfa11ef8dd3530.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6373649816"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/acedb223354cf37960f1bc66e7b72ddf.webp"
"MediaSize" => 61861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-acedb223354cf37960f1bc66e7b72ddf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6373649859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/5ce5f81c6c838c3a760be1847311d9ab.webp"
"MediaSize" => 61850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-5ce5f81c6c838c3a760be1847311d9ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6373649896"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/9861abf58362ff18728f9e0278be5d25.webp"
"MediaSize" => 48751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-9861abf58362ff18728f9e0278be5d25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6373649930"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/6da8eca6a22bac0d097434eea54682f1.webp"
"MediaSize" => 62610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-6da8eca6a22bac0d097434eea54682f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6373649968"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/129e1b383db62f267c3a761986add102.webp"
"MediaSize" => 58819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-129e1b383db62f267c3a761986add102.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6373650013"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/3aff4f063a355b006c14ce99cad87229.webp"
"MediaSize" => 100047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-3aff4f063a355b006c14ce99cad87229.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6373650044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/6e4d879b142e36e683820b705ff46a0e.webp"
"MediaSize" => 71411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-6e4d879b142e36e683820b705ff46a0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6373650098"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/67a8febf8abfd42917d1574872a196be.webp"
"MediaSize" => 119691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-67a8febf8abfd42917d1574872a196be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6373650145"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/d77b0704b752b962966e5b9180c32a10.webp"
"MediaSize" => 83346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-d77b0704b752b962966e5b9180c32a10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6373650177"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/77d8998b8e5acbc81d44742e5392e236.webp"
"MediaSize" => 45489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-77d8998b8e5acbc81d44742e5392e236.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6373650204"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/6019b74558debd8112ebb3f634c87bb6.webp"
"MediaSize" => 91769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-6019b74558debd8112ebb3f634c87bb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6373650235"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/3c06fbe7b7234d06c3fc5e0f2b40e30f.webp"
"MediaSize" => 30871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-3c06fbe7b7234d06c3fc5e0f2b40e30f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6373650273"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/0601513fd3c8451e7f34b10575d8e0a2.webp"
"MediaSize" => 118729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-0601513fd3c8451e7f34b10575d8e0a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6373650287"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/f29c344ff5cca66f69e086345c9dd0ed.webp"
"MediaSize" => 105923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-f29c344ff5cca66f69e086345c9dd0ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6373650300"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/2aeaa0514216ce9df27f1fbde01429ed.webp"
"MediaSize" => 68499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-2aeaa0514216ce9df27f1fbde01429ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6373650307"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/23c11fb7c0c347374d79ffb4aaa64239.webp"
"MediaSize" => 99748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-23c11fb7c0c347374d79ffb4aaa64239.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6373650325"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192639/0f155a51bb5f6cebe745ae94a064bdc1.webp"
"MediaSize" => 51307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192639/thumbnail-0f155a51bb5f6cebe745ae94a064bdc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794242"
"ResourceRecordKey" => "29192639"
"ModificationTimestamp" => "2025-12-17T21:08:23.48Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "Steve Murria"
"MemberFirstName" => "Steve"
"MemberLastName" => "Murria"
"MemberMlsId" => "MI5414"
"OriginatingSystemName" => 26
"MemberKey" => "2130012"
"ModificationTimestamp" => "2025-12-16T20:48:03Z"
"MemberStatus" => "Active"
"OfficeKey" => "283981"
"MemberAOR" => "Cornerstone"
"JobTitle" => "Broker"
"MemberCity" => "Milton"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "647-984-5304"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2021-03-31T19:41:00Z"
"MemberNationalAssociationId" => "1382976"
"OfficeNationalAssociationId" => "1337575"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "CENTURY 21 GREEN REALTY INC"
"OfficePhone" => "905-565-9565"
"OfficeMlsId" => "MI79"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "283981"
"ModificationTimestamp" => "2025-08-19T15:50:12Z"
"OfficeAddress1" => "10220 Derry Road Unit 204"
"OfficeCity" => "Milton"
"OfficePostalCode" => "L9T7J"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "905-565-9522"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2018-09-21T21:07:00Z"
"OfficeNationalAssociationId" => "1337575"
"FranchiseNationalAssociationId" => "1205554"
"OfficeBrokerNationalAssociationId" => "1337570"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192639')"
+"ID": "487319"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24916
+post_id: "487320"
+post_author: 1
+"ListingKey": "29192761"
+"ListingId": "X12639498"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T21:55:21Z"
+"RFModificationTimestamp": "2025-12-17T22:39:26Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "407 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.521297
1 => 43.510381
]
+"Latitude": 43.510381
+"Longitude": -80.521297
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover modern living at its finest at Blackstone Condos in Waterloo East! Built in 2020, this stunning 2-bed, 2-bath unit offers over 850 sqft of open-concept space with 9' ceilings, large windows, and a private balcony that fills the home with beautiful natural light. The sleek kitchen features white cabinetry, quartz countertops, stainless steel appliances, and a subway tile backsplash, complemented by premium laminate flooring throughout. The spacious layout includes a primary bedroom with ensuite and a second bedroom with a nicely sized closet, plus in-suite laundry for added convenience. Enjoy upscale amenitiesfitness center, co-working space, event lounge, bike storage, and a rooftop terrace with BBQs, fire pit, and courtyard views. Steps to Browns Socialhouse, shops, transit, and minutes to St. Jacobs Market, trails, and highwaysthis is contemporary comfort in the perfect location! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "648"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T22:39:25.446373+00:00"
+"Directions": "Bridge St W and Northfield Dr E"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967928"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-17T21:48:46Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T21:48:46Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3754"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1550544308"
"RoomType" => "Kitchen"
"ListingId" => "X12639498"
"RoomLevel" => "Main level"
"RoomWidth" => 2.79
"ListingKey" => "29192761"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T21:48:46.71Z"
]
1 => array:11 [
"RoomKey" => "1550544309"
"RoomType" => "Living room"
"ListingId" => "X12639498"
"RoomLevel" => "Main level"
"RoomWidth" => 3.12
"ListingKey" => "29192761"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T21:48:46.71Z"
]
2 => array:11 [
"RoomKey" => "1550544310"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12639498"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "29192761"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T21:48:46.71Z"
]
3 => array:11 [
"RoomKey" => "1550544311"
"RoomType" => "Bedroom"
"ListingId" => "X12639498"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29192761"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T21:48:46.71Z"
]
4 => array:11 [
"RoomKey" => "1550544312"
"RoomType" => "Bathroom"
"ListingId" => "X12639498"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29192761"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T21:48:46.72Z"
]
5 => array:11 [
"RoomKey" => "1550544313"
"RoomType" => "Bathroom"
"ListingId" => "X12639498"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29192761"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T21:48:46.72Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29192761/407-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Separate Heating Controls"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-12-17T21:48:46.68Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:36 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6373704287"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192761/2f496f1fb42de347e88ae26bd3e5ac55.webp"
"MediaSize" => 211508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192761/thumbnail-2f496f1fb42de347e88ae26bd3e5ac55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12639498"
"ResourceRecordKey" => "29192761"
"ModificationTimestamp" => "2025-12-17T21:48:46.69Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6373704304"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192761/480fbcc75664fcc6e5aa37d314204457.webp"
"MediaSize" => 111450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192761/thumbnail-480fbcc75664fcc6e5aa37d314204457.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12639498"
"ResourceRecordKey" => "29192761"
"ModificationTimestamp" => "2025-12-17T21:48:46.69Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6373704354"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29192761/2a749665ddf5a2bc719ac6291b065008.webp"
"MediaSize" => 152179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29192761/thumbnail-2a749665ddf5a2bc719ac6291b065008.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192761')"
+"ID": "487320"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "486928"
+post_author: 1
+"ListingKey": "29192622"
+"ListingId": "40794359"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T21:05:42Z"
+"RFModificationTimestamp": "2025-12-17T21:19:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 804.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6R4"
+"UnparsedAddress": "736 OLD ALBERT Street Unit# 102, Waterloo, Ontario N2L6R4"
+"Coordinates": array:2 [
0 => -80.5436452
1 => 43.4895277
]
+"Latitude": 43.4895277
+"Longitude": -80.5436452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Well-located ground-level 2-bedroom unit with 2 parking spaces, situated in a quiet and safe area, with easy access to the highway, University of Waterloo, Wilfrid Laurier University, nearby plazas, and Conestoga Mall. Available for sublease until August 31, 2026, or with the option to take over the existing lease, and can be offered furnished with items such as a dining table, bed and dresser, office desk, and microwave. Immediate occupancy available. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
4 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T21:19:42.855267+00:00"
+"Directions": "Parkside Dr to Glenelm to Old Albert"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
3 => "Laundry- Coin operated"
]
+"PhotosChangeTimestamp": "2025-12-17T20:59:48Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T20:59:48Z"
+"Stories": "1.0"
+"StreetName": "OLD ALBERT"
+"StreetNumber": "736"
+"StreetSuffix": "Street"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29192622/736-old-albert-street-unit-102-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1750
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 298.0
+"AboveGradeFinishedArea": 804
+"OriginalEntryTimestamp": "2025-12-17T20:59:48.09Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:13 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29192622')"
+"ID": "486928"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "485832"
+post_author: 1
+"ListingKey": "29191002"
+"ListingId": "X12637728"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T02:55:26Z"
+"RFModificationTimestamp": "2025-12-17T03:25:29Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0B7"
+"UnparsedAddress": "1310 - 318 SPRUCE STREET, Waterloo, Ontario N2L0B7"
+"Coordinates": array:2 [
0 => -80.526389
1 => 43.479
]
+"Latitude": 43.479
+"Longitude": -80.526389
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is a stunning 2-bedroom unit (with the living room converted into a 3rd bedroom, can be converted back to 2 bedroom) featuring an open balcony. A fantastic opportunity for investors or university parents in waterloo, located within walking distance of Wilfrid Laurier University and just a 6-minute drive to the University of Waterloo. Conveniently close to Express Hwy 85 and the LRT, the property is surrounded by numerous restaurants, shopping options, and a nearby cinema, making it an ideal location for both students and professionals. (id:62650)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Dryer"
2 => "Microwave"
]
+"AssociationFee": "610"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-17T03:25:11.217257+00:00"
+"Directions": "Hickory St W Between Hickory"
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1940824"
+"ListOfficeKey": "274886"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-12-17T02:48:28Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T02:48:28Z"
+"StreetName": "Spruce"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3800"
+"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/29191002/1310-318-spruce-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-12-17T02:48:28.74Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29191002')"
+"ID": "485832"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "485380"
+post_author: 1
+"ListingKey": "29190417"
+"ListingId": "40794074"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T22:05:18Z"
+"RFModificationTimestamp": "2025-12-16T22:37:23Z"
+"ListPrice": 439900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1087.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3V5"
+"UnparsedAddress": "643 ALBERT Street Unit# 2, Waterloo, Ontario N2L3V5"
+"Coordinates": array:2 [
0 => -80.5412026
1 => 43.4906865
]
+"Latitude": 43.4906865
+"Longitude": -80.5412026
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Amazing location—perfect for a first-time home buyer, a parent with a student attending one of the nearby universities, or an investor looking for strong cash flow. This home is freshly painted and located in a desirable complex close to both universities and right on a major bus route. Condo townhouse with a garage that has inside entry, parking for two cars, and visitor parking. This home features 3 spacious bedrooms, updated electrical panel, a newer kitchen, and a dining area that walks out to a private back patio. With low condo fees and an affordable price, this is a great opportunity to own in a thriving, fast-growing city. Come take a look! (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "286.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Insurance"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-16T22:37:16.841622+00:00"
+"Directions": "Head South on Albert St. from Weber & Albert to reach property. Entrance will be on your Right."
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Aluminum siding"
2 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990668"
+"ListOfficeKey": "77518"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-16T21:59:52Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-16T21:59:52Z"
+"Stories": "2.0"
+"StreetName": "ALBERT"
+"StreetNumber": "643"
+"StreetSuffix": "Street"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "2580.84"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29190417/643-albert-street-unit-2-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RMU-40"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1087
+"OriginalEntryTimestamp": "2025-12-16T21:59:52.79Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:26 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29190417')"
+"ID": "485380"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24961
+post_id: "484067"
+post_author: 1
+"ListingKey": "29188535"
+"ListingId": "40794079"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T21:40:39Z"
+"RFModificationTimestamp": "2025-12-16T21:43:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.076
+"LivingArea": 2400.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2Y7"
+"UnparsedAddress": "486B KINGSCOURT Drive, Waterloo, Ontario N2K2Y7"
+"Coordinates": array:2 [
0 => -80.5215279
1 => 43.4953314
]
+"Latitude": 43.4953314
+"Longitude": -80.5215279
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into the welcoming space at 486B Kingscourt Drive, situated in the vibrant community of Waterloo. This delightful 3+1-bedroom, 2-bathroom home invites you to experience comfort and convenience in a prime location. As you step inside, you'll be greeted by an inviting living space, perfect for both relaxation and entertaining guests. The kitchen comes fully equipped with everything you need, while ample natural light floods the space, creating a warm and inviting atmosphere. Kitchen appliances include Stove, Built-in microwave and Refrigerator. This house comes with pristine hardwood floors on all levels and laundry in the basement. The bedrooms are spacious with plenty of storage space and offer a serene retreat. The bathroom is modern and well-appointed, ensuring your comfort and convenience. Step outside onto your fully fenced private yard, where you can enjoy your morning coffee or soak up the sunshine in peace. Store your extras in the garden shed and large storage room in the basement. There are shopping, dining, and entertainment options just moments away, everything you need is within easy reach. Get ready to experience the charm of this home. It is close to Conestoga Mall, University of Waterloo and Wifrid Laurier University, KidsAbility, Schools, Parks, Golf Course & other Amenities. Schedule a viewing today and discover your new home in Waterloo. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-16T03:28:56.687586+00:00"
+"Directions": "From Lexington Road turn left on Davenport Road and left on Kingscourt Drive"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072201"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.076"
+"PhotosChangeTimestamp": "2025-12-16T02:28:48Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-16T21:38:25Z"
+"Stories": "1.0"
+"StreetName": "KINGSCOURT"
+"StreetNumber": "486"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3494"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29188535/486b-kingscourt-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2999
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1300
+"BelowGradeFinishedArea": 1100
+"OriginalEntryTimestamp": "2025-12-16T02:28:48.18Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29188535')"
+"ID": "484067"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23646
+post_id: "482562"
+post_author: 1
+"ListingKey": "29186384"
+"ListingId": "40792875"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T18:45:55Z"
+"RFModificationTimestamp": "2025-12-15T19:07:11Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 688.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3M6"
+"UnparsedAddress": "318 SPRUCE Street Unit# 1806, Waterloo, Ontario N2L3M6"
+"Coordinates": array:2 [
0 => -80.5264649
1 => 43.4784227
]
+"Latitude": 43.4784227
+"Longitude": -80.5264649
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This furnished one-bedroom condo with a den offers a comfortable 688 sq. ft. layout in a prime Waterloo location, close to the University of Waterloo, Wilfrid Laurier, and Conestoga College. The space includes a convenient one-and-a-half bath setup, a modern kitchen with granite counters and stainless steel appliances, and in-suite laundry. Underground parking is included, along with high-speed internet. The building offers several amenities such as a fitness room, study areas, a rooftop patio, bike storage, and a social lounge. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Heat"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-15T16:48:17.134327+00:00"
+"Directions": "Spruce Street and Hickory St. W."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2010964"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2025-12-15T15:38:22Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T18:29:38Z"
+"Stories": "1.0"
+"StreetName": "SPRUCE"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29186384/318-spruce-street-unit-1806-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "RN-25"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 688
+"OriginalEntryTimestamp": "2025-12-15T15:38:22.32Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:16 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:25 [ …25]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29186384')"
+"ID": "482562"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "481615"
+post_author: 1
+"ListingKey": "29185243"
+"ListingId": "X12632142"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T20:35:04Z"
+"RFModificationTimestamp": "2025-12-13T22:47:01Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "413 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.521297
1 => 43.510381
]
+"Latitude": 43.510381
+"Longitude": -80.521297
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "~ WELCOME TO BLACKSTONE CONDOS ~~ Stylish 1-Bedroom & 1 Bath Suite on the 4th Floor offering almost 600 SQFT with UNOBSTRUCTED 180 SKY VIEWS ~ enjoy your morning coffee or sunsets! Open-Concept Layout ~ Functional & Elegant Kitchen with Quartz Countertops, Subway Tile Backsplash, Stainless Steel Appliances & Undermount Sink Bright Living Area flowing seamlessly to Balcony Spacious Walk-In Closet + In-Suite Laundry + Front Hall Closet Modern 3-Pc Bath 1 Surface Parking Space Included~ LUXURY AMENITIES ~ Designer Lounge w/ Bar & Fireplace Fitness & Study Rooms Secure Bike Storage + Repair Station Pet Wash Station 2 Outdoor Lounges with BBQs & Hot Tub ~ Perfect for Entertaining!~ Bakery, Salon, Restaurants, Pub & Dental Office ~ All Just Steps Away!Minutes to Conestoga Mall, Public Library, RIM Park (sports & rec), Golf, Conservation Areas & Miles of Trails for Walking & Cycling. ~ Don't Miss This Opportunity! AVAILABLE IMMEDIATELY ~ (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-13T22:46:50.369270+00:00"
+"Directions": "Northfield & Bridge St W"
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Stone"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088809"
+"ListOfficeKey": "293791"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-13T20:22:38Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T20:22:38Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29185243/413-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2156054"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FIVE RIVERS PROPERTY MANAGEMENT GROUP INC."
+"CoListOfficeKey": "293791"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"BuildingFeatures": array:5 [
0 => "Exercise Centre"
1 => "Separate Electricity Meters"
2 => "Separate Heating Controls"
3 => "Party Room"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Controlled entry"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-13T20:22:38.4Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29185243')"
+"ID": "481615"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24915
+post_id: "478461"
+post_author: 1
+"ListingKey": "29184423"
+"ListingId": "X12631298"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T00:05:36Z"
+"RFModificationTimestamp": "2025-12-13T00:49:13Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5A7"
+"UnparsedAddress": "16 - 453 ALBERT STREET, Waterloo, Ontario N2L5A7"
+"Coordinates": array:2 [
0 => -80.541671
1 => 43.48544
]
+"Latitude": 43.48544
+"Longitude": -80.541671
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 453 Albert Street, Unit #16 in Waterloo! This charming 3-bedroom, 1-bathroom townhouse offers a perfect blend of comfort, convenience, and an unbeatable location in one of Waterloo's most vibrant communities. The home features a bright and inviting living room with a beautiful bay window, perfect for relaxing or entertaining. The kitchen comes fully equipped with a stove, fridge, and in-suite laundry, adding everyday comfort and convenience. Located directly across from a supermarket and shopping plaza, and just minutes from Conestoga College and the University of Waterloo, this unit offers exceptional accessibility. Public transit connections are excellent, making commuting easy. It's truly a great community and a wonderful place to live! tenant will share 70% of utilities with basement tenant . (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-13T00:48:54.640583+00:00"
+"Directions": "Bearinger And Albert"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1869322"
+"ListOfficeKey": "285001"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-12T23:56:15Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T23:56:15Z"
+"Stories": "2.0"
+"StreetName": "Albert"
+"StreetNumber": "453"
+"StreetSuffix": "Street"
+"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/29184423/16-453-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2299
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-12T23:56:15.7Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:7 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29184423')"
+"ID": "478461"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 128
+after_key: ""
}
"RF Response Time" => "0.33 seconds"
]
]