array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29174007/Property?$select=ALL&$top=20&$filter=ListingKey eq 29174007&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29174007/Property?$select=ALL&$top=20&$filter=ListingKey eq 29174007&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23632
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23634
+post_id: "471594"
+post_author: 1
+"ListingKey": "29174007"
+"ListingId": "40792808"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T17:15:58Z"
+"RFModificationTimestamp": "2025-12-17T17:25:11Z"
+"ListPrice": 1125000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3536.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y6"
+"UnparsedAddress": "604 PINERY Trail, Waterloo, Ontario N2V2Y6"
+"Coordinates": array:2 [
0 => -80.5901556
1 => 43.4903339
]
+"Latitude": 43.4903339
+"Longitude": -80.5901556
+"YearBuilt": 2015
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover the perfect blend of comfort, convenience, and community in this beautifully maintained Waterloo home. Nestled in a highly sought-after, family-friendly neighbourhood, this spacious open concept layout with separate dining area, offers 4 bright bedrooms on the second floor, plus an additional bedroom in the fully finished basement featuring a convenient wet bar, ideal for guests, extended family, or a private home office. With 4 well-appointed bathrooms, morning routines and busy family schedules become a breeze. Step outside and enjoy immediate access to scenic walking trails and the Laurel Creek Conservation Area, perfect for nature lovers and active lifestyles. You’re also just minutes from the vibrant St. Jacobs Market, the convenient Boardwalk shopping district, top-rated schools, and all the amenities that make this area one of Waterloo’s most desirable places to live. Whether you’re growing your family or simply looking for more space and comfort, this property presents an exceptional opportunity to own a spacious, move-in-ready home in a prime location. Don’t miss your chance—homes like this are rare to find and quick to love. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T17:23:08.440498+00:00"
+"Directions": "Conservation to Riverbend, left 0n Pinery Trail"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078033"
+"ListOfficeKey": "280339"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T17:08:59Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T17:00:16Z"
+"Stories": "2.0"
+"StreetName": "PINERY"
+"StreetNumber": "604"
+"StreetSuffix": "Trail"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "8302.4"
+"VirtualTourURLUnbranded": "https://youriguide.com/604_pinery_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [
"RoomKey" => "1550416624"
"RoomType" => "Utility room"
"ListingId" => "40792808"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.54Z"
]
1 => array:11 [
"RoomKey" => "1550416625"
"RoomType" => "Storage"
"ListingId" => "40792808"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.54Z"
]
2 => array:11 [
"RoomKey" => "1550416626"
"RoomType" => "Recreation room"
"ListingId" => "40792808"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.55Z"
]
3 => array:11 [
"RoomKey" => "1550416627"
"RoomType" => "Other"
"ListingId" => "40792808"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.55Z"
]
4 => array:11 [
"RoomKey" => "1550416628"
"RoomType" => "Other"
"ListingId" => "40792808"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.56Z"
]
5 => array:11 [
"RoomKey" => "1550416629"
"RoomType" => "Bedroom"
"ListingId" => "40792808"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.56Z"
]
6 => array:11 [
"RoomKey" => "1550416630"
"RoomType" => "3pc Bathroom"
"ListingId" => "40792808"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.57Z"
]
7 => array:11 [
"RoomKey" => "1550416631"
"RoomType" => "Other"
"ListingId" => "40792808"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.57Z"
]
8 => array:11 [
"RoomKey" => "1550416632"
"RoomType" => "Full bathroom"
"ListingId" => "40792808"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.57Z"
]
9 => array:11 [
"RoomKey" => "1550416633"
"RoomType" => "Primary Bedroom"
"ListingId" => "40792808"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "20'7'' x 17'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.58Z"
]
10 => array:11 [
"RoomKey" => "1550416634"
"RoomType" => "Bedroom"
"ListingId" => "40792808"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.58Z"
]
11 => array:11 [
"RoomKey" => "1550416635"
"RoomType" => "Bedroom"
"ListingId" => "40792808"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "17'10'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.59Z"
]
12 => array:11 [
"RoomKey" => "1550416636"
"RoomType" => "Bedroom"
"ListingId" => "40792808"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.59Z"
]
13 => array:11 [
"RoomKey" => "1550416637"
"RoomType" => "4pc Bathroom"
"ListingId" => "40792808"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.6Z"
]
14 => array:11 [
"RoomKey" => "1550416638"
"RoomType" => "Living room"
"ListingId" => "40792808"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.6Z"
]
15 => array:11 [
"RoomKey" => "1550416639"
"RoomType" => "Kitchen"
"ListingId" => "40792808"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "20'8'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.61Z"
]
16 => array:11 [
"RoomKey" => "1550416640"
"RoomType" => "Foyer"
"ListingId" => "40792808"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.61Z"
]
17 => array:11 [
"RoomKey" => "1550416641"
"RoomType" => "Dining room"
"ListingId" => "40792808"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.61Z"
]
18 => array:11 [
"RoomKey" => "1550416642"
"RoomType" => "2pc Bathroom"
"ListingId" => "40792808"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29174007"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 4'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-17T17:00:16.62Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29174007/604-pinery-trail-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1971051"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "280339"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 39.0
+"AboveGradeFinishedArea": 2531
+"BelowGradeFinishedArea": 1005
+"OriginalEntryTimestamp": "2025-12-09T16:38:30.66Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362861080"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/e02ec3980c1b60e010eb40b45ad5c7fe.webp"
"MediaSize" => 82044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-e02ec3980c1b60e010eb40b45ad5c7fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "French provincial home featuring an attached garage, stone siding, and a residential view"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:39.3Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362861147"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/52b34f52b96f8047a41af58c8a9d7d11.webp"
"MediaSize" => 51208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-52b34f52b96f8047a41af58c8a9d7d11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance foyer with baseboards and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:39.29Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362861186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/680146d1d343dd39a050918348b26d14.webp"
"MediaSize" => 48400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-680146d1d343dd39a050918348b26d14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance foyer featuring baseboards and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:39.21Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362861213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/20d5d5af6964460f1ec0676eed07b4a7.webp"
"MediaSize" => 79753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-20d5d5af6964460f1ec0676eed07b4a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining room featuring stairs, dark wood-style flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:39.31Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362861296"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/3f368d90459696ef61a6b006b88d3a8f.webp"
"MediaSize" => 68987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-3f368d90459696ef61a6b006b88d3a8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:39.31Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362861348"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/d7cb00467446dc643a5fb850657776d3.webp"
"MediaSize" => 74909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-d7cb00467446dc643a5fb850657776d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with coffered ceiling, dark wood-style floors, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:39.3Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362861367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/bf929ec464acc971e208e2aff9058ae8.webp"
"MediaSize" => 67491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-bf929ec464acc971e208e2aff9058ae8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining room featuring dark wood-style flooring, recessed lighting, and a glass covered fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:39.29Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362861451"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/894906a2b44b4a4f80b79d13c1457a6f.webp"
"MediaSize" => 88989
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-894906a2b44b4a4f80b79d13c1457a6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, wall chimney exhaust hood, light stone countertops, and an island with sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:39.99Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362861483"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/395b5586b9a6edb5f19be8acd020f7b0.webp"
"MediaSize" => 67797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-395b5586b9a6edb5f19be8acd020f7b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room with dark wood-type flooring, a glass covered fireplace, coffered ceiling, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:38.89Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362861594"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/1d5a9d7b600e0c8234a6c7e8f880ed87.webp"
"MediaSize" => 84669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-1d5a9d7b600e0c8234a6c7e8f880ed87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with a glass covered fireplace, recessed lighting, coffered ceiling, and dark wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362861613"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/efb40e20d223de8e81c7edf2190979c4.webp"
"MediaSize" => 83939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-efb40e20d223de8e81c7edf2190979c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring dark wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362861677"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/edfca2ed4182f1d6c5687fda81c441ee.webp"
"MediaSize" => 60965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-edfca2ed4182f1d6c5687fda81c441ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Half bath featuring vanity and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:38.89Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362861725"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/2cff9d06894e2c815e48eeb115195cdd.webp"
"MediaSize" => 65130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-2cff9d06894e2c815e48eeb115195cdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase with plenty of natural light and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.02Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362861813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/2464312caf03661603788874cf28d128.webp"
"MediaSize" => 46548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-2464312caf03661603788874cf28d128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway with an upstairs landing and light colored carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.02Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362861867"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/4760c50ee332ed5096604308ed3bbb97.webp"
"MediaSize" => 40887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-4760c50ee332ed5096604308ed3bbb97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairs with carpet flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.11Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6362861885"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/fe4cc87feda8d8b55232aa4fcf205b2b.webp"
"MediaSize" => 53706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-fe4cc87feda8d8b55232aa4fcf205b2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light colored carpet and a desk"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.18Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6362861948"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/12f969275d1f88b9acf39d81bbc3f062.webp"
"MediaSize" => 47782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-12f969275d1f88b9acf39d81bbc3f062.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring an office area and light carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.1Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6362861973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/9f20a9070b6c803b6d78c002afcfd4f7.webp"
"MediaSize" => 44670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-9f20a9070b6c803b6d78c002afcfd4f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.19Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6362862002"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/35641aa6224d2eeb5e7e34bfe513e96d.webp"
"MediaSize" => 43299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-35641aa6224d2eeb5e7e34bfe513e96d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.19Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6362862028"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/abd63d1e8942d70e8ccad6d7560a45b9.webp"
"MediaSize" => 45523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-abd63d1e8942d70e8ccad6d7560a45b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Office area featuring light colored carpet and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.21Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6362862057"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/2b030984df8224550953ed8fcabbdffc.webp"
"MediaSize" => 49386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-2b030984df8224550953ed8fcabbdffc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom with baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.02Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6362862091"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/80139978dbfd011baa52d307b61ed663.webp"
"MediaSize" => 45113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-80139978dbfd011baa52d307b61ed663.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway with light colored carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.21Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6362862140"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/0f0b89781deea1e73c4a571325574520.webp"
"MediaSize" => 69160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-0f0b89781deea1e73c4a571325574520.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious closet featuring light carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.02Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6362862160"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/f9404b33db5077e31c749c9457a91166.webp"
"MediaSize" => 70423
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-f9404b33db5077e31c749c9457a91166.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious closet featuring light carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.34Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6362862191"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/f5178a6f6cc0fcaf787074abf02422a5.webp"
"MediaSize" => 56136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-f5178a6f6cc0fcaf787074abf02422a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with a freestanding tub, double vanity, light tile patterned flooring, and plenty of natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.48Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6362862216"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/d7471ba8a2ee3b44b343e1a24cd86466.webp"
"MediaSize" => 43046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-d7471ba8a2ee3b44b343e1a24cd86466.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom with a freestanding bath, a stall shower, tile patterned floors, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.16Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6362862253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/4e9d25637d6de002bdd313ebba6dd5f0.webp"
"MediaSize" => 49270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-4e9d25637d6de002bdd313ebba6dd5f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring two vanities, a stall shower, and light tile patterned flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6362862263"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/99f7f490743e7f7b7d21987e115d25fd.webp"
"MediaSize" => 38712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-99f7f490743e7f7b7d21987e115d25fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase with wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.17Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6362862300"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/85f91656af6c99b9614c5a844d7a3f79.webp"
"MediaSize" => 57744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-85f91656af6c99b9614c5a844d7a3f79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring open floor plan, a peninsula, stainless steel appliances, hanging light fixtures, and dark countertops"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.14Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6362862344"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/05b0b75bfbfe4fe7b7d026d1b68766ea.webp"
"MediaSize" => 59554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-05b0b75bfbfe4fe7b7d026d1b68766ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with a peninsula, open floor plan, pendant lighting, stainless steel microwave, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.15Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6362862352"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/41f0e75315f048299120bca7928e125c.webp"
"MediaSize" => 62241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-41f0e75315f048299120bca7928e125c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with open floor plan, a peninsula, decorative light fixtures, white cabinets, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.01Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6362862384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/e450beff765e847d1136948ed4499f4e.webp"
"MediaSize" => 58236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-e450beff765e847d1136948ed4499f4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring a glass covered fireplace, light wood-style flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.33Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6362862406"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/b2839678fc462a87538d918e8ad71ae6.webp"
"MediaSize" => 64525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-b2839678fc462a87538d918e8ad71ae6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light wood-style flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.19Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6362862417"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/18ecaac1c7689b5f385dc5f5c77ed318.webp"
"MediaSize" => 43891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-18ecaac1c7689b5f385dc5f5c77ed318.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with vanity and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.14Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6362862466"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/4baf483fcf7f5b5f6e5bc07d49f564a4.webp"
"MediaSize" => 39190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-4baf483fcf7f5b5f6e5bc07d49f564a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a shower stall and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.33Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6362862487"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/336775f877a39ab26630567806770527.webp"
"MediaSize" => 34317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-336775f877a39ab26630567806770527.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring wallpapered walls, a shower stall, vanity, dark wood-style flooring, and an accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.15Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6362862512"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/1be320740c7a1259552cb31d5e9ef493.webp"
"MediaSize" => 97215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-1be320740c7a1259552cb31d5e9ef493.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Snow covered rear of property with brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.19Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6362862521"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/48b0b6c9a91bcb6ca6ea7f4b9386cbc8.webp"
"MediaSize" => 88327
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-48b0b6c9a91bcb6ca6ea7f4b9386cbc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Yard layered in snow with a fenced backyard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.15Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6362862549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/3dfab2b6714f99c3cec71f62ccabe43e.webp"
"MediaSize" => 125656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-3dfab2b6714f99c3cec71f62ccabe43e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front facade featuring concrete driveway, a garage, a front lawn, roof with shingles, and stucco siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.17Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6362862558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29174007/8741f16215ecdde48ef40f5fbacf7485.webp"
"MediaSize" => 165658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29174007/thumbnail-8741f16215ecdde48ef40f5fbacf7485.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective of suburban area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40792808"
"ResourceRecordKey" => "29174007"
"ModificationTimestamp" => "2025-12-09T17:00:40.07Z"
]
]
+"Member": array:1 [
0 => array:4 [
"MemberMlsId" => "2078033"
"OriginatingSystemName" => 26
"MemberKey" => "2078033"
"ModificationTimestamp" => "2025-12-09T17:22:04Z"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "Home and Property Real Estate Ltd."
"OfficePhone" => "800-258-2059"
"OfficeMlsId" => "KW84"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "280339"
"ModificationTimestamp" => "2025-08-19T15:50:12Z"
"OfficeAddress1" => "15 Burnaby Cres."
"OfficeCity" => "Kitchener"
"OfficePostalCode" => "N2N2W"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2017-06-16T13:39:00Z"
"OfficeNationalAssociationId" => "1312825"
"OfficeBrokerNationalAssociationId" => "1260703"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29174007')"
+"ID": "471594"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 280339/Office?$select=ALL&$top=10&$filter=OfficeKey eq 280339&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 280339/Office?$select=ALL&$top=10&$filter=OfficeKey eq 280339&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25478
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25480
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Home and Property Real Estate Ltd."
+"OfficeEmail": null
+"OfficePhone": "800-258-2059"
+"OfficeMlsId": "KW84"
+"ModificationTimestamp": "2025-08-19T15:50:12Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "280339"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "15 Burnaby Cres."
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Kitchener"
+"OfficePostalCode": "N2N2W"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1312825"
+"OriginalEntryTimestamp": "2017-06-16T13:39:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "444166"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "280339"
"SocialMediaUrlOrId" => "http://www.homeandproperty.ca/"
"ModificationTimestamp" => "2025-08-19T15:27:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1260703"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('280339')"
}
]
+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 2078033/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2078033&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2078033/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2078033&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25475
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25483
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "2078033"
+"ModificationTimestamp": "2025-12-09T17:22:04Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "2078033"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Member('2078033')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.22 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29174007" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25094
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29174007/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29174007&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29174007/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29174007&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25077
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25074
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29322344"
+"ListingKey": "29174007"
+"ListingId": "40792808"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-13"
+"OpenHouseStartTime": "2025-12-13T14:00:00Z"
+"OpenHouseEndTime": "2025-12-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-12T20:58:27Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29322344')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25072
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29322343"
+"ListingKey": "29174007"
+"ListingId": "40792808"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-14"
+"OpenHouseStartTime": "2025-12-14T14:00:00Z"
+"OpenHouseEndTime": "2025-12-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-12T20:58:27Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29322343')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25075
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29340690"
+"ListingKey": "29174007"
+"ListingId": "40792808"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-13"
+"OpenHouseStartTime": "2025-12-13T14:00:00Z"
+"OpenHouseEndTime": "2025-12-13T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-13T18:44:53Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29340690')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25071
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29340689"
+"ListingKey": "29174007"
+"ListingId": "40792808"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-14"
+"OpenHouseStartTime": "2025-12-14T14:00:00Z"
+"OpenHouseEndTime": "2025-12-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-13T18:44:53Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29340689')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25073
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29347366"
+"ListingKey": "29174007"
+"ListingId": "40792808"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-14"
+"OpenHouseStartTime": "2025-12-14T14:00:00Z"
+"OpenHouseEndTime": "2025-12-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-14T20:47:48Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29347366')"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25076
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29363327"
+"ListingKey": "29174007"
+"ListingId": "40792808"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-12-20"
+"OpenHouseStartTime": "2025-12-20T14:00:00Z"
+"OpenHouseEndTime": "2025-12-20T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-12-18T06:53:50Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29363327')"
}
]
+success: true
+page_size: 6
+page_count: 1
+count: 6
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29174007 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5901556 43.4903339)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29174007 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5901556 43.4903339)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29174007 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5901556 43.4903339)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29174007 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5901556 43.4903339)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24998
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25330
+post_id: "475178"
+post_author: 1
+"ListingKey": "29179504"
+"ListingId": "40791354"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-16T18:45:36Z"
+"RFModificationTimestamp": "2025-12-16T18:46:33Z"
+"ListPrice": 1199999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3150.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2C4"
+"UnparsedAddress": "629 BURNING BUSH Road, Waterloo, Ontario N2V2C4"
+"Coordinates": array:2 [
0 => -80.5692557
1 => 43.498359
]
+"Latitude": 43.498359
+"Longitude": -80.5692557
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This custom-built detached home features a spacious, well-designed layout offering a main-floor primary bedroom, two upper-level bedrooms, and two additional rooms in the finished basement, providing flexibility for a variety of needs. The main level begins with a foyer leading into a bright great room with vaulted ceiling, pot lighting, and maintained flooring. This level includes a high ceiling primary bedroom with a walk-in closet and a 5-piece ensuite. The eat-in kitchen features extensive cabinetry and opens to a sunroom with access to the rear yard. The main floor also includes a separate dining area suitable for formal or everyday use, positioned conveniently off the main living space. The upper level, overlooking the main living area, provides two comfortably sized bedrooms and a full bathroom, creating separation from the main floor while remaining connected to the living space. The finished basement extends the living area with an ample recreation space, a 5-piece bathroom, and two additional rooms suitable for flexible use, along with storage and utility areas. Exterior features include a stamped driveway, a maintained lawn, a private backyard, and a sprinkler system in the front. Located within the school boundaries of Northlake Woods Public School and Waterloo Collegiate Institute, and close to shopping, parks, trails, public transit, and major roadways. A well-maintained home in an established residential neighbourhood. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dishwasher"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T15:26:24.141954+00:00"
+"Directions": "Benjamin Rd and Burning Bush Rd"
+"ExteriorFeatures": array:4 [
0 => "Concrete"
1 => "Brick"
2 => "Stone"
3 => "Shingles"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2146831"
+"ListOfficeKey": "283251"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T15:11:11Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-16T18:29:39Z"
+"Stories": "2.0"
+"StreetName": "BURNING BUSH"
+"StreetNumber": "629"
+"StreetSuffix": "Road"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "7713"
+"VirtualTourURLUnbranded": "https://youriguide.com/629_burning_bush_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1549995567"
"RoomType" => "5pc Bathroom"
"ListingId" => "40791354"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.19Z"
]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29179504/629-burning-bush-road-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 59.0
+"AboveGradeFinishedArea": 2200
+"BelowGradeFinishedArea": 950
+"OriginalEntryTimestamp": "2025-12-11T14:08:42.3Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29179504')"
+"ID": "475178"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25012
+post_id: "460126"
+post_author: 1
+"ListingKey": "29158554"
+"ListingId": "X12597322"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-03T22:35:44Z"
+"RFModificationTimestamp": "2025-12-03T22:38:04Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "705 CONSERVATION DRIVE, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.604156
1 => 43.481806
]
+"Latitude": 43.481806
+"Longitude": -80.604156
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "London and St. Thomas Association of REALTORS®"
+"PublicRemarks": "Enjoy cottage living in the city with this unique two-storey, loft-style fully furnished apartment, located on a quiet rural road just outside Waterloo. This front-unit rental offers two bedrooms, two bathrooms (one 4-piece and one 2-piece), and sits on a spacious 1.35-acre lot with a private yard ideal for garden enthusiasts to grow their own vegetables. A vehicle is recommended, as the property is only a 10-minute drive to the University of Waterloo, Wilfrid Laurier University, St. Jacobs, the Farmers Market, The Boardwalk, Conestoga Mall, RIM Park, and Laurel Creek Conservation Area. The back unit is occupied by a professional family with one child and a dog. Utilities will be shared based on occupancy and divided according to the number of people living in each unit. If the lease term is longer than 24 months, the landlord can remove the furniture upon request. The landlord is seeking a long-term family tenant with stable income and strong credit history. (id:62650)"
+"Appliances": array:2 [
0 => "Water Treatment"
1 => "Furniture"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-03T16:58:32.095492+00:00"
+"Directions": "Cross Streets: Erbsville Rd & Conservation Dr. ** Directions: Please park in front of the door. Door faces the road.Erbsville Rd & Conservation Dr."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2224457"
+"ListOfficeKey": "47128"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Flat site"
]
+"LotSizeDimensions": "449.8 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-03T16:23:16Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-03T22:22:38Z"
+"Stories": "2.0"
+"StreetName": "Conservation"
+"StreetNumber": "705"
+"StreetSuffix": "Drive"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "London and St. Thomas"
+"ListAORKey": "13"
+"ListingURL": "www.realtor.ca/real-estate/29158554/unit-a-705-conservation-drive-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2147380"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "47128"
+"GeocodeManualYN": false
+"TotalActualRent": 1980
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 449.9
+"OriginalEntryTimestamp": "2025-12-03T16:23:16.17Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:33 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29158554')"
+"ID": "460126"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25011
+post_id: "458323"
+post_author: 1
+"ListingKey": "29155022"
+"ListingId": "X12500976"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-02T17:35:09Z"
+"RFModificationTimestamp": "2025-12-02T19:33:43Z"
+"ListPrice": 99999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2J3Z4"
+"UnparsedAddress": "153 - 580 BEAVER CREEK ROAD, Waterloo, Ontario N2J3Z4"
+"Coordinates": array:2 [
0 => -80.586345
1 => 43.484782
]
+"Latitude": 43.484782
+"Longitude": -80.586345
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This Open Concept, 2 bedroom Park Model-mobile home is located in a land lease community that offers 10 month seasonal accommodation. Perfect for Snowbirds looking to head south for January/February. Also ideal for young couples saving for a home who want their own space without renting. This particular unit is MOVE-IN-READY and is low maintenance. It has a warm cottage feel and is tastefully decorated. The kitchen is crisp and bright with white cabinetry, black appliances, updated hardware and newer quartz counter tops (2022). It has an island with bar stools and is open to the cozy living room with electric fireplace and laminate flooring throughout. There is a bedroom at both the front that could be used as an office, or hobby room and a bedroom at the rear with closet and close access to the 3 pc bath with walk in shower with surround. The sunporch area can be used as an additional sitting room, laundry room and/or storage/mud room. It has sliders to both the rear yard and patio as well as the front covered deck. There is parking for 2 vehicles and a generously sized side yard where you can enjoy your summer and fall nights sitting by the fire. There is also a large garden shed for all your additional storage needs whether it be garden tools or winter tire storage etc. This terrific move-in-ready home is located close to the city in a beautiful friendly park that is a clean, well maintained, well managed recreational park that offers 10 month living. It includes a pool, hot tubs, recreational hall, picnic areas, koi pond, catch and release pond, playgrounds, pickle ball courts and many fun activities & events to enjoy. Located within minutes of St. Jacob's Farmer's Market, North Waterloo and the amenities it has to offer. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Stove"
2 => "Microwave"
3 => "Furniture"
4 => "Window Coverings"
5 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-02T19:33:24.286772+00:00"
+"Directions": "Cross Streets: conservation. ** Directions: FROM NORTHFIELD EXIT-WEST ON NORTHFIELD DR., NORTH ON WESTMOUNT RD N. WEST ON CONSERVATION DR., SOUTH ON BEAVER CREED ROAD; ONCE INSIDE PARK, TURN RIGHT AT YEILD SIGN, TURN LEFT AT THE OFFICE AND 153 IS PARTWAY UP THE 2ND STREET ON THE LEFT."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceFeatures": array:1 [
0 => "Free Standing Metal"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:4 [
0 => "Forced air"
1 => "Not known"
2 => "Propane"
3 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235240"
+"ListOfficeKey": "290667"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-02T17:28:13Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-02T17:28:13Z"
+"Stories": "1.0"
+"StreetName": "Beaver Creek"
+"StreetNumber": "580"
+"StreetSuffix": "Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29155022/153-580-beaver-creek-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Modular"
]
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"ZoningDescription": "FD"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-12-02T17:28:13.22Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:21 [
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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29155022')"
+"ID": "458323"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24939
+post_id: "455677"
+post_author: 1
+"ListingKey": "29150077"
+"ListingId": "40790097"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-13T21:45:55Z"
+"RFModificationTimestamp": "2025-12-13T21:47:58Z"
+"ListPrice": 789000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1659.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5P1"
+"UnparsedAddress": "364 ROSELAWN Place, Waterloo, Ontario N2L5P1"
+"Coordinates": array:2 [
0 => -80.5655557
1 => 43.4885938
]
+"Latitude": 43.4885938
+"Longitude": -80.5655557
+"YearBuilt": 1975
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 364 Roselawn Place, a beautifully maintained five-bedroom, two-bathroom home tucked into one of Waterloo’s most desirable neighbourhoods. From the moment you arrive, the gorgeous curb appeal, spacious two-car garage, and ample parking set the tone for a home that truly has it all. Step inside to a main floor filled with wonderful natural light, enhanced by fresh paint in the living room, dining room, and hallway, along with new pot lights that brighten and modernize the space. The kitchen features stainless steel appliances, an upgraded refrigerator, an oversized sink, and a clear view overlooking the backyard oasis. Convenience continues with an upgraded washing machine and a new reverse osmosis water filtration system, adding comfort and quality to everyday living. Downstairs, the basement provides incredible flexibility—whether you envision a fifth oversized bedroom, a cozy rec room, home office or a gym the space is ready to adapt to your lifestyle. Outside is where this home truly shines. The inground saltwater pool with a gas heater promises endless summer enjoyment, while the spacious deck and beautifully landscaped yard create the ideal setting for hosting friends and family. It’s the kind of backyard that feels like a private escape yet is just minutes from all that Waterloo has to offer. Combining comfort, style, thoughtful upgrades, and an unbeatable location, this is the perfect place to call home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T17:01:51.264782+00:00"
+"Directions": "BEARINGER TO PINERIDGE RD TO ROSELAWN PLACE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2242919"
+"ListOfficeKey": "290392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-01T13:40:26Z"
+"PhotosCount": 34
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-13T21:30:27Z"
+"Stories": "1.0"
+"StreetName": "ROSELAWN"
+"StreetNumber": "364"
+"StreetSuffix": "Place"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4530"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/a4r3BgoD9Bc?feature=share"
+"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/29150077/364-roselawn-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2067042"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2142140"
+"CoListOfficeKey": "294394"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "290392"
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1042
+"BelowGradeFinishedArea": 617
+"OriginalEntryTimestamp": "2025-12-01T13:38:21.15Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:34 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29150077')"
+"ID": "455677"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24956
+post_id: "454953"
+post_author: 1
+"ListingKey": "29150133"
+"ListingId": "X12589242"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-14T13:25:25Z"
+"RFModificationTimestamp": "2025-12-14T13:28:52Z"
+"ListPrice": 789000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5P1"
+"UnparsedAddress": "364 ROSELAWN PLACE, Waterloo, Ontario N2L5P1"
+"Coordinates": array:2 [
0 => -80.5659382
1 => 43.4886917
]
+"Latitude": 43.4886917
+"Longitude": -80.5659382
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 364 Roselawn Place, a beautifully maintained five-bedroom, two-bathroom home tucked into one of Waterloo's most desirable neighbourhoods. From the moment you arrive, the gorgeous curb appeal, spacious two-car garage, and ample parking set the tone for a home that truly has it all. Step inside to a main floor filled with wonderful natural light, enhanced by fresh paint in the living room, dining room, and hallway, along with new pot lights that brighten and modernize the space. The kitchen features stainless steel appliances, an upgraded refrigerator, an oversized sink, and a clear view overlooking the backyard oasis. Convenience continues with an upgraded washing machine and a new reverse osmosis water filtration system, adding comfort and quality to everyday living. Downstairs, the basement provides incredible flexibility-whether you envision a fifth oversized bedroom, a cozy rec room, home office or a gym the space is ready to adapt to your lifestyle. Outside is where this home truly shines. The inground saltwater pool with a gas heater promises endless summer enjoyment, while the spacious deck and beautifully landscaped yard create the ideal setting for hosting friends and family. It's the kind of backyard that feels like a private escape yet is just minutes from all that Waterloo has to offer. Combining comfort, style, thoughtful upgrades, and an unbeatable location, this is the perfect place to call home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T15:09:43.259496+00:00"
+"Directions": "Cross Streets: BEARINGER RD & WESTMOUNT RD N. ** Directions: BEARINGER TO PINERIDGE RD TO ROSELAWN PLACE."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2202928"
+"ListOfficeKey": "294429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45.1 x 105.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-01T14:15:45Z"
+"PhotosCount": 34
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-14T13:16:20Z"
+"Stories": "1.0"
+"StreetName": "Roselawn"
+"StreetNumber": "364"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "4530"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/a4r3BgoD9Bc?feature=share"
+"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/29150133/364-roselawn-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.1
+"OriginalEntryTimestamp": "2025-12-01T14:15:45.32Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:34 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29150133')"
+"ID": "454953"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25004
+post_id: "448643"
+post_author: 1
+"ListingKey": "29142515"
+"ListingId": "40790958"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T17:40:30Z"
+"RFModificationTimestamp": "2025-11-27T19:48:26Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1353.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1L2"
+"UnparsedAddress": "106 CORNERBROOK Crescent, Waterloo, Ontario N2V1L2"
+"Coordinates": array:2 [
0 => -80.565609
1 => 43.491621
]
+"Latitude": 43.491621
+"Longitude": -80.565609
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 106 Cornerbrook Crescent in the desirable Lakeshore North area of Waterloo. This bright and well-maintained two-storey link homeoffers over 1,350 square feet of finished living space with three bedrooms and two bathrooms. The main level features a spacious kitchen anddining area with a walkout to the deck and backyard, perfect for family living and entertaining. Upstairs you’ll find three comfortable bedroomsand a full bath, while the fully finished basement includes a large rec room and an additional bathroom, offering plenty of space for relaxation ora home office. The property boasts a private single driveway with parking for three vehicles, central air, and forced-air gas heating for year-roundcomfort. Conveniently located close to schools, parks, shopping, public transit, and highway access, this home combines comfort withaccessibility. Available for lease at $3,200 per month, this property is ideal for families or professionals looking to settle in a quiet, establishedneighbourhood in Waterloo. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T19:48:09.411285+00:00"
+"Directions": "Highpoint/Northfield"
+"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": "2106892"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0"
+"NumberOfUnitsTotal": "1"
+"PhotosChangeTimestamp": "2025-11-27T17:30:46Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T17:30:45Z"
+"Stories": "2.0"
+"StreetName": "CORNERBROOK"
+"StreetNumber": "106"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29142515/106-cornerbrook-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 2690
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1130
+"BelowGradeFinishedArea": 223
+"OriginalEntryTimestamp": "2025-11-27T17:30:45.75Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:14 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29142515')"
+"ID": "448643"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23646
+post_id: "443152"
+post_author: 1
+"ListingKey": "29131516"
+"ListingId": "40789849"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T16:45:17Z"
+"RFModificationTimestamp": "2025-12-15T16:47:11Z"
+"ListPrice": 1082450.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2891.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y7"
+"UnparsedAddress": "548 WASAGA Crescent, Waterloo, Ontario N2V2Y7"
+"Coordinates": array:2 [
0 => -80.589464
1 => 43.4895367
]
+"Latitude": 43.4895367
+"Longitude": -80.589464
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Situated in the desirable Conservation Meadows community, this well-appointed home features an elegant and functional floor plan. Enjoy proximity to parks, shopping, scenic trails, highway access, and all major amenities. With a touch of imagination, this property presents an exceptional opportunity to transform it into a stunning showcase residence. Property sold as is, where is basis. Seller makes no representation and/ or warranties. RSA (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-11-24T19:47:02.482705+00:00"
+"Directions": "Rideau River St & Wasaga Cres"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523944"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T17:09:13Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T16:30:19Z"
+"Stories": "2.0"
+"StreetName": "WASAGA"
+"StreetNumber": "548"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7101"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29131516/548-wasaga-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2034860"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55026"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2891
+"OriginalEntryTimestamp": "2025-11-24T17:09:13.1Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29131516')"
+"ID": "443152"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24944
+post_id: "443153"
+post_author: 1
+"ListingKey": "29131773"
+"ListingId": "X12571800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T17:40:20Z"
+"RFModificationTimestamp": "2025-12-15T17:43:12Z"
+"ListPrice": 1082450.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2Y7"
+"UnparsedAddress": "548 WASAGA CRESCENT, Waterloo, Ontario N2V2Y7"
+"Coordinates": array:2 [
0 => -80.589484
1 => 43.4896692
]
+"Latitude": 43.4896692
+"Longitude": -80.589484
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Situated in the desirable Conservation Meadows community, this well-appointed home features an elegant and functional floor plan. Enjoy proximity to parks, shopping, scenic trails, highway access, and all major amenities. With a touch of imagination, this property presents an exceptional opportunity to transform it into a stunning showcase residence. Property sold "as is, where is" basis. Seller makes no representation and/ or warranties. RSA (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-11-24T18:39:53.421465+00:00"
+"Directions": "Rideau River St & Wasaga Cres"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162720"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "49.9 x 105.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T17:56:12Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T17:20:37Z"
+"Stories": "2.0"
+"StreetName": "Wasaga"
+"StreetNumber": "548"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7101"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29131773/548-wasaga-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 49.1
+"OriginalEntryTimestamp": "2025-11-24T17:56:12.22Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29131773')"
+"ID": "443153"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25010
+post_id: "431510"
+post_author: 1
+"ListingKey": "29119504"
+"ListingId": "40789360"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T17:45:08Z"
+"RFModificationTimestamp": "2025-12-06T17:46:15Z"
+"ListPrice": 1629000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 4609.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R2"
+"UnparsedAddress": "711 CEDAR BEND Drive, Waterloo, Ontario N2V2R2"
+"Coordinates": array:2 [
0 => -80.5888777
1 => 43.4737867
]
+"Latitude": 43.4737867
+"Longitude": -80.5888777
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 4-Bedroom Executive Home | Over 4,600 sq. ft. of Luxury Living ?Finished Top to Bottom with exceptional attention to detail, this 4-bedroom, 4-bathroom home offers over 4,600 sq. ft.of elegant living space designed for comfort and style. Step inside to a bright, open-concept main floor featuring 9’ ceilings, oversized windows, and abundant natural light. Enjoy a formal living room and dining room, perfect for entertaining. The gourmet kitchen boasts a large breakfast island, solid surface counters, walk-in pantry, and stainless steel appliances, overlooking a spacious family roomwith a stone fireplace framed by custom maple built-ins. An amazing mudroom with extensive cabinetry adds practicality to luxury. Upstairs, discover a spectacular primary retreat ?complete with a cozy sitting area, walk-in closets, and a spa-inspired 5-piece ensuite with his & her sinks, glass shower, and soaker tub. Three additional bedrooms are generously sized, complemented by a vaulted-ceiling office. The professionally finished lower level offers a spacious recreation room with a fireplace feature wall, wet bar with quartz counters, exercise room, bathroom, and ample storage space. Locatedin a vibrant community close to excellent schools, shopping, public transit, universities, library, YMCA, and beautiful conservation areas, this home is perfect for families seeking both comfort and convenience. Don’t miss your chance to live in this stunning home and exceptional neighbourhood! (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T23:09:00.182057+00:00"
+"Directions": "Laurelwood Dirve"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162407"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T21:19:12Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T17:30:20Z"
+"Stories": "2.0"
+"StreetName": "CEDAR BEND"
+"StreetNumber": "711"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "9326.54"
+"VirtualTourURLUnbranded": "https://youtu.be/G9mlEX2eKxw?feature=shared"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29119504/711-cedar-bend-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 74.0
+"AboveGradeFinishedArea": 3409
+"BelowGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2025-11-19T21:19:12.29Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29119504')"
+"ID": "431510"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 66
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]
