array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29103319/Property?$select=ALL&$top=20&$filter=ListingKey eq 29103319&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29103319/Property?$select=ALL&$top=20&$filter=ListingKey eq 29103319&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23619
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23621
+post_id: "421365"
+post_author: 1
+"ListingKey": "29103319"
+"ListingId": "X12544404"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-18T17:10:11Z"
+"RFModificationTimestamp": "2025-11-18T17:15:27Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0J3"
+"UnparsedAddress": "18 LAKESHORE DRIVE, Hamilton (Lakeshore), Ontario L8E0J3"
+"Coordinates": array:2 [
0 => -79.674449
1 => 43.229798
]
+"Latitude": 43.229798
+"Longitude": -79.674449
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Executive Picturesque Lakeside Community Townhouse. This stunning townhouse offers 2 bedrooms+den. The open-concept main floor, with 9ft ceilings, is flooded with natural light and Freshly painted features a modern kitchen with stainless steel appliances, a spacious living room, adining area, a 2-piece bath, and a walkout balcony. The third floor includes 2 large bedrooms,bedroom-level laundry, and a 4-piece bath. Additionally, the home boasts a single-car garage with inside entry to a large welcoming foyer. Located minutes from QEW, Confederation GoStation , Park, Winona Crossing Shopping Centre, and Costco, and within walking distance to the public beach, parks, and trails. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Water meter"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Water Heater"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-17T10:23:13.790789+00:00"
+"Directions": "Southshore Cres/Lakefront Dr"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Facing"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2019468"
+"ListOfficeKey": "51454"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Carpet Free"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-14T16:04:06Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-18T16:57:41Z"
+"Stories": "3.0"
+"StreetName": "Lakefront"
+"StreetNumber": "18"
+"StreetSuffix": "Drive"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "Lake view,View,View of water"
+"VirtualTourURLUnbranded": "https://sites.odyssey3d.ca/mls/221432406"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1536310056"
"RoomType" => "Den"
"ListingId" => "X12544404"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29103319"
"RoomLength" => 3.15
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-18T16:57:41.93Z"
]
1 => array:11 [
"RoomKey" => "1536310057"
"RoomType" => "Kitchen"
"ListingId" => "X12544404"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29103319"
"RoomLength" => 2.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-18T16:57:41.94Z"
]
2 => array:11 [
"RoomKey" => "1536310058"
"RoomType" => "Living room"
"ListingId" => "X12544404"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "29103319"
"RoomLength" => 4.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-18T16:57:41.95Z"
]
3 => array:11 [
"RoomKey" => "1536310059"
"RoomType" => "Dining room"
"ListingId" => "X12544404"
"RoomLevel" => "Second level"
"RoomWidth" => 3.84
"ListingKey" => "29103319"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-18T16:57:41.98Z"
]
4 => array:11 [
"RoomKey" => "1536310060"
"RoomType" => "Bathroom"
"ListingId" => "X12544404"
"RoomLevel" => "Second level"
"RoomWidth" => 1.8
"ListingKey" => "29103319"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-18T16:57:41.99Z"
]
5 => array:11 [
"RoomKey" => "1536310061"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12544404"
"RoomLevel" => "Third level"
"RoomWidth" => 3.35
"ListingKey" => "29103319"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-18T16:57:42Z"
]
6 => array:11 [
"RoomKey" => "1536310062"
"RoomType" => "Bedroom 2"
"ListingId" => "X12544404"
"RoomLevel" => "Third level"
"RoomWidth" => 2.79
"ListingKey" => "29103319"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-18T16:57:42.01Z"
]
7 => array:11 [
"RoomKey" => "1536310063"
"RoomType" => "Bathroom"
"ListingId" => "X12544404"
"RoomLevel" => "Third level"
"RoomWidth" => 2.0
"ListingKey" => "29103319"
"RoomLength" => 2.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-18T16:57:42.02Z"
]
8 => array:11 [
"RoomKey" => "1536310064"
"RoomType" => "Laundry room"
"ListingId" => "X12544404"
"RoomLevel" => "Third level"
"RoomWidth" => 1.0
"ListingKey" => "29103319"
"RoomLength" => 1.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-11-18T16:57:42.03Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29103319/18-lakefront-drive-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"TotalActualRent": 2600
+"BuildingFeatures": array:1 [
0 => "Separate Electricity Meters"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-11-14T16:04:06.26Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:35 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6327200296"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/d5bcc9f753954a09635b7e24577401ac.webp"
"MediaSize" => 272923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-d5bcc9f753954a09635b7e24577401ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6327200354"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/6f3bdaafb7061fd1833fa36790449a2f.webp"
"MediaSize" => 255508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-6f3bdaafb7061fd1833fa36790449a2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6327200477"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/a018099bee090dff07ab2dc23bb53a06.webp"
"MediaSize" => 280534
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-a018099bee090dff07ab2dc23bb53a06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6327200498"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/d5589eaa523cac0d5575b7960d271eee.webp"
"MediaSize" => 312518
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-d5589eaa523cac0d5575b7960d271eee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6327200517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/cd0a881a3ae5f3b63395f7d6e60de060.webp"
"MediaSize" => 147148
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-cd0a881a3ae5f3b63395f7d6e60de060.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6327200520"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/da6cc8f56065e37b30edba305ec71eca.webp"
"MediaSize" => 117949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-da6cc8f56065e37b30edba305ec71eca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6327200531"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/1cc92cdae0da360e05fa3bfee970e3c5.webp"
"MediaSize" => 178683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-1cc92cdae0da360e05fa3bfee970e3c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6327200552"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/3e56c09a945ad9172b411a6fa325832e.webp"
"MediaSize" => 223359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-3e56c09a945ad9172b411a6fa325832e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6327200569"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/e9b8149fb28a5d6113918f2d5d16cab2.webp"
"MediaSize" => 205267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-e9b8149fb28a5d6113918f2d5d16cab2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6327200598"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/1874287ae4d7fc51d282f3bce0276201.webp"
"MediaSize" => 217065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-1874287ae4d7fc51d282f3bce0276201.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6327200627"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/9c306b860984107a05b6112d140dbdeb.webp"
"MediaSize" => 175236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-9c306b860984107a05b6112d140dbdeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6327200634"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/180938e09979be324491420ceccba13c.webp"
"MediaSize" => 149830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-180938e09979be324491420ceccba13c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6327200658"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/25bc0adbf2b35c898778a8ddc2766c2d.webp"
"MediaSize" => 214624
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-25bc0adbf2b35c898778a8ddc2766c2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6327200679"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/2577d9357d75c656164a8aef6e4596f0.webp"
"MediaSize" => 173707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-2577d9357d75c656164a8aef6e4596f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6327200692"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/c45967778d6166edd49d8bae2ac01f57.webp"
"MediaSize" => 190235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-c45967778d6166edd49d8bae2ac01f57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6327200696"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/0724d7ec5f8c0182342578e79f549fdd.webp"
"MediaSize" => 209861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-0724d7ec5f8c0182342578e79f549fdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6327200705"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/46f133c71477a311a244e0745bda7b8c.webp"
"MediaSize" => 183984
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-46f133c71477a311a244e0745bda7b8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6327200715"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/1c0a6ca6e9335ae4596fb682d7a5e337.webp"
"MediaSize" => 98609
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-1c0a6ca6e9335ae4596fb682d7a5e337.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6327200718"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/30b19dc9741cdf89d5477d15a1758d97.webp"
"MediaSize" => 154249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-30b19dc9741cdf89d5477d15a1758d97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6327200724"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/b41d3c06c272bd4f1a73973919848183.webp"
"MediaSize" => 159995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-b41d3c06c272bd4f1a73973919848183.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6327200728"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/65759d04d45759b530cc6807fd85cb42.webp"
"MediaSize" => 189130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-65759d04d45759b530cc6807fd85cb42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6327200752"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/decd4e70470908d84affd00b9b9b2a42.webp"
"MediaSize" => 162812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-decd4e70470908d84affd00b9b9b2a42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6327200761"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/aee602fdff7c27a67cb46f1294a0c83a.webp"
"MediaSize" => 190996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-aee602fdff7c27a67cb46f1294a0c83a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6327200778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/6640cb30109a923c36b9d7f9d51a5609.webp"
"MediaSize" => 194358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-6640cb30109a923c36b9d7f9d51a5609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6327200780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/ff41004147e5645befa690048d9d7705.webp"
"MediaSize" => 134277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-ff41004147e5645befa690048d9d7705.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6327200787"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/b625e0bc72541e529c66a038cbc567c2.webp"
"MediaSize" => 269573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-b625e0bc72541e529c66a038cbc567c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6327200788"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/0b9059daa1bddeeb095e1964dd190328.webp"
"MediaSize" => 370713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-0b9059daa1bddeeb095e1964dd190328.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6327200800"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/c202bf23fa8ac26dfcb2fae77f7d448b.webp"
"MediaSize" => 442363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-c202bf23fa8ac26dfcb2fae77f7d448b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6327200813"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/9fb2f804e0c1d326fdf5ad1863fcb3d4.webp"
"MediaSize" => 380619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-9fb2f804e0c1d326fdf5ad1863fcb3d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6327200833"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/f5b437a441a1cb824ba54a3b9dd1f29e.webp"
"MediaSize" => 350209
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-f5b437a441a1cb824ba54a3b9dd1f29e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6327200853"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/6d10a51a4d0c377f5ba8a352770de16c.webp"
"MediaSize" => 360814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-6d10a51a4d0c377f5ba8a352770de16c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6327200865"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/1d4a355fadba1ee5367ec8674512b6a6.webp"
"MediaSize" => 416387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-1d4a355fadba1ee5367ec8674512b6a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6327200876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/b50f18d69e8a5b46ea9ae8cf9155041c.webp"
"MediaSize" => 361686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-b50f18d69e8a5b46ea9ae8cf9155041c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6327200884"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/1c0a72bd9ae36c842320acf31a938091.webp"
"MediaSize" => 333252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-1c0a72bd9ae36c842320acf31a938091.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6327200891"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29103319/4ab934db104ab684d70668b6fb8e610e.webp"
"MediaSize" => 262208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29103319/thumbnail-4ab934db104ab684d70668b6fb8e610e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12544404"
"ResourceRecordKey" => "29103319"
"ModificationTimestamp" => "2025-11-14T16:04:06.26Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "WAAD TAHA"
"MemberFirstName" => "WAAD"
"MemberLastName" => "TAHA"
"MemberMlsId" => "9573300"
"OriginatingSystemName" => 26
"MemberKey" => "2019468"
"ModificationTimestamp" => "2025-11-19T21:05:01Z"
"MemberStatus" => "Active"
"OfficeKey" => "51454"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:1 [ …1]
"MemberDesignation" => array:1 [ …1]
"MemberOfficePhone" => "905-844-5000"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2016-10-01T00:39:00Z"
"MemberNationalAssociationId" => "1299478"
"OfficeNationalAssociationId" => "1001135"
]
]
+"Office": array:1 [
0 => array:22 [
"OfficeName" => "SUTTON GROUP QUANTUM REALTY INC."
"OfficePhone" => "905-844-5000"
"OfficeMlsId" => "102302"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "51454"
"ModificationTimestamp" => "2025-11-19T16:48:16Z"
"OfficeAddress1" => "1673B LAKESHORE RD.W."
"OfficeAddress2" => "LOWER LEVL"
"OfficeCity" => "MISSISSAUGA"
"OfficePostalCode" => "L5J1J"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "905-822-5617"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OfficeNationalAssociationId" => "1001135"
"FranchiseNationalAssociationId" => "1176600"
"OfficeBrokerNationalAssociationId" => "1062293"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29103319')"
+"ID": "421365"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 51454/Office?$select=ALL&$top=10&$filter=OfficeKey eq 51454&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 51454/Office?$select=ALL&$top=10&$filter=OfficeKey eq 51454&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25461
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25463
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "SUTTON GROUP QUANTUM REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-844-5000"
+"OfficeMlsId": "102302"
+"ModificationTimestamp": "2025-11-19T16:48:16Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "51454"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1673B LAKESHORE RD.W."
+"OfficeAddress2": "LOWER LEVL"
+"OfficeBrokerKey": null
+"OfficeCity": "MISSISSAUGA"
+"OfficePostalCode": "L5J1J"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1001135"
+"OriginalEntryTimestamp": null
+"OfficeFax": "905-822-5617"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1176600"
+"OfficeBrokerNationalAssociationId": "1062293"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('51454')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2019468/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2019468&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2019468/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2019468&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25466
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29103319" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25055
+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 29103319/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29103319&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29103319/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29103319&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25009
+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 29103319 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.674449 43.229798)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29103319 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.674449 43.229798)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29103319 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.674449 43.229798)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29103319 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.674449 43.229798)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25314
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24946
+post_id: "470330"
+post_author: 1
+"ListingKey": "29173172"
+"ListingId": "X12611600"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-09T02:50:26Z"
+"RFModificationTimestamp": "2025-12-09T03:26:43Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "590 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.697415
1 => 43.234285
]
+"Latitude": 43.234285
+"Longitude": -79.697415
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover the perfect blend of modern living and natural beauty in this stunning townhome located in the sought-after Stoney Creek area. this home offers a bright and spacious living area, complete with a stylish kitchen featuring granite countertop and sleek stainless-steel appliances. Step out onto a beautiful balcony from the inviting living and dining room, perfect for enjoying the scenery. Upper floor features Aden with skylight and laundry. Deep/Appropriately cleaned. Convenient location close to QEW, go station, shopping and steps away from Lake Ontario. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-09T03:26:23.676827+00:00"
+"Directions": "Qew/Fruitland/North Service"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080235"
+"ListOfficeKey": "65275"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "20.4 x 40.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-09T02:45:10Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-09T02:45:10Z"
+"Stories": "3.0"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1547011439"
"RoomType" => "Foyer"
"ListingId" => "X12611600"
"RoomLevel" => "Ground level"
"RoomWidth" => 0.0
"ListingKey" => "29173172"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
1 => array:11 [
"RoomKey" => "1547011440"
"RoomType" => "Other"
"ListingId" => "X12611600"
"RoomLevel" => "Second level"
"RoomWidth" => 2.26
"ListingKey" => "29173172"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
2 => array:11 [
"RoomKey" => "1547011441"
"RoomType" => "Dining room"
"ListingId" => "X12611600"
"RoomLevel" => "Second level"
"RoomWidth" => 2.41
"ListingKey" => "29173172"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
3 => array:11 [
"RoomKey" => "1547011442"
"RoomType" => "Living room"
"ListingId" => "X12611600"
"RoomLevel" => "Second level"
"RoomWidth" => 3.54
"ListingKey" => "29173172"
"RoomLength" => 4.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
4 => array:11 [
"RoomKey" => "1547011443"
"RoomType" => "Kitchen"
"ListingId" => "X12611600"
"RoomLevel" => "Second level"
"RoomWidth" => 2.26
"ListingKey" => "29173172"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
5 => array:11 [
"RoomKey" => "1547011444"
"RoomType" => "Den"
"ListingId" => "X12611600"
"RoomLevel" => "Third level"
"RoomWidth" => 2.8
"ListingKey" => "29173172"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
6 => array:11 [
"RoomKey" => "1547011445"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12611600"
"RoomLevel" => "Third level"
"RoomWidth" => 3.05
"ListingKey" => "29173172"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
7 => array:11 [
"RoomKey" => "1547011446"
"RoomType" => "Bedroom 2"
"ListingId" => "X12611600"
"RoomLevel" => "Third level"
"RoomWidth" => 2.83
"ListingKey" => "29173172"
"RoomLength" => 3.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
8 => array:11 [
"RoomKey" => "1547011447"
"RoomType" => "Laundry room"
"ListingId" => "X12611600"
"RoomLevel" => "Third level"
"RoomWidth" => 0.0
"ListingKey" => "29173172"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
9 => array:11 [
"RoomKey" => "1547011448"
"RoomType" => "Bathroom"
"ListingId" => "X12611600"
"RoomLevel" => "Third level"
"RoomWidth" => 0.0
"ListingKey" => "29173172"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-09T02:45:10.56Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29173172/590-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2400
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 20.4
+"OriginalEntryTimestamp": "2025-12-09T02:45:10.53Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:19 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6362299406"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/c3490516d5ef264ae1e49e10e933bbb4.webp"
"MediaSize" => 161212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-c3490516d5ef264ae1e49e10e933bbb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6362299412"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/c3b4cb3fcaef36b84c7f025b8accafbb.webp"
"MediaSize" => 59443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-c3b4cb3fcaef36b84c7f025b8accafbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6362299422"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/749e99083e3b90b335db67f09a59d1e6.webp"
"MediaSize" => 108162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-749e99083e3b90b335db67f09a59d1e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6362299427"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/3bcae2bcb755f1c94cf7733e6671ceae.webp"
"MediaSize" => 80900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-3bcae2bcb755f1c94cf7733e6671ceae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6362299433"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/88b497de53e64c898f305b3ac7b9c1b7.webp"
"MediaSize" => 91373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-88b497de53e64c898f305b3ac7b9c1b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6362299438"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/ab7a40a8e37f06f885cdad51f162d562.webp"
"MediaSize" => 86933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-ab7a40a8e37f06f885cdad51f162d562.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6362299445"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/06ee26627f7087e3d59a14eb20384ff6.webp"
"MediaSize" => 102553
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-06ee26627f7087e3d59a14eb20384ff6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6362299451"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/2c97d3bf4cf173291d2af7e512f67e74.webp"
"MediaSize" => 99698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-2c97d3bf4cf173291d2af7e512f67e74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6362299458"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/34bcc2fd8827ba6042a2b8a49cbf3cc2.webp"
"MediaSize" => 86547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-34bcc2fd8827ba6042a2b8a49cbf3cc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6362299464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/a6158c1b35fb48ba4c44e1276cea1e40.webp"
"MediaSize" => 55296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-a6158c1b35fb48ba4c44e1276cea1e40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6362299468"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/4fa7d6bfcc36e658653846f0fc2cac69.webp"
"MediaSize" => 81307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-4fa7d6bfcc36e658653846f0fc2cac69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6362299473"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/609679907971efcaf401b740af97db57.webp"
"MediaSize" => 95212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-609679907971efcaf401b740af97db57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6362299475"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/2ecb3a0d3621cbd8ca521e09b608422b.webp"
"MediaSize" => 103805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-2ecb3a0d3621cbd8ca521e09b608422b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6362299485"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/cfca7613953a0860d28337336a91207b.webp"
"MediaSize" => 96739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-cfca7613953a0860d28337336a91207b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6362299492"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/eeeef60c24a45a7a28688be81a41382d.webp"
"MediaSize" => 55073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-eeeef60c24a45a7a28688be81a41382d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6362299496"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/9977f44eb49fd84e35c62217512ec952.webp"
"MediaSize" => 106142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-9977f44eb49fd84e35c62217512ec952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6362299502"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/019535503e25a54dd27cc8334ff740ed.webp"
"MediaSize" => 57838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-019535503e25a54dd27cc8334ff740ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6362299507"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/54412617526d6d6c25ba5657775f685d.webp"
"MediaSize" => 186240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29173172/thumbnail-54412617526d6d6c25ba5657775f685d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12611600"
"ResourceRecordKey" => "29173172"
"ModificationTimestamp" => "2025-12-09T02:45:10.54Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6362299511"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29173172/97bfe9cee94e1cd8db465c5c4172b232.webp"
"MediaSize" => 173753
"MediaType" => "webp"
…8
]
]
+"Member": array:1 [
0 => array:24 [ …24]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29173172')"
+"ID": "470330"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25310
+post_id: "469018"
+post_author: 1
+"ListingKey": "29170229"
+"ListingId": "X12608808"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-08T12:55:34Z"
+"RFModificationTimestamp": "2025-12-08T19:52:45Z"
+"ListPrice": 749888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0G1"
+"UnparsedAddress": "18 - 45 SEABREEZE CRESCENT, Hamilton (Lakeshore), Ontario L8E0G1"
+"Coordinates": array:2 [
0 => -79.66767
1 => 43.225385
]
+"Latitude": 43.225385
+"Longitude": -79.66767
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to this beautiful 3-bed, 2.5-bath townhouse offering over 2,000 sq. ft. of finished living space in one of the area's most convenient locations. The main floor features a bright, open-concept layout with fantastic flow-perfect for everyday living and entertaining. Upstairs, you'll find three generously sized bedrooms, including a comfortable primary retreat.The finished basement adds even more versatility, giving you the freedom to create a rec room, home office, gym, or play area-whatever suits your lifestyle. Located just steps from the lake and moments from the QEW, this home combines comfort, space, and unbeatable convenience. A perfect opportunity for families, commuters, or anyone looking for a well-designed home in a prime location. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
]
+"AssociationFee": "153.41"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-08T19:52:32.192484+00:00"
+"Directions": "McNeilly Rd to Seabreeze Cres"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104847"
+"ListOfficeKey": "292096"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.3 x 83.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-08T12:44:51Z"
+"PhotosCount": 29
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-08T12:44:51Z"
+"Stories": "2.0"
+"StreetName": "SEABREEZE"
+"StreetNumber": "45"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4642.07"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Lakeshore"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29170229/18-45-seabreeze-crescent-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 19.3
+"OriginalEntryTimestamp": "2025-12-08T12:44:51.16Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:29 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29170229')"
+"ID": "469018"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25329
+post_id: "466361"
+post_author: 1
+"ListingKey": "29168066"
+"ListingId": "X12606504"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-06T02:00:27Z"
+"RFModificationTimestamp": "2025-12-06T02:04:54Z"
+"ListPrice": 429000.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, ideally positioned directly across from the sparkling shores of Lake Ontario. 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. The sun-filled living area seamlessly access to private balcony-an ideal spot to unwind and enjoy the outdoors. A stylish 4-piece bathroom and in-suite laundry enhance everyday comfort. The pet-friendly building offers a selection of premium amenities, including a media room, event lounge, pet spa, visitor parking, and a rooftop terrace complete with BBQs and lounge seating-perfect for entertaining or taking in the lake views. Nestled in a vibrant lakeside community, this home is just steps from the Newport Yacht Club marina, scenic parks, and picturesque waterfront trails. You're only minutes from acclaimed restaurants, local wineries, farmers' markets, and golf courses, with convenient access to the QEW for seamless travel to Toronto or Niagara. (id:62650)"
+"Appliances": array:1 [
0 => "Central Vacuum"
]
+"AssociationFee": "293.7"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-06T00:52:02.848283+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": "2025-12-06T01:45:32Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-06T01:45:32Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3500"
+"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/29168066/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
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2025-12-05T23:51:00.06Z"
+"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:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29168066')"
+"ID": "466361"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25311
+post_id: "465972"
+post_author: 1
+"ListingKey": "29167717"
+"ListingId": "40792496"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-07T16:40:46Z"
+"RFModificationTimestamp": "2025-12-07T16:46:07Z"
+"ListPrice": 1599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1800.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5H4"
+"UnparsedAddress": "337 MCNEILLY Road, Stoney Creek, Ontario L8E5H4"
+"Coordinates": array:2 [
0 => -79.668954
1 => 43.216996
]
+"Latitude": 43.216996
+"Longitude": -79.668954
+"YearBuilt": 1970
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "337 McNeilly Rd has everything you could ever want. Custom built 1800 finished sq. ft side split (70 x 348 lot) contains 3 bedrooms and 2 bathrooms. Property is zoned M3 which allows for a wide range of permitted uses (see attached for details). Combination of hardwood and ceramic flooring throughout the house. Basement is finished and has potential for a fully functional in-law suite including separate entrance and walk-out to the backyard. Perfect for a growing family with room to grow for many, many years. Property has been well cared with only 1 owner. Located minutes from the QEW, public transportation, shopping and schools. Please allow 24 hours notice for all showings. RSA (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T23:35:44.481145+00:00"
+"Directions": "Baron St / McNeilly Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:3 [
0 => "Forced air"
1 => "Natural gas"
2 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1968363"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Country residential"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T23:29:33Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-07T16:29:27Z"
+"StreetName": "MCNEILLY"
+"StreetNumber": "337"
+"StreetSuffix": "Road"
+"SubdivisionName": "514 - Winona Industrial"
+"TaxAnnualAmount": "4500"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29167717/337-mcneilly-road-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "M3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 1800
+"OriginalEntryTimestamp": "2025-12-05T22:29:05.78Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29167717')"
+"ID": "465972"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "466599"
+post_author: 1
+"ListingKey": "29167176"
+"ListingId": "X12605512"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T21:10:26Z"
+"RFModificationTimestamp": "2025-12-05T21:14:33Z"
+"ListPrice": 1449900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E4Z2"
+"UnparsedAddress": "55 EDGEWATER DRIVE, Hamilton (Stoney Creek), Ontario L8E4Z2"
+"Coordinates": array:2 [
0 => -79.6920525
1 => 43.2353714
]
+"Latitude": 43.2353714
+"Longitude": -79.6920525
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Experience unparalleled lakefront living with this exceptional property, offering breathtaking vistas from nearly every room. Perfectly positioned within the prestigious Newport Yacht Club community, this home provides the rare convenience of mooring a boat just steps from your front door, along with effortless QEW access for commuting. This "linked" townhome lives like a detached home, sharing no common walls and boasting parking for six vehicles, including a full double garage. The open-concept main level is a showcase of style and comfort, featuring an updated kitchen with new quartz counters, crown molding, gleaming hardwood floors, a gas fireplace, and a separate dining room. Step through sliding doors to an oversized patio that stretches across a meticulously landscaped 100-foot yard, leading to a private waterfront patio where you can watch the sun rise or set over Lake Ontario. Upstairs, you'll find three generous bedrooms plus a home office, bedroom-level laundry, second gas fireplace in primary suite and two fully updated bathrooms. The primary suite opens onto a balcony where the panoramic lake and Toronto skyline views are simply unforgettable. Notable updates include new counters, sinks, faucets, roof, furnace, AC, light fixtures, and window treatments. A finished lower level with a walk-up to the yard adds even more living space. Rarely available, this is a truly special opportunity to secure a piece of Lake Ontario's waterfront-an address where every day feels like a getaway. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T21:14:22.074186+00:00"
+"Directions": "Cross Streets: Fruitland Rd. ** Directions: north on Fruitland Rd - right onto Harbour Dr - left at Edgewater Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038160"
+"ListOfficeKey": "280315"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "27.8 x 244.3 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2025-12-05T20:52:14Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T20:52:14Z"
+"Stories": "2.0"
+"StreetName": "Edgewater"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "9749.67"
+"View": "Lake view,View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/55-Edgewater-Dr/idx"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29167176/55-edgewater-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "RM2-1"
+"BedroomsAboveGrade": 3
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 27.9
+"OriginalEntryTimestamp": "2025-12-05T20:22:47.4Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29167176')"
+"ID": "466599"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: "466600"
+post_author: 1
+"ListingKey": "29166839"
+"ListingId": "40792625"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-05T20:55:11Z"
+"RFModificationTimestamp": "2025-12-05T20:59:07Z"
+"ListPrice": 1449900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2298.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E4Z2"
+"UnparsedAddress": "55 EDGEWATER Drive, Stoney Creek, Ontario L8E4Z2"
+"Coordinates": array:2 [
0 => -79.6920301
1 => 43.2349627
]
+"Latitude": 43.2349627
+"Longitude": -79.6920301
+"YearBuilt": 1997
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience unparalleled lakefront living with this exceptional property, offering breathtaking vistas from nearly every room. Perfectly positioned within the prestigious Newport Yacht Club community, this home provides the rare convenience of mooring a boat just steps from your front door, along with effortless QEW access for commuting. This “linked” townhome lives like a detached home, sharing no common walls and boasting parking for six vehicles, including a full double garage. The open-concept main level is a showcase of style and comfort, featuring an updated kitchen with new quartz counters, crown molding, gleaming hardwood floors, a gas fireplace, and a separate dining room. Step through sliding doors to an oversized patio that stretches across a meticulously landscaped 100-foot yard, leading to a private waterfront patio where you can watch the sun rise or set over Lake Ontario. Upstairs, you’ll find three generous bedrooms plus a home office, bedroom-level laundry, second gas fireplace in primary suite and two fully updated bathrooms. The primary suite opens onto a balcony where the panoramic lake and Toronto skyline views are simply unforgettable. Notable updates include new counters, sinks, faucets, roof, furnace, AC, light fixtures, and window treatments. A finished lower level with a walk-up to the yard adds even more living space. Rarely available, this is a truly special opportunity to secure a piece of Lake Ontario’s waterfront—an address where every day feels like a getaway. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Central Vacuum - Roughed In"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-05T20:58:44.718895+00:00"
+"Directions": "north on Fruitland Rd - right onto Harbour Dr - left at Edgewater Dr"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Vinyl siding"
]
+"FireplaceFeatures": array:1 [
0 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524652"
+"ListOfficeKey": "294490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-12-05T20:41:49Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-05T20:41:49Z"
+"Stories": "2.0"
+"StreetName": "EDGEWATER"
+"StreetNumber": "55"
+"StreetSuffix": "Drive"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "9749.62"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/55-Edgewater-Dr"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29166839/55-edgewater-drive-stoney-creek"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RM2-1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 2298
+"OriginalEntryTimestamp": "2025-12-05T19:20:11.8Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29166839')"
+"ID": "466600"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23633
+post_id: "463673"
+post_author: 1
+"ListingKey": "29163308"
+"ListingId": "X12601782"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-04T19:35:41Z"
+"RFModificationTimestamp": "2025-12-04T23:47:13Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Fruitland)"
+"PostalCode": "L8E5H9"
+"UnparsedAddress": "232 MCNEILLY ROAD, Hamilton (Fruitland), Ontario L8E5H9"
+"Coordinates": array:2 [
0 => -79.671193
1 => 43.2119721
]
+"Latitude": 43.2119721
+"Longitude": -79.671193
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Currently undergoing thoughtful updates, this spacious 4-bedroom, 2-bathroom bungalow offers comfort, convenience, and room to grow. Enjoy the ease of main-floor living with a generously sized living room, an inviting dining area, and an eat-in kitchen perfect for family meals. A roomy family room provides even more gathering space, while four well-sized bedrooms ensure everyone has a place to unwind. The quiet, private backyard offers a peaceful retreat, and the unfinished basement provides ample storage to keep everything organized. Situated close to major highway access and steps from the stunning Niagara Escarpment, this home combines tranquil living with exceptional convenience. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-04T23:47:05.134882+00:00"
+"Directions": "Cross Streets: Highway 8. ** Directions: Property located on McNeilly Road Just North of Highway 8."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2154672"
+"ListOfficeKey": "283302"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-12-04T19:21:06Z"
+"PhotosCount": 4
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-04T19:21:06Z"
+"Stories": "1.0"
+"StreetName": "McNeilly"
+"StreetNumber": "232"
+"StreetSuffix": "Road"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Fruitland"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29163308/232-mcneilly-road-hamilton-fruitland-fruitland"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3600
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2025-12-04T19:21:06.86Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:4 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
]
+"Member": []
+"Office": []
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29163308')"
+"ID": "463673"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25312
+post_id: "455579"
+post_author: 1
+"ListingKey": "29150689"
+"ListingId": "X12589674"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-12T15:00:52Z"
+"RFModificationTimestamp": "2025-12-12T15:03:16Z"
+"ListPrice": 734900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0B9"
+"UnparsedAddress": "31 PALACEBEACH TRAIL, Hamilton (Stoney Creek), Ontario L8E0B9"
+"Coordinates": array:2 [
0 => -79.6806632
1 => 43.2293899
]
+"Latitude": 43.2293899
+"Longitude": -79.6806632
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is an absolute Showstopper of a home nestled between the beautiful and peaceful waterfront and the convenience of the nearby highway. Home offers multi-level layout starting with the cozy foyer leading to the open concept living and dining room with gas fireplace. The modern kitchen offers granite counter tops and comfortable space with a breakfast area Leading out to the multi-level deck which offers a great space for entertaining and relaxation. The upper level offers multi-level bedrooms starting with the spacious master bedroom with, and spacious walk in closet, and 3 pc ensuite with heated floor. Step up to the 2nd and 2nd spacious bedrooms with laminate floors and lots of closet space. Upper floor laundry with front loader washer and dryer. California shutters throughout. Pot lights in main floor and basement. Central Vac. Dimmable Lights. Gas BBQ. Epoxy floor in Garage. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
7 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-12-01T20:03:17.382307+00:00"
+"Directions": "North Service Rd/Darmount Gate"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1412473"
+"ListOfficeKey": "271789"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Flat site"
]
+"LotSizeDimensions": "25.7 x 87.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-12-01T16:23:37Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-12-12T14:48:25Z"
+"Stories": "2.0"
+"StreetName": "Palacebeach"
+"StreetNumber": "31"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "4150"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29150689/31-palacebeach-trail-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.8
+"OriginalEntryTimestamp": "2025-12-01T16:23:37.28Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29150689')"
+"ID": "455579"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25313
+post_id: "451776"
+post_author: 1
+"ListingKey": "29147390"
+"ListingId": "X12586494"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T22:05:42Z"
+"RFModificationTimestamp": "2025-11-28T22:30:38Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "76 - 590 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.697415
1 => 43.234285
]
+"Latitude": 43.234285
+"Longitude": -79.697415
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright, freshly painted and well keptntownhome in the highly sought-after Stoney Creek lakefront community. Ideally situated just off the QEW and steps from Lake Ontario, this home offers unmatched convenience with Costco, the GO Station, Yacht Club, shopping, restaurants, and scenic walking trails only minutes away. The open-concept main floor features a modern kitchen with a breakfast bar overlooking the spacious living and dining areas-perfect for entertaining. Upstairs, you'll find two generously sized bedrooms plus a versatile bonus room that can function as a third bedroom, home office, games room, or kids' playroom. Visitor parking is conveniently located right across from the unit. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T22:30:31.321882+00:00"
+"Directions": "Lakeview/Fruitland"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1636085"
+"ListOfficeKey": "238732"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "20.4 x 39.4 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T21:59:11Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T21:59:11Z"
+"Stories": "3.0"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/76-590-north-service-road-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29147390/76-590-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 2549
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 20.4
+"OriginalEntryTimestamp": "2025-11-28T21:59:11.3Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:18 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29147390')"
+"ID": "451776"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 79
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]