array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29954817 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1565788"
+post_author: 1
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T18:30:05Z"
+"RFModificationTimestamp": "2026-06-27T18:40:59Z"
+"ListPrice": 539000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1055.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2L1"
+"UnparsedAddress": "525 NEW DUNDEE Road Unit# 226, Kitchener, Ontario N2P2L1"
+"Coordinates": array:2 [
0 => -80.4198614
1 => 43.3731807
]
+"Latitude": 43.3731807
+"Longitude": -80.4198614
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience elevated living in this beautifully appointed 2-bedroom, 2-bathroom condo set against the tranquil backdrop of Rainbow Lake. Situated on the 7th floor, Unit 226 offers breathtaking views and 1,055 square feet of thoughtfully designed contemporary space. The open-concept layout effortlessly blends the kitchen, living, and dining areas, creating a bright, inviting setting ideal for both everyday living and entertaining. The modern kitchen is equipped with stainless steel appliances and ample cabinetry, making it as functional as it is stylish. Step out onto your private balcony to unwind and enjoy peaceful views of Rainbow Lake and the surrounding conservation lands. The primary bedroom features a generous walk-in closet and a sleek 3-piece ensuite, while the second bedroom offers abundant natural light and excellent storage. Residents of this highly sought-after community enjoy premium amenities, including a fitness centre, yoga studio with sauna, library, social lounge, party room, pet grooming station, and direct access to scenic walking trails around Rainbow Lake. Don’t miss the opportunity to lease this exceptional condo in one of Kitchener’s most desirable locations! (id:62783)"
+"AccessibilityFeatures": array:1 [
0 => "Electronic Environmental Controls"
]
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "443"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:58:00.628703+00:00"
+"Directions": "Homer Watson Blvd to New Dundee Rd"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2204824"
+"ListOfficeKey": "277572"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-25T20:50:19Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T18:20:38Z"
+"Stories": "1.0"
+"StreetName": "NEW DUNDEE"
+"StreetNumber": "525"
+"StreetSuffix": "Road"
+"SubdivisionName": "335 - Pioneer Park/Doon/Wyldwoods"
+"TaxAnnualAmount": "4518"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1669576294"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843148"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954817"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T18:20:38.99Z"
]
1 => array:11 [
"RoomKey" => "1669576295"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843148"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954817"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T18:20:38.99Z"
]
2 => array:11 [
"RoomKey" => "1669576296"
"RoomType" => "Bedroom"
"ListingId" => "40843148"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954817"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T18:20:38.99Z"
]
3 => array:11 [
"RoomKey" => "1669576297"
"RoomType" => "Kitchen"
"ListingId" => "40843148"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954817"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T18:20:38.99Z"
]
4 => array:11 [
"RoomKey" => "1669576298"
"RoomType" => "Dining room"
"ListingId" => "40843148"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954817"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T18:20:38.99Z"
]
5 => array:11 [
"RoomKey" => "1669576299"
"RoomType" => "Living room"
"ListingId" => "40843148"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954817"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T18:20:38.99Z"
]
6 => array:11 [
"RoomKey" => "1669576300"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843148"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954817"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-27T18:20:38.99Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954817/525-new-dundee-road-unit-226-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1750692"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "277572"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "COM3 NHC1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1055
+"OriginalEntryTimestamp": "2026-06-25T20:50:18.67Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1453437"
+"ListOfficeNationalAssociationId": "1285375"
+"CoListAgentNationalAssociationId": "1117625"
+"CoListOfficeNationalAssociationId": "1285375"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29954817_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/8857046b75a723d57f2c78ae8b0eec3c.webp"
"MediaSize" => 39883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-8857046b75a723d57f2c78ae8b0eec3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29954817_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/a024e30def9fab382953998d9946d07e.webp"
"MediaSize" => 37085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-a024e30def9fab382953998d9946d07e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29954817_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/e60db6eca254ecc2c4451eca0ff9232f.webp"
"MediaSize" => 44067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-e60db6eca254ecc2c4451eca0ff9232f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29954817_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/698c4a56c4c289048165f2f70cfaeaa4.webp"
"MediaSize" => 34294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-698c4a56c4c289048165f2f70cfaeaa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29954817_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/bff9d2db9ff12e57ea4cfe9b9a8b6fc2.webp"
"MediaSize" => 37415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-bff9d2db9ff12e57ea4cfe9b9a8b6fc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29954817_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/8ff12cb1ddf2623066124da4ae404fcc.webp"
"MediaSize" => 33478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-8ff12cb1ddf2623066124da4ae404fcc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29954817_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/1c54c3f3f3a4b0699655b26057ca6c55.webp"
"MediaSize" => 41302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-1c54c3f3f3a4b0699655b26057ca6c55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29954817_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/593c0466680f5eeb652e73a0aeb4a86b.webp"
"MediaSize" => 94797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-593c0466680f5eeb652e73a0aeb4a86b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29954817_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/ca88984c15c4ade34dad2a17d6a21f6e.webp"
"MediaSize" => 105658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-ca88984c15c4ade34dad2a17d6a21f6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29954817_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/618df292fef30da8c09fbae4d6390d1e.webp"
"MediaSize" => 90361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-618df292fef30da8c09fbae4d6390d1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29954817_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/53586548010a5a274cfbaa89c7df5b5b.webp"
"MediaSize" => 99832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-53586548010a5a274cfbaa89c7df5b5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29954817_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/6b5c9753de61f27e6326a6930601aca7.webp"
"MediaSize" => 93238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-6b5c9753de61f27e6326a6930601aca7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29954817_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/10765758904b81fa20a12d29e7aa5529.webp"
"MediaSize" => 98103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-10765758904b81fa20a12d29e7aa5529.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29954817_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/544e8cf510ac0581973c272c20edb808.webp"
"MediaSize" => 115828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-544e8cf510ac0581973c272c20edb808.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29954817_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/249f6fb8b323bcc71ceb5a585168ef6a.webp"
"MediaSize" => 86209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-249f6fb8b323bcc71ceb5a585168ef6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29954817_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/3b05beaea62ffe7d1995d5835d8d3505.webp"
"MediaSize" => 78991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-3b05beaea62ffe7d1995d5835d8d3505.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29954817_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/4ba201686f0cffa57fe4b3cd249375c3.webp"
"MediaSize" => 87711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-4ba201686f0cffa57fe4b3cd249375c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29954817_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/cb25d63104a4e78b515988cc0433e006.webp"
"MediaSize" => 80541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-cb25d63104a4e78b515988cc0433e006.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29954817_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/c3ed2741e3697309d6e7fd194f785a89.webp"
"MediaSize" => 86467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-c3ed2741e3697309d6e7fd194f785a89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29954817_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/0b5cb811bbcc25f787516d27b5e3e1c8.webp"
"MediaSize" => 93249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-0b5cb811bbcc25f787516d27b5e3e1c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29954817_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/825bff65cb1ae01259909cf697d36c7b.webp"
"MediaSize" => 107628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-825bff65cb1ae01259909cf697d36c7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29954817_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/eee74fe4439596c2515069ac70a1a89b.webp"
"MediaSize" => 89925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-eee74fe4439596c2515069ac70a1a89b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29954817_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954817/eb4c0daaa9e01928f57d4a4bd28ac4c7.webp"
"MediaSize" => 84732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954817/thumbnail-eb4c0daaa9e01928f57d4a4bd28ac4c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843148"
"ResourceRecordKey" => "29954817"
"ModificationTimestamp" => "2026-06-25T20:50:18.69Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954817')"
+"ID": "1565788"
}
]
+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=OfficeMlsId eq 277572" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24869
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2204824" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24838
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29954817'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25212
+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 '29954817'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25235
+items: array:10 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664790"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-11"
+"OpenHouseStartTime": "2026-07-11T12:00:00Z"
+"OpenHouseEndTime": "2026-07-11T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664790')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664783"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-08-29"
+"OpenHouseStartTime": "2026-08-29T12:00:00Z"
+"OpenHouseEndTime": "2026-08-29T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664783')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25227
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664787"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-08-01"
+"OpenHouseStartTime": "2026-08-01T12:00:00Z"
+"OpenHouseEndTime": "2026-08-01T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664787')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25231
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664788"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-25"
+"OpenHouseStartTime": "2026-07-25T12:00:00Z"
+"OpenHouseEndTime": "2026-07-25T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664788')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664785"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-08-15"
+"OpenHouseStartTime": "2026-08-15T12:00:00Z"
+"OpenHouseEndTime": "2026-08-15T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664785')"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664792"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-27"
+"OpenHouseStartTime": "2026-06-27T12:00:00Z"
+"OpenHouseEndTime": "2026-06-27T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664792')"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664791"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-04"
+"OpenHouseStartTime": "2026-07-04T12:00:00Z"
+"OpenHouseEndTime": "2026-07-04T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664791')"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25232
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664784"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-08-22"
+"OpenHouseStartTime": "2026-08-22T12:00:00Z"
+"OpenHouseEndTime": "2026-08-22T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664784')"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25233
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664786"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-08-08"
+"OpenHouseStartTime": "2026-08-08T12:00:00Z"
+"OpenHouseEndTime": "2026-08-08T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664786')"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25234
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31664789"
+"ListingKey": "29954817"
+"ListingId": "40843148"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-18"
+"OpenHouseStartTime": "2026-07-18T12:00:00Z"
+"OpenHouseEndTime": "2026-07-18T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T16:25:41Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31664789')"
}
]
+success: true
+page_size: 10
+page_count: 2
+count: 19
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29954817' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4198614 43.3731807)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25321
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1571396"
+post_author: 1
+"ListingKey": "29959309"
+"ListingId": "40841016"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T19:00:07Z"
+"RFModificationTimestamp": "2026-06-26T19:05:08Z"
+"ListPrice": 1588888.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.11
+"LivingArea": 3963.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P0E7"
+"UnparsedAddress": "647 BLAIR CREEK Drive, Kitchener, Ontario N2P0E7"
+"Coordinates": array:2 [
0 => -80.4375984
1 => 43.3707958
]
+"Latitude": 43.3707958
+"Longitude": -80.4375984
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "EXTRAORDINARY CUSTOM-CRAFTED 4+1 bedroom, 4.5 bathroom luxury home, meticulous attention to detail w/9ft ceilings & 8ft 4 hinged custom doors & trim. PREMIUM 38' FRONTAGE LOT SPANNING 0.11 ACRES w/finished WO basement. A covered front porch with impressive foyer highlighted by a custom oak staircase and rich Biyork 6½ hand-scraped HICKORY ENGINEERED HARDWOOD FLOORING throughout the main & second level. HEATED FLOORS run through the kitchen, dining & primary ensuite floors. The elegant living and dining areas are enhanced by LED POT LIGHTS and a striking feature wall with an electric fireplace & custom mantle. Spectacular CW Kitchens DESIGNER KITCHEN showcasing 45½ upper cabinetry, Cambria quartz countertops, a custom range hood, herringbone backsplash, oversized island, built-in microwave pantry, soft-close cabinetry, lazy Susan corner cabinet, and premium dual-fuel stove with baking drawer. The adjoining dinette opens through a 6' sliding door to a COMPOSITE DECK COMPLETE WITH STAIRS AND A CUSTOM METAL AWNING WITH TINTED PANELS. The upper level offers 4 bedrooms, all with walk-in closets with custom organizers. The luxurious primary suite boasts a Palladian window, LARGE DRESSING ROOM, AND SPA-INSPIRED 5-PIECE ENSUITE with heated floors, freestanding tub, oversized glass shower with designer tile, dual quartz vanity, and custom lighting. Two bedrooms share a Jack & Jill bathroom while the fourth enjoys its own private ensuite. A full laundry room with quartz counters, sink, and folding area completes this level. The professionally finished walkout basement offers outstanding flexibility with a SECOND KITCHEN FEATURING QUARTZ COUNTERTOPS AND APPLIANCES, a spacious recreation area, fifth bedroom, rough-in for second laundry, and direct backyard access—ideal for multi-generational living or future income potential. Located within walking distance to Groh Public School, parks, trails, and only minutes to Conestoga College, shopping, restaurants, and Highway 401. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T19:04:57.515460+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563948"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.11"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T18:11:32Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T18:51:47Z"
+"Stories": "2.0"
+"StreetName": "BLAIR CREEK"
+"StreetNumber": "647"
+"StreetSuffix": "Drive"
+"SubdivisionName": "335 - Pioneer Park/Doon/Wyldwoods"
+"TaxAnnualAmount": "7943.89"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/647-blair-creek-dr-kitchener-on-n2p-0e7-26005000/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [
"RoomKey" => "1668754126"
"RoomType" => "Bedroom"
"ListingId" => "40841016"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.35Z"
]
1 => array:11 [
"RoomKey" => "1668754127"
"RoomType" => "Storage"
"ListingId" => "40841016"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 6'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.35Z"
]
2 => array:11 [
"RoomKey" => "1668754128"
"RoomType" => "Utility room"
"ListingId" => "40841016"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "19'11'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.35Z"
]
3 => array:11 [
"RoomKey" => "1668754129"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841016"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.35Z"
]
4 => array:11 [
"RoomKey" => "1668754130"
"RoomType" => "Kitchen"
"ListingId" => "40841016"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "15'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
5 => array:11 [
"RoomKey" => "1668754131"
"RoomType" => "Recreation room"
"ListingId" => "40841016"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "15'10'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
6 => array:11 [
"RoomKey" => "1668754132"
"RoomType" => "Laundry room"
"ListingId" => "40841016"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
7 => array:11 [
"RoomKey" => "1668754133"
"RoomType" => "Recreation room"
"ListingId" => "40841016"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
8 => array:11 [
"RoomKey" => "1668754134"
"RoomType" => "Bedroom"
"ListingId" => "40841016"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
9 => array:11 [
"RoomKey" => "1668754135"
"RoomType" => "5pc Bathroom"
"ListingId" => "40841016"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "5'11'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
10 => array:11 [
"RoomKey" => "1668754136"
"RoomType" => "Bedroom"
"ListingId" => "40841016"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
11 => array:11 [
"RoomKey" => "1668754137"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841016"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
12 => array:11 [
"RoomKey" => "1668754138"
"RoomType" => "Bedroom"
"ListingId" => "40841016"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
13 => array:11 [
"RoomKey" => "1668754139"
"RoomType" => "Other"
"ListingId" => "40841016"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
14 => array:11 [
"RoomKey" => "1668754140"
"RoomType" => "Full bathroom"
"ListingId" => "40841016"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "19'11'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.36Z"
]
15 => array:11 [
"RoomKey" => "1668754141"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841016"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "19'11'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.37Z"
]
16 => array:11 [
"RoomKey" => "1668754142"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841016"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.37Z"
]
17 => array:11 [
"RoomKey" => "1668754143"
"RoomType" => "Mud room"
"ListingId" => "40841016"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.37Z"
]
18 => array:11 [
"RoomKey" => "1668754144"
"RoomType" => "Dinette"
"ListingId" => "40841016"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.37Z"
]
19 => array:11 [
"RoomKey" => "1668754145"
"RoomType" => "Kitchen"
"ListingId" => "40841016"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.37Z"
]
20 => array:11 [
"RoomKey" => "1668754146"
"RoomType" => "Living room/Dining room"
"ListingId" => "40841016"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 25'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.37Z"
]
21 => array:11 [
"RoomKey" => "1668754147"
"RoomType" => "Foyer"
"ListingId" => "40841016"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959309"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T18:51:47.37Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29959309/647-blair-creek-drive-kitchener"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 2795
+"BelowGradeFinishedArea": 1168
+"OriginalEntryTimestamp": "2026-06-26T18:11:32.75Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1135552"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29959309_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959309/47358e7182af5b94c0a3d92e2981ed0a.webp"
"MediaSize" => 93365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959309/thumbnail-47358e7182af5b94c0a3d92e2981ed0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841016"
"ResourceRecordKey" => "29959309"
"ModificationTimestamp" => "2026-06-26T18:11:32.75Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29959309_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959309/0d81c90a2d34f27d821f51bf07ca1999.webp"
"MediaSize" => 86632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959309/thumbnail-0d81c90a2d34f27d821f51bf07ca1999.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841016"
"ResourceRecordKey" => "29959309"
"ModificationTimestamp" => "2026-06-26T18:11:32.75Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29959309_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959309/e86245c25d1c269ffd48eb9cb4b12c8b.webp"
"MediaSize" => 100210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959309/thumbnail-e86245c25d1c269ffd48eb9cb4b12c8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841016"
"ResourceRecordKey" => "29959309"
"ModificationTimestamp" => "2026-06-26T18:11:32.75Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29959309_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959309/a1b11da9194052b2d27e5a39b18cb33f.webp"
"MediaSize" => 109049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959309/thumbnail-a1b11da9194052b2d27e5a39b18cb33f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29959309')"
+"ID": "1571396"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25317
+post_id: "1571446"
+post_author: 1
+"ListingKey": "29958723"
+"ListingId": "X13494234"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T17:00:12Z"
+"RFModificationTimestamp": "2026-06-26T18:23:40Z"
+"ListPrice": 1348800.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2J6"
+"UnparsedAddress": "27 AUTUMN RIDGE TRAIL, Kitchener, Ontario N2P2J6"
+"Coordinates": array:2 [
0 => -80.421017
1 => 43.380186
]
+"Latitude": 43.380186
+"Longitude": -80.421017
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to This beautiful home. Located in the highly sought-after Doon South/Wyldwoods neighbourhood. This impressive home offers 4290sqft. of finished living space across three thoughtfully designed levels and is loaded with upgrades throughout.The main floor showcases 9 ft ceilings, large windows, and an open-concept that seamlessly connects the spacious sunken living room to bright dining room. The modern eat in kitchen is large and well appointed with plenty of counter space, cabinetry, large island and walk out to amazing cover patio and privet backyard oasis. The bright family room with gas fire place is perfect for everyday living and entertaining. A 2-piece bath and laundry room with access to garage and side patio finish off this floor. Up the grand staircase the primary suite impresses with a walk-in closet and a luxurious 5-piece ensuite featuring a freestanding soaker tub, glass shower and double quartz vanities. Three additional bedrooms - including one converted to the office, full renovated bathroom with oversized shower and integrated smart bidet toilet, provides comfort and convenience for the whole family. The fully finished basement extends the living space with large recreation area, 3pc washroom, plenty of storage and possibility's of 2nd kitchen, This home offering well over $1000.000. worth in upgrades over past few years, and an unbeatable location - close to 401, parks, trails, shopping and brand new elementary school. This home is a rare find in one of Kitchener's most desirable family communities. (id:62783)"
+"Appliances": array:3 [
0 => "Water softener"
1 => "Central Vacuum"
2 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T18:23:24.961775+00:00"
+"Directions": "Cross Streets: New Dundee/Thomas Slee Dr. ** Directions: From New Dundee Dr to Thomas Slee Dr to Autumn Ridge Tr."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"Fencing": array:2 [
0 => "Partially fenced"
1 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Ceramic"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1410932"
+"ListOfficeKey": "51317"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Carpet Free"
2 => "Sump Pump"
]
+"LotSizeDimensions": "58.4 x 151.7 FT ; 58.44 x 151.69 x 71.61 x 139.1"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T16:53:42Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T16:53:42Z"
+"Stories": "2.0"
+"StreetName": "Autumn Ridge"
+"StreetNumber": "27"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "8112.81"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29958723/27-autumn-ridge-trail-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 58.4
+"OriginalEntryTimestamp": "2026-06-26T16:53:42.4Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1057217"
+"ListOfficeNationalAssociationId": "1003156"
+"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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29958723')"
+"ID": "1571446"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: "1565995"
+post_author: 1
+"ListingKey": "29954546"
+"ListingId": "40800812"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T20:30:20Z"
+"RFModificationTimestamp": "2026-06-27T20:34:37Z"
+"ListPrice": 789900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1890.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P0B5"
+"UnparsedAddress": "260 CRANBROOK Street, Kitchener, Ontario N2P0B5"
+"Coordinates": array:2 [
0 => -80.4373102
1 => 43.376875
]
+"Latitude": 43.376875
+"Longitude": -80.4373102
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 3-bedroom, 3-bathroom home located in the highly sought-after, family-friendly community of Doon South. The main floor features an inviting open-concept living room complete with a cozy gas fireplace with a stone surround that extends to the ceiling and a conveniently located Powder Room. The next level has a spacious dining room and kitchen with stainless steel appliances, a center island, and convenient sliders leading to a deck overlooking the beautifully landscaped, fully fenced in backyard. Upstairs, the primary bedroom which includes a large walk-in closet with custom shelving and an ensuite with a large walk in shower. The next level, the second and third bedrooms are both generously sized, also with a 3 piece bathroom. The unfinished lower level rec-room features high ceilings, large window, gas line hookup for that potential fireplace and ready for your added touch. The utility area provides additional storage/workspace, laundry and even a large area crawl space for added storage. This home provides the perfect blend of comfort, functionality, and modern style all in a neighbourhood close to schools, parks, many walking trails and amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:02:19.400318+00:00"
+"ExteriorFeatures": array:4 [
0 => "Concrete"
1 => "Brick"
2 => "Vinyl siding"
3 => "Shingles"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2221008"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T20:14:11Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T20:25:06Z"
+"Stories": "2.0"
+"StreetName": "CRANBROOK"
+"StreetNumber": "260"
+"StreetSuffix": "Street"
+"SubdivisionName": "335 - Pioneer Park/Doon/Wyldwoods"
+"TaxAnnualAmount": "5961.44"
+"VirtualTourURLUnbranded": "https://youriguide.com/260_cranbrook_st_kitchener_on"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954546/260-cranbrook-street-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1890
+"OriginalEntryTimestamp": "2026-06-25T20:14:11.51Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1465287"
+"ListOfficeNationalAssociationId": "1165450"
+"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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954546')"
+"ID": "1565995"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1564955"
+post_author: 1
+"ListingKey": "29947846"
+"ListingId": "X13484422"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:25:05Z"
+"RFModificationTimestamp": "2026-06-26T00:50:59Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2X3"
+"UnparsedAddress": "227 CHESTNUT HILL CRESCENT, Kitchener, Ontario N2P2X3"
+"Coordinates": array:2 [
0 => -80.427286
1 => 43.381213
]
+"Latitude": 43.381213
+"Longitude": -80.427286
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "*OPEN HOUSE-SATURDAY, JUNE 27th & SUNDAY, JUNE 28th, 2:00 -4:00 pm* Executive BUNGALOFT with two primary suites- Welcome to one of the most coveted crescents in Doon, where homes are rarely offered & lifestyles are effortlessly elevated. Set on a premium lot backing onto Topper Woods, this executive freehold townhome offers a rare blend of privacy, space, & low-maintenance living just minutes from the 401. Step inside and you're immediately greeted by soaring ceilings, a beautifully open-concept layout, & an abundance of natural light that fills the main living space. Designed with both comfort and flexibility in mind, this home features a rare dual primary suite layout with a spacious main floor primary bedroom complete with ensuite and double closet, plus a second private primary retreat with ensuite in the loft level above. The main floor offers over 1,500 sq ft of well-appointed living space, including a generous living & dining area, an inviting kitchen, main floor laundry, & an additional bedroom or office, perfect for guests or work-from-home needs. Upstairs, the loft adds approximately 640 sq ft & functions beautifully as a second primary suite, featuring a large bedroom, walk-in closet, walk-in shower, & an open-to-below family space that overlooks the main floor-ideal for extended family, visiting guests, or a private retreat. The fully finished basement extends your living space even further with a large recreation room, additional bedroom, bathroom, den, cantina & ample storage bringing the total finished space to over 3,500 sq ft. Out back, the setting is truly special. With no rear neighbours & a peaceful forest backdrop, this is where morning coffees feel a little quieter and evenings a little more serene. Whether you're looking to simplify your lifestyle without sacrificing space, or need a home that offers true flexibility for multi-generational living this is a rare opportunity in a prestigious setting. (id:62783)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Range"
7 => "Oven"
8 => "Dryer"
9 => "Microwave"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
13 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:50:24.716733+00:00"
+"Directions": "Cross Streets: Doon South Drive & Forest Edge Trail. ** Directions: Doon South Drive to Forest Edge Trail to Chestnut Hill Crescent."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2101065"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Wooded area"
1 => "Irregular lot size"
2 => "Flat site"
3 => "Conservation/green belt"
4 => "Level"
5 => "Sump Pump"
]
+"LotSizeDimensions": "44 x 187 FT ; 44 x 187 x 44 x 189"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T17:54:41Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T19:16:04Z"
+"Stories": "1.5"
+"StreetName": "Chestnut Hill"
+"StreetNumber": "227"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7068"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/227_chestnut_hill_crescent_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29947846/227-chestnut-hill-crescent-kitchener"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "C2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"OriginalEntryTimestamp": "2026-06-24T17:54:41.6Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1371088"
+"ListOfficeNationalAssociationId": "1381521"
+"Media": array:39 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947846')"
+"ID": "1564955"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25316
+post_id: "1563473"
+post_author: 1
+"ListingKey": "29950915"
+"ListingId": "X13487136"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T12:55:14Z"
+"RFModificationTimestamp": "2026-06-25T21:30:30Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2T7"
+"UnparsedAddress": "500 ROBERT FERRIE DRIVE, Kitchener, Ontario N2P2T7"
+"Coordinates": array:2 [
0 => -80.4328798
1 => 43.378135
]
+"Latitude": 43.378135
+"Longitude": -80.4328798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this meticulously maintained freehold townhome nestled in the heart of the highly sought-after Doon South community. This bright, open-concept home offers a spacious and functional layout perfect for modern family living. The true highlight of this property is the expansive backyard oasis-a rare find that provides immense room for gardening, play, and outdoor entertaining, all while offering the privacy and tranquility you've been searching for. Inside, enjoy a thoughtfully designed space that flows seamlessly from the kitchen to the living area, filled with natural light. Ideally located just minutes from Highway 401, top-rated schools, nature trails, and everyday amenities, this home perfectly balances comfort and convenience. Don't miss your chance to own a home with one of the largest yards in the neighbourhood-schedule your private tour today! (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:29:43.986402+00:00"
+"Directions": "Cross Streets: Robert Ferrie Dr & Doon S Dr. ** Directions: At the intersection of Robert Ferrie Dr & Doon S Dr in Doon South community."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2143476"
+"ListOfficeKey": "292962"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "41 x 144.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T12:46:53Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T12:46:53Z"
+"Stories": "2.0"
+"StreetName": "Robert Ferrie"
+"StreetNumber": "500"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4572"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950915/500-robert-ferrie-drive-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "RES-5"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2026-06-25T12:46:53.56Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1395072"
+"ListOfficeNationalAssociationId": "1420223"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950915')"
+"ID": "1563473"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "1557739"
+post_author: 1
+"ListingKey": "29942288"
+"ListingId": "40842200"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T20:25:17Z"
+"RFModificationTimestamp": "2026-06-27T20:30:43Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3743.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2X3"
+"UnparsedAddress": "227 CHESTNUT HILL Crescent, Kitchener, Ontario N2P2X3"
+"Coordinates": array:2 [
0 => -80.4272793
1 => 43.381213
]
+"Latitude": 43.381213
+"Longitude": -80.4272793
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "*OPEN HOUSE-SATURDAY, JUNE 27th & SUNDAY, JUNE 28th, 2:00 -4:00 pm* Executive BUNGALOFT with two primary suites- Welcome to one of the most coveted crescents in Doon, where homes are rarely offered & lifestyles are effortlessly elevated. Set on a premium lot backing onto Topper Woods, this executive freehold townhome offers a rare blend of privacy, space, & low-maintenance living just minutes from the 401. Step inside and you’re immediately greeted by soaring ceilings, a beautifully open-concept layout, & an abundance of natural light that fills the main living space. Designed with both comfort and flexibility in mind, this home features a rare dual primary suite layout with a spacious main floor primary bedroom complete with ensuite and double closet, plus a second private primary retreat with ensuite in the loft level above. The main floor offers over 1,500 sq ft of well-appointed living space, including a generous living & dining area, an inviting kitchen, main floor laundry, & an additional bedroom or office, perfect for guests or work-from-home needs. Upstairs, the loft adds approximately 640 sq ft & functions beautifully as a second primary suite, featuring a large bedroom, walk-in closet, walk-in shower, & an open-to-below family space that overlooks the main floor-ideal for extended family, visiting guests, or a private retreat. The fully finished basement extends your living space even further with a large recreation room, additional bedroom, bathroom, den, cantina & ample storage bringing the total finished space to over 3,500 sq ft. Out back, the setting is truly special. With no rear neighbours & a peaceful forest backdrop, this is where morning coffees feel a little quieter and evenings a little more serene. Whether you’re looking to simplify your lifestyle without sacrificing space, or need a home that offers true flexibility for multi-generational living this is a rare opportunity in a prestigious setting. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T19:13:26.294307+00:00"
+"Directions": "Doon South Drive to Forest Edge Trail to Chestnut Hill Crescent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1914963"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T17:11:14Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T20:20:15Z"
+"Stories": "1.5"
+"StreetName": "CHESTNUT HILL"
+"StreetNumber": "227"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "335 - Pioneer Park/Doon/Wyldwoods"
+"TaxAnnualAmount": "7068"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/227_chestnut_hill_crescent_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29942288/227-chestnut-hill-crescent-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "C2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2218
+"BelowGradeFinishedArea": 1525
+"OriginalEntryTimestamp": "2026-06-23T17:11:14.02Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1224245"
+"ListOfficeNationalAssociationId": "1381240"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29942288')"
+"ID": "1557739"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1552819"
+post_author: 1
+"ListingKey": "29934386"
+"ListingId": "X13472206"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T11:55:03Z"
+"RFModificationTimestamp": "2026-06-25T20:10:56Z"
+"ListPrice": 1199000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2X6"
+"UnparsedAddress": "470 BLAIR CREEK DRIVE, Kitchener, Ontario N2P2X6"
+"Coordinates": array:2 [
0 => -80.4311546
1 => 43.3724297
]
+"Latitude": 43.3724297
+"Longitude": -80.4311546
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to 470 Blair Creek Drive in the highly sought-after Doon South community, where luxury living meets exceptional income potential. Offering 2,600 sq. ft. of above-grade living space, this beautifully maintained 4+2 bedroom home features a legal 2-bedroom basement apartment with a separate side entrance-ideal for rental income, multigenerational living, or extended family.The bright and spacious main floor showcases 9-foot ceilings, creating an open and inviting atmosphere throughout. The chef-inspired kitchen features quartz countertops, ample cabinetry, a built-in oven and microwave, and seamlessly connects to the dining and living areas. The living room is highlighted by a cozy fireplace, perfect for relaxing and entertaining. An updated 2-piece powder room completes the main level.Upstairs, you'll find Upgraded 9-foot ceilings, a versatile loft, four generously sized bedrooms with updated flooring, and convenient second-floor laundry. The spacious primary suite offers a walk-in closet and a luxurious 5-piece ensuite with double sinks and a quartz countertop. The additional upper-level bathroom has also been upgraded with a quartz countertop.This completely carpet-free home is loaded with upgrades, including modern flooring, oak stairs, California shutters, refreshed bathrooms and stylish finishes throughout.Step outside to enjoy a private backyard featuring a concrete patio and backing onto the Doon South walking trail with no rear neighbours.The property also boasts a concrete driveway, a double-car garage, and parking for up to six vehicles in total, offering exceptional convenience for growing families and visitors.Located in one of Kitchener's most desirable family-friendly neighbourhoods, this home is close to top-rated schools, parks, scenic trails, shopping, and offers quick access to Highway 401.A rare turnkey opportunity offering premium upgrades, a legal basement apartment, and outstanding income potential in a prime location. (id:66098)"
+"Appliances": array:15 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Water purifier"
4 => "Water softener"
5 => "Dishwasher"
6 => "Stove"
7 => "Oven"
8 => "Dryer"
9 => "Microwave"
10 => "Oven - Built-In"
11 => "Hood Fan"
12 => "Window Coverings"
13 => "Garage door opener remote(s)"
14 => "Water Heater"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-21T17:06:56.535188+00:00"
+"Directions": "Cross Streets: Blair Creek Drive / Robert Ferrie Drive. ** Directions: New Dundee Road to Robert Ferrie Drive to Blair Creek Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2157127"
+"ListOfficeKey": "85076"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "36.1 x 114.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-21T16:33:30Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T11:40:53Z"
+"Stories": "2.0"
+"StreetName": "Blair Creek"
+"StreetNumber": "470"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8100"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Pdw5XVen1nq"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29934386/470-blair-creek-drive-kitchener"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R-4 690R"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 36.1
+"OriginalEntryTimestamp": "2026-06-21T16:33:29.89Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1408564"
+"ListOfficeNationalAssociationId": "1187880"
+"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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29934386')"
+"ID": "1552819"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1542890"
+post_author: 1
+"ListingKey": "29922106"
+"ListingId": "X13461308"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T12:30:29Z"
+"RFModificationTimestamp": "2026-06-21T12:32:33Z"
+"ListPrice": 420000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P0K8"
+"UnparsedAddress": "413 - 525 NEW DUNDEE ROAD, Kitchener, Ontario N2P0K8"
+"Coordinates": array:2 [
0 => -80.419833
1 => 43.373302
]
+"Latitude": 43.373302
+"Longitude": -80.419833
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled within the sought after Rainbow Lake community in Kitchener, this one bedroom, one bathroom condo at 525 New Dundee Road offers 723 square feet of thoughtfully designed living space that truly feels like home. The open concept layout connects the living, dining, and kitchen areas in a way that feels both spacious and inviting, whether you are settling in after a long day or having friends over for the evening. The kitchen is well appointed with stainless steel appliances and generous cabinet storage that makes everyday living effortless. Step through the balcony door and you are greeted with peaceful views of Rainbow Lake, a backdrop that makes this unit genuinely special. The building itself is packed with amenities that support an active and balanced lifestyle, including a gym, yoga studio, sauna, library, social lounge, party room, and a pet wash station. Residents also enjoy exclusive access to the Rainbow Lake conservation area, where kayaking, canoeing, swimming, and fishing are all right at your doorstep. This is a wonderful opportunity to live surrounded by nature without giving up the comforts and conveniences of a well maintained modern building. (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"AssociationFee": "303"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:42:27.158974+00:00"
+"Directions": "Cross Streets: Homer Watson Blvd. ** Directions: Homer Watson Blvd to New Dundee Rd."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932995"
+"ListOfficeKey": "277695"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Elevator"
2 => "Balcony"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T16:05:41Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T12:23:47Z"
+"StreetName": "New Dundee"
+"StreetNumber": "525"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3514"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29922106/413-525-new-dundee-road-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Prop Mgmt"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Exercise Centre"
1 => "Party Room"
2 => "Sauna"
3 => "Security/Concierge"
4 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "COM3 NHC1"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T16:05:41.89Z"
+"ListAgentNationalAssociationId": "1233168"
+"ListOfficeNationalAssociationId": "1286818"
+"Media": array:17 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922106')"
+"ID": "1542890"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1543490"
+post_author: 1
+"ListingKey": "29921550"
+"ListingId": "40840900"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T18:30:03Z"
+"RFModificationTimestamp": "2026-06-27T18:40:59Z"
+"ListPrice": 420000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 723.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2P2L1"
+"UnparsedAddress": "525 NEW DUNDEE Road Unit# 413, Kitchener, Ontario N2P2L1"
+"Coordinates": array:2 [
0 => -80.4202476
1 => 43.373321
]
+"Latitude": 43.373321
+"Longitude": -80.4202476
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled within the sought after Rainbow Lake community in Kitchener, this one bedroom, one bathroom condo at 525 New Dundee Road offers 723 square feet of thoughtfully designed living space that truly feels like home. The open concept layout connects the living, dining, and kitchen areas in a way that feels both spacious and inviting, whether you are settling in after a long day or having friends over for the evening. The kitchen is well appointed with stainless steel appliances and generous cabinet storage that makes everyday living effortless. Step through the balcony door and you are greeted with peaceful views of Rainbow Lake, a backdrop that makes this unit genuinely special. The building itself is packed with amenities that support an active and balanced lifestyle, including a gym, yoga studio, sauna, library, social lounge, party room, and a pet wash station. Residents also enjoy exclusive access to the Rainbow Lake conservation area, where kayaking, canoeing, swimming, and fishing are all right at your doorstep. This is a wonderful opportunity to live surrounded by nature without giving up the comforts and conveniences of a well maintained modern building. (id:62783)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"AssociationFee": "303"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T15:45:50.109020+00:00"
+"Directions": "Homer Watson Blvd to New Dundee Rd."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2204824"
+"ListOfficeKey": "277572"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-18T15:12:17Z"
+"PhotosCount": 17
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T18:21:02Z"
+"Stories": "1.0"
+"StreetName": "NEW DUNDEE"
+"StreetNumber": "525"
+"StreetSuffix": "Road"
+"SubdivisionName": "335 - Pioneer Park/Doon/Wyldwoods"
+"TaxAnnualAmount": "3514"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921550/525-new-dundee-road-unit-413-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1750692"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "277572"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "COM3 NHC1"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 723
+"OriginalEntryTimestamp": "2026-06-18T15:12:16.89Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1453437"
+"ListOfficeNationalAssociationId": "1285375"
+"CoListAgentNationalAssociationId": "1117625"
+"CoListOfficeNationalAssociationId": "1285375"
+"Media": array:17 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921550')"
+"ID": "1543490"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 78
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]