array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29141044/Property?$select=ALL&$top=20&$filter=ListingKey eq 29141044&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29141044/Property?$select=ALL&$top=20&$filter=ListingKey eq 29141044&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23278
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23280
+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 [
"Order" => 26
"MediaKey" => "6341925048"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/ecea828026caf0b54de7453a1595b8f2.webp"
"MediaSize" => 46424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-ecea828026caf0b54de7453a1595b8f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6341925053"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/398a1dfcaf60fadc82e9206c20b2e9c8.webp"
"MediaSize" => 206565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-398a1dfcaf60fadc82e9206c20b2e9c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6341925055"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/ee8e51160f09eaae84c0d15307f32c74.webp"
"MediaSize" => 186212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-ee8e51160f09eaae84c0d15307f32c74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6341925057"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/66eb22b643d88592bc0784a3c8c3650a.webp"
"MediaSize" => 195903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-66eb22b643d88592bc0784a3c8c3650a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6341925060"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/1080ba1e03d973e4eb9846492f0e3fb9.webp"
"MediaSize" => 173827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-1080ba1e03d973e4eb9846492f0e3fb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6341925063"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/1614d25f7020e3169f1e7d4e00aad8e9.webp"
"MediaSize" => 152312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-1614d25f7020e3169f1e7d4e00aad8e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6341925066"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/245429fc43cf4dd7e3795eac4fe1d91f.webp"
"MediaSize" => 171320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-245429fc43cf4dd7e3795eac4fe1d91f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6341925070"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/bde3dc0b9417cf8007edc7c249ecbf2c.webp"
"MediaSize" => 149977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-bde3dc0b9417cf8007edc7c249ecbf2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6341925076"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/28a009fa0a10223530985276f8661760.webp"
"MediaSize" => 147636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-28a009fa0a10223530985276f8661760.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6341925079"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/674aa5925cc67b65e69a66725b475b81.webp"
"MediaSize" => 44393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-674aa5925cc67b65e69a66725b475b81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6341925082"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/4c48cef63f0f6a1029a818e357a716f8.webp"
"MediaSize" => 53298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-4c48cef63f0f6a1029a818e357a716f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6341925086"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29141044/865614c365dc8e4f386631d999539cc5.webp"
"MediaSize" => 40450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29141044/thumbnail-865614c365dc8e4f386631d999539cc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790651"
"ResourceRecordKey" => "29141044"
"ModificationTimestamp" => "2025-11-27T01:59:40.92Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141044')"
+"ID": "447626"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 292624/Office?$select=ALL&$top=10&$filter=OfficeKey eq 292624&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 292624/Office?$select=ALL&$top=10&$filter=OfficeKey eq 292624&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25128
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25130
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "EXP REALTY"
+"OfficeEmail": null
+"OfficePhone": "866-530-7737"
+"OfficeMlsId": "KW390"
+"ModificationTimestamp": "2025-08-19T15:49:32Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "292624"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "675 Riverbend Dr., Unit B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener,"
+"OfficePostalCode": "N2K3S"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1414872"
+"OriginalEntryTimestamp": "2022-04-26T18:17:00Z"
+"OfficeFax": "647-849-3180"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "231128"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "292624"
"SocialMediaUrlOrId" => "https://exprealty.ca/"
"ModificationTimestamp" => "2025-08-19T15:26:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1406847"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('292624')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2104716/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2104716&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2104716/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2104716&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25133
+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 29141044" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24724
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29141044/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29141044&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29141044/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29141044&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24704
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29141044 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5830379 43.472184)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29141044 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5830379 43.472184)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29141044 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5830379 43.472184)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29141044 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5830379 43.472184)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24978
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24971
+post_id: "446630"
+post_author: 1
+"ListingKey": "29140359"
+"ListingId": "X12580000"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T22:40:42Z"
+"RFModificationTimestamp": "2025-11-26T22:43:06Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "565 SUNDEW DRIVE, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.5978521
1 => 43.4581856
]
+"Latitude": 43.4581856
+"Longitude": -80.5978521
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 565 Sundew Drive, Waterloo - A Bright, Spacious & Modern Family Home in Sought-After Vista Hills Discover this large and impressive custom designed home, with 3.5-baths and over 4,200 sq. ft. of beautifully finished living space (2,937 sqft above grade), in the family-friendly new Vista Hills community. Designed with modern family living in mind, this home features a highly desirable open-concept layout, 9 ft ceilings, abundant oversized windows, and an incredible flow of natural light throughout. Entering the main floor, you are overwhelmed by the feeling of expansiveness with the huge living room, family room and kitchen. The renovated modern kitchen is a true centerpiece, featuring shaker cabinets, quartz countertops, stainless steel appliances and large pantry. Garden patio doors invite you to a backyard oasis with a private deck, pergola, louvered privacy screens, interlock patio, and mature landscaping - an ideal setting for outdoor dining, relaxation, and hosting guests. Upstairs, double doors open to a large master bedroom with ensuite bath and a private balcony. Two additional oversized bedrooms and a main bathroom with rough-in for a future sauna, 3rd upstairs bathroom or upper level laundry. The professionally finished basement provides two additional rooms ideal for bedrooms, office, or guest space, along with a lavish spa-like bathroom featuring a stylish soaker tub and heated towel rack. A perfect opportunity for professional families seeking a modern home in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:4 [
0 => "Water purifier"
1 => "Water softener"
2 => "Garage door opener remote(s)"
3 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T22:42:54.117075+00:00"
+"Directions": "Cross Streets: Columbia Street W. ** Directions: Columbia turns into Sundew. Stay on Sundew and unit is on the left."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2016676"
+"ListOfficeKey": "50449"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "38 x 98.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:00:22Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:28:56Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "565"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7537.69"
+"VirtualTourURLUnbranded": "https://mediatours.ca/property/565-sundew-drive-waterloo-s/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1540614903"
"RoomType" => "Living room"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 4.85
"ListingKey" => "29140359"
"RoomLength" => 5.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.35Z"
]
1 => array:11 [
"RoomKey" => "1540614904"
"RoomType" => "Utility room"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.06
"ListingKey" => "29140359"
"RoomLength" => 3.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.35Z"
]
2 => array:11 [
"RoomKey" => "1540614905"
"RoomType" => "Other"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 2.49
"ListingKey" => "29140359"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
3 => array:11 [
"RoomKey" => "1540614906"
"RoomType" => "Kitchen"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 4.19
"ListingKey" => "29140359"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
4 => array:11 [
"RoomKey" => "1540614907"
"RoomType" => "Dining room"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "29140359"
"RoomLength" => 4.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
5 => array:11 [
"RoomKey" => "1540614908"
"RoomType" => "Family room"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 4.65
"ListingKey" => "29140359"
"RoomLength" => 5.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
6 => array:11 [
"RoomKey" => "1540614909"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 5.94
"ListingKey" => "29140359"
"RoomLength" => 6.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
7 => array:11 [
"RoomKey" => "1540614910"
"RoomType" => "Bedroom 2"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 4.88
"ListingKey" => "29140359"
"RoomLength" => 5.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
8 => array:11 [
"RoomKey" => "1540614911"
"RoomType" => "Bedroom 3"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 3.81
"ListingKey" => "29140359"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
9 => array:11 [
"RoomKey" => "1540614912"
"RoomType" => "Bedroom 3"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.37
"ListingKey" => "29140359"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
10 => array:11 [
"RoomKey" => "1540614913"
"RoomType" => "Bedroom 4"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.94
"ListingKey" => "29140359"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
11 => array:11 [
"RoomKey" => "1540614914"
"RoomType" => "Laundry room"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.26
"ListingKey" => "29140359"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140359/565-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 38.0
+"OriginalEntryTimestamp": "2025-11-26T22:00:22.57Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:35 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341680706"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/a6958272eb5bfc3241075427bef8cbe1.webp"
"MediaSize" => 326682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-a6958272eb5bfc3241075427bef8cbe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341680714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/03446f598dd1616612df9127a7b92739.webp"
"MediaSize" => 311795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-03446f598dd1616612df9127a7b92739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341680740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/36ae64c62abea11b82440d2f7e07bfa2.webp"
"MediaSize" => 103164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-36ae64c62abea11b82440d2f7e07bfa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341680762"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/bc4258c5780aa67c9885ce6f75534732.webp"
"MediaSize" => 133125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-bc4258c5780aa67c9885ce6f75534732.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341680793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/729fb0ef6043b46b4d501aeb0172bb93.webp"
"MediaSize" => 162289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-729fb0ef6043b46b4d501aeb0172bb93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341680840"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/426614cb17bc45f88291e46c3bab48de.webp"
"MediaSize" => 158510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-426614cb17bc45f88291e46c3bab48de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341680849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/b48e3cbfa50a1b4a644417f55d0fe129.webp"
"MediaSize" => 158232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-b48e3cbfa50a1b4a644417f55d0fe129.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341680901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/ac3101458843806bb86eac364f94ae30.webp"
"MediaSize" => 148875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-ac3101458843806bb86eac364f94ae30.webp"
…7
]
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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24973
+post_id: "445151"
+post_author: 1
+"ListingKey": "29137601"
+"ListingId": "X12577186"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T02:35:52Z"
+"RFModificationTimestamp": "2025-11-26T03:29:47Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2W3"
+"UnparsedAddress": "528 VIRGINIA CREEPER STREET, Waterloo, Ontario N2V2W3"
+"Coordinates": array:2 [
0 => -80.6006499
1 => 43.4719752
]
+"Latitude": 43.4719752
+"Longitude": -80.6006499
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully maintained 3-bedroom townhome available for rent in the highly desirable Laurelwood community. Located on a quiet, family-friendly street, this home features a fully finished basement, updated modern light fixtures, a renovated kitchen, newly installed deck, refinished flooring, and a recently replaced roof .Just a short walk to Abraham P.S. and Laurel Heights Secondary School, and steps from the #13 bus route, this location is perfect for families and professionals. Don't miss the chance to rent this exceptional home in one of Waterloo's most sought-after neighborhoods! (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T03:29:33.406518+00:00"
+"Directions": "Erbsville Rd to Laurel Wood to Virginia Creeper"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2135624"
+"ListOfficeKey": "290489"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "22 x 98 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T02:23:00Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T02:23:00Z"
+"Stories": "2.0"
+"StreetName": "VIRGINIA CREEPER"
+"StreetNumber": "528"
+"StreetSuffix": "Street"
+"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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29137601/528-virginia-creeper-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1942496"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "290489"
+"TotalActualRent": 2900
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 22.0
+"OriginalEntryTimestamp": "2025-11-26T02:23:00.6Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:27 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29137601')"
+"ID": "445151"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24970
+post_id: "442635"
+post_author: 1
+"ListingKey": "29132628"
+"ListingId": "40790146"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:35:57Z"
+"RFModificationTimestamp": "2025-11-26T18:46:08Z"
+"ListPrice": 1349888.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.17
+"LivingArea": 3672.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X9"
+"UnparsedAddress": "531 WOOD NETTLE Way, Waterloo, Ontario N2V2X9"
+"Coordinates": array:2 [
0 => -80.6049935
1 => 43.4732895
]
+"Latitude": 43.4732895
+"Longitude": -80.6049935
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Your dream home awaits! Welcome to 531 WOOD NETTLE WAY, a spectacular CUSTOM-BUILT HOME on a premium PIE-SHAPED LOT (0.17 ACRES) in the highly sought-after neighbourhood of LAURELWOOD. From the moment you arrive, the grand DOUBLE-WIDE PAVER DRIVEWAY and wrap-around walkway create an unforgettable first impression, leading you to the elegant front entrance. Step inside this PROFESSIONALLY DESIGNED, OPEN-CONCEPT MASTERPIECE, where soaring 18-FOOT CEILINGS in the foyer welcome you home. Host unforgettable gatherings in the FORMAL DINING ROOM complete with a BUILT-IN WINE RACK, before moving into the stunning EAT-IN KITCHEN featuring GRANITE COUNTERTOPS and a SPACIOUS ISLAND & STAINLESS APPLIANCES. The OPEN-CONCEPT LIVING ROOM, featuring a cozy GAS FIREPLACE and elegant FRENCH DOORS, flows seamlessly out to the COVERED PRIVATE DECK—a serene retreat crafted with CUSTOM COMPOSITE DECKING and a GLASS RAILING SYSTEM. Need a workspace? Discover the luxurious MAIN-FLOOR OFFICE, filled with natural sunlight and its own private entrance. This level also boasts 9-FOOT CEILINGS, POT LIGHTING, and a convenient TWO-PIECE POWDER ROOM. The grandeur continues upstairs, where the PRIMARY BEDROOM offers a HUGE WALK-IN CLOSET and a luxurious 5PC ENSUITE with JACUZZI TUB and TILED SHOWER. Two additional bedrooms both feature WALK-IN CLOSETS, one with a CHEATER ENSUITE, plus a LAUNDRY ROOM with sink, shelving, and cabinetry. The LOWER LEVEL reveals incredible potential with a LARGE REC & GAMES ROOM with walkout to a STONE PATIO, plus a 3PC BATH WITH HEATED FLOORING. The massive 30X20 BONUS ROOM is an untouched canvas for your dream theatre, hobby space, or rink. The DOUBLE GARAGE includes two inside entries and a FULLY EQUIPPED WORKSHOP—a handyman or handywoman’s dream. Surrounded by PARKS, TRAILS, AND TOP-RATED SCHOOLS, this one-of-a-kind home is minutes from COSTCO, THE BOARDWALK, YMCA PROGRAMS, and LAUREL CREEK CONSERVATION AREA. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
]
+"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-25T00:30:56.565943+00:00"
+"Directions": "Erbsville RD. Turn left onto WIDEMAN RD. turn left onto Woolgrass, first right onto Wood Nettle Way"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563948"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Visual exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
5 => "Private Yard"
]
+"LotSizeDimensions": "0.17"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:11:26Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:11:26Z"
+"Stories": "2.0"
+"StreetName": "WOOD NETTLE"
+"StreetNumber": "531"
+"StreetSuffix": "Way"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7715.22"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/531-Wood-Nettle-Way"
+"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/29132628/531-wood-nettle-way-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "50-R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 2512
+"BelowGradeFinishedArea": 1160
+"OriginalEntryTimestamp": "2025-11-24T20:19:07.3Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"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('29132628')"
+"ID": "442635"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24974
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24972
+post_id: "443152"
+post_author: 1
+"ListingKey": "29131516"
+"ListingId": "40789849"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T17:15:53Z"
+"RFModificationTimestamp": "2025-11-24T19:47:07Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2891.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y7"
+"UnparsedAddress": "548 WASAGA Crescent, Waterloo, Ontario N2V2Y7"
+"Coordinates": array:2 [
0 => -80.589464
1 => 43.4895367
]
+"Latitude": 43.4895367
+"Longitude": -80.589464
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Situated in the desirable Conservation Meadows community, this well-appointed home features an elegant and functional floor plan. Enjoy proximity to parks, shopping, scenic trails, highway access, and all major amenities. With a touch of imagination, this property presents an exceptional opportunity to transform it into a stunning showcase residence. Property sold as is, where is basis. Seller makes no representation and/ or warranties. RSA (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-11-24T19:47:02.482705+00:00"
+"Directions": "Rideau River St & Wasaga Cres"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523944"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T17:09:13Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T17:09:13Z"
+"Stories": "2.0"
+"StreetName": "WASAGA"
+"StreetNumber": "548"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7101"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29131516/548-wasaga-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2034860"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55026"
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2891
+"OriginalEntryTimestamp": "2025-11-24T17:09:13.1Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29131516')"
+"ID": "443152"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24985
+post_id: "435906"
+post_author: 1
+"ListingKey": "29125272"
+"ListingId": "X12565380"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-21T14:25:33Z"
+"RFModificationTimestamp": "2025-11-21T17:59:53Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2X5"
+"UnparsedAddress": "571 WILD IRIS AVENUE, Waterloo, Ontario N2V2X5"
+"Coordinates": array:2 [
0 => -80.6009433
1 => 43.4725154
]
+"Latitude": 43.4725154
+"Longitude": -80.6009433
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright and spacious townhome in the sought-after, family-friendly community of Laurelwood. Offering 3 bedrooms, 3 bathrooms, and an impressive 16-foot cathedral ceiling in the grand foyer, this home is move-in ready and available immediately. The open-concept main floor features a large eat-in kitchen, spacious living room, brand new counters throughout, newer flooring and paint, and a walkout to a fully fenced back yard, ideal for entertaining or relaxing outdoors. Upstairs, the primary suite offers a generous walk-in closet and a 4-piece ensuite. Two additional well-sized bedrooms and another full bathroom provide plenty of space for family or guests. Set in a prime location, you'll enjoy top-rated schools, shopping, universities, public transit, and nearby conservation lands with endless walking and biking trails. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T17:59:33.944008+00:00"
+"Directions": "Cross Streets: Erbsville / Laurelwood. ** Directions: Erbsville / Laurelwood / Wild Iris."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067694"
+"ListOfficeKey": "159857"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "21.7 x 98.4 FT"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2025-11-21T14:19:37Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-21T14:19:37Z"
+"Stories": "2.0"
+"StreetName": "Wild Iris"
+"StreetNumber": "571"
+"StreetSuffix": "Avenue"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29125272/571-wild-iris-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1958530"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "159857"
+"TotalActualRent": 2800
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 21.8
+"OriginalEntryTimestamp": "2025-11-21T14:19:37.66Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:30 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29125272')"
+"ID": "435906"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23292
+post_id: "435046"
+post_author: 1
+"ListingKey": "29124115"
+"ListingId": "40788966"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T21:40:11Z"
+"RFModificationTimestamp": "2025-11-22T21:40:41Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.075
+"LivingArea": 2335.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "664 BRANDENBURG Boulevard, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.5800713
1 => 43.4582785
]
+"Latitude": 43.4582785
+"Longitude": -80.5800713
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A home your family has been waiting for in highly sought-after Clair Hills! Pride of ownership shines throughout this beautifully maintained, fully finished home. Step through the attractive double French doors into a spacious foyer with an oversized closet, leading to the carpet-free main floor enhanced with crown moulding. The chef-inspired kitchen features granite countertops, under-cabinet lighting, a built-in pantry, a stunning stone backsplash, and an over-the-range hood microwave. The bright dining area offers walkout sliders to a 12’ x 12’ deck overlooking a fantastic backyard with a serene pond feature. A welcoming living room with bamboo flooring and a convenient 3-piece bathroom complete the main level. Upstairs, the primary bedroom retreat includes a walk-in closet with excellent storage. Two additional generously sized bedrooms and a spacious 4-piece bathroom complete the second floor. The finished basement provides extra living and entertaining space, featuring a cozy rec room with a gas fireplace. Enjoy the tranquil backyard setting with no rear neighbours—a rare find. Close to great schools, parks, and all amenities. Updates include: Furnace (2023), Air Conditioner (2023), Hot Water Tank (2025), Freshly Painted Throughout (2025), New Carpet (2025). (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Hood Fan"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T01:22:14.513331+00:00"
+"Directions": "Erbsville Road to Brandenburg Boulevard"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Gazebo"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.075"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-21T16:21:56Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T21:29:51Z"
+"Stories": "2.0"
+"StreetName": "BRANDENBURG"
+"StreetNumber": "664"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4535"
+"View": "View of water"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/bc3mv_664_brandenburg_blvd_waterloo_on/"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Sand point"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29124115/664-brandenburg-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1637
+"BelowGradeFinishedArea": 698
+"OriginalEntryTimestamp": "2025-11-20T22:38:37.33Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29124115')"
+"ID": "435046"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24975
+post_id: "434029"
+post_author: 1
+"ListingKey": "29122954"
+"ListingId": "40789610"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-21T14:20:43Z"
+"RFModificationTimestamp": "2025-11-21T18:01:54Z"
+"ListPrice": 2200000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 4332.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2G3"
+"UnparsedAddress": "585 REGAL Place, Waterloo, Ontario N2V2G3"
+"Coordinates": array:2 [
0 => -80.6018121
1 => 43.4784334
]
+"Latitude": 43.4784334
+"Longitude": -80.6018121
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 585 Regal Place, a vibrant and distinguished former model home set on a beautifully landscaped corner lot in one of Waterloo’s most desirable and well-maintained enclaves. Nestled on a quiet cul-de-sac, this custom-built bungalow offers over 4,300 sq. ft. of finely curated living space, including more than 3,500 sq. ft. on the main floor, plus an oversized triple-car garage with high ceilings and a workshop area. The cobblestone driveway and covered entry make a striking first impression, leading into an expansive foyer where soaring 10-foot ceilings and an open, flowing layout instantly convey energy and light. Expansive rear windows draw the eye to views of the private gardens and backyard, enhancing the uplifting feel of the home. The executive kitchen is a central hub, featuring custom cabinetry, granite counters, a generous island, and professional-grade appliances. It flows seamlessly to the breakfast area and covered porch, creating an effortless connection between indoor and outdoor living. Formal dining and living spaces are enriched with statement lighting, rich wood flooring, and gallery-like wall space perfect for showcasing art. The primary suite offers a calm retreat, highlighted by a spa-inspired ensuite with a double-sided fireplace, soaker tub, and custom dressing room. Two additional bedrooms, including one with an ensuite, a dedicated office, and main-floor laundry add comfort and flexibility, while the finished lower level provides guest space and areas for recreation or fitness. Outside, extensive landscaping, mature gardens, and multiple sitting areas create an inviting backdrop for gatherings or quiet moments. Nearby trails, golf courses, the St. Jacobs Farmers’ Market, and top-rated schools add to the lifestyle appeal. This home combines elegant design and vibrant energy with practical function, offering an exceptional place to live and thrive. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-20T21:42:54.748193+00:00"
+"Directions": "Erbsville Rd to Regal Place"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564461"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T19:00:03Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-21T14:08:53Z"
+"Stories": "1.0"
+"StreetName": "REGAL"
+"StreetNumber": "585"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "17669"
+"VirtualTourURLUnbranded": "https://youriguide.com/585_regal_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29122954/585-regal-place-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Monitored Alarm"
]
+"ZoningDescription": "SR4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 87.0
+"AboveGradeFinishedArea": 3562
+"BelowGradeFinishedArea": 770
+"OriginalEntryTimestamp": "2025-11-20T19:00:03.65Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29122954')"
+"ID": "434029"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24976
+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"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 93
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]