array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29687083 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23410
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23412
+post_id: "1376086"
+post_author: 1
+"ListingKey": "29687083"
+"ListingId": "X13070406"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-25T12:30:49Z"
+"RFModificationTimestamp": "2026-05-25T12:42:03Z"
+"ListPrice": 774900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0J6"
+"UnparsedAddress": "100 NARBONNE CRESCENT, Hamilton (Stoney Creek Mountain), Ontario L8J0J6"
+"Coordinates": array:2 [
0 => -79.7800997
1 => 43.1842172
]
+"Latitude": 43.1842172
+"Longitude": -79.7800997
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully upgraded semi-detached home, ideally situated on a premium rear lot in a highly desirable Stoney Creek community. Offering 1,410 sq ft of thoughtfully designed living space, this home features 9-foot ceilings, rich hardwood flooring, and elegant California shutters throughout. The main floor showcases a bright, open-concept layout highlighted by a stylish living area with a striking white stone feature wall and built-in fireplace, creating a warm and inviting space. The kitchen is both functional and modern, complete with a breakfast bar and spacious eat-in area, with sliding doors leading to a private backyard retreat featuring a large two-tier deck, gazebo, and gas BBQ hookup-perfect for hosting family and friends. Downstairs, the fully finished basement (2025) offers additional living space with a generous rec room, pot lights, laundry area, cold room, and ample storage. Located close to highways for easy commuting and within walking distance to schools, parks, trails, and everyday amenities. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-01T20:01:27.148326+00:00"
+"Directions": "Cross Streets: Highland Rd W. ** Directions: Upper Centennial Pkwy/Highland Rd/Chaumont Dr/Narbonne."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2144393"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.9 x 108.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-01T18:45:43Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-25T12:23:02Z"
+"Stories": "2.0"
+"StreetName": "Narbonne"
+"StreetNumber": "100"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4467.84"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/363306"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1643459353"
"RoomType" => "Kitchen"
"ListingId" => "X13070406"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29687083"
"RoomLength" => 5.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T12:23:02.95Z"
]
1 => array:11 [
"RoomKey" => "1643459354"
"RoomType" => "Great room"
"ListingId" => "X13070406"
"RoomLevel" => "Main level"
"RoomWidth" => 5.28
"ListingKey" => "29687083"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T12:23:02.95Z"
]
2 => array:11 [
"RoomKey" => "1643459355"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13070406"
"RoomLevel" => "Second level"
"RoomWidth" => 4.06
"ListingKey" => "29687083"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T12:23:02.95Z"
]
3 => array:11 [
"RoomKey" => "1643459356"
"RoomType" => "Bedroom"
"ListingId" => "X13070406"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29687083"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T12:23:02.95Z"
]
4 => array:11 [
"RoomKey" => "1643459357"
"RoomType" => "Bedroom"
"ListingId" => "X13070406"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29687083"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T12:23:02.96Z"
]
5 => array:11 [
"RoomKey" => "1643459358"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13070406"
"RoomLevel" => "Basement"
"RoomWidth" => 4.88
"ListingKey" => "29687083"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-05-25T12:23:02.96Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29687083/100-narbonne-crescent-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.1
+"OriginalEntryTimestamp": "2026-05-01T18:45:43.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1395812"
+"ListOfficeNationalAssociationId": "1344854"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6643905665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/09c90bec88a1ca9ab8d0379dcecf9e4c.webp"
"MediaSize" => 145381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-09c90bec88a1ca9ab8d0379dcecf9e4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6643905747"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/258e1d818017ccc521478baedcf1ac7f.webp"
"MediaSize" => 152612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-258e1d818017ccc521478baedcf1ac7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6643905879"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/fc5e0d053ff1c95e6c30148144f09d23.webp"
"MediaSize" => 159233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-fc5e0d053ff1c95e6c30148144f09d23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6643905993"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/552d6bab68edefecd4b3f01be8720be5.webp"
"MediaSize" => 162765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-552d6bab68edefecd4b3f01be8720be5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6643906053"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/607206a649dbd9bff2b788111c4d2df2.webp"
"MediaSize" => 91227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-607206a649dbd9bff2b788111c4d2df2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6643906156"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/e586f8f7cb3a52771a26ea0af0ae328e.webp"
"MediaSize" => 86208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-e586f8f7cb3a52771a26ea0af0ae328e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6643906237"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/5e637da716429ae9ae08a2539bac2e00.webp"
"MediaSize" => 109586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-5e637da716429ae9ae08a2539bac2e00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6643906352"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/98c757a6aa970ebfb7b3e86458e5715d.webp"
"MediaSize" => 103072
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-98c757a6aa970ebfb7b3e86458e5715d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6643906464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/53cd19bf7590f7f4e454f714a1463063.webp"
"MediaSize" => 120336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-53cd19bf7590f7f4e454f714a1463063.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6643906504"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/eb7cf8444201808a1506c32bc895f511.webp"
"MediaSize" => 98710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-eb7cf8444201808a1506c32bc895f511.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6643906600"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/b9e32b476706a2f663b16e367b272855.webp"
"MediaSize" => 119456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-b9e32b476706a2f663b16e367b272855.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6643906642"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/69a543fee8b203b4101931e38b1fe5c8.webp"
"MediaSize" => 95510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-69a543fee8b203b4101931e38b1fe5c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6643906743"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/acdf13cda546c758a739e59a2a8f3a7f.webp"
"MediaSize" => 124724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-acdf13cda546c758a739e59a2a8f3a7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6643906833"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/6611623952b806f0fe271935ee6f2fa0.webp"
"MediaSize" => 106265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-6611623952b806f0fe271935ee6f2fa0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6643906920"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/348efb6340e171a3cc3d5432ca500772.webp"
"MediaSize" => 105038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-348efb6340e171a3cc3d5432ca500772.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6643907036"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/0d1f03adfaa73eb6d79d616f05495209.webp"
"MediaSize" => 131311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-0d1f03adfaa73eb6d79d616f05495209.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6643907110"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/dc4557d7a5fc5746c22c2bb5a61a8d0b.webp"
"MediaSize" => 115709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-dc4557d7a5fc5746c22c2bb5a61a8d0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6643907133"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/9ece01e33d418097dcfd48d38d1a758b.webp"
"MediaSize" => 120594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-9ece01e33d418097dcfd48d38d1a758b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6643907236"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/d1c75d5a887e38a7bcdd4af99732672d.webp"
"MediaSize" => 95391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-d1c75d5a887e38a7bcdd4af99732672d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6643907332"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/3bb797a3b34bc0ae52010e1edac77486.webp"
"MediaSize" => 84116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-3bb797a3b34bc0ae52010e1edac77486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6643907384"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/9b3a31eef6dcab8125893f7b53d6c06d.webp"
"MediaSize" => 106336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-9b3a31eef6dcab8125893f7b53d6c06d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6643907471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/2e369fb0d426c5942c23aa9ecaca919d.webp"
"MediaSize" => 92232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-2e369fb0d426c5942c23aa9ecaca919d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6643907550"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/91ff9941a0a7e938a35ba2aa0887f2a2.webp"
"MediaSize" => 102586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-91ff9941a0a7e938a35ba2aa0887f2a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6643907633"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/b6be9d9c7abe8884e1a4bd4230630e27.webp"
"MediaSize" => 97537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-b6be9d9c7abe8884e1a4bd4230630e27.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6643907662"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/0fbf78e460b1cd0e85eafdc3d6a90739.webp"
"MediaSize" => 70564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-0fbf78e460b1cd0e85eafdc3d6a90739.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6643907671"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/50f766cebee5745c18ebf4e38d654929.webp"
"MediaSize" => 101402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-50f766cebee5745c18ebf4e38d654929.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6643907791"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/056bb05953fcc5b5c5a9151f42d9f006.webp"
"MediaSize" => 112042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-056bb05953fcc5b5c5a9151f42d9f006.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6643907826"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/bf0c5011d555fc9b1a9616fbe26aa5fe.webp"
"MediaSize" => 107897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-bf0c5011d555fc9b1a9616fbe26aa5fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6643907900"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/c0578cb81e01326e58c339704677c60f.webp"
"MediaSize" => 112563
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-c0578cb81e01326e58c339704677c60f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6643907954"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/41750423f0bec35bde93384b20f8960b.webp"
"MediaSize" => 63652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-41750423f0bec35bde93384b20f8960b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6643907989"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/a1d4b336b6725ecf9ad4a599a5d8f33d.webp"
"MediaSize" => 73761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-a1d4b336b6725ecf9ad4a599a5d8f33d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6643908008"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/71e0ff82fd2dcbcb82b0c8fe70bef8e1.webp"
"MediaSize" => 70947
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-71e0ff82fd2dcbcb82b0c8fe70bef8e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6643908082"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/f621344a7997d1c2c6d737b72c18333c.webp"
"MediaSize" => 70488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-f621344a7997d1c2c6d737b72c18333c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6643908133"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/7d493d24a53c1adeefe5be045d6452ba.webp"
"MediaSize" => 82122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-7d493d24a53c1adeefe5be045d6452ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6643908182"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/7202a556df6a512bb593d5846e9fb39e.webp"
"MediaSize" => 102593
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-7202a556df6a512bb593d5846e9fb39e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6643908226"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/18985b0e7ea4dcbe9c4940a98386c87f.webp"
"MediaSize" => 90599
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-18985b0e7ea4dcbe9c4940a98386c87f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "6643908265"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/e0328cf1dcd34b483bead6426422b742.webp"
"MediaSize" => 83049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-e0328cf1dcd34b483bead6426422b742.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "6643908314"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/61514fc40299b34e31c85e0ea1cabb8a.webp"
"MediaSize" => 73512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-61514fc40299b34e31c85e0ea1cabb8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "6643908350"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/91fab84c9cbe3c3783f433d45ddec158.webp"
"MediaSize" => 92426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-91fab84c9cbe3c3783f433d45ddec158.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "6643908376"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/c8220e0368ef0bf549c22aef3efaed0e.webp"
"MediaSize" => 84866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-c8220e0368ef0bf549c22aef3efaed0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "6643908395"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/d8c8000d48843bf37c9b12441b098a98.webp"
"MediaSize" => 63501
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-d8c8000d48843bf37c9b12441b098a98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "6643908434"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/501cb279ea69fecd6c96f0b1978e7aca.webp"
"MediaSize" => 87740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-501cb279ea69fecd6c96f0b1978e7aca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "6643908456"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/621bf8a01d3e6209924302f0d7d533f0.webp"
"MediaSize" => 94932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-621bf8a01d3e6209924302f0d7d533f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "6643908471"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/c692842eca78c0b7d7b303a4d847cf23.webp"
"MediaSize" => 77686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-c692842eca78c0b7d7b303a4d847cf23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "6643908513"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/7105de123efb981c2bf4b5b131c50a30.webp"
"MediaSize" => 122067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-7105de123efb981c2bf4b5b131c50a30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "6643908554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/d21ca2329ec2c3e6c3ec18e362515ad0.webp"
"MediaSize" => 136802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-d21ca2329ec2c3e6c3ec18e362515ad0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "6643908583"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/11e1326b258cce2c05566e94a356227c.webp"
"MediaSize" => 166002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-11e1326b258cce2c05566e94a356227c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "6643908606"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/5e5938b3117ffaa9947df73cd4e2fda3.webp"
"MediaSize" => 161244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-5e5938b3117ffaa9947df73cd4e2fda3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
48 => array:13 [
"Order" => 49
"MediaKey" => "6643908631"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/e851d57bee683aba8f3ea028c526aaf8.webp"
"MediaSize" => 151471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-e851d57bee683aba8f3ea028c526aaf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
49 => array:13 [
"Order" => 50
"MediaKey" => "6643908675"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29687083/174ccd082f85874e56add117115b4fcb.webp"
"MediaSize" => 160190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29687083/thumbnail-174ccd082f85874e56add117115b4fcb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13070406"
"ResourceRecordKey" => "29687083"
"ModificationTimestamp" => "2026-05-01T18:45:43.72Z"
]
]
+"DaysOnMarket": 51
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29687083')"
+"ID": "1376086"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284787" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24857
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2144393" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24851
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29687083'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25271
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29687083'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25287
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29687083' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7800997 43.1842172)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25365
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "1551656"
+post_author: 1
+"ListingKey": "29932952"
+"ListingId": "X13470786"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T14:55:01Z"
+"RFModificationTimestamp": "2026-06-20T16:46:56Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J1A3"
+"UnparsedAddress": "47 ODESSA STREET, Hamilton (Stoney Creek Mountain), Ontario L8J1A3"
+"Coordinates": array:2 [
0 => -79.788494
1 => 43.19117
]
+"Latitude": 43.19117
+"Longitude": -79.788494
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "RENOVATED. MOVE-IN READY. LARGE YARD. GREAT LOCATION. This updated 3+1 bedroom, 1.5-bath backsplit offers the space, updates, and value today's buyers are looking for. Major improvements include the roof, windows, furnace, kitchen, bathrooms, backyard fencing, and virtually every surface throughout the home. Bright, modern living spaces flow throughout, while the finished basement adds valuable living space for a family room, home office, gym, play area, or private retreat for a teenager, extended family member, or multi-generational living. Step outside to an oversized fully fenced backyard with plenty of room for a future pool, deck, entertaining space, or room for kids and pets to play. Located in a desirable Stoney Creek neighbourhood close to schools, parks, shopping, dining, and commuter routes. Why buy a project when the work is already done? Move in before school starts and spend your time making memories, not tackling renovations. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T16:46:46.001268+00:00"
+"Directions": "Cross Streets: Issaac Brock. ** Directions: MUD ST. WEST/ISAAC BROCK DRIVE TO ODESSA STREET."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2089853"
+"ListOfficeKey": "289645"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "48.2 x 120 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T14:48:06Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T14:48:06Z"
+"StreetName": "Odessa"
+"StreetNumber": "47"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4038.23"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1663868620"
"RoomType" => "Kitchen"
"ListingId" => "X13470786"
"RoomLevel" => "Main level"
"RoomWidth" => 3.4
"ListingKey" => "29932952"
"RoomLength" => 4.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:48:06.01Z"
]
1 => array:11 [
"RoomKey" => "1663868621"
"RoomType" => "Living room"
"ListingId" => "X13470786"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "29932952"
"RoomLength" => 5.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:48:06.01Z"
]
2 => array:11 [
"RoomKey" => "1663868622"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13470786"
"RoomLevel" => "Second level"
"RoomWidth" => 3.51
"ListingKey" => "29932952"
"RoomLength" => 4.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:48:06.01Z"
]
3 => array:11 [
"RoomKey" => "1663868623"
"RoomType" => "Bedroom 2"
"ListingId" => "X13470786"
"RoomLevel" => "Second level"
"RoomWidth" => 3.48
"ListingKey" => "29932952"
"RoomLength" => 3.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:48:06.01Z"
]
4 => array:11 [
"RoomKey" => "1663868624"
"RoomType" => "Bedroom 3"
"ListingId" => "X13470786"
"RoomLevel" => "Second level"
"RoomWidth" => 2.36
"ListingKey" => "29932952"
"RoomLength" => 2.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:48:06.01Z"
]
5 => array:11 [
"RoomKey" => "1663868625"
"RoomType" => "Bathroom"
"ListingId" => "X13470786"
"RoomLevel" => "Second level"
"RoomWidth" => 0.0
"ListingKey" => "29932952"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:48:06.01Z"
]
6 => array:11 [
"RoomKey" => "1663868626"
"RoomType" => "Family room"
"ListingId" => "X13470786"
"RoomLevel" => "Basement"
"RoomWidth" => 3.15
"ListingKey" => "29932952"
"RoomLength" => 7.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:48:06.01Z"
]
7 => array:11 [
"RoomKey" => "1663868627"
"RoomType" => "Laundry room"
"ListingId" => "X13470786"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29932952"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-20T14:48:06.01Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932952/47-odessa-street-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 48.2
+"OriginalEntryTimestamp": "2026-06-20T14:48:05.98Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1363135"
+"ListOfficeNationalAssociationId": "1379865"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29932952_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932952/190b6b6212ffe12ff38b624cb496df81.webp"
"MediaSize" => 317978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932952/thumbnail-190b6b6212ffe12ff38b624cb496df81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13470786"
"ResourceRecordKey" => "29932952"
"ModificationTimestamp" => "2026-06-20T14:48:05.99Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29932952_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932952/be1e30842edbebc508931b85a5efa73b.webp"
"MediaSize" => 271468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932952/thumbnail-be1e30842edbebc508931b85a5efa73b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470786"
"ResourceRecordKey" => "29932952"
"ModificationTimestamp" => "2026-06-20T14:48:05.99Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29932952_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932952/50a47ccdf48c37fe65f8f53c1e89f365.webp"
"MediaSize" => 376347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932952/thumbnail-50a47ccdf48c37fe65f8f53c1e89f365.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470786"
"ResourceRecordKey" => "29932952"
"ModificationTimestamp" => "2026-06-20T14:48:05.99Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29932952_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932952/c02e1553dfc3928e5f5d41f80952bc69.webp"
"MediaSize" => 340299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932952/thumbnail-c02e1553dfc3928e5f5d41f80952bc69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470786"
"ResourceRecordKey" => "29932952"
"ModificationTimestamp" => "2026-06-20T14:48:05.99Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29932952_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932952/2d07756e71514564f1c6c4f2e38b4327.webp"
"MediaSize" => 370335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932952/thumbnail-2d07756e71514564f1c6c4f2e38b4327.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470786"
"ResourceRecordKey" => "29932952"
"ModificationTimestamp" => "2026-06-20T14:48:05.99Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29932952_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932952/dc9bfd131df3fcf77dd3329b8145df09.webp"
"MediaSize" => 143752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932952/thumbnail-dc9bfd131df3fcf77dd3329b8145df09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13470786"
"ResourceRecordKey" => "29932952"
"ModificationTimestamp" => "2026-06-20T14:48:05.99Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29932952_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29932952/531eb4cb55f95e9170e1a289591632d4.webp"
"MediaSize" => 205027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29932952/thumbnail-531eb4cb55f95e9170e1a289591632d4.webp"
"ResourceName" => "Property"
…6
]
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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932952')"
+"ID": "1551656"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+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 [ …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/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 [ …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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931294')"
+"ID": "1549746"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25358
+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 [ …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/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 [ …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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930701')"
+"ID": "1549448"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929497')"
+"ID": "1548755"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905671')"
+"ID": "1532434"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25355
+post_id: "1532435"
+post_author: 1
+"ListingKey": "29905461"
+"ListingId": "X13446472"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T12:30:24Z"
+"RFModificationTimestamp": "2026-06-21T12:33:39Z"
+"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:62783)"
+"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-21T12:23:14Z"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905461')"
+"ID": "1532435"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23424
+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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905460')"
+"ID": "1532436"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905376')"
+"ID": "1530992"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
+post_id: "1530804"
+post_author: 1
+"ListingKey": "29905032"
+"ListingId": "40839409"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:15Z"
+"RFModificationTimestamp": "2026-06-20T20:44:16Z"
+"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-20T20:32:20Z"
+"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": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905032')"
+"ID": "1530804"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 113
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]