array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29848313 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23331
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23333
+post_id: "1490439"
+post_author: 1
+"ListingKey": "29848313"
+"ListingId": "X13235358"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T16:06:03Z"
+"RFModificationTimestamp": "2026-06-04T16:52:43Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A0K4"
+"UnparsedAddress": "30 WATERBOW TRAIL, Kitchener, Ontario N2A0K4"
+"Coordinates": array:2 [
0 => -80.398826
1 => 43.451524
]
+"Latitude": 43.451524
+"Longitude": -80.398826
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 30 Waterbow Trail, a beautifully upgraded home built by New Lifestyle Homes and located in Kitchener's family-friendly Lackner Woods community. Offering over 2,450 sq. ft. of finished living space, this 4-bedroom, 3.5-bathroom home combines quality craftsmanship with thoughtful design throughout. The main floor features premium hardwood flooring, a spacious open-concept layout, and a stunning Kitchen complete with upgraded cabinetry, stainless steel appliances, a subway tile backsplash, and a large pantry. The upper level offers a spacious Primary Bedroom with a walk-in closet and private 4-piece en-suite, along with three additional bedrooms, a full bathroom, and a skylight that fills the space with natural light. The fully finished Basement adds valuable living space and includes a 3-piece bathroom, making it ideal for a recreation room, home office, guest area, or growing family. Step outside to enjoy a private, fully fenced backyard featuring multiple deck spaces, a gazebo, and beautiful landscaping that creates the perfect setting for entertaining or relaxing. This is a home that has been exceptionally well cared for and offers the space, upgrades, and location that today's buyers are looking for. Book your private showing today! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T19:30:26.668328+00:00"
+"Directions": "Valleybrook dr/Waterbow tr"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160947"
+"ListOfficeKey": "294429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "54.9 x 104.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T18:57:16Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T15:59:35Z"
+"Stories": "2.0"
+"StreetName": "Waterbow"
+"StreetNumber": "30"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "6064"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1651581716"
"RoomType" => "Kitchen"
"ListingId" => "X13235358"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29848313"
"RoomLength" => 4.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.38Z"
]
1 => array:11 [
"RoomKey" => "1651581717"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13235358"
"RoomLevel" => "Basement"
"RoomWidth" => 6.0
"ListingKey" => "29848313"
"RoomLength" => 6.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.38Z"
]
2 => array:11 [
"RoomKey" => "1651581718"
"RoomType" => "Bathroom"
"ListingId" => "X13235358"
"RoomLevel" => "Basement"
"RoomWidth" => 1.5
"ListingKey" => "29848313"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.38Z"
]
3 => array:11 [
"RoomKey" => "1651581719"
"RoomType" => "Dining room"
"ListingId" => "X13235358"
"RoomLevel" => "Main level"
"RoomWidth" => 2.2
"ListingKey" => "29848313"
"RoomLength" => 2.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.39Z"
]
4 => array:11 [
"RoomKey" => "1651581720"
"RoomType" => "Bathroom"
"ListingId" => "X13235358"
"RoomLevel" => "Main level"
"RoomWidth" => 1.2
"ListingKey" => "29848313"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.39Z"
]
5 => array:11 [
"RoomKey" => "1651581721"
"RoomType" => "Great room"
"ListingId" => "X13235358"
"RoomLevel" => "Main level"
"RoomWidth" => 3.8
"ListingKey" => "29848313"
"RoomLength" => 6.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.39Z"
]
6 => array:11 [
"RoomKey" => "1651581722"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13235358"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29848313"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.4Z"
]
7 => array:11 [
"RoomKey" => "1651581723"
"RoomType" => "Bathroom"
"ListingId" => "X13235358"
"RoomLevel" => "Second level"
"RoomWidth" => 1.8
"ListingKey" => "29848313"
"RoomLength" => 3.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.4Z"
]
8 => array:11 [
"RoomKey" => "1651581724"
"RoomType" => "Bathroom"
"ListingId" => "X13235358"
"RoomLevel" => "Second level"
"RoomWidth" => 1.7
"ListingKey" => "29848313"
"RoomLength" => 2.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.4Z"
]
9 => array:11 [
"RoomKey" => "1651581725"
"RoomType" => "Bedroom 2"
"ListingId" => "X13235358"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29848313"
"RoomLength" => 3.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.4Z"
]
10 => array:11 [
"RoomKey" => "1651581726"
"RoomType" => "Bedroom 3"
"ListingId" => "X13235358"
"RoomLevel" => "Second level"
"RoomWidth" => 3.28
"ListingKey" => "29848313"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.4Z"
]
11 => array:11 [
"RoomKey" => "1651581727"
"RoomType" => "Bedroom 4"
"ListingId" => "X13235358"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "29848313"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-04T15:59:35.4Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29848313/30-waterbow-trail-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 54.1
+"OriginalEntryTimestamp": "2026-06-03T18:57:16.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1412086"
+"ListOfficeNationalAssociationId": "1438893"
+"Media": array:43 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29848313_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/435b3ef32be70ef66d3197e646192dab.webp"
"MediaSize" => 224657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-435b3ef32be70ef66d3197e646192dab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29848313_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/21a3a69851dd736265b48bdcc3889483.webp"
"MediaSize" => 233397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-21a3a69851dd736265b48bdcc3889483.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29848313_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/8a6f568ec5558cc94dff92542211cf36.webp"
"MediaSize" => 272082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-8a6f568ec5558cc94dff92542211cf36.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29848313_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/6a77d54b5428fa70da030ec811243958.webp"
"MediaSize" => 393115
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-6a77d54b5428fa70da030ec811243958.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29848313_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/634e466d1c53576242712ea37289d2cf.webp"
"MediaSize" => 310411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-634e466d1c53576242712ea37289d2cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29848313_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/9a9dfa9f922fa76532d2adc8a224b3f1.webp"
"MediaSize" => 193711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-9a9dfa9f922fa76532d2adc8a224b3f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29848313_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/41bd1652d9d2e5a240e10ddc361a3ca3.webp"
"MediaSize" => 179698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-41bd1652d9d2e5a240e10ddc361a3ca3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29848313_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/23cd253989987fddaa4feff276373dee.webp"
"MediaSize" => 181320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-23cd253989987fddaa4feff276373dee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29848313_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/6de4b6de318cda35142caf0a72a4e24b.webp"
"MediaSize" => 200941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-6de4b6de318cda35142caf0a72a4e24b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29848313_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/06fde7f049288fa24bd335479e5588f4.webp"
"MediaSize" => 213941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-06fde7f049288fa24bd335479e5588f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29848313_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/2675c2becae08e1e9192d0b335ae4d34.webp"
"MediaSize" => 185689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-2675c2becae08e1e9192d0b335ae4d34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29848313_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/f27124b947db135cb0757046ae5d1221.webp"
"MediaSize" => 163904
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-f27124b947db135cb0757046ae5d1221.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29848313_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/7ebc6c3d0e1d5be3d09c98f04503d765.webp"
"MediaSize" => 157287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-7ebc6c3d0e1d5be3d09c98f04503d765.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29848313_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/35626d1fe7a282468afb7c1584c02713.webp"
"MediaSize" => 141467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-35626d1fe7a282468afb7c1584c02713.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29848313_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/b637a5177460429197d3068e4ff12da8.webp"
"MediaSize" => 157042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-b637a5177460429197d3068e4ff12da8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29848313_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/007ee77c5a5993296579870cf06fb8d4.webp"
"MediaSize" => 151056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-007ee77c5a5993296579870cf06fb8d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29848313_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/1306ebfb2b683f08b4afebc65784827f.webp"
"MediaSize" => 146031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-1306ebfb2b683f08b4afebc65784827f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29848313_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/d501434c91b6a1d373f7a2a3290c069d.webp"
"MediaSize" => 158260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-d501434c91b6a1d373f7a2a3290c069d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29848313_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/b5502be4044b6dbd2cbe2d0c6db9d981.webp"
"MediaSize" => 148621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-b5502be4044b6dbd2cbe2d0c6db9d981.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29848313_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/2f40dc10c4e876faacfb6d86b307d2c4.webp"
"MediaSize" => 121138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-2f40dc10c4e876faacfb6d86b307d2c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29848313_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/5cef72098574f1e344d56c9f1952c3fe.webp"
"MediaSize" => 100183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-5cef72098574f1e344d56c9f1952c3fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29848313_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/bd48ba031ee0ea9e1c676ec84f189f2e.webp"
"MediaSize" => 153286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-bd48ba031ee0ea9e1c676ec84f189f2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29848313_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/85584ca277041d2a707b0c90607a7738.webp"
"MediaSize" => 148223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-85584ca277041d2a707b0c90607a7738.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29848313_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/770c7e955749eee03d1dec8e74e6cd66.webp"
"MediaSize" => 113064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-770c7e955749eee03d1dec8e74e6cd66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29848313_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/f33aadd9f1a24410cf3a0c50ffaf35f0.webp"
"MediaSize" => 161114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-f33aadd9f1a24410cf3a0c50ffaf35f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29848313_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/8eb02ca3b39821f78ec123349794285b.webp"
"MediaSize" => 149253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-8eb02ca3b39821f78ec123349794285b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29848313_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/e99a181abea6b22390a3b7733a482d1b.webp"
"MediaSize" => 133480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-e99a181abea6b22390a3b7733a482d1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29848313_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/67e8e9ce08dc2165861bc4b27597324b.webp"
"MediaSize" => 88962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-67e8e9ce08dc2165861bc4b27597324b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29848313_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/7887e4a21ac36770c32b6c1d03049b52.webp"
"MediaSize" => 205223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-7887e4a21ac36770c32b6c1d03049b52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29848313_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/386c898084856bf5aac45f508ce36460.webp"
"MediaSize" => 149508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-386c898084856bf5aac45f508ce36460.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29848313_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/2522b5edfc4c92cc8fb90be12fabdcb8.webp"
"MediaSize" => 127152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-2522b5edfc4c92cc8fb90be12fabdcb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29848313_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/7bf2870d4bf04c72d7aaaa31da532084.webp"
"MediaSize" => 127084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-7bf2870d4bf04c72d7aaaa31da532084.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29848313_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/669b3defcb8769375f3d7bd81beb6a21.webp"
"MediaSize" => 104474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-669b3defcb8769375f3d7bd81beb6a21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29848313_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/d777f9b480ba774f9fb75b451351acee.webp"
"MediaSize" => 146815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-d777f9b480ba774f9fb75b451351acee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29848313_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/4f7a1c3332d664763f5ae7f9e1639b6f.webp"
"MediaSize" => 137058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-4f7a1c3332d664763f5ae7f9e1639b6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29848313_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/102b79c00e1648d35c084512e27b9645.webp"
"MediaSize" => 135711
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-102b79c00e1648d35c084512e27b9645.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29848313_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/8481a375acc7e1261259ee13c817de5a.webp"
"MediaSize" => 112800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-8481a375acc7e1261259ee13c817de5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29848313_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/2977e7999367f2200b2718bf58edbd56.webp"
"MediaSize" => 145477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-2977e7999367f2200b2718bf58edbd56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29848313_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/f02e4d367fde0e14fcdac2446fdeb48b.webp"
"MediaSize" => 126417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-f02e4d367fde0e14fcdac2446fdeb48b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29848313_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/efd1cc1ebdf220ceefb5baf7b49a4765.webp"
"MediaSize" => 314204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-efd1cc1ebdf220ceefb5baf7b49a4765.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29848313_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/bc6c1994f0f013e64915685dfb04716c.webp"
"MediaSize" => 338634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-bc6c1994f0f013e64915685dfb04716c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29848313_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/dc6a9dd9fecfcf6f431ee0fd1f780c5f.webp"
"MediaSize" => 304776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-dc6a9dd9fecfcf6f431ee0fd1f780c5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29848313_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848313/76d172315f01825ed9a2a63b5400b953.webp"
"MediaSize" => 331961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848313/thumbnail-76d172315f01825ed9a2a63b5400b953.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13235358"
"ResourceRecordKey" => "29848313"
"ModificationTimestamp" => "2026-06-03T18:57:16.55Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29848313')"
+"ID": "1490439"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 294429" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24694
+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 2160947" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24779
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29848313'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25102
+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 '29848313'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25118
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29848313' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.398826 43.451524)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25191
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: "1495679"
+post_author: 1
+"ListingKey": "29855687"
+"ListingId": "40833512"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:53Z"
+"RFModificationTimestamp": "2026-06-06T20:46:44Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1488.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A4N1"
+"UnparsedAddress": "86 UPPER MERCER Street, Kitchener, Ontario N2A4N1"
+"Coordinates": array:2 [
0 => -80.4062796
1 => 43.4453007
]
+"Latitude": 43.4453007
+"Longitude": -80.4062796
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Premium Forest View lot! Quality built by Fusion Homes! This beautifully maintained freehold townhome is ideally located steps to the Grand River Trails, a new high school, and a view of Chicopee Ski Resort off in the distance. With great access to the 401, this home is a commuter's dream with Cambridge and Guelph just a short drive away. The main floor is designed for modern living with a convenient two-piece powder room and an open-concept layout. The gorgeous kitchen boasts stainless appliances, upgraded maple cabinetry including pot and pan drawer and a luxury island with breakfast bar. The expansive dining area with upgraded 45 degree tiled floors flows seamlessly into the great-sized living room which has a walkout sliding patio door for a great view of the private yard. Upstairs, you’ll love the sunlit hallway from the upgraded skylight. You'll also find three generously sized bedrooms. The primary suite is large enough for a king sized bed and features an oversized window to take advantage of the views, a large walk-in closet as well as a luxury 3 piece ensuite with an upgraded glass walk-in shower. The upper level is complete with a four-piece main bathroom. The bright open basement features a walkout to the fully fenced backyard. The expansive basement can be finished however you Iike. It also has a laundry area, utility area, a cold room plus an area with a rough in bathroom. Additional impressive features of this home include : An oversized garage (1.5 interior) with direct walk-through access to the yard, water softener, electric garage door and central vac rough ins, insulated garage door and hard wired smoke and CO detectors. This well cared for one owner home is ready for you to move in and enjoy! Note some photos virtually staged. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Central Vacuum - Roughed In"
7 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-04T21:00:42.965433+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl 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": "1564578"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Visual exposure"
1 => "Ravine"
2 => "Conservation/green belt"
3 => "Skylight"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T18:51:20Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:22:20Z"
+"Stories": "2.0"
+"StreetName": "UPPER MERCER"
+"StreetNumber": "86"
+"StreetSuffix": "Street"
+"SubdivisionName": "232 - Idlewood/Lackner Woods"
+"TaxAnnualAmount": "4124"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/86_upper_mercer_st_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1653466614"
"RoomType" => "Kitchen"
"ListingId" => "40833512"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29855687"
"RoomLength" => null
"RoomDimensions" => "13'9'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:22:20.16Z"
]
1 => array:11 [
"RoomKey" => "1653466615"
"RoomType" => "2pc Bathroom"
"ListingId" => "40833512"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29855687"
"RoomLength" => null
"RoomDimensions" => "3'0'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:22:20.16Z"
]
2 => array:11 [
"RoomKey" => "1653466616"
"RoomType" => "Living room"
"ListingId" => "40833512"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29855687"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 17'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:22:20.16Z"
]
3 => array:11 [
"RoomKey" => "1653466617"
"RoomType" => "Bedroom"
"ListingId" => "40833512"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29855687"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:22:20.16Z"
]
4 => array:11 [
"RoomKey" => "1653466618"
"RoomType" => "Bedroom"
"ListingId" => "40833512"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29855687"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:22:20.16Z"
]
5 => array:11 [
"RoomKey" => "1653466619"
"RoomType" => "4pc Bathroom"
"ListingId" => "40833512"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29855687"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:22:20.16Z"
]
6 => array:11 [
"RoomKey" => "1653466620"
"RoomType" => "Full bathroom"
"ListingId" => "40833512"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29855687"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-06T20:22:20.16Z"
]
7 => array:11 [
"RoomKey" => "1653466621"
"RoomType" => "Primary Bedroom"
"ListingId" => "40833512"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29855687"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
…1
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29855687/86-upper-mercer-street-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1488
+"OriginalEntryTimestamp": "2026-06-04T19:32:56.87Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1069813"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29855687')"
+"ID": "1495679"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1491765"
+post_author: 1
+"ListingKey": "29849876"
+"ListingId": "X13236860"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T22:01:14Z"
+"RFModificationTimestamp": "2026-06-03T22:29:04Z"
+"ListPrice": 1475000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A0K3"
+"UnparsedAddress": "554 BRIDGEMILL CRESCENT E, Kitchener, Ontario N2A0K3"
+"Coordinates": array:2 [
0 => -80.41421
1 => 43.453362
]
+"Latitude": 43.453362
+"Longitude": -80.41421
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Luxury living in prestigious Lackner Woods! This exceptional 4,675 sq. ft. residence offers a rare blend of elegance, functionality, and income potential, featuring 4 spacious bedrooms-each with its own private ensuite-plus a finished walkout basement with 2-bedroom in-lawsuite.Situated in one of Kitchener's most desirable family-friendly communities, this home is just steps to top-rated schools, scenic walking trails along the Grand River, and minutes to Chicopee Ski Club, offering year-round lifestyle appeal. With extensive structural upgrades, this home is designed to impress. Enjoy 9' ceilings on all three levels, hardwood flooring throughout, and an abundance of natural light through oversized 12'patio doors. The open-concept main floor showcases a stunning transitional kitchen featuring custom Treasure Island cabinetry, premium Cambria quartz countertops, a custom range hood, and built-in Bosch appliances. The spacious living area is anchored by a striking 42" doublesided Marquis Bentley fireplace, perfect for both everyday living and entertaining.The thoughtfully designed layout includes a second-floor family room-ideal as a lounge or children's retreat-and a private main-floor office with separate garage access, perfectly suited for a home business or quiet workspace. A fully finished walkout basement adds incredible flexibility, complete with a private 2-bedroom in-law suite-perfect for multigenerational living or income potential. (id:62783)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
13 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-06-03T22:28:54.770800+00:00"
+"Directions": "Cross Streets: BRIDGEMILL CRES. ** Directions: Zeller Dr & Bridgemill Cres."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127798"
+"ListOfficeKey": "277399"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 105.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T21:51:51Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T21:51:51Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Bridgemill"
+"StreetNumber": "554"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "9930"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29849876/554-bridgemill-crescent-e-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-03T21:51:50.97Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1381042"
+"ListOfficeNationalAssociationId": "1282815"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29849876')"
+"ID": "1491765"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25164
+post_id: "1490656"
+post_author: 1
+"ListingKey": "29847261"
+"ListingId": "40836209"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T17:30:50Z"
+"RFModificationTimestamp": "2026-06-03T17:55:34Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2453.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A0K4"
+"UnparsedAddress": "30 WATERBOW Trail, Kitchener, Ontario N2A0K4"
+"Coordinates": array:2 [
0 => -80.3987649
1 => 43.4515822
]
+"Latitude": 43.4515822
+"Longitude": -80.3987649
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 30 Waterbow Trail, a beautifully upgraded home built by New Lifestyle Homes and located in Kitchener’s family-friendly Lackner Woods community. Offering over 2,450 sq. ft. of finished living space, this 4-bedroom, 3.5-bathroom home combines quality craftsmanship with thoughtful design throughout. The main floor features premium hardwood flooring, a spacious open-concept layout, and a stunning Kitchen complete with upgraded cabinetry, stainless steel appliances, a subway tile backsplash, and a large pantry. The upper level offers a spacious Primary Bedroom with a walk-in closet and private 4-piece en-suite, along with three additional bedrooms, a full bathroom, and a skylight that fills the space with natural light. The fully finished Basement adds valuable living space and includes a 3-piece bathroom, making it ideal for a recreation room, home office, guest area, or growing family. Step outside to enjoy a private, fully fenced backyard featuring multiple deck spaces, a gazebo, and beautiful landscaping that creates the perfect setting for entertaining or relaxing. This is a home that has been exceptionally well cared for and offers the space, upgrades, and location that today’s buyers are looking for. Book your private showing today! (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T17:55:30.019967+00:00"
+"Directions": "Valleybrook dr/Waterbow tr"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104178"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Corner Site"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T17:13:46Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T17:13:46Z"
+"Stories": "2.0"
+"StreetName": "WATERBOW"
+"StreetNumber": "30"
+"StreetSuffix": "Trail"
+"SubdivisionName": "228 - Chicopee/Freeport"
+"TaxAnnualAmount": "6064"
+"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/29847261/30-waterbow-trail-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 55.0
+"AboveGradeFinishedArea": 2003
+"BelowGradeFinishedArea": 450
+"OriginalEntryTimestamp": "2026-06-03T17:10:51.81Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1373627"
+"ListOfficeNationalAssociationId": "1438749"
+"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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29847261')"
+"ID": "1490656"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+post_id: "1486925"
+post_author: 1
+"ListingKey": "29842283"
+"ListingId": "40835624"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T20:25:45Z"
+"RFModificationTimestamp": "2026-06-02T23:14:44Z"
+"ListPrice": 969999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2689.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A0A3"
+"UnparsedAddress": "369 ZELLER Drive, Kitchener, Ontario N2A0A3"
+"Coordinates": array:2 [
0 => -80.4125499
1 => 43.4538132
]
+"Latitude": 43.4538132
+"Longitude": -80.4125499
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Custom-built Beautifully Upgraded Bungalow and one of a select few of its kind in Kitchener. Boasting 4 bedrooms, 3 full bathrooms, and over 2,700 square feet of impeccably finished living space, this home is filled with thoughtful upgrades. From the moment you arrive, the concrete driveway & walkway guide you past professionally landscaped grounds with zero grass to maintain. A welcoming main entry opens into an elegant, sun-drenched open-concept layout. The grand foyer flows seamlessly into a spectacular great room, anchored by a gas fireplace for evening relaxation. The kitchen is equipped with granite countertops, ceramic backsplash, stainless-steel appliances, and an abundance of premium cabinetry. Directly off the kitchen, step outside to your private outdoor retreat: a covered porch perfect for alfresco dining, rain or shine. The home is carpet-free with gleaming hardwood flooring, all illuminated by pot lights. The main-floor primary suite is a peaceful haven, complete with a 3-piece ensuite bath featuring granite counters. The 2nd main-floor bedroom enjoys convenient access to its own full 4-piece bathroom. Main floor mudroom provides a seamless access to the oversized garage. The lower level of this property is an incredible asset: a fully finished, legal 2-bedroom apartment with its own completely private separate entrance and dedicated laundry facilities. Perfect as rental, independent living for adult children, or an elite multi-generational setup, this expansive space mirrors the quality of the main floor. It features a full kitchen, a living room and electric fireplace, 4-piece bathroom, 2 bedrooms, and an abundance of storage space. Situated in a fully fenced yard with both covered front & back porches, this home offers the ultimate blend of lock-and-leave convenience and executive luxury. Located just minutes from top-rated schools, shopping & highway access, and just steps from the scenic Grand River Trail system. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T23:14:41.907753+00:00"
+"Directions": "Lackner to Zeller Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564437"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T20:19:17Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T20:19:17Z"
+"Stories": "1.0"
+"StreetName": "ZELLER"
+"StreetNumber": "369"
+"StreetSuffix": "Drive"
+"SubdivisionName": "232 - Idlewood/Lackner Woods"
+"TaxAnnualAmount": "6471"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/369_zeller_dr_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29842283/369-zeller-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1992792"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1564379"
+"CoListAgentKey3": "1921771"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "289541"
+"CoListOfficeKey3": "76840"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RES-2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 1371
+"BelowGradeFinishedArea": 1318
+"OriginalEntryTimestamp": "2026-06-02T20:19:17.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1115807"
+"ListOfficeNationalAssociationId": "1004363"
+"CoListAgentNationalAssociationId": "1276055"
+"CoListAgentNationalAssociationId2": "1070065"
+"CoListAgentNationalAssociationId3": "1227142"
+"CoListOfficeNationalAssociationId": "1378680"
+"CoListOfficeNationalAssociationId2": "1378680"
+"CoListOfficeNationalAssociationId3": "1004363"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29842283')"
+"ID": "1486925"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1484241"
+post_author: 1
+"ListingKey": "29839696"
+"ListingId": "X13227830"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T20:40:35Z"
+"RFModificationTimestamp": "2026-06-04T20:59:37Z"
+"ListPrice": 939900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A4L9"
+"UnparsedAddress": "27 TREMAINE DRIVE, Kitchener, Ontario N2A4L9"
+"Coordinates": array:2 [
0 => -80.412809
1 => 43.442707
]
+"Latitude": 43.442707
+"Longitude": -80.412809
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 27 Tremaine Drive, Kitchener: a stunning detached 2-storey home in the highly sought-after Edgewater Estates community, backing onto a picturesque ravine with no rear neighbors. This exceptional 4-bedroom, 3-bathroom house is truly a place you'll be proud to call home. Drive into this well-maintained house offering parking for 4 vehicles (2-car garage, 2-car driveway). Step inside the inviting foyer, the main level features multi-level layout designed for everyday living. The kitchen features ample cabinetry, quality appliances, a centre island and a bright breakfast area overlooking the breathtaking backyard. Adjacent, the dining room is ideal for family dinners and gatherings. The main-floor laundry room adds convenience. A few steps down, there is a family room, ideal for movie nights and game days. A few steps up, the elegant living room offers a cozy retreat, perfect for a home office, playroom or hobby space. The upper-level features 4 generously sized bedrooms, including a spectacular primary retreat with soaring ceilings, a private ensuite complete with heated tile flooring. Another bedroom boasts its own private balcony, while the spacious main bathroom features a sun tunnel that fills the space with natural light. The unfinished basement offers endless possibilities. Updates include a furnace, AC, washer and dryer (2022), refrigerator (2025), painting (2024) and an in-ground sprinkler system. Step outside to your private oasis, offering 2-tier deck for entertaining and relaxing, with access from both the breakfast area and living room. A walkout from the family room creates seamless indoor-outdoor living. Backing onto a scenic trail with peaceful views and the Grand River nearby, this property offers exceptional setting. Just steps away from Chicopee Hill, ideally located close to trails, parks, schools, shopping, dining, public transit and Highway 401. This house checks all boxes and can be your forever home. Book your private showing today! (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T17:00:10.691545+00:00"
+"Directions": "Cross Streets: Fairway Cres. ** Directions: Fairway Cres To Tremaine 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": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "45.1 x 105 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T16:00:11Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T20:30:29Z"
+"Stories": "2.0"
+"StreetName": "Tremaine"
+"StreetNumber": "27"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6553"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/rmi4y_27_tremaine_dr_kitchener_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/29839696/27-tremaine-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 45.1
+"OriginalEntryTimestamp": "2026-06-02T16:00:11.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839696')"
+"ID": "1484241"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25161
+post_id: "1484184"
+post_author: 1
+"ListingKey": "29839226"
+"ListingId": "40834258"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T19:41:09Z"
+"RFModificationTimestamp": "2026-06-03T19:46:25Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1848.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A4N2"
+"UnparsedAddress": "142 UPPER MERCER Street, Kitchener, Ontario N2A4N2"
+"Coordinates": array:2 [
0 => -80.403511
1 => 43.445738
]
+"Latitude": 43.445738
+"Longitude": -80.403511
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully updated and finished from top to bottom, this END-unit townhouse offers exceptional living space, thoughtful upgrades, and a location that combines everyday convenience with access to nature. Just down the road from the Grand River and hiking trails, plus handy to highway access, it delivers the best of natural spaces and routes to the GTA and beyond. A spacious foyer creates a welcoming first impression and leads into a sun-filled living room where large windows bring in abundant natural light. The eat-in kitchen is designed for gathering, featuring quartz countertops, a stylish backsplash, rich cabinetry, and custom built-in bench seating and shelving, providing ample space for family dinners and entertaining. Sliding doors open to a fully fenced backyard complete with an expansive deck and convenient storage shed—an ideal setting for summer barbecues, outdoor dining, or simply relaxing outdoors. Upstairs, the bright primary suite features a walk-in closet, elegant cathedral-style window detail, and an updated 4-piece ensuite bath. Two additional bedrooms, a beautifully updated 5-piece family bathroom, and a dedicated enclosed office provide the flexibility today's buyers are looking for. The finished basement adds even more living space, perfect for movie nights, home gym, or hobby area. Ample storage is available, and plumbing has already been roughed in for a future bathroom. Additional highlights include an oversized garage, parking for two vehicles in the driveway, a newer roof (2022), and a new furnace (2026). Located just down the street from the Grand River, with a canoe and kayak launch and access to miles of scenic trails, this move-in-ready home is ready to be enjoyed from day one. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T16:45:39.002016+00:00"
+"Directions": "Fairway Rd to Upper Mercer St"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600590"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T15:05:05Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T19:31:28Z"
+"Stories": "2.0"
+"StreetName": "UPPER MERCER"
+"StreetNumber": "142"
+"StreetSuffix": "Street"
+"SubdivisionName": "232 - Idlewood/Lackner Woods"
+"TaxAnnualAmount": "4395.57"
+"VirtualTourURLUnbranded": "https://youriguide.com/142_upper_mercer_st_kitchener_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/29839226/142-upper-mercer-street-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1881545"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1750730"
+"CoListOfficeKey": "289541"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "76840"
+"ZoningDescription": "Res 5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1651
+"BelowGradeFinishedArea": 197
+"OriginalEntryTimestamp": "2026-06-02T15:05:05.54Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1152043"
+"ListOfficeNationalAssociationId": "1378680"
+"CoListAgentNationalAssociationId": "1206820"
+"CoListAgentNationalAssociationId2": "1066204"
+"CoListOfficeNationalAssociationId": "1378680"
+"CoListOfficeNationalAssociationId2": "1004363"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839226')"
+"ID": "1484184"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23345
+post_id: "1484061"
+post_author: 1
+"ListingKey": "29839234"
+"ListingId": "40833462"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:47Z"
+"RFModificationTimestamp": "2026-06-06T20:47:50Z"
+"ListPrice": 939900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2031.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A4L9"
+"UnparsedAddress": "27 TREMAINE Drive, Kitchener, Ontario N2A4L9"
+"Coordinates": array:2 [
0 => -80.4128431
1 => 43.4427244
]
+"Latitude": 43.4427244
+"Longitude": -80.4128431
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 27 Tremaine Drive, Kitchener: a stunning detached 2-storey home in the highly sought-after Edgewater Estates community, backing onto a picturesque ravine with no rear neighbors. This exceptional 4-bedroom, 3-bathroom house is truly a place you'll be proud to call home. Drive into this well-maintained house offering parking for 4 vehicles (2-car garage, 2-car driveway). Step inside the inviting foyer, the main level features multi-level layout designed for everyday living. The kitchen features ample cabinetry, quality appliances, a centre island and a bright breakfast area overlooking the breathtaking backyard. Adjacent, the dining room is ideal for family dinners and gatherings. The main-floor laundry room adds convenience. A few steps down, there is a family room, ideal for movie nights and game days. A few steps up, the elegant living room offers a cozy retreat, perfect for a home office, playroom or hobby space. The upper-level features 4 generously sized bedrooms, including a spectacular primary retreat with soaring ceilings, a private ensuite complete with heated tile flooring. Another bedroom boasts its own private balcony, while the spacious main bathroom features a sun tunnel that fills the space with natural light. The unfinished basement offers endless possibilities. Updates include a furnace, AC, washer and dryer (2022), refrigerator (2025), painting (2024) and an in-ground sprinkler system. Step outside to your private oasis, offering 2-tier deck for entertaining and relaxing, with access from both the breakfast area and living room. A walkout from the family room creates seamless indoor-outdoor living. Backing onto a scenic trail with peaceful views and the Grand River nearby, this property offers exceptional setting. Just steps away from Chicopee Hill, ideally located close to trails, parks, schools, shopping, dining, public transit and Highway 401. This house checks all boxes and can be your forever home. Book your private showing today! (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T16:30:31.539749+00:00"
+"Directions": "Fairway Cres To Tremaine Dr"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Ravine"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Sump Pump"
5 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T15:07:45Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:22:21Z"
+"Stories": "2.0"
+"StreetName": "TREMAINE"
+"StreetNumber": "27"
+"StreetSuffix": "Drive"
+"SubdivisionName": "232 - Idlewood/Lackner Woods"
+"TaxAnnualAmount": "6553"
+"VirtualTourURLUnbranded": "https://youriguide.com/rmi4y_27_tremaine_dr_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/29839234/27-tremaine-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RES-2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2031
+"OriginalEntryTimestamp": "2026-06-02T15:07:45.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839234')"
+"ID": "1484061"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1483971"
+post_author: 1
+"ListingKey": "29839002"
+"ListingId": "40816259"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:35:25Z"
+"RFModificationTimestamp": "2026-06-06T20:45:26Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1430.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A0B8"
+"UnparsedAddress": "7 UPPER MERCER Street, Kitchener, Ontario N2A0B7"
+"Coordinates": array:2 [
0 => -80.4075567
1 => 43.4465796
]
+"Latitude": 43.4465796
+"Longitude": -80.4075567
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning, freshly painted, move-in-ready freehold townhome offering 3 bedrooms, 3.5 bathrooms, and a fully finished basement. The bright, modern kitchen features quartz countertops, a center island, stylish backsplash, white cabinetry, and stainless steel appliances. Upstairs, you'll find spacious bedrooms, including a primary suite with an ensuite bathroom, two full bathrooms, and a large family room perfect for relaxing or entertaining. The finished basement provides additional living space with a generous rec room and full bathroom. Step outside to enjoy the beautiful large deck, perfect for summer BBQs, outdoor dining, and entertaining family and friends. Conveniently located near Hwy 401, schools, Toyota, shopping, parks, and Chicopee Ski Resort, this home combines comfort, style, and an unbeatable location. Don't miss your opportunity to call this beautiful property home! (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Wine Fridge"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T15:58:44.483240+00:00"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2106354"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T17:24:54Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:25:36Z"
+"Stories": "2.0"
+"StreetName": "UPPER MERCER"
+"StreetNumber": "7"
+"StreetSuffix": "Street"
+"SubdivisionName": "232 - Idlewood/Lackner Woods"
+"TaxAnnualAmount": "4382"
+"VirtualTourURLUnbranded": "https://youriguide.com/g30_7_upper_mercer_st_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29839002/7-upper-mercer-street-unit-g30-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 1430
+"OriginalEntryTimestamp": "2026-06-02T14:43:09.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1375481"
+"ListOfficeNationalAssociationId": "1004415"
+"Media": array:36 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839002')"
+"ID": "1483971"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1484082"
+post_author: 1
+"ListingKey": "29838132"
+"ListingId": "40834398"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T16:11:06Z"
+"RFModificationTimestamp": "2026-06-03T16:19:43Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3398.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2A4N3"
+"UnparsedAddress": "125 WOOLNER Trail, Kitchener, Ontario N2A4N3"
+"Coordinates": array:2 [
0 => -80.4024552
1 => 43.4447529
]
+"Latitude": 43.4447529
+"Longitude": -80.4024552
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Some homes check the boxes. This one changes the standard. This beautiful bungalow was built by Fusion Homes in 2011 and positioned on one of the most desirable lots in the neighbourhood. This exceptional property offers over 63 feet of frontage, no neighbour on one side, no neighbours behind, and backs directly onto the natural beauty of Idlewood Creek. Just steps from the Grand River, it's a setting that delivers privacy, tranquility, and a connection to nature that is increasingly difficult to find. The curb appeal is undeniable. Professionally designed by a landscape architect, the grounds feature premium landscaping, an irrigation system, low-maintenance turf in the backyard, and a composite deck, creating a polished outdoor environment that's as beautiful as it is practical. Inside, the home blends comfort and sophistication. The great room is anchored by soaring vaulted ceilings, creating an impressive sense of scale and natural light. The kitchen is finished with quartz countertops and offers the perfect space for gathering, entertaining, and everyday living. The primary suite is complete with a walk-in closet and a luxury hotel-like feel ensuite bathroom, featuring a double vanity, glass walk-in shower, and private water closet. Thoughtful upgrades continue throughout the home, including main floor laundry, central vacuum, and pre-wiring for ceiling speakers. The finished lower level provides exceptional flexibility, including a bedroom equipped with a built-in Murphy bed—ideal for guests, a home office, or multi-purpose living. The garage is every enthusiast's dream: heated, insulated doors, powered by a 200-amp electrical service, EV charger and finished in iconic Harley-Davidson colours. Opportunities like this are rare. A premium lot. Exceptional privacy. Nature at your doorstep. A home designed to be enjoyed today and appreciated for years to come. Welcome to one of the finest offerings in the Idlewood Creek Neighbourhood. Don't miss it. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dryer"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T13:56:39.330552+00:00"
+"Directions": "Last house on the right on Woolner Trail."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1784347"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T11:49:46Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T16:01:58Z"
+"Stories": "1.0"
+"StreetName": "WOOLNER"
+"StreetNumber": "125"
+"StreetSuffix": "Trail"
+"SubdivisionName": "232 - Idlewood/Lackner Woods"
+"TaxAnnualAmount": "6526"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "River view"
+"VirtualTourURLUnbranded": "https://youriguide.com/125_woolner_trail_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29838132/125-woolner-trail-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RES-2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 63.0
+"AboveGradeFinishedArea": 1688
+"BelowGradeFinishedArea": 1710
+"OriginalEntryTimestamp": "2026-06-02T11:49:45.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1188300"
+"ListOfficeNationalAssociationId": "1004357"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29838132')"
+"ID": "1484082"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 39
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]