array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29625186 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408
+post_id: "1331911"
+post_author: 1
+"ListingKey": "29625186"
+"ListingId": "X13016248"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T19:25:04Z"
+"RFModificationTimestamp": "2026-06-15T19:42:32Z"
+"ListPrice": 1699999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E4Z7"
+"UnparsedAddress": "5 - 97 SUNVALE PLACE, Hamilton (Lakeshore), Ontario L8E4Z7"
+"Coordinates": array:2 [
0 => -79.689672
1 => 43.234566
]
+"Latitude": 43.234566
+"Longitude": -79.689672
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step inside this beautiful two-storey Stoney Creek lakeside townhome and feel instantly at home. A spacious foyer leads into a stunning gourmet kitchen with granite countertops, custom cabinetry, and a handcrafted hood vent, flowing effortlessly into the dining and living areas. The cozy fireplace and large windows create a warm, inviting space, while sliding doors open to a deck with breathtaking, unobstructed views of Lake Ontario-perfect for morning coffee or unwinding at sunset. Upstairs, you'll find generously sized bedrooms, including a serene primary suite with a spa-like ensuite featuring a deep soaker tub, walk-in shower, and elegant finishes. Convenient bedroom-level laundry adds everyday ease. The walkout lower level offers a bright family room that opens to a lakeside patio, ideal for entertaining or relaxing by the outdoor fireplace as you take in the views. With plenty of space to enjoy the outdoors, this home truly embraces waterfront living in every season. All this just minutes to QEW access, shopping, and everyday amenities. A rare opportunity to enjoy peaceful lakeside living on Lake Ontario. RSA. (id:62783)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
]
+"AssociationFee": "550"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Water"
1 => "Insurance"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Partially finished"
2 => "Full"
3 => "Walk out"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-18T18:44:21.756134+00:00"
+"Directions": "Cross Streets: Stoney Creek North Service Road to Waterford Crescent. ** Directions: Stoney Creek - North on Fruitland Rd East - Right on North Service Rd - Left at Waterford Crescent - Sunvale Place."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Tile"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:9 [
0 => "Cul-de-sac"
1 => "Rolling"
2 => "Waterway"
3 => "Open space"
4 => "Flat site"
5 => "Lighting"
6 => "Dry"
7 => "Carpet Free"
8 => "In suite Laundry"
]
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-04-18T17:43:55Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T19:19:01Z"
+"Stories": "2.0"
+"StreetName": "Sunvale"
+"StreetNumber": "97"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "10628.9"
+"View": "View,View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/trebtour.asp?tourid=68183"
+"WaterBodyName": "Lake Ontario"
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1660046085"
"RoomType" => "Foyer"
"ListingId" => "X13016248"
"RoomLevel" => "Ground level"
"RoomWidth" => 1.52
"ListingKey" => "29625186"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.7Z"
]
1 => array:11 [
"RoomKey" => "1660046086"
"RoomType" => "Bathroom"
"ListingId" => "X13016248"
"RoomLevel" => "Second level"
"RoomWidth" => 1.86
"ListingKey" => "29625186"
"RoomLength" => 2.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.7Z"
]
2 => array:11 [
"RoomKey" => "1660046087"
"RoomType" => "Laundry room"
"ListingId" => "X13016248"
"RoomLevel" => "Second level"
"RoomWidth" => 1.52
"ListingKey" => "29625186"
"RoomLength" => 2.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
3 => array:11 [
"RoomKey" => "1660046088"
"RoomType" => "Living room"
"ListingId" => "X13016248"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.76
"ListingKey" => "29625186"
"RoomLength" => 12.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
4 => array:11 [
"RoomKey" => "1660046089"
"RoomType" => "Family room"
"ListingId" => "X13016248"
"RoomLevel" => "Ground level"
"RoomWidth" => 4.06
"ListingKey" => "29625186"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
5 => array:11 [
"RoomKey" => "1660046090"
"RoomType" => "Eating area"
"ListingId" => "X13016248"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.07
"ListingKey" => "29625186"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
6 => array:11 [
"RoomKey" => "1660046091"
"RoomType" => "Kitchen"
"ListingId" => "X13016248"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.9
"ListingKey" => "29625186"
"RoomLength" => 3.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
7 => array:11 [
"RoomKey" => "1660046092"
"RoomType" => "Partial bathroom"
"ListingId" => "X13016248"
"RoomLevel" => "Ground level"
"RoomWidth" => 1.4
"ListingKey" => "29625186"
"RoomLength" => 1.58
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
8 => array:11 [
"RoomKey" => "1660046093"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13016248"
"RoomLevel" => "Second level"
"RoomWidth" => 4.27
"ListingKey" => "29625186"
"RoomLength" => 7.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
9 => array:11 [
"RoomKey" => "1660046094"
"RoomType" => "Bathroom"
"ListingId" => "X13016248"
"RoomLevel" => "Second level"
"RoomWidth" => 2.87
"ListingKey" => "29625186"
"RoomLength" => 3.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
10 => array:11 [
"RoomKey" => "1660046095"
"RoomType" => "Bedroom 2"
"ListingId" => "X13016248"
"RoomLevel" => "Second level"
"RoomWidth" => 2.87
"ListingKey" => "29625186"
"RoomLength" => 3.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
11 => array:11 [
"RoomKey" => "1660046096"
"RoomType" => "Bedroom 3"
"ListingId" => "X13016248"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29625186"
"RoomLength" => 3.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T19:19:01.71Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29625186/5-97-sunvale-place-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3249
+"LivingAreaMinimum": 3000
+"ZoningDescription": "RM3-4"
+"BedroomsAboveGrade": 3
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"OriginalEntryTimestamp": "2026-04-18T17:43:55.6Z"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6610148986"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/7b69cb5a7337aa5560f70c8c9692c392.webp"
"MediaSize" => 155548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-7b69cb5a7337aa5560f70c8c9692c392.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6610149000"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/249de60323cba8f64fcb08c289d418cb.webp"
"MediaSize" => 126081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-249de60323cba8f64fcb08c289d418cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6610149020"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/b89614ded0c43256c615216289f21b8a.webp"
"MediaSize" => 90652
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-b89614ded0c43256c615216289f21b8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6610149027"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/a2123b7610dd4083b6606719bd719bea.webp"
"MediaSize" => 105277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-a2123b7610dd4083b6606719bd719bea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6610149045"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/2ca47adebde7adb7999e5787bbc253dc.webp"
"MediaSize" => 118780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-2ca47adebde7adb7999e5787bbc253dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6610149056"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/948428245bb85c89e28da5a2c4e5c6bb.webp"
"MediaSize" => 100831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-948428245bb85c89e28da5a2c4e5c6bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6610149066"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/cd397b0978bd32db9d21c45270e282d1.webp"
"MediaSize" => 100846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-cd397b0978bd32db9d21c45270e282d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6610149078"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/e61c60a0d42027fb374995d6b5700040.webp"
"MediaSize" => 94512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-e61c60a0d42027fb374995d6b5700040.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6610149095"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/d46250a992946424e420dc28adf66faf.webp"
"MediaSize" => 112236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-d46250a992946424e420dc28adf66faf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6610149108"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/0cd0f3338b34056a852a2a4f1ee2310b.webp"
"MediaSize" => 127941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-0cd0f3338b34056a852a2a4f1ee2310b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6610149118"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/1792bb33e1ee69b65a82c411a3a493e5.webp"
"MediaSize" => 124937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-1792bb33e1ee69b65a82c411a3a493e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6610149132"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/3185845a261c7e6ff3c39f9939f3b5b6.webp"
"MediaSize" => 113265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-3185845a261c7e6ff3c39f9939f3b5b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6610149143"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/2c67ce67793d813ce407c240daa47af5.webp"
"MediaSize" => 113141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-2c67ce67793d813ce407c240daa47af5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6610149151"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/d989377b8179ff5ace62431cd19199ac.webp"
"MediaSize" => 108451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-d989377b8179ff5ace62431cd19199ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6610149175"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/b9856883dfe1bd89b9d6fa03bc33cddc.webp"
"MediaSize" => 75441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-b9856883dfe1bd89b9d6fa03bc33cddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6610149193"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/33b0bfa74f20eadc5baaa679d0060e1e.webp"
"MediaSize" => 76934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-33b0bfa74f20eadc5baaa679d0060e1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6610149214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/354dfb55318b36312b2e67f3480c3a96.webp"
"MediaSize" => 72742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-354dfb55318b36312b2e67f3480c3a96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6610149237"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/361cb5faa64d24746ef5e06124a0b834.webp"
"MediaSize" => 83345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-361cb5faa64d24746ef5e06124a0b834.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6610149267"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/6c2c6afd55f0c73419e7e3e3ccccf085.webp"
"MediaSize" => 105131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-6c2c6afd55f0c73419e7e3e3ccccf085.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6610149300"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/92a34b7d3d0a67770ab9972767f612a3.webp"
"MediaSize" => 85265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-92a34b7d3d0a67770ab9972767f612a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6610149320"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/289ebcf818d16c79cc5c80c721115cfc.webp"
"MediaSize" => 120295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-289ebcf818d16c79cc5c80c721115cfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6610149342"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/7eba3c3e5da857afbf83dd1777a8bcdd.webp"
"MediaSize" => 99594
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-7eba3c3e5da857afbf83dd1777a8bcdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6610149391"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/0cee2562a0befea6efbbc87945999c7a.webp"
"MediaSize" => 70588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-0cee2562a0befea6efbbc87945999c7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6610149414"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/e5874aee1580a13a857e1f7083469c1d.webp"
"MediaSize" => 109312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-e5874aee1580a13a857e1f7083469c1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6610149424"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/61cef4725469992add447e048b1abb35.webp"
"MediaSize" => 107321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-61cef4725469992add447e048b1abb35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6610149445"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/ac02f735687c3f0755dd3ffca9cfe5a7.webp"
"MediaSize" => 122583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-ac02f735687c3f0755dd3ffca9cfe5a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6610149458"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/bb5b4d5969f7cb49a130f0638f245de2.webp"
"MediaSize" => 146944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-bb5b4d5969f7cb49a130f0638f245de2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6610149490"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/0c32e2fc7ae09cf771cecf31f5798f34.webp"
"MediaSize" => 145764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-0c32e2fc7ae09cf771cecf31f5798f34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6610149498"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/3e141bd8f008fe771a79f56e40defcf4.webp"
"MediaSize" => 191075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-3e141bd8f008fe771a79f56e40defcf4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6610149558"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/2f39c2a71be921b356d3a0e54d7e33a9.webp"
"MediaSize" => 115175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-2f39c2a71be921b356d3a0e54d7e33a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6610149592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/256989c2d466fed165a3ffa177d35728.webp"
"MediaSize" => 134369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-256989c2d466fed165a3ffa177d35728.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6610149623"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/21e26304a6475a9d3949f84106323de7.webp"
"MediaSize" => 196437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-21e26304a6475a9d3949f84106323de7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6610149664"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/8f3f886b7709d6ed1957618fde15c109.webp"
"MediaSize" => 80845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-8f3f886b7709d6ed1957618fde15c109.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6610149707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29625186/8332c4555a61bbf940121f5105aeac25.webp"
"MediaSize" => 86028
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29625186/thumbnail-8332c4555a61bbf940121f5105aeac25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13016248"
"ResourceRecordKey" => "29625186"
"ModificationTimestamp" => "2026-04-18T17:43:55.61Z"
]
]
+"DaysOnMarket": 62
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29625186')"
+"ID": "1331911"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 266588" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24896
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2259210" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24869
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29625186'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25202
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29625186'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25218
+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 '29625186' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.689672 43.234566)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25271
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25265
+post_id: "1548748"
+post_author: 1
+"ListingKey": "29928457"
+"ListingId": "X13466848"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:20:09Z"
+"RFModificationTimestamp": "2026-06-19T16:56:41Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0C3"
+"UnparsedAddress": "128 PALACEBEACH TRAIL, Hamilton (Stoney Creek), Ontario L8E0C3"
+"Coordinates": array:2 [
0 => -79.677271
1 => 43.22798
]
+"Latitude": 43.22798
+"Longitude": -79.677271
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Your Dream Home In The Heart Of Stoney Creek! This Stunning Freehold Townhome Very Neat And Clean throughout, This Meticulously Maintained Home Offers A Modern, Functional Layout Featuring 3 Spacious Bedrooms And Convenient Upstairs Laundry. The Main Living Areas Are Bright, Spacious, And Perfect For Family Living. Step Outside To A Large Private Backyard Ideal For Summer BBQs And Entertaining. Enjoy the convenience of inside access from the attached garage. Located Just Minutes From Lake Ontario, Fifty Point Conservation Area, Scenic Waterfront Trails, Costco, Schools, Major Retailers, And Everyday Essentials. Quick Access To The QEW Keeps You Connected-Approx. 45 Minutes To Toronto And 30 Minutes To Niagara Falls. A Strong Opportunity For First-Time Buyers And Investors. Please note that the current photos on the listing are older. The property has since been freshly updated with a professional paint job completed approximately 6 months ago. The home shows much newer and improved condition compared to the photos displayed. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:56:34.274836+00:00"
+"Directions": "N Service Rd + Fruitland Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1919369"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.5 x 86.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T15:59:10Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:59:10Z"
+"Stories": "2.0"
+"StreetName": "Palacebeach"
+"StreetNumber": "128"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "4396"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1663038517"
"RoomType" => "Living room"
"ListingId" => "X13466848"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.47
"ListingKey" => "29928457"
"RoomLength" => 6.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:59:10.54Z"
]
1 => array:11 [
"RoomKey" => "1663038518"
"RoomType" => "Dining room"
"ListingId" => "X13466848"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.53
"ListingKey" => "29928457"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:59:10.54Z"
]
2 => array:11 [
"RoomKey" => "1663038519"
"RoomType" => "Kitchen"
"ListingId" => "X13466848"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.53
"ListingKey" => "29928457"
"RoomLength" => 3.54
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:59:10.54Z"
]
3 => array:11 [
"RoomKey" => "1663038520"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13466848"
"RoomLevel" => "Second level"
"RoomWidth" => 3.99
"ListingKey" => "29928457"
"RoomLength" => 4.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:59:10.54Z"
]
4 => array:11 [
"RoomKey" => "1663038521"
"RoomType" => "Bedroom 2"
"ListingId" => "X13466848"
"RoomLevel" => "Second level"
"RoomWidth" => 2.93
"ListingKey" => "29928457"
"RoomLength" => 3.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:59:10.54Z"
]
5 => array:11 [
"RoomKey" => "1663038522"
"RoomType" => "Bedroom 3"
"ListingId" => "X13466848"
"RoomLevel" => "Second level"
"RoomWidth" => 3.14
"ListingKey" => "29928457"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-19T15:59:10.54Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29928457/128-palacebeach-trail-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.6
+"OriginalEntryTimestamp": "2026-06-19T15:59:10.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1226081"
+"ListOfficeNationalAssociationId": "1200762"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29928457_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/cf92e7d44ba30fe4d10e0cd5728ee460.webp"
"MediaSize" => 127877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-cf92e7d44ba30fe4d10e0cd5728ee460.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29928457_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/bd9a5d3d3f82dc984e2e6309f7efdebf.webp"
"MediaSize" => 111723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-bd9a5d3d3f82dc984e2e6309f7efdebf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29928457_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/3dcdc7d1552a934eab149f430d188040.webp"
"MediaSize" => 65350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-3dcdc7d1552a934eab149f430d188040.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29928457_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/4cfd19aa0ece4dd38615c923968de22e.webp"
"MediaSize" => 48392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-4cfd19aa0ece4dd38615c923968de22e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29928457_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/15dc3790b38121b5ef36e17f50e1637d.webp"
"MediaSize" => 59565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-15dc3790b38121b5ef36e17f50e1637d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29928457_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/09cd7c74194439d481038d8c696a5f5f.webp"
"MediaSize" => 55569
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-09cd7c74194439d481038d8c696a5f5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29928457_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/af9c3f8bdf7e9a64e4588a85cfb6111d.webp"
"MediaSize" => 83092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-af9c3f8bdf7e9a64e4588a85cfb6111d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29928457_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/83955a28dbe21f56931c729de09558ef.webp"
"MediaSize" => 84810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-83955a28dbe21f56931c729de09558ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29928457_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/6189480fec80659c9988c37f1ed0c0ad.webp"
"MediaSize" => 99641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-6189480fec80659c9988c37f1ed0c0ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29928457_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/8e8f7a8abac7a066609fb579c253cf46.webp"
"MediaSize" => 82832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-8e8f7a8abac7a066609fb579c253cf46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29928457_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/5b369c435a744b70e08b6e13af6a9f47.webp"
"MediaSize" => 69845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-5b369c435a744b70e08b6e13af6a9f47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29928457_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/f13fbc5f3f3b98f3defd6586e8f2875c.webp"
"MediaSize" => 80023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-f13fbc5f3f3b98f3defd6586e8f2875c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29928457_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/7d9483baf32972e8a3556bceda9ba159.webp"
"MediaSize" => 62902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-7d9483baf32972e8a3556bceda9ba159.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29928457_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/9a38398aa037e4892ece5302180d0345.webp"
"MediaSize" => 80967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-9a38398aa037e4892ece5302180d0345.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29928457_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/40ca0dc32d4df44b19d9f3c913becaf8.webp"
"MediaSize" => 74527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-40ca0dc32d4df44b19d9f3c913becaf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29928457_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/3f444bde239684b978acabc591885884.webp"
"MediaSize" => 61523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-3f444bde239684b978acabc591885884.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29928457_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/8b86c368356b72809cbda9ce41437d17.webp"
"MediaSize" => 75438
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-8b86c368356b72809cbda9ce41437d17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29928457_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/221bc947715cec2a1c960d26de5ad929.webp"
"MediaSize" => 59732
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-221bc947715cec2a1c960d26de5ad929.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29928457_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/b98091971a8d99495b16ecf7e4db7708.webp"
"MediaSize" => 82626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-b98091971a8d99495b16ecf7e4db7708.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29928457_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/ed0643f834564bcb9e65d41e12adaff8.webp"
"MediaSize" => 64775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-ed0643f834564bcb9e65d41e12adaff8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13466848"
"ResourceRecordKey" => "29928457"
"ModificationTimestamp" => "2026-06-19T15:59:10.52Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29928457_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928457/4d89ace3bb60dfd9355b7e605925fbdc.webp"
"MediaSize" => 71131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928457/thumbnail-4d89ace3bb60dfd9355b7e605925fbdc.webp"
…7
]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928457')"
+"ID": "1548748"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: "1544939"
+post_author: 1
+"ListingKey": "29921795"
+"ListingId": "X13460848"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:30:39Z"
+"RFModificationTimestamp": "2026-06-19T16:42:30Z"
+"ListPrice": 1599000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0L4"
+"UnparsedAddress": "6 - 100 WATERSHORE DRIVE, Hamilton (Stoney Creek), Ontario L8E0L4"
+"Coordinates": array:2 [
0 => -79.678046
1 => 43.231402
]
+"Latitude": 43.231402
+"Longitude": -79.678046
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exceptional newer home in the award-winning Residences at Watershore community in Stoney Creek. Just steps from the shores of Lake Ontario, this stunning Elm Model offers the perfect blend of modern design, comfort, and upscale living. With over $200,000.00 in updgrades, it features 4 spacious bedrooms, 4 beautifully appointed bathrooms, and a fully finished basement, this home showcases thousands of dollars in premium upgrades throughout. The designer kitchen is a true showpiece, complete with extended cabinetry, elegant crown moulding, an oversized island, and soft-close cabinets and drawers-including a convenient Lazy Susan. Quartz countertops and upgraded faucets add a touch of luxury to both the kitchen and bathrooms. Thoughtfully designed with pot lights throughout and motion-sensor lighting in secondary closets, the home offers both style and functionality. The inviting family room features a custom-built entertainment unit paired with a stunning marble fireplace-perfect for relaxing or entertaining.Engineered hardwood flooring flows seamlessly across the main and second floors, while the basement is finished with high-quality luxury vinyl flooring.Step outside to enjoy the convenience of a natural gas BBQ line, ideal for effortless outdoor entertaining. The fully upgraded garage is a standout feature, complete with epoxy flooring, slat wall organization, built-in storage shelves, and a Chamberlain MyQ smart garage door opener for added convenience. This home offers an exceptional lifestyle with too many upgrades to list. ************OPEN HOUSE SUNDAY JUNE 28th.....2pm - 4pm************ (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Oven"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:37:04.032640+00:00"
+"Directions": "Watershore Dr. and Glover Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Vinyl"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1496667"
+"ListOfficeKey": "274885"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "51.8 x 99.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T15:37:16Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:59:01Z"
+"Stories": "2.0"
+"StreetName": "Watershore"
+"StreetNumber": "100"
+"StreetSuffix": "Drive"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29921795/6-100-watershore-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1880835"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "274885"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 51.9
+"OriginalEntryTimestamp": "2026-06-18T15:37:16.3Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1134565"
+"ListOfficeNationalAssociationId": "1259284"
+"CoListAgentNationalAssociationId": "1206466"
+"CoListOfficeNationalAssociationId": "1259284"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921795')"
+"ID": "1544939"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25264
+post_id: "1544940"
+post_author: 1
+"ListingKey": "29921117"
+"ListingId": "40840961"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:20:16Z"
+"RFModificationTimestamp": "2026-06-18T19:45:36Z"
+"ListPrice": 3200000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3067.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5C6"
+"UnparsedAddress": "511 GLOVER Road, Stoney Creek, Ontario L8E5C6"
+"Coordinates": array:2 [
0 => -79.6742669
1 => 43.2299725
]
+"Latitude": 43.2299725
+"Longitude": -79.6742669
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Custom all brick and stone bungalow on the shores of Lake Ontario. Tucked away at the end of the street offering no through traffic and all the privacy one could ask for. Substantial lot with substantial space for pool, pool-house and any other outdoor luxuries imaginable. Stately presence with rounded driveway parking for multiple cars. A spacious double door main entrance welcomes you into the massive open concept main level design. Sun drenched windows wrap the back of the home offering breathtaking views of the lake. Soaring ceilings and tasteful design give this space room and functionality. An entertainers dream with a chefs kitchen basting stainless steel appliances and luxurious black stone counters open to the dining and living/family room space offering stunning gas fireplace. Perfect for hosting gatherings and accommodating large groups of people with patio doors leading out to the private rear yard. Be mesmerized by primary bedroom offering tranquil sitting area enjoying stunning lake views from bay window. Primary ensuite offers jacuzzi tub and stand up glass shower. All bedrooms blanketed in high end hardwood floors. Second main level bath is equipped with tub and glass shower also. Convenient main level laundry makes living easy with all main functions on one level. Impressive covered patio at the end of the lot overlooks the lake, the perfect spot for morning coffees or conversation-filled evenings with guests. Stoney shoreline perfect for fishing, swimming and enjoying the water. Wide open unfinished basement offers endless opportunity for extended family or subsidizing mortgage payments with rental capabilities. Roof, furnace, fridge and stove just installed in 2023. Only minutes to the QEW, Costco and all other amenities This is a rarely offered bungalow in a high demand location. Difficult finds like this are hard to come by. Don't wait, act today. Luxury Certified. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T15:08:18.356811+00:00"
+"Directions": "FRUITLAND RD TO NORTH SERVICE RD"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Shingles"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1761197"
+"ListOfficeKey": "262664"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Southern exposure"
1 => "Lot with lake"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T14:31:55Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:11:03Z"
+"Stories": "1.0"
+"StreetName": "GLOVER"
+"StreetNumber": "511"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "17210"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://vimeo.com/1201502247?fl=ip&fe=ec"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921117/511-glover-road-stoney-creek"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "RR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 215.0
+"AboveGradeFinishedArea": 3067
+"OriginalEntryTimestamp": "2026-06-18T14:31:55.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1184463"
+"ListOfficeNationalAssociationId": "1223042"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921117')"
+"ID": "1544940"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: "1531335"
+post_author: 1
+"ListingKey": "29906174"
+"ListingId": "X13447120"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T01:55:11Z"
+"RFModificationTimestamp": "2026-06-16T01:57:46Z"
+"ListPrice": 2200000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E4X2"
+"UnparsedAddress": "36 LAKEVIEW DRIVE, Hamilton (Lakeshore), Ontario L8E4X2"
+"Coordinates": array:2 [
0 => -79.702211
1 => 43.234916
]
+"Latitude": 43.234916
+"Longitude": -79.702211
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 36 Lakeview Drive in Stoney Creek - Paradise by the Lake. An elegant lakeside home where considered design meets effortless living, rebuilt from the inside out for those who appreciate the finer things in life. Wake to the sound of the lake, step out for a morning walk along the water in the sought-after Stoney Creek area, and come home to easy, open-concept living bathed in natural light through oversized 8-by-10 curtain-wall windows beneath soaring 13-foot ceilings.Every surface has been elevated with an architect's eye: upgraded eight-foot two-panel doors with bevelled trim, seven-inch baseboards and bespoke flooring solutions throughout. Built for the entertainer, the home centres on a luxurious chef's kitchen anchored by a 48-inch pro-style natural gas range with six burners, integrated griddle, convection oven and self-clean, with a fullsuite of chef-grade appliances. Two private primary suites each feature a luxurious bathroom, a large walk-in closet, lake views and walkout access to the rooftop patio, with a private entrance and an 11-foot bathroom ceiling. Outdoor living reaches its finest with lakeview rooftop patios and dining gazebos for long summer evenings, a wine cellar/ventilated cigar lounge, a home gym and multi-zone outdoor living. No detail is overlooked, from smart toilets and designer fixtures to all-new plumbing, electrical, multi-zone HVAC and roof, new European windows and doors, and fresh sod throughout. Above it all, a 100-panel solar array quietly returns roughly $12,000 a year. With four bedrooms, 4.5 baths and a six-car built-in garage ready for the car collection or workshop, this is over 3,400 square feet of finished living space, offered with a flexible, long-term closing. Landscaped grounds with garden shed, landscape lighting and full irrigation complete this one-of-a-kind lakeside offering in an unbeatable location. Luxury living by the lake, a rare offering for those who expect the very best. Check out the video!! (id:62650)"
+"Appliances": array:3 [
0 => "Range"
1 => "Oven - Built-In"
2 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Wall unit"
]
+"CreationDate": "2026-06-15T20:55:30.324849+00:00"
+"Directions": "Cross Streets: Lakeview and North Service. ** Directions: Fruitland to North Service to Lakeview."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1423581"
+"ListOfficeKey": "51443"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Gazebo"
]
+"LotSizeDimensions": "49.2 x 191.9 FT ; Irregular lot as per survey"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T20:02:49Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T01:46:08Z"
+"Stories": "2.0"
+"StreetName": "Lakeview"
+"StreetNumber": "36"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7979.56"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://media.virtualgta.com/sites/rnqawooa/unbranded"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29906174/36-lakeview-drive-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 23
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Canopy"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 49.2
+"OriginalEntryTimestamp": "2026-06-15T20:02:49.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1071616"
+"ListOfficeNationalAssociationId": "1125322"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906174')"
+"ID": "1531335"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: "1525958"
+post_author: 1
+"ListingKey": "29898626"
+"ListingId": "X13440118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:10:06Z"
+"RFModificationTimestamp": "2026-06-12T23:36:48Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E4Z2"
+"UnparsedAddress": "23 EDGEWATER DRIVE, Hamilton (Lakeshore), Ontario L8E4Z2"
+"Coordinates": array:2 [
0 => -79.69403
1 => 43.235431
]
+"Latitude": 43.235431
+"Longitude": -79.69403
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Waterfront living without compromise. Situated on a premium 253-foot deep lot along the shores of Lake Ontario, this exceptional freehold townhome offers panoramic water views, professionally landscaped grounds, multiple outdoor entertaining spaces, and direct access to one of Hamilton's most sought-after waterfront communities. Featuring 3 bedrooms, 3 bathrooms, a double car garage, an updated kitchen, spacious principal rooms, a luxurious primary suite with private lakeview balcony, and meticulously maintained gardens stretching to the shoreline, this is a home designed around the water. Steps to Newport Yacht Club and minutes to the QEW, this is a rare opportunity to own a turnkey waterfront residence in an exclusive lakeside setting. (id:66098)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T23:36:31.373401+00:00"
+"Directions": "Harbour Dr & Edgewater Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834162"
+"ListOfficeKey": "293196"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "29 x 253.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T22:02:22Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T22:02:22Z"
+"Stories": "2.0"
+"StreetName": "Edgewater"
+"StreetNumber": "23"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "10295.79"
+"View": "Direct Water View"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29898626/23-edgewater-drive-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1899457"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292096"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RM2-1"
+"BedroomsAboveGrade": 3
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 29.0
+"OriginalEntryTimestamp": "2026-06-12T22:02:22.81Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1196633"
+"ListOfficeNationalAssociationId": "1423680"
+"CoListAgentNationalAssociationId": "1216506"
+"CoListOfficeNationalAssociationId": "1408169"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898626')"
+"ID": "1525958"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25261
+post_id: "1522705"
+post_author: 1
+"ListingKey": "29893673"
+"ListingId": "X13435362"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T12:30:31Z"
+"RFModificationTimestamp": "2026-06-15T12:32:24Z"
+"ListPrice": 628000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "67 - 590 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.697415
1 => 43.234285
]
+"Latitude": 43.234285
+"Longitude": -79.697415
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this modern 3-bedroom, 2-bathroom stacked townhome condo ideally located in the heart of Stoney Creek. Featuring two private balconies with stunning views of Lake Ontario, this home offers the perfect blend of comfort, convenience, and contemporary living. Thoughtfully designed with spacious bedrooms and functional living areas, this property is ideal for families, first-time buyers, or commuters seeking easy highway access. Situated directly off the QEW at Fruitland Road, you're just minutes from Costco, Stoney Creek shopping amenities, and popular retail destinations. Enjoy quick access to the GO Train, Toronto-bound highways, and Niagara - making this location a true commuter's dream and a gateway to everything the region has to offer. Additional features include garage and driveway parking, plus visitor parking within the complex. Set in a welcoming, family-friendly community, this home offers both lifestyle and location. Don't miss your opportunity to own in one of Stoney Creek's most convenient and desirable areas. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T04:26:29.926004+00:00"
+"Directions": "Cross Streets: North Service Road/Fruitland Road. ** Directions: QEW > EXIT FRUITLAND."
+"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": "2190589"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "41 x 40 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T03:41:54Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T12:28:16Z"
+"Stories": "3.0"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4254"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29893673/67-590-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2026-06-12T03:41:54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1439633"
+"ListOfficeNationalAssociationId": "1300540"
+"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": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893673')"
+"ID": "1522705"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1518678"
+post_author: 1
+"ListingKey": "29888005"
+"ListingId": "40837664"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T19:20:06Z"
+"RFModificationTimestamp": "2026-06-16T19:29:02Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.17
+"LivingArea": 2500.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E4Z2"
+"UnparsedAddress": "23 EDGEWATER Drive, Stoney Creek, Ontario L8E4Z2"
+"Coordinates": array:2 [
0 => -79.6936762
1 => 43.2356062
]
+"Latitude": 43.2356062
+"Longitude": -79.6936762
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Waterfront living without compromise. Situated on a premium 253-foot deep lot along the shores of Lake Ontario, this exceptional freehold townhome offers panoramic water views, professionally landscaped grounds, multiple outdoor entertaining spaces, and direct access to one of Hamilton's most sought-after waterfront communities. Featuring 3 bedrooms, 3 bathrooms, a double car garage, an updated kitchen, spacious principal rooms, a luxurious primary suite with private lakeview balcony, and meticulously maintained gardens stretching to the shoreline, this is a home designed around the water. Steps to Newport Yacht Club and minutes to the QEW, this is a rare opportunity to own a turnkey waterfront residence in an exclusive lakeside setting. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T15:27:57.065634+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981971"
+"ListOfficeKey": "293310"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.17"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T19:10:36Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T19:14:55Z"
+"Stories": "2.0"
+"StreetName": "EDGEWATER"
+"StreetNumber": "23"
+"StreetSuffix": "Drive"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "10295.79"
+"View": "Direct Water View"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29888005/23-edgewater-drive-stoney-creek"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RM2-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 2500
+"OriginalEntryTimestamp": "2026-06-11T14:24:50.81Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1267224"
+"ListOfficeNationalAssociationId": "1425260"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888005')"
+"ID": "1518678"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25269
+post_id: "1514794"
+post_author: 1
+"ListingKey": "29881757"
+"ListingId": "X13424546"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T18:05:16Z"
+"RFModificationTimestamp": "2026-06-10T18:52:09Z"
+"ListPrice": 1049000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E6E3"
+"UnparsedAddress": "506 JONES ROAD, Hamilton (Lakeshore), Ontario L8E6E3"
+"Coordinates": array:2 [
0 => -79.684803
1 => 43.231971
]
+"Latitude": 43.231971
+"Longitude": -79.684803
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this charming detached bungalow nestled in the highly desirable Lakeshore community of Stoney Creek, just steps from the shores of Lake Ontario. The main level features 3 spacious bedrooms with hardwood and laminate flooring throughout, along with an updated kitchen complete with granite countertops, breakfast bar, and walk-out access to a fully fenced backyard patio-perfect for relaxing or entertaining. The finished basement offers exceptional additional living space, including a large recreation room with an eat-in kitchen, expansive common area with potential for two additional bedrooms, a full 4-piece bathroom, and a laundry room with ample storage. Conveniently located with easy access to the QEW, parks, shopping, restaurants, and all essential amenities, this home offers incredible value and versatility for families, downsizers, or investors alike. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-10T15:33:13.893945+00:00"
+"Directions": "Cross Streets: QEW / Fruitland Rd. ** Directions: Fruitland Rd - N Service Rd - Jones Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1741542"
+"ListOfficeKey": "152307"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "39.7 x 121.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T14:54:05Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T17:57:47Z"
+"Stories": "1.0"
+"StreetName": "Jones"
+"StreetNumber": "506"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5568"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/506-jones-road-hamilton/"
+"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"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29881757/506-jones-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2095197"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "152307"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 39.8
+"OriginalEntryTimestamp": "2026-06-10T14:54:05.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1179250"
+"ListOfficeNationalAssociationId": "1201558"
+"CoListAgentNationalAssociationId": "1367385"
+"CoListOfficeNationalAssociationId": "1201558"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881757')"
+"ID": "1514794"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25270
+post_id: "1511215"
+post_author: 1
+"ListingKey": "29876848"
+"ListingId": "X13420616"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T21:55:16Z"
+"RFModificationTimestamp": "2026-06-09T21:56:10Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "415 - 600 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.69644
1 => 43.234121
]
+"Latitude": 43.234121
+"Longitude": -79.69644
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience Modern Lakeside Living At COMO Condos In Stoney Creek. This Stylish 1 Bedroom + Den Suite Offers A Thoughtfully Designed Layout With Open-Concept Living And Dining, Enhanced By Luxury Vinyl Plank Flooring And Floor-To-Ceiling Windows That Fill The Space With Natural Light And Showcase Beautiful Lake Views. The Contemporary Kitchen Features Quartz Countertops, Extended Cabinetry, Built-In Appliances, And A Functional Breakfast Bar-Perfect For Both Everyday Living And Entertaining. The Spacious Bedroom Includes A Walk-In Closet, While The Versatile Den Provides An Ideal Space For A Home Office Or Additional Living Area. Step Out Onto Your Private Balcony And Enjoy Unobstructed Views Of Lake Ontario And The Toronto Skyline-A True Extension Of Your Living Space. Complete With One Underground Parking Space And A Storage Locker, This Unit Offers Both Comfort And Convenience. Residents Enjoy Access To Exceptional Amenities Including A Rooftop Terrace, Community Garden, Party Room, Media Lounge, Parcel Lockers, Bike Storage, And More. Ideally Located Near The Waterfront, QEW, Upcoming GO Station, And Everyday Amenities-This Is A Fantastic Opportunity To Own In A Growing Lakeside Community. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Range"
4 => "Oven"
5 => "Dryer"
6 => "Microwave"
7 => "Cooktop"
]
+"AssociationFee": "427.85"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T18:45:29.708256+00:00"
+"Directions": "Cross Streets: Fruitland/Lakeview. ** Directions: Fruitland / N Service Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1416926"
+"ListOfficeKey": "276417"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-09T21:49:07Z"
+"PhotosCount": 38
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T21:49:07Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3416"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/462340/branded/4338"
+"WaterBodyName": "Lake Ontario"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29876848/415-600-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1988583"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Properties Ltd"
+"CoListOfficeKey": "283933"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Party Room"
2 => "Visitor Parking"
]
+"LivingAreaMaximum": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-06-09T17:20:08.77Z"
+"ListAgentNationalAssociationId": "1120102"
+"ListOfficeNationalAssociationId": "1274059"
+"CoListAgentNationalAssociationId": "1272681"
+"CoListOfficeNationalAssociationId": "1336950"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876848')"
+"ID": "1511215"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 92
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]