array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30060200 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23528
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23530
+post_id: "1644847"
+post_author: 1
+"ListingKey": "30060200"
+"ListingId": "X13588188"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T00:10:04Z"
+"RFModificationTimestamp": "2026-07-23T00:20:33Z"
+"ListPrice": 619000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "15 - 590 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.6976368
1 => 43.2342295
]
+"Latitude": 43.2342295
+"Longitude": -79.6976368
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To This Beautifully Maintained 2-Bedroom, 3-Bathroom Condo Townhome OfferingApproximately 1,300 Sq. Ft. Of Stylish, Carpet-Free Living In The Highly Sought-After FiftyPoint Waterfront Community. The Bright, Open-Concept Main Floor Features A Modern Kitchen WithQuartz Countertops, Stainless Steel Appliances, Ample Cabinetry And A Breakfast Bar, FlowingSeamlessly Into The Spacious Living And Dining Areas. Enjoy Two Open Balconies On The East AndWest Sides-Perfect For Taking In Both The Sunrise And Sunset and enjoying BBQs. Upstairs Offers A GenerousPrimary Suite With A Walk-In Closet And Private Ensuite, A Spacious Second Bedroom, A FullBathroom And Convenient Upper-Level Laundry. Complete With An Attached Garage And PrivateDriveway. Walking Distance To The Lake Ontario Waterfront, Scenic Trails And Marina, With A Children's Playground Conveniently Located Across The Street. Minutes To Costco, Shopping,Restaurants, The QEW And Future Confederation GO Station. Move-In Ready And Perfect For First-Time Buyers, Professionals, Downsizers Or Investors! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Window Coverings"
]
+"AssociationFee": "411.5"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T16:03:19.666817+00:00"
+"Directions": "Cross Streets: Lakeview/North Service Rd. ** Directions: Lakeview To North Service Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1669786"
+"ListOfficeKey": "256963"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T15:40:07Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T00:03:20Z"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3245.55"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1691298411"
"RoomType" => "Dining room"
"ListingId" => "X13588188"
"RoomLevel" => "Second level"
"RoomWidth" => 3.96
"ListingKey" => "30060200"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T00:03:20.54Z"
]
1 => array:11 [
"RoomKey" => "1691298412"
"RoomType" => "Bathroom"
"ListingId" => "X13588188"
"RoomLevel" => "Second level"
"RoomWidth" => 1.0
"ListingKey" => "30060200"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T00:03:20.54Z"
]
2 => array:11 [
"RoomKey" => "1691298413"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13588188"
"RoomLevel" => "Third level"
"RoomWidth" => 3.66
"ListingKey" => "30060200"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T00:03:20.54Z"
]
3 => array:11 [
"RoomKey" => "1691298414"
"RoomType" => "Bedroom"
"ListingId" => "X13588188"
"RoomLevel" => "Third level"
"RoomWidth" => 2.74
"ListingKey" => "30060200"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T00:03:20.54Z"
]
4 => array:11 [
"RoomKey" => "1691298415"
"RoomType" => "Bathroom"
"ListingId" => "X13588188"
"RoomLevel" => "Third level"
"RoomWidth" => 1.0
"ListingKey" => "30060200"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T00:03:20.55Z"
]
5 => array:11 [
"RoomKey" => "1691298416"
"RoomType" => "Bathroom"
"ListingId" => "X13588188"
"RoomLevel" => "Third level"
"RoomWidth" => 1.0
"ListingKey" => "30060200"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T00:03:20.55Z"
]
6 => array:11 [
"RoomKey" => "1691298417"
"RoomType" => "Kitchen"
"ListingId" => "X13588188"
"RoomLevel" => "Second level"
"RoomWidth" => 2.74
"ListingKey" => "30060200"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T00:03:20.55Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30060200/15-590-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Properties Limited"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-21T15:40:07.41Z"
+"ListAgentNationalAssociationId": "1170063"
+"ListOfficeNationalAssociationId": "1237568"
+"Media": array:23 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30060200_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/ed0bc7e9cac6175a807863079ced3dc2.webp"
"MediaSize" => 316079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-ed0bc7e9cac6175a807863079ced3dc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30060200_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/86bc20914940875b424cb34f28197b60.webp"
"MediaSize" => 119364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-86bc20914940875b424cb34f28197b60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30060200_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/c1fa883089d0f965972a04bed735f794.webp"
"MediaSize" => 28767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-c1fa883089d0f965972a04bed735f794.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30060200_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/d90927d2761861a2b45c7442abdcd8c2.webp"
"MediaSize" => 157468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-d90927d2761861a2b45c7442abdcd8c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30060200_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/fa39c3df5adb5814b5a19e0277396c4d.webp"
"MediaSize" => 170936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-fa39c3df5adb5814b5a19e0277396c4d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30060200_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/9bb319b7eba2986aeb818d4a12ee2ca3.webp"
"MediaSize" => 130225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-9bb319b7eba2986aeb818d4a12ee2ca3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30060200_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/27022eecc72a10091063bf208b7c3269.webp"
"MediaSize" => 115175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-27022eecc72a10091063bf208b7c3269.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30060200_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/56813a09362b39975f06bf7a4349c60f.webp"
"MediaSize" => 148671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-56813a09362b39975f06bf7a4349c60f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30060200_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/c3e1487ef726e2e3a34c2ad43b57dd20.webp"
"MediaSize" => 133992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-c3e1487ef726e2e3a34c2ad43b57dd20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30060200_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/fe1375ea5fad700ef26833a0ea27f630.webp"
"MediaSize" => 153590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-fe1375ea5fad700ef26833a0ea27f630.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30060200_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/9f0fce6af2f7f5e0904da93db91be5fe.webp"
"MediaSize" => 82237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-9f0fce6af2f7f5e0904da93db91be5fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30060200_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/d48505ca3f449749eb9e43a17f5ff587.webp"
"MediaSize" => 141196
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-d48505ca3f449749eb9e43a17f5ff587.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30060200_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/167b88c61cc391794fdc7ae2f6ded9ea.webp"
"MediaSize" => 144195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-167b88c61cc391794fdc7ae2f6ded9ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30060200_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/81e4631db6a54b75f5f4949901894ba4.webp"
"MediaSize" => 149978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-81e4631db6a54b75f5f4949901894ba4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30060200_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/4a8327e93b2ca1260241aa1ae350ce82.webp"
"MediaSize" => 147489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-4a8327e93b2ca1260241aa1ae350ce82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30060200_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/fb9f000c4b7f070c1bd18f52c598d6a5.webp"
"MediaSize" => 124957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-fb9f000c4b7f070c1bd18f52c598d6a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30060200_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/b1361dab811fae9116eacd9cf8d4b4d6.webp"
"MediaSize" => 111035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-b1361dab811fae9116eacd9cf8d4b4d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30060200_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/57f91956c6ca6cfbd265eb26318c9436.webp"
"MediaSize" => 128702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-57f91956c6ca6cfbd265eb26318c9436.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30060200_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/73b90a2529a189eae68e0875ac5b0421.webp"
"MediaSize" => 72746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-73b90a2529a189eae68e0875ac5b0421.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30060200_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/0bff7e33ce013eb35c0c7778de086f53.webp"
"MediaSize" => 233264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-0bff7e33ce013eb35c0c7778de086f53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30060200_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/f042416473267273e8bb9d08d62ddf24.webp"
"MediaSize" => 60308
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-f042416473267273e8bb9d08d62ddf24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30060200_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/13d6699bc0137bb29fb5b46e1f306506.webp"
"MediaSize" => 19804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-13d6699bc0137bb29fb5b46e1f306506.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30060200_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060200/0557a09b93f0e2bf52e34fb248fab4bc.webp"
"MediaSize" => 231184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060200/thumbnail-0557a09b93f0e2bf52e34fb248fab4bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13588188"
"ResourceRecordKey" => "30060200"
"ModificationTimestamp" => "2026-07-21T15:40:07.42Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30060200')"
+"ID": "1644847"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Cache Key: 7aa93f212304d7a5fa5b031cc177c4ac043c9c0baafbef77f8643cc1f9fdf147" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24681
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25011
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RIGHT AT HOME REALTY"
+"OfficeEmail": null
+"OfficePhone": "905-695-7888"
+"OfficeMlsId": "62207"
+"ModificationTimestamp": "2026-07-20T22:40:50Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "256963"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1550 16TH AVENUE BLDG B UNIT 3 & 4"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "RICHMOND HILL"
+"OfficePostalCode": "L4B3K"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1237568"
+"OriginalEntryTimestamp": "2010-08-07T03:21:00Z"
+"OfficeFax": "905-695-0900"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeBrokerNationalAssociationId": "1312984"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('256963')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1669786" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24927
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30060200'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25300
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30060200' AND OpenHouseDate ge '2026-07-23'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30060200' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6976368 43.2342295)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25369
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+post_id: "1654471"
+post_author: 1
+"ListingKey": "30072417"
+"ListingId": "40849414"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T02:30:01Z"
+"RFModificationTimestamp": "2026-07-24T02:40:54Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.13
+"LivingArea": 2297.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E4S4"
+"UnparsedAddress": "2 CRESTHAVEN Drive, Stoney Creek, Ontario L8E4S4"
+"Coordinates": array:2 [
0 => -79.7111735
1 => 43.2197412
]
+"Latitude": 43.2197412
+"Longitude": -79.7111735
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 2 Cresthaven Drive in Stoney Creek, a spacious 2-storey home situated on a desirable corner lot in a family-friendly neighbourhood. Offering 4 bedrooms and 4 bathrooms, this well-maintained home provides an ideal layout for growing families and those who love to entertain.The main floor features updated kitchen cabinetry and sliding patio doors leading to the backyard, making outdoor dining and entertaining a breeze. The large dining room is perfect for family gatherings and flows seamlessly into the living room, while the cozy family room is highlighted by a gas fireplace and a walkout to the backyard. Also on the main level is a convenient 3-piece bathroom, along with a laundry room that offers access to the double-car garage and a separate door to the side yard, adding to the home's everyday functionality. Upstairs, you'll find four generously sized bedrooms, including a spacious primary suite complete with a private 4-piece ensuite. A second 4-piece bathroom serves the remaining bedrooms, providing plenty of space for the whole family. The finished basement expands the living space with a large ceramic tiled recreation room, a second kitchen that's ideal for entertaining, a 2-piece bathroom, and a generous storage area. Conveniently located close to schools, parks, shopping, restaurants, public transit, and all major amenities, this fantastic corner-lot home offers the perfect combination of space, comfort, and convenience. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T23:20:09.169538+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1950516"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Corner Site"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.13"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T02:20:44Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T02:29:28Z"
+"Stories": "2.0"
+"StreetName": "CRESTHAVEN"
+"StreetNumber": "2"
+"StreetSuffix": "Drive"
+"SubdivisionName": "512 - Guernsey/Westmeria/Industrial"
+"TaxAnnualAmount": "6560.38"
+"VirtualTourURLUnbranded": "https://youtu.be/3qdQfshnsLA"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
0 => array:11 [
"RoomKey" => "1692188762"
"RoomType" => "2pc Bathroom"
"ListingId" => "40849414"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 5'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
1 => array:11 [
"RoomKey" => "1692188763"
"RoomType" => "Storage"
"ListingId" => "40849414"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
2 => array:11 [
"RoomKey" => "1692188764"
"RoomType" => "Cold room"
"ListingId" => "40849414"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
3 => array:11 [
"RoomKey" => "1692188765"
"RoomType" => "Utility room"
"ListingId" => "40849414"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
4 => array:11 [
"RoomKey" => "1692188766"
"RoomType" => "Eat in kitchen"
"ListingId" => "40849414"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
5 => array:11 [
"RoomKey" => "1692188767"
"RoomType" => "Recreation room"
"ListingId" => "40849414"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "27'7'' x 20'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
6 => array:11 [
"RoomKey" => "1692188768"
"RoomType" => "Bedroom"
"ListingId" => "40849414"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
7 => array:11 [
"RoomKey" => "1692188769"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849414"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
8 => array:11 [
"RoomKey" => "1692188770"
"RoomType" => "Bedroom"
"ListingId" => "40849414"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "13'3'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
9 => array:11 [
"RoomKey" => "1692188771"
"RoomType" => "Bedroom"
"ListingId" => "40849414"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
10 => array:11 [
"RoomKey" => "1692188772"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849414"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
11 => array:11 [
"RoomKey" => "1692188773"
"RoomType" => "Primary Bedroom"
"ListingId" => "40849414"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "16'0'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
12 => array:11 [
"RoomKey" => "1692188774"
"RoomType" => "Laundry room"
"ListingId" => "40849414"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
13 => array:11 [
"RoomKey" => "1692188775"
"RoomType" => "3pc Bathroom"
"ListingId" => "40849414"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.82Z"
]
14 => array:11 [
"RoomKey" => "1692188776"
"RoomType" => "Family room"
"ListingId" => "40849414"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "17'11'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.83Z"
]
15 => array:11 [
"RoomKey" => "1692188777"
"RoomType" => "Breakfast"
"ListingId" => "40849414"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.83Z"
]
16 => array:11 [
"RoomKey" => "1692188778"
"RoomType" => "Kitchen"
"ListingId" => "40849414"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.83Z"
]
17 => array:11 [
"RoomKey" => "1692188779"
"RoomType" => "Dining room"
"ListingId" => "40849414"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.83Z"
]
18 => array:11 [
"RoomKey" => "1692188780"
"RoomType" => "Living room"
"ListingId" => "40849414"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.83Z"
]
19 => array:11 [
"RoomKey" => "1692188781"
"RoomType" => "Foyer"
"ListingId" => "40849414"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30072417"
"RoomLength" => null
"RoomDimensions" => "21'8'' x 9'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-24T02:29:28.83Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30072417/2-cresthaven-drive-stoney-creek"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2192777"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 71.0
+"AboveGradeFinishedArea": 2297
+"OriginalEntryTimestamp": "2026-07-23T20:08:21.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1244653"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1441716"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30072417_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/24bd8e5df7673397cddc3fc31f0463dd.webp"
"MediaSize" => 150863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-24bd8e5df7673397cddc3fc31f0463dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30072417_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/4d091a74fd29d013c71ca2f105908b59.webp"
"MediaSize" => 119290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-4d091a74fd29d013c71ca2f105908b59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30072417_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/4a3dbfe6faca2961dfe08ce6b71c44e9.webp"
"MediaSize" => 166576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-4a3dbfe6faca2961dfe08ce6b71c44e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30072417_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/06cbef6ad7cb70d5cf83dd352498e524.webp"
"MediaSize" => 68919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-06cbef6ad7cb70d5cf83dd352498e524.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30072417_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/c213662a09458db318be159d007f4bdf.webp"
"MediaSize" => 65209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-c213662a09458db318be159d007f4bdf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30072417_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/967558461b980bd5e8bbd9a0ab6c8908.webp"
"MediaSize" => 110010
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-967558461b980bd5e8bbd9a0ab6c8908.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30072417_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/92ca6a2397e0eabc3a06792be698950c.webp"
"MediaSize" => 99956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-92ca6a2397e0eabc3a06792be698950c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30072417_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/5b5f6647afc5d8f2bcb906d64bd55a3c.webp"
"MediaSize" => 71663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-5b5f6647afc5d8f2bcb906d64bd55a3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30072417_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/8d231eedcf9a9e1784aa37bd6d9e01e3.webp"
"MediaSize" => 92208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-8d231eedcf9a9e1784aa37bd6d9e01e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30072417_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/fe6c0a70ee7a2882483e15318e31001a.webp"
"MediaSize" => 81804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-fe6c0a70ee7a2882483e15318e31001a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30072417_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/11dbfce693ebdf90e6278c051df95915.webp"
"MediaSize" => 89558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-11dbfce693ebdf90e6278c051df95915.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30072417_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/ce20abc18194c4a6e3a121c3a3558728.webp"
"MediaSize" => 82621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-ce20abc18194c4a6e3a121c3a3558728.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30072417_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/b54bc473922a7ac2c46ea2221d91f408.webp"
"MediaSize" => 75368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-b54bc473922a7ac2c46ea2221d91f408.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30072417_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/239ead0571bd6cd2fea015979de2f5cd.webp"
"MediaSize" => 64718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-239ead0571bd6cd2fea015979de2f5cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30072417_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/b5b2628c583455a1c6008883c4a5e2f9.webp"
"MediaSize" => 52936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-b5b2628c583455a1c6008883c4a5e2f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30072417_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/97b60c76cae6804789562a78940be72e.webp"
"MediaSize" => 75902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-97b60c76cae6804789562a78940be72e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30072417_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/00fec4e45e22ef21edccb54ece99911e.webp"
"MediaSize" => 81847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-00fec4e45e22ef21edccb54ece99911e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30072417_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/057de11a002b33137eadf4656daecca3.webp"
"MediaSize" => 69787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-057de11a002b33137eadf4656daecca3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30072417_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/f7c972d5712730cf757f062f81bb62cf.webp"
"MediaSize" => 43978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-f7c972d5712730cf757f062f81bb62cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30072417_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/61ab4a858ebeb98b8022b7cb3a751f94.webp"
"MediaSize" => 81615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-61ab4a858ebeb98b8022b7cb3a751f94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30072417_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/119af7c1b6b729381dc8340d911b7527.webp"
"MediaSize" => 72973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-119af7c1b6b729381dc8340d911b7527.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30072417_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/e7184371c16ad33fced589a3b6901eb7.webp"
"MediaSize" => 74048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-e7184371c16ad33fced589a3b6901eb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30072417_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/e0e07beec9fc61dc983d00614a207816.webp"
"MediaSize" => 46436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-e0e07beec9fc61dc983d00614a207816.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30072417_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/c67385549d0abc24a6c45fbe99c66e9b.webp"
"MediaSize" => 79829
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-c67385549d0abc24a6c45fbe99c66e9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30072417_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/9ff7eb26ede4ec3c9caa79a568789bf1.webp"
"MediaSize" => 51924
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-9ff7eb26ede4ec3c9caa79a568789bf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30072417_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072417/46b75d8247afeefe21874e30bbef4fa4.webp"
"MediaSize" => 65130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072417/thumbnail-46b75d8247afeefe21874e30bbef4fa4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849414"
"ResourceRecordKey" => "30072417"
"ModificationTimestamp" => "2026-07-23T20:08:21.21Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30072417_4890_27"
…11
]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072417')"
+"ID": "1654471"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25365
+post_id: "1654473"
+post_author: 1
+"ListingKey": "30072617"
+"ListingId": "X13599574"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:45:06Z"
+"RFModificationTimestamp": "2026-07-23T23:08:40Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "590 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.697576
1 => 43.233855
]
+"Latitude": 43.233855
+"Longitude": -79.697576
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 50 at 590 North Service Road in Stoney Creek, a beautifully maintained and affordable home built in 2020, offering modern living in one of the city's most convenient and rapidly growing communities. Whether you're a first time buyer, young professional, downsizer, or investor, this home delivers the perfect combination of style, comfort, and location.Nestled in a prime Stoney Creek setting, this property offers stunning escarpment views and is located just moments from the lake, giving you the best of both natural beauty and urban convenience. Enjoy easy access to waterfront parks, walking and biking trails, local beaches, and scenic outdoor spaces while still being close to everything you need for day to day living.Inside, you'll find a modern layout designed for today's lifestyle with bright living spaces, contemporary finishes, and a welcoming atmosphere throughout. Built in 2020, this newer home provides peace of mind with updated construction, energy efficiency, and low maintenance living.The location is truly unbeatable. Situated near the popular Costco Plaza, you are just minutes away from shopping, restaurants, cafes, fitness centres, and everyday amenities. Commuters will appreciate the quick access to the QEW, Red Hill Valley Parkway, and major routes connecting you to Hamilton, Niagara, and the GTA.Offering incredible value in an exceptional location, Unit 50 at 590 North Service Road is your opportunity to enjoy modern living surrounded by convenience, nature, and breathtaking escarpment scenery. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T23:08:31.364952+00:00"
+"Directions": "Cross Streets: Lakeview Drive. ** Directions: QEW exit Fruitland Rd, left onto Lakeview Dr, continue onto N. Service Rd, left into complex, property on outer perimeter facing highway."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.4 x 41.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T20:39:57Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T20:39:57Z"
+"Stories": "3.0"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4098.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30072617/590-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 20.4
+"OriginalEntryTimestamp": "2026-07-23T20:39:57.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072617')"
+"ID": "1654473"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+post_id: "1654472"
+post_author: 1
+"ListingKey": "30072625"
+"ListingId": "X13599684"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:45:06Z"
+"RFModificationTimestamp": "2026-07-23T23:08:02Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E4S4"
+"UnparsedAddress": "2 CRESTHAVEN DRIVE, Hamilton (Stoney Creek), Ontario L8E4S4"
+"Coordinates": array:2 [
0 => -79.711152
1 => 43.219727
]
+"Latitude": 43.219727
+"Longitude": -79.711152
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 2 Cresthaven Drive in Stoney Creek, a spacious 2-storey home situated on a desirable corner lot in a family-friendly neighbourhood. Offering 4 bedrooms and 4 bathrooms, this well-maintained home provides an ideal layout for growing families and those who love to entertain.The main floor features updated kitchen cabinetry and sliding patio doors leading to the backyard, making outdoor dining and entertaining a breeze. The large dining room is perfect for family gatherings and flows seamlessly into the living room, while the cozy family room is highlighted by a gas fireplace and a walkout to the backyard. Also on the main level is a convenient 3-piece bathroom, along with a laundry room that offers access to the double-car garage and a separate door to the side yard, adding to the home's everyday functionality. Upstairs, you'll find four generously sized bedrooms, including a spacious primary suite complete with a private 4-piece ensuite. A second 4-piece bathroom serves the remaining bedrooms, providing plenty of space for the whole family. The finished basement expands the living space with a large ceramic tiled recreation room, a second kitchen that's ideal for entertaining, a 2-piece bathroom, and a generous storage area. Conveniently located close to schools, parks, shopping, restaurants, public transit, and all major amenities, this fantastic corner-lot home offers the perfect combination of space, comfort, and convenience. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Freezer"
3 => "Two stoves"
4 => "Garage door opener"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T23:07:51.324447+00:00"
+"Directions": "Cross Streets: Dewitt Rd. ** Directions: Dewitt/Cresthaven Dr."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060730"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "70.7 x 100.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T20:39:58Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T20:39:58Z"
+"Stories": "2.0"
+"StreetName": "Cresthaven"
+"StreetNumber": "2"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6560.38"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30072625/2-cresthaven-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 70.8
+"OriginalEntryTimestamp": "2026-07-23T20:39:58.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1335888"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072625')"
+"ID": "1654472"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1653701"
+post_author: 1
+"ListingKey": "30073041"
+"ListingId": "X13600044"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T21:50:05Z"
+"RFModificationTimestamp": "2026-07-23T22:01:55Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0C3"
+"UnparsedAddress": "165 PALACEBEACH TRAIL, Hamilton (Lakeshore), Ontario L8E0C3"
+"Coordinates": array:2 [
0 => -79.676263
1 => 43.22838
]
+"Latitude": 43.22838
+"Longitude": -79.676263
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautiful two-storey home in the sought-after community of Stoney Creek-just a short drive to the beach! This 3-bedroom home offers a bright, open-concept layout with 9 ft ceilings, hardwood floors, tile, and a cozy gas fireplace. The spacious kitchen features rich wood cabinetry, stainless steel dishwasher, refrigerator, and stove, and opens to a fully fenced backyard with stamped concrete, a handy storage shed, and an irrigation system-perfect for relaxing or entertaining. Enjoy the convenience of inside access from the attached garage and a 2-pc powder room just a few steps down from the main level. The family room is also wired with a built-in music system and speakers, adding to the home's comfort and charm. Upstairs, you'll find three generously sized bedrooms, a charming loft space ideal for a home office or reading nook, and a 4-pc main bath. The primary suite boasts a large walk-in closet and a luxurious ensuite with a soaker tub and separate shower. The basement is framed and ready for your finishing touches, with potential for a 4th bedroom, rec room, and a roughed-in bathroom. Laundry is also located on the lower level. This home has great curb appeal, a new roof, and is located close to Costco, shops, restaurants, and offers quick access to the QEW. Don't miss this fantastic opportunity in a prime location (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T22:01:46.381718+00:00"
+"Directions": "Cross Streets: North Service Rd., North on Watercrest drive, South on Palacebeach Trail. ** Directions: Service Rd., Glover Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2170778"
+"ListOfficeKey": "279779"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.1 x 85.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T21:40:58Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T21:40:58Z"
+"Stories": "2.0"
+"StreetName": "Palacebeach"
+"StreetNumber": "165"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "5200.2"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30073041/165-palacebeach-trail-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.1
+"OriginalEntryTimestamp": "2026-07-23T21:40:58.41Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1421414"
+"ListOfficeNationalAssociationId": "1309078"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30073041')"
+"ID": "1653701"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
+post_id: "1652862"
+post_author: 1
+"ListingKey": "30072345"
+"ListingId": "40850466"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:05:19Z"
+"RFModificationTimestamp": "2026-07-23T20:17:06Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1169.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "590 NORTH SERVICE Road Unit# 50, Stoney Creek, Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.6970371
1 => 43.2332173
]
+"Latitude": 43.2332173
+"Longitude": -79.6970371
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 50 at 590 North Service Road in Stoney Creek, a beautifully maintained and affordable home built in 2020, offering modern living in one of the city's most convenient and rapidly growing communities. Whether you're a first time buyer, young professional, downsizer, or investor, this home delivers the perfect combination of style, comfort, and location. Nestled in a prime Stoney Creek setting, this property offers stunning escarpment views and is located just moments from the lake, giving you the best of both natural beauty and urban convenience. Enjoy easy access to waterfront parks, walking and biking trails, local beaches, and scenic outdoor spaces while still being close to everything you need for day to day living. Inside, you’ll find a modern layout designed for today’s lifestyle with bright living spaces, contemporary finishes, and a welcoming atmosphere throughout. Built in 2020, this newer home provides peace of mind delivers the perfect combination of style, comfort, and location. Nestled in a prime Stoney Creek setting, this with updated construction, energy efficiency, and low maintenance living. The location is truly unbeatable. Situated near the popular Costco Plaza, you are just minutes away from shopping, restaurants, cafes, fitness centres, and everyday amenities. Commuters will appreciate the quick access to the QEW, Red Hill Valley Parkway, and major routes connecting you to Hamilton, Niagara, and the GTA. Offering incredible value in an exceptional location, Unit 50 at 590 North Service Road is your opportunity to enjoy modern living surrounded by convenience, nature, and breathtaking escarpment scenery. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "117"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T20:17:01.549035+00:00"
+"Directions": "QEW Exit Fruitland, Left Onto Lakeview Dr, Continue Onto North Service Rd, Left Into Complex, Property On Outer Perimeter Facing Highway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T19:59:37Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T19:59:37Z"
+"Stories": "3.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4098.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30072345/590-north-service-road-unit-50-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2208479"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299867"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1169
+"OriginalEntryTimestamp": "2026-07-23T19:59:37.73Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1454953"
+"CoListOfficeNationalAssociationId": "1477945"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072345')"
+"ID": "1652862"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+post_id: "1652171"
+post_author: 1
+"ListingKey": "30071338"
+"ListingId": "X13598556"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:20:06Z"
+"RFModificationTimestamp": "2026-07-23T20:24:52Z"
+"ListPrice": 379900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0K2"
+"UnparsedAddress": "502 - 101 SHOREVIEW PLACE, Hamilton (Stoney Creek), Ontario L8E0K2"
+"Coordinates": array:2 [
0 => -79.719283
1 => 43.238795
]
+"Latitude": 43.238795
+"Longitude": -79.719283
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Wake up to spectacular, uninterrupted views of Lake Ontario from the living room, bedroom, and private balcony in this sun-filled fifth-floor condo offering the perfect blend of luxury, comfort, and waterfront living. Boasting 564 sq. ft. of thoughtfully designed interior space plus a 53 sq. ft. private terrace, this bright open-concept home features elegant wood flooring throughout, a modern kitchen with quartz countertops, ample cabinetry, a breakfast bar, upgraded ceramic flooring, and premium stainless steel appliances. The spacious bedroom offers serene lake views and generous closet space, while the suite also includes convenient ensuite laundry with full-size stacked washer and dryer. Complete with one owned underground parking space, a locker, and bike storage, residents enjoy exceptional amenities including a rooftop terrace with breathtaking panoramic lake views, a fully equipped fitness centre, party room, parcel lockers, and direct access to the scenic waterfront trail. Ideally located close to shopping, major highways, and the GO Station, this is an outstanding opportunity to experience lakeside living at its finest. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"AssociationFee": "460.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T18:19:48.703551+00:00"
+"Directions": "N. Service Rd to Millen Rd to Shoreview Pl"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1940894"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T17:39:28Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T20:10:17Z"
+"StreetName": "Shoreview"
+"StreetNumber": "101"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3092.74"
+"View": "Lake view,View"
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/502_101_shoreview_pl_hamilton_on/"
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071338/502-101-shoreview-place-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-23T17:39:28.41Z"
+"ListAgentNationalAssociationId": "1238254"
+"ListOfficeNationalAssociationId": "1375388"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071338')"
+"ID": "1652171"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23542
+post_id: "1646780"
+post_author: 1
+"ListingKey": "30062350"
+"ListingId": "X13590038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T14:15:09Z"
+"RFModificationTimestamp": "2026-07-22T14:19:59Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E4Z8"
+"UnparsedAddress": "3 WATERFORD CRESCENT, Hamilton (Lakeshore), Ontario L8E4Z8"
+"Coordinates": array:2 [
0 => -79.689776
1 => 43.230707
]
+"Latitude": 43.230707
+"Longitude": -79.689776
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "5 Reasons you will love 3 Waterford Crescent! 1. You'll enjoy 3 bedrooms, 3 bathrooms, and 1819sqft of space, giving your family plenty of space to enjoy, or grow. 2. Located within a 5-10 minute drive to restaurants, groceries, elementary schools, high schools, college, the QEW highway, and GO Train access. This is the perfect location. 3. Waterford Park is right across the street, great for your young ones to play and meet new friends, while you can keep a safe eye on them from home. 4. Quick access to the Newport Yacht Club, a boat dock, and 5 minute walk to the Lake Ontario waterfront. 5. Ample space in the backyard, with the included gazebo, for entertaining guests or for your own enjoyment! (id:62650)"
+"Appliances": array:3 [
0 => "Central Vacuum"
1 => "Window Coverings"
2 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T23:01:06.804759+00:00"
+"Directions": "Fruitland / North Service Road"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2046552"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "21.3 x 116.6 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-07-21T20:40:53Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T14:09:55Z"
+"Stories": "2.0"
+"StreetName": "Waterford"
+"StreetNumber": "3"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5090.38"
+"WaterBodyName": "Lake Ontario"
+"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": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30062350/3-waterford-crescent-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 21.3
+"OriginalEntryTimestamp": "2026-07-21T20:40:53.63Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1322432"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30062350')"
+"ID": "1646780"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+post_id: "1645733"
+post_author: 1
+"ListingKey": "30061073"
+"ListingId": "X13589036"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T22:20:10Z"
+"RFModificationTimestamp": "2026-07-21T22:20:39Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E6G4"
+"UnparsedAddress": "15 - 484 MILLEN ROAD, Hamilton (Stoney Creek), Ontario L8E6G4"
+"Coordinates": array:2 [
0 => -79.714162
1 => 43.237554
]
+"Latitude": 43.237554
+"Longitude": -79.714162
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to prestigious Bal Harbour Estates, where luxury waterfront living meets effortless everyday comfort. This extensively renovated bungalow style end unit condo townhouse offers over 2,300 sq. ft. of beautifully finished living space, showcasing exceptional craftsmanship and premium finishes throughout. Completely transformed from top to bottom, this turnkey residence features a stunning designer kitchen, elegant bathrooms, premium flooring, upgraded lighting, and high end finishes at every turn. The bright, open concept main level is thoughtfully designed to capture breathtaking views of Lake Ontario, featuring a walk out that seamlessly blends indoor and outdoor living while framing the Toronto skyline in the distance. Step outside to the newly installed concrete pad, the perfect place to unwind, entertain, or simply relax while taking in the ever changing waterfront scenery. Premium European engineered motorized blinds provide effortless light control and privacy without compromising the spectacular views. The finished lower level offers exceptional additional living space, ideal for a recreation room, home office, gym, or guest retreat. As a desirable end unit, the home is flooded with natural light and offers added privacy, along with the rare convenience of three parking spaces, including an attached garage, private driveway, and an exclusive parking space located directly in front of the home, plus ample visitor parking for family and guests. Enjoy direct access to the waterfront trail and private beach, while being just minutes from the Marina, shopping, dining, and convenient highway access. Perfect for professionals, commuters, retirees, and boating enthusiasts seeking a maintenance free waterfront lifestyle. The recently fortified shoreline provides long-term peace of mind, allowing you to simply relax and enjoy one of Stoney Creek's most sought after lakefront communities. Luxury. Location. Lifestyle. Welcome home. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "647"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T19:00:59.905710+00:00"
+"Directions": "North Service Road"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Electric"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Flat site"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T19:39:06Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T22:10:26Z"
+"Stories": "1.0"
+"StreetName": "Millen"
+"StreetNumber": "484"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "6424.8"
+"View": "Lake view,View of water,Direct Water View,Unobstructed Water View"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/rzqyzdab/unbranded"
+"WaterBodyName": "Lake Ontario"
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30061073/15-484-millen-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Lodestone Properties Inc"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Fireplace(s)"
1 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"ZoningDescription": "RM4-4"
+"BedroomsAboveGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"OriginalEntryTimestamp": "2026-07-21T17:39:33.26Z"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30061073')"
+"ID": "1645733"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+post_id: "1645734"
+post_author: 1
+"ListingKey": "30060273"
+"ListingId": "40849930"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T21:05:19Z"
+"RFModificationTimestamp": "2026-07-21T21:13:28Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2325.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E6G4"
+"UnparsedAddress": "484 MILLEN Road Unit# 15, Stoney Creek, Ontario L8E6G4"
+"Coordinates": array:2 [
0 => -79.7141601
1 => 43.2376077
]
+"Latitude": 43.2376077
+"Longitude": -79.7141601
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to prestigious Bal Harbour Estates, where luxury waterfront living meets effortless everyday comfort. This extensively renovated bungalow style end unit condo townhouse offers over 2,300 sq. ft. of beautifully finished living space, showcasing exceptional craftsmanship and premium finishes throughout. Completely transformed from top to bottom, this turnkey residence features a stunning designer kitchen, elegant bathrooms, premium flooring, upgraded lighting, and high end finishes at every turn. The bright, open concept main level is thoughtfully designed to capture breathtaking views of Lake Ontario, featuring a walk out that seamlessly blends indoor and outdoor living while framing the Toronto skyline in the distance. Step outside to the newly installed concrete pad, the perfect place to unwind, entertain, or simply relax while taking in the ever changing waterfront scenery. Premium European engineered motorized blinds provide effortless light control and privacy without compromising the spectacular views. The finished lower level offers exceptional additional living space, ideal for a recreation room, home office, gym, or guest retreat. As a desirable end unit, the home is flooded with natural light and offers added privacy, along with the rare convenience of three parking spaces, including an attached garage, private driveway, and an exclusive parking space located directly in front of the home, plus ample visitor parking for family and guests. Enjoy direct access to the waterfront trail and private beach, while being just minutes from Fifty Point Marina, shopping, dining, and convenient QEW access. Perfect for professionals, commuters, retirees, and boating enthusiasts seeking a maintenance free waterfront lifestyle. The recently fortified shoreline provides long-term peace of mind, allowing you to simply relax and enjoy one of Stoney Creek's most sought after lakefront communities. Luxury. Location. Lifestyle. Welcome home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "647"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T16:44:25.443320+00:00"
+"Directions": "NORTH SERVICE RD AND DRIVING EAST TURN ON MILLER RD TOWARDS THE WATER AND HOME IS ON THE NORTHEAST SIDE"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060544"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-21T18:08:29Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T20:59:38Z"
+"Stories": "1.0"
+"StreetName": "MILLEN"
+"StreetNumber": "484"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "6424.8"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/484-millen-rd-15-hamilton-on-l8e-6g4-26671344/branded"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30060273/484-millen-road-unit-15-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM4-4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"AboveGradeFinishedArea": 1550
+"BelowGradeFinishedArea": 775
+"OriginalEntryTimestamp": "2026-07-21T16:00:00.5Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1335689"
+"ListOfficeNationalAssociationId": "1344652"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30060273')"
+"ID": "1645734"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 114
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]