array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30067289 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23528
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23530
+post_id: "1650036"
+post_author: 1
+"ListingKey": "30067289"
+"ListingId": "X13594730"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T01:10:02Z"
+"RFModificationTimestamp": "2026-07-24T01:18:02Z"
+"ListPrice": 755000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5N5"
+"UnparsedAddress": "402 MIDWOOD CRESCENT, Waterloo, Ontario N2L5N5"
+"Coordinates": array:2 [
0 => -80.5525613
1 => 43.4572071
]
+"Latitude": 43.4572071
+"Longitude": -80.5525613
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Excellent investment opportunity in Prime Location in Waterloo! This beautifully updated, licensed rental property offers a turnkey opportunity in one of the city's most sought-after student rental locations. Featuring recent renovations through out. The seller is currently completing the conversion of the lower level into a legal 3-bedroom secondary suite, creating even greater rental potential and maximizing future income opportunities with a rare 6 Bedroom home in the City, with 2 Kitchens, 2 Sets of Laundry, and Separate Entrances, Ideally located just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, public transit, shopping, restaurants, and everyday amenities, this property is perfectly suited for students and investors alike. Seller has owned this property for more than 20 years and it has been consistently leased year after year. (id:62650)"
+"Appliances": array:5 [
0 => "Dryer"
1 => "Two stoves"
2 => "Window Coverings"
3 => "Two Washers"
4 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Apartment in basement"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T23:10:10.113033+00:00"
+"Directions": "Cross Streets: Beachwood/University. ** Directions: Keats Way to Midwood Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932389"
+"ListOfficeKey": "194325"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55.7 x 82.6 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T00:33:55Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T01:03:45Z"
+"Stories": "1.0"
+"StreetName": "Midwood"
+"StreetNumber": "402"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4042"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1692135790"
"RoomType" => "Living room"
"ListingId" => "X13594730"
"RoomLevel" => "Main level"
"RoomWidth" => 4.26
"ListingKey" => "30067289"
"RoomLength" => 4.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T01:03:45.76Z"
]
1 => array:11 [
"RoomKey" => "1692135791"
"RoomType" => "Kitchen"
"ListingId" => "X13594730"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "30067289"
"RoomLength" => 5.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T01:03:45.76Z"
]
2 => array:11 [
"RoomKey" => "1692135792"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13594730"
"RoomLevel" => "Main level"
"RoomWidth" => 3.9
"ListingKey" => "30067289"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T01:03:45.76Z"
]
3 => array:11 [
"RoomKey" => "1692135793"
"RoomType" => "Bedroom 2"
"ListingId" => "X13594730"
"RoomLevel" => "Main level"
"RoomWidth" => 2.92
"ListingKey" => "30067289"
"RoomLength" => 2.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T01:03:45.76Z"
]
4 => array:11 [
"RoomKey" => "1692135794"
"RoomType" => "Bedroom 3"
"ListingId" => "X13594730"
"RoomLevel" => "Main level"
"RoomWidth" => 2.46
"ListingKey" => "30067289"
"RoomLength" => 2.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T01:03:45.76Z"
]
5 => array:11 [
"RoomKey" => "1692135795"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13594730"
"RoomLevel" => "Basement"
"RoomWidth" => 4.75
"ListingKey" => "30067289"
"RoomLength" => 6.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T01:03:45.76Z"
]
6 => array:11 [
"RoomKey" => "1692135796"
"RoomType" => "Bedroom 4"
"ListingId" => "X13594730"
"RoomLevel" => "Basement"
"RoomWidth" => 3.32
"ListingKey" => "30067289"
"RoomLength" => 5.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T01:03:45.76Z"
]
7 => array:11 [
"RoomKey" => "1692135797"
"RoomType" => "Bedroom 5"
"ListingId" => "X13594730"
"RoomLevel" => "Basement"
"RoomWidth" => 3.29
"ListingKey" => "30067289"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T01:03:45.76Z"
]
8 => array:11 [
"RoomKey" => "1692135798"
"RoomType" => "Bedroom"
"ListingId" => "X13594730"
"RoomLevel" => "Basement"
"RoomWidth" => 3.24
"ListingKey" => "30067289"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T01:03:45.76Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30067289/402-midwood-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 55.8
+"OriginalEntryTimestamp": "2026-07-22T20:04:49.3Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1232756"
+"ListOfficeNationalAssociationId": "1191701"
+"Media": array:21 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30067289_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/69e26bf090ecbd642af1599771df74f8.webp"
"MediaSize" => 65958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-69e26bf090ecbd642af1599771df74f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:48.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30067289_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/3ca2ab43e59a746496f567c69b911ca3.webp"
"MediaSize" => 55268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-3ca2ab43e59a746496f567c69b911ca3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:43.46Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30067289_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/822d3a456c37f6ea31d81cf689419644.webp"
"MediaSize" => 83603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-822d3a456c37f6ea31d81cf689419644.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:51.19Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30067289_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/a01ac8c082579f40aae262038f9aa978.webp"
"MediaSize" => 65885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-a01ac8c082579f40aae262038f9aa978.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:35.12Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30067289_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/a90c16440065e7ca6548f4fa850f6f89.webp"
"MediaSize" => 80405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-a90c16440065e7ca6548f4fa850f6f89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:37.6Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30067289_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/8f7b6199caefec93f88aaa9b83fc6f73.webp"
"MediaSize" => 43358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-8f7b6199caefec93f88aaa9b83fc6f73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:35.18Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30067289_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/7897402cb20fb89fc0eb0794ae9e00e4.webp"
"MediaSize" => 66480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-7897402cb20fb89fc0eb0794ae9e00e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:35.26Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30067289_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/110c0f74aa41b75a7353173dc1810cf9.webp"
"MediaSize" => 76437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-110c0f74aa41b75a7353173dc1810cf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:35.26Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30067289_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/62d4b85d2a860bfb4340f96d4f24d069.webp"
"MediaSize" => 51492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-62d4b85d2a860bfb4340f96d4f24d069.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:37.78Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30067289_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/7fd44bc1d77722b2182daa331b7b89d7.webp"
"MediaSize" => 67812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-7fd44bc1d77722b2182daa331b7b89d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:52.59Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30067289_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/f352336bc01ca87dd40bf3cbea3cff22.webp"
"MediaSize" => 48979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-f352336bc01ca87dd40bf3cbea3cff22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:33.93Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30067289_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/e8a0175f38a54a453555c1a7a31e3d2f.webp"
"MediaSize" => 62040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-e8a0175f38a54a453555c1a7a31e3d2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:43.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30067289_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/2f2a6acef2375cd69e8dfc472998d0eb.webp"
"MediaSize" => 42033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-2f2a6acef2375cd69e8dfc472998d0eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:48.18Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30067289_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/c2b97a6910acd9ed6a4866572989634c.webp"
"MediaSize" => 45842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-c2b97a6910acd9ed6a4866572989634c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:52.59Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30067289_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/76c3050df57f2da14e211f37407278c0.webp"
"MediaSize" => 29540
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-76c3050df57f2da14e211f37407278c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:33.76Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30067289_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/413f0c830707b20b57a7c91428f836ba.webp"
"MediaSize" => 65096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-413f0c830707b20b57a7c91428f836ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:16:34.37Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30067289_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/16bf53bc48c21d980cbdfbb10f8957d2.webp"
"MediaSize" => 45322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-16bf53bc48c21d980cbdfbb10f8957d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:46:06.05Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30067289_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/dedf901e196671e53ce2f9354b2b382f.webp"
"MediaSize" => 53626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-dedf901e196671e53ce2f9354b2b382f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:46:04.43Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30067289_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/6fa4788043db07b099bb88c07ed1edc2.webp"
"MediaSize" => 57489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-6fa4788043db07b099bb88c07ed1edc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:46:04.53Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30067289_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/94b7bf32c8689241665066c6a17f3aa6.webp"
"MediaSize" => 41349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-94b7bf32c8689241665066c6a17f3aa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:46:05.69Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30067289_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30067289/d29dd902d6d8ad92967c13704a3f51a4.webp"
"MediaSize" => 182904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30067289/thumbnail-d29dd902d6d8ad92967c13704a3f51a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13594730"
"ResourceRecordKey" => "30067289"
"ModificationTimestamp" => "2026-07-23T23:46:06.04Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30067289')"
+"ID": "1650036"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 194325" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24989
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24932
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "ROCK STAR REAL ESTATE INC."
+"OfficeEmail": null
+"OfficePhone": "905-361-9098"
+"OfficeMlsId": "145500"
+"ModificationTimestamp": "2026-03-03T10:56:50Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "194325"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "418 IROQUOIS SHORE RD #103A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "OAKVILLE"
+"OfficePostalCode": "L6H0X"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1191701"
+"OriginalEntryTimestamp": "2008-09-13T00:38:00Z"
+"OfficeFax": "905-338-2727"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "10965"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "194325"
"SocialMediaUrlOrId" => "http://www.rockstarbrokerage.com"
"ModificationTimestamp" => "2025-06-11T21:27:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1243495"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('194325')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1932389" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25012
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30067289'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25296
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30067289' AND OpenHouseDate ge '2026-07-23'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25312
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30067289' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5525613 43.4572071)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25406
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25380
+post_id: "1652383"
+post_author: 1
+"ListingKey": "30071331"
+"ListingId": "X13598432"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T17:45:06Z"
+"RFModificationTimestamp": "2026-07-23T19:03:00Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE DRIVE, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.572799
1 => 43.457509
]
+"Latitude": 43.457509
+"Longitude": -80.572799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RemarksPublic Remarks: Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:02:42.717889+00:00"
+"Directions": "Cross Streets: Erbsville Rd/ Keatsway. ** Directions: Erbsville Road to Keatsway."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "47.9 x 102 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T17:39:27Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T17:39:27Z"
+"Stories": "2.0"
+"StreetName": "Yorkshire"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6960"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1691830136"
"RoomType" => "Dining room"
"ListingId" => "X13598432"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "30071331"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
1 => array:11 [
"RoomKey" => "1691830137"
"RoomType" => "Other"
"ListingId" => "X13598432"
"RoomLevel" => "Basement"
"RoomWidth" => 3.0
"ListingKey" => "30071331"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
2 => array:11 [
"RoomKey" => "1691830138"
"RoomType" => "Kitchen"
"ListingId" => "X13598432"
"RoomLevel" => "Main level"
"RoomWidth" => 3.15
"ListingKey" => "30071331"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
3 => array:11 [
"RoomKey" => "1691830139"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "30071331"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
4 => array:11 [
"RoomKey" => "1691830140"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Second level"
"RoomWidth" => 3.78
"ListingKey" => "30071331"
"RoomLength" => 4.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
5 => array:11 [
"RoomKey" => "1691830141"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Second level"
"RoomWidth" => 2.62
"ListingKey" => "30071331"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
6 => array:11 [
"RoomKey" => "1691830142"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Second level"
"RoomWidth" => 2.92
"ListingKey" => "30071331"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
7 => array:11 [
"RoomKey" => "1691830143"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Second level"
"RoomWidth" => 3.0
"ListingKey" => "30071331"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
8 => array:11 [
"RoomKey" => "1691830144"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Basement"
"RoomWidth" => 3.1
"ListingKey" => "30071331"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
9 => array:11 [
"RoomKey" => "1691830145"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Basement"
"RoomWidth" => 3.0
"ListingKey" => "30071331"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
10 => array:11 [
"RoomKey" => "1691830146"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13598432"
"RoomLevel" => "Basement"
"RoomWidth" => 4.47
"ListingKey" => "30071331"
"RoomLength" => 6.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071331/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 47.1
+"OriginalEntryTimestamp": "2026-07-23T17:39:27.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30071331_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/4c3428e65eb24fad04bc00e7c40d0f61.webp"
"MediaSize" => 281549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-4c3428e65eb24fad04bc00e7c40d0f61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30071331_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/503a882a7ed5adabb460b7fdf4c7d339.webp"
"MediaSize" => 316170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-503a882a7ed5adabb460b7fdf4c7d339.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30071331_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/9c14036e94f9bd81ea1dbc7a693a0f75.webp"
"MediaSize" => 430554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-9c14036e94f9bd81ea1dbc7a693a0f75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30071331_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/6ae2e0d73fcdcee69b0d052689bfdfe2.webp"
"MediaSize" => 215278
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-6ae2e0d73fcdcee69b0d052689bfdfe2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30071331_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/1240d16348e7d2dae599c75b6c4cbc9e.webp"
"MediaSize" => 181769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-1240d16348e7d2dae599c75b6c4cbc9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30071331_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/0ebf095fbc6c1767eeb25c0a93d3c26e.webp"
"MediaSize" => 175505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-0ebf095fbc6c1767eeb25c0a93d3c26e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30071331_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/c8fa3066976b2f5a4f50f4462620cd11.webp"
"MediaSize" => 175247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-c8fa3066976b2f5a4f50f4462620cd11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30071331_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/d7413af35eb0a438392b263f553ee3fc.webp"
"MediaSize" => 182343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-d7413af35eb0a438392b263f553ee3fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30071331_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/cc1653f6c5c1f0f8737af2819fa8557d.webp"
"MediaSize" => 185573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-cc1653f6c5c1f0f8737af2819fa8557d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30071331_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/287a7a7244fde89957c0b0f782af5be9.webp"
"MediaSize" => 152581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-287a7a7244fde89957c0b0f782af5be9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30071331_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/de31d069b39db9b5996f3d4d6bed4442.webp"
"MediaSize" => 170163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-de31d069b39db9b5996f3d4d6bed4442.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30071331_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/abaa7641d0065ea7e9723605985a9fff.webp"
"MediaSize" => 180976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-abaa7641d0065ea7e9723605985a9fff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30071331_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/74a7875245f58da1c20592e45a51c019.webp"
"MediaSize" => 172766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-74a7875245f58da1c20592e45a51c019.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30071331_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/2851c5b7e50ba5bffde0e1dee522e7cc.webp"
"MediaSize" => 109390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-2851c5b7e50ba5bffde0e1dee522e7cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30071331_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/349803dbffa705cb06f00d7c75bcfce2.webp"
"MediaSize" => 116146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-349803dbffa705cb06f00d7c75bcfce2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30071331_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/16042b08a021b9c96b8ef0f461e64bc1.webp"
"MediaSize" => 202286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-16042b08a021b9c96b8ef0f461e64bc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30071331_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/572350876bed18cd8beab304a8496747.webp"
"MediaSize" => 174716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-572350876bed18cd8beab304a8496747.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30071331_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/2b6f4fb03392b12b8b0ebac90f01e568.webp"
"MediaSize" => 153854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-2b6f4fb03392b12b8b0ebac90f01e568.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30071331_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/0c452894ee0bcb78458dd00a0bca10d4.webp"
"MediaSize" => 173240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-0c452894ee0bcb78458dd00a0bca10d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30071331_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/fd361ead194c570dd97dd7724f03db6c.webp"
"MediaSize" => 181057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-fd361ead194c570dd97dd7724f03db6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30071331_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/4a1e53bfd00437438b5dcd2329f46b10.webp"
"MediaSize" => 185893
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-4a1e53bfd00437438b5dcd2329f46b10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30071331_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/7730f114936d01a81aac97b0e76a90c1.webp"
"MediaSize" => 144022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-7730f114936d01a81aac97b0e76a90c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30071331_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/9c92ccf289bed65219c680d71d16c596.webp"
"MediaSize" => 151209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-9c92ccf289bed65219c680d71d16c596.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30071331_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/eaea24463dc46bc4ca14d96cad643ee6.webp"
"MediaSize" => 169158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-eaea24463dc46bc4ca14d96cad643ee6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30071331_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/09a7a684ce502443ce1f3a640f9fbc85.webp"
"MediaSize" => 158905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-09a7a684ce502443ce1f3a640f9fbc85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30071331_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/54aadf6140a50072d8e5867cb61ffc33.webp"
"MediaSize" => 139282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-54aadf6140a50072d8e5867cb61ffc33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30071331_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/12ddb383317cb4b8452a282a9237cfcc.webp"
"MediaSize" => 135781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-12ddb383317cb4b8452a282a9237cfcc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30071331_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/4feb609a4cb6be2d2f7468b6b2c72a45.webp"
"MediaSize" => 214310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-4feb609a4cb6be2d2f7468b6b2c72a45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30071331_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/6bd0876d193e1b785da930c1e2389211.webp"
"MediaSize" => 141730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-6bd0876d193e1b785da930c1e2389211.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30071331_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30071331/dfb971093f25a615ef4f2783e0ae48dc.webp"
"MediaSize" => 161977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30071331/thumbnail-dfb971093f25a615ef4f2783e0ae48dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13598432"
"ResourceRecordKey" => "30071331"
"ModificationTimestamp" => "2026-07-23T17:39:27.55Z"
]
30 => array:13 [
"Order" => 31
…12
]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071331')"
+"ID": "1652383"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25401
+post_id: "1652258"
+post_author: 1
+"ListingKey": "30070302"
+"ListingId": "40849801"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T15:45:05Z"
+"RFModificationTimestamp": "2026-07-23T16:58:27Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 3733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE Drive, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.5727819
1 => 43.4575227
]
+"Latitude": 43.4575227
+"Longitude": -80.5727819
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T16:58:13.051179+00:00"
+"Directions": "Erbsville Road to Keatsway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T15:38:28Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T15:38:28Z"
+"Stories": "2.0"
+"StreetName": "YORKSHIRE"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "6960"
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070302/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 2447
+"BelowGradeFinishedArea": 1286
+"OriginalEntryTimestamp": "2026-07-23T15:38:28.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070302')"
+"ID": "1652258"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+post_id: "1652327"
+post_author: 1
+"ListingKey": "30069106"
+"ListingId": "40850510"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T17:10:05Z"
+"RFModificationTimestamp": "2026-07-23T17:16:08Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1108.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "543 DRUMMERHILL Crescent, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.5529466
1 => 43.4462309
]
+"Latitude": 43.4462309
+"Longitude": -80.5529466
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great Location! Welcome to this beautiful detached home in the highly sought-after Westvale neighbourhood. Situated on a quiet, family-friendly crescent, this carpet-free home is conveniently located near top-rated schools, shopping, parks, trails, transit, and just minutes from Uptown Waterloo, the University of Waterloo, Costco, Walmart, medical centres, restaurants, and highway access. This well-maintained single-family home features 3 bedrooms, 2 bathrooms, a single-car garage, parking for three vehicles, and a finished recreation room. The bright main floor offers hardwood flooring, a 2-piece powder room, direct garage access, and sliding doors leading to a fully fenced backyard with a spacious deck—perfect for family gatherings and outdoor entertaining. Upstairs, you'll find three generous bedrooms and a beautifully renovated bathroom. The basement is nearly complete, featuring a finished rec room and a framed 3-piece bathroom rough-in, offering excellent potential for additional living space. Move-in ready and located in one of Waterloo's most desirable family communities, this is a fantastic opportunity you won't want to miss! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T16:24:16.671388+00:00"
+"Directions": "Fischer-Hallman to Thorndale, left onto Westvale, right onto Drummerhill Crescent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T17:02:44Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T17:02:44Z"
+"Stories": "2.0"
+"StreetName": "DRUMMERHILL"
+"StreetNumber": "543"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "3852.78"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30069106/543-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SD-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1108
+"OriginalEntryTimestamp": "2026-07-23T11:48:32.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30069106')"
+"ID": "1652327"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25403
+post_id: "1650535"
+post_author: 1
+"ListingKey": "30068427"
+"ListingId": "X13595566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:45:05Z"
+"RFModificationTimestamp": "2026-07-23T16:53:47Z"
+"ListPrice": 587000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0A5"
+"UnparsedAddress": "36 - 555 CHABLIS DRIVE, Waterloo, Ontario N2T0A5"
+"Coordinates": array:2 [
0 => -80.574031
1 => 43.449435
]
+"Latitude": 43.449435
+"Longitude": -80.574031
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare end-unit condo townhome in sought-after Clair Hills offers the space and features of a detached home without the upkeep. A double-car garage plus double-wide driveway delivers parking for four - virtually unheard of in condo life. At 2,478 sq. ft. of total finished living area, the layout is generous throughout: open-concept main floor with hardwood, a well-appointed kitchen with gas range, breakfast peninsula, pantry and stainless appliances, three upstairs bedrooms including an oversized primary with walk-in closet and ensuite, upper-level laundry, and a flexible lower level ideal for a family room, office or gym. Move-in ready with 2026 updates including fresh paint, new upstairs carpet and updated lighting, while the bathrooms have been refreshed with new vanities, mirrors, faucets, toilets and coordinated black fixtures. Smart home features include app-based locks, lighting and garage access. Furnace and AC replaced 2023. The end-unit position brings extra windows, privacy and a rear deck overlooking landscaped green space - no street exposure. Steps to The Boardwalk's shops, restaurants, Costco and healthcare, with easy GRT access and 150+ km of trails nearby. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T00:54:31.814311+00:00"
+"Directions": "Ira Needles & Chablis"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102918"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:07:11Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:39:54Z"
+"Stories": "2.0"
+"StreetName": "Chablis"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4956"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_36_555_chablis_dr_waterloo_on/"
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30068427/36-555-chablis-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-22T23:33:34.65Z"
+"ListAgentNationalAssociationId": "1372568"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30068427')"
+"ID": "1650535"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25381
+post_id: "1650037"
+post_author: 1
+"ListingKey": "30067297"
+"ListingId": "40850419"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T00:30:01Z"
+"RFModificationTimestamp": "2026-07-24T00:31:38Z"
+"ListPrice": 755000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5N5"
+"UnparsedAddress": "402 MIDWOOD Crescent, Waterloo, Ontario N2L5N5"
+"Coordinates": array:2 [
0 => -80.5536715
1 => 43.456899
]
+"Latitude": 43.456899
+"Longitude": -80.5536715
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Client Remarks Excellent investment opportunity in Prime Location in Waterloo! This beautifully updated, licensed rental property offers a turnkey opportunity in one of the city's most sought-after student rental locations. Featuring recent renovations through out. The seller is currently completing the conversion of the lower level into a legal 3-bedroom secondary suite, creating even greater rental potential making it a total of 6 Bedrooms which is not common in the city, Two Kitchens, Two Sets of Laundry with separate Entrance and maximizing future income opportunities. Ideally located just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, public transit, shopping, restaurants, and everyday amenities, this property is perfectly suited for students and investors alike. Seller has owned this property for more than 20 years and it has been consistently leased year after year. (id:62650)"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T20:44:19.513703+00:00"
+"Directions": "KEATSWAY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932389"
+"ListOfficeKey": "190426"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-24T00:22:05Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T00:29:19Z"
+"Stories": "1.0"
+"StreetName": "MIDWOOD"
+"StreetNumber": "402"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4042"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30067297/402-midwood-crescent-waterloo"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-07-22T20:08:20Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1232756"
+"ListOfficeNationalAssociationId": "1213294"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30067297')"
+"ID": "1650037"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "1649042"
+post_author: 1
+"ListingKey": "30065970"
+"ListingId": "40848982"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:10:07Z"
+"RFModificationTimestamp": "2026-07-23T16:26:37Z"
+"ListPrice": 587000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2478.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y7"
+"UnparsedAddress": "555 CHABLIS Drive Unit# 36, Waterloo, Ontario N2T2Y7"
+"Coordinates": array:2 [
0 => -80.5740634
1 => 43.4487988
]
+"Latitude": 43.4487988
+"Longitude": -80.5740634
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare end-unit condo townhome in sought-after Clair Hills offers the space and features of a detached home without the upkeep. A double-car garage plus double-wide driveway delivers parking for four — virtually unheard of in condo life. At 2,478 sq. ft. of total finished living area, the layout is generous throughout: open-concept main floor with hardwood, a well-appointed kitchen with gas range, breakfast peninsula, pantry and stainless appliances, three upstairs bedrooms including an oversized primary with walk-in closet and ensuite, upper-level laundry, and a flexible lower level ideal for a family room, office or gym. Move-in ready with 2026 updates including fresh paint, new upstairs carpet and updated lighting, while the bathrooms have been refreshed with new vanities, mirrors, faucets, toilets and coordinated black fixtures. Smart home features include app-based locks, lighting and garage access. Furnace and AC replaced 2023. The end-unit position brings extra windows, privacy and a rear deck overlooking landscaped green space — no street exposure. Steps to The Boardwalk's shops, restaurants, Costco and healthcare, with easy GRT access and 150+ km of trails nearby. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T17:53:32.701198+00:00"
+"Directions": "Ira Needles & Chablis"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1930634"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:02:56Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:02:56Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4956"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_36_555_chablis_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30065970/555-chablis-drive-unit-36-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1766
+"BelowGradeFinishedArea": 712
+"OriginalEntryTimestamp": "2026-07-22T17:08:17.78Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1231368"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30065970')"
+"ID": "1649042"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23542
+post_id: "1647387"
+post_author: 1
+"ListingKey": "30063837"
+"ListingId": "X13591300"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T03:45:03Z"
+"RFModificationTimestamp": "2026-07-22T04:38:07Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E4"
+"UnparsedAddress": "306 - 265 WESTCOURT PLACE, Waterloo, Ontario N2L6E4"
+"Coordinates": array:2 [
0 => -80.540493
1 => 43.460629
]
+"Latitude": 43.460629
+"Longitude": -80.540493
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Priced to Sell! AAA LOCATION! Spacious 1,376 sq ft unit in the well-maintained Beechmount building. Walk to Uptown, both universities, Waterloo Park, reccentre, T&T, Costco & more. Features include a large living room, enclosed sunroom, separate dining room, bright kitchen with ample cabinetry,2nd bedroom with balcony walkout, and a large in-suite laundry/storage room. Quiet setting with lovely grounds, updated lobby, games room,and library. A rare find in a prime Waterloo location! (id:62650)"
+"AssociationFee": "865"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Pets not Allowed"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T04:38:02.939644+00:00"
+"Directions": "Cross Streets: Westmount/Erb/University. ** Directions: Westmount to WestCourt Place."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2003456"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-22T03:37:28Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T03:37:28Z"
+"StreetName": "Westcourt"
+"StreetNumber": "265"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3938.71"
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30063837/306-265-westcourt-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CanLight Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "RMU-60"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-22T03:37:28.7Z"
+"ListAgentNationalAssociationId": "1286347"
+"ListOfficeNationalAssociationId": "1132867"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30063837')"
+"ID": "1647387"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25404
+post_id: "1646561"
+post_author: 1
+"ListingKey": "30062837"
+"ListingId": "40849430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T22:05:49Z"
+"RFModificationTimestamp": "2026-07-21T22:36:19Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1843.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1A6"
+"UnparsedAddress": "67 PINEMEADOW Crescent, Waterloo, Ontario N2T1A6"
+"Coordinates": array:2 [
0 => -80.5547069
1 => 43.449414
]
+"Latitude": 43.449414
+"Longitude": -80.5547069
+"YearBuilt": 1979
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "WOW! OVER Ca $ 30,000 IN UPGRADES, 5 BEDROOMS, 2 FULL BATHROOMS, AND IN-LAW FAMILY UNIT. LOOKING FOR FAMILY ORIENTED AREA WITH EXCELLENT OPPORTUNITY FOR SPACE TO LIVE WITH EXTENDED FAMILY, MORTGAGE HELPER OR INVESTMENT, IN WELL SOUGHT WATERLOO AREA, CLOSE TO WATERLOO AND WILFRID LAURIER UNIVERSITIES, THIS PROPERTY HAS IT ALL. THIS PRIME LOCATED DETACHED PROPERTY 3 + 2 BEDROOMS AND 2 FULL WASHROOMS, 2 CAR PARKING ASPHALT DRIVEWAY, SPACIOUS FULLY FENCED GARAGE, DECK, SHADE AND MANY UPDATES. THE MAIN UNIT HAS A LIVING ROOM WITH MODERN AND DESIGNER TOUCH, SPACIOUS KITCHEN AND DINNING AREA, 3 GOOD SIZE BEDROOMS, A FULL BATHROOM AND ITS OWN LAUNDRY. THE BASEMENT HAS A SEPARATE ACCESS THROUGH THE GARAGE, AND CONSISTS OF A LIVING ROOM, TWO GOOD SIZE BEDROOMS, A KITCHEN, 3 PCs BATHROOM, WITH ITS OWN LAUNDRY. LOOKING FOR PRIVATE FAMILY GATHERING, SPACE FOR YOUR GARDENING HOBBY, OR OUTOOR ENJOYMENT, THIS PROPERTY HAS IT. UPGRADES INCLUDE BUT NOT LIMITED TO MODERN MAIN FLOOR SEPARATION WALL (2025), BARN DOOR (2025), BASEMENT KITCHEN (2023), WHOLE HOUSE FRESHLY PAINTED (2023), FRONT LANDSCAPE (2023), REVERSE OSMOSIS WATER FILTER & WHOLE HOUSE FILTER DECHLORINATE WITH CARBOC(2023). SUCH OPPORTUNITY WON'T LAST LONG. COME AND SEE IT FOR YOURSELF! BOOK YOUR SHOWING TODAY! (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-07-21T22:36:09.131182+00:00"
+"Directions": "WESTVALE DRIVE to PINEMEADOW CRESCENT"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2089081"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T21:59:26Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T21:59:26Z"
+"Stories": "1.0"
+"StreetName": "PINEMEADOW"
+"StreetNumber": "67"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4028.3"
+"Utilities": array:1 [
0 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30062837/67-pinemeadow-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1106
+"BelowGradeFinishedArea": 737
+"OriginalEntryTimestamp": "2026-07-21T21:59:26.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1362345"
+"ListOfficeNationalAssociationId": "1004415"
+"Media": array:46 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30062837')"
+"ID": "1646561"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25405
+post_id: "1645492"
+post_author: 1
+"ListingKey": "30060616"
+"ListingId": "40849370"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T15:00:04Z"
+"RFModificationTimestamp": "2026-07-22T15:26:40Z"
+"ListPrice": 519000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1274.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5N4"
+"UnparsedAddress": "435A MIDWOOD Crescent, Waterloo, Ontario N2L5N4"
+"Coordinates": array:2 [
0 => -80.5555294
1 => 43.4561142
]
+"Latitude": 43.4561142
+"Longitude": -80.5555294
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Beechwood Living with duplex potential! Tucked away in one of Waterloo’s most sought-after neighbourhoods, this immaculate 4 bedroom, 2 bathroom freehold semi-detached home offers the perfect blend of style, space, and nature. Step inside to discover updated flooring and a large kitchen featuring a sleek glass-tile backsplash and stainless steel sink. Love to entertain or unwind? Bright sliding glass doors open onto an expansive, fully fenced backyard situated on a deep, wooded lot complete with a storage shed for all your gear. The finished lower level recreation room boasts a convenient separate side entrance, a full bathroom, and laundry, offering fantastic flexibility for additional living space or guest quarters. With private parking for 3 cars and an unbeatable location, this home is an opportunity you don't want to miss! New furnace Installed in November 2021, New humidifier 2025. Roof updates in 2015 and new eavestroughs and aluminium siding covering installed March 2026. Windows 2014. General Electrical Inspection dated Aug 2023 and HVAC Inspection dated Sep 2024. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T17:18:43.202599+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1914828"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-22T14:53:47Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T14:59:47Z"
+"Stories": "2.0"
+"StreetName": "MIDWOOD"
+"StreetNumber": "435"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3480"
+"VirtualTourURLUnbranded": "http://www.tylerodonovan.com/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30060616/435a-midwood-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1274
+"OriginalEntryTimestamp": "2026-07-21T16:38:14.76Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1224120"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:33 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30060616')"
+"ID": "1645492"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 132
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]