array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29118735/Property?$select=ALL&$top=20&$filter=ListingKey eq 29118735&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29118735/Property?$select=ALL&$top=20&$filter=ListingKey eq 29118735&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23274
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23276
+post_id: "430777"
+post_author: 1
+"ListingKey": "29118735"
+"ListingId": "40789294"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T16:30:28Z"
+"RFModificationTimestamp": "2025-11-26T16:34:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1498.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y7"
+"UnparsedAddress": "567 CHABLIS Drive, Waterloo, Ontario N2T2Y7"
+"Coordinates": array:2 [
0 => -80.573577
1 => 43.449765
]
+"Latitude": 43.449765
+"Longitude": -80.573577
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautiful and immaculately clean open-concept 2 story end unit townhome is truly a family's delight. Close to many elementary schools, universities, shopping, highways and other amenities. Contact us today to see this rental unit! 3 Bedrooms 2.5 Bathrooms with Soaker Tubs Finished Basement 5 Appliances Including Main Floor Laundry Central Air Conditioning Water Softener Garage with Opener Multi-Car Parking Deck Fenced Yard Mix of Hardwood, Tile & Carpet ** Available NOW!! ** *Non-Smoking Unit* *Tenant Insurance is Mandatory and Must be Provided on Move in Day* *Any Unit Listed by KWP That States All Inclusive Will Have a Cap Included* *See sales brochure below for showing instructions* (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T19:57:34.508163+00:00"
+"Directions": "Erbsville Rd From Erb Street West take first right on the round-about to Erbsville Road and take left on Chablis Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "No Pet Home"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T19:00:35Z"
+"PhotosCount": 13
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T16:18:56Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "567"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1540439006"
"RoomType" => "3pc Bathroom"
"ListingId" => "40789294"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.71Z"
]
1 => array:11 [
"RoomKey" => "1540439007"
"RoomType" => "4pc Bathroom"
"ListingId" => "40789294"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.71Z"
]
2 => array:11 [
"RoomKey" => "1540439008"
"RoomType" => "Loft"
"ListingId" => "40789294"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.71Z"
]
3 => array:11 [
"RoomKey" => "1540439009"
"RoomType" => "Bedroom"
"ListingId" => "40789294"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.71Z"
]
4 => array:11 [
"RoomKey" => "1540439010"
"RoomType" => "Bedroom"
"ListingId" => "40789294"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.71Z"
]
5 => array:11 [
"RoomKey" => "1540439011"
"RoomType" => "Primary Bedroom"
"ListingId" => "40789294"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.71Z"
]
6 => array:11 [
"RoomKey" => "1540439012"
"RoomType" => "2pc Bathroom"
"ListingId" => "40789294"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.72Z"
]
7 => array:11 [
"RoomKey" => "1540439013"
"RoomType" => "Dining room"
"ListingId" => "40789294"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.72Z"
]
8 => array:11 [
"RoomKey" => "1540439014"
"RoomType" => "Kitchen"
"ListingId" => "40789294"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.72Z"
]
9 => array:11 [
"RoomKey" => "1540439015"
"RoomType" => "Living room"
"ListingId" => "40789294"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29118735"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 21'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T16:18:56.72Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29118735/567-chablis-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2600
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 26.0
+"AboveGradeFinishedArea": 1498
+"OriginalEntryTimestamp": "2025-11-19T19:00:35.29Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:13 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6328467919"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/7b0f9e2ca08933ccae3c33f6d723212d.webp"
"MediaSize" => 47919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-7b0f9e2ca08933ccae3c33f6d723212d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with white appliances, dark countertops, under cabinet range hood, ceiling fan, and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6328467920"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/b2a8bb1ec2910a784b889c403b0c82e0.webp"
"MediaSize" => 64396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-b2a8bb1ec2910a784b889c403b0c82e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of home's exterior with a deck and roof with shingles"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6328467942"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/a1b2601654716aee7a91ddef0b31427d.webp"
"MediaSize" => 24886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-a1b2601654716aee7a91ddef0b31427d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished room with a textured ceiling and light carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6328467963"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/870078ddade23171c45e4950fe51f80e.webp"
"MediaSize" => 21064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-870078ddade23171c45e4950fe51f80e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring dark wood-style flooring and vanity"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6328468036"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/a4cf4457a0f825cd51a0cffaa756b5bd.webp"
"MediaSize" => 78295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-a4cf4457a0f825cd51a0cffaa756b5bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of home's exterior featuring a wooden deck and a pergola"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6328468039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/9586aa119ef47bbbb7cc1b628e31ca44.webp"
"MediaSize" => 25130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-9586aa119ef47bbbb7cc1b628e31ca44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished room with ornamental molding, light wood-style floors, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6328468040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/23b08982d16eba847cd42426b7b3839f.webp"
"MediaSize" => 22058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-23b08982d16eba847cd42426b7b3839f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front facade with driveway, a garage, brick siding, and a front lawn"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6328468082"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/d468ab455bd0f4ca8457368e36953dfa.webp"
"MediaSize" => 23912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-d468ab455bd0f4ca8457368e36953dfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement with dark wood-type flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6328468122"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/f146a61b3bf0da2309eac3b371d933b6.webp"
"MediaSize" => 33389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-f146a61b3bf0da2309eac3b371d933b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom featuring a textured ceiling, carpet, and a closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6328468142"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/a97a45c4a403e23b66e1db55e4a871ea.webp"
"MediaSize" => 22359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-a97a45c4a403e23b66e1db55e4a871ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished basement with dark wood-type flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6328468169"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/70f123806bb9746603f4073c52911451.webp"
"MediaSize" => 102083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-70f123806bb9746603f4073c52911451.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6328468213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/8303fd54a723abd52d7d260a05d5bcb5.webp"
"MediaSize" => 24622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-8303fd54a723abd52d7d260a05d5bcb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement with dark wood-style flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6328468254"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29118735/7a035bed8bad049d47d49130e5abd7e1.webp"
"MediaSize" => 24702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29118735/thumbnail-7a035bed8bad049d47d49130e5abd7e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted spare room featuring a textured ceiling and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789294"
"ResourceRecordKey" => "29118735"
"ModificationTimestamp" => "2025-11-19T19:00:35.31Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29118735')"
+"ID": "430777"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 300202/Office?$select=ALL&$top=10&$filter=OfficeKey eq 300202&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 300202/Office?$select=ALL&$top=10&$filter=OfficeKey eq 300202&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25075
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25077
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Vancor Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "519-242-0277"
+"OfficeMlsId": "WR50949"
+"ModificationTimestamp": "2025-11-21T15:46:40Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "300202"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1425 Bishop St. N. Unit 1"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Cambridge"
+"OfficePostalCode": "N1R6J"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1484182"
+"OriginalEntryTimestamp": "2025-06-16T18:10:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "434736"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "300202"
"SocialMediaUrlOrId" => "http://www.vancorgroup.com/"
"ModificationTimestamp" => "2025-11-21T13:58:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1196776"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('300202')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1834563/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1834563&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1834563/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1834563&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25080
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29118735" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24696
+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 29118735/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29118735&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29118735/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29118735&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24676
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29118735 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.573577 43.449765)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29118735 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.573577 43.449765)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29118735 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.573577 43.449765)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29118735 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.573577 43.449765)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24558
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24590
+post_id: "441138"
+post_author: 1
+"ListingKey": "29132632"
+"ListingId": "40789696"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T20:15:46Z"
+"RFModificationTimestamp": "2025-11-26T20:16:37Z"
+"ListPrice": 1100000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2301.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5V7"
+"UnparsedAddress": "424 CLAIRBROOK Crescent, Waterloo, Ontario N2L5V7"
+"Coordinates": array:2 [
0 => -80.5637594
1 => 43.465947
]
+"Latitude": 43.465947
+"Longitude": -80.5637594
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 424 Clairbrook, nestled in the highly sought-after, family-friendly Beechwood neighbourhood. This spacious home features four generous bedrooms on the upper level, plus an additional bedroom in the fully finished basement—perfect for growing families, hosting guests, or creating a dedicated home office. Inside, you'll find a warm and inviting layout with large principal rooms and an open-concept kitchen and dining area designed for everyday living and easy entertaining. Step outside to a large, private, fully fenced backyard, ideal for gatherings, gardening, or simply unwinding in your own outdoor retreat. This is a rare opportunity to own a home in one of Waterloo’s most desirable communities. Don’t miss your chance to make 424 Clairbrook yours. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T21:21:29.987509+00:00"
+"Directions": "Fischer- Hallman - Beechlawn"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2193974"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T20:19:13Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T20:00:34Z"
+"Stories": "2.0"
+"StreetName": "CLAIRBROOK"
+"StreetNumber": "424"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "6384"
+"VirtualTourURLUnbranded": "https://youriguide.com/424_clairbrook_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1540550123"
"RoomType" => "Utility room"
"ListingId" => "40789696"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 5'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.9Z"
]
1 => array:11 [
"RoomKey" => "1540550124"
"RoomType" => "Utility room"
"ListingId" => "40789696"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "23'0'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.9Z"
]
2 => array:11 [
"RoomKey" => "1540550125"
"RoomType" => "Bedroom"
"ListingId" => "40789696"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.9Z"
]
3 => array:11 [
"RoomKey" => "1540550126"
"RoomType" => "Recreation room"
"ListingId" => "40789696"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "20'9'' x 22'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.9Z"
]
4 => array:11 [
"RoomKey" => "1540550127"
"RoomType" => "Cold room"
"ListingId" => "40789696"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.9Z"
]
5 => array:11 [
"RoomKey" => "1540550128"
"RoomType" => "3pc Bathroom"
"ListingId" => "40789696"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.9Z"
]
6 => array:11 [
"RoomKey" => "1540550129"
"RoomType" => "Primary Bedroom"
"ListingId" => "40789696"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.9Z"
]
7 => array:11 [
"RoomKey" => "1540550130"
"RoomType" => "Bedroom"
"ListingId" => "40789696"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.9Z"
]
8 => array:11 [
"RoomKey" => "1540550131"
"RoomType" => "Bedroom"
"ListingId" => "40789696"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.9Z"
]
9 => array:11 [
"RoomKey" => "1540550132"
"RoomType" => "Bedroom"
"ListingId" => "40789696"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.91Z"
]
10 => array:11 [
"RoomKey" => "1540550133"
"RoomType" => "4pc Bathroom"
"ListingId" => "40789696"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.91Z"
]
11 => array:11 [
"RoomKey" => "1540550134"
"RoomType" => "3pc Bathroom"
"ListingId" => "40789696"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.91Z"
]
12 => array:11 [
"RoomKey" => "1540550135"
"RoomType" => "Office"
"ListingId" => "40789696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.91Z"
]
13 => array:11 [
"RoomKey" => "1540550136"
"RoomType" => "Living room"
"ListingId" => "40789696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 19'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.91Z"
]
14 => array:11 [
"RoomKey" => "1540550137"
"RoomType" => "Kitchen"
"ListingId" => "40789696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "20'7'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.91Z"
]
15 => array:11 [
"RoomKey" => "1540550138"
"RoomType" => "Dining room"
"ListingId" => "40789696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "18'1'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.91Z"
]
16 => array:11 [
"RoomKey" => "1540550139"
"RoomType" => "2pc Bathroom"
"ListingId" => "40789696"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29132632"
"RoomLength" => null
"RoomDimensions" => "3'11'' x 4'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T20:00:34.92Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29132632/424-clairbrook-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2301
+"OriginalEntryTimestamp": "2025-11-24T20:19:13.13Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:37 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6337966143"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/8106e756ab584f1c98f2d8ff7082746a.webp"
"MediaSize" => 151788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-8106e756ab584f1c98f2d8ff7082746a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6337966151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/8e647bbfa8234b3be6402180c8664075.webp"
"MediaSize" => 144164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-8e647bbfa8234b3be6402180c8664075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6337966284"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/1de582de390e68a4d65697269a207f64.webp"
"MediaSize" => 65063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-1de582de390e68a4d65697269a207f64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6337966405"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/71a2dd1a9572483427b4da8d46cca605.webp"
"MediaSize" => 94233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-71a2dd1a9572483427b4da8d46cca605.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6337966505"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/25e21d3be0c51ea8573a3d4d5a8883f3.webp"
"MediaSize" => 88188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-25e21d3be0c51ea8573a3d4d5a8883f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6337966554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/56b78322321a74b24c8dfd873b0f99d5.webp"
"MediaSize" => 86309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-56b78322321a74b24c8dfd873b0f99d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6337966665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/fd5bf9b57b2a1fcd92187bffbc1ce299.webp"
"MediaSize" => 196015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-fd5bf9b57b2a1fcd92187bffbc1ce299.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6337966755"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/e726f85623407761d9e6a92a67f2519f.webp"
"MediaSize" => 39304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-e726f85623407761d9e6a92a67f2519f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6337966848"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/bcf639e58ecba7588484361f8f4bb403.webp"
"MediaSize" => 86139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-bcf639e58ecba7588484361f8f4bb403.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6337966908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/b70bc1f2d279ee7771f6306c2428ebd1.webp"
"MediaSize" => 109700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-b70bc1f2d279ee7771f6306c2428ebd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6337967019"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/86e7b7179598c5fab02ed9f152d112cb.webp"
"MediaSize" => 91412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-86e7b7179598c5fab02ed9f152d112cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6337967039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/96d0a1a3a09ad0b12ac2dd4c03a673e7.webp"
"MediaSize" => 79437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-96d0a1a3a09ad0b12ac2dd4c03a673e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6337967073"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/c34dd54b3c63cf11829c5c71d1f2f0a5.webp"
"MediaSize" => 57296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-c34dd54b3c63cf11829c5c71d1f2f0a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6337967116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/faea30871b1a106c7a17c75282e39415.webp"
"MediaSize" => 46975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-faea30871b1a106c7a17c75282e39415.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6337967141"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/aed3d7e9aa3af105b567bcf017bc0df0.webp"
"MediaSize" => 44605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-aed3d7e9aa3af105b567bcf017bc0df0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6337967198"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/a52c6f7989700ef93db3abeb37acb114.webp"
"MediaSize" => 53767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-a52c6f7989700ef93db3abeb37acb114.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6337967246"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/cc158077635bebaf6d22c1a5f3ca2443.webp"
"MediaSize" => 88465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-cc158077635bebaf6d22c1a5f3ca2443.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6337967281"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/2fea83951c2c4cea9dfae25d101d37aa.webp"
"MediaSize" => 60684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-2fea83951c2c4cea9dfae25d101d37aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6337967308"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/bf3ee2671a339806ffb21f39b3c71791.webp"
"MediaSize" => 84234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-bf3ee2671a339806ffb21f39b3c71791.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6337967340"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/616dbbef03fb317f54ab410dea5f186f.webp"
"MediaSize" => 88346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-616dbbef03fb317f54ab410dea5f186f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6337967370"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/e648ae6a182424899f0c7494acec9bc3.webp"
"MediaSize" => 82710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-e648ae6a182424899f0c7494acec9bc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6337967418"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/a0cfa9a98ef293146e0e7a5970139d4f.webp"
"MediaSize" => 63722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-a0cfa9a98ef293146e0e7a5970139d4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6337967461"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/10d3fa93a1f7e24572d59a36ec209f71.webp"
"MediaSize" => 192612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-10d3fa93a1f7e24572d59a36ec209f71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6337967489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/0161ee4eea3ed841080405b57427e3e2.webp"
"MediaSize" => 156018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-0161ee4eea3ed841080405b57427e3e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6337967519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/e2f522dab163da4641262e357961a10b.webp"
"MediaSize" => 79132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-e2f522dab163da4641262e357961a10b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6337967571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/f2b4501b1276f4187fa8e6cd3826fe00.webp"
"MediaSize" => 72445
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-f2b4501b1276f4187fa8e6cd3826fe00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6337967609"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/c33d83f49027c6ab5b29b1fc872a0761.webp"
"MediaSize" => 192789
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-c33d83f49027c6ab5b29b1fc872a0761.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6337967624"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/dfb712245ca4eefc326bdacbe193193d.webp"
"MediaSize" => 86203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-dfb712245ca4eefc326bdacbe193193d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6337967646"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/caaf4ca184b806af97b960bf25a4262a.webp"
"MediaSize" => 96701
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-caaf4ca184b806af97b960bf25a4262a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6337967655"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/4a392896b471d4e3dfee442ad832928e.webp"
"MediaSize" => 113752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-4a392896b471d4e3dfee442ad832928e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6337967673"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/01cd8783665e9a148b6e38e2180c7d27.webp"
"MediaSize" => 71716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-01cd8783665e9a148b6e38e2180c7d27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6337967707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/edbdd5892a642e63ec44a221993c78b1.webp"
"MediaSize" => 94168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-edbdd5892a642e63ec44a221993c78b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6337967720"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/51758743532bf14ed766c1d2f5bd6082.webp"
"MediaSize" => 72220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-51758743532bf14ed766c1d2f5bd6082.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6337967727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/827d9d07a22d700371557a8de9869851.webp"
"MediaSize" => 38166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-827d9d07a22d700371557a8de9869851.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6337967746"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/a5193a0af82b0c9f7c2110ca81751f12.webp"
"MediaSize" => 55361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-a5193a0af82b0c9f7c2110ca81751f12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6337967757"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/5f5ef7232c4457b228ea93bc04430491.webp"
"MediaSize" => 63687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-5f5ef7232c4457b228ea93bc04430491.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6337967777"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29132632/8a2b3d75a77641fcb886240ceb6899a3.webp"
"MediaSize" => 65489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29132632/thumbnail-8a2b3d75a77641fcb886240ceb6899a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789696"
"ResourceRecordKey" => "29132632"
"ModificationTimestamp" => "2025-11-24T20:19:13.14Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29132632')"
+"ID": "441138"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24602
+post_id: "439187"
+post_author: 1
+"ListingKey": "29129641"
+"ListingId": "40789908"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T22:15:22Z"
+"RFModificationTimestamp": "2025-11-23T00:55:39Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1022.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 10, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.5881467
1 => 43.4502053
]
+"Latitude": 43.4502053
+"Longitude": -80.5881467
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to #10-142 Foamflower! Discover this charming, brand-new stacked townhome rental that stands out with its thoughtful updates and modern features. Enjoy the highly sought-after open concept living space, highlighted by a stunning kitchen equipped with quartz countertops, under-cabinet lighting, and recessed lighting. The spacious kitchen island features brand-new stainless steel appliances and large pot drawers-a space any chef would be proud of. This home offers two generously sized bedrooms, including a Primary suite with a walk-in closet and ensuite bathroom. The ensuite boasts a walk-in tiled shower with a rainfall showerhead, adding a touch of luxury. Relax on the sun-filled rear balcony—perfect for enjoying your morning coffee or unwinding in the evening. Location Highlights: Costco The Boardwalk Medical Center Landmark Cinema Close to numerous schools including grade schools high schools, Conestoga College, Laurier University and also a ten minute from the University of Waterloo, making it an ideal location for students and faculty. Don't miss your chance to make this beautiful townhome your new home! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"AssociationFeeIncludes": array:1 [
0 => "Property Management"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-23T00:55:38.042202+00:00"
+"Directions": "Platinum Dr and Columbia St W"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192898"
+"ListOfficeKey": "76844"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Industrial mall/subdivision"
]
+"PhotosChangeTimestamp": "2025-11-22T22:08:47Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T22:08:47Z"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1538296118"
"RoomType" => "3pc Bathroom"
"ListingId" => "40789908"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29129641"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T22:08:47.47Z"
]
1 => array:11 [
"RoomKey" => "1538296119"
"RoomType" => "Primary Bedroom"
"ListingId" => "40789908"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29129641"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T22:08:47.47Z"
]
2 => array:11 [
"RoomKey" => "1538296120"
"RoomType" => "Bedroom"
"ListingId" => "40789908"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29129641"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T22:08:47.47Z"
]
3 => array:11 [
"RoomKey" => "1538296121"
"RoomType" => "4pc Bathroom"
"ListingId" => "40789908"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29129641"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-22T22:08:47.48Z"
]
4 => array:11 [
"RoomKey" => "1538296122"
"RoomType" => "Kitchen"
"ListingId" => "40789908"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29129641"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 12'7''"
"RoomDescription" => null
…2
]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29129641/142-foamflower-place-unit-10-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Leasehold"
+"TotalActualRent": 2500
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 5.0
+"AboveGradeFinishedArea": 1022
+"OriginalEntryTimestamp": "2025-11-22T22:08:47.45Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:7 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29129641')"
+"ID": "439187"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24523
+post_id: "435046"
+post_author: 1
+"ListingKey": "29124115"
+"ListingId": "40788966"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T21:40:11Z"
+"RFModificationTimestamp": "2025-11-22T21:40:41Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.075
+"LivingArea": 2335.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "664 BRANDENBURG Boulevard, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.5800713
1 => 43.4582785
]
+"Latitude": 43.4582785
+"Longitude": -80.5800713
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A home your family has been waiting for in highly sought-after Clair Hills! Pride of ownership shines throughout this beautifully maintained, fully finished home. Step through the attractive double French doors into a spacious foyer with an oversized closet, leading to the carpet-free main floor enhanced with crown moulding. The chef-inspired kitchen features granite countertops, under-cabinet lighting, a built-in pantry, a stunning stone backsplash, and an over-the-range hood microwave. The bright dining area offers walkout sliders to a 12’ x 12’ deck overlooking a fantastic backyard with a serene pond feature. A welcoming living room with bamboo flooring and a convenient 3-piece bathroom complete the main level. Upstairs, the primary bedroom retreat includes a walk-in closet with excellent storage. Two additional generously sized bedrooms and a spacious 4-piece bathroom complete the second floor. The finished basement provides extra living and entertaining space, featuring a cozy rec room with a gas fireplace. Enjoy the tranquil backyard setting with no rear neighbours—a rare find. Close to great schools, parks, and all amenities. Updates include: Furnace (2023), Air Conditioner (2023), Hot Water Tank (2025), Freshly Painted Throughout (2025), New Carpet (2025). (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Hood Fan"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T01:22:14.513331+00:00"
+"Directions": "Erbsville Road to Brandenburg Boulevard"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1879079"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Gazebo"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.075"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-21T16:21:56Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T21:29:51Z"
+"Stories": "2.0"
+"StreetName": "BRANDENBURG"
+"StreetNumber": "664"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4535"
+"View": "View of water"
+"VirtualTourURLUnbranded": "https://iguidephotos.com/bc3mv_664_brandenburg_blvd_waterloo_on/"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Sand point"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29124115/664-brandenburg-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1637
+"BelowGradeFinishedArea": 698
+"OriginalEntryTimestamp": "2025-11-20T22:38:37.33Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"Media": array:24 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29124115')"
+"ID": "435046"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24609
+post_id: "432634"
+post_author: 1
+"ListingKey": "29121239"
+"ListingId": "X12561550"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T19:46:04Z"
+"RFModificationTimestamp": "2025-11-26T00:11:05Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 4
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B7"
+"UnparsedAddress": "22 - 435 WINCHESTER DRIVE, Waterloo, Ontario N2T0B7"
+"Coordinates": array:2 [
0 => -80.561888
1 => 43.452439
]
+"Latitude": 43.452439
+"Longitude": -80.561888
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "DISCOVER LIFE IN THE VILLAGE. A rare executive townhome with over 3,100 sqft. of beautifully finished living space, offering privacy and convenience in a quiet enclave ideal for retirees, or busy professionals. The home makes a strong first impression with its attached double garage and meticulous curb appeal. Inside, you're greeted by an open concept main floor with a bright kitchen featuring granite countertops and ample cabinetry, a welcoming dining area and a living room with a cozy gas fireplace. Large windows fill the space with natural light and provide clear views of McCrae Park. A convenient 2 piece bathroom completes this level. Upstairs, a versatile family room provides additional living space or a dedicated office. The primary bedroom includes a walk-in closet and a luxurious 5 piece ensuite. The second bedroom also features its own walk-in closet and a 4 piece ensuite. The laundry room completes the upper level. The fully finished basement offers a large recreation room and a full 4 piece bathroom. Outside, enjoy a private patio area with a gas BBQ hookup. Living in Beechwood means enjoying one of Waterloo's most desirable and peaceful neighbourhoods, with nearby amenities, top rated schools and quick access to Uptown Waterloo. Homes in The Village rarely come to market, so this is an opportunity not to be missed. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener"
]
+"AssociationFee": "617.18"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 4
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-20T15:41:10.504292+00:00"
+"Directions": "Cross Streets: Fischer-Hallman Road. ** Directions: Fischer-Hallman Road to Winchester Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093834"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Backs on greenbelt"
1 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-20T14:49:25Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T19:34:31Z"
+"Stories": "2.0"
+"StreetName": "Winchester"
+"StreetNumber": "435"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8111.22"
+"VirtualTourURLUnbranded": "https://youriguide.com/435_winchester_dr_waterloo_on/"
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29121239/22-435-winchester-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-20T14:49:24.91Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29121239')"
+"ID": "432634"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24546
+post_id: "430786"
+post_author: 1
+"ListingKey": "29118745"
+"ListingId": "X12559066"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T19:40:25Z"
+"RFModificationTimestamp": "2025-11-26T19:43:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "467 DRUMMERHILL CRESCENT, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.5512601
1 => 43.4455427
]
+"Latitude": 43.4455427
+"Longitude": -80.5512601
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to family-friendly Westvale! This thoughtfully updated 4-level backsplit sits on a quiet crescent, just steps from parks, playgrounds, walking trails, and top-rated schools. Offering 3 bedrooms, 2 full baths, and a practical layout, this detached home is built for comfortable modern living. The main level includes a bright kitchen, a formal dining area, and a living room. Upstairs are three bedrooms and a 4-piece main bath. The lower level features a warm, welcoming rec room - perfect for movie nights or relaxed gatherings. A few steps down, you'll find a 3-piece bath, a laundry area, and a finished bonus room ideal for an additional bedroom or home office. Situated only minutes from Costco, The Boardwalk, shops, restaurants, and entertainment, this move-in-ready home is a fantastic opportunity to experience the best of Westvale living! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-11-19T19:56:02.022546+00:00"
+"Directions": "Cross Streets: Westvale Dr/ Drummerhill Cres. ** Directions: THORNDALE DRIVE TO WESTVALE DRIVE TO DRUMMERHILLCRES."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2189224"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "31.1 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T19:00:42Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T19:29:03Z"
+"StreetName": "Drummerhill"
+"StreetNumber": "467"
+"StreetSuffix": "Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29118745/467-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2750
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.1
+"OriginalEntryTimestamp": "2025-11-19T19:00:42.92Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:17 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29118745')"
+"ID": "430786"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24535
+post_id: "430516"
+post_author: 1
+"ListingKey": "29118413"
+"ListingId": "40789043"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:55:38Z"
+"RFModificationTimestamp": "2025-11-26T19:10:05Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1775.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "467 DRUMMERHILL Crescent, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.5512583
1 => 43.445542
]
+"Latitude": 43.445542
+"Longitude": -80.5512583
+"YearBuilt": 1982
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to family-friendly Westvale! This thoughtfully updated 4-level backsplit sits on a quiet crescent, just steps from parks, playgrounds, walking trails, and top-rated schools. Offering 3 bedrooms, 2 full baths, and a practical layout, this detached home is built for comfortable modern living. The main level includes a bright kitchen, a formal dining area, and a living room. Upstairs are three bedrooms and a 4-piece main bath. The lower level features a warm, welcoming rec room - perfect for movie nights or relaxed gatherings. A few steps down, you'll find a 3-piece bath, a laundry area, and a finished bonus room ideal for an additional bedroom or home office. Situated only minutes from Costco, The Boardwalk, shops, restaurants, and entertainment, this move-in-ready home is a fantastic opportunity to experience the best of Westvale living! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T19:00:07.975738+00:00"
+"Directions": "THORNDALE DRIVE TO WESTVALE DRIVE TO DRUMMERHILL CRES"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2140701"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"PhotosChangeTimestamp": "2025-11-19T18:19:24Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:40:08Z"
+"StreetName": "DRUMMERHILL"
+"StreetNumber": "467"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "2540"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29118413/467-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2750
+"ZoningDescription": "SD-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1080
+"BelowGradeFinishedArea": 695
+"OriginalEntryTimestamp": "2025-11-19T18:19:24.41Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:17 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29118413')"
+"ID": "430516"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23288
+post_id: "426760"
+post_author: 1
+"ListingKey": "29113730"
+"ListingId": "X12554306"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T13:40:58Z"
+"RFModificationTimestamp": "2025-11-24T13:45:37Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X9"
+"UnparsedAddress": "707 PARIS BOULEVARD, Waterloo, Ontario N2T2X9"
+"Coordinates": array:2 [
0 => -80.574404
1 => 43.451072
]
+"Latitude": 43.451072
+"Longitude": -80.574404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A warm and inviting 3-bed, 2.5-bath family home located in one of Waterloo's most convenient and sought-after neighbourhoods. Bright, stylish, and beautifully maintained, this home offers a functional layout with modern finishes and an airy atmosphere throughout. Step inside to a spacious kitchen featuring white cabinetry, stainless steel appliances, and generous counter space-perfect for everyday cooking and entertaining. The kitchen opens seamlessly into the show-stopping living and dining area, where soaring cathedral ceilings and abundant natural light create an impressive, open-concept space. From here, sliding doors lead directly to the backyard deck, making indoor-outdoor living and summer barbecues effortless. Upstairs, you'll find three comfortable bedrooms, including a serene primary suite with soft neutral tones and ample closet space. The additional bedrooms are ideal for children, guests, or home offices, offering flexibility for today's lifestyle. The insulated and drywalled basement is ready for your finishing touches-ideal for a rec room, gym, or additional living space-and includes a central vac rough-in for added convenience. Outside, the fully fenced yard provides privacy, room to play, and space to relax, complete with a deck and storage shed. The low-maintenance yard offers year-round enjoyment with plenty of space for gardening, pets, or entertaining. Located just minutes from Edna Staebler Public School, parks, trails, and a wide selection of shopping and amenities, this home offers exceptional convenience in a family-friendly community. Whether you're a first-time buyer, growing family, or downsizer seeking comfort and function, 707 Paris Boulevard delivers a welcoming lifestyle in a prime Waterloo location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T17:56:49.946565+00:00"
+"Directions": "Cross Streets: Brandenburg Blvd. ** Directions: From Erbsville Rd to Brandenburg Blvd to Paris Blvd."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093590"
+"ListOfficeKey": "294121"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "28 x 106.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-18T16:58:07Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T13:24:15Z"
+"Stories": "2.0"
+"StreetName": "Paris"
+"StreetNumber": "707"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4069"
+"VirtualTourURLUnbranded": "https://youriguide.com/707_paris_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29113730/707-paris-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2025-11-18T16:58:06.95Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29113730')"
+"ID": "426760"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24957
+post_id: "426427"
+post_author: 1
+"ListingKey": "29113065"
+"ListingId": "40788324"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-23T22:45:13Z"
+"RFModificationTimestamp": "2025-11-23T22:46:31Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.068
+"LivingArea": 1921.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X9"
+"UnparsedAddress": "707 PARIS Boulevard, Waterloo, Ontario N2T2X9"
+"Coordinates": array:2 [
0 => -80.5744431
1 => 43.4510713
]
+"Latitude": 43.4510713
+"Longitude": -80.5744431
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A warm and inviting 3-bed, 2.5-bath family home located in one of Waterloo’s most convenient and sought-after neighbourhoods. Bright, stylish, and beautifully maintained, this home offers a functional layout with modern finishes and an airy atmosphere throughout. Step inside to a spacious kitchen featuring white cabinetry, stainless steel appliances, and generous counter space—perfect for everyday cooking and entertaining. The kitchen opens seamlessly into the show-stopping living and dining area, where soaring cathedral ceilings and abundant natural light create an impressive, open-concept space. From here, sliding doors lead directly to the backyard deck, making indoor-outdoor living and summer barbecues effortless. Upstairs, you’ll find three comfortable bedrooms, including a serene primary suite with soft neutral tones and ample closet space. The additional bedrooms are ideal for children, guests, or home offices, offering flexibility for today’s lifestyle. The insulated and drywalled basement is ready for your finishing touches—ideal for a rec room, gym, or additional living space—and includes a central vac rough-in for added convenience. Outside, the fully fenced yard provides privacy, room to play, and space to relax, complete with a deck and storage shed. The low-maintenance yard offers year-round enjoyment with plenty of space for gardening, pets, or entertaining. Located just minutes from Edna Staebler Public School, parks, trails, and a wide selection of shopping and amenities, this home offers exceptional convenience in a family-friendly community. Whether you’re a first-time buyer, growing family, or downsizer seeking comfort and function, 707 Paris Boulevard delivers a welcoming lifestyle in a prime Waterloo location. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Central Vacuum - Roughed In"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T15:35:59.017951+00:00"
+"Directions": "From Erbsville Rd to Brandenburg Blvd to Paris Blvd"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600677"
+"ListOfficeKey": "294047"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0.068"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-18T14:00:23Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-23T22:30:23Z"
+"Stories": "2.0"
+"StreetName": "PARIS"
+"StreetNumber": "707"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4069"
+"VirtualTourURLUnbranded": "https://youriguide.com/707_paris_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29113065/707-paris-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1308
+"BelowGradeFinishedArea": 613
+"OriginalEntryTimestamp": "2025-11-18T14:00:23.01Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29113065')"
+"ID": "426427"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24589
+post_id: "422600"
+post_author: 1
+"ListingKey": "29109111"
+"ListingId": "40787926"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-22T21:45:51Z"
+"RFModificationTimestamp": "2025-11-22T21:49:25Z"
+"ListPrice": 724900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1914.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2G6"
+"UnparsedAddress": "511 OAKVALE Drive Unit# 1, Waterloo, Ontario N2T2G6"
+"Coordinates": array:2 [
0 => -80.5580906
1 => 43.4433527
]
+"Latitude": 43.4433527
+"Longitude": -80.5580906
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stop scrolling. Start packing. Here's a spacious freehold townhouse in the quiet well maintained neighbourhood of Westvale in Waterloo. With many new improvements including a fully finished walkout basement, new bathtub, bathroom flooring, and updated lighting, this home has everything and then some. Consider the bright spacious kitchen with easy access to the open concept living and dining room. Consider too the 3 bedrooms on the second floor, including a massive primary bedroom with ensuite bathroom. Step out from the dining room to your own private deck with great views for a morning cappuccino or evening glass of wine. Cozy up in front of the rec room fireplace for a romantic interlude, or step out to the lower level patio to cook up some burgers on the BBQ. The combination Laundry/storage room round out an ergonomically efficient and comfortable space. Close to the Boardwalk at Ira Needles Blvd., and only a stone's throw away from a myriad of other great amenities, including Waterloo Costco, schools, banks, restaurants, parks and trails, this home exudes the perfect blend location, condition and price. Book your private showing today. You'll be glad you did. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Central Vacuum - Roughed In"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-17T15:32:53.396942+00:00"
+"Directions": "East on Thorndale Drive at the Thorndale and Ira Needles traffic circle. Stay on Thorndale through two stop signs. Turn right onto Oakvale Drive. House is the first in the third block of 6 townhomes on the left side of the street."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1973993"
+"ListOfficeKey": "280339"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-17T14:38:34Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-22T21:30:15Z"
+"Stories": "2.0"
+"StreetName": "OAKVALE"
+"StreetNumber": "511"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "3946.37"
+"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/29109111/511-oakvale-drive-unit-1-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 9.0
+"AboveGradeFinishedArea": 1530
+"BelowGradeFinishedArea": 384
+"OriginalEntryTimestamp": "2025-11-17T14:38:32.93Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29109111')"
+"ID": "422600"
}
]
+success: true
+page_size: 9
+page_count: 14
+count: 121
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]