array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29888538 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23338
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23340
+post_id: "1518667"
+post_author: 1
+"ListingKey": "29888538"
+"ListingId": "40838818"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T19:40:08Z"
+"RFModificationTimestamp": "2026-06-12T19:43:03Z"
+"ListPrice": 719000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1746.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P6"
+"UnparsedAddress": "635 ROYAL FERN Street, Waterloo, Ontario N2V2P6"
+"Coordinates": array:2 [
0 => -80.5898653
1 => 43.4648243
]
+"Latitude": 43.4648243
+"Longitude": -80.5898653
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"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 family-sized primary bathroom is truly impressive. Updated in 2023 it features a separate glass shower and jacuzzi tub with a large vanity and ample counter space. The heated tile floor adds a luxurious warmth that adds to the spa-like atmosphere. 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 with built-in speakers and set-up for a projector for a potential home theatre experience! 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:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"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-11T15:39:38.270491+00:00"
+"Directions": "Erbsville Road, west onto Columbia Forest Blvd, right onto Royal Fern, house on the left near top of the street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1921681"
+"ListOfficeKey": "289848"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T01:49:36Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T19:31:52Z"
+"Stories": "2.0"
+"StreetName": "ROYAL FERN"
+"StreetNumber": "635"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4225.17"
+"VirtualTourURLUnbranded": "https://youtu.be/6ORw7Bao_3A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1657926250"
"RoomType" => "Storage"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "5'2'' x 7'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.66Z"
]
1 => array:11 [
"RoomKey" => "1657926251"
"RoomType" => "Laundry room"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "8'7'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.66Z"
]
2 => array:11 [
"RoomKey" => "1657926252"
"RoomType" => "3pc Bathroom"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
3 => array:11 [
"RoomKey" => "1657926253"
"RoomType" => "Office"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
4 => array:11 [
"RoomKey" => "1657926254"
"RoomType" => "Recreation room"
"ListingId" => "40838818"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 17'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
5 => array:11 [
"RoomKey" => "1657926255"
"RoomType" => "Bedroom"
"ListingId" => "40838818"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
6 => array:11 [
"RoomKey" => "1657926256"
"RoomType" => "Bedroom"
"ListingId" => "40838818"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
7 => array:11 [
"RoomKey" => "1657926257"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838818"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
8 => array:11 [
"RoomKey" => "1657926258"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838818"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
9 => array:11 [
"RoomKey" => "1657926259"
"RoomType" => "2pc Bathroom"
"ListingId" => "40838818"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
10 => array:11 [
"RoomKey" => "1657926260"
"RoomType" => "Living room"
"ListingId" => "40838818"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 19'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
11 => array:11 [
"RoomKey" => "1657926261"
"RoomType" => "Dining room"
"ListingId" => "40838818"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
12 => array:11 [
"RoomKey" => "1657926262"
"RoomType" => "Kitchen"
"ListingId" => "40838818"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29888538"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T19:31:52.67Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29888538/635-royal-fern-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1333
+"BelowGradeFinishedArea": 413
+"OriginalEntryTimestamp": "2026-06-11T15:11:24.95Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1227128"
+"ListOfficeNationalAssociationId": "1381908"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29888538_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/1ce9baabfc18d22de633c5b90cf1d54f.webp"
"MediaSize" => 145331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-1ce9baabfc18d22de633c5b90cf1d54f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-12T00:01:17.14Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29888538_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/e23124f845a7ad1f4dcae3637cd1fc67.webp"
"MediaSize" => 52557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-e23124f845a7ad1f4dcae3637cd1fc67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.93Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29888538_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/54d67cb9d1ccac6bf0f079ef4abc5c8c.webp"
"MediaSize" => 91533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-54d67cb9d1ccac6bf0f079ef4abc5c8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:40.92Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29888538_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/d216f4da5f685998af526b5fe877c753.webp"
"MediaSize" => 33412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-d216f4da5f685998af526b5fe877c753.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.94Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29888538_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/43572b3703f98bc3bf9d835ee981d8f8.webp"
"MediaSize" => 78985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-43572b3703f98bc3bf9d835ee981d8f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.95Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29888538_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/021f96fbebeb90c67be65b166e1aae9a.webp"
"MediaSize" => 33622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-021f96fbebeb90c67be65b166e1aae9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.95Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29888538_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/8516e1ddbe903713d807c318af40f3bc.webp"
"MediaSize" => 29592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-8516e1ddbe903713d807c318af40f3bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:40.99Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29888538_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/4c457c787544dac3bf7b89c6269fa88a.webp"
"MediaSize" => 30781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-4c457c787544dac3bf7b89c6269fa88a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:40.92Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29888538_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/ba68ed2020be455e6ac1f0c123fb4842.webp"
"MediaSize" => 34763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-ba68ed2020be455e6ac1f0c123fb4842.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.96Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29888538_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/0ff34a18b8c1251c96aedb9a1bb8a610.webp"
"MediaSize" => 34742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-0ff34a18b8c1251c96aedb9a1bb8a610.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:40.92Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29888538_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/037b364caa25f7c518b5640ca29d6f87.webp"
"MediaSize" => 26279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-037b364caa25f7c518b5640ca29d6f87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:40.92Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29888538_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/1e30f07788a6b1dbd5a2ef61455d2689.webp"
"MediaSize" => 29568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-1e30f07788a6b1dbd5a2ef61455d2689.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.95Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29888538_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/a8fc4e161c0d7d773171caacece4bf50.webp"
"MediaSize" => 21629
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-a8fc4e161c0d7d773171caacece4bf50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.96Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29888538_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/88bedaf34d9258e90e7e3865d5c835e8.webp"
"MediaSize" => 24685
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-88bedaf34d9258e90e7e3865d5c835e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.94Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29888538_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/9662a377f875cffcb2a63bab20df018d.webp"
"MediaSize" => 28949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-9662a377f875cffcb2a63bab20df018d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.94Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29888538_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/d5272e725c6523a6db0fd578fdf06bac.webp"
"MediaSize" => 28664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-d5272e725c6523a6db0fd578fdf06bac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:41.02Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29888538_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/90f1c762e2d85867e9325908c9ca21d4.webp"
"MediaSize" => 35643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-90f1c762e2d85867e9325908c9ca21d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.97Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29888538_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/daa17b22c0fd202a9e848b064a40740f.webp"
"MediaSize" => 30833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-daa17b22c0fd202a9e848b064a40740f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.96Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29888538_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/76ad7504e1c7893f54e5516693c8cc5b.webp"
"MediaSize" => 23353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-76ad7504e1c7893f54e5516693c8cc5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.95Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29888538_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/92b576deb406a236c734a3a5ddcb9e03.webp"
"MediaSize" => 79321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-92b576deb406a236c734a3a5ddcb9e03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:39.95Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29888538_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/637a76c8ef339dc33072ef3284a676be.webp"
"MediaSize" => 66715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-637a76c8ef339dc33072ef3284a676be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-11T15:13:40.93Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29888538_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888538/8b2389bb541a3d32447ffa1d5a99dca9.webp"
"MediaSize" => 58709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888538/thumbnail-8b2389bb541a3d32447ffa1d5a99dca9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838818"
"ResourceRecordKey" => "29888538"
"ModificationTimestamp" => "2026-06-12T01:31:53.69Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888538')"
+"ID": "1518667"
}
]
+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 289848" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24745
+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 1921681" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24721
+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 '29888538'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25044
+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 '29888538'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25063
+items: array:3 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25060
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31428455"
+"ListingKey": "29888538"
+"ListingId": "40838818"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-11T23:41:57Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31428455')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25062
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31438651"
+"ListingKey": "29888538"
+"ListingId": "40838818"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T17:59:38Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31438651')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25059
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31450038"
+"ListingKey": "29888538"
+"ListingId": "40838818"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-12T22:35:10Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31450038')"
}
]
+success: true
+page_size: 3
+page_count: 1
+count: 3
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29888538' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5898653 43.4648243)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25119
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25113
+post_id: "1524682"
+post_author: 1
+"ListingKey": "29895200"
+"ListingId": "40838845"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T15:40:12Z"
+"RFModificationTimestamp": "2026-06-12T19:50:35Z"
+"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), 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:62783)"
+"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-12T15:31:43Z"
+"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 [
"RoomKey" => "1657761785"
"RoomType" => "Bedroom"
"ListingId" => "40838845"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.41Z"
]
1 => array:11 [
"RoomKey" => "1657761786"
"RoomType" => "Utility room"
"ListingId" => "40838845"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.41Z"
]
2 => array:11 [
"RoomKey" => "1657761787"
"RoomType" => "Recreation room"
"ListingId" => "40838845"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "17'4'' x 21'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.41Z"
]
3 => array:11 [
"RoomKey" => "1657761788"
"RoomType" => "Laundry room"
"ListingId" => "40838845"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
4 => array:11 [
"RoomKey" => "1657761789"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838845"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
5 => array:11 [
"RoomKey" => "1657761790"
"RoomType" => "Bedroom"
"ListingId" => "40838845"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
6 => array:11 [
"RoomKey" => "1657761791"
"RoomType" => "Bedroom"
"ListingId" => "40838845"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
7 => array:11 [
"RoomKey" => "1657761792"
"RoomType" => "Bedroom"
"ListingId" => "40838845"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
8 => array:11 [
"RoomKey" => "1657761793"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838845"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
9 => array:11 [
"RoomKey" => "1657761794"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838845"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
10 => array:11 [
"RoomKey" => "1657761795"
"RoomType" => "Other"
"ListingId" => "40838845"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
11 => array:11 [
"RoomKey" => "1657761796"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838845"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 19'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
12 => array:11 [
"RoomKey" => "1657761797"
"RoomType" => "Dining room"
"ListingId" => "40838845"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "15'6'' x 20'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
13 => array:11 [
"RoomKey" => "1657761798"
"RoomType" => "Kitchen"
"ListingId" => "40838845"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 17'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.42Z"
]
14 => array:11 [
"RoomKey" => "1657761799"
"RoomType" => "Living room"
"ListingId" => "40838845"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29895200"
"RoomLength" => null
"RoomDimensions" => "17'11'' x 20'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T15:31:43.43Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29895200_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/cc6ca7308fd37a66b09f83faaafc0eba.webp"
"MediaSize" => 94978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-cc6ca7308fd37a66b09f83faaafc0eba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick and siding exterior with stone accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29895200_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/c552ea67c72cdc5e8543ea1703abf254.webp"
"MediaSize" => 100272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-c552ea67c72cdc5e8543ea1703abf254.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring brick and siding exterior, an integrated garage with a dark panel door, an upper-level balcony with black railings, and a paved driveway with stone edging"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29895200_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/1dfd30dee44c31586a5fa801ac8fe0fa.webp"
"MediaSize" => 122760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-1dfd30dee44c31586a5fa801ac8fe0fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring an attached garage with a dark panel door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29895200_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/e20f93d63591cf2c72a8218732f6bead.webp"
"MediaSize" => 103993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-e20f93d63591cf2c72a8218732f6bead.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Property entrance featuring a paneled black door, sidelight windows, and transom window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29895200_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/93339a6dcf00bf03b689721b41a0344f.webp"
"MediaSize" => 51833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-93339a6dcf00bf03b689721b41a0344f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive living space featuring light wood-finish flooring, recessed lighting, white window shutters, and an open layout to the dining area and kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29895200_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/6ea702ddc07da1ea4b0e684cd2965e42.webp"
"MediaSize" => 43823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-6ea702ddc07da1ea4b0e684cd2965e42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living area with light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29895200_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/3e75690e990ce2adcda579f9408dd674.webp"
"MediaSize" => 46513
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-3e75690e990ce2adcda579f9408dd674.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-finish flooring, white walls, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29895200_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/24cd1c44c19d4f2e60c9d244208348e0.webp"
"MediaSize" => 46631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-24cd1c44c19d4f2e60c9d244208348e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living space featuring light wood-finish flooring, recessed lighting, a modern ceiling fan, and a wood slat accent wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29895200_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/0e27a2c2b9029e509774cb584ee40ba4.webp"
"MediaSize" => 62844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-0e27a2c2b9029e509774cb584ee40ba4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring light wood-finish flooring, recessed lighting, and white plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29895200_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/65395cf1259abb96caba134c6cfd9ef0.webp"
"MediaSize" => 64353
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-65395cf1259abb96caba134c6cfd9ef0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring light wood-finish flooring, recessed ceiling lighting, and multiple windows with plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29895200_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/5933fde54edbec53df485ac7e0d8b770.webp"
"MediaSize" => 57948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29895200/thumbnail-5933fde54edbec53df485ac7e0d8b770.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838845"
"ResourceRecordKey" => "29895200"
"ModificationTimestamp" => "2026-06-12T15:31:43.38Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29895200_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29895200/3da3d68888dc63eb12bb6101cc1ce665.webp"
"MediaSize" => 69812
"MediaType" => "webp"
…8
]
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('29895200')"
+"ID": "1524682"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25115
+post_id: "1524746"
+post_author: 1
+"ListingKey": "29896131"
+"ListingId": "40839300"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:30:21Z"
+"RFModificationTimestamp": "2026-06-12T19:24:26Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1793.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "742 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5833029
1 => 43.4751935
]
+"Latitude": 43.4751935
+"Longitude": -80.5833029
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This beautifully maintained home is ideally located on a quiet cul-de-sac in Waterloo's sought-after Laurelwood neighbourhood. Backing onto a conservation area with NO REAR NEIGHBOURS, this smoke-free, pet-free home features nearly 1,800 sq. ft. of finished living space, 3 bedrooms, 2 bathrooms, and a finished basement with rough-in for an additional bathroom. The bright, open-concept main floor showcases hardwood flooring and a stunning great room with soaring cathedral ceilings and tranquil forest views. Upstairs, you'll find a spacious primary bedroom with cheater ensuite access, along with two additional bedrooms ideal for family, guests, or a home office. The finished basement adds valuable living space with a bright recroom, laundry/mechanical area, storage, and future 2-pc bathroom. Step outside to a spacious pie-shaped backyard, complete with a multi-level deck and peaceful natural surroundings. Thoughtful updates include: RO water system (2026), broadloom in basement and upper stairs (2026), kitchen faucet (2025), upper bathroom sink and faucet (2025), washer and dryer (2024).Located just minutes from excellent schools, scenic trails, parks, shopping, The YMCA, library, and both universities, this is a rare opportunity to enjoy the lifestyle Laurelwood is known for. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:24:17.772712+00:00"
+"Directions": "West on Laurelwood from Fischer-Hallman, then north on Brookmill Pl."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981704"
+"ListOfficeKey": "289890"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:15:38Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T17:15:38Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "742"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "4970.51"
+"VirtualTourURLUnbranded": "https://youriguide.com/vYG2V95C5V8DD1/"
+"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/29896131/742-brookmill-place-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 22.0
+"AboveGradeFinishedArea": 1230
+"BelowGradeFinishedArea": 563
+"OriginalEntryTimestamp": "2026-06-12T17:10:09.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267102"
+"ListOfficeNationalAssociationId": "1382470"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896131')"
+"ID": "1524746"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25112
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896571')"
+"ID": "1524092"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25116
+post_id: "1520602"
+post_author: 1
+"ListingKey": "29889823"
+"ListingId": "40838151"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:30:21Z"
+"RFModificationTimestamp": "2026-06-11T20:31:11Z"
+"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:62783)"
+"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-11T17:10:33Z"
+"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 [ …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/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 [ …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('29889823')"
+"ID": "1520602"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25114
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25109
+post_id: "1520603"
+post_author: 1
+"ListingKey": "29890553"
+"ListingId": "40838621"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T16:20:03Z"
+"RFModificationTimestamp": "2026-06-12T16:26:21Z"
+"ListPrice": 2350000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.374
+"LivingArea": 6672.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2E7"
+"UnparsedAddress": "336 BUSHWOOD Court, Waterloo, Ontario N2T2E7"
+"Coordinates": array:2 [
0 => -80.5744606
1 => 43.4627013
]
+"Latitude": 43.4627013
+"Longitude": -80.5744606
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to The Woods' of Upper Beechwood. Bushwood Court is one of the premier cul-de-sacs in the subdivision. Built by Bushview Homes, this grand Georgian style brick home with stone accents, offers 5 bedrooms, 6 bathrooms, 3 gas fireplaces, triple car garage & a fully finished walkout basement level plus walk-up stairs to the garage. Fabulous 4,780 sq feet above grade plus the finished lower level with about an additional 1,891 sq feet ensures your family will enjoy the extensive livability of this home. Wonderful opportunity for a generational family to live comfortably here with modifications. Vestibule entry leads to an impressive foyer introducing you to a centre hall plan. The main floor features 9' ceilings with layered molding, Brazilian cherry hardwood floors, 18 travertine tile, wide baseboard trim, multiple windows in each room with French doors to open or close off the rooms while entertaining. Elegant oversized dining room. Gather in the kitchen featuring granite counters, bubble tile backsplash, stainless appliances, centre island with sitting peninsula plus multiple ceiling pot lights. The bright vaulted dinette has overhead skylights with views to the deck & mature yard. Your office can be on the main floor or one of the upper bedrooms. The Primary suite fits king sized furniture with a private den/nursery/sitting area plus has 3 closets & a 5 pc Ensuite. Each upper bathroom has its own linen closet. Spacious basement level ready for recreation activities. Known for its great community spirit, families enjoy the neighbourhood for the greenspace trails that lead up to the Recreational facility which has a supervised oversized inground pool, basketball court & two tennis courts. Fun programs for the whole family to participate in throughout the Summer season. Minutes to shopping, Library, Laurelwood Conservation area plus Universities of Waterloo & Laurier. Amazing space in a wonderful location...Bushwood Court in Upper Beechwood! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Tudor"
]
+"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-11T19:13:13.411100+00:00"
+"Directions": "Columbia Street West to roundabout at Bennington Gate, turn right on Clair Creek, right on Bushwood Court"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564125"
+"ListOfficeKey": "76836"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Skylight"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.374"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T18:31:42Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T16:11:06Z"
+"Stories": "2.0"
+"StreetName": "BUSHWOOD"
+"StreetNumber": "336"
+"StreetSuffix": "Court"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "18947.94"
+"VirtualTourURLUnbranded": "https://youriguide.com/336_bushwood_court_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29890553/336-bushwood-court-waterloo"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 140.0
+"AboveGradeFinishedArea": 4781
+"BelowGradeFinishedArea": 1891
+"OriginalEntryTimestamp": "2026-06-11T18:31:42.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070169"
+"ListOfficeNationalAssociationId": "1004398"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890553')"
+"ID": "1520603"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23352
+post_id: "1520604"
+post_author: 1
+"ListingKey": "29890254"
+"ListingId": "X13432602"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T18:05:11Z"
+"RFModificationTimestamp": "2026-06-11T18:50:56Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V4"
+"UnparsedAddress": "729 BRANDENBURG BOULEVARD, Waterloo, Ontario N2T2V4"
+"Coordinates": array:2 [
0 => -80.57901
1 => 43.456959
]
+"Latitude": 43.456959
+"Longitude": -80.57901
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"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:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Water Treatment"
10 => "Window Coverings"
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-11T18:50:49.899890+00:00"
+"Directions": "Cross Streets: Erbsville Rd and Keats Way. ** Directions: Erbsville Rd to Brandenburg Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138804"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.2 x 115.6 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T17:59:58Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:59:58Z"
+"Stories": "2.0"
+"StreetName": "Brandenburg"
+"StreetNumber": "729"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4644"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/729_brandenburg_blvd_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29890254/729-brandenburg-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.2
+"OriginalEntryTimestamp": "2026-06-11T17:59:58.77Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1390596"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890254')"
+"ID": "1520604"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25117
+post_id: "1517955"
+post_author: 1
+"ListingKey": "29884895"
+"ListingId": "40838570"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T20:15:15Z"
+"RFModificationTimestamp": "2026-06-10T20:43:37Z"
+"ListPrice": 675000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1952.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2L2"
+"UnparsedAddress": "704 STAR FLOWER Avenue, Waterloo, Ontario N2V2L2"
+"Coordinates": array:2 [
0 => -80.5876117
1 => 43.4653582
]
+"Latitude": 43.4653582
+"Longitude": -80.5876117
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 2 story home with a HUGE LOFT in a desirable family neighbourhood. Brand new kitchen with quartz countertops and new stainless appliances. Lovely living room with multiple windows that provide lots of natural light--such a great family space. Sunny dinette with slider walk-out to the deck. Amazing 3rd floor loft is fabulous bonus space for multipurpose--so many options: family room, workout area, office, den, playroom, etc! Good sized primary bedroom with vaulted ceiling and walk-in closet. The 2 other bedrooms are also large with good size closets. Finished basement with a walk out to the large private fenced yard. The home just received multiple updates which include New Kitchen, Appliances, Bathrooms, Paint, Carpet-Free Flooring, Lighting and much more! Amazing location: close to top rated schools, parks, shopping, Costco, kilometres of walking trails (also great for running, biking, walking the dog, etc.) (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"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-10T20:41:07.698967+00:00"
+"Directions": "Erbsville Rd & Columbia Forest Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1768640"
+"ListOfficeKey": "76807"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T20:09:55Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T20:09:55Z"
+"Stories": "2.0"
+"StreetName": "STAR FLOWER"
+"StreetNumber": "704"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4864"
+"VirtualTourURLUnbranded": "https://youriguide.com/704_star_flower_ave_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/29884895/704-star-flower-avenue-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1952
+"OriginalEntryTimestamp": "2026-06-10T20:09:55.55Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"ListAgentNationalAssociationId": "1185878"
+"ListOfficeNationalAssociationId": "1004370"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884895')"
+"ID": "1517955"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25118
+post_id: "1515451"
+post_author: 1
+"ListingKey": "29883477"
+"ListingId": "40837309"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T02:10:12Z"
+"RFModificationTimestamp": "2026-06-11T02:15:26Z"
+"ListPrice": 750000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2358.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S6"
+"UnparsedAddress": "819 CREEKSIDE Drive, Waterloo, Ontario N2V2S6"
+"Coordinates": array:2 [
0 => -80.5920205
1 => 43.4730669
]
+"Latitude": 43.4730669
+"Longitude": -80.5920205
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare executive bungaloft townhome in one of Waterloo's most sought after neighbourhoods! Beautifully maintained, this bright and functional home is ideal for downsizers, professionals or anyone seeking the convenience of main floor living. Featuring a main floor primary bedroom, a private loft with a second bedroom and ensuite bath and a finished basement offering additional space for entertaining, hobbies, or relaxation. The gorgeous private backyard is perfect for morning coffee, summer evenings and peaceful outdoor enjoyment. Ideally located near walking trails, parks, shopping, and Laurel Creek Conservation Area, this home offers the perfect blend of comfort and convenience. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"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-10T18:57:44.529764+00:00"
+"Directions": "LAURELWOOD DRIVE TO CREEKSIDE DRIVE"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564345"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T17:51:15Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T02:01:52Z"
+"Stories": "1.5"
+"StreetName": "CREEKSIDE"
+"StreetNumber": "819"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5530.38"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Cable"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/819-Creekside-Dr"
+"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/29883477/819-creekside-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 39.0
+"AboveGradeFinishedArea": 1584
+"BelowGradeFinishedArea": 774
+"OriginalEntryTimestamp": "2026-06-10T17:51:14.76Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1135414"
+"ListOfficeNationalAssociationId": "1473831"
+"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('29883477')"
+"ID": "1515451"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 117
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]