array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29131516/Property?$select=ALL&$top=20&$filter=ListingKey eq 29131516&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29131516/Property?$select=ALL&$top=20&$filter=ListingKey eq 29131516&$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: "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 [
"RoomKey" => "1549446899"
"RoomType" => "Recreation room"
"ListingId" => "40789849"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.4Z"
]
1 => array:11 [
"RoomKey" => "1549446900"
"RoomType" => "4pc Bathroom"
"ListingId" => "40789849"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.4Z"
]
2 => array:11 [
"RoomKey" => "1549446901"
"RoomType" => "2pc Bathroom"
"ListingId" => "40789849"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.41Z"
]
3 => array:11 [
"RoomKey" => "1549446902"
"RoomType" => "Bedroom"
"ListingId" => "40789849"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.41Z"
]
4 => array:11 [
"RoomKey" => "1549446903"
"RoomType" => "Bedroom"
"ListingId" => "40789849"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.41Z"
]
5 => array:11 [
"RoomKey" => "1549446904"
"RoomType" => "Bedroom"
"ListingId" => "40789849"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.42Z"
]
6 => array:11 [
"RoomKey" => "1549446905"
"RoomType" => "Primary Bedroom"
"ListingId" => "40789849"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.42Z"
]
7 => array:11 [
"RoomKey" => "1549446906"
"RoomType" => "Office"
"ListingId" => "40789849"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.43Z"
]
8 => array:11 [
"RoomKey" => "1549446907"
"RoomType" => "Family room"
"ListingId" => "40789849"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.43Z"
]
9 => array:11 [
"RoomKey" => "1549446908"
"RoomType" => "Kitchen"
"ListingId" => "40789849"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.44Z"
]
10 => array:11 [
"RoomKey" => "1549446909"
"RoomType" => "Dining room"
"ListingId" => "40789849"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.44Z"
]
11 => array:11 [
"RoomKey" => "1549446910"
"RoomType" => "Living room"
"ListingId" => "40789849"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29131516"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T16:30:19.44Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6337457000"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/641c95d2b9275250e74812bd36de738d.webp"
"MediaSize" => 62831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-641c95d2b9275250e74812bd36de738d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6337457006"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/782615742a3a82e2836c11bc3610adc3.webp"
"MediaSize" => 65932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-782615742a3a82e2836c11bc3610adc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6337457012"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/11a4357f578f5026259137c14d5b6be7.webp"
"MediaSize" => 41308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-11a4357f578f5026259137c14d5b6be7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6337457018"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/1a261051956dd475e95151a251bbe5d0.webp"
"MediaSize" => 80194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-1a261051956dd475e95151a251bbe5d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6337457027"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/96f9ca064c57d9245b825bdf792c60fa.webp"
"MediaSize" => 75920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-96f9ca064c57d9245b825bdf792c60fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6337457037"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/cecd0919162a43beea7e01708d62cdeb.webp"
"MediaSize" => 38222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-cecd0919162a43beea7e01708d62cdeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6337457044"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/08f4f064d24d20669ae3c83860890510.webp"
"MediaSize" => 45864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-08f4f064d24d20669ae3c83860890510.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6337457057"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/d7ebdcc1c5adc08d7b089ea3bf76a44e.webp"
"MediaSize" => 50330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-d7ebdcc1c5adc08d7b089ea3bf76a44e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6337457072"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/b8878d9a6a9d45c3301fd064278d6636.webp"
"MediaSize" => 61719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-b8878d9a6a9d45c3301fd064278d6636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6337457084"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/cc9f546d5d111a7b14f730659926b6ed.webp"
"MediaSize" => 80110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-cc9f546d5d111a7b14f730659926b6ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6337457096"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/fb6181526a20ea7b58649d7d6acc0bec.webp"
"MediaSize" => 58199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-fb6181526a20ea7b58649d7d6acc0bec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6337457119"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/92cc1f699420e2b4e30704bcf0313897.webp"
"MediaSize" => 55028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-92cc1f699420e2b4e30704bcf0313897.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6337457138"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/15c2503b3849f3cfff1fa2663c6b285f.webp"
"MediaSize" => 59651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-15c2503b3849f3cfff1fa2663c6b285f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6337457179"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/bb177388cbf0771b205589b5f6a8c2f1.webp"
"MediaSize" => 49602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-bb177388cbf0771b205589b5f6a8c2f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6337457218"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/13e3119a32be9eda330dddc832c5897b.webp"
"MediaSize" => 104082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-13e3119a32be9eda330dddc832c5897b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6337457253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/f519023dc8aa4ce90955b262b9e0eec2.webp"
"MediaSize" => 40154
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-f519023dc8aa4ce90955b262b9e0eec2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6337457270"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/a3313c0c6b6aa4bd02118695575e1027.webp"
"MediaSize" => 80323
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-a3313c0c6b6aa4bd02118695575e1027.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6337457292"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/a974e9f4ad1b8b56272853b8033eec2e.webp"
"MediaSize" => 56404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-a974e9f4ad1b8b56272853b8033eec2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6337457311"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/fec4d9f68996f0d97c4bb05767fb7909.webp"
"MediaSize" => 46955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-fec4d9f68996f0d97c4bb05767fb7909.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6337457321"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/6a55cb6290ec64b25a4d19af7eabafc1.webp"
"MediaSize" => 61738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-6a55cb6290ec64b25a4d19af7eabafc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6337457340"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/8c5a4996c7220c1b42eb4920bdb16b27.webp"
"MediaSize" => 52234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-8c5a4996c7220c1b42eb4920bdb16b27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6337457353"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/2712413dbc1e49342300c934df499778.webp"
"MediaSize" => 42394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-2712413dbc1e49342300c934df499778.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6337457377"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/0d1236d78315a2314255c65908875e6f.webp"
"MediaSize" => 50754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-0d1236d78315a2314255c65908875e6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6337457388"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/58d2ba5687169899d1a46a327b56542f.webp"
"MediaSize" => 92904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-58d2ba5687169899d1a46a327b56542f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6337457399"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/81d81f6c50cebe197db3e6916f179f8f.webp"
"MediaSize" => 75511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-81d81f6c50cebe197db3e6916f179f8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6337457415"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/105234d8122555f0e7bd5de2405e92ce.webp"
"MediaSize" => 25405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-105234d8122555f0e7bd5de2405e92ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6337457448"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/14ada609ba700e69da575e8b222ab11b.webp"
"MediaSize" => 35382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-14ada609ba700e69da575e8b222ab11b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6337457462"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/0294d4b730456e299729f08732312a60.webp"
"MediaSize" => 59231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-0294d4b730456e299729f08732312a60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6337457484"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/0eed0f549588171e28562053fb5b144f.webp"
"MediaSize" => 48175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-0eed0f549588171e28562053fb5b144f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6337457503"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/d0030c99b285eef6579f567c963e743a.webp"
"MediaSize" => 87228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-d0030c99b285eef6579f567c963e743a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6337457524"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/ac44872af71d11d8b8e35e22e830ba72.webp"
"MediaSize" => 83561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-ac44872af71d11d8b8e35e22e830ba72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6337457540"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/e97c49a4f2e929b1ac5e18edf1608219.webp"
"MediaSize" => 25604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-e97c49a4f2e929b1ac5e18edf1608219.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6337457564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/d2f214b0e88f808811569e5f59ed5d04.webp"
"MediaSize" => 60408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-d2f214b0e88f808811569e5f59ed5d04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6337457586"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/aa4893b6828312195a4f9635349f4b73.webp"
"MediaSize" => 84055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-aa4893b6828312195a4f9635349f4b73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6337457606"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/d8607f2eb3e59b69f6bfb5d31f743100.webp"
"MediaSize" => 80592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-d8607f2eb3e59b69f6bfb5d31f743100.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6337457630"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29131516/f46171b5b2046faf98a22248c57ff05e.webp"
"MediaSize" => 79829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29131516/thumbnail-f46171b5b2046faf98a22248c57ff05e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40789849"
"ResourceRecordKey" => "29131516"
"ModificationTimestamp" => "2025-11-24T17:09:13.11Z"
]
]
+"Member": array:1 [
0 => array:20 [
"MemberFullName" => "Joe Cosentino"
"MemberFirstName" => "Joe"
"MemberLastName" => "Cosentino"
"MemberMlsId" => "HBCOSENJO2"
"OriginatingSystemName" => 26
"MemberKey" => "1523944"
"ModificationTimestamp" => "2025-10-28T23:14:16Z"
"MemberStatus" => "Active"
"OfficeKey" => "291472"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"JobTitle" => "Salesperson"
"MemberCity" => "HAMILTON"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-574-4600"
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1063914"
"OfficeNationalAssociationId" => "1398404"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Royal LePage State Realty Inc."
"OfficePhone" => "905-574-4600"
"OfficeMlsId" => "HBRLPSTATERS"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "291472"
"ModificationTimestamp" => "2025-07-09T19:37:07Z"
"OfficeAddress1" => "987 Rymal Road Suite 100"
"OfficeCity" => "HAMILTON"
"OfficePostalCode" => "L8W3M"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-10-05T19:41:00Z"
"OfficeNationalAssociationId" => "1398404"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1063185"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29131516')"
+"ID": "443152"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 291472/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291472&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291472/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291472&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25469
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25471
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage State Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-574-4600"
+"OfficeMlsId": "HBRLPSTATERS"
+"ModificationTimestamp": "2025-07-09T19:37:07Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "291472"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "987 Rymal Road Suite 100"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "HAMILTON"
+"OfficePostalCode": "L8W3M"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1398404"
+"OriginalEntryTimestamp": "2021-10-05T19:41:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439684"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "291472"
"SocialMediaUrlOrId" => "https://www.royallepagestate.ca/"
"ModificationTimestamp" => "2025-07-09T19:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1063185"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('291472')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1523944/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1523944&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1523944/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1523944&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25474
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29131516" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25090
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29131516/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29131516&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29131516/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29131516&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25070
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29131516 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.589464 43.4895367)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29131516 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.589464 43.4895367)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29131516 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.589464 43.4895367)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29131516 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.589464 43.4895367)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25007
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25024
+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 [
"RoomKey" => "1549995568"
"RoomType" => "Bedroom"
"ListingId" => "40791354"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.19Z"
]
2 => array:11 [
"RoomKey" => "1549995569"
"RoomType" => "Bedroom"
"ListingId" => "40791354"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "19'9'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.19Z"
]
3 => array:11 [
"RoomKey" => "1549995570"
"RoomType" => "Family room"
"ListingId" => "40791354"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "18'6'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.19Z"
]
4 => array:11 [
"RoomKey" => "1549995571"
"RoomType" => "4pc Bathroom"
"ListingId" => "40791354"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.19Z"
]
5 => array:11 [
"RoomKey" => "1549995572"
"RoomType" => "Bedroom"
"ListingId" => "40791354"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.19Z"
]
6 => array:11 [
"RoomKey" => "1549995573"
"RoomType" => "Bedroom"
"ListingId" => "40791354"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.19Z"
]
7 => array:11 [
"RoomKey" => "1549995574"
"RoomType" => "Sunroom"
"ListingId" => "40791354"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.19Z"
]
8 => array:11 [
"RoomKey" => "1549995575"
"RoomType" => "Laundry room"
"ListingId" => "40791354"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.2Z"
]
9 => array:11 [
"RoomKey" => "1549995576"
"RoomType" => "2pc Bathroom"
"ListingId" => "40791354"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.2Z"
]
10 => array:11 [
"RoomKey" => "1549995577"
"RoomType" => "5pc Bathroom"
"ListingId" => "40791354"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.2Z"
]
11 => array:11 [
"RoomKey" => "1549995578"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791354"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.2Z"
]
12 => array:11 [
"RoomKey" => "1549995579"
"RoomType" => "Dining room"
"ListingId" => "40791354"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.2Z"
]
13 => array:11 [
"RoomKey" => "1549995580"
"RoomType" => "Great room"
"ListingId" => "40791354"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.2Z"
]
14 => array:11 [
"RoomKey" => "1549995581"
"RoomType" => "Kitchen"
"ListingId" => "40791354"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29179504"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 19'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-16T18:29:39.2Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6364105547"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179504/22f761b1d70938064d0e904459c025a5.webp"
"MediaSize" => 154193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179504/thumbnail-22f761b1d70938064d0e904459c025a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front facade featuring brick siding and an attached garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791354"
"ResourceRecordKey" => "29179504"
"ModificationTimestamp" => "2025-12-11T15:11:09.16Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6364105564"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179504/f2eba62f1c1f0ccb42674cc5c08a7462.webp"
"MediaSize" => 143883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179504/thumbnail-f2eba62f1c1f0ccb42674cc5c08a7462.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of snowy aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791354"
"ResourceRecordKey" => "29179504"
"ModificationTimestamp" => "2025-12-11T15:11:10.46Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6364105583"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179504/b79c8ce937c78c835558cc465d1127db.webp"
"MediaSize" => 139012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179504/thumbnail-b79c8ce937c78c835558cc465d1127db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of snowy aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791354"
"ResourceRecordKey" => "29179504"
"ModificationTimestamp" => "2025-12-11T15:11:10.46Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6364105597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179504/76440d7bd2cd0a5744e8e70efa52e2e3.webp"
"MediaSize" => 137843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179504/thumbnail-76440d7bd2cd0a5744e8e70efa52e2e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of snowy aerial view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791354"
"ResourceRecordKey" => "29179504"
"ModificationTimestamp" => "2025-12-11T15:11:11Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6364105624"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179504/56b29a6bd2ca82be565b6fb4e49cc77e.webp"
"MediaSize" => 130775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179504/thumbnail-56b29a6bd2ca82be565b6fb4e49cc77e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of property featuring a garage and brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791354"
"ResourceRecordKey" => "29179504"
"ModificationTimestamp" => "2025-12-11T15:11:10.2Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6364105684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179504/6873798cb7924e94cd3fd6bfc0d0fe84.webp"
"MediaSize" => 152867
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29179504/thumbnail-6873798cb7924e94cd3fd6bfc0d0fe84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front facade featuring stone siding and a garage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791354"
"ResourceRecordKey" => "29179504"
"ModificationTimestamp" => "2025-12-11T15:11:10.46Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6364105705"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29179504/2dc8b89ce4cd2de0e158e07a69f4d7df.webp"
…10
]
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 {#24954
+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 [ …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]
]
+"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 [ …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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29174007')"
+"ID": "471594"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25005
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25023
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25014
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23646
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24993
+post_id: "447626"
+post_author: 1
+"ListingKey": "29141044"
+"ListingId": "40790651"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-27T02:05:04Z"
+"RFModificationTimestamp": "2025-11-27T03:33:23Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2000.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M1"
+"UnparsedAddress": "508 BROOKMILL Crescent, Waterloo, Ontario N2V2M1"
+"Coordinates": array:2 [
0 => -80.5830379
1 => 43.472184
]
+"Latitude": 43.472184
+"Longitude": -80.5830379
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A Rare Find in Laurelwood, Waterloo Nestled on a quiet crescent in one of Waterloos most sought-after family neighbourhoods, this beautifully maintained detached home in Laurelwood is a must-see. Located just steps from top-rated schools Laurel Heights Secondary, Laurelwood P.S., and St. Nicholas and minutes to both Wilfrid Laurier and the University of Waterloo, its ideal for families and professionals alike. Step inside to a warm, functional layout featuring custom built-in storage in the entry, a refreshed 2-piece bath, and garage access. The open-concept main floor impresses with brand-new stainless steel appliances (2022), new countertops, and a central island that flows into a sunlit dining area. The cozy living room boasts custom wall-to-wall bookcases, a fireplace, and large windows leading to a private backyard oasis. The outdoor space is truly special a deep, landscaped lot with mature trees and shrubs offers a peaceful retreat. Enjoy summer evenings on the spacious 20x16 wood deck, perfect for entertaining or unwinding. An 8x12 pine shed provides extra storage or workshop potential. Nature enthusiasts will love being close to Laurel Creek Conservation Area offering trails, swimming, campsites, and picnic spots year-round. Upstairs, the vaulted-ceiling primary bedroom features double closets, while second-floor laundry adds everyday convenience. The finished basement extends the living space with a generous family room and an updated 2-piece bath. With nearly 2,000 sq. ft. of finished living space, 2017 roof, insulated garage, and thoughtful updates throughout, this lovingly cared-for home checks every box. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Central Vacuum - Roughed In"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T03:33:06.839652+00:00"
+"Directions": "Erbsville Rd >Right on Laurelwood Dr > Left on Brookmill Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104716"
+"ListOfficeKey": "292624"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-27T01:59:41Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-27T01:59:40Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "508"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"VirtualTourURLUnbranded": "https://youriguide.com/508_brookmil_cr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …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/29141044/508-brookmill-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2048148"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299917"
+"GeocodeManualYN": true
+"TotalActualRent": 3500
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1560
+"BelowGradeFinishedArea": 440
+"OriginalEntryTimestamp": "2025-11-27T01:59:40.91Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:38 [
0 => array:13 [ …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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29141044')"
+"ID": "447626"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25012
+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"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 69
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]