array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29249728/Property?$select=ALL&$top=20&$filter=ListingKey eq 29249728&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29249728/Property?$select=ALL&$top=20&$filter=ListingKey eq 29249728&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "533317"
+post_author: 1
+"ListingKey": "29249728"
+"ListingId": "X12694842"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T16:35:08Z"
+"RFModificationTimestamp": "2026-01-14T16:47:41Z"
+"ListPrice": 688000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4S6"
+"UnparsedAddress": "231A CEDARBRAE AVENUE, Waterloo, Ontario N2L4S6"
+"Coordinates": array:2 [
0 => -80.5499591
1 => 43.4871352
]
+"Latitude": 43.4871352
+"Longitude": -80.5499591
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stunning, fully renovated bungalow 2 minutes from Waterloo University ! steps away from school and park. Featuring 3 bedrooms on main floor and 3 in the lower level. This home offers versatility and excellent income potential. Open concept layout is practical and functional, offering comfortable living for families. fully renovated house, new flooring, updated kitchen, beautifully refreshed washrooms. It's also an ideal spot for commuters, with quick access to both the 401 and the Expressway. Move in ready-Perfect for students, families, or investors looking for a turnkey property in prime location. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Apartment in basement"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T16:47:27.185148+00:00"
+"Directions": "Bearinger rd/ glen forest blvd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1882561"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "36.8 x 100.2 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T16:25:57Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T16:25:57Z"
+"Stories": "1.0"
+"StreetName": "Cedarbrae"
+"StreetNumber": "231A"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3331.88"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1560275307"
"RoomType" => "Living room"
"ListingId" => "X12694842"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29249728"
"RoomLength" => 6.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.63Z"
]
1 => array:11 [
"RoomKey" => "1560275308"
"RoomType" => "Dining room"
"ListingId" => "X12694842"
"RoomLevel" => "Main level"
"RoomWidth" => 2.64
"ListingKey" => "29249728"
"RoomLength" => 2.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.63Z"
]
2 => array:11 [
"RoomKey" => "1560275309"
"RoomType" => "Kitchen"
"ListingId" => "X12694842"
"RoomLevel" => "Main level"
"RoomWidth" => 2.49
"ListingKey" => "29249728"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.64Z"
]
3 => array:11 [
"RoomKey" => "1560275310"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12694842"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "29249728"
"RoomLength" => 4.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.64Z"
]
4 => array:11 [
"RoomKey" => "1560275311"
"RoomType" => "Bedroom 2"
"ListingId" => "X12694842"
"RoomLevel" => "Main level"
"RoomWidth" => 2.49
"ListingKey" => "29249728"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.64Z"
]
5 => array:11 [
"RoomKey" => "1560275312"
"RoomType" => "Bedroom 3"
"ListingId" => "X12694842"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "29249728"
"RoomLength" => 2.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.64Z"
]
6 => array:11 [
"RoomKey" => "1560275313"
"RoomType" => "Bedroom"
"ListingId" => "X12694842"
"RoomLevel" => "Basement"
"RoomWidth" => 2.62
"ListingKey" => "29249728"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.64Z"
]
7 => array:11 [
"RoomKey" => "1560275314"
"RoomType" => "Bedroom 2"
"ListingId" => "X12694842"
"RoomLevel" => "Basement"
"RoomWidth" => 2.31
"ListingKey" => "29249728"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.64Z"
]
8 => array:11 [
"RoomKey" => "1560275315"
"RoomType" => "Bedroom 3"
"ListingId" => "X12694842"
"RoomLevel" => "Basement"
"RoomWidth" => 2.19
"ListingKey" => "29249728"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.64Z"
]
9 => array:11 [
"RoomKey" => "1560275316"
"RoomType" => "Living room"
"ListingId" => "X12694842"
"RoomLevel" => "Basement"
"RoomWidth" => 1.55
"ListingKey" => "29249728"
"RoomLength" => 4.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T16:25:57.64Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29249728/231a-cedarbrae-avenue-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 36.9
+"OriginalEntryTimestamp": "2026-01-14T16:25:57.61Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:13 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404285985"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/c23bdb55ab2b6f26f9f1240c9fe8de8c.webp"
"MediaSize" => 381633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-c23bdb55ab2b6f26f9f1240c9fe8de8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404285995"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/ae87e56144c00240a4f6efeb3a5b385b.webp"
"MediaSize" => 362556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-ae87e56144c00240a4f6efeb3a5b385b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404286009"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/331da44485cbceb00f7da39d642fd043.webp"
"MediaSize" => 82845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-331da44485cbceb00f7da39d642fd043.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404286036"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/b5a0f13bfa9182d7147b561d7e33d4d2.webp"
"MediaSize" => 122502
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-b5a0f13bfa9182d7147b561d7e33d4d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404286048"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/af074e65a78a940083315fe626b49c14.webp"
"MediaSize" => 90139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-af074e65a78a940083315fe626b49c14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404286062"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/d47023f0bd40011c78bb9879741aff11.webp"
"MediaSize" => 165631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-d47023f0bd40011c78bb9879741aff11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404286108"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/8794e01e4513aaa62cfcc179f04cab88.webp"
"MediaSize" => 172680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-8794e01e4513aaa62cfcc179f04cab88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404286125"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/d8d27935f8a2249ad8b2ee5d6164e8e9.webp"
"MediaSize" => 162436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-d8d27935f8a2249ad8b2ee5d6164e8e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404286166"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/a5343d4cff4d7beef24bbb6a5b045a3a.webp"
"MediaSize" => 90243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-a5343d4cff4d7beef24bbb6a5b045a3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404286186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/75541a396bf87ccf91a3d0d43a1b379b.webp"
"MediaSize" => 93587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-75541a396bf87ccf91a3d0d43a1b379b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404286214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/063f2685e486e20bc0d72c4d1ddb5279.webp"
"MediaSize" => 88066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-063f2685e486e20bc0d72c4d1ddb5279.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404286248"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/033442265b5f637b0f5118f5e9d16f87.webp"
"MediaSize" => 102941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-033442265b5f637b0f5118f5e9d16f87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6404286251"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249728/87ff911edea84ab336591eb90be23559.webp"
"MediaSize" => 88834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249728/thumbnail-87ff911edea84ab336591eb90be23559.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12694842"
"ResourceRecordKey" => "29249728"
"ModificationTimestamp" => "2026-01-14T16:25:57.62Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "RAJVIR BAINS"
"MemberFirstName" => "RAJVIR"
"MemberLastName" => "BAINS"
"MemberMlsId" => "9538047"
"OriginatingSystemName" => 26
"MemberKey" => "1882561"
"ModificationTimestamp" => "2025-12-15T06:30:45Z"
"MemberStatus" => "Active"
"OfficeKey" => "289187"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Broker"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "647-268-4800"
"MemberTollFreePhone" => "647-268-4800"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2010-03-03T02:46:00Z"
"MemberNationalAssociationId" => "1207350"
"OfficeNationalAssociationId" => "1375388"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX GOLD REALTY INC."
"OfficePhone" => "905-456-1010"
"OfficeMlsId" => "187103"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "289187"
"ModificationTimestamp" => "2025-06-10T15:18:00Z"
"OfficeAddress1" => "2720 NORTH PARK DRIVE #201"
"OfficeCity" => "BRAMPTON"
"OfficePostalCode" => "L6S0E"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "905-673-8900"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2020-12-30T18:49:00Z"
"OfficeNationalAssociationId" => "1375388"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1051513"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249728')"
+"ID": "533317"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 289187/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289187&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289187/Office?$select=ALL&$top=10&$filter=OfficeKey eq 289187&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25271
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX GOLD REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-456-1010"
+"OfficeMlsId": "187103"
+"ModificationTimestamp": "2025-06-10T15:18:00Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "289187"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2720 NORTH PARK DRIVE #201"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BRAMPTON"
+"OfficePostalCode": "L6S0E"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1375388"
+"OriginalEntryTimestamp": "2020-12-30T18:49:00Z"
+"OfficeFax": "905-673-8900"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1051513"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('289187')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1882561/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1882561&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1882561/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1882561&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25276
+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 29249728" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24915
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29249728/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29249728&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29249728/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29249728&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24897
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29249728 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5499591 43.4871352)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29249728 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5499591 43.4871352)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29249728 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5499591 43.4871352)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29249728 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5499591 43.4871352)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25136
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24852
+post_id: "535219"
+post_author: 1
+"ListingKey": "29250998"
+"ListingId": "X12696136"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T19:26:01Z"
+"RFModificationTimestamp": "2026-01-15T00:09:59Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K5"
+"UnparsedAddress": "1510 - 239 ALBERT STREET, Waterloo, Ontario N2L0K5"
+"Coordinates": array:2 [
0 => -80.53259
1 => 43.474388
]
+"Latitude": 43.474388
+"Longitude": -80.53259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "SUBLEASE From May to End of August. Two Bedroom with one bath* * Water and Internet is already included in the price! Floor garbage disposal, 2 desks, bed, chairs, coffee table, 2 couches. Prime Location - Close to Wilfrid Laurier University, University of Waterloo, and Conestoga College* Albert Street. Fully furnished. Very close to restaurants and stores. Could do early move-in at the end of April if easier for you. Can be be Lease Transfer if you wish to get more occupation time. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T00:09:50.221306+00:00"
+"Directions": "University Avenue W & Albert Street"
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109403"
+"ListOfficeKey": "283413"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T19:18:46Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T19:18:46Z"
+"StreetName": "Albert"
+"StreetNumber": "239"
+"StreetSuffix": "Street"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29250998/1510-239-albert-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "BBBB"
+"GeocodeManualYN": false
+"TotalActualRent": 1800
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-14T19:18:45.98Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:15 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404541476"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/8edffc7f94fd6e34a86d896ef29b37d8.webp"
"MediaSize" => 332397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-8edffc7f94fd6e34a86d896ef29b37d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404541491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/7816689e29dabdf35ce6d27594274781.webp"
"MediaSize" => 96059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-7816689e29dabdf35ce6d27594274781.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404541571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/0b28684b08b2f10382aeb485e6de7ec3.webp"
"MediaSize" => 84439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-0b28684b08b2f10382aeb485e6de7ec3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404541601"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/391ff8ee8dc0e51ba3e0c7a2b744f8e8.webp"
"MediaSize" => 85207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-391ff8ee8dc0e51ba3e0c7a2b744f8e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404541635"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/5b7457fa3faa6a953fb0dec4618d6c98.webp"
"MediaSize" => 89917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-5b7457fa3faa6a953fb0dec4618d6c98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404541644"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/1080cbbb8bcd4021888dfdedf15b401c.webp"
"MediaSize" => 85285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-1080cbbb8bcd4021888dfdedf15b401c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404541681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/59232f743727552cf0f40f2dcea2f1a1.webp"
"MediaSize" => 86810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-59232f743727552cf0f40f2dcea2f1a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404541707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/fc0c720f4c75ab7bd5a6cbd210d91c35.webp"
"MediaSize" => 71390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-fc0c720f4c75ab7bd5a6cbd210d91c35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404541748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/80c7e629558ead5e1ccc189693962660.webp"
"MediaSize" => 90327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-80c7e629558ead5e1ccc189693962660.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404541785"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/95110dc2a4957f5b5741d61a3725e360.webp"
"MediaSize" => 89640
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-95110dc2a4957f5b5741d61a3725e360.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404541829"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/8b895577d43a00af5c0d0aa2f1ca06d5.webp"
"MediaSize" => 76246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-8b895577d43a00af5c0d0aa2f1ca06d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404541855"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/91707b2f0ffaead9469c184764d48ddc.webp"
"MediaSize" => 87151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-91707b2f0ffaead9469c184764d48ddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6404541939"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/95b6adce92778f6bc87c90ca9b93b8fc.webp"
"MediaSize" => 76805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-95b6adce92778f6bc87c90ca9b93b8fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6404541989"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/3f10b9c42bf762a73555dc3ae30003f9.webp"
"MediaSize" => 22400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-3f10b9c42bf762a73555dc3ae30003f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6404541997"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29250998/29eb480430c227af0689edd6383e097b.webp"
"MediaSize" => 320964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29250998/thumbnail-29eb480430c227af0689edd6383e097b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696136"
"ResourceRecordKey" => "29250998"
"ModificationTimestamp" => "2026-01-14T19:18:45.99Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "RITA SEIFIN"
"MemberFirstName" => "RITA"
"MemberLastName" => "SEIFIN"
"MemberMlsId" => "9604539"
"OriginatingSystemName" => 26
"MemberKey" => "2109403"
"ModificationTimestamp" => "2025-12-15T10:04:00Z"
"MemberStatus" => "Active"
"OfficeKey" => "283413"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:2 [ …2]
"MemberOfficePhone" => "647-300-2721"
"MemberSocialMedia" => array:2 [ …2]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2021-02-04T22:42:00Z"
"MemberNationalAssociationId" => "1378246"
"OfficeNationalAssociationId" => "1328652"
]
]
+"Office": array:1 [
0 => array:23 [
"OfficeName" => "ROYAL LEPAGE REAL ESTATE SERVICES LTD."
"OfficePhone" => "905-257-3633"
"OfficeMlsId" => "519013"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "283413"
"ModificationTimestamp" => "2025-05-21T20:02:13Z"
"OfficeAddress1" => "231 OAK PARK #400B"
"OfficeCity" => "OAKVILLE"
"OfficePostalCode" => "L6H7S"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "905-257-3550"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2018-04-27T00:19:00Z"
"OfficeNationalAssociationId" => "1328652"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1128382"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29250998')"
+"ID": "535219"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25123
+post_id: "534841"
+post_author: 1
+"ListingKey": "29252027"
+"ListingId": "X12696974"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:55:43Z"
+"RFModificationTimestamp": "2026-01-14T22:52:10Z"
+"ListPrice": 439999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H7"
+"UnparsedAddress": "2122 - 258B SUNVIEW STREET, Waterloo, Ontario N2L0H7"
+"Coordinates": array:2 [
0 => -80.53335
1 => 43.474556
]
+"Latitude": 43.474556
+"Longitude": -80.53335
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 258B Sunview Street, Unit 2122 - A Bright And Modern 2-Bedroom, 1-Bathroom Corner Suite Offering 705 Sq Ft Of Thoughtfully Designed Living Space In The Heart Of Waterloo's Vibrant University District. This Stylish Unit Features An Open-Concept Layout With Large Windows That Flood The Space With Natural Light, A Contemporary Kitchen With Sleek Cabinetry, And Two Well-Sized Bedrooms Ideal For Students, Professionals, Or Investors. Step Out Onto Your Private Balcony And Enjoy Elevated Views Of The Neighbourhood, Perfect For Relaxing Or Entertaining. Located Just Minutes From The University Of Waterloo, Wilfrid Laurier University, Conestoga College, And Within Walking Distance To The Ion Lrt, Commuting Across The City Is Effortless. Surrounded By Cafés, Restaurants, Shopping, Tech Hubs, And Everyday Amenities, This Location Offers Unbeatable Convenience And Strong Rental Demand. Whether You're Looking For A Smart Investment Or A Place To Call Home, This Unit Delivers Lifestyle, Value, And Long-Term Potential In One Exceptional Package. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Furniture"
6 => "Window Coverings"
]
+"AssociationFee": "427.43"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T22:51:59.693638+00:00"
+"Directions": "ALBERT & UNIVERSITY AVE W."
+"ExteriorFeatures": array:1 [
0 => "Steel"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2049355"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T21:45:59Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:45:59Z"
+"StreetName": "Sunview"
+"StreetNumber": "258B"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3659.64"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1560412646"
"RoomType" => "Living room"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 2.56
"ListingKey" => "29252027"
"RoomLength" => 2.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
1 => array:11 [
"RoomKey" => "1560412647"
"RoomType" => "Kitchen"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 2.56
"ListingKey" => "29252027"
"RoomLength" => 2.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
2 => array:11 [
"RoomKey" => "1560412648"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 5.3
"ListingKey" => "29252027"
"RoomLength" => 2.63
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
3 => array:11 [
"RoomKey" => "1560412649"
"RoomType" => "Bedroom 2"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 3.46
"ListingKey" => "29252027"
"RoomLength" => 2.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
4 => array:11 [
"RoomKey" => "1560412650"
"RoomType" => "Laundry room"
"ListingId" => "X12696974"
"RoomLevel" => "Flat"
"RoomWidth" => 0.0
"ListingKey" => "29252027"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.52Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252027/2122-258b-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1735636"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"CoListOfficeKey": "289187"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-14T21:45:59.5Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:15 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404776151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/f86b9c42ac2b3b4dfe1cab7caa3684b0.webp"
"MediaSize" => 287542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-f86b9c42ac2b3b4dfe1cab7caa3684b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404776183"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/c3a082ea2e253ae8fed6a227912a86d8.webp"
"MediaSize" => 39425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-c3a082ea2e253ae8fed6a227912a86d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404776226"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/07dd8830019ab2b485187bec8394a370.webp"
"MediaSize" => 198903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-07dd8830019ab2b485187bec8394a370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404776301"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/9f54741a8ca2d0ea73ee1e059429cef9.webp"
"MediaSize" => 164597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-9f54741a8ca2d0ea73ee1e059429cef9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404776373"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/869e78b9eca3d143fb68c1f2e9a03585.webp"
"MediaSize" => 235880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-869e78b9eca3d143fb68c1f2e9a03585.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404776416"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/2d7a8574c98c877bcff048410718b454.webp"
"MediaSize" => 225319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-2d7a8574c98c877bcff048410718b454.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404776473"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/cf1a7b5e754c6dc74e2a28e5bb0f7cd8.webp"
"MediaSize" => 275006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-cf1a7b5e754c6dc74e2a28e5bb0f7cd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404776517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/4b71ac09f99bfbbf7a54f71d41bd61b6.webp"
"MediaSize" => 139315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-4b71ac09f99bfbbf7a54f71d41bd61b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404776524"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/09897dae8182b8b9865d3433ac8c8e8d.webp"
"MediaSize" => 251317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-09897dae8182b8b9865d3433ac8c8e8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404776626"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/4ed333e72d814e5e27d8f01ba1c29a31.webp"
"MediaSize" => 250735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-4ed333e72d814e5e27d8f01ba1c29a31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404776670"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/36c4b050e4c7ca1bed699a4b7ec81c49.webp"
"MediaSize" => 234548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-36c4b050e4c7ca1bed699a4b7ec81c49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404776733"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/2bbab1600178b6bdf5cdcfffb491da14.webp"
"MediaSize" => 207600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-2bbab1600178b6bdf5cdcfffb491da14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6404776795"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/546812e21ab45e8bb79c3a538f81b83d.webp"
"MediaSize" => 262528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-546812e21ab45e8bb79c3a538f81b83d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6404776842"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/a92b4e4fef3e1f9ebd031b8779e2b98e.webp"
"MediaSize" => 252383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-a92b4e4fef3e1f9ebd031b8779e2b98e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6404776864"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252027/5b0437d0d08536fa7b22ece8e9332c56.webp"
"MediaSize" => 115494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252027/thumbnail-5b0437d0d08536fa7b22ece8e9332c56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696974"
"ResourceRecordKey" => "29252027"
"ModificationTimestamp" => "2026-01-14T21:45:59.5Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "HARMAN SAINI"
"MemberFirstName" => "HARMAN"
"MemberLastName" => "SAINI"
"MemberMlsId" => "9585542"
"OriginatingSystemName" => 26
"MemberKey" => "2049355"
"ModificationTimestamp" => "2025-12-15T10:18:33Z"
"MemberStatus" => "Active"
"OfficeKey" => "289187"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:1 [ …1]
"MemberOfficePhone" => "905-456-1010"
"MemberSocialMedia" => array:1 [ …1]
"MemberTollFreePhone" => "416-317-4900"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2018-03-02T01:23:00Z"
"MemberNationalAssociationId" => "1324736"
"OfficeNationalAssociationId" => "1375388"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX GOLD REALTY INC."
"OfficePhone" => "905-456-1010"
"OfficeMlsId" => "187103"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "289187"
"ModificationTimestamp" => "2025-06-10T15:18:00Z"
"OfficeAddress1" => "2720 NORTH PARK DRIVE #201"
"OfficeCity" => "BRAMPTON"
"OfficePostalCode" => "L6S0E"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "905-673-8900"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2020-12-30T18:49:00Z"
"OfficeNationalAssociationId" => "1375388"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1051513"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252027')"
+"ID": "534841"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24853
+post_id: "534789"
+post_author: 1
+"ListingKey": "29252033"
+"ListingId": "X12697078"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T22:31:06Z"
+"RFModificationTimestamp": "2026-01-14T22:35:02Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3T7"
+"UnparsedAddress": "108 - 253 ALBERT STREET, Waterloo, Ontario N2L3T7"
+"Coordinates": array:2 [
0 => -80.533259
1 => 43.47544
]
+"Latitude": 43.47544
+"Longitude": -80.533259
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to the Ivy Towns. One of the best off-campus condo's in Uptown Waterloo. Less than 5 minutes walk to the University of Waterloo and Wilfrid Laurier. Shopping, restaurants and many other offerings are within easy walking distance as well. These modern and beautifully appointed condo's feature vaulted ceilings, huge windows and an open-concept living area. With two spacious bedrooms, two bathrooms, a private terrace and in-suite laundry along with private parking, this unit has everything needed to call home. A beautiful rooftop garden and terrace is an added bonus space for residents as well. Recently leased for $2,600 monthly, this is a great investment opportunity or a wonderful place to call home for yourself! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Oven"
3 => "Dryer"
4 => "Furniture"
5 => "Window Coverings"
6 => "Water Heater"
]
+"AssociationFee": "779.02"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T22:34:42.607234+00:00"
+"Directions": "Albert St & Columbia St W"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1998221"
+"ListOfficeKey": "50441"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T21:46:00Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T22:17:35Z"
+"StreetName": "Albert"
+"StreetNumber": "253"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4614"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1560424669"
"RoomType" => "Living room"
"ListingId" => "X12697078"
"RoomLevel" => "Main level"
"RoomWidth" => 5.08
"ListingKey" => "29252033"
"RoomLength" => 5.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T22:17:35.97Z"
]
1 => array:11 [
"RoomKey" => "1560424670"
"RoomType" => "Kitchen"
"ListingId" => "X12697078"
"RoomLevel" => "Main level"
"RoomWidth" => 5.08
"ListingKey" => "29252033"
"RoomLength" => 5.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T22:17:35.97Z"
]
2 => array:11 [
"RoomKey" => "1560424671"
"RoomType" => "Bathroom"
"ListingId" => "X12697078"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29252033"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T22:17:35.97Z"
]
3 => array:11 [
"RoomKey" => "1560424672"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12697078"
"RoomLevel" => "Main level"
"RoomWidth" => 3.86
"ListingKey" => "29252033"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T22:17:35.97Z"
]
4 => array:11 [
"RoomKey" => "1560424673"
"RoomType" => "Bedroom 2"
"ListingId" => "X12697078"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29252033"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T22:17:35.97Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252033/108-253-albert-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-01-14T21:46:00.11Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:9 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404826961"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252033/41390a587a884d60f36dd79702568ce5.webp"
"MediaSize" => 120139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252033/thumbnail-41390a587a884d60f36dd79702568ce5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12697078"
"ResourceRecordKey" => "29252033"
"ModificationTimestamp" => "2026-01-14T21:46:00.12Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404827037"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252033/d0e6884adc1b4509256f605edec5e302.webp"
"MediaSize" => 94692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252033/thumbnail-d0e6884adc1b4509256f605edec5e302.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697078"
"ResourceRecordKey" => "29252033"
"ModificationTimestamp" => "2026-01-14T21:46:00.12Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404827079"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252033/64cf0b83cf2484f2e4bb121798e44e76.webp"
"MediaSize" => 127663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252033/thumbnail-64cf0b83cf2484f2e4bb121798e44e76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697078"
"ResourceRecordKey" => "29252033"
"ModificationTimestamp" => "2026-01-14T21:46:00.12Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404827162"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252033/c5975b1fcc6ea018a38d1aed56a3b5b8.webp"
"MediaSize" => 94448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252033/thumbnail-c5975b1fcc6ea018a38d1aed56a3b5b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697078"
"ResourceRecordKey" => "29252033"
"ModificationTimestamp" => "2026-01-14T21:46:00.12Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404827266"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252033/7be3954ccc3e013aada1ae171250b617.webp"
"MediaSize" => 81736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252033/thumbnail-7be3954ccc3e013aada1ae171250b617.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697078"
"ResourceRecordKey" => "29252033"
"ModificationTimestamp" => "2026-01-14T21:46:00.12Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404827282"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252033/9411f745913eeb04bef3fa1ce497f6ae.webp"
"MediaSize" => 83032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252033/thumbnail-9411f745913eeb04bef3fa1ce497f6ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697078"
"ResourceRecordKey" => "29252033"
"ModificationTimestamp" => "2026-01-14T21:46:00.12Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404827374"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252033/aeb0e678da9a39c8aec732242e402355.webp"
"MediaSize" => 88225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252033/thumbnail-aeb0e678da9a39c8aec732242e402355.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697078"
"ResourceRecordKey" => "29252033"
"ModificationTimestamp" => "2026-01-14T21:46:00.12Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404827435"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252033/6e3da6c5b1f2121efaa00b4791bb92ae.webp"
"MediaSize" => 96360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252033/thumbnail-6e3da6c5b1f2121efaa00b4791bb92ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697078"
"ResourceRecordKey" => "29252033"
"ModificationTimestamp" => "2026-01-14T21:46:00.12Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404827548"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252033/acfeead6050209b561be5b5e565c5e99.webp"
"MediaSize" => 95998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252033/thumbnail-acfeead6050209b561be5b5e565c5e99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697078"
"ResourceRecordKey" => "29252033"
"ModificationTimestamp" => "2026-01-14T21:46:00.12Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "GABRIEL DUNBAR MARTIN"
"MemberFirstName" => "GABRIEL DUNBAR"
"MemberLastName" => "MARTIN"
"MemberMlsId" => "9566572"
"OriginatingSystemName" => 26
"MemberKey" => "1998221"
"ModificationTimestamp" => "2025-12-15T05:52:22Z"
"MemberStatus" => "Active"
"OfficeKey" => "50441"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "416-785-1500"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2015-10-03T00:37:00Z"
"MemberNationalAssociationId" => "1280647"
"OfficeNationalAssociationId" => "1112107"
]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252033')"
+"ID": "534789"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24789
+post_id: "534341"
+post_author: 1
+"ListingKey": "29251167"
+"ListingId": "X12696336"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T00:25:24Z"
+"RFModificationTimestamp": "2026-01-15T00:28:12Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4L4"
+"UnparsedAddress": "520 TEAKWOOD DRIVE, Waterloo, Ontario N2L4L4"
+"Coordinates": array:2 [
0 => -80.5530687
1 => 43.4843178
]
+"Latitude": 43.4843178
+"Longitude": -80.5530687
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "On a prime corner lot in the street of Lakeshore Village, you will find 520 Teakwood Drive. Sitting on an over-sized 65 by 122+ foot lot, this home offers plenty of outdoor space to enjoy with two large side yards and a private back deck. The interior is filled with natural light, creating a warm and inviting atmosphere across more than 2,000 square feet of total living space. Meticulously maintained, the main level features three bright bedrooms, including one with a seamless walk-out to the deck. Throughout this level, the recently refinished original hardwood floors add a touch of timeless character and warmth to every room. The kitchen has been thoughtfully updated with a larger island, newer appliances, modern countertops, and a stylish backsplash. Downstairs, the space continues to impress with a large family room and two additional bedrooms featuring egress windows. This lower level also includes a kitchenette new in 2018, a full bathroom, and laundry facilities. This home has been extensively renovated and is truly ready for its next owners. Much of the basement was redone in 2024, which included the installation of a new furnace and sump pump. The roof and siding were also redone this past fall, along with the completion of a new storage shed. This home is completely move-in ready. With two expansive side yards and a private back deck, this property is a dream for gardeners and families alike. Whether you're hosting a summer BBQ or enjoying a quiet morning coffee surrounded by mature trees, the outdoor space provides endless options for relaxation and play. Get in before the summer so you can relax and enjoy all that 520 Teakwood has to offer! (id:62650)"
+"Appliances": array:4 [
0 => "All"
1 => "Water meter"
2 => "Water softener"
3 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T20:46:57.129329+00:00"
+"Directions": "Glen forrest blvd and Bearinger Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1911639"
+"ListOfficeKey": "50472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Carpet Free"
2 => "Sump Pump"
]
+"LotSizeDimensions": "65 x 122 FT ; longest 130 feet as sidewalk curves"
+"ParkingFeatures": array:3 [
0 => "Carport"
1 => "Covered"
2 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T19:46:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T00:13:48Z"
+"Stories": "1.0"
+"StreetName": "Teakwood"
+"StreetNumber": "520"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4082.92"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://sites.odyssey3d.ca/mls/224770381"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1560467429"
"RoomType" => "Living room"
"ListingId" => "X12696336"
"RoomLevel" => "Main level"
"RoomWidth" => 3.4
"ListingKey" => "29251167"
"RoomLength" => 4.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:48.26Z"
]
1 => array:11 [
"RoomKey" => "1560467430"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12696336"
"RoomLevel" => "Main level"
"RoomWidth" => 4.29
"ListingKey" => "29251167"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:48.26Z"
]
2 => array:11 [
"RoomKey" => "1560467431"
"RoomType" => "Bedroom"
"ListingId" => "X12696336"
"RoomLevel" => "Main level"
"RoomWidth" => 2.72
"ListingKey" => "29251167"
"RoomLength" => 3.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:48.27Z"
]
3 => array:11 [
"RoomKey" => "1560467432"
"RoomType" => "Bedroom"
"ListingId" => "X12696336"
"RoomLevel" => "Main level"
"RoomWidth" => 3.23
"ListingKey" => "29251167"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:48.28Z"
]
4 => array:11 [
"RoomKey" => "1560467433"
"RoomType" => "Kitchen"
"ListingId" => "X12696336"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "29251167"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:48.29Z"
]
5 => array:11 [
"RoomKey" => "1560467434"
"RoomType" => "Family room"
"ListingId" => "X12696336"
"RoomLevel" => "Basement"
"RoomWidth" => 5.16
"ListingKey" => "29251167"
"RoomLength" => 5.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:48.3Z"
]
6 => array:11 [
"RoomKey" => "1560467435"
"RoomType" => "Bedroom"
"ListingId" => "X12696336"
"RoomLevel" => "Basement"
"RoomWidth" => 3.3
"ListingKey" => "29251167"
"RoomLength" => 3.81
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:48.3Z"
]
7 => array:11 [
"RoomKey" => "1560467436"
"RoomType" => "Bedroom"
"ListingId" => "X12696336"
"RoomLevel" => "Basement"
"RoomWidth" => 3.33
"ListingKey" => "29251167"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:48.31Z"
]
8 => array:11 [
"RoomKey" => "1560467437"
"RoomType" => "Kitchen"
"ListingId" => "X12696336"
"RoomLevel" => "Basement"
"RoomWidth" => 2.82
"ListingKey" => "29251167"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:48.32Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29251167/520-teakwood-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.0
+"OriginalEntryTimestamp": "2026-01-14T19:46:22.54Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404673937"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251167/da5cdf9d7da0f2a061d6cde881587e46.webp"
"MediaSize" => 329250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251167/thumbnail-da5cdf9d7da0f2a061d6cde881587e46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696336"
"ResourceRecordKey" => "29251167"
"ModificationTimestamp" => "2026-01-14T19:46:22.55Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404674005"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251167/6e8698a79fc16b51f30892e300413478.webp"
"MediaSize" => 171446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251167/thumbnail-6e8698a79fc16b51f30892e300413478.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696336"
"ResourceRecordKey" => "29251167"
"ModificationTimestamp" => "2026-01-14T19:46:22.55Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404674077"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251167/938027107b846988375c21a316a4e63a.webp"
"MediaSize" => 146741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251167/thumbnail-938027107b846988375c21a316a4e63a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696336"
…2
]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251167')"
+"ID": "534341"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24747
+post_id: "532803"
+post_author: 1
+"ListingKey": "29248584"
+"ListingId": "X12693854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T03:21:01Z"
+"RFModificationTimestamp": "2026-01-14T04:36:11Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4P3"
+"UnparsedAddress": "MAIN - 543 GLENDENE CRESCENT, Waterloo, Ontario N2L4P3"
+"Coordinates": array:2 [
0 => -80.5602635
1 => 43.4911066
]
+"Latitude": 43.4911066
+"Longitude": -80.5602635
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 543 Glendene Crescent - a meticulously maintained gem that effortlessly combines timeless charm with modern updates. This inviting three-bedroom, two-bathroom brick bungalow demands your immediate attention, showcasing a perfect blend of functionality and style. Step inside to discover a wealth of contemporary upgrades, including new windows (2012), doors, roof, and aluminum soffits and fascia, ensuring both aesthetic appeal and structural integrity. The living room and hallway boast wide plank oak hardwood, adding warmth and character to the home. The eat-in kitchen is a culinary delight with extensive oak cabinetry, providing ample storage space for all your kitchen essentials. LOCATED in the sought-after Lakeshore neighborhood in Waterloo. close to all amenities. students are welcome. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T04:35:47.201823+00:00"
+"Directions": "Glendene Cres/ Glen Forest"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2082451"
+"ListOfficeKey": "279248"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T03:11:51Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T03:11:51Z"
+"Stories": "1.0"
+"StreetName": "Glendene"
+"StreetNumber": "543"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29248584/main-543-glendene-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2350
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-14T03:11:51.13Z"
+"MapCoordinateVerifiedYN": false
+"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:23 [ …23]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29248584')"
+"ID": "532803"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24856
+post_id: "529027"
+post_author: 1
+"ListingKey": "29242200"
+"ListingId": "X12688386"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-12T20:50:44Z"
+"RFModificationTimestamp": "2026-01-12T23:17:31Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W9"
+"UnparsedAddress": "N206 - 330 PHILLIP STREET, Waterloo, Ontario N2L3W9"
+"Coordinates": array:2 [
0 => -80.538971
1 => 43.476309
]
+"Latitude": 43.476309
+"Longitude": -80.538971
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Icon 330 modern 1 Bedroom + Den condominium located directly across from the University of Waterloo and Wilfrid Laurier University. Features an urban, furnished layout ideal for students, young professionals, and investors. Enjoy premium amenities including a fitness centre, yoga studio, sauna, study lounges, games room, basketball court, rooftop patio, and Wi-Fi throughout the building. Equipped with granite countertops, stainless steel fridge, stove, dishwasher, microwave, and in-suite washer and dryer. New washer and over-the-range microwave. 24/7 security and excellent property management make this an outstanding investment opportunity for premium student living. Currently leased for $2100/month, vacant possession can be provided. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Range"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "303.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T23:17:10.717650+00:00"
+"Directions": "Columbia St W/ Phillip Street"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2004054"
+"ListOfficeKey": "254197"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-12T20:41:43Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-12T20:41:43Z"
+"StreetName": "Phillip"
+"StreetNumber": "330"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3316.35"
+"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/29242200/n206-330-phillip-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1755798"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Management"
+"CoListOfficeKey": "254197"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-01-12T20:41:43.25Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:15 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29242200')"
+"ID": "529027"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "527912"
+post_author: 1
+"ListingKey": "29240097"
+"ListingId": "40797759"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-12T16:30:35Z"
+"RFModificationTimestamp": "2026-01-12T19:46:17Z"
+"ListPrice": 315000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 450.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K2"
+"UnparsedAddress": "257 HEMLOCK Street Unit# 217, Waterloo, Ontario N2L0K2"
+"Coordinates": array:2 [
0 => -80.5321789
1 => 43.4757884
]
+"Latitude": 43.4757884
+"Longitude": -80.5321789
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to contemporary condo living in the heart of Waterloo—vacant and ready for you to move right in. Just steps from the University of Waterloo, Wilfrid Laurier University, shopping, and dining, this unbeatable location offers convenience at every turn. Inside, the open-concept layout is designed for modern comfort, featuring a sleek kitchen with stainless steel appliances, granite countertops, and plenty of cabinet space. Floor-to-ceiling windows fill the home with natural light, creating a bright and inviting atmosphere. Enjoy a morning coffee or unwind at the end of the day on the large private balcony, where you can take in vibrant city views. The unit comes fully furnished and includes in-suite laundry, making the move-in process effortless. Residents also have access to exceptional building amenities, including a fitness center, study area, lounge, and a rooftop terrace. Whether you're looking for a stylish place to call home or a smart investment opportunity, this condo is an excellent choice. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "430.48"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T19:45:43.587908+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1688209"
+"ListOfficeKey": "296447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-12T16:18:28Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-12T16:18:28Z"
+"Stories": "1.0"
+"StreetName": "HEMLOCK"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2699"
+"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/29240097/257-hemlock-street-unit-217-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2099327"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "283397"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RN6"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 450
+"OriginalEntryTimestamp": "2026-01-12T16:18:28.84Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:25 [ …25]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29240097')"
+"ID": "527912"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24805
+post_id: "527230"
+post_author: 1
+"ListingKey": "29240774"
+"ListingId": "X12687042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-12T17:50:23Z"
+"RFModificationTimestamp": "2026-01-12T18:03:25Z"
+"ListPrice": 315000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K2"
+"UnparsedAddress": "217 - 257 HEMLOCK STREET, Waterloo, Ontario N2L0K2"
+"Coordinates": array:2 [
0 => -80.532334
1 => 43.475918
]
+"Latitude": 43.475918
+"Longitude": -80.532334
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to contemporary condo living in the heart of Waterloo-vacant and ready for you to move right in. Just steps from the University of Waterloo, Wilfrid Laurier University, shopping, and dining, this unbeatable location offers convenience at every turn. Inside, the open-concept layout is designed for modern comfort, featuring a sleek kitchen with stainless steel appliances, granite countertops, and plenty of cabinet space. Floor-to-ceiling windows fill the home with natural light, creating a bright and inviting atmosphere. Enjoy a morning coffee or unwind at the end of the day on the large private balcony, where you can take in vibrant city views. The unit comes fully furnished and includes in-suite laundry, making the move-in process effortless. Residents also have access to exceptional building amenities, including a fitness center, study area, lounge, and a rooftop terrace. Whether you're looking for a stylish place to call home or a smart investment opportunity, this condo is an excellent choice. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Furniture"
]
+"AssociationFee": "430.48"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-12T18:03:07.763631+00:00"
+"Directions": "Cross Streets: University and Hemlock. ** Directions: University Ave to Hemlock."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211703"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-12T17:43:20Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-12T17:43:19Z"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2699"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29240774/217-257-hemlock-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 499
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-12T17:43:19.91Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:28 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29240774')"
+"ID": "527230"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24812
+post_id: "526414"
+post_author: 1
+"ListingKey": "29238580"
+"ListingId": "X12684904"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-11T19:50:28Z"
+"RFModificationTimestamp": "2026-01-11T22:48:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "F504 - 275 LARCH STREET, Waterloo, Ontario N2L3R2"
+"Coordinates": array:2 [
0 => -80.5313421
1 => 43.4771648
]
+"Latitude": 43.4771648
+"Longitude": -80.5313421
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious and Fully Furnished Student/Younge Professional Condo - Spacious Living Area and Dining, Ensuite Bathroom in Primary Bedroom, 5Appliances (Fridge, Stove, Dishwasher, Washer, Dryer), Fully Furnished (Common Areas and Bedrooms), Couch, Dining Table, Chairs,Bed/Mattress, Desk and Chair, Plenty of Natural Light Throughout Large Balcony With Nice Unblocked View. Walking Distance to Conestoga,Laurier and University of Waterloo.High speed internet included and tenant to setup his account directly with rogers (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Furniture"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-11T22:48:19.749609+00:00"
+"Directions": "University Ave & Hazel St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533818"
+"ListOfficeKey": "50115"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-11T19:41:24Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-11T19:41:24Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29238580/f504-275-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 2000
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-11T19:41:24.19Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:9 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29238580')"
+"ID": "526414"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 161
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]