array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29579723 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1299661"
+post_author: 1
+"ListingKey": "29579723"
+"ListingId": "40819205"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:56:06Z"
+"RFModificationTimestamp": "2026-06-02T17:46:04Z"
+"ListPrice": 759000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.257
+"LivingArea": 1254.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G2W8"
+"UnparsedAddress": "62 BRENTWOOD Drive, Stoney Creek, Ontario L8G2W8"
+"Coordinates": array:2 [
0 => -79.7484241
1 => 43.2134399
]
+"Latitude": 43.2134399
+"Longitude": -79.7484241
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled at the base of the Niagara Escarpment in one of Stoney Creek's most sought-after neighbourhoods, this beautifully maintained family home offers privacy, comfort, and easy access to top-rated schools. The lot extends into the forest, giving a serene backyard setting with only one neighbour. Inside, the home features two main-level bedrooms and an open, light-filled layout. Recent updates include a modern kitchen, refresed interior finishes, rear deck, and exterior stairs-perfect for entertaining or relaxing with family. Enjoy the convenience of nearby parks, shopping, and dining, with quick access to the QEW via Centennial Parkway and Fruitland Road. Located in the scenic Cardinal Heights area-known for its beautiful cardinal birds - this home offers a rare blend of natual surroundings and neighbourhood amenities, making it a must-see for families and anyone who enjoys privacy and serenity. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-09T18:31:36.308420+00:00"
+"Directions": "King St E to Grey Rd to Brentwood Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2197911"
+"ListOfficeKey": "294490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.257"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-04-09T17:49:45Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:43:41Z"
+"Stories": "1.5"
+"StreetName": "BRENTWOOD"
+"StreetNumber": "62"
+"StreetSuffix": "Drive"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4460.72"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=UMg_gH_1cfA"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1649896436"
"RoomType" => "Recreation room"
"ListingId" => "40819205"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29579723"
"RoomLength" => null
"RoomDimensions" => "17'4'' x 25'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:43:41.81Z"
]
1 => array:11 [
"RoomKey" => "1649896437"
"RoomType" => "Bedroom"
"ListingId" => "40819205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29579723"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:43:41.81Z"
]
2 => array:11 [
"RoomKey" => "1649896438"
"RoomType" => "Primary Bedroom"
"ListingId" => "40819205"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29579723"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:43:41.81Z"
]
3 => array:11 [
"RoomKey" => "1649896439"
"RoomType" => "4pc Bathroom"
"ListingId" => "40819205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29579723"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:43:41.81Z"
]
4 => array:11 [
"RoomKey" => "1649896440"
"RoomType" => "Bedroom"
"ListingId" => "40819205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29579723"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:43:41.81Z"
]
5 => array:11 [
"RoomKey" => "1649896441"
"RoomType" => "Bedroom"
"ListingId" => "40819205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29579723"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:43:41.82Z"
]
6 => array:11 [
"RoomKey" => "1649896442"
"RoomType" => "Kitchen"
"ListingId" => "40819205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29579723"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:43:41.82Z"
]
7 => array:11 [
"RoomKey" => "1649896443"
"RoomType" => "Living room"
"ListingId" => "40819205"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29579723"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:43:41.82Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29579723/62-brentwood-drive-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1254
+"OriginalEntryTimestamp": "2026-04-09T16:30:42.97Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1446283"
+"ListOfficeNationalAssociationId": "1439453"
+"Media": array:37 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6581381042"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/49a1384fbf63a18d7618dc90d950a26e.webp"
"MediaSize" => 146052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-49a1384fbf63a18d7618dc90d950a26e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.48Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6581132929"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/58bd836395e928d9b4f71b239edfb900.webp"
"MediaSize" => 165532
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-58bd836395e928d9b4f71b239edfb900.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T16:30:42.98Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6581133028"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/f5db0e37d7d3fb8facbc609b9d57a932.webp"
"MediaSize" => 161458
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-f5db0e37d7d3fb8facbc609b9d57a932.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T16:30:42.98Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6581381295"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/52ccc90932ed1b815146adc6af2b8c2e.webp"
"MediaSize" => 123600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-52ccc90932ed1b815146adc6af2b8c2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.51Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6581382940"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/10e9a19c8d60ba2b3de8503ac35f400e.webp"
"MediaSize" => 122696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-10e9a19c8d60ba2b3de8503ac35f400e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.21Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6581381408"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/a6bc41c2c15a1667f3d2a8cf7cb33328.webp"
"MediaSize" => 133096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-a6bc41c2c15a1667f3d2a8cf7cb33328.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.4Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6581381186"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/884d88ac739d37d64194a62b3b56a64e.webp"
"MediaSize" => 124101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-884d88ac739d37d64194a62b3b56a64e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.34Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6581382998"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/95673e073a92d93237b2a1ab2bfad397.webp"
"MediaSize" => 127339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-95673e073a92d93237b2a1ab2bfad397.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.42Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6581381390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/ab9c159d250868a3403afd23acec7e91.webp"
"MediaSize" => 96452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-ab9c159d250868a3403afd23acec7e91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.48Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6581381543"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/ec48eca2e4647a7b3ce38a4e790cb0aa.webp"
"MediaSize" => 129679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-ec48eca2e4647a7b3ce38a4e790cb0aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.22Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6581383063"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/b9e1131befe70ef086428476155551b9.webp"
"MediaSize" => 138825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-b9e1131befe70ef086428476155551b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.43Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6581134104"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/4536b6b3c715fff548b3446e2b2722c1.webp"
"MediaSize" => 147461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-4536b6b3c715fff548b3446e2b2722c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T16:30:42.98Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6581134226"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/be35aee624e96cff0368041d28b24df9.webp"
"MediaSize" => 100177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-be35aee624e96cff0368041d28b24df9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T16:30:42.98Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6581134249"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/112f8bce8fc06aa3ce212366c3cfaf49.webp"
"MediaSize" => 152570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-112f8bce8fc06aa3ce212366c3cfaf49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T16:30:42.98Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6581381051"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/7a3d180a5abe2cb463d0da249f665dbe.webp"
"MediaSize" => 71215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-7a3d180a5abe2cb463d0da249f665dbe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.22Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6581381647"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/160e8a758f70b64bbfe73c1e94a7b98b.webp"
"MediaSize" => 93876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-160e8a758f70b64bbfe73c1e94a7b98b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.34Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6581382400"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/490d22094464ec21fad0a258f0827fe2.webp"
"MediaSize" => 79163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-490d22094464ec21fad0a258f0827fe2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.38Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6581382846"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/8c5c2c72be218e124e764637bc1a9fec.webp"
"MediaSize" => 83193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-8c5c2c72be218e124e764637bc1a9fec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.36Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6581381830"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/1237c757133b5604d7cdcbc7fc9dbdf7.webp"
"MediaSize" => 68914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-1237c757133b5604d7cdcbc7fc9dbdf7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.37Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6581382282"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/12f028e012e1d1bd08cdcd7229963674.webp"
"MediaSize" => 88798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-12f028e012e1d1bd08cdcd7229963674.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.4Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6581382918"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/0ade6e8d826d7bd5c778cf91afcca3e3.webp"
"MediaSize" => 72618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-0ade6e8d826d7bd5c778cf91afcca3e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.23Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6581382131"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/1ea27b7e720d7f0926331877f7e9f532.webp"
"MediaSize" => 81680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-1ea27b7e720d7f0926331877f7e9f532.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.22Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6581382314"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/d7e3d96902adafc6db92dfabdb599c67.webp"
"MediaSize" => 57314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-d7e3d96902adafc6db92dfabdb599c67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.48Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6581382872"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/e80978076e6e5d1d217be19fe2e31c0c.webp"
"MediaSize" => 76915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-e80978076e6e5d1d217be19fe2e31c0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.54Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6581381756"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/1635a03c1c8e5084340d9facdc41a67f.webp"
"MediaSize" => 70548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-1635a03c1c8e5084340d9facdc41a67f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.38Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6581382661"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/3ae6a0b53884745182e0c1e7dc3292df.webp"
"MediaSize" => 68766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-3ae6a0b53884745182e0c1e7dc3292df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.34Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6581382887"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/c8a153c04c666fe7d4a196f620bfc41e.webp"
"MediaSize" => 74972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-c8a153c04c666fe7d4a196f620bfc41e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.49Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6581381589"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/e59b9cc28b80be945bc7aded9810cbbc.webp"
"MediaSize" => 69287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-e59b9cc28b80be945bc7aded9810cbbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.37Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6581382840"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/1b02d103c3c42203a6a52db672bc5a06.webp"
"MediaSize" => 67146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-1b02d103c3c42203a6a52db672bc5a06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.38Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6581382142"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/881fb72a8997bf1bec9151bda2d6b64d.webp"
"MediaSize" => 55668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-881fb72a8997bf1bec9151bda2d6b64d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.34Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6581382026"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/f375141f16703a45e0fd6f1fe1f43dd9.webp"
"MediaSize" => 98315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-f375141f16703a45e0fd6f1fe1f43dd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.21Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6581382800"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/c91f32c498b53bf1d723b5627a638049.webp"
"MediaSize" => 95158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-c91f32c498b53bf1d723b5627a638049.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.51Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6581382258"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/3af586567b6aadec1564917b299147ae.webp"
"MediaSize" => 83636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-3af586567b6aadec1564917b299147ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.37Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6581383102"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/c9f31f0202d9ff65fc30a2ce31bc7262.webp"
"MediaSize" => 123747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-c9f31f0202d9ff65fc30a2ce31bc7262.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.46Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6581382531"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/c553a3c2de0d72fad21a63dc872ded3a.webp"
"MediaSize" => 133671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-c553a3c2de0d72fad21a63dc872ded3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.51Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6581382192"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/4c2b9036ed580c9435492a75c76b871e.webp"
"MediaSize" => 116019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-4c2b9036ed580c9435492a75c76b871e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.48Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "6581383141"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29579723/edba106a753590cfca349397f9562bb0.webp"
"MediaSize" => 117099
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29579723/thumbnail-edba106a753590cfca349397f9562bb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40819205"
"ResourceRecordKey" => "29579723"
"ModificationTimestamp" => "2026-04-09T17:42:16.22Z"
]
]
+"DaysOnMarket": 70
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29579723')"
+"ID": "1299661"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 294490" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24855
+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 2197911" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24828
+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 '29579723'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25166
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29579723'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25182
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29579723' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7484241 43.2134399)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25235
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1543087"
+post_author: 1
+"ListingKey": "29921939"
+"ListingId": "40840993"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T16:00:11Z"
+"RFModificationTimestamp": "2026-06-18T16:56:20Z"
+"ListPrice": 989850.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.17
+"LivingArea": 3024.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G2L5"
+"UnparsedAddress": "55 GLENVIEW Drive, Stoney Creek, Ontario L8G2L5"
+"Coordinates": array:2 [
0 => -79.7633672
1 => 43.2225277
]
+"Latitude": 43.2225277
+"Longitude": -79.7633672
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 55 Glenview Drive in Stoney Creek, a rare opportunity to own an exceptional solid brick bungalow offering over 3,000 sq. ft. of finished living space in a sought-after, family-friendly neighbourhood. Perfectly positioned on a quiet cul-de-sac just two doors from Green Acres Park, this impressive home blends timeless curb appeal, thoughtful upgrades, and a functional layout for everyday living and entertaining. The main level offers an inviting foyer leading to a bright living room with cove ceilings and custom wall-to-wall built-in cabinetry. The dining room features garden doors to the private backyard oasis, while the chef-inspired kitchen showcases a large centre island with heated tile flooring, double sink, prep sink, quartz counters, modern cabinetry, and appliances are included. A generous main-floor laundry room with custom storage adds convenience. Three bedrooms are located on the main level, including a private primary wing with a three-piece ensuite, plus a stylish four-piece bath. Heated flooring in many areas of the home, including much of the lower level, adds comfort and luxury. The finished lower level offers additional living space with a large recreation room with custom wet bar with live-edge countertop, fourth bedroom, three-piece bath, utility room, and excellent storage. Step outside to a private, fenced yard landscaped with perennial gardens. The covered deck is perfect for relaxing or entertaining, and the custom shed/workshop with hydro is ideal for hobbies, storage, or projects. Thoughtfully updated, including a full roof replacement with plywood in 2025, this home also features updated bathrooms, quartz finishes, central vacuum, security system, Ethernet wiring, in-wall speakers, water softener, reverse osmosis system, upgraded exterior doors, and more. With quick access to the QEW, Red Hill, Highway 403, shopping, restaurants, parks, and amenities, this elegant, move-in ready home is one of a kind! (id:62650)"
+"Appliances": array:4 [
0 => "Water purifier"
1 => "Water softener"
2 => "Central Vacuum"
3 => "Wet Bar"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:56:12.061156+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524687"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Ravine"
1 => "Wet bar"
2 => "Paved driveway"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.17"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T15:52:21Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T15:52:21Z"
+"Stories": "1.0"
+"StreetName": "GLENVIEW"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "5467.33"
+"VirtualTourURLUnbranded": "https://youtu.be/YkoFi89wAwc"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1662140039"
"RoomType" => "Utility room"
"ListingId" => "40840993"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.13Z"
]
1 => array:11 [
"RoomKey" => "1662140040"
"RoomType" => "Storage"
"ListingId" => "40840993"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.13Z"
]
2 => array:11 [
"RoomKey" => "1662140041"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840993"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.13Z"
]
3 => array:11 [
"RoomKey" => "1662140042"
"RoomType" => "Bedroom"
"ListingId" => "40840993"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.13Z"
]
4 => array:11 [
"RoomKey" => "1662140043"
"RoomType" => "Recreation room"
"ListingId" => "40840993"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "21'7'' x 29'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.13Z"
]
5 => array:11 [
"RoomKey" => "1662140044"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840993"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.13Z"
]
6 => array:11 [
"RoomKey" => "1662140045"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840993"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.14Z"
]
7 => array:11 [
"RoomKey" => "1662140046"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840993"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.14Z"
]
8 => array:11 [
"RoomKey" => "1662140047"
"RoomType" => "Bedroom"
"ListingId" => "40840993"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.14Z"
]
9 => array:11 [
"RoomKey" => "1662140048"
"RoomType" => "Bedroom"
"ListingId" => "40840993"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.14Z"
]
10 => array:11 [
"RoomKey" => "1662140049"
"RoomType" => "Laundry room"
"ListingId" => "40840993"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.14Z"
]
11 => array:11 [
"RoomKey" => "1662140050"
"RoomType" => "Eat in kitchen"
"ListingId" => "40840993"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.14Z"
]
12 => array:11 [
"RoomKey" => "1662140051"
"RoomType" => "Dining room"
"ListingId" => "40840993"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.14Z"
]
13 => array:11 [
"RoomKey" => "1662140052"
"RoomType" => "Living room"
"ListingId" => "40840993"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 19'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.14Z"
]
14 => array:11 [
"RoomKey" => "1662140053"
"RoomType" => "Foyer"
"ListingId" => "40840993"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29921939"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 5'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T15:51:30.15Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921939/55-glenview-drive-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1628810"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1739
+"BelowGradeFinishedArea": 1285
+"OriginalEntryTimestamp": "2026-06-18T15:51:30.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063164"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1161564"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29921939_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/5677dda3d45fb75a2634fba34c193903.webp"
"MediaSize" => 144806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-5677dda3d45fb75a2634fba34c193903.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:17.93Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29921939_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/ed1cf5ddcce34ae0d35069ee24a3e0c4.webp"
"MediaSize" => 107192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-ed1cf5ddcce34ae0d35069ee24a3e0c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:18.71Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29921939_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/0cf842fffe3f42476f41d087b95e5331.webp"
"MediaSize" => 174469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-0cf842fffe3f42476f41d087b95e5331.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:17.9Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29921939_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/3028552cbcbaecc892a55831b0dfcf13.webp"
"MediaSize" => 177152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-3028552cbcbaecc892a55831b0dfcf13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:18.35Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29921939_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/07e387f19ff6d72171fd351e8d636de5.webp"
"MediaSize" => 144806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-07e387f19ff6d72171fd351e8d636de5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:18.38Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29921939_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/876baeafa183f75e045ea0c65d6f5373.webp"
"MediaSize" => 98691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-876baeafa183f75e045ea0c65d6f5373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:18.35Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29921939_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/e1335c789fcef364c43171b79c81741c.webp"
"MediaSize" => 103564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-e1335c789fcef364c43171b79c81741c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:18.72Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29921939_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/3a97644e340ee1483055eb57ebae5187.webp"
"MediaSize" => 73592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-3a97644e340ee1483055eb57ebae5187.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:18.37Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29921939_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/d1d94cc085e132f8ac457a813dba1467.webp"
"MediaSize" => 91177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-d1d94cc085e132f8ac457a813dba1467.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:18.9Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29921939_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/9a656d893fed0b5367cde6957787a35b.webp"
"MediaSize" => 88022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-9a656d893fed0b5367cde6957787a35b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:19.72Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29921939_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/e6712f5112dbb799750e2f522e4e68da.webp"
"MediaSize" => 78977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-e6712f5112dbb799750e2f522e4e68da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:18.47Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29921939_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/8014c32af5063027c370866b2507feb5.webp"
"MediaSize" => 84946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-8014c32af5063027c370866b2507feb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:19.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29921939_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/e78d4b857d893bad64341fa37839eee8.webp"
"MediaSize" => 89658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-e78d4b857d893bad64341fa37839eee8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:18.76Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29921939_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/0af3543925748cc2b8e28dbbf555db15.webp"
"MediaSize" => 86936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-0af3543925748cc2b8e28dbbf555db15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840993"
"ResourceRecordKey" => "29921939"
"ModificationTimestamp" => "2026-06-18T15:52:19.66Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29921939_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29921939/5550e666c35a85f92040ae5eca587b17.webp"
"MediaSize" => 90289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29921939/thumbnail-5550e666c35a85f92040ae5eca587b17.webp"
"ResourceName" => "Property"
…6
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921939')"
+"ID": "1543087"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25231
+post_id: "1540738"
+post_author: 1
+"ListingKey": "29918492"
+"ListingId": "X13458290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:00:17Z"
+"RFModificationTimestamp": "2026-06-17T21:35:59Z"
+"ListPrice": 724999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1N9"
+"UnparsedAddress": "17 ALBA STREET, Hamilton (Stoney Creek), Ontario L8G1N9"
+"Coordinates": array:2 [
0 => -79.765014
1 => 43.212423
]
+"Latitude": 43.212423
+"Longitude": -79.765014
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully updated solid brick bungalow offering 3 bedrooms, 2 full bathrooms, and a versatile layout ideal for families, downsizers, or multi-generational living. Located in one of Stoney Creek's most sought-after neighbourhoods, directly below the Niagara Escarpment, you'll enjoy easy access to the Bruce Trail, Devil's Punch Bowl, Battlefield Park, countless parks, and outdoor recreation. Commuters will love the proximity to the Red Hill Valley Parkway, Lincoln Alexander Parkway, QEW, and the future Stoney Creek GO Station. Featuring a separate side entrance and finished lower level, this home offers excellent in-law suite potential. Extensively renovated since 2020, the home blends timeless charm with modern updates. The stunning 2021 kitchen renovation included new cabinetry, flooring, lighting, baseboards, outlets, dishwasher, and stylish finishes throughout. The main floor was further refreshed with updated flooring, lighting, paint, and repairs to windows and doors. The main bathroom was tastefully updated with a new vanity, toilet, flooring, lighting, and fixtures, while the lower-level bathroom was completely rebuilt with a new shower, vanity, toilet, flooring, lighting, and exterior-vented exhaust fan. The finished basement adds exceptional living space with new drywall, windows, carpeting, baseboards, lighting, paint, updated electrical, and a modern electric fireplace. The former wood stove and chimney were removed to create a clean, contemporary feel. The laundry room was also fully upgraded with new flooring, windows, lighting, cabinetry, and finished drywall. Outside, enjoy expanded front and rear decks, a raised and enlarged shed, partial new fencing, a refinished driveway, stone walkways, raised garden beds, and eight fruit trees creating a private backyard retreat. Move-in ready and loaded with value, this extensively updated home offers the perfect blend of comfort, functionality, location, and future potential. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T21:35:53.577115+00:00"
+"Directions": "King St. to Battlefield Dr. south to Alba turn left"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104490"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wooded area"
]
+"LotSizeDimensions": "53.7 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T20:53:46Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T20:53:46Z"
+"Stories": "1.0"
+"StreetName": "Alba"
+"StreetNumber": "17"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4068"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29918492/17-alba-street-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 53.8
+"OriginalEntryTimestamp": "2026-06-17T20:53:46.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373980"
+"ListOfficeNationalAssociationId": "1344892"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918492')"
+"ID": "1540738"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: "1539162"
+post_author: 1
+"ListingKey": "29914609"
+"ListingId": "40840183"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:20:04Z"
+"RFModificationTimestamp": "2026-06-17T17:17:52Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2441.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8J0K9"
+"UnparsedAddress": "35 MIDHURST Heights Unit# 1, Hamilton, Ontario L8J0K9"
+"Coordinates": array:2 [
0 => -79.7653957
1 => 43.2049018
]
+"Latitude": 43.2049018
+"Longitude": -79.7653957
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beyond a home, Fallingwater is a statement of arrival and a masterpiece of the esteemed Losani Collection. This is not merely Unit #1; it is the vision that set the standard, the original model home that showcased the full potential of contemporary luxury living in Stoney Creek. Commanding the most expansive, pie-shaped lot, this end-unit sanctuary offers unrivaled privacy and a breathtaking, direct view over a tranquil outdoor pond—a serene vista enjoyed from your principal rooms. With only three units in the complex, exclusivity is paramount, and this residence represents the undisputed pinnacle. Step inside to discover over 2,441 square feet of impeccably designed, living space, artfully enhanced by high ceilings that amplifies the sense of light and volume. The home unfolds with the grace of a gallery, leading you to a sprawling 164 sq. ft. elevated terrace, your private stage for outdoor entertaining. Ascend further to the 241 sq. ft. rooftop terrace—a crowning glory offering panoramic views and an unparalleled space for sunset soirees or peaceful contemplation. While other, more modestly scaled units are available in the complex, Fallingwater stands apart. It is the largest, the first, and by every measure, the finest. This is the home for those who seek not just square footage, but significance; not just a view, but a vista; not just a unit, but a legacy property. Presented with professional photography that captures its exquisite d architectural brilliance, Fallingwater awaits its final curator. This is your chance to acquire the cornerstone residence of Stone Creek's most distinguished address. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Central Vacuum - Roughed In"
]
+"AssociationFee": "446.64"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Insurance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T17:17:25.256814+00:00"
+"Directions": "Green Mountain and Upper Centennial"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525060"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Balcony"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T13:10:49Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T13:10:48Z"
+"Stories": "2.0"
+"StreetName": "MIDHURST"
+"StreetNumber": "35"
+"StreetSuffix": "Heights"
+"SubdivisionName": "500 - Heritage Green"
+"TaxAnnualAmount": "6995.42"
+"View": "View of water"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29914609/35-midhurst-heights-unit-1-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "P5, RM3-50, RM3-51"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 2441
+"OriginalEntryTimestamp": "2026-06-17T13:10:48.91Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1135225"
+"ListOfficeNationalAssociationId": "1132083"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914609')"
+"ID": "1539162"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25232
+post_id: "1538886"
+post_author: 1
+"ListingKey": "29915912"
+"ListingId": "X13455996"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:05:15Z"
+"RFModificationTimestamp": "2026-06-17T16:32:31Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Riverdale)"
+"PostalCode": "L8E3T8"
+"UnparsedAddress": "366 BERKINDALE DRIVE, Hamilton (Riverdale), Ontario L8E3T8"
+"Coordinates": array:2 [
0 => -79.744411
1 => 43.226447
]
+"Latitude": 43.226447
+"Longitude": -79.744411
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully maintained 4-level backsplit, where pride of ownership is evident throughout. Impeccably kept and truly move-in ready, this exceptional home offers a level of care and attention that is rarely seen. Mrs.Clean definitely lives here! Thoughtfully designed with afunctional and spacious layout, this home also offers in-law suite potential-ideal for extended family or future income opportunities. Enjoy peace of mind with key updates already completed, including a newer roof (2022), updated windows and patio door, and a newer main kitchen stove(2021). Step outside to your own private backyard retreat-perfect for relaxing or entertaining-featuring a hot tub and TV setup for year-round enjoyment. Located in a desirable, family-friendly neighborhood, close to schools, shopping, and everyday amenities. An added bonus is the exceptional storage throughout, including a 21 x11x ft loft above the garage-ideal for a workshop, studio, or additional storage-as well as a huge crawl space to keep everything neatly organized. A rare opportunity to own a home that truly has it all! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Stove"
5 => "Dryer"
6 => "Freezer"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T16:32:18.283674+00:00"
+"Directions": "Cross Streets: Federal Street. ** Directions: Gray Road, to Federal Street, To Berkindale Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025204"
+"ListOfficeKey": "279481"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "40 x 104 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T15:57:56Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T15:57:55Z"
+"StreetName": "BERKINDALE"
+"StreetNumber": "366"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5898.72"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Riverdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29915912/366-berkindale-drive-hamilton-riverdale-riverdale"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "D/S-336"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-17T15:57:55.91Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1304916"
+"ListOfficeNationalAssociationId": "1304915"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915912')"
+"ID": "1538886"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: "1530269"
+post_author: 1
+"ListingKey": "29903950"
+"ListingId": "2128555"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T16:10:07Z"
+"RFModificationTimestamp": "2026-06-15T16:48:55Z"
+"ListPrice": 349000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8G1B4"
+"UnparsedAddress": "851 Queenston Road Unit# 601, Hamilton, Ontario L8G1B4"
+"Coordinates": array:2 [
0 => -79.760902
1 => 43.227837
]
+"Latitude": 43.227837
+"Longitude": -79.760902
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Sudbury Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully upgraded 2 bedroom plus den condo offering the perfect belnd of comofrt, style and convenience. This condo features upgraded kitchen cabinets, newer appliances, and modern lighting. Every detail has been attended to - from the fully redone baseboards to the elegant double door entry. The open concept layout is ideal for both everyday living and entertaining, while the balcony positioned away from Queenston Road - offers a peaceful retreat with no traffic noise. This unit is unique as it has in-suite laundry. You will enjoy the secuirty of a controlled building entrance and two coveted underground parking spaces and a storage locker. Whether you're an investor or sometone to call Unit 601 home, this well maintained unit checks all the boxes. (id:62650)"
+"AssociationFee": "763.63"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-15T16:48:49.612288+00:00"
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523314"
+"ListOfficeKey": "79955"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-15T16:04:31Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T16:04:31Z"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Sudbury"
+"ListAORKey": "35"
+"ListingURL": "www.realtor.ca/real-estate/29903950/851-queenston-road-unit-601-hamilton"
+"StructureType": array:1 [
0 => "Other"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": false
+"ZoningDescription": "C, RM5"
+"OriginalEntryTimestamp": "2026-06-15T16:04:31.94Z"
+"ListAgentNationalAssociationId": "1038262"
+"ListOfficeNationalAssociationId": "1001285"
+"Media": array:17 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903950')"
+"ID": "1530269"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: "1530085"
+post_author: 1
+"ListingKey": "29902817"
+"ListingId": "40839577"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T13:15:03Z"
+"RFModificationTimestamp": "2026-06-15T15:32:06Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1313.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1R7"
+"UnparsedAddress": "22 MARION Place, Stoney Creek, Ontario L8G1R7"
+"Coordinates": array:2 [
0 => -79.7619961
1 => 43.2134775
]
+"Latitude": 43.2134775
+"Longitude": -79.7619961
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming 1.5-storey detached home tucked away on a quiet dead-end street in a fantastic neighborhood! Featuring 3 bedrooms, including a main floor bedroom for added convenience, this home features a versatile layout perfect for families or downsizers. Bright and inviting main floor with a 3-piece bathroom. Enjoy your morning coffee or unwind in the sunroom overlooking the backyard. Detached single-car garage adds extra storage and functionality. Unfinished basement provides endless possibilities to make it your own. A great opportunity in a peaceful, family-friendly location! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:32:02.201918+00:00"
+"Directions": "wardrope ave to trevor"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524566"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T13:11:46Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T13:11:46Z"
+"Stories": "1.5"
+"StreetName": "MARION"
+"StreetNumber": "22"
+"StreetSuffix": "Place"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4340.33"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/362684"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902817/22-marion-place-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1313
+"OriginalEntryTimestamp": "2026-06-15T13:10:02.29Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1102136"
+"ListOfficeNationalAssociationId": "1398404"
+"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('29902817')"
+"ID": "1530085"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1530106"
+post_author: 1
+"ListingKey": "29902965"
+"ListingId": "X13443952"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T13:55:19Z"
+"RFModificationTimestamp": "2026-06-15T15:26:43Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1R7"
+"UnparsedAddress": "22 MARION PLACE, Hamilton (Stoney Creek), Ontario L8G1R7"
+"Coordinates": array:2 [
0 => -79.762082
1 => 43.213464
]
+"Latitude": 43.213464
+"Longitude": -79.762082
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this charming 1.5-storey detached home tucked away on a quiet dead-end street in a fantastic neighborhood! Featuring 3 bedrooms, including a main floor bedroom for added convenience, this home features a versatile layout perfect for families or downsizers. Bright and inviting main floor with a 3-piece bathroom. Enjoy your morning coffee or unwind in the sunroom overlooking the backyard. Detached single-car garage adds extra storage and functionality. Unfinished basement provides endless possibilities to make it your own. A great opportunity in a peaceful, family-friendly location! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:26:29.420984+00:00"
+"Directions": "Cross Streets: TREVOR DR. ** Directions: wardrope ave to trevor."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2146668"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 110.2 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T13:45:16Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T13:45:16Z"
+"Stories": "1.5"
+"StreetName": "Marion"
+"StreetNumber": "22"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "4340.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29902965/22-marion-place-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-15T13:45:16.52Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1397862"
+"ListOfficeNationalAssociationId": "1398828"
+"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('29902965')"
+"ID": "1530106"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25233
+post_id: "1530107"
+post_author: 1
+"ListingKey": "29902988"
+"ListingId": "40829987"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T14:00:08Z"
+"RFModificationTimestamp": "2026-06-15T15:25:32Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1172.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1S2"
+"UnparsedAddress": "20 WARDROPE Avenue, Stoney Creek, Ontario L8G1S2"
+"Coordinates": array:2 [
0 => -79.7619651
1 => 43.2161206
]
+"Latitude": 43.2161206
+"Longitude": -79.7619651
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your dream farmhouse in the city, perfectly situated just steps from downtown Stoney Creek & Historic Battlefield Park! This stunning property combines modern amenities with rustic charm, offering a unique lifestyle for discerning buyers. Imagine unwinding in your expansive outdoor detached sunroom, complete with power, or hosting summer barbecues in the covered area just off the newly updated kitchen. This culinary haven features elegant stone countertops, newer appliances—including a gas range—and stylish cabinetry, making meal prep a joy. The large island with breakfast bar and stools invites casual dining, while the marble backsplash adds a touch of sophistication. As you enter, you’re greeted by a charming foyer with new flooring that flows seamlessly into a spacious dining room, where two large windows bathe the space in natural light. The inviting family room boasts hardwood flooring and fresh paint, creating an ideal setting for relaxation and entertaining. Head upstairs to discover a large primary bedroom with ensuite privileges, ensuring privacy and comfort. The room features two windows and a generous closet, perfect for your wardrobe. Two additional bedrooms, each with closets, provide ample space for family or guests. The beautifully updated bathroom is a true retreat, showcasing a walk-in shower, a classic clawfoot tub, and a window that invites the outdoors in. With a large lot and detached garage, this property offers abundant outdoor space for gardening, play, or simply enjoying the serene surroundings. Don’t miss the chance to own this exceptional farmhouse where modern living meets classic elegance. Walk to restaurants and shopping, Make it yours today! Updates include: Furnace and AC - 24, Basement Waterproofing & Sump Pump- 21, Fridge/Dishwasher/Gas Stove/Gas Dryer/Deep Freezer- 21, Steel Roof - 14, Siding/Windows -16. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T15:25:29.502196+00:00"
+"Directions": "King St E to Wardrope Ave"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524250"
+"ListOfficeKey": "54923"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T13:52:08Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T13:52:08Z"
+"Stories": "2.0"
+"StreetName": "WARDROPE"
+"StreetNumber": "20"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "4268.56"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29902988/20-wardrope-avenue-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1533175"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "54923"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 1172
+"OriginalEntryTimestamp": "2026-06-15T13:52:08.15Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1127411"
+"ListOfficeNationalAssociationId": "1003529"
+"CoListAgentNationalAssociationId": "1143027"
+"CoListOfficeNationalAssociationId": "1003529"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29902988')"
+"ID": "1530107"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25234
+post_id: "1529190"
+post_author: 1
+"ListingKey": "29901626"
+"ListingId": "X13442704"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T15:25:10Z"
+"RFModificationTimestamp": "2026-06-14T21:12:40Z"
+"ListPrice": 3998000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J2Y5"
+"UnparsedAddress": "420 RIDGE ROAD, Hamilton (Stoney Creek Mountain), Ontario L8J2Y5"
+"Coordinates": array:2 [
0 => -79.734014
1 => 43.209478
]
+"Latitude": 43.209478
+"Longitude": -79.734014
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "420 Ridge Road where the fortunes of the past meet the opportunity of the future on this idyllic 77+1- acre farm. Set atop the edge of the escarpment which offers panoramic views of the region this property offers a rare opportunity to own a large piece of property on one of Ontario's estately streets. It is conveniently located 5 minutes from downtown Stoney Creek, close in proximity to both city amenities and all major transportation routes. Step back in time as you explore the original red brick homestead full of character and awaiting a new owner. Complete with slate roof, five bedrooms and large verandas, this gem exudes warmth and charm. The thick beam hip roof barn is sturdy in construction with ample space and provides endless opportunities for a hobby farmer or agri-tourism venture. A steel insulated and heated outbuilding awaits, offering the perfect workshop with concrete floors, wood paneled horse stalls, hot and cold water, electric door entrance. Whether you're a crafts person, an artist, or horse enthusiast, this space is sure to inspire creativity and productivity. Outside large fenced in paddocks and well maintained pastures for grazing are ready to welcome your animals. Whether you're starting a small hobby farm or expanding your agricultural endeavors, this property has everything you need to make your vision a reality. Don't miss your opportunity to own a piece of this paradise at 420 Ridge Road, Stoney Creek Ontario (id:62783)"
+"Appliances": array:1 [
0 => "Refrigerator"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-14T21:12:37.243525+00:00"
+"Directions": "Upper Centennial Parkway"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2055870"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Wooded area"
2 => "Irregular lot size"
3 => "Conservation/green belt"
]
+"LotSizeDimensions": "286 x 2901 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-14T15:17:35Z"
+"PhotosCount": 35
+"PossibleUse": "Pasture"
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T15:17:35Z"
+"Stories": "2.0"
+"StreetName": "Ridge"
+"StreetNumber": "420"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2768"
+"Utilities": array:1 [
0 => "Electricity"
]
+"View": "City view,Lake view"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"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 Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29901626/420-ridge-road-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 20
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "NEC/ Agr"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 286.0
+"OriginalEntryTimestamp": "2026-06-14T15:17:35.79Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1331169"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:35 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29901626')"
+"ID": "1529190"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 138
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]