array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30031489 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23472
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23474
+post_id: "1623714"
+post_author: 1
+"ListingKey": "30031489"
+"ListingId": "X13562104"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T17:45:04Z"
+"RFModificationTimestamp": "2026-07-14T19:11:41Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1R6"
+"UnparsedAddress": "9 - 306 ROXTON DRIVE, Waterloo, Ontario N2T1R6"
+"Coordinates": array:2 [
0 => -80.562639
1 => 43.462585
]
+"Latitude": 43.462585
+"Longitude": -80.562639
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Opportunity Knocks in Beechwood's Sought-After Westwinds Enclave! Welcome to this spacious and beautifully located lifestyle home in the desirable Westwinds community - a quiet, well-maintained enclave offering land ownership with the convenience of lawn care and snow removal handled for you. This thoughtfully designed two-storey home offers exceptional living space, featuring soaring ceilings in the foyer and living room, a separate dining area ideal for entertaining, and a fully renovated kitchen with walkout access to a private patio. The inviting family room with gas fireplace creates a warm and comfortable gathering space, while the main-floor laundry/mudroom adds everyday convenience. The home features 4 bedrooms (2+2) and four bathrooms, providing flexible living arrangements ideal for families, downsizers, or professionals seeking space for guests or a home office. The finished lower level expands the living area with a recreation room, additional bedrooms, full bathroom, and ample storage including a cold room. Additional highlights include a full double garage and a private setting that does not back onto Fischer-Hallman Road, offering added peace and quiet. Located in the heart of Beechwood, you are just minutes from universities, shopping, parks, and the library - combining lifestyle convenience with one of Waterloo's most established and desirable neighbourhoods. (id:62650)"
+"Appliances": array:5 [
0 => "All"
1 => "Water meter"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Water Heater"
]
+"AssociationFee": "434"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"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-07-14T19:11:22.983412+00:00"
+"Directions": "Cross Streets: Fischer Hallman And Erb. ** Directions: Fischer Hallman to Roxton."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2213356"
+"ListOfficeKey": "296481"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T17:39:31Z"
+"PhotosCount": 34
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-14T17:39:31Z"
+"Stories": "2.0"
+"StreetName": "Roxton"
+"StreetNumber": "306"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5946"
+"VirtualTourURLUnbranded": "https://www.mikebolger.ca/listing/306-roxton-drive.html"
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1684149884"
"RoomType" => "Kitchen"
"ListingId" => "X13562104"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.38
"ListingKey" => "30031489"
"RoomLength" => 6.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.4Z"
]
1 => array:11 [
"RoomKey" => "1684149885"
"RoomType" => "Bathroom"
"ListingId" => "X13562104"
"RoomLevel" => "Second level"
"RoomWidth" => 3.06
"ListingKey" => "30031489"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.4Z"
]
2 => array:11 [
"RoomKey" => "1684149886"
"RoomType" => "Bathroom"
"ListingId" => "X13562104"
"RoomLevel" => "Second level"
"RoomWidth" => 2.24
"ListingKey" => "30031489"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.4Z"
]
3 => array:11 [
"RoomKey" => "1684149887"
"RoomType" => "Bathroom"
"ListingId" => "X13562104"
"RoomLevel" => "Basement"
"RoomWidth" => 3.0
"ListingKey" => "30031489"
"RoomLength" => 2.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.4Z"
]
4 => array:11 [
"RoomKey" => "1684149888"
"RoomType" => "Bedroom"
"ListingId" => "X13562104"
"RoomLevel" => "Basement"
"RoomWidth" => 3.05
"ListingKey" => "30031489"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.4Z"
]
5 => array:11 [
"RoomKey" => "1684149889"
"RoomType" => "Bedroom"
"ListingId" => "X13562104"
"RoomLevel" => "Basement"
"RoomWidth" => 2.84
"ListingKey" => "30031489"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.4Z"
]
6 => array:11 [
"RoomKey" => "1684149890"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13562104"
"RoomLevel" => "Basement"
"RoomWidth" => 6.88
"ListingKey" => "30031489"
"RoomLength" => 9.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
7 => array:11 [
"RoomKey" => "1684149891"
"RoomType" => "Other"
"ListingId" => "X13562104"
"RoomLevel" => "Basement"
"RoomWidth" => 5.59
"ListingKey" => "30031489"
"RoomLength" => 4.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
8 => array:11 [
"RoomKey" => "1684149892"
"RoomType" => "Great room"
"ListingId" => "X13562104"
"RoomLevel" => "Ground level"
"RoomWidth" => 4.32
"ListingKey" => "30031489"
"RoomLength" => 5.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
9 => array:11 [
"RoomKey" => "1684149893"
"RoomType" => "Office"
"ListingId" => "X13562104"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.79
"ListingKey" => "30031489"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
10 => array:11 [
"RoomKey" => "1684149894"
"RoomType" => "Family room"
"ListingId" => "X13562104"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.79
"ListingKey" => "30031489"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
11 => array:11 [
"RoomKey" => "1684149895"
"RoomType" => "Bathroom"
"ListingId" => "X13562104"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.0
"ListingKey" => "30031489"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
12 => array:11 [
"RoomKey" => "1684149896"
"RoomType" => "Laundry room"
"ListingId" => "X13562104"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.18
"ListingKey" => "30031489"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
13 => array:11 [
"RoomKey" => "1684149897"
"RoomType" => "Laundry room"
"ListingId" => "X13562104"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.18
"ListingKey" => "30031489"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
14 => array:11 [
"RoomKey" => "1684149898"
"RoomType" => "Foyer"
"ListingId" => "X13562104"
"RoomLevel" => "Main level"
"RoomWidth" => 2.36
"ListingKey" => "30031489"
"RoomLength" => 2.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
15 => array:11 [
"RoomKey" => "1684149899"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13562104"
"RoomLevel" => "Second level"
"RoomWidth" => 4.93
"ListingKey" => "30031489"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
16 => array:11 [
"RoomKey" => "1684149900"
"RoomType" => "Bedroom"
"ListingId" => "X13562104"
"RoomLevel" => "Second level"
"RoomWidth" => 3.51
"ListingKey" => "30031489"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-14T17:39:31.41Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30031489/9-306-roxton-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self Managed"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Fireplace(s)"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"ZoningDescription": "Res 1"
+"BedroomsAboveGrade": 4
+"OriginalEntryTimestamp": "2026-07-14T17:39:31.38Z"
+"ListAgentNationalAssociationId": "1459149"
+"ListOfficeNationalAssociationId": "1470796"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30031489_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/3662f6e87362417e4a80919496b2ba93.webp"
"MediaSize" => 267202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-3662f6e87362417e4a80919496b2ba93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30031489_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/7b193e3c2da799b6be2bef7244b65375.webp"
"MediaSize" => 259063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-7b193e3c2da799b6be2bef7244b65375.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30031489_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/f18f4b0fa7aac9e0eba55f87b98e8ac7.webp"
"MediaSize" => 104755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-f18f4b0fa7aac9e0eba55f87b98e8ac7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30031489_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/2777af4cbab57edb5edf540057def731.webp"
"MediaSize" => 143078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-2777af4cbab57edb5edf540057def731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30031489_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/3c64a958382d75c4d4b07d7c07e7150c.webp"
"MediaSize" => 152529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-3c64a958382d75c4d4b07d7c07e7150c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30031489_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/57993ea83488aa017b6f51ab7d74e66d.webp"
"MediaSize" => 167474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-57993ea83488aa017b6f51ab7d74e66d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30031489_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/47ccddb4c9e9ab1b0027c26db926dd6b.webp"
"MediaSize" => 162869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-47ccddb4c9e9ab1b0027c26db926dd6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30031489_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/8b3a63fdf1407cef2564a35137d94636.webp"
"MediaSize" => 121776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-8b3a63fdf1407cef2564a35137d94636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30031489_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/2f72120b90f279345e0111f616565cdb.webp"
"MediaSize" => 121683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-2f72120b90f279345e0111f616565cdb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30031489_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/a3cb9833f0494e420d6d2cba51742ae1.webp"
"MediaSize" => 139002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-a3cb9833f0494e420d6d2cba51742ae1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30031489_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/c2ac4aecd5d8037c38bdf7ffa07c803d.webp"
"MediaSize" => 149665
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-c2ac4aecd5d8037c38bdf7ffa07c803d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30031489_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/4cda5058483bf848fac9f5a479723b7d.webp"
"MediaSize" => 168448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-4cda5058483bf848fac9f5a479723b7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30031489_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/c143848f0664731ac3970d56c7c9618d.webp"
"MediaSize" => 170945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-c143848f0664731ac3970d56c7c9618d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30031489_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/8d24cf1dfb0ff39bb3a687f4b954d637.webp"
"MediaSize" => 123564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-8d24cf1dfb0ff39bb3a687f4b954d637.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30031489_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/16e3b021bc8161123a82c6f1e1660c4b.webp"
"MediaSize" => 150044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-16e3b021bc8161123a82c6f1e1660c4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30031489_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/d6c0ca8cb1d195c5a12d884a4f50dc09.webp"
"MediaSize" => 97473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-d6c0ca8cb1d195c5a12d884a4f50dc09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30031489_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/feb2793600c33de263599130a6e748a2.webp"
"MediaSize" => 160991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-feb2793600c33de263599130a6e748a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30031489_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/32d4453871fff25e28e858e8df435a44.webp"
"MediaSize" => 145604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-32d4453871fff25e28e858e8df435a44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30031489_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/e4ecb6da2024342f0e1cc97410c82030.webp"
"MediaSize" => 166504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-e4ecb6da2024342f0e1cc97410c82030.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30031489_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/9ce580de4f58bea00f244d1605cedd7d.webp"
"MediaSize" => 127098
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-9ce580de4f58bea00f244d1605cedd7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30031489_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/7701ed87c27babeecf384ee6ff0d9194.webp"
"MediaSize" => 157561
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-7701ed87c27babeecf384ee6ff0d9194.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30031489_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/4b5d7120f24674a22b4a10c4c8ed0385.webp"
"MediaSize" => 159422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-4b5d7120f24674a22b4a10c4c8ed0385.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30031489_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/699e1d98f418d1c87473e621e19c7ccf.webp"
"MediaSize" => 129839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-699e1d98f418d1c87473e621e19c7ccf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30031489_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/f36dd1f7b96c6c138d28944ff3837f16.webp"
"MediaSize" => 159547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-f36dd1f7b96c6c138d28944ff3837f16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30031489_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/3e44848d36e9d5cd8c1005c0f23c1f17.webp"
"MediaSize" => 136462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-3e44848d36e9d5cd8c1005c0f23c1f17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30031489_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/f6bfd4e94b866a057500cf159bd69736.webp"
"MediaSize" => 150165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-f6bfd4e94b866a057500cf159bd69736.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30031489_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/62c7ae85877649b36bc204609d258735.webp"
"MediaSize" => 216207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-62c7ae85877649b36bc204609d258735.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30031489_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/9916ad9583e251778aaacce234501289.webp"
"MediaSize" => 219342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-9916ad9583e251778aaacce234501289.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30031489_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/4f1bd5567eab0debb71ebeefa266f330.webp"
"MediaSize" => 253538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-4f1bd5567eab0debb71ebeefa266f330.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30031489_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/f6a0bb6bf09e761a56bfd2aa55a860bd.webp"
"MediaSize" => 276055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-f6a0bb6bf09e761a56bfd2aa55a860bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30031489_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/ad0130a400ed4c1aa924d071da3a73d4.webp"
"MediaSize" => 315238
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-ad0130a400ed4c1aa924d071da3a73d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30031489_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/963f9ab4778f5feaa4f1b6b297e2654f.webp"
"MediaSize" => 97913
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-963f9ab4778f5feaa4f1b6b297e2654f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30031489_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/1e9cde1db4069442558477712b50511c.webp"
"MediaSize" => 106783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-1e9cde1db4069442558477712b50511c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30031489_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30031489/c770458c31dddf9eacce62f1da6d0064.webp"
"MediaSize" => 100394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30031489/thumbnail-c770458c31dddf9eacce62f1da6d0064.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13562104"
"ResourceRecordKey" => "30031489"
"ModificationTimestamp" => "2026-07-14T17:39:31.39Z"
]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031489')"
+"ID": "1623714"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 296481" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24977
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24885
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CHESTNUT PARK REALTY(SOUTHWESTERN ONTARIO) LTD"
+"OfficeEmail": null
+"OfficePhone": "519-804-7200"
+"OfficeMlsId": "454001"
+"ModificationTimestamp": "2026-03-03T12:05:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "296481"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "75 KING ST SOUTH #50A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "WATERLOO"
+"OfficePostalCode": "N2J1P2"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1470796"
+"OriginalEntryTimestamp": "2024-03-21T19:18:00Z"
+"OfficeAORKey": "82"
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1457628"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('296481')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2213356" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24958
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30031489'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25274
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30031489' AND OpenHouseDate ge '2026-07-18'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25290
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30031489' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.562639 43.462585)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25343
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+post_id: "1639781"
+post_author: 1
+"ListingKey": "30052633"
+"ListingId": "X13581052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T21:30:05Z"
+"RFModificationTimestamp": "2026-07-18T21:44:24Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L2X1"
+"UnparsedAddress": "111 CHURCHILL STREET, Waterloo, Ontario N2L2X1"
+"Coordinates": array:2 [
0 => -80.5479638
1 => 43.4563421
]
+"Latitude": 43.4563421
+"Longitude": -80.5479638
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Investors and parents take note of this great investment opportunity! excellent location! licensed 5 bedroom free hold- no condo fee student rental, walking distance to universities of waterloo and close to university of laurier as well as amenities. Main floor consists of good size eat-in kitchen, spacious living room and 2 bedrooms, walk out to backyard from living room. Upper level features 3 bedrooms with 4pc bathroom, lower level features 3 pcs bathroom, laundry area, storage and entry to the garage. Driveway parking for 2 cars plus 1 in the garage. Easy to rent, this townhouse is vacant and available for immediate purchase. Don't miss the excellent potential gross annual income opportunity of $ 33, 000. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-18T21:44:14.911911+00:00"
+"Directions": "Cross Streets: keats way/ amos ave. ** Directions: Take University Ave S / King St S: Follow directional signs toward downtown Kitchener to smoothly merge onto King St S / University Ave S.Turn onto Churchill St: Continue until you reach 111 Churchill St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2211281"
+"ListOfficeKey": "271929"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T21:24:55Z"
+"PhotosCount": 1
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T21:24:55Z"
+"Stories": "2.0"
+"StreetName": "Churchill"
+"StreetNumber": "111"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3891"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1688030590"
"RoomType" => "Kitchen"
"ListingId" => "X13581052"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30052633"
"RoomLength" => 3.352
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.93Z"
]
1 => array:11 [
"RoomKey" => "1688030591"
"RoomType" => "Living room"
"ListingId" => "X13581052"
"RoomLevel" => "Main level"
"RoomWidth" => 3.352
"ListingKey" => "30052633"
"RoomLength" => 3.048
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.93Z"
]
2 => array:11 [
"RoomKey" => "1688030592"
"RoomType" => "Bedroom"
"ListingId" => "X13581052"
"RoomLevel" => "Main level"
"RoomWidth" => 2.438
"ListingKey" => "30052633"
"RoomLength" => 3.657
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.93Z"
]
3 => array:11 [
"RoomKey" => "1688030593"
"RoomType" => "Bedroom 2"
"ListingId" => "X13581052"
"RoomLevel" => "Main level"
"RoomWidth" => 2.438
"ListingKey" => "30052633"
"RoomLength" => 3.048
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.94Z"
]
4 => array:11 [
"RoomKey" => "1688030594"
"RoomType" => "Bedroom 3"
"ListingId" => "X13581052"
"RoomLevel" => "Second level"
"RoomWidth" => 3.657
"ListingKey" => "30052633"
"RoomLength" => 3.352
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.94Z"
]
5 => array:11 [
"RoomKey" => "1688030595"
"RoomType" => "Bedroom 4"
"ListingId" => "X13581052"
"RoomLevel" => "Second level"
"RoomWidth" => 2.743
"ListingKey" => "30052633"
"RoomLength" => 3.048
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.94Z"
]
6 => array:11 [
"RoomKey" => "1688030596"
"RoomType" => "Bedroom 5"
"ListingId" => "X13581052"
"RoomLevel" => "Second level"
"RoomWidth" => 3.352
"ListingKey" => "30052633"
"RoomLength" => 3.352
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-18T21:24:55.94Z"
]
]
+"ListAOR": "Oakville-Milton"
+"TaxYear": 2025
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/30052633/111-churchill-street-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "MD1"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 24.0
+"OriginalEntryTimestamp": "2026-07-18T21:24:55.91Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1457176"
+"ListOfficeNationalAssociationId": "1282872"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30052633_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30052633/03b074b7dda6da881d4b200e7efb1bc9.webp"
"MediaSize" => 56450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30052633/thumbnail-03b074b7dda6da881d4b200e7efb1bc9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13581052"
"ResourceRecordKey" => "30052633"
"ModificationTimestamp" => "2026-07-18T21:24:55.91Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30052633')"
+"ID": "1639781"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25339
+post_id: "1637960"
+post_author: 1
+"ListingKey": "30043669"
+"ListingId": "40848597"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T20:25:31Z"
+"RFModificationTimestamp": "2026-07-18T20:28:15Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1732.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0A5"
+"UnparsedAddress": "555 CHABLIS Drive Unit# 12, Waterloo, Ontario N2T0A5"
+"Coordinates": array:2 [
0 => -80.5740134
1 => 43.4487735
]
+"Latitude": 43.4487735
+"Longitude": -80.5740134
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this fantastic townhouse in a highly desirable Waterloo location, just minutes from the universities, shopping, restaurants, and public transit. The bright, open-concept main floor features beautiful hardwood flooring, granite countertops, an undermount sink, updated lighting, California shutters on all window and doors and a full suite of stainless steel appliances. A hidden retractable screen on the front door allows you to enjoy fresh air while keeping insects out. The spacious primary bedroom offers a walk-in closet and a private 3-piece ensuite. The second-floor den features new hardwood flooring, making it an ideal home office, study area, or reading nook. The beautifully finished lower-level recreation room provides exceptional additional living space and has been thoughtfully completed with insulated walls and ceilings, Dricore subfloor beneath luxury vinyl flooring, and fully finished drywall on the walls and ceilings for added comfort and durability. Sliding doors from the main living area lead to a private deck, perfect for relaxing or entertaining. Additional features include a single-car garage, central air conditioning, all new ceiling light fixtures throughout, updated bathrooms, and fresh paint in every room completed within the last few years. Move-in ready and located in one of Waterloo's most convenient neighbourhoods, this beautifully updated home is ideal for professionals, families, or investors looking for a low-maintenance property close to all amenities. Den could be converted to 3rd bedroom (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Central Vacuum - Roughed In"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:18:51.013996+00:00"
+"Directions": "Ira Needles"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Covered"
]
+"PhotosChangeTimestamp": "2026-07-18T12:51:56Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T20:18:17Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4358.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/12_555_chablis_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1687972592"
"RoomType" => "2pc Bathroom"
"ListingId" => "40848597"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:17.27Z"
]
1 => array:11 [
"RoomKey" => "1687972593"
"RoomType" => "Storage"
"ListingId" => "40848597"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:17.27Z"
]
2 => array:11 [
"RoomKey" => "1687972594"
"RoomType" => "Recreation room"
"ListingId" => "40848597"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 18'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:17.27Z"
]
3 => array:11 [
"RoomKey" => "1687972595"
"RoomType" => "4pc Bathroom"
"ListingId" => "40848597"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:17.27Z"
]
4 => array:11 [
"RoomKey" => "1687972596"
"RoomType" => "Den"
"ListingId" => "40848597"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 19'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:17.27Z"
]
5 => array:11 [
"RoomKey" => "1687972597"
"RoomType" => "Bedroom"
"ListingId" => "40848597"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30043669"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T20:18:17.27Z"
]
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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30043669/555-chablis-drive-unit-12-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1435
+"BelowGradeFinishedArea": 297
+"OriginalEntryTimestamp": "2026-07-16T18:59:55.46Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30043669')"
+"ID": "1637960"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25336
+post_id: "1637101"
+post_author: 1
+"ListingKey": "30042738"
+"ListingId": "40848676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:14Z"
+"RFModificationTimestamp": "2026-07-17T20:56:26Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1433.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y1"
+"UnparsedAddress": "760 PARIS Boulevard, Waterloo, Ontario N2T2Y1"
+"Coordinates": array:2 [
0 => -80.5744358
1 => 43.4491472
]
+"Latitude": 43.4491472
+"Longitude": -80.5744358
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained freehold end-unit townhome in the highly sought-after Clair Hills community of Waterloo. Featuring over 1,400 sq. ft. of above-grade living space plus a fully finished basement, this spacious home offers 3 bedrooms plus 2 additional bedrooms in the finished basement and 3 bathrooms, making it an excellent choice for growing families, multi-generational living, or buyers seeking added flexibility. The bright main floor features a functional open-concept layout with a spacious living room, an eat-in kitchen, and sliding doors leading to a private backyard deck, perfect for relaxing or entertaining. Upstairs, the generous primary bedroom includes a walk-in closet and semi-ensuite bathroom access, complemented by two additional bedrooms. The fully finished basement features two additional bedrooms, a full bathroom, and a rough-in kitchen, offering excellent flexibility for extended family, guests, a home office, or future in-law suite potential. As an end unit, the home enjoys additional windows, abundant natural light, enhanced privacy, and a larger side yard. Additional features include roof shingles replaced in 2022. Families will appreciate being within the highly regarded Laurel Heights Secondary School boundary, along with excellent elementary schools, nearby parks, walking trails, and playgrounds. Convenient public transit provides easy access to the University of Waterloo. The Boardwalk Shopping Centre, with Costco, Walmart, Landmark Cinemas, restaurants, cafés, medical services, and a wide range of retail amenities, is just minutes away. With quick access to Laurel Creek Conservation Area, The Hydrocut, and major commuter routes, this move-in-ready freehold townhome combines space, flexibility, and an outstanding location in one of Waterloo's most desirable communities. (Some photos have been virtually staged for illustrative purposes only.) (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:56:19.914403+00:00"
+"Directions": "Erbsville Rd. to Chablis, left on Paris"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180828"
+"ListOfficeKey": "290853"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T20:42:50Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:08:53Z"
+"Stories": "2.0"
+"StreetName": "PARIS"
+"StreetNumber": "760"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "3863"
+"VirtualTourURLUnbranded": "https://iguideradix.com/760_paris_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30042738/760-paris-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 1433
+"OriginalEntryTimestamp": "2026-07-16T17:18:27.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1430684"
+"ListOfficeNationalAssociationId": "1394395"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30042738')"
+"ID": "1637101"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25340
+post_id: "1637112"
+post_author: 1
+"ListingKey": "30031516"
+"ListingId": "40847959"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:06Z"
+"RFModificationTimestamp": "2026-07-17T20:47:15Z"
+"ListPrice": 1089900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2882.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2N5"
+"UnparsedAddress": "561 CHANCERY Lane, Waterloo, Ontario N2T2N5"
+"Coordinates": array:2 [
0 => -80.5790555
1 => 43.4649869
]
+"Latitude": 43.4649869
+"Longitude": -80.5790555
+"YearBuilt": 1994
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 561 Chancery Lane, Waterloo – a beautifully open and spacious backsplit nestled in one of Waterloo’s most desirable neighbourhoods. Offering 3 bedrooms, 3 full bathrooms, and exceptional indoor and outdoor living spaces, this home is designed for both everyday comfort and entertaining. The bright and inviting main level features soaring cathedral ceilings, hardwood flooring, and an open-concept living and dining area filled with natural light. The gourmet kitchen is sure to impress with stainless appliances, double wall ovens, a gas cooktop, built-in Miele coffee maker, and a spacious island perfect for gathering with family and friends. The lower level is an entertainer’s dream, showcasing a stylish bar area, custom built-ins, heated slate flooring, and a convenient walk-up to the backyard. A 3-piece bathroom on this level adds functionality and convenience for guests. Upstairs, you'll find three generously sized bedrooms and an updated 4-piece bathroom. The primary bedroom offers the added luxury of a private 3-piece ensuite. The basement provides excellent flexibility and can be used as a home gym, office, additional bedroom, or hobby space. A dedicated laundry room completes this level. Step outside to your own backyard retreat featuring a heated inground pool surrounded by stamped concrete. The cabana is fully equipped with hydro, speakers, a ceiling fan, and a fireplace, creating the perfect setting for summer entertaining. A separate pool house provides ample storage for all your pool equipment and accessories. Completing this home is a double attached garage and an exceptional location close to parks (backs onto Cavendish Park), shopping, and everyday amenities. Families will appreciate being situated within the highly sought-after school catchment for Laurelwood P.S., St. Nicholas Catholic School, Laurel Heights S.S., and Resurrection Catholic S.S., making this an outstanding place to call home. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:47:08.645552+00:00"
+"Directions": "Columbia/Chancery Lane"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908292"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-14T18:25:31Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:10:04Z"
+"Stories": "3.0"
+"StreetName": "CHANCERY"
+"StreetNumber": "561"
+"StreetSuffix": "Lane"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7433.43"
+"VirtualTourURLUnbranded": "https://youriguide.com/561_chancery_lane_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30031516/561-chancery-lane-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2130
+"BelowGradeFinishedArea": 752
+"OriginalEntryTimestamp": "2026-07-14T17:48:18.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1221205"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031516')"
+"ID": "1637112"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25338
+post_id: "1637099"
+post_author: 1
+"ListingKey": "30038060"
+"ListingId": "40848404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T12:20:00Z"
+"RFModificationTimestamp": "2026-07-18T12:23:26Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.272
+"LivingArea": 2866.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5A5"
+"UnparsedAddress": "337 MARLOWE Drive, Waterloo, Ontario N2L5A5"
+"Coordinates": array:2 [
0 => -80.5513334
1 => 43.4621325
]
+"Latitude": 43.4621325
+"Longitude": -80.5513334
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This is the Beechwood home you’ve been waiting for. Tucked beneath mature trees & set on an exceptional 78’ x 181’ lot spanning more than 1/4 acre, this distinctive 3-bed, 3-bath home offers 2,800+ SF of finished living space, a landscaped private backyard, inground pool W/ waterfall & finished walkout lower level in one of Waterloo’s most established neighbourhoods. The main flr features two gathering areas. The living rm has a vaulted wood-clad ceiling, expansive windows, built-in shelving & full-height stone gas fireplace, while the family rm offers a wood-burning fireplace & direct access to the deck & backyard. The updated custom kitchen features white cabinetry, quartz counters, stainless appliances, subway-tile backsplash, skylights & ample workspace & storage. The adjoining breakfast rm features custom pantry cabinetry, a quartz-topped serving station, open wood shelving & another walkout to the deck, while the separate dining rm offers ample space for hosting. Upstairs are 3 well-sized beds & 2 full baths, including a spacious primary W/ excellent closet space & private 3-pc ensuite, plus a 4-pc main bath. The finished walkout lower level adds a lrg rec rm, sauna, separate shower ideal for the pool, laundry/utility rm & storage. Surrounded by mature trees & lush perennial gardens, the backyard feels exceptionally private & peaceful. An expansive deck offers plenty of rm for outdoor dining & lounging, while stone pathways lead to the inground pool, waterfall & stone terrace. Multiple walkouts create an easy indoor-outdoor connection. Located on a quiet street, steps from Clair Lake, trails, parks & schools, & close to Uptown Waterloo, both universities, shopping, restaurants & major employers. Residents also enjoy access to Beechwood Park Homes Association amenities & the strong sense of community Beechwood is known for. A rare opportunity to own a private poolside family home on an extraordinary mature lot in one of Waterloo’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:40:23.159836+00:00"
+"Directions": "KEATS WAY TO AMOS AVENUE, THEN MARLOWE DRIVE"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932106"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.272"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T12:11:21Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T12:11:21Z"
+"Stories": "2.0"
+"StreetName": "MARLOWE"
+"StreetNumber": "337"
+"StreetSuffix": "Drive"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "7061.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/337_marlowe_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30038060/337-marlowe-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975048"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 78.0
+"AboveGradeFinishedArea": 2064
+"BelowGradeFinishedArea": 802
+"OriginalEntryTimestamp": "2026-07-15T19:48:18.36Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1232419"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1261853"
+"CoListOfficeNationalAssociationId": "1004357"
+"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('30038060')"
+"ID": "1637099"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
+post_id: "1634495"
+post_author: 1
+"ListingKey": "30046352"
+"ListingId": "40849006"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T15:20:06Z"
+"RFModificationTimestamp": "2026-07-17T15:22:50Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1358.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1G3"
+"UnparsedAddress": "543 DRUMMERHILL Crescent, Waterloo, Ontario N2T1G3"
+"Coordinates": array:2 [
0 => -80.553139
1 => 43.4461149
]
+"Latitude": 43.4461149
+"Longitude": -80.553139
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Great Location! Welcome to this beautiful detached home in the highly sought-after Westvale neighbourhood. Situated on a quiet, family-friendly crescent, this carpet-free home is conveniently located near top-rated schools, shopping, parks, trails, transit, and just minutes from Uptown Waterloo, the University of Waterloo, Costco, Walmart, medical centres, restaurants, and highway access. This well-maintained single-family home features 3 bedrooms, 2 bathrooms, a single-car garage, parking for three vehicles, and a finished recreation room. The bright main floor offers hardwood flooring, a 2-piece powder room, direct garage access, and sliding doors leading to a fully fenced backyard with a spacious deck—perfect for family gatherings and outdoor entertaining. Upstairs, you'll find three generous bedrooms and a beautifully renovated bathroom. The basement is nearly complete, featuring a finished rec room and a framed 3-piece bathroom rough-in, offering excellent potential for additional living space. Move-in ready and located in one of Waterloo's most desirable family communities, this is a fantastic opportunity you won't want to miss! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"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-07-17T13:55:25.143676+00:00"
+"Directions": "Fischer-Hallman to Thorndale, left onto Westvale, right onto Drummerhill Crescent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T15:13:22Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T15:18:20Z"
+"Stories": "2.0"
+"StreetName": "DRUMMERHILL"
+"StreetNumber": "543"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "439 - Westvale"
+"TaxAnnualAmount": "3852.78"
+"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/30046352/543-drummerhill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SD-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1108
+"BelowGradeFinishedArea": 250
+"OriginalEntryTimestamp": "2026-07-17T11:49:29.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30046352')"
+"ID": "1634495"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "1631260"
+post_author: 1
+"ListingKey": "30042935"
+"ListingId": "X13572494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T03:45:02Z"
+"RFModificationTimestamp": "2026-07-18T03:47:17Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y1"
+"UnparsedAddress": "760 PARIS BOULEVARD, Waterloo, Ontario N2T2Y1"
+"Coordinates": array:2 [
0 => -80.574452
1 => 43.449168
]
+"Latitude": 43.449168
+"Longitude": -80.574452
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained freehold end-unit townhome in the highly sought-after Clair Hills community of Waterloo. Featuring over 1,400 sq. ft. of above-grade living space plus a fully finished basement, this spacious home offers 3 bedrooms plus 2 additional bedrooms in the finished basement and 3 bathrooms, making it an excellent choice for growing families, multi-generational living, or buyers seeking added flexibility. The bright main floor features a functional open-concept layout with a spacious living room, an eat-in kitchen, and sliding doors leading to a private backyard deck, perfect for relaxing or entertaining. Upstairs, the generous primary bedroom includes a walk-in closet and semi-ensuite bathroom access, complemented by two additional bedrooms. The fully finished basement features two additional bedrooms, a full bathroom, and a rough-in kitchen, offering excellent flexibility for extended family, guests, a home office, or future in-law suite potential. As an end unit, the home enjoys additional windows, abundant natural light, enhanced privacy, and a larger side yard. Additional features include roof shingles replaced in 2022. Families will appreciate being within the highly regarded Laurel Heights Secondary School boundary, along with excellent elementary schools, nearby parks, walking trails, and playgrounds. Convenient public transit provides easy access to the University of Waterloo. The Boardwalk Shopping Centre, with Costco, Walmart, Landmark Cinemas, restaurants, cafés, medical services, and a wide range of retail amenities, is just minutes away.With quick access to Laurel Creek Conservation Area, The Hydrocut, and major commuter routes, this move-in-ready freehold townhome combines space, flexibility, and an outstanding location in one of Waterloo's most desirable communities.(Some photos have been virtually staged for illustrative purposes only.) (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T18:06:12.656811+00:00"
+"Directions": "Cross Streets: Erbsville Road and Erb Street. ** Directions: Erbsville Rd. to Chablis, left on Paris."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188755"
+"ListOfficeKey": "291409"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "26.9 x 99.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T20:58:38Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T03:37:52Z"
+"Stories": "2.0"
+"StreetName": "Paris"
+"StreetNumber": "760"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4863"
+"VirtualTourURLUnbranded": "https://iguideradix.com/760_paris_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30042935/760-paris-boulevard-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1418255"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "90198"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 26.1
+"OriginalEntryTimestamp": "2026-07-16T17:40:46.35Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1437820"
+"ListOfficeNationalAssociationId": "1397659"
+"CoListAgentNationalAssociationId": "1105101"
+"CoListOfficeNationalAssociationId": "1153615"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30042935')"
+"ID": "1631260"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25341
+post_id: "1629363"
+post_author: 1
+"ListingKey": "30038706"
+"ListingId": "X13568634"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T21:20:04Z"
+"RFModificationTimestamp": "2026-07-15T23:10:41Z"
+"ListPrice": 1149900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5A5"
+"UnparsedAddress": "337 MARLOWE DRIVE, Waterloo, Ontario N2L5A5"
+"Coordinates": array:2 [
0 => -80.551304
1 => 43.462117
]
+"Latitude": 43.462117
+"Longitude": -80.551304
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is the Beechwood home you've been waiting for. Tucked beneath mature trees & set on an exceptional 78' x 181' lot spanning more than 1/4 acre, this distinctive 3-bed, 3-bath home offers 2,800+ SF of finished living space, a landscaped private backyard, inground pool W/ waterfall & finished walkout lower level in one of Waterloo's most established neighbourhoods. The main flr features two gathering areas. The living rm has a vaulted wood-clad ceiling, expansive windows, built-in shelving & full-height stone gas fireplace, while the family rm offers a wood-burning fireplace & direct access to the deck & backyard. The updated custom kitchen features white cabinetry, quartz counters, stainless appliances, subway-tile backsplash, skylights & ample workspace & storage. The adjoining breakfast rm features custom pantry cabinetry, a quartz-topped serving station, open wood shelving & another walkout to the deck, while the separate dining rm offers ample space for hosting. Upstairs are 3 well-sized beds & 2 full baths, including a spacious primary W/ excellent closet space & private 3-pc ensuite, plus a 4-pc main bath. The finished walkout lower level adds a lrg rec rm, sauna, separate shower ideal for the pool, laundry/utility rm & storage. Surrounded by mature trees & lush perennial gardens, the backyard feels exceptionally private & peaceful. An expansive deck offers plenty of rm for outdoor dining & lounging, while stone pathways lead to the inground pool, waterfall & stone terrace. Multiple walkouts create an easy indoor-outdoor connection. Located on a quiet street, steps from Clair Lake, trails, parks & schools, & close to Uptown Waterloo, both universities, shopping, restaurants & major employers. Residents also enjoy access to Beechwood Park Homes Association amenities & the strong sense of community Beechwood is known for. A rare opportunity to own a private poolside family home on an extraordinary mature lot in one of Waterloo's most desirable neighbourhoods. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T23:10:34.793879+00:00"
+"Directions": "Cross Streets: AMOS AVENUE. ** Directions: KEATS WAY TO AMOS AVENUE, THEN MARLOWE DRIVE."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103799"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
2 => "Lighting"
3 => "Sauna"
]
+"LotSizeDimensions": "77.7 x 134.5 FT ; 77.85 x 181.25 x 79.61 x 134.50"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T21:10:25Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Outdoor pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T21:10:25Z"
+"Stories": "2.0"
+"StreetName": "Marlowe"
+"StreetNumber": "337"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7061.04"
+"VirtualTourURLUnbranded": "https://youriguide.com/337_marlowe_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30038706/337-marlowe-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 77.8
+"OriginalEntryTimestamp": "2026-07-15T21:10:25.4Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373322"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30038706')"
+"ID": "1629363"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25342
+post_id: "1626777"
+post_author: 1
+"ListingKey": "30035988"
+"ListingId": "X13565994"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T15:50:04Z"
+"RFModificationTimestamp": "2026-07-16T17:06:49Z"
+"ListPrice": 959000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T1R5"
+"UnparsedAddress": "298 ROXTON DRIVE, Waterloo, Ontario N2T1R5"
+"Coordinates": array:2 [
0 => -80.5631353
1 => 43.4630718
]
+"Latitude": 43.4630718
+"Longitude": -80.5631353
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 298 Roxton Drive, a spacious and versatile two-storey home nestled in Waterloo's sought-after Westwinds community. Thoughtfully designed for comfortable family living and entertaining, this well-appointed home offers an exceptional layout with generous principal rooms and endless potential. The main floor features a bright eat-in kitchen, inviting family room, formal living and dining rooms, a private den ideal for a home office, convenient main floor laundry, and a powder room. Upstairs, the expansive primary suite includes a walk-in closet with built-ins and a private 4-piece ensuite. A generous second bedroom, additional 4-piece bath, and a flexible loft and sitting area provide outstanding versatility - perfect for a media room, home gym, office, or easily converted third sleeping space. The oversized basement offers incredible additional living potential, highlighted by a massive L-shaped recreation room ready to be customized to suit your lifestyle - whether as a games room, home theatre, fitness area, or multi-generational living space. Ideally located close to both University of Waterloo and Wilfrid Laurier University, this home is situated in a desirable family-friendly neighbourhood near parks, schools, shopping, and everyday amenities. Community fees conveniently include landscaping and snow removal, offering added ease and low-maintenance living. This home presents a rare opportunity to create the space you've been looking for in one of Waterloo's most established communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "376.66"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-15T17:01:19.196208+00:00"
+"Directions": "Cross Streets: Fischer-Hallman. ** Directions: Fischer-Hallman and Roxton."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099764"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T15:39:55Z"
+"PhotosCount": 33
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T15:40:25Z"
+"Stories": "2.0"
+"StreetName": "Roxton"
+"StreetNumber": "298"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7118.33"
+"VirtualTourURLUnbranded": "https://youriguide.com/298_roxton_dr_waterloo_on/"
+"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/30035988/298-roxton-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Self Managed"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2499
+"LivingAreaMinimum": 2250
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-07-15T15:39:55.35Z"
+"ListAgentNationalAssociationId": "1369922"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30035988')"
+"ID": "1626777"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 130
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
]