array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30048928 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23473
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23475
+post_id: "1635926"
+post_author: 1
+"ListingKey": "30048928"
+"ListingId": "40849174"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T13:55:18Z"
+"RFModificationTimestamp": "2026-07-18T14:00:09Z"
+"ListPrice": 1249990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2768.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A2"
+"UnparsedAddress": "88 VALLEY Trail, Waterdown, Ontario L8B2A2"
+"Coordinates": array:2 [
0 => -79.8763805
1 => 43.3445569
]
+"Latitude": 43.3445569
+"Longitude": -79.8763805
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Valley Trail Place, an exclusive collection of freehold executive townhomes in sought after Waterdown. This 4 bedroom plus den, 4 bathroom home offers 2,768 sq ft of beautifully designed living space with over $50,000 in builder upgrades. The chef-inspired kitchen features stainless steel appliances, an upgraded LG 36 fridge with waterline, upgraded quartz countertops, designer shaker cabinetry, under-cabinet LED lighting, and a walk-in pantry. Expansive windows fill the open-concept living areas with natural light, complemented by 9' ceilings, upgraded vinyl flooring throughout, and pot lights throughout. Upstairs, enjoy the convenience of two ensuite bathrooms featuring upgraded quartz countertops, designer tile, glass shower enclosures, and modern finishes. Additional upgrades include black metal stair spindles with stained oak stairs, upgraded interior doors and trim, an extended rear deck overlooking the ravine, and a walk-out basement. Located just minutes from vibrant downtown Waterdown, you'll enjoy boutique shopping, diverse dining, scenic hiking trails, and convenient access to major highways and transit, including Aldershot GO Station. Don't miss this rare opportunity to own your dream home surrounded by nature's beauty. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T18:53:14.637588+00:00"
+"Directions": "Mallard Trail."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Shared Driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T13:48:07Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T13:48:07Z"
+"Stories": "2.0"
+"StreetName": "VALLEY"
+"StreetNumber": "88"
+"StreetSuffix": "Trail"
+"SubdivisionName": "461 - Waterdown East"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1687638978"
"RoomType" => "Bedroom"
"ListingId" => "40849174"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => "13'2'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.51Z"
]
1 => array:11 [
"RoomKey" => "1687638979"
"RoomType" => "3pc Bathroom"
"ListingId" => "40849174"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.51Z"
]
2 => array:11 [
"RoomKey" => "1687638980"
"RoomType" => "Bedroom"
"ListingId" => "40849174"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.52Z"
]
3 => array:11 [
"RoomKey" => "1687638981"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849174"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.52Z"
]
4 => array:11 [
"RoomKey" => "1687638982"
"RoomType" => "Full bathroom"
"ListingId" => "40849174"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.52Z"
]
5 => array:11 [
"RoomKey" => "1687638983"
"RoomType" => "Primary Bedroom"
"ListingId" => "40849174"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.52Z"
]
6 => array:11 [
"RoomKey" => "1687638984"
"RoomType" => "Bedroom"
"ListingId" => "40849174"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => "14'2'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.52Z"
]
7 => array:11 [
"RoomKey" => "1687638985"
"RoomType" => "Family room"
"ListingId" => "40849174"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 23'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.52Z"
]
8 => array:11 [
"RoomKey" => "1687638986"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40849174"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 23'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.52Z"
]
9 => array:11 [
"RoomKey" => "1687638987"
"RoomType" => "3pc Bathroom"
"ListingId" => "40849174"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.52Z"
]
10 => array:11 [
"RoomKey" => "1687638988"
"RoomType" => "Den"
"ListingId" => "40849174"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30048928"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 8'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-18T13:48:07.53Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30048928/88-valley-trail-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"ZoningDescription": "R6-32"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 2768
+"OriginalEntryTimestamp": "2026-07-17T18:18:20.28Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30048928_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/a59967cfc3d56badf7b604e40ba6dbff.webp"
"MediaSize" => 130695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-a59967cfc3d56badf7b604e40ba6dbff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:15.88Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30048928_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/a2b6247cdb9006cdd197d78508d010be.webp"
"MediaSize" => 119029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-a2b6247cdb9006cdd197d78508d010be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30048928_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/7f699e1d63317b1901e6a2d42bf5a5bd.webp"
"MediaSize" => 45531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-7f699e1d63317b1901e6a2d42bf5a5bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:20.11Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30048928_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/5b83e59d318e674493e3aa18fdd718a2.webp"
"MediaSize" => 59807
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-5b83e59d318e674493e3aa18fdd718a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:19.75Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30048928_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/ddfb46aa31704dd75e5a77b382e72d77.webp"
"MediaSize" => 46258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-ddfb46aa31704dd75e5a77b382e72d77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:20.05Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30048928_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/aafb1bb8320021789d93350613f721d5.webp"
"MediaSize" => 42588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-aafb1bb8320021789d93350613f721d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:19.82Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30048928_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/d386722e66ad986a18022ea5c858c283.webp"
"MediaSize" => 69370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-d386722e66ad986a18022ea5c858c283.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.11Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30048928_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/692b1b59a1b9eeaae76fcfdb0fe004c2.webp"
"MediaSize" => 39693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-692b1b59a1b9eeaae76fcfdb0fe004c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:20.66Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30048928_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/fe2f496bb1b8e69b4ab230626af64628.webp"
"MediaSize" => 54454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-fe2f496bb1b8e69b4ab230626af64628.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:19.75Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30048928_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/4894fb763ed45262856ea86d12b5f30e.webp"
"MediaSize" => 51938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-4894fb763ed45262856ea86d12b5f30e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30048928_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/48589091eba03e041b6617cb72de85ad.webp"
"MediaSize" => 56103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-48589091eba03e041b6617cb72de85ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.49Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30048928_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/c0dc1474bad566170d244b8deb623bbd.webp"
"MediaSize" => 64075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-c0dc1474bad566170d244b8deb623bbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:18.03Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30048928_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/27ab239ef6872a4134ca2bc3552953e8.webp"
"MediaSize" => 56739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-27ab239ef6872a4134ca2bc3552953e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.49Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30048928_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/1f0d4bb9d653f5bf9ec6e64a87726a42.webp"
"MediaSize" => 57715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-1f0d4bb9d653f5bf9ec6e64a87726a42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.54Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30048928_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/5e345dbcbeeb4b184299520696d99e81.webp"
"MediaSize" => 43746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-5e345dbcbeeb4b184299520696d99e81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.46Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30048928_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/a9a8189fe9315077b440fc1e0b351342.webp"
"MediaSize" => 53202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-a9a8189fe9315077b440fc1e0b351342.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.43Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30048928_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/a1d88d83c8669e59330c935e8e47e4b1.webp"
"MediaSize" => 58995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-a1d88d83c8669e59330c935e8e47e4b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:20.06Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30048928_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/260f1d369142f92ceae6c32c7d5bd85e.webp"
"MediaSize" => 147043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-260f1d369142f92ceae6c32c7d5bd85e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.63Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30048928_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/698d6aaffd111c40c56dc0688306f20d.webp"
"MediaSize" => 149673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-698d6aaffd111c40c56dc0688306f20d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.44Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30048928_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/d236ea659533eb3632c1e30ffbbde40b.webp"
"MediaSize" => 150545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-d236ea659533eb3632c1e30ffbbde40b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.67Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30048928_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/57950e2758ad8440cce1949034619dd1.webp"
"MediaSize" => 140449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-57950e2758ad8440cce1949034619dd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:19.82Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30048928_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/f01e9418f1064042ca3813f8c6d96f21.webp"
"MediaSize" => 56878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-f01e9418f1064042ca3813f8c6d96f21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.44Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30048928_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/45ccf5e539148730f860527463d16623.webp"
"MediaSize" => 54312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-45ccf5e539148730f860527463d16623.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:19.75Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30048928_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/eda4801554cd0b7f8f01ade9f30d377d.webp"
"MediaSize" => 49091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-eda4801554cd0b7f8f01ade9f30d377d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:19.75Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30048928_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/558ebee123d9e18449aad6aa0faa1fa8.webp"
"MediaSize" => 46958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-558ebee123d9e18449aad6aa0faa1fa8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:17.49Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30048928_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/5c020bf1e7af5a2e52752003b9360604.webp"
"MediaSize" => 48409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-5c020bf1e7af5a2e52752003b9360604.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:32.77Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30048928_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/724ba9b412ab862784e825c0580d4c24.webp"
"MediaSize" => 46688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-724ba9b412ab862784e825c0580d4c24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.17Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30048928_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/4d1ae4feb6272bf81982ebd484f342a7.webp"
"MediaSize" => 48142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-4d1ae4feb6272bf81982ebd484f342a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.17Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30048928_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/62fa860d20e43e0f8ec6ad5ecc12e2ed.webp"
"MediaSize" => 49097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-62fa860d20e43e0f8ec6ad5ecc12e2ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.22Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30048928_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/375a202face6020512bc0a9179db839c.webp"
"MediaSize" => 51048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-375a202face6020512bc0a9179db839c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.17Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30048928_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/b2e2396535c3b81e4c4895a1c1e30404.webp"
"MediaSize" => 52517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-b2e2396535c3b81e4c4895a1c1e30404.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.17Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30048928_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/baa52e9399ee53ea4dd8c9daacf95906.webp"
"MediaSize" => 43891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-baa52e9399ee53ea4dd8c9daacf95906.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.18Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30048928_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/63370d1ef2876cf84a6965c8d562076a.webp"
"MediaSize" => 50757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-63370d1ef2876cf84a6965c8d562076a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.34Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30048928_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/4ffdd6f359fe2f62d70e4d4c7729c275.webp"
"MediaSize" => 34142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-4ffdd6f359fe2f62d70e4d4c7729c275.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.19Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30048928_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/76c4191a73361a2e4b3d846914e5a480.webp"
"MediaSize" => 42471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-76c4191a73361a2e4b3d846914e5a480.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:23Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30048928_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/ad7e3d8ec30841bc02718b0d8be248cd.webp"
"MediaSize" => 42858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-ad7e3d8ec30841bc02718b0d8be248cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.18Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30048928_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/2b8562a1373a36ff4229d93b855e1b76.webp"
"MediaSize" => 44584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-2b8562a1373a36ff4229d93b855e1b76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.27Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30048928_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/1dfa0460c1ba94b73b1b434c1ca3f2a8.webp"
"MediaSize" => 32947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-1dfa0460c1ba94b73b1b434c1ca3f2a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.2Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30048928_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/8fb9b881a1249a00c4275f97725f851a.webp"
"MediaSize" => 41461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-8fb9b881a1249a00c4275f97725f851a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.67Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30048928_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/494120071cc83ff6c0f47f7ee34749d9.webp"
"MediaSize" => 42349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-494120071cc83ff6c0f47f7ee34749d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:23.01Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30048928_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/4e86f7cd9b5bc57dca42990aab53af1d.webp"
"MediaSize" => 43315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-4e86f7cd9b5bc57dca42990aab53af1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:23.01Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30048928_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/f4abcea49264cbcb12ce5856768a1d9e.webp"
"MediaSize" => 47712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-f4abcea49264cbcb12ce5856768a1d9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.17Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30048928_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/2bab5b810067a62ea419c38077a17c44.webp"
"MediaSize" => 34793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-2bab5b810067a62ea419c38077a17c44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.17Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30048928_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/9c7a386aef4a528a6da851db99d503f2.webp"
"MediaSize" => 52815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-9c7a386aef4a528a6da851db99d503f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:24.11Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "30048928_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/3432003bddb261633f1be38ddae03871.webp"
"MediaSize" => 52796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-3432003bddb261633f1be38ddae03871.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:23Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "30048928_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/8b08c538d9ec95caa36c599f1c899afb.webp"
"MediaSize" => 52347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-8b08c538d9ec95caa36c599f1c899afb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:23.46Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "30048928_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/1df407d81d454182d262abd01037b811.webp"
"MediaSize" => 46438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-1df407d81d454182d262abd01037b811.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:23Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "30048928_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/6247457f05df8ca12d068bc366d2425e.webp"
"MediaSize" => 140095
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-6247457f05df8ca12d068bc366d2425e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:21.17Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "30048928_4890_49"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/4ddca8d798e86dc7b13991852e42ff9a.webp"
"MediaSize" => 164229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-4ddca8d798e86dc7b13991852e42ff9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:22.86Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "30048928_4890_50"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30048928/fa573deac598cb9aab7c564aa56b7128.webp"
"MediaSize" => 153189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30048928/thumbnail-fa573deac598cb9aab7c564aa56b7128.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849174"
"ResourceRecordKey" => "30048928"
"ModificationTimestamp" => "2026-07-18T13:31:23Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30048928')"
+"ID": "1635926"
}
]
+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 284639" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25013
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24921
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-631-8118"
+"OfficeMlsId": "HBREMAESBR1A"
+"ModificationTimestamp": "2026-06-18T15:38:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "284639"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "502 Brant Street Unit 1A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7R2G"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1344653"
+"OriginalEntryTimestamp": "2019-01-30T21:05:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439642"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "284639"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2026-06-18T14:28:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('284639')"
}
]
+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 2007461" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24994
+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 '30048928'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25326
+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 '30048928' AND OpenHouseDate ge '2026-07-19'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25342
+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 '30048928' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8763805 43.3445569)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25415
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25409
+post_id: "1640551"
+post_author: 1
+"ListingKey": "30053418"
+"ListingId": "X13581880"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T18:10:01Z"
+"RFModificationTimestamp": "2026-07-19T18:42:27Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W5"
+"UnparsedAddress": "279 SKINNER ROAD N, Hamilton (Waterdown), Ontario L8B1W5"
+"Coordinates": array:2 [
0 => -79.877083
1 => 43.340355
]
+"Latitude": 43.340355
+"Longitude": -79.877083
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover stylish, low-maintenance living in this beautifully maintained, sun-filled condo townhome nestled in the highly desirable East Waterdown community. Boasting soaring 9-foot ceilings and a unique open-concept design, this home offers an inviting blend of space, natural light, and everyday functionality. The spacious eat-in kitchen is designed for both entertaining and daily living, featuring stainless steel appliances, abundant cabinetry, generous prep space, and a walk-out to a private balcony-perfect for morning coffee, evening sunsets, or summer BBQs. Upstairs, you'll find two generously sized bedrooms, each with its own private ensuite, including a spacious primary retreat with a 4-piece bath and a second bedroom with a 3-piece ensuite-an ideal layout for families, guests, or professionals seeking added privacy. Enjoy the convenience of an attached garage with inside entry, plus parking for up to three vehicles-a rare and valuable feature. Low condo fees make ownership even more affordable while allowing you to enjoy a carefree, low-maintenance lifestyle. Located in one of Waterdown's most sought-after neighbourhoods, you're just minutes from top-rated schools, scenic parks and trails, shopping, restaurants, the GO Station, major highways, downtown Waterdown, and Burlington, offering the perfect balance of small-town charm and effortless connectivity. Whether you're a first-time buyer, downsizer, busy professional, or savvy investor, this move-in-ready home delivers exceptional value, comfort, and lifestyle in an outstanding location. Simply unpack and enjoy. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Humidifier"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
10 => "Water Heater - Tankless"
11 => "Water Heater"
]
+"AssociationFee": "194.39"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-07-19T18:42:15.396330+00:00"
+"Directions": "Cross Streets: Dundas/Mallard/Skinner. ** Directions: South of Dundas at Mallard & Skinner Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1660663"
+"ListOfficeKey": "93711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-19T18:03:24Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T18:03:24Z"
+"Stories": "3.0"
+"StreetDirSuffix": "North"
+"StreetName": "Skinner"
+"StreetNumber": "279"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4497.87"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/279-skinner-road-hamilton-l8b-1w5/nb/"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1688696074"
"RoomType" => "Foyer"
"ListingId" => "X13581880"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.0
"ListingKey" => "30053418"
"RoomLength" => 6.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-19T18:03:24.74Z"
]
1 => array:11 [
"RoomKey" => "1688696075"
"RoomType" => "Living room"
"ListingId" => "X13581880"
"RoomLevel" => "Main level"
"RoomWidth" => 3.0
"ListingKey" => "30053418"
"RoomLength" => 6.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-19T18:03:24.74Z"
]
2 => array:11 [
"RoomKey" => "1688696076"
"RoomType" => "Kitchen"
"ListingId" => "X13581880"
"RoomLevel" => "Second level"
"RoomWidth" => 2.95
"ListingKey" => "30053418"
"RoomLength" => 6.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-19T18:03:24.74Z"
]
3 => array:11 [
"RoomKey" => "1688696077"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13581880"
"RoomLevel" => "Third level"
"RoomWidth" => 2.95
"ListingKey" => "30053418"
"RoomLength" => 3.95
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-19T18:03:24.74Z"
]
4 => array:11 [
"RoomKey" => "1688696078"
"RoomType" => "Bedroom 2"
"ListingId" => "X13581880"
"RoomLevel" => "Third level"
"RoomWidth" => 2.96
"ListingKey" => "30053418"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-19T18:03:24.74Z"
]
5 => array:11 [
"RoomKey" => "1688696079"
"RoomType" => "Laundry room"
"ListingId" => "X13581880"
"RoomLevel" => "Second level"
"RoomWidth" => 1.06
"ListingKey" => "30053418"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-19T18:03:24.74Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30053418/279-skinner-road-n-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "WENTWORTH STANDARD"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Separate Electricity Meters"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-19T18:03:24.72Z"
+"ListAgentNationalAssociationId": "1167703"
+"ListOfficeNationalAssociationId": "1158326"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30053418_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053418/65b4a9b20495083560c66451a353c97a.webp"
"MediaSize" => 420210
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053418/thumbnail-65b4a9b20495083560c66451a353c97a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13581880"
"ResourceRecordKey" => "30053418"
"ModificationTimestamp" => "2026-07-19T18:03:24.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30053418_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053418/e431111c9643551d09e09aed61af69e5.webp"
"MediaSize" => 462415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053418/thumbnail-e431111c9643551d09e09aed61af69e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13581880"
"ResourceRecordKey" => "30053418"
"ModificationTimestamp" => "2026-07-19T18:03:24.72Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30053418_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053418/2fc2e7d5d37f3987cc953d3a178a77be.webp"
"MediaSize" => 223391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053418/thumbnail-2fc2e7d5d37f3987cc953d3a178a77be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13581880"
"ResourceRecordKey" => "30053418"
"ModificationTimestamp" => "2026-07-19T18:03:24.72Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30053418_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053418/a8d793eb12bd7b32d13b4ef39f1e1d0d.webp"
"MediaSize" => 216608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30053418/thumbnail-a8d793eb12bd7b32d13b4ef39f1e1d0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13581880"
"ResourceRecordKey" => "30053418"
"ModificationTimestamp" => "2026-07-19T18:03:24.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30053418_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30053418/74b661ad6d95ad2eaae0f022afc3d30d.webp"
"MediaSize" => 178893
…9
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30053418')"
+"ID": "1640551"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25411
+post_id: "1638001"
+post_author: 1
+"ListingKey": "30039464"
+"ListingId": "40848631"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:15:11Z"
+"RFModificationTimestamp": "2026-07-17T23:28:59Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2300.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B0Y5"
+"UnparsedAddress": "286 SPRING CREEK Drive, Waterdown, Ontario L8B0Y5"
+"Coordinates": array:2 [
0 => -79.8854648
1 => 43.3500505
]
+"Latitude": 43.3500505
+"Longitude": -79.8854648
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 2,300 sq. ft. family home in the heart of Waterdown! Offering 3 spacious bedrooms, 3 bathrooms, and a versatile second-floor loft that can easily serve as a 4th bedroom, home office, or second living space, this home is designed to grow with your family. Step inside to a bright, open-concept layout featuring rich hardwood flooring, a cozy gas fireplace, and an abundance of natural light. The chef-inspired kitchen boasts stainless steel appliances, a large centre island, and plenty of workspace, flowing seamlessly into the dining area with walkout access to the spacious backyard-perfect for entertaining family and friends. Upstairs, the primary retreat offers a generous walk-in closet and a spa-like ensuite. Two additional bedrooms, a beautifully appointed 4-piece bathroom, convenient second-floor laundry, and the bonus loft complete the upper level. The unspoiled basement provides endless possibilities to create the space you've always envisioned. Complete with a double-car garage and ideally located close to parks, schools, shopping, downtown Waterdown, and everyday amenities, this exceptional home offers the perfect combination of style, comfort, and convenience. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:28:56.204263+00:00"
+"Directions": "Parkside Drive and Spring Creek Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908213"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Country residential"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-15T23:02:14Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:08:57Z"
+"Stories": "2.0"
+"StreetName": "SPRING CREEK"
+"StreetNumber": "286"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6339"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30039464/286-spring-creek-drive-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-70"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2300
+"OriginalEntryTimestamp": "2026-07-15T22:59:23.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1221145"
+"ListOfficeNationalAssociationId": "1333115"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30039464')"
+"ID": "1638001"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25408
+post_id: "1637788"
+post_author: 1
+"ListingKey": "30044105"
+"ListingId": "40848896"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:20:10Z"
+"RFModificationTimestamp": "2026-07-17T23:18:16Z"
+"ListPrice": 514900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 775.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "460 DUNDAS Street E Unit# 1109, Waterdown, Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.8784862
1 => 43.3440765
]
+"Latitude": 43.3440765
+"Longitude": -79.8784862
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown — a beautifully designed corner-unit condo built in 2023 that perfectly blends modern style, comfort, and convenience. Offering approximately 750 sq. ft. of thoughtfully designed living space, this stunning unit features soaring 9-ft ceilings, upscale finishes, and a bright open-concept layout tailored for today’s lifestyle. Designed with both style and functionality in mind, this stunning unit features 2 spacious bedrooms, 1 elegant bathroom, in-suite laundry, and a walk-in closet. Expansive windows throughout flood the home with an abundance of natural light, creating a warm, airy, and inviting atmosphere from the moment you step inside. The contemporary kitchen is sure to impress with sleek custom cabinetry, designer fixtures, stylish backsplash, and modern finishes, while the spa-inspired bathroom showcases quartz countertops and premium detailing throughout. Step outside onto your private balcony — the perfect space to enjoy your morning coffee or unwind after a long day. This pet-friendly building offers exceptional amenities including geothermal heating and cooling for energy-efficient living, a fully equipped fitness centre, party room, rooftop terrace, secure entry, professional management, an owned locker, and 1 owned underground parking space — a rare and highly sought-after feature in condo living. Perfectly situated close to parks, shopping, restaurants, transit, schools, and major highways, this prime location offers effortless convenience while being nestled within one of Waterdown’s most desirable communities. Whether you’re a first-time buyer, downsizer, or investor, this is an incredible opportunity to own a stylish, low-maintenance condo that truly checks all the boxes. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Oven - Built-In"
7 => "Hood Fan"
8 => "Microwave Built-in"
]
+"AssociationFee": "551.4"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
3 => "Other, See Remarks"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:18:08.491184+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2147312"
+"ListOfficeKey": "289424"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-17T15:02:55Z"
+"PhotosCount": 39
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:08:30Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3340"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30044105/460-dundas-street-e-unit-1109-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 775
+"OriginalEntryTimestamp": "2026-07-16T19:59:56.28Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1398385"
+"ListOfficeNationalAssociationId": "1377637"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30044105')"
+"ID": "1637788"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25412
+post_id: "1637166"
+post_author: 1
+"ListingKey": "30032062"
+"ListingId": "40848087"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T18:05:13Z"
+"RFModificationTimestamp": "2026-07-19T18:09:13Z"
+"ListPrice": 369990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 585.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 904, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.8804385
1 => 43.342509
]
+"Latitude": 43.342509
+"Longitude": -79.8804385
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning 1 bed, 1 bath condo showcasing a bright, open-concept design with modern finishes throughout. Featuring an upgraded kitchen with stainless steel appliances, a spacious island with built-in storage, and elegant pendant lighting, this unit flows effortlessly into the sun-filled living area with expansive windows and beautiful views. The generous bedroom is complemented by a contemporary 4-piece bath and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Enjoy premium building amenities including a party room, gym, rooftop patios, and bike storage. Ideally located in the sought-after Waterdown community, just minutes to dining, shopping, parks, and a quick 5-minute drive to downtown Burlington or Aldershot GO Station. Book your private showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "553.7"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"CreationDate": "2026-07-17T21:04:18.509410+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-19T18:01:32Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T18:01:32Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2717.19"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30032062/470-dundas-street-e-unit-904-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 585
+"OriginalEntryTimestamp": "2026-07-14T18:48:15.74Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30032062')"
+"ID": "1637166"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25410
+post_id: "1636997"
+post_author: 1
+"ListingKey": "30031287"
+"ListingId": "40847887"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-19T18:05:13Z"
+"RFModificationTimestamp": "2026-07-19T18:09:13Z"
+"ListPrice": 369990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 585.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1Z2"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 804, Waterdown, Ontario L8B1Z2"
+"Coordinates": array:2 [
0 => -79.8804822
1 => 43.342526
]
+"Latitude": 43.342526
+"Longitude": -79.8804822
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful 1 bed, 1 bath condo offering a bright, open-concept layout with modern finishes throughout. The stylish kitchen features stainless steel appliances, a breakfast bar, and contemporary cabinetry, flowing effortlessly into the spacious living area with large windows and plenty of natural light. The well-sized bedroom offers comfort and great views, complemented by a sleek 4-piece bathroom and convenient in-suite laundry. Includes storage locker and 1 underground parking space. Residents have access to excellent amenities including a party room, gym, rooftop patios, and bike storage. Located in the highly desirable Waterdown community, close to dining, shopping, schools, parks, and just a 5-minute drive to downtown Burlington or Aldershot GO Station. Book your private showing today! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "553.7"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"CreationDate": "2026-07-17T20:46:50.615929+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Heating": array:1 [
0 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2007461"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "Open"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-19T18:01:27Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-19T18:01:27Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "2717.19"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30031287/470-dundas-street-e-unit-804-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1931240"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 585
+"OriginalEntryTimestamp": "2026-07-14T17:18:16.02Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1289513"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1252488"
+"CoListOfficeNationalAssociationId": "1306586"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30031287')"
+"ID": "1636997"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25405
+post_id: "1636875"
+post_author: 1
+"ListingKey": "30040002"
+"ListingId": "40848382"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T20:30:03Z"
+"RFModificationTimestamp": "2026-07-17T20:31:30Z"
+"ListPrice": 1500000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2700.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "39 AVANTI Crescent, Waterdown, Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8829439
1 => 43.334933
]
+"Latitude": 43.334933
+"Longitude": -79.8829439
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional Starlane built executive home, ideally located on a quiet crescent in the highly desirable Mountainview Heights community of Waterdown. Surrounded by beautiful homes and welcoming neighbours, this family friendly neighbourhood offers parks, playgrounds, scenic trails and sought after schools. Enjoy easy access to shopping, restaurants, GO Transit, major highways and the Niagara Escarpment, making this the perfect place to enjoy both convenience and an active lifestyle. Offering approximately 4,000 sq. ft. of finished living space, including a professionally finished basement, this meticulously maintained home showcases approximately $350K in upgrades. Designed for family living and entertaining, the main floor features an elegant dining room with butler's pantry, upgraded kitchen with granite countertops, premium appliances and a spacious family room overlooking the backyard oasis. Upstairs offers a rare layout with four spacious bedrooms, including two private primary retreats, each with a walk in closet and ensuite bathroom. The additional bedrooms share a convenient Jack and Jill bathroom, creating an ideal setup for families. The finished basement adds two bedrooms, a full bathroom, large recreation room and ample storage, providing exceptional flexibility for guests, teens or extended family. The south facing backyard is a private retreat featuring a heated saltwater in ground pool with non slip concrete surround, professionally installed trench drains, custom cedar gazebo, elevated deck with natural gas BBQ hookup and beautifully landscaped grounds. Perfect for entertaining, relaxing and creating lasting memories with family and friends throughout the summer months. A rare opportunity to own a beautifully upgraded Starlane home in one of Waterdown's most desirable communities, offering exceptional space, privacy and a lifestyle you'll love. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "School Bus"
1 => "Community Centre"
2 => "Industrial Park"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T20:31:12.312980+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1902312"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T20:23:39Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T20:23:39Z"
+"Stories": "2.0"
+"StreetName": "AVANTI"
+"StreetNumber": "39"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8891.77"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/39-Avanti-Cres"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30040002/39-avanti-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "R1-62"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 2700
+"OriginalEntryTimestamp": "2026-07-16T01:59:04.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1218041"
+"ListOfficeNationalAssociationId": "1473831"
+"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": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30040002')"
+"ID": "1636875"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23487
+post_id: "1636876"
+post_author: 1
+"ListingKey": "30049464"
+"ListingId": "X13578020"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-18T14:10:01Z"
+"RFModificationTimestamp": "2026-07-18T14:10:38Z"
+"ListPrice": 1249990.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A2"
+"UnparsedAddress": "88 VALLEY TRAIL PLACE, Hamilton (Waterdown), Ontario L8B2A2"
+"Coordinates": array:2 [
0 => -79.875868
1 => 43.344656
]
+"Latitude": 43.344656
+"Longitude": -79.875868
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Valley Trail Place, an exclusive collection of freehold executive townhomes in sought after Waterdown. This 4 bedroom plus den, 4 bathroom home offers 2,768 sq ft of beautifully designed living space with over $50,000 in builder upgrades. The chef-inspired kitchen features stainless steel appliances, an upgraded LG 36" fridge with waterline, upgraded quartz countertops, designer shaker cabinetry, under-cabinet LED lighting, and a walk-in pantry. Expansive windows fill the open-concept living areas with natural light, complemented by 9' ceilings, upgraded vinyl flooring throughout, and pot lights throughout. Upstairs, enjoy the convenience of two ensuite bathrooms featuring upgraded quartz countertops, designer tile, glass shower enclosures, and modern finishes. Additional upgrades include black metal stair spindles with stained oak stairs, upgraded interior doors and trim, an extended rear deck overlooking the ravine, and a walk-out basement. Located just minutes from vibrant downtown Waterdown, you'll enjoy boutique shopping, diverse dining, scenic hiking trails, and convenient access to major highways and transit, including Aldershot GO Station. Don't miss this rare opportunity to own your dream home surrounded by nature's beauty. (id:62650)"
+"Basement": array:2 [
0 => "Full"
1 => "Walk out"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T19:39:08.890497+00:00"
+"Directions": "Cross Streets: Mallard Trail. ** Directions: Dundas St E - Mallard Trail - Valley Trail Place."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2092595"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Ravine"
]
+"LotSizeDimensions": "24.6 x 115.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-18T14:03:13Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-18T14:03:13Z"
+"Stories": "2.0"
+"StreetName": "Valley Trail"
+"StreetNumber": "88"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30049464/88-valley-trail-place-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2026-07-17T19:09:33.32Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1365159"
+"ListOfficeNationalAssociationId": "1344892"
+"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('30049464')"
+"ID": "1636876"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25413
+post_id: "1633673"
+post_author: 1
+"ListingKey": "30045689"
+"ListingId": "X13574556"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T13:45:02Z"
+"RFModificationTimestamp": "2026-07-17T13:48:55Z"
+"ListPrice": 419999.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "209 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879636
1 => 43.343264
]
+"Latitude": 43.343264
+"Longitude": -79.879636
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 209 at 460 Dundas Street East, where smart design meets effortless living in the heart of Waterdown. Perfectly positioned on the second floor, this thoughtfully laid-out 1-bedroom + den, 1-bathroom condo offers the ideal blend of comfort, function, and style, whether you're planting your first roots or simplifying your next chapter. The sleek Hollywood kitchen is a showstopper, featuring stainless steel appliances and clean lines that make cooking and entertaining a breeze. The open-concept living space flows seamlessly onto your oversized private balcony, accessible from both the living room and the bedroom, giving you two ways to step out and enjoy the fresh air morning or night. The versatile den provides the flexibility you need: a home office, reading nook, or guest space; the choice is yours. In-suite stacked laundry adds everyday convenience, and your dedicated storage locker is conveniently located right on the same floor as the unit. A private underground parking space rounds out the package, keeping your vehicle secure through every season. Beyond your front door, everything you need is within minutes. Dundas Street's vibrant shopping corridor, including Walmart Supercenter, Waterdown Shopping Centre, cafés, restaurants, and local boutiques, is just steps away. Commuters will love being minutes from GO Transit, making downtown Hamilton and beyond easily accessible without the stress. Low-maintenance living at its finest. Move in, settle in, and enjoy everything Waterdown has to offer. Don't miss your opportunity. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"AssociationFee": "542.07"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T00:43:28.920316+00:00"
+"Directions": "Cross Streets: Dundas & Riverwalk Drive. ** Directions: GPS."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1882428"
+"ListOfficeKey": "299835"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-17T00:08:30Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T13:39:05Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "2901.85"
+"View": "View"
+"VirtualTourURLUnbranded": "https://tourwizard.net/592450e2/nb/"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30045689/209-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residentials"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Recreation Centre"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-17T00:08:30.39Z"
+"ListAgentNationalAssociationId": "1207252"
+"ListOfficeNationalAssociationId": "1477585"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30045689')"
+"ID": "1633673"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25414
+post_id: "1632862"
+post_author: 1
+"ListingKey": "30044621"
+"ListingId": "X13573766"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T15:20:06Z"
+"RFModificationTimestamp": "2026-07-17T15:23:03Z"
+"ListPrice": 514900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "1109 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879636
1 => 43.343264
]
+"Latitude": 43.343264
+"Longitude": -79.879636
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Trend Living in the heart of Waterdown - a beautifully designed corner-unit condo built in 2023 that perfectly blends modern style, comfort, and convenience. Offering approximately 750 sq. ft. of thoughtfully designed living space, this stunning unit features soaring 9-ft ceilings, upscale finishes, and a bright open-concept layout tailored for today's lifestyle. Designed with both style and functionality in mind, this stunning unit features 2 spacious bedrooms, 1 elegant bathroom, in-suite laundry, and a walk-in closet. Expansive windows throughout flood the home with an abundance of natural light, creating a warm, airy, and inviting atmosphere from the moment you step inside. The contemporary kitchen is sure to impress with sleek custom cabinetry, designer fixtures, stylish backsplash, and modern finishes, while the spa-inspired bathroom showcases quartz countertops and premium detailing throughout. Step outside onto your private balcony - the perfect space to enjoy your morning coffee or unwind after a long day. This pet-friendly building offers exceptional amenities including geothermal heating and cooling for energy-efficient living, a fully equipped fitness centre, party room, rooftop terrace, secure entry, professional management, an owned locker, and 1 owned underground parking space - a rare and highly sought-after feature in condo living. Perfectly situated close to parks, shopping, restaurants, transit, schools, and major highways, this prime location offers effortless convenience while being nestled within one of Waterdown's most desirable communities. Whether you're a first-time buyer, downsizer, or investor, this is an incredible opportunity to own a stylish, low-maintenance condo that truly checks all the boxes. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Oven - Built-In"
7 => "Hood Fan"
8 => "Garage door opener remote(s)"
9 => "Water Heater - Tankless"
]
+"AssociationFee": "551.4"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-16T23:09:01.819475+00:00"
+"Directions": "Dundas St onto Riverwalk Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2163829"
+"ListOfficeKey": "279481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wheelchair access"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-17T15:11:14Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T15:11:14Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3340"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30044621/1109-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-16T21:09:44.95Z"
+"ListAgentNationalAssociationId": "1414802"
+"ListOfficeNationalAssociationId": "1304915"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30044621')"
+"ID": "1632862"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 147
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]