array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29977237 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1583692"
+post_author: 1
+"ListingKey": "29977237"
+"ListingId": "40844510"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T14:00:17Z"
+"RFModificationTimestamp": "2026-07-02T14:07:55Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1898.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1Z2"
+"UnparsedAddress": "464 BEECHWOOD Place Unit# 3, Waterloo, Ontario N2T1Z2"
+"Coordinates": array:2 [
0 => -80.5579777
1 => 43.4525513
]
+"Latitude": 43.4525513
+"Longitude": -80.5579777
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover this beautifully updated two storey condo townhouse where modern finishes and functional design come together effortlessly. At the centre of the home is a stunning renovated kitchen featuring sleek quartz countertops, an oversized island perfect for gathering with family and friends, and plenty of workspace for everyday living. The bright and inviting main floor offers a spacious living room with a cozy gas fireplace, patio doors leading to a private balcony, a convenient two-piece powder room, and a flexible bedroom that's ideal for guests, a home office, or hobby space. Upstairs, the open loft style den overlooks the main level, adding character and an abundance of natural light. The generous primary suite provides a peaceful retreat with a beautifully updated ensuite bathroom. The finished lower level extends your living space with a comfortable rec room highlighted by a second gas fireplace, an additional powder room, laundry area, and a mudroom with direct access to the attached garage. Residents enjoy a meticulously maintained condo community complete with an outdoor swimming pool and plenty of visitor parking. Ideally situated close to grocery stores, restaurants, schools, public transit, The Boardwalk shopping district, and only minutes from Uptown Waterloo, this move-in ready home offers the perfect combination of style, comfort, and convenience. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "775"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T14:07:43.796922+00:00"
+"Directions": "Fisher Hallman to Erb to Beechwood Pl"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564580"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T13:31:51Z"
+"PhotosCount": 35
+"PoolFeatures": array:1 [
0 => "Pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T13:50:38Z"
+"Stories": "2.0"
+"StreetName": "BEECHWOOD"
+"StreetNumber": "464"
+"StreetSuffix": "Place"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3630"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/3_464_beechwood_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1673260602"
"RoomType" => "Mud room"
"ListingId" => "40844510"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "9'3'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.01Z"
]
1 => array:11 [
"RoomKey" => "1673260605"
"RoomType" => "Utility room"
"ListingId" => "40844510"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.01Z"
]
2 => array:11 [
"RoomKey" => "1673260609"
"RoomType" => "Storage"
"ListingId" => "40844510"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 4'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.02Z"
]
3 => array:11 [
"RoomKey" => "1673260610"
"RoomType" => "Laundry room"
"ListingId" => "40844510"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.03Z"
]
4 => array:11 [
"RoomKey" => "1673260611"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844510"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "4'8'' x 4'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.03Z"
]
5 => array:11 [
"RoomKey" => "1673260612"
"RoomType" => "Recreation room"
"ListingId" => "40844510"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "16'8'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.04Z"
]
6 => array:11 [
"RoomKey" => "1673260613"
"RoomType" => "Full bathroom"
"ListingId" => "40844510"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.04Z"
]
7 => array:11 [
"RoomKey" => "1673260614"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844510"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 16'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.05Z"
]
8 => array:11 [
"RoomKey" => "1673260615"
"RoomType" => "Den"
"ListingId" => "40844510"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.06Z"
]
9 => array:11 [
"RoomKey" => "1673260616"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.07Z"
]
10 => array:11 [
"RoomKey" => "1673260617"
"RoomType" => "Bedroom"
"ListingId" => "40844510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.07Z"
]
11 => array:11 [
"RoomKey" => "1673260618"
"RoomType" => "Living room"
"ListingId" => "40844510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.07Z"
]
12 => array:11 [
"RoomKey" => "1673260621"
"RoomType" => "Dining room"
"ListingId" => "40844510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.08Z"
]
13 => array:11 [
"RoomKey" => "1673260627"
"RoomType" => "Eat in kitchen"
"ListingId" => "40844510"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29977237"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T13:50:38.08Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977237/464-beechwood-place-unit-3-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1958320"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "290620"
+"GeocodeManualYN": true
+"ZoningDescription": "MR150"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 1.0
+"AboveGradeFinishedArea": 1375
+"BelowGradeFinishedArea": 523
+"OriginalEntryTimestamp": "2026-07-02T13:31:51Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1069941"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1249173"
+"CoListOfficeNationalAssociationId": "1389824"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29977237_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/fdefc7a73fb947f36301826618718a14.webp"
"MediaSize" => 132385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-fdefc7a73fb947f36301826618718a14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29977237_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/c1fb9e61ee30b3456049c99fa4509831.webp"
"MediaSize" => 143200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-c1fb9e61ee30b3456049c99fa4509831.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29977237_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/e0683818e47afda3d841689d6d333ea7.webp"
"MediaSize" => 67597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-e0683818e47afda3d841689d6d333ea7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29977237_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/7854ca4507fe0704a6b0e5d070ac485b.webp"
"MediaSize" => 55912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-7854ca4507fe0704a6b0e5d070ac485b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29977237_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/bbad8f62d67d3c170a8db54717bbdb70.webp"
"MediaSize" => 63648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-bbad8f62d67d3c170a8db54717bbdb70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29977237_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/359c84b319a107ce25d398309155a613.webp"
"MediaSize" => 62588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-359c84b319a107ce25d398309155a613.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29977237_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/0171a99f043cbc8d8ebb81971dd0070f.webp"
"MediaSize" => 53563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-0171a99f043cbc8d8ebb81971dd0070f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29977237_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/b279ac2829a1bb505f12feb17ce2f6de.webp"
"MediaSize" => 49835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-b279ac2829a1bb505f12feb17ce2f6de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29977237_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/8b15611c249b6c076a07829a39f52479.webp"
"MediaSize" => 42873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-8b15611c249b6c076a07829a39f52479.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29977237_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/2283c6fec93a725af7f0abb6f7eaab9a.webp"
"MediaSize" => 71705
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-2283c6fec93a725af7f0abb6f7eaab9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29977237_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/c14166ecea88964ff2e9af23576900a3.webp"
"MediaSize" => 63868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-c14166ecea88964ff2e9af23576900a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29977237_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/b7ee1a69287db163d796da17d220c549.webp"
"MediaSize" => 75098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-b7ee1a69287db163d796da17d220c549.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29977237_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/67679369cb4ed44d426469bd5f00e70a.webp"
"MediaSize" => 82577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-67679369cb4ed44d426469bd5f00e70a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29977237_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/9ff8da1fa852beca8ba6c1236c1b2495.webp"
"MediaSize" => 85845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-9ff8da1fa852beca8ba6c1236c1b2495.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29977237_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/f7e952f772bf54432ad16b6a7a953766.webp"
"MediaSize" => 123492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-f7e952f772bf54432ad16b6a7a953766.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29977237_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/8f49ed1d100c895515157b9384a927c5.webp"
"MediaSize" => 45214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-8f49ed1d100c895515157b9384a927c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29977237_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/08f4b058147045c5d216e2e6c1abf92a.webp"
"MediaSize" => 74950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-08f4b058147045c5d216e2e6c1abf92a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29977237_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/2057c10f63fcf6a87339c2f6f84ed233.webp"
"MediaSize" => 62657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-2057c10f63fcf6a87339c2f6f84ed233.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29977237_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/df12b0a9acdaadcd9bd320217f182784.webp"
"MediaSize" => 62207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-df12b0a9acdaadcd9bd320217f182784.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29977237_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/2c601bd048c407a8fd788243312a997a.webp"
"MediaSize" => 59838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-2c601bd048c407a8fd788243312a997a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29977237_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/9ead7275ca98920ee07cf720a02042bf.webp"
"MediaSize" => 46817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-9ead7275ca98920ee07cf720a02042bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29977237_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/f657ad7f6ceee1198f33bbea6e5950c0.webp"
"MediaSize" => 51657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-f657ad7f6ceee1198f33bbea6e5950c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29977237_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/74da7c14d30a3168d99204c24b43a847.webp"
"MediaSize" => 58337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-74da7c14d30a3168d99204c24b43a847.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29977237_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/908e7c2751376a4addfd45deb97f055e.webp"
"MediaSize" => 59792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-908e7c2751376a4addfd45deb97f055e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29977237_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/e7ef6a09ea0a5d38c23478f88c599e3d.webp"
"MediaSize" => 51996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-e7ef6a09ea0a5d38c23478f88c599e3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29977237_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/623b774149f08da2ecf433b471d3b350.webp"
"MediaSize" => 42203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-623b774149f08da2ecf433b471d3b350.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29977237_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/9440a68742788295e189a3dab2a814f0.webp"
"MediaSize" => 57158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-9440a68742788295e189a3dab2a814f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29977237_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/1bc0985ff37583bf3d902eb1449840ef.webp"
"MediaSize" => 126171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-1bc0985ff37583bf3d902eb1449840ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29977237_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/2e2110b21138c921d89958b280addb2b.webp"
"MediaSize" => 152072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-2e2110b21138c921d89958b280addb2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29977237_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/5c8aec0723629b35fec313174405a8f7.webp"
"MediaSize" => 146855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-5c8aec0723629b35fec313174405a8f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29977237_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/6e880179f7d4049fa01f5b44796268fe.webp"
"MediaSize" => 178235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-6e880179f7d4049fa01f5b44796268fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29977237_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/cd22d2f4be00ffe24d370fba86acc92a.webp"
"MediaSize" => 110849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-cd22d2f4be00ffe24d370fba86acc92a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29977237_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/bc9bea42d30e38262d41989ff7a447d2.webp"
"MediaSize" => 138616
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-bc9bea42d30e38262d41989ff7a447d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29977237_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/70e994f174f7b41358cfcc69f9f2a9f8.webp"
"MediaSize" => 135527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-70e994f174f7b41358cfcc69f9f2a9f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29977237_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977237/91f4d62fa4540e7cf705551f30c55725.webp"
"MediaSize" => 135456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977237/thumbnail-91f4d62fa4540e7cf705551f30c55725.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844510"
"ResourceRecordKey" => "29977237"
"ModificationTimestamp" => "2026-07-02T13:31:51.01Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977237')"
+"ID": "1583692"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 76826" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24815
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1564580" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24810
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29977237'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25281
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29977237'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25296
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31755214"
+"ListingKey": "29977237"
+"ListingId": "40844510"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-04"
+"OpenHouseStartTime": "2026-07-04T13:00:00Z"
+"OpenHouseEndTime": "2026-07-04T15:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-02T15:41:23Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31755214')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31755215"
+"ListingKey": "29977237"
+"ListingId": "40844510"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-05"
+"OpenHouseStartTime": "2026-07-05T14:00:00Z"
+"OpenHouseEndTime": "2026-07-05T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-02T15:41:23Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31755215')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29977237' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5579777 43.4525513)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25361
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25355
+post_id: "1581769"
+post_author: 1
+"ListingKey": "29973034"
+"ListingId": "40844104"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T21:25:01Z"
+"RFModificationTimestamp": "2026-06-30T22:54:29Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2534.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P2"
+"UnparsedAddress": "622 WESTFIELD Drive, Waterloo, Ontario N2T2P2"
+"Coordinates": array:2 [
0 => -80.56095
1 => 43.441031
]
+"Latitude": 43.441031
+"Longitude": -80.56095
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to one of Westvale's most extraordinary homes, where over $650,000 has been invested in a complete top-to-bottom transformation. Expertly renovated by Menno Martin Contractors with custom craftsmanship by TimberBarn, this magazine-worthy residence blends timeless design with uncompromising quality. From the moment you arrive, the beautifully landscaped perennial gardens, updated exterior, Techo-Bloc walkway, and exceptional curb appeal make a lasting impression. Inside, a stunning staircase and custom built-in mudroom lead to an open-concept main floor with soaring vaulted ceilings, hand-hewn timber beams, custom engineered white oak flooring, upgraded Craftsman-style millwork, and a floor-to-ceiling stone gas fireplace. Designed for entertaining and everyday living, the custom kitchen showcases a reclaimed elm island with a hand-poured epoxy top, Caesarstone quartz countertops, gas range, built-in pantry, and exceptional custom cabinetry. Thoughtfully curated finishes include wormy maple accents, designer lighting, and a stunning laundry room with custom cabinetry and quartz counters. The professionally finished lower level offers custom built-ins, a charming children's playhouse, and a private guest suite with a full bathroom. Upstairs are three spacious bedrooms, including a luxurious primary retreat with a walk-in closet and spa-inspired marble ensuite. Even the insulated garage has epoxy flooring, while every inch of the home reflects exceptional attention to detail. Situated in one of Waterloo's most sought-after neighbourhoods, Westvale offers excellent schools, parks, trails, and quick access to Ira Needles Boulevard, The Boardwalk, Costco, shopping, restaurants, and Highway 7/8. Immaculately maintained and truly turnkey, this is a rare opportunity to own a home where no expense was spared and every detail has already been perfected. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:5 [
0 => "Quiet Area"
1 => "High Traffic Area"
2 => "School Bus"
3 => "Community Centre"
4 => "Industrial Park"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T22:40:11.775086+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1902312"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Paved driveway"
1 => "Skylight"
2 => "Sump Pump"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T21:19:43Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T21:19:43Z"
+"Stories": "2.0"
+"StreetName": "WESTFIELD"
+"StreetNumber": "622"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "6531.1"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/622-Westfield-Dr"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1672195507"
"RoomType" => "Utility room"
"ListingId" => "40844104"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29973034"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T21:19:43.01Z"
]
1 => array:11 [
"RoomKey" => "1672195508"
"RoomType" => "Storage"
"ListingId" => "40844104"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29973034"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 3'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T21:19:43.01Z"
]
2 => array:11 [
"RoomKey" => "1672195509"
"RoomType" => "Recreation room"
"ListingId" => "40844104"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29973034"
"RoomLength" => null
"RoomDimensions" => "24'2'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T21:19:43.01Z"
]
3 => array:11 [
"RoomKey" => "1672195510"
"RoomType" => "Laundry room"
"ListingId" => "40844104"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29973034"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T21:19:43.01Z"
]
4 => array:11 [
"RoomKey" => "1672195511"
"RoomType" => "Bedroom"
"ListingId" => "40844104"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29973034"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T21:19:43.01Z"
]
5 => array:11 [
"RoomKey" => "1672195512"
"RoomType" => "3pc Bathroom"
"ListingId" => "40844104"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29973034"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T21:19:43.01Z"
]
6 => array:11 [
"RoomKey" => "1672195513"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844104"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29973034"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T21:19:43.01Z"
]
7 => array:11 [
"RoomKey" => "1672195514"
"RoomType" => "Bedroom"
"ListingId" => "40844104"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29973034"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T21:19:43.01Z"
]
8 => array:11 [
"RoomKey" => "1672195515"
"RoomType" => "Bedroom"
"ListingId" => "40844104"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29973034"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T21:19:43.01Z"
]
9 => array:11 [
"RoomKey" => "1672195516"
"RoomType" => "5pc Bathroom"
"ListingId" => "40844104"
"RoomLevel" => "Second level"
"RoomWidth" => null
…6
]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29973034/622-westfield-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 1640
+"BelowGradeFinishedArea": 894
+"OriginalEntryTimestamp": "2026-06-30T21:19:42.97Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1218041"
+"ListOfficeNationalAssociationId": "1473831"
+"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('29973034')"
+"ID": "1581769"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1576006"
+post_author: 1
+"ListingKey": "29967155"
+"ListingId": "40843458"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:00:08Z"
+"RFModificationTimestamp": "2026-06-29T19:38:50Z"
+"ListPrice": 1350000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.196
+"LivingArea": 2254.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1L1"
+"UnparsedAddress": "200 MACDONALD Place, Waterloo, Ontario N2L1L1"
+"Coordinates": array:2 [
0 => -80.5336085
1 => 43.45156
]
+"Latitude": 43.45156
+"Longitude": -80.5336085
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Westmount welcomes you to the established, quiet court of MacDonald Place. If the time is right to downsize then this gorgeous ranch style home will be of interest. Attractive curb appeal with no sidewalks. Wide covered front porch is ready for evening chats with a glass of wine. The aggregate driveway leads to a double car garage with finished interior & roughed-in EV charger. Renovated extensively to high standards in 2013 and very well maintained by present owner. An open concept interior with vaulted ceilings are highlighted with numerous pot lights plus windows for natural light. Walkouts to two decks with a rear stone patio waiting for you to relax in the privacy of your lushly landscaped low maintenance fenced yard. Brazilian cherry hardwood floors & tile make for a carpet free main floor. You can have one level living with two bedrooms, two bathrooms, and stackable laundry all on the main level. Fabulous kitchen with gas stove & stainless appliances, centre island with bar sink & wine racks, plus thick granite counters with breakfast bar seating at the end. The Dining room has an open flow to the Living room featuring a gas fireplace accented with custom cabinets & wall mounted TV. The primary bedroom fits a king size bed, has an inverted tray ceiling, his & her closets, luxury 5 pc ensuite with walk-in shower, jet tub & double vanities plus additional storage cabinetry. The second bedroom is presently being used as an office but has a walk-in closet for use as a bedroom. The lower level is equally spacious with an office/guest room, 3 pc bathroom, Rec room/gym area plus unfinished storage & utility room. Be over to the Private Westmount Golf & Country Club within minutes where year round activities include golf, curling, & tennis in an engaging social atmosphere. Belmont Village & two Universities beckon minutes away. You can bike & walk the Iron Horse Trail from Waterloo to Kitchener or catch the ION light rail routes to explore further. August closing! (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Garburator"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T19:38:45.112482+00:00"
+"Directions": "Westmount Road South to Forsyth Drive, left on Stanley Drive, left on MacDonald Place"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564125"
+"ListOfficeKey": "76836"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.196"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T18:50:44Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:50:44Z"
+"Stories": "1.0"
+"StreetName": "MACDONALD"
+"StreetNumber": "200"
+"StreetSuffix": "Place"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "9080.53"
+"VirtualTourURLUnbranded": "https://youriguide.com/200_macdonald_place_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29967155/200-macdonald-place-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 110.0
+"AboveGradeFinishedArea": 1707
+"BelowGradeFinishedArea": 547
+"OriginalEntryTimestamp": "2026-06-29T18:50:44.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070169"
+"ListOfficeNationalAssociationId": "1004398"
+"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('29967155')"
+"ID": "1576006"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25354
+post_id: "1576317"
+post_author: 1
+"ListingKey": "29966442"
+"ListingId": "40836179"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:40:45Z"
+"RFModificationTimestamp": "2026-06-29T18:49:17Z"
+"ListPrice": 1470000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2663.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2S8"
+"UnparsedAddress": "294 ALGONQUIN Drive, Waterloo, Ontario N2L2S8"
+"Coordinates": array:2 [
0 => -80.5462881
1 => 43.4644504
]
+"Latitude": 43.4644504
+"Longitude": -80.5462881
+"YearBuilt": 1961
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Architecturally Distinct Mid-Century Bungalow in Prestigious Beechwood. A rare opportunity to own a truly unique home in one of Waterloo's most sought-after neighbourhoods. Nestled within a private wooded enclave, this architecturally significant mid-century executive bungalow offers over 2,650 sq. ft. of thoughtfully designed living space and an exceptional connection to nature. Step inside and be captivated by soaring floor-to-ceiling windows that frame private views and fill the home with natural light. The spacious main level is designed for both everyday living and entertaining, featuring expansive principal rooms, a welcoming living and dining area with a striking double-sided fireplace, and multiple spaces to gather with family and friends. The lower level offers incredible flexibility with a walkout to the backyard, a large family room, two additional bedrooms or office, a full bathroom, and direct access to the garage—ideal for multi-generational living, guests, or a future in-law setup. Outside, enjoy your own private backyard retreat surrounded by mature trees, offering peace, privacy, and endless potential to create your dream outdoor oasis. Updates include windows, roof, hot water tank and boiler, electrical service, extensive landscaping. While some cosmetic updating may be desired, the home presents an outstanding opportunity to personalize a property with exceptional character in an unbeatable location. Virtual staging has been provided to show decorating potential. Situated just minutes from the University of Waterloo, top-rated schools, parks, trails, shopping, and amenities, this is a location rarely offered and highly coveted. Bring your vision and imagination or just move in—this remarkable Beechwood property is ready to become your forever home. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Sauna"
5 => "Central Vacuum"
6 => "Dishwasher"
7 => "Stove"
8 => "Dryer"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:2 [
0 => "Window air conditioner"
1 => "None"
]
+"CreationDate": "2026-06-29T18:49:12.869016+00:00"
+"Directions": "Westmount Rd to Longfellow Dr. to Iroquois Pl. to Algonquin Dr."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Boiler"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1996603"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Ravine"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T17:33:05Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:33:05Z"
+"Stories": "1.0"
+"StreetName": "ALGONQUIN"
+"StreetNumber": "294"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7014"
+"VirtualTourURLUnbranded": "https://youriguide.com/7ypyq_294_algonquin_dr_waterloo_on/"
+"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/29966442/294-algonquin-drive-waterloo"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 1651
+"BelowGradeFinishedArea": 1011
+"OriginalEntryTimestamp": "2026-06-29T17:33:05.3Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1279276"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966442')"
+"ID": "1576317"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+post_id: "1575466"
+post_author: 1
+"ListingKey": "29964973"
+"ListingId": "40843611"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T13:55:11Z"
+"RFModificationTimestamp": "2026-06-29T17:23:56Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2092.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N3"
+"UnparsedAddress": "465 COLUMBIA Street W Unit# 4, Waterloo, Ontario N2T2N3"
+"Coordinates": array:2 [
0 => -80.5699679
1 => 43.4659574
]
+"Latitude": 43.4659574
+"Longitude": -80.5699679
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Move-in Ready. Prestigious Upper Beechwood bungalow end-unit condo nestled among the beautiful treed surroundings of Roxton Park. Offering carefree living style for the busy professional, young executive & active empty nesters. An intimate complex with 8 owners. Filled with natural light, this elegant bungalow features large windows, transoms, soaring 9’ ceilings, 3 full bathrooms, and 2 walkouts. The spacious kitchen with a dinette showcases an impressive 12’ ceiling, while the open-concept dining area and great room create an inviting atmosphere complete with oversized windows and a cozy gas fireplace. The primary bedroom retreat offers a beautifully updated 3pc ensuite featuring quartz countertops and a glass shower. Step outside from the 2nd bedroom to the oversized deck and enjoy peaceful views in a serene setting. The finished lower level adds exceptional living space with a large recreation room and an additional full bathroom. Recent Updates: Kitchen sink faucet (2026), Range Hood (2021), newly painted most walls (2026), all 3 bathroom vanities, faucets and toilets (2024, 2026). Master bedroom ensuite shower (2024). Dining room sliding door (2020). Gas Fireplace (2021). Dryer (2018). Washer (2020). Outstanding location within walking distance to Shopping, Roxton Park, Conservation area, transit, University of Waterloo, Library, YMCA. A short drive to Costco, the Boardwalk, and all other amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"AssociationFee": "911.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T17:23:46.447783+00:00"
+"Directions": "Fischer-Hallman Rd N to Columbia St W"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970409"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:03Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T13:50:03Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "COLUMBIA"
+"StreetNumber": "465"
+"StreetSuffix": "Street"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4795"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/465-Columbia-St-W-unit-4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964973/465-columbia-street-w-unit-4-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1301
+"BelowGradeFinishedArea": 791
+"OriginalEntryTimestamp": "2026-06-29T13:50:03.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1257707"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964973')"
+"ID": "1575466"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25356
+post_id: "1574187"
+post_author: 1
+"ListingKey": "29963570"
+"ListingId": "40841161"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T02:15:21Z"
+"RFModificationTimestamp": "2026-06-28T02:17:27Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2P7"
+"UnparsedAddress": "350 ERBSVILLE Road Unit# 3, Waterloo, Ontario N2T2P7"
+"Coordinates": array:2 [
0 => -80.5789343
1 => 43.4607288
]
+"Latitude": 43.4607288
+"Longitude": -80.5789343
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "There’s a reason people hold onto these units for an average of 25 years. If you’ve been looking for that perfect middle ground, more space than a starter home, a backyard that’s actually private, and a neighbourhood where kids still ride their bikes to the park, this is it. The main floor is designed for how families actually live. Flowing naturally from a bright living room into the kitchen and dining area White shaker cabinetry, stainless steel appliances, and sliding doors out to the yard. Upstairs, you’ll find three genuinely spacious bedrooms. The primary bedroom easily fits a king-sized bed and offers ensuite privilege to a bright, updated 5-piece bathroom. Need a playroom, a home office, or just somewhere to send the kids when they’re being loud? The fully finished basement has you covered. It features a massive rec room with pot lights, and a convenient 3-piece bathroom, plus dedicated laundry and storage space. Now, let’s talk about the lifestyle. You’re steps from the Laurel Creek Conservation Area, meaning weekend hikes, canoeing, and trails are practically in your backyard. You’ve got the Stork Family YMCA and the John M. Harper Library just down the street. Need to run errands? The Boardwalk and Costco are minutes away for groceries, and restaurants. Plus, you’re in the catchment for some of the best schools in the region, including Laurel Heights Secondary School. And the best part? The condo fees are only $230 a month, and they’ve barely increased in years. It’s the peace of mind of a well-managed complex with the space and privacy of a freehold feel. If you’re outgrowing your condo or starter home, this is the exact upgrade you’ve been looking for. It’s the perfect blend of space, location, and neighbourhood. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "230"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T01:52:07.760475+00:00"
+"Directions": "Nearest Intersection: Erbsville Rd & Columbia St. W."
+"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": "2027560"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T01:20:59Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T02:02:40Z"
+"Stories": "2.0"
+"StreetName": "ERBSVILLE"
+"StreetNumber": "350"
+"StreetSuffix": "Road"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3425"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/cjdyt_3_350_erbsville_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29963570/350-erbsville-road-unit-3-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD-3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1275
+"BelowGradeFinishedArea": 525
+"OriginalEntryTimestamp": "2026-06-28T01:20:58.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1306927"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963570')"
+"ID": "1574187"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24909
+post_id: "1567194"
+post_author: 1
+"ListingKey": "29946411"
+"ListingId": "40842515"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T17:40:37Z"
+"RFModificationTimestamp": "2026-06-29T17:51:18Z"
+"ListPrice": 339000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 774.0
+"BuildingAreaTotal": 0
+"City": "Kitchener"
+"PostalCode": "N2N0B6"
+"UnparsedAddress": "931 GLASGOW Street Unit# 14A, Kitchener, Ontario N2N0B6"
+"Coordinates": array:2 [
0 => -80.5428958
1 => 43.4395765
]
+"Latitude": 43.4395765
+"Longitude": -80.5428958
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 14A at 931 Glasgow Street, a bright and well-maintained townhouse-style condo offering low-maintenance living in one of Kitchener-Waterloo’s most convenient locations. Ideal for first-time buyers, young professionals, students, or investors, this move-in ready home combines comfort, functionality, and strong rental appeal. Located in a quiet and welcoming complex, this 1-bedroom, 1-bathroom unit features a sun-filled open-concept layout designed for everyday living. The kitchen is both practical and stylish, offering ample cabinetry, generous prep space, and a functional island that flows seamlessly into the living and dining area. The living space is filled with natural light and provides direct access to a private patio, perfect for morning coffee, relaxing evenings, or summer barbecues. The spacious primary bedroom includes double closets and additional storage, while the 4-piece bathroom and in-suite laundry/utility room add everyday convenience. Enjoy the ease of assigned parking right outside your door, with additional visitor parking available for guests. This home is minutes from Uptown Waterloo, Belmont Village, The Boardwalk, Catalyst Commons, major transit routes, Wilfrid Laurier University, and the University of Waterloo, offering excellent access to shopping, dining, healthcare, and everyday amenities.Estate sale. Property being sold in “as is” condition. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"AssociationFee": "173.5"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:21:18.318765+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129344"
+"ListOfficeKey": "291992"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-24T14:51:22Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T17:31:54Z"
+"Stories": "2.0"
+"StreetName": "GLASGOW"
+"StreetNumber": "931"
+"StreetSuffix": "Street"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "2673"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946411/931-glasgow-street-unit-14a-kitchener"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 774
+"OriginalEntryTimestamp": "2026-06-24T14:51:22.4Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1382427"
+"ListOfficeNationalAssociationId": "1407252"
+"Media": array:23 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946411')"
+"ID": "1567194"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1564509"
+post_author: 1
+"ListingKey": "29947005"
+"ListingId": "40842209"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T21:20:13Z"
+"RFModificationTimestamp": "2026-06-25T23:48:39Z"
+"ListPrice": 979900.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.5546106
1 => 43.4355261
]
+"Latitude": 43.4355261
+"Longitude": -80.5546106
+"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-06-25T23:48:14.454906+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-06-24T21:01:52Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T21:11:21Z"
+"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/29947005/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-06-24T16:11:08.49Z"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947005')"
+"ID": "1564509"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "1564004"
+post_author: 1
+"ListingKey": "29954921"
+"ListingId": "40842745"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T01:55:08Z"
+"RFModificationTimestamp": "2026-06-27T02:06:55Z"
+"ListPrice": 3995000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 2
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 5920.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L1H7"
+"UnparsedAddress": "230 STANLEY Drive, Waterloo, Ontario N2L1H7"
+"Coordinates": array:2 [
0 => -80.5335915
1 => 43.4538961
]
+"Latitude": 43.4538961
+"Longitude": -80.5335915
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "SOPHISTICATED CUSTOM DESIGN. 230 Stanley Drive, nestled on an expansive, mature-treed lot in one of Waterloo’s most desirable neighbourhoods. This striking custom new build seamlessly blends architectural curb appeal with 5,920 sqft of meticulously finished, high-performance living space, featuring 4+2 bedrooms and 4+2 bathrooms. Step inside to discover an airy open-concept layout adorned with wide-plank white oak flooring, modern trim, & an elegant neutral colour palette. The main level flows effortlessly from the gourmet chef’s kitchen, a culinary masterpiece with premium cabinetry, quartz countertops, a servery, and a massive walk-in pantry, open to an expansive family room anchored by an elegant linear fireplace and custom built-in shelving. The kitchen features premium, front-paneled Jenn-Air appliances, including a 48” fridge/freezer, 48” dual-fuel range, integrated dishwasher, dual-zone wine cooler, and a drawer microwave. Upstairs, the wide-plank flooring leads to a lavish primary suite with a massive, brilliantly organized custom walk-in closet system. The upper level also features a convenient laundry room. The lower level boasts a fully finished basement with 9-ft ceilings, large windows, and a versatile recreation room with a fireplace and built-in cabinetry. A private staircase connects the basement directly to the fully insulated double-tandem deep garage. Outside, the property transforms into an incredible backyard oasis with a spacious covered porch featuring a stone fireplace, plank tile flooring, a ceiling fan, and a summer kitchen with granite countertops, a built-in Weber BBQ, a drawer fridge, and a sink. Built with tomorrow's tech, this Energy Star-certified home features a high-performance building envelope, triple-pane windows, and a Control4 home automation package with multi-zone audio, exterior security cameras, a full security system, and a high-efficiency HVAC system with zoned climate control via a centralized WiFi hub. Virtually Staged. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Range - Gas"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Dryer"
6 => "Wet Bar"
7 => "Hood Fan"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:40:02.578588+00:00"
+"Directions": "Westmount Road S"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750694"
+"ListOfficeKey": "285293"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wet bar"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T21:10:58Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T01:50:03Z"
+"Stories": "2.0"
+"StreetName": "STANLEY"
+"StreetNumber": "230"
+"StreetSuffix": "Drive"
+"SubdivisionName": "415 - Uptown Waterloo/Westmount"
+"TaxAnnualAmount": "18248"
+"VirtualTourURLUnbranded": "https://youriguide.com/230_stanley_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954921/230-stanley-drive-waterloo"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "SR3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.0
+"AboveGradeFinishedArea": 4220
+"BelowGradeFinishedArea": 1700
+"OriginalEntryTimestamp": "2026-06-25T21:10:58.64Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1066261"
+"ListOfficeNationalAssociationId": "1349925"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954921')"
+"ID": "1564004"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "1563978"
+post_author: 1
+"ListingKey": "29949431"
+"ListingId": "40842822"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T22:00:21Z"
+"RFModificationTimestamp": "2026-06-25T23:28:32Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1855.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5Y9"
+"UnparsedAddress": "206 CANDLEWOOD Crescent Unit# 13, Waterloo, Ontario N2L5Y9"
+"Coordinates": array:2 [
0 => -80.5581841
1 => 43.4593984
]
+"Latitude": 43.4593984
+"Longitude": -80.5581841
+"YearBuilt": 1978
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rarely available in sought-after Beechwood, this spacious executive condominium townhome offers the perfect blend of refined living, low-maintenance convenience, and an exceptional Waterloo location. Set within an exclusive, executive-style enclave, this beautifully maintained home delivers the space and comfort of a traditional residence with the ease of condominium living. Quality built and thoughtfully designed, the home features four levels of finished living space, including 3 bedrooms, 2.5 bathrooms, and a bright, open-concept main floor ideal for both everyday living and entertaining. The generous kitchen flows seamlessly into the dining area, while engineered hardwood flooring and a cozy wood-burning fireplace add warmth and character to the principal living space. Upstairs, the spacious primary suite offers a walk-in closet and private 3-piece ensuite, creating a comfortable retreat at the end of the day. The finished walkout basement extends the home’s versatility with a large recreation room and direct access to the private, fenced backyard. Recent updates include a new furnace in 2024. Additional highlights include an oversized single-car garage, ample visitor parking conveniently located near the front door, and reasonable condominium fees that include snow removal right to your doorstep through an exceptionally well-managed corporation. Ideally located close to parks, shopping, The Boardwalk, the University of Waterloo, and Waterloo’s thriving Tech Park, this is a rare opportunity to enjoy an executive lifestyle townhome in one of Waterloo’s most desirable communities—without compromising on space, comfort, or convenience. Book your private viewing today!! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Water"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:27:31.005349+00:00"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-24T21:50:55Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T21:50:55Z"
+"Stories": "2.0"
+"StreetName": "CANDLEWOOD"
+"StreetNumber": "206"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "3809"
+"VirtualTourURLUnbranded": "https://youriguide.com/13_206_candlewood_crescent_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/29949431/206-candlewood-crescent-unit-13-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1549
+"BelowGradeFinishedArea": 306
+"OriginalEntryTimestamp": "2026-06-24T21:50:55.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949431')"
+"ID": "1563978"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 141
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]