array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29198328/Property?$select=ALL&$top=20&$filter=ListingKey eq 29198328&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29198328/Property?$select=ALL&$top=20&$filter=ListingKey eq 29198328&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23512
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23514
+post_id: "496598"
+post_author: 1
+"ListingKey": "29198328"
+"ListingId": "X12645042"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-21T00:10:59Z"
+"RFModificationTimestamp": "2025-12-21T00:12:22Z"
+"ListPrice": 314900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G3S4"
+"UnparsedAddress": "3 - 5 APPLEWOOD AVENUE, Hamilton (Stoney Creek), Ontario L8G3S4"
+"Coordinates": array:2 [
0 => -79.75238
1 => 43.217445
]
+"Latitude": 43.217445
+"Longitude": -79.75238
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Cheerful and Spacious Fully Renovated Condo In The Heart Of Old Stoney Creek. Fantastic Location in Close Proximity To 4 Parks, Recreation Facilities, Great Restaurants, Shopping, Public Transit, Stoney Creek Go, As Well As Lots Of Other Amenities. Many recent upgrades including new kitchen with marble design Backsplash, Quartz countertops, brand new stainless steel appliances and built in dishwasher, Luxury vinyl plank flooring, updated 4 piece bathroom, Freshly Painted throughout, New Windows, Double closets in the bright Bedroom, double wide hallway closet for storage, the list goes on! Nothing to do here but move in. With low condo fees and a very attractive price this home is perfect for first-time home buyers or those looking for an easy care-free lifestyle. Condo Fees Include Exterior Maintenance, Exterior Insurance, Heat, Water & your own Dedicated parking space! (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
4 => "Window Air Conditioner"
5 => "Window Coverings"
]
+"AssociationFee": "445.34"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2025-12-21T00:12:00.471617+00:00"
+"Directions": "Cross Streets: Gray Rd and King St E. ** Directions: Gray Rd to King St E to Applewood Ave."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1746450"
+"ListOfficeKey": "268318"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-20T23:52:35Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-20T23:56:55Z"
+"Stories": "3.0"
+"StreetName": "Applewood"
+"StreetNumber": "5"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "1079"
+"Rooms": array:4 [
0 => array:11 [
"RoomKey" => "1551963265"
"RoomType" => "Bedroom"
"ListingId" => "X12645042"
"RoomLevel" => "Main level"
"RoomWidth" => 3.048
"ListingKey" => "29198328"
"RoomLength" => 4.1148
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-20T23:56:55.03Z"
]
1 => array:11 [
"RoomKey" => "1551963266"
"RoomType" => "Bathroom"
"ListingId" => "X12645042"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29198328"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-20T23:56:55.04Z"
]
2 => array:11 [
"RoomKey" => "1551963267"
"RoomType" => "Living room"
"ListingId" => "X12645042"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5052
"ListingKey" => "29198328"
"RoomLength" => 4.7244
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-20T23:56:55.05Z"
]
3 => array:11 [
"RoomKey" => "1551963268"
"RoomType" => "Kitchen"
"ListingId" => "X12645042"
"RoomLevel" => "Main level"
"RoomWidth" => 1.9812
"ListingKey" => "29198328"
"RoomLength" => 4.7244
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-20T23:56:55.05Z"
]
]
+"ListAOR": "Niagara"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29198328/3-5-applewood-avenue-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2081731"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"CoListOfficeKey": "268318"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2025-12-20T22:56:53.53Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:32 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6377939403"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/34fda35b28af07bf051722ec79d7d5ee.webp"
"MediaSize" => 73263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-34fda35b28af07bf051722ec79d7d5ee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Welcome to 5 Applewood Ave in Stoney Creek"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6377939450"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/69c6c94cd28c933221c5137472eb61df.webp"
"MediaSize" => 50880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-69c6c94cd28c933221c5137472eb61df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Secure entry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6377939501"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/afb570ab72ad61213a488bd34d30eabc.webp"
"MediaSize" => 36557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-afb570ab72ad61213a488bd34d30eabc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unit #3"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T23:52:35.01Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6377939581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/f34c1c9f4378060fa83a9a7e00f2e29b.webp"
"MediaSize" => 50189
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-f34c1c9f4378060fa83a9a7e00f2e29b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T23:52:35.02Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6377939616"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/5416f49956bc1b702b51c2bb3472a35d.webp"
"MediaSize" => 49103
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-5416f49956bc1b702b51c2bb3472a35d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T23:52:35.02Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6377939720"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/4f5e553d88862378ce63877d6602ec96.webp"
"MediaSize" => 84830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-4f5e553d88862378ce63877d6602ec96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T23:52:35.04Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6377939766"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/3dd0c453bd0cbb7048950e2d6d231f67.webp"
"MediaSize" => 30612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-3dd0c453bd0cbb7048950e2d6d231f67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entry into the Unit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6377939873"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/1c05f2b83fbd1cafd38ebc054f8d05e5.webp"
"MediaSize" => 40460
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-1c05f2b83fbd1cafd38ebc054f8d05e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Oversized living room with brand new windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6377939910"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/f494a5b4871970d36c002232cb616b08.webp"
"MediaSize" => 41173
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-f494a5b4871970d36c002232cb616b08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Freshly painted throughout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6377939941"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/8428f1033c561ae71ea7b335c08bd744.webp"
"MediaSize" => 42977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-8428f1033c561ae71ea7b335c08bd744.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6377939995"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/5e4d1191c25eec34e207929405e0d8d7.webp"
"MediaSize" => 40470
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-5e4d1191c25eec34e207929405e0d8d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6377940040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/f1e4b5ca04f8713fd5d51859a7f5e5ea.webp"
"MediaSize" => 34413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-f1e4b5ca04f8713fd5d51859a7f5e5ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6377940094"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/b9ea3272eadb933104559f6d4bb126f6.webp"
"MediaSize" => 36876
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-b9ea3272eadb933104559f6d4bb126f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Beautifully renovated Kitchen with white cabinets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6377940131"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/b1d9a701edfdfa5c0e760b6d31e1b8c8.webp"
"MediaSize" => 40204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-b1d9a701edfdfa5c0e760b6d31e1b8c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6377940219"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/b6bc84a3e04249253c4ed65fa75c7cf3.webp"
"MediaSize" => 38679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-b6bc84a3e04249253c4ed65fa75c7cf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Quartz counter tops and undermount double sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6377940269"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/376ff534cd889f99083f2202e275fa72.webp"
"MediaSize" => 40003
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-376ff534cd889f99083f2202e275fa72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6377940283"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/7bbe44719ff99b93624284df4f91e1b8.webp"
"MediaSize" => 36546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-7bbe44719ff99b93624284df4f91e1b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "GE Stainless Steel Fridge"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6377940308"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/e72213cea92a44928035cbffe04e7f13.webp"
"MediaSize" => 38583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-e72213cea92a44928035cbffe04e7f13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "GE Stainless steel ceramic cooktop stove"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6377940368"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/6298725bb7c5f44f030ea3f6667fcd86.webp"
"MediaSize" => 32806
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-6298725bb7c5f44f030ea3f6667fcd86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "GE Stainless steel built-in dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6377940409"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/fd551af1bc090b67041cc27fa518dfba.webp"
"MediaSize" => 27838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-fd551af1bc090b67041cc27fa518dfba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Linen closet storage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6377940427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/f29c3181f05d142c6b68b8a589d79e2b.webp"
"MediaSize" => 40911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-f29c3181f05d142c6b68b8a589d79e2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Huge Bedroom big enough for a King Sized bed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6377940470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/23e99c068080d781b66426bcf905db42.webp"
"MediaSize" => 41393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-23e99c068080d781b66426bcf905db42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6377940482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/0ecc9fc5016a511e0e788b87f1431119.webp"
"MediaSize" => 38855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-0ecc9fc5016a511e0e788b87f1431119.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6377940517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/a60ae25c0650ce18b2882b762a5676dc.webp"
"MediaSize" => 41757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-a60ae25c0650ce18b2882b762a5676dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6377940554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/18ebe4c767671c110bf7a261d5ae9e07.webp"
"MediaSize" => 39212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-18ebe4c767671c110bf7a261d5ae9e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6377940566"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/e527876d8310eb1acc9e9893bd148f3b.webp"
"MediaSize" => 35230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-e527876d8310eb1acc9e9893bd148f3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Updated 4 piece bathroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6377940588"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/4428f4f7066b7a77b474d4e6ac64f3ae.webp"
"MediaSize" => 32684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-4428f4f7066b7a77b474d4e6ac64f3ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6377940607"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/9d245331eed8d510fef83b9854f6e4c1.webp"
"MediaSize" => 35151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-9d245331eed8d510fef83b9854f6e4c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6377940641"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/03f41d5e288af8188842746bc9796a74.webp"
"MediaSize" => 33121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-03f41d5e288af8188842746bc9796a74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6377940680"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/0ac29f0b608902490942b8c5e3d4969f.webp"
"MediaSize" => 37583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-0ac29f0b608902490942b8c5e3d4969f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Laundry room located in the lower level"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6377940695"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/8df32f9be19eed0eab449ab758cb0db3.webp"
"MediaSize" => 38743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-8df32f9be19eed0eab449ab758cb0db3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6377940728"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29198328/d18f430f65647121054ea08767cadefb.webp"
"MediaSize" => 75405
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29198328/thumbnail-d18f430f65647121054ea08767cadefb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "5 Applewood Ave, Stoney Creek"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12645042"
"ResourceRecordKey" => "29198328"
"ModificationTimestamp" => "2025-12-20T22:56:53.53Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "M. Ryan Martin"
"MemberFirstName" => "M. Ryan"
"MemberLastName" => "Martin"
"MemberMlsId" => "9641639"
"OriginatingSystemName" => 26
"MemberKey" => "1746450"
"ModificationTimestamp" => "2025-10-27T17:59:19Z"
"MemberStatus" => "Active"
"OfficeKey" => "268318"
"MemberAOR" => "Niagara"
"Media" => array:1 [ …1]
"JobTitle" => "Broker of Record"
"MemberType" => "Salesperson"
"MemberAORKey" => "114"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "416-939-6000"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2008-02-14T04:10:00Z"
"MemberNationalAssociationId" => "1180413"
"OfficeNationalAssociationId" => "1284892"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "REFLECTION BAY REALTY INC., BROKERAGE"
"OfficePhone" => "289-876-8717"
"OfficeMlsId" => "463800"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "268318"
"ModificationTimestamp" => "2025-10-27T17:48:10Z"
"OfficeAddress1" => "2981 SHAWNEE TRAIL"
"OfficeCity" => "RIDGEWAY"
"OfficePostalCode" => "L0S1N"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Niagara"
"OfficeType" => "Firm"
"OfficeAORKey" => "114"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2011-12-12T19:40:00Z"
"OfficeNationalAssociationId" => "1284892"
"OfficeBrokerNationalAssociationId" => "1180413"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29198328')"
+"ID": "496598"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 268318/Office?$select=ALL&$top=10&$filter=OfficeKey eq 268318&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 268318/Office?$select=ALL&$top=10&$filter=OfficeKey eq 268318&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25340
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25342
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "REFLECTION BAY REALTY INC., BROKERAGE"
+"OfficeEmail": null
+"OfficePhone": "289-876-8717"
+"OfficeMlsId": "463800"
+"ModificationTimestamp": "2025-10-27T17:48:10Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "268318"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "2981 SHAWNEE TRAIL"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "RIDGEWAY"
+"OfficePostalCode": "L0S1N"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Niagara"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1284892"
+"OriginalEntryTimestamp": "2011-12-12T19:40:00Z"
+"OfficeAORKey": "114"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "377028"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "268318"
"SocialMediaUrlOrId" => "http://reflectionbayrealty.com/"
"ModificationTimestamp" => "2025-10-27T13:55:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1180413"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('268318')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.27 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1746450/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1746450&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1746450/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1746450&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25345
+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 29198328" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24969
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29198328/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29198328&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29198328/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29198328&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24949
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29198328 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.75238 43.217445)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29198328 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.75238 43.217445)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29198328 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.75238 43.217445)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29198328 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.75238 43.217445)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24874
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24856
+post_id: "500408"
+post_author: 1
+"ListingKey": "29202545"
+"ListingId": "40791790"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-23T21:40:36Z"
+"RFModificationTimestamp": "2025-12-23T21:43:58Z"
+"ListPrice": 998999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.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.765194
1 => 43.204143
]
+"Latitude": 43.204143
+"Longitude": -79.765194
+"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"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"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": "2025-12-23T20:23:22.633380+00:00"
+"Directions": "Green Mountain and Upper Centennial"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"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": "2025-12-23T21:30:11Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-23T21:30:10Z"
+"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:13 [
0 => array:11 [
"RoomKey" => "1553233589"
"RoomType" => "3pc Bathroom"
"ListingId" => "40791790"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.79Z"
]
1 => array:11 [
"RoomKey" => "1553233590"
"RoomType" => "Dining room"
"ListingId" => "40791790"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 16'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.79Z"
]
2 => array:11 [
"RoomKey" => "1553233591"
"RoomType" => "Bedroom"
"ListingId" => "40791790"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.8Z"
]
3 => array:11 [
"RoomKey" => "1553233592"
"RoomType" => "Bedroom"
"ListingId" => "40791790"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.81Z"
]
4 => array:11 [
"RoomKey" => "1553233593"
"RoomType" => "Bedroom"
"ListingId" => "40791790"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.82Z"
]
5 => array:11 [
"RoomKey" => "1553233594"
"RoomType" => "Primary Bedroom"
"ListingId" => "40791790"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.83Z"
]
6 => array:11 [
"RoomKey" => "1553233595"
"RoomType" => "Laundry room"
"ListingId" => "40791790"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.84Z"
]
7 => array:11 [
"RoomKey" => "1553233596"
"RoomType" => "Loft"
"ListingId" => "40791790"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.85Z"
]
8 => array:11 [
"RoomKey" => "1553233597"
"RoomType" => "3pc Bathroom"
"ListingId" => "40791790"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.85Z"
]
9 => array:11 [
"RoomKey" => "1553233598"
"RoomType" => "2pc Bathroom"
"ListingId" => "40791790"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.86Z"
]
10 => array:11 [
"RoomKey" => "1553233599"
"RoomType" => "Great room"
"ListingId" => "40791790"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.87Z"
]
11 => array:11 [
"RoomKey" => "1553233600"
"RoomType" => "Kitchen"
"ListingId" => "40791790"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.88Z"
]
12 => array:11 [
"RoomKey" => "1553233601"
"RoomType" => "Den"
"ListingId" => "40791790"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29202545"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-12-23T21:30:10.89Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29202545/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": 0
+"AboveGradeFinishedArea": 2441
+"OriginalEntryTimestamp": "2025-12-23T19:39:10.8Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6381518584"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/b0f58af12a8204c2767c92e0023f762b.webp"
"MediaSize" => 113263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-b0f58af12a8204c2767c92e0023f762b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior featuring concrete driveway and a garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T19:39:10.81Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6381518593"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/6e7c2a56c8966374f8946567ae7f8889.webp"
"MediaSize" => 185547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-6e7c2a56c8966374f8946567ae7f8889.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of community / neighborhood sign"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T19:39:10.81Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6381518600"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/445e7872408cc731d64e1a8745bb5439.webp"
"MediaSize" => 123044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-445e7872408cc731d64e1a8745bb5439.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of home's exterior featuring stone siding, a yard, and a residential view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T19:39:10.81Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6381518607"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/295fc2c1372e6fa6d7bcbc64e92d8da1.webp"
"MediaSize" => 57166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-295fc2c1372e6fa6d7bcbc64e92d8da1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance foyer with baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T19:39:10.81Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6381550985"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/861dc1ab7f52296b8468698ecef136f2.webp"
"MediaSize" => 57850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-861dc1ab7f52296b8468698ecef136f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring recessed lighting and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.39Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6381551040"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/3462bb3b0acccaf9cc8575dfc81f6360.webp"
"MediaSize" => 56380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-3462bb3b0acccaf9cc8575dfc81f6360.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring dark wood-style flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.34Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6381551116"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/260a3dbcd0faaa89393b15803ba6d8c6.webp"
"MediaSize" => 67175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-260a3dbcd0faaa89393b15803ba6d8c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring dark wood-type flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.34Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6381547765"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/fb5c740e0c2bcca27c16d3e9f11f383a.webp"
"MediaSize" => 84231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-fb5c740e0c2bcca27c16d3e9f11f383a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring light wood-style floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:58.3Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6381551201"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/d6945c845ae2f6e406957fc266185c8b.webp"
"MediaSize" => 76381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-d6945c845ae2f6e406957fc266185c8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Mudroom featuring light wood-type flooring and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.4Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6381551266"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/6df1be8fb37e250fced13feb73f39b4c.webp"
"MediaSize" => 95461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-6df1be8fb37e250fced13feb73f39b4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a glass covered fireplace, wood finished floors, healthy amount of natural light, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.38Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6381551291"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/1278237dc7d0dbbabba513c500fff881.webp"
"MediaSize" => 78150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-1278237dc7d0dbbabba513c500fff881.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with stairway, hardwood / wood-style flooring, a chandelier, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.38Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6381551368"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/c69a02abac056d6d3c1c2ee44b7930e6.webp"
"MediaSize" => 87431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-c69a02abac056d6d3c1c2ee44b7930e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase featuring wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.39Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6381551406"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/33402c585b2749598e4ae801f9fd38df.webp"
"MediaSize" => 77794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-33402c585b2749598e4ae801f9fd38df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:58.55Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6381551455"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/9e3e28e2c1457d4b01403b25ae5d72c7.webp"
"MediaSize" => 61715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-9e3e28e2c1457d4b01403b25ae5d72c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with dark wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.38Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6381551491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/3a14b6ff240947262dc8f0d1f0ac6268.webp"
"MediaSize" => 54283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-3a14b6ff240947262dc8f0d1f0ac6268.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.49Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6381551520"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/dacae6f3f3a39d88c518f1c38b918edb.webp"
"MediaSize" => 82948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-dacae6f3f3a39d88c518f1c38b918edb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with wood finished floors and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.39Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6381551554"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/6d2b4a726bb552e033c78da66700ffd0.webp"
"MediaSize" => 80284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29202545/thumbnail-6d2b4a726bb552e033c78da66700ffd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring wood finished floors, healthy amount of natural light, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40791790"
"ResourceRecordKey" => "29202545"
"ModificationTimestamp" => "2025-12-23T20:40:59.39Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6381548168"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29202545/4c8f7f2c9949b95d560576113e18a2d8.webp"
"MediaSize" => 82348
"MediaType" => "webp"
…8
]
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]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29202545')"
+"ID": "500408"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24799
+post_id: "500293"
+post_author: 1
+"ListingKey": "29202410"
+"ListingId": "X12648140"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-23T22:01:12Z"
+"RFModificationTimestamp": "2025-12-23T22:05:45Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G4A7"
+"UnparsedAddress": "15 - 150 GATESHEAD CRESCENT, Hamilton (Stoney Creek), Ontario L8G4A7"
+"Coordinates": array:2 [
0 => -79.740933
1 => 43.220106
]
+"Latitude": 43.220106
+"Longitude": -79.740933
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 15-150 Gateshead Cres, SC. This spectacular, immaculate townhome is situated in one of the most convenient and desire-able locations in Stoney Creek. Featuring 3 bedrooms, 1.5 bathrooms, with a partially finished basement, making it a perfect home for first time buyers and down-sizers alike. On the main floor, you'll find newer modern white kitchen cupboards, countertops, stylish appliances, a large window over the sink, spacious living room with lot of natural light, dining room with access to fully fenced back yard, and convenient powder room. Beautiful staircase leading you up to the second level is sure to impress. The second floor contains 3 good sized bedrooms with laminate flooring and full bathroom. Elegant recreation room gives you plenty of space for every day entertainment and enjoyment. Parking is conveniently located on the back of townhome for easy access/parking. Pride of ownership is evident in this meticulously cared for home. You'll fall in love, the moment you walk in. This beautiful home checks off all necessary features and is located near schools, shopping, public transit, hwy access and all necessary amenities. Shows 10++. RSA. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Water Heater"
]
+"AssociationFee": "420"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Cable TV"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-23T19:45:05.170341+00:00"
+"Directions": "Cross Streets: Highway 8. ** Directions: Highway 8 - South on Gateshead Crescent."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1413922"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-23T18:43:33Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-23T21:45:50Z"
+"Stories": "2.0"
+"StreetName": "Gateshead"
+"StreetNumber": "150"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "2827.41"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/361046#Maps"
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29202410/15-150-gateshead-crescent-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2025-12-23T18:43:33.68Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29202410')"
+"ID": "500293"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24815
+post_id: "500294"
+post_author: 1
+"ListingKey": "29202024"
+"ListingId": "40794910"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-23T16:35:27Z"
+"RFModificationTimestamp": "2025-12-23T19:18:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.14
+"LivingArea": 1000.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E1P6"
+"UnparsedAddress": "249 FEDERAL Street Unit# LOWER, Stoney Creek, Ontario L8E1P6"
+"Coordinates": array:2 [
0 => -79.7350109
1 => 43.2230054
]
+"Latitude": 43.2230054
+"Longitude": -79.7350109
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Amazing Stoney Creek location in a family friendly neighbourhood. Within close proximity to all amenities including parks, schools, shopping and bus routes. Spacious two bedroom basement apartment with a private side entrance. Large eat-in kitchen measuring 21' X 13'10. Spacious Living Room with gas fireplace and walk-up into the garage (used for storage but no access for parking). Large rear yard to be shared with the main floor tenant. Tenants are responsible for 50% of utilities (gas, electricity, water, water heater). Double driveway to be shared with the main floor Tenant (one parking spot included). All Tenants are to provide Full Equifax or Trans Union Credit Reports, rental application, Employment & reference letters, income verification, and bank statements if needed. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-23T19:18:22.995722+00:00"
+"Directions": "Federal Street between Norwich Road and Green Road"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523812"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Corner Site"
]
+"LotSizeDimensions": "0.14"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-23T16:29:02Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-23T16:29:02Z"
+"Stories": "1.0"
+"StreetName": "FEDERAL"
+"StreetNumber": "249"
+"StreetSuffix": "Street"
+"SubdivisionName": "511 - Eastdale/Poplar Park/Industrial"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29202024/249-federal-street-unit-lower-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1999
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R6"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 61.0
+"AboveGradeFinishedArea": 0
+"BelowGradeFinishedArea": 1000
+"OriginalEntryTimestamp": "2025-12-23T16:29:02.63Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29202024')"
+"ID": "500294"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24880
+post_id: "498715"
+post_author: 1
+"ListingKey": "29200693"
+"ListingId": "40794756"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-23T01:40:33Z"
+"RFModificationTimestamp": "2025-12-23T01:43:51Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1558.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G4A7"
+"UnparsedAddress": "150 GATESHEAD Crescent Unit# 15, Stoney Creek, Ontario L8G4A7"
+"Coordinates": array:2 [
0 => -79.7414751
1 => 43.2213721
]
+"Latitude": 43.2213721
+"Longitude": -79.7414751
+"YearBuilt": 1976
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 15-150 Gateshead Cres, SC. This spectacular, immaculate townhome is situated in one of the most convenient and desire-able locations in Stoney Creek. Featuring 3 bedrooms, 1.5 bathrooms, with a partially finished basement, making it a perfect home for first time buyers and down-sizers alike. On the main floor, you’ll find newer modern white kitchen cupboards, countertops, stylish appliances, a large window over the sink, spacious living room with lot of natural light, dining room with access to fully fenced back yard, and convenient powder room. Beautiful staircase leading you up to the second level is sure to impress. The second floor contains 3 good sized bedrooms with laminate flooring and full bathroom. Elegant recreation room gives you plenty of space for every day entertainment and enjoyment. Parking is conveniently located on the back of townhome for easy access/parking. Pride of ownership is evident in this meticulously cared for home. You’ll fall in love, the moment you walk in. This beautiful home checks off all necessary features and is located near schools, shopping, public transit, hwy access and all necessary amenities. Book your apt today and be one of first to call this your home. Shows 10++. RSA. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "420"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Cable TV"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-22T19:37:48.819021+00:00"
+"Directions": "Highway 8 - South on Gateshead Crescent"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1563191"
+"ListOfficeKey": "262664"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2025-12-22T19:08:51Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-23T01:38:06Z"
+"Stories": "2.0"
+"StreetName": "GATESHEAD"
+"StreetNumber": "150"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "516 - Corman/South Meadow"
+"TaxAnnualAmount": "2827.41"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvt/361046"
+"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/29200693/150-gateshead-crescent-unit-15-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1244
+"BelowGradeFinishedArea": 314
+"OriginalEntryTimestamp": "2025-12-22T19:08:51Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29200693')"
+"ID": "498715"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24873
+post_id: "497312"
+post_author: 1
+"ListingKey": "28996297"
+"ListingId": "40777137"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-21T06:15:58Z"
+"RFModificationTimestamp": "2025-12-21T06:17:57Z"
+"ListPrice": 900000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1442.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8G1X4"
+"UnparsedAddress": "7 AVALON Avenue, Stoney Creek, Ontario L8G1X4"
+"Coordinates": array:2 [
0 => -79.758639
1 => 43.224055
]
+"Latitude": 43.224055
+"Longitude": -79.758639
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 7 Avalon Ave - where peace of mind meets polished design in the heart of Stoney Creek. Tucked at the end of a quiet, family-friendly cul-de-sac, this charming 3-bedroom, 2-bathroom bungalow sits on a generous lot with room to grow, play, or simply unwind. But what truly sets this home apart? It was professionally designed and renovated by the team from HGTV’s Holmes Family Rescue, with upgrades focused on safety, comfort, and long-term durability. Step inside and discover a bright, functional layout with thoughtful finishes and a lower level that’s been transformed into a stylish retreat - perfect for movie nights, remote work, or hosting guests. The 2022 renovation included a complete electrical overhaul with 200 amp service, advanced waterproofing using Schluter systems, a spa-inspired bathroom with heated floors and a brand-new laundry room featuring a steamer closet. Outside, the expansive backyard offers endless potential, while the dead-end street provides privacy and a true sense of community. Located in a sought-after neighbourhood close to parks, schools, and everyday amenities, with easy access to the QEW, Red Hill Parkway, and GO Transit. This is more than a home - it’s a professionally perfected haven ready for its next chapter. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-21T06:17:55.742613+00:00"
+"Directions": "Lake Avenue to Avalon Avenue"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2102891"
+"ListOfficeKey": "300660"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-10-22T23:21:59Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-21T06:00:43Z"
+"Stories": "1.0"
+"StreetName": "AVALON"
+"StreetNumber": "7"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"TaxAnnualAmount": "5020.22"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/7-Avalon-Ave"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/28996297/7-avalon-avenue-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1829328"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "284371"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1235
+"BelowGradeFinishedArea": 207
+"OriginalEntryTimestamp": "2025-10-16T16:09:53.58Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:5 [ …5]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28996297')"
+"ID": "497312"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24813
+post_id: "496581"
+post_author: 1
+"ListingKey": "29198075"
+"ListingId": "40794604"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-20T19:15:47Z"
+"RFModificationTimestamp": "2025-12-20T19:38:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0.154
+"LivingArea": 595.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E1L2"
+"UnparsedAddress": "41 LAKE Avenue Unit# Main, Stoney Creek, Ontario L8E1L2"
+"Coordinates": array:2 [
0 => -79.7550632
1 => 43.227281
]
+"Latitude": 43.227281
+"Longitude": -79.7550632
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this charming main floor unit at 41 Lake Avenue Drive in desirable Stoney Creek location! This 1-bedroom, 1-bath home features a bright living room with a bay window, an updated kitchen with modern finishes, and in-suite laundry for added convenience. Enjoy your own private deck and yard, perfect for relaxing outdoors or entertaining guests. The unit includes 2 parking spaces, a pantry closet, and a front foyer closet, providing plenty of storage. Located just minutes from downtown Stoney Creek, you’ll have easy access to shops, restaurants, parks, and transit. All utilities are included, making this a hassle-free and comfortable rental in a great location. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFeeIncludes": array:4 [
0 => "Cable TV"
1 => "Heat"
2 => "Electricity"
3 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2025-12-20T19:33:08.708185+00:00"
+"Directions": "Highway 8 to Lake Avenue Drive (BETWEEN KING & QUEENSTON), corner of Randall Drive & Lake"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524896"
+"ListOfficeKey": "55053"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Crushed stone driveway"
]
+"LotSizeDimensions": "0.154"
+"PhotosChangeTimestamp": "2025-12-20T19:08:40Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-20T19:08:40Z"
+"Stories": "1.0"
+"StreetName": "LAKE"
+"StreetNumber": "41"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "515 - Battlefield"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29198075/41-lake-avenue-unit-main-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"TotalActualRent": 1650
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 595
+"OriginalEntryTimestamp": "2025-12-20T19:08:39.94Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:22 [
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]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29198075')"
+"ID": "496581"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "494015"
+post_author: 1
+"ListingKey": "29197259"
+"ListingId": "X12643988"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T22:55:25Z"
+"RFModificationTimestamp": "2025-12-20T00:58:01Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J0K9"
+"UnparsedAddress": "22 - 35 MIDHURST HEIGHTS, Hamilton (Stoney Creek Mountain), Ontario L8J0K9"
+"Coordinates": array:2 [
0 => -79.766094
1 => 43.205614
]
+"Latitude": 43.205614
+"Longitude": -79.766094
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "The Ultimate Luxury EXECUTIVE townhouse CORNER Unit (like SEMI) in Stoney Creek by Losani Homes! Welcome to the most coveted floor plan and view in the community! This CORNER UNIT (like a SEMI) with 3 bedrooms, 4baths,HARDWOOD FLOORS all through out, CALIFORNIA Shutters windows all through out, family room in the second floor combines complete privacy with breathtaking, unobstructed views and a serene, private backyard. Step inside and be greeted by a wine cellar to envy, wall-to-wall floor-to-ceiling windows that bathe the open-concept living space in natural light. The chef-inspired kitchen features premium stainless steel appliances, QUARTZ countertops, ample storage, and custom upgrades designed for both style and functionality. The living area exudes warmth and sophistication, anchored by modern fireplace, an elegant feature wall, and designer details throughout. With hardwood floors, soaring 9-FOOT ceilings, pot lights, CALIFORNIA shutters, and SMART HOME technology, every inch reflects luxury living. A striking floating staircase adds an architectural statement. The second floor welcomes you with a bright family room that walks out to the terrace. The master bedroom is elegantly designed for warmth and comfort with walk-in closet and quartz counter 4 piece bathroom. The 2 bedrooms boast light through out. The crown jewel? A private rooftop terrace with sweeping panoramic views-perfect for unforgettable starlit gatherings or tranquil morning coffee moments. The finished basement with a full bathroom offers endless possibilities for a guest suite, home office, or media room. This home doesn't just check boxes-it sets a new standard for modern elegance. Extras: All ELFs, Built-in Microwave with Range Hood, Built-in Dishwasher, Washer & Dryer, Garage Remote, Fridge (purchased 2022), CALIFORNIA SHUTTERS window coverings, EV Charger. (id:62650)"
+"Appliances": array:4 [
0 => "Water meter"
1 => "Range"
2 => "Oven - Built-In"
3 => "Garage door opener remote(s)"
]
+"AssociationFee": "411.66"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-20T00:57:52.127445+00:00"
+"Directions": "Bedrock Dr & Bradshaw Dr"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2061147"
+"ListOfficeKey": "275784"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Conservation/green belt"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-19T22:47:11Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T22:47:11Z"
+"Stories": "2.0"
+"StreetName": "Midhurst"
+"StreetNumber": "35"
+"StreetSuffix": "Heights"
+"TaxAnnualAmount": "6103.23"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://tours.vision360tours.ca/35-midhurst-heights-unit-22-stoney-creek/"
+"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/29197259/22-35-midhurst-heights-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "TAG Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Fireplace(s)"
2 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2025-12-19T22:47:11.09Z"
+"MapCoordinateVerifiedYN": false
+"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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29197259')"
+"ID": "494015"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24864
+post_id: "491128"
+post_author: 1
+"ListingKey": "29196585"
+"ListingId": "X12643302"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-19T18:55:24Z"
+"RFModificationTimestamp": "2025-12-19T19:44:24Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8G1T8"
+"UnparsedAddress": "23 BATTLEFIELD DRIVE, Hamilton (Stoney Creek), Ontario L8G1T8"
+"Coordinates": array:2 [
0 => -79.765534
1 => 43.2160889
]
+"Latitude": 43.2160889
+"Longitude": -79.765534
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fixer-Upper Opportunity in Charming Old Stoney Creek. Located in a great neighbourhood, this 3+1 bedroom bungalow sits on a generous 60 x 100 ft lot, offering plenty of space and potential. This property provides both privacy and a rare opportunity to create your ideal home. The main level features hardwood flooring, classic shutters, living room with large beautiful bay window, dining room, eat-in kitchen and a walkout to a deck overlooking the spacious backyard. A separate entrance leads to the finished lower level, complete with an additional bedroom and large rec room - perfect for in-law potential, extended family, or a future income suite. With solid bones and a functional layout, this home is ready for your vision and updates. Whether you're an investor, first-time buyer, or someone looking to customize a home, this property has endless possibilities. Conveniently located close to parks, schools, shopping, and easy highway access, this bungalow blends potential with location. Don't miss your chance to make it your own in one of Stoney Creek's most established neighbourhoods. (id:62650)"
+"Appliances": array:2 [
0 => "All"
1 => "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": "2025-12-19T19:44:14.442402+00:00"
+"Directions": "Cross Streets: King Street West. ** Directions: Centennial Pkwy North- King St. W - Battlefield Drive."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2022178"
+"ListOfficeKey": "283372"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "60 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-19T18:48:21Z"
+"PhotosCount": 1
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-19T18:48:21Z"
+"Stories": "1.0"
+"StreetName": "Battlefield"
+"StreetNumber": "23"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4942.8"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29196585/23-battlefield-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2025-12-19T18:48:21.51Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:1 [
0 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29196585')"
+"ID": "491128"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24804
+post_id: "490751"
+post_author: 1
+"ListingKey": "29196345"
+"ListingId": "X12643016"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-20T20:30:19Z"
+"RFModificationTimestamp": "2025-12-20T20:31:29Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Riverdale)"
+"PostalCode": "L8E1E1"
+"UnparsedAddress": "64 GAINSBOROUGH ROAD, Hamilton (Riverdale), Ontario L8E1E1"
+"Coordinates": array:2 [
0 => -79.7601248
1 => 43.2312525
]
+"Latitude": 43.2312525
+"Longitude": -79.7601248
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Portion of Lease: Main Floor.This tastefully updated semi-detached bungalow showcases a modern, carpet-free layout designed for comfortable living. Stylish laminate flooring runs throughout the bright, open-concept living and dining spaces, enhanced by a large window and contemporary pot lighting. The well-appointed kitchen features quartz countertops, a tiled backsplash, stainless steel appliances, and plenty of cabinetry, making it both functional and inviting for everyday cooking or entertaining.The home offers three spacious bedrooms along with two beautifully renovated bathrooms, complete with modern finishes and elegant tile accents.Step outside to a fully fenced backyard, perfect for unwinding or enjoying outdoor gatherings during the warmer months.Additional conveniences include a large concrete driveway providing ample parking and a prime location close to shopping, major highways, parks, and schools. (id:62650)"
+"Appliances": array:1 [
0 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Separate entrance"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-19T19:03:04.065337+00:00"
+"Directions": "Centennial Pkwy/Delawana Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2151987"
+"ListOfficeKey": "280225"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "30 x 118 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-20T20:19:46Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-20T20:19:46Z"
+"Stories": "1.0"
+"StreetName": "Gainsborough"
+"StreetNumber": "64"
+"StreetSuffix": "Road"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"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": "Toronto"
+"CityRegion": "Riverdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29196345/64-gainsborough-road-hamilton-riverdale-riverdale"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2550
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2025-12-19T17:48:53.6Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:45 [
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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29196345')"
+"ID": "490751"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 150
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]