array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29140359/Property?$select=ALL&$top=20&$filter=ListingKey eq 29140359&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29140359/Property?$select=ALL&$top=20&$filter=ListingKey eq 29140359&$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: "446630"
+post_author: 1
+"ListingKey": "29140359"
+"ListingId": "X12580000"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T22:40:42Z"
+"RFModificationTimestamp": "2025-11-26T22:43:06Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "565 SUNDEW DRIVE, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.5978521
1 => 43.4581856
]
+"Latitude": 43.4581856
+"Longitude": -80.5978521
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 565 Sundew Drive, Waterloo - A Bright, Spacious & Modern Family Home in Sought-After Vista Hills Discover this large and impressive custom designed home, with 3.5-baths and over 4,200 sq. ft. of beautifully finished living space (2,937 sqft above grade), in the family-friendly new Vista Hills community. Designed with modern family living in mind, this home features a highly desirable open-concept layout, 9 ft ceilings, abundant oversized windows, and an incredible flow of natural light throughout. Entering the main floor, you are overwhelmed by the feeling of expansiveness with the huge living room, family room and kitchen. The renovated modern kitchen is a true centerpiece, featuring shaker cabinets, quartz countertops, stainless steel appliances and large pantry. Garden patio doors invite you to a backyard oasis with a private deck, pergola, louvered privacy screens, interlock patio, and mature landscaping - an ideal setting for outdoor dining, relaxation, and hosting guests. Upstairs, double doors open to a large master bedroom with ensuite bath and a private balcony. Two additional oversized bedrooms and a main bathroom with rough-in for a future sauna, 3rd upstairs bathroom or upper level laundry. The professionally finished basement provides two additional rooms ideal for bedrooms, office, or guest space, along with a lavish spa-like bathroom featuring a stylish soaker tub and heated towel rack. A perfect opportunity for professional families seeking a modern home in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:4 [
0 => "Water purifier"
1 => "Water softener"
2 => "Garage door opener remote(s)"
3 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T22:42:54.117075+00:00"
+"Directions": "Cross Streets: Columbia Street W. ** Directions: Columbia turns into Sundew. Stay on Sundew and unit is on the left."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2016676"
+"ListOfficeKey": "50449"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "38 x 98.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T22:00:22Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T22:28:56Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "565"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7537.69"
+"VirtualTourURLUnbranded": "https://mediatours.ca/property/565-sundew-drive-waterloo-s/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1540614903"
"RoomType" => "Living room"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 4.85
"ListingKey" => "29140359"
"RoomLength" => 5.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.35Z"
]
1 => array:11 [
"RoomKey" => "1540614904"
"RoomType" => "Utility room"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.06
"ListingKey" => "29140359"
"RoomLength" => 3.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.35Z"
]
2 => array:11 [
"RoomKey" => "1540614905"
"RoomType" => "Other"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 2.49
"ListingKey" => "29140359"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
3 => array:11 [
"RoomKey" => "1540614906"
"RoomType" => "Kitchen"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 4.19
"ListingKey" => "29140359"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
4 => array:11 [
"RoomKey" => "1540614907"
"RoomType" => "Dining room"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "29140359"
"RoomLength" => 4.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
5 => array:11 [
"RoomKey" => "1540614908"
"RoomType" => "Family room"
"ListingId" => "X12580000"
"RoomLevel" => "Main level"
"RoomWidth" => 4.65
"ListingKey" => "29140359"
"RoomLength" => 5.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
6 => array:11 [
"RoomKey" => "1540614909"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 5.94
"ListingKey" => "29140359"
"RoomLength" => 6.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
7 => array:11 [
"RoomKey" => "1540614910"
"RoomType" => "Bedroom 2"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 4.88
"ListingKey" => "29140359"
"RoomLength" => 5.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
8 => array:11 [
"RoomKey" => "1540614911"
"RoomType" => "Bedroom 3"
"ListingId" => "X12580000"
"RoomLevel" => "Second level"
"RoomWidth" => 3.81
"ListingKey" => "29140359"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
9 => array:11 [
"RoomKey" => "1540614912"
"RoomType" => "Bedroom 3"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.37
"ListingKey" => "29140359"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
10 => array:11 [
"RoomKey" => "1540614913"
"RoomType" => "Bedroom 4"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.94
"ListingKey" => "29140359"
"RoomLength" => 4.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
11 => array:11 [
"RoomKey" => "1540614914"
"RoomType" => "Laundry room"
"ListingId" => "X12580000"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.26
"ListingKey" => "29140359"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-26T22:28:56.36Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29140359/565-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 38.0
+"OriginalEntryTimestamp": "2025-11-26T22:00:22.57Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:35 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341680706"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/a6958272eb5bfc3241075427bef8cbe1.webp"
"MediaSize" => 326682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-a6958272eb5bfc3241075427bef8cbe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341680714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/03446f598dd1616612df9127a7b92739.webp"
"MediaSize" => 311795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-03446f598dd1616612df9127a7b92739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341680740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/36ae64c62abea11b82440d2f7e07bfa2.webp"
"MediaSize" => 103164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-36ae64c62abea11b82440d2f7e07bfa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341680762"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/bc4258c5780aa67c9885ce6f75534732.webp"
"MediaSize" => 133125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-bc4258c5780aa67c9885ce6f75534732.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341680793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/729fb0ef6043b46b4d501aeb0172bb93.webp"
"MediaSize" => 162289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-729fb0ef6043b46b4d501aeb0172bb93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341680840"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/426614cb17bc45f88291e46c3bab48de.webp"
"MediaSize" => 158510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-426614cb17bc45f88291e46c3bab48de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341680849"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/b48e3cbfa50a1b4a644417f55d0fe129.webp"
"MediaSize" => 158232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-b48e3cbfa50a1b4a644417f55d0fe129.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341680901"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/ac3101458843806bb86eac364f94ae30.webp"
"MediaSize" => 148875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-ac3101458843806bb86eac364f94ae30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6341680938"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/373858709216e91065bb8d3b5aee5f98.webp"
"MediaSize" => 169527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-373858709216e91065bb8d3b5aee5f98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6341680954"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/0b02c4ee7e8715b056a2b3aea5f55609.webp"
"MediaSize" => 181420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-0b02c4ee7e8715b056a2b3aea5f55609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6341680962"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/f9bed34e8437fb16e0aa37f30ad9f3b2.webp"
"MediaSize" => 159930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-f9bed34e8437fb16e0aa37f30ad9f3b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6341680984"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/a810452ccf96fdc5f48fa544cb71ceaf.webp"
"MediaSize" => 89924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-a810452ccf96fdc5f48fa544cb71ceaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6341680993"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/47a5ba96aa026eb67c8a5219c8b2b8b5.webp"
"MediaSize" => 93611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-47a5ba96aa026eb67c8a5219c8b2b8b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6341681028"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/4fcdf57f8568f80bde058ccea8ab9f50.webp"
"MediaSize" => 97871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-4fcdf57f8568f80bde058ccea8ab9f50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6341681056"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/cc9eccf4cdf173aea0f5cd6d94e4628a.webp"
"MediaSize" => 145522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-cc9eccf4cdf173aea0f5cd6d94e4628a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6341681121"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/ea1b6ca463c9fd0f380f45d773c5a2ba.webp"
"MediaSize" => 154576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-ea1b6ca463c9fd0f380f45d773c5a2ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6341681173"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/5c1b86590c94317829818b2044d210a2.webp"
"MediaSize" => 112011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-5c1b86590c94317829818b2044d210a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6341681217"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/3aa28b784c81ee371ee7290bd1806e46.webp"
"MediaSize" => 92679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-3aa28b784c81ee371ee7290bd1806e46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6341681220"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/8deef329c6f7e4740d4c099ccedf878a.webp"
"MediaSize" => 126866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-8deef329c6f7e4740d4c099ccedf878a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6341681259"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/a7356385caa01a1b9294fd5522bbc980.webp"
"MediaSize" => 140121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-a7356385caa01a1b9294fd5522bbc980.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6341681290"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/030f31219f7bb33026c56a0045a165d0.webp"
"MediaSize" => 138896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-030f31219f7bb33026c56a0045a165d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6341681305"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/5bd439afef1c2de36bf0c662d0fc44d5.webp"
"MediaSize" => 147594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-5bd439afef1c2de36bf0c662d0fc44d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6341681362"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/29e4165935185c874a8fbb32d73e80c8.webp"
"MediaSize" => 72419
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-29e4165935185c874a8fbb32d73e80c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6341681406"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/1ce9510f5254fa6d6b429b7de5675736.webp"
"MediaSize" => 191594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-1ce9510f5254fa6d6b429b7de5675736.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6341681445"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/f3558ee2db382f98cb6d6fe5e30f312a.webp"
"MediaSize" => 164453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-f3558ee2db382f98cb6d6fe5e30f312a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6341681451"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/021b75a1d91c89bd288a9dc6d40fc0e3.webp"
"MediaSize" => 115715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-021b75a1d91c89bd288a9dc6d40fc0e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6341681474"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/5163695c2004e2a191e10db34c363553.webp"
"MediaSize" => 65994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-5163695c2004e2a191e10db34c363553.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6341681509"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/899fd5e4da0163a329c402d30215f2c8.webp"
"MediaSize" => 152058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-899fd5e4da0163a329c402d30215f2c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6341681595"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/89b27a49e29611cd44949c9d3c679ec9.webp"
"MediaSize" => 162791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-89b27a49e29611cd44949c9d3c679ec9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6341681626"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/a06cd5a4f687a2c415ae64a904cf6254.webp"
"MediaSize" => 150345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-a06cd5a4f687a2c415ae64a904cf6254.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6341681629"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/300aded3bbfc1fe10f87c6c2caaadb4e.webp"
"MediaSize" => 142224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-300aded3bbfc1fe10f87c6c2caaadb4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6341681640"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/21d8836420a330209e46f279a33fe97a.webp"
"MediaSize" => 149191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-21d8836420a330209e46f279a33fe97a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6341681661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/320fea6282a48e4c897de4056b82e39e.webp"
"MediaSize" => 369689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-320fea6282a48e4c897de4056b82e39e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6341681692"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/0883fe6aabdb50f502e0adaa85af5e9f.webp"
"MediaSize" => 375281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-0883fe6aabdb50f502e0adaa85af5e9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6341681699"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29140359/5365025ef022ebc3eb0714bb82ed5ecc.webp"
"MediaSize" => 407643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29140359/thumbnail-5365025ef022ebc3eb0714bb82ed5ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12580000"
"ResourceRecordKey" => "29140359"
"ModificationTimestamp" => "2025-11-26T22:00:22.58Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29140359')"
+"ID": "446630"
}
]
+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 50449/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50449&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50449/Office?$select=ALL&$top=10&$filter=OfficeKey eq 50449&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25116
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25118
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "SUTTON GROUP REALTY SYSTEMS INC."
+"OfficeEmail": null
+"OfficePhone": "905-896-3333"
+"OfficeMlsId": "601410"
+"ModificationTimestamp": "2025-05-07T17:51:28Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "50449"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1542 DUNDAS STREET WEST"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5C1E"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1003210"
+"OriginalEntryTimestamp": null
+"Media": array:1 [
0 => array:10 [
"Order" => 1
"MediaKey" => "5987066409"
"MediaURL" => "https://ddfcdn.realtor.ca/organization/en-ca/TS638822218800000000/highres/50449.jpg"
"ResourceName" => "Office"
"MediaCategory" => "Office Logo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "601410"
"ResourceRecordKey" => "50449"
"ModificationTimestamp" => "2025-05-07T17:38:00Z"
]
]
+"OfficeFax": "905-848-5327"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "432325"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "50449"
"SocialMediaUrlOrId" => "http://www.suttonrealty.com/"
"ModificationTimestamp" => "2025-05-07T17:38:00Z"
]
]
+"FranchiseNationalAssociationId": "1176600"
+"OfficeBrokerNationalAssociationId": "1036213"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('50449')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2016676/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2016676&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2016676/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2016676&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25121
+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 29140359" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24715
+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 29140359/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29140359&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29140359/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29140359&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24695
+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 29140359 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5978521 43.4581856)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29140359 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5978521 43.4581856)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29140359 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5978521 43.4581856)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29140359 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5978521 43.4581856)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24962
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24599
+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"
…8
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141044')"
+"ID": "447626"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24958
+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 {#24973
+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 {#24959
+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 {#24657
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24574
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23288
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24960
+post_id: "428430"
+post_author: 1
+"ListingKey": "29115130"
+"ListingId": "40789049"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-18T20:30:35Z"
+"RFModificationTimestamp": "2025-11-18T22:09:44Z"
+"ListPrice": 405000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 690.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A8"
+"UnparsedAddress": "776 LAURELWOOD Drive Unit# 307, Waterloo, Ontario N2V0A8"
+"Coordinates": array:2 [
0 => -80.5983268
1 => 43.4708684
]
+"Latitude": 43.4708684
+"Longitude": -80.5983268
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 1 bedroom + den condo located in the highly sought-after Laurelwood neighbourhood! This bright and tasteful unit offers a functional layout with a spacious open-concept design, perfect for comfortable everyday living. The kitchen is beautiful and features, granite countertops, stainless steel appliances, and a large island—ideal for casual breakfasts or entertaining guests. The primary bedroom has a walk-in closet and the versatile den provides flexible space that can easily be used as a home office, guest room, or cozy reading nook. Enjoy all the conveniences of condo living in a vibrant community known for its top-rated schools, scenic trails, beautiful parks, the YMCA, public library, shopping, and a wide selection of restaurants—all just minutes from your door. Whether you're a first-time buyer, downsizer, or investor, this Laurelwood condo offers incredible value in a prime location. Don't miss this opportunity! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "326.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T22:09:34.898698+00:00"
+"Directions": "Erbsville to Laurelwood Drive"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915825"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-11-18T20:19:38Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-18T20:19:38Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "776"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "2990.5"
+"VirtualTourURLUnbranded": "https://youriguide.com/776_laurelwood_dr_307_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29115130/776-laurelwood-drive-unit-307-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"BuildingFeatures": array:1 [
0 => "Party Room"
]
+"ZoningDescription": "RMU-20"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 690
+"OriginalEntryTimestamp": "2025-11-18T20:19:38.9Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:48 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29115130')"
+"ID": "428430"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24961
+post_id: "419557"
+post_author: 1
+"ListingKey": "29098594"
+"ListingId": "40787765"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-20T17:45:17Z"
+"RFModificationTimestamp": "2025-11-20T17:46:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.114
+"LivingArea": 3300.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C4"
+"UnparsedAddress": "722 SUNDEW Drive, Waterloo, Ontario N2V0C4"
+"Coordinates": array:2 [
0 => -80.6026665
1 => 43.4610373
]
+"Latitude": 43.4610373
+"Longitude": -80.6026665
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 722 Sundew Drive, Waterloo – an exquisite and meticulously maintained fully furnished home available for lease. Perfectly suited for families or working professionals, this expansive property offers a harmonious blend of comfort, convenience, and style. The carpet-free main level features distinct living and family rooms, providing ample space for relaxation and entertainment. The state-of-the-art kitchen is equipped with high-end stainless steel appliances, a walk-in pantry, and is complemented by a separate dining room and a cozy breakfast area, ideal for both casual and formal dining experiences. Ascend to the upper level where you'll discover four generously sized bedrooms, including two luxurious master suites each with their own private bathrooms, offering a serene retreat. The additional two bedrooms share a well-appointed Jack and Jill bathroom, ensuring privacy and convenience. 5th bedroom on this level provides a quiet area and offers flex space for home office, and the upper-level laundry room adds an extra layer of convenience to your daily routine. The basement, though unfinished, is included in the lease and provides additional space for storage or recreational use, with the landlords reserving half for their own storage needs. This home is ideally located near Costco Plaza and Boardwalk Plazas, providing easy access to shopping, dining, and entertainment options. Top-notch schools and scenic walking trails are within walking distance, making it a perfect, family-friendly neighborhood. Don't miss out on this fantastic leasing opportunity. Embrace the exceptional lifestyle that 722 Sundew Drive has to offer. Book your showing today and experience the perfect blend of luxury and convenience in this outstanding home. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-17T10:51:25.701280+00:00"
+"Directions": "Pasture Rose St To Sundew Drive"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Gazebo"
3 => "No Pet Home"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.114"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T17:38:53Z"
+"PhotosCount": 28
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-20T17:38:53Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "722"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29098594/722-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"TotalActualRent": 4200
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 3300
+"OriginalEntryTimestamp": "2025-11-13T15:09:26.38Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:28 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29098594')"
+"ID": "419557"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 117
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]
