array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29089434/Property?$select=ALL&$top=20&$filter=ListingKey eq 29089434&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29089434/Property?$select=ALL&$top=20&$filter=ListingKey eq 29089434&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23276
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23278
+post_id: "408322"
+post_author: 1
+"ListingKey": "29089434"
+"ListingId": "40787290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-21T02:15:15Z"
+"RFModificationTimestamp": "2025-11-21T02:17:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2447.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Z4"
+"UnparsedAddress": "241 RASPBERRY Place, Waterloo, Ontario N2T2Z4"
+"Coordinates": array:2 [
0 => -80.5863377
1 => 43.45122039
]
+"Latitude": 43.45122039
+"Longitude": -80.5863377
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "For Lease - This beautiful 4-bedroom, 4 wash. A Family home features a convenient main-floor bedroom, ideal for guests or multi-generational living. Enjoy cozy evenings in a spacious home with a double garage, just minutes from the highly-rated Vista Hills Public School perfect for busy mornings. With Costco, Walmart, and a variety of dining and shopping options nearby, everything you need is within reach. Plus, major universities are just a short drive away, making this location perfect for families and students. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-11T03:44:17.300803+00:00"
+"Directions": "Ladyslipper Drive to Raspberry Place"
+"ExteriorFeatures": array:5 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
3 => "Vinyl siding"
4 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109542"
+"ListOfficeKey": "288733"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-10T23:38:28Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-21T02:01:10Z"
+"Stories": "2.0"
+"StreetName": "RASPBERRY"
+"StreetNumber": "241"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1537287043"
"RoomType" => "5pc Bathroom"
"ListingId" => "40787290"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.08Z"
]
1 => array:11 [
"RoomKey" => "1537287044"
"RoomType" => "Laundry room"
"ListingId" => "40787290"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.08Z"
]
2 => array:11 [
"RoomKey" => "1537287045"
"RoomType" => "Bedroom"
"ListingId" => "40787290"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.08Z"
]
3 => array:11 [
"RoomKey" => "1537287046"
"RoomType" => "Bedroom"
"ListingId" => "40787290"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.09Z"
]
4 => array:11 [
"RoomKey" => "1537287047"
"RoomType" => "5pc Bathroom"
"ListingId" => "40787290"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.09Z"
]
5 => array:11 [
"RoomKey" => "1537287048"
"RoomType" => "Primary Bedroom"
"ListingId" => "40787290"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.09Z"
]
6 => array:11 [
"RoomKey" => "1537287049"
"RoomType" => "3pc Bathroom"
"ListingId" => "40787290"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.09Z"
]
7 => array:11 [
"RoomKey" => "1537287050"
"RoomType" => "2pc Bathroom"
"ListingId" => "40787290"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.09Z"
]
8 => array:11 [
"RoomKey" => "1537287051"
"RoomType" => "Bedroom"
"ListingId" => "40787290"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.09Z"
]
9 => array:11 [
"RoomKey" => "1537287052"
"RoomType" => "Kitchen"
"ListingId" => "40787290"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.1Z"
]
10 => array:11 [
"RoomKey" => "1537287053"
"RoomType" => "Living room"
"ListingId" => "40787290"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.1Z"
]
11 => array:11 [
"RoomKey" => "1537287054"
"RoomType" => "Other"
"ListingId" => "40787290"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => "16'3'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.1Z"
]
12 => array:11 [
"RoomKey" => "1537287055"
"RoomType" => "Foyer"
"ListingId" => "40787290"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29089434"
"RoomLength" => null
"RoomDimensions" => "16'7'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-21T02:01:10.1Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29089434/241-raspberry-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2141441"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289615"
+"TotalActualRent": 3499
+"ZoningDescription": "R6-FT"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 2447
+"OriginalEntryTimestamp": "2025-11-10T23:38:28.16Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:37 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6307882082"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/84bdb5790c11f423f84d409d6bc5cfb6.webp"
"MediaSize" => 98401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-84bdb5790c11f423f84d409d6bc5cfb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6307882086"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/125934066bb021c9b55f29b8027689cb.webp"
"MediaSize" => 100004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-125934066bb021c9b55f29b8027689cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6307882096"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/9f0a1fcd44ba1e805c993efdba421f58.webp"
"MediaSize" => 96636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-9f0a1fcd44ba1e805c993efdba421f58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6307882158"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/de9a1608587885de32571ca78fe15f2d.webp"
"MediaSize" => 42880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-de9a1608587885de32571ca78fe15f2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6307882191"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/84bc2d5c57f9f767a3d173f53530679e.webp"
"MediaSize" => 43299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-84bc2d5c57f9f767a3d173f53530679e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6307882192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/cf3aa8500d8652ace7594e539bd68ca6.webp"
"MediaSize" => 48788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-cf3aa8500d8652ace7594e539bd68ca6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6307882237"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/c39151329fb9b936657585fa074b36ad.webp"
"MediaSize" => 67910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-c39151329fb9b936657585fa074b36ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6307882272"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/a55499c8885e4dd0d57575356d1488f6.webp"
"MediaSize" => 51379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-a55499c8885e4dd0d57575356d1488f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6307882335"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/84055e8fc51057efb5f71e77a4f1bfa6.webp"
"MediaSize" => 42645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-84055e8fc51057efb5f71e77a4f1bfa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6307882357"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/966f2d7c2f569c36f4530803e1956d86.webp"
"MediaSize" => 28221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-966f2d7c2f569c36f4530803e1956d86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6307882362"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/31ad30bd903c24d2ef358ea691c40b46.webp"
"MediaSize" => 31817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-31ad30bd903c24d2ef358ea691c40b46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6307882390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/0be67342777c9b276a586012a44970e6.webp"
"MediaSize" => 57215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-0be67342777c9b276a586012a44970e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6307882391"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/7955a4263f5bedfe428911a48b7a6347.webp"
"MediaSize" => 29443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-7955a4263f5bedfe428911a48b7a6347.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6307882401"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/4977e0c47167aa87f77c2bca605cab55.webp"
"MediaSize" => 27391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-4977e0c47167aa87f77c2bca605cab55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6307882419"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/54a187aab057b075d215aecf4e38c5d0.webp"
"MediaSize" => 44695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-54a187aab057b075d215aecf4e38c5d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6307882444"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/1a8b61faf3ca7867d9520b190f5dfcc8.webp"
"MediaSize" => 44157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-1a8b61faf3ca7867d9520b190f5dfcc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6307882479"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/72238147ec6bc0a56ab2266586005f20.webp"
"MediaSize" => 50259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-72238147ec6bc0a56ab2266586005f20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6307882504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/399d7590a4dd442b445adc37e03bbe21.webp"
"MediaSize" => 38469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-399d7590a4dd442b445adc37e03bbe21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6307882544"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/40dd6ffb708bd2a487450bdf0e43b48c.webp"
"MediaSize" => 41404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-40dd6ffb708bd2a487450bdf0e43b48c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6307882583"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/8c38c10edd301b39f0785560fb9048e0.webp"
"MediaSize" => 64237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-8c38c10edd301b39f0785560fb9048e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6307882596"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/a0e338c5341784b49a1eeedf2807a749.webp"
"MediaSize" => 49653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-a0e338c5341784b49a1eeedf2807a749.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6307882632"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/077481a9b0fdb2455fd2047f20fb1f15.webp"
"MediaSize" => 36186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-077481a9b0fdb2455fd2047f20fb1f15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6307882700"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/d7da04b124fd296265d5f5839bfa8779.webp"
"MediaSize" => 32536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-d7da04b124fd296265d5f5839bfa8779.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6307882759"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/a0c20f1c18b3a7efc3fed73444948d59.webp"
"MediaSize" => 37162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-a0c20f1c18b3a7efc3fed73444948d59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6307882816"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/2e6426081572f9dd693834699695d8c5.webp"
"MediaSize" => 32339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-2e6426081572f9dd693834699695d8c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6307882892"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/4ee8085dab2966696ae1e5c390b4bb11.webp"
"MediaSize" => 38141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-4ee8085dab2966696ae1e5c390b4bb11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6307882906"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/564f08b9c2f881d5e4c072d2345f6d4b.webp"
"MediaSize" => 34084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-564f08b9c2f881d5e4c072d2345f6d4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6307882994"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/a273b62cf733c97f7e32a7eced038e2b.webp"
"MediaSize" => 37172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-a273b62cf733c97f7e32a7eced038e2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6307883053"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/15fcb9c7328aa4211e1cd4e059726c02.webp"
"MediaSize" => 51685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-15fcb9c7328aa4211e1cd4e059726c02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6307883113"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/9386d0ce7cefc875321952df383be32d.webp"
"MediaSize" => 91017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-9386d0ce7cefc875321952df383be32d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6307883146"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/39ea472d058a2898d4df40b6cd52dd26.webp"
"MediaSize" => 72915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-39ea472d058a2898d4df40b6cd52dd26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6307883216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/d69ebbc41aa871fcfddd249e765c92a5.webp"
"MediaSize" => 108743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-d69ebbc41aa871fcfddd249e765c92a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6307883286"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/6412233a89a35b12f0abe3737309e94f.webp"
"MediaSize" => 108684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-6412233a89a35b12f0abe3737309e94f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6307883309"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/0732bbee758e5cf608ddfc39ebe36dbb.webp"
"MediaSize" => 94365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-0732bbee758e5cf608ddfc39ebe36dbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6307883371"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/97ce7ad521b56b4a033446736569032b.webp"
"MediaSize" => 108814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-97ce7ad521b56b4a033446736569032b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6307883436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/2c53551f4fcee093c88b37a99daa0d66.webp"
"MediaSize" => 105171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-2c53551f4fcee093c88b37a99daa0d66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6307883488"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29089434/48edf3ce8adadce0c28d5ba93d9b6ae5.webp"
"MediaSize" => 96811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29089434/thumbnail-48edf3ce8adadce0c28d5ba93d9b6ae5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787290"
"ResourceRecordKey" => "29089434"
"ModificationTimestamp" => "2025-11-10T23:38:28.17Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29089434')"
+"ID": "408322"
}
]
+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=OfficeKey eq 288733/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288733&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288733/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288733&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25124
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25126
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "EXP REALTY OF CANADA INC"
+"OfficeEmail": null
+"OfficePhone": "866-530-7737"
+"OfficeMlsId": "MIB133"
+"ModificationTimestamp": "2025-10-15T17:55:44Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "288733"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "14 30 Eglinton Avenue West Unit 451"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Mississauga"
+"OfficePostalCode": "L5R0C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1371169"
+"OriginalEntryTimestamp": "2020-10-08T20:59:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "348996"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "288733"
"SocialMediaUrlOrId" => "http://www.exprealty.ca/"
"ModificationTimestamp" => "2025-10-15T15:58:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1489451"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('288733')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2109542/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2109542&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2109542/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2109542&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25129
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29089434" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24721
+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 29089434/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29089434&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29089434/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29089434&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24701
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29089434 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5863377 43.45122039)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29089434 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5863377 43.45122039)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29089434 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5863377 43.45122039)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29089434 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5863377 43.45122039)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24972
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24966
+post_id: "446630"
+post_author: 1
+"ListingKey": "29140359"
+"ListingId": "X12580000"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T22:40:42Z"
+"RFModificationTimestamp": "2025-11-26T22:43:06Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "565 SUNDEW DRIVE, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.5978521
1 => 43.4581856
]
+"Latitude": 43.4581856
+"Longitude": -80.5978521
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 565 Sundew Drive, Waterloo - A Bright, Spacious & Modern Family Home in Sought-After Vista Hills Discover this large and impressive custom designed home, with 3.5-baths and over 4,200 sq. ft. of beautifully finished living space (2,937 sqft above grade), in the family-friendly new Vista Hills community. Designed with modern family living in mind, this home features a highly desirable open-concept layout, 9 ft ceilings, abundant oversized windows, and an incredible flow of natural light throughout. Entering the main floor, you are overwhelmed by the feeling of expansiveness with the huge living room, family room and kitchen. The renovated modern kitchen is a true centerpiece, featuring shaker cabinets, quartz countertops, stainless steel appliances and large pantry. Garden patio doors invite you to a backyard oasis with a private deck, pergola, louvered privacy screens, interlock patio, and mature landscaping - an ideal setting for outdoor dining, relaxation, and hosting guests. Upstairs, double doors open to a large master bedroom with ensuite bath and a private balcony. Two additional oversized bedrooms and a main bathroom with rough-in for a future sauna, 3rd upstairs bathroom or upper level laundry. The professionally finished basement provides two additional rooms ideal for bedrooms, office, or guest space, along with a lavish spa-like bathroom featuring a stylish soaker tub and heated towel rack. A perfect opportunity for professional families seeking a modern home in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:4 [
0 => "Water purifier"
1 => "Water softener"
2 => "Garage door opener remote(s)"
3 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T22:42:54.117075+00:00"
+"Directions": "Cross Streets: Columbia Street W. ** Directions: Columbia turns into Sundew. Stay on Sundew and unit is on the left."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2016676"
+"ListOfficeKey": "50449"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "38 x 98.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:00:22Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:28:56Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "565"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7537.69"
+"VirtualTourURLUnbranded": "https://mediatours.ca/property/565-sundew-drive-waterloo-s/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1540614903"
"RoomType" => "Living room"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 4.85
"ListingKey" => "29140359"
"RoomLength" => 5.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.35Z"
]
1 => array:11 [
"RoomKey" => "1540614904"
"RoomType" => "Utility room"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.06
"ListingKey" => "29140359"
"RoomLength" => 3.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.35Z"
]
2 => array:11 [
"RoomKey" => "1540614905"
"RoomType" => "Other"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 2.49
"ListingKey" => "29140359"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
3 => array:11 [
"RoomKey" => "1540614906"
"RoomType" => "Kitchen"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 4.19
"ListingKey" => "29140359"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
4 => array:11 [
"RoomKey" => "1540614907"
"RoomType" => "Dining room"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "29140359"
"RoomLength" => 4.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
5 => array:11 [
"RoomKey" => "1540614908"
"RoomType" => "Family room"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 4.65
"ListingKey" => "29140359"
"RoomLength" => 5.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
6 => array:11 [
"RoomKey" => "1540614909"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 5.94
"ListingKey" => "29140359"
"RoomLength" => 6.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
7 => array:11 [
"RoomKey" => "1540614910"
"RoomType" => "Bedroom 2"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 4.88
"ListingKey" => "29140359"
"RoomLength" => 5.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
8 => array:11 [
"RoomKey" => "1540614911"
"RoomType" => "Bedroom 3"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 3.81
"ListingKey" => "29140359"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
9 => array:11 [
"RoomKey" => "1540614912"
"RoomType" => "Bedroom 3"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.37
"ListingKey" => "29140359"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
10 => array:11 [
"RoomKey" => "1540614913"
"RoomType" => "Bedroom 4"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.94
"ListingKey" => "29140359"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
11 => array:11 [
"RoomKey" => "1540614914"
"RoomType" => "Laundry room"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.26
"ListingKey" => "29140359"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140359/565-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 38.0
+"OriginalEntryTimestamp": "2025-11-26T22:00:22.57Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:35 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341680706"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/a6958272eb5bfc3241075427bef8cbe1.webp"
"MediaSize" => 326682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-a6958272eb5bfc3241075427bef8cbe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341680714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/03446f598dd1616612df9127a7b92739.webp"
"MediaSize" => 311795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-03446f598dd1616612df9127a7b92739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341680740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/36ae64c62abea11b82440d2f7e07bfa2.webp"
"MediaSize" => 103164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-36ae64c62abea11b82440d2f7e07bfa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341680762"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/bc4258c5780aa67c9885ce6f75534732.webp"
"MediaSize" => 133125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-bc4258c5780aa67c9885ce6f75534732.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341680793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/729fb0ef6043b46b4d501aeb0172bb93.webp"
"MediaSize" => 162289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-729fb0ef6043b46b4d501aeb0172bb93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341680840"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/426614cb17bc45f88291e46c3bab48de.webp"
"MediaSize" => 158510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-426614cb17bc45f88291e46c3bab48de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341680849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/b48e3cbfa50a1b4a644417f55d0fe129.webp"
"MediaSize" => 158232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-b48e3cbfa50a1b4a644417f55d0fe129.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341680901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/ac3101458843806bb86eac364f94ae30.webp"
"MediaSize" => 148875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-ac3101458843806bb86eac364f94ae30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6341680938"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/373858709216e91065bb8d3b5aee5f98.webp"
"MediaSize" => 169527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-373858709216e91065bb8d3b5aee5f98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6341680954"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/0b02c4ee7e8715b056a2b3aea5f55609.webp"
"MediaSize" => 181420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-0b02c4ee7e8715b056a2b3aea5f55609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6341680962"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/f9bed34e8437fb16e0aa37f30ad9f3b2.webp"
"MediaSize" => 159930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-f9bed34e8437fb16e0aa37f30ad9f3b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6341680984"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/a810452ccf96fdc5f48fa544cb71ceaf.webp"
"MediaSize" => 89924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-a810452ccf96fdc5f48fa544cb71ceaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6341680993"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/47a5ba96aa026eb67c8a5219c8b2b8b5.webp"
"MediaSize" => 93611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-47a5ba96aa026eb67c8a5219c8b2b8b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6341681028"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/4fcdf57f8568f80bde058ccea8ab9f50.webp"
"MediaSize" => 97871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-4fcdf57f8568f80bde058ccea8ab9f50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6341681056"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/cc9eccf4cdf173aea0f5cd6d94e4628a.webp"
"MediaSize" => 145522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-cc9eccf4cdf173aea0f5cd6d94e4628a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6341681121"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/ea1b6ca463c9fd0f380f45d773c5a2ba.webp"
"MediaSize" => 154576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-ea1b6ca463c9fd0f380f45d773c5a2ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6341681173"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/5c1b86590c94317829818b2044d210a2.webp"
"MediaSize" => 112011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-5c1b86590c94317829818b2044d210a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6341681217"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/3aa28b784c81ee371ee7290bd1806e46.webp"
"MediaSize" => 92679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-3aa28b784c81ee371ee7290bd1806e46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6341681220"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/8deef329c6f7e4740d4c099ccedf878a.webp"
"MediaSize" => 126866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-8deef329c6f7e4740d4c099ccedf878a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140359')"
+"ID": "446630"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24968
+post_id: "439187"
+post_author: 1
+"ListingKey": "29129641"
+"ListingId": "40789908"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T22:15:22Z"
+"RFModificationTimestamp": "2025-11-23T00:55:39Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1022.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 10, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.5881467
1 => 43.4502053
]
+"Latitude": 43.4502053
+"Longitude": -80.5881467
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to #10-142 Foamflower! Discover this charming, brand-new stacked townhome rental that stands out with its thoughtful updates and modern features. Enjoy the highly sought-after open concept living space, highlighted by a stunning kitchen equipped with quartz countertops, under-cabinet lighting, and recessed lighting. The spacious kitchen island features brand-new stainless steel appliances and large pot drawers-a space any chef would be proud of. This home offers two generously sized bedrooms, including a Primary suite with a walk-in closet and ensuite bathroom. The ensuite boasts a walk-in tiled shower with a rainfall showerhead, adding a touch of luxury. Relax on the sun-filled rear balcony—perfect for enjoying your morning coffee or unwinding in the evening. Location Highlights: Costco The Boardwalk Medical Center Landmark Cinema Close to numerous schools including grade schools high schools, Conestoga College, Laurier University and also a ten minute from the University of Waterloo, making it an ideal location for students and faculty. Don't miss your chance to make this beautiful townhome your new home! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"AssociationFeeIncludes": array:1 [
0 => "Property Management"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-23T00:55:38.042202+00:00"
+"Directions": "Platinum Dr and Columbia St W"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192898"
+"ListOfficeKey": "76844"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Industrial mall/subdivision"
]
+"PhotosChangeTimestamp": "2025-11-22T22:08:47Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T22:08:47Z"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29129641/142-foamflower-place-unit-10-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Leasehold"
+"TotalActualRent": 2500
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 5.0
+"AboveGradeFinishedArea": 1022
+"OriginalEntryTimestamp": "2025-11-22T22:08:47.45Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:7 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29129641')"
+"ID": "439187"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24665
+post_id: "435046"
+post_author: 1
+"ListingKey": "29124115"
+"ListingId": "40788966"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T21:40:11Z"
+"RFModificationTimestamp": "2025-11-22T21:40:41Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.075
+"LivingArea": 2335.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "664 BRANDENBURG Boulevard, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.5800713
1 => 43.4582785
]
+"Latitude": 43.4582785
+"Longitude": -80.5800713
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A home your family has been waiting for in highly sought-after Clair Hills! Pride of ownership shines throughout this beautifully maintained, fully finished home. Step through the attractive double French doors into a spacious foyer with an oversized closet, leading to the carpet-free main floor enhanced with crown moulding. The chef-inspired kitchen features granite countertops, under-cabinet lighting, a built-in pantry, a stunning stone backsplash, and an over-the-range hood microwave. The bright dining area offers walkout sliders to a 12’ x 12’ deck overlooking a fantastic backyard with a serene pond feature. A welcoming living room with bamboo flooring and a convenient 3-piece bathroom complete the main level. Upstairs, the primary bedroom retreat includes a walk-in closet with excellent storage. Two additional generously sized bedrooms and a spacious 4-piece bathroom complete the second floor. The finished basement provides extra living and entertaining space, featuring a cozy rec room with a gas fireplace. Enjoy the tranquil backyard setting with no rear neighbours—a rare find. Close to great schools, parks, and all amenities. Updates include: Furnace (2023), Air Conditioner (2023), Hot Water Tank (2025), Freshly Painted Throughout (2025), New Carpet (2025). (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Hood Fan"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T01:22:14.513331+00:00"
+"Directions": "Erbsville Road to Brandenburg Boulevard"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Gazebo"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.075"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-21T16:21:56Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T21:29:51Z"
+"Stories": "2.0"
+"StreetName": "BRANDENBURG"
+"StreetNumber": "664"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4535"
+"View": "View of water"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/bc3mv_664_brandenburg_blvd_waterloo_on/"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Sand point"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29124115/664-brandenburg-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1637
+"BelowGradeFinishedArea": 698
+"OriginalEntryTimestamp": "2025-11-20T22:38:37.33Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"Media": array:24 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29124115')"
+"ID": "435046"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24969
+post_id: "432634"
+post_author: 1
+"ListingKey": "29121239"
+"ListingId": "X12561550"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T19:46:04Z"
+"RFModificationTimestamp": "2025-11-26T00:11:05Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 4
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B7"
+"UnparsedAddress": "22 - 435 WINCHESTER DRIVE, Waterloo, Ontario N2T0B7"
+"Coordinates": array:2 [
0 => -80.561888
1 => 43.452439
]
+"Latitude": 43.452439
+"Longitude": -80.561888
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "DISCOVER LIFE IN THE VILLAGE. A rare executive townhome with over 3,100 sqft. of beautifully finished living space, offering privacy and convenience in a quiet enclave ideal for retirees, or busy professionals. The home makes a strong first impression with its attached double garage and meticulous curb appeal. Inside, you're greeted by an open concept main floor with a bright kitchen featuring granite countertops and ample cabinetry, a welcoming dining area and a living room with a cozy gas fireplace. Large windows fill the space with natural light and provide clear views of McCrae Park. A convenient 2 piece bathroom completes this level. Upstairs, a versatile family room provides additional living space or a dedicated office. The primary bedroom includes a walk-in closet and a luxurious 5 piece ensuite. The second bedroom also features its own walk-in closet and a 4 piece ensuite. The laundry room completes the upper level. The fully finished basement offers a large recreation room and a full 4 piece bathroom. Outside, enjoy a private patio area with a gas BBQ hookup. Living in Beechwood means enjoying one of Waterloo's most desirable and peaceful neighbourhoods, with nearby amenities, top rated schools and quick access to Uptown Waterloo. Homes in The Village rarely come to market, so this is an opportunity not to be missed. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener"
]
+"AssociationFee": "617.18"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 4
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-20T15:41:10.504292+00:00"
+"Directions": "Cross Streets: Fischer-Hallman Road. ** Directions: Fischer-Hallman Road to Winchester Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093834"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Backs on greenbelt"
1 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T14:49:25Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T19:34:31Z"
+"Stories": "2.0"
+"StreetName": "Winchester"
+"StreetNumber": "435"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8111.22"
+"VirtualTourURLUnbranded": "https://youriguide.com/435_winchester_dr_waterloo_on/"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29121239/22-435-winchester-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-20T14:49:24.91Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29121239')"
+"ID": "432634"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24967
+post_id: "430777"
+post_author: 1
+"ListingKey": "29118735"
+"ListingId": "40789294"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T16:30:28Z"
+"RFModificationTimestamp": "2025-11-26T16:34:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1498.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y7"
+"UnparsedAddress": "567 CHABLIS Drive, Waterloo, Ontario N2T2Y7"
+"Coordinates": array:2 [
0 => -80.573577
1 => 43.449765
]
+"Latitude": 43.449765
+"Longitude": -80.573577
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful and immaculately clean open-concept 2 story end unit townhome is truly a family's delight. Close to many elementary schools, universities, shopping, highways and other amenities. Contact us today to see this rental unit! 3 Bedrooms 2.5 Bathrooms with Soaker Tubs Finished Basement 5 Appliances Including Main Floor Laundry Central Air Conditioning Water Softener Garage with Opener Multi-Car Parking Deck Fenced Yard Mix of Hardwood, Tile & Carpet ** Available NOW!! ** *Non-Smoking Unit* *Tenant Insurance is Mandatory and Must be Provided on Move in Day* *Any Unit Listed by KWP That States All Inclusive Will Have a Cap Included* *See sales brochure below for showing instructions* (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T19:57:34.508163+00:00"
+"Directions": "Erbsville Rd From Erb Street West take first right on the round-about to Erbsville Road and take left on Chablis Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T19:00:35Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T16:18:56Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "567"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29118735/567-chablis-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2600
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 26.0
+"AboveGradeFinishedArea": 1498
+"OriginalEntryTimestamp": "2025-11-19T19:00:35.29Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:13 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29118735')"
+"ID": "430777"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24982
+post_id: "426760"
+post_author: 1
+"ListingKey": "29113730"
+"ListingId": "X12554306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T13:40:58Z"
+"RFModificationTimestamp": "2025-11-24T13:45:37Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X9"
+"UnparsedAddress": "707 PARIS BOULEVARD, Waterloo, Ontario N2T2X9"
+"Coordinates": array:2 [
0 => -80.574404
1 => 43.451072
]
+"Latitude": 43.451072
+"Longitude": -80.574404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A warm and inviting 3-bed, 2.5-bath family home located in one of Waterloo's most convenient and sought-after neighbourhoods. Bright, stylish, and beautifully maintained, this home offers a functional layout with modern finishes and an airy atmosphere throughout. Step inside to a spacious kitchen featuring white cabinetry, stainless steel appliances, and generous counter space-perfect for everyday cooking and entertaining. The kitchen opens seamlessly into the show-stopping living and dining area, where soaring cathedral ceilings and abundant natural light create an impressive, open-concept space. From here, sliding doors lead directly to the backyard deck, making indoor-outdoor living and summer barbecues effortless. Upstairs, you'll find three comfortable bedrooms, including a serene primary suite with soft neutral tones and ample closet space. The additional bedrooms are ideal for children, guests, or home offices, offering flexibility for today's lifestyle. The insulated and drywalled basement is ready for your finishing touches-ideal for a rec room, gym, or additional living space-and includes a central vac rough-in for added convenience. Outside, the fully fenced yard provides privacy, room to play, and space to relax, complete with a deck and storage shed. The low-maintenance yard offers year-round enjoyment with plenty of space for gardening, pets, or entertaining. Located just minutes from Edna Staebler Public School, parks, trails, and a wide selection of shopping and amenities, this home offers exceptional convenience in a family-friendly community. Whether you're a first-time buyer, growing family, or downsizer seeking comfort and function, 707 Paris Boulevard delivers a welcoming lifestyle in a prime Waterloo location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T17:56:49.946565+00:00"
+"Directions": "Cross Streets: Brandenburg Blvd. ** Directions: From Erbsville Rd to Brandenburg Blvd to Paris Blvd."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093590"
+"ListOfficeKey": "294121"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "28 x 106.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-18T16:58:07Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T13:24:15Z"
+"Stories": "2.0"
+"StreetName": "Paris"
+"StreetNumber": "707"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4069"
+"VirtualTourURLUnbranded": "https://youriguide.com/707_paris_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29113730/707-paris-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2025-11-18T16:58:06.95Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:39 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29113730')"
+"ID": "426760"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23290
+post_id: "426427"
+post_author: 1
+"ListingKey": "29113065"
+"ListingId": "40788324"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-23T22:45:13Z"
+"RFModificationTimestamp": "2025-11-23T22:46:31Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.068
+"LivingArea": 1921.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X9"
+"UnparsedAddress": "707 PARIS Boulevard, Waterloo, Ontario N2T2X9"
+"Coordinates": array:2 [
0 => -80.5744431
1 => 43.4510713
]
+"Latitude": 43.4510713
+"Longitude": -80.5744431
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A warm and inviting 3-bed, 2.5-bath family home located in one of Waterloo’s most convenient and sought-after neighbourhoods. Bright, stylish, and beautifully maintained, this home offers a functional layout with modern finishes and an airy atmosphere throughout. Step inside to a spacious kitchen featuring white cabinetry, stainless steel appliances, and generous counter space—perfect for everyday cooking and entertaining. The kitchen opens seamlessly into the show-stopping living and dining area, where soaring cathedral ceilings and abundant natural light create an impressive, open-concept space. From here, sliding doors lead directly to the backyard deck, making indoor-outdoor living and summer barbecues effortless. Upstairs, you’ll find three comfortable bedrooms, including a serene primary suite with soft neutral tones and ample closet space. The additional bedrooms are ideal for children, guests, or home offices, offering flexibility for today’s lifestyle. The insulated and drywalled basement is ready for your finishing touches—ideal for a rec room, gym, or additional living space—and includes a central vac rough-in for added convenience. Outside, the fully fenced yard provides privacy, room to play, and space to relax, complete with a deck and storage shed. The low-maintenance yard offers year-round enjoyment with plenty of space for gardening, pets, or entertaining. Located just minutes from Edna Staebler Public School, parks, trails, and a wide selection of shopping and amenities, this home offers exceptional convenience in a family-friendly community. Whether you’re a first-time buyer, growing family, or downsizer seeking comfort and function, 707 Paris Boulevard delivers a welcoming lifestyle in a prime Waterloo location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Central Vacuum - Roughed In"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T15:35:59.017951+00:00"
+"Directions": "From Erbsville Rd to Brandenburg Blvd to Paris Blvd"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600677"
+"ListOfficeKey": "294047"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0.068"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-18T14:00:23Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-23T22:30:23Z"
+"Stories": "2.0"
+"StreetName": "PARIS"
+"StreetNumber": "707"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4069"
+"VirtualTourURLUnbranded": "https://youriguide.com/707_paris_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29113065/707-paris-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1308
+"BelowGradeFinishedArea": 613
+"OriginalEntryTimestamp": "2025-11-18T14:00:23.01Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:42 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29113065')"
+"ID": "426427"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24970
+post_id: "419557"
+post_author: 1
+"ListingKey": "29098594"
+"ListingId": "40787765"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T17:45:17Z"
+"RFModificationTimestamp": "2025-11-20T17:46:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.114
+"LivingArea": 3300.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C4"
+"UnparsedAddress": "722 SUNDEW Drive, Waterloo, Ontario N2V0C4"
+"Coordinates": array:2 [
0 => -80.6026665
1 => 43.4610373
]
+"Latitude": 43.4610373
+"Longitude": -80.6026665
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 722 Sundew Drive, Waterloo – an exquisite and meticulously maintained fully furnished home available for lease. Perfectly suited for families or working professionals, this expansive property offers a harmonious blend of comfort, convenience, and style. The carpet-free main level features distinct living and family rooms, providing ample space for relaxation and entertainment. The state-of-the-art kitchen is equipped with high-end stainless steel appliances, a walk-in pantry, and is complemented by a separate dining room and a cozy breakfast area, ideal for both casual and formal dining experiences. Ascend to the upper level where you'll discover four generously sized bedrooms, including two luxurious master suites each with their own private bathrooms, offering a serene retreat. The additional two bedrooms share a well-appointed Jack and Jill bathroom, ensuring privacy and convenience. 5th bedroom on this level provides a quiet area and offers flex space for home office, and the upper-level laundry room adds an extra layer of convenience to your daily routine. The basement, though unfinished, is included in the lease and provides additional space for storage or recreational use, with the landlords reserving half for their own storage needs. This home is ideally located near Costco Plaza and Boardwalk Plazas, providing easy access to shopping, dining, and entertainment options. Top-notch schools and scenic walking trails are within walking distance, making it a perfect, family-friendly neighborhood. Don't miss out on this fantastic leasing opportunity. Embrace the exceptional lifestyle that 722 Sundew Drive has to offer. Book your showing today and experience the perfect blend of luxury and convenience in this outstanding home. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-17T10:51:25.701280+00:00"
+"Directions": "Pasture Rose St To Sundew Drive"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"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": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Gazebo"
3 => "No Pet Home"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.114"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T17:38:53Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-20T17:38:53Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "722"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"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/29098594/722-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"TotalActualRent": 4200
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 3300
+"OriginalEntryTimestamp": "2025-11-13T15:09:26.38Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:28 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29098594')"
+"ID": "419557"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24971
+post_id: "419558"
+post_author: 1
+"ListingKey": "29099740"
+"ListingId": "X12541176"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-13T18:30:23Z"
+"RFModificationTimestamp": "2025-11-17T10:49:10Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C4"
+"UnparsedAddress": "722 SUNDEW DRIVE, Waterloo, Ontario N2V0C4"
+"Coordinates": array:2 [
0 => -80.6026239
1 => 43.4610132
]
+"Latitude": 43.4610132
+"Longitude": -80.6026239
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 722 Sundew Drive, Waterloo - an exquisite and meticulously maintained fully furnished home available for lease. Perfectly suited for families or working professionals, this expansive property offers a harmonious blend of comfort, convenience, and style. The carpet-free main level features distinct living and family rooms, providing ample space for relaxation and entertainment. The state-of-the-art kitchen is equipped with high-end stainless steel appliances, a walk-in pantry, and is complemented by a separate dining room and a cozy breakfast area, ideal for both casual and formal dining experiences. Ascend to the upper level where you'll discover four generously sized bedrooms, including two luxurious master suites each with their own private bathrooms, offering a serene retreat. The additional two bedrooms share a well-appointed Jack and Jill bathroom, ensuring privacy and convenience. 5th bedroom on this level provides a quiet area and offers flex space for home office, and the upper-level laundry room adds an extra layer of convenience to your daily routine. The basement, though unfinished, is included in the lease and provides additional space for storage or recreational use, with the landlords reserving half for their own storage needs. This home is ideally located near Costco Plaza and Boardwalk Plazas, providing easy access to shopping, dining, and entertainment options. Top-notch schools and scenic walking trails are within walking distance, making it a perfect, family-friendly neighborhood. Don't miss out on this fantastic leasing opportunity. Embrace the exceptional lifestyle that 722 Sundew Drive has to offer. Book your showing today and experience the perfect blend of luxury and convenience in this outstanding home. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Furniture"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-17T10:48:40.215103+00:00"
+"Directions": "Cross Streets: Columbia St To Sundew Dr. ** Directions: Pasture Rose St To Sundew Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-13T18:01:56Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-13T18:01:56Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "722"
+"StreetSuffix": "Drive"
+"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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29099740/722-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"TotalActualRent": 4200
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-13T18:01:56.8Z"
+"MapCoordinateVerifiedYN": false
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29099740')"
+"ID": "419558"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 99
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]
