array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29134291/Property?$select=ALL&$top=20&$filter=ListingKey eq 29134291&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29134291/Property?$select=ALL&$top=20&$filter=ListingKey eq 29134291&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23278
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23280
+post_id: "443746"
+post_author: 1
+"ListingKey": "29134291"
+"ListingId": "40789308"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T13:40:30Z"
+"RFModificationTimestamp": "2025-11-25T20:42:22Z"
+"ListPrice": 369900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 644.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "247 E NORTHFIELD Drive E Unit# 415, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.5218345
1 => 43.5102257
]
+"Latitude": 43.5102257
+"Longitude": -80.5218345
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright and modern one-bedroom, one-bathroom corner unit on the 4th floor with large windows overlooking a serene landscaped courtyard. This stylish apartment features quality white cabinetry, sleek gray floors, in-unit laundry, and a private balcony. Located steps from a park with walking trails, a playground & a dog wash station, perfect for pet lovers and outdoor enthusiasts. Enjoy premium amenities, including a chic party room with a bar/lounge, a fitness room, a study/meeting room, an outdoor entertainment area & a rooftop terrace. Underground parking is included for your convenience. Easy access to the highway, RIM Park, Grey Silo Golf Club & more! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "521"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T20:42:10.123381+00:00"
+"Directions": "Northfield E Drive and Bridge Street"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564314"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2025-11-25T13:30:22Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T13:30:22Z"
+"Stories": "1.0"
+"StreetDirPrefix": "East"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3220"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1539837459"
"RoomType" => "3pc Bathroom"
"ListingId" => "40789308"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134291"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T13:30:22.71Z"
]
1 => array:11 [
"RoomKey" => "1539837460"
"RoomType" => "Bedroom"
"ListingId" => "40789308"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134291"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T13:30:22.71Z"
]
2 => array:11 [
"RoomKey" => "1539837461"
"RoomType" => "Foyer"
"ListingId" => "40789308"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134291"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T13:30:22.71Z"
]
3 => array:11 [
"RoomKey" => "1539837462"
"RoomType" => "Kitchen"
"ListingId" => "40789308"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134291"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 15'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T13:30:22.71Z"
]
4 => array:11 [
"RoomKey" => "1539837463"
"RoomType" => "Living room"
"ListingId" => "40789308"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29134291"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T13:30:22.71Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29134291/247-e-northfield-drive-e-unit-415-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 644
+"OriginalEntryTimestamp": "2025-11-25T13:30:22.65Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:36 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6338964265"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/9c76a8221d2ada60ab73b61d5294d87b.webp"
"MediaSize" => 83023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-9c76a8221d2ada60ab73b61d5294d87b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Building lobby featuring floor to ceiling windows and a towering ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6338964268"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/72e3b852e1179fa6f79589f4e26cd53c.webp"
"MediaSize" => 36434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-72e3b852e1179fa6f79589f4e26cd53c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hall with light wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6338964271"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/50ce545b62c48847af3dec92f7f2400a.webp"
"MediaSize" => 95956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-50ce545b62c48847af3dec92f7f2400a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of parking deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6338964276"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/aecbd0feff4c8531469c82858bd8b638.webp"
"MediaSize" => 118687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-aecbd0feff4c8531469c82858bd8b638.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of apartment building / complex"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6338964280"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/4fd1ab2782def73f6a3df7c3ae188138.webp"
"MediaSize" => 75424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-4fd1ab2782def73f6a3df7c3ae188138.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Snow covered property featuring a view of apartment building / complex"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6338964284"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/6f5a1ce60c17fdd6d0fb2690738ae99b.webp"
"MediaSize" => 71302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-6f5a1ce60c17fdd6d0fb2690738ae99b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of community lobby"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6338964288"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/7addb1eab231e964aaeb66a1b6482eba.webp"
"MediaSize" => 64429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-7addb1eab231e964aaeb66a1b6482eba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office featuring french doors and a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6338964292"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/51284d14f26effe9cf428d831a8db831.webp"
"MediaSize" => 100929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-51284d14f26effe9cf428d831a8db831.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Snow covered building featuring a view of apartment building / complex"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6338964296"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/aef167215de37612eca8aad6df84c6d3.webp"
"MediaSize" => 143313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-aef167215de37612eca8aad6df84c6d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exterior view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6338964299"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/09158339d00f77b87cca3655241f9d0a.webp"
"MediaSize" => 66908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-09158339d00f77b87cca3655241f9d0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-style flooring, plenty of natural light, a raised ceiling, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6338964303"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/bdac2f72eac3ed5b485e8db3f523ef71.webp"
"MediaSize" => 58662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-bdac2f72eac3ed5b485e8db3f523ef71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring a desk, light wood-style floors, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6338964307"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/ea2f3b8797ecce2a02999441bb5c467a.webp"
"MediaSize" => 72177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-ea2f3b8797ecce2a02999441bb5c467a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring recessed lighting, light wood finished floors, and a raised ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6338964311"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/246a250886c2bbbd0809e784a14bfbc2.webp"
"MediaSize" => 36708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-246a250886c2bbbd0809e784a14bfbc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Doorway with baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6338964316"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/005c6bce8c754b8ba5de62b6cfa88b3c.webp"
"MediaSize" => 31572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-005c6bce8c754b8ba5de62b6cfa88b3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Doorway featuring wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6338964321"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/19bb91ba6684d60ab9e503780f2f343a.webp"
"MediaSize" => 66165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-19bb91ba6684d60ab9e503780f2f343a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, white cabinets, light wood finished floors, tasteful backsplash, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6338964325"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/19ffb4826272038ea5775882d2b2a712.webp"
"MediaSize" => 52647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-19ffb4826272038ea5775882d2b2a712.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6338964329"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/22086778443f110c2adba35822435047.webp"
"MediaSize" => 48295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-22086778443f110c2adba35822435047.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Community lobby featuring recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6338964333"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/ea4646371c473022c26bec70409bc6a9.webp"
"MediaSize" => 31572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-ea4646371c473022c26bec70409bc6a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Doorway featuring wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6338964337"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/b4045004b26a5f6b862037ddf358f05a.webp"
"MediaSize" => 64277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-b4045004b26a5f6b862037ddf358f05a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with white cabinetry, appliances with stainless steel finishes, dark wood-type flooring, tasteful backsplash, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6338964342"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/f73f4ddd21307e5c13b470a241c59852.webp"
"MediaSize" => 136175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-f73f4ddd21307e5c13b470a241c59852.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property's community featuring a pergola and a patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6338964348"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/c5c11d39398a94d62fa32a459bd4557a.webp"
"MediaSize" => 108506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-c5c11d39398a94d62fa32a459bd4557a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6338964351"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/94c4146c437b75ffc2eb5429d581288a.webp"
"MediaSize" => 88338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-94c4146c437b75ffc2eb5429d581288a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Snow covered building with a view of apartment building / complex"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6338964357"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/ceb5210fb651d8ccad7bd22ed8e325f7.webp"
"MediaSize" => 39413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-ceb5210fb651d8ccad7bd22ed8e325f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6338964359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/3c373028d8660ec490e0f1fc8b689e0b.webp"
"MediaSize" => 77422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-3c373028d8660ec490e0f1fc8b689e0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lobby with a towering ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6338964364"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/06ccac9ad629cb4a2a722c51af2b7986.webp"
"MediaSize" => 68180
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-06ccac9ad629cb4a2a722c51af2b7986.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Home office featuring a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6338964369"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/1099a2ceaaf37967fadd74d70e1dd86e.webp"
"MediaSize" => 89906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-1099a2ceaaf37967fadd74d70e1dd86e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of parking garage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6338964373"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/266527a11c19879648cedc9377994041.webp"
"MediaSize" => 60707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-266527a11c19879648cedc9377994041.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring light wood-type flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6338964377"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/0f23cf901af8e25318d394e206a12f96.webp"
"MediaSize" => 49188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-0f23cf901af8e25318d394e206a12f96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office area featuring healthy amount of natural light and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6338964381"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/297e3bcf764d15b836dd6623ceb82aac.webp"
"MediaSize" => 44625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-297e3bcf764d15b836dd6623ceb82aac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with multiple closets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6338964384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/353a9c959e360a92555635196edd8b2f.webp"
"MediaSize" => 38830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-353a9c959e360a92555635196edd8b2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Washroom with light wood-type flooring and estacked washer and dryer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6338964388"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/19504136a6636fe5866c6b645b7b947c.webp"
"MediaSize" => 54360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-19504136a6636fe5866c6b645b7b947c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office with wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6338964390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/37e1007831dc75936a2e57c10fda0e71.webp"
"MediaSize" => 70181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-37e1007831dc75936a2e57c10fda0e71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with light wood finished floors, vanity, and a shower with curtain"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6338964393"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/883795f1f0a176a501ca4fcb11e8bdcf.webp"
"MediaSize" => 90181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-883795f1f0a176a501ca4fcb11e8bdcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Common area with a wall of windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6338964397"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/244da38965681a09618a951d3c5996a0.webp"
"MediaSize" => 70389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-244da38965681a09618a951d3c5996a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exercise room featuring a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6338964401"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/34b00475d3259656fc362fd302dd5746.webp"
"MediaSize" => 110925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-34b00475d3259656fc362fd302dd5746.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6338964405"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29134291/b55aef6e46ddcf12295a5ae810ecc28a.webp"
"MediaSize" => 42477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29134291/thumbnail-b55aef6e46ddcf12295a5ae810ecc28a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789308"
"ResourceRecordKey" => "29134291"
"ModificationTimestamp" => "2025-11-25T13:30:22.66Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29134291')"
+"ID": "443746"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 290168/Office?$select=ALL&$top=10&$filter=OfficeKey eq 290168&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 290168/Office?$select=ALL&$top=10&$filter=OfficeKey eq 290168&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25123
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25125
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-885-0200"
+"OfficeMlsId": "KW357"
+"ModificationTimestamp": "2025-11-06T22:57:19Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "290168"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "83 ERB STREET W, SUITE B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2L6C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1384313"
+"OriginalEntryTimestamp": "2021-04-15T13:36:00Z"
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "6299259082"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/office-290168/703135b62fcfb9911c047f54e9e3f01c.webp"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "KW357"
"ResourceRecordKey" => "290168"
"ModificationTimestamp" => "2025-11-06T18:57:00Z"
]
]
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "431113"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "290168"
"SocialMediaUrlOrId" => "http://www.remaxtwincity.com/"
"ModificationTimestamp" => "2025-11-06T18:57:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1236348"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('290168')"
}
]
+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 1564314/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564314&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564314/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564314&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25128
+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 29134291" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24721
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29134291/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29134291&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29134291/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29134291&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24701
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29134291 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5218345 43.5102257)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29134291 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5218345 43.5102257)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29134291 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5218345 43.5102257)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29134291 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5218345 43.5102257)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24970
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24664
+post_id: "446181"
+post_author: 1
+"ListingKey": "29139457"
+"ListingId": "X12579086"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T19:10:40Z"
+"RFModificationTimestamp": "2025-11-26T19:41:03Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z6"
+"UnparsedAddress": "MAIN - 579 WINDJAMMER WAY, Waterloo, Ontario N2K3Z6"
+"Coordinates": array:2 [
0 => -80.5029887
1 => 43.5084069
]
+"Latitude": 43.5084069
+"Longitude": -80.5029887
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful main-floor unit in Waterloo's highly desirable East Bridge community. Bright open-concept layout with an updated kitchen featuring stone countertops and new appliances. Enjoy a cozy family room with a fireplace and a primary bedroom with a 3-piece ensuite. Private Laundry. Private backyard backing onto a park and school. Minutes to top-rated schools, RIM Park, Conestoga Mall, UW, Conestoga College, and highway access. Double garage and wide driveway included! tenant pay 80% utilities (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T19:40:52.761761+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2023409"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T19:01:42Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T19:01:42Z"
+"Stories": "2.0"
+"StreetName": "Windjammer"
+"StreetNumber": "579"
+"StreetSuffix": "Way"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1540519425"
"RoomType" => "Living room"
"ListingId" => "X12579086"
"RoomLevel" => "Main level"
"RoomWidth" => 7.78
"ListingKey" => "29139457"
"RoomLength" => 3.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:01:42.62Z"
]
1 => array:11 [
"RoomKey" => "1540519426"
"RoomType" => "Dining room"
"ListingId" => "X12579086"
"RoomLevel" => "Main level"
"RoomWidth" => 7.78
"ListingKey" => "29139457"
"RoomLength" => 3.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:01:42.62Z"
]
2 => array:11 [
"RoomKey" => "1540519427"
"RoomType" => "Kitchen"
"ListingId" => "X12579086"
"RoomLevel" => "Main level"
"RoomWidth" => 6.05
"ListingKey" => "29139457"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:01:42.62Z"
]
3 => array:11 [
"RoomKey" => "1540519428"
"RoomType" => "Family room"
"ListingId" => "X12579086"
"RoomLevel" => "In between"
"RoomWidth" => 4.88
"ListingKey" => "29139457"
"RoomLength" => 3.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:01:42.62Z"
]
4 => array:11 [
"RoomKey" => "1540519429"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12579086"
"RoomLevel" => "Second level"
"RoomWidth" => 4.88
"ListingKey" => "29139457"
"RoomLength" => 3.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:01:42.62Z"
]
5 => array:11 [
"RoomKey" => "1540519430"
"RoomType" => "Bedroom 2"
"ListingId" => "X12579086"
"RoomLevel" => "Second level"
"RoomWidth" => 4.03
"ListingKey" => "29139457"
"RoomLength" => 4.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:01:42.62Z"
]
6 => array:11 [
"RoomKey" => "1540519431"
"RoomType" => "Bedroom 3"
"ListingId" => "X12579086"
"RoomLevel" => "Second level"
"RoomWidth" => 3.33
"ListingKey" => "29139457"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:01:42.62Z"
]
7 => array:11 [
"RoomKey" => "1540519432"
"RoomType" => "Laundry room"
"ListingId" => "X12579086"
"RoomLevel" => "Second level"
"RoomWidth" => 1.68
"ListingKey" => "29139457"
"RoomLength" => 2.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T19:01:42.62Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139457/main-579-windjammer-way-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3000
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-26T19:01:42.59Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:37 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341325523"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/548717402c64a7574a94beadd4fc8897.webp"
"MediaSize" => 143143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-548717402c64a7574a94beadd4fc8897.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341325550"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/8ef83de09f58d9508fa1a435c87a2949.webp"
"MediaSize" => 148118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-8ef83de09f58d9508fa1a435c87a2949.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341325587"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/1d9491097e482e3f040d812551514476.webp"
"MediaSize" => 151774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-1d9491097e482e3f040d812551514476.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341325637"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/7ce5973ee7132140ae693c441840a481.webp"
"MediaSize" => 71896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-7ce5973ee7132140ae693c441840a481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341325707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/aace97d7c2c7e832b6d0bf1d3010dce3.webp"
"MediaSize" => 46504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-aace97d7c2c7e832b6d0bf1d3010dce3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341325753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/664b60d124a8a1460964fdfc3ecd5a98.webp"
"MediaSize" => 72226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-664b60d124a8a1460964fdfc3ecd5a98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341325761"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/7f378cb239e4e81ed8793880a519ace6.webp"
"MediaSize" => 71041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-7f378cb239e4e81ed8793880a519ace6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341325810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/a04dce7df1e4593ca38c08818593a786.webp"
"MediaSize" => 73746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-a04dce7df1e4593ca38c08818593a786.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6341325839"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/8103a84f3f62bb588eeaa86662361b82.webp"
"MediaSize" => 73981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-8103a84f3f62bb588eeaa86662361b82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6341325862"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/80281c9b39a8224e448f8ad772b1373d.webp"
"MediaSize" => 73200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-80281c9b39a8224e448f8ad772b1373d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6341325896"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/65e11c4d986e9936ab60875ad672854c.webp"
"MediaSize" => 69022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-65e11c4d986e9936ab60875ad672854c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6341325936"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/835b0b05a515b2395b0ea793bb474337.webp"
"MediaSize" => 75471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-835b0b05a515b2395b0ea793bb474337.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6341325979"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/05b9cd7883dd84027419ad64a1c55259.webp"
"MediaSize" => 71236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-05b9cd7883dd84027419ad64a1c55259.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6341326016"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/a75b45800f08033a8d972fad5d7398c0.webp"
"MediaSize" => 64155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-a75b45800f08033a8d972fad5d7398c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6341326045"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/64d5c23f9d23211ca29a25fef5909292.webp"
"MediaSize" => 65774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-64d5c23f9d23211ca29a25fef5909292.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6341326097"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/58668239254a4556c84a46b12159c10f.webp"
"MediaSize" => 59528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-58668239254a4556c84a46b12159c10f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6341326117"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/91c5ac94e8544a8774c3ae972263c7be.webp"
"MediaSize" => 70573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-91c5ac94e8544a8774c3ae972263c7be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6341326157"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/a72f63172c213ef71a02772f597d608a.webp"
"MediaSize" => 62870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-a72f63172c213ef71a02772f597d608a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6341326159"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/673f9c9a164f9dd5878dacc4ce95165b.webp"
"MediaSize" => 75857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-673f9c9a164f9dd5878dacc4ce95165b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6341326183"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/f0702924ff7c6b6d5cc721225dd6f2d2.webp"
"MediaSize" => 69770
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-f0702924ff7c6b6d5cc721225dd6f2d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6341326198"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/155514157896836c19c2af16c230e4b7.webp"
"MediaSize" => 48811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-155514157896836c19c2af16c230e4b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6341326216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/d603456d225255aaf3acb6d287c800ce.webp"
"MediaSize" => 93475
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-d603456d225255aaf3acb6d287c800ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6341326233"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/672a0164d61cdab6b4aea531bbb84426.webp"
"MediaSize" => 84395
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-672a0164d61cdab6b4aea531bbb84426.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6341326245"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/e5680d1539598bdb432e7b6039127500.webp"
"MediaSize" => 56001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-e5680d1539598bdb432e7b6039127500.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6341326251"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/c1faf44e0fd2a286245ecd3b4e189ba2.webp"
"MediaSize" => 57975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-c1faf44e0fd2a286245ecd3b4e189ba2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6341326299"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/64f8f11726e44d3caf151ef7e7732d38.webp"
"MediaSize" => 58447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139457/thumbnail-64f8f11726e44d3caf151ef7e7732d38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12579086"
"ResourceRecordKey" => "29139457"
"ModificationTimestamp" => "2025-11-26T19:01:42.6Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6341326318"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139457/350fd7dd816e0a6246a252a9ad0ed61d.webp"
…10
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139457')"
+"ID": "446181"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24966
+post_id: "446183"
+post_author: 1
+"ListingKey": "29139074"
+"ListingId": "40790705"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:30:52Z"
+"RFModificationTimestamp": "2025-11-26T18:56:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1991.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Z6"
+"UnparsedAddress": "579 WINDJAMMER Way Unit# Main, Waterloo, Ontario N2K3Z6"
+"Coordinates": array:2 [
0 => -80.5028784
1 => 43.5080285
]
+"Latitude": 43.5080285
+"Longitude": -80.5028784
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful main-floor unit in Waterloo’s highly desirable East Bridge community. Bright open-concept layout with an updated kitchen featuring stone countertops and new appliances. Enjoy a cozy family room with a fireplace and a primary bedroom with a 3-piece ensuite. PrivauPrivate backyard backing onto a park and school. Minutes to top-rated schools, RIM Park, Conestoga Mall, UW, Conestoga College, and highway access. Double garage and wide driveway included—an ideal place to call home! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:56:33.467036+00:00"
+"Directions": "Eastbridge Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129629"
+"ListOfficeKey": "283262"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:11:43Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:11:43Z"
+"Stories": "2.0"
+"StreetName": "WINDJAMMER"
+"StreetNumber": "579"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"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/29139074/579-windjammer-way-unit-main-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 3000
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1991
+"OriginalEntryTimestamp": "2025-11-26T18:08:41.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139074')"
+"ID": "446183"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24606
+post_id: "446184"
+post_author: 1
+"ListingKey": "29138905"
+"ListingId": "40790707"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:50:15Z"
+"RFModificationTimestamp": "2025-11-26T18:32:43Z"
+"ListPrice": 1775000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4544.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H9"
+"UnparsedAddress": "250 GREY SQUIRREL Place, Waterloo, Ontario N2K3H9"
+"Coordinates": array:2 [
0 => -80.520379
1 => 43.508525
]
+"Latitude": 43.508525
+"Longitude": -80.520379
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 250 Grey Squirrel Place—an elegant family home tucked along a quiet crescent in one of Waterloo’s most desirable neighbourhoods, Colonial Acres, where warmth, space, and sophistication meet. Set on a rare double lot, this property offers exceptional outdoor space and privacy. The moment you step inside, you’re met with a stunning view of the main floor: a vaulted 14-foot ceiling in the front living room anchored by a wood-burning fireplace and framed by gleaming hardwood floors. A second wood fireplace enhances the cozy atmosphere in the main-level family room, while a dedicated office provides a quiet workspace. The mudroom/laundry room, conveniently located by the garage entrance, adds everyday practicality. The kitchen is designed for connection and function, featuring granite counters, Bosch stove and Miele appliances, and a walkout to the brand-new 2025 tiered wood deck overlooking the double-sized backyard—complete with a sports court, two Honeycrisp apple trees, and a peach tree, offering the perfect space for family play, gardening, or summer entertaining. Upstairs, you’ll find four generous bedrooms, including a serene primary suite with an ensuite, along with a second full washroom. The fully finished basement extends your living space with two additional bedrooms, a three-piece bathroom, and a large recreation room perfect for movie nights or weekend gatherings. With a double-car garage, interlock driveway, and mature trees surrounding the property, every detail speaks to comfort and quality. Ideally located minutes from Uptown Waterloo, the University of Waterloo, and Waterloo Park, with quick access to The Boardwalk, RIM Park, and Grey Silo Golf Course, this home offers the perfect balance of family living and professional convenience. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:32:38.425964+00:00"
+"Directions": "Deer Run Dr to Grey Squirrel Pl"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152269"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T17:38:46Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:38:46Z"
+"Stories": "2.0"
+"StreetName": "GREY SQUIRREL"
+"StreetNumber": "250"
+"StreetSuffix": "Place"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "9353.85"
+"VirtualTourURLUnbranded": "https://youriguide.com/250_grey_squirrel_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29138905/250-grey-squirrel-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 114.0
+"AboveGradeFinishedArea": 2883
+"BelowGradeFinishedArea": 1661
+"OriginalEntryTimestamp": "2025-11-26T17:38:46.01Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138905')"
+"ID": "446184"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24967
+post_id: "443071"
+post_author: 1
+"ListingKey": "29134352"
+"ListingId": "X12574088"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T14:31:06Z"
+"RFModificationTimestamp": "2025-11-25T17:38:15Z"
+"ListPrice": 369900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "415 - 247 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.521945
1 => 43.509547
]
+"Latitude": 43.509547
+"Longitude": -80.521945
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright and modern one-bedroom, one-bathroom corner unit on the 4th floor with large windows overlooking a serene landscaped courtyard. This stylish apartment features quality white cabinetry, sleek gray floors, in-unit laundry, and a private balcony. Located steps from a park with walking trails, a playground & a dog wash station, perfect for pet lovers and outdoor enthusiasts. Enjoy premium amenities, including a chic party room with a bar/lounge, a fitness room, a study/meeting room, an outdoor entertainment area & a rooftop terrace. Underground parking is included for your convenience. Easy access to the highway, RIM Park, Grey Silo Golf Club & more! (id:62650)"
+"Appliances": array:1 [
0 => "Garage door opener remote(s)"
]
+"AssociationFee": "521"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Electricity"
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-11-25T17:37:59.494283+00:00"
+"Directions": "Cross Streets: Bridge St. W. ** Directions: Northfield E Drive and Bridge Street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101285"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-25T14:20:20Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T14:20:20Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3220"
+"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"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29134352/415-247-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five River"
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2025-11-25T14:20:20.16Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29134352')"
+"ID": "443071"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24965
+post_id: "441278"
+post_author: 1
+"ListingKey": "29131608"
+"ListingId": "40790134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:55:51Z"
+"RFModificationTimestamp": "2025-11-26T18:23:47Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2747.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4B8"
+"UnparsedAddress": "442 CHESAPEAKE Drive, Waterloo, Ontario N2K4B8"
+"Coordinates": array:2 [
0 => -80.508133
1 => 43.506918
]
+"Latitude": 43.506918
+"Longitude": -80.508133
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this lovely and move-in-ready 3+1 bedroom single-family home, perfectly situated in Eastbridge, one of Waterloo's most sought-after neighbourhoods. Ideally located backing onto the school yard green space with no backyard neighbours, this home offers privacy and direct access to Lester B. Pearson Public School yard, green space and playground—a rare advantage for families. Inside, you'll enter into a stylishly updated (2025) main floor including spacious foyer leading into a bright, sun filled open-concept space featuring a lovely living room with a gas fireplace, a separate dining area and convenient mudroom/laundry. The impressive upper family room with vaulted ceilings is perfect for family gatherings, or cozy movie nights. This family room offers a unique covered second-storey balcony—an ideal spot for morning coffee or unwinding in the evening. The primary suite features a renovated (2025) 5 pc ensuite and generous walk-in closet. The fully finished lower level adds even more functional space, including a fabulous rec room with rustic barn board feature wall, an additional bedroom or office area and another full bath. With approximately 2,800 sq. ft. of living space, this home is designed for comfort and versatility. Just steps from two highly rated elementary schools, the new splash pad, walking trails, Manulife RIM park including the Eastside Library and Grey Silo Golf Club this home puts recreation, learning, and convenience at your doorstep. You're also minutes from Conestoga Mall, St. Jacobs Market, LRT, Expressway access and more—everything a growing family needs. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T19:58:38.442364+00:00"
+"Directions": "Bridge Street to Chesapeake Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563572"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T17:30:15Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:38:51Z"
+"Stories": "2.0"
+"StreetName": "CHESAPEAKE"
+"StreetNumber": "442"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5680.58"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/442-Chesapeake-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29131608/442-chesapeake-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 2079
+"BelowGradeFinishedArea": 668
+"OriginalEntryTimestamp": "2025-11-24T17:30:15.59Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29131608')"
+"ID": "441278"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24982
+post_id: "439871"
+post_author: 1
+"ListingKey": "29130349"
+"ListingId": "X12570350"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T20:35:47Z"
+"RFModificationTimestamp": "2025-11-24T20:38:37Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y3"
+"UnparsedAddress": "488 CABOT TRAIL, Waterloo, Ontario N2K3Y3"
+"Coordinates": array:2 [
0 => -80.5042596
1 => 43.5042704
]
+"Latitude": 43.5042704
+"Longitude": -80.5042596
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 488 Cabot Trail. This executive bungalow nestled in a quiet, family-friendly street. Sitting on a 52.5 ft wide lot, this meticulously maintained home features a massive 4,000+ sf total livable space, including a 2,101 sf floor plan on main (per MPAC), three spacious bedrooms including a primary suite with walk-in closet and ensuite, plus a second full washroom for extra convenience, a soaring 15 ft high cathedral ceiling at foyer with double door entry, a formal dining room, an open concept kitchen combined with a large family room walk out to the deck. Numerous pot lights throughout. Downstairs, the finished basement offers the 4th bedroom with its own ensuite, a generous multi-function storage room, and a HUGE 813 sf recreation room can be used as gym, home theatre, workshop, studios, you name it. The fully fenced backyard lined with privacy trees and a large deck covered by a motorized awning, perfect for BBQs with family and friends. No sidewalk. The two-car garage with a deep driveway can park 6 vehicles. Minutes to parks, trails, top-rated schools, RIM Park, Grey Silo Golf Club, Conestoga Mall, and the St. Jacobs Market. This home offers comfort, space, flexibility, and endless potential in one of the most desirable neighbourhoods in Waterloo. A Must see! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-23T22:38:42.740659+00:00"
+"Directions": "Lexington & Bridge"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007138"
+"ListOfficeKey": "280684"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "52.5 x 122 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-23T20:54:04Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T20:24:34Z"
+"Stories": "1.0"
+"StreetName": "Cabot"
+"StreetNumber": "488"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "7439.58"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29130349/488-cabot-trail-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 52.6
+"OriginalEntryTimestamp": "2025-11-23T20:54:03.83Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29130349')"
+"ID": "439871"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23292
+post_id: "437789"
+post_author: 1
+"ListingKey": "29126400"
+"ListingId": "X12566444"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-21T20:40:20Z"
+"RFModificationTimestamp": "2025-11-21T23:52:58Z"
+"ListPrice": 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"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T20:31:33.812266+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-11-21T17:56:21Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-21T20:26:49Z"
+"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/29126400/407-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Management"
+"TotalActualRent": 2450
+"BuildingFeatures": array:4 [
0 => "Exercise Centre"
1 => "Separate Heating Controls"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-21T17:56:21.17Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:35 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29126400')"
+"ID": "437789"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24968
+post_id: "437790"
+post_author: 1
+"ListingKey": "29126074"
+"ListingId": "40789795"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-21T17:10:18Z"
+"RFModificationTimestamp": "2025-11-21T19:55:43Z"
+"ListPrice": 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": 0
+"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 highwaysthis is contemporary comfort in the perfect location! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T19:55:23.204488+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:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "No Pet Home"
]
+"PhotosChangeTimestamp": "2025-11-21T17:00:30Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-21T17:00:30Z"
+"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 [ …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/29126074/255-northfield-drive-e-unit-407-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"TotalActualRent": 2450
+"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
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 854
+"OriginalEntryTimestamp": "2025-11-21T17:00:30.04Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29126074')"
+"ID": "437790"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24969
+post_id: "432784"
+post_author: 1
+"ListingKey": "29121948"
+"ListingId": "X12562532"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T17:45:18Z"
+"RFModificationTimestamp": "2025-11-20T17:45:41Z"
+"ListPrice": 643900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2X9"
+"UnparsedAddress": "B - 501 KINGSCOURT DRIVE, Waterloo, Ontario N2K2X9"
+"Coordinates": array:2 [
0 => -80.5215882
1 => 43.4967266
]
+"Latitude": 43.4967266
+"Longitude": -80.5215882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome home to this spacious 3+2 bedroom property featuring a separate entrance to a fully finished basement making it ideal for an in-law suite, multi-generational living, or an excellent setup for extended family. Located just a short walk to Conestoga Mall, transit, restaurants, and with quick access to Highway 7/8, this home with over 2000 sq ft of finished space offers outstanding convenience for any lifestyle. Whether you're a first-time buyer looking to offset your mortgage, an investor seeking strong rental returns, or a family needing flexible living arrangements, this property is a fantastic mortgage helper with good rental potential. The home is carpet-free, freshly painted, and move-in ready. The large pool-sized backyard provides excellent privacy-ideal for children, pets, and outdoor entertaining. Parking is a breeze with a driveway that accommodates up to 6 vehicles. (id:62650)"
+"Appliances": array:1 [
0 => "All"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-20T17:41:22.634734+00:00"
+"Directions": "Davenport"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1557114"
+"ListOfficeKey": "141983"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 115 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T16:51:21Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-20T17:31:44Z"
+"StreetName": "Kingscourt"
+"StreetNumber": "501"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3644"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/501-Kingscourt-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "OnePoint"
+"TaxYear": 2025
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29121948/b-501-kingscourt-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2025-11-20T16:51:21.66Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:39 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29121948')"
+"ID": "432784"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 69
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]
