array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29889823 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23361
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23363
+post_id: "1520602"
+post_author: 1
+"ListingKey": "29889823"
+"ListingId": "40838151"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T18:50:08Z"
+"RFModificationTimestamp": "2026-06-13T18:53:44Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2301.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "729 BRANDENBURG Boulevard, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.5790115
1 => 43.4569573
]
+"Latitude": 43.4569573
+"Longitude": -80.5790115
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 729 Brandenburg Boulevard, a beautifully maintained and thoughtfully updated 3-bedroom, 3-bathroom detached home in one of Waterloo’s most sought-after family-friendly neighbourhoods. Offering the perfect blend of comfort, functionality, and convenience, this move-in-ready home is ideal for growing families and busy professionals alike. The main floor features a bright and inviting layout, where a central staircase creates distinct living spaces while maintaining an open and connected feel. Spacious principal rooms provide plenty of room for everyday living and entertaining, while direct access to the backyard seamlessly extends your living space outdoors. Upstairs, you'll find three generously sized bedrooms and a well-appointed main bathroom designed for everyday family living. The finished basement adds valuable additional space with a large rec room, versatile den, full bathroom, cold cellar, and utility room—perfect for a home office, guest space, or recreation area. A rare detached double-car garage accessed from the rear laneway, along with direct gated access to the backyard, offers exceptional convenience, privacy, and flexibility. Ideally located just minutes from shopping, restaurants, The Boardwalk, Costco, Laurel Creek Conservation Area, parks, and excellent schools, this home offers an outstanding lifestyle in a highly desirable Waterloo community. Meticulously cared for and perfectly situated, this is a home you won't want to miss. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:31:02.889440+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2011048"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:10:34Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T18:39:40Z"
+"Stories": "2.0"
+"StreetName": "BRANDENBURG"
+"StreetNumber": "729"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4644"
+"VirtualTourURLUnbranded": "https://youriguide.com/729_brandenburg_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1658668452"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 3'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.31Z"
]
1 => array:11 [
"RoomKey" => "1658668453"
"RoomType" => "Bonus Room"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.31Z"
]
2 => array:11 [
"RoomKey" => "1658668454"
"RoomType" => "Bonus Room"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.31Z"
]
3 => array:11 [
"RoomKey" => "1658668455"
"RoomType" => "3pc Bathroom"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 6'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.32Z"
]
4 => array:11 [
"RoomKey" => "1658668456"
"RoomType" => "Utility room"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.32Z"
]
5 => array:11 [
"RoomKey" => "1658668457"
"RoomType" => "Recreation room"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "22'6'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.33Z"
]
6 => array:11 [
"RoomKey" => "1658668458"
"RoomType" => "Cold room"
"ListingId" => "40838151"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 20'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.33Z"
]
7 => array:11 [
"RoomKey" => "1658668459"
"RoomType" => "Bedroom"
"ListingId" => "40838151"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.34Z"
]
8 => array:11 [
"RoomKey" => "1658668460"
"RoomType" => "Bedroom"
"ListingId" => "40838151"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.34Z"
]
9 => array:11 [
"RoomKey" => "1658668461"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838151"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.34Z"
]
10 => array:11 [
"RoomKey" => "1658668462"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838151"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.35Z"
]
11 => array:11 [
"RoomKey" => "1658668463"
"RoomType" => "Kitchen"
"ListingId" => "40838151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.35Z"
]
12 => array:11 [
"RoomKey" => "1658668464"
"RoomType" => "Dining room"
"ListingId" => "40838151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.36Z"
]
13 => array:11 [
"RoomKey" => "1658668465"
"RoomType" => "Living room"
"ListingId" => "40838151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "22'4'' x 17'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.36Z"
]
14 => array:11 [
"RoomKey" => "1658668466"
"RoomType" => "Foyer"
"ListingId" => "40838151"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29889823"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T18:39:40.36Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29889823/729-brandenburg-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1549
+"BelowGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-06-11T17:10:33.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1292484"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29889823_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/b35b31a4268141f30960ab0f3beb915b.webp"
"MediaSize" => 126727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-b35b31a4268141f30960ab0f3beb915b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29889823_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/9abaffe1a8efc3ce7a855bc3b2e051b4.webp"
"MediaSize" => 104479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-9abaffe1a8efc3ce7a855bc3b2e051b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29889823_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/ce0287c597dff3953ba01ffcd108f775.webp"
"MediaSize" => 68865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-ce0287c597dff3953ba01ffcd108f775.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29889823_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/7d1c6a11e47d7f26764f9f13bdaaef56.webp"
"MediaSize" => 72438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-7d1c6a11e47d7f26764f9f13bdaaef56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29889823_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/e505781c6834922c90d59850e91460a0.webp"
"MediaSize" => 79740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-e505781c6834922c90d59850e91460a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29889823_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/b21a24e5617c12b3f8b945782eb55d7c.webp"
"MediaSize" => 94011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-b21a24e5617c12b3f8b945782eb55d7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29889823_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/3e7bc9fe7747e9b7678b9608a78d7084.webp"
"MediaSize" => 87780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-3e7bc9fe7747e9b7678b9608a78d7084.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29889823_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/c6fc221c7435c515645d57157ed5899f.webp"
"MediaSize" => 91130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-c6fc221c7435c515645d57157ed5899f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29889823_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/35e07a08f213d9f02a01cb8cac25c14d.webp"
"MediaSize" => 81536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-35e07a08f213d9f02a01cb8cac25c14d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29889823_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/915a8c3ba72669cb6ca25a3939bdfb00.webp"
"MediaSize" => 79509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-915a8c3ba72669cb6ca25a3939bdfb00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29889823_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/5f210f648ae20ef9e3754a9e078251cd.webp"
"MediaSize" => 76539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-5f210f648ae20ef9e3754a9e078251cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29889823_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/f1041a45ce74ee9a9841184ef7fc5764.webp"
"MediaSize" => 64265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-f1041a45ce74ee9a9841184ef7fc5764.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29889823_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/d0d7aa162e2d7f0567358e049ae2325a.webp"
"MediaSize" => 76032
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-d0d7aa162e2d7f0567358e049ae2325a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29889823_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/0eb7503dbc7e5463e5ec555d9126d86a.webp"
"MediaSize" => 56342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-0eb7503dbc7e5463e5ec555d9126d86a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29889823_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/f1f179ba415c1e757bac9bfdc2dd785f.webp"
"MediaSize" => 90289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-f1f179ba415c1e757bac9bfdc2dd785f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29889823_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/db6f771b9d90ab221fd0ce28b1cb3a0c.webp"
"MediaSize" => 68978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-db6f771b9d90ab221fd0ce28b1cb3a0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29889823_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/e4313056c874ce124f1d875e283a9478.webp"
"MediaSize" => 68146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-e4313056c874ce124f1d875e283a9478.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29889823_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/66d2e46e3bbf5ed4e523a2ba562efcaa.webp"
"MediaSize" => 74075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-66d2e46e3bbf5ed4e523a2ba562efcaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29889823_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/fc8d7190249ac45094b9228228007c5f.webp"
"MediaSize" => 87715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-fc8d7190249ac45094b9228228007c5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29889823_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/d4528f7cdb5263fc4b5791a751caec53.webp"
"MediaSize" => 87798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-d4528f7cdb5263fc4b5791a751caec53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29889823_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/b59f67bd14ab09e2b7ae3daa340119a7.webp"
"MediaSize" => 95043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-b59f67bd14ab09e2b7ae3daa340119a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29889823_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/0508cfb6fa0943466c10da28388f48ae.webp"
"MediaSize" => 97614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-0508cfb6fa0943466c10da28388f48ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29889823_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/cc5565f25650aee39b5af3fbc6dd9b72.webp"
"MediaSize" => 65049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-cc5565f25650aee39b5af3fbc6dd9b72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29889823_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/b5ffb52ef2af0a04188cf783eca30c94.webp"
"MediaSize" => 72802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-b5ffb52ef2af0a04188cf783eca30c94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29889823_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/fffeff4ed7de5d8be3116ca9245e32d4.webp"
"MediaSize" => 52781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-fffeff4ed7de5d8be3116ca9245e32d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29889823_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/8ed77503591b5ca99a9a4eca04dcdb75.webp"
"MediaSize" => 98706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-8ed77503591b5ca99a9a4eca04dcdb75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29889823_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/a0181c9a727e06813a82e2f15b5bc8fb.webp"
"MediaSize" => 124946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-a0181c9a727e06813a82e2f15b5bc8fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29889823_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/74c5e99d26d8c031cff3aa1b7b9e8fa6.webp"
"MediaSize" => 111624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-74c5e99d26d8c031cff3aa1b7b9e8fa6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29889823_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/a7fa9c65afbe3c76bb4e1df04644dee9.webp"
"MediaSize" => 113356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-a7fa9c65afbe3c76bb4e1df04644dee9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29889823_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/b9b1805a36893a3ad98bb64525421d10.webp"
"MediaSize" => 111986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-b9b1805a36893a3ad98bb64525421d10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29889823_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/d632fde6feb8c99d4c3f656d3120b18f.webp"
"MediaSize" => 118796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-d632fde6feb8c99d4c3f656d3120b18f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29889823_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/fc819aec5d00091a933059225faad293.webp"
"MediaSize" => 99941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-fc819aec5d00091a933059225faad293.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29889823_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/31df38e1a8c0beb66afee95a4f3877a2.webp"
"MediaSize" => 153955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-31df38e1a8c0beb66afee95a4f3877a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29889823_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/3598a3498cfb7adb7dca6180576d6d30.webp"
"MediaSize" => 136076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-3598a3498cfb7adb7dca6180576d6d30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29889823_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/94513e856e163f5f808a357804b892a8.webp"
"MediaSize" => 145049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-94513e856e163f5f808a357804b892a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29889823_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/54a0cf584aa07ea1f9a102d55abca911.webp"
"MediaSize" => 169950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-54a0cf584aa07ea1f9a102d55abca911.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29889823_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/a4c7140fb4892dc80be6686cb771e757.webp"
"MediaSize" => 126313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-a4c7140fb4892dc80be6686cb771e757.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29889823_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/535d0b830de8603621ae044facf5da02.webp"
"MediaSize" => 44522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-535d0b830de8603621ae044facf5da02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29889823_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/1184e5d0941186e8c987a897e0ccde38.webp"
"MediaSize" => 48935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-1184e5d0941186e8c987a897e0ccde38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29889823_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29889823/aeed28bddcf82674a40a26615165f36a.webp"
"MediaSize" => 48357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29889823/thumbnail-aeed28bddcf82674a40a26615165f36a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838151"
"ResourceRecordKey" => "29889823"
"ModificationTimestamp" => "2026-06-11T17:10:33.94Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889823')"
+"ID": "1520602"
}
]
+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 76789" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24808
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2011048" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24781
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29889823'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25122
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29889823'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25140
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25138
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31429827"
+"ListingKey": "29889823"
+"ListingId": "40838151"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-13"
+"OpenHouseStartTime": "2026-06-13T12:00:00Z"
+"OpenHouseEndTime": "2026-06-13T14:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-13T16:40:28Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31429827')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29889823' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5790115 43.4569573)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25213
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1526888"
+post_author: 1
+"ListingKey": "29899457"
+"ListingId": "40836979"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T16:10:07Z"
+"RFModificationTimestamp": "2026-06-13T16:11:17Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1178.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R4"
+"UnparsedAddress": "545 LAURELWOOD Drive Unit# 8, Waterloo, Ontario N2V2R4"
+"Coordinates": array:2 [
0 => -80.5892362
1 => 43.472406
]
+"Latitude": 43.472406
+"Longitude": -80.5892362
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Luxury Condo Bungalow Townhome (Perfect for Carefree Living//Young Professionals/Downsizers or Empty Nesters) Experience elevated main-floor living nestled in the heart of one of Waterloo's most coveted and desirable neighbourhoods, Laurelwood. This executive bungalow offers the perfect blend of luxury and natural privacy, backing directly onto a mature, tree-lined woodlot.The lush landscaping and charming front porch create a warm and inviting first impression. Step inside to a welcoming foyer where this bungalow offers elegant and carpet-free space. The sweeping 9' ceiling heights and large, bright windows create an incredibly airy and inviting atmosphere drawing natural light from every angle. Enjoy the warmth of a gas fireplace in the living room, a bright eat-in kitchen with a spacious dinette with garden doors opening to a walk-out private two tier deck ideal for your morning coffee or evening unwind. This beautifully maintained, 2+1 bedroom offers effortless, main-floor living. The large primary suite has a walk-in closet and an en-suite with a walk-in shower. The versatile second bedroom, currently used as a den, caters to your exact lifestyle needs. A convenient main-floor laundry as well as direct access to the garage adds to the home's practicality. Downstairs, the fully finished basement offers an incredible rec room/family room with a second gas fireplace, perfectly suited for hosting gatherings, movie nights or simply relaxing with loved ones along with a 4pc bathroom and a generous legal third bedroom and plenty of storage. Best of all the condo corporation takes care of all exterior maintenance, lawn care, and snow removal - giving you a true lock-and-leave convenience. With easy access to the Laurel Creek Conservation Area, scenic walking trails, YMCA, public transit and all local amenities, this move-in-ready home is a standout. Don't miss your chance to own this beautiful bungalow townhome - schedule your private showing today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "675"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:10:08.151035+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2192927"
+"ListOfficeKey": "294394"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T01:09:43Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T16:02:00Z"
+"Stories": "1.0"
+"StreetName": "LAURELWOOD"
+"StreetNumber": "545"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5098.85"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/pfcza_545_laurelwood_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1658585381"
"RoomType" => "4pc Bathroom"
"ListingId" => "40836979"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29899457"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 6'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:02:00.34Z"
]
1 => array:11 [
"RoomKey" => "1658585382"
"RoomType" => "Utility room"
"ListingId" => "40836979"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29899457"
"RoomLength" => null
"RoomDimensions" => "20'8'' x 23'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:02:00.34Z"
]
2 => array:11 [
"RoomKey" => "1658585383"
"RoomType" => "Recreation room"
"ListingId" => "40836979"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29899457"
"RoomLength" => null
"RoomDimensions" => "23'9'' x 31'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:02:00.35Z"
]
3 => array:11 [
"RoomKey" => "1658585384"
"RoomType" => "Bedroom"
"ListingId" => "40836979"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29899457"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:02:00.35Z"
]
4 => array:11 [
"RoomKey" => "1658585385"
"RoomType" => "4pc Bathroom"
"ListingId" => "40836979"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899457"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:02:00.35Z"
]
5 => array:11 [
"RoomKey" => "1658585386"
"RoomType" => "Full bathroom"
"ListingId" => "40836979"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899457"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:02:00.35Z"
]
6 => array:11 [
"RoomKey" => "1658585387"
"RoomType" => "Primary Bedroom"
"ListingId" => "40836979"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899457"
"RoomLength" => null
"RoomDimensions" => "24'1'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:02:00.35Z"
]
7 => array:11 [
"RoomKey" => "1658585388"
"RoomType" => "Bedroom"
"ListingId" => "40836979"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29899457"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:02:00.35Z"
]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29899457/545-laurelwood-drive-unit-8-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RES"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1178
+"OriginalEntryTimestamp": "2026-06-13T01:09:43.87Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1441867"
+"ListOfficeNationalAssociationId": "1438749"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899457')"
+"ID": "1526888"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1526793"
+post_author: 1
+"ListingKey": "29899532"
+"ListingId": "X13440680"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T18:25:11Z"
+"RFModificationTimestamp": "2026-06-13T18:26:28Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2R4"
+"UnparsedAddress": "8 - 545 LAURELWOOD DRIVE, Waterloo, Ontario N2V2R4"
+"Coordinates": array:2 [
0 => -80.5888765
1 => 43.4720287
]
+"Latitude": 43.4720287
+"Longitude": -80.5888765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Luxury Condo Bungalow Townhome (Perfect for Carefree Living//Young Professionals/Downsizers or Empty Nesters) Experience elevated main-floor living nestled in the heart of one of Waterloo's most coveted and desirable neighbourhoods, Laurelwood. This executive bungalow offers the perfect blend of luxury and natural privacy, backing directly onto a mature, tree-lined woodlot.The lush landscaping and charming front porch create a warm and inviting first impression. Step inside to a welcoming foyer where this bungalow offers elegant and carpet-free space. The sweeping 9' ceiling heights and large, bright windows create an incredibly airy and inviting atmosphere drawing natural light from every angle. Enjoy the warmth of a gas fireplace in the living room, a bright eat-in kitchen with a spacious dinette with garden doors opening to a walk-out private two tier deck ideal for your morning coffee or evening unwind. This beautifully maintained, 2+1 bedroom offers effortless, main-floor living. The large primary suite has a walk-in closet and an en-suite with a walk-in shower. The versatile second bedroom, currently used as a den, caters to your exact lifestyle needs. A convenient main-floor laundry as well as direct access to the garage adds to the home's practicality. Downstairs, the fully finished basement offers an incredible rec room/family room with a second gas fireplace, perfectly suited for hosting gatherings, movie nights or simply relaxing with loved ones along with a 4pc bathroom and a generous legal third bedroom and plenty of storage. Best of all the condo corporation takes care of all exterior maintenance, lawn care, and snow removal - giving you a true lock-and-leave convenience. With easy access to the Laurel Creek Conservation Area, scenic walking trails, YMCA, public transit and all local amenities, this move-in-ready home is a standout. Don't miss your chance to own this beautiful bungalow townhome - schedule your private showing today! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T02:04:46.105847+00:00"
+"Directions": "Cross Streets: Birchmount/Cedar Bend. ** Directions: Birchmount/Cedar Bend/Hollyview Place."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1406393"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T01:41:25Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T18:19:20Z"
+"Stories": "1.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "545"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5098.85"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/pfcza_545_laurelwood_dr_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"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29899532/8-545-laurelwood-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "CMC"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-13T01:41:25.63Z"
+"ListAgentNationalAssociationId": "1109349"
+"ListOfficeNationalAssociationId": "1310773"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29899532')"
+"ID": "1526793"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1525564"
+post_author: 1
+"ListingKey": "29898161"
+"ListingId": "40839319"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T14:45:03Z"
+"RFModificationTimestamp": "2026-06-13T14:48:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1322.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2K6"
+"UnparsedAddress": "629 SETTLERSFIELD Court Unit# B, Waterloo, Ontario N2T2K6"
+"Coordinates": array:2 [
0 => -80.569755
1 => 43.4490121
]
+"Latitude": 43.4490121
+"Longitude": -80.569755
+"YearBuilt": 1991
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prepare to fall in love with this beautifully updated backsplit with separate side entrance. Located in a quiet family friendly neighbourhood close to the Boardwalk Costco and more. This 2 plus bedroom boasts 3 full bathrooms, open concept floor plan featuring Stainless steel appliance, quartz countertops, upgraded kitchen cabinets and lighting package plus an attractive staircase. Upstairs you will find 2 bedrooms plus built in laundry and 4 piece bath. You'll love the familyroom with large windows for tons of natural light. Full 4 piece bath is within easy reach, there is a side entrance leading to a great deck and a fully fenced pie shaped back yard with mature trees. Looking for extra space then basement level features a brand new inlaw with 2nd kitchen with appliances, good size 3rd bedroom or recroom plus another 3 piece bathroom for the teens. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T21:37:11.360335+00:00"
+"Directions": "ERBSVILLE ROAD TO RUMMERLHARDT DR TO PINEROW CRES"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948781"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-12T21:10:21Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T14:40:05Z"
+"Stories": "3.0"
+"StreetName": "SETTLERSFIELD"
+"StreetNumber": "629"
+"StreetSuffix": "Court"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "4025"
+"Utilities": array:1 [
0 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/629_b_settlersfield_ct_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898161/629-settlersfield-court-unit-b-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1563914"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76807"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 24.0
+"AboveGradeFinishedArea": 829
+"BelowGradeFinishedArea": 493
+"OriginalEntryTimestamp": "2026-06-12T21:10:19.47Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1243289"
+"ListOfficeNationalAssociationId": "1380559"
+"CoListAgentNationalAssociationId": "1069671"
+"CoListOfficeNationalAssociationId": "1004370"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898161')"
+"ID": "1525564"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1524680"
+post_author: 1
+"ListingKey": "29894553"
+"ListingId": "40829023"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:30:06Z"
+"RFModificationTimestamp": "2026-06-12T20:09:42Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1596.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "417 KEATS Way Unit# 4, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.5566627
1 => 43.4577016
]
+"Latitude": 43.4577016
+"Longitude": -80.5566627
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you’ll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T20:09:38.059035+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-12T14:22:18Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T14:22:18Z"
+"Stories": "2.0"
+"StreetName": "KEATS"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_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/29894553/417-keats-way-unit-4-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1366
+"BelowGradeFinishedArea": 230
+"OriginalEntryTimestamp": "2026-06-12T14:22:18.59Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894553')"
+"ID": "1524680"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+post_id: "1524681"
+post_author: 1
+"ListingKey": "29895192"
+"ListingId": "X13436726"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:40:12Z"
+"RFModificationTimestamp": "2026-06-12T19:50:47Z"
+"ListPrice": 429900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5S7"
+"UnparsedAddress": "4 - 417 KEATS WAY, Waterloo, Ontario N2L5S7"
+"Coordinates": array:2 [
0 => -80.556684
1 => 43.457734
]
+"Latitude": 43.457734
+"Longitude": -80.556684
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Updated and spacious, this Beechwood, 3 bedroom, 2.5 bathroom townhouse offers approximately 1,600 square feet of comfortable living space in a highly desirable Waterloo location. Ideal for first-time buyers, families, or investors, the home features a bright, open living room with built-in shelving and elegant crown molding. Upstairs, you'll find a large primary bedroom with a walk-in closet, along with two additional generously sized bedrooms. The fully finished basement adds excellent flexibility with a large, versatile rec room, full bathroom, and laundry area. Set in a quiet complex with ample visitor parking and green space, this property is conveniently located close to everyday amenities, including two grocery stores within walking distance, major bus routes, the expressway, and both universities, including walking distance to the University of Waterloo. A well-kept, move-in-ready opportunity in a convenient and sought-after location. (id:62783)"
+"AssociationFee": "612"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:38.683182+00:00"
+"Directions": "Fischer-Hallman"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Garage"
1 => "Carport"
2 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-12T15:30:32Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T15:30:32Z"
+"Stories": "2.0"
+"StreetName": "Keats"
+"StreetNumber": "417"
+"StreetSuffix": "Way"
+"TaxAnnualAmount": "3014"
+"VirtualTourURLUnbranded": "https://youriguide.com/4_417_keats_way_waterloo_on/"
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895192/4-417-keats-way-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-12T15:30:32.56Z"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895192')"
+"ID": "1524681"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25183
+post_id: "1524682"
+post_author: 1
+"ListingKey": "29895200"
+"ListingId": "40838845"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T00:40:13Z"
+"RFModificationTimestamp": "2026-06-13T00:41:23Z"
+"ListPrice": 1179000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3112.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2V4"
+"UnparsedAddress": "725 ZURICH Drive, Waterloo, Ontario N2V2V4"
+"Coordinates": array:2 [
0 => -80.58337
1 => 43.4566032
]
+"Latitude": 43.4566032
+"Longitude": -80.58337
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located in the highly desirable neighbourhood of Clair Hills in West Waterloo, 725 Zurich Drive is a rare opportunity for growing families seeking space, functionality, and an unbeatable location! Boasting over 3000 sq/ft of finished living space, this impressive 5 Bed/3 Bath home offers a thoughtfully designed open concept layout with incredible versatility throughout. The bright and welcoming main floor serves as the heart of the home, featuring spacious principal rooms ideal for everyday living and entertaining. Large windows provide an abundance of natural light while creating a warm and inviting atmosphere. Recent major updates including a new roof with solar panels (~5k/Yr ROI), new windows, new furnace, and new on-demand water heater provide exceptional value and peace of mind for years to come. Upstairs, the spacious primary bedroom offers a comfortable retreat with a large en-suite, while an additional bedroom and full bathroom complete the upper level with functionality and convenience. A true standout feature of this home is the fully finished basement, offering exceptional additional living space with *3 generously sized bedrooms, making it ideal for larger families, multi-generational living, overnight guests, or flexible work-from-home options. Complete with a full bathroom and ample space for recreation or additional family living, the lower level adds tremendous versatility and value rarely found in homes within this neighbourhood. Step outside to enjoy the fully fenced backyard featuring a private patio area and storage shed, the perfect setting for relaxing evenings, entertaining guests, or safe outdoor play for children and pets alike. Ideally located near top-rated schools including Vista Hills and Laurel Heights Secondary School, as well as the scenic GeoTime trails and surrounding forest, this family-friendly location offers the perfect balance of convenience and nature. Pride of ownership is evident throughout this beautifully maintained home! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Satellite Dish"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:48:03.419047+00:00"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2052274"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Corner Site"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T15:31:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T00:31:49Z"
+"Stories": "1.0"
+"StreetName": "ZURICH"
+"StreetNumber": "725"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "6877"
+"VirtualTourURLUnbranded": "https://youriguide.com/725_zurich_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29895200/725-zurich-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1587
+"BelowGradeFinishedArea": 1525
+"OriginalEntryTimestamp": "2026-06-12T15:31:43.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1327496"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895200')"
+"ID": "1524682"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23375
+post_id: "1524092"
+post_author: 1
+"ListingKey": "29896571"
+"ListingId": "X13438200"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:55:09Z"
+"RFModificationTimestamp": "2026-06-12T22:58:47Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P6"
+"UnparsedAddress": "635 ROYAL FERN STREET, Waterloo, Ontario N2V2P6"
+"Coordinates": array:2 [
0 => -80.589798
1 => 43.464848
]
+"Latitude": 43.464848
+"Longitude": -80.589798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RARE FIND! Prime location with amazing privacy and forest views! This fully finished detached 3 bedroom, 3 bathroom home offers an exceptional layout and an excellent finished basement. As you pull up to the home, you'll immediately notice its charming curb appeal. Step inside and you'll find a bright, welcoming space that feels just right. The care and updates throughout the home are evident at every turn. The main floor features an open-concept kitchen, dining, and living area with a vaulted ceiling and beautiful patio doors leading to your backyard paradise. The yard includes a new deck (2024) and a fenced yard, creating a beautiful, peaceful retreat that is still low maintenance. Upstairs, the spacious primary bedroom overlooks the backyard and offers plenty of room to relax. The stunning, spa-like primary ensuite, updated in 2023, is truly impressive. Two additional bedrooms complete the upper level. The basement features another full bathroom, plenty of storage space, a home office, and a large recreation room. The location is fantastic, close to top rated schools, beautiful walking trails, shopping, and more! Don't miss this rare opportunity to own a private, move-in-ready home in an outstanding location. ** SEE VIDEO FOR FULL TOUR!! ** WOW! (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:21:27.298705+00:00"
+"Directions": "Cross Streets: Erbville Rd and Columbia Forst Blvd. ** Directions: Erbsville Rd, West on Columbia Forest Blvd, right on Royal Fern St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2246631"
+"ListOfficeKey": "286835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "27.8 x 106.1 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-12T22:49:11Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T22:49:11Z"
+"Stories": "2.0"
+"StreetName": "ROYAL FERN"
+"StreetNumber": "635"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4225.17"
+"VirtualTourURLUnbranded": "https://youtu.be/6ORw7Bao_3A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896571/635-royal-fern-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 27.9
+"OriginalEntryTimestamp": "2026-06-12T17:56:38.8Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1485484"
+"ListOfficeNationalAssociationId": "1364242"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896571')"
+"ID": "1524092"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1521301"
+post_author: 1
+"ListingKey": "29891893"
+"ListingId": "X13433902"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T22:00:07Z"
+"RFModificationTimestamp": "2026-06-11T22:02:43Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2R2"
+"UnparsedAddress": "450 WESTHAVEN STREET, Waterloo, Ontario N2T2R2"
+"Coordinates": array:2 [
0 => -80.566908
1 => 43.445283
]
+"Latitude": 43.445283
+"Longitude": -80.566908
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 450 Westhaven Street, a beautifully upgraded Ritz Homes residence in one of Waterloo's most sought after family neighbourhoods. Less than one year old, this stunning home offers approximately 2,320 sq ft above grade plus a finished basement, featuring quartz countertops throughout, a designer kitchen with a custom coffee bar, engineered hardwood flooring, oak staircases with black metal pickets, and no carpet throughout. The finished lower level adds exceptional versatility with a spacious recreation room, additional bedroom, full bathroom, and a convenient kitchenette complete with a sink, making it ideal for extended family, guests, or multi generational living. Complete with 200 amp service, central air conditioning, gas lines for the stove and BBQ, and numerous builder upgrades, this move in ready home offers the perfect blend of style, comfort, and functionality.Ideally situated in the highly desirable Westvale area of Waterloo, this home is surrounded by excellent schools, beautiful parks, walking trails, playgrounds, and family friendly amenities. Enjoy convenient access to shopping, restaurants, Costco, The Boardwalk, universities, public transit, and major commuter routes including Highway 7/8. Whether you're raising a family, working from home, or simply looking for a newer home in a thriving community, 450 Westhaven Street delivers exceptional value in one of Waterloo's most convenient and connected locations. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Apartment in basement"
3 => "Separate entrance"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:22:24.773387+00:00"
+"Directions": "Cross Streets: Erb Street W to Westhaven Street. ** Directions: Erb Street W."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2071055"
+"ListOfficeKey": "148048"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Guest Suite"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "31.5 x 113.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T20:54:15Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T21:53:53Z"
+"Stories": "2.0"
+"StreetName": "Westhaven"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3794.36"
+"VirtualTourURLUnbranded": "https://youriguide.com/450_westhaven_st_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891893/450-westhaven-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "SR-1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 31.6
+"OriginalEntryTimestamp": "2026-06-11T20:54:14.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1346258"
+"ListOfficeNationalAssociationId": "1177786"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891893')"
+"ID": "1521301"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1521937"
+post_author: 1
+"ListingKey": "29891240"
+"ListingId": "X13433662"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:15:13Z"
+"RFModificationTimestamp": "2026-06-11T20:20:04Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2X4"
+"UnparsedAddress": "462 LAUSANNE CRESCENT, Waterloo, Ontario N2T2X4"
+"Coordinates": array:2 [
0 => -80.5749644
1 => 43.453304
]
+"Latitude": 43.453304
+"Longitude": -80.5749644
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Rarely does a home offer the perfect combination of privacy, convenience, and natural surroundings quite like this. Welcome to 462 Lausanne Crescent, a beautifully maintained FREEHOLD townhouse in Waterloo's highly desirable Clair Hills neighbourhood - providing the freedom of homeownership with no condo fees and backing directly onto open park-like space. Inside, you'll find a thoughtfully designed layout featuring two spacious bedrooms, each complete with its own private 4-piece ensuite bathroom - an ideal setup for professionals, downsizers, guests, or those seeking comfortable multi-generational living. The bright and functional main living areas provide an inviting space for everyday life, while the fully finished basement expands your options with a generous recreation room and versatile den, perfect for a home office or hobby room. One of the home's standout features is its exceptional setting. Backing onto expansive open park-like space with no rear neighbours, you'll enjoy peaceful views, added privacy, and direct access to trails and the outdoors. Located in the sought-after Clair Hills community and nearby Boardwalk shopping district, you'll enjoy close proximity to shopping, restaurants, public transit, and everyday amenities making this a favourite neighbourhood for professionals, families, and active adults alike. Offering flexible living space, a fully finished basement, two private ensuites, no condo fees, and a premium park-side location, this is a wonderful opportunity to enjoy all that Clair Hills has to offer. (id:66098)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Freezer"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:19:52.553690+00:00"
+"Directions": "Cross Streets: Erbsville Road. ** Directions: Erbsville Road to Keats Way to Brandenburg Blvd to Lausanne Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1555372"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "16 x 99.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:31:56Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T20:04:17Z"
+"Stories": "2.0"
+"StreetName": "Lausanne"
+"StreetNumber": "462"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3766.84"
+"VirtualTourURLUnbranded": "https://youriguide.com/lmi4y_462_lausanne_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "OnePoint"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29891240/462-lausanne-crescent-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2088761"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "85457"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 16.0
+"OriginalEntryTimestamp": "2026-06-11T19:31:56.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1147383"
+"ListOfficeNationalAssociationId": "1002051"
+"CoListAgentNationalAssociationId": "1362076"
+"CoListOfficeNationalAssociationId": "1002051"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891240')"
+"ID": "1521937"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 129
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]