array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30073974 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23528
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23530
+post_id: "1654553"
+post_author: 1
+"ListingKey": "30073974"
+"ListingId": "X13600694"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T03:40:01Z"
+"RFModificationTimestamp": "2026-07-24T04:37:45Z"
+"ListPrice": 990000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2W4"
+"UnparsedAddress": "735 KARLSFELD ROAD, Waterloo, Ontario N2T2W4"
+"Coordinates": array:2 [
0 => -80.57791
1 => 43.456617
]
+"Latitude": 43.456617
+"Longitude": -80.57791
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the heart of Clair Hills, this bright and spacious home offers the perfect blend ofcomfort, nature, and community. Located just steps from scenic walking trails and a charmingneighbourhood park, the area is known for a very friendly, respectful atmosphere and top-ratedschools.This well-designed two-story home features an open-concept layout with 4 bedrooms, 3 bathrooms,and a 2-car garage plus a double driveway accommodating up to 4 vehicles.The main floor is ideal for both everyday living and entertaining. A generous living and diningarea flows seamlessly into a warm and inviting family room with large windows and a cozy gasfireplace. The kitchen offers ample cabinetry, an open connection to the family room, and apleasant view right from the kitchen sink window.Step outside to enjoy a southwest-facing deck overlooking the open area - perfect for relaxingevenings and sunsets.Upstairs, you'll find four spacious bedrooms, each with a good size closets. The primary suite features abundant natural light, a walk-in closet, and a private ensuite bathroom complete with a tub, separate shower, and oversized vanity.Unfinished basement has big windows and walk-in backyard entry, good for storage or as a fitness equipment room.Conveniently located just minutes from major amenities including Costco and T&T Supermarket, as well as top institutions such as University of Waterloo and Wilfrid Laurier University.This home is ideal for families seeking space, comfort, and a peaceful, nature-connected lifestyle. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-24T04:37:35.038256+00:00"
+"Directions": "Cross Streets: Keats Way and Erbsville Rd. ** Directions: Erbsville Rd to Keats Way to Karlsfeld Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623242"
+"ListOfficeKey": "300429"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "34 x 128 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T03:32:27Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T03:32:27Z"
+"Stories": "2.0"
+"StreetName": "Karlsfeld"
+"StreetNumber": "735"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6359.23"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/735-karlsfeld-road-waterloo/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1692223062"
"RoomType" => "Living room"
"ListingId" => "X13600694"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "30073974"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
1 => array:11 [
"RoomKey" => "1692223063"
"RoomType" => "Laundry room"
"ListingId" => "X13600694"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "30073974"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
2 => array:11 [
"RoomKey" => "1692223064"
"RoomType" => "Dining room"
"ListingId" => "X13600694"
"RoomLevel" => "Main level"
"RoomWidth" => 3.81
"ListingKey" => "30073974"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
3 => array:11 [
"RoomKey" => "1692223065"
"RoomType" => "Family room"
"ListingId" => "X13600694"
"RoomLevel" => "Main level"
"RoomWidth" => 4.11
"ListingKey" => "30073974"
"RoomLength" => 5.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
4 => array:11 [
"RoomKey" => "1692223066"
"RoomType" => "Kitchen"
"ListingId" => "X13600694"
"RoomLevel" => "Main level"
"RoomWidth" => 3.33
"ListingKey" => "30073974"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
5 => array:11 [
"RoomKey" => "1692223067"
"RoomType" => "Bedroom"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 4.52
"ListingKey" => "30073974"
"RoomLength" => 5.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
6 => array:11 [
"RoomKey" => "1692223068"
"RoomType" => "Bedroom 2"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 2.87
"ListingKey" => "30073974"
"RoomLength" => 3.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.74Z"
]
7 => array:11 [
"RoomKey" => "1692223069"
"RoomType" => "Bedroom 3"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 2.84
"ListingKey" => "30073974"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.75Z"
]
8 => array:11 [
"RoomKey" => "1692223070"
"RoomType" => "Bedroom 4"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "30073974"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.75Z"
]
9 => array:11 [
"RoomKey" => "1692223071"
"RoomType" => "Bathroom"
"ListingId" => "X13600694"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "30073974"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.75Z"
]
10 => array:11 [
"RoomKey" => "1692223072"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13600694"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "30073974"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T03:32:27.75Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30073974/735-karlsfeld-road-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 34.0
+"OriginalEntryTimestamp": "2026-07-24T03:32:27.72Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1160967"
+"ListOfficeNationalAssociationId": "1487853"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30073974_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/4336044a1c92aaa36dbea58d7be186c3.webp"
"MediaSize" => 599059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-4336044a1c92aaa36dbea58d7be186c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30073974_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/c14e54afbc9bcd3e394ce3f894ed151b.webp"
"MediaSize" => 375022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-c14e54afbc9bcd3e394ce3f894ed151b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30073974_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/34c9406a351f1ac730ef4867a7ea73c7.webp"
"MediaSize" => 162392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-34c9406a351f1ac730ef4867a7ea73c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30073974_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/0b85526263283391fa76117a81884e69.webp"
"MediaSize" => 104567
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-0b85526263283391fa76117a81884e69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30073974_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/841f9aa50155d06ba8a106d58c5b0075.webp"
"MediaSize" => 173970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-841f9aa50155d06ba8a106d58c5b0075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30073974_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/bdcc5502309fd2bbdf89d75143181ec2.webp"
"MediaSize" => 152612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-bdcc5502309fd2bbdf89d75143181ec2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30073974_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/5dee4c5a188a905cd5288f986dbc032e.webp"
"MediaSize" => 176956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-5dee4c5a188a905cd5288f986dbc032e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30073974_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/adb4af0431bd584474ae808f64588b78.webp"
"MediaSize" => 171337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-adb4af0431bd584474ae808f64588b78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30073974_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/38721c2d047365eba39d8bf4512eb09b.webp"
"MediaSize" => 160104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-38721c2d047365eba39d8bf4512eb09b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30073974_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/2c06761c2cfe0bd27464edefb7e52f02.webp"
"MediaSize" => 146293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-2c06761c2cfe0bd27464edefb7e52f02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30073974_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/c61c2c76a1426cb9775766b124d057e2.webp"
"MediaSize" => 163523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-c61c2c76a1426cb9775766b124d057e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30073974_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/9d438c47eba52e4aa832814fd04781d9.webp"
"MediaSize" => 223652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-9d438c47eba52e4aa832814fd04781d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30073974_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/d6cea52524c2d8496de826ff3c5c84cb.webp"
"MediaSize" => 184987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-d6cea52524c2d8496de826ff3c5c84cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30073974_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/82266eb70b0fb3e4db0220b74c87fc73.webp"
"MediaSize" => 235215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-82266eb70b0fb3e4db0220b74c87fc73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30073974_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/77173354a074a93ec9bd0a082a38f99d.webp"
"MediaSize" => 187885
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-77173354a074a93ec9bd0a082a38f99d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30073974_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/44973116ff3293d16bca73ca78c8de4a.webp"
"MediaSize" => 176130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-44973116ff3293d16bca73ca78c8de4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30073974_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/2978ec973414c55c5af6139fc8f580e2.webp"
"MediaSize" => 224853
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-2978ec973414c55c5af6139fc8f580e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30073974_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/c207c2fa9070e17f5a9ed7d3d6dedf76.webp"
"MediaSize" => 216129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-c207c2fa9070e17f5a9ed7d3d6dedf76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30073974_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/dab002432db0bb6eb4108ab4e5f6003b.webp"
"MediaSize" => 217391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-dab002432db0bb6eb4108ab4e5f6003b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30073974_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/d810b761d07c1d6549d3bb59552f53a7.webp"
"MediaSize" => 262018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-d810b761d07c1d6549d3bb59552f53a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30073974_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/b0d0b23a668c85d422f5cd46d31d7f17.webp"
"MediaSize" => 237341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-b0d0b23a668c85d422f5cd46d31d7f17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30073974_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/e9753b932aebd63fd9a1111afa77aeef.webp"
"MediaSize" => 207026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-e9753b932aebd63fd9a1111afa77aeef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30073974_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/d34464ca908bbd8e2c735c50dd95f7d9.webp"
"MediaSize" => 225645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-d34464ca908bbd8e2c735c50dd95f7d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30073974_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/60d7840a1a939eac505014445dee815f.webp"
"MediaSize" => 328668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-60d7840a1a939eac505014445dee815f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30073974_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/aee60f04a4e670966a0a8145603da941.webp"
"MediaSize" => 348171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-aee60f04a4e670966a0a8145603da941.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30073974_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/0fb56b70d83571f1489e0940d651b63c.webp"
"MediaSize" => 122063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-0fb56b70d83571f1489e0940d651b63c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30073974_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/5d83dc0a8343ab9400eaabffee70e054.webp"
"MediaSize" => 190249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-5d83dc0a8343ab9400eaabffee70e054.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30073974_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/e04d8c96071d16b0176ac3beb7bc1c17.webp"
"MediaSize" => 172794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-e04d8c96071d16b0176ac3beb7bc1c17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30073974_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/5b65a9d66536c54be45744e3fe85e63e.webp"
"MediaSize" => 206026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-5b65a9d66536c54be45744e3fe85e63e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30073974_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/1006f6ec22ec769783324e07055c2372.webp"
"MediaSize" => 107182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-1006f6ec22ec769783324e07055c2372.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30073974_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/35b49253dc21c8bc8aef4d063b59328c.webp"
"MediaSize" => 172931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-35b49253dc21c8bc8aef4d063b59328c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30073974_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/6d63a09550157aa2ea9f5ed3746035d9.webp"
"MediaSize" => 173209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-6d63a09550157aa2ea9f5ed3746035d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30073974_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/3dd8dbd1416dd11e02313049758abc1b.webp"
"MediaSize" => 142219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-3dd8dbd1416dd11e02313049758abc1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30073974_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/1c23a2ebc8cffa436a206195cd623413.webp"
"MediaSize" => 156028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-1c23a2ebc8cffa436a206195cd623413.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30073974_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/5c8661282078750d2fd596d914eb81cd.webp"
"MediaSize" => 202911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-5c8661282078750d2fd596d914eb81cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30073974_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/fc4d1606685e9e52d73d50499df2c5fb.webp"
"MediaSize" => 190690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-fc4d1606685e9e52d73d50499df2c5fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30073974_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/544673fda139e4509ec1bcf06c15d917.webp"
"MediaSize" => 112124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-544673fda139e4509ec1bcf06c15d917.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30073974_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/0752e3520f906efcc72794929ec77b15.webp"
"MediaSize" => 148043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-0752e3520f906efcc72794929ec77b15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30073974_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/f4f28d943f012c44f4e5a0cd722daaa9.webp"
"MediaSize" => 121404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-f4f28d943f012c44f4e5a0cd722daaa9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30073974_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/e32df929d1dc4d0fea4751f05f68266e.webp"
"MediaSize" => 488399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-e32df929d1dc4d0fea4751f05f68266e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30073974_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/fa9b5b85dfb46bd103d9b43a0146308d.webp"
"MediaSize" => 342037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-fa9b5b85dfb46bd103d9b43a0146308d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30073974_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/756975736cbcb3fa7727fc3332e4e090.webp"
"MediaSize" => 491865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-756975736cbcb3fa7727fc3332e4e090.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30073974_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/c17919e9baf24bd9e2aed435398240fe.webp"
"MediaSize" => 397944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-c17919e9baf24bd9e2aed435398240fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30073974_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/584ee5f42cc546166c3daf2e83436d1f.webp"
"MediaSize" => 315717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-584ee5f42cc546166c3daf2e83436d1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30073974_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/0f96c77118f7896424eb6121e249e73e.webp"
"MediaSize" => 302967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-0f96c77118f7896424eb6121e249e73e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "30073974_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/147eedbb31853b9183fefdb00be2365e.webp"
"MediaSize" => 339970
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-147eedbb31853b9183fefdb00be2365e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "30073974_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073974/8f54708b7b8a8059fe087c84dac60faa.webp"
"MediaSize" => 261754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073974/thumbnail-8f54708b7b8a8059fe087c84dac60faa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600694"
"ResourceRecordKey" => "30073974"
"ModificationTimestamp" => "2026-07-24T03:32:27.72Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30073974')"
+"ID": "1654553"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 300429" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25041
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24984
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "SKYBOUND REALTY"
+"OfficeEmail": null
+"OfficePhone": "905-798-6060"
+"OfficeMlsId": "20015601"
+"ModificationTimestamp": "2026-03-31T20:46:56Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "300429"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "5805 Whittle Rd Unit: 4A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Mississauga"
+"OfficePostalCode": "L4Z2J"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1487853"
+"OriginalEntryTimestamp": "2025-09-04T17:10:00Z"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeBrokerNationalAssociationId": "1141721"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('300429')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1623242" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25064
+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 '30073974'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25374
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30073974' AND OpenHouseDate ge '2026-07-23'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25390
+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 '30073974' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.57791 43.456617)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25507
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25501
+post_id: "1652383"
+post_author: 1
+"ListingKey": "30071331"
+"ListingId": "X13598432"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T17:45:06Z"
+"RFModificationTimestamp": "2026-07-23T19:03:00Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE DRIVE, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.572799
1 => 43.457509
]
+"Latitude": 43.457509
+"Longitude": -80.572799
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RemarksPublic Remarks: Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T19:02:42.717889+00:00"
+"Directions": "Cross Streets: Erbsville Rd/ Keatsway. ** Directions: Erbsville Road to Keatsway."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "47.9 x 102 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T17:39:27Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T17:39:27Z"
+"Stories": "2.0"
+"StreetName": "Yorkshire"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6960"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1691830136"
"RoomType" => "Dining room"
"ListingId" => "X13598432"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "30071331"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
1 => array:11 [
"RoomKey" => "1691830137"
"RoomType" => "Other"
"ListingId" => "X13598432"
"RoomLevel" => "Basement"
"RoomWidth" => 3.0
"ListingKey" => "30071331"
"RoomLength" => 4.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
2 => array:11 [
"RoomKey" => "1691830138"
"RoomType" => "Kitchen"
"ListingId" => "X13598432"
"RoomLevel" => "Main level"
"RoomWidth" => 3.15
"ListingKey" => "30071331"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
3 => array:11 [
"RoomKey" => "1691830139"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Main level"
"RoomWidth" => 2.97
"ListingKey" => "30071331"
"RoomLength" => 3.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
4 => array:11 [
"RoomKey" => "1691830140"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Second level"
"RoomWidth" => 3.78
"ListingKey" => "30071331"
"RoomLength" => 4.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.57Z"
]
5 => array:11 [
"RoomKey" => "1691830141"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Second level"
"RoomWidth" => 2.62
"ListingKey" => "30071331"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
6 => array:11 [
"RoomKey" => "1691830142"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Second level"
"RoomWidth" => 2.92
"ListingKey" => "30071331"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
7 => array:11 [
"RoomKey" => "1691830143"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Second level"
"RoomWidth" => 3.0
"ListingKey" => "30071331"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
8 => array:11 [
"RoomKey" => "1691830144"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Basement"
"RoomWidth" => 3.1
"ListingKey" => "30071331"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
9 => array:11 [
"RoomKey" => "1691830145"
"RoomType" => "Bedroom"
"ListingId" => "X13598432"
"RoomLevel" => "Basement"
"RoomWidth" => 3.0
"ListingKey" => "30071331"
"RoomLength" => 3.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
10 => array:11 [
"RoomKey" => "1691830146"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13598432"
"RoomLevel" => "Basement"
"RoomWidth" => 4.47
"ListingKey" => "30071331"
"RoomLength" => 6.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T17:39:27.58Z"
]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071331/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 47.1
+"OriginalEntryTimestamp": "2026-07-23T17:39:27.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30071331_4890_1"
…11
]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071331')"
+"ID": "1652383"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25503
+post_id: "1652258"
+post_author: 1
+"ListingKey": "30070302"
+"ListingId": "40849801"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T15:45:05Z"
+"RFModificationTimestamp": "2026-07-23T16:58:27Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 7.0
+"LotSizeArea": 0
+"LivingArea": 3733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2V1"
+"UnparsedAddress": "519 YORKSHIRE Drive, Waterloo, Ontario N2T2V1"
+"Coordinates": array:2 [
0 => -80.5727819
1 => 43.4575227
]
+"Latitude": 43.4575227
+"Longitude": -80.5727819
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 519 Yorkshire Drive, Waterloo: Luxury Living in Prestigious Upper Beechwood! A beautifully updated detached 2-storey home, Nestled on a mature, tree-lined street in Upper Beechwood offers outstanding curb appeal with lush landscaping and parking for 4 vehicles (2 in oversized 13.5 ft high garage, 2 on concrete driveway. Step inside through a Grand porch to welcoming foyer leading to a thoughtfully renovated interior featuring updated flooring and pot lights throughout. The spacious living room is warm, airy and very bright. A rare main-floor bedroom offers incredible flexibility. The inviting family room creates the perfect setting for relaxing evenings, game nights or movie nights. The beautifully updated kitchen is fully equipped with stainless steel appliances, granite countertops, a chic tile backsplash and ample cabinetry. Adjacent is the spacious dining area, perfect for hosting dinner parties or creating lasting memories. A spacious Laundry room with ample storage and a convenient 2pc powder room completes the main level. Upstairs there are 4 generous bedrooms and 2 full bathrooms. The primary suite includes a walk-in closet and a luxurious ensuite with a Jacuzzi tub. Most windows in this house have been replaced. The fully finished basement adds exceptional living space with 2 additional bedrooms, 3pc bathroom and huge Rec area with kitchenette setup. Step outside to fully fenced backyard, featuring a spacious patio and charming gazebo, perfect for summer BBQs, entertaining or simply relaxing. Additional updates: Furnace and AC (2025) and a new water heater (2026). Located minutes from top-rated schools, University of Waterloo and Wilfrid Laurier, The Boardwalk Plaza, Costco, parks, Trails, public transit, restaurants and healthcare facilities, this location has it all. Offering 7 bedrooms, 4 bathrooms, this beautifully upgraded home is a rare opportunity, Book your private showing today and make it your forever home. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T16:58:13.051179+00:00"
+"Directions": "Erbsville Road to Keatsway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T15:38:28Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T15:38:28Z"
+"Stories": "2.0"
+"StreetName": "YORKSHIRE"
+"StreetNumber": "519"
+"StreetSuffix": "Drive"
+"SubdivisionName": "440 - Upper Beechwood/Beechwood W."
+"TaxAnnualAmount": "6960"
+"VirtualTourURLUnbranded": "https://youriguide.com/6d9ag_519_yorkshire_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070302/519-yorkshire-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 48.0
+"AboveGradeFinishedArea": 2447
+"BelowGradeFinishedArea": 1286
+"OriginalEntryTimestamp": "2026-07-23T15:38:28.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070302')"
+"ID": "1652258"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25500
+post_id: "1650965"
+post_author: 1
+"ListingKey": "30068661"
+"ListingId": "X13595776"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T01:05:41Z"
+"RFModificationTimestamp": "2026-07-23T01:16:39Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2M1"
+"UnparsedAddress": "518 BROOKMILL CRESCENT, Waterloo, Ontario N2V2M1"
+"Coordinates": array:2 [
0 => -80.583029
1 => 43.472566
]
+"Latitude": 43.472566
+"Longitude": -80.583029
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Welcome to the home that checks all the boxes-and then a few you didn't even know were on your list!** Located in Waterloo's ever-popular Laurelwood neighborhoods, this beautifully maintained 3-bedroom, 2.5-bathroom home is ready for its next chapter. From the moment you step inside, you'll appreciate the bright, carpet-free main floor that's perfect for busy families, muddy paws, and everyday life. The functional main floor offers plenty of space to gather, whether you're hosting friends for dinner, helping with homework at the kitchen table, or enjoying a quiet night in. Upstairs, you'll find three spacious bedrooms, including a relaxing primary retreat with its own ensuite-because everyone deserves a little space to escape. Need more room? The finished basement has you covered! With a large carpet-free rec room, it's ready to become your movie lounge, kids' playroom, home gym, office, games room...or maybe all of them! Plus, the extensive built-in storage means you can finally tuck away the holiday decorations, hockey equipment, and all those "I'll deal with it later" bins. Outside, the single-car garage and private driveway make coming and going a breeze, while the location is hard to beat. You're surrounded by parks, walking trails, top-rated schools, shopping, restaurants, the YMCA, and everything that makes Laurelwood one of Waterloo's most loved communities. This isn't just another house-it's the kind of home where birthday parties are celebrated, backyard BBQs become a summer tradition, and Friday night pizza tastes just a little bit better. Come see why so many people dream of calling Laurelwood home... and why 518 Brookmill Crescent might just be the one you've been waiting for. (id:66098)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Water softener"
2 => "Dryer"
3 => "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-23T01:16:28.826767+00:00"
+"Directions": "LAURELWOOD DR"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127309"
+"ListOfficeKey": "275615"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"LotSizeDimensions": "30.2 x 115 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T00:58:53Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T00:58:53Z"
+"Stories": "2.0"
+"StreetName": "Brookmill"
+"StreetNumber": "518"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5430"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/518_brookmill_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/30068661/518-brookmill-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 30.2
+"OriginalEntryTimestamp": "2026-07-23T00:58:53.87Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1380658"
+"ListOfficeNationalAssociationId": "1266850"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30068661')"
+"ID": "1650965"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25504
+post_id: "1650535"
+post_author: 1
+"ListingKey": "30068427"
+"ListingId": "X13595566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:45:05Z"
+"RFModificationTimestamp": "2026-07-23T16:53:47Z"
+"ListPrice": 587000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T0A5"
+"UnparsedAddress": "36 - 555 CHABLIS DRIVE, Waterloo, Ontario N2T0A5"
+"Coordinates": array:2 [
0 => -80.574031
1 => 43.449435
]
+"Latitude": 43.449435
+"Longitude": -80.574031
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare end-unit condo townhome in sought-after Clair Hills offers the space and features of a detached home without the upkeep. A double-car garage plus double-wide driveway delivers parking for four - virtually unheard of in condo life. At 2,478 sq. ft. of total finished living area, the layout is generous throughout: open-concept main floor with hardwood, a well-appointed kitchen with gas range, breakfast peninsula, pantry and stainless appliances, three upstairs bedrooms including an oversized primary with walk-in closet and ensuite, upper-level laundry, and a flexible lower level ideal for a family room, office or gym. Move-in ready with 2026 updates including fresh paint, new upstairs carpet and updated lighting, while the bathrooms have been refreshed with new vanities, mirrors, faucets, toilets and coordinated black fixtures. Smart home features include app-based locks, lighting and garage access. Furnace and AC replaced 2023. The end-unit position brings extra windows, privacy and a rear deck overlooking landscaped green space - no street exposure. Steps to The Boardwalk's shops, restaurants, Costco and healthcare, with easy GRT access and 150+ km of trails nearby. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T00:54:31.814311+00:00"
+"Directions": "Ira Needles & Chablis"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102918"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:07:11Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:39:54Z"
+"Stories": "2.0"
+"StreetName": "Chablis"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4956"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_36_555_chablis_dr_waterloo_on/"
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30068427/36-555-chablis-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-22T23:33:34.65Z"
+"ListAgentNationalAssociationId": "1372568"
+"ListOfficeNationalAssociationId": "1385020"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30068427')"
+"ID": "1650535"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25502
+post_id: "1650445"
+post_author: 1
+"ListingKey": "30067509"
+"ListingId": "X13594960"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T20:45:03Z"
+"RFModificationTimestamp": "2026-07-22T23:01:01Z"
+"ListPrice": 799990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V0B4"
+"UnparsedAddress": "274 BUTTONBUSH STREET, Waterloo, Ontario N2V0B4"
+"Coordinates": array:2 [
0 => -80.590313
1 => 43.451104
]
+"Latitude": 43.451104
+"Longitude": -80.590313
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Vista Hills - Home To Some Of Waterloo's Highest-Ranked Schools And One Of The Region's Most In-Demand Family Neighbourhoods. Families Move Here For The Schools And Stay For The Trails, Parks, And True Community Feel -And This Detached 4+1 Bedroom, 4 Bathroom Home Puts You Right In The Heart Of It All. Offering Over 3,000 Sq Ft Of Finished Living Space, A Double Garage, And A Finished Basement With Separate Entrance, This Home Checks Every Box On The Family Wish List - And With Vacant Immediate Possession, You Can Be Settled Before The New School Term Begins. The Bright Open-Concept Main Floor Features Hardwood Floors, Pot Lights, And Large Windows Throughout, While The Chef-Inspired Kitchen Impresses With Quartz Counters, Stainless Steel Appliances, And An Oversized Centre Island Built For Busy Mornings And Weekend Gatherings Alike. Upstairs, The Spacious Primary Retreat Offers A Walk-In Closet And Private Ensuite, Joined By Generously Sized Bedrooms - Including A Rare Jr. Primary-Style Bedroom Perfect For Older Kids, Guests Extended Family, Or A Quiet Home Office. The Finished Lower Level Extends The Living Space With A Full Bedroom, 3-Piece Bath, Large Rec Room, And Separate Entrance Opening The Door To In-Law Suite Or Income Potential. Vacant, Easy To Show, And Ready For Immediate Closing. Space, Schools, And Value Rarely Line Up Like This In Waterloo. Don't Let This One Get Away! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T23:00:03.833971+00:00"
+"Directions": "Columbia St W and Ladyslipper Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976739"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "34.1 x 98.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-22T20:36:31Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T20:36:31Z"
+"Stories": "2.5"
+"StreetName": "Buttonbush"
+"StreetNumber": "274"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "6315.55"
+"VirtualTourURLUnbranded": "https://sites.happyhousegta.com/274buttonbushstreet"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30067509/274-buttonbush-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 34.1
+"OriginalEntryTimestamp": "2026-07-22T20:36:31.77Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1263079"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30067509')"
+"ID": "1650445"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25497
+post_id: "1650037"
+post_author: 1
+"ListingKey": "30067297"
+"ListingId": "40850419"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T00:30:01Z"
+"RFModificationTimestamp": "2026-07-24T00:31:38Z"
+"ListPrice": 755000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5N5"
+"UnparsedAddress": "402 MIDWOOD Crescent, Waterloo, Ontario N2L5N5"
+"Coordinates": array:2 [
0 => -80.5536715
1 => 43.456899
]
+"Latitude": 43.456899
+"Longitude": -80.5536715
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Client Remarks Excellent investment opportunity in Prime Location in Waterloo! This beautifully updated, licensed rental property offers a turnkey opportunity in one of the city's most sought-after student rental locations. Featuring recent renovations through out. The seller is currently completing the conversion of the lower level into a legal 3-bedroom secondary suite, creating even greater rental potential making it a total of 6 Bedrooms which is not common in the city, Two Kitchens, Two Sets of Laundry with separate Entrance and maximizing future income opportunities. Ideally located just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga College, public transit, shopping, restaurants, and everyday amenities, this property is perfectly suited for students and investors alike. Seller has owned this property for more than 20 years and it has been consistently leased year after year. (id:62650)"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T20:44:19.513703+00:00"
+"Directions": "KEATSWAY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932389"
+"ListOfficeKey": "190426"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-24T00:22:05Z"
+"PhotosCount": 13
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T00:29:19Z"
+"Stories": "1.0"
+"StreetName": "MIDWOOD"
+"StreetNumber": "402"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "4042"
+"Utilities": array:1 [
0 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30067297/402-midwood-crescent-waterloo"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-07-22T20:08:20Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1232756"
+"ListOfficeNationalAssociationId": "1213294"
+"Media": array:13 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30067297')"
+"ID": "1650037"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23542
+post_id: "1649189"
+post_author: 1
+"ListingKey": "30066738"
+"ListingId": "40850366"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T03:35:25Z"
+"RFModificationTimestamp": "2026-07-23T03:39:04Z"
+"ListPrice": 949999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1717.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2T4"
+"UnparsedAddress": "553 BLUE BEECH Boulevard, Waterloo, Ontario N2V2T4"
+"Coordinates": array:2 [
0 => -80.5942896
1 => 43.4684464
]
+"Latitude": 43.4684464
+"Longitude": -80.5942896
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "*** For more information, please click Brochure button. *** This unique abode backs to the most vast scenic forest trails and fronts no direct house across the street so you never have to risk an awkward encounter with a peeping neighbor, truly the most exceptional privacy. Being on high ground is also very advantageous with how much flooding is seen through the region in early spring. The sump pump has never had to work a day in its life. A second private entrance to the house leads to an incredibly spacious and finished basement, just the right amount of segregation for lending provisions to a studying/working kin or renting to generate some side income. Finally, save more utilities with the addition of a newly installed, high efficiency heat pump (2024). All in all 100% carpet free, pet free, open concept, and turnkey. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Central Vacuum - Roughed In"
10 => "Hood Fan"
11 => "Window Coverings"
12 => "Garage door opener"
]
+"AssociationFeeFrequency": "Monthly"
+"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-22T20:02:18.021489+00:00"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2220194"
+"ListOfficeKey": "296937"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-22T23:03:22Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T03:28:31Z"
+"Stories": "2.0"
+"StreetName": "BLUE BEECH"
+"StreetNumber": "553"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "5141.81"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30066738/553-blue-beech-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1717
+"OriginalEntryTimestamp": "2026-07-22T18:38:05.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1464325"
+"ListOfficeNationalAssociationId": "1464303"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30066738')"
+"ID": "1649189"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25505
+post_id: "1649042"
+post_author: 1
+"ListingKey": "30065970"
+"ListingId": "40848982"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:10:07Z"
+"RFModificationTimestamp": "2026-07-23T16:26:37Z"
+"ListPrice": 587000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2478.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2T2Y7"
+"UnparsedAddress": "555 CHABLIS Drive Unit# 36, Waterloo, Ontario N2T2Y7"
+"Coordinates": array:2 [
0 => -80.5740634
1 => 43.4487988
]
+"Latitude": 43.4487988
+"Longitude": -80.5740634
+"YearBuilt": 2010
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rare end-unit condo townhome in sought-after Clair Hills offers the space and features of a detached home without the upkeep. A double-car garage plus double-wide driveway delivers parking for four — virtually unheard of in condo life. At 2,478 sq. ft. of total finished living area, the layout is generous throughout: open-concept main floor with hardwood, a well-appointed kitchen with gas range, breakfast peninsula, pantry and stainless appliances, three upstairs bedrooms including an oversized primary with walk-in closet and ensuite, upper-level laundry, and a flexible lower level ideal for a family room, office or gym. Move-in ready with 2026 updates including fresh paint, new upstairs carpet and updated lighting, while the bathrooms have been refreshed with new vanities, mirrors, faucets, toilets and coordinated black fixtures. Smart home features include app-based locks, lighting and garage access. Furnace and AC replaced 2023. The end-unit position brings extra windows, privacy and a rear deck overlooking landscaped green space — no street exposure. Steps to The Boardwalk's shops, restaurants, Costco and healthcare, with easy GRT access and 150+ km of trails nearby. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "280"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-22T17:53:32.701198+00:00"
+"Directions": "Ira Needles & Chablis"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1930634"
+"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"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:02:56Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:02:56Z"
+"Stories": "2.0"
+"StreetName": "CHABLIS"
+"StreetNumber": "555"
+"StreetSuffix": "Drive"
+"SubdivisionName": "443 - Columbia Forest/Clair Hills"
+"TaxAnnualAmount": "4956"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_36_555_chablis_dr_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/30065970/555-chablis-drive-unit-36-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R7"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1766
+"BelowGradeFinishedArea": 712
+"OriginalEntryTimestamp": "2026-07-22T17:08:17.78Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1231368"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30065970')"
+"ID": "1649042"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25506
+post_id: "1645492"
+post_author: 1
+"ListingKey": "30060616"
+"ListingId": "40849370"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T15:00:04Z"
+"RFModificationTimestamp": "2026-07-22T15:26:40Z"
+"ListPrice": 519000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1274.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5N4"
+"UnparsedAddress": "435A MIDWOOD Crescent, Waterloo, Ontario N2L5N4"
+"Coordinates": array:2 [
0 => -80.5555294
1 => 43.4561142
]
+"Latitude": 43.4561142
+"Longitude": -80.5555294
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Beechwood Living with duplex potential! Tucked away in one of Waterloo’s most sought-after neighbourhoods, this immaculate 4 bedroom, 2 bathroom freehold semi-detached home offers the perfect blend of style, space, and nature. Step inside to discover updated flooring and a large kitchen featuring a sleek glass-tile backsplash and stainless steel sink. Love to entertain or unwind? Bright sliding glass doors open onto an expansive, fully fenced backyard situated on a deep, wooded lot complete with a storage shed for all your gear. The finished lower level recreation room boasts a convenient separate side entrance, a full bathroom, and laundry, offering fantastic flexibility for additional living space or guest quarters. With private parking for 3 cars and an unbeatable location, this home is an opportunity you don't want to miss! New furnace Installed in November 2021, New humidifier 2025. Roof updates in 2015 and new eavestroughs and aluminium siding covering installed March 2026. Windows 2014. General Electrical Inspection dated Aug 2023 and HVAC Inspection dated Sep 2024. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T17:18:43.202599+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1914828"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-22T14:53:47Z"
+"PhotosCount": 33
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T14:59:47Z"
+"Stories": "2.0"
+"StreetName": "MIDWOOD"
+"StreetNumber": "435"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "417 - Beechwood/University"
+"TaxAnnualAmount": "3480"
+"VirtualTourURLUnbranded": "http://www.tylerodonovan.com/"
+"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/30060616/435a-midwood-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1274
+"OriginalEntryTimestamp": "2026-07-21T16:38:14.76Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1224120"
+"ListOfficeNationalAssociationId": "1384313"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30060616')"
+"ID": "1645492"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 112
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]