array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29836452 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1481672"
+post_author: 1
+"ListingKey": "29836452"
+"ListingId": "X13225046"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T12:00:41Z"
+"RFModificationTimestamp": "2026-06-08T12:01:49Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Riverdale)"
+"PostalCode": "L8E1M9"
+"UnparsedAddress": "38 RIVERCREST ROAD, Hamilton (Riverdale), Ontario L8E1M9"
+"Coordinates": array:2 [
0 => -79.748604
1 => 43.231481
]
+"Latitude": 43.231481
+"Longitude": -79.748604
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to 38 Rivercrest Rd, a well-maintained bungalow offering over 2,300 sq ft of finished living space in a sought after Stoney Creek neighbourhood. Lovingly cared for by its original owner, this home has been kept in excellent condition and is ready for its next chapter. The main level features a bright, functional layout with a spacious living area, ideal for both everyday living and entertaining. Generous room sizes and a practical flow make this home a great fit for families, downsizers who still want space, or anyone looking for flexibility. A standout feature is the separate entrance to the basement, offering excellent in-law suite potential or the opportunity for multi-generational living. The lower level provides additional finished space that can easily be customized to suit your needs. Situated in a convenient location, you're just minutes from parks, schools, and everyday amenities. Enjoy quick access to the Red Hill Valley Parkway and Queen Elizabeth Way for an easy commute, while nearby shopping at Eastgate Square and access to the scenic Niagara Escarpment offer the perfect balance of convenience and outdoor lifestyle. A solid, well-loved home with space, potential, and a location that checks all the boxes! (id:62783)"
+"Appliances": array:2 [
0 => "Window Coverings"
1 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T22:52:15.194389+00:00"
+"Directions": "Cross Streets: Barton and Grays. ** Directions: Barton to Varga right on Berkindale left on Rivercrest."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:1 [
0 => "Roughed in"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2204485"
+"ListOfficeKey": "75381"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 100.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T21:58:14Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T11:58:35Z"
+"Stories": "1.0"
+"StreetName": "Rivercrest"
+"StreetNumber": "38"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5165.12"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1654871954"
"RoomType" => "Kitchen"
"ListingId" => "X13225046"
"RoomLevel" => "Main level"
"RoomWidth" => 2.907
"ListingKey" => "29836452"
"RoomLength" => 3.969
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
1 => array:11 [
"RoomKey" => "1654871955"
"RoomType" => "Den"
"ListingId" => "X13225046"
"RoomLevel" => "Basement"
"RoomWidth" => 4.487
"ListingKey" => "29836452"
"RoomLength" => 4.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
2 => array:11 [
"RoomKey" => "1654871956"
"RoomType" => "Other"
"ListingId" => "X13225046"
"RoomLevel" => "Basement"
"RoomWidth" => 3.408
"ListingKey" => "29836452"
"RoomLength" => 8.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
3 => array:11 [
"RoomKey" => "1654871957"
"RoomType" => "Cold room"
"ListingId" => "X13225046"
"RoomLevel" => "Basement"
"RoomWidth" => 1.268
"ListingKey" => "29836452"
"RoomLength" => 7.76
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
4 => array:11 [
"RoomKey" => "1654871958"
"RoomType" => "Dining room"
"ListingId" => "X13225046"
"RoomLevel" => "Main level"
"RoomWidth" => 3.129
"ListingKey" => "29836452"
"RoomLength" => 3.698
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
5 => array:11 [
"RoomKey" => "1654871959"
"RoomType" => "Living room"
"ListingId" => "X13225046"
"RoomLevel" => "Main level"
"RoomWidth" => 3.625
"ListingKey" => "29836452"
"RoomLength" => 5.463
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
6 => array:11 [
"RoomKey" => "1654871960"
"RoomType" => "Bedroom"
"ListingId" => "X13225046"
"RoomLevel" => "Main level"
"RoomWidth" => 3.318
"ListingKey" => "29836452"
"RoomLength" => 3.626
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
7 => array:11 [
"RoomKey" => "1654871961"
"RoomType" => "Bedroom"
"ListingId" => "X13225046"
"RoomLevel" => "Main level"
"RoomWidth" => 3.616
"ListingKey" => "29836452"
"RoomLength" => 3.852
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
8 => array:11 [
"RoomKey" => "1654871962"
"RoomType" => "Bedroom"
"ListingId" => "X13225046"
"RoomLevel" => "Main level"
"RoomWidth" => 3.14
"ListingKey" => "29836452"
"RoomLength" => 3.969
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
9 => array:11 [
"RoomKey" => "1654871963"
"RoomType" => "Bathroom"
"ListingId" => "X13225046"
"RoomLevel" => "Main level"
"RoomWidth" => 1.402
"ListingKey" => "29836452"
"RoomLength" => 2.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.92Z"
]
10 => array:11 [
"RoomKey" => "1654871964"
"RoomType" => "Family room"
"ListingId" => "X13225046"
"RoomLevel" => "Basement"
"RoomWidth" => 4.127
"ListingKey" => "29836452"
"RoomLength" => 7.481
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.93Z"
]
11 => array:11 [
"RoomKey" => "1654871965"
"RoomType" => "Utility room"
"ListingId" => "X13225046"
"RoomLevel" => "Basement"
"RoomWidth" => 2.966
"ListingKey" => "29836452"
"RoomLength" => 3.494
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.93Z"
]
12 => array:11 [
"RoomKey" => "1654871966"
"RoomType" => "Bathroom"
"ListingId" => "X13225046"
"RoomLevel" => "Basement"
"RoomWidth" => 2.383
"ListingKey" => "29836452"
"RoomLength" => 3.286
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-08T11:58:35.93Z"
]
]
+"ListAOR": "Niagara"
+"CityRegion": "Riverdale"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29836452/38-rivercrest-road-hamilton-riverdale-riverdale"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-01T21:58:14.55Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1453088"
+"ListOfficeNationalAssociationId": "1004013"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29836452_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/16ddc95305395c1efd659270dbd7106e.webp"
"MediaSize" => 356555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-16ddc95305395c1efd659270dbd7106e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29836452_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/9eeddf4b9476cf8321c1478910d681b2.webp"
"MediaSize" => 336964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-9eeddf4b9476cf8321c1478910d681b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29836452_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/c7298886ac818d999046f99b2ba2e881.webp"
"MediaSize" => 165011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-c7298886ac818d999046f99b2ba2e881.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29836452_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/820658448d2ad0405376e3a32dfadba2.webp"
"MediaSize" => 177974
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-820658448d2ad0405376e3a32dfadba2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29836452_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/c17aca5139359c90f357e9dfcee34c1c.webp"
"MediaSize" => 187303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-c17aca5139359c90f357e9dfcee34c1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29836452_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/9483b91947d9a4948f219d876f7d0ecc.webp"
"MediaSize" => 182586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-9483b91947d9a4948f219d876f7d0ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29836452_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/f5e4b04cbd2b4c119aa4eb8761331049.webp"
"MediaSize" => 169578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-f5e4b04cbd2b4c119aa4eb8761331049.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29836452_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/a60c977edd56077667c4c125ab43fc01.webp"
"MediaSize" => 185412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-a60c977edd56077667c4c125ab43fc01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29836452_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/b86f86ea008a7b79e4eb533ece5257b2.webp"
"MediaSize" => 174565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-b86f86ea008a7b79e4eb533ece5257b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29836452_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/afe00ba737c8d401cc685cd11be8deb8.webp"
"MediaSize" => 190273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-afe00ba737c8d401cc685cd11be8deb8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29836452_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/68b337f0495c71007152723b2da1fdb4.webp"
"MediaSize" => 178094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-68b337f0495c71007152723b2da1fdb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29836452_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/17ddd647192d5183900e70cd738710ca.webp"
"MediaSize" => 146102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-17ddd647192d5183900e70cd738710ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29836452_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/64d314b11a999f065ea44d567820481b.webp"
"MediaSize" => 142887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-64d314b11a999f065ea44d567820481b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29836452_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/6671825952e050a05a925b7cb425dae7.webp"
"MediaSize" => 153614
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-6671825952e050a05a925b7cb425dae7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29836452_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/6f3a8dbea2534f5ec7e5bad50d725cc0.webp"
"MediaSize" => 161437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-6f3a8dbea2534f5ec7e5bad50d725cc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29836452_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/323d698658944c2297bc590ef6107c9a.webp"
"MediaSize" => 171296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-323d698658944c2297bc590ef6107c9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29836452_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/33e70cfe60b045d2c64b3fc5bfc2d909.webp"
"MediaSize" => 156355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-33e70cfe60b045d2c64b3fc5bfc2d909.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29836452_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/80edccbe8a03c93aa0f9c7e1069c293d.webp"
"MediaSize" => 142260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-80edccbe8a03c93aa0f9c7e1069c293d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29836452_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/749e9eb9a7c37bdc403346c01eae88f5.webp"
"MediaSize" => 154112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-749e9eb9a7c37bdc403346c01eae88f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29836452_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/5ebc9914137e17826a2b4684f96a5633.webp"
"MediaSize" => 78930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-5ebc9914137e17826a2b4684f96a5633.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29836452_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/86ac636968b865084d45dcb6d2f7ee89.webp"
"MediaSize" => 210181
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-86ac636968b865084d45dcb6d2f7ee89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29836452_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/4e800cc068decebbc37096a365fa0900.webp"
"MediaSize" => 184299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-4e800cc068decebbc37096a365fa0900.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29836452_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/06ba4e56b8433e41a998a54d044d3b77.webp"
"MediaSize" => 233828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-06ba4e56b8433e41a998a54d044d3b77.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29836452_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/a3d9d20856e1cce132844668dfb52f20.webp"
"MediaSize" => 243488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-a3d9d20856e1cce132844668dfb52f20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29836452_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/e4e0b3c1319e48689589a82a0238806c.webp"
"MediaSize" => 188335
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-e4e0b3c1319e48689589a82a0238806c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29836452_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/dccd1655aad2180fac0b83781ae4b887.webp"
"MediaSize" => 187574
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-dccd1655aad2180fac0b83781ae4b887.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29836452_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/313f15c6676ccbf41317c881c3ad91e2.webp"
"MediaSize" => 291269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-313f15c6676ccbf41317c881c3ad91e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29836452_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/a162b1ec30a4480f152681fcd237b4eb.webp"
"MediaSize" => 282120
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-a162b1ec30a4480f152681fcd237b4eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29836452_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/37216393e2b986b920d3d4cde69e7eb6.webp"
"MediaSize" => 244405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-37216393e2b986b920d3d4cde69e7eb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29836452_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/22a828f897ab41558d100ca6d3c73d86.webp"
"MediaSize" => 218496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-22a828f897ab41558d100ca6d3c73d86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29836452_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/b914c46ca3a70ec4d6c0e2ca53db1910.webp"
"MediaSize" => 217049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-b914c46ca3a70ec4d6c0e2ca53db1910.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29836452_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/f89b7e77d72e2738831ad457caf3dc74.webp"
"MediaSize" => 280676
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-f89b7e77d72e2738831ad457caf3dc74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29836452_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/a7011b0bed849259d8fbd5b794916308.webp"
"MediaSize" => 311999
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-a7011b0bed849259d8fbd5b794916308.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29836452_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/db1a9b51e44b7877967a6194236000b8.webp"
"MediaSize" => 329046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-db1a9b51e44b7877967a6194236000b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29836452_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/2a769cee5c0602c06190c7361c2d12f4.webp"
"MediaSize" => 319620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-2a769cee5c0602c06190c7361c2d12f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29836452_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/b9ce771854673ef447afc89ddefa9d1d.webp"
"MediaSize" => 286754
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-b9ce771854673ef447afc89ddefa9d1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29836452_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/9252cf327ab3053ef4b96dd8c2b76a9c.webp"
"MediaSize" => 304653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-9252cf327ab3053ef4b96dd8c2b76a9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29836452_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29836452/2014d9fa42c58f28d43d82c7e43483db.webp"
"MediaSize" => 333151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29836452/thumbnail-2014d9fa42c58f28d43d82c7e43483db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13225046"
"ResourceRecordKey" => "29836452"
"ModificationTimestamp" => "2026-06-01T21:58:14.55Z"
]
]
+"DaysOnMarket": 31
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29836452')"
+"ID": "1481672"
}
]
+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 75381" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24900
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2204485" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24858
+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 '29836452'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25253
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29836452'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25271
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25269
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31287824"
+"ListingKey": "29836452"
+"ListingId": "X13225046"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-07"
+"OpenHouseStartTime": "2026-06-07T14:00:00Z"
+"OpenHouseEndTime": "2026-06-07T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-08T03:59:50Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31287824')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29836452' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.748604 43.231481)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25344
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
+post_id: "1590213"
+post_author: 1
+"ListingKey": "29985571"
+"ListingId": "40845048"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:10:10Z"
+"RFModificationTimestamp": "2026-07-03T18:59:55Z"
+"ListPrice": 855000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.21
+"LivingArea": 1964.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G3W4"
+"UnparsedAddress": "124 CORMAN Avenue, Stoney Creek, Ontario L8G3W4"
+"Coordinates": array:2 [
0 => -79.7398287
1 => 43.2192534
]
+"Latitude": 43.2192534
+"Longitude": -79.7398287
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fully renovated with all Building permits and ESA certificate. NEW double wide asphalt driveway. NEW 6x6 post fencing. NEW concrete wrap-around. Surrounded by custom million dollar homes! Almost 2,000 square feet of living space. Spacious 3+2 bedrooms and 2 full bathrooms. Everything new within last few months. 1 inch city water line. New electrical, plumbing, custom kitchen with quartz counter tops and backsplash, led pot lights, 2 full bathrooms, all windows and doors, custom trim work, all baseboards and casing, New S.S appliance package included (Gas stove hook up), high efficiency Gas furnace, AC unit, Water heater (all owned with warranty), list goes on! Updated sump pump for piece of mind, fully fenced, 141.50 feet deep corner lot. Enjoy the wood burning fireplace (chimney swept/cleaned), nothing else to do but to enjoy the bright and warm home! Enjoy trails, parks, and schools just steps away, with public transit and everyday essentials within walking distance. Minutes to QEW, Red Hill, and Costco, this location offers the perfect blend of lifestyle, convenience, and opportunity! OPEN HOUSE SUNDAY 2-4 PM! (id:62650)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T18:58:58.797263+00:00"
+"Directions": "KING STREET EAST TO CORMAN AVE., AT THE CORNER OF CORMAN AND CARLA AVE."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2020660"
+"ListOfficeKey": "289605"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "0.21"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T17:18:49Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:00:01Z"
+"Stories": "1.0"
+"StreetName": "CORMAN"
+"StreetNumber": "124"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "516 - Cherry Heights"
+"TaxAnnualAmount": "4600"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/364689"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1674286172"
"RoomType" => "Bedroom"
"ListingId" => "40845048"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.44Z"
]
1 => array:11 [
"RoomKey" => "1674286173"
"RoomType" => "3pc Bathroom"
"ListingId" => "40845048"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.44Z"
]
2 => array:11 [
"RoomKey" => "1674286174"
"RoomType" => "Eat in kitchen"
"ListingId" => "40845048"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.44Z"
]
3 => array:11 [
"RoomKey" => "1674286175"
"RoomType" => "Bedroom"
"ListingId" => "40845048"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.45Z"
]
4 => array:11 [
"RoomKey" => "1674286176"
"RoomType" => "Recreation room"
"ListingId" => "40845048"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.45Z"
]
5 => array:11 [
"RoomKey" => "1674286177"
"RoomType" => "Bedroom"
"ListingId" => "40845048"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.45Z"
]
6 => array:11 [
"RoomKey" => "1674286178"
"RoomType" => "Bedroom"
"ListingId" => "40845048"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.45Z"
]
7 => array:11 [
"RoomKey" => "1674286179"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845048"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.45Z"
]
8 => array:11 [
"RoomKey" => "1674286180"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845048"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.45Z"
]
9 => array:11 [
"RoomKey" => "1674286181"
"RoomType" => "Kitchen"
"ListingId" => "40845048"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.45Z"
]
10 => array:11 [
"RoomKey" => "1674286182"
"RoomType" => "Dining room"
"ListingId" => "40845048"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.45Z"
]
11 => array:11 [
"RoomKey" => "1674286183"
"RoomType" => "Living room"
"ListingId" => "40845048"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29985571"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:00:01.45Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29985571/124-corman-avenue-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1921958"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54876"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.0
+"AboveGradeFinishedArea": 1044
+"BelowGradeFinishedArea": 920
+"OriginalEntryTimestamp": "2026-07-03T17:18:49.05Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1300535"
+"ListOfficeNationalAssociationId": "1379433"
+"CoListAgentNationalAssociationId": "1227299"
+"CoListOfficeNationalAssociationId": "1003493"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29985571_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985571/af2d4c3261b7bb723d1ac25a92714547.webp"
"MediaSize" => 124844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985571/thumbnail-af2d4c3261b7bb723d1ac25a92714547.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ranch-style exterior featuring white-painted brick, a dark asphalt shingle roof, and a modern dark gray garage door with horizontal windows"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845048"
"ResourceRecordKey" => "29985571"
"ModificationTimestamp" => "2026-07-03T17:18:49.06Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29985571_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985571/a21cd19d9e7acfc2422643186951ce6a.webp"
"MediaSize" => 174480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985571/thumbnail-a21cd19d9e7acfc2422643186951ce6a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Single-story residence featuring a brown shingle roof and white brick exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845048"
"ResourceRecordKey" => "29985571"
"ModificationTimestamp" => "2026-07-03T17:18:49.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29985571_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985571/7e27134652235f04c0254104d1c8adcc.webp"
"MediaSize" => 174008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985571/thumbnail-7e27134652235f04c0254104d1c8adcc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary single-story residence featuring a brown shingle roof and white brick exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845048"
"ResourceRecordKey" => "29985571"
"ModificationTimestamp" => "2026-07-03T17:18:49.06Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29985571_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29985571/81d3f18dff0a9ea798c7569be6720be5.webp"
"MediaSize" => 127993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29985571/thumbnail-81d3f18dff0a9ea798c7569be6720be5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Single-story residence featuring a dark asphalt driveway and a black garage door"
"PreferredPhotoYN" => false
…3
]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985571')"
+"ID": "1590213"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25320
+post_id: "1586470"
+post_author: 1
+"ListingKey": "29981973"
+"ListingId": "X13515750"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T17:45:39Z"
+"RFModificationTimestamp": "2026-07-03T17:52:31Z"
+"ListPrice": 1099900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Riverdale)"
+"PostalCode": "L8E0H3"
+"UnparsedAddress": "147 FEDERAL STREET, Hamilton (Riverdale), Ontario L8E0H3"
+"Coordinates": array:2 [
0 => -79.743894
1 => 43.225318
]
+"Latitude": 43.225318
+"Longitude": -79.743894
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "LOCATION, LOCATION, LOCATION!! This almost 4500 Sq Ft home offers plenty of space for the growing family in a 10+ family friendly neighbourhood close to ALL conveniences. Prepare to be wowed by the spacious floor plan this home offers. The Living room with plenty of natural light is a great place to sit an unwind with family. The Eat-In Kitchen is sure to impress with stone counters, stainless appliances, large island with extra seating, modern backsplash and plenty of counter prep space and storage. The formal dining room offers more space for larger family meals. There is a bonus Family Room perfect for family games and move nights and an office space tucked away for a perfect place to be available but away from the hustle. This floor is complete with the convenience of a 3 pce bath. Upstairs is a dream layout with 4 spacious bedrooms all with ensuite or ensuite privilege. The master retreat offers plenty of space to relax and offers a 5 pce ensuite. There are also 2 others 4 pce baths to complete this level. The basement offers even more space for older children still at home or the in-laws with large living room area, modern Eat-in Kitchen with plenty of space, additional bedroom and a 3 pce bath. There is also plenty of storage and a cold room. The backyard with large concrete patio and fully fenced yard awaits your oasis dreams. This is the home you have been looking for and it is even minutes to the BEACH!!! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T22:32:04.649708+00:00"
+"Directions": "Cross Streets: GRAY RD. ** Directions: HWY 8 TO GRAY TO FEDERAL."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1937514"
+"ListOfficeKey": "284773"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 102.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T21:54:40Z"
+"PhotosCount": 25
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T17:06:16Z"
+"Stories": "2.0"
+"StreetName": "Federal"
+"StreetNumber": "147"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7891.92"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Riverdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29981973/147-federal-street-hamilton-riverdale-riverdale"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-02T21:54:40.82Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1294063"
+"ListOfficeNationalAssociationId": "1344627"
+"Media": array:25 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981973')"
+"ID": "1586470"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25317
+post_id: "1586166"
+post_author: 1
+"ListingKey": "29981386"
+"ListingId": "40844603"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T21:20:23Z"
+"RFModificationTimestamp": "2026-07-02T21:25:07Z"
+"ListPrice": 1099900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4526.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0H3"
+"UnparsedAddress": "147 FEDERAL Street, Stoney Creek, Ontario L8E0H3"
+"Coordinates": array:2 [
0 => -79.742254
1 => 43.2244682
]
+"Latitude": 43.2244682
+"Longitude": -79.742254
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "LOCATION, LOCATION, LOCATION!! This almost 4500 Sq Ft home offers plenty of space for the growing family in a 10+ family friendly neighbourhood close to ALL conveniences. Prepare to be wowed by the spacious floor plan this home offers. The Living room with plenty of natural light is a great place to sit an unwind with family. The Eat-In Kitchen is sure to impress with stone counters, stainless appliances, large island with extra seating, modern backsplash and plenty of counter prep space and storage. The formal dining room offers more space for larger family meals. There is a bonus Family Room perfect for family games and move nights and an office space tucked away for a perfect place to be available but away from the hustle. This floor is complete with the convenience of a 3 pce bath. Upstairs is a dream layout with 4 spacious bedrooms all with ensuite or ensuite privilege. The master retreat offers plenty of space to relax and offers a 5 pce ensuite. There are also 2 others 4 pce baths to complete this level. The basement offers even more space for older children still at home or the in-laws with large living room area, modern Eat-in Kitchen with plenty of space, additional bedroom and a 3 pce bath. There is also plenty of storage and a cold room. The backyard with large concrete patio and fully fenced yard awaits your oasis dreams. This is the home you have been looking for and it is even minutes to the BEACH!!! (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T21:25:03.986085+00:00"
+"Directions": "GRAY / HWY 8"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"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": "1902828"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T20:51:39Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:11:58Z"
+"Stories": "2.0"
+"StreetName": "FEDERAL"
+"StreetNumber": "147"
+"StreetSuffix": "Street"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "7892"
+"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/29981386/147-federal-street-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 3400
+"BelowGradeFinishedArea": 1126
+"OriginalEntryTimestamp": "2026-07-02T20:51:39.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1218389"
+"ListOfficeNationalAssociationId": "1344654"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981386')"
+"ID": "1586166"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
+post_id: "1581957"
+post_author: 1
+"ListingKey": "29974470"
+"ListingId": "X13507970"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T04:50:23Z"
+"RFModificationTimestamp": "2026-07-01T04:55:23Z"
+"ListPrice": 824900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J3H4"
+"UnparsedAddress": "293 #20 REGIONAL ROAD, Hamilton, Ontario L8J3H4"
+"Coordinates": array:2 [
0 => -79.760102
1 => 43.23771
]
+"Latitude": 43.23771
+"Longitude": -79.760102
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome home! Set on a picturesque, tree-lined lot just shy of half an acre, this beautifully updated turnkey home offers over $200,000 in upgrades and truly nothing left to do but move in. With a separate entrance to the basement, a roughed-in kitchen, oversized bedroom, and full bathroom, this property is an ideal option for multi-generational living, a nanny suite, or a private teen retreat. The bright, open-concept main floor features seamless luxury vinyl plank flooring throughout, a spacious living room filled with natural light, and an inviting eat-in kitchen designed for both everyday living and entertaining. The chef-inspired kitchen boasts upgraded cabinetry with abundant storage, stunning stone countertops, a large pantry, and plenty of room for a full-sized dining table. Three generously sized bedrooms and a beautifully updated 4-piece bathroom complete the main level. The lower level offers exceptional flexibility with direct access to the backyard. Above-grade windows provide plenty of natural light throughout the spacious rec room, massive bedroom, 3-piece bathroom, utility room, laundry room, and future kitchen area already roughed in and ready for your vision. Major updates include furnace, well pump, and plumbing (2020), windows (2020 and newer), kitchen, flooring, and appliances (2020/21), roof (2024), complete septic system and ejector pump (2025), and a 100-amp electrical panel (2025). Enjoy the peace and privacy of country-style living while remaining just minutes from restaurants, grocery stores, schools, shopping, Costco, Lime Ridge Mall, and major commuter routes including the Red Hill Valley Parkway, Lincoln Alexander Parkway, and QEW. Offering the perfect blend of space, flexibility, convenience, and peace of mind, this exceptional property is one you won't want to miss. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Water Treatment"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T04:55:14.009242+00:00"
+"Directions": "Cross Streets: Hendershot Rd. ** Directions: From Hwy 56 - head East on RR20."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2150303"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Sump Pump"
]
+"LotSizeDimensions": "100 x 173 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T04:34:17Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T04:34:17Z"
+"StreetName": "#20 REGIONAL"
+"StreetNumber": "293"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3675"
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Rural Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29974470/293-20-regional-road-hamilton-rural-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "A1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 100.0
+"OriginalEntryTimestamp": "2026-07-01T04:17:52.9Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1401088"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974470')"
+"ID": "1581957"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1578919"
+post_author: 1
+"ListingKey": "29969738"
+"ListingId": "X13503810"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T13:55:02Z"
+"RFModificationTimestamp": "2026-06-30T17:29:12Z"
+"ListPrice": 1499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G2R7"
+"UnparsedAddress": "44 NEW MOUNTAIN ROAD, Hamilton (Stoney Creek), Ontario L8G2R7"
+"Coordinates": array:2 [
0 => -79.750946
1 => 43.213957
]
+"Latitude": 43.213957
+"Longitude": -79.750946
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 44 New Mountain Road in Stoney Creek, an exceptional 1.5-storey Board & Batten home set on a spectacular professionally landscaped ravine lot measuring approximately 217 x 289 ft. This 3-bedroom home blends timeless character with quality craftsmanship, featuring engineered hardwood flooring and professionally crafted custom cabinetry throughout, along with three fireplaces, including a wood-burning fireplace in the dining room and gas fireplaces in the family and recreation rooms.The custom kitchen is designed for everyday living and entertaining, offering granite countertops, a large centre island, and ample custom cabinetry. The inviting family room is enhanced by skylights, custom built-in cabinetry, and a gas fireplace. The main floor includes one bedroom and a beautifully updated 3-piece bathroom with a glass shower, while the upper level features two spacious bedrooms and a 5-piece bathroom complete with a glass shower and soaker tub.Step outside to your private backyard oasis featuring an 18' x 36' inground saltwater pool with a newer liner and saltwater system, flagstone patios, and an impressive 13.5' x 27' clear cedar cabana complete with granite countertops and a change room. Additional highlights include a BBQ gas hookup, an attached garage, a newly paved 9-car driveway, mature perennial gardens, and breathtaking ravine views offering exceptional privacy. A rare opportunity to own a truly one-of-a-kind property that combines comfort, craftsmanship, and resort-style outdoor living in one of Stoney Creek's most desirable locations. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T17:28:58.161127+00:00"
+"Directions": "Cross Streets: King St. E. ** Directions: King St. E. - New Mountain Road."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060730"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wooded area"
1 => "Ravine"
2 => "Conservation/green belt"
]
+"LotSizeDimensions": "217.4 x 289.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T13:45:17Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Outdoor pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T13:45:17Z"
+"Stories": "1.5"
+"StreetName": "New Mountain"
+"StreetNumber": "44"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7015.23"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/OduwkFNX1wI?feature=share"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29969738/44-new-mountain-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 217.4
+"OriginalEntryTimestamp": "2026-06-30T13:45:17.77Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1335888"
+"ListOfficeNationalAssociationId": "1344707"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29969738')"
+"ID": "1578919"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: "1578523"
+post_author: 1
+"ListingKey": "29969569"
+"ListingId": "40841695"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T13:10:22Z"
+"RFModificationTimestamp": "2026-06-30T14:20:23Z"
+"ListPrice": 1499900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.74
+"LivingArea": 1632.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G2R7"
+"UnparsedAddress": "44 NEW MOUNTAIN Road, Stoney Creek, Ontario L8G2R7"
+"Coordinates": array:2 [
0 => -79.7510975
1 => 43.2138326
]
+"Latitude": 43.2138326
+"Longitude": -79.7510975
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 44 New Mountain Road in Stoney Creek, an exceptional 1.5-storey Board & Batten home set on a spectacular professionally landscaped ravine lot measuring approximately 217 x 289 ft. This 3-bedroom home blends timeless character with quality craftsmanship, featuring engineered hardwood flooring and professionally crafted custom cabinetry throughout, along with three fireplaces, including a wood-burning fireplace in the dining room and gas fireplaces in the family and recreation rooms. The custom kitchen is designed for everyday living and entertaining, offering granite countertops, a large centre island, and ample custom cabinetry. The inviting family room is enhanced by skylights, custom built-in cabinetry, and a gas fireplace. The main floor includes one bedroom and a beautifully updated 3-piece bathroom with a glass shower, while the upper level features two spacious bedrooms and a 5-piece bathroom complete with a glass shower and soaker tub. Step outside to your private backyard oasis featuring an 18' x 36' inground saltwater pool with a newer liner and saltwater system, flagstone patios, and an impressive 13.5' x 27' clear cedar cabana complete with granite countertops and a change room. Additional highlights include a BBQ gas hookup, an attached garage, a newly paved 9-car driveway, mature perennial gardens, and breathtaking ravine views offering exceptional privacy. A rare opportunity to own a truly one-of-a-kind property that combines comfort, craftsmanship, and resort-style outdoor living in one of Stoney Creek's most desirable locations. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T14:20:09.662231+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1950516"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Conservation/green belt"
2 => "Paved driveway"
3 => "Skylight"
]
+"LotSizeDimensions": "0.74"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T13:02:44Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T13:02:44Z"
+"Stories": "1.5"
+"StreetName": "NEW MOUNTAIN"
+"StreetNumber": "44"
+"StreetSuffix": "Road"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "7015.23"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/OduwkFNX1wI?feature=share"
+"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/29969569/44-new-mountain-road-stoney-creek"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2023012"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 217.0
+"AboveGradeFinishedArea": 1632
+"OriginalEntryTimestamp": "2026-06-30T13:02:44.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1244653"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1302600"
+"CoListOfficeNationalAssociationId": "1223032"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29969569')"
+"ID": "1578523"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1577590"
+post_author: 1
+"ListingKey": "29968459"
+"ListingId": "40843990"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T17:46:17Z"
+"RFModificationTimestamp": "2026-06-30T17:58:24Z"
+"ListPrice": 859900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1957.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G2N1"
+"UnparsedAddress": "57 NEIL Avenue, Stoney Creek, Ontario L8G2N1"
+"Coordinates": array:2 [
0 => -79.7622649
1 => 43.2256352
]
+"Latitude": 43.2256352
+"Longitude": -79.7622649
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Room to spread out and a view that stays with you. Set on a corner lot in a quiet Stoney Creek neighborhood, this full-brick two-storey residence pairs everyday comfort with escarpment views. A covered front porch sets the tone; the double concrete driveway parks four and the attached one-and-a-half-car garage is ready for projects with its workbench and shelving. Inside, a bright foyer opens to a formal living and dining room that run together for easy hosting, while the kitchen flows into a sun-filled dinette with a walkout to the back deck and private yard, an effortless link between indoors and out. A family room anchored by a gas fireplace and a three-piece bathroom complete the main floor. Upstairs, gleaming hardwood leads to four spacious bedrooms and a five-piece bathroom, and two of them - including the primary suite - open through walkouts onto a full-width front balcony. Downstairs, a fully finished basement adds a rec room, game room, a cedar storage closet, a big laundry/utility room and a spacious cantina with plenty of shelving. Outside, perennial gardens, a privacy hedge and a vegetable garden complete a beautifully landscaped yard, all under that escarpment backdrop. Walk to downtown Stoney Creek's cafés, restaurants and Battlefield Park; minutes to Eastgate Mall, Denninger's, schools and the Queen Elizabeth Way and Red Hill Valley Parkway, five minutes to the new Confederation GO station and seven to Confederation Park's beach and waterfront trail. Don’t be TOO LATE*! *REG TM. RSA. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T01:01:04.422498+00:00"
+"Directions": "Queenston Rd to Centennial Pkwy to Neil Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525426"
+"ListOfficeKey": "293261"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Corner Site"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T22:31:34Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T17:32:08Z"
+"Stories": "2.0"
+"StreetName": "NEIL"
+"StreetNumber": "57"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "5900"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29968459/57-neil-avenue-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 1957
+"OriginalEntryTimestamp": "2026-06-29T22:31:34.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063673"
+"ListOfficeNationalAssociationId": "1424570"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968459')"
+"ID": "1577590"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1577324"
+post_author: 1
+"ListingKey": "29968874"
+"ListingId": "X13503100"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T16:30:27Z"
+"RFModificationTimestamp": "2026-06-30T16:33:18Z"
+"ListPrice": 859900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G2N1"
+"UnparsedAddress": "57 NEIL AVENUE, Hamilton (Stoney Creek), Ontario L8G2N1"
+"Coordinates": array:2 [
0 => -79.762267
1 => 43.225596
]
+"Latitude": 43.225596
+"Longitude": -79.762267
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Room to spread out and a view that stays with you. Set on a corner lot in a quiet Stoney Creek neighborhood, this full-brick two-storey residence pairs everyday comfort with escarpment views. A covered front porch sets the tone; the double concrete driveway parks four and the attached one-and-a-half-car garage is ready for projects with its workbench and shelving. Inside, a bright foyer opens to a formal living and dining room that run together for easy hosting, while the kitchen flows into a sun-filled dinette with a walkout to the back deck and private yard, an effortless link between indoors and out. A family room anchored by a gas fireplace and a three-piece bathroom complete the main floor. Upstairs, gleaming hardwood leads to four spacious bedrooms and a five-piece bathroom, and two of them - including the primary suite - open through walkouts onto a full-width front balcony. Downstairs, a fully finished basement adds a rec room, game room, a cedar storage closet, a big laundry/utility room and a spacious cantina with plenty of shelving. Outside, perennial gardens, a privacy hedge and a vegetable garden complete a beautifully landscaped yard, all under that escarpment backdrop. Walk to downtown Stoney Creek's cafés, restaurants and Battlefield Park; minutes to Eastgate Mall, Groceries, schools and the Queen Elizabeth Way and Red Hill Valley Parkway, five minutes to the new Confederation GO station and seven to Confederation Park's beach and waterfront trail. RSA. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T00:43:22.410044+00:00"
+"Directions": "Cross Streets: Centennial Pkwy. ** Directions: QUEENSON RD TO CENTENNIAL PKWY TO NEIL AVE."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "41.5 x 100 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-30T00:14:57Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T16:15:23Z"
+"Stories": "2.0"
+"StreetName": "NEIL"
+"StreetNumber": "57"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5900"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29968874/57-neil-avenue-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 41.6
+"OriginalEntryTimestamp": "2026-06-30T00:14:57.08Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29968874')"
+"ID": "1577324"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25342
+post_id: "1575521"
+post_author: 1
+"ListingKey": "29965142"
+"ListingId": "X13499766"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T19:00:18Z"
+"RFModificationTimestamp": "2026-06-30T19:11:47Z"
+"ListPrice": 829000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E4G4"
+"UnparsedAddress": "11 DRAKES DRIVE, Hamilton (Lakeshore), Ontario L8E4G4"
+"Coordinates": array:2 [
0 => -79.733236
1 => 43.24487
]
+"Latitude": 43.24487
+"Longitude": -79.733236
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Just steps from the lake, waterfront trail, and beach, this beautifully renovated 4-level backsplit offers the perfect combination of space, flexibility, and lifestyle. Situated on a quiet, family-friendly street, you'll enjoy easy access to Confederation Park, Wild Waterworks, parks, schools, shopping, and major commuter routes. Offering over 2,500 sq ft of finished living space, this home provides the versatility today's families are searching for. With 6 bedrooms, 4 bathrooms, 2 kitchens, and 2 laundry areas, this home is designed to adapt to every stage of life. Thoughtfully renovated from top to bottom, it offers two complete living spaces that remain seamlessly connected as one home. Both primary bedrooms feature private ensuites, providing comfort and privacy for multi-generational living, while a separate backyard entrance to the lower living area adds even more flexibility. The beautifully updated kitchen showcases quartz countertops and stainless steel appliances, while the expansive family room is the perfect place for movie nights, holiday celebrations, and everyday living. Outside, you'll discover an oversized backyard with a covered concrete patio, creating the perfect setting for summer BBQs, morning coffee, or unwinding at the end of the day. The hot tub is included in as-is condition, and there's plenty of space for children, pets, gardening, and entertaining family and friends. From evening strolls along the waterfront and bike rides on the trail to summer days spent at Confederation Park or Wild Waterworks, this location offers a lifestyle that's hard to match. Whether you're bringing generations together, looking for room to grow, or simply searching for a home that offers exceptional flexibility without compromising style or location, 11 Drakes Drive delivers. Homes offering this much space, versatility, and lifestyle in one of Hamilton's most desirable lakeside neighbourhoods are rare. (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk out"
4 => "N/A"
5 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T17:13:45.500590+00:00"
+"Directions": "Cross Streets: Grays & Frances. ** Directions: North on Grays, East on Frances, North on Drakes."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241284"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "34.7 x 201.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T14:30:54Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T18:54:46Z"
+"StreetName": "Drakes"
+"StreetNumber": "11"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5533.24"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29965142/11-drakes-drive-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 34.8
+"OriginalEntryTimestamp": "2026-06-29T14:30:53.91Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1479438"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29965142')"
+"ID": "1575521"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 161
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]