array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29167176/Property?$select=ALL&$top=20&$filter=ListingKey eq 29167176&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29167176/Property?$select=ALL&$top=20&$filter=ListingKey eq 29167176&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23660
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23662
+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 [
"RoomKey" => "1545429058"
"RoomType" => "Foyer"
"ListingId" => "X12605512"
"RoomLevel" => "Main level"
"RoomWidth" => 2.26
"ListingKey" => "29167176"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.44Z"
]
1 => array:11 [
"RoomKey" => "1545429059"
"RoomType" => "Utility room"
"ListingId" => "X12605512"
"RoomLevel" => "Basement"
"RoomWidth" => 2.26
"ListingKey" => "29167176"
"RoomLength" => 4.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.44Z"
]
2 => array:11 [
"RoomKey" => "1545429060"
"RoomType" => "Cold room"
"ListingId" => "X12605512"
"RoomLevel" => "Basement"
"RoomWidth" => 0.99
"ListingKey" => "29167176"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.44Z"
]
3 => array:11 [
"RoomKey" => "1545429061"
"RoomType" => "Dining room"
"ListingId" => "X12605512"
"RoomLevel" => "Main level"
"RoomWidth" => 3.02
"ListingKey" => "29167176"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.44Z"
]
4 => array:11 [
"RoomKey" => "1545429062"
"RoomType" => "Other"
"ListingId" => "X12605512"
"RoomLevel" => "Basement"
"RoomWidth" => 1.8
"ListingKey" => "29167176"
"RoomLength" => 2.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.45Z"
]
5 => array:11 [
"RoomKey" => "1545429063"
"RoomType" => "Great room"
"ListingId" => "X12605512"
"RoomLevel" => "Main level"
"RoomWidth" => 3.63
"ListingKey" => "29167176"
"RoomLength" => 7.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.45Z"
]
6 => array:11 [
"RoomKey" => "1545429064"
"RoomType" => "Kitchen"
"ListingId" => "X12605512"
"RoomLevel" => "Main level"
"RoomWidth" => 2.51
"ListingKey" => "29167176"
"RoomLength" => 3.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.45Z"
]
7 => array:11 [
"RoomKey" => "1545429065"
"RoomType" => "Eating area"
"ListingId" => "X12605512"
"RoomLevel" => "Main level"
"RoomWidth" => 2.51
"ListingKey" => "29167176"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.45Z"
]
8 => array:11 [
"RoomKey" => "1545429066"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12605512"
"RoomLevel" => "Second level"
"RoomWidth" => 4.04
"ListingKey" => "29167176"
"RoomLength" => 5.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.45Z"
]
9 => array:11 [
"RoomKey" => "1545429067"
"RoomType" => "Bedroom"
"ListingId" => "X12605512"
"RoomLevel" => "Second level"
"RoomWidth" => 3.23
"ListingKey" => "29167176"
"RoomLength" => 3.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.45Z"
]
10 => array:11 [
"RoomKey" => "1545429068"
"RoomType" => "Bedroom"
"ListingId" => "X12605512"
"RoomLevel" => "Second level"
"RoomWidth" => 3.33
"ListingKey" => "29167176"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.45Z"
]
11 => array:11 [
"RoomKey" => "1545429069"
"RoomType" => "Loft"
"ListingId" => "X12605512"
"RoomLevel" => "Second level"
"RoomWidth" => 2.67
"ListingKey" => "29167176"
"RoomLength" => 4.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.45Z"
]
12 => array:11 [
"RoomKey" => "1545429070"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12605512"
"RoomLevel" => "Basement"
"RoomWidth" => 5.31
"ListingKey" => "29167176"
"RoomLength" => 8.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-12-05T20:22:47.45Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6357548331"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/778dcba5c130a310909da2282987e8cd.webp"
"MediaSize" => 187373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-778dcba5c130a310909da2282987e8cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:52:14.96Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6357548401"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/8fb6f623f13d7f91801cf66e76063254.webp"
"MediaSize" => 145823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-8fb6f623f13d7f91801cf66e76063254.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6357548428"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/1949e94a1eef5f0828fc8c12c9916d91.webp"
"MediaSize" => 154349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-1949e94a1eef5f0828fc8c12c9916d91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6357548477"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/80cf80ec4d8bfd9ffd630138baae15e8.webp"
"MediaSize" => 144760
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-80cf80ec4d8bfd9ffd630138baae15e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6357548502"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/5bca277988d0c5d26d957cdf514af514.webp"
"MediaSize" => 128400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-5bca277988d0c5d26d957cdf514af514.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6357548540"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/6ba9cc8bc661c69df99f3415e623f44a.webp"
"MediaSize" => 114838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-6ba9cc8bc661c69df99f3415e623f44a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6357548571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/9ca00879b45ebd72c426e17c88bb0c88.webp"
"MediaSize" => 142214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-9ca00879b45ebd72c426e17c88bb0c88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6357548612"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/b0b7bd9fcfd89a13bea5299d28116c1f.webp"
"MediaSize" => 85686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-b0b7bd9fcfd89a13bea5299d28116c1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6357548652"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/4c038e9245c971bc22784f75b9662d4e.webp"
"MediaSize" => 202568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-4c038e9245c971bc22784f75b9662d4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6357548755"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/32321aa67c9d54a9c973168958ddee53.webp"
"MediaSize" => 174671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-32321aa67c9d54a9c973168958ddee53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6357548775"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/a635744beee18c3d0e7cda26f2240939.webp"
"MediaSize" => 354850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-a635744beee18c3d0e7cda26f2240939.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6357548812"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/7ec6ee9e33ed4a5df20ba515a2e0af14.webp"
"MediaSize" => 268859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-7ec6ee9e33ed4a5df20ba515a2e0af14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6357548831"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/fff2c268647be5b0d81f2763a94a93c0.webp"
"MediaSize" => 269428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-fff2c268647be5b0d81f2763a94a93c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6357548866"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/40621339a4875cd0fa05debdba5c71ba.webp"
"MediaSize" => 133399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-40621339a4875cd0fa05debdba5c71ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6357548882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/933fc5e6de778d498908f6cf106659fa.webp"
"MediaSize" => 116443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-933fc5e6de778d498908f6cf106659fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6357548906"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/d40054e68786d00b7daba3e9649f389c.webp"
"MediaSize" => 140065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-d40054e68786d00b7daba3e9649f389c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6357548922"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/57c785914f0e42166da16afca877556e.webp"
"MediaSize" => 149469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-57c785914f0e42166da16afca877556e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6357548964"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/fa95c539585c6369a2ccd52b94b44877.webp"
"MediaSize" => 152666
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-fa95c539585c6369a2ccd52b94b44877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6357548976"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/e1990a23aff81f32e79d4d85f639183a.webp"
"MediaSize" => 108401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-e1990a23aff81f32e79d4d85f639183a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6357548989"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/1d4944bb7970dc90a0ef9bec1fb63363.webp"
"MediaSize" => 119945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-1d4944bb7970dc90a0ef9bec1fb63363.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6357549023"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/3ac5b172d25acee633499e28390db105.webp"
"MediaSize" => 85682
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-3ac5b172d25acee633499e28390db105.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6357549031"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/703f643da0887b16f3c273d30e25f6da.webp"
"MediaSize" => 94296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-703f643da0887b16f3c273d30e25f6da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6357549061"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/564249bce02c4559161ef2a3d1f33850.webp"
"MediaSize" => 107380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-564249bce02c4559161ef2a3d1f33850.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6357549091"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/e5aad947f67c5898fa1e9c9b65f3152f.webp"
"MediaSize" => 142214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-e5aad947f67c5898fa1e9c9b65f3152f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6357549160"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/a6c218993016b904e4fc044141277e37.webp"
"MediaSize" => 115937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-a6c218993016b904e4fc044141277e37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6357549213"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/36ffd2296c0ec393f33f0c8268ccb100.webp"
"MediaSize" => 194707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-36ffd2296c0ec393f33f0c8268ccb100.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6357549238"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/a40aef863ddc2554e2371287effab701.webp"
"MediaSize" => 98664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-a40aef863ddc2554e2371287effab701.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6357549279"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/cdde251c5e0bee6f9e1c07bc47514fa2.webp"
"MediaSize" => 93483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-cdde251c5e0bee6f9e1c07bc47514fa2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6357549308"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/c913d4aa43b50ab0c9da5c1ecd3d7beb.webp"
"MediaSize" => 215927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-c913d4aa43b50ab0c9da5c1ecd3d7beb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6357549344"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/429bd3439f9316b8bad7156ad49c2600.webp"
"MediaSize" => 126218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-429bd3439f9316b8bad7156ad49c2600.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6357549369"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/5030c714e69940f4288174ca42226502.webp"
"MediaSize" => 180891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-5030c714e69940f4288174ca42226502.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6357549398"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/ee96e2d886a8665eff59ec311081fa91.webp"
"MediaSize" => 112902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-ee96e2d886a8665eff59ec311081fa91.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6357549424"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/ee7b6fdffa13119f93aac88235a0ba20.webp"
"MediaSize" => 102659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-ee7b6fdffa13119f93aac88235a0ba20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6357549442"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/44707b3985c2a04ee1756abb100b9677.webp"
"MediaSize" => 80661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-44707b3985c2a04ee1756abb100b9677.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6357549456"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/0fb7ab676a2fbba83588ed742698fc1e.webp"
"MediaSize" => 96413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-0fb7ab676a2fbba83588ed742698fc1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6357549473"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/711687810f0fd7aa6661be5281a5a1f9.webp"
"MediaSize" => 102113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-711687810f0fd7aa6661be5281a5a1f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6357549493"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/54eae477c94fe9582f8da442a7b24f06.webp"
"MediaSize" => 141981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-54eae477c94fe9582f8da442a7b24f06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6357549509"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/85535582db03a944f19e8b971537d36a.webp"
"MediaSize" => 84400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-85535582db03a944f19e8b971537d36a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6357549519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/02cebff7a853afd01e1d77d081d66f71.webp"
"MediaSize" => 287877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-02cebff7a853afd01e1d77d081d66f71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6357549552"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/13d045120c027c4849c1c2626d4bded2.webp"
"MediaSize" => 238827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-13d045120c027c4849c1c2626d4bded2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6357549565"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/86aee2b6acc02a5706545148bba34bc5.webp"
"MediaSize" => 275842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-86aee2b6acc02a5706545148bba34bc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
41 => array:13 [
"Order" => 41
"MediaKey" => "6357549571"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/af69cfc0b440b83fb123ce1b189f8f2a.webp"
"MediaSize" => 180355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-af69cfc0b440b83fb123ce1b189f8f2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
42 => array:13 [
"Order" => 42
"MediaKey" => "6357549580"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/af971223ec672423a3ab5fdaba82e3cd.webp"
"MediaSize" => 163819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-af971223ec672423a3ab5fdaba82e3cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
43 => array:13 [
"Order" => 43
"MediaKey" => "6357549588"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/00d4ab5bde2f76decbf228b14d8d21aa.webp"
"MediaSize" => 207583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-00d4ab5bde2f76decbf228b14d8d21aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
44 => array:13 [
"Order" => 44
"MediaKey" => "6357549592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/408ad0814896cde2448929627d99cadb.webp"
"MediaSize" => 241261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-408ad0814896cde2448929627d99cadb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
45 => array:13 [
"Order" => 45
"MediaKey" => "6357549601"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/23a4e25fb229522318eacd1c2ea764ea.webp"
"MediaSize" => 331286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-23a4e25fb229522318eacd1c2ea764ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
46 => array:13 [
"Order" => 46
"MediaKey" => "6357549605"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/067b6b8d3016c5ddde1a39b0e277a68d.webp"
"MediaSize" => 300934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-067b6b8d3016c5ddde1a39b0e277a68d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
47 => array:13 [
"Order" => 47
"MediaKey" => "6357549610"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29167176/8efb172712f363eea23bb76ad5441865.webp"
"MediaSize" => 262112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29167176/thumbnail-8efb172712f363eea23bb76ad5441865.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12605512"
"ResourceRecordKey" => "29167176"
"ModificationTimestamp" => "2025-12-05T20:22:47.41Z"
]
]
+"Member": array:1 [
0 => array:21 [
"MemberFullName" => "E. MARTIN MAZZA"
"MemberFirstName" => "E. MARTIN"
"MemberLastName" => "MAZZA"
"MemberMlsId" => "9581870"
"OriginatingSystemName" => 26
"MemberKey" => "2038160"
"ModificationTimestamp" => "2025-08-13T17:59:57Z"
"MemberStatus" => "Active"
"OfficeKey" => "280315"
"MemberAOR" => "Toronto"
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-662-6666"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2017-07-21T00:14:00Z"
"MemberNationalAssociationId" => "1314350"
"OfficeNationalAssociationId" => "1312645"
]
]
+"Office": array:1 [
0 => array:23 [
"OfficeName" => "ROYAL LEPAGE STATE REALTY"
"OfficePhone" => "905-662-6666"
"OfficeMlsId" => "288000"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "280315"
"ModificationTimestamp" => "2025-06-10T11:58:34Z"
"OfficeAddress1" => "115 HIGHWAY 8 #102"
"OfficeCity" => "STONEY CREEK"
"OfficePostalCode" => "L8G1C"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"Media" => array:1 [ …1]
"OfficeFax" => "905-662-2227"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2017-06-13T00:47:00Z"
"OfficeNationalAssociationId" => "1312645"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1312646"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29167176')"
+"ID": "466599"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 280315/Office?$select=ALL&$top=10&$filter=OfficeKey eq 280315&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 280315/Office?$select=ALL&$top=10&$filter=OfficeKey eq 280315&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25530
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25532
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "ROYAL LEPAGE STATE REALTY"
+"OfficeEmail": null
+"OfficePhone": "905-662-6666"
+"OfficeMlsId": "288000"
+"ModificationTimestamp": "2025-06-10T11:58:34Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "280315"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "115 HIGHWAY 8 #102"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "STONEY CREEK"
+"OfficePostalCode": "L8G1C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1312645"
+"OriginalEntryTimestamp": "2017-06-13T00:47:00Z"
+"OfficeFax": "905-662-2227"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "291909"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "280315"
"SocialMediaUrlOrId" => "http://www.royallepagestate.ca/"
"ModificationTimestamp" => "2025-06-10T11:45:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1312646"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('280315')"
}
]
+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 2038160/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2038160&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2038160/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2038160&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25535
+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 29167176" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25113
+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 29167176/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29167176&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29167176/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29167176&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24993
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29167176 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6920525 43.2353714)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29167176 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6920525 43.2353714)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29167176 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6920525 43.2353714)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29167176 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6920525 43.2353714)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25373
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25390
+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"
…2
]
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]
]
+"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 {#25402
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25388
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25005
+post_id: "455579"
+post_author: 1
+"ListingKey": "29150689"
+"ListingId": "X12589674"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-12-01T16:30:35Z"
+"RFModificationTimestamp": "2025-12-01T20:03:31Z"
+"ListPrice": 754900.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-01T16:23:37Z"
+"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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25404
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25385
+post_id: "451012"
+post_author: 1
+"ListingKey": "29145048"
+"ListingId": "40784890"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-29T21:45:51Z"
+"RFModificationTimestamp": "2025-11-29T21:47:53Z"
+"ListPrice": 839000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1070.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5X8"
+"UnparsedAddress": "515 NORTH SERVICE Road, Stoney Creek, Ontario L8E5X8"
+"Coordinates": array:2 [
0 => -79.7069649
1 => 43.2351655
]
+"Latitude": 43.2351655
+"Longitude": -79.7069649
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Waterfront, sunsets, beautiful breezes & unobstructed Toronto skyline LAKE VIEWS that take your breath away! Unique bungalow 2 bd, 2.5 bath main lvl condo in SEASIDE VILLAGE, perfect for folks who need low maintenance lifestyle but don’t want to compromise on size style or comfort. A redesigned floor plan features expanded primary KING-SIZE suite on main level w/ensuite incl step-in tub w/jets & convenient hand-held shower.If desired this expanded master suite can be returned to original design to include a master bdrm PLUSden/office with a simple & inexpensive remodel of the space.Gorgeous STRIP HARDWOOD throughout the main level including lliving/dining room with stunning water views & walkout to stamped concrete patio w/greenspace & private community lakeside trail. Fresh & bright kitchen features granite counters,breakfast bar w/white appliances, lovely corner gas fireplace at the heart of it all. New washer and dryer conveniently located in main floor laundry/utility room.A 2nd bdrm is downstairs perfect for guests or extended family w/large walk-in closet & 3 pc ensuite bathroom. The spacious rec room offers LIMITLESS OPPORTUNITY & potential from casual family living to home-gym workout space.You’ll also find abundant storage incl large cold cellar, furnace/utility room, under-the-stairs closet, &workshop w/work bench. This extraordinary home features many upgrades including:new air conditioner('23) high efficiency furnace with humidifier('24)all new windows('22)dishwasher('23) washer/dryer('24) owned hot water heater ('23),auto garage door opener,gas hookup for BBQ on patio,waterproofed exterior underside of deck, covered front porch,beautifully landscaped gardens.There is a separate single car garage with paved driveway for your 2nd vehicle plus convenient visitor parking at the curb.Just minutes from local amenities, parks, schools, waterfront walking trails, Winona Crossings plaza,dining&easy highway access for efficient commute. This home is a rare find. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "557.8"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-28T17:38:35.897097+00:00"
+"Directions": "QEW to Fruitland Road, West on North Service Rd."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1770002"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2025-11-29T21:31:20Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-29T21:31:20Z"
+"Stories": "1.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "515"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4861"
+"View": "Unobstructed Water View"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29145048/515-north-service-road-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3-11"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1070
+"OriginalEntryTimestamp": "2025-11-28T14:00:22.74Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"Media": array:42 [
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]
]
+"Member": []
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29145048')"
+"ID": "451012"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23674
+post_id: "449615"
+post_author: 1
+"ListingKey": "29143353"
+"ListingId": "X12582688"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T19:30:18Z"
+"RFModificationTimestamp": "2025-11-30T19:34:30Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E5C9"
+"UnparsedAddress": "80 SEABREEZE CRESCENT, Hamilton (Lakeshore), Ontario L8E5C9"
+"Coordinates": array:2 [
0 => -79.6703399
1 => 43.2281318
]
+"Latitude": 43.2281318
+"Longitude": -79.6703399
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover elevated coastal living in this fully furnished, beautifully curated residence, perfectly situated in one of Stoney Creek's most exclusive lakeside neighborhoods. Every detail has been thoughtfully selected to offer a luxurious, move-in-ready experience designed for comfort, convenience, and style.From the moment you arrive, the home's coastal-inspired architecture sets a sophisticated tone. Stepinside to a sun-filled open-concept layout where rich hardwood floors, and expansive windows create an atmosphere of refined elegance. The gourmet kitchen stands at the heart of the home, featuring premium stainless steel appliances, ample cabinetry, and a functional layout ideal for cooking, hosting, or everyday living. Enjoy two beautifully appointed bedrooms, each furnished. The primary suite offers a truly serene retreat with a spa-like en suite, generous closet space, and breathtaking sunrise views right from your bed.The private backyard extends your living space outdoors - the perfect spot to unwind and enjoy the tranquility of the lakeside setting. This residence is ideal for professionals, relocating families, or tenants seeking a turn-key luxury rental in a quiet, prestigious community. Open to flexible lease terms: 6 months to 1 year (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Other, See Remarks"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-27T23:52:20.225831+00:00"
+"Directions": "North Service Rd/Glover Rd"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Shingles"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2136530"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In suite Laundry"
]
+"LotSizeDimensions": "33 x 161 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-28T19:39:14Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T19:18:26Z"
+"Stories": "1.0"
+"StreetName": "Seabreeze"
+"StreetNumber": "80"
+"StreetSuffix": "Crescent"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "View,View of water,Direct Water View"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29143353/80-seabreeze-crescent-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"TotalActualRent": 3300
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 33.0
+"OriginalEntryTimestamp": "2025-11-27T20:01:37.35Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:22 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29143353')"
+"ID": "449615"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25006
+post_id: "441861"
+post_author: 1
+"ListingKey": "29133396"
+"ListingId": "X12573368"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T23:30:30Z"
+"RFModificationTimestamp": "2025-11-25T01:05:36Z"
+"ListPrice": 669000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Industrial)"
+"PostalCode": "L8E5L8"
+"UnparsedAddress": "795 BARTON STREET, Hamilton (Stoney Creek Industrial), Ontario L8E5L8"
+"Coordinates": array:2 [
0 => -79.6885118
1 => 43.2198519
]
+"Latitude": 43.2198519
+"Longitude": -79.6885118
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Great Location !!! Open Concept, Extra Large Lot Size 60ft X 200ft With Commercial M3 Zoning. Well Kept 2 Spacious Bedrooms Bungalow With Updated Kitchen, Large Size Windows For Lots Of Natural Light, Lots Of Future Potential, Many Commercial Uses Allowed Including Day Care & Much More!! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-25T01:05:32.065701+00:00"
+"Directions": "Fruitland rd / Barton St"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1724988"
+"ListOfficeKey": "261422"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "60 x 200 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-24T23:22:44Z"
+"PhotosCount": 5
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T23:22:44Z"
+"Stories": "1.0"
+"StreetName": "Barton"
+"StreetNumber": "795"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3132.53"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Industrial"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29133396/795-barton-street-hamilton-stoney-creek-industrial-stoney-creek-industrial"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"BuildingFeatures": array:1 [
0 => "Separate Electricity Meters"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2025-11-24T23:22:44.42Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:5 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:25 [ …25]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29133396')"
+"ID": "441861"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25391
+post_id: "436540"
+post_author: 1
+"ListingKey": "29126835"
+"ListingId": "40789845"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-30T21:46:02Z"
+"RFModificationTimestamp": "2025-11-30T21:53:28Z"
+"ListPrice": 849000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.373
+"LivingArea": 3285.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E5N2"
+"UnparsedAddress": "322 JONES Road, Hamilton, Ontario L8E5N2"
+"Coordinates": array:2 [
0 => -79.6898793
1 => 43.2199072
]
+"Latitude": 43.2199072
+"Longitude": -79.6898793
+"YearBuilt": 1920
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A turnkey multi-family property with tons of prospects - an investor's dream deal that won't last long. Step inside 322 Jones Road and discover a thoughtfully renovated legal duplex with residential and commercial zoning in prime Stoney Creek. The main floor welcomes you with a bright, massive open-concept living and dining area, perfect for entertaining. The updated kitchen features modern finishes and a walkout to a spacious back deck - ideal for summer BBQs or morning coffee. Head upstairs to find three generous bedrooms, including an expansive primary suite with its own private deck - a true retreat. The oversized rec room on this level offers extra space for a home office, playroom, or media lounge. The lower level offers a separate, fully legal 2-bedroom apartment with its own private parking & entrance, kitchen, full bath, and separate hydro meter - perfect for extended family or generating income. Step outside to your own private oasis: a 90x180 ft lot with mature trees, a massive backyard, and a large enclosed shed for extra storage. Two separate driveways and a heated triple-car garage with its own thermostat and EV charger complete the package. Close to the QEW, public transit, schools, and parks - this property is move-in ready and packed with potential. (id:62650)"
+"Appliances": array:1 [
0 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-21T20:21:08.391773+00:00"
+"Directions": "Fruitland Rd, East on Barton Road, North on Jones"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Corner Site"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "0.373"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-21T19:00:20Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-30T21:30:16Z"
+"Stories": "2.0"
+"StreetName": "JONES"
+"StreetNumber": "322"
+"StreetSuffix": "Road"
+"SubdivisionName": "513 - Industrial"
+"TaxAnnualAmount": "4400"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/kvQujsIQW2k"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29126835/322-jones-road-hamilton"
+"ParkingTotal": 11
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "M3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 90.0
+"AboveGradeFinishedArea": 2187
+"BelowGradeFinishedArea": 1098
+"OriginalEntryTimestamp": "2025-11-21T19:00:20.29Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29126835')"
+"ID": "436540"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 65
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]