array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29840907 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1485514"
+post_author: 1
+"ListingKey": "29840907"
+"ListingId": "X13228894"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T18:25:20Z"
+"RFModificationTimestamp": "2026-06-02T18:57:26Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0H6"
+"UnparsedAddress": "123 - 258A SUNVIEW STREET, Waterloo, Ontario N2L0H6"
+"Coordinates": array:2 [
0 => -80.532991
1 => 43.474108
]
+"Latitude": 43.474108
+"Longitude": -80.532991
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This bright and modern 2-bedroom unit is perfectly situated in the vibrant university district, nestled between Wilfrid Laurier University and the University of Waterloojust a short 2 to 7-minute walk to both campuses Waterloo and Wifred Laurier as well as Conestoga College. Ideal for students or young professionals, the unit comes fully furnished and features stainless steel appliances, large windows that allow for plenty of natural light, and convenient internal and external bicycle parking. Located steps from University Avenue, the building offers easy access to public transit, including light rail and GO Transit, and is surrounded by a variety of amenities such as restaurants, parks, banks, grocery stores, and shops.. This is a fantastic opportunity to live in one of Waterloos most desirable and walkable neighborhoods! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T18:57:22.687348+00:00"
+"Directions": "Cross Streets: University Ave W / Sunview St. ** Directions: University Ave W. Sunview St."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Concrete"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1778599"
+"ListOfficeKey": "290358"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T17:56:02Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T18:15:12Z"
+"StreetName": "Sunview"
+"StreetNumber": "258A"
+"StreetSuffix": "Street"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1650030912"
"RoomType" => "Bedroom"
"ListingId" => "X13228894"
"RoomLevel" => "Main level"
"RoomWidth" => 4.05
"ListingKey" => "29840907"
"RoomLength" => 2.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-02T18:15:12.97Z"
]
1 => array:11 [
"RoomKey" => "1650030913"
"RoomType" => "Bedroom 2"
"ListingId" => "X13228894"
"RoomLevel" => "Main level"
"RoomWidth" => 2.59
"ListingKey" => "29840907"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-02T18:15:12.98Z"
]
2 => array:11 [
"RoomKey" => "1650030914"
"RoomType" => "Kitchen"
"ListingId" => "X13228894"
"RoomLevel" => "Main level"
"RoomWidth" => 2.04
"ListingKey" => "29840907"
"RoomLength" => 2.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-02T18:15:12.98Z"
]
3 => array:11 [
"RoomKey" => "1650030915"
"RoomType" => "Living room"
"ListingId" => "X13228894"
"RoomLevel" => "Main level"
"RoomWidth" => 2.04
"ListingKey" => "29840907"
"RoomLength" => 3.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-02T18:15:12.98Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29840907/123-258a-sunview-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"GeocodeManualYN": false
+"TotalActualRent": 1950
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-02T17:56:02.66Z"
+"ListAgentNationalAssociationId": "1187420"
+"ListOfficeNationalAssociationId": "1386142"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29840907_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/276a1161fb874219ba4ae0d47b87b974.webp"
"MediaSize" => 387862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-276a1161fb874219ba4ae0d47b87b974.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29840907_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/c9bb85e0813179802c8038c7cce127af.webp"
"MediaSize" => 387862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-c9bb85e0813179802c8038c7cce127af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29840907_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/f47c382a19200c4e757bfc3ec95d1bc6.webp"
"MediaSize" => 404866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-f47c382a19200c4e757bfc3ec95d1bc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29840907_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/14d097dbc59826b195273f14ef2cbe0f.webp"
"MediaSize" => 292659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-14d097dbc59826b195273f14ef2cbe0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29840907_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/62be38565d7db2267fe2bcc845985315.webp"
"MediaSize" => 183454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-62be38565d7db2267fe2bcc845985315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29840907_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/3de00d082d896293804f3032e81f54c3.webp"
"MediaSize" => 252563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-3de00d082d896293804f3032e81f54c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29840907_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/0af5afe646edfa78953baaa9b64e58e0.webp"
"MediaSize" => 242708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-0af5afe646edfa78953baaa9b64e58e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29840907_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/ab69290df70d17342a6c36f9dad76a6b.webp"
"MediaSize" => 250543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-ab69290df70d17342a6c36f9dad76a6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29840907_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/ef2a7988b1ae22b268f32f1033c28158.webp"
"MediaSize" => 212048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-ef2a7988b1ae22b268f32f1033c28158.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29840907_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/10e0d99895ff8a8572fa022c575e7809.webp"
"MediaSize" => 212048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-10e0d99895ff8a8572fa022c575e7809.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29840907_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/5c89eef1af5505c78741463ce1064ef2.webp"
"MediaSize" => 164453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-5c89eef1af5505c78741463ce1064ef2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29840907_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/eb9f8e866f2995518fa0f6d6c43188c8.webp"
"MediaSize" => 166937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-eb9f8e866f2995518fa0f6d6c43188c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29840907_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/3f910f982109eaabdd48bba7302b9a57.webp"
"MediaSize" => 210325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-3f910f982109eaabdd48bba7302b9a57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29840907_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/5670e196c384d6d6e14c948e7b5e41b7.webp"
"MediaSize" => 210325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-5670e196c384d6d6e14c948e7b5e41b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29840907_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/287bed5a23d3cc1ecd28a82907865723.webp"
"MediaSize" => 210325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-287bed5a23d3cc1ecd28a82907865723.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29840907_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/123150eb7b40aca45a89d3e0e9be06b9.webp"
"MediaSize" => 161059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-123150eb7b40aca45a89d3e0e9be06b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29840907_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/b240314875e455b351018ad0a97c9720.webp"
"MediaSize" => 218054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-b240314875e455b351018ad0a97c9720.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29840907_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/8c08b197ca9859dc4793824a25d8fca8.webp"
"MediaSize" => 215856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-8c08b197ca9859dc4793824a25d8fca8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29840907_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/f7c6897196e68cc9fc73c16f7b9647ec.webp"
"MediaSize" => 215856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-f7c6897196e68cc9fc73c16f7b9647ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29840907_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/09335ac348ad45a5cc44e1a6549af3ab.webp"
"MediaSize" => 220772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-09335ac348ad45a5cc44e1a6549af3ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29840907_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/b8859da772dcdaf88062624bc8be337d.webp"
"MediaSize" => 215305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-b8859da772dcdaf88062624bc8be337d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29840907_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/7cf593c7771f6acfdfa8da9f888d8592.webp"
"MediaSize" => 215305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-7cf593c7771f6acfdfa8da9f888d8592.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29840907_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/4d46219806e559c6b11ce5b829815bc2.webp"
"MediaSize" => 203197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-4d46219806e559c6b11ce5b829815bc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29840907_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/eff7d3f19eab4b844ee1cd03672dbe8c.webp"
"MediaSize" => 203197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-eff7d3f19eab4b844ee1cd03672dbe8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29840907_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/d6b4f948e2dbe4c1c2d793d52daed982.webp"
"MediaSize" => 200003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-d6b4f948e2dbe4c1c2d793d52daed982.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29840907_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/a757c0ae5f18e6226a7eeb30614080a1.webp"
"MediaSize" => 189960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-a757c0ae5f18e6226a7eeb30614080a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29840907_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/3aed4678b7db43418e6194d29c29fc34.webp"
"MediaSize" => 216646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-3aed4678b7db43418e6194d29c29fc34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29840907_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/e04aa51839e6122a7301044823a31543.webp"
"MediaSize" => 191148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-e04aa51839e6122a7301044823a31543.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29840907_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/a309e8239c9a8f8f18c37af9f63fbf62.webp"
"MediaSize" => 200654
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-a309e8239c9a8f8f18c37af9f63fbf62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29840907_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/8e767051d564457ff2e874dfbed3fbbf.webp"
"MediaSize" => 121832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-8e767051d564457ff2e874dfbed3fbbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29840907_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/40044b150c76678784404c03b29a21ee.webp"
"MediaSize" => 132374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-40044b150c76678784404c03b29a21ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29840907_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/276e6b60e8efd5b051391b3265835180.webp"
"MediaSize" => 223743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-276e6b60e8efd5b051391b3265835180.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29840907_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/b8cd5989bdbcbd58887e49567de35e1b.webp"
"MediaSize" => 223743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-b8cd5989bdbcbd58887e49567de35e1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29840907_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/38456c09eb2022a9420ee260d5927528.webp"
"MediaSize" => 135930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-38456c09eb2022a9420ee260d5927528.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29840907_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/2ded3755ddc8f40b33e442103641099a.webp"
"MediaSize" => 163296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-2ded3755ddc8f40b33e442103641099a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29840907_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/241e8a20626ec9bf377c01193c97d1d6.webp"
"MediaSize" => 316328
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-241e8a20626ec9bf377c01193c97d1d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29840907_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/2ed92792661af853a19c958b35dae1ca.webp"
"MediaSize" => 316846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-2ed92792661af853a19c958b35dae1ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29840907_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29840907/99d6208d9934ec93b345526561c241f0.webp"
"MediaSize" => 358159
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29840907/thumbnail-99d6208d9934ec93b345526561c241f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13228894"
"ResourceRecordKey" => "29840907"
"ModificationTimestamp" => "2026-06-02T17:56:02.67Z"
]
]
+"DaysOnMarket": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29840907')"
+"ID": "1485514"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290358" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24894
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1778599" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24852
+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 '29840907'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25247
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29840907'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25263
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29840907' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential Lease' AND geo.distance(Coordinates, POINT(-80.532991 43.474108)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "1581585"
+post_author: 1
+"ListingKey": "29974256"
+"ListingId": "X13507904"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T02:35:08Z"
+"RFModificationTimestamp": "2026-07-01T02:39:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2H0J5"
+"UnparsedAddress": "H201 - 275 LARCH STREET, Waterloo, Ontario N2H0J5"
+"Coordinates": array:2 [
0 => -80.531342
1 => 43.477165
]
+"Latitude": 43.477165
+"Longitude": -80.531342
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Beautiful 3 Bedroom (one bedroom is a den with a privacy separation) 2 bath condo available! Fully furnished and fully supplied with kitchen, bedding items and all! In suite laundry, nothing is shared! Rent is $2,550 all included except hydro. High speed Rogers internet included as well! Amazing location! Minutes walk away from University of Waterloo and Laurier university! Available Sept 1, 2026 (id:62650)"
+"Appliances": array:1 [
0 => "Intercom"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T02:39:26.556315+00:00"
+"Directions": "Hickory St/Larch St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2059512"
+"ListOfficeKey": "204997"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T01:56:42Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T02:26:27Z"
+"StreetName": "LARCH"
+"StreetNumber": "275"
+"StreetSuffix": "Street"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1672424888"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13507904"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29974256"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T02:26:27.49Z"
]
1 => array:11 [
"RoomKey" => "1672424889"
"RoomType" => "Bathroom"
"ListingId" => "X13507904"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29974256"
"RoomLength" => 1.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T02:26:27.5Z"
]
2 => array:11 [
"RoomKey" => "1672424890"
"RoomType" => "Bedroom"
"ListingId" => "X13507904"
"RoomLevel" => "Main level"
"RoomWidth" => 2.82
"ListingKey" => "29974256"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T02:26:27.51Z"
]
3 => array:11 [
"RoomKey" => "1672424891"
"RoomType" => "Bathroom"
"ListingId" => "X13507904"
"RoomLevel" => "Main level"
"RoomWidth" => 2.0
"ListingKey" => "29974256"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T02:26:27.52Z"
]
4 => array:11 [
"RoomKey" => "1672424892"
"RoomType" => "Kitchen"
"ListingId" => "X13507904"
"RoomLevel" => "Main level"
"RoomWidth" => 1.52
"ListingKey" => "29974256"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T02:26:27.53Z"
]
5 => array:11 [
"RoomKey" => "1672424893"
"RoomType" => "Living room"
"ListingId" => "X13507904"
"RoomLevel" => "Main level"
"RoomWidth" => 4.57
"ListingKey" => "29974256"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T02:26:27.55Z"
]
6 => array:11 [
"RoomKey" => "1672424894"
"RoomType" => "Bedroom"
"ListingId" => "X13507904"
"RoomLevel" => "Main level"
"RoomWidth" => 2.82
"ListingKey" => "29974256"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-01T02:26:27.56Z"
]
]
+"ListAOR": "Oakville-Milton"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29974256/h201-275-larch-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Condo Management Corp"
+"GeocodeManualYN": false
+"TotalActualRent": 2550
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Separate Heating Controls"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-07-01T01:56:41.97Z"
+"ListAgentNationalAssociationId": "1334662"
+"ListOfficeNationalAssociationId": "1245785"
+"Media": array:16 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29974256_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/c86aa7d3d3e235ebea1e70f22cff5053.webp"
"MediaSize" => 161237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-c86aa7d3d3e235ebea1e70f22cff5053.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29974256_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/c07afbda34dd8fd731957926a776fe6d.webp"
"MediaSize" => 95608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-c07afbda34dd8fd731957926a776fe6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29974256_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/bbfab3e7993a7ac27ba0715dc681df4e.webp"
"MediaSize" => 113404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-bbfab3e7993a7ac27ba0715dc681df4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29974256_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/295ab4b4c1184fcadfab6d698440f9f8.webp"
"MediaSize" => 113714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-295ab4b4c1184fcadfab6d698440f9f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29974256_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/9e3279636b95910d6ea57a96c3bb6e1f.webp"
"MediaSize" => 111983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-9e3279636b95910d6ea57a96c3bb6e1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29974256_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/ce0ca3b8ed0b29ee263af175ffe5fc74.webp"
"MediaSize" => 108479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-ce0ca3b8ed0b29ee263af175ffe5fc74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29974256_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/afe8e00495738d3abbf4bd43b0593ee4.webp"
"MediaSize" => 102651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-afe8e00495738d3abbf4bd43b0593ee4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29974256_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/a647196cd26b758da03eb6cae729d046.webp"
"MediaSize" => 103643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-a647196cd26b758da03eb6cae729d046.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29974256_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/4266c5fa4a6726d827e80eb3c1fabe96.webp"
"MediaSize" => 104660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-4266c5fa4a6726d827e80eb3c1fabe96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29974256_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/0cf7ac7c046cff270f1f3f38affac570.webp"
"MediaSize" => 117316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-0cf7ac7c046cff270f1f3f38affac570.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29974256_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/7242af33f9d239b5bdd5412002cf4962.webp"
"MediaSize" => 127814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-7242af33f9d239b5bdd5412002cf4962.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29974256_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/7adf1d106d4da5d26e489de24e01fcc2.webp"
"MediaSize" => 95354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-7adf1d106d4da5d26e489de24e01fcc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29974256_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/53ca0232fdd2cd0178c2d583e681dae7.webp"
"MediaSize" => 134303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-53ca0232fdd2cd0178c2d583e681dae7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29974256_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/ec3316050a12dfa5eab6131763acbf77.webp"
"MediaSize" => 130347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-ec3316050a12dfa5eab6131763acbf77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29974256_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/84b46790ab23ace86966b6f11d058683.webp"
"MediaSize" => 64025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-84b46790ab23ace86966b6f11d058683.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29974256_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974256/aec2ec6c66f99f686c00aff4698c0cbc.webp"
"MediaSize" => 48845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974256/thumbnail-aec2ec6c66f99f686c00aff4698c0cbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13507904"
"ResourceRecordKey" => "29974256"
"ModificationTimestamp" => "2026-07-01T01:56:41.98Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974256')"
+"ID": "1581585"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+post_id: "1579583"
+post_author: 1
+"ListingKey": "29971101"
+"ListingId": "X13505152"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T17:46:21Z"
+"RFModificationTimestamp": "2026-06-30T18:59:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0K2"
+"UnparsedAddress": "309 - 257 HEMLOCK STREET, Waterloo, Ontario N2L0K2"
+"Coordinates": array:2 [
0 => -80.532334
1 => 43.475918
]
+"Latitude": 43.475918
+"Longitude": -80.532334
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright & Modern 1 Bedroom w/ Large Bathroom Condo Unit Comes Fully Furnished In The Heart of Waterloo! Beautiful East Views From TheLiving Space that Walks-Out To A Large Balcony. This Condominium Building is Peace & Very Well Maintained. Condo Amenities Include: LoungeRoom, Study Room, Exercise Room, Large Rooftop Terrace for Entertainment, Visitor's Parking & Security System. It is Near to RenownedUniversity of Waterloo & Wilfred Laurier University. Waterloo/Kitchener has Many Notable Companies Such As Google, OpenText, Manulife, Sunlife, Rimowa & More! This is A Very Nice Place to Live with Steps to Top Schools, Parks, Groceries, Library, Restaurants, Shop & More! (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T18:59:37.339001+00:00"
+"Directions": "Cross Streets: University Avenue West & Hemlock Street. ** Directions: University Avenue West & HemlockStreet."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Electric"
1 => "Coil Fan"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2009590"
+"ListOfficeKey": "50730"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T17:16:18Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T17:16:18Z"
+"StreetName": "Hemlock"
+"StreetNumber": "257"
+"StreetSuffix": "Street"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/309_257_hemlock_st_waterloo_on/"
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1672010265"
"RoomType" => "Dining room"
"ListingId" => "X13505152"
"RoomLevel" => "Main level"
"RoomWidth" => 2.88
"ListingKey" => "29971101"
"RoomLength" => 1.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:18.27Z"
]
1 => array:11 [
"RoomKey" => "1672010266"
"RoomType" => "Living room"
"ListingId" => "X13505152"
"RoomLevel" => "Main level"
"RoomWidth" => 2.49
"ListingKey" => "29971101"
"RoomLength" => 2.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:18.27Z"
]
2 => array:11 [
"RoomKey" => "1672010267"
"RoomType" => "Kitchen"
"ListingId" => "X13505152"
"RoomLevel" => "Main level"
"RoomWidth" => 3.72
"ListingKey" => "29971101"
"RoomLength" => 1.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:18.27Z"
]
3 => array:11 [
"RoomKey" => "1672010268"
"RoomType" => "Bedroom"
"ListingId" => "X13505152"
"RoomLevel" => "Main level"
"RoomWidth" => 3.12
"ListingKey" => "29971101"
"RoomLength" => 2.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:18.27Z"
]
4 => array:11 [
"RoomKey" => "1672010269"
"RoomType" => "Bathroom"
"ListingId" => "X13505152"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29971101"
"RoomLength" => 2.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-30T17:16:18.27Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29971101/309-257-hemlock-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard (519) 620-8778 X 147"
+"GeocodeManualYN": false
+"TotalActualRent": 1850
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 499
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-30T16:58:33.5Z"
+"ListAgentNationalAssociationId": "1291277"
+"ListOfficeNationalAssociationId": "1093338"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29971101_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/6aac76366f78e043226765c190ce497a.webp"
"MediaSize" => 119856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-6aac76366f78e043226765c190ce497a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29971101_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/e4066367ee9d1c8de1eb3981c72fd37d.webp"
"MediaSize" => 108743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-e4066367ee9d1c8de1eb3981c72fd37d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29971101_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/f1eed4eae3af98858afdf78809981cde.webp"
"MediaSize" => 100436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-f1eed4eae3af98858afdf78809981cde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29971101_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/249197f41c6f507327730493e3acbcd5.webp"
"MediaSize" => 105396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-249197f41c6f507327730493e3acbcd5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29971101_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/e1330bcd98a3f360cba614dd94c77513.webp"
"MediaSize" => 52847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-e1330bcd98a3f360cba614dd94c77513.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29971101_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/11bcbe4c86709d501ba52ff7c0dc7ab3.webp"
"MediaSize" => 43578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-11bcbe4c86709d501ba52ff7c0dc7ab3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29971101_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/5cb5c386e6b5cde7e9714e952cace9ea.webp"
"MediaSize" => 59484
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-5cb5c386e6b5cde7e9714e952cace9ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29971101_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/f7728a91dd72bb29920d8e9640759ab7.webp"
"MediaSize" => 78635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-f7728a91dd72bb29920d8e9640759ab7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29971101_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/2eec40b84a61cea21afc91a5cf681ef6.webp"
"MediaSize" => 68077
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-2eec40b84a61cea21afc91a5cf681ef6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29971101_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/ded1cb0c350e0e4d91d1308dfe83bbf2.webp"
"MediaSize" => 86806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-ded1cb0c350e0e4d91d1308dfe83bbf2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29971101_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/b0a2f39e911a01397a42552df77d6090.webp"
"MediaSize" => 87312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-b0a2f39e911a01397a42552df77d6090.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29971101_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/e595160172e3ce04b6b94b9077d64f31.webp"
"MediaSize" => 72469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-e595160172e3ce04b6b94b9077d64f31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29971101_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/67cc7b29dcb249b51e70e8c08e9091de.webp"
"MediaSize" => 66703
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-67cc7b29dcb249b51e70e8c08e9091de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29971101_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/2003fcf2690fe2a6257cf4eb23b5965e.webp"
"MediaSize" => 69297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-2003fcf2690fe2a6257cf4eb23b5965e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29971101_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/05bb47d8991ec33c99317f27818b8163.webp"
"MediaSize" => 137927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-05bb47d8991ec33c99317f27818b8163.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29971101_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/5027a9924be344644e25bee22c19051e.webp"
"MediaSize" => 131270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-5027a9924be344644e25bee22c19051e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29971101_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/dfa8d70fdf32cdb1ea0be185260759e9.webp"
"MediaSize" => 129446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-dfa8d70fdf32cdb1ea0be185260759e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29971101_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/7794c228b767f0aeadc7dfa78ecf244e.webp"
"MediaSize" => 82281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-7794c228b767f0aeadc7dfa78ecf244e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
"ModificationTimestamp" => "2026-06-30T16:58:33.51Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29971101_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29971101/6a41a7cda45ee7a9c1e48c6abe6cdcfa.webp"
"MediaSize" => 68592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29971101/thumbnail-6a41a7cda45ee7a9c1e48c6abe6cdcfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13505152"
"ResourceRecordKey" => "29971101"
…1
]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29971101')"
+"ID": "1579583"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25309
+post_id: "1578608"
+post_author: 1
+"ListingKey": "29970695"
+"ListingId": "40843403"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T16:20:02Z"
+"RFModificationTimestamp": "2026-06-30T16:43:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 963.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0B3"
+"UnparsedAddress": "223 W ERB Street W Unit# 704, Waterloo, Ontario N2L0B3"
+"Coordinates": array:2 [
0 => -80.5363682
1 => 43.4591695
]
+"Latitude": 43.4591695
+"Longitude": -80.5363682
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully designed 2 bedroom, 2 bathroom condo that features a spacious eat-in kitchen perfect for both everyday living and entertaining. Boasting an abundance of cabinet space, sleek quartz countertops, and stainless steel appliances, this kitchen is as functional as it is stylish. The open-concept layout flows seamlessly into the bright and inviting living room, where patio doors lead out to your private balcony— ideal for morning coffee or evening relaxation. Both bedrooms have large windows, allowing in lots of natural light and the main bathroom is complete with a walk-in shower. The large primary bedroom is a true retreat, featuring a convenient walk-through closet and a luxurious 5-piece ensuite complete with a double vanity, soaker tub, and separate shower. The amenities in the Westmount Grand include a rooftop terrace complete with BBQ's, a party room, a library/piano room, a large gym with saunas, and a bike room. Conveniently located beside the mosque (Muslim Society of Waterloo Wellington Counties) and close to restaurants, shops, parks, all amenities, and universities. Don’t miss your chance to own this beautiful condo—whether you're a first-time buyer or looking to downsize, it’s the perfect fit. Schedule your private showing today and see all that this property has to offer! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T16:43:04.481465+00:00"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130785"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-30T16:11:42Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T16:11:42Z"
+"Stories": "18.0"
+"StreetDirPrefix": "West"
+"StreetDirSuffix": "West"
+"StreetName": "ERB"
+"StreetNumber": "223"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29970695/223-w-erb-street-w-unit-704-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2250
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 963
+"OriginalEntryTimestamp": "2026-06-30T16:11:29.54Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1383619"
+"ListOfficeNationalAssociationId": "1381240"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970695')"
+"ID": "1578608"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "1578587"
+post_author: 1
+"ListingKey": "29970594"
+"ListingId": "X13504834"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T18:30:13Z"
+"RFModificationTimestamp": "2026-06-30T18:41:47Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4T2"
+"UnparsedAddress": "611 - 30 BLUE SPRINGS DRIVE, Waterloo, Ontario N2J4T2"
+"Coordinates": array:2 [
0 => -80.526045
1 => 43.488822
]
+"Latitude": 43.488822
+"Longitude": -80.526045
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful upgraded condo with water view from kitchen living and both bedrooms. Discover the perfect blend of tranquility & convenience in this sought-after building, ideally located near Uptown Waterloo. Near an abundance of restaurants, shops, and amenities including Conestoga Mall & 3 grocery stores that are within a few minutes walk. West-facing view to enjoy stunning sunsets & warm, natural sunlight throughout the day. Nestled around kilometers of trails, ponds& streams. Close to the expressway, Conestoga College & both U of W & Wilfrid Laurier Universities. Conveniently located near the LRT station & a bus stop at King & Blue Springs Dr make commuting a breeze. Near the charming town of St. Jacob's & its famous Farmer's Market &Waterloo Park, perfect for outdoor activities & relaxation. This spacious condo boasts floor-to-ceiling window in the living room, providing beautiful views of the surrounding area. Enjoy new flooring throughout, an efficient galley kitchen, new stove, ample counter space &storage, a separate dining area, 2 generously sized bedrooms, & 2 full baths. Also includes in-suite laundry, allowing for ultimate convenience. 1underground parking, with the option to rent an additional parking spot if needed. Take advantage of a wide range of building amenities, including controlled entry, newly updated balconies, a touch screen directory, elevators, a library, rooftop lounge with sun deck & gas BBQ for residents, a lower level party room to rent for a small fee, both equipped with kitchens & restrooms. The pond has a pergola & coal BBQ for gatherings. plenty of visitor parking spots, Brand new Hvac unit installed june 2026 . hydro extra (id:62783)"
+"Appliances": array:3 [
0 => "Water meter"
1 => "Intercom"
2 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-06-30T16:22:37.312064+00:00"
+"Directions": "King Street North"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600034"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Wheelchair access"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
4 => "Atrium/Sunroom"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-30T15:55:12Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T18:16:28Z"
+"StreetName": "Blue Springs"
+"StreetNumber": "30"
+"StreetSuffix": "Drive"
+"VirtualTourURLUnbranded": "https://virtualtours.jarts360view.com/cp/30-blue-springs-drive-unit-611-waterloo/"
+"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/29970594/611-30-blue-springs-drive-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Sanderson Property"
+"GeocodeManualYN": false
+"TotalActualRent": 2795
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-30T15:55:12.33Z"
+"ListAgentNationalAssociationId": "1157959"
+"ListOfficeNationalAssociationId": "1375388"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970594')"
+"ID": "1578587"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+post_id: "1578861"
+post_author: 1
+"ListingKey": "29970326"
+"ListingId": "X13504480"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T15:25:14Z"
+"RFModificationTimestamp": "2026-06-30T16:00:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "504 - 158 KING STREET N, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.523574
1 => 43.471807
]
+"Latitude": 43.471807
+"Longitude": -80.523574
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To 158 King St N Located In A Prime Location Of Downtown Waterloo! This Spacious Corner 3Br Unit Offers Large Windows, Lots Of Natural Light.9 Ft Ceilings. Custom Kitchen Cabinetry. Fully Furnished Appliance, Ensuite Laundry (brand new), 3 Great Size Bdrms & 2 Full Baths, Newly upgraded Vinyl flooring! 5 minutes walk to Wilfrid Laurier University, 5 min bus to University Of Waterloo, Uw Tech. Park, Shops, Restaurants And More! Perfect Opportunity to Invest In One Of The Fastest Growing Communities In Waterloo! Tenant Requirements: One occupant/student per bedroom only. Tenant required to pay all Hydro Charges. Each occupant must provide a qualified guarantor, along with first and last month's rent. No pets permitted. A refundable $500 security deposit per occupant is required and will be returned at the conclusion of the lease term, subject to the unit being maintained in good condition. A refundable key FOB deposit of $125 per FOB is also required and will be returned upon surrender of the FOB at the end of the tenancy. Rent is payable on the first day of each month. Two underground parking spaces are available at an additional cost of $150 per month, per space. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T16:00:17.814800+00:00"
+"Directions": "King St N / University Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188517"
+"ListOfficeKey": "277403"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-30T15:16:27Z"
+"PhotosCount": 16
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T15:16:27Z"
+"StreetDirSuffix": "North"
+"StreetName": "King"
+"StreetNumber": "158"
+"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/29970326/504-158-king-street-n-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2132538"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Grand River Property Management Inc. 519-778-5986"
+"CoListAgentKey2": "2224422"
+"CoListOfficeKey": "277403"
+"GeocodeManualYN": false
+"TotalActualRent": 3300
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"CoListOfficeKey2": "277403"
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-30T15:16:27.5Z"
+"ListAgentNationalAssociationId": "1437568"
+"ListOfficeNationalAssociationId": "1282893"
+"CoListAgentNationalAssociationId": "1385216"
+"CoListAgentNationalAssociationId2": "1467766"
+"CoListOfficeNationalAssociationId": "1282893"
+"CoListOfficeNationalAssociationId2": "1282893"
+"Media": array:16 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970326')"
+"ID": "1578861"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1578052"
+post_author: 1
+"ListingKey": "29969025"
+"ListingId": "40844016"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T01:25:13Z"
+"RFModificationTimestamp": "2026-06-30T04:40:37Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 691.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J0E5"
+"UnparsedAddress": "160 KING Street N Unit# #1003, Waterloo, Ontario N2J0E5"
+"Coordinates": array:2 [
0 => -80.5233299
1 => 43.4717062
]
+"Latitude": 43.4717062
+"Longitude": -80.5233299
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 160 King Street N, Unit #1003 – a beautifully spacious 2-bedroom, 2-bathroom condo located in the heart of downtown Waterloo! This bright and modern unit features 9 ft ceilings, oversized windows, and an open-concept living and dining area filled with natural light. Enjoy the convenience of in-suite laundry and a layout that’s perfect for families, students, or working professionals. Just steps from Wilfrid Laurier University, the University of Waterloo, the Science Building, shops, restaurants, and more. Excellent public transit and connectivity make this location unbeatable. Don’t miss this fantastic opportunity to live in one of Waterloo’s most sought-after locations! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:7 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Water"
5 => "Insurance"
6 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T04:40:34.779512+00:00"
+"Directions": "Intersection of Noecker ST and King ST"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104481"
+"ListOfficeKey": "292713"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "None"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-30T01:19:37Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T01:19:37Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "KING"
+"StreetNumber": "160"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29969025/160-king-street-n-unit-1003-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2200
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 691
+"OriginalEntryTimestamp": "2026-06-30T01:19:36.91Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1373851"
+"ListOfficeNationalAssociationId": "1416387"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29969025')"
+"ID": "1578052"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1577423"
+post_author: 1
+"ListingKey": "29968865"
+"ListingId": "40843767"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T19:30:08Z"
+"RFModificationTimestamp": "2026-06-30T19:36:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1373.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4S3"
+"UnparsedAddress": "6 WILLOW Street, Waterloo, Ontario N2J4S3"
+"Coordinates": array:2 [
0 => -80.5166824
1 => 43.4655444
]
+"Latitude": 43.4655444
+"Longitude": -80.5166824
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Newly renovated 2-bedroom plus solarium suite located at The Waterpark Place, 6 Willow Street, in the heart of Waterloo. This prime location is within walking distance to trails, transit, Uptown restaurants, a hospital, and boutique shops, offering an active and convenient urban lifestyle. Bright, spacious suite with panoramic city views and lush treetop canopy outlooks, offering beautiful day-to-night scenery. Elegant blend of comfort and function with wood flooring throughout and a full wall of windows providing abundant natural light. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T00:44:48.882869+00:00"
+"Directions": "Erb Street East to Willow Street"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1601823"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "No Pet Home"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-30T00:11:42Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T19:20:23Z"
+"Stories": "1.0"
+"StreetName": "WILLOW"
+"StreetNumber": "6"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "4713"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29968865/6-willow-street-unit-1004-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2750
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "RMU-81"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1373
+"OriginalEntryTimestamp": "2026-06-30T00:10:11.57Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1158319"
+"ListOfficeNationalAssociationId": "1004357"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968865')"
+"ID": "1577423"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: "1577112"
+post_author: 1
+"ListingKey": "29967642"
+"ListingId": "40843788"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T20:20:08Z"
+"RFModificationTimestamp": "2026-06-29T23:03:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2K3"
+"UnparsedAddress": "151 BRIDGEPORT Road E Unit# 4, Waterloo, Ontario N2J2K3"
+"Coordinates": array:2 [
0 => -80.5089956
1 => 43.4711627
]
+"Latitude": 43.4711627
+"Longitude": -80.5089956
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to unit 4 of 151 Brideport Road, Waterloo. This modern and spacious apartment is perfect for families, professionals, or corporate rentals and is available immediately with a minimum one-year lease. Located in a newer building, this top-floor unit offers 1,500 sq. ft. of bright and comfortable living space, complete with 5 bedrooms and 2 bathrooms. The open-concept design features a large common area that flows seamlessly into the kitchen, creating an inviting space for both relaxation and entertaining. With windows on all four sides and a Juliet balcony, the apartment is flooded with natural light, enhancing its warm and welcoming atmosphere. Convenience and comfort are at the heart of this unit. It comes equipped with in-suite laundry for added ease and includes one dedicated parking spot. The apartment is carpet-free and features central air conditioning, a private furnace, and a water heater with in-unit heating control, allowing you to customize your comfort year-round. The location couldn’t be more ideal. Just a short walk to Bridgeport Supercenter, you’ll find a variety of shops and services, including Walmart, Tim Hortons, Shoppers Drug Mart, the Dollar Store, and Bulk Barn. The building is also situated on a bus route that provides direct access to local universities, making it a great option for students. For those who commute, the proximity to major highways ensures quick and easy travel. This small building houses only four apartments, offering a quieter and more private living experience. The no-pets and no-smoking policy ensures a clean and peaceful environment for all residents. With its thoughtful design, prime location, and bright interior, this unit is an excellent choice for anyone looking for a well-maintained and convenient place to live. Book your showing today and see all that this beautiful apartment has to offer. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T23:03:42.456826+00:00"
+"Directions": "ELLIS CR N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Shared Driveway"
3 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-29T20:10:29Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T20:10:29Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "BRIDGEPORT"
+"StreetNumber": "151"
+"StreetSuffix": "Road"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29967642/151-bridgeport-road-e-unit-4-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2700
+"ZoningDescription": "R-1"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2026-06-29T20:10:29.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967642')"
+"ID": "1577112"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1576730"
+post_author: 1
+"ListingKey": "29967889"
+"ListingId": "X13502408"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T23:20:13Z"
+"RFModificationTimestamp": "2026-06-29T23:24:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J2K3"
+"UnparsedAddress": "4 - 151 BRIDGEPORT ROAD E, Waterloo, Ontario N2J2K3"
+"Coordinates": array:2 [
0 => -80.508934
1 => 43.471083
]
+"Latitude": 43.471083
+"Longitude": -80.508934
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to unit 4 of 151 Brideport Road, Waterloo. This modern and spacious apartment is perfect for families, professionals, or corporate rentals and is available immediately with a minimum one-year lease. Located in a newer building, this top-floor unit offers 1,500 sq. ft. of bright and comfortable living space, complete with 5 bedrooms and 2 bathrooms. The open-concept design features a large common area that flows seamlessly into the kitchen, creating an inviting space for both relaxation and entertaining. With windows on all four sides and a Juliet balcony, the apartment is flooded with natural light, enhancing its warm and welcoming atmosphere. Convenience and comfort are at the heart of this unit. It comes equipped with in-suite laundry for added ease and includes one dedicated parking spot. The apartment is carpet-free and features central air conditioning, a private furnace, and a water heater with in-unit heating control, allowing you to customize your comfort year-round. The location couldn't be more ideal. Just a short walk to Bridgeport Supercenter, you'll find a variety of shops and services, including Walmart, Tim Hortons, Shoppers Drug Mart, the Dollar Store, and Bulk Barn. The building is also situated on a bus route that provides direct access to local universities, making it a great option for students. For those who commute, the proximity to major highways ensures quick and easy travel. This small building houses only four apartments, offering a quieter and more private living experience. The no-pets and no-smoking policy ensures a clean and peaceful environment for all residents. With its thoughtful design, prime location, and bright interior, this unit is an excellent choice for anyone looking for a well-maintained and convenient place to live. Book your showing today and see all that this beautiful apartment has to offer. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T22:48:48.950487+00:00"
+"Directions": "Cross Streets: ELLIS CR N. ** Directions: ELLIS CR N to Bridgeport Road E."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T23:12:48Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T23:12:48Z"
+"StreetDirSuffix": "East"
+"StreetName": "Bridgeport"
+"StreetNumber": "151"
+"StreetSuffix": "Road"
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29967889/4-151-bridgeport-road-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "N/A"
+"GeocodeManualYN": false
+"TotalActualRent": 2700
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-29T20:54:15.59Z"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29967889')"
+"ID": "1576730"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 142
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]