array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29835362 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1481276"
+post_author: 1
+"ListingKey": "29835362"
+"ListingId": "40835440"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:21:15Z"
+"RFModificationTimestamp": "2026-06-02T16:48:59Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 707.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4H4"
+"UnparsedAddress": "225 HARVARD Place Unit# 1105, Waterloo, Ontario N2J4H4"
+"Coordinates": array:2 [
0 => -80.5043917
1 => 43.4833935
]
+"Latitude": 43.4833935
+"Longitude": -80.5043917
+"YearBuilt": 1974
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to 1105-225 Harvard Place! Well, located one bedroom, one bathroom condo suite in Waterloo. This bright, carpet free unit has been recently renovated. Features updated bath, kitchen includes stainless steel appliances, a beautiful back splash, with abundance of cupboard space. Located close to groceries, restaurants, the expressway and so much more. Short walk, drive/bus ride from Wilfrid Laurier University, University of Waterloo and Conestoga College (Waterloo Campus). Amazing amenities included - party room, games room, workshop, sauna, fitness room and tennis courts. Condo fees include all utilities. Book your showing today. (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Heat"
3 => "Electricity"
4 => "Water"
5 => "Insurance"
6 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-01T20:29:05.068431+00:00"
+"Directions": "Lincoln & University"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Metal"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564020"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Laundry- Coin operated"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "None"
]
+"PhotosChangeTimestamp": "2026-06-01T19:50:23Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:10:45Z"
+"StreetName": "HARVARD"
+"StreetNumber": "225"
+"StreetSuffix": "Place"
+"SubdivisionName": "116 - Glenridge/Lincoln Heights"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1649775052"
"RoomType" => "3pc Bathroom"
"ListingId" => "40835440"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29835362"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:10:45.11Z"
]
1 => array:11 [
"RoomKey" => "1649775053"
"RoomType" => "Bedroom"
"ListingId" => "40835440"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29835362"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:10:45.12Z"
]
2 => array:11 [
"RoomKey" => "1649775054"
"RoomType" => "Living room/Dining room"
"ListingId" => "40835440"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29835362"
"RoomLength" => null
"RoomDimensions" => "19'3'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:10:45.13Z"
]
3 => array:11 [
"RoomKey" => "1649775055"
"RoomType" => "Kitchen"
"ListingId" => "40835440"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29835362"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:10:45.13Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29835362/225-harvard-place-unit-1105-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 1750
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "GR"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 707
+"OriginalEntryTimestamp": "2026-06-01T19:50:23.35Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1120111"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29835362_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/8f61109cb13b0fc5e21b51d895c215b0.webp"
"MediaSize" => 129139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-8f61109cb13b0fc5e21b51d895c215b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-story building featuring numerous window units and balconies"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29835362_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/3c0d1fe7f6f2d8461190aa8aeeb0fbf0.webp"
"MediaSize" => 132784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-3c0d1fe7f6f2d8461190aa8aeeb0fbf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Building entrance featuring a prominent awning, glass double doors, a paved drive-through area, and surrounding landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29835362_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/5603d5ce4f5c1d495d5fb21a14fc841b.webp"
"MediaSize" => 88713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-5603d5ce4f5c1d495d5fb21a14fc841b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lobby"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29835362_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/dd01160dd938f37d60fac451f100ae34.webp"
"MediaSize" => 96190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-dd01160dd938f37d60fac451f100ae34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29835362_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/e7cad542d29d7992a0e68bd9a36dd131.webp"
"MediaSize" => 48177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-e7cad542d29d7992a0e68bd9a36dd131.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front hall entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29835362_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/8b3391dc282f0bb60142c7018127f106.webp"
"MediaSize" => 76540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-8b3391dc282f0bb60142c7018127f106.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29835362_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/31f368d92d37992a2ab91ee142083477.webp"
"MediaSize" => 69847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-31f368d92d37992a2ab91ee142083477.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29835362_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/f8e6cab025ea2ddf3675d30b502612c2.webp"
"MediaSize" => 79616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-f8e6cab025ea2ddf3675d30b502612c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29835362_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/736c8fe784df62af2dac9226c1ecab77.webp"
"MediaSize" => 63523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-736c8fe784df62af2dac9226c1ecab77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29835362_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/0e1833077547e05741c7d26af761a627.webp"
"MediaSize" => 80894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-0e1833077547e05741c7d26af761a627.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29835362_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/2a8ce2ccb7e8a017250a8f417d2aef77.webp"
"MediaSize" => 75071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-2a8ce2ccb7e8a017250a8f417d2aef77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29835362_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/6fb14db326060cd64f88d659f44ffe25.webp"
"MediaSize" => 35286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-6fb14db326060cd64f88d659f44ffe25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, gray subway tile backsplash, stainless steel range, stainless steel range hood, and light-toned countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29835362_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/fba4ac83d67e594da299ea9665dd8679.webp"
"MediaSize" => 34111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-fba4ac83d67e594da299ea9665dd8679.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white shaker-style cabinetry, wood-finish countertops, and a built-in stainless steel sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29835362_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/569c216d1ff44eb7d0aad4b15ccb0a99.webp"
"MediaSize" => 32055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-569c216d1ff44eb7d0aad4b15ccb0a99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen area featuring white shaker-style cabinetry, a double basin stainless steel sink with a high-arch faucet, and wood-finish countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29835362_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/f27288e8086a0fbd77fd240a58e6a791.webp"
"MediaSize" => 29660
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-f27288e8086a0fbd77fd240a58e6a791.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29835362_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/f586aff7630ff44e88567af720ef37e5.webp"
"MediaSize" => 61984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-f586aff7630ff44e88567af720ef37e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29835362_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/140d2c0748da4c01750ce8245d2ab731.webp"
"MediaSize" => 45916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-140d2c0748da4c01750ce8245d2ab731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29835362_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/40f8b80dfc75f1e4de99910c265fa534.webp"
"MediaSize" => 52840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-40f8b80dfc75f1e4de99910c265fa534.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29835362_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/49275346a360e4a87d9d4cc87743d866.webp"
"MediaSize" => 28206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-49275346a360e4a87d9d4cc87743d866.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vanity with integrated sink, chrome faucet, and expansive mirror with overhead lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29835362_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/11f91066e084d55d231905d24e99b4a0.webp"
"MediaSize" => 25765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-11f91066e084d55d231905d24e99b4a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Shower with white acrylic surround, integrated shelving, handheld showerhead, adjustable slide bar, and polished chrome fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29835362_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/1bcdcd25c08739cf545a51fae23d00e0.webp"
"MediaSize" => 33612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-1bcdcd25c08739cf545a51fae23d00e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in shower with clear glass door, chrome fixtures, and integrated shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29835362_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/430c7c1d95406d64baa46d9437f843eb.webp"
"MediaSize" => 66518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-430c7c1d95406d64baa46d9437f843eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Enclosed balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29835362_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/59b8ff053eda0285f6519886673b44cc.webp"
"MediaSize" => 61053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-59b8ff053eda0285f6519886673b44cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29835362_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/671d4e9bba08e098f73e7e2ea4ca73f6.webp"
"MediaSize" => 40695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-671d4e9bba08e098f73e7e2ea4ca73f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Games room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29835362_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/fddc7c816755af3f1c14c982053c2d7d.webp"
"MediaSize" => 56748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-fddc7c816755af3f1c14c982053c2d7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Party room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29835362_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/32d62a3cc98e2f5edd362c7197b333f3.webp"
"MediaSize" => 55834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-32d62a3cc98e2f5edd362c7197b333f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29835362_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/e8ccc3b28007f0c0162779aeef1e166c.webp"
"MediaSize" => 61918
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-e8ccc3b28007f0c0162779aeef1e166c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29835362_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/45869dc439d887637a3be08639205300.webp"
"MediaSize" => 64810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-45869dc439d887637a3be08639205300.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29835362_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/fc92f51cedf3e6b98d6acc5f3a431e75.webp"
"MediaSize" => 112964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-fc92f51cedf3e6b98d6acc5f3a431e75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29835362_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/e4c5cd612cab5da1c60e77b1f2c8e0b5.webp"
"MediaSize" => 97027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-e4c5cd612cab5da1c60e77b1f2c8e0b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sauna"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29835362_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29835362/ab9200271f123fb896096d7caa166658.webp"
"MediaSize" => 56002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29835362/thumbnail-ab9200271f123fb896096d7caa166658.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gym"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835440"
"ResourceRecordKey" => "29835362"
"ModificationTimestamp" => "2026-06-01T19:50:23.36Z"
]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29835362')"
+"ID": "1481276"
}
]
+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 289722" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24759
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564020" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24844
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29835362'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25152
+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 '29835362'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25168
+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 '29835362' 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.5043917 43.4833935)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25221
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1538204"
+post_author: 1
+"ListingKey": "29914403"
+"ListingId": "X13454290"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T12:25:14Z"
+"RFModificationTimestamp": "2026-06-17T13:47:33Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0E9"
+"UnparsedAddress": "406 - 318 SPRUCE STREET, Waterloo, Ontario N2L0E9"
+"Coordinates": array:2 [
0 => -80.526389
1 => 43.479
]
+"Latitude": 43.479
+"Longitude": -80.526389
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "***Fully Furnished 1-Bedroom Unit - Luxury Sage Living***Perfect for students and professionals alike, this beautifully furnished 1-bedroom suite offers modern comfort in a prime location*** Just minutes from the University of Waterloo, Wilfrid Laurier University, and Conestoga College, with easy access to multiple public transit routes***Enjoy a bright and stylish living space featuring high ceilings, laminate flooring throughout, and a walkout balcony***The contemporary kitchen is equipped with granite countertops and stainless steel appliances, perfect for everyday living***Additional highlights include free Wi-Fi and a spacious storage room conveniently located on the same floor-ideal for all your extra belongings***A perfect blend of convenience, comfort, and luxury living!*** (id:62650)"
+"Appliances": array:2 [
0 => "All"
1 => "Furniture"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:47:25.710154+00:00"
+"Directions": "King/Hickory"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1406342"
+"ListOfficeKey": "50115"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T12:16:42Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T12:16:42Z"
+"StreetName": "Spruce"
+"StreetNumber": "318"
+"StreetSuffix": "Street"
+"View": "View"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1661039429"
"RoomType" => "Living room"
"ListingId" => "X13454290"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29914403"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T12:16:42.27Z"
]
1 => array:11 [
"RoomKey" => "1661039430"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13454290"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29914403"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T12:16:42.28Z"
]
2 => array:11 [
"RoomKey" => "1661039431"
"RoomType" => "Kitchen"
"ListingId" => "X13454290"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29914403"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-17T12:16:42.28Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29914403/406-318-spruce-street-waterloo"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"TotalActualRent": 1600
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-17T12:16:42.21Z"
+"ListAgentNationalAssociationId": "1107138"
+"ListOfficeNationalAssociationId": "1002581"
+"Media": array:27 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29914403_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/654a9e2b4270f91e77850bb89e8f9447.webp"
"MediaSize" => 128418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-654a9e2b4270f91e77850bb89e8f9447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29914403_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/6b2d680a8226693b009a9c8316a1df6d.webp"
"MediaSize" => 147200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-6b2d680a8226693b009a9c8316a1df6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29914403_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/13beb077fe87f2846322e5f57895f211.webp"
"MediaSize" => 24795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-13beb077fe87f2846322e5f57895f211.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29914403_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/aa0bd5571d7c5c1c5dd8fd1d73c30a20.webp"
"MediaSize" => 24833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-aa0bd5571d7c5c1c5dd8fd1d73c30a20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29914403_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/decc4adb3541aacb5bec73bbea8e0efc.webp"
"MediaSize" => 46850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-decc4adb3541aacb5bec73bbea8e0efc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29914403_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/f46633bc8fc777b934314ad9a3c89eb3.webp"
"MediaSize" => 26700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-f46633bc8fc777b934314ad9a3c89eb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29914403_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/1761f4fe5f8453392a7623bfe4f3388e.webp"
"MediaSize" => 124181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-1761f4fe5f8453392a7623bfe4f3388e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29914403_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/de9b5a64f7c318314d148142d738dd9d.webp"
"MediaSize" => 142900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-de9b5a64f7c318314d148142d738dd9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29914403_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/d847db757626f9ebf70af392a2ebe5dd.webp"
"MediaSize" => 121608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-d847db757626f9ebf70af392a2ebe5dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29914403_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/5950f457ba4a6b4cc659b667bc67f36d.webp"
"MediaSize" => 129513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-5950f457ba4a6b4cc659b667bc67f36d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29914403_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/ac5b481b3b4ffc76c0cd7181200098bd.webp"
"MediaSize" => 111719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-ac5b481b3b4ffc76c0cd7181200098bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29914403_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/be5b93cf14d35f93a04ab6f4170d1d0b.webp"
"MediaSize" => 78907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-be5b93cf14d35f93a04ab6f4170d1d0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29914403_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/397633533689a9ffb249f0ee45616f3a.webp"
"MediaSize" => 69188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-397633533689a9ffb249f0ee45616f3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29914403_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/06ec2c5d18fdf58cd774430decaf96a9.webp"
"MediaSize" => 108471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-06ec2c5d18fdf58cd774430decaf96a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29914403_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/0b4c70af11b7423e281d4c0fde634802.webp"
"MediaSize" => 96196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-0b4c70af11b7423e281d4c0fde634802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29914403_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/9177b8e9dc8c6f914335e5f55bd12a5a.webp"
"MediaSize" => 77771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-9177b8e9dc8c6f914335e5f55bd12a5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29914403_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/0020e05f0e8293c28c3d12f93040e575.webp"
"MediaSize" => 116413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-0020e05f0e8293c28c3d12f93040e575.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29914403_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/d5c23f3f369978f0ccc32ae1fd2a4cc8.webp"
"MediaSize" => 67279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-d5c23f3f369978f0ccc32ae1fd2a4cc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29914403_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/ccd3a5be6449b9027dbc0a413fcd5b4c.webp"
"MediaSize" => 23157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-ccd3a5be6449b9027dbc0a413fcd5b4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Premium Locker"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29914403_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/78c0b49e55edd7a2403e5dfe9b86669e.webp"
"MediaSize" => 55170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-78c0b49e55edd7a2403e5dfe9b86669e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Premium Locker"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29914403_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/451b0bd420c843f54dafbeca7283b6fe.webp"
"MediaSize" => 54392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-451b0bd420c843f54dafbeca7283b6fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Premium Locker"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29914403_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/b7c7dfbc8a94a44bb74ce53269238952.webp"
"MediaSize" => 34886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-b7c7dfbc8a94a44bb74ce53269238952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29914403_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/0a08551cf404573a6467eb67435d3aa8.webp"
"MediaSize" => 47324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-0a08551cf404573a6467eb67435d3aa8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29914403_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/33173182f4be6e526b08900bbd3aefc2.webp"
"MediaSize" => 63933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-33173182f4be6e526b08900bbd3aefc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29914403_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/f526397a494a1845443d62c8d9f54ef2.webp"
"MediaSize" => 63738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-f526397a494a1845443d62c8d9f54ef2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29914403_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/e801852546768f47585cb6250866c956.webp"
"MediaSize" => 60448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-e801852546768f47585cb6250866c956.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29914403_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914403/d1fc4b1511f7862a12dcbf13f0ca3816.webp"
"MediaSize" => 65064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914403/thumbnail-d1fc4b1511f7862a12dcbf13f0ca3816.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13454290"
"ResourceRecordKey" => "29914403"
"ModificationTimestamp" => "2026-06-17T12:16:42.22Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914403')"
+"ID": "1538204"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "1530280"
+post_author: 1
+"ListingKey": "29902640"
+"ListingId": "40839596"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:20:07Z"
+"RFModificationTimestamp": "2026-06-15T19:20:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.192
+"LivingArea": 1600.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K1M6"
+"UnparsedAddress": "19 HAMEL Avenue, Kitchener, Ontario N2K1M6"
+"Coordinates": array:2 [
0 => -80.4854346
1 => 43.4749643
]
+"Latitude": 43.4749643
+"Longitude": -80.4854346
+"YearBuilt": 1960
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 19 Hamel Ave (Main Unit and partial basement) – an Immaculate 3 Bedroom Home located in East Waterloo. This Bright & Spacious home has been FULLY renovated and is located in the perfect spot with easy access to the highway, stores, shops and more. The main floor offers 3 spacious bedrooms, a bright open kitchen, and a fully renovated bathroom. Downstairs is a laundry area, a large recroom and a remodelled bathroom. There is a large open backyard that is shared space, while each unit has their own concrete patio to enjoy. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:42:45.710134+00:00"
+"Directions": "Lancaster St. N. to Hamel"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2085320"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.192"
+"PhotosChangeTimestamp": "2026-06-15T12:10:38Z"
+"PhotosCount": 10
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T19:11:11Z"
+"Stories": "1.0"
+"StreetName": "HAMEL"
+"StreetNumber": "19"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1660040518"
"RoomType" => "Laundry room"
"ListingId" => "40839596"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29902640"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:11:11.97Z"
]
1 => array:11 [
"RoomKey" => "1660040519"
"RoomType" => "Recreation room"
"ListingId" => "40839596"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29902640"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:11:11.97Z"
]
2 => array:11 [
"RoomKey" => "1660040520"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839596"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29902640"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:11:11.97Z"
]
3 => array:11 [
"RoomKey" => "1660040521"
"RoomType" => "5pc Bathroom"
"ListingId" => "40839596"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902640"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:11:11.97Z"
]
4 => array:11 [
"RoomKey" => "1660040522"
"RoomType" => "Bedroom"
"ListingId" => "40839596"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902640"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:11:11.97Z"
]
5 => array:11 [
"RoomKey" => "1660040523"
"RoomType" => "Bedroom"
"ListingId" => "40839596"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902640"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:11:11.97Z"
]
6 => array:11 [
"RoomKey" => "1660040524"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839596"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902640"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:11:11.97Z"
]
7 => array:11 [
"RoomKey" => "1660040525"
"RoomType" => "Family room"
"ListingId" => "40839596"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902640"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:11:11.97Z"
]
8 => array:11 [
"RoomKey" => "1660040526"
"RoomType" => "Kitchen"
"ListingId" => "40839596"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29902640"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 15'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-15T19:11:11.97Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902640/19-hamel-avenue-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563756"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289722"
+"GeocodeManualYN": true
+"TotalActualRent": 2350
+"ZoningDescription": "RES2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 950
+"BelowGradeFinishedArea": 650
+"OriginalEntryTimestamp": "2026-06-15T12:10:37.9Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1358718"
+"ListOfficeNationalAssociationId": "1004370"
+"CoListAgentNationalAssociationId": "1069793"
+"CoListOfficeNationalAssociationId": "1380559"
+"Media": array:10 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29902640_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/18dc050d04e3e89d47e5e14db8983952.webp"
"MediaSize" => 134183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-18dc050d04e3e89d47e5e14db8983952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29902640_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/3922904933d24eaea898edcba0ae67a1.webp"
"MediaSize" => 36984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-3922904933d24eaea898edcba0ae67a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29902640_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/0a10fdca1778aa6280adb1706dddbed5.webp"
"MediaSize" => 43490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-0a10fdca1778aa6280adb1706dddbed5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29902640_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/24b874e85e602538f2911a9871de5aba.webp"
"MediaSize" => 85147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-24b874e85e602538f2911a9871de5aba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29902640_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/e2af2de51381506b05a5540fb1be82bf.webp"
"MediaSize" => 78142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-e2af2de51381506b05a5540fb1be82bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29902640_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/de8da911585ddc3fa43e42a80d791441.webp"
"MediaSize" => 36119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-de8da911585ddc3fa43e42a80d791441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29902640_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/97347a3dd85a5d8e7f6208da403c370f.webp"
"MediaSize" => 76634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-97347a3dd85a5d8e7f6208da403c370f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29902640_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/452bd46f046ea5f3bd1d2002c1f728cd.webp"
"MediaSize" => 111357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-452bd46f046ea5f3bd1d2002c1f728cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29902640_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/99a5d0fc063631dc6a31a757b34faec7.webp"
"MediaSize" => 44910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-99a5d0fc063631dc6a31a757b34faec7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29902640_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902640/ee80e84504697852b2ce827b938f15e2.webp"
"MediaSize" => 69350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902640/thumbnail-ee80e84504697852b2ce827b938f15e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839596"
"ResourceRecordKey" => "29902640"
"ModificationTimestamp" => "2026-06-15T12:10:37.91Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902640')"
+"ID": "1530280"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1530284"
+post_author: 1
+"ListingKey": "29902771"
+"ListingId": "X13443776"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:30:17Z"
+"RFModificationTimestamp": "2026-06-15T20:31:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K1M6"
+"UnparsedAddress": "19 HAMEL AVENUE, Waterloo, Ontario N2K1M6"
+"Coordinates": array:2 [
0 => -80.485547
1 => 43.474699
]
+"Latitude": 43.474699
+"Longitude": -80.485547
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 19 Hamel Ave (Main Unit and partial basement) - an Immaculate 3 Bedroom Home located in East Waterloo. This Bright & Spacious home has been FULLY renovated and is located in the perfect spot with easy access to the highway, stores, shops and more. The main floor offers 3 spacious bedrooms, a bright open kitchen, and a fully renovated bathroom. Downstairs is a laundry area, a large recroom and a remodelled bathroom. There is a large open backyard that is shared space, while each unit has their own concrete patio to enjoy. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:33:48.426368+00:00"
+"Directions": "Cross Streets: Lancaster. ** Directions: Lancaster St W to Hamel Ave."
+"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": "2104045"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T12:48:28Z"
+"PhotosCount": 10
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:22:58Z"
+"Stories": "1.0"
+"StreetName": "Hamel"
+"StreetNumber": "19"
+"StreetSuffix": "Avenue"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1660090837"
"RoomType" => "Kitchen"
"ListingId" => "X13443776"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "29902771"
"RoomLength" => 4.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T20:22:58.06Z"
]
1 => array:11 [
"RoomKey" => "1660090838"
"RoomType" => "Living room"
"ListingId" => "X13443776"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29902771"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T20:22:58.06Z"
]
2 => array:11 [
"RoomKey" => "1660090839"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13443776"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29902771"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T20:22:58.07Z"
]
3 => array:11 [
"RoomKey" => "1660090840"
"RoomType" => "Bedroom 2"
"ListingId" => "X13443776"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29902771"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T20:22:58.07Z"
]
4 => array:11 [
"RoomKey" => "1660090841"
"RoomType" => "Bedroom 3"
"ListingId" => "X13443776"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "29902771"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T20:22:58.07Z"
]
5 => array:11 [
"RoomKey" => "1660090842"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13443776"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.71
"ListingKey" => "29902771"
"RoomLength" => 5.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T20:22:58.08Z"
]
6 => array:11 [
"RoomKey" => "1660090843"
"RoomType" => "Laundry room"
"ListingId" => "X13443776"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.21
"ListingKey" => "29902771"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T20:22:58.08Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29902771/19-hamel-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2350
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-15T12:48:28.32Z"
+"ListAgentNationalAssociationId": "1373560"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:10 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29902771_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902771/74fba89bec30cf96f261d9769e5b5f56.webp"
"MediaSize" => 309352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902771/thumbnail-74fba89bec30cf96f261d9769e5b5f56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13443776"
"ResourceRecordKey" => "29902771"
"ModificationTimestamp" => "2026-06-15T12:48:28.33Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29902771_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902771/e6e6d5d3b3d7057c2d9b5d636a6b381f.webp"
"MediaSize" => 82372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902771/thumbnail-e6e6d5d3b3d7057c2d9b5d636a6b381f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13443776"
"ResourceRecordKey" => "29902771"
"ModificationTimestamp" => "2026-06-15T12:48:28.33Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29902771_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902771/135885022b401c78d1cd2f693f5270a1.webp"
"MediaSize" => 98773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902771/thumbnail-135885022b401c78d1cd2f693f5270a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13443776"
"ResourceRecordKey" => "29902771"
"ModificationTimestamp" => "2026-06-15T12:48:28.33Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29902771_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902771/3909efc2a331cb2371c53e8cc6333ff7.webp"
"MediaSize" => 181455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902771/thumbnail-3909efc2a331cb2371c53e8cc6333ff7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13443776"
"ResourceRecordKey" => "29902771"
"ModificationTimestamp" => "2026-06-15T12:48:28.33Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29902771_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29902771/dc1c6cb649a03edc99757a0e335cc2d0.webp"
"MediaSize" => 167672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29902771/thumbnail-dc1c6cb649a03edc99757a0e335cc2d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902771')"
+"ID": "1530284"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25218
+post_id: "1528515"
+post_author: 1
+"ListingKey": "29900683"
+"ListingId": "X13441774"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T17:55:09Z"
+"RFModificationTimestamp": "2026-06-13T18:20:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3K9"
+"UnparsedAddress": "199 DIXIE CRESCENT, Waterloo, Ontario N2J3K9"
+"Coordinates": array:2 [
0 => -80.512728
1 => 43.476664
]
+"Latitude": 43.476664
+"Longitude": -80.512728
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious and well-maintained main floor apartment available for lease in a desirable Waterloo neighbourhood. This bright and inviting unit features 3 generously sized bedrooms, 2 full bathrooms, a functional layout with ample living space, and one dedicated parking spot. Ideally located just minutes from Wilfrid Laurier University, the University of Waterloo, and Conestoga College, this home is perfect for families, professionals, faculty, or students seeking convenience and accessibility. Close to schools, parks, shopping, public transit, and major amenities, this move-in-ready residence offers the perfect blend of comfort and location. Move-in ready! (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Oven"
2 => "Dryer"
3 => "Microwave"
4 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T18:20:16.935636+00:00"
+"Directions": "Cross Streets: Carter Ave and Marshall St. ** Directions: University Ave onto Carter Ave, Turn left on Marshall St, Turn left on Dixie."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2191693"
+"ListOfficeKey": "285736"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"LotSizeDimensions": "52 FT"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T17:47:04Z"
+"PhotosCount": 15
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T17:47:04Z"
+"Stories": "1.0"
+"StreetName": "Dixie"
+"StreetNumber": "199"
+"StreetSuffix": "Crescent"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29900683/199-dixie-crescent-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2700
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 52.0
+"OriginalEntryTimestamp": "2026-06-13T17:47:04.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1440755"
+"ListOfficeNationalAssociationId": "1353987"
+"Media": array:15 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29900683')"
+"ID": "1528515"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1525123"
+post_author: 1
+"ListingKey": "29894532"
+"ListingId": "40839265"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T20:20:08Z"
+"RFModificationTimestamp": "2026-06-12T20:20:47Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3W7"
+"UnparsedAddress": "279 PASTERN Trail Unit# Lower Unit, Waterloo, Ontario N2K3W7"
+"Coordinates": array:2 [
0 => -80.4888866
1 => 43.4911387
]
+"Latitude": 43.4911387
+"Longitude": -80.4888866
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautifully designed 2-bedroom basement apartment located at 279 Pastern Trail offers stylish, modern living for young professionals seeking a hassle-free home. This legally built (2021) unit features a modern kitchen with stainless steel appliances, a stackable washer/dryer, and central air. Enjoy low-maintenance living with the landlord handling lawn care and snow removal. One reserved parking space is included, and a small exterior area provides space for outdoor relaxation. Non-smoking and pet-free, this unit is ideal for those who appreciate peace and privacy. With gas and water included, and a corner-lot location close to amenities, this is an opportunity to live in a modern, move-in-ready space tailored for professionals. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Heat"
2 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:04:19.624570+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "No Pet Home"
]
+"PhotosChangeTimestamp": "2026-06-12T20:10:42Z"
+"PhotosCount": 14
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T20:10:42Z"
+"Stories": "1.0"
+"StreetName": "PASTERN"
+"StreetNumber": "279"
+"StreetSuffix": "Trail"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"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/29894532/279-pastern-trail-unit-lower-unit-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1600
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 59.0
+"AboveGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-06-12T14:20:18.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1430151"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:14 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894532')"
+"ID": "1525123"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1520721"
+post_author: 1
+"ListingKey": "29889923"
+"ListingId": "X13432486"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:30:23Z"
+"RFModificationTimestamp": "2026-06-11T20:24:24Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J4Z5"
+"UnparsedAddress": "12C - 139 BRIGHTON STREET, Waterloo, Ontario N2J4Z5"
+"Coordinates": array:2 [
0 => -80.519359
1 => 43.471018
]
+"Latitude": 43.471018
+"Longitude": -80.519359
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Central Lakes Association of REALTORS®"
+"PublicRemarks": "With the feel of a semi, you will find this unique town-house nestled in a quiet area of Waterloo. It boasts two good sized bedrooms, each privately located on separate floors, with the larger master bedroom on the upper (second floor). Included is one exclusive parking space, an additional space can be leased for approx $50 per month. Laundry is on the main floor. Shopping, parks, Laurier University & transit are in walking distance. Easy commute to University of Waterloo. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:24:11.882983+00:00"
+"Directions": "Cross Streets: Noecker St to Brighton St. ** Directions: Weber St N to Noecker St to Brighton St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1788193"
+"ListOfficeKey": "51597"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:22:18Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:22:18Z"
+"Stories": "2.0"
+"StreetName": "Brighton"
+"StreetNumber": "139"
+"StreetSuffix": "Street"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Central Lakes"
+"ListAORKey": "88"
+"ListingURL": "www.realtor.ca/real-estate/29889923/12c-139-brighton-street-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2000
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-06-11T17:22:18.12Z"
+"ListAgentNationalAssociationId": "1189238"
+"ListOfficeNationalAssociationId": "1004585"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889923')"
+"ID": "1520721"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1509402"
+post_author: 1
+"ListingKey": "29874300"
+"ListingId": "40838047"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T03:26:14Z"
+"RFModificationTimestamp": "2026-06-09T04:33:15Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3T1"
+"UnparsedAddress": "209 AUBURN Drive Unit# A, Waterloo, Ontario N2K3T1"
+"Coordinates": array:2 [
0 => -80.4869972
1 => 43.4877142
]
+"Latitude": 43.4877142
+"Longitude": -80.4869972
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "FOR LEASE – AVAILABLE JULY 1, 2026 Charming 3-Bedroom Semi-Detached Townhome in Waterloo's Desirable University Downs Community Welcome to 209A Auburn Drive, Waterloo, a well-maintained and inviting 3-bedroom, 2-bathroom semi-detached townhome located in the highly sought-after University Downs neighbourhood. This bright and spacious home offers a functional layout designed for comfortable family living and everyday convenience. The main living areas provide ample space for relaxing and entertaining, while the well-appointed kitchen offers plenty of storage and workspace. Three generously sized bedrooms and two full bathrooms make this home ideal for families, professionals, or mature students seeking a quiet residential setting. Enjoy easy access to nearby parks, walking trails, shopping, public transit, and a variety of amenities. Families will appreciate the proximity to excellent schools, including Lincoln Heights Public School and Bluevale Collegiate Institute. The home is also conveniently located near both the University of Waterloo and Wilfrid Laurier University. Features: 3 spacious bedrooms 2 bathrooms Bright and functional layout Semi-detached townhome Family-friendly neighbourhood Close to parks, trails, schools, shopping, and transit Minutes from universities and major amenities Available July 1, 2026 Don't miss this opportunity to lease a wonderful home in one of Waterloo's most desirable neighbourhoods. Contact us today to schedule a viewing. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T04:33:12.489792+00:00"
+"Directions": "Pastern Trail"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2169011"
+"ListOfficeKey": "292732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-09T03:19:33Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T03:19:33Z"
+"Stories": "2.0"
+"StreetName": "AUBURN"
+"StreetNumber": "209"
+"StreetSuffix": "Drive"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"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/29874300/209-auburn-drive-unit-a-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2800
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2026-06-09T03:19:33.18Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1419680"
+"ListOfficeNationalAssociationId": "1416806"
+"Media": array:18 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874300')"
+"ID": "1509402"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25219
+post_id: "1500271"
+post_author: 1
+"ListingKey": "29862402"
+"ListingId": "40837185"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T19:15:52Z"
+"RFModificationTimestamp": "2026-06-05T19:41:35Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.396
+"LivingArea": 699.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J1M4"
+"UnparsedAddress": "158 ERB Street E Unit# 33, Waterloo, Ontario N2J1M4"
+"Coordinates": array:2 [
0 => -80.5130622
1 => 43.4682861
]
+"Latitude": 43.4682861
+"Longitude": -80.5130622
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "3-BEDROOM W/ BALCONY AND SEPTEMBER 1ST MOVE IN DATE!!! (Early move-in available). Embrace the perfect blend of modern living and historic charm in this beautifully renovated 3-bedroom, 1-bathroom apartment. Enjoy pristine modern living with updated energy-efficient windows, and a contemporary aesthetic. Features a 4-piece stainless steel appliance package. Offers 3 generous bedrooms, 1 full bathroom, an inviting living space, and a private balcony perfect for your morning coffee. Work-from-Home Ready: Ideal for working professionals or couples looking to utilize the third bedroom as a spacious home office. Convenient on-site laundry equipped with a Coinamatic card system. Dedicated parking spaces are available for rent. UNBEATABLE LOCATION & WALKABILITY(Walk Score: 89/100). Live in a Very Walkable paradise where daily errands do not require a car. You are just steps away from the finest amenities Waterloo has to offer including Transit Hub: A short walk to the Uptown Waterloo ION Light Rail station, connecting you effortlessly to the rest of the Region.Perfect for professionals or academics-walk to Wilfrid Laurier University in 15 minutes, or take a quick 10-minute ION ride directly into the University of Waterloo. Conestoga College (Waterloo Campus) is just a 6-minute bike ride away.Located mere minutes from Bridgeport Plaza (Sobeys, Walmart, retail) and the vibrant heart of Uptown Waterloo’s premier restaurants, cafes, boutiques, and scenic Waterloo Park.Don't miss out on this rare opportunity to secure a premium, spacious rental in one of the city's best neighbourhoods. All walk times are approximate of course! Room measurements are approximate based on iGuide. All iGuide photos and virtual tour are of a neighbouring model unit with floor plan and finishes that are similar if not exactly the same. (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Stove"
]
+"AssociationFeeIncludes": array:5 [
0 => "Exterior Maintenance"
1 => "Property Management"
2 => "Heat"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-05T19:41:30.110679+00:00"
+"Directions": "Take ON-401 W to Bridgeport Rd E in Kitchener. Take the Bridgeport Road W exit from ON-7. Continue on Bridgeport Rd E. Drive to Erb St E in Waterloo."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Shingles"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Hot water radiator heat"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095000"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
3 => "Laundry- Coin operated"
]
+"LotSizeDimensions": "0.396"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-05T19:09:49Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-05T19:09:49Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "ERB"
+"StreetNumber": "158"
+"StreetSuffix": "Street"
+"SubdivisionName": "114 - Uptown Waterloo/North Ward"
+"TaxAnnualAmount": "46924.79"
+"VirtualTourURLUnbranded": "https://youriguide.com/31_158_erb_st_e_waterloo_on/"
+"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/29862402/158-erb-street-e-unit-33-waterloo"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2110
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 108.0
+"AboveGradeFinishedArea": 699
+"OriginalEntryTimestamp": "2026-06-05T19:09:49.4Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1367202"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:12 [
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]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29862402')"
+"ID": "1500271"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25220
+post_id: "1495842"
+post_author: 1
+"ListingKey": "29854429"
+"ListingId": "40836298"
+"PropertyType": "Residential Lease"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T03:00:02Z"
+"RFModificationTimestamp": "2026-06-15T03:02:58Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 847.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2K0G4"
+"UnparsedAddress": "54 W BRIDGE Street W Unit# 1, Kitchener, Ontario N2K0G4"
+"Coordinates": array:2 [
0 => -80.4858805
1 => 43.4839856
]
+"Latitude": 43.4839856
+"Longitude": -80.4858805
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this spacious and well-maintained 2-bedroom, 1-bathroom condo located in a desirable, family-friendly neighbourhood. This bright and inviting unit offers a functional layout, generous living space, and an abundance of storage throughout. Enjoy your own large private patio, perfect for relaxing, entertaining, or enjoying your morning coffee outdoors. Conveniently located close to schools, shopping centres, parks, public transit, and major highways, this home offers easy access to all the amenities you need while maintaining the charm of a quiet residential community. Includes one dedicated parking space and plenty of storage for added convenience. A fantastic opportunity for professionals, couples, or small families looking for a comfortable home in a great location. Don't miss out on this wonderful rental opportunity! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
]
+"AssociationFeeIncludes": array:2 [
0 => "Property Management"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T18:22:29.747851+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564437"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-05T20:19:28Z"
+"PhotosCount": 11
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T02:50:33Z"
+"Stories": "1.0"
+"StreetDirPrefix": "West"
+"StreetDirSuffix": "West"
+"StreetName": "BRIDGE"
+"StreetNumber": "54"
+"StreetSuffix": "Street"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"Utilities": array:1 [
0 => "Electricity"
]
+"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/29854429/54-w-bridge-street-w-unit-1-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1992792"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "1921771"
+"CoListAgentKey3": "1564379"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"CoListOfficeKey2": "76840"
+"CoListOfficeKey3": "289541"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 847
+"OriginalEntryTimestamp": "2026-06-04T17:31:00.6Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1115807"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1276055"
+"CoListAgentNationalAssociationId2": "1227142"
+"CoListAgentNationalAssociationId3": "1070065"
+"CoListOfficeNationalAssociationId": "1378680"
+"CoListOfficeNationalAssociationId2": "1004363"
+"CoListOfficeNationalAssociationId3": "1378680"
+"Media": array:11 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29854429')"
+"ID": "1495842"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 34
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]