array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29228873/Property?$select=ALL&$top=20&$filter=ListingKey eq 29228873&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29228873/Property?$select=ALL&$top=20&$filter=ListingKey eq 29228873&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23467
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23469
+post_id: "519412"
+post_author: 1
+"ListingKey": "29228873"
+"ListingId": "40796231"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T16:10:29Z"
+"RFModificationTimestamp": "2026-01-08T16:48:31Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 699.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0L1"
+"UnparsedAddress": "333 ALBERT Street Unit# 718, Waterloo, Ontario N2L0L1"
+"Coordinates": array:2 [
0 => -80.5350127
1 => 43.4780225
]
+"Latitude": 43.4780225
+"Longitude": -80.5350127
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "for both comfort and functionality. This brand-new, never-lived-in residence offers a smart, efficient layout ideal for professionals, graduate students, or anyone seeking upscale urban living. The generous bedroom includes a walk-in closet, while the flexible dining area can easily function as a formal dining space, home office, or creative studio. The open-concept living and dining area is filled with natural light and provides an inviting space for everyday living or entertaining guests. The contemporary kitchen is finished with stainless steel appliances, modern cabinetry, and sleek countertops, creating a stylish yet practical cooking environment. With two full bathrooms, the suite offers exceptional convenience and privacy-rarely found in one-bedroom layouts. Rough-ins for in-suite laundry are already in place, and the unit is offered furnished, allowing for a seamless, turnkey move-in experience. Residents of 333 Albert Street enjoy a secure building with controlled entry, bike friendly storage, and over 4,000 sq. ft. of on-site commercial space offering vibrant amenities. Standout features include a second-level rooftop terrace and a modern resident lounge complete with a ping-pong area, perfect for socializing or unwinding. Limited underground and surface parking is available for a monthly fee. Ideally located in the heart of Waterloo's university district, this prime address places you just steps from Wilfrid Laurier University, minutes from the University of Waterloo, and within walking distance to Uptown Waterloo's shopping, dining, entertainment, transit, and green spaces. Be the first to call this exceptional two-bath, 699 sq. ft. suite home-available September 2026 (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
]
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T16:48:22.554024+00:00"
+"Directions": "ALBERT ST AND COLUMBIA ST W"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235496"
+"ListOfficeKey": "76849"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Visual exposure"
1 => "Balcony"
2 => "Laundry- Coin operated"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-01-08T16:01:12Z"
+"PhotosCount": 10
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T16:01:12Z"
+"Stories": "1.0"
+"StreetName": "ALBERT"
+"StreetNumber": "333"
+"StreetSuffix": "Street"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1557930501"
"RoomType" => "3pc Bathroom"
"ListingId" => "40796231"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228873"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:12.52Z"
]
1 => array:11 [
"RoomKey" => "1557930502"
"RoomType" => "Den"
"ListingId" => "40796231"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228873"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:12.52Z"
]
2 => array:11 [
"RoomKey" => "1557930503"
"RoomType" => "Kitchen"
"ListingId" => "40796231"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228873"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:12.52Z"
]
3 => array:11 [
"RoomKey" => "1557930504"
"RoomType" => "Living room"
"ListingId" => "40796231"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228873"
"RoomLength" => null
"RoomDimensions" => "18'8'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:12.53Z"
]
4 => array:11 [
"RoomKey" => "1557930505"
"RoomType" => "Dinette"
"ListingId" => "40796231"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228873"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:12.53Z"
]
5 => array:11 [
"RoomKey" => "1557930506"
"RoomType" => "3pc Bathroom"
"ListingId" => "40796231"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228873"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:12.53Z"
]
6 => array:11 [
"RoomKey" => "1557930507"
"RoomType" => "Bedroom"
"ListingId" => "40796231"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228873"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:12.53Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29228873/333-albert-street-unit-718-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2370
+"ZoningDescription": "RN-6"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 699
+"OriginalEntryTimestamp": "2026-01-08T16:01:12.49Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:10 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6396703724"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/8b1caeac1fb5cb1a58b47d1b6284d251.webp"
"MediaSize" => 44101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-8b1caeac1fb5cb1a58b47d1b6284d251.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, a breakfast bar, modern cabinets, light wood-type flooring, and a peninsula"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6396703738"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/2e94d552d86e5232b27253fa6d3e8cb2.webp"
"MediaSize" => 51382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-2e94d552d86e5232b27253fa6d3e8cb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with light wood-style floors and a desk"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6396703773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/1f01c0213beb5bff15e6ddee5ea282de.webp"
"MediaSize" => 86216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-1f01c0213beb5bff15e6ddee5ea282de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of apartment building / complex with a view of city"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6396703814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/5072ef3bc354f4cb9376edf269e00ede.webp"
"MediaSize" => 42276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-5072ef3bc354f4cb9376edf269e00ede.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood finished floors and a barn door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6396703838"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/f760cd60b4bbe27912c3aeb59cf714c5.webp"
"MediaSize" => 74847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-f760cd60b4bbe27912c3aeb59cf714c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of apartment building / complex"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6396703863"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/7e45d7fb91d1e747163f29d7c6e6809e.webp"
"MediaSize" => 54217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-7e45d7fb91d1e747163f29d7c6e6809e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with modern cabinets, backsplash, light countertops, and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6396703941"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/abaf394c2641e21e52ee1d1a17b2c5e6.webp"
"MediaSize" => 51607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-abaf394c2641e21e52ee1d1a17b2c5e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6396703984"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/96f065a1678bb18d29588b45a4772888.webp"
"MediaSize" => 53363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-96f065a1678bb18d29588b45a4772888.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office with light wood-style floors and a raised ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6396704044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/125fa30ddde238aad3d3c51595dc6db7.webp"
"MediaSize" => 52137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-125fa30ddde238aad3d3c51595dc6db7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring light wood-style floors"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6396704159"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228873/8bc755b1c6cb9361b4b710d2f694b483.webp"
"MediaSize" => 55756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228873/thumbnail-8bc755b1c6cb9361b4b710d2f694b483.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-style floors and a desk"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796231"
"ResourceRecordKey" => "29228873"
"ModificationTimestamp" => "2026-01-08T16:01:12.49Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "Khaled Khalil"
"MemberFirstName" => "Khaled"
"MemberLastName" => "Khalil"
"MemberMlsId" => "WR60277"
"OriginatingSystemName" => 26
"MemberKey" => "2235496"
"ModificationTimestamp" => "2025-10-28T23:38:10Z"
"MemberStatus" => "Active"
"OfficeKey" => "76849"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"JobTitle" => "Salesperson"
"MemberCity" => "KITCHENER"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-570-4663"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2024-12-09T14:14:00Z"
"MemberNationalAssociationId" => "1473399"
"OfficeNationalAssociationId" => "1004401"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "CENTURY 21 HERITAGE HOUSE LTD."
"OfficePhone" => "519-570-4663"
"OfficeMlsId" => "KW217"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "76849"
"ModificationTimestamp" => "2025-08-19T15:50:12Z"
"OfficeAddress1" => "515 RIVERBEND DR., UNIT 103"
"OfficeCity" => "KITCHENER"
"OfficePostalCode" => "N2K3S"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1004401"
"FranchiseNationalAssociationId" => "1205554"
"OfficeBrokerNationalAssociationId" => "1336243"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29228873')"
+"ID": "519412"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 76849/Office?$select=ALL&$top=10&$filter=OfficeKey eq 76849&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 76849/Office?$select=ALL&$top=10&$filter=OfficeKey eq 76849&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25251
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25253
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CENTURY 21 HERITAGE HOUSE LTD."
+"OfficeEmail": null
+"OfficePhone": "519-570-4663"
+"OfficeMlsId": "KW217"
+"ModificationTimestamp": "2025-08-19T15:50:12Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "76849"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "515 RIVERBEND DR., UNIT 103"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KITCHENER"
+"OfficePostalCode": "N2K3S"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1004401"
+"OriginalEntryTimestamp": null
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "279161"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "76849"
"SocialMediaUrlOrId" => "http://heritagehouse.c21.ca/"
"ModificationTimestamp" => "2025-08-19T15:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1205554"
+"OfficeBrokerNationalAssociationId": "1336243"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('76849')"
}
]
+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 2235496/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2235496&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2235496/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2235496&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25256
+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 29228873" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24898
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29228873/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29228873&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29228873/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29228873&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24878
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29228873 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5350127 43.4780225)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29228873 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5350127 43.4780225)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29228873 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5350127 43.4780225)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29228873 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5350127 43.4780225)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24784
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24833
+post_id: "525186"
+post_author: 1
+"ListingKey": "29237381"
+"ListingId": "X12683718"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T17:50:23Z"
+"RFModificationTimestamp": "2026-01-10T18:43:32Z"
+"ListPrice": 589900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2H3"
+"UnparsedAddress": "59 LAUREL STREET, Waterloo, Ontario N2J2H3"
+"Coordinates": array:2 [
0 => -80.5167218
1 => 43.4679284
]
+"Latitude": 43.4679284
+"Longitude": -80.5167218
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A charming home tucked in the heart of Waterloo, where vibrant Uptown energy meets quiet, family-friendly comfort. This rare, grandfathered, 5bedroom licensed gem is more than just a house, it's a canvas for your next chapter, whether you're raising a family, investing in a thriving student rental market, or seeking a flexible space to make your own. Three bright bedrooms upstairs share a full bathroom, while a spacious main-floor bedroom and another in the basement (with its own full bath) offer endless possibilities. Need a home office? A guest suite? A student rental? Convert into bigger single family home? This layout adapts to you. Outside, a good-sized backyard invites summer barbecues, playtime, or simply soaking in the fresh air. And the location? Unbeatable. Just steps from Weber and King Street, you're a quick 10-minute ride to the University of Waterloo or Laurier via public transit. Uptown's restaurants, shops, and nightlife are practically your neighbours, with grocery stores and daily conveniences right around the corner. Ready for move-in, this home comes empty on closing, giving you a blank slate to create your vision-whether it's a forever home or a smart investment near top universities. Don't let this one pass you by. Your Waterloo story starts here. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T18:43:07.396108+00:00"
+"Directions": "Moore & Laurel"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1907911"
+"ListOfficeKey": "194325"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "33.9 x 93.3 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-10T17:41:11Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T17:41:10Z"
+"Stories": "2.0"
+"StreetName": "Laurel"
+"StreetNumber": "59"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4199"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1558671987"
"RoomType" => "Living room"
"ListingId" => "X12683718"
"RoomLevel" => "Main level"
"RoomWidth" => 3.4
"ListingKey" => "29237381"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.99Z"
]
1 => array:11 [
"RoomKey" => "1558671988"
"RoomType" => "Kitchen"
"ListingId" => "X12683718"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29237381"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.99Z"
]
2 => array:11 [
"RoomKey" => "1558671989"
"RoomType" => "Bedroom"
"ListingId" => "X12683718"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29237381"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.99Z"
]
3 => array:11 [
"RoomKey" => "1558671990"
"RoomType" => "Bedroom"
"ListingId" => "X12683718"
"RoomLevel" => "Second level"
"RoomWidth" => 3.17
"ListingKey" => "29237381"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.99Z"
]
4 => array:11 [
"RoomKey" => "1558671991"
"RoomType" => "Bedroom"
"ListingId" => "X12683718"
"RoomLevel" => "Second level"
"RoomWidth" => 2.77
"ListingKey" => "29237381"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.99Z"
]
5 => array:11 [
"RoomKey" => "1558671992"
"RoomType" => "Bedroom"
"ListingId" => "X12683718"
"RoomLevel" => "Second level"
"RoomWidth" => 2.16
"ListingKey" => "29237381"
"RoomLength" => 2.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.99Z"
]
6 => array:11 [
"RoomKey" => "1558671993"
"RoomType" => "Bedroom"
"ListingId" => "X12683718"
"RoomLevel" => "Basement"
"RoomWidth" => 2.9
"ListingKey" => "29237381"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T17:41:10.99Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29237381/59-laurel-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 33.1
+"OriginalEntryTimestamp": "2026-01-10T17:41:10.96Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:28 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6399198326"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/e78004859967e00ef275e4c6f4d9240e.webp"
"MediaSize" => 421873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-e78004859967e00ef275e4c6f4d9240e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6399198332"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/d4741b30bb7c98bd04909bddfbe52ded.webp"
"MediaSize" => 449285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-d4741b30bb7c98bd04909bddfbe52ded.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6399198334"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/b869695834b99470aea168441f6cf716.webp"
"MediaSize" => 200696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-b869695834b99470aea168441f6cf716.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6399198343"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/5000980f086089cdc439405b3ee13c28.webp"
"MediaSize" => 209568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-5000980f086089cdc439405b3ee13c28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6399198357"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/12ed1c4dd6bdaaf68f4f192796ad613f.webp"
"MediaSize" => 196884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-12ed1c4dd6bdaaf68f4f192796ad613f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6399198376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/f782425a5b3fb080a2d77cb3dde83ed8.webp"
"MediaSize" => 202681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-f782425a5b3fb080a2d77cb3dde83ed8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6399198401"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/da89fc7be741ccf9a72fddab3d1ef214.webp"
"MediaSize" => 197548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-da89fc7be741ccf9a72fddab3d1ef214.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6399198462"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/69db6825df46ddf163931b54b8898636.webp"
"MediaSize" => 169716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-69db6825df46ddf163931b54b8898636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6399198504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/25de7d53e421364baf10039f5f1c1667.webp"
"MediaSize" => 164901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-25de7d53e421364baf10039f5f1c1667.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6399198589"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/6211a6a857763243e67aecfc12b1043f.webp"
"MediaSize" => 186263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-6211a6a857763243e67aecfc12b1043f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6399198633"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/61e263ed632ab5fffd004eabee89558a.webp"
"MediaSize" => 168729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-61e263ed632ab5fffd004eabee89558a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6399198685"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/321a1f6d978d073e891f91721b3b0f9b.webp"
"MediaSize" => 157533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-321a1f6d978d073e891f91721b3b0f9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6399198757"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/9dd44948754748de58ea265535b48e73.webp"
"MediaSize" => 161751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-9dd44948754748de58ea265535b48e73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6399198773"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/b68ba281a7d46f821516bde5b32cd644.webp"
"MediaSize" => 161270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-b68ba281a7d46f821516bde5b32cd644.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6399198835"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/9408d60faf49e5897f15ecc2400889bf.webp"
"MediaSize" => 174632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-9408d60faf49e5897f15ecc2400889bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6399198894"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/9ca0952e97c7ab4b50e6f4cd784bd0a4.webp"
"MediaSize" => 208666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-9ca0952e97c7ab4b50e6f4cd784bd0a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6399198944"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/7b0017fa03ed973d567f49c86e3f2d52.webp"
"MediaSize" => 189374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-7b0017fa03ed973d567f49c86e3f2d52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6399198973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/aca069feb50d858da0e6d255f7dfa043.webp"
"MediaSize" => 189405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-aca069feb50d858da0e6d255f7dfa043.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6399199033"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/f4c5cb4a3592fd30673e0ad5a32cf942.webp"
"MediaSize" => 214992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-f4c5cb4a3592fd30673e0ad5a32cf942.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6399199081"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/be5cce7e8732cb6bb51652cedf6c3877.webp"
"MediaSize" => 148989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-be5cce7e8732cb6bb51652cedf6c3877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6399199133"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/38a49a6f162c91ce7afc9201319dddd1.webp"
"MediaSize" => 189204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-38a49a6f162c91ce7afc9201319dddd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6399199225"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/94777e13fb689f732e72e7305bfa1aa1.webp"
"MediaSize" => 202518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-94777e13fb689f732e72e7305bfa1aa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6399199264"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/18acafb23be9eda969d77cfa37202854.webp"
"MediaSize" => 210616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-18acafb23be9eda969d77cfa37202854.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6399199315"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/2a61025f9b8f9d95f0e763ff95b62b53.webp"
"MediaSize" => 170944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-2a61025f9b8f9d95f0e763ff95b62b53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6399199340"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/957c55bbed1a3cece51fddf5108e6240.webp"
"MediaSize" => 160403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-957c55bbed1a3cece51fddf5108e6240.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6399199388"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/4706df8054ffd1598961cdc66bda4e90.webp"
"MediaSize" => 408168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-4706df8054ffd1598961cdc66bda4e90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6399199424"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/5bd6a7c0d9ff7bce8f94e0efba922c6e.webp"
"MediaSize" => 466411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-5bd6a7c0d9ff7bce8f94e0efba922c6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6399199441"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237381/49fbeaeb4bd773bbad7a89379aa8feae.webp"
"MediaSize" => 524159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237381/thumbnail-49fbeaeb4bd773bbad7a89379aa8feae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683718"
"ResourceRecordKey" => "29237381"
"ModificationTimestamp" => "2026-01-10T17:41:10.96Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "TIMOTHY WAI MING HONG"
"MemberFirstName" => "TIMOTHY WAI MING"
"MemberLastName" => "HONG"
"MemberMlsId" => "9542424"
"OriginatingSystemName" => 26
"MemberKey" => "1907911"
"ModificationTimestamp" => "2025-12-15T06:24:15Z"
"MemberStatus" => "Active"
"OfficeKey" => "194325"
"MemberAOR" => "Toronto"
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-361-9098"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2011-03-09T05:03:00Z"
"MemberNationalAssociationId" => "1220950"
"OfficeNationalAssociationId" => "1191701"
]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29237381')"
+"ID": "525186"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24831
+post_id: "525069"
+post_author: 1
+"ListingKey": "29237078"
+"ListingId": "40797443"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T15:05:54Z"
+"RFModificationTimestamp": "2026-01-10T16:50:31Z"
+"ListPrice": 1299000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2241.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6N6"
+"UnparsedAddress": "255 KEATS Way Unit# 1404, Waterloo, Ontario N2L6N6"
+"Coordinates": array:2 [
0 => -80.543239
1 => 43.461952
]
+"Latitude": 43.461952
+"Longitude": -80.543239
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this one-of-a-kind, professionally designed 2,241 sq. ft. penthouse in the heart of Waterloo’s coveted Beechwood neighbourhood. Perched high above the treetops, this showstopper boasts panoramic views from three sides and offers an unmatched sense of privacy and natural light through oversized windows at every turn. Meticulously renovated top to bottom by Menno Martin, this residence exudes quality and elegance. The grand living room features coffered ceilings and hardwood flooring throughout, opening onto a breathtaking 400 sq. ft. terrace—one of three outdoor spaces. The open-concept kitchen is a chef’s dream, showcasing solid wood cabinetry, quartz countertops, and premium finishes, seamlessly connecting to a formal dining area perfect for entertaining. The spacious primary suite is a private retreat with its own 400 sq. ft. terrace, a luxurious ensuite, and generous closet space. A second bedroom, additional bedroom or den, and a second expansive 200 sq. ft. terrace offer plenty of flexibility for guests, work, or relaxation. Set in a quiet, exceptionally well-maintained building, this rare penthouse is just steps to Waterloo Park, trails, and the vibrant offerings of Uptown Waterloo. Three underground parking spaces complete this truly exceptional package—an incredibly rare find in this location. The condominium also includes a fitness center, library, on-site super-intendant, guest suite and two lockers. Call to book a private showing today. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Freezer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"AssociationFee": "1344.71"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T16:50:20.477476+00:00"
+"Directions": "University Avenue to Keats Way"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Boiler"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960053"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-10T14:59:59Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T14:59:59Z"
+"Stories": "1.0"
+"StreetName": "KEATS"
+"StreetNumber": "255"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7032"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/255-Keats-Way-1404"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1558629951"
"RoomType" => "Den"
"ListingId" => "40797443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237078"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T14:59:59.49Z"
]
1 => array:11 [
"RoomKey" => "1558629952"
"RoomType" => "Living room"
"ListingId" => "40797443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237078"
"RoomLength" => null
"RoomDimensions" => "21'0'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T14:59:59.49Z"
]
2 => array:11 [
"RoomKey" => "1558629953"
"RoomType" => "Kitchen"
"ListingId" => "40797443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237078"
"RoomLength" => null
"RoomDimensions" => "17'9'' x 18'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T14:59:59.49Z"
]
3 => array:11 [
"RoomKey" => "1558629954"
"RoomType" => "Dining room"
"ListingId" => "40797443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237078"
"RoomLength" => null
"RoomDimensions" => "16'5'' x 18'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T14:59:59.49Z"
]
4 => array:11 [
"RoomKey" => "1558629955"
"RoomType" => "Laundry room"
"ListingId" => "40797443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237078"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T14:59:59.49Z"
]
5 => array:11 [
"RoomKey" => "1558629956"
"RoomType" => "4pc Bathroom"
"ListingId" => "40797443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237078"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T14:59:59.49Z"
]
6 => array:11 [
"RoomKey" => "1558629957"
"RoomType" => "Bedroom"
"ListingId" => "40797443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237078"
"RoomLength" => null
"RoomDimensions" => "22'7'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T14:59:59.49Z"
]
7 => array:11 [
"RoomKey" => "1558629958"
"RoomType" => "3pc Bathroom"
"ListingId" => "40797443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237078"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T14:59:59.49Z"
]
8 => array:11 [
"RoomKey" => "1558629959"
"RoomType" => "Primary Bedroom"
"ListingId" => "40797443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237078"
"RoomLength" => null
"RoomDimensions" => "15'4'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T14:59:59.49Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29237078/255-keats-way-unit-1404-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Guest Suite"
2 => "Party Room"
]
+"ZoningDescription": "MR-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 2241
+"OriginalEntryTimestamp": "2026-01-10T14:59:59.41Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:25 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6399070613"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/cf5ae303fac9fa3c79a9f15e4c1927ba.webp"
"MediaSize" => 227727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-cf5ae303fac9fa3c79a9f15e4c1927ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6399070618"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/7eda21094b9de56355dfe36521153b22.webp"
"MediaSize" => 98612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-7eda21094b9de56355dfe36521153b22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6399070624"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/d87f5fc813825cd3bf57b48c1e2ea0de.webp"
"MediaSize" => 122992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-d87f5fc813825cd3bf57b48c1e2ea0de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6399070629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/290297cfc50824ff601c16f939cb2ad8.webp"
"MediaSize" => 79878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-290297cfc50824ff601c16f939cb2ad8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6399070633"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/3f4cd0828b43181454d888e06aa6f93a.webp"
"MediaSize" => 77671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-3f4cd0828b43181454d888e06aa6f93a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6399070637"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/b3a7ef58582f4f2ab66a145ea846a659.webp"
"MediaSize" => 88349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-b3a7ef58582f4f2ab66a145ea846a659.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6399070643"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/f9d82e6c22a9ebe1400788326f74e50d.webp"
"MediaSize" => 80356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-f9d82e6c22a9ebe1400788326f74e50d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6399070650"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/d956e1e1678981090cc778a6eedbad92.webp"
"MediaSize" => 89638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-d956e1e1678981090cc778a6eedbad92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6399070658"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/b8350f150f1273fc159c8b4c33f93945.webp"
"MediaSize" => 88775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-b8350f150f1273fc159c8b4c33f93945.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6399070665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/9ae8c7902ce1f012e3980823ecdf97fb.webp"
"MediaSize" => 95301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-9ae8c7902ce1f012e3980823ecdf97fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6399070669"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/81b9537a9a4065d6e32e6c6a6aaa0e31.webp"
"MediaSize" => 107215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-81b9537a9a4065d6e32e6c6a6aaa0e31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6399070672"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/02e9a77491e6e146b0f600fc805f5f48.webp"
"MediaSize" => 79499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-02e9a77491e6e146b0f600fc805f5f48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6399070677"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/08507bcf07d287ddfd90435e6b83b8f7.webp"
"MediaSize" => 87442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-08507bcf07d287ddfd90435e6b83b8f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6399070681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/3526c4c53dbf0c816812b1600bf51cc1.webp"
"MediaSize" => 98578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-3526c4c53dbf0c816812b1600bf51cc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6399070686"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/efb87afea14caa652f290ee6820d2cd0.webp"
"MediaSize" => 73083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-efb87afea14caa652f290ee6820d2cd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6399070690"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/2382c11f045987212dadc2166cd91574.webp"
"MediaSize" => 67674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-2382c11f045987212dadc2166cd91574.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6399070697"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/20b0f3c10b648a4e2e2a389d2177edee.webp"
"MediaSize" => 65487
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-20b0f3c10b648a4e2e2a389d2177edee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6399070703"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/243ff5c1ccd35ab9c85dab32d3476354.webp"
"MediaSize" => 54295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-243ff5c1ccd35ab9c85dab32d3476354.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6399070714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/82a02f6e83da1e38752ee42d1ab29b25.webp"
"MediaSize" => 70016
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-82a02f6e83da1e38752ee42d1ab29b25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6399070723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/22c6cd6d3abb9cdafb4d3618eaca1d63.webp"
"MediaSize" => 80835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-22c6cd6d3abb9cdafb4d3618eaca1d63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6399070728"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237078/20c379d87b34f2cb2a09365c424ca823.webp"
"MediaSize" => 70898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237078/thumbnail-20c379d87b34f2cb2a09365c424ca823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797443"
"ResourceRecordKey" => "29237078"
"ModificationTimestamp" => "2026-01-10T14:59:59.42Z"
]
21 => array:13 [
"Order" => 21
…12
]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => 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('29237078')"
+"ID": "525069"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24834
+post_id: "523948"
+post_author: 1
+"ListingKey": "29236246"
+"ListingId": "X12682720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T01:25:31Z"
+"RFModificationTimestamp": "2026-01-10T01:26:16Z"
+"ListPrice": 849998.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 8.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3X7"
+"UnparsedAddress": "51 HIGH STREET, Waterloo, Ontario N2L3X7"
+"Coordinates": array:2 [
0 => -80.5311638
1 => 43.4808124
]
+"Latitude": 43.4808124
+"Longitude": -80.5311638
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Great location-attention investors seeking strong and stable rental income. This well-maintained property offers a total of 8 bedrooms configured across two self-contained living areas, each featuring four bedrooms, a full bathroom, kitchen, laundry, and separate entrance. Ideally located steps to the University of Waterloo and minutes to Wilfrid Laurier University, colleges, and the LRT at University of Waterloo Station. Close to all amenities includingshops, restaurants, bars, and Uptown Waterloo.Features include central air conditioning, ample parking with up to 5 driveway spaces, and agenerous 50 x 130 ft lot with a well-maintained backyard. Previously leased for over $6,000 per month, this is an excellent income-generating opportunity with strong upside and long-term appreciation potential. Amazing value for moneyin a prime university location. (id:62650)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T00:51:18.436855+00:00"
+"Directions": "Cross Streets: Hazel St. ** Directions: Colombia x Albert."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952795"
+"ListOfficeKey": "290772"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 130 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T23:40:22Z"
+"PhotosCount": 15
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T01:13:06Z"
+"Stories": "1.0"
+"StreetName": "High"
+"StreetNumber": "51"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7237.28"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:2 [
0 => array:11 [ …11]
1 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29236246/51-high-street-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2181759"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "290772"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 4
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-01-09T23:40:22.12Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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:23 [ …23]
]
+"Office": array:1 [
0 => array:5 [ …5]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29236246')"
+"ID": "523948"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24726
+post_id: "522810"
+post_author: 1
+"ListingKey": "29234582"
+"ListingId": "X12681248"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T19:25:11Z"
+"RFModificationTimestamp": "2026-01-09T19:26:35Z"
+"ListPrice": 375000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3R2"
+"UnparsedAddress": "G216 - 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": "Looking for the ideal one-bedroom plus den home in the heart of Waterloo? Explore 275 Larch Street, Unit 216-a beautifully renovated condo that combines modern design with a prime location. Just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, shopping, dining, and all the city's vibrant amenities, this unit is perfect for students, professionals, or investors. Inside, an open-concept layout welcomes you with comfort and versatility, ideal for relaxing, studying, or entertaining. Large windows bathe the space in natural light, while contemporary finishes and warm tones create a cozy, inviting atmosphere. The bedroom is generously sized, and the den provides flexible space for work, study, or hobbies. The updated four-piece bathroom adds a touch of style and luxury. With convenient access to Waterloo Park, transit, top-rated restaurants, and more, this home offers unmatched lifestyle and convenience. Schedule your private tour today! (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"AssociationFee": "271.2"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T19:26:16.961099+00:00"
+"Directions": "Cross Streets: Balsam St turn to Larch St. ** Directions: From Balsam St turn to Larch St and proceed to 275 Larch St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2146218"
+"ListOfficeKey": "272157"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T18:42:02Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T19:12:32Z"
+"StreetName": "Larch"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2266.77"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29234582/g216-275-larch-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Schembri Prop Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"ZoningDescription": "RN-6"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-09T18:42:01.96Z"
+"MapCoordinateVerifiedYN": false
+"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:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29234582')"
+"ID": "522810"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24832
+post_id: "522811"
+post_author: 1
+"ListingKey": "29232871"
+"ListingId": "X12679414"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T14:20:22Z"
+"RFModificationTimestamp": "2026-01-09T18:41:20Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W9"
+"UnparsedAddress": "N2704 - 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": "Newly painted penthouse featuring the largest layout in the building-1,107 sq. ft. with 4 bedrooms and 3 bathrooms. Bright and sun-filled with large windows and a modern open-concept design. Located directly across the street from the University of Waterloo and just steps to Wilfrid Laurier University-ideal for student rental or end-users. The building offers resort-style amenities including a rooftop terrace with stunning views, fitness centre, basketball court, sauna, yoga studio, games room, study lounge, and 24-hour security.Newly painted penthouse featuring the largest layout in the building-1,107 sq. ft. with 4 bedrooms and 3 bathrooms. Bright and sun-filled with large windows and a modern open-concept design. Located directly across the street from the University of Waterloo and just steps to Wilfrid Laurier University-ideal for student rental or end-users. The building offers resort-style amenities including a rooftop terrace with stunning views, fitness centre, basketball court, sauna, yoga studio, games room, study lounge, and 24-hour security. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "599"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T18:41:07.885425+00:00"
+"Directions": "Cross Streets: Columbia St W and Phillip St. ** Directions: SW of Columbia St W and Phillip St."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1917450"
+"ListOfficeKey": "286795"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T14:11:42Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T14:11:42Z"
+"StreetName": "Phillip"
+"StreetNumber": "330"
+"StreetSuffix": "Street"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29232871/n2704-330-phillip-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2107351"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group Kwg"
+"CoListOfficeKey": "286795"
+"GeocodeManualYN": false
+"TotalActualRent": 4400
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-09T14:11:42.48Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:34 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29232871')"
+"ID": "522811"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24837
+post_id: "522812"
+post_author: 1
+"ListingKey": "29233699"
+"ListingId": "40797346"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T16:45:36Z"
+"RFModificationTimestamp": "2026-01-09T17:40:02Z"
+"ListPrice": 1398888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.2
+"LivingArea": 3307.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3X8"
+"UnparsedAddress": "279 FERNDALE Place, Waterloo, Ontario N2J3X8"
+"Coordinates": array:2 [
0 => -80.5126327
1 => 43.4835795
]
+"Latitude": 43.4835795
+"Longitude": -80.5126327
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Remarks Public Remarks: Is it the finest listing on the nicest street in all of Waterloo Region? Maybe.* Welcome to 279 Ferndale Place, don't let the modest classic mid century modern frontage fool you, once inside this home opens up to many wonderful spaces and large windows throughout. A walk out bungalow, designed to sit behind adjacent homes, giving panoramic views from almost all principal rooms of the mature forest/nature. Many trees over 100 years old are on the property and street. A major addtion allowed this home to be reimagined meshing mid century feel with modern finishes. The kitchen/living area is open but not a bland box. This space flows from the bright, large, functional kitchen into a wonderful entertaing gathering place with awe inspiring views. This is a special place for family and entertaining. The master bedroom is a private setting with an ensuite that is top of class, tranquil, a spa like experience. A walk out to a separate balcony, for a morning coffee or a quiet evening, completes this space. The basement really isn't a basement with walk out and floor to ceiling windows in a couple of the rooms. An entertainment area for movie nights as well as a warm family room to gather around. The main bedroom on this level has huge windows with great forest views. This might be the nicest room in the home, a special place. This home could easily be converted to have second/bright kitchen downstairs for second suite or be converted to duplex. Close to the expressway, universities, shopping and transit, the location is exceptional and the 60 acre park a rarity in a central location. Come have a look, there is nothing quite like this home in this region. A special place great for dog walkers, nature lovers and is a birding paradise. Google the Record + three pairs of shoes to see why one man who walked every street in the region picked Ferndale Place as their favourite (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Oven - Built-In"
8 => "Hood Fan"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T17:39:47.395456+00:00"
+"Directions": "From University West off the Expressway to Glenridge Drive, to MacGregor Cres, to Ferndale Place"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Electric"
2 => "Other - See remarks"
3 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564385"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Skylight"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.2"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T16:38:43Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T16:38:42Z"
+"Stories": "1.0"
+"StreetName": "FERNDALE"
+"StreetNumber": "279"
+"StreetSuffix": "Place"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"TaxAnnualAmount": "6964.18"
+"View": "View of water"
+"VirtualTourURLUnbranded": "https://youriguide.com/279_ferndale_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29233699/279-ferndale-place-waterloo"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2182352"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283125"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.0
+"AboveGradeFinishedArea": 1922
+"BelowGradeFinishedArea": 1385
+"OriginalEntryTimestamp": "2026-01-09T16:38:42.9Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29233699')"
+"ID": "522812"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23481
+post_id: "522813"
+post_author: 1
+"ListingKey": "29232830"
+"ListingId": "X12679364"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T16:30:39Z"
+"RFModificationTimestamp": "2026-01-09T16:33:19Z"
+"ListPrice": 798000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L3W9"
+"UnparsedAddress": "N2704 - 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": "Newly painted penthouse featuring the largest layout in the building-1,107 sq. ft. with 4 bedrooms and 3 bathrooms. Bright and sun-filled with large windows and a modern open-concept design. Exceptional investment potential with estimated rent of $4,400/month.Located directly across the street from the University of Waterloo and just steps to Wilfrid Laurier University-ideal for student rental or end-users. The building offers resort-style amenities including a rooftop terrace with stunning views, fitness centre, basketball court, sauna, yoga studio, games room, study lounge, and 24-hour security.A rare opportunity to own a premium penthouse in one of Waterloo's most sought-after locations. Don't miss it. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Oven - Built-In"
7 => "Window Coverings"
]
+"AssociationFee": "599.49"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T16:02:15.933841+00:00"
+"Directions": "Cross Streets: Columbia St W and Phillip St. ** Directions: SW of Columbia St W and Phillip St."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1917450"
+"ListOfficeKey": "286795"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T16:16:40Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T16:16:40Z"
+"StreetName": "Phillip"
+"StreetNumber": "330"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4946"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29232830/n2704-330-phillip-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2107351"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Craft Property Group"
+"CoListOfficeKey": "286795"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Security/Concierge"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 4
+"OriginalEntryTimestamp": "2026-01-09T13:40:20.1Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29232830')"
+"ID": "522813"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25102
+post_id: "521504"
+post_author: 1
+"ListingKey": "29232223"
+"ListingId": "X12678814"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T01:20:08Z"
+"RFModificationTimestamp": "2026-01-09T01:31:33Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H5"
+"UnparsedAddress": "314 - 250 ALBERT STREET, Waterloo, Ontario N2L0H5"
+"Coordinates": array:2 [
0 => -80.532427
1 => 43.475199
]
+"Latitude": 43.475199
+"Longitude": -80.532427
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Excellent Opportunity for Investors, Professors, Couples, Parents & Students. Minutes Walk From Wilfred Laurier & U Waterloo. Bright & Open Concept Layout. Sunny west view with walk-out to balcony. Modern Kitchen with Granite Countertop. In Suite Laundry. Lovely Common Area On Rooftop Terrace. Updated sofa, coffee table, kitchen table, shower curtain bar, adjustable shower head. (id:62650)"
+"Appliances": array:2 [
0 => "Oven - Built-In"
1 => "Furniture"
]
+"AssociationFee": "337.55"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T01:31:32.750797+00:00"
+"Directions": "University and King"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1927235"
+"ListOfficeKey": "51307"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T01:13:26Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T01:13:26Z"
+"StreetName": "Albert"
+"StreetNumber": "250"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2403.32"
+"View": "City view,View"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29232223/314-250-albert-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 499
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-09T01:13:26.86Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:20 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29232223')"
+"ID": "521504"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24768
+post_id: "520968"
+post_author: 1
+"ListingKey": "29231651"
+"ListingId": "X12678370"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T22:50:13Z"
+"RFModificationTimestamp": "2026-01-08T23:06:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H7"
+"UnparsedAddress": "282 - 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": "Just minutes from the University of Waterloo, this bright and well-maintained 2-bedroomapartment for lease features a full kitchen, 3-piece bathroom, and a large private balcony, offering an ideal living space for students or professionals who want comfort and convenience in a prime location close to University, transit, shopping, and everyday amenities. Available March 1, 2026 (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-08T23:05:52.974008+00:00"
+"Directions": "Cross Streets: University Ave W & Albert. ** Directions: University Ave W & Alber."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1895539"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-08T22:41:26Z"
+"PhotosCount": 11
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T22:41:26Z"
+"StreetName": "Sunview"
+"StreetNumber": "258B"
+"StreetSuffix": "Street"
+"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/29231651/282-258b-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management Inc."
+"GeocodeManualYN": false
+"TotalActualRent": 2100
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-08T22:41:26.04Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:11 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29231651')"
+"ID": "520968"
}
]
+success: true
+page_size: 9
+page_count: 24
+count: 209
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]