array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29180081/Property?$select=ALL&$top=20&$filter=ListingKey eq 29180081&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29180081/Property?$select=ALL&$top=20&$filter=ListingKey eq 29180081&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23633
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23635
+post_id: "475745"
+post_author: 1
+"ListingKey": "29180081"
+"ListingId": "X12627206"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T06:31:02Z"
+"RFModificationTimestamp": "2025-12-17T06:35:24Z"
+"ListPrice": 745000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X9"
+"UnparsedAddress": "520 CHABLIS DRIVE, Waterloo, Ontario N2T2X9"
+"Coordinates": array:2 [
0 => -80.5751586
1 => 43.4502041
]
+"Latitude": 43.4502041
+"Longitude": -80.5751586
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 520 Chablis Drive, Waterloo! Located in one of Waterloo's most desirable, family-friendly, calm, and quiet neighborhoods, this beautiful carpet-free home offers exceptional convenience-just minutes to The Boardwalk, Costco, shopping, schools, and all major amenities. The main floor features an open-concept layout with a spacious kitchen, cathedral ceiling in the great room, and a sliding door walkout to the back deck and landscaped backyard. The welcoming front entrance opens into a bright hallway leading to the living room. To the right is a powder room and the kitchen; to the left is a dedicated dining room-perfect for family gatherings and entertaining. The second floor offers 3 bedrooms, including a generous primary bedroom with its own ensuite. Two additional good-sized bedrooms share a full main bathroom. The fully finished basement adds valuable living space with a large recreation room complete with countertop, sink, and cabinetry-ideal for entertaining or extended family. A full bathroom, cold cellar, laundry area, and utility room complete the lower level. Upgrades & Features: Kitchen countertop and island with quartz, interior paint (2023), Washer/Dryer/Stove (2022), Two cooking lines: Hydro/Gas, Air Conditioner (2022), Water Softener (2022), Furnace (2018), Roof (2017), Concrete driveway (2024), Properly insulated cold room. Garage door remote sold as is. A wonderful opportunity to own a well-maintained home in a prime Waterloo location! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T19:19:16.442127+00:00"
+"Directions": "Cross Streets: Erbsville Rd/Chablis Dr. ** Directions: Erbsville Road to Chablis Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2136085"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Carpet Free"
]
+"LotSizeDimensions": "28 x 105 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T16:54:21Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T06:17:21Z"
+"Stories": "2.0"
+"StreetName": "Chablis"
+"StreetNumber": "520"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4261"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1550290849"
"RoomType" => "Kitchen"
"ListingId" => "X12627206"
"RoomLevel" => "Main level"
"RoomWidth" => 2.95
"ListingKey" => "29180081"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.32Z"
]
1 => array:11 [
"RoomKey" => "1550290850"
"RoomType" => "Bathroom"
"ListingId" => "X12627206"
"RoomLevel" => "Second level"
"RoomWidth" => 1.52
"ListingKey" => "29180081"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.32Z"
]
2 => array:11 [
"RoomKey" => "1550290851"
"RoomType" => "Dining room"
"ListingId" => "X12627206"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29180081"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.33Z"
]
3 => array:11 [
"RoomKey" => "1550290852"
"RoomType" => "Living room"
"ListingId" => "X12627206"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "29180081"
"RoomLength" => 5.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.33Z"
]
4 => array:11 [
"RoomKey" => "1550290853"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12627206"
"RoomLevel" => "Second level"
"RoomWidth" => 3.63
"ListingKey" => "29180081"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.33Z"
]
5 => array:11 [
"RoomKey" => "1550290854"
"RoomType" => "Bedroom"
"ListingId" => "X12627206"
"RoomLevel" => "Second level"
"RoomWidth" => 2.9
"ListingKey" => "29180081"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.33Z"
]
6 => array:11 [
"RoomKey" => "1550290855"
"RoomType" => "Bedroom"
"ListingId" => "X12627206"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "29180081"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.33Z"
]
7 => array:11 [
"RoomKey" => "1550290856"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12627206"
"RoomLevel" => "Basement"
"RoomWidth" => 4.37
"ListingKey" => "29180081"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.33Z"
]
8 => array:11 [
"RoomKey" => "1550290857"
"RoomType" => "Bathroom"
"ListingId" => "X12627206"
"RoomLevel" => "Basement"
"RoomWidth" => 1.52
"ListingKey" => "29180081"
"RoomLength" => 2.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.33Z"
]
9 => array:11 [
"RoomKey" => "1550290858"
"RoomType" => "Bathroom"
"ListingId" => "X12627206"
"RoomLevel" => "Main level"
"RoomWidth" => 1.5
"ListingKey" => "29180081"
"RoomLength" => 1.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.33Z"
]
10 => array:11 [
"RoomKey" => "1550290859"
"RoomType" => "Bathroom"
"ListingId" => "X12627206"
"RoomLevel" => "Second level"
"RoomWidth" => 1.47
"ListingKey" => "29180081"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-17T06:17:21.33Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29180081/520-chablis-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 28.0
+"OriginalEntryTimestamp": "2025-12-11T16:54:21.42Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:27 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6364276940"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/e6873a29c723853448af4638424504ea.webp"
"MediaSize" => 323046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-e6873a29c723853448af4638424504ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6364276970"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/727cd9372fa9e955bc811fbf920163a9.webp"
"MediaSize" => 138486
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-727cd9372fa9e955bc811fbf920163a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6364277014"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/be92e5b0fd735877efacefc2868841f0.webp"
"MediaSize" => 136883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-be92e5b0fd735877efacefc2868841f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6364277030"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/94717d8391fb5b5d3224425b4613d724.webp"
"MediaSize" => 168377
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-94717d8391fb5b5d3224425b4613d724.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6364277091"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/fe8707f51123bb53bc605713cb8173fc.webp"
"MediaSize" => 247299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-fe8707f51123bb53bc605713cb8173fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6364277152"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/2a27a9fedde31ac1468168df2aa28325.webp"
"MediaSize" => 206224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-2a27a9fedde31ac1468168df2aa28325.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6364277187"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/1a52cb0c786eb87e3b0874ea50bb80c6.webp"
"MediaSize" => 233080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-1a52cb0c786eb87e3b0874ea50bb80c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6364277244"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/00567f6003d52c96579d69158eceb2d4.webp"
"MediaSize" => 180049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-00567f6003d52c96579d69158eceb2d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6364277255"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/02804ff6fd784f33b23c3af5029b5ca4.webp"
"MediaSize" => 296344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-02804ff6fd784f33b23c3af5029b5ca4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6364277265"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/b7becfb0b05f945d98416c751792d290.webp"
"MediaSize" => 169062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-b7becfb0b05f945d98416c751792d290.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6364277307"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/42d3ac38f4809c8959645749a4aac5e6.webp"
"MediaSize" => 62900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-42d3ac38f4809c8959645749a4aac5e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6364277312"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/872cbee616cfb296862c68d0c0701627.webp"
"MediaSize" => 82324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-872cbee616cfb296862c68d0c0701627.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6364277346"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/8138df53f276947649ecb32861ff354d.webp"
"MediaSize" => 295655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-8138df53f276947649ecb32861ff354d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6364277375"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/576e4e3a0943e79ad0d37e74f0f5fb82.webp"
"MediaSize" => 261410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-576e4e3a0943e79ad0d37e74f0f5fb82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6364277412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/3081bf887986fb1c5b7f7c6d297d167a.webp"
"MediaSize" => 172295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-3081bf887986fb1c5b7f7c6d297d167a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6364277436"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/156d0a9236c0dab8feca10bff65c708b.webp"
"MediaSize" => 107362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-156d0a9236c0dab8feca10bff65c708b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6364277464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/a003172935e40acf2d2acfe47fb2a437.webp"
"MediaSize" => 234854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-a003172935e40acf2d2acfe47fb2a437.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6364277504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/2be9b612d8848c525a2c1e838a90ec29.webp"
"MediaSize" => 123489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-2be9b612d8848c525a2c1e838a90ec29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6364277545"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/8434466c9701af48210db87566367734.webp"
"MediaSize" => 87184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-8434466c9701af48210db87566367734.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6364277554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/d9b93777640f39a7aa52579ff7a7f855.webp"
"MediaSize" => 102213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-d9b93777640f39a7aa52579ff7a7f855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6364277597"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/54fe7cdfbc0f598734007ffeb454c154.webp"
"MediaSize" => 163491
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-54fe7cdfbc0f598734007ffeb454c154.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6364277621"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/d1a7ad6538ceb233f4c2b9f4959acf53.webp"
"MediaSize" => 140804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-d1a7ad6538ceb233f4c2b9f4959acf53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6364277642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/68ff48ec5c230b21768d2cf7e95de6bd.webp"
"MediaSize" => 136980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-68ff48ec5c230b21768d2cf7e95de6bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6364277682"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/1cd462e19d53d7e431f65ac010fc4d1d.webp"
"MediaSize" => 169088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-1cd462e19d53d7e431f65ac010fc4d1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6364277712"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/2c75a06668b2673cca883070d8449505.webp"
"MediaSize" => 223580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-2c75a06668b2673cca883070d8449505.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6364277727"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/23615d9694a4e67329404e11b10b3c16.webp"
"MediaSize" => 118398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-23615d9694a4e67329404e11b10b3c16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6364277755"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29180081/d6fec1775ad4a8ce2c9389e145845848.webp"
"MediaSize" => 295782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29180081/thumbnail-d6fec1775ad4a8ce2c9389e145845848.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12627206"
"ResourceRecordKey" => "29180081"
"ModificationTimestamp" => "2025-12-11T16:54:21.43Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "MD HASAN IMAM"
"MemberFirstName" => "MD HASAN"
"MemberLastName" => "IMAM"
"MemberMlsId" => "9608428"
"OriginatingSystemName" => 26
"MemberKey" => "2136085"
"ModificationTimestamp" => "2025-12-15T10:01:44Z"
"MemberStatus" => "Active"
"OfficeKey" => "288578"
"MemberAOR" => "Toronto"
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:2 [ …2]
"MemberOfficePhone" => "647-707-6088"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2021-06-01T21:38:00Z"
"MemberNationalAssociationId" => "1388344"
"OfficeNationalAssociationId" => "1369645"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "RE/MAX TWIN CITY REALTY INC."
"OfficePhone" => "519-579-4110"
"OfficeMlsId" => "360900"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "288578"
"ModificationTimestamp" => "2025-06-17T20:58:11Z"
"OfficeAddress1" => "901 VICTORIA STREET N UNIT B"
"OfficeCity" => "KITCHENER"
"OfficePostalCode" => "N2B3C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2020-09-17T17:39:00Z"
"OfficeNationalAssociationId" => "1369645"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1369644"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29180081')"
+"ID": "475745"
}
]
+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 288578/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288578&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288578/Office?$select=ALL&$top=10&$filter=OfficeKey eq 288578&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25456
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25458
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX TWIN CITY REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "519-579-4110"
+"OfficeMlsId": "360900"
+"ModificationTimestamp": "2025-06-17T20:58:11Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "288578"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "901 VICTORIA STREET N UNIT B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KITCHENER"
+"OfficePostalCode": "N2B3C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1369645"
+"OriginalEntryTimestamp": "2020-09-17T17:39:00Z"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "318561"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "288578"
"SocialMediaUrlOrId" => "http://www.remaxtwincity.com/"
"ModificationTimestamp" => "2025-06-17T19:05:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1369644"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('288578')"
}
]
+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 2136085/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2136085&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2136085/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2136085&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25461
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29180081" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25089
+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 29180081/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29180081&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29180081/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29180081&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25069
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29180081 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5751586 43.4502041)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29180081 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5751586 43.4502041)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29180081 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5751586 43.4502041)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29180081 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5751586 43.4502041)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24990
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "482743"
+post_author: 1
+"ListingKey": "29186814"
+"ListingId": "40793908"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T17:35:20Z"
+"RFModificationTimestamp": "2025-12-15T17:47:52Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 750.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y2"
+"UnparsedAddress": "641 FRIEBURG Drive Unit# Lower, Waterloo, Ontario N2T2Y2"
+"Coordinates": array:2 [
0 => -80.5799905
1 => 43.4554446
]
+"Latitude": 43.4554446
+"Longitude": -80.5799905
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new Waterloo home in Clair Hills! This bright, spacious, and beautifully maintained 1-bedroom apartment offers over 750 sq ft of comfortable living, tons of built-in storage, and a private entrance for complete independence and quiet living. With warm maple cabinetry, a full dine-in kitchen, front-loading LG washer/dryer, a corner gas fireplace, and an updated bathroom with a glass shower, this unit has everything a professional or graduate student needs. Rent: $1,800/month (All Inclusive) Includes: Heat, Hydro, Water Unit Features Private/separate entrance Bright living area with corner fireplace Large dine-in kitchen with: Maple cabinets Dishwasher Full-size fridge & stove LG front-loader washer & dryer Spacious bedroom with double closet Bathroom with glass corner shower Tons of built-in storage for skis, bikes, gear, etc. Oversized windows with blinds Parking for one car Water softener Space for an outdoor propane BBQ Location – Clair Hills (Waterloo) Perfect for professionals or grad students: 5-min walk to Bus Routes 13 & 29 5-min drive to UW, Costco, Boardwalk Shopping Centre 10-min drive to WLU 15-min walk to Shoppers, Tims, Winners, Dutchie’s Grocery, Canadian Tire & more Quick access to beautiful walking, biking & hiking trails 10 minutes to HydroCut bike trails Availability: January 1/ February 1st 2026 Lease: 1 year Requirements: Credit & references, tenant insurance Occupants: Professionals or graduate students preferred Pets/Smoking: Not permitted Outdoor Space: No separate private yard ***see sales brochure below for showing instructions***** (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2025-12-15T17:47:28.445888+00:00"
+"Directions": "Off of Keatsway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834563"
+"ListOfficeKey": "300202"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-12-15T17:29:41Z"
+"PhotosCount": 9
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T17:29:41Z"
+"Stories": "1.0"
+"StreetName": "FRIEBURG"
+"StreetNumber": "641"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1549475518"
"RoomType" => "3pc Bathroom"
"ListingId" => "40793908"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29186814"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T17:29:41.47Z"
]
1 => array:11 [
"RoomKey" => "1549475519"
"RoomType" => "Bedroom"
"ListingId" => "40793908"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29186814"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T17:29:41.48Z"
]
2 => array:11 [
"RoomKey" => "1549475520"
"RoomType" => "Kitchen"
"ListingId" => "40793908"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29186814"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T17:29:41.49Z"
]
3 => array:11 [
"RoomKey" => "1549475521"
"RoomType" => "Living room"
"ListingId" => "40793908"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29186814"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-15T17:29:41.5Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29186814/641-frieburg-drive-unit-lower-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1800
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 0
+"BelowGradeFinishedArea": 750
+"OriginalEntryTimestamp": "2025-12-15T17:29:41.27Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:9 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6370339491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186814/804d958eec58f8f9f8a7a5dea094aed1.webp"
"MediaSize" => 24566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186814/thumbnail-804d958eec58f8f9f8a7a5dea094aed1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom with a closet and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793908"
"ResourceRecordKey" => "29186814"
"ModificationTimestamp" => "2025-12-15T17:29:41.29Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6370339500"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186814/207b0a97237575a3519408a54a922cdd.webp"
"MediaSize" => 46523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186814/thumbnail-207b0a97237575a3519408a54a922cdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Corridor featuring light wood-style floors and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793908"
"ResourceRecordKey" => "29186814"
"ModificationTimestamp" => "2025-12-15T17:29:41.29Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6370339504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186814/23879531f2f32aa14302246d9955859e.webp"
"MediaSize" => 33105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186814/thumbnail-23879531f2f32aa14302246d9955859e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white appliances, stacked washer and clothes dryer, light wood-style flooring, light brown cabinetry, and range hood"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40793908"
"ResourceRecordKey" => "29186814"
"ModificationTimestamp" => "2025-12-15T17:29:41.29Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6370339511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186814/226224a0f7dbc197b9e3504edb5edc39.webp"
"MediaSize" => 19821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186814/thumbnail-226224a0f7dbc197b9e3504edb5edc39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room with a textured ceiling and light wood-style flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793908"
"ResourceRecordKey" => "29186814"
"ModificationTimestamp" => "2025-12-15T17:29:41.29Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6370339515"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186814/74de11574458c49c982fbfcec90cae47.webp"
"MediaSize" => 45163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186814/thumbnail-74de11574458c49c982fbfcec90cae47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement featuring a glass covered fireplace, light wood-type flooring, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793908"
"ResourceRecordKey" => "29186814"
"ModificationTimestamp" => "2025-12-15T17:29:41.29Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6370339524"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186814/e060dae57c9199c2674cce0d795997c7.webp"
"MediaSize" => 30646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186814/thumbnail-e060dae57c9199c2674cce0d795997c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom with vanity, a shower stall, and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793908"
"ResourceRecordKey" => "29186814"
"ModificationTimestamp" => "2025-12-15T17:29:41.29Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6370339534"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186814/3cb9f26d68339084de37a85e3f6b56cd.webp"
"MediaSize" => 20514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186814/thumbnail-3cb9f26d68339084de37a85e3f6b56cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway with a textured ceiling and light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793908"
"ResourceRecordKey" => "29186814"
"ModificationTimestamp" => "2025-12-15T17:29:41.29Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6370339540"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186814/2f98f9ae8f8784d7c05000df45f5e766.webp"
"MediaSize" => 23389
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186814/thumbnail-2f98f9ae8f8784d7c05000df45f5e766.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Empty room with a textured ceiling, light wood finished floors, and rail lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793908"
"ResourceRecordKey" => "29186814"
"ModificationTimestamp" => "2025-12-15T17:29:41.29Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6370339549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29186814/81512c8514875a410b662abcdabbe8a2.webp"
"MediaSize" => 30820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29186814/thumbnail-81512c8514875a410b662abcdabbe8a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white appliances, dark countertops, light wood finished floors, and washer / dryer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793908"
"ResourceRecordKey" => "29186814"
"ModificationTimestamp" => "2025-12-15T17:29:41.29Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "Corry Van Iersel"
"MemberFirstName" => "Corry"
"MemberLastName" => "Van Iersel"
"MemberMlsId" => "CA5984"
"OriginatingSystemName" => 26
"MemberKey" => "1834563"
"ModificationTimestamp" => "2025-10-28T23:28:48Z"
"MemberMiddleName" => "Christopher"
"MemberStatus" => "Active"
"OfficeKey" => "300202"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Broker of Record"
"MemberCity" => "Cambridge"
"MemberType" => "Broker"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "519-242-0277"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2009-04-07T20:41:00Z"
"MemberNationalAssociationId" => "1196776"
"OfficeNationalAssociationId" => "1484182"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "Vancor Realty Inc."
"OfficePhone" => "519-242-0277"
"OfficeMlsId" => "WR50949"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "300202"
"ModificationTimestamp" => "2025-11-21T15:46:40Z"
"OfficeAddress1" => "1425 Bishop St. N. Unit 1"
"OfficeCity" => "Cambridge"
"OfficePostalCode" => "N1R6J"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2025-06-16T18:10:00Z"
"OfficeNationalAssociationId" => "1484182"
"OfficeBrokerNationalAssociationId" => "1196776"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29186814')"
+"ID": "482743"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24903
+post_id: "477277"
+post_author: 1
+"ListingKey": "29182622"
+"ListingId": "40793443"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T18:55:15Z"
+"RFModificationTimestamp": "2025-12-12T18:57:59Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1216.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K8"
+"UnparsedAddress": "621 PINEROW Crescent Unit# A, Waterloo, Ontario N2T2K8"
+"Coordinates": array:2 [
0 => -80.5684805
1 => 43.4486279
]
+"Latitude": 43.4486279
+"Longitude": -80.5684805
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "What a fantastic Christmas present for YOU! This smartly updated and lovingly maintained semi-detached home would look great in your stocking. Street appeal ++ with a rarely found Cape Cod exterior giving 2 of your upper bedrooms so much character with their dormers! Located on a quiet Crescent in popular Beechwood West and featuring a deep, fully fenced lot (with shed) and a sliding walkout from the living room to an elevated sundeck! The upper level offers 3 generous sized bedrooms and a fully renovated (2020) 4 piece bathroom highlighted by the deep, acrylic soaker bathtub, raindrop shower head, Subway tile tub/shower finish and a duo-flush water closet. All bedrooms have dark, laminate flooring! The main floor offers a combination living room/dining room with laminate floors and a bright functional kitchen appointed with oak cabinets, glass/ceramic tile backsplash, a 2 door pantry cabinet, an over the range microwave oven and a double door stainless steel fridge with water and ice dispenser. The lower level was completely gutted and rebuilt in 2019 too! Here you will find a large recreation room with grey vinyl flooring, a remodeled 2 piece bathroom and a spacious utility/laundry room. The laundry room has a convenient folding counter. Here is a list of some of the updates and extras! A natural gas hook up on the deck for your BBQ, 4 appliances included, (2016) replacement windows in the kitchen and patio door, deck boards and railing (2019), water softener (2020) and roof shingles in 2025. You can't go wrong by making this house YOUR home in 2026! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T17:19:38.535226+00:00"
+"Directions": "RUMMELHARDT TO PINEROW CR"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563599"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2025-12-12T18:01:30Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T18:38:30Z"
+"Stories": "2.0"
+"StreetName": "PINEROW"
+"StreetNumber": "621"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3632"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1547986833"
"RoomType" => "Living room"
"ListingId" => "40793443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "17'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.76Z"
]
1 => array:11 [
"RoomKey" => "1547986834"
"RoomType" => "Recreation room"
"ListingId" => "40793443"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.76Z"
]
2 => array:11 [
"RoomKey" => "1547986835"
"RoomType" => "2pc Bathroom"
"ListingId" => "40793443"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "6'1'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.76Z"
]
3 => array:11 [
"RoomKey" => "1547986836"
"RoomType" => "Laundry room"
"ListingId" => "40793443"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.76Z"
]
4 => array:11 [
"RoomKey" => "1547986837"
"RoomType" => "4pc Bathroom"
"ListingId" => "40793443"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "5'0'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.76Z"
]
5 => array:11 [
"RoomKey" => "1547986838"
"RoomType" => "Bedroom"
"ListingId" => "40793443"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.76Z"
]
6 => array:11 [
"RoomKey" => "1547986839"
"RoomType" => "Bedroom"
"ListingId" => "40793443"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.76Z"
]
7 => array:11 [
"RoomKey" => "1547986840"
"RoomType" => "Primary Bedroom"
"ListingId" => "40793443"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.76Z"
]
8 => array:11 [
"RoomKey" => "1547986841"
"RoomType" => "Dining room"
"ListingId" => "40793443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.77Z"
]
9 => array:11 [
"RoomKey" => "1547986842"
"RoomType" => "Kitchen"
"ListingId" => "40793443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29182622"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-12T18:38:30.77Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29182622/621-pinerow-crescent-unit-a-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1216
+"OriginalEntryTimestamp": "2025-12-12T16:19:14.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6365893406"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182622/c2304e4a91ea46880aa9d32aa45c634d.webp"
"MediaSize" => 147638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182622/thumbnail-c2304e4a91ea46880aa9d32aa45c634d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40793443"
"ResourceRecordKey" => "29182622"
"ModificationTimestamp" => "2025-12-12T16:19:14.11Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6365893443"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182622/0b1459a206fe89fe44cd0e0b7b59d8a1.webp"
"MediaSize" => 134827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182622/thumbnail-0b1459a206fe89fe44cd0e0b7b59d8a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793443"
"ResourceRecordKey" => "29182622"
"ModificationTimestamp" => "2025-12-12T16:19:14.11Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6365893496"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182622/cb3dd5d2865a838cd7e8e662377be654.webp"
"MediaSize" => 148987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182622/thumbnail-cb3dd5d2865a838cd7e8e662377be654.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793443"
"ResourceRecordKey" => "29182622"
"ModificationTimestamp" => "2025-12-12T16:19:14.11Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6365893556"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182622/846113dab9dd12228934cbbec640d675.webp"
"MediaSize" => 130541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182622/thumbnail-846113dab9dd12228934cbbec640d675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40793443"
"ResourceRecordKey" => "29182622"
"ModificationTimestamp" => "2025-12-12T16:19:14.11Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6365893596"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29182622/45b88d41ed697d34e622c124278e4fcd.webp"
"MediaSize" => 118046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29182622/thumbnail-45b88d41ed697d34e622c124278e4fcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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('29182622')"
+"ID": "477277"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25000
+post_id: "476555"
+post_author: 1
+"ListingKey": "29181658"
+"ListingId": "X12628714"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-15T13:31:02Z"
+"RFModificationTimestamp": "2025-12-15T13:33:29Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864391
1 => 43.4620608
]
+"Latitude": 43.4620608
+"Longitude": -80.5864391
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "IF THIS IS YOUR TIME TO DOWNSIZE, THIS IS YOUR HOUSE. A Rare Opportunity Come and see this Home before its gone! If you've been searching for the perfect retirement bungalow, this is the one people remember for years - the one that "got away." A modern-built, freehold bungalow (yes, no condo fees) with a walkout basement and a million-dollar pond view in Waterloo's prestigious Rosewood/Clair Hills community. Homes like this almost never come to market, and with the neighbourhood fully built out, finding another one like it may soon be impossible. Designed for effortless, comfortable living, this 2+1 bedroom, 3-bath walkout bungalow offers nearly 2,000 sq. ft. of beautifully finished space. Freshly painted with brand-new carpet, it's fully move-in ready - the perfect option for anyone looking to simplify without compromising quality. The open-concept main floor features maple hardwood, ceramic tile, & seamless access to a raised deck with glass railings overlooking the tranquil Rosewood Pond - a protected view that can't be duplicated today. The primary suite faces the water & includes a private 4-piece en-suite, while the second bedroom with a built-in Murphy bed easily doubles as a guest room or home office. The bright walkout basement expands your living space with oversized windows, a cozy gas fireplace, & direct yard access for peaceful mornings by the water. A third bedroom with en-suite privileges and a generous storage area complete the lower level. Thoughtfully built with long-term comfort in mind, this home includes widened doorways, lowered switches, updated mechanicals, a double garage, and a quiet, low-traffic street - exactly what downsizers value most. This is the ideal combination: one-floor living, serene natural surroundings, no condo fees, minimal maintenance, & a view to die for. Opportunities like this simply do not come twice. Welcome to Rosewood Estates - a truly irreplaceable home. IT COULD BE YEARS BEFORE ANOTHER ONE COMES ALONG. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water meter"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-12T00:43:51.399784+00:00"
+"Directions": "Cross Streets: Columbia St. W. ** Directions: Columbia to Salzburg Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T23:54:34Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-15T13:26:05Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5446"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "http://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29181658/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2025-12-11T23:54:34.64Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29181658')"
+"ID": "476555"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25004
+post_id: "476346"
+post_author: 1
+"ListingKey": "29181381"
+"ListingId": "40793071"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-14T21:40:51Z"
+"RFModificationTimestamp": "2025-12-14T21:44:55Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1983.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG Drive, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864356
1 => 43.4620435
]
+"Latitude": 43.4620435
+"Longitude": -80.5864356
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IF THIS IS YOUR TIME TO DOWNSIZE, THIS IS YOUR HOUSE. A Rare Opportunity Come and see this Home before its gone! If you’ve been searching for the perfect retirement bungalow, this is the one people remember for years — the one that “got away.” A modern-built, freehold bungalow (yes, no condo fees) with a walkout basement and a million-dollar pond view in Waterloo’s prestigious Rosewood/Clair Hills community. Homes like this almost never come to market, and with the neighbourhood fully built out, finding another one like it may soon be impossible. Designed for effortless, comfortable living, this 2+1 bedroom, 3-bath walkout bungalow offers nearly 2,000 sq. ft. of beautifully finished space. Freshly painted with brand-new carpet, it’s fully move-in ready — the perfect option for anyone looking to simplify without compromising quality. The open-concept main floor features maple hardwood, ceramic tile, & seamless access to a raised deck with glass railings overlooking the tranquil Rosewood Pond — a protected view that can’t be duplicated today. The primary suite faces the water & includes a private 4-piece en-suite, while the second bedroom with a built-in Murphy bed easily doubles as a guest room or home office. The bright walkout basement expands your living space with oversized windows, a cozy gas fireplace, & direct yard access for peaceful mornings by the water. A third bedroom with en-suite privileges and a generous storage area complete the lower level. Thoughtfully built with long-term comfort in mind, this home includes widened doorways, lowered switches, updated mechanicals, a double garage, and a quiet, low-traffic street — exactly what downsizers value most. This is the ideal combination: one-floor living, serene natural surroundings, no condo fees, minimal maintenance, & a view to die for. Opportunities like this simply do not come twice. Welcome to Rosewood Estates — a truly irreplaceable home. IT COULD BE YEARS BEFORE ANOTHER ONE COMES ALONG. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T22:50:59.185685+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T22:29:37Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-14T21:29:59Z"
+"Stories": "1.0"
+"StreetName": "SALZBURG"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5446"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29181381/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2025-12-11T22:29:37.47Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"Media": array:49 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29181381')"
+"ID": "476346"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24929
+post_id: "475035"
+post_author: 1
+"ListingKey": "29179351"
+"ListingId": "40793332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-17T06:40:26Z"
+"RFModificationTimestamp": "2025-12-17T06:44:21Z"
+"ListPrice": 745000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2161.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X9"
+"UnparsedAddress": "520 CHABLIS Drive, Waterloo, Ontario N2T2X9"
+"Coordinates": array:2 [
0 => -80.5751473
1 => 43.4502056
]
+"Latitude": 43.4502056
+"Longitude": -80.5751473
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 520 Chablis Drive, Waterloo! Located in one of Waterloo’s most desirable, family-friendly, calm, and quiet neighborhoods, this beautiful carpet-free home offers exceptional convenience—just minutes to The Boardwalk, Costco, shopping, schools, and all major amenities. The main floor features an open-concept layout with a spacious kitchen, cathedral ceiling in the great room, and a sliding door walkout to the back deck and landscaped backyard. The welcoming front entrance opens into a bright hallway leading to the living room. To the right is a powder room and the kitchen; to the left is a dedicated dining room—perfect for family gatherings and entertaining. The second floor offers 3 bedrooms, including a generous primary bedroom with its own ensuite. Two additional good-sized bedrooms share a full main bathroom. The fully finished basement adds valuable living space with a large recreation room complete with countertop, sink, and cabinetry—ideal for entertaining or extended family. A full bathroom, cold cellar, laundry area, and utility room complete the lower level. Upgrades & Features: Kitchen countertop and island with quartz, interior paint (2023), Washer/Dryer/Stove (2022), Two cooking lines: Hydro/Gas, Air Conditioner (2022), Water Softener (2022), Furnace (2018), Roof (2017), Concrete driveway (2024), Properly insulated cold room. Garage door remote sold as is. A wonderful opportunity to own a well-maintained home in a prime Waterloo location! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-11T06:41:47.676088+00:00"
+"Directions": "Erbsville Road to Chablis Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2062546"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-11T06:08:20Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-17T06:29:29Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "520"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4261"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"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/29179351/520-chablis-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1448
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2025-12-11T06:08:20.17Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:27 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29179351')"
+"ID": "475035"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: "474317"
+post_author: 1
+"ListingKey": "29178457"
+"ListingId": "X12616732"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-10T22:05:16Z"
+"RFModificationTimestamp": "2025-12-10T22:34:27Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 4
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0B7"
+"UnparsedAddress": "22 - 435 WINCHESTER DRIVE, Waterloo, Ontario N2T0B7"
+"Coordinates": array:2 [
0 => -80.561888
1 => 43.452439
]
+"Latitude": 43.452439
+"Longitude": -80.561888
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "DISCOVER LIFE IN THE VILLAGE. A rare executive townhome with over 3,100 sqft. of beautifully finished living space, offering privacy and convenience in a quiet enclave ideal for retirees, or busy professionals. The home makes a strong first impression with its attached double garage and meticulous curb appeal. Inside, you're greeted by an open concept main floor with a bright kitchen featuring granite countertops and ample cabinetry, a welcoming dining area and a living room with a cozy gas fireplace. Large windows fill the space with natural light and provide clear views of McCrae Park. A convenient 2 piece bathroom completes this level. Upstairs, a versatile family room provides additional living space or a dedicated office. The primary bedroom includes a walk-in closet and a luxurious 5 piece ensuite. The second bedroom also features its own walk-in closet and a 4 piece ensuite. The laundry room completes the upper level. The fully finished basement offers a large recreation room and a full 4 piece bathroom. Outside, enjoy a private patio area with a gas BBQ hookup. Living in Beechwood means enjoying one of Waterloo's most desirable and peaceful neighbourhoods, with nearby amenities, top rated schools and quick access to Uptown Waterloo. Homes in The Village rarely come to market, so this is an opportunity not to be missed. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"AssociationFee": "617.18"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 4
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-10T22:34:05.078153+00:00"
+"Directions": "Cross Streets: Fischer-Hallman Road. ** Directions: Fischer-Hallman Road to Winchester Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093834"
+"ListOfficeKey": "294392"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
]
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2025-12-10T21:55:53Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-10T21:55:53Z"
+"Stories": "2.0"
+"StreetName": "Winchester"
+"StreetNumber": "435"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8111.22"
+"VirtualTourURLUnbranded": "https://youriguide.com/435_winchester_dr_waterloo_on/"
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29178457/22-435-winchester-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2249
+"LivingAreaMinimum": 2000
+"ZoningDescription": "G"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-12-10T21:55:53.48Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29178457')"
+"ID": "474317"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23647
+post_id: "470664"
+post_author: 1
+"ListingKey": "29173617"
+"ListingId": "X12612020"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T15:25:41Z"
+"RFModificationTimestamp": "2025-12-09T16:59:19Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "1 - 433 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.557083
1 => 43.458011
]
+"Latitude": 43.458011
+"Longitude": -80.557083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bedrooms available for lease in this beautiful and Cozy End-Unit Townhouse In Desirable Beechwood! List Price is price for each room, including utilities and internet, please contact for details. Main Floor Features A Large, Comfortable Living Space And Newer Kitchen Appliances. Student Welcome, landlord considers short term lease too. (id:62650)"
+"Basement": array:4 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T16:59:14.953589+00:00"
+"Directions": "Cross Streets: Keats Way And Fischer Hallman. ** Directions: Google Map."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091671"
+"ListOfficeKey": "289061"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Carport"
]
+"PhotosChangeTimestamp": "2025-12-09T15:17:20Z"
+"PhotosCount": 7
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T15:17:20Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "433"
+"StreetSuffix": "Way"
+"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/29173617/1-433-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"TotalActualRent": 750
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-09T15:17:20.94Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:7 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173617')"
+"ID": "470664"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24931
+post_id: "468798"
+post_author: 1
+"ListingKey": "29171100"
+"ListingId": "40792839"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-14T21:40:50Z"
+"RFModificationTimestamp": "2025-12-14T21:44:56Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2768.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N6"
+"UnparsedAddress": "368 CAVENDISH Drive, Waterloo, Ontario N2T2N6"
+"Coordinates": array:2 [
0 => -80.5770067
1 => 43.4642492
]
+"Latitude": 43.4642492
+"Longitude": -80.5770067
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "**Located in Prestigious LAURELWOOD! This beautiful, renovated home offers over 2,750 sq. ft. of above grade finished area! **WALKOUT BASEMENT and massive rear and side yard (0.222-acre lot) surrounded by mature trees. **The main floor has an updated kitchen, subway tile backsplash, quartz countertops, plenty of cupboard space, large island and Kitchen Aid appliances are included. **Living room features custom built-ins, hardwood floors and 24 LED pot lights on the main level. **Main floor laundry and mudroom with access to the double garage. **Second level Primary bedroom with recessed ceilings, updated Ensuite with double sink, freestanding tub, and walk-in closet. **Updated main bathroom with soaker tub along with 2 additional generous size bedrooms, and skylight in the hallway. **Finished walkout basement with recreation room, 4th bedroom, 3-piece bathroom, tons of windows and sliding door to the rear yard! **Other features include roof replaced with 40-year shingles (2025), Concrete driveway (2020), Garage door (2019), 2-tier deck off the Kitchen, Shed with concrete pad (2020), Freshly painted (2025), upstairs carpets (2025) and fenced yard. **Located in the family-friendly Laurelwood neighbourhood surrounded by highly rated schools, parks including the Laurel Creek Conservation Area, and many biking/walking trails. Walking distance to Trillium Valley Park and Chancery Lane Trail. Just minutes away from the University of Waterloo Campus. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "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-08T17:50:11.594469+00:00"
+"Directions": "Columbia St. to Cavendish Dr."
+"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": "1563803"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T17:28:59Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-14T21:30:06Z"
+"Stories": "2.0"
+"StreetName": "CAVENDISH"
+"StreetNumber": "368"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6096"
+"VirtualTourURLUnbranded": "https://youriguide.com/5mptk_368_cavendish_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29171100/368-cavendish-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 112.0
+"AboveGradeFinishedArea": 1880
+"BelowGradeFinishedArea": 887
+"OriginalEntryTimestamp": "2025-12-08T17:28:58.89Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:49 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29171100')"
+"ID": "468798"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24972
+post_id: "466453"
+post_author: 1
+"ListingKey": "29167696"
+"ListingId": "X12606140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T18:35:56Z"
+"RFModificationTimestamp": "2025-12-09T18:38:36Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W2"
+"UnparsedAddress": "44 - 360 ERBSVILLE ROAD, Waterloo, Ontario N2T2W2"
+"Coordinates": array:2 [
0 => -80.579155
1 => 43.461338
]
+"Latitude": 43.461338
+"Longitude": -80.579155
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Don't miss your chance to join the sought-after 360 Erbsville community! This Executive-style bungalow condo is vacant and move-in ready before the holidays. Enjoy upgraded flooring, a custom kitchen, and an open living area with walkout to a private deck. With interior access to the garage and all exterior maintenance handled - lawn care, snow removal, roofing, and more - you can truly relax and enjoy a carefree lifestyle. The finished lower level offers a large rec room, home office (or 3rd bedroom), and full bath. Prime Waterloo location close to parks, shopping, and transit - an opportunity not to be missed! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "717.44"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T01:29:39.384325+00:00"
+"Directions": "Erbsville Rd. & Columbia St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1903978"
+"ListOfficeKey": "275965"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T18:17:35Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T18:17:35Z"
+"Stories": "1.0"
+"StreetName": "Erbsville"
+"StreetNumber": "360"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4644"
+"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/29167696/44-360-erbsville-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2025-12-05T22:22:15.04Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:35 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29167696')"
+"ID": "466453"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 97
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]