array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29139051/Property?$select=ALL&$top=20&$filter=ListingKey eq 29139051&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29139051/Property?$select=ALL&$top=20&$filter=ListingKey eq 29139051&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23278
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23280
+post_id: "446149"
+post_author: 1
+"ListingKey": "29139051"
+"ListingId": "40790678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:30:53Z"
+"RFModificationTimestamp": "2025-11-26T18:54:09Z"
+"ListPrice": 1299900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2870.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "107 AVANTI Crescent, Waterdown, Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8819455
1 => 43.3353076
]
+"Latitude": 43.3353076
+"Longitude": -79.8819455
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome To 107 Avanti Crescent, A Beautiful Detached Home On One Of The Most Sought-After Streets In Waterdown's Mountainview Heights Community. With Nearly 3,000 Sq Ft Of Finished Living Space Above Grade, This 4-Bedroom, 3.5-Bath Home Offers A Great Layout And High-End Finishes Throughout. The Entire Home Is Carpet-Free, With Hardwood Flooring On The Main Level, Pot Lights, And A Custom White Shaker Kitchen With Quartz Countertops, An Oversized Island With Seating And Stainless Steel Appliances. The Family Room Is Warm And Welcoming With A Gas Fireplace And Coffered Ceiling. Both The Main And Upper Levels Boast 9 Foot Ceilings & The Home Features California Shutters Throughout. Upstairs, Every Bedroom Has A Walk-In Closet And Access To A Bathroom, Perfect For Families, Including A Spacious Primary Suite With Dual Walk-In Closets And A Luxurious 5-Piece Ensuite. Exterior Pot Lights Surround The Home For Added Curb Appeal. The Unfinished Basement Includes A Rough-In For A Bathroom And Room To Grow. Located Close To Top-Rated Schools, Parks, Trails, And Highways 403/407, This Is A Rare Opportunity To Own A Stunning Home In One Of Waterdown's Best Neighbourhoods. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Central Vacuum - Roughed In"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:53:52.505254+00:00"
+"Directions": "Burke St. South To Kenesky Dr. To Avanti Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2062140"
+"ListOfficeKey": "283666"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:00:20Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:00:20Z"
+"Stories": "2.0"
+"StreetName": "AVANTI"
+"StreetNumber": "107"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "8924.36"
+"VirtualTourURLUnbranded": "https://media.relavix.com/107-avanti-crescent-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1540488388"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.05Z"
]
1 => array:11 [
"RoomKey" => "1540488389"
"RoomType" => "5pc Bathroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
2 => array:11 [
"RoomKey" => "1540488390"
"RoomType" => "3pc Bathroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
3 => array:11 [
"RoomKey" => "1540488391"
"RoomType" => "Bedroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
4 => array:11 [
"RoomKey" => "1540488392"
"RoomType" => "Bedroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
5 => array:11 [
"RoomKey" => "1540488393"
"RoomType" => "Bedroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
6 => array:11 [
"RoomKey" => "1540488394"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790678"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 20'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
7 => array:11 [
"RoomKey" => "1540488395"
"RoomType" => "2pc Bathroom"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
8 => array:11 [
"RoomKey" => "1540488396"
"RoomType" => "Laundry room"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
9 => array:11 [
"RoomKey" => "1540488397"
"RoomType" => "Family room"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
10 => array:11 [
"RoomKey" => "1540488398"
"RoomType" => "Kitchen"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "18'5'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
11 => array:11 [
"RoomKey" => "1540488399"
"RoomType" => "Living room/Dining room"
"ListingId" => "40790678"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29139051"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T18:00:20.06Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29139051/107-avanti-crescent-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2085942"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55165"
+"GeocodeManualYN": true
+"ZoningDescription": "R1 - 64"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 41.0
+"AboveGradeFinishedArea": 2870
+"OriginalEntryTimestamp": "2025-11-26T18:00:20.02Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:43 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341230006"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/aad8bd606b5ead46ce8d0238cc6daaf4.webp"
"MediaSize" => 74997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-aad8bd606b5ead46ce8d0238cc6daaf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341230037"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/c29672c735a88e1aea3e8508ea6d1106.webp"
"MediaSize" => 68398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-c29672c735a88e1aea3e8508ea6d1106.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341230055"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/f81285eaf4a5ae8ec46eec1407337d84.webp"
"MediaSize" => 68270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-f81285eaf4a5ae8ec46eec1407337d84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341230103"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/575377ced9e47e62b7cfa7e3b04b76c8.webp"
"MediaSize" => 78218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-575377ced9e47e62b7cfa7e3b04b76c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341230112"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/7537a9b1274c1056361c6b8dfbe973ab.webp"
"MediaSize" => 75906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-7537a9b1274c1056361c6b8dfbe973ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341230153"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/b2907bb4b2240bb721d9b6f67bd84554.webp"
"MediaSize" => 67078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-b2907bb4b2240bb721d9b6f67bd84554.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6341230202"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/ac1166114925e90bde84d4d1d293d6e7.webp"
"MediaSize" => 52835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-ac1166114925e90bde84d4d1d293d6e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6341230251"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/74eb3b1ca8fb451fc3003d80d60a08d3.webp"
"MediaSize" => 76925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-74eb3b1ca8fb451fc3003d80d60a08d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6341230267"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/239a5f820fd7079c5182dbbac2549f28.webp"
"MediaSize" => 77572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-239a5f820fd7079c5182dbbac2549f28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6341230322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/3ba47da9b1c4b720e21751012041d14f.webp"
"MediaSize" => 147856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-3ba47da9b1c4b720e21751012041d14f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6341230342"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/9214b3aad555e8e158a99c3710dfb77b.webp"
"MediaSize" => 130931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-9214b3aad555e8e158a99c3710dfb77b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6341230384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/8dabb1a87bbccf7b794123afb99a4fa2.webp"
"MediaSize" => 76425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-8dabb1a87bbccf7b794123afb99a4fa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6341230424"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/11d14e0289523a72498aca1a701ec490.webp"
"MediaSize" => 71798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-11d14e0289523a72498aca1a701ec490.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6341230444"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/a5872a8d0cb52bbe390ea77bd4b2fbca.webp"
"MediaSize" => 101011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-a5872a8d0cb52bbe390ea77bd4b2fbca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6341230446"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/3fb2afd9a692e0e09b9ece411d099033.webp"
"MediaSize" => 63140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-3fb2afd9a692e0e09b9ece411d099033.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6341230466"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/a80a54885f4820c10b58e13e35ee53ce.webp"
"MediaSize" => 70636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-a80a54885f4820c10b58e13e35ee53ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6341230491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/776761a2b288715f1a3dc0e261d32fcd.webp"
"MediaSize" => 70744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-776761a2b288715f1a3dc0e261d32fcd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6341230519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/580767cfb748a1ed1a3a92e182e529af.webp"
"MediaSize" => 76914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-580767cfb748a1ed1a3a92e182e529af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6341230539"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/077a116e7fed95984b67784970963b76.webp"
"MediaSize" => 131161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-077a116e7fed95984b67784970963b76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6341230585"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/352f86111f1525c09b854860dfc5b4d4.webp"
"MediaSize" => 77771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-352f86111f1525c09b854860dfc5b4d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6341230637"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/4476b9bf281db7e13a601c7957537704.webp"
"MediaSize" => 69898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-4476b9bf281db7e13a601c7957537704.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6341230666"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/cccf27a9dfdaaef0cd95e72109a43682.webp"
"MediaSize" => 68511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-cccf27a9dfdaaef0cd95e72109a43682.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6341230693"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/05f0ceb2bae507e3dd3d7497fc3da29f.webp"
"MediaSize" => 44632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-05f0ceb2bae507e3dd3d7497fc3da29f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6341230722"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/652e99c19ef494afedf8a4a4e2e3b473.webp"
"MediaSize" => 75764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-652e99c19ef494afedf8a4a4e2e3b473.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6341230764"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/d9337914f3e3a3306c9f4d2f80fa1a0e.webp"
"MediaSize" => 101652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-d9337914f3e3a3306c9f4d2f80fa1a0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6341230808"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/01359064eb150dfcf52326343a83052a.webp"
"MediaSize" => 67330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-01359064eb150dfcf52326343a83052a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6341230817"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/831312116cdd156837558b542146c10d.webp"
"MediaSize" => 150056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-831312116cdd156837558b542146c10d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6341230833"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/69b9719c208efe1a7625b8f3ea394c62.webp"
"MediaSize" => 74047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-69b9719c208efe1a7625b8f3ea394c62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6341230854"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/3ea04ca997c46cf3f93a8654ac9e6976.webp"
"MediaSize" => 62957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-3ea04ca997c46cf3f93a8654ac9e6976.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6341230874"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/ea5a93aea7ae140072de7ea70c9d19e9.webp"
"MediaSize" => 69257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-ea5a93aea7ae140072de7ea70c9d19e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6341230889"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/3a50cdd77d50979600f0ba40a05770d8.webp"
"MediaSize" => 80182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-3a50cdd77d50979600f0ba40a05770d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6341230908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/a390ae119c7e075260d4d002a8a96cf4.webp"
"MediaSize" => 65201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-a390ae119c7e075260d4d002a8a96cf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6341230926"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/6155f9975a3857b03a2084ba85939cca.webp"
"MediaSize" => 70746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-6155f9975a3857b03a2084ba85939cca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6341230948"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/081948856756a2d339359e1864d19133.webp"
"MediaSize" => 67403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-081948856756a2d339359e1864d19133.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6341230974"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/9dd6c340538105113bf6013ede32b0d4.webp"
"MediaSize" => 151325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-9dd6c340538105113bf6013ede32b0d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6341231007"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/2877fa6d103d332ffa55c1254f93e292.webp"
"MediaSize" => 124878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-2877fa6d103d332ffa55c1254f93e292.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6341231024"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/7ed6d38d59f74e42f1a3db8b7b163acf.webp"
"MediaSize" => 94637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-7ed6d38d59f74e42f1a3db8b7b163acf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6341231058"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/07021f4f0655bcfa5de4b2e6c315cc9a.webp"
"MediaSize" => 74891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-07021f4f0655bcfa5de4b2e6c315cc9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6341231083"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/73cd870385040c6460355128f29a9a83.webp"
"MediaSize" => 58047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-73cd870385040c6460355128f29a9a83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6341231099"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/4220477c6987f71b84f119f790d394f9.webp"
"MediaSize" => 71960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-4220477c6987f71b84f119f790d394f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6341231119"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/fe911c81e90b08b09153f14d473f1e6c.webp"
"MediaSize" => 63521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-fe911c81e90b08b09153f14d473f1e6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6341231148"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/5238cafa29d08eab0e4cd70aa8a6580d.webp"
"MediaSize" => 45956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-5238cafa29d08eab0e4cd70aa8a6580d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6341231165"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29139051/330f68b53169f228696525e0953a8cd7.webp"
"MediaSize" => 87909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29139051/thumbnail-330f68b53169f228696525e0953a8cd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790678"
"ResourceRecordKey" => "29139051"
"ModificationTimestamp" => "2025-11-26T18:00:20.03Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139051')"
+"ID": "446149"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283666/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283666&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283666/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283666&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25138
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25140
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-639-7676"
+"OfficeMlsId": "HBRMXESCBU4B"
+"ModificationTimestamp": "2025-07-09T18:36:53Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283666"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2180 Itabashi Way Unit 4B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Burlington"
+"OfficePostalCode": "L7M5A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1333115"
+"OriginalEntryTimestamp": "2018-06-25T18:38:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439661"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283666"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2025-07-09T18:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1201589"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('283666')"
+"Media": []
}
]
+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 2062140/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2062140&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2062140/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2062140&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25143
+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 29139051" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24756
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29139051/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29139051&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29139051/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29139051&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24736
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29139051 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8819455 43.3353076)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29139051 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8819455 43.3353076)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29139051 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8819455 43.3353076)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29139051 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8819455 43.3353076)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24980
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24652
+post_id: "446148"
+post_author: 1
+"ListingKey": "29138861"
+"ListingId": "40790658"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:41:06Z"
+"RFModificationTimestamp": "2025-11-26T19:13:20Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2316.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "225 SKINNER Road, Waterdown, Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.8764705
1 => 43.3410201
]
+"Latitude": 43.3410201
+"Longitude": -79.8764705
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don’t miss this exceptional opportunity to own a rare, end-unit townhome with over 3,200 square feet of total living space — larger than many detached homes! This all-brick beauty blends timeless curb appeal with modern comfort and functionality. The main level features a bright, open layout filled with natural light from the extra end-unit windows, complimented by elegant finishes throughout. The heart of the home is a generous kitchen with matching high-end KitchenAid appliances, including a gas stove, quartz countertops and pot lights. Upstairs, you’ll find four spacious bedrooms, including a fantastic primary suite with a four-piece ensuite and walk-in closet. The kids will love the Jack and Jill bathroom, providing their own ensuite experience! This floor plan is ideal for growing families or hosting guests. Downstairs, the professionally finished walkout basement offers flexible space for a rec room, home gym, office or guest suite — complete with a full bath and bedroom for added convenience. Outside, you’ll fall in love with the extensive landscaping that enhances both curb appeal and privacy. The end-unit location also provides extra green space and a peaceful setting rarely found in townhomes. Meticulously maintained and move-in ready, this home delivers the space of a detached property in the desirable community of Waterdown! Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T19:13:10.094628+00:00"
+"Directions": "Dundas St E to Mallard Tr to Skinner Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T17:30:27Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:30:27Z"
+"Stories": "2.0"
+"StreetName": "SKINNER"
+"StreetNumber": "225"
+"StreetSuffix": "Road"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "7804"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/01985c82-00e4-7304-a6b8-ffaba5553267"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1540473148"
"RoomType" => "Bedroom"
"ListingId" => "40790658"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => "22'0'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.17Z"
]
1 => array:11 [
"RoomKey" => "1540473149"
"RoomType" => "3pc Bathroom"
"ListingId" => "40790658"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.17Z"
]
2 => array:11 [
"RoomKey" => "1540473150"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790658"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.17Z"
]
3 => array:11 [
"RoomKey" => "1540473151"
"RoomType" => "Bedroom"
"ListingId" => "40790658"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.17Z"
]
4 => array:11 [
"RoomKey" => "1540473152"
"RoomType" => "Bedroom"
"ListingId" => "40790658"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.18Z"
]
5 => array:11 [
"RoomKey" => "1540473153"
"RoomType" => "Bedroom"
"ListingId" => "40790658"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.18Z"
]
6 => array:11 [
"RoomKey" => "1540473154"
"RoomType" => "4pc Bathroom"
"ListingId" => "40790658"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.18Z"
]
7 => array:11 [
"RoomKey" => "1540473155"
"RoomType" => "Primary Bedroom"
"ListingId" => "40790658"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.18Z"
]
8 => array:11 [
"RoomKey" => "1540473156"
"RoomType" => "2pc Bathroom"
"ListingId" => "40790658"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.18Z"
]
9 => array:11 [
"RoomKey" => "1540473157"
"RoomType" => "Family room"
"ListingId" => "40790658"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 17'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.19Z"
]
10 => array:11 [
"RoomKey" => "1540473158"
"RoomType" => "Eat in kitchen"
"ListingId" => "40790658"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 23'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.19Z"
]
11 => array:11 [
"RoomKey" => "1540473159"
"RoomType" => "Living room/Dining room"
"ListingId" => "40790658"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29138861"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T17:30:27.19Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29138861/225-skinner-road-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 2316
+"OriginalEntryTimestamp": "2025-11-26T17:30:27.1Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6341171428"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29138861/a8d00daddf123addfffc70969345c6e2.webp"
"MediaSize" => 54320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29138861/thumbnail-a8d00daddf123addfffc70969345c6e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790658"
"ResourceRecordKey" => "29138861"
"ModificationTimestamp" => "2025-11-26T17:30:27.11Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6341171549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29138861/3ac9fe27590558927e637af960a830f8.webp"
"MediaSize" => 79467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29138861/thumbnail-3ac9fe27590558927e637af960a830f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790658"
"ResourceRecordKey" => "29138861"
"ModificationTimestamp" => "2025-11-26T17:30:27.11Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6341171658"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29138861/e48d0ca378d84456f1b4e92206828f54.webp"
"MediaSize" => 148346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29138861/thumbnail-e48d0ca378d84456f1b4e92206828f54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790658"
"ResourceRecordKey" => "29138861"
"ModificationTimestamp" => "2025-11-26T17:30:27.11Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6341171757"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29138861/e634a04727319dca49b4fb84dd746058.webp"
"MediaSize" => 82010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29138861/thumbnail-e634a04727319dca49b4fb84dd746058.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790658"
"ResourceRecordKey" => "29138861"
"ModificationTimestamp" => "2025-11-26T17:30:27.11Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6341171857"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29138861/b1a0e6154a19bb82a90f30c82d3450c4.webp"
"MediaSize" => 78892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29138861/thumbnail-b1a0e6154a19bb82a90f30c82d3450c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40790658"
"ResourceRecordKey" => "29138861"
"ModificationTimestamp" => "2025-11-26T17:30:27.11Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6341171975"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29138861/c1191d5cfeb627185f032258b5a5e7af.webp"
"MediaSize" => 76151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29138861/thumbnail-c1191d5cfeb627185f032258b5a5e7af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138861')"
+"ID": "446148"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24665
+post_id: "445901"
+post_author: 1
+"ListingKey": "29139042"
+"ListingId": "X12578734"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T18:30:53Z"
+"RFModificationTimestamp": "2025-11-26T18:55:40Z"
+"ListPrice": 1349900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1X2"
+"UnparsedAddress": "225 SKINNER ROAD, Hamilton (Waterdown), Ontario L8B1X2"
+"Coordinates": array:2 [
0 => -79.8767129
1 => 43.3408287
]
+"Latitude": 43.3408287
+"Longitude": -79.8767129
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Don't miss this exceptional opportunity to own a rare, end-unit townhome with over 3,200 square feet of total living space - larger than many detached homes! This all-brick beauty blends timeless curb appeal with modern comfort and functionality. The main level features a bright, open layout filled with natural light from the extra end-unit windows, complimented by elegant finishes throughout. The heart of the home is a generous kitchen with matching high-end KitchenAid appliances, including a gas stove, quartz countertops and pot lights. Upstairs, you'll find four spacious bedrooms, including a fantastic primary suite with a four-piece ensuite and walk-in closet. The kids will love the Jack and Jill bathroom, providing their own ensuite experience! This floor plan is ideal for growing families or hosting guests. Downstairs, the professionally finished walkout basement offers flexible space for a rec room, home gym, office or guest suite - complete with a full bath and bedroom for added convenience. Outside, you'll fall in love with the extensive landscaping that enhances both curb appeal and privacy. The end-unit location also provides extra green space and a peaceful setting rarely found in townhomes. Meticulously maintained and move-in ready, this home delivers the space of a detached property in the desirable community of Waterdown! RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T18:54:54.519917+00:00"
+"Directions": "Dundas St E to Mallard Tr to Skinner Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.1 x 91.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T18:00:15Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T18:00:15Z"
+"Stories": "2.0"
+"StreetName": "Skinner"
+"StreetNumber": "225"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7804"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29139042/225-skinner-road-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4-6"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.1
+"OriginalEntryTimestamp": "2025-11-26T18:00:15.15Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29139042')"
+"ID": "445901"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24651
+post_id: "445585"
+post_author: 1
+"ListingKey": "29138080"
+"ListingId": "X12577628"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T14:55:21Z"
+"RFModificationTimestamp": "2025-11-26T17:30:25Z"
+"ListPrice": 459900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "613 - 470 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.878916
1 => 43.343831
]
+"Latitude": 43.343831
+"Longitude": -79.878916
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning 2-bedroom, 1-bath end-unit condo in the sought-after Trend community of Waterdown. This bright, modern suite features 9 ft ceilings, floor-to-ceiling windows, quartz countertops, luxury laminate flooring, and large-format tile in the bath, entry, and laundry areas. Freshly painted with updated lighting throughout. Enjoy energy-efficient geothermal heating and cooling, full-size stainless steel appliances, and exceptional privacy with no neighbouring unit. Includes one underground parking space and a same-floor locker. Building amenities include a gym, party room, rooftop BBQ terrace, and bike storage. A perfect blend of style, comfort, and convenience. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "384.5"
+"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": "2025-11-26T17:30:10.126885+00:00"
+"Directions": "Cross Streets: Dundas Street East and Mallard. ** Directions: Dundas Street East and MallardDundas Street East and Mallard."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970959"
+"ListOfficeKey": "299544"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-26T14:47:57Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T14:47:57Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3120.94"
+"VirtualTourURLUnbranded": "https://viralrealestate.media/470-dundas-st-e-unit-613"
+"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"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29138080/613-470-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2142995"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "FirstService Residential Ontario - (416) 293-5900"
+"CoListOfficeKey": "299544"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "UC-12 - Residential"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-11-26T14:47:57.33Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:37 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138080')"
+"ID": "445585"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24658
+post_id: "445160"
+post_author: 1
+"ListingKey": "29137642"
+"ListingId": "X12577214"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T03:40:38Z"
+"RFModificationTimestamp": "2025-11-26T03:42:44Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0X2"
+"UnparsedAddress": "4 - 215 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B0X2"
+"Coordinates": array:2 [
0 => -79.901284
1 => 43.327067
]
+"Latitude": 43.327067
+"Longitude": -79.901284
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained condo townhouse offering style, comfort, and convenience in every detail. The main level features an inviting open-concept layout with hardwood flooring and neutral paint tones that create a warm, modern feel. The gourmet kitchen boasts stainless steel appliances, a functional island, and plenty of counter space-perfect for cooking and entertaining. A custom built-in wall unit with charming shiplap & electric fireplace adds character and a cozy focal point to the living area. Upstairs, you'll find three generous-sized bedrooms, including a spacious primary suite complete with built-ins in the walk-in closet and its own 4-piece ensuite bathroom. An additional 4-piece bathroom serves guests or family. The second-floor laundry room has been tastefully updated, offering added convenience and style. The finished basement expands your living space with a versatile recreation room and ample storage options. A single-car garage provides secure parking and additional room for belongings. Move-in ready and thoughtfully updated, this home blends updated finishes with practical living spaces-perfect for families, professionals, or anyone seeking a low-maintenance lifestyle. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"AssociationFee": "260.19"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T03:21:10.295086+00:00"
+"Directions": "Dundas St E/ Hamilton St S"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235857"
+"ListOfficeKey": "280835"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T02:53:38Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T03:20:42Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "215"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5639.1"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/4_215_dundas_st_e_hamilton_on/"
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29137642/4-215-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1956613"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Blair Blanchard"
+"CoListAgentKey2": "2235858"
+"CoListOfficeKey": "280835"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"CoListOfficeKey2": "280835"
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2025-11-26T02:53:38.32Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:48 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29137642')"
+"ID": "445160"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24666
+post_id: "442976"
+post_author: 1
+"ListingKey": "29134742"
+"ListingId": "X12574358"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T17:45:31Z"
+"RFModificationTimestamp": "2025-11-25T17:53:05Z"
+"ListPrice": 1429888.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1V3"
+"UnparsedAddress": "28 CELANO DRIVE, Hamilton (Waterdown), Ontario L8B1V3"
+"Coordinates": array:2 [
0 => -79.8817753
1 => 43.34823
]
+"Latitude": 43.34823
+"Longitude": -79.8817753
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 28 Celano Drive, a beautifully upgraded and meticulously maintained 4+1 bedroom, 4-bathroom home offering approximately 3,026 sq. ft. of finished living space, built in 2017 and ideally set directly on Cranberry Park with private park access. The bright main level features an open-concept layout with hardwood flooring, a custom kitchen with quartz countertops, upgraded cabinetry, KitchenAid stainless steel appliances, and complemented by a brand-new LG 36" refrigerator and Samsung dishwasher. A spacious Great Room with a fireplace and a separate den perfect for a home office complete the main floor. The second level offers new flooring, a primary bedroom with a 3-piece ensuite and walk-in closet, three additional bedrooms, second-floor laundry, and a generous family room. The fully finished basement includes an additional bedroom, full bathroom, and a recreational area,pantry, ideal for extended family or guests. The home is enhanced with new LED lighting throughout and marble and stone finishes in the kitchen and all bathrooms. The fully fenced backyard features a deck and an extra-large hot tub that doubles as a swimming pool, creating a private retreat backing onto Cranberry Park. Located in one of Waterdown's most desirable neighbourhoods, this move-in ready home is close to excellent schools, shopping, restaurants, parks, and major highways including the QEW, 403, and 407. A perfect opportunity to own a modern family home that blends comfort, style, and an exceptional setting. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Oven - Built-In"
8 => "Hood Fan"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T16:42:25.131851+00:00"
+"Directions": "Spring Creek Dr & Avonsyde Blv"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Shingles"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Laminate"
2 => "Stone"
3 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091988"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "39.1 x 89.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-25T16:39:42Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T17:35:12Z"
+"Stories": "2.0"
+"StreetName": "Celano"
+"StreetNumber": "28"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8044"
+"View": "View"
+"VirtualTourURLUnbranded": "https://view.spiro.media/28_celano_dr-2779?branding=false"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29134742/28-celano-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 39.1
+"OriginalEntryTimestamp": "2025-11-25T16:01:12.01Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29134742')"
+"ID": "442976"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24693
+post_id: "441783"
+post_author: 1
+"ListingKey": "29133282"
+"ListingId": "X12573354"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T03:05:20Z"
+"RFModificationTimestamp": "2025-11-25T03:10:09Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R6"
+"UnparsedAddress": "67 GOLDEN IRIS CRESCENT, Hamilton (Waterdown), Ontario L8B0R6"
+"Coordinates": array:2 [
0 => -79.8821805
1 => 43.3467106
]
+"Latitude": 43.3467106
+"Longitude": -79.8821805
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover family-friendly bliss in East Waterdown! Step into 67 Golden Iris, a charming two-storey link home boasting more than 2,100 square feet of inviting living space, three spacious bedrooms, and three-and-a-half bathrooms, all complemented by stunning curb appeal. Nestled on a serene crescent, it's just moments from Cranberry Hill Park, top-rated schools, and everyday essentials.Freshly painted from top to bottom, the interior showcases an airy open-concept design with thoughtfully crafted areas. Host memorable gatherings in the generous dining room, while the warm family room flows seamlessly into the eat-in kitchen. Here, you'll love the extended white cabinetry featuring a bespoke coffee station and full-height storage, paired with sleek granite counters, premium black Maytag and Whirlpool appliances, and an elegant glass backsplash.Head upstairs to find three bedrooms with newly installed flooring (2024) and a convenient stackable washer-dryer setup. The luxurious primary bedroom offers a walk-in closet and a private ensuite bath complete with a relaxing soaker tub and glass-enclosed shower. A full four-piece bathroom rounds out this floor.The fully finished basement expands your options with a versatile rec room, another full bathroom, and ample storage. Step through sliding doors to the vast backyard oasis, highlighted by a spacious deck ideal for outdoor entertaining, lush gardens, and plenty of room for a potential swim spa.Outside, enjoy driveway parking for two vehicles plus an attached single garage. Located in the sought-after catchment for Mary Hopkins Elementary, Flamborough Centre School, and Waterdown District High School. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T01:31:47.795383+00:00"
+"Directions": "Cross Streets: Dundas St E to Spring Creek Dr to Hountrail Drive to Golden Iris Cr. ** Directions: Dundas St and Spring Creek Dr."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2107855"
+"ListOfficeKey": "294942"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "24.6 x 109.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T22:55:11Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T02:52:16Z"
+"Stories": "2.0"
+"StreetName": "Golden Iris"
+"StreetNumber": "67"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5193.61"
+"VirtualTourURLUnbranded": "https://tours.aisonphoto.com/idx/302359"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29133282/67-golden-iris-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2025-11-24T22:55:10.95Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29133282')"
+"ID": "441783"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23292
+post_id: "441028"
+post_author: 1
+"ListingKey": "29130952"
+"ListingId": "X12570894"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T15:30:33Z"
+"RFModificationTimestamp": "2025-11-24T20:47:26Z"
+"ListPrice": 877000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0A5"
+"UnparsedAddress": "69 MCMONIES DRIVE, Hamilton (Waterdown), Ontario L8B0A5"
+"Coordinates": array:2 [
0 => -79.8835772
1 => 43.3503531
]
+"Latitude": 43.3503531
+"Longitude": -79.8835772
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Don't miss this bright and stylish FREEHOLD Mattamy built townhouse! No condo fees! Built in 2016, this 3-bedroom, 3-bathhome welcomes you with a light-filled open layout designed for everyday living. Upstairs, the spacious primary suite includes a walk-in closetand ensuite bath, while the basement rough-in offers room to grow. Ideally located in one of Waterdowns most sought-after communities,just steps from schools, parks, shops, highways, transit, and two GO stations. A perfect mix of modern comfort and community living! (id:62650)"
+"Appliances": array:7 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T20:47:12.805462+00:00"
+"Directions": "Cross Streets: Parkside Drive and Spring Creek Drive. ** Directions: Spring Creek Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240296"
+"ListOfficeKey": "269948"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "21.3 x 89.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T15:21:38Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T15:21:37Z"
+"Stories": "2.0"
+"StreetName": "Mcmonies"
+"StreetNumber": "69"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5491.42"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": 2025
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29130952/69-mcmonies-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 21.3
+"OriginalEntryTimestamp": "2025-11-24T15:21:37.78Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:28 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29130952')"
+"ID": "441028"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24659
+post_id: "440914"
+post_author: 1
+"ListingKey": "29132154"
+"ListingId": "X12572254"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T19:05:23Z"
+"RFModificationTimestamp": "2025-11-24T19:44:19Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "11 - 70 KENESKY DRIVE, Hamilton (Waterdown), Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.878967
1 => 43.337159
]
+"Latitude": 43.337159
+"Longitude": -79.878967
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Brand new and never lived in! This modern one-bedroom, one-bathroom stacked townhouse offers stylish living in the heart of Waterdown. This unit features an open-concept living area, in-suite laundry, and an attached one-car garage with inside entry, a rare and convenient feature. The kitchen boasts white cabinetry, stainless steel appliances, a full pantry, and a functional layout perfect for everyday cooking or entertaining. Thoughtfully designed, this home was built with storage, making it stand out. You're steps from everyday conveniences and surrounded by the best of Waterdown living. Enjoy quick access to parks, schools, grocery stores, restaurants, shops, and walking trails. Commuters will appreciate being close to Highway 403, the QEW, and the Aldershot GO Station, offering easy travel to Burlington, Hamilton, and the GTA. Nearby amenities include Fortinos, Walmart, restaurants along Dundas Street, Waterdown Memorial Park, and scenic trails at Smokey Hollow Falls. Perfect for anyone seeking modern comfort in a growing, vibrant community. Don't miss this exceptional opportunity! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"CreationDate": "2025-11-24T19:44:14.194212+00:00"
+"Directions": "Cross Streets: Burke St. ** Directions: Burke St to Kenesky Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1973790"
+"ListOfficeKey": "84654"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T18:56:21Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T18:56:21Z"
+"StreetName": "Kenesky"
+"StreetNumber": "70"
+"StreetSuffix": "Drive"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29132154/11-70-kenesky-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"TotalActualRent": 2295
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-24T18:56:21.22Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:22 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29132154')"
+"ID": "440914"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24657
+post_id: "440607"
+post_author: 1
+"ListingKey": "29131788"
+"ListingId": "X12572028"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T18:30:22Z"
+"RFModificationTimestamp": "2025-11-24T19:04:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B2A5"
+"UnparsedAddress": "317 - 460 DUNDAS STREET E, Hamilton (Waterdown), Ontario L8B2A5"
+"Coordinates": array:2 [
0 => -79.879544
1 => 43.343071
]
+"Latitude": 43.343071
+"Longitude": -79.879544
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Bright and sunny, one bedroom condo with underground parking and locker. Trendy kitchen cabinets, grey vinyl floors throughout. Upgraded Kitchen with quartz counter tops, custom quartz island with granite sink and upgraded faucets. Full sized front loading washer and dryer. Bathroom vanity upgraded to quartz with custom sink and tap. All lights replaced with Trendy custom LED light fixtures. Building amenities include a well appointed gym, rooftop terrace with BBQ's, Beautiful party room, bike storage. Area amenities include close proximity to Aldershot GO & highways, close to trails for hiking and biking, shopping close by. Available immediately for a one year lease with full credit check, employment letter, rental application and two month's deposit. No pets and non smokers only. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-24T19:04:35.331117+00:00"
+"Directions": "Cross Streets: Dundas Street to Riverwalk. ** Directions: Dundas to Riverwalk."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1735614"
+"ListOfficeKey": "118891"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2025-11-24T17:56:49Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T17:56:49Z"
+"StreetDirSuffix": "East"
+"StreetName": "Dundas"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"View": "City view"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Waterdown"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29131788/317-460-dundas-street-e-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1593651"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "First Service Residential"
+"CoListOfficeKey": "283413"
+"TotalActualRent": 1975
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-24T17:56:48.97Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:22 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29131788')"
+"ID": "440607"
}
]
+success: true
+page_size: 9
+page_count: 25
+count: 221
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]
