array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29945897 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: "1561838"
+post_author: 1
+"ListingKey": "29945897"
+"ListingId": "40842553"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T17:40:47Z"
+"RFModificationTimestamp": "2026-06-25T19:10:27Z"
+"ListPrice": 880000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.11
+"LivingArea": 2692.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V6"
+"UnparsedAddress": "439 WOODROW Drive, Waterloo, Ontario N2T2V6"
+"Coordinates": array:2 [
0 => -80.5847961
1 => 43.4697644
]
+"Latitude": 43.4697644
+"Longitude": -80.5847961
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully renovated backsplit nestled in the highly sought after Laurelwood neighbourhood! Updated from top to bottom, this exceptional home offers the perfect blend of style, comfort, and functionality. The stunning 2016 kitchen is the heart of the home, featuring a large centre island ideal for family gatherings and entertaining, while flowing seamlessly into the spacious dining area and bright living room. Just steps away, the inviting lower level family room showcases a beautifully updated gas fireplace with custom mantel (2021) and patio doors leading to your own private backyard retreat. Beautifully landscaped with mature perennial gardens, a charming gazebo, and an outdoor BBQ and prep station that stays with the home, this backyard is designed for relaxing and entertaining alike. The lower level also features a versatile fourth bedroom, an updated 3 piece bathroom (2018), convenient laundry area, and direct access to the side entrance. The fully finished basement provides an expansive recreation room, utility room, and an abundance of storage. Upstairs, you'll find three generous bedrooms, including the primary retreat, along with a beautifully renovated 4 piece bathroom (2020) complete with a luxurious soaker tub. Double car garage equipped with Ev charger rough in, plus parking for 4 in your concrete driveway. Situated in one of Waterloo's most desirable family friendly neighbourhoods, this move in ready home is close to top rated schools, parks, walking trails, shopping, universities, and every amenity. Simply unpack and enjoy everything this exceptional Laurelwood home has to offer! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T19:10:22.497664+00:00"
+"Directions": "Laurelwood to Old Oak Dr., to Woodrow."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958320"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Gazebo"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"LotSizeDimensions": "0.11"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T13:30:38Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T17:11:56Z"
+"Stories": "3.0"
+"StreetName": "WOODROW"
+"StreetNumber": "439"
+"StreetSuffix": "Drive"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5946"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/439_woodrow_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1667835863"
"RoomType" => "Storage"
"ListingId" => "40842553"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.25Z"
]
1 => array:11 [
"RoomKey" => "1667835864"
"RoomType" => "Utility room"
"ListingId" => "40842553"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.26Z"
]
2 => array:11 [
"RoomKey" => "1667835865"
"RoomType" => "Storage"
"ListingId" => "40842553"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "3'3'' x 4'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.26Z"
]
3 => array:11 [
"RoomKey" => "1667835866"
"RoomType" => "Recreation room"
"ListingId" => "40842553"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.26Z"
]
4 => array:11 [
"RoomKey" => "1667835867"
"RoomType" => "Laundry room"
"ListingId" => "40842553"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "7'7'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.26Z"
]
5 => array:11 [
"RoomKey" => "1667835868"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842553"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.26Z"
]
6 => array:11 [
"RoomKey" => "1667835869"
"RoomType" => "Bedroom"
"ListingId" => "40842553"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.26Z"
]
7 => array:11 [
"RoomKey" => "1667835870"
"RoomType" => "Family room"
"ListingId" => "40842553"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "20'5'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.26Z"
]
8 => array:11 [
"RoomKey" => "1667835871"
"RoomType" => "Bedroom"
"ListingId" => "40842553"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.27Z"
]
9 => array:11 [
"RoomKey" => "1667835872"
"RoomType" => "Bedroom"
"ListingId" => "40842553"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.27Z"
]
10 => array:11 [
"RoomKey" => "1667835873"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842553"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.27Z"
]
11 => array:11 [
"RoomKey" => "1667835874"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842553"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.28Z"
]
12 => array:11 [
"RoomKey" => "1667835875"
"RoomType" => "Eat in kitchen"
"ListingId" => "40842553"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "15'8'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.28Z"
]
13 => array:11 [
"RoomKey" => "1667835876"
"RoomType" => "Dining room"
"ListingId" => "40842553"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 13'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.28Z"
]
14 => array:11 [
"RoomKey" => "1667835877"
"RoomType" => "Living room"
"ListingId" => "40842553"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29945897"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T17:11:56.28Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945897/439-woodrow-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1564580"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2037
+"BelowGradeFinishedArea": 655
+"OriginalEntryTimestamp": "2026-06-24T13:30:38.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1249173"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1069941"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29945897_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/314382b26ef8c1c0f0ea6f502288a758.webp"
"MediaSize" => 134626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-314382b26ef8c1c0f0ea6f502288a758.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29945897_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/a4f3807173d45678f9f8d4e68e0a0bfa.webp"
"MediaSize" => 170390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-a4f3807173d45678f9f8d4e68e0a0bfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29945897_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/2dbceeeb10db2e8244d249572b67e7e9.webp"
"MediaSize" => 119505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-2dbceeeb10db2e8244d249572b67e7e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29945897_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/b4a68eba64bc7f6c578a8f481b18550f.webp"
"MediaSize" => 139605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-b4a68eba64bc7f6c578a8f481b18550f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29945897_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/3ac5aac520047bd5bd062a051ef5f2b6.webp"
"MediaSize" => 120008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-3ac5aac520047bd5bd062a051ef5f2b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29945897_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/b960f8ed9a76f67b63d693682503844e.webp"
"MediaSize" => 54751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-b960f8ed9a76f67b63d693682503844e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29945897_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/28e21d29062db0394d33a4982193d45a.webp"
"MediaSize" => 65302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-28e21d29062db0394d33a4982193d45a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29945897_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/186e166c83c1159bd27547885ec439e7.webp"
"MediaSize" => 57056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-186e166c83c1159bd27547885ec439e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29945897_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/c753662c4abac97d4deaf8889e25746c.webp"
"MediaSize" => 64282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-c753662c4abac97d4deaf8889e25746c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29945897_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/26c0b59534eea1fd820a361bde517e00.webp"
"MediaSize" => 63062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-26c0b59534eea1fd820a361bde517e00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29945897_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/ec3616bfba924bc86c6c7b031fca72d0.webp"
"MediaSize" => 67764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-ec3616bfba924bc86c6c7b031fca72d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29945897_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/36fca0906bf89e79c76b29d4ea1eda55.webp"
"MediaSize" => 69579
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-36fca0906bf89e79c76b29d4ea1eda55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29945897_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/e8cbf86558ab44bd8b2cbaefaa6a9584.webp"
"MediaSize" => 73426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-e8cbf86558ab44bd8b2cbaefaa6a9584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29945897_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/d9cd9dc043061432121529c16ee28a5d.webp"
"MediaSize" => 71664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-d9cd9dc043061432121529c16ee28a5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29945897_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/9525179ea04bb0cead8558d9397e2371.webp"
"MediaSize" => 81780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-9525179ea04bb0cead8558d9397e2371.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29945897_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/6a4efd004eea6b62e94a3fb378912286.webp"
"MediaSize" => 75756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-6a4efd004eea6b62e94a3fb378912286.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29945897_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/b264d5ff6ea12da8fde0b898f17f63a0.webp"
"MediaSize" => 71596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-b264d5ff6ea12da8fde0b898f17f63a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29945897_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/3d4f3d1c9d4c0364771fb55bca3a56ab.webp"
"MediaSize" => 74652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-3d4f3d1c9d4c0364771fb55bca3a56ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29945897_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/83ad475503e4945edb921f6c6b4ad734.webp"
"MediaSize" => 60532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-83ad475503e4945edb921f6c6b4ad734.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29945897_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/c9eb77964d19963ff5454ff4d71b7499.webp"
"MediaSize" => 61205
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-c9eb77964d19963ff5454ff4d71b7499.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29945897_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/6e4f16d2d6c0c65e5c55108087dfea7f.webp"
"MediaSize" => 62574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-6e4f16d2d6c0c65e5c55108087dfea7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29945897_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/882b0cb631ca9f567d67f8cd5422b0a1.webp"
"MediaSize" => 47798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-882b0cb631ca9f567d67f8cd5422b0a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29945897_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/77fd2f8193696ee60826a8297639bf0b.webp"
"MediaSize" => 55498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-77fd2f8193696ee60826a8297639bf0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29945897_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/283dffbc169905a53030d92a1ee13b1c.webp"
"MediaSize" => 49812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-283dffbc169905a53030d92a1ee13b1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29945897_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/999a320e3b9f1284968e71d03ea5dbcb.webp"
"MediaSize" => 76456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-999a320e3b9f1284968e71d03ea5dbcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29945897_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/ec9b0bfe2852cac5fcdc4d11a1bc83fd.webp"
"MediaSize" => 75888
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-ec9b0bfe2852cac5fcdc4d11a1bc83fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29945897_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/81439b324dcd2ca7f72a7cef29cce69c.webp"
"MediaSize" => 66408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-81439b324dcd2ca7f72a7cef29cce69c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29945897_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/5013b885be066673fa535d8aa0746009.webp"
"MediaSize" => 48380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-5013b885be066673fa535d8aa0746009.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29945897_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/d900603644f8b9197d3eb37299f4584c.webp"
"MediaSize" => 47707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-d900603644f8b9197d3eb37299f4584c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29945897_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/98fe1d0cfe054b8dc67c78f31b1710ce.webp"
"MediaSize" => 85769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-98fe1d0cfe054b8dc67c78f31b1710ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29945897_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/824eb20e7b47845c530b4811124a6316.webp"
"MediaSize" => 67284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-824eb20e7b47845c530b4811124a6316.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29945897_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/c517335351681febc46113d41bfc7bba.webp"
"MediaSize" => 78259
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-c517335351681febc46113d41bfc7bba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29945897_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/d985073bf21c87d90ad0aa7a7f0c1c30.webp"
"MediaSize" => 81625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-d985073bf21c87d90ad0aa7a7f0c1c30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29945897_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/5793c736a3675e46d345df0a73b4ae32.webp"
"MediaSize" => 156844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-5793c736a3675e46d345df0a73b4ae32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29945897_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/dda02f4e758251f32ec71c0710e5da61.webp"
"MediaSize" => 145663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-dda02f4e758251f32ec71c0710e5da61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29945897_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/ef03d3a65d5a0d441d13781ca1cd49bd.webp"
"MediaSize" => 149704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-ef03d3a65d5a0d441d13781ca1cd49bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29945897_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/fef4f99f272a1bb0d06beceaa696f917.webp"
"MediaSize" => 149738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-fef4f99f272a1bb0d06beceaa696f917.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29945897_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/68aa58dc11c061e651b317737d974be6.webp"
"MediaSize" => 162265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-68aa58dc11c061e651b317737d974be6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29945897_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/906f7583d60994fa15f8e416674317ca.webp"
"MediaSize" => 166628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-906f7583d60994fa15f8e416674317ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29945897_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/4fa7513d3c69d77bc712f6409c4bff04.webp"
"MediaSize" => 162385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-4fa7513d3c69d77bc712f6409c4bff04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29945897_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/faed1e3f45d699e2413dd0692ff2e286.webp"
"MediaSize" => 176480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-faed1e3f45d699e2413dd0692ff2e286.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29945897_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/1a4d45220fb1671270c59dc141e4282b.webp"
"MediaSize" => 43069
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-1a4d45220fb1671270c59dc141e4282b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842553"
"ResourceRecordKey" => "29945897"
"ModificationTimestamp" => "2026-06-24T13:30:38.72Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29945897_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29945897/d869940d1ddf3b64d68800be8a9acb24.webp"
"MediaSize" => 44915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29945897/thumbnail-d869940d1ddf3b64d68800be8a9acb24.webp"
"ResourceName" => "Property"
…6
]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945897')"
+"ID": "1561838"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290620" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24913
+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 1958320" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24882
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29945897'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25278
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29945897'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25296
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31648388"
+"ListingKey": "29945897"
+"ListingId": "40842553"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-28"
+"OpenHouseStartTime": "2026-06-28T14:00:00Z"
+"OpenHouseEndTime": "2026-06-28T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-27T07:11:00Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31648388')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29945897' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5847961 43.4697644)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25369
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+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 {#25365
+post_id: "1571642"
+post_author: 1
+"ListingKey": "29961010"
+"ListingId": "X13496142"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T21:55:08Z"
+"RFModificationTimestamp": "2026-06-26T22:37:39Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0A3"
+"UnparsedAddress": "A3 - 795 LAURELWOOD DRIVE, Waterloo, Ontario N2V0A3"
+"Coordinates": array:2 [
0 => -80.600804
1 => 43.471001
]
+"Latitude": 43.471001
+"Longitude": -80.600804
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful family home offers spacious layout throughout with a extra large living area. Situated in a quiet cul-de-sac with privacy surrounded by mature trees and landscaping. Beautiful curve appeal complex. This unit really good size 3 bedrooms upstairs with a cozy study or a tv room. This home has extra large garage compared to other units in the complex with tall ceiling to create more storage. The laundry room spacious behind the kitchen and there is a spacious separate pantry. The kitchen has stainless steel appliances, a quartz counter top is a deep and large single sink. The island has a breakfast bar with a separate dining area. Large sliding glass doors lead to the deck, cozy for reading or entertaining during summer evenings. The basement is fully finished and very spacious that can be used as a suite or a large rec room.with a full bathroom and large open areas which can be separated into bedrooms. One of the most desired school zones, walking distance to highly rated Abraham Erb public school and Laurel Heights Secondary school, Food basics and Shoppers drug mart. Within 7 min drive to University of Waterloo, Costco, YMCA, and The Boardwalk. Many all season walking trails around the neighbourhood.. The complex is a close community with small number of units. Very safe and welcoming... Equally good for anyone downsizing or starting a new family. This unit is larger than some detached homes in the neighbourhood at 1925 sqft. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Blinds"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "314"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:37:28.493792+00:00"
+"Directions": "Cross Streets: Laurelwood Drive. ** Directions: Erbsville Road to Laurelwood Drive."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1412135"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:49:26Z"
+"PhotosCount": 25
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T21:49:26Z"
+"Stories": "2.0"
+"StreetName": "Laurelwood"
+"StreetNumber": "795"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4642.04"
+"VirtualTourURLUnbranded": "https://unbranded.iguideradix.com/3_795_laurelwood_dr_waterloo_on/"
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29961010/a3-795-laurelwood-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self Managed"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-26T21:49:26.34Z"
+"ListAgentNationalAssociationId": "1105043"
+"ListOfficeNationalAssociationId": "1310773"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961010')"
+"ID": "1571642"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
+post_id: "1565003"
+post_author: 1
+"ListingKey": "29948730"
+"ListingId": "40842788"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T20:00:23Z"
+"RFModificationTimestamp": "2026-06-26T00:28:21Z"
+"ListPrice": 1139000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3143.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2P1"
+"UnparsedAddress": "723 BROOKMILL Place, Waterloo, Ontario N2V2P1"
+"Coordinates": array:2 [
0 => -80.5842507
1 => 43.4746813
]
+"Latitude": 43.4746813
+"Longitude": -80.5842507
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 723 Brookmill Place in the desirable neighbourhood of Laurelwood in Waterloo. Just steps from the Laurel Creek Conservation area, this expansive 4 bedroom 4 bathroom family home offers over 3,000 square feet of updated living space you can move right into and immediately enjoy. Step inside through the double door entry way and appreciate the bright, open concept layout with hardwood & porcelain floors, 9 ft ceiling heights and updated finishes throughout. The chef’s kitchen has been carefully designed to cater to a passion for cooking and hosting, featuring a 10 ft quartz island, gas stove, wine bar with wine fridge, and two stainless steel dishwashers. Host a dinner party in the formal dining area with friends and family, or curl up by the gas fireplace in the family room on a cold night. Upstairs, the spacious primary suite serves as a luxurious retreat, complete with a beautifully appointed double sink ensuite bathroom with a glass shower and a functional walk-in closet. Three more generously sized bedrooms with hardwood floors and a 4 pc bathroom complete the upper level. The basement features a bright, expansive layout with brand new custom-ordered carpet, a 4th bathroom, and plenty of storage space. Outside, your backyard oasis awaits! Landscaped with both privacy and functionality in mind, this peaceful outdoor space with new sodding, solar lighting and a 12 ft gazebo makes you feel like you’ve escaped the busy city. Steps away from conservation trails, public and Catholic schools, the YMCA, shopping, dining, universities, golf courses and so much more. New furnace with air hydration system, new kitchen appliances, new hot Water heater tank. With an array of luxurious features and thoughtful touches inside & out, this distinguished residence offers a lifestyle of unparalleled comfort and convenience thats perfect for your family’s next chapter. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:27:20.571658+00:00"
+"Directions": "Laurelwood Dr/ Brookmill Ct"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2088817"
+"ListOfficeKey": "76789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T19:51:09Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T19:51:09Z"
+"Stories": "2.0"
+"StreetName": "BROOKMILL"
+"StreetNumber": "723"
+"StreetSuffix": "Place"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6960.78"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"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/29948730/723-brookmill-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R 5"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2459
+"BelowGradeFinishedArea": 684
+"OriginalEntryTimestamp": "2026-06-24T19:51:09.22Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1362124"
+"ListOfficeNationalAssociationId": "1004357"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948730')"
+"ID": "1565003"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+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"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+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"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+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"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 104
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]