array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29228867/Property?$select=ALL&$top=20&$filter=ListingKey eq 29228867&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29228867/Property?$select=ALL&$top=20&$filter=ListingKey eq 29228867&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23469
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23471
+post_id: "519413"
+post_author: 1
+"ListingKey": "29228867"
+"ListingId": "40796720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T16:10:28Z"
+"RFModificationTimestamp": "2026-01-08T16:49:54Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1192.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W2"
+"UnparsedAddress": "360 ERBSVILLE Road Unit# 7, Waterloo, Ontario N2T2W2"
+"Coordinates": array:2 [
0 => -80.5800942
1 => 43.4617129
]
+"Latitude": 43.4617129
+"Longitude": -80.5800942
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to effortless, turnkey living in one of Waterloo’s most desirable communities. This immaculate bungalow townhouse is thoughtfully designed for comfort, ease, and everyday enjoyment—ideal for downsizers, professionals, or anyone seeking a low-maintenance lifestyle without compromise. From the moment you step inside, the home feels bright, calm, and impeccably cared for. A sun-filled bedroom at the front of the home offers flexibility as a guest room, office, or cozy retreat. The heart of the home unfolds into a beautifully updated, open-concept kitchen, dining, and living area—perfect for both quiet mornings and relaxed entertaining. The kitchen features stainless steel appliances, modern finishes, and a seamless connection to the outdoors, with views over a lush, green backyard. Step out onto the newer deck and imagine summer evenings spent BBQ’ing, hosting friends, or simply enjoying the peaceful backdrop of mature greenery—your own private escape. The spacious primary bedroom offers comfort and privacy, complete with its own ensuite bathroom. A convenient additional two-piece bathroom is located on the main floor, along with a laundry rough-in for future flexibility. Accessibility has been thoughtfully considered throughout the home, including a chair lift providing easy access to the fully finished basement. Downstairs, you’ll find a large, versatile living space, an additional full bathroom, and a substantial storage/workroom—ideal for hobbies, organization, or extra living needs. Immaculately maintained, move-in ready, and set within a sought-after Waterloo location close to amenities, trails, and everyday conveniences, this home offers the perfect balance of simplicity, comfort, and quality. A rare opportunity to enjoy bungalow living at its very best. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "756.43"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T16:49:30.858726+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1902312"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-08T16:01:07Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T16:01:07Z"
+"Stories": "1.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "360"
+"StreetSuffix": "Road"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4678.09"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/unit_7_360_erbsville_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1557930359"
"RoomType" => "3pc Bathroom"
"ListingId" => "40796720"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.53Z"
]
1 => array:11 [
"RoomKey" => "1557930360"
"RoomType" => "Utility room"
"ListingId" => "40796720"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.53Z"
]
2 => array:11 [
"RoomKey" => "1557930361"
"RoomType" => "Storage"
"ListingId" => "40796720"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => "18'10'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.53Z"
]
3 => array:11 [
"RoomKey" => "1557930362"
"RoomType" => "Recreation room"
"ListingId" => "40796720"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => "23'5'' x 19'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.53Z"
]
4 => array:11 [
"RoomKey" => "1557930363"
"RoomType" => "2pc Bathroom"
"ListingId" => "40796720"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.54Z"
]
5 => array:11 [
"RoomKey" => "1557930364"
"RoomType" => "4pc Bathroom"
"ListingId" => "40796720"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.54Z"
]
6 => array:11 [
"RoomKey" => "1557930365"
"RoomType" => "Primary Bedroom"
"ListingId" => "40796720"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.54Z"
]
7 => array:11 [
"RoomKey" => "1557930366"
"RoomType" => "Bedroom"
"ListingId" => "40796720"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.54Z"
]
8 => array:11 [
"RoomKey" => "1557930367"
"RoomType" => "Living room"
"ListingId" => "40796720"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.54Z"
]
9 => array:11 [
"RoomKey" => "1557930368"
"RoomType" => "Kitchen"
"ListingId" => "40796720"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.54Z"
]
10 => array:11 [
"RoomKey" => "1557930369"
"RoomType" => "Dining room"
"ListingId" => "40796720"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29228867"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T16:01:07.54Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29228867/360-erbsville-road-unit-7-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1.0
+"AboveGradeFinishedArea": 1192
+"OriginalEntryTimestamp": "2026-01-08T16:01:07.49Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:37 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6396703749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/220a971219703b793338b93ec2daed1f.webp"
"MediaSize" => 71884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-220a971219703b793338b93ec2daed1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Large finished space - also includes a spacious workroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6396703804"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/519a0db35a03a3d9f5da6aaee9a0e03b.webp"
"MediaSize" => 49645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-519a0db35a03a3d9f5da6aaee9a0e03b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement Bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6396703876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/1ab392ee3b6cd521824361258b558117.webp"
"MediaSize" => 60896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-1ab392ee3b6cd521824361258b558117.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6396703947"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/82f135c0d59a8bffe1631ea9e2038e12.webp"
"MediaSize" => 111785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-82f135c0d59a8bffe1631ea9e2038e12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6396703995"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/86938c45fbe79cd362f158ed2adf3a40.webp"
"MediaSize" => 61859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-86938c45fbe79cd362f158ed2adf3a40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6396704072"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/f7a33b4b4127e6f634b8550834fc2a5a.webp"
"MediaSize" => 76809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-f7a33b4b4127e6f634b8550834fc2a5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6396704099"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/fb8aef9871ec87347e49130b47d97b4e.webp"
"MediaSize" => 69795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-fb8aef9871ec87347e49130b47d97b4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6396704156"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/56ad6efd07a5450fa84da918eaba086f.webp"
"MediaSize" => 105481
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-56ad6efd07a5450fa84da918eaba086f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6396704186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/7785daf442696682df8b7614bf219013.webp"
"MediaSize" => 61738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-7785daf442696682df8b7614bf219013.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6396704222"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/92701ae5f19a3dcf738db434b180d5b0.webp"
"MediaSize" => 76106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-92701ae5f19a3dcf738db434b180d5b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6396704245"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/1ebadf60ff5a34d763be59999d6b4481.webp"
"MediaSize" => 121824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-1ebadf60ff5a34d763be59999d6b4481.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6396704327"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/53d897608d10d5973d8859dde6681aac.webp"
"MediaSize" => 67558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-53d897608d10d5973d8859dde6681aac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6396704390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/976ea9da04c1088a71ca825e4393ad36.webp"
"MediaSize" => 63140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-976ea9da04c1088a71ca825e4393ad36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6396704436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/bd6421f31f1f7a843a521b5d00df36b0.webp"
"MediaSize" => 49434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-bd6421f31f1f7a843a521b5d00df36b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6396704458"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/ffde8a4877ea3218841217d7c9c4a443.webp"
"MediaSize" => 53555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-ffde8a4877ea3218841217d7c9c4a443.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6396704530"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/8edb498c9ecee21730372cd7c2488cba.webp"
"MediaSize" => 56528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-8edb498c9ecee21730372cd7c2488cba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6396704592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/1c784e5669c8af690f9d746d619b18b3.webp"
"MediaSize" => 63451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-1c784e5669c8af690f9d746d619b18b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6396704631"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/9b29c9fe559c24937c29c99bf06efeed.webp"
"MediaSize" => 116389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-9b29c9fe559c24937c29c99bf06efeed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6396704655"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/f0a3a054000453deebd6efad4527e0c9.webp"
"MediaSize" => 79200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-f0a3a054000453deebd6efad4527e0c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6396704701"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/1c955e7a2889b8843750fb24b72809e9.webp"
"MediaSize" => 70830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-1c955e7a2889b8843750fb24b72809e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6396704741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/1cd7983ae1a13f8ce128850bbf28890b.webp"
"MediaSize" => 88183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-1cd7983ae1a13f8ce128850bbf28890b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6396704792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/93ae2ab330fdc4463c06ef82f2f5ea13.webp"
"MediaSize" => 108089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-93ae2ab330fdc4463c06ef82f2f5ea13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6396704830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/566399727fe7341aebbf61697f188be6.webp"
"MediaSize" => 70027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-566399727fe7341aebbf61697f188be6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6396704865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/d4271e644962ad04b60f8b4abbefa9d5.webp"
"MediaSize" => 103150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-d4271e644962ad04b60f8b4abbefa9d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6396704902"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/1184017f388cf7d6dee35032d971f788.webp"
"MediaSize" => 90209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-1184017f388cf7d6dee35032d971f788.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6396704927"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/f5408e87c6c17dfb9d7a9586b45e1cb2.webp"
"MediaSize" => 71063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-f5408e87c6c17dfb9d7a9586b45e1cb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6396704956"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/40646ba5767d084a96cd9c35abe8cfdc.webp"
"MediaSize" => 60700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-40646ba5767d084a96cd9c35abe8cfdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6396704978"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/daf7e66c4b5c0a47d5c144e8727b9994.webp"
"MediaSize" => 66539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-daf7e66c4b5c0a47d5c144e8727b9994.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6396705001"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/569f00d46a3d7155e056471d118812a3.webp"
"MediaSize" => 112694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-569f00d46a3d7155e056471d118812a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6396705007"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/d4ef82e27409503eace9f0b800187ded.webp"
"MediaSize" => 124276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-d4ef82e27409503eace9f0b800187ded.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6396705022"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/66548a38713dcddb538d425daa478444.webp"
"MediaSize" => 96294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-66548a38713dcddb538d425daa478444.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6396705042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/6c20ab755fab40fbed3503786bd3a231.webp"
"MediaSize" => 67073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-6c20ab755fab40fbed3503786bd3a231.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6396705059"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/b936f540092e5fca3bef40f2ad3f7286.webp"
"MediaSize" => 75724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-b936f540092e5fca3bef40f2ad3f7286.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6396705074"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/be695782737c8def9c5e3480d51e8235.webp"
"MediaSize" => 121280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-be695782737c8def9c5e3480d51e8235.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6396705087"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/8a0f70480050130b9c410447971db90b.webp"
"MediaSize" => 76538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-8a0f70480050130b9c410447971db90b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6396705096"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/fc9b4e8851285569142b5bb83b4aeaac.webp"
"MediaSize" => 60599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-fc9b4e8851285569142b5bb83b4aeaac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6396705109"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29228867/ed9d052f563f0e95833ad6c7a9fb7bd0.webp"
"MediaSize" => 54558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29228867/thumbnail-ed9d052f563f0e95833ad6c7a9fb7bd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796720"
"ResourceRecordKey" => "29228867"
"ModificationTimestamp" => "2026-01-08T16:01:07.5Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Jen Ziegler"
"MemberFirstName" => "Jen"
"MemberLastName" => "Ziegler"
"MemberMlsId" => "KWkw7538"
"OriginatingSystemName" => 26
"MemberKey" => "1902312"
"ModificationTimestamp" => "2025-10-28T23:27:42Z"
"MemberStatus" => "Active"
"OfficeKey" => "299554"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Waterloo"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-807-9416"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2010-12-06T14:01:00Z"
"MemberNationalAssociationId" => "1218041"
"OfficeNationalAssociationId" => "1473831"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "RE/MAX SOLID GOLD REALTY (II) LTD."
"OfficePhone" => "519-888-7110"
"OfficeMlsId" => "WR50869"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "299554"
"ModificationTimestamp" => "2026-01-02T22:48:39Z"
"OfficeAddress1" => "180 Weber Street South Unit A"
"OfficeCity" => "Waterloo"
"OfficePostalCode" => "N2J2B"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2024-12-18T13:19:00Z"
"OfficeNationalAssociationId" => "1473831"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1069893"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29228867')"
+"ID": "519413"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 299554/Office?$select=ALL&$top=10&$filter=OfficeKey eq 299554&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 299554/Office?$select=ALL&$top=10&$filter=OfficeKey eq 299554&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25302
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX SOLID GOLD REALTY (II) LTD."
+"OfficeEmail": null
+"OfficePhone": "519-888-7110"
+"OfficeMlsId": "WR50869"
+"ModificationTimestamp": "2026-01-02T22:48:39Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "299554"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "180 Weber Street South Unit A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2J2B"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1473831"
+"OriginalEntryTimestamp": "2024-12-18T13:19:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "398511"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "299554"
"SocialMediaUrlOrId" => "http://www.remaxsolidgold.biz/"
"ModificationTimestamp" => "2026-01-02T22:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1069893"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('299554')"
}
]
+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 1902312/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1902312&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1902312/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1902312&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25307
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29228867" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24922
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29228867/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29228867&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29228867/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29228867&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24902
+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 29228867 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5800942 43.4617129)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29228867 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5800942 43.4617129)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29228867 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5800942 43.4617129)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29228867 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5800942 43.4617129)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24841
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25148
+post_id: "524212"
+post_author: 1
+"ListingKey": "29235913"
+"ListingId": "X12682444"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T22:50:05Z"
+"RFModificationTimestamp": "2026-01-10T01:16:38Z"
+"ListPrice": 1105900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "541 BALSAM POPLAR STREET, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.598831
1 => 43.456753
]
+"Latitude": 43.456753
+"Longitude": -80.598831
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The Lucy - This spacious Net Zero Ready Single Detached Home boasts a thoughtfully designed living space. The main floor showcases an open-concept layout with a great room, modern kitchen, dinette, and dining room. It also includes a powder room and mudroom leading through the garage. On the second floor, you'll find a principal bedroom with a walk-in closet and luxury ensuite, along with three additional bedrooms, a main bath, upper lounge, and convenient laundry area. The basement provides a generous unfinished space with the option to add a bedroom, 3-piece bathroom, and laundry area, allowing you to maximize the home to suit your needs now or in the future. (id:62650)"
+"Appliances": array:3 [
0 => "Water meter"
1 => "Water softener"
2 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"CreationDate": "2026-01-10T01:15:50.840189+00:00"
+"Directions": "Sundew Dr. and Balsam Poplar St."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:7 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Not known"
3 => "Not known"
4 => "Electric"
5 => "Electric"
6 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240654"
+"ListOfficeKey": "287182"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "40.1 x 98.6 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-01-09T22:41:18Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T22:41:18Z"
+"Stories": "2.0"
+"StreetName": "Balsam Poplar"
+"StreetNumber": "541"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2184.84"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1558451334"
"RoomType" => "Great room"
"ListingId" => "X12682444"
"RoomLevel" => "Main level"
"RoomWidth" => 6.81
"ListingKey" => "29235913"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:41:18.14Z"
]
1 => array:11 [
"RoomKey" => "1558451335"
"RoomType" => "Kitchen"
"ListingId" => "X12682444"
"RoomLevel" => "Main level"
"RoomWidth" => 4.34
"ListingKey" => "29235913"
"RoomLength" => 5.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:41:18.14Z"
]
2 => array:11 [
"RoomKey" => "1558451336"
"RoomType" => "Dining room"
"ListingId" => "X12682444"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29235913"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:41:18.14Z"
]
3 => array:11 [
"RoomKey" => "1558451337"
"RoomType" => "Bedroom 2"
"ListingId" => "X12682444"
"RoomLevel" => "Second level"
"RoomWidth" => 3.86
"ListingKey" => "29235913"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:41:18.14Z"
]
4 => array:11 [
"RoomKey" => "1558451338"
"RoomType" => "Bedroom 3"
"ListingId" => "X12682444"
"RoomLevel" => "Second level"
"RoomWidth" => 3.86
"ListingKey" => "29235913"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:41:18.14Z"
]
5 => array:11 [
"RoomKey" => "1558451339"
"RoomType" => "Bedroom 4"
"ListingId" => "X12682444"
"RoomLevel" => "Second level"
"RoomWidth" => 3.86
"ListingKey" => "29235913"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:41:18.15Z"
]
6 => array:11 [
"RoomKey" => "1558451340"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12682444"
"RoomLevel" => "Second level"
"RoomWidth" => 5.46
"ListingKey" => "29235913"
"RoomLength" => 5.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:41:18.15Z"
]
7 => array:11 [
"RoomKey" => "1558451341"
"RoomType" => "Loft"
"ListingId" => "X12682444"
"RoomLevel" => "Second level"
"RoomWidth" => 4.52
"ListingKey" => "29235913"
"RoomLength" => 2.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:41:18.15Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29235913/541-balsam-poplar-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2240411"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "290667"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.1
+"OriginalEntryTimestamp": "2026-01-09T22:41:18.11Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:4 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398511595"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235913/dcf3969d2a7bc78d3689dc9f0a21b4ea.webp"
"MediaSize" => 78930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235913/thumbnail-dcf3969d2a7bc78d3689dc9f0a21b4ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12682444"
"ResourceRecordKey" => "29235913"
"ModificationTimestamp" => "2026-01-09T22:41:18.12Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398511628"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235913/579fcbf5c1bfb169e0ad0bca071492ad.webp"
"MediaSize" => 34582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235913/thumbnail-579fcbf5c1bfb169e0ad0bca071492ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682444"
"ResourceRecordKey" => "29235913"
"ModificationTimestamp" => "2026-01-09T22:41:18.12Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398511680"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235913/c0a8aa574b7a7ccf0bf984f3b5556f39.webp"
"MediaSize" => 37416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235913/thumbnail-c0a8aa574b7a7ccf0bf984f3b5556f39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682444"
"ResourceRecordKey" => "29235913"
"ModificationTimestamp" => "2026-01-09T22:41:18.12Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398511705"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235913/a887058dfcfc90bb0daa440557185c32.webp"
"MediaSize" => 33027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235913/thumbnail-a887058dfcfc90bb0daa440557185c32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682444"
"ResourceRecordKey" => "29235913"
"ModificationTimestamp" => "2026-01-09T22:41:18.12Z"
]
]
+"Member": array:1 [
0 => array:4 [
"MemberMlsId" => "2240654"
"OriginatingSystemName" => 26
"MemberKey" => "2240654"
"ModificationTimestamp" => "2026-01-09T22:00:04Z"
]
]
+"Office": array:1 [
0 => array:5 [
"OfficeMlsId" => "287182"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "287182"
"ModificationTimestamp" => "2025-03-04T16:59:11Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235913')"
+"ID": "524212"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24769
+post_id: "524213"
+post_author: 1
+"ListingKey": "29234903"
+"ListingId": "40796695"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T19:45:45Z"
+"RFModificationTimestamp": "2026-01-09T23:55:01Z"
+"ListPrice": 1079900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2881.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "337 CANADA PLUM Street, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.5976073
1 => 43.4571288
]
+"Latitude": 43.4571288
+"Longitude": -80.5976073
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in the Vista Hills community in Waterloo, this spacious Net Zero Ready Single Detached Home boasts a thoughtfully designed living space. The main floor offers a large, open-concept layout with a great room, kitchen, and dinette. You'll also find a dining room, office, powder room, and covered porch and balcony. The Samuel's third floor offers a principal bedroom with a walk-in closet and luxury ensuite, as well as 3 additional bedrooms, two bathrooms and a laundry room. The ground floor provides a spacious unfinished area with an optional secondary suite option, complete with bedroom, bathroom, and kitchen. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-01-09T23:54:43.195011+00:00"
+"Directions": "Sundew and Canada Plum"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564212"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T19:39:26Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T19:39:26Z"
+"Stories": "3.0"
+"StreetName": "CANADA PLUM"
+"StreetNumber": "337"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "2130.22"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1558382065"
"RoomType" => "Laundry room"
"ListingId" => "40796695"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
1 => array:11 [
"RoomKey" => "1558382066"
"RoomType" => "5pc Bathroom"
"ListingId" => "40796695"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
2 => array:11 [
"RoomKey" => "1558382067"
"RoomType" => "4pc Bathroom"
"ListingId" => "40796695"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
3 => array:11 [
"RoomKey" => "1558382068"
"RoomType" => "Other"
"ListingId" => "40796695"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
4 => array:11 [
"RoomKey" => "1558382069"
"RoomType" => "Great room"
"ListingId" => "40796695"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
5 => array:11 [
"RoomKey" => "1558382070"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40796695"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 23'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
6 => array:11 [
"RoomKey" => "1558382071"
"RoomType" => "Dining room"
"ListingId" => "40796695"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
7 => array:11 [
"RoomKey" => "1558382072"
"RoomType" => "Office"
"ListingId" => "40796695"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 6'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
8 => array:11 [
"RoomKey" => "1558382073"
"RoomType" => "2pc Bathroom"
"ListingId" => "40796695"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
9 => array:11 [
"RoomKey" => "1558382074"
"RoomType" => "Primary Bedroom"
"ListingId" => "40796695"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.66Z"
]
10 => array:11 [
"RoomKey" => "1558382075"
"RoomType" => "Full bathroom"
"ListingId" => "40796695"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.67Z"
]
11 => array:11 [
"RoomKey" => "1558382076"
"RoomType" => "Bedroom"
"ListingId" => "40796695"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.67Z"
]
12 => array:11 [
"RoomKey" => "1558382077"
"RoomType" => "Bedroom"
"ListingId" => "40796695"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.67Z"
]
13 => array:11 [
"RoomKey" => "1558382078"
"RoomType" => "Bedroom"
"ListingId" => "40796695"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.67Z"
]
14 => array:11 [
"RoomKey" => "1558382079"
"RoomType" => "Foyer"
"ListingId" => "40796695"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29234903"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T19:39:26.67Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29234903/337-canada-plum-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1951790"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2881
+"OriginalEntryTimestamp": "2026-01-09T19:39:26.62Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:4 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398273539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29234903/e4cfea108fd65f37d6389d7498a745cd.webp"
"MediaSize" => 106680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29234903/thumbnail-e4cfea108fd65f37d6389d7498a745cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front facade with board and batten siding, a garage, brick siding, and a balcony"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40796695"
"ResourceRecordKey" => "29234903"
"ModificationTimestamp" => "2026-01-09T19:39:26.62Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398273569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29234903/21ce3daa9d6ac0d80521e16b15b16d8f.webp"
"MediaSize" => 40939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29234903/thumbnail-21ce3daa9d6ac0d80521e16b15b16d8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of floor plan / room layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796695"
"ResourceRecordKey" => "29234903"
"ModificationTimestamp" => "2026-01-09T19:39:26.62Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398273613"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29234903/8ca9f88540320dec9fe51956570fac18.webp"
"MediaSize" => 37909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29234903/thumbnail-8ca9f88540320dec9fe51956570fac18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of room layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796695"
"ResourceRecordKey" => "29234903"
"ModificationTimestamp" => "2026-01-09T19:39:26.62Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398273635"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29234903/adbe75a9595023617feb22eac524e28a.webp"
"MediaSize" => 30162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29234903/thumbnail-adbe75a9595023617feb22eac524e28a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of home floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40796695"
"ResourceRecordKey" => "29234903"
"ModificationTimestamp" => "2026-01-09T19:39:26.62Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "GREG METCALFE"
"MemberFirstName" => "GREG"
"MemberLastName" => "METCALFE"
"MemberMlsId" => "KWkw5739"
"OriginatingSystemName" => 26
"MemberKey" => "1564212"
"ModificationTimestamp" => "2025-10-28T23:31:15Z"
"MemberStatus" => "Active"
"OfficeKey" => "290620"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Kitchener"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-747-0231"
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1134817"
"OfficeNationalAssociationId" => "1389824"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "Peak Realty Ltd."
"OfficePhone" => "519-747-0231"
"OfficeMlsId" => "KW368"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "290620"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "25 Bruce St., Unit 5B"
"OfficeCity" => "Kitchener"
"OfficePostalCode" => "N2B1Y"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-06-21T16:36:00Z"
"OfficeNationalAssociationId" => "1389824"
"FranchiseNationalAssociationId" => "1230701"
"OfficeBrokerNationalAssociationId" => "1171153"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29234903')"
+"ID": "524213"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24857
+post_id: "524214"
+post_author: 1
+"ListingKey": "29235086"
+"ListingId": "40796657"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T20:20:03Z"
+"RFModificationTimestamp": "2026-01-09T23:40:17Z"
+"ListPrice": 1089900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2747.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "543 BALSAM POPLAR Street, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.5980104
1 => 43.4564344
]
+"Latitude": 43.4564344
+"Longitude": -80.5980104
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The Lucas - This spacious Net Zero Ready Single Detached Home boasts a thoughtfully designed living space. The main floor showcases an open-concept layout with a great room, modern kitchen, and a dinette. It also includes a powder room and a convenient laundry area. On the second floor, you'll find a principal bedroom with a walk-in closet and luxury ensuite, along with three additional bedrooms, and a family room that can be transformed into an additional bedroom. The basement provides a generous unfinished space with the option to add a bedroom, 3-piece bathroom, and laundry area, allowing you to maximize the home to suit your needs now or in the future. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-01-09T23:40:13.622852+00:00"
+"Directions": "Sundew and Balsam Poplar"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564212"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T20:09:58Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T20:09:58Z"
+"Stories": "2.0"
+"StreetName": "BALSAM POPLAR"
+"StreetNumber": "543"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1558394130"
"RoomType" => "Family room"
"ListingId" => "40796657"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.43Z"
]
1 => array:11 [
"RoomKey" => "1558394131"
"RoomType" => "4pc Bathroom"
"ListingId" => "40796657"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.43Z"
]
2 => array:11 [
"RoomKey" => "1558394132"
"RoomType" => "Bedroom"
"ListingId" => "40796657"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.43Z"
]
3 => array:11 [
"RoomKey" => "1558394133"
"RoomType" => "Bedroom"
"ListingId" => "40796657"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.43Z"
]
4 => array:11 [
"RoomKey" => "1558394134"
"RoomType" => "Bedroom"
"ListingId" => "40796657"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.43Z"
]
5 => array:11 [
"RoomKey" => "1558394135"
"RoomType" => "Full bathroom"
"ListingId" => "40796657"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.44Z"
]
6 => array:11 [
"RoomKey" => "1558394136"
"RoomType" => "Primary Bedroom"
"ListingId" => "40796657"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.44Z"
]
7 => array:11 [
"RoomKey" => "1558394137"
"RoomType" => "Laundry room"
"ListingId" => "40796657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.44Z"
]
8 => array:11 [
"RoomKey" => "1558394138"
"RoomType" => "2pc Bathroom"
"ListingId" => "40796657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.44Z"
]
9 => array:11 [
"RoomKey" => "1558394139"
"RoomType" => "Foyer"
"ListingId" => "40796657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.44Z"
]
10 => array:11 [
"RoomKey" => "1558394140"
"RoomType" => "Great room"
"ListingId" => "40796657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.44Z"
]
11 => array:11 [
"RoomKey" => "1558394141"
"RoomType" => "Dining room"
"ListingId" => "40796657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.44Z"
]
12 => array:11 [
"RoomKey" => "1558394142"
"RoomType" => "Eat in kitchen"
"ListingId" => "40796657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29235086"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 19'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-09T20:09:58.44Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29235086/543-balsam-poplar-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1951790"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2747
+"OriginalEntryTimestamp": "2026-01-09T20:09:58.35Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:1 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398320842"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235086/9fdfb16b6ad3efca1cee01302d53f41d.webp"
"MediaSize" => 94814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235086/thumbnail-9fdfb16b6ad3efca1cee01302d53f41d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Craftsman inspired home with a garage, roof with shingles, stone siding, and driveway"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40796657"
"ResourceRecordKey" => "29235086"
"ModificationTimestamp" => "2026-01-09T20:09:58.36Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "GREG METCALFE"
"MemberFirstName" => "GREG"
"MemberLastName" => "METCALFE"
"MemberMlsId" => "KWkw5739"
"OriginatingSystemName" => 26
"MemberKey" => "1564212"
"ModificationTimestamp" => "2025-10-28T23:31:15Z"
"MemberStatus" => "Active"
"OfficeKey" => "290620"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Kitchener"
"MemberType" => "Salesperson"
…7
]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235086')"
+"ID": "524214"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24828
+post_id: "524215"
+post_author: 1
+"ListingKey": "29235085"
+"ListingId": "40796662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T20:20:03Z"
+"RFModificationTimestamp": "2026-01-09T23:39:02Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2448.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "529 BALSAM POPLAR Street, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.5980903
1 => 43.4564562
]
+"Latitude": 43.4564562
+"Longitude": -80.5980903
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The Miles II Model located in the Vista Hills community in Waterloo, this spacious Net Zero Ready Single Detached Home Boasts a thoughtfully designed living space. The main floor offers a large, open-concept layout with a great room, kitchen, and dinette. Around the corner from the kitchen, you'll find the mudroom, a walk-in storage closet and powder room. On the second floor, you'll find a principal bedroom with an ensuite and walk-in closet, along with two additional bedrooms, a family room (which can be converted into a fourth bedroom), and a main bathroom. The basement provides a spacious unfinished area with an optional secondary suite option, complete with bedroom, bathroom, and kitchen. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-01-09T23:38:40.846812+00:00"
+"Directions": "Sundew and Balsam Poplar"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564212"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T20:09:58Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T20:09:58Z"
+"Stories": "2.0"
+"StreetName": "BALSAM POPLAR"
+"StreetNumber": "529"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "2130.22"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29235085/529-balsam-poplar-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1951790"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2448
+"OriginalEntryTimestamp": "2026-01-09T20:09:58.24Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235085')"
+"ID": "524215"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24776
+post_id: "523368"
+post_author: 1
+"ListingKey": "29235668"
+"ListingId": "X12682226"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T22:25:48Z"
+"RFModificationTimestamp": "2026-01-09T22:28:09Z"
+"ListPrice": 1056900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "335 CANADA PLUM STREET, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.59785
1 => 43.456993
]
+"Latitude": 43.456993
+"Longitude": -80.59785
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The Isaac - Located in the Vista Hills community in Waterloo, this spacious NetZero Ready Single Detached Home boasts a thoughtfully designed living space. The main floor offers a large, open-concept layout with a great room, kitchen, and dinette. Down the hallway you'll find a dining room, office, and powder room. The Isaac's third floor offers a principal bedroom with a walk-in closet and luxury ensuite. Also on the third floor is the home's second and third bedroom, main bathroom, a laundry unit, a multi-purpose room, and a lounge off the stairwell. The ground floor provides a spacious unfinished area with a rough-in for a bathroom, offering flexibility for future development. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"CreationDate": "2026-01-09T22:02:12.165938+00:00"
+"Directions": "Sundew Dr. and Canada Plum St."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:7 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Not known"
3 => "Not known"
4 => "Electric"
5 => "Electric"
6 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240654"
+"ListOfficeKey": "287182"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "37.8 x 98.6 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-01-09T21:40:14Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T22:12:01Z"
+"Stories": "3.0"
+"StreetName": "CANADA PLUM"
+"StreetNumber": "335"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2157.53"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29235668/335-canada-plum-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2240411"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "290667"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 37.9
+"OriginalEntryTimestamp": "2026-01-09T21:40:14.54Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:5 [ …5]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235668')"
+"ID": "523368"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24762
+post_id: "523378"
+post_author: 1
+"ListingKey": "29235673"
+"ListingId": "X12682260"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T22:25:48Z"
+"RFModificationTimestamp": "2026-01-09T22:28:09Z"
+"ListPrice": 1089900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "543 BALSAM POPLAR STREET, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.598923
1 => 43.456829
]
+"Latitude": 43.456829
+"Longitude": -80.598923
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The Lucas - This spacious Net Zero Ready Single Detached Home boasts a thoughtfully designed living space. The main floor showcases an open-concept layout with a great room, modern kitchen, and a dinette. It also includes a powder room and a convenient laundry area. On the second floor, you'll find a principal bedroom with a walk-in closet and luxury ensuite, along with three additional bedrooms, and a family room that can be transformed into an additional bedroom. The basement provides a generous unfinished space with the option to add a bedroom, 3-piece bathroom, and laundry area, allowing you to maximize the home to suit your needs now or in the future. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"CreationDate": "2026-01-09T22:00:11.286631+00:00"
+"Directions": "Sundew Dr. and Balsam Poplar St."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:7 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Not known"
3 => "Not known"
4 => "Electric"
5 => "Electric"
6 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240654"
+"ListOfficeKey": "287182"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "40.1 x 98.6 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-01-09T21:46:48Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T22:12:01Z"
+"Stories": "2.0"
+"StreetName": "Balsam Poplar"
+"StreetNumber": "543"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2184.84"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29235673/543-balsam-poplar-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2240411"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "290667"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.1
+"OriginalEntryTimestamp": "2026-01-09T21:40:15.8Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:5 [ …5]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235673')"
+"ID": "523378"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23484
+post_id: "522987"
+post_author: 1
+"ListingKey": "29234950"
+"ListingId": "40796684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T20:05:43Z"
+"RFModificationTimestamp": "2026-01-09T20:19:00Z"
+"ListPrice": 1056900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2823.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "335 CANADA PLUM Street, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.6016613
1 => 43.4582167
]
+"Latitude": 43.4582167
+"Longitude": -80.6016613
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "The Isaac - Located in the Vista Hills community in Waterloo, this spacious Net Zero Ready Single Detached Homes boasts a thoughtfully designed living space. The main floor offers a large, open-concept layout with a great room, kitchen, and dinette. Down the hallway you'll find a dining room, office, and powder room. The Isaac's third floor offers a principal bedroom with a walk-in closet and luxury ensuite. Also on the third floor is the home's second and third bedroom, main bathroom, a laundry unit, a multi-purpose room, and a lounge off the stairwell. The ground floor provides a spacious unfinished area with a rough-in for a bathroom, offering flexibility for future development. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-01-09T20:18:46.576276+00:00"
+"Directions": "Sundew and Mayapple"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564212"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T19:50:25Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T19:50:25Z"
+"Stories": "3.0"
+"StreetName": "CANADA PLUM"
+"StreetNumber": "335"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "2157.53"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29234950/335-canada-plum-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1951790"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2823
+"OriginalEntryTimestamp": "2026-01-09T19:50:25.17Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29234950')"
+"ID": "522987"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24847
+post_id: "522988"
+post_author: 1
+"ListingKey": "29234951"
+"ListingId": "40796673"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T20:05:43Z"
+"RFModificationTimestamp": "2026-01-09T20:18:59Z"
+"ListPrice": 994900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2409.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0H8"
+"UnparsedAddress": "688 AUTUMN WILLOW Drive, Waterloo, Ontario N2V0H8"
+"Coordinates": array:2 [
0 => -80.598758
1 => 43.4558362
]
+"Latitude": 43.4558362
+"Longitude": -80.598758
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in the Vista Hills community in Waterloo, this spacious Net Zero Ready Single detached Home boasts a thoughtfully designed living space. The main floor includes a spacious great room, a kitchen with a dinette, a mudroom with laundry, and a powder room. On the second floor, you'll find a principal bedroom with an ensuite and walk-in closet, two additional bedrooms, a family room (which can be converted into a fourth bedroom), and a main bathroom. Upgrade your home with a finished basement or to a legal secondary suite - including a kitchen, living/dining area, bedroom with walk-in closet, 3-piece bathroom, and separate entrance. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-01-09T20:18:44.524011+00:00"
+"Directions": "Sundew and Balsam Poplar"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564212"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T19:50:25Z"
+"PhotosCount": 3
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T19:50:25Z"
+"Stories": "2.0"
+"StreetName": "AUTUMN WILLOW"
+"StreetNumber": "688"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "2130.22"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29234951/688-autumn-willow-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1951790"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2409
+"OriginalEntryTimestamp": "2026-01-09T19:50:25.4Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:3 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29234951')"
+"ID": "522988"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24842
+post_id: "521600"
+post_author: 1
+"ListingKey": "29232281"
+"ListingId": "X12678880"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T02:25:09Z"
+"RFModificationTimestamp": "2026-01-09T02:26:25Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "2 - 433 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.557083
1 => 43.458011
]
+"Latitude": 43.458011
+"Longitude": -80.557083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Amazing opportunity to lease in the highly sought-after Beechwood area, offering exceptional access to shopping, transit, and the University of Waterloo campus. This spacious 3-bedroom home checks all the boxes and showcases numerous upgrades, including bamboo hardwood flooring on the main and second levels, tasteful kitchen finishes, and a wet bar/summer kitchen in the finished basement. The exterior features a dedicated parking space and a large, fully fenced, landscaped backyard-perfect for outdoor enjoyment. A fantastic leasing opportunity in a prime location at excellent value in today's market. (id:62650)"
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T02:26:19.781275+00:00"
+"Directions": "Fischer Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1906649"
+"ListOfficeKey": "146431"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T02:12:00Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T02:12:00Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "433"
+"StreetSuffix": "Way"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29232281/2-433-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Prop Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2400
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-09T01:40:13.15Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:13 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29232281')"
+"ID": "521600"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 112
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]