array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29124115/Property?$select=ALL&$top=20&$filter=ListingKey eq 29124115&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29124115/Property?$select=ALL&$top=20&$filter=ListingKey eq 29124115&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23274
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23276
+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 [
"RoomKey" => "1538274677"
"RoomType" => "Recreation room"
"ListingId" => "40788966"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 22'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:51.99Z"
]
1 => array:11 [
"RoomKey" => "1538274678"
"RoomType" => "Laundry room"
"ListingId" => "40788966"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:51.99Z"
]
2 => array:11 [
"RoomKey" => "1538274679"
"RoomType" => "Primary Bedroom"
"ListingId" => "40788966"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 17'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:51.99Z"
]
3 => array:11 [
"RoomKey" => "1538274680"
"RoomType" => "Bedroom"
"ListingId" => "40788966"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:51.99Z"
]
4 => array:11 [
"RoomKey" => "1538274681"
"RoomType" => "Bedroom"
"ListingId" => "40788966"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:52Z"
]
5 => array:11 [
"RoomKey" => "1538274682"
"RoomType" => "5pc Bathroom"
"ListingId" => "40788966"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:52Z"
]
6 => array:11 [
"RoomKey" => "1538274683"
"RoomType" => "Dining room"
"ListingId" => "40788966"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:52Z"
]
7 => array:11 [
"RoomKey" => "1538274684"
"RoomType" => "Living room"
"ListingId" => "40788966"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 16'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:52Z"
]
8 => array:11 [
"RoomKey" => "1538274685"
"RoomType" => "Kitchen"
"ListingId" => "40788966"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:52Z"
]
9 => array:11 [
"RoomKey" => "1538274686"
"RoomType" => "3pc Bathroom"
"ListingId" => "40788966"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29124115"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T21:29:52Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6330570866"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/9189956d6905eb2361056041ea6e7509.webp"
"MediaSize" => 199327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-9189956d6905eb2361056041ea6e7509.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-20T22:40:55.56Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6330570976"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/41fb43db345dbd2291e26ee339205ab6.webp"
"MediaSize" => 145440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-41fb43db345dbd2291e26ee339205ab6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-20T22:40:55.55Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6331725931"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/68b2928fcd1042823a074eb452e0b6cb.webp"
"MediaSize" => 73661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-68b2928fcd1042823a074eb452e0b6cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:46.26Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6331725986"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/01c3fba20a4ef23b03bbf6008e6081a1.webp"
"MediaSize" => 90844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-01c3fba20a4ef23b03bbf6008e6081a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.28Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6331726047"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/f374b878b13a566576b8f7d64751c741.webp"
"MediaSize" => 48318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-f374b878b13a566576b8f7d64751c741.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.29Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6331726109"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/87fc4e9b24c14012eb0dc1d26f271dee.webp"
"MediaSize" => 73399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-87fc4e9b24c14012eb0dc1d26f271dee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:46.28Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6331726137"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/4bc538de31bf020398736224648aa1eb.webp"
"MediaSize" => 79195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-4bc538de31bf020398736224648aa1eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:56.19Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6331726168"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/6285b38e891f4e01ebf789564205c361.webp"
"MediaSize" => 83066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-6285b38e891f4e01ebf789564205c361.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.29Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6331726240"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/3cc13cb8455db7725a51d1804f4e886b.webp"
"MediaSize" => 73543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-3cc13cb8455db7725a51d1804f4e886b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.28Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6331726266"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/da3a1848c16ea054b2ebdcb7c111c246.webp"
"MediaSize" => 77908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-da3a1848c16ea054b2ebdcb7c111c246.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.3Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6331726328"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/2d9f67aa7bd438e164f0444f7314a9f6.webp"
"MediaSize" => 62176
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-2d9f67aa7bd438e164f0444f7314a9f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.28Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6331726384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/cbd07debc33ba8ba73c72f84c5b7e1e8.webp"
"MediaSize" => 67439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-cbd07debc33ba8ba73c72f84c5b7e1e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:46.58Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6331726405"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/6a9c3e02d38550c031204008ef3e6a49.webp"
"MediaSize" => 69088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-6a9c3e02d38550c031204008ef3e6a49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.28Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6331726482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/32d201fc51dee8a6e31860a6ff6b7e60.webp"
"MediaSize" => 72048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-32d201fc51dee8a6e31860a6ff6b7e60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:46.58Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6331726510"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/d66c0aa5dda3dc27525b505f9aa59abc.webp"
"MediaSize" => 58283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-d66c0aa5dda3dc27525b505f9aa59abc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.29Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6331726531"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/10e2fe40c6e486907db4f8fdcf5eb709.webp"
"MediaSize" => 64479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-10e2fe40c6e486907db4f8fdcf5eb709.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.28Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6331726545"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/8e7b03237b4ac5e40d2a68b6a06dfaa4.webp"
"MediaSize" => 58044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-8e7b03237b4ac5e40d2a68b6a06dfaa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.28Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6331726581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/2ce9dd1f74b3856d0b28d1072767f65a.webp"
"MediaSize" => 64392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-2ce9dd1f74b3856d0b28d1072767f65a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.3Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6331726628"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/7a674327b479f0f6a4cf22b0fdef8f90.webp"
"MediaSize" => 65013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-7a674327b479f0f6a4cf22b0fdef8f90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.3Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6331726657"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/a24e7c9f8d32b4be4a83e6e31966f49a.webp"
"MediaSize" => 60617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-a24e7c9f8d32b4be4a83e6e31966f49a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.28Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6331726678"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/3a5a4ad8fe665c30a9fa0131f86bd59a.webp"
"MediaSize" => 120371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-3a5a4ad8fe665c30a9fa0131f86bd59a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:46.27Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6331726705"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/84f3bca25edee8d996be1ceee0752bae.webp"
"MediaSize" => 177996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-84f3bca25edee8d996be1ceee0752bae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:46.28Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6331726733"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/4838ce51eef8aff5d8404b7f5641490e.webp"
"MediaSize" => 201856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-4838ce51eef8aff5d8404b7f5641490e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.33Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6331726753"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29124115/cde5ce486fee83e155cb8f78d98d053c.webp"
"MediaSize" => 190359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29124115/thumbnail-cde5ce486fee83e155cb8f78d98d053c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40788966"
"ResourceRecordKey" => "29124115"
"ModificationTimestamp" => "2025-11-21T16:21:45.28Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29124115')"
+"ID": "435046"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 290620/Office?$select=ALL&$top=10&$filter=OfficeKey eq 290620&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 290620/Office?$select=ALL&$top=10&$filter=OfficeKey eq 290620&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25098
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25100
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Peak Realty Ltd."
+"OfficeEmail": null
+"OfficePhone": "519-747-0231"
+"OfficeMlsId": "KW368"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "290620"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "25 Bruce St., Unit 5B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2B1Y"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1389824"
+"OriginalEntryTimestamp": "2021-06-21T16:36:00Z"
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "6130797835"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/office-290620/3e0374aa449844d055d4e82c55d36707.webp"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "KW368"
"ResourceRecordKey" => "290620"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "266649"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "290620"
"SocialMediaUrlOrId" => "http://www.peakrealtyltd.com/"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"FranchiseNationalAssociationId": "1230701"
+"OfficeBrokerNationalAssociationId": "1171153"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('290620')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.27 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1879079/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1879079&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1879079/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1879079&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25103
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29124115" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24708
+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 29124115/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29124115&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29124115/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29124115&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24689
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24688
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29151231"
+"ListingKey": "29124115"
+"ListingId": "40788966"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-11-22"
+"OpenHouseStartTime": "2025-11-22T14:00:00Z"
+"OpenHouseEndTime": "2025-11-22T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-11-21T15:52:56Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29151231')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24686
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29158876"
+"ListingKey": "29124115"
+"ListingId": "40788966"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-11-22"
+"OpenHouseStartTime": "2025-11-22T14:00:00Z"
+"OpenHouseEndTime": "2025-11-22T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-11-22T17:37:51Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29158876')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29124115 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5800713 43.4582785)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29124115 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5800713 43.4582785)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29124115 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5800713 43.4582785)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29124115 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5800713 43.4582785)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24955
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24567
+post_id: "447626"
+post_author: 1
+"ListingKey": "29141044"
+"ListingId": "40790651"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T02:05:04Z"
+"RFModificationTimestamp": "2025-11-27T03:33:23Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2000.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M1"
+"UnparsedAddress": "508 BROOKMILL Crescent, Waterloo, Ontario N2V2M1"
+"Coordinates": array:2 [
0 => -80.5830379
1 => 43.472184
]
+"Latitude": 43.472184
+"Longitude": -80.5830379
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Rare Find in Laurelwood, Waterloo Nestled on a quiet crescent in one of Waterloos most sought-after family neighbourhoods, this beautifully maintained detached home in Laurelwood is a must-see. Located just steps from top-rated schools Laurel Heights Secondary, Laurelwood P.S., and St. Nicholas and minutes to both Wilfrid Laurier and the University of Waterloo, its ideal for families and professionals alike. Step inside to a warm, functional layout featuring custom built-in storage in the entry, a refreshed 2-piece bath, and garage access. The open-concept main floor impresses with brand-new stainless steel appliances (2022), new countertops, and a central island that flows into a sunlit dining area. The cozy living room boasts custom wall-to-wall bookcases, a fireplace, and large windows leading to a private backyard oasis. The outdoor space is truly special a deep, landscaped lot with mature trees and shrubs offers a peaceful retreat. Enjoy summer evenings on the spacious 20x16 wood deck, perfect for entertaining or unwinding. An 8x12 pine shed provides extra storage or workshop potential. Nature enthusiasts will love being close to Laurel Creek Conservation Area offering trails, swimming, campsites, and picnic spots year-round. Upstairs, the vaulted-ceiling primary bedroom features double closets, while second-floor laundry adds everyday convenience. The finished basement extends the living space with a generous family room and an updated 2-piece bath. With nearly 2,000 sq. ft. of finished living space, 2017 roof, insulated garage, and thoughtful updates throughout, this lovingly cared-for home checks every box. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Central Vacuum - Roughed In"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T03:33:06.839652+00:00"
+"Directions": "Erbsville Rd >Right on Laurelwood Dr > Left on Brookmill Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104716"
+"ListOfficeKey": "292624"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T01:59:41Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T01:59:40Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "508"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"VirtualTourURLUnbranded": "https://youriguide.com/508_brookmil_cr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1540689108"
"RoomType" => "Utility room"
"ListingId" => "40790651"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.95Z"
]
1 => array:11 [
"RoomKey" => "1540689109"
"RoomType" => "Recreation room"
"ListingId" => "40790651"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "22'8'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
2 => array:11 [
"RoomKey" => "1540689110"
"RoomType" => "2pc Bathroom"
"ListingId" => "40790651"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "6'8'' x 2'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
3 => array:11 [
"RoomKey" => "1540689111"
"RoomType" => "Laundry room"
"ListingId" => "40790651"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 7'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
4 => array:11 [
"RoomKey" => "1540689112"
"RoomType" => "Bedroom"
"ListingId" => "40790651"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
5 => array:11 [
"RoomKey" => "1540689113"
"RoomType" => "Bedroom"
"ListingId" => "40790651"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
6 => array:11 [
"RoomKey" => "1540689114"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790651"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
7 => array:11 [
"RoomKey" => "1540689115"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790651"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
8 => array:11 [
"RoomKey" => "1540689116"
"RoomType" => "2pc Bathroom"
"ListingId" => "40790651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
9 => array:11 [
"RoomKey" => "1540689117"
"RoomType" => "Dining room"
"ListingId" => "40790651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
10 => array:11 [
"RoomKey" => "1540689118"
"RoomType" => "Living room"
"ListingId" => "40790651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
11 => array:11 [
"RoomKey" => "1540689119"
"RoomType" => "Kitchen"
"ListingId" => "40790651"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29141044"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-27T01:59:40.96Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29141044/508-brookmill-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2048148"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299917"
+"GeocodeManualYN": true
+"TotalActualRent": 3500
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1560
+"BelowGradeFinishedArea": 440
+"OriginalEntryTimestamp": "2025-11-27T01:59:40.91Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:38 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341925008"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/362e47681bc344f11d1911154fd0e165.webp"
"MediaSize" => 193864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-362e47681bc344f11d1911154fd0e165.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341925009"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/f49e96eb72e7fe2fd54a79400827166a.webp"
"MediaSize" => 60028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-f49e96eb72e7fe2fd54a79400827166a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341925010"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/2d0cb462826804895e98fab773af2c5e.webp"
"MediaSize" => 88651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-2d0cb462826804895e98fab773af2c5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341925011"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/ca069e0afc1dbad8cc29e6d4db67ba11.webp"
"MediaSize" => 81213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-ca069e0afc1dbad8cc29e6d4db67ba11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341925012"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/c3a9dd409d92dc36a5a74480549dff83.webp"
"MediaSize" => 83309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-c3a9dd409d92dc36a5a74480549dff83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341925013"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/6857592481a213d278e29c836ea94151.webp"
"MediaSize" => 85871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-6857592481a213d278e29c836ea94151.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341925014"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/d744623427ae27d4d4f091aca4999f67.webp"
"MediaSize" => 72500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-d744623427ae27d4d4f091aca4999f67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341925015"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/ff51f18065f01f0bc19be671c5392f21.webp"
"MediaSize" => 82880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-ff51f18065f01f0bc19be671c5392f21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6341925016"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/d68b7bebe5fa1eab264f8d3fc32233d0.webp"
"MediaSize" => 94871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-d68b7bebe5fa1eab264f8d3fc32233d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6341925017"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/7ea8762484e1ab6dcabc7c052f5c7b40.webp"
"MediaSize" => 91865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-7ea8762484e1ab6dcabc7c052f5c7b40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6341925018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/52f29c676d257846a743c51d12bff4ad.webp"
"MediaSize" => 81734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-52f29c676d257846a743c51d12bff4ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6341925019"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/338a6af6a5d0d29d4cd44951e307d3bf.webp"
"MediaSize" => 69714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-338a6af6a5d0d29d4cd44951e307d3bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6341925021"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/b100f458a5e24fb9d345d69d9b1b922d.webp"
"MediaSize" => 62543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-b100f458a5e24fb9d345d69d9b1b922d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6341925023"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/04011364d9772dc5472617bd297786cb.webp"
"MediaSize" => 53612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-04011364d9772dc5472617bd297786cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6341925025"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/d1beae641078fdf994f1038cc65b900b.webp"
"MediaSize" => 58545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-d1beae641078fdf994f1038cc65b900b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6341925027"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/ecdc5fe49724eef11f46ca7d9ea2ce89.webp"
"MediaSize" => 49665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-ecdc5fe49724eef11f46ca7d9ea2ce89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6341925029"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/2da547277b43472f6e37935be9c98ad6.webp"
"MediaSize" => 55054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-2da547277b43472f6e37935be9c98ad6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6341925031"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/2e81ac8344572448a0ef5a059ef89e27.webp"
"MediaSize" => 32204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-2e81ac8344572448a0ef5a059ef89e27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6341925033"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/066dc0488c8c735b0a1b2e4db3e9c642.webp"
"MediaSize" => 57166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-066dc0488c8c735b0a1b2e4db3e9c642.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6341925035"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/b5717169699b2c984d3dedfb5f032ce6.webp"
"MediaSize" => 49966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-b5717169699b2c984d3dedfb5f032ce6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6341925037"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/b76009523d0af6602fa7abee55db7d30.webp"
"MediaSize" => 53147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-b76009523d0af6602fa7abee55db7d30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6341925039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/ddd2cfe661bea1c83a5f1d3b602354ee.webp"
"MediaSize" => 62496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-ddd2cfe661bea1c83a5f1d3b602354ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6341925041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/e17addf1ffbde88776e9e10a145a8fc1.webp"
"MediaSize" => 48775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-e17addf1ffbde88776e9e10a145a8fc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6341925043"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/a7e80a1f2d8818fc2d1cf462e2b4b32a.webp"
"MediaSize" => 81564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-a7e80a1f2d8818fc2d1cf462e2b4b32a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6341925044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/33eb296e81db17d6c07974a94e0a9943.webp"
"MediaSize" => 86889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-33eb296e81db17d6c07974a94e0a9943.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6341925046"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/0cb5d9de8d53004ff7f1a062a45f86e6.webp"
"MediaSize" => 75892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-0cb5d9de8d53004ff7f1a062a45f86e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141044')"
+"ID": "447626"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24541
+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 [ …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/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 [ …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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140359')"
+"ID": "446630"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24959
+post_id: "441138"
+post_author: 1
+"ListingKey": "29132632"
+"ListingId": "40789696"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T20:15:46Z"
+"RFModificationTimestamp": "2025-11-26T20:16:37Z"
+"ListPrice": 1100000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2301.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5V7"
+"UnparsedAddress": "424 CLAIRBROOK Crescent, Waterloo, Ontario N2L5V7"
+"Coordinates": array:2 [
0 => -80.5637594
1 => 43.465947
]
+"Latitude": 43.465947
+"Longitude": -80.5637594
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 424 Clairbrook, nestled in the highly sought-after, family-friendly Beechwood neighbourhood. This spacious home features four generous bedrooms on the upper level, plus an additional bedroom in the fully finished basement—perfect for growing families, hosting guests, or creating a dedicated home office. Inside, you'll find a warm and inviting layout with large principal rooms and an open-concept kitchen and dining area designed for everyday living and easy entertaining. Step outside to a large, private, fully fenced backyard, ideal for gatherings, gardening, or simply unwinding in your own outdoor retreat. This is a rare opportunity to own a home in one of Waterloo’s most desirable communities. Don’t miss your chance to make 424 Clairbrook yours. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T21:21:29.987509+00:00"
+"Directions": "Fischer- Hallman - Beechlawn"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2193974"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T20:19:13Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T20:00:34Z"
+"Stories": "2.0"
+"StreetName": "CLAIRBROOK"
+"StreetNumber": "424"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "6384"
+"VirtualTourURLUnbranded": "https://youriguide.com/424_clairbrook_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29132632/424-clairbrook-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2301
+"OriginalEntryTimestamp": "2025-11-24T20:19:13.13Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:37 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29132632')"
+"ID": "441138"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24957
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24554
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24960
+post_id: "431510"
+post_author: 1
+"ListingKey": "29119504"
+"ListingId": "40789360"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T21:40:10Z"
+"RFModificationTimestamp": "2025-11-22T21:40:42Z"
+"ListPrice": 1629000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 4609.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R2"
+"UnparsedAddress": "711 CEDAR BEND Drive, Waterloo, Ontario N2V2R2"
+"Coordinates": array:2 [
0 => -80.5888777
1 => 43.4737867
]
+"Latitude": 43.4737867
+"Longitude": -80.5888777
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 4-Bedroom Executive Home | Over 4,600 sq. ft. of Luxury Living ?Finished Top to Bottom with exceptional attention to detail, this 4-bedroom, 4-bathroom home offers over 4,600 sq. ft.of elegant living space designed for comfort and style. Step inside to a bright, open-concept main floor featuring 9’ ceilings, oversized windows, and abundant natural light. Enjoy a formal living room and dining room, perfect for entertaining. The gourmet kitchen boasts a large breakfast island, solid surface counters, walk-in pantry, and stainless steel appliances, overlooking a spacious family roomwith a stone fireplace framed by custom maple built-ins. An amazing mudroom with extensive cabinetry adds practicality to luxury. Upstairs, discover a spectacular primary retreat ?complete with a cozy sitting area, walk-in closets, and a spa-inspired 5-piece ensuite with his & her sinks, glass shower, and soaker tub. Three additional bedrooms are generously sized, complemented by a vaulted-ceiling office. The professionally finished lower level offers a spacious recreation room with a fireplace feature wall, wet bar with quartz counters, exercise room, bathroom, and ample storage space. Locatedin a vibrant community close to excellent schools, shopping, public transit, universities, library, YMCA, and beautiful conservation areas, this home is perfect for families seeking both comfort and convenience. Don’t miss your chance to live in this stunning home and exceptional neighbourhood! (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T23:09:00.182057+00:00"
+"Directions": "Laurelwood Dirve"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T21:19:12Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T21:29:44Z"
+"Stories": "2.0"
+"StreetName": "CEDAR BEND"
+"StreetNumber": "711"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "9326.54"
+"VirtualTourURLUnbranded": "https://youtu.be/G9mlEX2eKxw?feature=shared"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29119504/711-cedar-bend-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 74.0
+"AboveGradeFinishedArea": 3409
+"BelowGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2025-11-19T21:19:12.29Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29119504')"
+"ID": "431510"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23288
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24555
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24956
+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"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 130
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]