array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29450591 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1212537"
+post_author: 1
+"ListingKey": "29450591"
+"ListingId": "X12865658"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-03-10T15:30:33Z"
+"RFModificationTimestamp": "2026-03-10T17:43:06Z"
+"ListPrice": 95000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "215 - 580 BEAVER CREEK ROAD, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.586345
1 => 43.484782
]
+"Latitude": 43.484782
+"Longitude": -80.586345
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 580 Beaver Creek Road Unit 215. This modular home is located on a quiet road within Green Acre Park in Waterloo - minutes from Universities, St. Jacobs, major highways and Laurel Creek Conservation. This home offers 452 sq. ft. of living space with one bedroom and one bathroom. Entering the home, living room and kitchen greet you for an open concept floor plan. With windows throughout allowing lots of natural light to shine through. Sliding doors off of the living room make it accessible to the yard. Steps away, you will find the bedroom and a three piece bathroom. The exterior space leaves plenty of room for outdoor dining, lounging and entertaining- picnics and a fire pit. Notable updates include freshly painted, newer floors, newer bathroom and plumbing, newer electric water heater and fridge. Enjoy the comforts of 10 month seasonal living (park closed Jan and Feb) with a turn key home, surrounded by nature, old growth trees and a spacious lot. Green Acre Park features a community swimming pool, a games room, a catch and release fishing pond for plenty of outdoor activities. This property is the perfect getaway for the ultimate cottage feel with the modern convenience of amenities around the corner and ample visitor parking. Monthly Land Lease fee $935.17 includes water & taxes (park closed Jan & Feb). (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Fishing"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-03-10T17:42:43.982948+00:00"
+"Directions": "Cross Streets: Conservation Drive. ** Directions: Hwy 85 to Northfield to Westmount to Conservation Dr to Beaver Creek."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180619"
+"ListOfficeKey": "293007"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-03-10T15:23:00Z"
+"PhotosCount": 32
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Outdoor pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-03-10T15:23:00Z"
+"Stories": "1.0"
+"StreetName": "Beaver Creek"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1589174395"
"RoomType" => "Kitchen"
"ListingId" => "X12865658"
"RoomLevel" => "Main level"
"RoomWidth" => 3.2
"ListingKey" => "29450591"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-03-10T15:23:00.01Z"
]
1 => array:11 [
"RoomKey" => "1589174396"
"RoomType" => "Living room"
"ListingId" => "X12865658"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "29450591"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-03-10T15:23:00.01Z"
]
2 => array:11 [
"RoomKey" => "1589174397"
"RoomType" => "Bedroom"
"ListingId" => "X12865658"
"RoomLevel" => "Main level"
"RoomWidth" => 3.02
"ListingKey" => "29450591"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-03-10T15:23:00.02Z"
]
3 => array:11 [
"RoomKey" => "1589174398"
"RoomType" => "Foyer"
"ListingId" => "X12865658"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "29450591"
"RoomLength" => 1.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-03-10T15:23:00.02Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29450591/215-580-beaver-creek-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Modular"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Controlled entry"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-03-10T15:22:59.98Z"
+"ListAgentNationalAssociationId": "1430522"
+"ListOfficeNationalAssociationId": "1420771"
+"Media": array:32 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6508299382"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/028714091dc4cdff23eac2442227f57b.webp"
"MediaSize" => 419532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-028714091dc4cdff23eac2442227f57b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6508299479"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/f79b95bf64a7cf32996f218d06cf5794.webp"
"MediaSize" => 451834
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-f79b95bf64a7cf32996f218d06cf5794.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6508299612"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/63675cb39de0e070bccabebe4a174f0c.webp"
"MediaSize" => 430678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-63675cb39de0e070bccabebe4a174f0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6508299726"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/1a2b760e1d4d1905ea0a3499bcbead32.webp"
"MediaSize" => 442184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-1a2b760e1d4d1905ea0a3499bcbead32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6508299813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/b6beb88d5011e5383b5c15dd87567551.webp"
"MediaSize" => 427621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-b6beb88d5011e5383b5c15dd87567551.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6508299867"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/4a834ac96dd353f322a6650767e7d211.webp"
"MediaSize" => 280206
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-4a834ac96dd353f322a6650767e7d211.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6508299886"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/23a92775286c9e73fec3d86bc009f468.webp"
"MediaSize" => 150892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-23a92775286c9e73fec3d86bc009f468.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6508299994"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/3046bacfa1121263c5fa3241a58098b5.webp"
"MediaSize" => 136549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-3046bacfa1121263c5fa3241a58098b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6508300062"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/6749c653672cba135cc8b74804cbda17.webp"
"MediaSize" => 237032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-6749c653672cba135cc8b74804cbda17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6508300117"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/411542fa5af289fc754e7cafb23fc52f.webp"
"MediaSize" => 190068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-411542fa5af289fc754e7cafb23fc52f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6508300188"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/3eea4951c5720cda821e0cdf64c13067.webp"
"MediaSize" => 169718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-3eea4951c5720cda821e0cdf64c13067.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6508300210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/215ac299e40376f51c54ed878b0136ff.webp"
"MediaSize" => 166102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-215ac299e40376f51c54ed878b0136ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6508300275"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/202b188239d73854b25362fd6907c739.webp"
"MediaSize" => 192271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-202b188239d73854b25362fd6907c739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6508300318"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/450cb34a657fd0f3cc8321ae173c9467.webp"
"MediaSize" => 203531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-450cb34a657fd0f3cc8321ae173c9467.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6508300406"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/da960bc3b6e7da952b78aaf8b49c7aad.webp"
"MediaSize" => 186602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-da960bc3b6e7da952b78aaf8b49c7aad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6508300455"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/66ee23f66325cbec780c902803d13c76.webp"
"MediaSize" => 203733
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-66ee23f66325cbec780c902803d13c76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6508300484"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/bdef727895c5984ffbb65d5dfb7c1dfb.webp"
"MediaSize" => 135177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-bdef727895c5984ffbb65d5dfb7c1dfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6508300553"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/ac959813128bc2516afa4f2abacd3ac4.webp"
"MediaSize" => 227183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-ac959813128bc2516afa4f2abacd3ac4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6508300602"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/ef033e963d7c06fde5a47c872c3e9cfd.webp"
"MediaSize" => 181541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-ef033e963d7c06fde5a47c872c3e9cfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6508300627"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/73085fb8fe761b1932315dcde2df8d11.webp"
"MediaSize" => 198551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-73085fb8fe761b1932315dcde2df8d11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6508300694"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/9422b069083a983e221628e1bee36186.webp"
"MediaSize" => 135938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-9422b069083a983e221628e1bee36186.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6508300753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/054519d55cdcc60404f8f1abceb10f02.webp"
"MediaSize" => 375339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-054519d55cdcc60404f8f1abceb10f02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6508300766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/d32ca508205161de31b046fd8e32e9cf.webp"
"MediaSize" => 507550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-d32ca508205161de31b046fd8e32e9cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6508300818"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/1aa8a156d4f35dac30b6ce85b7d6d6dd.webp"
"MediaSize" => 379903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-1aa8a156d4f35dac30b6ce85b7d6d6dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6508300856"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/03db46d0b5843a53d5182c103f9879b0.webp"
"MediaSize" => 424094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-03db46d0b5843a53d5182c103f9879b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6508300890"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/ee5673b7d21579c9a9fdaae0cd31f691.webp"
"MediaSize" => 467984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-ee5673b7d21579c9a9fdaae0cd31f691.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6508300915"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/7bb334e37db2a19c4f3b4655169499f8.webp"
"MediaSize" => 445085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-7bb334e37db2a19c4f3b4655169499f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6508300980"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/de4e3364240344002ad8bb55d3535f01.webp"
"MediaSize" => 507384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-de4e3364240344002ad8bb55d3535f01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6508301014"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/90ff51cfabfb8e04e581540a56798df9.webp"
"MediaSize" => 361378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-90ff51cfabfb8e04e581540a56798df9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6508301054"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/91b5dde649f6d87130128fb241dd36ea.webp"
"MediaSize" => 502495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-91b5dde649f6d87130128fb241dd36ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6508301071"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/0a1b0c747fa9025e881bed9d61f83823.webp"
"MediaSize" => 444296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-0a1b0c747fa9025e881bed9d61f83823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6508301088"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29450591/d134f9da5cff8aebdd794373250f630b.webp"
"MediaSize" => 392771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29450591/thumbnail-d134f9da5cff8aebdd794373250f630b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12865658"
"ResourceRecordKey" => "29450591"
"ModificationTimestamp" => "2026-03-10T15:22:59.98Z"
]
]
+"DaysOnMarket": 115
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29450591')"
+"ID": "1212537"
}
]
+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 293007" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24888
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2180619" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24846
+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 '29450591'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25235
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29450591'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25251
+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 '29450591' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.586345 43.484782)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25304
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25298
+post_id: "1590429"
+post_author: 1
+"ListingKey": "29986610"
+"ListingId": "40844919"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:25:11Z"
+"RFModificationTimestamp": "2026-07-03T20:06:53Z"
+"ListPrice": 927500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2692.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V6"
+"UnparsedAddress": "439 WOODROW Drive, Waterloo, Ontario N2T2V6"
+"Coordinates": array:2 [
0 => -80.5847827
1 => 43.4697703
]
+"Latitude": 43.4697703
+"Longitude": -80.5847827
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in Waterloo's highly sought after Laurelwood neighbourhood, this beautifully renovated backsplit offers the perfect balance of modern updates, functional living space, and an incredible outdoor retreat. Every level of this home has been thoughtfully updated, making it truly move in ready. The beautifully designed kitchen (2016) serves as the heart of the home, showcasing quartz countertops, a spacious centre island, and abundant cabinetry. Whether you're preparing family meals or hosting friends, the open layout seamlessly connects the kitchen to the bright living and dining areas, creating an ideal space for everyday living and entertaining. A few steps down, the inviting family room is the perfect place to unwind, featuring a stylish gas fireplace with a custom mantel (2021) and patio doors that open to your own private backyard sanctuary. Enjoy beautifully landscaped perennial gardens, a charming gazebo, and an outdoor BBQ with prep station all included creating an exceptional setting for summer gatherings or peaceful evenings outdoors. The lower level features a flexible fourth bedroom or home office, a beautifully updated 3 piece bathroom (2018), a convenient laundry room, and direct access to the side entrance. The fully finished basement provides more living space with a generous recreation room, utility area, and extensive storage options to meet the needs of a growing family. Upstairs, you'll find three spacious bedrooms, including a relaxing primary retreat, along with a tastefully renovated 4npiece bathroom (2020). Additional features include a double car garage with EV charger rough in, a concrete driveway accommodating 4 vehicles, and quality finishes throughout. Ideally situated close to excellent schools, parks, scenic walking trails, shopping, universities, and all the amenities Waterloo has to offer, this exceptional Laurelwood home delivers the perfect combination of comfort, style, and location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T20:06:47.479378+00:00"
+"Directions": "Laurelwood to Old Oak Dr to Woodrow Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958320"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Gazebo"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T19:18:19Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:18:19Z"
+"Stories": "3.0"
+"StreetName": "WOODROW"
+"StreetNumber": "439"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5946"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/439_woodrow_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1674342406"
"RoomType" => "Storage"
"ListingId" => "40844919"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
1 => array:11 [
"RoomKey" => "1674342407"
"RoomType" => "Utility room"
"ListingId" => "40844919"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
2 => array:11 [
"RoomKey" => "1674342408"
"RoomType" => "Storage"
"ListingId" => "40844919"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "3'3'' x 4'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
3 => array:11 [
"RoomKey" => "1674342409"
"RoomType" => "Recreation room"
"ListingId" => "40844919"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
4 => array:11 [
"RoomKey" => "1674342410"
"RoomType" => "Laundry room"
"ListingId" => "40844919"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.18Z"
]
5 => array:11 [
"RoomKey" => "1674342411"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844919"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
6 => array:11 [
"RoomKey" => "1674342412"
"RoomType" => "Bedroom"
"ListingId" => "40844919"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
7 => array:11 [
"RoomKey" => "1674342413"
"RoomType" => "Family room"
"ListingId" => "40844919"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "20'5'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
8 => array:11 [
"RoomKey" => "1674342414"
"RoomType" => "Bedroom"
"ListingId" => "40844919"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
9 => array:11 [
"RoomKey" => "1674342415"
"RoomType" => "Bedroom"
"ListingId" => "40844919"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
10 => array:11 [
"RoomKey" => "1674342416"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844919"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
11 => array:11 [
"RoomKey" => "1674342417"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844919"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
12 => array:11 [
"RoomKey" => "1674342418"
"RoomType" => "Eat in kitchen"
"ListingId" => "40844919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "15'8'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
13 => array:11 [
"RoomKey" => "1674342419"
"RoomType" => "Dining room"
"ListingId" => "40844919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
14 => array:11 [
"RoomKey" => "1674342420"
"RoomType" => "Living room"
"ListingId" => "40844919"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986610"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T19:18:19.19Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986610/439-woodrow-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1564580"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2037
+"BelowGradeFinishedArea": 655
+"OriginalEntryTimestamp": "2026-07-03T19:18:19.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1249173"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1069941"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986610_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/539a2e99ee2e3ee4d35a9de0a180f175.webp"
"MediaSize" => 134626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-539a2e99ee2e3ee4d35a9de0a180f175.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986610_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/f4436c0042a72da114488be1e56f72a3.webp"
"MediaSize" => 170390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-f4436c0042a72da114488be1e56f72a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986610_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/02ada643367467588537eaa0811b334a.webp"
"MediaSize" => 139605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-02ada643367467588537eaa0811b334a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986610_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/df08876de49ef37d0340e96b2b760c17.webp"
"MediaSize" => 120008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-df08876de49ef37d0340e96b2b760c17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986610_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/dac08fcdc60fff7c9957c18093e6e606.webp"
"MediaSize" => 63062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-dac08fcdc60fff7c9957c18093e6e606.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986610_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/ef6eab2984a47b22f0c2dcd3e58be239.webp"
"MediaSize" => 54751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-ef6eab2984a47b22f0c2dcd3e58be239.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29986610_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/039fd445b3c168b5175c7e993c56d575.webp"
"MediaSize" => 57056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-039fd445b3c168b5175c7e993c56d575.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29986610_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/f6836f477f7f1d252ea73545dc780a6a.webp"
"MediaSize" => 65302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-f6836f477f7f1d252ea73545dc780a6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29986610_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/240634218062a39254a44c08c6eee37a.webp"
"MediaSize" => 64282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-240634218062a39254a44c08c6eee37a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29986610_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/0b83a9883afb17d6ddab61616cb37d28.webp"
"MediaSize" => 67764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-0b83a9883afb17d6ddab61616cb37d28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29986610_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/28e1c6484889fd0b247bb0bf1b25372e.webp"
"MediaSize" => 69579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-28e1c6484889fd0b247bb0bf1b25372e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29986610_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/7aa6a7292461e47b3cc992df485d815b.webp"
"MediaSize" => 73426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-7aa6a7292461e47b3cc992df485d815b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844919"
"ResourceRecordKey" => "29986610"
"ModificationTimestamp" => "2026-07-03T19:18:19.15Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29986610_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986610/4660d17c7cbdc23ea8d0003c2fd5d139.webp"
"MediaSize" => 71664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986610/thumbnail-4660d17c7cbdc23ea8d0003c2fd5d139.webp"
"ResourceName" => "Property"
…6
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986610')"
+"ID": "1590429"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1589222"
+post_author: 1
+"ListingKey": "29984123"
+"ListingId": "40843883"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:25:11Z"
+"RFModificationTimestamp": "2026-07-03T17:12:05Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2618.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T8"
+"UnparsedAddress": "569 VIOLET Street, Waterloo, Ontario N2V2T8"
+"Coordinates": array:2 [
0 => -80.5958904
1 => 43.4687764
]
+"Latitude": 43.4687764
+"Longitude": -80.5958904
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 569 Violet Street, where comfort, space, and an incredible family-friendly location come together in one of Waterloo's most sought-after neighbourhoods. This beautifully maintained 4-bedroom home offers the flexibility today's families are looking for, with an additional upper-level room that can easily serve as a fourth bedroom, home office, playroom, or be converted back into a spacious family room. The primary suite is a true retreat, featuring a stunning brand-new ensuite and a generous walk-in closet designed for everyday comfort. The bright, functional main floor is perfect for both entertaining and daily living, with the kitchen opening onto a spacious deck overlooking the peaceful green space behind the home. Whether you're enjoying your morning coffee, hosting summer barbecues, or simply unwinding at the end of the day, the private backdrop of the Columbia Forest trail system creates a setting that's hard to beat. Downstairs, the finished walkout basement adds exceptional versatility with direct access to the backyard as well as a separate entrance through the garage, making it an excellent opportunity for multi-generational living or future in-law suite potential. Location is everything, and this home delivers. You're just a short walk to Abraham Erb Public School and Laurel Heights Secondary School, with scenic walking trails, parks, a newer splash pad, shopping, restaurants, the YMCA, public library, transit, and both universities all within easy reach. This is a neighbourhood known for its outstanding schools, beautiful green spaces, and welcoming community atmosphere. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:11:59.990060+00:00"
+"Directions": "Erbsville to Laurelwood"
+"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": "1921212"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T14:29:56Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:18:28Z"
+"Stories": "2.0"
+"StreetName": "VIOLET"
+"StreetNumber": "569"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5900.92"
+"VirtualTourURLUnbranded": "https://youriguide.com/569_violet_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29984123/569-violet-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1984162"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156376"
+"GeocodeManualYN": true
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1836
+"BelowGradeFinishedArea": 782
+"OriginalEntryTimestamp": "2026-07-03T14:29:56.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1226897"
+"ListOfficeNationalAssociationId": "1381240"
+"CoListAgentNationalAssociationId": "1268935"
+"CoListOfficeNationalAssociationId": "1003925"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984123')"
+"ID": "1589222"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "1589037"
+post_author: 1
+"ListingKey": "29984740"
+"ListingId": "X13518228"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:50:03Z"
+"RFModificationTimestamp": "2026-07-03T20:52:45Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T8"
+"UnparsedAddress": "569 VIOLET STREET, Waterloo, Ontario N2V2T8"
+"Coordinates": array:2 [
0 => -80.595899
1 => 43.468787
]
+"Latitude": 43.468787
+"Longitude": -80.595899
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 569 Violet Street, where comfort, space, and an incredible family-friendly location come together in one of Waterloo's most sought-after neighbourhoods. This beautifully maintained 4-bedroom home offers the flexibility today's families are looking for, with an additional upper-level room that can easily serve as a fourth bedroom, home office, playroom, or be converted back into a spacious family room. The primary suite is a true retreat, featuring a stunning brand-new ensuite and a generous walk-in closet designed for everyday comfort. The bright, functional main floor is perfect for both entertaining and daily living, with the kitchen opening onto a spacious deck overlooking the peaceful green space behind the home. Whether you're enjoying your morning coffee, hosting summer barbecues, or simply unwinding at the end of the day, the private backdrop of the Columbia Forest trail system creates a setting that's hard to beat. Downstairs, the finished walkout basement adds exceptional versatility with direct access to the backyard as well as a separate entrance through the garage, making it an excellent opportunity for multi-generational living or future in-law suite potential. Location is everything, and this home delivers. You're just a short walk to Abraham Erb Public School and Laurel Heights Secondary School, with scenic walking trails, parks, a newer splash pad, shopping, restaurants, the YMCA, public library, transit, and both universities all within easy reach. This is a neighbourhood known for its outstanding schools, beautiful green spaces, and welcoming community atmosphere. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T16:16:39.552339+00:00"
+"Directions": "Cross Streets: Laurelwood/Erbsville. ** Directions: Erbsville to Laurelwood."
+"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": "2099892"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Wooded area"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Carpet Free"
4 => "Sump Pump"
]
+"LotSizeDimensions": "30 x 102.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:40:19Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:40:30Z"
+"Stories": "2.0"
+"StreetName": "Violet"
+"StreetNumber": "569"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5900.92"
+"VirtualTourURLUnbranded": "https://youriguide.com/569_violet_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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/29984740/569-violet-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-07-03T15:40:19.68Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370040"
+"ListOfficeNationalAssociationId": "1381521"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984740')"
+"ID": "1589037"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1585264"
+post_author: 1
+"ListingKey": "29979277"
+"ListingId": "X13513406"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T00:20:40Z"
+"RFModificationTimestamp": "2026-07-03T00:23:03Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S1"
+"UnparsedAddress": "430 KELSO DRIVE, Waterloo, Ontario N2V2S1"
+"Coordinates": array:2 [
0 => -80.583859
1 => 43.490424
]
+"Latitude": 43.490424
+"Longitude": -80.583859
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 430 Kelso Drive, Waterloo: a beautifully maintained family home nestled in the highly sought-after Lakeshore North community. Situated on an impressive 44 x 139 ft. lot and just steps from the scenic Laurel Creek Conservation Area, this exceptional property offers fantastic curb appeal and parking for up to 4 vehicles, including a 2-car garage and 2-car private driveway. Step inside to a bright, carpet-free interior featuring soaring 9-foot ceilings, an open-concept layout and abundant natural light throughout. The kitchen comes complete with updated appliances, ample cabinetry, and generous counter space, making meal preparation effortless. The adjoining dining and living areas, anchored by a cozy electric fireplace create a warm, inviting atmosphere. Main floor laundry adds everyday convenience. Upstairs, you'll find 4 generously sized bedrooms and two full bathrooms, including a primary retreat with a walk-in closet and private ensuite. Designed with growing families in mind, the upper level offers both comfort and functionality. The fully finished basement adds tremendous versatility with a large recreation room, an additional bedroom and 3pc bathroom, ideal for extended family, guests, an in-law suite or mortgage-helper potential. This home has been thoughtfully upgraded for comfort and efficiency: a new heat pump (2024, doubling as central air), a two-stage furnace and refreshed R-60 attic insulation (2022) keep utility costs down year-round. Step outside to a huge, fully fenced, pool-sized backyard with a concrete patio, perfect for summer bbq's, family gatherings or simply relaxing. Set on a quiet street in one of Waterloo's most desirable neighbourhoods, this home is close to top-rated schools, parks, trails, universities, the YMCA, Conestoga Mall, shopping, restaurants, public transit, and major highways. A premium lot in an outstanding location, this house truly checks all the boxes. Don't miss your chance, book your private showing today! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:09:35.541665+00:00"
+"Directions": "Cross Streets: LakeLouise Blvd. ** Directions: Kelso Dr To LakeLouise Blvd."
+"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": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "44.8 x 139.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:29:47Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T00:13:07Z"
+"Stories": "2.0"
+"StreetName": "Kelso"
+"StreetNumber": "430"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6672"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/c95ms_430_kelso_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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29979277/430-kelso-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.9
+"OriginalEntryTimestamp": "2026-07-02T17:00:50.97Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979277')"
+"ID": "1585264"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1584362"
+post_author: 1
+"ListingKey": "29977664"
+"ListingId": "40842487"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:25:14Z"
+"RFModificationTimestamp": "2026-07-03T16:29:59Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "500 GLACIER Street, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5790234
1 => 43.4957774
]
+"Latitude": 43.4957774
+"Longitude": -80.5790234
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**PUBLIC OPEN HOUSE: SAT & SUN 2-4 PM** Welcome to 500 Glacier Street in Waterloo-your dream home with a spectacular backyard retreat, including a heated above-ground saltwater pool, backing onto greenspace & trails. Situated on an oversized corner lot in the highly desirable & family-oriented neighbourhood of Conservation Meadows, this lovely 4-bedroom, 3-bathroom home offers over 2,700 sq. ft. of finished living space, many recent updates & a bright, spacious open-concept layout perfect for entertaining or relaxing with family. The recently renovated gourmet kitchen features stainless steel appliances, a beautiful backsplash & a convenient centre island for casual dining, while the oversized dining area offers plenty of space for more formal gatherings. Relax & unwind in the sophisticated family room, complete with a gas fireplace, oversized windows & sliding door access to the expansive deck & pool area. A 2-piece bathroom & main floor laundry complete the main level. Upstairs, the stunning primary suite features vaulted ceilings, custom built-ins, two walk-in closets & a newly updated spa-like 3-piece ensuite with tiled glass shower, rain shower fixture, heated floors & heated towel rack. Two additional spacious bedrooms & a 4-piece main bathroom complete this level. The fully finished basement offers a large recreation room, a potential 4th bedroom & the added convenience of a walk-up directly into the garage.. Notable updates include furnace & air conditioning in 2017, shingles in 2015 & above-ground saltwater pool in 2018. Additional features include a carpet-free main & lower level with luxury vinyl flooring, custom blinds & more. Backing onto greenspace & walking trails, surrounded by mature trees & lush perennial gardens, this lovely home is located on a quiet, tree-lined street in a premium location close to schools, parks, Laurel Creek Conservation Area, shopping, restaurants, Starbucks, Sobeys, St. Jacobs Farmers’ Market, quick highway access & more. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:41:40.814366+00:00"
+"Directions": "Conservation Drive to Lake Louise to Glacier"
+"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": "1564122"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Corner Site"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:31:21Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:18:39Z"
+"Stories": "2.0"
+"StreetName": "GLACIER"
+"StreetNumber": "500"
+"StreetSuffix": "Street"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5653"
+"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977664/500-glacier-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 63.0
+"AboveGradeFinishedArea": 1854
+"BelowGradeFinishedArea": 879
+"OriginalEntryTimestamp": "2026-07-02T14:33:21.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1142829"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977664')"
+"ID": "1584362"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1583779"
+post_author: 1
+"ListingKey": "29977455"
+"ListingId": "40841745"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T18:45:15Z"
+"RFModificationTimestamp": "2026-07-02T19:10:05Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.144
+"LivingArea": 3238.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S5"
+"UnparsedAddress": "430 KELSO Drive, Waterloo, Ontario N2V2S5"
+"Coordinates": array:2 [
0 => -80.5838742
1 => 43.4904493
]
+"Latitude": 43.4904493
+"Longitude": -80.5838742
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 430 Kelso Drive, Waterloo: a beautifully maintained family home nestled in the highly sought-after Lakeshore North community. Situated on an impressive 44 x 139 ft. lot and just steps from the scenic Laurel Creek Conservation Area, this exceptional property offers fantastic curb appeal and parking for up to 4 vehicles, including a 2-car garage and 2-car private driveway. Step inside to a bright, carpet-free interior featuring soaring 9-foot ceilings, an open-concept layout and abundant natural light throughout. The kitchen comes complete with updated appliances, ample cabinetry, and generous counter space, making meal preparation effortless. The adjoining dining and living areas, anchored by a cozy electric fireplace create a warm, inviting atmosphere. Main floor laundry adds everyday convenience. Upstairs, you'll find 4 generously sized bedrooms and two full bathrooms, including a primary retreat with a walk-in closet and private ensuite. Designed with growing families in mind, the upper level offers both comfort and functionality. The fully finished basement adds tremendous versatility with a large recreation room, an additional bedroom and 3pc bathroom, ideal for extended family, guests, an in-law suite or mortgage-helper potential. This home has been thoughtfully upgraded for comfort and efficiency: a new heat pump (2024, doubling as central air), a two-stage furnace and refreshed R-60 attic insulation (2022) keep utility costs down year-round. Step outside to a huge, fully fenced, pool-sized backyard with a concrete patio, perfect for summer bbq's, family gatherings or simply relaxing. Set on a quiet street in one of Waterloo's most desirable neighbourhoods, this home is close to top-rated schools, parks, trails, universities, the YMCA, Conestoga Mall, shopping, restaurants, public transit, and major highways. A premium lot in an outstanding location, this house truly checks all the boxes. Don't miss your chance, book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "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-02T16:19:31.551916+00:00"
+"Directions": "Kelso Dr/LakeLouise Blvd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"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 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.144"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T18:34:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T18:34:06Z"
+"Stories": "2.0"
+"StreetName": "KELSO"
+"StreetNumber": "430"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "6672"
+"VirtualTourURLUnbranded": "https://youriguide.com/c95ms_430_kelso_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/29977455/430-kelso-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2250
+"BelowGradeFinishedArea": 988
+"OriginalEntryTimestamp": "2026-07-02T14:12:03.26Z"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977455')"
+"ID": "1583779"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1584541"
+post_author: 1
+"ListingKey": "29977329"
+"ListingId": "X13511442"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:20:05Z"
+"RFModificationTimestamp": "2026-07-03T15:27:41Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "500 GLACIER STREET, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.578434
1 => 43.495943
]
+"Latitude": 43.495943
+"Longitude": -80.578434
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "**PUBLIC OPEN HOUSE: SAT & SUN, 2-4 PM** Welcome to 500 Glacier Street in Waterloo - your dream home with a spectacular backyard retreat, including a heated above-ground saltwater pool, backing onto greenspace & trails. Situated on an oversized corner lot in the highly desirable & family-oriented neighbourhood of Conservation Meadows, this lovely 4-bed, 3-bath home offers over 2,700 sq. ft. of finished living space, many recent updates & a bright, spacious open-concept layout perfect for entertaining or relaxing with family. The recently renovated gourmet kitchen features stainless steel appliances, a beautiful backsplash & a convenient centre island for casual dining, while the oversized dining area offers plenty of space for more formal gatherings. Relax & unwind in the sophisticated family room, complete with a gas fireplace, oversized windows & sliding door access to the expansive deck & pool area. A 2-piece bathroom & main floor laundry complete the main level. Upstairs, the stunning primary suite features vaulted ceilings, custom built-ins, two walk-in closets & a newly updated spa-like 3-piece ensuite with tiled glass shower, rain shower fixture, heated floors & heated towel rack. Two additional spacious bedrooms & a 4-piece main bathroom complete this level. The fully finished basement offers a large recreation room, a potential 4th bedroom & the added convenience of a walk-up directly into the garage. Notable updates include furnace & air conditioning in 2017, shingles in 2015 & above-ground saltwater pool in 2018. Additional features include a carpet-free main & lower level with luxury vinyl flooring, custom blinds & more. Backing onto greenspace & walking trails, surrounded by mature trees & lush perennial gardens, this lovely home is located on a quiet, tree-lined street in a premium location close to schools, parks, Laurel Creek Conservation Area, shopping, restaurants, Starbucks, Sobeys, St. Jacobs Farmers' Market, quick highway access & more. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Treatment"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T15:52:13.449772+00:00"
+"Directions": "Cross Streets: Lake Louise Blvd. ** Directions: Conservation Drive to Lake Louise to Glacier."
+"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": "2099842"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wooded area"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"LotSizeDimensions": "63.1 x 124.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T15:37:24Z"
+"PhotosCount": 45
+"PoolFeatures": array:2 [
0 => "Above ground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:12:24Z"
+"Stories": "2.0"
+"StreetName": "Glacier"
+"StreetNumber": "500"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5653"
+"View": "View"
+"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/doc/floorplan_imperial.pdf"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29977329/500-glacier-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 63.1
+"OriginalEntryTimestamp": "2026-07-02T13:47:07.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370032"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977329')"
+"ID": "1584541"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: "1582426"
+post_author: 1
+"ListingKey": "29975146"
+"ListingId": "40843757"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T15:00:07Z"
+"RFModificationTimestamp": "2026-07-01T16:49:13Z"
+"ListPrice": 1995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3951.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2G3"
+"UnparsedAddress": "585 REGAL Place, Waterloo, Ontario N2V2G3"
+"Coordinates": array:2 [
0 => -80.6020125
1 => 43.4785166
]
+"Latitude": 43.4785166
+"Longitude": -80.6020125
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Positioned on a beautifully landscaped corner lot at the end of a quiet cul-de-sac, 585 Regal Place offers an exceptional blend of luxury, comfort, and everyday livability in one of Waterloo's most sought-after neighbourhoods. This former model home showcases over 4,300 sq. ft. of thoughtfully designed living space, including more than 3,500 sq. ft. on the main level, complemented by an oversized triple-car garage with soaring ceilings and a dedicated workshop area. A cobblestone driveway and covered front entrance introduce an impressive interior where 10-foot ceilings, expansive windows, and spacious principal rooms create an inviting atmosphere filled with natural light. The chef-inspired kitchen serves as the heart of the home, offering custom cabinetry, granite countertops, premium appliances, a large island, and seamless access to the breakfast area and covered outdoor living space, making entertaining effortless in every season. Elegant formal living and dining rooms provide refined spaces for hosting, accented by rich hardwood flooring, statement lighting, and walls perfectly suited for displaying artwork. The luxurious primary suite is a private sanctuary featuring a spa-inspired ensuite with a double-sided fireplace, soaker tub, and an expansive custom dressing room. Two additional bedrooms, including a private ensuite, a dedicated home office, main-floor laundry, and a beautifully finished lower level with recreation, fitness, and guest accommodations ensure flexibility for every stage of life. Professionally landscaped gardens, mature trees, and multiple outdoor seating areas create a peaceful setting to relax or entertain. Just minutes from championship golf, scenic walking trails, the St. Jacobs Farmers' Market, shopping, and highly regarded schools, this remarkable residence delivers the space, quality, and lifestyle today's discerning buyer is seeking. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T16:49:07.978429+00:00"
+"Directions": "Erbsville Rd to Regal Place"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564461"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T14:50:30Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T14:50:30Z"
+"Stories": "1.0"
+"StreetName": "REGAL"
+"StreetNumber": "585"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "18533"
+"VirtualTourURLUnbranded": "https://youriguide.com/585_regal_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29975146/585-regal-place-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Monitored Alarm"
]
+"ZoningDescription": "SR4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 87.0
+"AboveGradeFinishedArea": 3181
+"BelowGradeFinishedArea": 770
+"OriginalEntryTimestamp": "2026-07-01T14:50:30.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070059"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975146')"
+"ID": "1582426"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1582284"
+post_author: 1
+"ListingKey": "29974955"
+"ListingId": "40840178"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T17:00:10Z"
+"RFModificationTimestamp": "2026-07-01T17:11:48Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1929.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W5"
+"UnparsedAddress": "980 CREEKSIDE Drive, Waterloo, Ontario N2V2W5"
+"Coordinates": array:2 [
0 => -80.5995972
1 => 43.4717177
]
+"Latitude": 43.4717177
+"Longitude": -80.5995972
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 980 Creekside Drive, a move-in-ready freehold townhome in Waterloo’s highly sought-after Laurelwood community — an ideal starter home for young families looking to settle near top-rated schools, parks, shopping, and everyday conveniences. This well-maintained 3-bedroom, 3.5-bathroom two-storey home offers a bright and functional open-concept main floor with a carpet-free layout, laminate flooring, and sliding doors leading to a private deck and fully fenced backyard — perfect for children, pets, and outdoor family time. The kitchen features ample cabinetry, stainless steel appliances, and a sleek glass backsplash, creating a practical and inviting space for busy family living. Upstairs, the spacious primary bedroom includes a walk-in closet with organizer and private ensuite, while the additional bedrooms are well-sized for children, guests, or a home office. The fully finished lower level provides valuable extra living space with a recreation room, 3-piece bathroom, laundry area, and storage room — ideal for a playroom, family movie nights, or a flexible work-from-home setup. Located within walking distance to schools, shopping, public transit, and close to the YMCA, universities, The Boardwalk, St. Jacobs Farmers’ Market, and the Waterloo Costco, this home offers the perfect blend of comfort, convenience, and community. A fantastic opportunity for first-time buyers and young families to own a move-in-ready home in one of Waterloo’s most desirable family-friendly neighbourhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"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-01T14:51:04.303021+00:00"
+"Directions": "Laurelwood Drive Erbsville Road"
+"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": "2130071"
+"ListOfficeKey": "300812"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T16:40:42Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T16:51:27Z"
+"Stories": "2.0"
+"StreetName": "CREEKSIDE"
+"StreetNumber": "980"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "3521"
+"VirtualTourURLUnbranded": "https://realty.pixsouls.com/980-Creekside-Dr"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"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/29974955/980-creekside-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR50"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1408
+"BelowGradeFinishedArea": 521
+"OriginalEntryTimestamp": "2026-07-01T14:10:29.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1382995"
+"ListOfficeNationalAssociationId": "1493167"
+"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('29974955')"
+"ID": "1582284"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 81
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]