array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29953497 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23442
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23444
+post_id: "1562794"
+post_author: 1
+"ListingKey": "29953497"
+"ListingId": "40842430"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:40:16Z"
+"RFModificationTimestamp": "2026-06-25T21:14:44Z"
+"ListPrice": 945000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2362.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G2"
+"UnparsedAddress": "176 SANDFORD FLEMING Drive, Waterloo, Ontario N2T1G2"
+"Coordinates": array:2 [
0 => -80.5655765
1 => 43.4559425
]
+"Latitude": 43.4559425
+"Longitude": -80.5655765
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 176 Sandford Fleming Drive, Waterloo! Situated on a rare 81' x 130' mature lot in one of Waterloo's most sought-after neighbourhoods, this spacious detached home presents an exceptional opportunity for both families and investors. Featuring soaring cathedral ceilings, 3 generous bedrooms, 2 bathrooms, and a mostly above-grade lower level with an additional bedroom, recreation room, and bathroom, the home offers flexible living space with excellent future potential. Located just minutes from the University of Waterloo, top-rated schools, parks, and the vibrant Boardwalk shopping district, this property is ideally positioned for growing families, student rental opportunities, or long-term investment. The roof was replaced in 2026, providing added peace of mind, while the solid structure and oversized lot offer tremendous potential to renovate, personalize, and build equity. A rare opportunity to own a home in a prime Waterloo location that combines lifestyle, convenience, and investment value. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"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-25T21:14:37.773819+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055634"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:33:08Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:33:08Z"
+"Stories": "2.0"
+"StreetName": "SANDFORD FLEMING"
+"StreetNumber": "176"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "6187.62"
+"VirtualTourURLUnbranded": "https://youriguide.com/176_sandford_fleming_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1667909747"
"RoomType" => "Utility room"
"ListingId" => "40842430"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "16'11'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
1 => array:11 [
"RoomKey" => "1667909748"
"RoomType" => "Laundry room"
"ListingId" => "40842430"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 5'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
2 => array:11 [
"RoomKey" => "1667909749"
"RoomType" => "Recreation room"
"ListingId" => "40842430"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 29'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
3 => array:11 [
"RoomKey" => "1667909750"
"RoomType" => "Bedroom"
"ListingId" => "40842430"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
4 => array:11 [
"RoomKey" => "1667909751"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842430"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
5 => array:11 [
"RoomKey" => "1667909752"
"RoomType" => "Sunroom"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "15'10'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
6 => array:11 [
"RoomKey" => "1667909753"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
7 => array:11 [
"RoomKey" => "1667909754"
"RoomType" => "Living room"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
8 => array:11 [
"RoomKey" => "1667909755"
"RoomType" => "Kitchen"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
9 => array:11 [
"RoomKey" => "1667909756"
"RoomType" => "Dining room"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.88Z"
]
10 => array:11 [
"RoomKey" => "1667909757"
"RoomType" => "Breakfast"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.89Z"
]
11 => array:11 [
"RoomKey" => "1667909758"
"RoomType" => "Bedroom"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.89Z"
]
12 => array:11 [
"RoomKey" => "1667909759"
"RoomType" => "Bedroom"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.89Z"
]
13 => array:11 [
"RoomKey" => "1667909760"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.89Z"
]
14 => array:11 [
"RoomKey" => "1667909761"
"RoomType" => "Full bathroom"
"ListingId" => "40842430"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29953497"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:33:08.89Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29953497/176-sandford-fleming-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 81.0
+"AboveGradeFinishedArea": 1507
+"BelowGradeFinishedArea": 855
+"OriginalEntryTimestamp": "2026-06-25T18:33:08.82Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1330898"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29953497_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/d05e8b09b2a15d3019317d6253dc6cca.webp"
"MediaSize" => 171574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-d05e8b09b2a15d3019317d6253dc6cca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with gray siding accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29953497_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/d5e8fc6baf3d6d924a9e7c643678ab08.webp"
"MediaSize" => 156316
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-d5e8fc6baf3d6d924a9e7c643678ab08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29953497_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/474f83cd31ab0c6e85e54192fc544af1.webp"
"MediaSize" => 67926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-474f83cd31ab0c6e85e54192fc544af1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29953497_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/fd0fd929aaaf4fbc90b48e269c0fce6e.webp"
"MediaSize" => 78129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-fd0fd929aaaf4fbc90b48e269c0fce6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted ceiling in the living area featuring neutral wall tones and carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29953497_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/81d189904dd5e15b1c2c6ca51e47dc89.webp"
"MediaSize" => 92767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-81d189904dd5e15b1c2c6ca51e47dc89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted ceilings define this living area, featuring a tiered chandelier and light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29953497_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/9821f89ed7fb33aa129ae3d7ef944575.webp"
"MediaSize" => 92178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-9821f89ed7fb33aa129ae3d7ef944575.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a vaulted ceiling with a prominent chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29953497_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/e9b18e883984bc431479afb88ba1935b.webp"
"MediaSize" => 77771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-e9b18e883984bc431479afb88ba1935b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with a crystal chandelier, neutral wall paint, and baseboard trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29953497_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/f94f7f83398128a15668dcc1fb3e70c1.webp"
"MediaSize" => 79506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-f94f7f83398128a15668dcc1fb3e70c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring a glass-top table, suspended lighting fixture, large window, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29953497_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/1d18108cae55c1ebba70b45d010c4a6f.webp"
"MediaSize" => 84686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-1d18108cae55c1ebba70b45d010c4a6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with light wood cabinetry, white countertops, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29953497_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/ecb40d81608b91ef2ec61a92c180750a.webp"
"MediaSize" => 81723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-ecb40d81608b91ef2ec61a92c180750a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring wood cabinetry, white countertops, tile backsplash, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29953497_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/258a7ceb60ffc23e985249de8734e7fd.webp"
"MediaSize" => 93836
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-258a7ceb60ffc23e985249de8734e7fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Functional kitchen featuring wood cabinetry, white tile backsplash, a stainless steel sink, and a built-in dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29953497_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/c4347ab4e50283f066201dba26463136.webp"
"MediaSize" => 96762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-c4347ab4e50283f066201dba26463136.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a neutral carpet, patterned wallpaper, and a window with blinds and a valance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29953497_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/34d19e94e3ddb53d1efba600b7094db0.webp"
"MediaSize" => 81789
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-34d19e94e3ddb53d1efba600b7094db0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with a bathtub and sliding glass shower doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29953497_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/172e344d0fe4e4c4be7b069230d42553.webp"
"MediaSize" => 65849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-172e344d0fe4e4c4be7b069230d42553.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29953497_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/83649efe73077fccc541103a121e165c.webp"
"MediaSize" => 72181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-83649efe73077fccc541103a121e165c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom featuring a window with sheer and fabric treatments, a ceiling-mounted light fixture, and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29953497_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/daf5d9639eb3d5d4d5b63477ebeddbeb.webp"
"MediaSize" => 63119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-daf5d9639eb3d5d4d5b63477ebeddbeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White interior walls with light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29953497_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/1e4838aed336330b65e56f8b40986410.webp"
"MediaSize" => 74818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-1e4838aed336330b65e56f8b40986410.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a ceiling-mounted light fixture and textured white walls with a decorative border"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29953497_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/7b35e48b8e8215515571c3214304debd.webp"
"MediaSize" => 77698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-7b35e48b8e8215515571c3214304debd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom with a flat white ceiling, white walls, and decorative wallpaper border"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29953497_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/1445209df23f9464aeeea8fa1e5f7bd7.webp"
"MediaSize" => 67172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-1445209df23f9464aeeea8fa1e5f7bd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a built-in soaking tub with white tile surround, a spacious vanity with a teal countertop and integrated sink, white cabinetry with storage, and wood-finish parquet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29953497_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/5fcdd45f0de08fff2a98e2f09351e51f.webp"
"MediaSize" => 56600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-5fcdd45f0de08fff2a98e2f09351e51f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in shower with gold-tone frame and clear glass enclosure"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29953497_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/33d0b779e347a22890506b62951757de.webp"
"MediaSize" => 123931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-33d0b779e347a22890506b62951757de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Enclosed porch featuring paneled wood walls and ceiling, multiple windows, and a light-colored floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29953497_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/b22d7358b23c907ae7ca5b69cccbfea3.webp"
"MediaSize" => 119872
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-b22d7358b23c907ae7ca5b69cccbfea3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sunroom featuring a wood-paneled ceiling, exposed brick wall, and multiple windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29953497_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/1fab88f8f82c3722522b5967369bf98c.webp"
"MediaSize" => 90670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-1fab88f8f82c3722522b5967369bf98c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious interior room featuring parquet wood flooring, a central fireplace with a mantel, built-in shelving, white cabinetry, and a large window with vertical blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29953497_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/5afd2dd4217dc4957a96e7ce067b3d58.webp"
"MediaSize" => 90138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-5afd2dd4217dc4957a96e7ce067b3d58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring and a large window with vertical blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29953497_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/a209277e87f2308d70302faa388583f9.webp"
"MediaSize" => 100619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-a209277e87f2308d70302faa388583f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring a large window and glass sliding door, both equipped with vertical blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29953497_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/323f98eed340c837a2bf48b05a10d79f.webp"
"MediaSize" => 107276
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-323f98eed340c837a2bf48b05a10d79f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29953497_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/0591221bd2324c8622265f4a5de10c29.webp"
"MediaSize" => 70982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-0591221bd2324c8622265f4a5de10c29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring complements the neutral wall tones"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29953497_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/5b96c6bda0cdf882f8e380bf6c9dad97.webp"
"MediaSize" => 50615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-5b96c6bda0cdf882f8e380bf6c9dad97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a wood-finish flooring, white walls, and a built-in vanity with a laminate countertop and undermount sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29953497_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/3b936b5c0ab9088839559aba1b20148e.webp"
"MediaSize" => 60014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-3b936b5c0ab9088839559aba1b20148e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Utility room featuring a built-in shower, wire shelving, and durable flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29953497_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/6e9b6f30ce1cac86186e32e699427c88.webp"
"MediaSize" => 172954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-6e9b6f30ce1cac86186e32e699427c88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Multi-level wood deck featuring broad stairs and a perimeter railing"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29953497_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/82e1f1bdccec2c2da9adcfa921e946fa.webp"
"MediaSize" => 129842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-82e1f1bdccec2c2da9adcfa921e946fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood-finish deck with integrated seating, featuring direct access to the interior and exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29953497_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953497/d30005a05c1e5cec1614747a3bf92d68.webp"
"MediaSize" => 197903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953497/thumbnail-d30005a05c1e5cec1614747a3bf92d68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842430"
"ResourceRecordKey" => "29953497"
"ModificationTimestamp" => "2026-06-25T18:33:08.83Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953497')"
+"ID": "1562794"
}
]
+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 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24885
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2055634" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24854
+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 '29953497'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25237
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29953497'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25253
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29953497' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5655765 43.4559425)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25306
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25300
+post_id: "1564289"
+post_author: 1
+"ListingKey": "29949076"
+"ListingId": "40841876"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T21:20:13Z"
+"RFModificationTimestamp": "2026-06-25T23:48:22Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1983.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG Drive, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864421
1 => 43.462059
]
+"Latitude": 43.462059
+"Longitude": -80.5864421
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PRICELESS VIEW! The Holy Grail of Retirement Bungalows. Modern-build, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo’s coveted Clair Hills community! This rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. It is freshly painted and updated with new carpet, and is completely move-in ready. With 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The sun-filled open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings where you’ll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and features a walk-in closet and private 4-piece ensuite. The second bedroom delights with a built-in Murphy bed that easily converts the space from home office to ready-made guest room. The bright walkout basement includes oversized windows, a cozy gas fireplace, and direct yard access with a covered deck that's perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privilege, along with a spacious utility/storage room complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered light switches, and modern mechanical systems. Add the double garage, quiet low-traffic location, and a peaceful pond-side setting, and you have effortless living at its finest! Homes offering this combination of location, quality, and accessibility are seldom available, and perfect for those looking to downsize. Don’t miss your opportunity to call Rosewood Estates home! Book your private showing today!! (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:48:02.127003+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:11:25Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T21:11:25Z"
+"Stories": "1.0"
+"StreetName": "SALZBURG"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5446"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1667181102"
"RoomType" => "Utility room"
"ListingId" => "40841876"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "19'10'' x 18'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.43Z"
]
1 => array:11 [
"RoomKey" => "1667181103"
"RoomType" => "Recreation room"
"ListingId" => "40841876"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "18'9'' x 22'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
2 => array:11 [
"RoomKey" => "1667181104"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841876"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
3 => array:11 [
"RoomKey" => "1667181105"
"RoomType" => "Bedroom"
"ListingId" => "40841876"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "17'0'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
4 => array:11 [
"RoomKey" => "1667181106"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841876"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
5 => array:11 [
"RoomKey" => "1667181107"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841876"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
6 => array:11 [
"RoomKey" => "1667181108"
"RoomType" => "Bedroom"
"ListingId" => "40841876"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
7 => array:11 [
"RoomKey" => "1667181109"
"RoomType" => "Dining room"
"ListingId" => "40841876"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
8 => array:11 [
"RoomKey" => "1667181110"
"RoomType" => "Kitchen"
"ListingId" => "40841876"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
9 => array:11 [
"RoomKey" => "1667181111"
"RoomType" => "Living room"
"ListingId" => "40841876"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "18'10'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
10 => array:11 [
"RoomKey" => "1667181112"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841876"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29949076"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T21:11:25.44Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29949076/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2026-06-24T21:11:25.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29949076_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949076/0ed85418d432df11347e854051af5cda.webp"
"MediaSize" => 131787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949076/thumbnail-0ed85418d432df11347e854051af5cda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841876"
"ResourceRecordKey" => "29949076"
"ModificationTimestamp" => "2026-06-24T21:11:25.22Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29949076_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949076/6b871f20e9b90e7c1d4ff9d3d993bedd.webp"
"MediaSize" => 199594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949076/thumbnail-6b871f20e9b90e7c1d4ff9d3d993bedd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841876"
"ResourceRecordKey" => "29949076"
"ModificationTimestamp" => "2026-06-24T21:11:25.22Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29949076_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949076/b473eb626b50134fa0bea1efbb50955f.webp"
"MediaSize" => 161315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949076/thumbnail-b473eb626b50134fa0bea1efbb50955f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841876"
"ResourceRecordKey" => "29949076"
"ModificationTimestamp" => "2026-06-24T21:11:25.22Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29949076_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949076/41fb96a3f696858474b184ce542e8725.webp"
"MediaSize" => 74140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949076/thumbnail-41fb96a3f696858474b184ce542e8725.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841876"
"ResourceRecordKey" => "29949076"
"ModificationTimestamp" => "2026-06-24T21:11:25.22Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29949076_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949076/45be3c7ee598a2fc16a0b8c291be1ff1.webp"
"MediaSize" => 91853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949076/thumbnail-45be3c7ee598a2fc16a0b8c291be1ff1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841876"
"ResourceRecordKey" => "29949076"
"ModificationTimestamp" => "2026-06-24T21:11:25.22Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29949076_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949076/c71161490f676a2ceea7118e8373b877.webp"
"MediaSize" => 70006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949076/thumbnail-c71161490f676a2ceea7118e8373b877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841876"
"ResourceRecordKey" => "29949076"
"ModificationTimestamp" => "2026-06-24T21:11:25.22Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29949076_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949076/424d32853a6360b09c966dc532f00556.webp"
"MediaSize" => 69344
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949076/thumbnail-424d32853a6360b09c966dc532f00556.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841876"
"ResourceRecordKey" => "29949076"
"ModificationTimestamp" => "2026-06-24T21:11:25.22Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29949076_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29949076/bdb7bd8306d513aa13d69726e85b68ff.webp"
"MediaSize" => 80000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29949076/thumbnail-bdb7bd8306d513aa13d69726e85b68ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949076')"
+"ID": "1564289"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949431')"
+"ID": "1563978"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25299
+post_id: "1563698"
+post_author: 1
+"ListingKey": "29949612"
+"ListingId": "X13486026"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T22:55:14Z"
+"RFModificationTimestamp": "2026-06-25T23:10:34Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.586439
1 => 43.462061
]
+"Latitude": 43.462061
+"Longitude": -80.586439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "PRICELESS VIEW! The Holy Grail of Retirement Bungalows! Modern-build, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo's coveted Clair Hills community! This rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. It is freshly painted and updated with new carpet, and is completely move-in ready. With 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The sun-filled open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings where you'll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and features a walk-in closet and private 4-piece ensuite. The second bedroom delights with a built-in Murphy bed that easily converts the space from home office to ready-made guest room. The bright walkout basement includes oversized windows, a cozy gas fireplace, and direct yard access with a covered deck that's perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privilege, along with a spacious utility/storage room complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered light switches, and modern mechanical systems. Add the double garage, quiet low-traffic location, and a peaceful pond-side setting, and you have effortless living at its finest! Homes offering this combination of location, quality, and accessibility are seldom available, and perfect for those looking to downsize. Don't miss your opportunity to call Rosewood Estates home! (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:09:20.683398+00:00"
+"Directions": "Cross Streets: Columbia St W. ** Directions: Columbia to Salzburg Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T22:17:44Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T22:48:20Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5446"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29949612/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-24T22:17:44.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949612')"
+"ID": "1563698"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25303
+post_id: "1563603"
+post_author: 1
+"ListingKey": "29950018"
+"ListingId": "X13486204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T23:55:33Z"
+"RFModificationTimestamp": "2026-06-25T22:48:42Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5Y9"
+"UnparsedAddress": "13 - 206 CANDLEWOOD CRESCENT, Waterloo, Ontario N2L5Y9"
+"Coordinates": array:2 [
0 => -80.5582178
1 => 43.4593845
]
+"Latitude": 43.4593845
+"Longitude": -80.5582178
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"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)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T22:47:34.405190+00:00"
+"Directions": "Fisher-Hallman Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T23:45:35Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T23:45:35Z"
+"Stories": "2.0"
+"StreetName": "Candlewood"
+"StreetNumber": "206"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3809"
+"VirtualTourURLUnbranded": "https://youriguide.com/13_206_candlewood_crescent_waterloo_on/"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29950018/13-206-candlewood-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-24T23:45:35.6Z"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950018')"
+"ID": "1563603"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1563352"
+post_author: 1
+"ListingKey": "29950884"
+"ListingId": "40841906"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T14:10:21Z"
+"RFModificationTimestamp": "2026-06-26T14:12:48Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1748.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2H6"
+"UnparsedAddress": "402 WESTVALE Drive, Waterloo, Ontario N2T2H6"
+"Coordinates": array:2 [
0 => -80.5542697
1 => 43.4409929
]
+"Latitude": 43.4409929
+"Longitude": -80.5542697
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Sought-after Westvale 4-level backsplit that has been thoughtfully transformed for modern family living. Behind the front door, sunlight dances across the fully renovated open-concept main floor, where conversations flow easily from the spacious kitchen to the formal dining room and welcoming living room. Fully renovated in 2023, every detail was chosen with both beauty and function in mind. Upstairs, peaceful bedrooms offer a place to rest and recharge, while a third bedroom on the family room level creates flexibility for guests, a home office, or a growing family. Two full bathrooms ensure everyone has room to begin and end their day with ease. A few steps down from the formal living area offers one of the two family rooms, with a gas fireplace inviting cozy evenings, while sliding doors lead to a private backyard retreat. Here you'll find a deck for summer gatherings, a hot tub for starlit evenings, mature landscaping, and a fenced yard where children and pets can play freely. The lower level offers a third retreat to gather, relax, and create memories, with a spacious recreation room and built-in storage to keep life's treasures tucked neatly away, and a perfect hideaway to enjoy movie nights, a workout area, or a kids' playroom. Outside, the story continues. Walk to neighbourhood parks, playgrounds, and schools. Stroll to The Boardwalk for shopping, restaurants, a movie night, or everyday conveniences. Costco and Herrle's Country Farm Market are just minutes away. Beautifully updated, wonderfully located, and filled with spaces to live, laugh, and gather, this Westvale home is ready for its next chapter. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener"
5 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:03:58.769152+00:00"
+"Directions": "Westvale/Portsmouth"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563569"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T12:31:46Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T14:02:31Z"
+"Stories": "1.0"
+"StreetName": "WESTVALE"
+"StreetNumber": "402"
+"StreetSuffix": "Drive"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4110.58"
+"VirtualTourURLUnbranded": "https://youriguide.com/402_westvale_dr_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/29950884/402-westvale-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1600603"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2246706"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "76826"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 909
+"BelowGradeFinishedArea": 839
+"OriginalEntryTimestamp": "2026-06-25T12:31:46.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1109914"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1145016"
+"CoListAgentNationalAssociationId2": "1485557"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1004387"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950884')"
+"ID": "1563352"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "1562249"
+post_author: 1
+"ListingKey": "29951642"
+"ListingId": "40842957"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T03:45:03Z"
+"RFModificationTimestamp": "2026-06-26T04:28:10Z"
+"ListPrice": 1599000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3181.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2V7"
+"UnparsedAddress": "361 COLERIDGE Place, Waterloo, Ontario N2L2V7"
+"Coordinates": array:2 [
0 => -80.5520319
1 => 43.4595088
]
+"Latitude": 43.4595088
+"Longitude": -80.5520319
+"YearBuilt": 1972
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome Home Again to 361 Coleridge Place, nestled in the heart of sought-after Beechwood in Waterloo — one of the city’s most established and family-oriented neighborhoods. Situated on a quiet court and set on a large, private lot with a pool, this beautifully renovated home offers the perfect blend of modern luxury and mature community charm. Completely transformed, this home showcases a stunning new kitchen featuring a spacious island, built-in appliances, sleek finishes, and a thoughtful design ideal for both everyday living and entertaining. Smart home technology adds convenience and efficiency throughout. Designed with families in mind, this spacious home offers four generous bedrooms upstairs and a total of four beautifully updated bathrooms, providing comfort and functionality for busy households. The fully finished basement includes a fifth bedroom and offers excellent in-law capability, creating flexible living options for multigenerational families or guests. Step outside to your backyard retreat — a large lot with mature trees and an inviting pool with a refreshed concrete poolside terrace, ready for summer gatherings and family fun. Located in a quiet, established neighbourhood known for its parks, schools, and strong sense of community, this is a rare opportunity to own a turnkey home in one of Waterloo’s most desirable areas. A perfect place to call home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T19:48:24.883391+00:00"
+"Directions": "Erb St or Keats Way to Amos Ave to Coleridge Place"
+"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": "2010359"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T03:20:56Z"
+"PhotosCount": 42
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T03:39:41Z"
+"Stories": "2.0"
+"StreetName": "COLERIDGE"
+"StreetNumber": "361"
+"StreetSuffix": "Place"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "6864"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/km94d_361_coleridge_pl_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/29951642/361-coleridge-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2142
+"BelowGradeFinishedArea": 1039
+"OriginalEntryTimestamp": "2026-06-25T15:30:55.51Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1291922"
+"ListOfficeNationalAssociationId": "1328541"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29951642')"
+"ID": "1562249"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23456
+post_id: "1557597"
+post_author: 1
+"ListingKey": "29942116"
+"ListingId": "40841799"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T23:30:11Z"
+"RFModificationTimestamp": "2026-06-26T01:38:34Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2882.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N5"
+"UnparsedAddress": "561 CHANCERY Lane, Waterloo, Ontario N2T2N5"
+"Coordinates": array:2 [
0 => -80.5790524
1 => 43.4650089
]
+"Latitude": 43.4650089
+"Longitude": -80.5790524
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 561 Chancery Lane, Waterloo – a beautifully open and spacious backsplit nestled in one of Waterloo’s most desirable neighbourhoods. Offering 3 bedrooms, 3 full bathrooms, and exceptional indoor and outdoor living spaces, this home is designed for both everyday comfort and entertaining. The bright and inviting main level features soaring cathedral ceilings, hardwood flooring, and an open-concept living and dining area filled with natural light. The gourmet kitchen is sure to impress with stainless appliances, double wall ovens, a gas cooktop, built-in Miele coffee maker, and a spacious island perfect for gathering with family and friends. The lower level is an entertainer’s dream, showcasing a stylish bar area, custom built-ins, heated slate flooring, and a convenient walk-up to the backyard. A 3-piece bathroom on this level adds functionality and convenience for guests. Upstairs, you'll find three generously sized bedrooms and an updated 4-piece bathroom. The primary bedroom offers the added luxury of a private 3-piece ensuite. The basement provides excellent flexibility and can be used as a home gym, office, additional bedroom, or hobby space. A dedicated laundry room completes this level. Step outside to your own backyard retreat featuring a heated inground pool surrounded by stamped concrete. The cabana is fully equipped with hydro, speakers, a ceiling fan, and a fireplace, creating the perfect setting for summer entertaining. A separate pool house provides ample storage for all your pool equipment and accessories. Completing this home is a double attached garage and a fantastic location close to parks, schools, shopping, and all the amenities Waterloo has to offer. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T18:46:47.816559+00:00"
+"Directions": "Columbia/Chancery Lane"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T18:13:56Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T23:20:24Z"
+"Stories": "3.0"
+"StreetName": "CHANCERY"
+"StreetNumber": "561"
+"StreetSuffix": "Lane"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7433.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/561_chancery_lane_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/29942116/561-chancery-lane-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2130
+"BelowGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-06-23T16:51:24.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"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('29942116')"
+"ID": "1557597"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1557558"
+post_author: 1
+"ListingKey": "29940379"
+"ListingId": "40839785"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T14:10:19Z"
+"RFModificationTimestamp": "2026-06-26T14:13:16Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2313.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2T1"
+"UnparsedAddress": "183 DALECROFT Place, Waterloo, Ontario N2T2T1"
+"Coordinates": array:2 [
0 => -80.5784059
1 => 43.4702968
]
+"Latitude": 43.4702968
+"Longitude": -80.5784059
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Tucked away on a quiet court in sought-after Laurelwood, this enchanting family home offers the perfect blend of comfort, convenience, and community. Set on a pie-shaped lot, the property unfolds like a hidden garden retreat, with a private fenced yard, thoughtful landscaping, and a gate that opens directly onto a winding walking path. Imagine morning strolls beneath leafy canopies as you walk the children to top-rated Laurelwood Public School, or an easy walk to St. Nicholas Catholic School, the YMCA, library, Columbia Plaza with a major grocery store and many more shops, and nearby conservation lands filled with trails waiting to be explored. Inside, the home welcomes you with an airy open-concept design, updated flooring, and a beautifully refreshed kitchen where family meals and holiday gatherings naturally come together. Sliding doors lead seamlessly to the backyard oasis, inviting indoor-outdoor living throughout the seasons. A convenient two-piece powder room completes the main floor. Upstairs, three comfortable bedrooms provide peaceful spaces to rest and recharge. The primary suite features an updated three-piece ensuite, creating a private retreat at the end of the day. The lower level offers a spacious family room perfect for movie nights, play space, or cozy evenings at home. A rough-in for a future bathroom in the laundry area provides additional potential for growing families. Surrounded by nature, connected to every amenity, and nestled within one of Waterloo's most beloved neighbourhoods, this is more than a home - it's the setting for your family's next chapter. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"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-23T17:30:47.444552+00:00"
+"Directions": "Laurelwood Drive/Beaver Creek Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563569"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Gazebo"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T12:32:59Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T14:03:00Z"
+"Stories": "2.0"
+"StreetName": "DALECROFT"
+"StreetNumber": "183"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5354"
+"VirtualTourURLUnbranded": "https://youriguide.com/183_dalecroft_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29940379/183-dalecroft-place-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1600603"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2246706"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "76826"
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1677
+"BelowGradeFinishedArea": 636
+"OriginalEntryTimestamp": "2026-06-23T12:32:59.8Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1109914"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1145016"
+"CoListAgentNationalAssociationId2": "1485557"
+"CoListOfficeNationalAssociationId": "1004387"
+"CoListOfficeNationalAssociationId2": "1004387"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940379')"
+"ID": "1557558"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1557065"
+post_author: 1
+"ListingKey": "29940376"
+"ListingId": "40842170"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T21:40:14Z"
+"RFModificationTimestamp": "2026-06-23T21:40:33Z"
+"ListPrice": 629900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1981.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2L3"
+"UnparsedAddress": "560 PENNY Lane, Waterloo, Ontario N2T2L3"
+"Coordinates": array:2 [
0 => -80.556739
1 => 43.4393556
]
+"Latitude": 43.4393556
+"Longitude": -80.556739
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful two-storey home in the highly sought-after Westvale neighbourhood of Waterloo! Offering a functional traditional layout and numerous updates throughout, this move-in ready home is perfect for families and professionals alike. The main floor features a spacious kitchen, a bright and inviting living room with a stunning vaulted ceiling, and patio doors leading to your private, fully fenced backyard complete with an elevated deck—ideal for relaxing or entertaining. Upstairs, you'll find three generously sized bedrooms filled with natural light, including a primary bedroom with convenient built-in cabinetry. The fully finished basement provides additional living space, a second bathroom, and a large laundry room. Recent updates include an owned hot water heater (2025), water softener (2023), air conditioner (2024), many updated windows (2017), and more. Conveniently located close to schools, parks, groceries, shopping, restaurants, cafés, and everyday amenities, this is an exceptional opportunity to own a well-maintained home in one of Waterloo's most desirable communities. Book your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:30:44.470200+00:00"
+"Directions": "University to Baker to Penny Lane"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1962973"
+"ListOfficeKey": "259258"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T12:32:32Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T21:32:18Z"
+"Stories": "2.0"
+"StreetName": "PENNY"
+"StreetNumber": "560"
+"StreetSuffix": "Lane"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "4597"
+"VirtualTourURLUnbranded": "https://youriguide.com/560_penny_ln_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29940376/560-penny-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SD-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 34.0
+"AboveGradeFinishedArea": 1340
+"BelowGradeFinishedArea": 641
+"OriginalEntryTimestamp": "2026-06-23T12:32:32.39Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1252469"
+"ListOfficeNationalAssociationId": "1217708"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940376')"
+"ID": "1557065"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 111
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
]