array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29229510/Property?$select=ALL&$top=20&$filter=ListingKey eq 29229510&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29229510/Property?$select=ALL&$top=20&$filter=ListingKey eq 29229510&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23467
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23469
+post_id: "519414"
+post_author: 1
+"ListingKey": "29229510"
+"ListingId": "40797077"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T17:35:37Z"
+"RFModificationTimestamp": "2026-01-08T18:01:23Z"
+"ListPrice": 1348800.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": "2026-01-08T18:01:04.243789+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": "2026-01-08T17:28:56Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T17:28:56Z"
+"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" => "1557968361"
"RoomType" => "4pc Bathroom"
"ListingId" => "40797077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.4Z"
]
1 => array:11 [
"RoomKey" => "1557968362"
"RoomType" => "5pc Bathroom"
"ListingId" => "40797077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.4Z"
]
2 => array:11 [
"RoomKey" => "1557968363"
"RoomType" => "3pc Bathroom"
"ListingId" => "40797077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.4Z"
]
3 => array:11 [
"RoomKey" => "1557968364"
"RoomType" => "Bedroom"
"ListingId" => "40797077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.4Z"
]
4 => array:11 [
"RoomKey" => "1557968365"
"RoomType" => "Bedroom"
"ListingId" => "40797077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.4Z"
]
5 => array:11 [
"RoomKey" => "1557968366"
"RoomType" => "Bedroom"
"ListingId" => "40797077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.4Z"
]
6 => array:11 [
"RoomKey" => "1557968367"
"RoomType" => "Primary Bedroom"
"ListingId" => "40797077"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 20'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.41Z"
]
7 => array:11 [
"RoomKey" => "1557968368"
"RoomType" => "2pc Bathroom"
"ListingId" => "40797077"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.41Z"
]
8 => array:11 [
"RoomKey" => "1557968369"
"RoomType" => "Laundry room"
"ListingId" => "40797077"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.41Z"
]
9 => array:11 [
"RoomKey" => "1557968370"
"RoomType" => "Family room"
"ListingId" => "40797077"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.41Z"
]
10 => array:11 [
"RoomKey" => "1557968371"
"RoomType" => "Kitchen"
"ListingId" => "40797077"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => "18'5'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.41Z"
]
11 => array:11 [
"RoomKey" => "1557968372"
"RoomType" => "Living room/Dining room"
"ListingId" => "40797077"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29229510"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 18'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-08T17:28:56.41Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29229510/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": "2026-01-08T17:28:56.31Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:43 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6396826941"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/0a55243ede3ab1c5e1f0deb3d385cc05.webp"
"MediaSize" => 130931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-0a55243ede3ab1c5e1f0deb3d385cc05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6396826973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/c58d66a8ebfb77a942ac726f019487b6.webp"
"MediaSize" => 76425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-c58d66a8ebfb77a942ac726f019487b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6396826987"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/14d83b127f089a648149d48d30c5b31b.webp"
"MediaSize" => 146902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-14d83b127f089a648149d48d30c5b31b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6396827039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/a4c97622bcacbf84738c83c03158c2d2.webp"
"MediaSize" => 68511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-a4c97622bcacbf84738c83c03158c2d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6396827061"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/130acfec845403d78d763ec196f2e66b.webp"
"MediaSize" => 69898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-130acfec845403d78d763ec196f2e66b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6396827115"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/077424611a01f735c270484fd660d2fb.webp"
"MediaSize" => 76914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-077424611a01f735c270484fd660d2fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6396827134"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/0ca4164edb389f948a2919646467013c.webp"
"MediaSize" => 62957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-0ca4164edb389f948a2919646467013c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6396827176"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/991d7d4bd1b54ffb7d21f78636cebf88.webp"
"MediaSize" => 58047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-991d7d4bd1b54ffb7d21f78636cebf88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6396827193"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/fa23d66227c2ccc9095969d45c3a950a.webp"
"MediaSize" => 80182
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-fa23d66227c2ccc9095969d45c3a950a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6396827258"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/979679192f1d1045b2d7ae4e09742b44.webp"
"MediaSize" => 70636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-979679192f1d1045b2d7ae4e09742b44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6396827289"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/a570b3e30eccdbfb922c722c10a2a741.webp"
"MediaSize" => 63140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-a570b3e30eccdbfb922c722c10a2a741.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6396827296"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/9c10bfe3b099e85488c5853c6a458d7a.webp"
"MediaSize" => 147856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-9c10bfe3b099e85488c5853c6a458d7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6396827331"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/193abf3b5b8e02e7a69f96ad1f454b0b.webp"
"MediaSize" => 65201
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-193abf3b5b8e02e7a69f96ad1f454b0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6396827349"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/6d6bfc4956d77aec781cce9afccd606d.webp"
"MediaSize" => 69257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-6d6bfc4956d77aec781cce9afccd606d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6396827392"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/2cf7ab686dc00c1d2a0d256c8139e268.webp"
"MediaSize" => 45956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-2cf7ab686dc00c1d2a0d256c8139e268.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6396827404"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/1819e19cd0debee9623be548d4c9d73e.webp"
"MediaSize" => 101011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-1819e19cd0debee9623be548d4c9d73e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6396827448"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/46641338d697227f3bcc5c7ea09b0318.webp"
"MediaSize" => 76925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-46641338d697227f3bcc5c7ea09b0318.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6396827464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/cfa5ae5dc67c2f0d021a7d257dd240bb.webp"
"MediaSize" => 68398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-cfa5ae5dc67c2f0d021a7d257dd240bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6396827506"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/5de41a4c91b75840a24bcb6bd5b08007.webp"
"MediaSize" => 78218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-5de41a4c91b75840a24bcb6bd5b08007.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6396827532"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/aeaeb1259cad6b3705d784f3f474c058.webp"
"MediaSize" => 74997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-aeaeb1259cad6b3705d784f3f474c058.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6396827558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/6c6e702d80e35aa7ee62a65a86c72c9e.webp"
"MediaSize" => 52835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-6c6e702d80e35aa7ee62a65a86c72c9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6396827573"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/a8b9902d71faf6a70c4b3b87a27782e0.webp"
"MediaSize" => 71798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-a8b9902d71faf6a70c4b3b87a27782e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6396827616"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/e2b8d80b779fa6e189ce2552d19fcb7d.webp"
"MediaSize" => 75906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-e2b8d80b779fa6e189ce2552d19fcb7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6396827634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/523cf30097070cdd5dae1f99064621e1.webp"
"MediaSize" => 75764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-523cf30097070cdd5dae1f99064621e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6396827678"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/d646252b6fb21eba82c9c05afc5ee6f6.webp"
"MediaSize" => 131161
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-d646252b6fb21eba82c9c05afc5ee6f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6396827686"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/bba7173b6c5a23296c625460df0a7223.webp"
"MediaSize" => 44632
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-bba7173b6c5a23296c625460df0a7223.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6396827732"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/0b1dfec4cce6c90eda309d17e876cbe9.webp"
"MediaSize" => 101652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-0b1dfec4cce6c90eda309d17e876cbe9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6396827737"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/bfc5ca6ca6cd83c003c9cb574aa30650.webp"
"MediaSize" => 74891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-bfc5ca6ca6cd83c003c9cb574aa30650.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6396827777"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/401e8b00c3e3ca25b537da60727da895.webp"
"MediaSize" => 94637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-401e8b00c3e3ca25b537da60727da895.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6396827824"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/b71bf4aeff146589521f646b53d8f5cc.webp"
"MediaSize" => 63521
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-b71bf4aeff146589521f646b53d8f5cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6396827830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/93cfe624d19d0980e8976441d5c3f896.webp"
"MediaSize" => 87909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-93cfe624d19d0980e8976441d5c3f896.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6396827866"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/a4312598ba5bb34cfe34068b3e328eee.webp"
"MediaSize" => 151325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-a4312598ba5bb34cfe34068b3e328eee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6396827892"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/03ecf1d129609972bf094a19d9da63b7.webp"
"MediaSize" => 71960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-03ecf1d129609972bf094a19d9da63b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6396827923"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/842260883f836f0bb41391c9165fce20.webp"
"MediaSize" => 70746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-842260883f836f0bb41391c9165fce20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6396827934"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/8f3399a2b99a1811ffcd3c02c49fda06.webp"
"MediaSize" => 67403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-8f3399a2b99a1811ffcd3c02c49fda06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6396827968"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/8ff9f9ebccfd18195032fcf5f06ba3ad.webp"
"MediaSize" => 70744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-8ff9f9ebccfd18195032fcf5f06ba3ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6396828001"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/78bd94413a163a58b22d851055fa1ccf.webp"
"MediaSize" => 67330
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-78bd94413a163a58b22d851055fa1ccf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6396828039"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/8043b9fe0e7fb57abcbb7fc67c1f3dab.webp"
"MediaSize" => 77771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-8043b9fe0e7fb57abcbb7fc67c1f3dab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6396828073"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/da38a6af6b0a0275a474853ddc6f967b.webp"
"MediaSize" => 68270
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-da38a6af6b0a0275a474853ddc6f967b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6396828095"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/1f4d1993f5b43f65626becd6fbfa3751.webp"
"MediaSize" => 67078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-1f4d1993f5b43f65626becd6fbfa3751.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6396828138"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/79f37bea1acf380733a001e777c79364.webp"
"MediaSize" => 77572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-79f37bea1acf380733a001e777c79364.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6396828167"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/713a5067fb9e265122296a917c05300a.webp"
"MediaSize" => 74047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-713a5067fb9e265122296a917c05300a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6396828195"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29229510/fd95d7853b161b12d57f1a5e5ce34385.webp"
"MediaSize" => 150056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29229510/thumbnail-fd95d7853b161b12d57f1a5e5ce34385.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40797077"
"ResourceRecordKey" => "29229510"
"ModificationTimestamp" => "2026-01-08T17:28:56.32Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Yvonne Morrow"
"MemberFirstName" => "Yvonne"
"MemberLastName" => "Morrow"
"MemberMlsId" => "HBGRABOYV"
"OriginatingSystemName" => 26
"MemberKey" => "2062140"
"ModificationTimestamp" => "2025-10-28T23:08:36Z"
"MemberStatus" => "Active"
"OfficeKey" => "283666"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Burlington"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-580-0324"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2018-09-14T12:51:00Z"
"MemberNationalAssociationId" => "1337143"
"OfficeNationalAssociationId" => "1333115"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "RE/MAX Escarpment Realty Inc."
"OfficePhone" => "905-639-7676"
"OfficeMlsId" => "HBRMXESCBU4B"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "283666"
"ModificationTimestamp" => "2025-07-09T18:36:53Z"
"OfficeAddress1" => "2180 Itabashi Way Unit 4B"
"OfficeCity" => "Burlington"
"OfficePostalCode" => "L7M5A"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2018-06-25T18:38:00Z"
"OfficeNationalAssociationId" => "1333115"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1201589"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29229510')"
+"ID": "519414"
}
]
+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=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283666/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283666&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+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')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.27 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2062140/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2062140&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2062140/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2062140&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25321
+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 29229510" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24930
+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 29229510/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29229510&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29229510/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29229510&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24910
+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 29229510 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 29229510 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=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29229510 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 29229510 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=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24846
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24855
+post_id: "524595"
+post_author: 1
+"ListingKey": "29236873"
+"ListingId": "X12683140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T04:50:06Z"
+"RFModificationTimestamp": "2026-01-10T04:51:09Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y6"
+"UnparsedAddress": "BASEMENT - 171 GREAT FALLS BOULEVARD, Hamilton (Waterdown), Ontario L8B1Y6"
+"Coordinates": array:2 [
0 => -79.8749328
1 => 43.3382768
]
+"Latitude": 43.3382768
+"Longitude": -79.8749328
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright, spacious, and fully legal 3-bedroom, 2-bathroom basement apartment located in the highly desirable Waterdown community. With thoughtful design and generous living space, this home offers modern comfort and excellent ventilation, making it feel warm, inviting, and truly livable year-round.Step inside to find a well-planned layout featuring three full-sized bedrooms, perfect for families, professionals, or roommates seeking privacy and comfort. The two updated bathrooms provide convenience and functionality, while the open living and dining areas create a welcoming environment ideal for relaxing or entertaining.The unit is situated in a quiet, family-friendly neighbourhood known for its safety, charm, and strong sense of community. Daily life is made easier with close proximity to Highway 403, public transit routes, multiple grocery stores, shopping plazas, schools, parks, cafés, and other essential amenities. Whether you're commuting, running errands, or enjoying local trails and recreation, everything you need is right at your doorstep.With an unbeatable combination of location, comfort, and practical living, this apartment presents a fantastic opportunity for those looking for quality housing in Waterdown. (id:62650)"
+"Basement": array:5 [
0 => "Finished"
1 => "Apartment in basement"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T04:31:08.035343+00:00"
+"Directions": "GREAT FALLS BLVD & SEALEY AVE."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2146090"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"LotSizeDimensions": "46.4 x 90.4 FT ; 34.85 ft x 23.24 ft x 73.97 ft x 51.29 f"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-10T04:11:21Z"
+"PhotosCount": 11
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T04:39:43Z"
+"Stories": "2.0"
+"StreetName": "Great Falls"
+"StreetNumber": "171"
+"StreetSuffix": "Boulevard"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1558559371"
"RoomType" => "Living room"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29236873"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
1 => array:11 [
"RoomKey" => "1558559372"
"RoomType" => "Dining room"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29236873"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
2 => array:11 [
"RoomKey" => "1558559373"
"RoomType" => "Bedroom"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 3.9
"ListingKey" => "29236873"
"RoomLength" => 5.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
3 => array:11 [
"RoomKey" => "1558559374"
"RoomType" => "Bedroom 2"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 2.89
"ListingKey" => "29236873"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
4 => array:11 [
"RoomKey" => "1558559375"
"RoomType" => "Bedroom 3"
"ListingId" => "X12683140"
"RoomLevel" => "Basement"
"RoomWidth" => 2.55
"ListingKey" => "29236873"
"RoomLength" => 3.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-10T04:39:43.8Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29236873/basement-171-great-falls-boulevard-hamilton-waterdown-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2300
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 46.4
+"OriginalEntryTimestamp": "2026-01-10T04:11:21.76Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:11 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398828341"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/864e0e6d1c05e333cd7a17c2475ff840.webp"
"MediaSize" => 231781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-864e0e6d1c05e333cd7a17c2475ff840.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398828346"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/196b17df1775e2ad17c2fa1ff91bc6d2.webp"
"MediaSize" => 112242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-196b17df1775e2ad17c2fa1ff91bc6d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398828350"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/18d40bed1f6c7de96d087edb07cc735b.webp"
"MediaSize" => 212790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-18d40bed1f6c7de96d087edb07cc735b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398828354"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/b633c5603db6a82917ddbd603da62416.webp"
"MediaSize" => 132404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-b633c5603db6a82917ddbd603da62416.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6398828359"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/7a5161f0b34464f6ee2cd6a1eabd3306.webp"
"MediaSize" => 135972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-7a5161f0b34464f6ee2cd6a1eabd3306.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6398828364"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/57e4f40653f6237fb44ec7364c78fe83.webp"
"MediaSize" => 127258
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-57e4f40653f6237fb44ec7364c78fe83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6398828367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/78b24b0a98cc18d1e71d1bbf53049bf0.webp"
"MediaSize" => 130954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-78b24b0a98cc18d1e71d1bbf53049bf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6398828371"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/33f8b61b6159cbf25289c249dd6d5628.webp"
"MediaSize" => 121236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-33f8b61b6159cbf25289c249dd6d5628.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6398828378"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/0a0ccaf9fa30264722ff4f9d64ddda05.webp"
"MediaSize" => 130468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-0a0ccaf9fa30264722ff4f9d64ddda05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6398828384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/93f842a7927af016bd2fe5e929bdfb75.webp"
"MediaSize" => 114688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-93f842a7927af016bd2fe5e929bdfb75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6398828390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29236873/bdd96f97b6763142c0422e8677c71c33.webp"
"MediaSize" => 117383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29236873/thumbnail-bdd96f97b6763142c0422e8677c71c33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12683140"
"ResourceRecordKey" => "29236873"
"ModificationTimestamp" => "2026-01-10T04:11:21.76Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "RAMIN ALOKOZAY"
"MemberFirstName" => "RAMIN"
"MemberLastName" => "ALOKOZAY"
"MemberMlsId" => "9611874"
"OriginatingSystemName" => 26
"MemberKey" => "2146090"
"ModificationTimestamp" => "2025-12-15T09:59:54Z"
"MemberStatus" => "Active"
"OfficeKey" => "270920"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:5 [ …5]
"MemberOfficePhone" => "416-910-5424"
"MemberSocialMedia" => array:2 [ …2]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2021-09-21T15:20:00Z"
"MemberNationalAssociationId" => "1397417"
"OfficeNationalAssociationId" => "1236912"
]
]
+"Office": array:1 [
0 => array:19 [
"OfficeName" => "RIGHT AT HOME REALTY, BROKERAGE"
"OfficePhone" => "905-637-1700"
"OfficeMlsId" => "466000"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "293485"
"ModificationTimestamp" => "2025-01-12T14:00:57Z"
"OfficeAddress1" => "5111 New Street, Suite 106"
"OfficeCity" => "Burlington"
"OfficePostalCode" => "L7L1V"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Niagara"
"OfficeType" => "Firm"
"OfficeAORKey" => "114"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2022-10-27T17:59:00Z"
"OfficeNationalAssociationId" => "1427673"
"OfficeBrokerNationalAssociationId" => "1411464"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29236873')"
+"ID": "524595"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24849
+post_id: "524488"
+post_author: 1
+"ListingKey": "29236583"
+"ListingId": "X12682864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-10T01:20:45Z"
+"RFModificationTimestamp": "2026-01-10T03:45:49Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L0R2H8"
+"UnparsedAddress": "212 SPRING CREEK DRIVE, Hamilton (Waterdown), Ontario L0R2H8"
+"Coordinates": array:2 [
0 => -79.8837091
1 => 43.3486947
]
+"Latitude": 43.3486947
+"Longitude": -79.8837091
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This beautiful detached home is over 2200 sqft, main floor offers 9 ft ceilings, an open concept with maple hardwood floors, maple wood staircase with steel pickets, large great room, upgraded chef's kitchen with quartz countertops, high end stainless steel appliances, walk in pantry, zebra window coverings on main floor, California shutters on 2nd floor. 4 bedrooms w/large mbdrm w/his and hers walk in closets, glass uper shower in master ensuite and 2nd floor laundry. Comes with Gazebo, Outdoor furniture and the deck! (id:62650)"
+"Appliances": array:2 [
0 => "Oven - Built-In"
1 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Apartment in basement"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-10T03:45:34.846371+00:00"
+"Directions": "Dundas & Spring Creek"
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2131503"
+"ListOfficeKey": "295098"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-10T01:13:07Z"
+"PhotosCount": 35
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-10T01:13:07Z"
+"Stories": "2.0"
+"StreetName": "Spring Creek"
+"StreetNumber": "212"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:1 [
0 => array:11 [
"RoomKey" => "1558502785"
"RoomType" => "Dining room"
…9
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29236583/212-spring-creek-drive-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Other"
]
+"GeocodeManualYN": false
+"TotalActualRent": 3199
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-10T01:13:07.35Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29236583')"
+"ID": "524488"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24856
+post_id: "523751"
+post_author: 1
+"ListingKey": "29235192"
+"ListingId": "40797504"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T20:30:39Z"
+"RFModificationTimestamp": "2026-01-09T23:35:13Z"
+"ListPrice": 1165000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2903.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H3"
+"UnparsedAddress": "43 NISKA Drive, Waterdown, Ontario L0R2H3"
+"Coordinates": array:2 [
0 => -79.8891476
1 => 43.3433412
]
+"Latitude": 43.3433412
+"Longitude": -79.8891476
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained 3-bedroom, 2.5-bathroom home located in a quiet, family-friendly neighbourhood, with easy access to highway and GO station. Thoughtfully updated for modern living and easy entertaining. Inside, enjoy a spacious, sunlit kitchen perfect for gatherings and daily life. The home has seen important updates, including a newly replaced roof and windows that were updated within the past few years, providing comfort, efficiency, and long-term peace of mind. The furnace and A/C are only 5-6 years old, so major systems are well taken care of. Fully finished basement features a dedicated gym area, creating a flexible space for wellness or recreation. Step outside and you’ll find a true backyard retreat: A sparkling in-ground pool with a Safecover, safe, secure, and easy to operate; A hot tub with a hard cover, perfect for relaxing year-round. Private, landscaped yard in a peaceful neighbourhood. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T23:34:47.694093+00:00"
+"Directions": "Dundas St.. E. to First St. to Niska Dr."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524541"
+"ListOfficeKey": "293386"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T20:19:13Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T20:19:13Z"
+"Stories": "2.0"
+"StreetName": "NISKA"
+"StreetNumber": "43"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "6467.49"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29235192/43-niska-drive-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2158
+"BelowGradeFinishedArea": 745
+"OriginalEntryTimestamp": "2026-01-09T20:19:13.73Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235192')"
+"ID": "523751"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24847
+post_id: "523251"
+post_author: 1
+"ListingKey": "29235663"
+"ListingId": "X12682138"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T21:50:47Z"
+"RFModificationTimestamp": "2026-01-09T22:02:21Z"
+"ListPrice": 1279000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B0R4"
+"UnparsedAddress": "174 MCKNIGHT AVENUE, Hamilton (Waterdown), Ontario L8B0R4"
+"Coordinates": array:2 [
0 => -79.877943
1 => 43.340356
]
+"Latitude": 43.340356
+"Longitude": -79.877943
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Spacious 2,955 sq ft, four bedroom, three and a half bath home in a sought after Waterdown neighbourhood built in 2012. Featuring formal living and dining rooms, a large kitchen open to the family room with gas fireplace, and a generous primary suite with walk in closet and en suite with soaker tub. Three additional bedrooms and two full bathrooms complete the upper level.Located minutes to Waterdown's charming downtown core, the Bruce Trail, parks, and conservation areas, with easy access to Highway 403, Highway 6, and the QEW for commuters. Double car garage and covered front porch complete this inviting family home. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T22:01:59.469084+00:00"
+"Directions": "Cross Streets: Dundas And Burke. ** Directions: Dundas to Burke."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1407052"
+"ListOfficeKey": "286883"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "75.7 x 94 FT ; REAR-38.79"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T21:40:13Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T21:40:13Z"
+"Stories": "2.0"
+"StreetName": "Mcknight"
+"StreetNumber": "174"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "8534"
+"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"
+"TaxYear": 2026
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29235663/174-mcknight-avenue-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 75.8
+"OriginalEntryTimestamp": "2026-01-09T21:40:13.7Z"
+"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]
]
+"Member": []
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235663')"
+"ID": "523251"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24848
+post_id: "522839"
+post_author: 1
+"ListingKey": "29234148"
+"ListingId": "X12680794"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T17:50:46Z"
+"RFModificationTimestamp": "2026-01-09T18:20:17Z"
+"ListPrice": 889000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1Y1"
+"UnparsedAddress": "7 WESTFIELD CRESCENT, Hamilton (Waterdown), Ontario L8B1Y1"
+"Coordinates": array:2 [
0 => -79.8794614
1 => 43.3365679
]
+"Latitude": 43.3365679
+"Longitude": -79.8794614
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 7 Westfield Cres, a beautifully maintained 3-bedroom home in the newer, highly sought-after pocket of Waterdown, where modern design meets everyday comfort. The spacious open-concept main floor is filled with natural light and anchored by a cozy fireplace - perfect for warm winter nights and effortless summer entertaining. Completely carpet-free, the home offers three generous bedrooms and a private, gated backyard ideal for kids, pets, and weekend gatherings. Set in the heart of the Village of Waterdown, you're surrounded by top-rated schools, scenic parks and trails, great dining, and every amenity you could need, all while enjoying quick 5-minute easy access to Aldershot GO, and seamless connections to Highways 6 and 6. This is the kind of home that just feels right - so why not make this Waterdown gem your next home sweet home? (id:62650)"
+"Appliances": array:2 [
0 => "Range"
1 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T18:19:57.590756+00:00"
+"Directions": "DUNDAS ST E & BURKE ST"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2162448"
+"ListOfficeKey": "269338"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "24.6 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T17:41:03Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T17:41:03Z"
+"Stories": "2.0"
+"StreetName": "Westfield"
+"StreetNumber": "7"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6665.35"
+"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/29234148/7-westfield-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 24.7
+"OriginalEntryTimestamp": "2026-01-09T17:41:03.24Z"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29234148')"
+"ID": "522839"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24783
+post_id: "522840"
+post_author: 1
+"ListingKey": "29233700"
+"ListingId": "40797332"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T17:30:55Z"
+"RFModificationTimestamp": "2026-01-09T17:55:50Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 692.0
+"BuildingAreaTotal": 0
+"City": "Waterdown"
+"PostalCode": "L0R2H4"
+"UnparsedAddress": "450 DUNDAS Street E Unit# 333, Waterdown, Ontario L0R2H4"
+"Coordinates": array:2 [
0 => -79.8796682
1 => 43.3426305
]
+"Latitude": 43.3426305
+"Longitude": -79.8796682
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "WELCOME TO TREND! A New Condominium built by New Horizon in Waterdown. This bright west facing spacious unit is a 1 bedroom + den. Suitable for anyone who needs a home office or just some extra living space. Fantastic galley kitchen with a large breakfast bar and a walk-out to your private balcony. This unit features an open concept layout with many upgrades including Shaw luxury vinyl flooring, quartz countertops, porcelain floor to wall tiles in the bathroom with rain head shower faucet, upgraded stainless kitchen appliance package, upgraded large washer and dryer. The spacious primary bedroom boasts a walk in closet and floor to ceiling windows. One underground parking spot with a locker on the same floor as the unit are also added features. Amenities include fitness room, party room, roof top patio and a bike room. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:2 [
0 => "Heat"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T17:31:52.499334+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1936273"
+"ListOfficeKey": "55165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-01-09T17:22:17Z"
+"PhotosCount": 15
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T17:22:17Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "450"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"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/29233700/450-dundas-street-e-unit-333-waterdown"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2250
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "UC-12"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 692
+"OriginalEntryTimestamp": "2026-01-09T16:38:43.16Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:15 [
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29233700')"
+"ID": "522840"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23481
+post_id: "522841"
+post_author: 1
+"ListingKey": "29233356"
+"ListingId": "40787081"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-09T16:05:47Z"
+"RFModificationTimestamp": "2026-01-09T16:50:32Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1386.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B1Y4"
+"UnparsedAddress": "70 KENESKY Drive Unit# 30, Hamilton, Ontario L8B1Y4"
+"Coordinates": array:2 [
0 => -79.878484
1 => 43.3369104
]
+"Latitude": 43.3369104
+"Longitude": -79.878484
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Be The First To Live In This Stunning, Never-Before-Lived-In 3-Bed, 2.5-Bath Townhome In Sought-After Waterdown! This Bright, Modern Home Offers 1,386 Sq Ft Of Functional Living With Quality Finishes Throughout — Including Quartz Countertops, Vinyl Plank Flooring, And Full-Size Stainless Steel Appliances. Enjoy A Spacious Open-Concept Layout With A Versatile Den, Perfect For A Home Office Or Reading Nook. The Primary Bedroom Features A Luxurious Glass-Enclosed Ensuite. Relax On The 160 Sq Ft Terrace Or Take Advantage Of The Private Garage And Additional Parking Options. Located Minutes From Downtown Waterdown’s Shops, Dining, Bruce Trail, And Smokey Hollow Waterfall. Easy Access To Aldershot GO, Hwy 403 & 407. Lawn & Snow Care Included! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Landscaping"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-09T16:50:14.286291+00:00"
+"Directions": "Dundas St E/Burke St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1752844"
+"ListOfficeKey": "190426"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T15:50:25Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-09T15:50:25Z"
+"Stories": "3.0"
+"StreetName": "KENESKY"
+"StreetNumber": "70"
+"StreetSuffix": "Drive"
+"SubdivisionName": "461 - Waterdown East"
+"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/29233356/70-kenesky-drive-unit-30-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2800
+"ZoningDescription": "R6-30"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1386
+"OriginalEntryTimestamp": "2026-01-09T15:50:24.81Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:21 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29233356')"
+"ID": "522841"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24844
+post_id: "519633"
+post_author: 1
+"ListingKey": "29229893"
+"ListingId": "X12676720"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T18:26:11Z"
+"RFModificationTimestamp": "2026-01-08T18:51:48Z"
+"ListPrice": 1348800.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Waterdown)"
+"PostalCode": "L8B1W7"
+"UnparsedAddress": "107 AVANTI CRESCENT, Hamilton (Waterdown), Ontario L8B1W7"
+"Coordinates": array:2 [
0 => -79.8817092
1 => 43.3352959
]
+"Latitude": 43.3352959
+"Longitude": -79.8817092
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"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:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T18:51:36.902973+00:00"
+"Directions": "Cross Streets: Dundas St & Burke St. ** 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": "1991785"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "41 x 90.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-08T18:16:02Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T18:16:02Z"
+"Stories": "2.0"
+"StreetName": "Avanti"
+"StreetNumber": "107"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "8924.36"
+"VirtualTourURLUnbranded": "https://media.relavix.com/107-avanti-crescent-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterdown"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29229893/107-avanti-crescent-hamilton-waterdown-waterdown"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2026-01-08T18:16:02.15Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29229893')"
+"ID": "519633"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24845
+post_id: "517821"
+post_author: 1
+"ListingKey": "29227505"
+"ListingId": "40795589"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-08T00:15:27Z"
+"RFModificationTimestamp": "2026-01-08T00:48:37Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 728.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8B2A6"
+"UnparsedAddress": "470 DUNDAS Street E Unit# 909, Hamilton, Ontario L8B2A6"
+"Coordinates": array:2 [
0 => -79.8786324
1 => 43.3440957
]
+"Latitude": 43.3440957
+"Longitude": -79.8786324
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning Corner Condo with Expansive Private Rooftop Terrace, a storage locker and two parking spots! Discover a one-of-a-kind opportunity to own this beautiful corner unit with breathtaking views and a massive private terrace—your very own rooftop retreat. Whether you love to entertain, need a play space, or simply want to bask in the sun, this outdoor oasis is a rare find. Inside, the open concept living space is designed for both style and functionality. The upgraded kitchen boasts ample cabinetry, quartz countertops, and high-end finishes, perfect for cooking and hosting. Floor-to-ceiling windows flood the unit with natural light, creating a bright and airy ambiance. Step into the primary bedroom and enjoy expansive windows and a spacious walk-in closet. The second bedroom, also featuring a walk-in closet and floor-to-ceiling windows, is ideal as a guest room or home office. The sleek, upgraded bathroom includes a stunning walk-in shower with a waterfall showerhead for a spa-like experience. Located in a prime area, you’ll be within walking distance of restaurants and shops, with easy access to highways and the GO Station for commuters. Residents enjoy top-tier amenities, including a state-of-the-art fitness center, an elegant party room, and a rooftop deck with a community BBQ area. Don’t miss this rare opportunity to own a beautiful, modern condo with a private rooftop terrace that truly sets it apart. Schedule your viewing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "440.93"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-08T00:48:28.585103+00:00"
+"Directions": "Dundas St. E"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2156372"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-01-08T00:08:46Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-08T00:08:46Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "DUNDAS"
+"StreetNumber": "470"
+"StreetSuffix": "Street"
+"SubdivisionName": "461 - Waterdown East"
+"TaxAnnualAmount": "3297.86"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29227505/470-dundas-street-e-unit-909-hamilton"
+"ParkingTotal": 2
+"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": 728
+"OriginalEntryTimestamp": "2026-01-08T00:08:46.19Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:31 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29227505')"
+"ID": "517821"
}
]
+success: true
+page_size: 9
+page_count: 20
+count: 178
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]