array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29249089/Property?$select=ALL&$top=20&$filter=ListingKey eq 29249089&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29249089/Property?$select=ALL&$top=20&$filter=ListingKey eq 29249089&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "533463"
+post_author: 1
+"ListingKey": "29249089"
+"ListingId": "40798135"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T14:55:25Z"
+"RFModificationTimestamp": "2026-01-14T17:25:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 653.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "600 NORTH SERVICE Road Unit# 419, Hamilton, Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.697041
1 => 43.234195
]
+"Latitude": 43.234195
+"Longitude": -79.697041
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience the epitome of modern coastal living in the newly completed and vibrant CoMo Condos. This beautifully designed 1-bedroom, 1-washroom unit has stunning waterfront views that create a calming ambiance throughout. The spacious layout features a sleek kitchen with a breakfast bar, an enclosed balcony ideal for relaxation, and a generously sized washroom. For added convenience, the unit includes one parking space and one locker. CoMo Condos also has an exceptional amenities such as a pet spa, an off-leash pet area, a media and gaming room, a party room, automated package pick-up, and a rooftop patio perfect for entertaining or unwinding. Ideally located with easy access to highways, schools, shopping, and dining, this home is perfect for those seeking style, comfort, and convenience. Don’t miss your chance to enjoy breathtaking waterfront living every day. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T17:24:56.938712+00:00"
+"Directions": "Lakeview and Fruitland"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525060"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-14T14:49:02Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T14:49:02Z"
+"Stories": "1.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1560239178"
"RoomType" => "Dining room"
"ListingId" => "40798135"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29249089"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T14:49:02.21Z"
]
1 => array:11 [
"RoomKey" => "1560239179"
"RoomType" => "Living room"
"ListingId" => "40798135"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29249089"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T14:49:02.21Z"
]
2 => array:11 [
"RoomKey" => "1560239180"
"RoomType" => "Kitchen"
"ListingId" => "40798135"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29249089"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T14:49:02.21Z"
]
3 => array:11 [
"RoomKey" => "1560239181"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798135"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29249089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T14:49:02.21Z"
]
4 => array:11 [
"RoomKey" => "1560239182"
"RoomType" => "Primary Bedroom"
"ListingId" => "40798135"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29249089"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 10'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T14:49:02.21Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29249089/600-north-service-road-unit-419-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RM3-64, C5"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 653
+"OriginalEntryTimestamp": "2026-01-14T14:49:02.17Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404151333"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/86ae15aa2ea2f1962f94f41717b37c45.webp"
"MediaSize" => 120061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-86ae15aa2ea2f1962f94f41717b37c45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of apartment building / complex"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404151345"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/d59c15f41b05adc5729e06c66645fd0c.webp"
"MediaSize" => 156062
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-d59c15f41b05adc5729e06c66645fd0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of apartment building / complex"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404151367"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/962b580e702be300c550281d7902cecd.webp"
"MediaSize" => 166568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-962b580e702be300c550281d7902cecd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance to property featuring brick siding"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404151375"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/74531ebfbc4b1032ed594e17910d9c9b.webp"
"MediaSize" => 110365
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-74531ebfbc4b1032ed594e17910d9c9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404151383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/1a043fce72de20aecd79c47fa499e658.webp"
"MediaSize" => 122053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-1a043fce72de20aecd79c47fa499e658.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of community lobby"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404151391"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/3c8cd587debeacb1dec3f16bbdc1821d.webp"
"MediaSize" => 73827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-3c8cd587debeacb1dec3f16bbdc1821d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hall with elevator and tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404151429"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/d80ad79c71a87eeb5413447c3d873bb0.webp"
"MediaSize" => 65215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-d80ad79c71a87eeb5413447c3d873bb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hall with recessed lighting and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404151450"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/f50c8cd1d7d166acd5b579de556fd315.webp"
"MediaSize" => 86588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-f50c8cd1d7d166acd5b579de556fd315.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a peninsula, light wood finished floors, white cabinetry, stainless steel dishwasher, and open floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404151473"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/526ce64c46d26401b28a866513e0791c.webp"
"MediaSize" => 93175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-526ce64c46d26401b28a866513e0791c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with a peninsula, white cabinets, dark wood-type flooring, dishwasher, and open floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404151493"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/ae9e50009ddabc242476eb5803e5c3d4.webp"
"MediaSize" => 63118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-ae9e50009ddabc242476eb5803e5c3d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished room featuring light wood-style flooring and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404151522"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/abc625b152f8aea803f5a82c54c36fa1.webp"
"MediaSize" => 45957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-abc625b152f8aea803f5a82c54c36fa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with light countertops, appliances with stainless steel finishes, white cabinets, light wood-type flooring, and a peninsula"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404151603"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/8e0def45285bdfc3da3bd87ff6792ff6.webp"
"MediaSize" => 76222
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-8e0def45285bdfc3da3bd87ff6792ff6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with a textured ceiling and dark wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6404151617"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/6ab1ef803c2f344475b4573be8171a41.webp"
"MediaSize" => 116374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-6ab1ef803c2f344475b4573be8171a41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6404151652"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/74aa460ad3ab2dbab196c032444062bb.webp"
"MediaSize" => 99587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-74aa460ad3ab2dbab196c032444062bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6404151687"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/7a3c9a8f6fed686cd08bf34166b34048.webp"
"MediaSize" => 118199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-7a3c9a8f6fed686cd08bf34166b34048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6404151723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/41511e3038f5222bbf793727085f1f2f.webp"
"MediaSize" => 57274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-41511e3038f5222bbf793727085f1f2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished living room with light wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6404151748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/f32d9121258a8b520777c64e5c9808c5.webp"
"MediaSize" => 86507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-f32d9121258a8b520777c64e5c9808c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area with light wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6404151756"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/e6bf19f387f21a8f7e1dec5243f383d0.webp"
"MediaSize" => 61417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-e6bf19f387f21a8f7e1dec5243f383d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a peninsula, appliances with stainless steel finishes, white cabinets, light wood-style flooring, and modern cabinets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6404151780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/b0f3249b1b2033bc648da22e4a942b4c.webp"
"MediaSize" => 84349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-b0f3249b1b2033bc648da22e4a942b4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with a breakfast bar, stainless steel appliances, decorative light fixtures, light wood-style flooring, and a peninsula"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6404151833"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/7d04e3929cb161948f61b1950f1faab7.webp"
"MediaSize" => 67361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-7d04e3929cb161948f61b1950f1faab7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen with white cabinetry, a peninsula, black appliances, light wood-type flooring, and light stone counters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6404151873"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/cb0f144a3807724a3d983363cdcdc39d.webp"
"MediaSize" => 75284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-cb0f144a3807724a3d983363cdcdc39d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring stainless steel appliances, white cabinets, light wood-style floors, light stone counters, and a peninsula"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6404151980"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/b7d9e04b40de15faa49d93331148478b.webp"
"MediaSize" => 68510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-b7d9e04b40de15faa49d93331148478b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spare room with wood finished floors and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6404152000"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/72d9598bde8f854afed801025a6115d1.webp"
"MediaSize" => 101237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-72d9598bde8f854afed801025a6115d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom with baseboards and wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6404152080"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/9d947bfa0a2a3cedfbd20692e09c4cf6.webp"
"MediaSize" => 92538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-9d947bfa0a2a3cedfbd20692e09c4cf6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Detailed view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6404152140"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/5ff9dc5dda91b1200b7599fb2863699e.webp"
"MediaSize" => 27598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-5ff9dc5dda91b1200b7599fb2863699e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Corridor with light wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6404152188"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/3e56559dd757b63cfc7df3bb5ef8f626.webp"
"MediaSize" => 77111
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-3e56559dd757b63cfc7df3bb5ef8f626.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom with vanity and shower / bathtub combination with curtain"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6404152233"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/34d518558966d00a5ed2d585e5547f7b.webp"
"MediaSize" => 101896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-34d518558966d00a5ed2d585e5547f7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bathroom featuring walk in shower, tile patterned flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6404152285"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/c84fbb4666755426365c33223eb6ec66.webp"
"MediaSize" => 37922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-c84fbb4666755426365c33223eb6ec66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Washroom with stacked washer / dryer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6404152319"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/bafe0fb8eda78d85896e7c21f7cd2804.webp"
"MediaSize" => 49693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-bafe0fb8eda78d85896e7c21f7cd2804.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6404152358"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/eae5c194b4ea228e08b7d632a9571dfc.webp"
"MediaSize" => 101857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-eae5c194b4ea228e08b7d632a9571dfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfurnished bedroom featuring elevator"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6404152365"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/e35aacf7d0b15c7e771a28c12375f561.webp"
"MediaSize" => 82490
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-e35aacf7d0b15c7e771a28c12375f561.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of home's community"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6404152390"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/502e617845b017632b00825e29470356.webp"
"MediaSize" => 94928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-502e617845b017632b00825e29470356.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6404152439"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/2a9b728c12652e4a289bb321ee7c80d6.webp"
"MediaSize" => 110145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-2a9b728c12652e4a289bb321ee7c80d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Indoor dry bar featuring a wooden ceiling with exposed beams, coffered ceiling, hanging light fixtures, and dark brown cabinets"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6404152533"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/773c8e23820f2424e460fcd8821c7e0c.webp"
"MediaSize" => 94360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-773c8e23820f2424e460fcd8821c7e0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6404152563"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/18e15372519ca9ebb4595c9665c63500.webp"
"MediaSize" => 108266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-18e15372519ca9ebb4595c9665c63500.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Common area featuring wooden ceiling and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6404152596"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/5d24259591130994e7007075eecb70aa.webp"
"MediaSize" => 25477
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-5d24259591130994e7007075eecb70aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Detailed view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6404152639"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/ab722e438e9d48925befefe687661b09.webp"
"MediaSize" => 118700
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-ab722e438e9d48925befefe687661b09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of patio"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6404152655"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/8b0ef31a5e841222f386bbb5cbefe5bb.webp"
"MediaSize" => 100895
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-8b0ef31a5e841222f386bbb5cbefe5bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of patio featuring area for grilling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6404152707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/8867441d7004ecea2a95cceba5594710.webp"
"MediaSize" => 129442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-8867441d7004ecea2a95cceba5594710.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Deck with outdoor dining space, a patio, and area for grilling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6404152739"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29249089/2c1190e48679e9c4bd398f0e5e0dbe2a.webp"
"MediaSize" => 112236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29249089/thumbnail-2c1190e48679e9c4bd398f0e5e0dbe2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Water view"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798135"
"ResourceRecordKey" => "29249089"
"ModificationTimestamp" => "2026-01-14T14:49:02.18Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Francesco Russumanno"
"MemberFirstName" => "Francesco"
"MemberLastName" => "Russumanno"
"MemberMlsId" => "HBRUSSUFR"
"OriginatingSystemName" => 26
"MemberKey" => "1525060"
"ModificationTimestamp" => "2026-01-02T18:31:04Z"
"MemberStatus" => "Active"
"OfficeKey" => "67816"
"MemberAOR" => "Cornerstone"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Stoney Creek"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-966-5655"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1135225"
"OfficeNationalAssociationId" => "1132083"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "Royal LePage Macro Realty"
"OfficePhone" => "905-574-3038"
"OfficeMlsId" => "HBRLPMACRO"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "67816"
"ModificationTimestamp" => "2025-07-09T18:17:42Z"
"OfficeAddress1" => "#250-2247 Rymal Road East"
"OfficeCity" => "Stoney Creek"
"OfficePostalCode" => "L8J2V"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"OfficeFax" => "905-574-8333"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OfficeNationalAssociationId" => "1132083"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1064635"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249089')"
+"ID": "533463"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.28 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 67816/Office?$select=ALL&$top=10&$filter=OfficeKey eq 67816&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 67816/Office?$select=ALL&$top=10&$filter=OfficeKey eq 67816&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25330
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage Macro Realty"
+"OfficeEmail": null
+"OfficePhone": "905-574-3038"
+"OfficeMlsId": "HBRLPMACRO"
+"ModificationTimestamp": "2025-07-09T18:17:42Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "67816"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "#250-2247 Rymal Road East"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Stoney Creek"
+"OfficePostalCode": "L8J2V"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1132083"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-574-8333"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439624"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "67816"
"SocialMediaUrlOrId" => "https://www.royallepagemacro.ca/"
"ModificationTimestamp" => "2025-07-09T18:07:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1064635"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('67816')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525060/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525060&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525060/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1525060&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25335
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.26 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29249089" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24947
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29249089/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29249089&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29249089/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29249089&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24929
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29249089 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.697041 43.234195)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29249089 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.697041 43.234195)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29249089 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.697041 43.234195)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29249089 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.697041 43.234195)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24862
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24804
+post_id: "535552"
+post_author: 1
+"ListingKey": "29251089"
+"ListingId": "40798532"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T19:45:51Z"
+"RFModificationTimestamp": "2026-01-15T00:04:47Z"
+"ListPrice": 3100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2841.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0C1"
+"UnparsedAddress": "100 WATERSHORE Drive Unit# 19, Stoney Creek, Ontario L8E0C1"
+"Coordinates": array:2 [
0 => -79.675003
1 => 43.229989
]
+"Latitude": 43.229989
+"Longitude": -79.675003
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't Miss This Rare Lakefront Bungalow on the Shores of Lake Ontario. Welcome to a truly exceptional opportunity— an exquisite 2,841 sq. ft. lakefront bungalow perfectly positioned along the sparkling shoreline of Lake Ontario offering breathtaking panoramic views. This brand-new floor plan has been meticulously crafted to maximize lake views and everyday livability. With 10' ceilings, 8' solid-core interior doors, hardwood floors, upgraded tile throughout, and an elegant oak staircase- this home exudes sophistication. The chef-inspired kitchen is as functional as it is striking, featuring extended-height cabinetry with crown moulding, premium quartz countertops, a stylish backsplash, and a large central island— ideal for both casual meals and upscale entertaining. As a purchaser, you’ll have the rare opportunity to fully customize your finishes at our brand-new design studio, guided by our expert design consultant and curated selection of elevated materials. An open-concept layout anchors the home’s living and dining areas, centered around a 46” gas fireplace with a stained wood beam mantle. Floor-to-ceiling lake-facing windows flood the space with natural light and showcase the unmatched views. Step through to the covered rear patio and enjoy year-round relaxation beside the water. Wake up to panoramic lake views from the luxurious primary bedroom, complete with a spa-like ensuite featuring a freestanding soaker tub, custom glass shower, dual vanities, and quartz countertops. Not to mention two additional bedrooms offering ensuite privilege and premium finishes, and a stylish 2-piece powder room. This home offers both peaceful lakeside living and convenient access to QEW, top-rated schools, shopping, and daily amenities. Enjoy the security of a sloped, granite capped revetment wall designed by a coastal engineer— a premium shoreline upgrade designed to safeguard your investment. *This home is pre-construction. Estimated closing 12 months after purchase. (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T00:04:22.760439+00:00"
+"Directions": "Fruitland to N. Service to Glover to Watershore."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Other"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025165"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T19:38:15Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T19:38:15Z"
+"Stories": "1.0"
+"StreetName": "WATERSHORE"
+"StreetNumber": "100"
+"StreetSuffix": "Drive"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"View": "Lake view"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1560357716"
"RoomType" => "Laundry room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
1 => array:11 [
"RoomKey" => "1560357717"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
2 => array:11 [
"RoomKey" => "1560357718"
"RoomType" => "5pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
3 => array:11 [
"RoomKey" => "1560357719"
"RoomType" => "2pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
4 => array:11 [
"RoomKey" => "1560357720"
"RoomType" => "Den"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
5 => array:11 [
"RoomKey" => "1560357721"
"RoomType" => "Bedroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
6 => array:11 [
"RoomKey" => "1560357722"
"RoomType" => "Bedroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
7 => array:11 [
"RoomKey" => "1560357723"
"RoomType" => "Primary Bedroom"
"ListingId" => "40798532"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "18'0'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
8 => array:11 [
"RoomKey" => "1560357724"
"RoomType" => "Dining room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.15Z"
]
9 => array:11 [
"RoomKey" => "1560357725"
"RoomType" => "Kitchen"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.15Z"
]
10 => array:11 [
"RoomKey" => "1560357726"
"RoomType" => "Living room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "20'8'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.15Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29251089/100-watershore-drive-unit-19-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1986960"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55053"
+"GeocodeManualYN": true
+"ZoningDescription": "R2-66"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2841
+"OriginalEntryTimestamp": "2026-01-14T19:38:15.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404573772"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/2bd6871eee548767ce3cb5fafb7b366f.webp"
"MediaSize" => 83613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-2bd6871eee548767ce3cb5fafb7b366f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404573776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/e8a7696e337da1eb4ce40ebd7f99c45a.webp"
"MediaSize" => 167406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-e8a7696e337da1eb4ce40ebd7f99c45a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404573778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/9cbbdf0d3af16e1f85ea6fd9a72e0cff.webp"
"MediaSize" => 172811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-9cbbdf0d3af16e1f85ea6fd9a72e0cff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404573781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/07251fc8783b3ef0197b92e10af6edbf.webp"
"MediaSize" => 128225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-07251fc8783b3ef0197b92e10af6edbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404573788"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/5469ca2078454c5e5f424f36d3958c25.webp"
"MediaSize" => 137645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-5469ca2078454c5e5f424f36d3958c25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404573792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/b84932083c291312022e39320429c199.webp"
"MediaSize" => 79951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-b84932083c291312022e39320429c199.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inspiration photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404573796"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/14409ce29620198cf31d87bc62d6e496.webp"
"MediaSize" => 85549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-14409ce29620198cf31d87bc62d6e496.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inspiration photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404573801"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/85759c11eb4cdfbfa123570316b24e30.webp"
"MediaSize" => 98054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-85759c11eb4cdfbfa123570316b24e30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inspiration photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404573805"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/21d59776cdab194d5f1c5af373f0aace.webp"
"MediaSize" => 74902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-21d59776cdab194d5f1c5af373f0aace.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404573810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/09aa05aff7cc975c8262cc4b7342b399.webp"
"MediaSize" => 161765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-09aa05aff7cc975c8262cc4b7342b399.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404573814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/073a8f63ad996b203834a6ee9073ebfa.webp"
"MediaSize" => 49718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-073a8f63ad996b203834a6ee9073ebfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404573819"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/7d2c7f43641578cf40a04d6748223aae.webp"
"MediaSize" => 56281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-7d2c7f43641578cf40a04d6748223aae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Deanna Bodden"
"MemberFirstName" => "Deanna"
"MemberLastName" => "Bodden"
"MemberMlsId" => "HBBODDEDE"
"OriginatingSystemName" => 26
"MemberKey" => "2025165"
"ModificationTimestamp" => "2025-10-28T23:23:51Z"
"MemberStatus" => "Active"
"OfficeKey" => "288925"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Ancaster"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-648-4451"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2017-01-20T15:23:00Z"
"MemberNationalAssociationId" => "1304829"
"OfficeNationalAssociationId" => "1372539"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Royal LePage State Realty Inc."
"OfficePhone" => "905-648-4451"
"OfficeMlsId" => "HBRLPSTATEA2"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "288925"
"ModificationTimestamp" => "2025-12-30T03:00:56Z"
"OfficeAddress1" => "1122 Wilson Street W Suite 200"
"OfficeCity" => "Ancaster"
"OfficePostalCode" => "L9G3K"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2020-11-03T19:13:00Z"
"OfficeNationalAssociationId" => "1372539"
"FranchiseNationalAssociationId" => "1230730"
"OfficeBrokerNationalAssociationId" => "1063185"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251089')"
+"ID": "535552"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24856
+post_id: "534950"
+post_author: 1
+"ListingKey": "29251667"
+"ListingId": "X12696554"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T20:56:05Z"
+"RFModificationTimestamp": "2026-01-14T23:21:02Z"
+"ListPrice": 3100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0C1"
+"UnparsedAddress": "19 - 100 WATERSHORE DRIVE, Hamilton (Stoney Creek), Ontario L8E0C1"
+"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": "Don't Miss This Rare Lakefront Bungalow on the Shores of Lake Ontario. Welcome to a truly exceptional opportunity- an exquisite 2,841 sq. ft. lakefront bungalow perfectly positioned along the sparkling shoreline of Lake Ontario offering breathtaking panoramic views. This brand-new floor plan has been meticulously crafted to maximize lake views and everyday livability. With 10' ceilings, 8' solid-core interior doors, hardwood floors, upgraded tile throughout, and an elegant oak staircase- this home exudes sophistication. The chef-inspired kitchen is as functional as it is striking, featuring extended-height cabinetry with crown moulding, premium quartz countertops, a stylish backsplash, and a large central island- ideal for both casual meals and upscale entertaining. As a purchaser, you'll have the rare opportunity to fully customize your finishes at our brand-new design studio, guided by our expert design consultant and curated selection of elevated materials. An open-concept layout anchors the home's living and dining areas, centered around a 46" gas fireplace with a stained wood beam mantle. Floor-to-ceiling lake-facing windows flood the space with natural light and showcase the unmatched views. Step through to the covered rear patio and enjoy year-round relaxation beside the water. Wake up to panoramic lake views from the luxurious primary bedroom, complete with a spa-like ensuite featuring a freestanding soaker tub, custom glass shower, dual vanities, and quartz countertops. Not to mention two additional bedrooms offering ensuite privilege and premium finishes, and a stylish 2-piece powder room. This home offers both peaceful lakeside living and convenient access to QEW, top-rated schools, shopping, and daily amenities. Enjoy the security of a sloped, granite capped revetment wall designed by a coastal engineer- a premium shoreline upgrade designed to safeguard your investment. *This home is pre-construction. Estimated closing 12 months after purchase. (id:62650)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T23:20:40.192642+00:00"
+"Directions": "Cross Streets: Watershore & Aquamarine. ** Directions: Fruitland to N. Service to Glover to Watershore."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2234697"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "In suite Laundry"
2 => "Sump Pump"
]
+"LotSizeDimensions": "."
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T20:47:44Z"
+"PhotosCount": 12
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T20:47:44Z"
+"Stories": "1.0"
+"StreetName": "Watershore"
+"StreetNumber": "100"
+"StreetSuffix": "Drive"
+"View": "Lake view,View of water,Direct Water View"
+"WaterBodyName": "Lake Ontario"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1560390237"
"RoomType" => "Living room"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 6.1
"ListingKey" => "29251667"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.83Z"
]
1 => array:11 [
"RoomKey" => "1560390238"
"RoomType" => "Kitchen"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 4.27
"ListingKey" => "29251667"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.83Z"
]
2 => array:11 [
"RoomKey" => "1560390239"
"RoomType" => "Dining room"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 5.79
"ListingKey" => "29251667"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.84Z"
]
3 => array:11 [
"RoomKey" => "1560390240"
"RoomType" => "Den"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29251667"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.84Z"
]
4 => array:11 [
"RoomKey" => "1560390241"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 5.49
"ListingKey" => "29251667"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.85Z"
]
5 => array:11 [
"RoomKey" => "1560390242"
"RoomType" => "Bedroom 2"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29251667"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.85Z"
]
6 => array:11 [
"RoomKey" => "1560390243"
"RoomType" => "Bedroom 3"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29251667"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.86Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29251667/19-100-watershore-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2999
+"LivingAreaMinimum": 2750
+"ZoningDescription": "R2-66"
+"BedroomsAboveGrade": 3
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"OriginalEntryTimestamp": "2026-01-14T20:47:44.78Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404691322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/647ead6954a5f0111ca2417157bbd68f.webp"
"MediaSize" => 86387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-647ead6954a5f0111ca2417157bbd68f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
…3
]
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]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251667')"
+"ID": "534950"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25176
+post_id: "534850"
+post_author: 1
+"ListingKey": "29252026"
+"ListingId": "X12696964"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:55:43Z"
+"RFModificationTimestamp": "2026-01-14T22:52:09Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E5W8"
+"UnparsedAddress": "469 DEWITT ROAD, Hamilton (Stoney Creek), Ontario L8E5W8"
+"Coordinates": array:2 [
0 => -79.705193
1 => 43.234605
]
+"Latitude": 43.234605
+"Longitude": -79.705193
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright and cheerful freehold, end-unit 2 storey townhouse designed to feel like a semi-detached. Just steps away from the Lake, it offers amazing views from the deck, living room and master bedroom. The large lot boasts great curb appeal, and a spacious layout that includes direct access to the garage and a practical open concept floor plan. The large deck, off the kitchen, spans the back of the house, ideal for entertaining, bbqs and relaxation. The second floor open concept family room features gleaming hardwood floors, large windows that allow lots of sunshine; and it can potentially be converted into a 3rd bedroom. The finished basement has so much more potential, it contains abundant storage space, the laundry room, a cold cellar and a 2 piece bathroom. It is the location that makes this home so desirable! This home awaits your creative touch! Do not miss this great opportunity! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T22:51:51.592966+00:00"
+"Directions": "Cross Streets: North Service Road. ** Directions: QEW to Centennial, right on Service Rd, Left on Dewitt."
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1405690"
+"ListOfficeKey": "271789"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.2 x 101.7 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T21:45:59Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:45:59Z"
+"Stories": "2.0"
+"StreetName": "Dewitt"
+"StreetNumber": "469"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4952.39"
+"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": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252026/469-dewitt-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 32.2
+"OriginalEntryTimestamp": "2026-01-14T21:45:59.36Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"Member": []
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252026')"
+"ID": "534850"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24875
+post_id: "533893"
+post_author: 1
+"ListingKey": "29249920"
+"ListingId": "X12694942"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:05:38Z"
+"RFModificationTimestamp": "2026-01-14T19:42:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "306 - 600 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This sophisticated 1-bedroom residence is situated on the third floor of a nearly new boutique condominium. A rare opportunity, it includes an owned parking space and a secure storage locker for exceptional convenience. Inside, you'll find soaring ceilings, abundant natural light, upgraded designer lighting, and a thoughtfully crafted open-concept layout tailored for contemporary living. The inviting entryway offers a full-sized closet for coats and additional storage. The bright, well-appointed kitchen features ample counter space, stainless steel appliances, and a generous peninsula ideal for meal preparation or casual dining. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Central Vacuum"
2 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T19:42:23.816818+00:00"
+"Directions": "FRUITLAND RD & NORTH SERVICE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127500"
+"ListOfficeKey": "274354"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T16:56:17Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T16:56:17Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29249920/306-600-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Properties Ltd"
+"GeocodeManualYN": false
+"TotalActualRent": 2000
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-14T16:56:17.07Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:21 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249920')"
+"ID": "533893"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24797
+post_id: "533981"
+post_author: 1
+"ListingKey": "29250796"
+"ListingId": "X12695858"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T19:00:27Z"
+"RFModificationTimestamp": "2026-01-14T19:36:10Z"
+"ListPrice": 459000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0K3"
+"UnparsedAddress": "227 - 125 SHOREVIEW PLACE, Hamilton (Lakeshore), Ontario L8E0K3"
+"Coordinates": array:2 [
0 => -79.720692
1 => 43.238951
]
+"Latitude": 43.238951
+"Longitude": -79.720692
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover Lakeside Living. This bright and beautiful designed 564 sq. ft. condo offers an inviting open-concept layout. Large windows that fill the space with natural and peaceful views of the lake. Master Bed features a walk - in -closet. Enjoy the convenience of in-suite laundry and building amenities, including a modern gym, party room and rooftop. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
]
+"AssociationFee": "448.04"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T19:36:03.696242+00:00"
+"Directions": "Cross Streets: Millen Rd/Shoreview Pl. ** Directions: From north Service Rd turn south on Millen Rd and right onto Shoreview Pl."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1528247"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-14T18:46:47Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T18:46:47Z"
+"StreetName": "Shoreview"
+"StreetNumber": "125"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2772"
+"View": "Lake view"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29250796/227-125-shoreview-place-hamilton-lakeshore-lakeshore"
+"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-01-14T18:46:47.67Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:8 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29250796')"
+"ID": "533981"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24881
+post_id: "532252"
+post_author: 1
+"ListingKey": "29247006"
+"ListingId": "40797950"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T20:55:46Z"
+"RFModificationTimestamp": "2026-01-13T23:23:11Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1064.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5V2"
+"UnparsedAddress": "610 BARTON Street Unit# 46, Stoney Creek, Ontario L8E5V2"
+"Coordinates": array:2 [
0 => -79.703288
1 => 43.2221018
]
+"Latitude": 43.2221018
+"Longitude": -79.703288
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Gorgeous end-unit townhouse in a fantastic Stoney Creek location! Just minutes to the QEW (Fruitland) and close to schools, parks, restaurants, and all amenities. This home is extremely well maintained, spotless, and loaded with updates. Stunning open-concept kitchen featuring white soft-close cabinetry, quartz countertops, backsplash, centre island, and wine fridge—perfect for everyday living and entertaining. Updated bathrooms, ceramic and hardwood flooring, pot lights, California shutters, and convenient inside entry from the garage. Major updates include furnace and A/C (August 2022) and a garage door opener (August 2022). Unspoiled unfinished basement offers endless potential. Enjoy a private rear yard surrounded by trees with patio, deck, and professional landscaping. Outstanding location, great complex—shows 10+! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "324.96"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:22:55.259352+00:00"
+"Directions": "Fruitland Rd to Barton St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524652"
+"ListOfficeKey": "294490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T20:48:53Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T20:48:53Z"
+"Stories": "2.0"
+"StreetName": "BARTON"
+"StreetNumber": "610"
+"StreetSuffix": "Street"
+"SubdivisionName": "512 - Guernsey/Westmeria/Industrial"
+"TaxAnnualAmount": "3432.5"
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/610bartonstreetl8e5v2"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29247006/610-barton-street-unit-46-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1910452"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "294490"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1064
+"OriginalEntryTimestamp": "2026-01-13T20:48:53.7Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:43 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247006')"
+"ID": "532252"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "532460"
+post_author: 1
+"ListingKey": "29247190"
+"ListingId": "40798194"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T21:25:19Z"
+"RFModificationTimestamp": "2026-01-13T23:03:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 806.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5A7"
+"UnparsedAddress": "600 NORTH SERVICE Road Unit# 309, Stoney Creek, Ontario L8E5A7"
+"Coordinates": array:2 [
0 => -79.697019
1 => 43.234159
]
+"Latitude": 43.234159
+"Longitude": -79.697019
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic 2 bedroom corner unit with large bright windows with lake view. Located on 3rd floor, unit comes with 2 parking spaces. Open style kitchen and living room, 2 baths, large balcony, numerous amenities. parking space under ground #42, parking space above ground #265. Looking for A+++ tenant. Rental application, pay stubs & photo ID, up-to-date Equifax credit report, employment letter, reference letter, bank statement. No smoking. Tenant pays all utilities. Tenants need tenant insurance. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:03:24.375923+00:00"
+"Directions": "Fruitland Rd and North Service Rd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524358"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Corner Site"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-13T21:21:08Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T21:21:08Z"
+"Stories": "1.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4135"
+"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/29247190/600-north-service-road-unit-309-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2495
+"ZoningDescription": "C5, RM3-64"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 806
+"OriginalEntryTimestamp": "2026-01-13T21:18:57.99Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:12 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247190')"
+"ID": "532460"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24870
+post_id: "532253"
+post_author: 1
+"ListingKey": "29247330"
+"ListingId": "X12692886"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T21:50:37Z"
+"RFModificationTimestamp": "2026-01-13T22:51:08Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E5V2"
+"UnparsedAddress": "46 - 610 BARTON STREET, Hamilton (Stoney Creek), Ontario L8E5V2"
+"Coordinates": array:2 [
0 => -79.703296
1 => 43.222185
]
+"Latitude": 43.222185
+"Longitude": -79.703296
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Gorgeous end-unit townhouse in a fantastic Stoney Creek location! Just minutes to the QEW (Fruitland) and close to schools, parks, restaurants, and all amenities. This home is extremely well maintained, spotless, and loaded with updates. Stunning open-concept kitchen featuring white soft-close cabinetry, quartz countertops, backsplash, centre island, and wine fridge-perfect for everyday living and entertaining. Updated bathrooms, ceramic and hardwood flooring, pot lights, California shutters, and convenient inside entry from the garage. Major updates include furnace and A/C (August 2022) and a garage door opener (August 2022). Unspoiled unfinished basement offers endless potential. Enjoy a private rear yard surrounded by trees with patio, deck, and professional landscaping. Outstanding location, great complex-shows 10+! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "324.96"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T22:50:45.105628+00:00"
+"Directions": "Cross Streets: Fruitland Rd. ** Directions: Fruitland Rd to Barton St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038160"
+"ListOfficeKey": "280315"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T21:40:39Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T21:40:39Z"
+"Stories": "2.0"
+"StreetName": "Barton"
+"StreetNumber": "610"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3432.5"
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/mls/227708841"
+"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"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29247330/46-610-barton-street-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2106038"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"CoListOfficeKey": "280315"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-01-13T21:40:39.2Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
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]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247330')"
+"ID": "532253"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24869
+post_id: "531722"
+post_author: 1
+"ListingKey": "29247455"
+"ListingId": "X12693050"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T22:20:50Z"
+"RFModificationTimestamp": "2026-01-13T22:32:08Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E5A7"
+"UnparsedAddress": "309 - 600 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E5A7"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic 2 bedroom corner unit with large bright windows with lake view. Located on 3rd floor, unit comes with 2 parking spaces. Open style kitchen and living room, 2 baths, large balcony, numerous amenities. parking space under ground #42, parking space above ground #265. Looking for A+++ tenant. Rental application, pay stubs & photo ID, up-to-date Equifax credit report, employment letter, reference letter, bank statement. No smoking. Tenant pays all utilities. Tenants need tenant insurance. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T22:31:50.312880+00:00"
+"Directions": "Cross Streets: Fruitland Road. ** Directions: Fruitland Rd and North Service Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2163724"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T22:11:25Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T22:11:25Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29247455/309-600-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2495
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-13T22:11:25.42Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
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]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247455')"
+"ID": "531722"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 114
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]