array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29891430 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1521034"
+post_author: 1
+"ListingKey": "29891430"
+"ListingId": "X13433424"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:49:20Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8J0G4"
+"UnparsedAddress": "39 MAYLAND TRAIL, Hamilton (Stoney Creek), Ontario L8J0G4"
+"Coordinates": array:2 [
0 => -79.773451
1 => 43.18963
]
+"Latitude": 43.18963
+"Longitude": -79.773451
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Amazing Views in Stoney Creek! Welcome to 39 Mayland Trail. This stunning freehold townhouse is loaded with upgrades and offers breathtaking, unobstructed pond views. With over $30,000 spent on quality improvements, this home is sure to impress. Enjoy an abundance of natural light throughout the open-concept living space, perfect for both everyday living and entertaining.The modern white kitchen features stylish shaker-style cabinetry and contemporary finishes. A convenient walk-out from the main floor leads to a private outdoor space where you can relax and take in the picturesque scenery.Located in a highly desirable Stoney Creek neighbourhood, this home offers exceptional convenience with easy access to the Lincoln Alexander Parkway, Red Hill Valley Parkway, QEW, Highway 403, GO Transit, public transit, schools, shopping, and everyday amenities.A fantastic opportunity to own a beautifully upgraded home in a prime location! (id:62783)"
+"Appliances": array:2 [
0 => "All"
1 => "Window Coverings"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:49:11.768377+00:00"
+"Directions": "Cross Streets: Mud St/Upper Centennial. ** Directions: Mud St. to Trafalgar Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423901"
+"ListOfficeKey": "284505"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "18 x 76.8 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:51Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:51Z"
+"Stories": "3.0"
+"StreetName": "Mayland"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "4324.49"
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1657299332"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13433424"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.29
"ListingKey" => "29891430"
"RoomLength" => 3.36
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T19:54:51.79Z"
]
1 => array:11 [
"RoomKey" => "1657299333"
"RoomType" => "Kitchen"
"ListingId" => "X13433424"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.47
"ListingKey" => "29891430"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T19:54:51.79Z"
]
2 => array:11 [
"RoomKey" => "1657299334"
"RoomType" => "Eating area"
"ListingId" => "X13433424"
"RoomLevel" => "Main level"
"RoomWidth" => 2.47
"ListingKey" => "29891430"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T19:54:51.79Z"
]
3 => array:11 [
"RoomKey" => "1657299335"
"RoomType" => "Dining room"
"ListingId" => "X13433424"
"RoomLevel" => "Main level"
"RoomWidth" => 4.15
"ListingKey" => "29891430"
"RoomLength" => 6.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T19:54:51.79Z"
]
4 => array:11 [
"RoomKey" => "1657299336"
"RoomType" => "Living room"
"ListingId" => "X13433424"
"RoomLevel" => "Main level"
"RoomWidth" => 4.15
"ListingKey" => "29891430"
"RoomLength" => 6.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T19:54:51.8Z"
]
5 => array:11 [
"RoomKey" => "1657299337"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13433424"
"RoomLevel" => "Third level"
"RoomWidth" => 3.35
"ListingKey" => "29891430"
"RoomLength" => 4.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T19:54:51.8Z"
]
6 => array:11 [
"RoomKey" => "1657299338"
"RoomType" => "Bedroom 2"
"ListingId" => "X13433424"
"RoomLevel" => "Third level"
"RoomWidth" => 3.35
"ListingKey" => "29891430"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-11T19:54:51.8Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891430/39-mayland-trail-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2130897"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284505"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 18.0
+"OriginalEntryTimestamp": "2026-06-11T19:54:51.76Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1119532"
+"ListOfficeNationalAssociationId": "1342135"
+"CoListAgentNationalAssociationId": "1383711"
+"CoListOfficeNationalAssociationId": "1342135"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29891430_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/f544eae5d9b54a787defea784e7a066b.webp"
"MediaSize" => 54845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-f544eae5d9b54a787defea784e7a066b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29891430_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/fcda2720fb9b9c65b45578d4a5b58ee0.webp"
"MediaSize" => 46321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-fcda2720fb9b9c65b45578d4a5b58ee0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29891430_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/c4de689647784631b2dee621b9d1cded.webp"
"MediaSize" => 58625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-c4de689647784631b2dee621b9d1cded.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29891430_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/9a83ec0d606517be3ea229517884aa43.webp"
"MediaSize" => 43818
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-9a83ec0d606517be3ea229517884aa43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29891430_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/b472cd4ef12742ced908c0a2332ad315.webp"
"MediaSize" => 48880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-b472cd4ef12742ced908c0a2332ad315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29891430_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/13f69c22995fa044ac7b3adbbf756ea7.webp"
"MediaSize" => 34358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-13f69c22995fa044ac7b3adbbf756ea7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29891430_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/62caee8878a64e79af6d6cd28a803110.webp"
"MediaSize" => 43290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-62caee8878a64e79af6d6cd28a803110.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29891430_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/29efe84e714442ab39b6a954c3d3cc71.webp"
"MediaSize" => 30394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-29efe84e714442ab39b6a954c3d3cc71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29891430_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/e2702785c477625c37d050ec51e871c7.webp"
"MediaSize" => 44073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-e2702785c477625c37d050ec51e871c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29891430_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/90a35880e553295cfab24422684ec355.webp"
"MediaSize" => 29256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-90a35880e553295cfab24422684ec355.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29891430_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/0ed5988db2bc4363b3f750bf43bc1335.webp"
"MediaSize" => 46321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-0ed5988db2bc4363b3f750bf43bc1335.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29891430_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/ceed73012e2c3621d532e028e5d844dd.webp"
"MediaSize" => 35092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-ceed73012e2c3621d532e028e5d844dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29891430_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/39a06886e3c9b6627f2ab5a45e03aa73.webp"
"MediaSize" => 25166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-39a06886e3c9b6627f2ab5a45e03aa73.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29891430_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/fba2ab02aece39b2d2e582e0901b31f6.webp"
"MediaSize" => 34478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-fba2ab02aece39b2d2e582e0901b31f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29891430_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/52fd5ff922590db02e752c0977b822dd.webp"
"MediaSize" => 28313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-52fd5ff922590db02e752c0977b822dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29891430_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/b353d6b79c2521189342ded6e6a06264.webp"
"MediaSize" => 31617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-b353d6b79c2521189342ded6e6a06264.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29891430_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/d32d761fd94a15b7791179bf3ddde096.webp"
"MediaSize" => 32243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-d32d761fd94a15b7791179bf3ddde096.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29891430_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/28b78f32591a13df41d1d3681c03e1d1.webp"
"MediaSize" => 43677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-28b78f32591a13df41d1d3681c03e1d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29891430_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/b8992a1d8025e8fee84a99cd85369388.webp"
"MediaSize" => 35092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-b8992a1d8025e8fee84a99cd85369388.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29891430_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/54366a74721747fd74c40a0631a9d113.webp"
"MediaSize" => 34225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-54366a74721747fd74c40a0631a9d113.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29891430_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/9f7ecad5bca01695bc2ae0708adce4cd.webp"
"MediaSize" => 33902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-9f7ecad5bca01695bc2ae0708adce4cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29891430_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891430/4ef84a0cb9344f31f2c361eced34e668.webp"
"MediaSize" => 26329
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891430/thumbnail-4ef84a0cb9344f31f2c361eced34e668.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13433424"
"ResourceRecordKey" => "29891430"
"ModificationTimestamp" => "2026-06-11T19:54:51.76Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891430')"
+"ID": "1521034"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284505" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24741
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1423901" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24826
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29891430'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25125
+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 '29891430'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25141
+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 '29891430' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.773451 43.18963)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25194
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+post_id: "1539162"
+post_author: 1
+"ListingKey": "29914609"
+"ListingId": "40840183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:20:04Z"
+"RFModificationTimestamp": "2026-06-17T17:17:52Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2441.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J0K9"
+"UnparsedAddress": "35 MIDHURST Heights Unit# 1, Hamilton, Ontario L8J0K9"
+"Coordinates": array:2 [
0 => -79.7653957
1 => 43.2049018
]
+"Latitude": 43.2049018
+"Longitude": -79.7653957
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beyond a home, Fallingwater is a statement of arrival and a masterpiece of the esteemed Losani Collection. This is not merely Unit #1; it is the vision that set the standard, the original model home that showcased the full potential of contemporary luxury living in Stoney Creek. Commanding the most expansive, pie-shaped lot, this end-unit sanctuary offers unrivaled privacy and a breathtaking, direct view over a tranquil outdoor pond—a serene vista enjoyed from your principal rooms. With only three units in the complex, exclusivity is paramount, and this residence represents the undisputed pinnacle. Step inside to discover over 2,441 square feet of impeccably designed, living space, artfully enhanced by high ceilings that amplifies the sense of light and volume. The home unfolds with the grace of a gallery, leading you to a sprawling 164 sq. ft. elevated terrace, your private stage for outdoor entertaining. Ascend further to the 241 sq. ft. rooftop terrace—a crowning glory offering panoramic views and an unparalleled space for sunset soirees or peaceful contemplation. While other, more modestly scaled units are available in the complex, Fallingwater stands apart. It is the largest, the first, and by every measure, the finest. This is the home for those who seek not just square footage, but significance; not just a view, but a vista; not just a unit, but a legacy property. Presented with professional photography that captures its exquisite d architectural brilliance, Fallingwater awaits its final curator. This is your chance to acquire the cornerstone residence of Stone Creek's most distinguished address. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Central Vacuum - Roughed In"
]
+"AssociationFee": "446.64"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T17:17:25.256814+00:00"
+"Directions": "Green Mountain and Upper Centennial"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525060"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T13:10:49Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T13:10:48Z"
+"Stories": "2.0"
+"StreetName": "MIDHURST"
+"StreetNumber": "35"
+"StreetSuffix": "Heights"
+"SubdivisionName": "500 - Heritage Green"
+"TaxAnnualAmount": "6995.42"
+"View": "View of water"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1661084841"
"RoomType" => "Storage"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 20'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.96Z"
]
1 => array:11 [
"RoomKey" => "1661084842"
"RoomType" => "Eat in kitchen"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.96Z"
]
2 => array:11 [
"RoomKey" => "1661084843"
"RoomType" => "Sitting room"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.96Z"
]
3 => array:11 [
"RoomKey" => "1661084844"
"RoomType" => "Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
4 => array:11 [
"RoomKey" => "1661084845"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840183"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
5 => array:11 [
"RoomKey" => "1661084846"
"RoomType" => "Dining room"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 16'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
6 => array:11 [
"RoomKey" => "1661084847"
"RoomType" => "Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
7 => array:11 [
"RoomKey" => "1661084848"
"RoomType" => "Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.97Z"
]
8 => array:11 [
"RoomKey" => "1661084849"
"RoomType" => "Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
9 => array:11 [
"RoomKey" => "1661084850"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
10 => array:11 [
"RoomKey" => "1661084851"
"RoomType" => "Laundry room"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
11 => array:11 [
"RoomKey" => "1661084852"
"RoomType" => "Loft"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
12 => array:11 [
"RoomKey" => "1661084853"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840183"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
13 => array:11 [
"RoomKey" => "1661084854"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
14 => array:11 [
"RoomKey" => "1661084855"
"RoomType" => "Great room"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
15 => array:11 [
"RoomKey" => "1661084856"
"RoomType" => "Kitchen"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
16 => array:11 [
"RoomKey" => "1661084857"
"RoomType" => "Den"
"ListingId" => "40840183"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914609"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:10:48.98Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914609/35-midhurst-heights-unit-1-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "P5, RM3-50, RM3-51"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 2441
+"OriginalEntryTimestamp": "2026-06-17T13:10:48.91Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1135225"
+"ListOfficeNationalAssociationId": "1132083"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29914609_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/a8f8b7266614a03c61a7387a29e89864.webp"
"MediaSize" => 113263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-a8f8b7266614a03c61a7387a29e89864.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29914609_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/d8ba72ef1054b9db8096b2cf30f8f2fd.webp"
"MediaSize" => 123044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-d8ba72ef1054b9db8096b2cf30f8f2fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29914609_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/baf6ae96e5dcc598d13a346856846719.webp"
"MediaSize" => 185547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-baf6ae96e5dcc598d13a346856846719.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29914609_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/fd4d534d39cfc0369254a921f49c28da.webp"
"MediaSize" => 66662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-fd4d534d39cfc0369254a921f49c28da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29914609_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/b05b1020c036dfb634e54d910cdbf433.webp"
"MediaSize" => 69434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-b05b1020c036dfb634e54d910cdbf433.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29914609_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/9cdee34c63930d934c8e300c135133a1.webp"
"MediaSize" => 57166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-9cdee34c63930d934c8e300c135133a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29914609_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/3a13603e01660839bebbb150b478c7c2.webp"
"MediaSize" => 57850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-3a13603e01660839bebbb150b478c7c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29914609_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/68e35b3def9c61e4459148b0453ce08c.webp"
"MediaSize" => 56380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-68e35b3def9c61e4459148b0453ce08c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29914609_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/330d6812c3830014f1256f8aba0b7898.webp"
"MediaSize" => 67175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-330d6812c3830014f1256f8aba0b7898.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29914609_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/89541516e4d380593d3e2fe61b6e6121.webp"
"MediaSize" => 84231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-89541516e4d380593d3e2fe61b6e6121.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29914609_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/519ada1eb8027218a1ab85d0ea3b6e59.webp"
"MediaSize" => 76381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-519ada1eb8027218a1ab85d0ea3b6e59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29914609_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/07c0256e7b03c63caeb52a606f242ba8.webp"
"MediaSize" => 78150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-07c0256e7b03c63caeb52a606f242ba8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29914609_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/1825d966b29cbac6bd9969d2defd8cda.webp"
"MediaSize" => 95461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-1825d966b29cbac6bd9969d2defd8cda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29914609_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/eb71792cdd0a8a7e7c0374ad4af7044e.webp"
"MediaSize" => 80559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-eb71792cdd0a8a7e7c0374ad4af7044e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29914609_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/f257372fb6edd6c8b02548c52c29116d.webp"
"MediaSize" => 74774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-f257372fb6edd6c8b02548c52c29116d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29914609_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/615bd5ef147b90ac7b7f49e0aca38727.webp"
"MediaSize" => 82884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-615bd5ef147b90ac7b7f49e0aca38727.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29914609_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/02b1b038e8ccd7a96426774949dbfdb5.webp"
"MediaSize" => 73169
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-02b1b038e8ccd7a96426774949dbfdb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29914609_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/7ea20e5d1ee5186711331655a0cde5c6.webp"
"MediaSize" => 43555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-7ea20e5d1ee5186711331655a0cde5c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29914609_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/554d4408519aa178860773569f073e4f.webp"
"MediaSize" => 75384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-554d4408519aa178860773569f073e4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29914609_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/c4f489b49ef08c8a9287284877c62c9c.webp"
"MediaSize" => 69627
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-c4f489b49ef08c8a9287284877c62c9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29914609_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/5e99b744342ebb4c9dd393aae750ba98.webp"
"MediaSize" => 80313
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-5e99b744342ebb4c9dd393aae750ba98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29914609_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/c3fd2addbe4123220449c60bbf7a5c83.webp"
"MediaSize" => 77794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-c3fd2addbe4123220449c60bbf7a5c83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29914609_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914609/d5b63a1ce53cb5dc0cdc9afa32327229.webp"
"MediaSize" => 80822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914609/thumbnail-d5b63a1ce53cb5dc0cdc9afa32327229.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840183"
"ResourceRecordKey" => "29914609"
"ModificationTimestamp" => "2026-06-17T13:10:48.92Z"
]
23 => array:13 [
"Order" => 24
…12
]
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('29914609')"
+"ID": "1539162"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905461')"
+"ID": "1532435"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905460')"
+"ID": "1532436"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25191
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905032')"
+"ID": "1530804"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1524745"
+post_author: 1
+"ListingKey": "29895690"
+"ListingId": "X13437284"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T16:40:11Z"
+"RFModificationTimestamp": "2026-06-12T19:36:35Z"
+"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:62783)"
+"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-12T16:31:49Z"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895690')"
+"ID": "1524745"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: "1524562"
+post_author: 1
+"ListingKey": "29896093"
+"ListingId": "X13437678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:30:20Z"
+"RFModificationTimestamp": "2026-06-12T19:26:10Z"
+"ListPrice": 769999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0K9"
+"UnparsedAddress": "23 - 35 MIDHURST HEIGHTS, Hamilton (Stoney Creek Mountain), Ontario L8J0K9"
+"Coordinates": array:2 [
0 => -79.766094
1 => 43.205614
]
+"Latitude": 43.205614
+"Longitude": -79.766094
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained end-unit 3+1 bedroom, 4 bathroom townhome with a private rooftop terrace in the highly desirable Stoney Creek Mountain community.The main floor offers a bright open-concept living and dining area filled with natural light, ideal for everyday living and entertaining.Upstairs features three generously sized bedrooms and a versatile loft space currently styled as a cozy library, easily adaptable as a home office or lounge area. The primary bedroom includes a custom closet installed in 2021 and direct walk-out access to a private patio that leads to the rooftop terrace above.The finished basement adds valuable living space with a fourth bedroom and full bathroom, currently set up as a home gym and easily adaptable as a guest suite, playroom, or media room.Enjoy the private rooftop terrace - a perfect space for relaxing or entertaining.Additional updates include custom window coverings, a privacy fence, and a remote garage opener installed in 2021. Parking for two vehicles with a private garage and driveway.Ideally located minutes from the new Confederation GO Station with quick access to the QEW, Red Hill Valley Parkway, and Lincoln Alexander Parkway.Move-in ready and offering exceptional value in today's market. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"AssociationFee": "434.11"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T19:26:02.230031+00:00"
+"Directions": "Cross Streets: Upper Centennial/Green Mountain. ** Directions: Upper Centennial Green Mountain."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1969961"
+"ListOfficeKey": "292212"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Carpet Free"
3 => "Guest Suite"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:01:37Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T17:01:37Z"
+"Stories": "2.0"
+"StreetName": "Midhurst"
+"StreetNumber": "35"
+"StreetSuffix": "Heights"
+"TaxAnnualAmount": "6103.23"
+"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"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896093/23-35-midhurst-heights-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "TAG Management"
+"GeocodeManualYN": false
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-12T17:01:37.3Z"
+"ListAgentNationalAssociationId": "1257383"
+"ListOfficeNationalAssociationId": "1409372"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896093')"
+"ID": "1524562"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896136')"
+"ID": "1524636"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25192
+post_id: "1526368"
+post_author: 1
+"ListingKey": "29895201"
+"ListingId": "40838563"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:50:05Z"
+"RFModificationTimestamp": "2026-06-17T18:52:37Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1064.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J3Z4"
+"UnparsedAddress": "39 PINEWOODS Drive Unit# 35, Stoney Creek, Ontario L8J3Z4"
+"Coordinates": array:2 [
0 => -79.7748029
1 => 43.1802664
]
+"Latitude": 43.1802664
+"Longitude": -79.7748029
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"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 open-concept living and dining spaces, while the upper level features three carpet-free bedrooms, including a large 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. 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"
]
+"AssociationFee": "195.92"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Insurance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T18:32:14.015373+00:00"
+"Directions": "HIGHBURY / HIGHLAND"
+"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": "2037792"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T18:11:54Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T18:40:39Z"
+"Stories": "2.0"
+"StreetName": "PINEWOODS"
+"StreetNumber": "39"
+"StreetSuffix": "Drive"
+"SubdivisionName": "504 - Leckie Park/Highland"
+"TaxAnnualAmount": "3092.74"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29895201/39-pinewoods-drive-unit-35-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 19.0
+"AboveGradeFinishedArea": 1064
+"OriginalEntryTimestamp": "2026-06-12T15:31:47.11Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1314146"
+"ListOfficeNationalAssociationId": "1330157"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29895201')"
+"ID": "1526368"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25193
+post_id: "1524025"
+post_author: 1
+"ListingKey": "29896576"
+"ListingId": "X13438258"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T18:05:18Z"
+"RFModificationTimestamp": "2026-06-12T18:21:16Z"
+"ListPrice": 630000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0M5"
+"UnparsedAddress": "36 - 185 BEDROCK DRIVE, Hamilton (Stoney Creek Mountain), Ontario L8J0M5"
+"Coordinates": array:2 [
0 => -79.777729
1 => 43.204392
]
+"Latitude": 43.204392
+"Longitude": -79.777729
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exceptional end-unit freehold townhouse in the highly sought-after Stoney Creek Mountain, just moments from Heritage Green. Boasting 1,739 sq ft of elegantly finished living space, this 3-bedroom, 3-bathroom residence offers the feel of a detached home with the ease of townhouse living. Meticulously upgraded and move-in ready, it features premium finishes throughout, including a brand-new walk-in shower and sleek, modern design elements.The end-unit positioning allows for extra privacy and abundant natural light, creating abright and inviting atmosphere. Situated in a newer, family-oriented community, this home is ideal for those seeking a true practical layout, and a neighbourhood built for lasting comfort. Conveniently located near parks, schools, shopping, and with quick highway access,it's perfect for families, professionals, or downsizers. A turnkey opportunity in a primeStoney Creek setting-this home truly has it all. NO POTL FEE FOR NEXT 2 YEARS !! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-06-12T18:21:05.354395+00:00"
+"Directions": "First Rd W/Bedrock Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2069742"
+"ListOfficeKey": "293109"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "20.5 x 75.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:56:39Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T17:56:39Z"
+"Stories": "3.0"
+"StreetName": "Bedrock"
+"StreetNumber": "185"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4836"
+"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": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29896576/36-185-bedrock-drive-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2203057"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "293109"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.6
+"OriginalEntryTimestamp": "2026-06-12T17:56:39.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1344911"
+"ListOfficeNationalAssociationId": "1422605"
+"CoListAgentNationalAssociationId": "1451643"
+"CoListOfficeNationalAssociationId": "1422605"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896576')"
+"ID": "1524025"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 102
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]