array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29953614 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1562598"
+post_author: 1
+"ListingKey": "29953614"
+"ListingId": "X13488898"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:45:13Z"
+"RFModificationTimestamp": "2026-06-25T21:05:35Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "12 - 142 FOAMFLOWER PLACE, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.589814
1 => 43.4496898
]
+"Latitude": 43.4496898
+"Longitude": -80.589814
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this meticulously maintained, turn-key stacked townhouse in Waterloo's highly sought-after Vista Hills community! Built by Activa, this "Viola" layout has been lovingly cared for by its original and sole owner, showing true pride of ownership. Step inside to discover a bright,open-concept layout elevated by a complete premium interior renovation upon move-in. The main floor boasts 9-foot ceilings and features a stunning, fully upgraded modern kitchen with high-end countertops, custom cabinetry, and a seamless flow into the great room. The space is beautifully accented with sophisticated crown moldings and elegant, large-format wall tiles that exude a custom, luxury feel. True Carpet-Freeliving throughout with contemporary, wide-plank flooring. Enjoy private outdoor living with TWO balconies-one off the main great room and a second off the primary bedroom. The upper level offers two spacious bedrooms, a 4-piece main bathroom, upper-floor laundry, and a generous linen/storage closet. The primary suite serves as a true retreat, complete with a 3-piece ensuite and a walk-in closet. Phenomenal location, designated for top-rated schools, including Vista Hills Public School and Laurel Heights Secondary School. Unbeatable convenience with Costco, just a short drive away, alongside the nearby Boardwalk shopping district for all your retail and dining needs. Enjoy scenic walking trails, community parks, public transit, and quick access to the University of Waterloo and Wilfrid Laurier University. This pristine, upgraded home offers the perfect blend of comfort, style, and a lifestyle of ultimate convenience-ideal for professionals, growing families, or investors! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "359.56"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T21:05:30.909378+00:00"
+"Directions": "Cross Streets: Columbia St & Platinum Dr. ** Directions: COLUMBIA ST TO LADYSLIPPER DR TO FOAMFLOWER PLACE."
+"ExteriorFeatures": array:2 [
0 => "Brick Facing"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188755"
+"ListOfficeKey": "291409"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:37Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:36:37Z"
+"StreetName": "Foamflower"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3315"
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1667913126"
"RoomType" => "Kitchen"
"ListingId" => "X13488898"
"RoomLevel" => "Second level"
"RoomWidth" => 2.69
"ListingKey" => "29953614"
"RoomLength" => 5.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T18:36:37.35Z"
]
1 => array:11 [
"RoomKey" => "1667913127"
"RoomType" => "Great room"
"ListingId" => "X13488898"
"RoomLevel" => "Second level"
"RoomWidth" => 3.76
"ListingKey" => "29953614"
"RoomLength" => 5.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T18:36:37.35Z"
]
2 => array:11 [
"RoomKey" => "1667913128"
"RoomType" => "Bathroom"
"ListingId" => "X13488898"
"RoomLevel" => "Second level"
"RoomWidth" => 0.86
"ListingKey" => "29953614"
"RoomLength" => 1.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T18:36:37.36Z"
]
3 => array:11 [
"RoomKey" => "1667913129"
"RoomType" => "Foyer"
"ListingId" => "X13488898"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29953614"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T18:36:37.36Z"
]
4 => array:11 [
"RoomKey" => "1667913130"
"RoomType" => "Utility room"
"ListingId" => "X13488898"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29953614"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T18:36:37.37Z"
]
5 => array:11 [
"RoomKey" => "1667913131"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13488898"
"RoomLevel" => "Third level"
"RoomWidth" => 3.48
"ListingKey" => "29953614"
"RoomLength" => 4.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T18:36:37.37Z"
]
6 => array:11 [
"RoomKey" => "1667913132"
"RoomType" => "Bedroom 2"
"ListingId" => "X13488898"
"RoomLevel" => "Third level"
"RoomWidth" => 2.77
"ListingKey" => "29953614"
"RoomLength" => 3.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T18:36:37.38Z"
]
7 => array:11 [
"RoomKey" => "1667913133"
"RoomType" => "Bathroom"
"ListingId" => "X13488898"
"RoomLevel" => "Third level"
"RoomWidth" => 1.37
"ListingKey" => "29953614"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T18:36:37.38Z"
]
8 => array:11 [
"RoomKey" => "1667913135"
"RoomType" => "Laundry room"
"ListingId" => "X13488898"
"RoomLevel" => "Third level"
"RoomWidth" => 0.0
"ListingKey" => "29953614"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-25T18:36:37.38Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953614/12-142-foamflower-place-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1418255"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"CoListOfficeKey": "90198"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-25T18:36:37.03Z"
+"ListAgentNationalAssociationId": "1437820"
+"ListOfficeNationalAssociationId": "1397659"
+"CoListAgentNationalAssociationId": "1105101"
+"CoListOfficeNationalAssociationId": "1153615"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29953614_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/4a4f7bf08288f4bad9a6a3e8e1e06e2d.webp"
"MediaSize" => 154666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-4a4f7bf08288f4bad9a6a3e8e1e06e2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29953614_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/0f34bcf104b57e288fe8822c6d7b65d0.webp"
"MediaSize" => 146051
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-0f34bcf104b57e288fe8822c6d7b65d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29953614_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/8b6614f97f442590918cd7ddd7d176d7.webp"
"MediaSize" => 154556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-8b6614f97f442590918cd7ddd7d176d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29953614_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/b32b364d6ff479ccc8b5f2cd394fb6ad.webp"
"MediaSize" => 154414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-b32b364d6ff479ccc8b5f2cd394fb6ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29953614_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/6da770214a3aeab8862ff0a547795de6.webp"
"MediaSize" => 142162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-6da770214a3aeab8862ff0a547795de6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29953614_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/29acb96f2c6ed804d58c675a93372fbf.webp"
"MediaSize" => 131414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-29acb96f2c6ed804d58c675a93372fbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29953614_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/9b0ac6cc678c9fd408dee557c72ac6d0.webp"
"MediaSize" => 152153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-9b0ac6cc678c9fd408dee557c72ac6d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29953614_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/c8bdf10ce6bc055ddbb8c91dce2dacd0.webp"
"MediaSize" => 154122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-c8bdf10ce6bc055ddbb8c91dce2dacd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29953614_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/98c8bd782504c71b0438f5bc1ef27dfd.webp"
"MediaSize" => 144044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-98c8bd782504c71b0438f5bc1ef27dfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29953614_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/3c824c890944fca760364eb2d3a7e950.webp"
"MediaSize" => 125061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-3c824c890944fca760364eb2d3a7e950.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29953614_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/b7bd5ca143fcc25e0f0ac7e5adc2f1e3.webp"
"MediaSize" => 144844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-b7bd5ca143fcc25e0f0ac7e5adc2f1e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29953614_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/c40ca0613d98a234c5152fcb3d3b894e.webp"
"MediaSize" => 148405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-c40ca0613d98a234c5152fcb3d3b894e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29953614_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/ab518d79ca10d1739a933f2688b3e015.webp"
"MediaSize" => 126543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-ab518d79ca10d1739a933f2688b3e015.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29953614_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/cc6053a44591416bd94f9f7bcbdf442e.webp"
"MediaSize" => 134987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-cc6053a44591416bd94f9f7bcbdf442e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29953614_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/2085a3a4a0aa1f779331bb0680426601.webp"
"MediaSize" => 146702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-2085a3a4a0aa1f779331bb0680426601.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29953614_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/00864eb2938c456aef210ce3d1b9ccf4.webp"
"MediaSize" => 143497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-00864eb2938c456aef210ce3d1b9ccf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29953614_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/9c3d1bb56b846ca782744e6597803260.webp"
"MediaSize" => 148599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-9c3d1bb56b846ca782744e6597803260.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29953614_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/178cc995d2b7fd6f2b69409f89fc8747.webp"
"MediaSize" => 106222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-178cc995d2b7fd6f2b69409f89fc8747.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29953614_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/32a1308133e1a726a1f783bea038e12b.webp"
"MediaSize" => 111891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-32a1308133e1a726a1f783bea038e12b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29953614_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/51a4cd0dde6cb668acb51bcde019504f.webp"
"MediaSize" => 63551
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-51a4cd0dde6cb668acb51bcde019504f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29953614_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/b4dcf7c87bfa5f69c3992d2d867d8cc5.webp"
"MediaSize" => 98555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-b4dcf7c87bfa5f69c3992d2d867d8cc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29953614_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/64022521f0dc6b5cbe9606928a3ab477.webp"
"MediaSize" => 132202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-64022521f0dc6b5cbe9606928a3ab477.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29953614_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/5aa6f317ee5e973f7a79133d77a7bcec.webp"
"MediaSize" => 142727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-5aa6f317ee5e973f7a79133d77a7bcec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29953614_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/fbf00137608b31e51a82f4420960b902.webp"
"MediaSize" => 150735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-fbf00137608b31e51a82f4420960b902.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29953614_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/1c0101528b7bd9b3959cd8c6c4b8f52f.webp"
"MediaSize" => 143091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-1c0101528b7bd9b3959cd8c6c4b8f52f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29953614_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/c7fdd29eaddad0705f8e0618b3474602.webp"
"MediaSize" => 135027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-c7fdd29eaddad0705f8e0618b3474602.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29953614_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/423e56417d1211d4286c7e26062d303f.webp"
"MediaSize" => 145264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-423e56417d1211d4286c7e26062d303f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29953614_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/ad3704fa0ccccbc2436f6a8a4fbf4e6e.webp"
"MediaSize" => 111218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-ad3704fa0ccccbc2436f6a8a4fbf4e6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29953614_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/9b25565aeda8de4c711bf88bd9b6c5e6.webp"
"MediaSize" => 105156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-9b25565aeda8de4c711bf88bd9b6c5e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29953614_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/1fddf2a799ab9548cb92d51167ba9b8a.webp"
"MediaSize" => 90536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-1fddf2a799ab9548cb92d51167ba9b8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29953614_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/383ea7305bdb284bcb4d0a51d1874c14.webp"
"MediaSize" => 99790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-383ea7305bdb284bcb4d0a51d1874c14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29953614_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/43725dd3d17fc24af627e0ecdb7662c3.webp"
"MediaSize" => 106144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-43725dd3d17fc24af627e0ecdb7662c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29953614_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/48f35f42b10a6636b805f3ca558e6964.webp"
"MediaSize" => 100172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-48f35f42b10a6636b805f3ca558e6964.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29953614_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/7dae7f668d7b3abad03dce4ff114b4de.webp"
"MediaSize" => 149378
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-7dae7f668d7b3abad03dce4ff114b4de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29953614_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/c54ffaff4b72f9c8c0806cb37d24decd.webp"
"MediaSize" => 155739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-c54ffaff4b72f9c8c0806cb37d24decd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29953614_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/87317a93af74032edec05d2b0944f37d.webp"
"MediaSize" => 158512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-87317a93af74032edec05d2b0944f37d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29953614_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/f2e1077c18adf63080c8a04999286d71.webp"
"MediaSize" => 115468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-f2e1077c18adf63080c8a04999286d71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29953614_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/95513388cde44df6964c23f7cdf98f49.webp"
"MediaSize" => 107258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-95513388cde44df6964c23f7cdf98f49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29953614_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/15a685dd3752b3015d613d26d9e4cc1e.webp"
"MediaSize" => 132826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-15a685dd3752b3015d613d26d9e4cc1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29953614_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/0359cc4f37911482933364e22e6ed1cb.webp"
"MediaSize" => 147608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-0359cc4f37911482933364e22e6ed1cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29953614_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/fb00e38ad9a382ec5d6af9c3a781027b.webp"
"MediaSize" => 118743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-fb00e38ad9a382ec5d6af9c3a781027b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29953614_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/c9d8249f36b99243cc62fffb7c600c58.webp"
"MediaSize" => 142354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-c9d8249f36b99243cc62fffb7c600c58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29953614_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/61d93c71525215079acf306d04c6ea2a.webp"
"MediaSize" => 146900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-61d93c71525215079acf306d04c6ea2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29953614_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/15fa409a556765601905938bb5b500dd.webp"
"MediaSize" => 133753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-15fa409a556765601905938bb5b500dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29953614_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/44e1e2bf1928a81a2c927c3f0488b9c3.webp"
"MediaSize" => 130934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-44e1e2bf1928a81a2c927c3f0488b9c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29953614_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/bad4ba3f66e3b510c6bd93abc79ec2ba.webp"
"MediaSize" => 101666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-bad4ba3f66e3b510c6bd93abc79ec2ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29953614_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/8398b9eb080bbcf3a1bc2dd6df9589c0.webp"
"MediaSize" => 100905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-8398b9eb080bbcf3a1bc2dd6df9589c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29953614_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/4b6039239f4e9fcf43ff4e9d45f82d23.webp"
"MediaSize" => 111261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29953614/thumbnail-4b6039239f4e9fcf43ff4e9d45f82d23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13488898"
"ResourceRecordKey" => "29953614"
"ModificationTimestamp" => "2026-06-25T18:36:37.05Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "29953614_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29953614/dc3d344d60efbedeb27967a85c8fade3.webp"
"MediaSize" => 123860
…9
]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953614')"
+"ID": "1562598"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 291409" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24921
+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 2188755" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24890
+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 '29953614'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25291
+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 '29953614'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25363
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29953614' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.589814 43.4496898)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25325
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1571992"
+post_author: 1
+"ListingKey": "29960557"
+"ListingId": "X13495788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:55:03Z"
+"RFModificationTimestamp": "2026-06-26T23:03:08Z"
+"ListPrice": 975000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "597 SUNDEW DRIVE, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.597865
1 => 43.459722
]
+"Latitude": 43.459722
+"Longitude": -80.597865
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Vista Hills-one of Waterloo's most sought-after family communities! Set on a premium 58-foot lot with beautifully curated perennial landscaping, this stunning "White Cherry" model offers the perfect balance of upscale finishes, functional family living, and outdoor enjoyment. The fully fenced backyard feels like your own private retreat, featuring a stamped concrete patio, sleek modern pergola, and lush gardens-an ideal setting for kids to play, summer entertaining, or quiet evenings outdoors. Step inside to a bright, thoughtfully designed main floor where durable 12x24 porcelain tile and hand-scraped hardwood create a warm and timeless feel throughout. At the heart of the home is a beautifully appointed chef-inspired kitchen with granite countertops, a large island perfect for gathering, ceiling-height custom cabinetry, pantry storage, and a newer smart stove. The open-concept layout flows seamlessly into the living and dining areas, creating a welcoming space for everyday life and hosting family and friends. Upstairs, you'll find 4 spacious bedrooms along with the convenience of second-floor laundry. The primary suite offers a peaceful escape with a spa-inspired 5-piece ensuite complete with a glass shower and relaxing soaker tub. The fully finished basement adds incredible versatility with a stylish wet bar, custom entertainment feature wall, additional bedroom, and full bathroom-perfect for guests, movie nights, or multi-generational living. Additional updates include smart switches, modern lighting, owned water softener and water heater, plus a newer furnace and air conditioner (2022). With 4+1 bedrooms, 4 bathrooms, and highly rated schools including Vista Hills Public School just minutes away, this is the kind of home where families can truly settle in and grow for years to come. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Blinds"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T23:02:57.139170+00:00"
+"Directions": "Cross Streets: Columbia Street & Sundew Drive. ** Directions: Columbia Street West to Sundew Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138804"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "57.8 x 110 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:48:02Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:48:02Z"
+"Stories": "2.0"
+"StreetName": "Sundew"
+"StreetNumber": "597"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7645"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/597_sundew_dr_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29960557/597-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 57.9
+"OriginalEntryTimestamp": "2026-06-26T20:48:02.22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1390596"
+"ListOfficeNationalAssociationId": "1385020"
+"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('29960557')"
+"ID": "1571992"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1571993"
+post_author: 1
+"ListingKey": "29960298"
+"ListingId": "40843054"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T20:20:09Z"
+"RFModificationTimestamp": "2026-06-26T21:08:38Z"
+"ListPrice": 975000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3312.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B9"
+"UnparsedAddress": "597 SUNDEW Drive, Waterloo, Ontario N2V0B9"
+"Coordinates": array:2 [
0 => -80.5978545
1 => 43.4597552
]
+"Latitude": 43.4597552
+"Longitude": -80.5978545
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Vista Hills—one of Waterloo’s most sought-after family communities! Set on a premium 58-foot lot with beautifully curated perennial landscaping, this stunning “White Cherry” model offers the perfect balance of upscale finishes, functional family living, and outdoor enjoyment. The fully fenced backyard feels like your own private retreat, featuring a stamped concrete patio, sleek modern pergola, and lush gardens—an ideal setting for kids to play, summer entertaining, or quiet evenings outdoors. Step inside to a bright, thoughtfully designed main floor where durable 12x24 porcelain tile and hand-scraped hardwood create a warm and timeless feel throughout. At the heart of the home is a beautifully appointed chef-inspired kitchen with granite countertops, a large island perfect for gathering, ceiling-height custom cabinetry, pantry storage, and a newer smart stove. The open-concept layout flows seamlessly into the living and dining areas, creating a welcoming space for everyday life and hosting family and friends. Upstairs, you’ll find 4 spacious bedrooms along with the convenience of second-floor laundry. The primary suite offers a peaceful escape with a spa-inspired 5-piece ensuite complete with a glass shower and relaxing soaker tub. The fully finished basement adds incredible versatility with a stylish wet bar, custom entertainment feature wall, additional bedroom, and full bathroom—perfect for guests, movie nights, or multi-generational living. Additional updates include smart switches, modern lighting, owned water softener and water heater, plus a newer furnace and air conditioner (2022). With 4+1 bedrooms, 4 bathrooms, and highly rated schools including Vista Hills Public School just minutes away, this is the kind of home where families can truly settle in and grow for years to come. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Wet Bar"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"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-26T21:08:29.368025+00:00"
+"Directions": "Columbia Street West to Sundew Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1944030"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wet bar"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T20:11:08Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T20:11:08Z"
+"Stories": "2.0"
+"StreetName": "SUNDEW"
+"StreetNumber": "597"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7645"
+"VirtualTourURLUnbranded": "https://youriguide.com/597_sundew_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29960298/597-sundew-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 58.0
+"AboveGradeFinishedArea": 2345
+"BelowGradeFinishedArea": 967
+"OriginalEntryTimestamp": "2026-06-26T20:11:08.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1239929"
+"ListOfficeNationalAssociationId": "1384313"
+"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('29960298')"
+"ID": "1571993"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1568039"
+post_author: 1
+"ListingKey": "29956203"
+"ListingId": "40843022"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T01:45:02Z"
+"RFModificationTimestamp": "2026-06-26T04:50:46Z"
+"ListPrice": 1130000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2774.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "745 WOOD LILY Street, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.5998881
1 => 43.4612882
]
+"Latitude": 43.4612882
+"Longitude": -80.5998881
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Here is the 40ft Model, not 36ft. Nestled in the highly sought-after Vista Hills community, this stunning executive home offers modern living in one of Waterloo’s most desirable neighbourhoods. Conveniently located near Costco, The Boardwalk, Boardwalk Medical Centre, shopping plazas, restaurants, and everyday amenities, this home is also within the top-ranked school boundaries of Vista Hills Public School and Laurel Heights Secondary School. Offering nearly 2,800 sq. ft. of thoughtfully designed living space, this home features a double-car garage and a bright openconcept layout. The modern kitchen flows seamlessly into the spacious living room with hardwood floors and a cozy fireplace, creating the perfect space for entertaining and family living. Sliding doors from the breakfast area lead to a private backyard retreat, while the separate dining room can also serve as a home office. Upstairs, each bedroom features its own private ensuite bathroom, providing comfort and privacy for the whole family. A versatile loft area offers additional space for a family lounge, study, or reading nook. Surrounded by scenic greenbelt and nature trails, this exceptional property perfectly blends luxury, convenience, and tranquility. A rare opportunity to own in one of Vista Hills’ most prestigious enclaves. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T04:49:23.213409+00:00"
+"Directions": "Rock Elm St. /Wood Lily"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T01:39:29Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T01:39:29Z"
+"Stories": "2.0"
+"StreetName": "WOOD LILY"
+"StreetNumber": "745"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "8766.67"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=kx_UbYopPFU"
+"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/29956203/745-wood-lily-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 2774
+"OriginalEntryTimestamp": "2026-06-26T01:39:29.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956203')"
+"ID": "1568039"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1564289"
+post_author: 1
+"ListingKey": "29949076"
+"ListingId": "40841876"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T21:20:13Z"
+"RFModificationTimestamp": "2026-06-25T23:48:22Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.12
+"LivingArea": 1983.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG Drive, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.5864421
1 => 43.462059
]
+"Latitude": 43.462059
+"Longitude": -80.5864421
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "PRICELESS VIEW! The Holy Grail of Retirement Bungalows. Modern-build, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo’s coveted Clair Hills community! This rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. It is freshly painted and updated with new carpet, and is completely move-in ready. With 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The sun-filled open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings where you’ll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and features a walk-in closet and private 4-piece ensuite. The second bedroom delights with a built-in Murphy bed that easily converts the space from home office to ready-made guest room. The bright walkout basement includes oversized windows, a cozy gas fireplace, and direct yard access with a covered deck that's perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privilege, along with a spacious utility/storage room complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered light switches, and modern mechanical systems. Add the double garage, quiet low-traffic location, and a peaceful pond-side setting, and you have effortless living at its finest! Homes offering this combination of location, quality, and accessibility are seldom available, and perfect for those looking to downsize. Don’t miss your opportunity to call Rosewood Estates home! Book your private showing today!! (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:48:02.127003+00:00"
+"Directions": "Columbia to Salzburg Drive"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:11:25Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T21:11:25Z"
+"Stories": "1.0"
+"StreetName": "SALZBURG"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5446"
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …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/29949076/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1223
+"BelowGradeFinishedArea": 760
+"OriginalEntryTimestamp": "2026-06-24T21:11:25.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1125580"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:42 [
0 => array:13 [ …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('29949076')"
+"ID": "1564289"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1563698"
+post_author: 1
+"ListingKey": "29949612"
+"ListingId": "X13486026"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T22:55:14Z"
+"RFModificationTimestamp": "2026-06-25T23:10:34Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2N8"
+"UnparsedAddress": "670 SALZBURG DRIVE, Waterloo, Ontario N2V2N8"
+"Coordinates": array:2 [
0 => -80.586439
1 => 43.462061
]
+"Latitude": 43.462061
+"Longitude": -80.586439
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "PRICELESS VIEW! The Holy Grail of Retirement Bungalows! Modern-build, freehold (no condo fees!), and backing onto the serene Rosewood Pond in Waterloo's coveted Clair Hills community! This rare walkout bungalow blends elegance, comfort, and true accessibility in one perfect package. It is freshly painted and updated with new carpet, and is completely move-in ready. With 2+1 bedrooms, 3 bathrooms, and nearly 2,000 sq. ft. of beautifully finished living space, this home offers both style and ease. The sun-filled open-concept main floor showcases rich maple hardwood and ceramic tile, flowing naturally to a raised deck with glass railings where you'll enjoy the definition of a million-dollar view. The spacious primary suite overlooks the water and features a walk-in closet and private 4-piece ensuite. The second bedroom delights with a built-in Murphy bed that easily converts the space from home office to ready-made guest room. The bright walkout basement includes oversized windows, a cozy gas fireplace, and direct yard access with a covered deck that's perfect for entertaining or quiet mornings by the water. A third bedroom with ensuite privilege, along with a spacious utility/storage room complete the lower level. Built with accessibility in mind, this home includes widened doorways, lowered light switches, and modern mechanical systems. Add the double garage, quiet low-traffic location, and a peaceful pond-side setting, and you have effortless living at its finest! Homes offering this combination of location, quality, and accessibility are seldom available, and perfect for those looking to downsize. Don't miss your opportunity to call Rosewood Estates home! (id:62783)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:09:20.683398+00:00"
+"Directions": "Cross Streets: Columbia St W. ** Directions: Columbia to Salzburg Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Backs on greenbelt"
]
+"LotSizeDimensions": "45 x 118.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T22:17:44Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T22:48:20Z"
+"Stories": "1.0"
+"StreetName": "Salzburg"
+"StreetNumber": "670"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5446"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/670_salzburg_drive_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29949612/670-salzburg-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-24T22:17:44.25Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370979"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29949612')"
+"ID": "1563698"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25315
+post_id: "1561837"
+post_author: 1
+"ListingKey": "29951785"
+"ListingId": "40842536"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T16:00:15Z"
+"RFModificationTimestamp": "2026-06-25T20:03:47Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1279.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0G9"
+"UnparsedAddress": "142 FOAMFLOWER Place Unit# 12, Waterloo, Ontario N2V0G9"
+"Coordinates": array:2 [
0 => -80.5890984
1 => 43.4499345
]
+"Latitude": 43.4499345
+"Longitude": -80.5890984
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this meticulously maintained, turn-key stacked townhouse in Waterloo’s highly sought-after Vista Hills community! Built by Activa, this Viola layout has been lovingly cared for by its original and sole owner, showing true pride of ownership. Step inside to discover a bright, open-concept layout elevated by a complete premium interior renovation upon move-in. The main floor boasts 9-foot ceilings and features a stunning, fully upgraded modern kitchen with high-end countertops, custom cabinetry, and a seamless flow into the great room. The space is beautifully accented with sophisticated crown moldings and elegant large-format wall tiles that exude a custom, luxury feel. True Carpet-Free living throughout with contemporary, wide-plank flooring. Enjoy private outdoor living with TWO balconies—one off the main great room and a second off the primary bedroom. The upper level offers two spacious bedrooms, a 4-piece main bathroom, upper-floor laundry, and a generous linen/storage closet. The primary suite serves as a true retreat, complete with a 3-piece ensuite and a walk-in closet. Phenomenal location designated for top-rated schools, including Vista Hills Public School and Laurel Heights Secondary School. Unbeatable convenience with Costco just a short drive away, alongside the nearby Boardwalk shopping district for all your retail and dining needs. Enjoy scenic walking trails, community parks, public transit, and quick access to the University of Waterloo and Wilfrid Laurier University. This pristine, upgraded home offers the perfect blend of comfort, style, and a lifestyle of ultimate convenience—ideal for professionals, growing families, or investors! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"AssociationFee": "359.56"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Property Management"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:03:37.713365+00:00"
+"Directions": "COLUMBIA ST TO LADYSLIPPER DR TO FOAMFLOWER PLACE"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180828"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-25T15:50:49Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T15:50:49Z"
+"Stories": "2.0"
+"StreetName": "FOAMFLOWER"
+"StreetNumber": "142"
+"StreetSuffix": "Place"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3315"
+"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/29951785/142-foamflower-place-unit-12-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R9 R6-FT"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1279
+"OriginalEntryTimestamp": "2026-06-25T15:50:49.21Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430684"
+"ListOfficeNationalAssociationId": "1394395"
+"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('29951785')"
+"ID": "1561837"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1560177"
+post_author: 1
+"ListingKey": "29944974"
+"ListingId": "X13481758"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T00:20:15Z"
+"RFModificationTimestamp": "2026-06-24T00:39:42Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "736 WOOD LILY STREET, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.599137
1 => 43.461038
]
+"Latitude": 43.461038
+"Longitude": -80.599137
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 736 Wood Lily Street, a contemporary masterpiece in the prestigious Vista Hillscommunity, offering over 3,400 sq. ft. of finished living space (2,469 sq. ft. above grade).This executive residence impresses with its modern architectural design and a spacious layoutperfect for both family living and high-end entertaining.The main level invites you into a bright, open-concept floor plan defined by 9ft ceilings, wideoak stairs, and over $85k in premium upgrades. The gourmet kitchen is a chef's dream, featuringcustom white cabinetry, a high-end upgraded range hood, and sleek built-in oven and microwave.Transition effortlessly to your private backyard oasis, complete with a recently finishedinterlocking stone patio, an outdoor storage shed, and full fencing.The second floor is intelligently designed for family comfort, boasting a sprawling family roomand a dedicated office space. The primary suite serves as a true sanctuary with a privatecovered balcony, a large walk-in closet, and a spa-like 5-piece ensuite. This level alsofeatures two additional generously sized bedrooms and a modern 4-piece main bath. The fullyfinished basement is an entertainer's paradise, featuring a massive open recreation area with acustom accent wall designed for a home theater. The space is anchored by a luxury wet bar withquartz countertops and designer cabinetry, and is perfectly complemented by a sophisticated3-piece luxury bathroom. With multiple storage rooms, parking for four and a prime location,this home is a must-see!The Vista Hills Lifestyle: This vibrant community is surrounded by environmentally protectedlands and over 25km of scenic trails, including the nearby Geo-Time Trail. Families will lovebeing steps away from the top-rated Vista Hills Public School and various local playgrounds.For ultimate convenience, you are just a 5-minute drive from Costco and The Boardwalk at IraNeedles, which offers premier shopping, dining, and Landmark Cinemas. (id:62783)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener remote(s)"
13 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:3 [
0 => "Central air conditioning"
1 => "Air exchanger"
2 => "Ventilation system"
]
+"CreationDate": "2026-06-24T00:39:39.336420+00:00"
+"Directions": "Cross Streets: Sundew Dr and Mayapple St. ** Directions: Take Columbia St W, turn onto Sundew Dr, turnonto Mayapple St, turn onto Wood Lily St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Carpeted"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2076953"
+"ListOfficeKey": "275137"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved yard"
2 => "Sump Pump"
]
+"LotSizeDimensions": "36.1 x 99.3 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-24T00:13:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T00:13:23Z"
+"Stories": "2.0"
+"StreetName": "Wood Lily"
+"StreetNumber": "736"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7305.56"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/736_wood_lily_st_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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29944974/736-wood-lily-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 36.1
+"OriginalEntryTimestamp": "2026-06-24T00:13:23.67Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1352099"
+"ListOfficeNationalAssociationId": "1262136"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29944974')"
+"ID": "1560177"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1560178"
+post_author: 1
+"ListingKey": "29944899"
+"ListingId": "40842511"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T00:00:09Z"
+"RFModificationTimestamp": "2026-06-24T00:25:06Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3426.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0C3"
+"UnparsedAddress": "736 WOOD LILY Street, Waterloo, Ontario N2V0C3"
+"Coordinates": array:2 [
0 => -80.5995752
1 => 43.4611724
]
+"Latitude": 43.4611724
+"Longitude": -80.5995752
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 736 Wood Lily Street, a contemporary masterpiece in the prestigious Vista Hills community, offering over 3,400 sq. ft. of finished living space (2,469 sq. ft. above grade). This executive residence impresses with its modern architectural design and a spacious layout perfect for both family living and high-end entertaining.The main level invites you into a bright, open-concept floor plan defined by 9ft ceilings, wid oak stairs, and over $85k in premium upgrades. The gourmet kitchen is a chef’s dream, featuring custom white cabinetry, a high-end upgraded range hood, and sleek built-in oven and microwave. Transition effortlessly to your private backyard oasis, complete with a recently finished interlocking stone patio, an outdoor storage shed, and full fencing. The second floor is intelligently designed for family comfort, boasting a sprawling family room and a dedicated office space. The primary suite serves as a true sanctuary with a private covered balcony, a large walk-in closet, and a spa-like 5-piece ensuite. This level also features two additional generously sized bedrooms and a modern 4-piece main bath. The fully finished basement is an entertainer’s paradise, featuring a massive open recreation area with a custom accent wall designed for a home theater. The space is anchored by a luxury wet bar with quartz countertops and designer cabinetry, and is perfectly complemented by a sophisticated 3-piece luxury bathroom. With multiple storage rooms, parking for four and a prime location, this home is a must-see! The Vista Hills Lifestyle: This vibrant community is surrounded by environmentally protected lands and over 25km of scenic trails, including the nearby Geo-Time Trail. Families will love being steps away from the top-rated Vista Hills Public School and various local playgrounds. For ultimate convenience, you are just a 5-minute drive from Costco and The Boardwalk at Ira Needles, which offers shopping, dining, and Landmark Cinemas. (id:62783)"
+"Appliances": array:14 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Oven - Built-In"
9 => "Wet Bar"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
13 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-24T00:25:02.267747+00:00"
+"Directions": "Take Columbia St W, turn onto Sundew Dr, turn onto Mayapple St, turn onto Wood Lily St"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2217869"
+"ListOfficeKey": "284587"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Wet bar"
2 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-23T23:50:33Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T23:50:33Z"
+"Stories": "2.0"
+"StreetName": "WOOD LILY"
+"StreetNumber": "736"
+"StreetSuffix": "Street"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "7305.56"
+"VirtualTourURLUnbranded": "https://youriguide.com/736_wood_lily_st_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/29944899/736-wood-lily-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "NR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2469
+"BelowGradeFinishedArea": 957
+"OriginalEntryTimestamp": "2026-06-23T23:50:33.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1463522"
+"ListOfficeNationalAssociationId": "1343174"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29944899')"
+"ID": "1560178"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: "1557597"
+post_author: 1
+"ListingKey": "29942116"
+"ListingId": "40841799"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T23:30:11Z"
+"RFModificationTimestamp": "2026-06-26T01:38:34Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2882.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N5"
+"UnparsedAddress": "561 CHANCERY Lane, Waterloo, Ontario N2T2N5"
+"Coordinates": array:2 [
0 => -80.5790524
1 => 43.4650089
]
+"Latitude": 43.4650089
+"Longitude": -80.5790524
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 561 Chancery Lane, Waterloo – a beautifully open and spacious backsplit nestled in one of Waterloo’s most desirable neighbourhoods. Offering 3 bedrooms, 3 full bathrooms, and exceptional indoor and outdoor living spaces, this home is designed for both everyday comfort and entertaining. The bright and inviting main level features soaring cathedral ceilings, hardwood flooring, and an open-concept living and dining area filled with natural light. The gourmet kitchen is sure to impress with stainless appliances, double wall ovens, a gas cooktop, built-in Miele coffee maker, and a spacious island perfect for gathering with family and friends. The lower level is an entertainer’s dream, showcasing a stylish bar area, custom built-ins, heated slate flooring, and a convenient walk-up to the backyard. A 3-piece bathroom on this level adds functionality and convenience for guests. Upstairs, you'll find three generously sized bedrooms and an updated 4-piece bathroom. The primary bedroom offers the added luxury of a private 3-piece ensuite. The basement provides excellent flexibility and can be used as a home gym, office, additional bedroom, or hobby space. A dedicated laundry room completes this level. Step outside to your own backyard retreat featuring a heated inground pool surrounded by stamped concrete. The cabana is fully equipped with hydro, speakers, a ceiling fan, and a fireplace, creating the perfect setting for summer entertaining. A separate pool house provides ample storage for all your pool equipment and accessories. Completing this home is a double attached garage and a fantastic location close to parks, schools, shopping, and all the amenities Waterloo has to offer. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T18:46:47.816559+00:00"
+"Directions": "Columbia/Chancery Lane"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T18:13:56Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T23:20:24Z"
+"Stories": "3.0"
+"StreetName": "CHANCERY"
+"StreetNumber": "561"
+"StreetSuffix": "Lane"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7433.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/561_chancery_lane_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29942116/561-chancery-lane-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2130
+"BelowGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-06-23T16:51:24.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29942116')"
+"ID": "1557597"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 77
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]