array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29930701 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408
+post_id: "1549448"
+post_author: 1
+"ListingKey": "29930701"
+"ListingId": "40841580"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:30:01Z"
+"RFModificationTimestamp": "2026-06-19T21:04:37Z"
+"ListPrice": 589999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1380.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J0M7"
+"UnparsedAddress": "19 PICARDY Drive Unit# 4, Hamilton, Ontario L8J0M7"
+"Coordinates": array:2 [
0 => -79.7765846
1 => 43.1843905
]
+"Latitude": 43.1843905
+"Longitude": -79.7765846
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully built 3-level townhouse offering modern living in an unbeatable location. Featuring a spacious and functional layout, this home boasts bright open-concept living spaces, stylish finishes, generous-sized bedrooms, and the added convenience of a private garage for parking and extra storage. Perfect for families, professionals, or investors, this property is situated in a fantastic area close to shopping, restaurants, schools, parks, transit, and major highways — truly close to everything you need. Move-in ready and thoughtfully designed, this is a wonderful opportunity to own a stylish home in a highly desirable community! (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:04:30.708502+00:00"
+"Directions": "UPPER CENTENNIAL PKWY TO HIGHLAND RD W TO PICARDY"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2201906"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T20:11:28Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:11:28Z"
+"Stories": "3.0"
+"StreetName": "PICARDY"
+"StreetNumber": "19"
+"StreetSuffix": "Drive"
+"SubdivisionName": "502 - Felker"
+"TaxAnnualAmount": "3423"
+"Utilities": array:1 [
0 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1663242115"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841580"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930701"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:11:28.73Z"
]
1 => array:11 [
"RoomKey" => "1663242116"
"RoomType" => "Bedroom"
"ListingId" => "40841580"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930701"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:11:28.74Z"
]
2 => array:11 [
"RoomKey" => "1663242117"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841580"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930701"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:11:28.74Z"
]
3 => array:11 [
"RoomKey" => "1663242118"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841580"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29930701"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:11:28.74Z"
]
4 => array:11 [
"RoomKey" => "1663242119"
"RoomType" => "Kitchen"
"ListingId" => "40841580"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930701"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:11:28.74Z"
]
5 => array:11 [
"RoomKey" => "1663242120"
"RoomType" => "Dining room"
"ListingId" => "40841580"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930701"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:11:28.75Z"
]
6 => array:11 [
"RoomKey" => "1663242121"
"RoomType" => "Living room"
"ListingId" => "40841580"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29930701"
"RoomLength" => null
"RoomDimensions" => "17'10'' x 17'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:11:28.75Z"
]
7 => array:11 [
"RoomKey" => "1663242122"
"RoomType" => "Utility room"
"ListingId" => "40841580"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29930701"
"RoomLength" => null
"RoomDimensions" => "8'5'' x 3'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:11:28.75Z"
]
8 => array:11 [
"RoomKey" => "1663242123"
"RoomType" => "Foyer"
"ListingId" => "40841580"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29930701"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T20:11:28.76Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930701/19-picardy-drive-unit-4-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3-64"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 18.0
+"AboveGradeFinishedArea": 1380
+"OriginalEntryTimestamp": "2026-06-19T20:11:28.58Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1450381"
+"ListOfficeNationalAssociationId": "1344652"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29930701_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/dece4ae36653b6529edc7fc55cbabc8a.webp"
"MediaSize" => 132005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-dece4ae36653b6529edc7fc55cbabc8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29930701_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/b045a1cf616b8131557b66fda5dd3f0b.webp"
"MediaSize" => 140212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-b045a1cf616b8131557b66fda5dd3f0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29930701_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/6e5b7528c2d06af9dc5d10d5ed70227f.webp"
"MediaSize" => 133064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-6e5b7528c2d06af9dc5d10d5ed70227f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29930701_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/c6d3736404a402133ed0669bb28dfd9a.webp"
"MediaSize" => 123253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-c6d3736404a402133ed0669bb28dfd9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29930701_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/79ea23ec63aa63ce93566a482763e0c1.webp"
"MediaSize" => 55265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-79ea23ec63aa63ce93566a482763e0c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29930701_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/7d829c7f073ac9c441afea0c3a325dee.webp"
"MediaSize" => 62367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-7d829c7f073ac9c441afea0c3a325dee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29930701_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/72db2b1707c61c19a11b44971057b1b5.webp"
"MediaSize" => 38349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-72db2b1707c61c19a11b44971057b1b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29930701_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/a1efd7e89293f3d71d1af84091d5f0c7.webp"
"MediaSize" => 75576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-a1efd7e89293f3d71d1af84091d5f0c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29930701_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/2f33788401aafda3cc3c74dbef3b98c9.webp"
"MediaSize" => 80319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-2f33788401aafda3cc3c74dbef3b98c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29930701_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/dd056f3bc86451357f207c5768059ab4.webp"
"MediaSize" => 74360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-dd056f3bc86451357f207c5768059ab4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29930701_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/0fee8aac1e725dc9187f50b078ce8bd2.webp"
"MediaSize" => 76148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-0fee8aac1e725dc9187f50b078ce8bd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29930701_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/b04becbd4e26dba0fd801aa407236192.webp"
"MediaSize" => 75248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-b04becbd4e26dba0fd801aa407236192.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29930701_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/6626094a23d58be31011a6e6d31c1b90.webp"
"MediaSize" => 70257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-6626094a23d58be31011a6e6d31c1b90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29930701_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/06629a019f25dac05c520175a97e5e8e.webp"
"MediaSize" => 71480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-06629a019f25dac05c520175a97e5e8e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29930701_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/6fb18292b3c7e7b0608b6754420dceaf.webp"
"MediaSize" => 77525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-6fb18292b3c7e7b0608b6754420dceaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29930701_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/b3484121bdb758a761bdb7ad031e616f.webp"
"MediaSize" => 79865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-b3484121bdb758a761bdb7ad031e616f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29930701_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/524fab6dbe10980c9710dcd0a70696c6.webp"
"MediaSize" => 109935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-524fab6dbe10980c9710dcd0a70696c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29930701_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/3d598d924f55726aa2987059ed7ddc0a.webp"
"MediaSize" => 69898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-3d598d924f55726aa2987059ed7ddc0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29930701_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/ab6669ee40dc7d6ad5b4ae29085b0425.webp"
"MediaSize" => 68465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-ab6669ee40dc7d6ad5b4ae29085b0425.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29930701_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/18ceb83f784d2bbbaf7d7d69fd64b406.webp"
"MediaSize" => 54843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-18ceb83f784d2bbbaf7d7d69fd64b406.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29930701_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/9e5371ea118c00e875b788462b9e2210.webp"
"MediaSize" => 44969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-9e5371ea118c00e875b788462b9e2210.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29930701_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/89aff5dd5e4002e2b88becd28c92b5b1.webp"
"MediaSize" => 87575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-89aff5dd5e4002e2b88becd28c92b5b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29930701_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/ae1dc59463f093a23801a5f4303492de.webp"
"MediaSize" => 100974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-ae1dc59463f093a23801a5f4303492de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29930701_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/23274d0812570c2a8c89901f5b2bce96.webp"
"MediaSize" => 56260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-23274d0812570c2a8c89901f5b2bce96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29930701_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/ee7cfb036424c1c6db931de509246f87.webp"
"MediaSize" => 173153
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-ee7cfb036424c1c6db931de509246f87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29930701_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/a5815fe7f3168c5ef353738ae504d8a2.webp"
"MediaSize" => 178968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-a5815fe7f3168c5ef353738ae504d8a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29930701_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/b33e31dc38d3422bbe1140e1a242043d.webp"
"MediaSize" => 182195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-b33e31dc38d3422bbe1140e1a242043d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29930701_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/2a49c97bae1fbe6dd12e0e5a06c4d189.webp"
"MediaSize" => 140718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-2a49c97bae1fbe6dd12e0e5a06c4d189.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29930701_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/63cb0afdb4f242c5c754c524cb6a85e5.webp"
"MediaSize" => 148183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-63cb0afdb4f242c5c754c524cb6a85e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29930701_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/8e7aa5e24ab5573fde59cd035b42f5c5.webp"
"MediaSize" => 150760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-8e7aa5e24ab5573fde59cd035b42f5c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29930701_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/43c4f1962962816017c019843ad08a46.webp"
"MediaSize" => 140624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-43c4f1962962816017c019843ad08a46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29930701_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/cf3b5db3b3167ef617798b1ff899f0f6.webp"
"MediaSize" => 141512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-cf3b5db3b3167ef617798b1ff899f0f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29930701_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/8869a93565c2bfcab9d1f130b0b8f601.webp"
"MediaSize" => 118731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-8869a93565c2bfcab9d1f130b0b8f601.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29930701_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/3cd1e73fc259823d150d3ef9e08ea5e0.webp"
"MediaSize" => 127044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-3cd1e73fc259823d150d3ef9e08ea5e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29930701_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/c3244d5db8da749cd146fe2018d212e0.webp"
"MediaSize" => 142131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-c3244d5db8da749cd146fe2018d212e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29930701_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/32feef7b34a18544f8a65d34599b09d5.webp"
"MediaSize" => 138273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-32feef7b34a18544f8a65d34599b09d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29930701_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/7d79f26bc5ad75c845185cba1a7daaa1.webp"
"MediaSize" => 140916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-7d79f26bc5ad75c845185cba1a7daaa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29930701_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/ea1993f4b34406e9c079621e6c719c76.webp"
"MediaSize" => 78657
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-ea1993f4b34406e9c079621e6c719c76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29930701_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/41031c406762172415d931f977493a08.webp"
"MediaSize" => 42462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-41031c406762172415d931f977493a08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29930701_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/141aaa7252edc667deef02f5b3442fcf.webp"
"MediaSize" => 27410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-141aaa7252edc667deef02f5b3442fcf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29930701_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/5b6340e4be7702a35aa5292580f136c7.webp"
"MediaSize" => 27189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-5b6340e4be7702a35aa5292580f136c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29930701_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29930701/275e5bf6e901eb669781d5abf972e590.webp"
"MediaSize" => 32801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29930701/thumbnail-275e5bf6e901eb669781d5abf972e590.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841580"
"ResourceRecordKey" => "29930701"
"ModificationTimestamp" => "2026-06-19T20:11:28.6Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930701')"
+"ID": "1549448"
}
]
+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=OfficeMlsId eq 284635" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24911
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2201906" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24884
+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 '29930701'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25225
+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 '29930701'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25241
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29930701' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7765846 43.1843905)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25314
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1549746"
+post_author: 1
+"ListingKey": "29931294"
+"ListingId": "X13469260"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T22:25:34Z"
+"RFModificationTimestamp": "2026-06-19T22:28:58Z"
+"ListPrice": 589999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0M7"
+"UnparsedAddress": "4 - 19 PICARDY DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J0M7"
+"Coordinates": array:2 [
0 => -79.776303
1 => 43.182992
]
+"Latitude": 43.182992
+"Longitude": -79.776303
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully built 3-level townhouse offering modern living in an unbeatable location. Featuring a spacious and functional layout, this home boasts bright open-concept living spaces, stylish finishes, generous-sized bedrooms, and the added convenience of a private garage for parking and extra storage. Perfect for families, professionals, or investors, this property is situated in a fantastic area close to shopping, restaurants, schools, parks, transit, and major highways - truly close to everything you need. Move-in ready and thoughtfully designed, this is a wonderful opportunity to own a stylish home in a highly desirable community! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Heater - Tankless"
]
+"AssociationFee": "109.29"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:28:55.290329+00:00"
+"Directions": "Cross Streets: Highland and Picardy. ** Directions: Upper Centennial Pkwy to Highland Rd W to Picardy."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Facing"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2188730"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "18.3 x 61.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T21:30:43Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T21:52:49Z"
+"Stories": "3.0"
+"StreetName": "PICARDY"
+"StreetNumber": "19"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3423"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1663330028"
"RoomType" => "Foyer"
"ListingId" => "X13469260"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.0
"ListingKey" => "29931294"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.38Z"
]
1 => array:11 [
"RoomKey" => "1663330029"
"RoomType" => "Utility room"
"ListingId" => "X13469260"
"RoomLevel" => "Basement"
"RoomWidth" => 2.57
"ListingKey" => "29931294"
"RoomLength" => 0.99
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.39Z"
]
2 => array:11 [
"RoomKey" => "1663330030"
"RoomType" => "Living room"
"ListingId" => "X13469260"
"RoomLevel" => "Main level"
"RoomWidth" => 5.44
"ListingKey" => "29931294"
"RoomLength" => 5.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.39Z"
]
3 => array:11 [
"RoomKey" => "1663330031"
"RoomType" => "Dining room"
"ListingId" => "X13469260"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "29931294"
"RoomLength" => 2.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.4Z"
]
4 => array:11 [
"RoomKey" => "1663330032"
"RoomType" => "Kitchen"
"ListingId" => "X13469260"
"RoomLevel" => "Main level"
"RoomWidth" => 2.67
"ListingKey" => "29931294"
"RoomLength" => 2.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.4Z"
]
5 => array:11 [
"RoomKey" => "1663330033"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13469260"
"RoomLevel" => "Second level"
"RoomWidth" => 3.63
"ListingKey" => "29931294"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.4Z"
]
6 => array:11 [
"RoomKey" => "1663330034"
"RoomType" => "Bathroom"
"ListingId" => "X13469260"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29931294"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.41Z"
]
7 => array:11 [
"RoomKey" => "1663330035"
"RoomType" => "Bedroom"
"ListingId" => "X13469260"
"RoomLevel" => "Second level"
"RoomWidth" => 2.57
"ListingKey" => "29931294"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.41Z"
]
8 => array:11 [
"RoomKey" => "1663330036"
"RoomType" => "Bathroom"
"ListingId" => "X13469260"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29931294"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T21:52:49.42Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931294/4-19-picardy-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 18.3
+"OriginalEntryTimestamp": "2026-06-19T21:30:43.02Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1437783"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29931294_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/e00c555b3d227fe5e2819154e638ef92.webp"
"MediaSize" => 322443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-e00c555b3d227fe5e2819154e638ef92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29931294_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/a87455e010a7850245b26e9c16a18136.webp"
"MediaSize" => 341144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-a87455e010a7850245b26e9c16a18136.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29931294_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/2ac08d951fa1bc04593bb0870ca4238f.webp"
"MediaSize" => 321827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-2ac08d951fa1bc04593bb0870ca4238f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29931294_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/673a8f05b77764b0f7a6ffc595b0a1a8.webp"
"MediaSize" => 291604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-673a8f05b77764b0f7a6ffc595b0a1a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29931294_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/21205b4285924dd16b60b01969f180a9.webp"
"MediaSize" => 128060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-21205b4285924dd16b60b01969f180a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29931294_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/c1cedd4492528f9b939c994875881a01.webp"
"MediaSize" => 157033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-c1cedd4492528f9b939c994875881a01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29931294_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/8b768accb8fedb063cb73e7ab33a7a58.webp"
"MediaSize" => 95027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-8b768accb8fedb063cb73e7ab33a7a58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29931294_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/7eb28f25534dbc6e8a455905a42eb258.webp"
"MediaSize" => 171611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931294/thumbnail-7eb28f25534dbc6e8a455905a42eb258.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469260"
"ResourceRecordKey" => "29931294"
"ModificationTimestamp" => "2026-06-19T21:30:43.03Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29931294_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931294/95912af6ed27ac95f11b7c4d10cd9108.webp"
…10
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931294')"
+"ID": "1549746"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25290
+post_id: "1548755"
+post_author: 1
+"ListingKey": "29929497"
+"ListingId": "40840776"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T18:10:06Z"
+"RFModificationTimestamp": "2026-06-19T20:15:40Z"
+"ListPrice": 969900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3088.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J2T2"
+"UnparsedAddress": "111 AUBREY Avenue, Stoney Creek, Ontario L8J2T2"
+"Coordinates": array:2 [
0 => -79.7795153
1 => 43.1822947
]
+"Latitude": 43.1822947
+"Longitude": -79.7795153
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located on the prestigious Stoney Creek Mountain in one of the area's most exclusive neighbourhoods, this exceptional property is surrounded by luxury custom homes and stunning tear-down rebuilds. Offering incredible versatility and space, the main level features an updated kitchen and a functional layout with three spacious bedrooms upstairs. Step outside to a beautifully upgraded backyard complete with stamped concrete, creating the perfect setting for entertaining or relaxing. The fully finished lower level offers an ideal in-law suite with a separate entrance, featuring its own full kitchen, living room, and two bedrooms—perfect for multigenerational living, extended family, or additional flexibility. Complete with a two-car garage and parking for two additional vehicles in the private driveway, this is a rare opportunity to own in one of Stoney Creek Mountain's most sought-after communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T20:15:34.595236+00:00"
+"Directions": "Upper Cenntenial to Highland Rd to Aubrey Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623259"
+"ListOfficeKey": "275165"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T17:52:36Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T17:52:36Z"
+"Stories": "2.0"
+"StreetName": "AUBREY"
+"StreetNumber": "111"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "504 - Leckie Park/Highland"
+"TaxAnnualAmount": "6172.12"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29929497/111-aubrey-avenue-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1983
+"BelowGradeFinishedArea": 1105
+"OriginalEntryTimestamp": "2026-06-19T17:52:36.27Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1161082"
+"ListOfficeNationalAssociationId": "1262401"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929497')"
+"ID": "1548755"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1532434"
+post_author: 1
+"ListingKey": "29905671"
+"ListingId": "X13446794"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:05:11Z"
+"RFModificationTimestamp": "2026-06-15T22:05:40Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R1P0"
+"UnparsedAddress": "53 AQUARIUS CRESCENT, Hamilton, Ontario L0R1P0"
+"Coordinates": array:2 [
0 => -79.7861225
1 => 43.1732547
]
+"Latitude": 43.1732547
+"Longitude": -79.7861225
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully styled 3-bedroom townhome tucked away in a quiet, family-friendly community on sought-after Stoney Creek mountain. Freshly painted and filled with natural light, this move-in-ready home offers the perfect blend of style, function, and everyday comfort. The main floor features 9-foot ceilings, modern pot lights, and a thoughtfully designed kitchen with custom cabinetry, a breakfast bar, and plenty of prep space for busy mornings or entertaining friends and family. At the front of the home, a dedicated dining room provides the perfect setting for hosting holiday dinners or gathering with family and friends. From the kitchen, the spacious living area flows effortlessly to sliding doors leading to an elevated and private, southeast-facing deck - an ideal spot to enjoy your morning coffee or unwind at the end of the day. Upstairs, the generous primary suite offers double closets and a private ensuite, while two additional bedrooms provide flexible space for kids, guests, or a home office. The bright walkout lower level adds even more versatility with direct backyard access and endless possibilities for a rec room, fourth bedroom, or home gym. Just steps from the neighbourhood park and close to schools, shopping, restaurants, and every convenience, this home offers an exceptional lifestyle in one of Stoney Creek's most desirable locations. Whether you're a first-time buyer, downsizer, or investor, this is an opportunity you won't want to miss. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T22:05:30.694564+00:00"
+"Directions": "Cross Streets: Rymal Rd & Terryberry Rd. ** Directions: From Rymal Rd, turn onto Terryberry Rd., left on Dalgleish Trail, left on Canary Grass Blvd., left on Aquarius Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952102"
+"ListOfficeKey": "285151"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "15 x 86.2 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:56:14Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:13Z"
+"Stories": "3.0"
+"StreetName": "Aquarius"
+"StreetNumber": "53"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4026.64"
+"VirtualTourURLUnbranded": "https://youriguide.com/53_aquarius_cres_hamilton_on/https://youriguide.com/53_aquarius_cres_hamilton_on/"
+"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": "Oakville-Milton"
+"CityRegion": "Rural Glanbrook"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29905671/53-aquarius-crescent-hamilton-rural-glanbrook"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2050273"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285151"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 15.0
+"OriginalEntryTimestamp": "2026-06-15T18:56:13.69Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1245775"
+"ListOfficeNationalAssociationId": "1347969"
+"CoListAgentNationalAssociationId": "1325722"
+"CoListOfficeNationalAssociationId": "1347969"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905671')"
+"ID": "1532434"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "1532435"
+post_author: 1
+"ListingKey": "29905461"
+"ListingId": "X13446472"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:05:04Z"
+"RFModificationTimestamp": "2026-06-16T19:09:10Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0J7"
+"UnparsedAddress": "17 NARBONNE CRESCENT, Hamilton (Stoney Creek Mountain), Ontario L8J0J7"
+"Coordinates": array:2 [
0 => -79.77968
1 => 43.186331
]
+"Latitude": 43.186331
+"Longitude": -79.77968
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 17 Narbonne Crescent in desirable Stoney Creek! Situated on a premium oversized corner lot, this beautifully maintained home offers exceptional space, comfort, and potential for growing families. Inside, you'll find four generously sized bedrooms and an abundance of natural light that fills the home through large windows, creating a bright and inviting atmosphere throughout. Thoughtfully updated with numerous upgrades, this home blends functionality with modern appeal. The spacious layout provides plenty of room for everyday living and entertaining, while the unfinished basement offers a blank canvas to create additional living space, a home gym, recreation room, or in-law suite tailored to your needs. Step outside to enjoy the covered rear patio-perfect for relaxing, hosting guests, or extending your outdoor living season. The expansive corner lot provides excellent curb appeal, additional yard space, and added privacy. Located in a family-friendly neighbourhood close to parks, schools, shopping, and major commuter routes, this is a fantastic opportunity to own a move-in-ready home in one of Stoney Creek's most sought-after communities. Don't miss your chance to make this bright, spacious, and upgraded property your next home! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Furniture"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
9 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-15T19:32:45.673191+00:00"
+"Directions": "Cross Streets: Narbonne Cres & Chaumont Dr. ** Directions: From First Rd W, Turn Onto Lormont Blvd, Right Onto Chaumont Dr, Left Onto Narbonne Cres, Property On Right."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "46.5 x 110.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:37:21Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T18:58:44Z"
+"Stories": "2.0"
+"StreetName": "Narbonne"
+"StreetNumber": "17"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6246.48"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=NVdN9tD5o5b"
+"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": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905461/17-narbonne-crescent-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 46.6
+"OriginalEntryTimestamp": "2026-06-15T18:37:20.59Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905461')"
+"ID": "1532435"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25289
+post_id: "1532436"
+post_author: 1
+"ListingKey": "29905460"
+"ListingId": "X13446466"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:05:11Z"
+"RFModificationTimestamp": "2026-06-15T19:34:17Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0E8"
+"UnparsedAddress": "12 - 70 HIGHGATE DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J0E8"
+"Coordinates": array:2 [
0 => -79.7793009
1 => 43.1780002
]
+"Latitude": 43.1780002
+"Longitude": -79.7793009
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stunning move-in ready freehold townhouse in desirable Stoney Creek featuring a spacious three-bedroom layout plus an upper-level loft perfect for home office. The home is highlighted by beautiful finishes throughout, including hardwood flooring throughout, a floating oak staircase, and a bright, open-concept main floor. The gourmet white kitchen is equipped with stainless steel appliances, granite countertops, a stylish tile backsplash with under cabinet lighting, and a breakfast bar. The living area flows seamlessly to a fully fenced backyard, perfect for outdoor relaxation. The large bright primary suite serves as a true retreat with a walk-in closet and a renovated three-piece ensuite. The finished basement adds significant value with hardwood floors, a beautiful electric fireplace set against a decorative stone wall, an oversized window, and a dedicated laundry area. Additional features include an interior garage entry, ample storage, and a convenient $95/month POTL fee. Please note that the Listing Agent is related to the seller. (id:62783)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Stove"
2 => "Blinds"
3 => "Window Coverings"
4 => "Garage door opener remote(s)"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:32:33.922978+00:00"
+"Directions": "Cross Streets: Upper Pkwy & Highgate Dr. ** Directions: Upper Pkwy to Highgate Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094277"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Level"
2 => "Carpet Free"
]
+"LotSizeDimensions": "20 x 82.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:37:20Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T18:56:51Z"
+"Stories": "2.0"
+"StreetName": "Highgate"
+"StreetNumber": "70"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4498"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://listing.at-photo.ca/videos/019e738a-43f1-705a-9028-950c806273d8"
+"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": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29905460/12-70-highgate-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "RM3-35"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.0
+"OriginalEntryTimestamp": "2026-06-15T18:37:20.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1367911"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905460')"
+"ID": "1532436"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: "1530992"
+post_author: 1
+"ListingKey": "29905376"
+"ListingId": "40839706"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T15:20:40Z"
+"RFModificationTimestamp": "2026-06-17T15:46:07Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1674.0
+"BuildingAreaTotal": 0
+"City": "Hannon"
+"PostalCode": "L0R1P0"
+"UnparsedAddress": "53 AQUARIUS Crescent, Hannon, Ontario L0R1P0"
+"Coordinates": array:2 [
0 => -79.7861384
1 => 43.1732572
]
+"Latitude": 43.1732572
+"Longitude": -79.7861384
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully styled 3-bedroom townhome tucked away in a quiet, family-friendly community on sought-after Stoney Creek mountain. Freshly painted and filled with natural light, this move-in-ready home offers the perfect blend of style, function, and everyday comfort. The main floor features 9-foot ceilings, modern pot lights, and a thoughtfully designed kitchen with custom cabinetry, a breakfast bar, and plenty of prep space for busy mornings or entertaining friends and family. At the front of the home, a dedicated dining room provides the perfect setting for hosting holiday dinners or gathering with family and friends. From the kitchen, the spacious living area flows effortlessly to sliding doors leading to an elevated and private, southeast-facing deck - an ideal spot to enjoy your morning coffee or unwind at the end of the day. Upstairs, the generous primary suite offers double closets and a private ensuite, while two additional bedrooms provide flexible space for kids, guests, or a home office. The bright walkout lower level adds even more versatility with direct backyard access and endless possibilities for a rec room, fourth bedroom, or home gym. Just steps from the neighbourhood park and close to schools, shopping, restaurants, and every convenience, this home offers an exceptional lifestyle in one of Stoney Creek’s most desirable locations. Whether you’re a first-time buyer, downsizer, or investor, this is an opportunity you won’t want to miss. (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"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:17:44.147415+00:00"
+"Directions": "From Rymal Rd, turn onto Terryberry Rd., left on Dalgleish Trail, left on Canary Grass Blvd., left on Aquarius Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239450"
+"ListOfficeKey": "299790"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T15:12:36Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:12:36Z"
+"Stories": "3.0"
+"StreetName": "AQUARIUS"
+"StreetNumber": "53"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "504 - Leckie Park/Highland"
+"TaxAnnualAmount": "4026.64"
+"VirtualTourURLUnbranded": "https://youriguide.com/53_aquarius_cres_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29905376/53-aquarius-crescent-hannon"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2050273"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299790"
+"GeocodeManualYN": true
+"ZoningDescription": "RM4 - 289"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 15.0
+"AboveGradeFinishedArea": 1674
+"OriginalEntryTimestamp": "2026-06-15T18:32:40.16Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1477386"
+"ListOfficeNationalAssociationId": "1476846"
+"CoListAgentNationalAssociationId": "1325722"
+"CoListOfficeNationalAssociationId": "1476846"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905376')"
+"ID": "1530992"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1530804"
+post_author: 1
+"ListingKey": "29905032"
+"ListingId": "40839409"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:00:09Z"
+"RFModificationTimestamp": "2026-06-16T18:28:03Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2125.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J0J7"
+"UnparsedAddress": "17 NARBONNE Crescent, Stoney Creek, Ontario L8J0J7"
+"Coordinates": array:2 [
0 => -79.7797008
1 => 43.1862603
]
+"Latitude": 43.1862603
+"Longitude": -79.7797008
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 17 Narbonne Crescent in desirable Stoney Creek! Situated on a premium oversized corner lot, this beautifully maintained home offers exceptional space, comfort, and potential for growing families. Inside, you'll find four generously sized bedrooms and an abundance of natural light that fills the home through large windows, creating a bright and inviting atmosphere throughout. Thoughtfully updated with numerous upgrades, this home blends functionality with modern appeal. The spacious layout provides plenty of room for everyday living and entertaining, while the unfinished basement offers a blank canvas to create additional living space, a home gym, recreation room, or in-law suite tailored to your needs. Step outside to enjoy the covered rear patio—perfect for relaxing, hosting guests, or extending your outdoor living season. The expansive corner lot provides excellent curb appeal, additional yard space, and added privacy. Located in a family-friendly neighbourhood close to parks, schools, shopping, and major commuter routes, this is a fantastic opportunity to own a move-in-ready home in one of Stoney Creek’s most sought-after communities. Don't miss your chance to make this bright, spacious, and upgraded property your next home! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T18:34:36.517772+00:00"
+"Directions": "From First Rd W, Turn Onto Lormont Blvd, Right Onto Chaumont Dr, Left Onto Narbonne Cres, Property On Right"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T17:51:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T17:52:41Z"
+"Stories": "2.0"
+"StreetName": "NARBONNE"
+"StreetNumber": "17"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "502 - Felker"
+"TaxAnnualAmount": "6246.48"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=NVdN9tD5o5b"
+"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/29905032/17-narbonne-crescent-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2208479"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299867"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 47.0
+"AboveGradeFinishedArea": 2125
+"OriginalEntryTimestamp": "2026-06-15T17:51:43.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1454953"
+"CoListOfficeNationalAssociationId": "1477945"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905032')"
+"ID": "1530804"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+post_id: "1524745"
+post_author: 1
+"ListingKey": "29895690"
+"ListingId": "X13437284"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:25:28Z"
+"RFModificationTimestamp": "2026-06-19T21:30:55Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J3Z4"
+"UnparsedAddress": "35 - 39 PINEWOODS DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J3Z4"
+"Coordinates": array:2 [
0 => -79.774625
1 => 43.180455
]
+"Latitude": 43.180455
+"Longitude": -79.774625
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 35 at 39 Pinewoods Drive, a beautifully updated 3-bedroom, 1.5-bathroom townhome in a desirable Stoney Creek neighbourhood. This move-in-ready home features an updated kitchen with stainless steel appliances, stylish vinyl flooring, and pot lights throughout the main floor. The bright and functional layout offers comfortable living and dining spaces, while the upper level features three, carpet-free bedrooms, including a primary bedroom with a walk-in closet. An unfinished basement provides excellent storage and future potential. Enjoy peace of mind with a newer roof (2017), furnace (2026), washer and dryer (2026), and an attached garage with automatic garage door opener. Ideally located close to schools, parks, shopping, restaurants, public transit, and community amenities. Commuters will appreciate easy access to the Red Hill Valley Parkway, LINC, QEW, and Highway 403. Whether you're a first-time buyer, investor, or downsizer, this home offers exceptional value in a convenient, family-friendly location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"AssociationFee": "195.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:36:29.664657+00:00"
+"Directions": "Cross Streets: Highland Rd W & Upper Centennial. ** Directions: Highland Rd W to Highbury, to Pinewoods."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2094057"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T16:31:49Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:55:26Z"
+"Stories": "2.0"
+"StreetName": "Pinewoods"
+"StreetNumber": "39"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3092.74"
+"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": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29895690/35-39-pinewoods-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Arthex Property Management"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-12T16:31:49.6Z"
+"ListAgentNationalAssociationId": "1366548"
+"ListOfficeNationalAssociationId": "1243249"
+"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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895690')"
+"ID": "1524745"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "1524636"
+post_author: 1
+"ListingKey": "29896136"
+"ListingId": "40837830"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:30:21Z"
+"RFModificationTimestamp": "2026-06-12T19:23:49Z"
+"ListPrice": 1249900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.125
+"LivingArea": 3778.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J3X2"
+"UnparsedAddress": "26 SHADETREE Crescent, Stoney Creek, Ontario L8J3X2"
+"Coordinates": array:2 [
0 => -79.7944236
1 => 43.1846205
]
+"Latitude": 43.1846205
+"Longitude": -79.7944236
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 26 Shadetree Crescent, an exceptional executive residence nestled in one of Stoney Creek Mountain's most sought-after family neighbourhoods. Offering over 3,700 square feet of finished living space, including 2,807 square feet above grade, this impressive 4-bedroom home combines timeless elegance, exceptional privacy & resort-style outdoor living. Step through the grand double-door entry into a breathtaking foyer highlighted by a sweeping curved staircase with wrought iron balusters, soaring ceilings & an abundance of natural light. The thoughtfully designed main floor features spacious principal rooms, a formal living & dining room, a private den perfect for a home office & a warm, inviting family room with gas fireplace. The spacious eat-in kitchen overlooks the backyard oasis & seamlessly connects to the breakfast area with walkout access to an elevated deck, making entertaining effortless. Upstairs, you'll find four generously sized bedrooms, including a stunning primary retreat featuring a walk-in closet & private ensuite bath. Convenient second-floor laundry adds everyday functionality for growing families. The fully finished lower level provides outstanding additional living space with a large recreation room, dedicated office area & ample storage, offering flexibility for multi-generational living, hobbies, or work-from-home needs. Outside, discover your own private backyard paradise. Backing directly onto mature green space with no rear neighbours, this spectacular setting offers complete privacy & tranquility. Enjoy summer days around the heated in-ground pool, entertain, or unwind on the expansive patios surrounded by lush landscaping & towering trees. Ideally located close to top-rated schools, parks, shopping, restaurants, community centres & major highway access, this is a rare opportunity to own a beautifully maintained family home in one of Stoney Creek Mountain's premier locations. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Central Vacuum - Roughed In"
6 => "Hood Fan"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:23:42.039540+00:00"
+"Directions": "Highland Rd W to Second Rd W to Shadetree Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Automatic Garage Door Opener"
1 => "Private Yard"
]
+"LotSizeDimensions": "0.125"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:10:27Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T17:10:27Z"
+"Stories": "2.0"
+"StreetName": "SHADETREE"
+"StreetNumber": "26"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "503 - Trinity"
+"TaxAnnualAmount": "7872"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29896136/26-shadetree-crescent-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 2807
+"BelowGradeFinishedArea": 971
+"OriginalEntryTimestamp": "2026-06-12T17:10:27.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896136')"
+"ID": "1524636"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 100
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]