array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29170241/Property?$select=ALL&$top=20&$filter=ListingKey eq 29170241&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29170241/Property?$select=ALL&$top=20&$filter=ListingKey eq 29170241&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23632
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23634
+post_id: "468750"
+post_author: 1
+"ListingKey": "29170241"
+"ListingId": "40791913"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T14:40:52Z"
+"RFModificationTimestamp": "2025-12-08T14:43:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1559.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4A2"
+"UnparsedAddress": "447 BRIGANTINE Drive, Waterloo, Ontario N2K4A2"
+"Coordinates": array:2 [
0 => -80.5109197
1 => 43.5063641
]
+"Latitude": 43.5063641
+"Longitude": -80.5109197
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Perfect for families or professionals, this full-home rental is set within one of Waterloo’s most sought-after neighbourhoods. The thoughtfully designed floor plan includes 3 above-grade bedrooms, including a generous primary suite featuring a walk-in closet and private ensuite, with a second full bathroom completing the upper level. The main floor offers a bright, functional layout with a dining room, living room, kitchen, and a convenient powder room. The large front hallway closet provides exceptional storage for all your family’s needs, and the kitchen offers ample cabinetry, including a convenient pantry. Skylights bring in abundant natural light, creating a warm and inviting atmosphere, and a walkout leads to a deck overlooking a beautifully maintained garden and fully fenced backyard—ideal for relaxing, barbecuing, or entertaining. The finished basement enhances the home’s versatility with a fourth bedroom or flex room, a full bathroom, a wet bar, a laundry area, and a generous family room with a cozy gas fireplace—perfect for guests, a home office, or additional recreational space. Located close to top-rated schools, RIM Park, golf courses, trails, the river, shopping, dining, Conestoga Mall, Uptown Waterloo, and convenient public transit, this home also offers quick access to Hwy 7/8 and both universities, combining comfort, convenience, and an unbeatable location to create an exceptional place to call home. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Freezer"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T14:43:19.127196+00:00"
+"Directions": "Bridge St. W., to Chesapeake Drive, to Brigantine Drive"
+"ExteriorFeatures": array:3 [
0 => "Vinyl siding"
1 => "Shingles"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101905"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Skylight"
3 => "Sump Pump"
4 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T12:58:33Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T14:30:00Z"
+"Stories": "2.0"
+"StreetName": "BRIGANTINE"
+"StreetNumber": "447"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4822"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/447_brigantine_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1546647309"
"RoomType" => "3pc Bathroom"
"ListingId" => "40791913"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.97Z"
]
1 => array:11 [
"RoomKey" => "1546647310"
"RoomType" => "Recreation room"
"ListingId" => "40791913"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => "20'0'' x 25'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.97Z"
]
2 => array:11 [
"RoomKey" => "1546647311"
"RoomType" => "Bedroom"
"ListingId" => "40791913"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.97Z"
]
3 => array:11 [
"RoomKey" => "1546647312"
"RoomType" => "Full bathroom"
"ListingId" => "40791913"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.97Z"
]
4 => array:11 [
"RoomKey" => "1546647313"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791913"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.97Z"
]
5 => array:11 [
"RoomKey" => "1546647314"
"RoomType" => "Bedroom"
"ListingId" => "40791913"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.97Z"
]
6 => array:11 [
"RoomKey" => "1546647315"
"RoomType" => "Bedroom"
"ListingId" => "40791913"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.98Z"
]
7 => array:11 [
"RoomKey" => "1546647316"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791913"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.98Z"
]
8 => array:11 [
"RoomKey" => "1546647317"
"RoomType" => "2pc Bathroom"
"ListingId" => "40791913"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.99Z"
]
9 => array:11 [
"RoomKey" => "1546647318"
"RoomType" => "Living room"
"ListingId" => "40791913"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.99Z"
]
10 => array:11 [
"RoomKey" => "1546647319"
"RoomType" => "Dining room"
"ListingId" => "40791913"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.99Z"
]
11 => array:11 [
"RoomKey" => "1546647320"
"RoomType" => "Kitchen"
"ListingId" => "40791913"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29170241"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-08T14:30:00.99Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29170241/447-brigantine-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1908292"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"TotalActualRent": 3100
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 1559
+"OriginalEntryTimestamp": "2025-12-08T12:58:32.94Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:42 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6361079220"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/853b30850e36c52aea2eb26c67010ee1.webp"
"MediaSize" => 128088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-853b30850e36c52aea2eb26c67010ee1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Traditional-style home with brick siding, a porch, and an attached garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6361079229"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/d2a7386c8a6039f0231b23d9a71191d2.webp"
"MediaSize" => 126205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-d2a7386c8a6039f0231b23d9a71191d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front facade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6361079336"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/f992f5643e54402f2063394e9b36f0a0.webp"
"MediaSize" => 153213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-f992f5643e54402f2063394e9b36f0a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front facade"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6361079359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/1c76f4baca9d1666a3bbedbce4b55c5f.webp"
"MediaSize" => 109059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-1c76f4baca9d1666a3bbedbce4b55c5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Porch"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6361079375"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/395670bb09bd333a14d6a5ad8efc1ddc.webp"
"MediaSize" => 46629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-395670bb09bd333a14d6a5ad8efc1ddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry way"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6361079448"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/6ac6db05b25e148eac215fded452c672.webp"
"MediaSize" => 57032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-6ac6db05b25e148eac215fded452c672.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry way"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6361079534"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/54871120ca1dfb4c150762e02bb844ed.webp"
"MediaSize" => 45409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-54871120ca1dfb4c150762e02bb844ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Half bathroom featuring plenty of natural light and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6361079558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/1159003bea2d113a93478ee5e318730c.webp"
"MediaSize" => 70877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-1159003bea2d113a93478ee5e318730c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room with wood floors, vaulted ceiling, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6361079642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/fd1e45de5c5a7d1cc76232e3daeec29c.webp"
"MediaSize" => 76109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-fd1e45de5c5a7d1cc76232e3daeec29c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6361079709"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/84572c6b4dfe08cf5ca6e338dce1f546.webp"
"MediaSize" => 82173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-84572c6b4dfe08cf5ca6e338dce1f546.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6361079806"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/3d9f3b3dc1ff977cab1b96024447ea24.webp"
"MediaSize" => 79307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-3d9f3b3dc1ff977cab1b96024447ea24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6361079906"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/5edfb0b85539a246df57dbf07dd39415.webp"
"MediaSize" => 80234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-5edfb0b85539a246df57dbf07dd39415.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6361079927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/806d8f0543b1141c44ebcbc7bb5f5824.webp"
"MediaSize" => 79798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-806d8f0543b1141c44ebcbc7bb5f5824.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6361080000"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/ac47136616dc4351a0eb0515c22f3fcb.webp"
"MediaSize" => 65806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-ac47136616dc4351a0eb0515c22f3fcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with a breakfast bar, ss appliances, glass insert cabinets, and light stone counters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6361080096"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/84f29ccf25f534f03728230e0f69cc69.webp"
"MediaSize" => 62550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-84f29ccf25f534f03728230e0f69cc69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6361080116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/6bd699fefb56c754d341dd0a4554dead.webp"
"MediaSize" => 62299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-6bd699fefb56c754d341dd0a4554dead.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6361080202"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/452ab5319d51e2ba51675f913f6151bd.webp"
"MediaSize" => 66391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-452ab5319d51e2ba51675f913f6151bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6361080232"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/e66d58dcc313a1c8584e8eb05c2b8650.webp"
"MediaSize" => 59462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-e66d58dcc313a1c8584e8eb05c2b8650.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6361080245"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/639606d4af8820c96729e43e4a500645.webp"
"MediaSize" => 61919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-639606d4af8820c96729e43e4a500645.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6361080301"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/88cb9feeb5e3746cb9c1b1deccd9f144.webp"
"MediaSize" => 39434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-88cb9feeb5e3746cb9c1b1deccd9f144.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Second floor landing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6361080349"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/db183160072abaebd002972d887cd8cf.webp"
"MediaSize" => 72246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-db183160072abaebd002972d887cd8cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom with vaulted ceiling, dark wood-style flooring, and array of windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6361080400"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/81f7a4e28fc90f866b43e37504bcd3d7.webp"
"MediaSize" => 76605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-81f7a4e28fc90f866b43e37504bcd3d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6361080416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/83f4b0e08eb5f4190458c4dc6fed1fe1.webp"
"MediaSize" => 73139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-83f4b0e08eb5f4190458c4dc6fed1fe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6361080437"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/8ba0fba35dcc575d4d7bb7ae3b74f159.webp"
"MediaSize" => 59845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-8ba0fba35dcc575d4d7bb7ae3b74f159.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary bedroom ensuite bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6361080467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/b191ca49e0240e76c954be5def1d0e72.webp"
"MediaSize" => 49447
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-b191ca49e0240e76c954be5def1d0e72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6361080511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/8380f0122c3f7ac0dc5c5aeb6dfb9b44.webp"
"MediaSize" => 71203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-8380f0122c3f7ac0dc5c5aeb6dfb9b44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with dark wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6361080535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/5b5b0d6b717dabb7d436d3b3de4a2f89.webp"
"MediaSize" => 74033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-5b5b0d6b717dabb7d436d3b3de4a2f89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with dark wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6361080589"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/d2166a4e14db946f70788772390a7357.webp"
"MediaSize" => 39278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-d2166a4e14db946f70788772390a7357.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main 2nd floor bathroom with vanity, light wood-style flooring, and shower / bath combo with shower curtain"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6361080607"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/da889e2309e8c75e02c01f762555914e.webp"
"MediaSize" => 37762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-da889e2309e8c75e02c01f762555914e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wet bar featuring white cabinets, light countertops, and tile floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6361080629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/51dc6719b7c1cfaa4dacb228792a6655.webp"
"MediaSize" => 38827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-51dc6719b7c1cfaa4dacb228792a6655.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wet bar"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6361080643"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/27f12169b73bae39f2ab4e5f62f3aa0b.webp"
"MediaSize" => 49673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-27f12169b73bae39f2ab4e5f62f3aa0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted family room with recessed lighting and a gas fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6361080661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/8e40ede372a4d2581cdb5f7ba6de9edf.webp"
"MediaSize" => 42156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-8e40ede372a4d2581cdb5f7ba6de9edf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Family room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6361080695"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/5a42daad3edc5767c155fb2d52c60267.webp"
"MediaSize" => 73109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-5a42daad3edc5767c155fb2d52c60267.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Family room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6361080715"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/2ba38cc41de516fb468e99f54ec706a4.webp"
"MediaSize" => 68843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-2ba38cc41de516fb468e99f54ec706a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Family room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6361080734"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/a5071cfb90285913ab25b2b952b70a35.webp"
"MediaSize" => 71677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-a5071cfb90285913ab25b2b952b70a35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Flex room in basement for office, guest bedroom, gym, etc."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6361080751"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/c6a66277f4bca7a7ceaf84801f078a8b.webp"
"MediaSize" => 63813
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-c6a66277f4bca7a7ceaf84801f078a8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full 3pc bathroom in basement"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6361080770"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/a649cb029feaa1bbdfc36cf571332d38.webp"
"MediaSize" => 127622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-a649cb029feaa1bbdfc36cf571332d38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Snow covered deck with a fenced backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6361080787"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/937d567ff92b0e068b191822d47e8e5c.webp"
"MediaSize" => 87617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-937d567ff92b0e068b191822d47e8e5c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6361080798"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/7b0b6ef74ab67f5a7b7a80db44d95864.webp"
"MediaSize" => 111370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-7b0b6ef74ab67f5a7b7a80db44d95864.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6361080813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/82e4605fcbf55bf2feb848988ee088c0.webp"
"MediaSize" => 104891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-82e4605fcbf55bf2feb848988ee088c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6361080820"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/ee36ee7e55caf135c01dedcda32fa332.webp"
"MediaSize" => 120424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-ee36ee7e55caf135c01dedcda32fa332.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6361080828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29170241/3049628a94534a36135bbf8046bfb9e9.webp"
"MediaSize" => 105280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29170241/thumbnail-3049628a94534a36135bbf8046bfb9e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Snow covered property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791913"
"ResourceRecordKey" => "29170241"
"ModificationTimestamp" => "2025-12-08T12:58:32.94Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Corinna Riquelme"
"MemberFirstName" => "Corinna"
"MemberLastName" => "Riquelme"
"MemberMlsId" => "KWkw1283"
"OriginatingSystemName" => 26
"MemberKey" => "2101905"
"ModificationTimestamp" => "2025-12-11T01:31:28Z"
"MemberStatus" => "Active"
"OfficeKey" => "283125"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberFax" => "519-747-2081"
"MemberCity" => "Waterloo"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "226-338-8989"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2020-10-20T19:04:00Z"
"MemberNationalAssociationId" => "1371695"
"OfficeNationalAssociationId" => "1324759"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "Royal LePage Wolle Realty"
"OfficePhone" => "519-747-2040"
"OfficeMlsId" => "KW45"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "283125"
"ModificationTimestamp" => "2025-08-19T15:50:12Z"
"OfficeAddress1" => "180 Northfield Drive W., Unit 7A"
"OfficeCity" => "Waterloo"
"OfficePostalCode" => "N2L0C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "519-747-2081"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2018-03-02T15:26:00Z"
"OfficeNationalAssociationId" => "1324759"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1069818"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29170241')"
+"ID": "468750"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283125/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283125&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283125/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283125&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25483
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25485
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Wolle Realty"
+"OfficeEmail": null
+"OfficePhone": "519-747-2040"
+"OfficeMlsId": "KW45"
+"ModificationTimestamp": "2025-08-19T15:50:12Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283125"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "180 Northfield Drive W., Unit 7A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2L0C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1324759"
+"OriginalEntryTimestamp": "2018-03-02T15:26:00Z"
+"OfficeFax": "519-747-2081"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "269302"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283125"
"SocialMediaUrlOrId" => "http://www.wollerealty.com/"
"ModificationTimestamp" => "2025-08-19T15:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1069818"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('283125')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2101905/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2101905&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2101905/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2101905&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25488
+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 29170241" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25098
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29170241/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29170241&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29170241/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29170241&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25078
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29170241 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5109197 43.5063641)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29170241 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5109197 43.5063641)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29170241 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5109197 43.5063641)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29170241 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5109197 43.5063641)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25010
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25021
+post_id: "484067"
+post_author: 1
+"ListingKey": "29188535"
+"ListingId": "40794079"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T21:40:39Z"
+"RFModificationTimestamp": "2025-12-16T21:43:56Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.076
+"LivingArea": 2400.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K2Y7"
+"UnparsedAddress": "486B KINGSCOURT Drive, Waterloo, Ontario N2K2Y7"
+"Coordinates": array:2 [
0 => -80.5215279
1 => 43.4953314
]
+"Latitude": 43.4953314
+"Longitude": -80.5215279
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into the welcoming space at 486B Kingscourt Drive, situated in the vibrant community of Waterloo. This delightful 3+1-bedroom, 2-bathroom home invites you to experience comfort and convenience in a prime location. As you step inside, you'll be greeted by an inviting living space, perfect for both relaxation and entertaining guests. The kitchen comes fully equipped with everything you need, while ample natural light floods the space, creating a warm and inviting atmosphere. Kitchen appliances include Stove, Built-in microwave and Refrigerator. This house comes with pristine hardwood floors on all levels and laundry in the basement. The bedrooms are spacious with plenty of storage space and offer a serene retreat. The bathroom is modern and well-appointed, ensuring your comfort and convenience. Step outside onto your fully fenced private yard, where you can enjoy your morning coffee or soak up the sunshine in peace. Store your extras in the garden shed and large storage room in the basement. There are shopping, dining, and entertainment options just moments away, everything you need is within easy reach. Get ready to experience the charm of this home. It is close to Conestoga Mall, University of Waterloo and Wifrid Laurier University, KidsAbility, Schools, Parks, Golf Course & other Amenities. Schedule a viewing today and discover your new home in Waterloo. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-16T03:28:56.687586+00:00"
+"Directions": "From Lexington Road turn left on Davenport Road and left on Kingscourt Drive"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072201"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0.076"
+"PhotosChangeTimestamp": "2025-12-16T02:28:48Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-16T21:38:25Z"
+"Stories": "1.0"
+"StreetName": "KINGSCOURT"
+"StreetNumber": "486"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3494"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1550079882"
"RoomType" => "Storage"
"ListingId" => "40794079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.93Z"
]
1 => array:11 [
"RoomKey" => "1550079883"
"RoomType" => "Bedroom"
"ListingId" => "40794079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.94Z"
]
2 => array:11 [
"RoomKey" => "1550079884"
"RoomType" => "Bedroom"
"ListingId" => "40794079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.94Z"
]
3 => array:11 [
"RoomKey" => "1550079885"
"RoomType" => "Bedroom"
"ListingId" => "40794079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.95Z"
]
4 => array:11 [
"RoomKey" => "1550079886"
"RoomType" => "3pc Bathroom"
"ListingId" => "40794079"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.95Z"
]
5 => array:11 [
"RoomKey" => "1550079887"
"RoomType" => "Laundry room"
"ListingId" => "40794079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.95Z"
]
6 => array:11 [
"RoomKey" => "1550079888"
"RoomType" => "Bedroom"
"ListingId" => "40794079"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
7 => array:11 [
"RoomKey" => "1550079889"
"RoomType" => "3pc Bathroom"
"ListingId" => "40794079"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
8 => array:11 [
"RoomKey" => "1550079890"
"RoomType" => "Recreation room"
"ListingId" => "40794079"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 25'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
9 => array:11 [
"RoomKey" => "1550079891"
"RoomType" => "Kitchen"
"ListingId" => "40794079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
10 => array:11 [
"RoomKey" => "1550079892"
"RoomType" => "Living room/Dining room"
"ListingId" => "40794079"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29188535"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 24'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T21:38:25.96Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29188535/486b-kingscourt-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2999
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1300
+"BelowGradeFinishedArea": 1100
+"OriginalEntryTimestamp": "2025-12-16T02:28:48.18Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"Media": array:33 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6371135802"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/f351d75a58213cf3aab556205df57383.webp"
"MediaSize" => 95826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-f351d75a58213cf3aab556205df57383.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of property featuring brick siding and driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6371135803"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/c0fbd8747164f4d4bec337e93bfa4718.webp"
"MediaSize" => 37575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-c0fbd8747164f4d4bec337e93bfa4718.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room with stairway and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6371135805"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/466e96ad6f75d4008855110504093ba3.webp"
"MediaSize" => 72032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-466e96ad6f75d4008855110504093ba3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen view of electric stove and light stone countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6371135807"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/cfe648557cc05b203e471f0e7e761219.webp"
"MediaSize" => 44812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-cfe648557cc05b203e471f0e7e761219.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Below grade area featuring light wood finished floors, recessed lighting, and stairway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6371135809"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/c9f3f4ec5cdb4516ab87cd55eed61fdd.webp"
"MediaSize" => 43835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-c9f3f4ec5cdb4516ab87cd55eed61fdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished basement featuring baseboards and dark wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6371135811"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/eef7764171e21988ea8a6a0fafbff88d.webp"
"MediaSize" => 30716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-eef7764171e21988ea8a6a0fafbff88d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of storage area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6371135813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/1a14fe6da7b54eb2bf146b2600b88104.webp"
"MediaSize" => 71837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-1a14fe6da7b54eb2bf146b2600b88104.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with stove, dark cabinetry, refrigerator, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6371135815"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29188535/d5f17063a294a4dacbdbc958cc38d9f2.webp"
"MediaSize" => 35665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29188535/thumbnail-d5f17063a294a4dacbdbc958cc38d9f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring light wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40794079"
"ResourceRecordKey" => "29188535"
"ModificationTimestamp" => "2025-12-16T02:28:48.2Z"
]
8 => array:13 [
"Order" => 8
…12
]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29188535')"
+"ID": "484067"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25013
+post_id: "481615"
+post_author: 1
+"ListingKey": "29185243"
+"ListingId": "X12632142"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T20:35:04Z"
+"RFModificationTimestamp": "2025-12-13T22:47:01Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "413 - 255 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.521297
1 => 43.510381
]
+"Latitude": 43.510381
+"Longitude": -80.521297
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "~ WELCOME TO BLACKSTONE CONDOS ~~ Stylish 1-Bedroom & 1 Bath Suite on the 4th Floor offering almost 600 SQFT with UNOBSTRUCTED 180 SKY VIEWS ~ enjoy your morning coffee or sunsets! Open-Concept Layout ~ Functional & Elegant Kitchen with Quartz Countertops, Subway Tile Backsplash, Stainless Steel Appliances & Undermount Sink Bright Living Area flowing seamlessly to Balcony Spacious Walk-In Closet + In-Suite Laundry + Front Hall Closet Modern 3-Pc Bath 1 Surface Parking Space Included~ LUXURY AMENITIES ~ Designer Lounge w/ Bar & Fireplace Fitness & Study Rooms Secure Bike Storage + Repair Station Pet Wash Station 2 Outdoor Lounges with BBQs & Hot Tub ~ Perfect for Entertaining!~ Bakery, Salon, Restaurants, Pub & Dental Office ~ All Just Steps Away!Minutes to Conestoga Mall, Public Library, RIM Park (sports & rec), Golf, Conservation Areas & Miles of Trails for Walking & Cycling. ~ Don't Miss This Opportunity! AVAILABLE IMMEDIATELY ~ (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-13T22:46:50.369270+00:00"
+"Directions": "Northfield & Bridge St W"
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Stone"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088809"
+"ListOfficeKey": "293791"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-13T20:22:38Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T20:22:38Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29185243/413-255-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2156054"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FIVE RIVERS PROPERTY MANAGEMENT GROUP INC."
+"CoListOfficeKey": "293791"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"BuildingFeatures": array:5 [
0 => "Exercise Centre"
1 => "Separate Electricity Meters"
2 => "Separate Heating Controls"
3 => "Party Room"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:3 [
0 => "Security system"
1 => "Smoke Detectors"
2 => "Controlled entry"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-13T20:22:38.4Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29185243')"
+"ID": "481615"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25026
+post_id: "478869"
+post_author: 1
+"ListingKey": "29183515"
+"ListingId": "X12630486"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T19:55:38Z"
+"RFModificationTimestamp": "2025-12-12T23:40:07Z"
+"ListPrice": 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:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T23:39:50.467805+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-12-12T19:49:56Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T19:49:56Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "247"
+"StreetSuffix": "Drive"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29183515/415-247-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five River"
+"GeocodeManualYN": false
+"TotalActualRent": 1795
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-12T19:49:56.83Z"
+"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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29183515')"
+"ID": "478869"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25014
+post_id: "477497"
+post_author: 1
+"ListingKey": "29183318"
+"ListingId": "40793559"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T19:10:22Z"
+"RFModificationTimestamp": "2025-12-12T19:37:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 644.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H1"
+"UnparsedAddress": "247 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:6 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Insurance"
5 => "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-12-12T19:37:13.615169+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-12-12T19:00:28Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T19:00:27Z"
+"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: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/29183318/247-northfield-drive-e-unit-415-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1795
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 644
+"OriginalEntryTimestamp": "2025-12-12T19:00:27.37Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29183318')"
+"ID": "477497"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25020
+post_id: "475760"
+post_author: 1
+"ListingKey": "29179982"
+"ListingId": "40793510"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T16:50:04Z"
+"RFModificationTimestamp": "2025-12-11T19:29:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 835.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "251 NORTHFIELD Drive Unit# 415B, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5213246
1 => 43.5104707
]
+"Latitude": 43.5104707
+"Longitude": -80.5213246
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the modern and sought after Blackstone Condos, inspired by Scandinavian living and located in Colonial Acres in North Waterloo! This beautiful open concept 2BR/2BA unit is in exceptional condition with several upgrades.\u{A0} The unit features high ceilings, spacious dining/living area with access to an oversized balcony.\u{A0} The kitchen has been upgraded with quality stainless steel appliances, quartz countertops, subway tile backsplash, tall dishwasher and double undermount stainless steel sink.. Extra upgrades with under the cabinets lights and media charging station. The primary bedroom has a very sizeable walk-in closet and the upgraded all around tiled ensuite.\u{A0} The second bedroom/bathroom can also function as a second suite. There is a lot being offered with the many community amenities, which include a fitness center, a firepit area, outdoor kitchens with BBQs, a co-working space, 1-dedicated underground parking space and a 2,000 sqft event room! The complex also offers bicycle storage, keyless entry, parking garage elevators, close to restaurants and convenience stores, shopping malls, highways, St. Jacobs Farmers Market, entertainment, and so much more! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"AssociationFeeIncludes": array:3 [
0 => "Property Management"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T19:29:10.453555+00:00"
+"Directions": "Northfield Dr E and Bridge St W"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2025-12-11T16:41:05Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-11T16:41:05Z"
+"Stories": "1.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"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/29179982/251-northfield-drive-unit-415b-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2250
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 835
+"OriginalEntryTimestamp": "2025-12-11T16:38:17.64Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:16 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29179982')"
+"ID": "475760"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24968
+post_id: "475761"
+post_author: 1
+"ListingKey": "29180619"
+"ListingId": "40793474"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-11T19:05:43Z"
+"RFModificationTimestamp": "2025-12-11T19:19:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3R5"
+"UnparsedAddress": "455 KINGSCOURT Drive Unit# 3, Waterloo, Ontario N2K3R5"
+"Coordinates": array:2 [
0 => -80.5228476
1 => 43.4940991
]
+"Latitude": 43.4940991
+"Longitude": -80.5228476
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this cozy and spacious 2-bedroom, 2-bath townhome located in a quiet, family-friendly community in the heart of Waterloo’s highly desirable Lexington area. With bright living spaces, modern finishes, and convenient access to schools, parks, shopping, and transit, this home is perfect for young professionals, families, or anyone seeking comfort and convenience. Contact us today to see this rental unit! 2 Spacious Bedrooms (Master has walk-in closet) 2 Bathrooms 5 Appliances Included – Fridge, Stove, Dishwasher, Washer, and Dryer Ensuite Laundry – Enjoy private in-unit laundry Water Softener Included Eat-In Kitchen Large Bedrooms Google Smart thermostat Ample Natural Light – Bright and welcoming atmosphere Private Backyard patio 3 Parking Spots (1 in garage, 2 in driveway - Tandem) Snow & Lawn Maintenance are included ** Rent: $2500.00 Plus Utilities Available December 15th, 2025!! ** ***See sales brochure below below for showing instructions*** (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T19:19:00.425762+00:00"
+"Directions": "Lexington/Davenport"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T18:58:24Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-11T18:58:24Z"
+"Stories": "2.0"
+"StreetName": "KINGSCOURT"
+"StreetNumber": "455"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29180619/455-kingscourt-drive-unit-3-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2500
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 15.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2025-12-11T18:58:24.33Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:22 [
0 => array:13 [ …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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29180619')"
+"ID": "475761"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23646
+post_id: "473700"
+post_author: 1
+"ListingKey": "29177287"
+"ListingId": "40793254"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T17:45:58Z"
+"RFModificationTimestamp": "2025-12-10T19:03:45Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1580.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3S4"
+"UnparsedAddress": "465 WOOLWICH Street N Unit# 17, Waterloo, Ontario N2K3S4"
+"Coordinates": array:2 [
0 => -80.4926409
1 => 43.4994817
]
+"Latitude": 43.4994817
+"Longitude": -80.4926409
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to unit 17 at 465 Woolwich St N., Waterloo. This bright condo townhome is situated close to Kaufman Flats and the Grand River, RIM Park, Kiwanis Park, steps to trails, public transit, shopping, highway 85 and so much more! Step inside the foyer and see the flood of natural light that comes through the main floor. This main floor has a nice sized eating area just off the galley kitchen. The living room is a nice size, with access to the deck and green views from your patio doors. Recently replaced deck. Upstairs you will find 3 bedrooms and a 4 pc bath. The fully finished basement is a bonus space with a rec room w. fireplace. There is a 3 pc bath on this level, laundry, and plenty of storage. This is a very well managed complex which is evident from the well maintained grounds, parking and buildings. Enjoy the private garbage pickup right at your front door! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "450.59"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T19:03:40.375141+00:00"
+"Directions": "University Ave to Woolwich St N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-12-10T17:38:30Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T17:38:30Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "WOOLWICH"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "3195.33"
+"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/29177287/465-woolwich-street-n-unit-17-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1065
+"BelowGradeFinishedArea": 515
+"OriginalEntryTimestamp": "2025-12-10T17:38:30.48Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:21 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29177287')"
+"ID": "473700"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25012
+post_id: "472969"
+post_author: 1
+"ListingKey": "29176263"
+"ListingId": "40793134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T03:35:53Z"
+"RFModificationTimestamp": "2025-12-10T04:33:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 581.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2H1"
+"UnparsedAddress": "251 NORTHFIELD Drive E Unit# 410, Waterloo, Ontario N2V2H1"
+"Coordinates": array:2 [
0 => -80.52132
1 => 43.5105097
]
+"Latitude": 43.5105097
+"Longitude": -80.52132
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience this exquisite one-bedroom condo in Waterloo's vibrant center, where contemporary design meets sophisticated living. The south west facing orientation captures abundant sunlight throughout the day, enhancing the already stunning open-concept space. Entertain with ease in the living area where expansive windows bathe the room in natural light, creating a refreshing and spacious ambiance. The kitchen stands as a culinary masterpiece with its premium stainless steel appliances, elegant quartz countertops, stylish backsplash, and generous workspace that transforms meal preparation into a pleasure. Throughout the unit, high-end finishes and meticulous attention to detail showcase the numerous quality upgrades. The spacious balcony overlooks a serene courtyard, providing the perfect retreat for unwinding and savoring beautiful sunset views thanks to its southwestern exposure. Inside, the bedroom combines practicality with elegance, featuring an impressive walk-in closet that addresses all storage requirements. The luxurious bathroom complements the space with its inviting soaker tub and extensive counter area for added functionality. This residence embodies the perfect blend of luxury, accessibility, and refined style in an ideal Waterloo location. Enjoy proximity to Dining, Conestoga Mall, St. Jacobs Farmers Market, Rim Park and numerous other attractions, making this sophisticated condo the perfect place to call home. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"AssociationFee": "477"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Property Management"
2 => "Heat"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T04:33:32.103850+00:00"
+"Directions": "Northfield Drive and Bridge Street"
+"ExteriorFeatures": array:2 [
0 => "Metal"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2082150"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-12-10T03:29:23Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T03:29:23Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ZR9waXEZVbw"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29176263/251-northfield-drive-e-unit-410-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2180308"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"TotalActualRent": 1950
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 581
+"OriginalEntryTimestamp": "2025-12-10T03:29:23.27Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:25 [ …25]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29176263')"
+"ID": "472969"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25009
+post_id: "467668"
+post_author: 1
+"ListingKey": "29169156"
+"ListingId": "40792688"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T20:45:06Z"
+"RFModificationTimestamp": "2025-12-06T22:44:54Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 584.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G9"
+"UnparsedAddress": "251 E NORTHFIELD Drive E Unit# 504, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.5214174
1 => 43.5105266
]
+"Latitude": 43.5105266
+"Longitude": -80.5214174
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Lief / Lamont model at 251 Northfield Dr E, Waterloo. One bedroom + den in a Sentral building with a practical layout, private balcony, and modern finishes. The den is suitable for a small office or storage. In-suite stacked washer/dryer combo included. Tenants have access to amenities including a gym, party lounge, bike storage room, and a furnished outdoor terrace with BBQs and a gas fire pit for summer use. Unit includes 1 underground parking spot + 1 locker. Internet included. Convenient location with close proximity to St. Jacob’s Farmers Market, Conestoga Mall, LRT, RIM Park, Grey Silo Golf Course, and nearby walking/biking trails, as well as access to everyday necessities. Available for rent February 1, 2026. (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-12-06T22:44:37.045568+00:00"
+"Directions": "Bridge St. W & Northfield Drive E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213806"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2025-12-06T20:38:24Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T20:38:24Z"
+"Stories": "1.0"
+"StreetDirPrefix": "East"
+"StreetDirSuffix": "East"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "251"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29169156/251-e-northfield-drive-e-unit-504-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2000
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 584
+"OriginalEntryTimestamp": "2025-12-06T20:38:24.19Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:18 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29169156')"
+"ID": "467668"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 78
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]