array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29235673/Property?$select=ALL&$top=20&$filter=ListingKey eq 29235673&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29235673/Property?$select=ALL&$top=20&$filter=ListingKey eq 29235673&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23467
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23469
+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 [
"RoomKey" => "1558440868"
"RoomType" => "Great room"
"ListingId" => "X12682260"
"RoomLevel" => "Main level"
"RoomWidth" => 4.29
"ListingKey" => "29235673"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:12:01.5Z"
]
1 => array:11 [
"RoomKey" => "1558440869"
"RoomType" => "Dining room"
"ListingId" => "X12682260"
"RoomLevel" => "Main level"
"RoomWidth" => 4.19
"ListingKey" => "29235673"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:12:01.5Z"
]
2 => array:11 [
"RoomKey" => "1558440870"
"RoomType" => "Kitchen"
"ListingId" => "X12682260"
"RoomLevel" => "Main level"
"RoomWidth" => 4.11
"ListingKey" => "29235673"
"RoomLength" => 6.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:12:01.5Z"
]
3 => array:11 [
"RoomKey" => "1558440871"
"RoomType" => "Bedroom 2"
"ListingId" => "X12682260"
"RoomLevel" => "Second level"
"RoomWidth" => 3.43
"ListingKey" => "29235673"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:12:01.5Z"
]
4 => array:11 [
"RoomKey" => "1558440872"
"RoomType" => "Bedroom 3"
"ListingId" => "X12682260"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29235673"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:12:01.5Z"
]
5 => array:11 [
"RoomKey" => "1558440873"
"RoomType" => "Bedroom 4"
"ListingId" => "X12682260"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "29235673"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:12:01.51Z"
]
6 => array:11 [
"RoomKey" => "1558440874"
"RoomType" => "Family room"
"ListingId" => "X12682260"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "29235673"
"RoomLength" => 4.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:12:01.51Z"
]
7 => array:11 [
"RoomKey" => "1558440875"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12682260"
"RoomLevel" => "Second level"
"RoomWidth" => 3.96
"ListingKey" => "29235673"
"RoomLength" => 5.03
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-09T22:12:01.51Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6398440246"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235673/1d04cc3a139f65c8fcbec3d254e8efce.webp"
"MediaSize" => 11261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235673/thumbnail-1d04cc3a139f65c8fcbec3d254e8efce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12682260"
"ResourceRecordKey" => "29235673"
"ModificationTimestamp" => "2026-01-09T21:40:15.8Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398440254"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235673/5fbc2b3fae6c0e027c5542c071bf7948.webp"
"MediaSize" => 60079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235673/thumbnail-5fbc2b3fae6c0e027c5542c071bf7948.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682260"
"ResourceRecordKey" => "29235673"
"ModificationTimestamp" => "2026-01-09T21:46:48.38Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398440265"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235673/f4c15af403cd0c9f12c7d27372fdb9f8.webp"
"MediaSize" => 45588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235673/thumbnail-f4c15af403cd0c9f12c7d27372fdb9f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682260"
"ResourceRecordKey" => "29235673"
"ModificationTimestamp" => "2026-01-09T21:46:45.99Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398440313"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235673/0c1e8214eff8eae3eecee62734eda888.webp"
"MediaSize" => 43107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235673/thumbnail-0c1e8214eff8eae3eecee62734eda888.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12682260"
"ResourceRecordKey" => "29235673"
"ModificationTimestamp" => "2026-01-09T21:46:47.7Z"
]
]
+"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('29235673')"
+"ID": "523378"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 287182/Office?$select=ALL&$top=10&$filter=OfficeKey eq 287182&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 287182/Office?$select=ALL&$top=10&$filter=OfficeKey eq 287182&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25236
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25238
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": null
+"OfficeEmail": null
+"OfficePhone": null
+"OfficeMlsId": "287182"
+"ModificationTimestamp": "2025-03-04T16:59:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "287182"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": null
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": null
+"OfficePostalCode": null
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": null
+"OfficeStatus": null
+"OfficeAOR": null
+"OfficeType": null
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": null
+"OriginalEntryTimestamp": null
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('287182')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2240654/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2240654&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2240654/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2240654&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25233
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25241
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2240654"
+"ModificationTimestamp": "2026-01-09T22:00:04Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2240654"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Member('2240654')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29235673" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24888
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235673/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235673&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235673/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235673&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24868
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235673 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.598923 43.456829)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235673 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.598923 43.456829)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235673 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.598923 43.456829)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235673 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.598923 43.456829)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24817
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24823
+post_id: "525437"
+post_author: 1
+"ListingKey": "29237600"
+"ListingId": "40797604"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T20:31:03Z"
+"RFModificationTimestamp": "2026-01-10T20:34:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1050.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0J1"
+"UnparsedAddress": "D58-142 N FOAMFLOWER Common, Waterloo, Ontario N2V0J1"
+"Coordinates": array:2 [
0 => -80.5903072
1 => 43.4496086
]
+"Latitude": 43.4496086
+"Longitude": -80.5903072
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Spacious 1,050 sq. ft. ground-floor apartment in a prime Waterloo location. This well-maintained unit features a functional layout with 2 large bedrooms and 2 full bathrooms. The modern kitchen offers ample storage and opens into a bright, oversized living area with access to a private balcony boasting scenic views. Additional Storage room with ZEBRA blinds in all areas. Rare find with 2 dedicated parking spots and high-speed internet included in the rent! Unit have installed water filter! Conveniently situated behind Costco, just 3km from Wilfrid Laurier University, 5km from the University of Waterloo and next to Vista Hills Public School with top-rated elementary school ranking. Close to major shopping, dining, and transit hubs. Move-in ready and easy to show. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T19:46:00.618582+00:00"
+"Directions": "Columbia Street to Ladyslipper Place to Foamflower Place"
+"ExteriorFeatures": array:3 [
0 => "Stucco"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2203844"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2026-01-10T19:29:44Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T20:18:40Z"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "58"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1558719768"
"RoomType" => "Great room"
"ListingId" => "40797604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237600"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T20:18:40.4Z"
]
1 => array:11 [
"RoomKey" => "1558719769"
"RoomType" => "Kitchen"
"ListingId" => "40797604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237600"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T20:18:40.4Z"
]
2 => array:11 [
"RoomKey" => "1558719770"
"RoomType" => "3pc Bathroom"
"ListingId" => "40797604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237600"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T20:18:40.4Z"
]
3 => array:11 [
"RoomKey" => "1558719771"
"RoomType" => "3pc Bathroom"
"ListingId" => "40797604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237600"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T20:18:40.4Z"
]
4 => array:11 [
"RoomKey" => "1558719772"
"RoomType" => "Bedroom"
"ListingId" => "40797604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237600"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T20:18:40.4Z"
]
5 => array:11 [
"RoomKey" => "1558719773"
"RoomType" => "Bedroom"
"ListingId" => "40797604"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29237600"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T20:18:40.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29237600/d58-142-foamflower-place-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2450
+"ZoningDescription": "R6 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 1050
+"OriginalEntryTimestamp": "2026-01-10T19:29:44.36Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:23 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6399289562"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/1f13ec96dbd6da8d16e9999feb2e0c9e.webp"
"MediaSize" => 57463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-1f13ec96dbd6da8d16e9999feb2e0c9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6399289564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/2a254dbef43894f8af86948d4ed547f5.webp"
"MediaSize" => 43156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-2a254dbef43894f8af86948d4ed547f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6399289567"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/a4109814b9f85d515601cf8c51db1b50.webp"
"MediaSize" => 43865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-a4109814b9f85d515601cf8c51db1b50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6399289568"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/7c73605f0f4a56231ca8ba2fa92e0bc0.webp"
"MediaSize" => 58317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-7c73605f0f4a56231ca8ba2fa92e0bc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6399289570"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/62e965ddee4791853c47c24f6df6c833.webp"
"MediaSize" => 44023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-62e965ddee4791853c47c24f6df6c833.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6399289571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/b4bf86e26c019ae30bd4d4242eb52e39.webp"
"MediaSize" => 59238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-b4bf86e26c019ae30bd4d4242eb52e39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6399289573"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/9a7860651fca410bbf5cbf00b6c84f8c.webp"
"MediaSize" => 28720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-9a7860651fca410bbf5cbf00b6c84f8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6399289580"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/86b581b15bf6b1efc96d04da00d444a7.webp"
"MediaSize" => 37078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-86b581b15bf6b1efc96d04da00d444a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6399289584"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/91e17585a78606dda74577c3bcb30cce.webp"
"MediaSize" => 38836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-91e17585a78606dda74577c3bcb30cce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6399289587"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/51aaed24aeafc6d580d44eec48c3ec51.webp"
"MediaSize" => 20661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-51aaed24aeafc6d580d44eec48c3ec51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6399289593"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/171e631b5db4e750c19db3d15abb4327.webp"
"MediaSize" => 40567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-171e631b5db4e750c19db3d15abb4327.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6399289604"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/654ccf7199ae767787ce4649294a4a47.webp"
"MediaSize" => 43521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-654ccf7199ae767787ce4649294a4a47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6399289612"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/30e3504468acbc7ad3873a55df8b933a.webp"
"MediaSize" => 58318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-30e3504468acbc7ad3873a55df8b933a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6399289623"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/531648c9984c43950af3b7090c1f9c40.webp"
"MediaSize" => 58348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-531648c9984c43950af3b7090c1f9c40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6399289628"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/4821915ce0979c6cebf1b95cf432ad95.webp"
"MediaSize" => 45104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-4821915ce0979c6cebf1b95cf432ad95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6399289633"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/28930c5ae58bdac1b35a4b5743fad7b3.webp"
"MediaSize" => 39864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-28930c5ae58bdac1b35a4b5743fad7b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6399289638"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/7781dbc1eb23548d30663b4181e0178b.webp"
"MediaSize" => 53771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-7781dbc1eb23548d30663b4181e0178b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6399289642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/e94d34ab1f80f7053b0158777c0ed4ca.webp"
"MediaSize" => 44181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-e94d34ab1f80f7053b0158777c0ed4ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6399289648"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/8e487081b470b45aa261a963745dcddc.webp"
"MediaSize" => 53388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-8e487081b470b45aa261a963745dcddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6399289656"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/da1a40f1bab8b847feed4fb9c8dd05fe.webp"
"MediaSize" => 30158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-da1a40f1bab8b847feed4fb9c8dd05fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6399289664"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/69b2a7b7ef79ca8bea6e615f2c8d3daf.webp"
"MediaSize" => 25523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-69b2a7b7ef79ca8bea6e615f2c8d3daf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6399289671"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/7549ee20c7e666cbe7f3d8de569e8258.webp"
"MediaSize" => 77178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-7549ee20c7e666cbe7f3d8de569e8258.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6399289681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29237600/47588729b880c9a2a0aad9498b2963ad.webp"
"MediaSize" => 52616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29237600/thumbnail-47588729b880c9a2a0aad9498b2963ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797604"
"ResourceRecordKey" => "29237600"
"ModificationTimestamp" => "2026-01-10T19:29:44.41Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Narinder Singh"
"MemberFirstName" => "Narinder"
"MemberLastName" => "Singh"
"MemberMlsId" => "WR59240"
"OriginatingSystemName" => 26
"MemberKey" => "2203844"
"ModificationTimestamp" => "2025-10-28T23:35:39Z"
"MemberStatus" => "Active"
"OfficeKey" => "290392"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Kitchener"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-497-8651"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2023-11-06T19:38:00Z"
"MemberNationalAssociationId" => "1452441"
"OfficeNationalAssociationId" => "1386847"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "EXP REALTY"
"OfficePhone" => "866-530-7737"
"OfficeMlsId" => "KW362"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "290392"
"ModificationTimestamp" => "2025-08-19T15:49:32Z"
"OfficeAddress1" => "7-871 Victoria Street North Unit: 355"
"OfficeCity" => "Kitchener"
"OfficePostalCode" => "N2B3S"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeFax" => "647-849-3180"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-05-12T18:25:00Z"
"OfficeNationalAssociationId" => "1386847"
"OfficeBrokerNationalAssociationId" => "1430609"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29237600')"
+"ID": "525437"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24821
+post_id: "524621"
+post_author: 1
+"ListingKey": "29236916"
+"ListingId": "40797573"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T06:00:55Z"
+"RFModificationTimestamp": "2026-01-10T06:03:06Z"
+"ListPrice": 1039000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2741.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "709 ROCK ELM Street, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.602481
1 => 43.459931
]
+"Latitude": 43.459931
+"Longitude": -80.602481
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prime location! The most popular community - Vista Hill - The best Spectacular Spec Home is for Sale! 2091 SQFT in one of the most popular floor plans, Hampton Model-Elevation A on the lookout lot! Loaded with upgrades: 9' ceiling on Main Floor, Hardwood floor in living room and Dinette, with stunningly beautiful Fireplace; upgraded kitchen with beautiful W/I pantry, Kitchen island, and Backsplash. Master bedroom with W/I closet & 5 piece Ensuite with double sink and Luxury Glass Shower door. Upper Floor Family room, finished basement with bath, bedroom, gym, and a good-sized home entertainment studio, garage door opener, and more!! See listing attachment for features and finished standards, and Upgrades. Minutes to all amenities/shopping/restaurants at the Boardwalk, Costco, parks, walking trails, school bus to top-rated schools, universities & more… move in and enjoy, A MUST SEE house!!! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T06:02:58.061976+00:00"
+"Directions": "Columbia/Ira Needles"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-10T05:21:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T05:49:00Z"
+"Stories": "2.0"
+"StreetName": "ROCK ELM"
+"StreetNumber": "709"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6759.35"
+"VirtualTourURLUnbranded": "https://www.facebook.com/reel/1383737613335768"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1558578022"
"RoomType" => "Laundry room"
"ListingId" => "40797573"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
1 => array:11 [
"RoomKey" => "1558578023"
"RoomType" => "4pc Bathroom"
"ListingId" => "40797573"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
2 => array:11 [
"RoomKey" => "1558578024"
"RoomType" => "Gym"
"ListingId" => "40797573"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
3 => array:11 [
"RoomKey" => "1558578025"
"RoomType" => "Recreation room"
"ListingId" => "40797573"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
4 => array:11 [
"RoomKey" => "1558578026"
"RoomType" => "Bedroom"
"ListingId" => "40797573"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
5 => array:11 [
"RoomKey" => "1558578027"
"RoomType" => "Family room"
"ListingId" => "40797573"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
6 => array:11 [
"RoomKey" => "1558578028"
"RoomType" => "4pc Bathroom"
"ListingId" => "40797573"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
7 => array:11 [
"RoomKey" => "1558578029"
"RoomType" => "5pc Bathroom"
"ListingId" => "40797573"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
8 => array:11 [
"RoomKey" => "1558578030"
"RoomType" => "Bedroom"
"ListingId" => "40797573"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
9 => array:11 [
"RoomKey" => "1558578031"
"RoomType" => "Bedroom"
"ListingId" => "40797573"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.81Z"
]
10 => array:11 [
"RoomKey" => "1558578032"
"RoomType" => "Primary Bedroom"
"ListingId" => "40797573"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.82Z"
]
11 => array:11 [
"RoomKey" => "1558578033"
"RoomType" => "2pc Bathroom"
"ListingId" => "40797573"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.82Z"
]
12 => array:11 [
"RoomKey" => "1558578034"
"RoomType" => "Kitchen"
"ListingId" => "40797573"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.82Z"
]
13 => array:11 [
"RoomKey" => "1558578035"
"RoomType" => "Dining room"
"ListingId" => "40797573"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.82Z"
]
14 => array:11 [
"RoomKey" => "1558578036"
"RoomType" => "Living room"
"ListingId" => "40797573"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29236916"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-10T05:49:00.82Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29236916/709-rock-elm-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 2091
+"BelowGradeFinishedArea": 650
+"OriginalEntryTimestamp": "2026-01-10T05:18:38.61Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398899210"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/e272565626e7526e5f71cf7b12091b65.webp"
"MediaSize" => 53713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-e272565626e7526e5f71cf7b12091b65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer entrance with recessed lighting and dark tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:19.91Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398899326"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/6ac50ea3f9ded562d575ab2e9b9d573d.webp"
"MediaSize" => 87000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-6ac50ea3f9ded562d575ab2e9b9d573d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring freestanding refrigerator, tasteful backsplash, a kitchen breakfast bar, dark cabinetry, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:18.88Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398899471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/1dfbe085c5e8763d4235a812a581e980.webp"
"MediaSize" => 90500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-1dfbe085c5e8763d4235a812a581e980.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with a kitchen breakfast bar, stainless steel appliances, an island with sink, pendant lighting, and light wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:18.84Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398899634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/4a323c1625a831ed20c7bd97b7042ee8.webp"
"MediaSize" => 71746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-4a323c1625a831ed20c7bd97b7042ee8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with dark wood-style floors and a chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:19.76Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6398899704"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/3a41d036ec4610d12b51350bf0a2e199.webp"
"MediaSize" => 57691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-3a41d036ec4610d12b51350bf0a2e199.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.27Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6398899830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/b69db301db6c4904e919ecc2a53a037d.webp"
"MediaSize" => 55965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-b69db301db6c4904e919ecc2a53a037d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring vanity, tub / shower combination, and tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.32Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6398899932"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/b647ec52d754de0898b466163d9c0375.webp"
"MediaSize" => 75418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-b647ec52d754de0898b466163d9c0375.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Home theater room featuring wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.39Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6398900021"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/c5345eacd98afe66f2fece57ad6f0af0.webp"
"MediaSize" => 69722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-c5345eacd98afe66f2fece57ad6f0af0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Workout area with dark wood-type flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:21.89Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6398900129"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/873f666389c90e121a1b4186cd8262ac.webp"
"MediaSize" => 76204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-873f666389c90e121a1b4186cd8262ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring backsplash, stainless steel appliances, a kitchen bar, dark cabinets, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:18.84Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6398900150"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/c7260389392c2cd19b8523502dff3e2b.webp"
"MediaSize" => 82103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-c7260389392c2cd19b8523502dff3e2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring stainless steel fridge with ice dispenser, hanging light fixtures, a glass covered fireplace, open floor plan, and a kitchen bar"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:18.84Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6398900260"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/26658e1c8431662171b507b1ff721b50.webp"
"MediaSize" => 74242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-26658e1c8431662171b507b1ff721b50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with baseboards and dark wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:18.83Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6398900369"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/3e4504b876b668c2693fc2b6dce2f68c.webp"
"MediaSize" => 65891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-3e4504b876b668c2693fc2b6dce2f68c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room with a glass covered fireplace, stairway, dark wood-style flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.32Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6398900549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/2db71e5c69238186baf7715976e931f5.webp"
"MediaSize" => 67370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-2db71e5c69238186baf7715976e931f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood finished floors and an office area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.58Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6398900570"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/fc8eb51617827f01cc5dc69b86ac5439.webp"
"MediaSize" => 88229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-fc8eb51617827f01cc5dc69b86ac5439.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.37Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6398900651"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/5a1e29ba3cf38ba6ee387d5bf1bbf5b8.webp"
"MediaSize" => 156378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-5a1e29ba3cf38ba6ee387d5bf1bbf5b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wooden deck featuring a residential view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:21.82Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6398900737"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/b868940d85b2269f4d9ec844e77bae19.webp"
"MediaSize" => 97375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-b868940d85b2269f4d9ec844e77bae19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring a textured ceiling and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:19.63Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6398900748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/dda72d129516c0e50b4d47adb132c195.webp"
"MediaSize" => 79927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-dda72d129516c0e50b4d47adb132c195.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with a textured ceiling and light wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:19.86Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6398900828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/6bfca87c616df53fa13f87392857c0c9.webp"
"MediaSize" => 68226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-6bfca87c616df53fa13f87392857c0c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sitting room featuring wood finished floors and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:19.87Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6398900902"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/f05ef09ea39894761f31f1ef53f3a8ea.webp"
"MediaSize" => 50298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-f05ef09ea39894761f31f1ef53f3a8ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.37Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6398900969"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/e58c28264d8615466d18e8db92416563.webp"
"MediaSize" => 71804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-e58c28264d8615466d18e8db92416563.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring a glass covered fireplace, dark wood finished floors, healthy amount of natural light, a textured ceiling, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:19.85Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6398901008"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/50850c8ada09f82c63a4d6cfcb6daff2.webp"
"MediaSize" => 79634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-50850c8ada09f82c63a4d6cfcb6daff2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room with recessed lighting and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:19.85Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6398901075"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/2e095ce36c5586175f174a8dbab3f698.webp"
"MediaSize" => 74182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-2e095ce36c5586175f174a8dbab3f698.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a glass covered fireplace, dark wood-style flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:19.63Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6398901105"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/a1e1f6f9b6f40c948238a5176bd2b95c.webp"
"MediaSize" => 50469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-a1e1f6f9b6f40c948238a5176bd2b95c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase featuring wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.27Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6398901172"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/c508b97120df44438bc8b21abc886403.webp"
"MediaSize" => 50298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-c508b97120df44438bc8b21abc886403.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Exercise room with wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.42Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6398901248"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/bb243fad1e7040b9493a3ad7021b0aa7.webp"
"MediaSize" => 158216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-bb243fad1e7040b9493a3ad7021b0aa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear view of house with a fenced backyard, a deck, and stairway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:21.88Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6398901316"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/87ce59dc97cb2a03bf9e0cb4aed3d532.webp"
"MediaSize" => 83214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-87ce59dc97cb2a03bf9e0cb4aed3d532.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring stairway, dark wood-style floors, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:18.88Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6398901363"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/3012e92a4bb71a7430945520aa1920fe.webp"
"MediaSize" => 79012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-3012e92a4bb71a7430945520aa1920fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.33Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6398901396"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/6e4c3bbbc66876f26bda653e8f2e525b.webp"
"MediaSize" => 65188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-6e4c3bbbc66876f26bda653e8f2e525b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sitting room with wood finished floors and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.27Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6398901417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/cbee22c8ef4e5b06fd49ea99acb1a3c8.webp"
"MediaSize" => 131476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-cbee22c8ef4e5b06fd49ea99acb1a3c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front facade with driveway, an attached garage, and brick siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:18.83Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6398901433"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/3db9b91259de60d7271a5dcd295a4d33.webp"
"MediaSize" => 50913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-3db9b91259de60d7271a5dcd295a4d33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring dark tile patterned flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:18.89Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6398901463"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/624660c933228d5be208055e99bb9a32.webp"
"MediaSize" => 77080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-624660c933228d5be208055e99bb9a32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sitting room with a textured ceiling and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:19.87Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6398901473"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/fdf8b227fb3134acfb5339d55018c5fb.webp"
"MediaSize" => 45042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-fdf8b227fb3134acfb5339d55018c5fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.27Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6398901496"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/f6fe43e94c4918dd0d6db218f79f2f40.webp"
"MediaSize" => 67181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-f6fe43e94c4918dd0d6db218f79f2f40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath with double vanity, a bathtub, and dark tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.37Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6398901521"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236916/dafffd075d7a9b2cbd8fafd78c6fc4e4.webp"
"MediaSize" => 50706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236916/thumbnail-dafffd075d7a9b2cbd8fafd78c6fc4e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity and shower / tub combo with curtain"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797573"
"ResourceRecordKey" => "29236916"
"ModificationTimestamp" => "2026-01-10T05:21:20.26Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6398901532"
…11
]
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29236916')"
+"ID": "524621"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24824
+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 [ …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/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 [ …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('29235913')"
+"ID": "524212"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24820
+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 [ …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/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 [ …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('29234903')"
+"ID": "524213"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24822
+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 [ …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]
]
+"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 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235086')"
+"ID": "524214"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24827
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23481
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24819
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24818
+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"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 92
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]