array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29238768/Property?$select=ALL&$top=20&$filter=ListingKey eq 29238768&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29238768/Property?$select=ALL&$top=20&$filter=ListingKey eq 29238768&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "526557"
+post_author: 1
+"ListingKey": "29238768"
+"ListingId": "40797113"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T22:55:35Z"
+"RFModificationTimestamp": "2026-01-12T00:48:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 518.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "247 NORTHFIELD Drive E Unit# 405, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5217691
1 => 43.5105762
]
+"Latitude": 43.5105762
+"Longitude": -80.5217691
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Blackstone, a unique Scandinavian-inspired community blending modern farmhouse vibes with ultimate comfort. This bright 1-bedroom unit features a balcony overlooking the beautiful RO courtyard, complete with a fire pit, BBQs, and a spa for relaxing. The sleek kitchen boasts stainless steel appliances and quartz countertops, and Browns Social House is just a short walk away for nights off from cooking. With onsite shopping, 24/7 security, a fitness centre, and easy access to trails, the Grand River, and transit, Blackstone offers a lifestyle you’ll love! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T00:48:39.224990+00:00"
+"Directions": "CORNER OF NORTHFIELD DR AND BRIDGE ST"
+"ExteriorFeatures": array:3 [
0 => "Wood"
1 => "Stone"
2 => "Metal"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1950448"
+"ListOfficeKey": "299742"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-11T22:49:28Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T22:49:28Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1559160876"
"RoomType" => "Full bathroom"
"ListingId" => "40797113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29238768"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-11T22:49:28.09Z"
]
1 => array:11 [
"RoomKey" => "1559160878"
"RoomType" => "Bedroom"
"ListingId" => "40797113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29238768"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-11T22:49:28.09Z"
]
2 => array:11 [
"RoomKey" => "1559160879"
"RoomType" => "Living room"
"ListingId" => "40797113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29238768"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-11T22:49:28.1Z"
]
3 => array:11 [
"RoomKey" => "1559160880"
"RoomType" => "Kitchen"
"ListingId" => "40797113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29238768"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-11T22:49:28.1Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29238768/247-northfield-drive-e-unit-405-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1819312"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76849"
+"GeocodeManualYN": true
+"TotalActualRent": 1950
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 518
+"OriginalEntryTimestamp": "2026-01-11T22:49:23.31Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:18 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6400618550"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/8ea1f32aa8e43a5f169adbb7608fbd62.webp"
"MediaSize" => 49377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-8ea1f32aa8e43a5f169adbb7608fbd62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6400618576"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/30db93e014bec9910ca0384d76e960f5.webp"
"MediaSize" => 111570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-30db93e014bec9910ca0384d76e960f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6400618602"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/f9859954cdc444b5f31a0f0dbc260584.webp"
"MediaSize" => 114503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-f9859954cdc444b5f31a0f0dbc260584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6400618626"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/f0df42d6fd6f76d3c990f53eaaae87c4.webp"
"MediaSize" => 86298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-f0df42d6fd6f76d3c990f53eaaae87c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6400618660"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/258ebffda20b6f2f7ec5dcc5718cf7f0.webp"
"MediaSize" => 94941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-258ebffda20b6f2f7ec5dcc5718cf7f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6400618696"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/3098fd9a24efd0dfb4bda9ed8a243196.webp"
"MediaSize" => 54436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-3098fd9a24efd0dfb4bda9ed8a243196.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6400618725"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/f5043579aa4f9fa115d0973d31e433ea.webp"
"MediaSize" => 47798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-f5043579aa4f9fa115d0973d31e433ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6400618751"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/37c59855779f3fce1bb54dd2c1ef2bab.webp"
"MediaSize" => 54114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-37c59855779f3fce1bb54dd2c1ef2bab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6400618778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/9b294ee0579292941987e71e7dcdf14b.webp"
"MediaSize" => 33710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-9b294ee0579292941987e71e7dcdf14b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6400618796"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/0bf2080cc70dcd42b3f0aaba08a48c98.webp"
"MediaSize" => 44130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-0bf2080cc70dcd42b3f0aaba08a48c98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6400618824"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/a25785f811e26b34f759fe25aa07a366.webp"
"MediaSize" => 32525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-a25785f811e26b34f759fe25aa07a366.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6400618831"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/4196ba905df14e3f1239a86bf346fc13.webp"
"MediaSize" => 112090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-4196ba905df14e3f1239a86bf346fc13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6400618847"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/e9609a6c77f8f1a1d95972d6b90695e2.webp"
"MediaSize" => 143152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-e9609a6c77f8f1a1d95972d6b90695e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6400618869"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/cb31007906e45e12fb15515cfc986653.webp"
"MediaSize" => 94427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-cb31007906e45e12fb15515cfc986653.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6400618888"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/39edf08556abb6f4b6a5206307e8166c.webp"
"MediaSize" => 91964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-39edf08556abb6f4b6a5206307e8166c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6400618912"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/dfc9cc041cbc36333a5934a2928af727.webp"
"MediaSize" => 104549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-dfc9cc041cbc36333a5934a2928af727.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6400618918"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/8f028be7d1f8830796f1e101b53ee121.webp"
"MediaSize" => 61088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-8f028be7d1f8830796f1e101b53ee121.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6400618931"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238768/e3ba06a84a7417eb2e9b0a1195297b68.webp"
"MediaSize" => 110258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238768/thumbnail-e3ba06a84a7417eb2e9b0a1195297b68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797113"
"ResourceRecordKey" => "29238768"
"ModificationTimestamp" => "2026-01-11T22:49:23.32Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "DUSTIN O'CONNOR"
"MemberFirstName" => "DUSTIN"
"MemberLastName" => "O'CONNOR"
"MemberMlsId" => "KWkw7800"
"OriginatingSystemName" => 26
"MemberKey" => "1950448"
"ModificationTimestamp" => "2025-08-19T16:08:03Z"
"MemberStatus" => "Active"
"OfficeKey" => "299742"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Kitchener"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-570-4663"
"MemberSocialMedia" => array:2 [ …2]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2013-01-24T16:27:00Z"
"MemberNationalAssociationId" => "1244611"
"OfficeNationalAssociationId" => "1476132"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Century 21 Heritage House Ltd."
"OfficePhone" => "519-570-4663"
"OfficeMlsId" => "WR50909"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "299742"
"ModificationTimestamp" => "2026-01-02T22:48:39Z"
"OfficeAddress1" => "515 Riverbend Drive, Unit 103A"
"OfficeCity" => "Kitchener"
"OfficePostalCode" => "N2K3S"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2025-01-30T18:51:00Z"
"OfficeNationalAssociationId" => "1476132"
"FranchiseNationalAssociationId" => "1205554"
"OfficeBrokerNationalAssociationId" => "1336243"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238768')"
+"ID": "526557"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 299742/Office?$select=ALL&$top=10&$filter=OfficeKey eq 299742&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 299742/Office?$select=ALL&$top=10&$filter=OfficeKey eq 299742&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25285
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Century 21 Heritage House Ltd."
+"OfficeEmail": null
+"OfficePhone": "519-570-4663"
+"OfficeMlsId": "WR50909"
+"ModificationTimestamp": "2026-01-02T22:48:39Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "299742"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "515 Riverbend Drive, Unit 103A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2K3S"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1476132"
+"OriginalEntryTimestamp": "2025-01-30T18:51:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "422820"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "299742"
"SocialMediaUrlOrId" => "https://www.c21.ca/directory/offices/heritage-house-ltd-brokerage-1"
"ModificationTimestamp" => "2026-01-02T22:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1205554"
+"OfficeBrokerNationalAssociationId": "1336243"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('299742')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1950448/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1950448&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1950448/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1950448&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25290
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29238768" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24924
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.43 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29238768/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29238768&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29238768/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29238768&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24906
+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 29238768 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5217691 43.5105762)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29238768 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5217691 43.5105762)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29238768 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5217691 43.5105762)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29238768 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5217691 43.5105762)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25140
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24826
+post_id: "526569"
+post_author: 1
+"ListingKey": "29238726"
+"ListingId": "X12685032"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T21:50:35Z"
+"RFModificationTimestamp": "2026-01-11T22:36:32Z"
+"ListPrice": 889000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4B7"
+"UnparsedAddress": "503 BRIGANTINE DRIVE, Waterloo, Ontario N2K4B7"
+"Coordinates": array:2 [
0 => -80.5142811
1 => 43.5076026
]
+"Latitude": 43.5076026
+"Longitude": -80.5142811
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Prime Eastbridge Location The Perfect Family Home with Room to Grow! Welcome to this beautifully maintained home in the heart of Eastbridge, one of Waterloos most desirable family-friendly neighborhoods. Offering plenty of space, comfort, and charm, this home is designed for both everyday living and entertaining. The main floor features a bright, open-concept layout with a spacious living room highlighted by a cozy center fireplace and Palladium windows that flood the space with natural light. The carpet-free design adds a clean, modern touch throughout. The expansive kitchen boasts ample cabinetry, including a full pantry wall, and an adjoining dining area with a walkout to a large deck perfect for family dinners or weekend barbecues. Upstairs, you'll find a welcoming family room with oversized windows, offering the ideal spot for movie nights or kids playtime. The second floor includes three generous bedrooms, including a primary suite complete with a walk-in closet and a private ensuite bathroom. The basement is mostly finished, offering a spacious recreation room, games area, laundry, and ample storage giving your family even more room to grow and play. Step outside to enjoy the oversized deck with a charming gazebo, overlooking a large fenced yard thats perfect for children, pets, or summer gatherings with friends and family. This home is ideally located with quick access to schools, parks, shopping, and transit everything a growing family needs, right at your doorstep. Move-in ready and waiting for its next family to make lasting memories. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Blinds"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-11T22:36:11.479436+00:00"
+"Directions": "Cross Streets: Chesapeake. ** Directions: Chesapeake to Bringantine."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094417"
+"ListOfficeKey": "270562"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36 x 148 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-11T21:40:59Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T21:40:59Z"
+"Stories": "2.0"
+"StreetName": "Brigantine"
+"StreetNumber": "503"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6069"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://iframe.videodelivery.net/36321914b51693ba3632b84777376e1e"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1559134803"
"RoomType" => "Living room"
"ListingId" => "X12685032"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29238726"
"RoomLength" => 8.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.14Z"
]
1 => array:11 [
"RoomKey" => "1559134804"
"RoomType" => "Other"
"ListingId" => "X12685032"
"RoomLevel" => "Basement"
"RoomWidth" => 2.6
"ListingKey" => "29238726"
"RoomLength" => 2.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.14Z"
]
2 => array:11 [
"RoomKey" => "1559134805"
"RoomType" => "Bathroom"
"ListingId" => "X12685032"
"RoomLevel" => "Main level"
"RoomWidth" => 1.42
"ListingKey" => "29238726"
"RoomLength" => 1.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.14Z"
]
3 => array:11 [
"RoomKey" => "1559134806"
"RoomType" => "Bathroom"
"ListingId" => "X12685032"
"RoomLevel" => "Second level"
"RoomWidth" => 1.72
"ListingKey" => "29238726"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.14Z"
]
4 => array:11 [
"RoomKey" => "1559134807"
"RoomType" => "Bathroom"
"ListingId" => "X12685032"
"RoomLevel" => "Second level"
"RoomWidth" => 1.72
"ListingKey" => "29238726"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.14Z"
]
5 => array:11 [
"RoomKey" => "1559134808"
"RoomType" => "Kitchen"
"ListingId" => "X12685032"
"RoomLevel" => "Main level"
"RoomWidth" => 3.43
"ListingKey" => "29238726"
"RoomLength" => 3.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.14Z"
]
6 => array:11 [
"RoomKey" => "1559134809"
"RoomType" => "Dining room"
"ListingId" => "X12685032"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29238726"
"RoomLength" => 3.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.14Z"
]
7 => array:11 [
"RoomKey" => "1559134810"
"RoomType" => "Foyer"
"ListingId" => "X12685032"
"RoomLevel" => "Main level"
"RoomWidth" => 2.19
"ListingKey" => "29238726"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.14Z"
]
8 => array:11 [
"RoomKey" => "1559134811"
"RoomType" => "Family room"
"ListingId" => "X12685032"
"RoomLevel" => "Second level"
"RoomWidth" => 4.84
"ListingKey" => "29238726"
"RoomLength" => 6.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.15Z"
]
9 => array:11 [
"RoomKey" => "1559134812"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12685032"
"RoomLevel" => "Second level"
"RoomWidth" => 4.86
"ListingKey" => "29238726"
"RoomLength" => 5.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.15Z"
]
10 => array:11 [
"RoomKey" => "1559134813"
"RoomType" => "Bedroom 2"
"ListingId" => "X12685032"
"RoomLevel" => "Second level"
"RoomWidth" => 3.14
"ListingKey" => "29238726"
"RoomLength" => 4.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.15Z"
]
11 => array:11 [
"RoomKey" => "1559134814"
"RoomType" => "Bedroom 3"
"ListingId" => "X12685032"
"RoomLevel" => "Second level"
"RoomWidth" => 3.32
"ListingKey" => "29238726"
"RoomLength" => 3.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.15Z"
]
12 => array:11 [
"RoomKey" => "1559134815"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12685032"
"RoomLevel" => "Basement"
"RoomWidth" => 4.81
"ListingKey" => "29238726"
"RoomLength" => 5.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.15Z"
]
13 => array:11 [
"RoomKey" => "1559134816"
"RoomType" => "Games room"
"ListingId" => "X12685032"
"RoomLevel" => "Basement"
"RoomWidth" => 3.47
"ListingKey" => "29238726"
"RoomLength" => 5.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-11T21:40:59.15Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29238726/503-brigantine-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4 Residential"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 36.0
+"OriginalEntryTimestamp": "2026-01-11T21:40:59.09Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:35 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6400553785"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/28ef57f68fc7b7ade08b4af0ce9b554d.webp"
"MediaSize" => 353104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-28ef57f68fc7b7ade08b4af0ce9b554d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6400553788"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/4beb71f6df9e1d25683daf28f5b37862.webp"
"MediaSize" => 389278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-4beb71f6df9e1d25683daf28f5b37862.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6400553791"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/498a8be9ab6fc7a1cca53ec925acf9e3.webp"
"MediaSize" => 349669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-498a8be9ab6fc7a1cca53ec925acf9e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6400553794"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/c644eee779a62b1e0b6912a0565e57c7.webp"
"MediaSize" => 148876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-c644eee779a62b1e0b6912a0565e57c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6400553797"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/cee5692d2a4872c6ba75434a294d148e.webp"
"MediaSize" => 213144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-cee5692d2a4872c6ba75434a294d148e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6400553800"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/2fa3eb474bf4eebd60970977e3a2c26f.webp"
"MediaSize" => 204892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-2fa3eb474bf4eebd60970977e3a2c26f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6400553802"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/c94ae93fad821722d5e74e82f7e8c5ef.webp"
"MediaSize" => 192878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-c94ae93fad821722d5e74e82f7e8c5ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6400553805"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/5980f1d629e3e6a4e178490e85dd6089.webp"
"MediaSize" => 222640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-5980f1d629e3e6a4e178490e85dd6089.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6400553807"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/3756df25884a0c38707b3af13f1e279f.webp"
"MediaSize" => 224634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-3756df25884a0c38707b3af13f1e279f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6400553810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/b4cca995b7ca7a90f56f76540f4243eb.webp"
"MediaSize" => 166599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-b4cca995b7ca7a90f56f76540f4243eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6400553813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/96e6832389f82f6e00d1cd6064d690d8.webp"
"MediaSize" => 185980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-96e6832389f82f6e00d1cd6064d690d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6400553816"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/93767962769ad637d78c68fba23b7030.webp"
"MediaSize" => 169511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-93767962769ad637d78c68fba23b7030.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6400553819"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/cfd83070260eac4e6538de7002d5b002.webp"
"MediaSize" => 134283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-cfd83070260eac4e6538de7002d5b002.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6400553822"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/83cb77ac07a7f9dff2c0ead1054d3a41.webp"
"MediaSize" => 198669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-83cb77ac07a7f9dff2c0ead1054d3a41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6400553823"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/7a50df2435898982ea08c1869f5f0853.webp"
"MediaSize" => 152172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-7a50df2435898982ea08c1869f5f0853.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6400553826"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/8c1861047c6b071d246195402ecbf2cb.webp"
"MediaSize" => 148209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-8c1861047c6b071d246195402ecbf2cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6400553830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/e45fd231be99bf2e66cf469acc5ab023.webp"
"MediaSize" => 153214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-e45fd231be99bf2e66cf469acc5ab023.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6400553833"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/e2083cfa31dfca6d686ff991e096f6b8.webp"
"MediaSize" => 124885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-e2083cfa31dfca6d686ff991e096f6b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6400553836"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/3cb22dfc86aa86d5d996298fc36b2b29.webp"
"MediaSize" => 200008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-3cb22dfc86aa86d5d996298fc36b2b29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6400553841"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/46da55421771eb5a8834bcdca4e2ca73.webp"
"MediaSize" => 200008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-46da55421771eb5a8834bcdca4e2ca73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6400553848"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/1495dcdd2c88dbd80b3f8c3b2a7e6f3d.webp"
"MediaSize" => 189334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-1495dcdd2c88dbd80b3f8c3b2a7e6f3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6400553852"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/adf712cac56f4c60a8ffde2c393e1679.webp"
"MediaSize" => 146242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-adf712cac56f4c60a8ffde2c393e1679.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6400553858"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/5e564da51ef38f03d723591c29e59639.webp"
"MediaSize" => 221388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-5e564da51ef38f03d723591c29e59639.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6400553863"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/797e44176e77051768c4c399936b3256.webp"
"MediaSize" => 256722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-797e44176e77051768c4c399936b3256.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6400553868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/6e473462004a368fc9c40cae0114bb9e.webp"
"MediaSize" => 271511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-6e473462004a368fc9c40cae0114bb9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6400553873"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/b1ddd2bbad7926a5d36b01ebcf7288c5.webp"
"MediaSize" => 266359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-b1ddd2bbad7926a5d36b01ebcf7288c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6400553878"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/723bf61ea8cdcb446477e5100cffbb18.webp"
"MediaSize" => 247091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-723bf61ea8cdcb446477e5100cffbb18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6400553885"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/d0b77d0e49bc84e0983e8292d18c33ec.webp"
"MediaSize" => 302537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-d0b77d0e49bc84e0983e8292d18c33ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6400553888"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/2c9f17f0f671a2e4b8ae252dc6b29458.webp"
"MediaSize" => 294958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-2c9f17f0f671a2e4b8ae252dc6b29458.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6400553895"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/a95f1d308536dc9cd2a2fb45b4ef2a5d.webp"
"MediaSize" => 304810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-a95f1d308536dc9cd2a2fb45b4ef2a5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6400553902"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/edab565923b0e80766f4a4bf1820797c.webp"
"MediaSize" => 438203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-edab565923b0e80766f4a4bf1820797c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6400553907"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/f5bcfe09dced8ef47b3c5812b9de780c.webp"
"MediaSize" => 364813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-f5bcfe09dced8ef47b3c5812b9de780c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6400553911"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29238726/b9d28236ae6057f0d6c8f4ff1a913b1a.webp"
"MediaSize" => 352356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29238726/thumbnail-b9d28236ae6057f0d6c8f4ff1a913b1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12685032"
"ResourceRecordKey" => "29238726"
"ModificationTimestamp" => "2026-01-11T21:40:59.1Z"
]
33 => array:13 [
"Order" => 33
…12
]
34 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238726')"
+"ID": "526569"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24807
+post_id: "517642"
+post_author: 1
+"ListingKey": "29226352"
+"ListingId": "X12673470"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T15:25:54Z"
+"RFModificationTimestamp": "2026-01-09T15:27:51Z"
+"ListPrice": 1875000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 4
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3L7"
+"UnparsedAddress": "592 MANORWOOD COURT, Waterloo, Ontario N2K3L7"
+"Coordinates": array:2 [
0 => -80.519367
1 => 43.5024746
]
+"Latitude": 43.5024746
+"Longitude": -80.519367
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "LARGE BUNGALOW LOCATED ON A PRIVATE STEET IN ONE OF THE MOST DESIRABLE POCKETS OF TOWN. Nestled on a serene, private street in one of the region's most coveted neighborhoods, this beautiful, unique bungalow presents a rare blend of timeless charm and endless potential. Set on a beautifully landscaped lot, the home boasts a resort-style backyard oasis featuring a custom stone-surrounded pool and jacuzzi-a true retreat for elegant outdoor living, perfect for entertaining or relaxing in total privacy. Recent updates, including a new furnace and AC, enhance comfort and efficiency, while other thoughtful upgrades throughout the home reflect pride of ownership. The unfinished lower level invites your vision, offering the perfect canvas for a luxury extension. Just moments from Conestoga Mall, restaurants, trails, parks, schools, and more. A remarkable opportunity for the discerning buyer. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Furniture"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 4
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T21:11:20.747069+00:00"
+"Directions": "Cross Streets: OLD ABBEY RD. ** Directions: OLD ABBEY RD TO MANORWOOD CRT."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182896"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T20:41:46Z"
+"PhotosCount": 33
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T15:14:20Z"
+"Stories": "1.0"
+"StreetName": "Manorwood"
+"StreetNumber": "592"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "13892"
+"VirtualTourURLUnbranded": "https://youriguide.com/vMO8OJ3ZOEEDD1/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29226352/592-manorwood-court-waterloo"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 91.1
+"OriginalEntryTimestamp": "2026-01-07T20:41:46.25Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29226352')"
+"ID": "517642"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24819
+post_id: "517747"
+post_author: 1
+"ListingKey": "29225692"
+"ListingId": "40796792"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T15:10:38Z"
+"RFModificationTimestamp": "2026-01-09T15:13:01Z"
+"ListPrice": 1875000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3515.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3L7"
+"UnparsedAddress": "592 MANORWOOD Court, Waterloo, Ontario N2K3L7"
+"Coordinates": array:2 [
0 => -80.5192028
1 => 43.5023406
]
+"Latitude": 43.5023406
+"Longitude": -80.5192028
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "LARGE BUNGALOW LOCATED ON A PRIVATE STEET IN ONE OF THE MOST DESIRABLE POCKETS OF TOWN. Nestled on a serene, private street in one of the region’s most coveted neighborhoods, this beautiful, unique bungalow presents a rare blend of timeless charm and endless potential. Set on a beautifully landscaped lot, the home boasts a resort-style backyard oasis featuring a custom stone-surrounded pool and jacuzzi—a true retreat for elegant outdoor living, perfect for entertaining or relaxing in total privacy. Recent updates, including a new furnace and AC, enhance comfort and efficiency, while other thoughtful upgrades throughout the home reflect pride of ownership. The unfinished lower level invites your vision, offering the perfect canvas for a luxury extension. Just moments from Conestoga Mall, restaurants, trails, parks, schools, and more. A remarkable opportunity for the discerning buyer. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T19:40:26.137979+00:00"
+"Directions": "OLD ABBEY RD"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-07T19:08:51Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T14:59:44Z"
+"Stories": "1.0"
+"StreetName": "MANORWOOD"
+"StreetNumber": "592"
+"StreetSuffix": "Court"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "13892"
+"VirtualTourURLUnbranded": "https://youriguide.com/vMO8OJ3ZOEEDD1/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29225692/592-manorwood-court-waterloo"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 92.0
+"AboveGradeFinishedArea": 3515
+"OriginalEntryTimestamp": "2026-01-07T19:08:51.09Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29225692')"
+"ID": "517747"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24769
+post_id: "515381"
+post_author: 1
+"ListingKey": "29223342"
+"ListingId": "40795022"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-07T15:15:05Z"
+"RFModificationTimestamp": "2026-01-07T15:16:59Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 562.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "247 NORTHFIELD Street Unit# 308, Waterloo, Ontario N2K0H1"
+"Coordinates": array:2 [
0 => -80.5217286
1 => 43.5099657
]
+"Latitude": 43.5099657
+"Longitude": -80.5217286
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new home at the prestigious Blackstone building in Waterloo! This stunning one bedroom condo offers luxury living at its finest. Step into a modern space with high-end finishes including stainless appliances, sleek quartz countertops, and a spacious walk-in closet. This unit also comes with an owned storage locker and a conveniently located parking spot, W6 - the closest parking space to the front doors of the building, ensuring a hassle-free experience every time you come home. Condo fees include water and internet as well. Blackstone's amenities are second to none, with a fitness centre to keep you active, social rooms for entertaining guests, a co-working space with meeting rooms for your business needs, and even a pet wash station for your furry friends. Outdoor enthusiasts will love the courtyard with a hot tub, fire bowl, BBQ area, and harvest table - perfect for enjoying the fresh air. And don't forget about the rooftop terrace with lounge seating and BBQ facilities, offering stunning views of the city skyline. Experience convenience, luxury, and a vibrant community lifestyle at Blackstone. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"AssociationFee": "469"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-07T06:53:42.491533+00:00"
+"Directions": "Northfield to entrance"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2126426"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Country residential"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-07T05:21:44Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-07T15:00:51Z"
+"Stories": "1.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "247"
+"StreetSuffix": "Street"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "2822"
+"VirtualTourURLUnbranded": "https://youriguide.com/247_northfield_dr_e_suite_308_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29223342/247-northfield-street-unit-308-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 562
+"OriginalEntryTimestamp": "2026-01-07T05:18:38.79Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29223342')"
+"ID": "515381"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25150
+post_id: "512734"
+post_author: 1
+"ListingKey": "29220138"
+"ListingId": "40796187"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-06T17:35:37Z"
+"RFModificationTimestamp": "2026-01-06T17:52:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 538.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H4"
+"UnparsedAddress": "251 NORTHFIELD Drive E Unit# 105, Waterloo, Ontario N2K3H4"
+"Coordinates": array:2 [
0 => -80.5217325
1 => 43.5105682
]
+"Latitude": 43.5105682
+"Longitude": -80.5217325
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into the welcoming embrace of 251 NORTHFIELD Drive E Unit #105, situated in the vibrant community of Waterloo. This delightful 1-bedroom, 1-bathroom unit invites you to experience comfort and convenience in a prime location. As you step inside, you'll be greeted by an inviting open-concept living space, perfect for both relaxation and entertaining guests. The kitchen comes fully equipped with everything you need to whip up delicious meals, while ample natural light floods the space, creating a warm and inviting atmosphere. When it's time to unwind, the bedroom offers a serene retreat, with plenty of storage space. The bathroom is modern and well-appointed, ensuring your comfort and convenience. Step outside onto your private balcony, where you can enjoy your morning coffee or soak up the sunshine in peace. With reserved parking and on-site laundry facilities, everyday tasks become a breeze. And for those with furry companions, rest assured that this apartment is pet-friendly, so your four-legged friends can feel right at home too. With shopping, dining, and entertainment options just moments away, everything you need is within easy reach. Ready to experience the charm and convenience of life at 251 NORTHFIELD Drive E Unit #105? Schedule a viewing today and discover your new home sweet home in Waterloo. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Industrial Park"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-06T17:52:35.282729+00:00"
+"Directions": "Northfield Dr. to Bridge St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1897408"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Industrial mall/subdivision"
]
+"PhotosChangeTimestamp": "2026-01-06T17:29:07Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-06T17:29:07Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "2662.77"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29220138/251-northfield-drive-e-unit-105-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1850
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 538
+"OriginalEntryTimestamp": "2026-01-06T17:29:07.33Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29220138')"
+"ID": "512734"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24761
+post_id: "512605"
+post_author: 1
+"ListingKey": "29219150"
+"ListingId": "40795948"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:20:25Z"
+"RFModificationTimestamp": "2026-01-14T21:29:22Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3080.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3Y5"
+"UnparsedAddress": "537 WINDJAMMER Way, Waterloo, Ontario N2K3Y5"
+"Coordinates": array:2 [
0 => -80.5050792
1 => 43.506906
]
+"Latitude": 43.506906
+"Longitude": -80.5050792
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful Family Home in Highly Sought-After Eastbridge Community Welcome to this charming 4-bed, 3.5-bath home in the heart of Eastbridge—complete with a fully finished basement, covered outdoor living space, and no rear neighbours. With outstanding curb appeal in a family-friendly neighbourhood, this meticulously maintained home offers bright and thoughtfully designed living space. The spacious foyer includes a highly functional walk-in coat closet, ideal for busy families or hosting guests. A front living room provides the perfect spot for a home office or play area, with a clear view of the street to keep an eye on the kids. Elegant hardwood floors lead you to the renovated kitchen, featuring a gas stove, large island, and ambient pot lighting. The open-concept layout connects seamlessly to the second living area, complete with large windows and a cozy fireplace. Step through the sliding glass doors to your expansive covered deck, featuring a built-in BBQ, ample seating, and peaceful views—no rear neighbours make this private outdoor retreat exceptionally enjoyable. Upstairs, hardwood floors continue throughout. The large primary suite features two closets and a renovated spa-like 4-pc ensuite with heated floors and a steam shower. Three additional bedrooms, a linen closet, and a 5-pc bathroom complete the upper level. The fully finished basement offers engineered hardwood floors, a stone fireplace, a 3-pc bathroom, and generous storage space. This home has been exceptionally cared for and is truly move-in ready. Book your showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-06T17:43:16.683185+00:00"
+"Directions": "Eastbridge Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-06T15:00:44Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:09:21Z"
+"Stories": "2.0"
+"StreetName": "WINDJAMMER"
+"StreetNumber": "537"
+"StreetSuffix": "Way"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6138"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/95usa_537_windjammer_way_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29219150/537-windjammer-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2104
+"BelowGradeFinishedArea": 976
+"OriginalEntryTimestamp": "2026-01-06T15:00:44.44Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Assessor"
+"Media": array:40 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29219150')"
+"ID": "512605"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "507283"
+post_author: 1
+"ListingKey": "29211765"
+"ListingId": "40795634"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-03T03:45:10Z"
+"RFModificationTimestamp": "2026-01-03T04:38:01Z"
+"ListPrice": 1749000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.464
+"LivingArea": 4211.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1Y6"
+"UnparsedAddress": "514 OXBOW Road, Waterloo, Ontario N2K1Y6"
+"Coordinates": array:2 [
0 => -80.5133408
1 => 43.4996137
]
+"Latitude": 43.4996137
+"Longitude": -80.5133408
+"YearBuilt": 1968
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Updated executive home sits on a private court in Colonial Acres and backs onto a stream. There is plenty of room with the main floor office and five bathrooms. the main level is carpet free and features a beautiful floating staircase. The custom kitchen features a walk-in pantry and an island with seating. The bright living room features a built in fireplace and large windows. The dining area features its own built-in fireplace and walk out to backyard patio. Two of the five bedrooms have ensuite bathrooms. The primary features vaulted ceilings and a walk-in closet with built in organization. Prepare to be impressed by the 6 piece en-suite with its walkthrough shower, heated tiled floors and soaker tub. The finished lower level features a bar, wine cellar, gym and recreation room that walks out to the fenced rear yard. The spacious backyard features a 40' x 20' pool. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Range - Gas"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-03T04:37:44.786486+00:00"
+"Directions": "Lexington Rd. to Lee Ave. to Oxbow Rd."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Aluminum siding"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750484"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.464"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-03T03:38:25Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-03T03:38:25Z"
+"Stories": "2.0"
+"StreetName": "OXBOW"
+"StreetNumber": "514"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "15826"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29211765/514-oxbow-road-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 125.0
+"AboveGradeFinishedArea": 3254
+"BelowGradeFinishedArea": 957
+"OriginalEntryTimestamp": "2026-01-03T03:38:25.48Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
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]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29211765')"
+"ID": "507283"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25142
+post_id: "506185"
+post_author: 1
+"ListingKey": "29210260"
+"ListingId": "X12656486"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-02T18:30:06Z"
+"RFModificationTimestamp": "2026-01-02T20:01:03Z"
+"ListPrice": 475000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3R5"
+"UnparsedAddress": "2 - 455 KINGSCOURT DRIVE, Waterloo, Ontario N2K3R5"
+"Coordinates": array:2 [
0 => -80.523088
1 => 43.494076
]
+"Latitude": 43.494076
+"Longitude": -80.523088
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Tucked into a well-managed condo enclave in Waterloo, this stylish 2-storey townhouse offers the perfect blend of functionality and modern comfort. A welcoming tile foyer leads to a bright kitchen featuring stainless steel appliances and a clean, efficient layout ideal for everyday cooking. The open-concept living area with laminate flooring is anchored by a walk-out to a private yard-ideal for hosting or simply enjoying the outdoors in warmer months.Upstairs, you'll find two generously sized bedrooms, both with laminate flooring and large windows that invite abundant natural light. The primary bedroom boasts a walk-in closet for added convenience, while the second bedroom offers flexibility for guests, a home office, or a nursery. A 3-piece bath on the second level complements the main floor powder room, providing function across both levels.Additional highlights include central air conditioning, gas-forced air heating, ensuite laundry, and a built-in garage with Electric Vehicle Charger installed and with a private driveway-providing two parking spaces in total. With maintenance fees covering common elements and building insurance, this unit presents a low-stress ownership opportunity.Positioned with south-facing exposure, the home captures all-day light and is conveniently located near King Street and Conestoga Parkway, offering easy access to local amenities, shopping, and transit. Whether you're looking to enter the market, downsize smartly, or invest in a desirable area, this turn-key unit offers lasting value in a sought-after Waterloo location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
]
+"AssociationFee": "394.73"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-02T20:00:42.442175+00:00"
+"Directions": "KING ST / CONESTOGA PKWY"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1719272"
+"ListOfficeKey": "282777"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-02T18:12:23Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-02T18:12:23Z"
+"Stories": "2.0"
+"StreetName": "Kingscourt"
+"StreetNumber": "455"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3140.71"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29210260/2-455-kingscourt-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Reed Condominium Management Solutions OLCMP"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-02T18:12:23.09Z"
+"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]
]
+"Member": array:1 [
0 => array:25 [ …25]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29210260')"
+"ID": "506185"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25141
+post_id: "506358"
+post_author: 1
+"ListingKey": "29209781"
+"ListingId": "X12655928"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-02T16:21:00Z"
+"RFModificationTimestamp": "2026-01-02T19:45:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "217 - 251 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.521738
1 => 43.509974
]
+"Latitude": 43.509974
+"Longitude": -80.521738
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Amazingly upgraded two-bedroom, two full bath unit at the Blackstone Condos in Northeast Waterloo - close to Conestoga Mall, the LRT, with restaurants and amenites just steps away and everything need in walking distance. This unit has been upgraded with quartz in the kitchen and bathrooms, glass shower doors, potlights, stylish finishes, barn door sliders, decorative shelving, closet organizers, custom blinds and decorative wallpaper. Internet and heat included with your unit; tenant pays electricity and water. Add an east-facing balcony for morning coffee and you have all you need! Excellent location on the second floor, you have the option to just scoot up the front stairwell and straight to your unit, or you can enter through the fancy lobby and lounge, past the gym and board room via the elevator. Exercise room and amazing party room on site. In suite laundry and one above ground surface parking space right near the entrance included. (id:62650)"
+"Appliances": array:1 [
0 => "Intercom"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-02T19:45:26.298594+00:00"
+"Directions": "Cross Streets: Bridge Street. ** Directions: Bridge and Northfield."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099893"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-02T16:12:16Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-02T16:12:16Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "251"
+"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/29209781/217-251-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers"
+"GeocodeManualYN": false
+"TotalActualRent": 2199
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-02T16:12:16.4Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29209781')"
+"ID": "506358"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 45
+after_key: ""
}
"RF Response Time" => "0.35 seconds"
]
]