array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30069106 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23528
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23530
+post_id: "1652327"
+post_author: 1
+"ListingKey": "30069106"
+"ListingId": "40850510"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T17:10:05Z"
+"RFModificationTimestamp": "2026-07-23T17:16:08Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1108.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "543 DRUMMERHILL Crescent, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.5529466
1 => 43.4462309
]
+"Latitude": 43.4462309
+"Longitude": -80.5529466
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great Location! Welcome to this beautiful detached home in the highly sought-after Westvale neighbourhood. Situated on a quiet, family-friendly crescent, this carpet-free home is conveniently located near top-rated schools, shopping, parks, trails, transit, and just minutes from Uptown Waterloo, the University of Waterloo, Costco, Walmart, medical centres, restaurants, and highway access. This well-maintained single-family home features 3 bedrooms, 2 bathrooms, a single-car garage, parking for three vehicles, and a finished recreation room. The bright main floor offers hardwood flooring, a 2-piece powder room, direct garage access, and sliding doors leading to a fully fenced backyard with a spacious deck—perfect for family gatherings and outdoor entertaining. Upstairs, you'll find three generous bedrooms and a beautifully renovated bathroom. The basement is nearly complete, featuring a finished rec room and a framed 3-piece bathroom rough-in, offering excellent potential for additional living space. Move-in ready and located in one of Waterloo's most desirable family communities, this is a fantastic opportunity you won't want to miss! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T16:24:16.671388+00:00"
+"Directions": "Fischer-Hallman to Thorndale, left onto Westvale, right onto Drummerhill Crescent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T17:02:44Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T17:02:44Z"
+"Stories": "2.0"
+"StreetName": "DRUMMERHILL"
+"StreetNumber": "543"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "3852.78"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1691766231"
"RoomType" => "Utility room"
"ListingId" => "40850510"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.24Z"
]
1 => array:11 [
"RoomKey" => "1691766232"
"RoomType" => "Laundry room"
"ListingId" => "40850510"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.24Z"
]
2 => array:11 [
"RoomKey" => "1691766233"
"RoomType" => "Recreation room"
"ListingId" => "40850510"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 20'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.24Z"
]
3 => array:11 [
"RoomKey" => "1691766234"
"RoomType" => "4pc Bathroom"
"ListingId" => "40850510"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.24Z"
]
4 => array:11 [
"RoomKey" => "1691766235"
"RoomType" => "Bedroom"
"ListingId" => "40850510"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.24Z"
]
5 => array:11 [
"RoomKey" => "1691766236"
"RoomType" => "Bedroom"
"ListingId" => "40850510"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.24Z"
]
6 => array:11 [
"RoomKey" => "1691766237"
"RoomType" => "Primary Bedroom"
"ListingId" => "40850510"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.24Z"
]
7 => array:11 [
"RoomKey" => "1691766238"
"RoomType" => "2pc Bathroom"
"ListingId" => "40850510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.24Z"
]
8 => array:11 [
"RoomKey" => "1691766239"
"RoomType" => "Dining room"
"ListingId" => "40850510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.25Z"
]
9 => array:11 [
"RoomKey" => "1691766240"
"RoomType" => "Living room"
"ListingId" => "40850510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.25Z"
]
10 => array:11 [
"RoomKey" => "1691766241"
"RoomType" => "Kitchen"
"ListingId" => "40850510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30069106"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:08:46.25Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30069106/543-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SD-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1108
+"OriginalEntryTimestamp": "2026-07-23T11:48:32.74Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30069106_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/9c7db17616203ea70144889e832209ff.webp"
"MediaSize" => 150692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-9c7db17616203ea70144889e832209ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-toned brick and siding"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.38Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30069106_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/7dc906f872b4d77579876ce105462fc4.webp"
"MediaSize" => 138283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-7dc906f872b4d77579876ce105462fc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a front lawn and paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30069106_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/3daa09c09078c4388a45d1300e0b56e5.webp"
"MediaSize" => 139145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-3daa09c09078c4388a45d1300e0b56e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front exterior featuring brick and siding facade, an attached single-car garage, a paved driveway, a wooden deck with railings, and a landscaped front yard with mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.57Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30069106_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/7f6cfd8cf4447768ac631ecc49fea886.webp"
"MediaSize" => 149305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-7f6cfd8cf4447768ac631ecc49fea886.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring an attached garage with a light gray door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.38Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30069106_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/62d69acac785d70c22d229fa36789c3d.webp"
"MediaSize" => 170931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-62d69acac785d70c22d229fa36789c3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Red-stained wood deck featuring white vertical railings and a latticework foundation"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.38Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30069106_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/2b5ba6c7d272f3d6f0006d0b1964801c.webp"
"MediaSize" => 38996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-2b5ba6c7d272f3d6f0006d0b1964801c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.58Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30069106_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/8ae6af70453e9de94adebf7496e3213f.webp"
"MediaSize" => 63792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-8ae6af70453e9de94adebf7496e3213f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30069106_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/eefe21aef37fc54615304dedcf3197c7.webp"
"MediaSize" => 41122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-eefe21aef37fc54615304dedcf3197c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room featuring a shiplap accent wall, white vanity with integrated sink, chrome faucet, and patterned floor tile"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30069106_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/c37fb597d95269da8c5f6b30f903afeb.webp"
"MediaSize" => 83775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-c37fb597d95269da8c5f6b30f903afeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, dark countertops, a mosaic tile backsplash, wood-finish flooring, and a stainless steel stove with an overhead range hood"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.38Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30069106_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/034adf8557fdb438fe3c2ac39b9f9f43.webp"
"MediaSize" => 62656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-034adf8557fdb438fe3c2ac39b9f9f43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, dark countertops, and a mosaic tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.38Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30069106_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/3fceb919141135808542de7902d3d8b3.webp"
"MediaSize" => 71473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-3fceb919141135808542de7902d3d8b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, dark countertops, a tiled backsplash, stainless steel appliances, and dark wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.38Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30069106_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/5bbb16e2f71b90e7c9df3577419c9374.webp"
"MediaSize" => 79281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-5bbb16e2f71b90e7c9df3577419c9374.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, dark countertops, a mosaic tile backsplash, and a double stainless steel sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.38Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30069106_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/7e6631e2f93ba48c3811e14d5d26a874.webp"
"MediaSize" => 69083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-7e6631e2f93ba48c3811e14d5d26a874.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring dark wood-finish flooring and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30069106_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/61b0050434fbaa5632b58fbebc6d4cc7.webp"
"MediaSize" => 89874
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-61b0050434fbaa5632b58fbebc6d4cc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring dark wood-finish flooring, light grey wall paint, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:52.38Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30069106_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/d8c326ef4417e2b167f803a3fc953680.webp"
"MediaSize" => 75644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-d8c326ef4417e2b167f803a3fc953680.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with wood-finish flooring and a contemporary chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30069106_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/e2596f89c93cdac248b115b9b519b3a6.webp"
"MediaSize" => 83425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-e2596f89c93cdac248b115b9b519b3a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept dining and living area featuring dark wood-finish flooring, a contemporary chandelier, and a sliding glass door leading to an outdoor deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30069106_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/cb44aa9052b9f8d19f0f46b894e9d841.webp"
"MediaSize" => 36533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-cb44aa9052b9f8d19f0f46b894e9d841.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stairwell featuring a skylight, a semi-flush mount ceiling fixture, and a wood handrail with white balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.61Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30069106_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/3c37d593e14c1d2d5e02009bd378b29e.webp"
"MediaSize" => 55969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-3c37d593e14c1d2d5e02009bd378b29e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring a single window with a wood-finish frame, light green painted walls, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.82Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30069106_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/9f83d90405232d360b1449cc1aa5d954.webp"
"MediaSize" => 54096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-9f83d90405232d360b1449cc1aa5d954.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a gray subway tile shower surround, a white shower curtain, and a window with privacy glass"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.61Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30069106_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/c0b05467dd5f22a7ce05ad8580cdd9ce.webp"
"MediaSize" => 41075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-c0b05467dd5f22a7ce05ad8580cdd9ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brushed nickel chandelier with a frosted glass bowl shade and decorative scrolling arms"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30069106_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/7d51fc68f8bb842f6416d52e821ff411.webp"
"MediaSize" => 73058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-7d51fc68f8bb842f6416d52e821ff411.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring dark wood-finish flooring, a decorative accent wall, crown molding, and a drum chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.65Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30069106_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/383965a5e292707dee0ed50467a3dad0.webp"
"MediaSize" => 63800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-383965a5e292707dee0ed50467a3dad0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rich wood-finish flooring complements the detailed white wainscoting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30069106_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/6e2a9e95ec8cd920eb5beba081909c48.webp"
"MediaSize" => 83239
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-6e2a9e95ec8cd920eb5beba081909c48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a dark-painted ceiling, crown molding, and white paneled accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.87Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30069106_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/6a34e19703821c1a2d82739d49de3c47.webp"
"MediaSize" => 60028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-6a34e19703821c1a2d82739d49de3c47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light-toned walls with tree-themed wall art"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30069106_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/79bcd6e29ad5d5e7440eee731b70f994.webp"
"MediaSize" => 50417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-79bcd6e29ad5d5e7440eee731b70f994.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a wall with tree-patterned decor, a built-in closet with bifold doors, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30069106_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/d62331bb774d19abcd55b586b33d5b62.webp"
"MediaSize" => 101857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-d62331bb774d19abcd55b586b33d5b62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Utility room featuring a laundry sink, exposed wood ceiling joists, and a water heater"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.61Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30069106_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/9fc1535261017c9a73186b3eb7d4042a.webp"
"MediaSize" => 48780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-9fc1535261017c9a73186b3eb7d4042a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Lower level room featuring light wood-finish flooring, light blue wall paint, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.64Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30069106_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/8b2b4a51a3ab3a1a36531f2318d69f59.webp"
"MediaSize" => 47999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-8b2b4a51a3ab3a1a36531f2318d69f59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recessed window providing natural light, light wood-finish flooring, overhead track lighting, and a built-in wood cabinet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.65Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30069106_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/db1e3d30a8077170023da5fe53112642.webp"
"MediaSize" => 49017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-db1e3d30a8077170023da5fe53112642.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light wood-finish flooring and a light blue wall color"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30069106_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/a1e4a0a1473dfa1978226d7ddff0cfe5.webp"
"MediaSize" => 59334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-a1e4a0a1473dfa1978226d7ddff0cfe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Versatile room featuring light wood-finish flooring, a track lighting fixture, and a window with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.65Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30069106_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/21aa66757c29143ed6beebfa4553451d.webp"
"MediaSize" => 47836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-21aa66757c29143ed6beebfa4553451d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Versatile room featuring light wood-finish flooring, light blue wall paint, white baseboards, and a white ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.65Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30069106_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/edc04f280c9ccc3a14953bd45e23b98e.webp"
"MediaSize" => 83872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-edc04f280c9ccc3a14953bd45e23b98e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.65Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30069106_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/e4ada12935569bdbedeb3f4c47b29a26.webp"
"MediaSize" => 170374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-e4ada12935569bdbedeb3f4c47b29a26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Red-stained wood deck with white painted railings overlooking a green lawn with a large mature tree"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30069106_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/d4d72242f22d625cadaa5ee221d41f8a.webp"
"MediaSize" => 178741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-d4d72242f22d625cadaa5ee221d41f8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a mature tree, a tiered deck with white railings, a bay window, and a sliding glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:53.83Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30069106_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30069106/ef3afe4997693318754509218fbbfa6c.webp"
"MediaSize" => 169224
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30069106/thumbnail-ef3afe4997693318754509218fbbfa6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive rear yard featuring a multi-level wood deck with white railings, a partial brick and siding exterior, a bay window, and a wooden fence enclosing the property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850510"
"ResourceRecordKey" => "30069106"
"ModificationTimestamp" => "2026-07-23T16:12:51.81Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30069106')"
+"ID": "1652327"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 295659" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25018
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24961
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Peaceland Realty"
+"OfficeEmail": null
+"OfficePhone": "226-666-9766"
+"OfficeMlsId": "WR50789"
+"ModificationTimestamp": "2026-03-24T17:19:43Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "295659"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "279 Weber St. N. Unit 20A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2J3H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1452740"
+"OriginalEntryTimestamp": "2023-11-09T14:28:00Z"
+"OfficeFax": "905-707-0288"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "335094"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "295659"
"SocialMediaUrlOrId" => "http://www.peacelandrealty.com/"
"ModificationTimestamp" => "2026-03-24T16:37:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1452745"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('295659')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1955745" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25041
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30069106'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25339
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30069106' AND OpenHouseDate ge '2026-07-23'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25355
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30069106' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5529466 43.4462309)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25472
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25443
+post_id: "1652990"
+post_author: 1
+"ListingKey": "30070839"
+"ListingId": "40850520"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:45:06Z"
+"RFModificationTimestamp": "2026-07-23T19:32:17Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2266.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3R7"
+"UnparsedAddress": "59 IRON GATE Street, Kitchener, Ontario N2N3R7"
+"Coordinates": array:2 [
0 => -80.5561378
1 => 43.4380116
]
+"Latitude": 43.4380116
+"Longitude": -80.5561378
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "ABSOLUTELY STUNNING & FULLY RENOVATED FROM TOP TO BOTTOM! Welcome to this superb freehold home, offered for the first time in a highly desirable, family-oriented Waterloo neighbourhood with NO REAR NEIGHBOURS! Perfectly carpet free and freshly painted, this residence blends modern luxury with ultimate convenience. The main level boasts a bright, open layout featuring a newly updated kitchen complete with gorgeous quartz countertops, a stylish new backsplash, and stainless steel appliances. Walk up the beautifully updated staircase to find 3 generous bedrooms and updated bathrooms. In total, this home features 3 spacious bedrooms and 4 completely renovated, well-appointed bathrooms! The fully finished basement features large windows that flood the space with natural light, offering the perfect setup for your recreational space. Every detail has been taken care of: new flooring throughout, updated modern light fixtures, and a brand-new water softener. Unbeatable location just minutes from The Boardwalk Shopping Centre, excellent schools, and top-tier institutions including the University of Waterloo and Wilfred Laurier University. Move-in ready with zero renovation hassle just turn the key and settle into this wonderful community. Schedule your private viewing today before it’s gone! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:32:05.590879+00:00"
+"Directions": "University Ave West to Countrystone Drive to Iron Gate Street."
+"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": "1981149"
+"ListOfficeKey": "135429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:38:10Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:38:10Z"
+"Stories": "2.0"
+"StreetName": "IRON GATE"
+"StreetNumber": "59"
+"StreetSuffix": "Street"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4569"
+"VirtualTourURLUnbranded": "https://youriguide.com/59_iron_gate_st_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1691786997"
"RoomType" => "Laundry room"
"ListingId" => "40850520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
1 => array:11 [
"RoomKey" => "1691786998"
"RoomType" => "3pc Bathroom"
"ListingId" => "40850520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
2 => array:11 [
"RoomKey" => "1691786999"
"RoomType" => "Recreation room"
"ListingId" => "40850520"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
3 => array:11 [
"RoomKey" => "1691787000"
"RoomType" => "Full bathroom"
"ListingId" => "40850520"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
4 => array:11 [
"RoomKey" => "1691787001"
"RoomType" => "4pc Bathroom"
"ListingId" => "40850520"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
5 => array:11 [
"RoomKey" => "1691787002"
"RoomType" => "Bedroom"
"ListingId" => "40850520"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
6 => array:11 [
"RoomKey" => "1691787003"
"RoomType" => "Bedroom"
"ListingId" => "40850520"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
7 => array:11 [
"RoomKey" => "1691787004"
"RoomType" => "Primary Bedroom"
"ListingId" => "40850520"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => "21'2'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
8 => array:11 [
"RoomKey" => "1691787005"
"RoomType" => "2pc Bathroom"
"ListingId" => "40850520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
9 => array:11 [
"RoomKey" => "1691787006"
"RoomType" => "Dining room"
"ListingId" => "40850520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
10 => array:11 [
"RoomKey" => "1691787007"
"RoomType" => "Living room"
"ListingId" => "40850520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
11 => array:11 [
"RoomKey" => "1691787008"
"RoomType" => "Kitchen"
"ListingId" => "40850520"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30070839"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T16:38:10.61Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070839/59-iron-gate-street-kitchener"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 26.0
+"AboveGradeFinishedArea": 1622
+"BelowGradeFinishedArea": 644
+"OriginalEntryTimestamp": "2026-07-23T16:38:10.57Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1266646"
+"ListOfficeNationalAssociationId": "1195809"
+"Media": array:39 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30070839_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/158af51517e121f8dcd3ee982cb6d24e.webp"
"MediaSize" => 105948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-158af51517e121f8dcd3ee982cb6d24e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30070839_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/d318271283ac7fd532ea5d12b4ebebb5.webp"
"MediaSize" => 52622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-d318271283ac7fd532ea5d12b4ebebb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30070839_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/2f00eaf18d6e2cfb384841d432fe68cb.webp"
"MediaSize" => 40425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-2f00eaf18d6e2cfb384841d432fe68cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30070839_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/c6e1eee283aed0d405fa0920fe21144c.webp"
"MediaSize" => 43253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-c6e1eee283aed0d405fa0920fe21144c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30070839_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/66b6fb98dd46fd5481f861d8fa761c02.webp"
"MediaSize" => 51644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-66b6fb98dd46fd5481f861d8fa761c02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30070839_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/0250eb7e44f6edd253641b50bc06d22a.webp"
"MediaSize" => 41950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-0250eb7e44f6edd253641b50bc06d22a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30070839_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/9c321797eb18447754ae43e17bc9a970.webp"
"MediaSize" => 46200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-9c321797eb18447754ae43e17bc9a970.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30070839_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/f1659fe6826e03c89be73a35a628cd9f.webp"
"MediaSize" => 49996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-f1659fe6826e03c89be73a35a628cd9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30070839_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/3e9adbbb1d35e71df9c624e375b6d050.webp"
"MediaSize" => 48515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-3e9adbbb1d35e71df9c624e375b6d050.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30070839_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/f4fe8befdc65bf7568482d3d68145c16.webp"
"MediaSize" => 37627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-f4fe8befdc65bf7568482d3d68145c16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30070839_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/745ab2ff3f2485413c8588ee2e0f71a7.webp"
"MediaSize" => 37274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-745ab2ff3f2485413c8588ee2e0f71a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30070839_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/27a0eb80cd1bce4f907c9b92fdfaad74.webp"
"MediaSize" => 40212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30070839/thumbnail-27a0eb80cd1bce4f907c9b92fdfaad74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850520"
"ResourceRecordKey" => "30070839"
"ModificationTimestamp" => "2026-07-23T16:38:10.58Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30070839_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30070839/f7e39dd720276063b7237337b2a3a073.webp"
"MediaSize" => 28110
"MediaType" => "webp"
…8
]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070839')"
+"ID": "1652990"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25445
+post_id: "1650535"
+post_author: 1
+"ListingKey": "30068427"
+"ListingId": "X13595566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:45:05Z"
+"RFModificationTimestamp": "2026-07-23T16:53:47Z"
+"ListPrice": 587000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0A5"
+"UnparsedAddress": "36 - 555 CHABLIS DRIVE, Waterloo, Ontario N2T0A5"
+"Coordinates": array:2 [
0 => -80.574031
1 => 43.449435
]
+"Latitude": 43.449435
+"Longitude": -80.574031
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare end-unit condo townhome in sought-after Clair Hills offers the space and features of a detached home without the upkeep. A double-car garage plus double-wide driveway delivers parking for four - virtually unheard of in condo life. At 2,478 sq. ft. of total finished living area, the layout is generous throughout: open-concept main floor with hardwood, a well-appointed kitchen with gas range, breakfast peninsula, pantry and stainless appliances, three upstairs bedrooms including an oversized primary with walk-in closet and ensuite, upper-level laundry, and a flexible lower level ideal for a family room, office or gym. Move-in ready with 2026 updates including fresh paint, new upstairs carpet and updated lighting, while the bathrooms have been refreshed with new vanities, mirrors, faucets, toilets and coordinated black fixtures. Smart home features include app-based locks, lighting and garage access. Furnace and AC replaced 2023. The end-unit position brings extra windows, privacy and a rear deck overlooking landscaped green space - no street exposure. Steps to The Boardwalk's shops, restaurants, Costco and healthcare, with easy GRT access and 150+ km of trails nearby. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T00:54:31.814311+00:00"
+"Directions": "Ira Needles & Chablis"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102918"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:07:11Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:39:54Z"
+"Stories": "2.0"
+"StreetName": "Chablis"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4956"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_36_555_chablis_dr_waterloo_on/"
+"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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30068427/36-555-chablis-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-22T23:33:34.65Z"
+"ListAgentNationalAssociationId": "1372568"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30068427')"
+"ID": "1650535"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25442
+post_id: "1650036"
+post_author: 1
+"ListingKey": "30067289"
+"ListingId": "X13594730"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T01:10:02Z"
+"RFModificationTimestamp": "2026-07-24T01:18:02Z"
+"ListPrice": 755000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5N5"
+"UnparsedAddress": "402 MIDWOOD CRESCENT, Waterloo, Ontario N2L5N5"
+"Coordinates": array:2 [
0 => -80.5525613
1 => 43.4572071
]
+"Latitude": 43.4572071
+"Longitude": -80.5525613
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Excellent investment opportunity in Prime Location in Waterloo! This beautifully updated, licensed rental property offers a turnkey opportunity in one of the city's most sought-after student rental locations. Featuring recent renovations through out. The seller is currently completing the conversion of the lower level into a legal 3-bedroom secondary suite, creating even greater rental potential and maximizing future income opportunities with a rare 6 Bedroom home in the City, with 2 Kitchens, 2 Sets of Laundry, and Separate Entrances, Ideally located just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, public transit, shopping, restaurants, and everyday amenities, this property is perfectly suited for students and investors alike. Seller has owned this property for more than 20 years and it has been consistently leased year after year. (id:62650)"
+"Appliances": array:5 [
0 => "Dryer"
1 => "Two stoves"
2 => "Window Coverings"
3 => "Two Washers"
4 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Apartment in basement"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T23:10:10.113033+00:00"
+"Directions": "Cross Streets: Beachwood/University. ** Directions: Keats Way to Midwood Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932389"
+"ListOfficeKey": "194325"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "55.7 x 82.6 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T00:33:55Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T01:03:45Z"
+"Stories": "1.0"
+"StreetName": "Midwood"
+"StreetNumber": "402"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4042"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30067289/402-midwood-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 55.8
+"OriginalEntryTimestamp": "2026-07-22T20:04:49.3Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1232756"
+"ListOfficeNationalAssociationId": "1191701"
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30067289')"
+"ID": "1650036"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25446
+post_id: "1650037"
+post_author: 1
+"ListingKey": "30067297"
+"ListingId": "40850419"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T00:30:01Z"
+"RFModificationTimestamp": "2026-07-24T00:31:38Z"
+"ListPrice": 755000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5N5"
+"UnparsedAddress": "402 MIDWOOD Crescent, Waterloo, Ontario N2L5N5"
+"Coordinates": array:2 [
0 => -80.5536715
1 => 43.456899
]
+"Latitude": 43.456899
+"Longitude": -80.5536715
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Client Remarks Excellent investment opportunity in Prime Location in Waterloo! This beautifully updated, licensed rental property offers a turnkey opportunity in one of the city's most sought-after student rental locations. Featuring recent renovations through out. The seller is currently completing the conversion of the lower level into a legal 3-bedroom secondary suite, creating even greater rental potential making it a total of 6 Bedrooms which is not common in the city, Two Kitchens, Two Sets of Laundry with separate Entrance and maximizing future income opportunities. Ideally located just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, public transit, shopping, restaurants, and everyday amenities, this property is perfectly suited for students and investors alike. Seller has owned this property for more than 20 years and it has been consistently leased year after year. (id:62650)"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T20:44:19.513703+00:00"
+"Directions": "KEATSWAY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932389"
+"ListOfficeKey": "190426"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-24T00:22:05Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T00:29:19Z"
+"Stories": "1.0"
+"StreetName": "MIDWOOD"
+"StreetNumber": "402"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4042"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30067297/402-midwood-crescent-waterloo"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-07-22T20:08:20Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1232756"
+"ListOfficeNationalAssociationId": "1213294"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30067297')"
+"ID": "1650037"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25444
+post_id: "1648841"
+post_author: 1
+"ListingKey": "30065965"
+"ListingId": "40850051"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T13:00:01Z"
+"RFModificationTimestamp": "2026-07-23T13:14:18Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 3618.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3S4"
+"UnparsedAddress": "1263 COUNTRYSTONE Drive, Kitchener, Ontario N2N3S4"
+"Coordinates": array:2 [
0 => -80.5545922
1 => 43.4355673
]
+"Latitude": 43.4355673
+"Longitude": -80.5545922
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 1263 Countrystone Drive, Kitchener: a beautifully renovated, detached 2-storey home offering exceptional living space, modern finishes and incredible income potential with a Legal Duplex walkout basement. Situated on a premium corner lot, this meticulously maintained property has been renovated from top to bottom and is truly move-in ready. Drive into this amazing house offering outstanding curb appeal and parking for 4 vehicles (2-car garage, 2-car Concrete driveway). Step inside the welcoming foyer and discover carpet-free interior that has been freshly painted and thoughtfully designed. The stunning chef-inspired kitchen features elegant quartz countertops extended to the back, a large centre island, stainless steel appliances, ample cabinetry and spacious pantry. Adjacent is a breakfast area, while the separate formal dining room provides the perfect setting for family dinners and gatherings. The spacious living room is filled with natural light and is ideal for relaxing or entertaining. Upstairs there are 4 generously sized bedrooms and 2 full bathrooms. The spacious primary retreat features a private ensuite and his/her closet. 3 additional bedrooms share a beautifully updated 4pc bathroom, offering plenty of room for a growing family. Adding tremendous value is the fully finished legal Duplex walkout basement complete with 2 bedrooms, 3pc bathroom, full kitchen, dining area, separate laundry and lots of storage is an excellent opportunity for multi-generational living or potential rental income. The walkout basement leads directly to fully fenced backyard with a raised deck, also a patio area, perfect for family gatherings, BBQs or simply relaxing. Perfectly positioned, the home is just minutes from Boardwalk Shopping District, parks, playgrounds, trails, excellent schools and quick access to University of Waterloo and Highway 7/8 and public transit. Don't miss your chance to call this remarkable home your own. Book your private showing today! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T19:27:49.900279+00:00"
+"Directions": "University Ave W To countrystone Dr"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"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:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T12:51:33Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T12:51:33Z"
+"Stories": "2.0"
+"StreetName": "COUNTRYSTONE"
+"StreetNumber": "1263"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "6756"
+"VirtualTourURLUnbranded": "https://youriguide.com/1263_countrystone_dr_kitchener_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30065965/1263-countrystone-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Res-4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2475
+"BelowGradeFinishedArea": 1143
+"OriginalEntryTimestamp": "2026-07-22T17:08:10.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30065965')"
+"ID": "1648841"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25439
+post_id: "1648842"
+post_author: 1
+"ListingKey": "30066221"
+"ListingId": "X13593838"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T17:45:04Z"
+"RFModificationTimestamp": "2026-07-22T19:04:32Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3S4"
+"UnparsedAddress": "1263 COUNTRYSTONE DRIVE, Kitchener, Ontario N2N3S4"
+"Coordinates": array:2 [
0 => -80.554601
1 => 43.435548
]
+"Latitude": 43.435548
+"Longitude": -80.554601
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 1263 Countrystone Drive, Kitchener: a beautifully renovated, detached 2-storey home offering exceptional living space, modern finishes and incredible income potential with a Legal Duplex walkout basement. Situated on a premium corner lot, this meticulously maintained property has been renovated from top to bottom and is truly move-in ready. Drive into this amazing house offering outstanding curb appeal and parking for 4 vehicles (2-car garage, 2-car Concrete driveway). Step inside the welcoming foyer and discover carpet-free interior that has been freshly painted and thoughtfully designed. The stunning chef-inspired kitchen features elegant quartz countertops extended to the back, a large centre island, stainless steel appliances, ample cabinetry and spacious pantry. Adjacent is a breakfast area, while the separate formal dining room provides the perfect setting for family dinners and gatherings. The spacious living room is filled with natural light and is ideal for relaxing or entertaining. Upstairs there are 4 generously sized bedrooms and 2 full bathrooms. The spacious primary retreat features a private ensuite and his/her closet. 3 additional bedrooms share a beautifully updated 4pc bathroom, offering plenty of room for a growing family. Adding tremendous value is the fully finished legal Duplex walkout basement complete with 2 bedrooms, 3pc bathroom, full kitchen, dining area, separate laundry and lots of storage is an excellent opportunity for multi-generational living or potential rental income. The walkout basement leads directly to fully fenced backyard with a raised deck, also a patio area, perfect for family gatherings, BBQs or simply relaxing. Perfectly positioned, the home is just minutes from Boardwalk Shopping District, parks, playgrounds, trails, excellent schools and quick access to University of Waterloo and Highway 7/8 and public transit. Don't miss your chance to call this remarkable home your own. Book your private showing today! (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T19:04:16.727176+00:00"
+"Directions": "Cross Streets: University Ave W. ** Directions: University Ave W To countrystone 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:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "45.1 x 105 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T17:37:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T17:37:22Z"
+"Stories": "2.0"
+"StreetName": "Countrystone"
+"StreetNumber": "1263"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6756"
+"VirtualTourURLUnbranded": "https://youriguide.com/1263_countrystone_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": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30066221/1263-countrystone-drive-kitchener"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.1
+"OriginalEntryTimestamp": "2026-07-22T17:37:22.93Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066221')"
+"ID": "1648842"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23542
+post_id: "1649042"
+post_author: 1
+"ListingKey": "30065970"
+"ListingId": "40848982"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:10:07Z"
+"RFModificationTimestamp": "2026-07-23T16:26:37Z"
+"ListPrice": 587000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2478.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y7"
+"UnparsedAddress": "555 CHABLIS Drive Unit# 36, Waterloo, Ontario N2T2Y7"
+"Coordinates": array:2 [
0 => -80.5740634
1 => 43.4487988
]
+"Latitude": 43.4487988
+"Longitude": -80.5740634
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare end-unit condo townhome in sought-after Clair Hills offers the space and features of a detached home without the upkeep. A double-car garage plus double-wide driveway delivers parking for four — virtually unheard of in condo life. At 2,478 sq. ft. of total finished living area, the layout is generous throughout: open-concept main floor with hardwood, a well-appointed kitchen with gas range, breakfast peninsula, pantry and stainless appliances, three upstairs bedrooms including an oversized primary with walk-in closet and ensuite, upper-level laundry, and a flexible lower level ideal for a family room, office or gym. Move-in ready with 2026 updates including fresh paint, new upstairs carpet and updated lighting, while the bathrooms have been refreshed with new vanities, mirrors, faucets, toilets and coordinated black fixtures. Smart home features include app-based locks, lighting and garage access. Furnace and AC replaced 2023. The end-unit position brings extra windows, privacy and a rear deck overlooking landscaped green space — no street exposure. Steps to The Boardwalk's shops, restaurants, Costco and healthcare, with easy GRT access and 150+ km of trails nearby. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T17:53:32.701198+00:00"
+"Directions": "Ira Needles & Chablis"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1930634"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:02:56Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:02:56Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4956"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_36_555_chablis_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30065970/555-chablis-drive-unit-36-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1766
+"BelowGradeFinishedArea": 712
+"OriginalEntryTimestamp": "2026-07-22T17:08:17.78Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1231368"
+"ListOfficeNationalAssociationId": "1384313"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30065970')"
+"ID": "1649042"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25470
+post_id: "1647510"
+post_author: 1
+"ListingKey": "30063970"
+"ListingId": "40850179"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T07:00:01Z"
+"RFModificationTimestamp": "2026-07-23T07:02:32Z"
+"ListPrice": 839000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1820.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N3R5"
+"UnparsedAddress": "28 LEMON GRASS Street, Kitchener, Ontario N2N3R5"
+"Coordinates": array:2 [
0 => -80.5562691
1 => 43.4371781
]
+"Latitude": 43.4371781
+"Longitude": -80.5562691
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated 3-bedroom, 2.5-bath detached home in a highly desirable Kitchener neighbourhood! Offering approximately 1,820 sq ft of bright open-concept living space, this well-maintained home features a renovated kitchen, living area, bathrooms, and stairs (2024), with nearly $60,000 in upgrades. The kitchen includes newer fridge, stove, dishwasher, and range hood, all replaced in 2024. The spacious primary bedroom features a private ensuite with a Jacuzzi tub. Additional updates include a new water softener and owned hot water heater (2025), plus roof replacement in 2022. The unfinished basement with 3-piece bathroom rough-in is ready to be transformed into your dream rec room, gym, or additional living space. Enjoy the fully fenced backyard with patio, concrete double driveway, attached garage, and convenient main floor laundry. Ideally located close to schools, shopping, parks, restaurants, transit, and all essential amenities — offering the perfect balance of space, comfort, and convenience. A wonderful opportunity for families, first-time buyers, or investors alike! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T06:42:00.184294+00:00"
+"Directions": "University Ave W / Countrystone Dr / Lemon Grass St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T06:51:51Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T06:51:51Z"
+"Stories": "2.0"
+"StreetName": "LEMON GRASS"
+"StreetNumber": "28"
+"StreetSuffix": "Street"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4911"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"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/30063970/28-lemon-grass-street-kitchener"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RUEC"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1820
+"OriginalEntryTimestamp": "2026-07-22T05:58:17.05Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30063970')"
+"ID": "1647510"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25471
+post_id: "1647387"
+post_author: 1
+"ListingKey": "30063837"
+"ListingId": "X13591300"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T03:45:03Z"
+"RFModificationTimestamp": "2026-07-22T04:38:07Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L6E4"
+"UnparsedAddress": "306 - 265 WESTCOURT PLACE, Waterloo, Ontario N2L6E4"
+"Coordinates": array:2 [
0 => -80.540493
1 => 43.460629
]
+"Latitude": 43.460629
+"Longitude": -80.540493
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Priced to Sell! AAA LOCATION! Spacious 1,376 sq ft unit in the well-maintained Beechmount building. Walk to Uptown, both universities, Waterloo Park, reccentre, T&T, Costco & more. Features include a large living room, enclosed sunroom, separate dining room, bright kitchen with ample cabinetry,2nd bedroom with balcony walkout, and a large in-suite laundry/storage room. Quiet setting with lovely grounds, updated lobby, games room,and library. A rare find in a prime Waterloo location! (id:62650)"
+"AssociationFee": "865"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Pets not Allowed"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T04:38:02.939644+00:00"
+"Directions": "Cross Streets: Westmount/Erb/University. ** Directions: Westmount to WestCourt Place."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2003456"
+"ListOfficeKey": "70066"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-22T03:37:28Z"
+"PhotosCount": 36
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T03:37:28Z"
+"StreetName": "Westcourt"
+"StreetNumber": "265"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3938.71"
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30063837/306-265-westcourt-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CanLight Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:5 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
3 => "Party Room"
4 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "RMU-60"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-22T03:37:28.7Z"
+"ListAgentNationalAssociationId": "1286347"
+"ListOfficeNationalAssociationId": "1132867"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30063837')"
+"ID": "1647387"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 130
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
]