array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30073041 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23528
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23530
+post_id: "1653701"
+post_author: 1
+"ListingKey": "30073041"
+"ListingId": "X13600044"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T21:50:05Z"
+"RFModificationTimestamp": "2026-07-23T22:01:55Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0C3"
+"UnparsedAddress": "165 PALACEBEACH TRAIL, Hamilton (Lakeshore), Ontario L8E0C3"
+"Coordinates": array:2 [
0 => -79.676263
1 => 43.22838
]
+"Latitude": 43.22838
+"Longitude": -79.676263
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautiful two-storey home in the sought-after community of Stoney Creek-just a short drive to the beach! This 3-bedroom home offers a bright, open-concept layout with 9 ft ceilings, hardwood floors, tile, and a cozy gas fireplace. The spacious kitchen features rich wood cabinetry, stainless steel dishwasher, refrigerator, and stove, and opens to a fully fenced backyard with stamped concrete, a handy storage shed, and an irrigation system-perfect for relaxing or entertaining. Enjoy the convenience of inside access from the attached garage and a 2-pc powder room just a few steps down from the main level. The family room is also wired with a built-in music system and speakers, adding to the home's comfort and charm. Upstairs, you'll find three generously sized bedrooms, a charming loft space ideal for a home office or reading nook, and a 4-pc main bath. The primary suite boasts a large walk-in closet and a luxurious ensuite with a soaker tub and separate shower. The basement is framed and ready for your finishing touches, with potential for a 4th bedroom, rec room, and a roughed-in bathroom. Laundry is also located on the lower level. This home has great curb appeal, a new roof, and is located close to Costco, shops, restaurants, and offers quick access to the QEW. Don't miss this fantastic opportunity in a prime location (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T22:01:46.381718+00:00"
+"Directions": "Cross Streets: North Service Rd., North on Watercrest drive, South on Palacebeach Trail. ** Directions: Service Rd., Glover Rd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2170778"
+"ListOfficeKey": "279779"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30.1 x 85.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T21:40:58Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T21:40:58Z"
+"Stories": "2.0"
+"StreetName": "Palacebeach"
+"StreetNumber": "165"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "5200.2"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30073041/165-palacebeach-trail-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.1
+"OriginalEntryTimestamp": "2026-07-23T21:40:58.41Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1421414"
+"ListOfficeNationalAssociationId": "1309078"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30073041_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/8cf14fc7b0ffcfffa949251b3f681fc8.webp"
"MediaSize" => 304642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-8cf14fc7b0ffcfffa949251b3f681fc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30073041_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/ab3ab9c41db22f9e8dc464d9f8908546.webp"
"MediaSize" => 303480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-ab3ab9c41db22f9e8dc464d9f8908546.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30073041_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/e4c0135714138cbf55f4c488a17848b8.webp"
"MediaSize" => 328996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-e4c0135714138cbf55f4c488a17848b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30073041_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/c3804d4d7c55c590b1c8009cca02b094.webp"
"MediaSize" => 213297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-c3804d4d7c55c590b1c8009cca02b094.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30073041_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/5f0ff23e7fc5c98ee9343ef3f5d2070e.webp"
"MediaSize" => 194903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-5f0ff23e7fc5c98ee9343ef3f5d2070e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30073041_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/2bd7029d91d2ac97fe16b29b7dd54e9b.webp"
"MediaSize" => 174533
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-2bd7029d91d2ac97fe16b29b7dd54e9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30073041_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/d788966169f8ab9f12bb5f8d6d3ad463.webp"
"MediaSize" => 183375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-d788966169f8ab9f12bb5f8d6d3ad463.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30073041_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/df0f1efa08d535eaf2706104486f2995.webp"
"MediaSize" => 179845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-df0f1efa08d535eaf2706104486f2995.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30073041_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/1660d93da0018db18122f455135c35bb.webp"
"MediaSize" => 169036
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-1660d93da0018db18122f455135c35bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30073041_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/27ccb08aa98f4481353bb7fc26d5ae0c.webp"
"MediaSize" => 189833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-27ccb08aa98f4481353bb7fc26d5ae0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30073041_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/34056ccac85ebd727d09ba06791cbfb7.webp"
"MediaSize" => 195029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-34056ccac85ebd727d09ba06791cbfb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30073041_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/3d0f2710052f2639778b5dd95f96654e.webp"
"MediaSize" => 168247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-3d0f2710052f2639778b5dd95f96654e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30073041_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/78a44c960a5352ad0e79834f8f5466fe.webp"
"MediaSize" => 148784
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-78a44c960a5352ad0e79834f8f5466fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30073041_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/56eaa7bda6aa9602185947184d765701.webp"
"MediaSize" => 200992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-56eaa7bda6aa9602185947184d765701.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30073041_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/6167ac9b8a8c2174cb7a2a0c31280584.webp"
"MediaSize" => 168178
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-6167ac9b8a8c2174cb7a2a0c31280584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30073041_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/741a4ea69b1bb92a6602110f533c2d1f.webp"
"MediaSize" => 149890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-741a4ea69b1bb92a6602110f533c2d1f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30073041_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/b98b104cc662034d84733c2709d24b42.webp"
"MediaSize" => 137558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-b98b104cc662034d84733c2709d24b42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30073041_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/0785b4714715b323322357b9c41cd869.webp"
"MediaSize" => 128283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-0785b4714715b323322357b9c41cd869.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30073041_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/b3d38162f3752fc1c4e9850035df4cc4.webp"
"MediaSize" => 195409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-b3d38162f3752fc1c4e9850035df4cc4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30073041_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/b7fa9bbc969a11e6ec9cfa6ba1905dab.webp"
"MediaSize" => 137360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-b7fa9bbc969a11e6ec9cfa6ba1905dab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30073041_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/c1d756d814f2932134513b35ae8a3b6e.webp"
"MediaSize" => 144891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-c1d756d814f2932134513b35ae8a3b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30073041_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/251df45b75f20fe9e3df5aa8bf03b82c.webp"
"MediaSize" => 193145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-251df45b75f20fe9e3df5aa8bf03b82c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30073041_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/adc23662b0313c0ababaf88ad93ecc52.webp"
"MediaSize" => 173105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-adc23662b0313c0ababaf88ad93ecc52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30073041_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/b46072aa61f181c7e1de14b8402b98f8.webp"
"MediaSize" => 275243
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-b46072aa61f181c7e1de14b8402b98f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30073041_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/d4312121008599876e6e1aeafe5afcd4.webp"
"MediaSize" => 347194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-d4312121008599876e6e1aeafe5afcd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30073041_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073041/7f757b808476b737472f5ed70adf4ede.webp"
"MediaSize" => 398525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073041/thumbnail-7f757b808476b737472f5ed70adf4ede.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600044"
"ResourceRecordKey" => "30073041"
"ModificationTimestamp" => "2026-07-23T21:40:58.41Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30073041')"
+"ID": "1653701"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 279779" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24997
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24940
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CENTRAL HOME REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "416-500-5888"
+"OfficeMlsId": "280600"
+"ModificationTimestamp": "2026-03-03T10:53:20Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "279779"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "30 FULTON WAY UNIT 8 STE 100"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "RICHMOND HILL"
+"OfficePostalCode": "L4B1E"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1309078"
+"OriginalEntryTimestamp": "2017-03-22T00:11:00Z"
+"OfficeFax": "416-238-4386"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"FranchiseNationalAssociationId": "1230730"
+"OfficeBrokerNationalAssociationId": "1310558"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('279779')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2170778" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25020
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30073041'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25309
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30073041' AND OpenHouseDate ge '2026-07-23'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25325
+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 '30073041' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.676263 43.22838)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25378
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25372
+post_id: "1654473"
+post_author: 1
+"ListingKey": "30072617"
+"ListingId": "X13599574"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:45:06Z"
+"RFModificationTimestamp": "2026-07-23T23:08:40Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "590 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.697576
1 => 43.233855
]
+"Latitude": 43.233855
+"Longitude": -79.697576
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 50 at 590 North Service Road in Stoney Creek, a beautifully maintained and affordable home built in 2020, offering modern living in one of the city's most convenient and rapidly growing communities. Whether you're a first time buyer, young professional, downsizer, or investor, this home delivers the perfect combination of style, comfort, and location.Nestled in a prime Stoney Creek setting, this property offers stunning escarpment views and is located just moments from the lake, giving you the best of both natural beauty and urban convenience. Enjoy easy access to waterfront parks, walking and biking trails, local beaches, and scenic outdoor spaces while still being close to everything you need for day to day living.Inside, you'll find a modern layout designed for today's lifestyle with bright living spaces, contemporary finishes, and a welcoming atmosphere throughout. Built in 2020, this newer home provides peace of mind with updated construction, energy efficiency, and low maintenance living.The location is truly unbeatable. Situated near the popular Costco Plaza, you are just minutes away from shopping, restaurants, cafes, fitness centres, and everyday amenities. Commuters will appreciate the quick access to the QEW, Red Hill Valley Parkway, and major routes connecting you to Hamilton, Niagara, and the GTA.Offering incredible value in an exceptional location, Unit 50 at 590 North Service Road is your opportunity to enjoy modern living surrounded by convenience, nature, and breathtaking escarpment scenery. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T23:08:31.364952+00:00"
+"Directions": "Cross Streets: Lakeview Drive. ** Directions: QEW exit Fruitland Rd, left onto Lakeview Dr, continue onto N. Service Rd, left into complex, property on outer perimeter facing highway."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.4 x 41.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T20:39:57Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T20:39:57Z"
+"Stories": "3.0"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4098.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1691964013"
"RoomType" => "Foyer"
"ListingId" => "X13599574"
"RoomLevel" => "Main level"
"RoomWidth" => 4.65
"ListingKey" => "30072617"
"RoomLength" => 2.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T20:39:57.22Z"
]
1 => array:11 [
"RoomKey" => "1691964014"
"RoomType" => "Kitchen"
"ListingId" => "X13599574"
"RoomLevel" => "Second level"
"RoomWidth" => 3.81
"ListingKey" => "30072617"
"RoomLength" => 4.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T20:39:57.22Z"
]
2 => array:11 [
"RoomKey" => "1691964015"
"RoomType" => "Living room"
"ListingId" => "X13599574"
"RoomLevel" => "Second level"
"RoomWidth" => 4.17
"ListingKey" => "30072617"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T20:39:57.22Z"
]
3 => array:11 [
"RoomKey" => "1691964016"
"RoomType" => "Dining room"
"ListingId" => "X13599574"
"RoomLevel" => "Second level"
"RoomWidth" => 2.51
"ListingKey" => "30072617"
"RoomLength" => 2.41
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T20:39:57.22Z"
]
4 => array:11 [
"RoomKey" => "1691964017"
"RoomType" => "Bathroom"
"ListingId" => "X13599574"
"RoomLevel" => "Second level"
"RoomWidth" => 1.47
"ListingKey" => "30072617"
"RoomLength" => 1.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T20:39:57.22Z"
]
5 => array:11 [
"RoomKey" => "1691964018"
"RoomType" => "Bedroom"
"ListingId" => "X13599574"
"RoomLevel" => "Third level"
"RoomWidth" => 4.55
"ListingKey" => "30072617"
"RoomLength" => 3.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T20:39:57.22Z"
]
6 => array:11 [
"RoomKey" => "1691964019"
"RoomType" => "Bedroom 2"
"ListingId" => "X13599574"
"RoomLevel" => "Third level"
"RoomWidth" => 4.09
"ListingKey" => "30072617"
"RoomLength" => 2.67
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T20:39:57.22Z"
]
7 => array:11 [
"RoomKey" => "1691964020"
"RoomType" => "Bathroom"
"ListingId" => "X13599574"
"RoomLevel" => "Third level"
"RoomWidth" => 2.49
"ListingKey" => "30072617"
"RoomLength" => 1.52
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-23T20:39:57.22Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30072617/590-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 20.4
+"OriginalEntryTimestamp": "2026-07-23T20:39:57.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30072617_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/26e0bd82121fc37038bafca076d121c9.webp"
"MediaSize" => 403927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-26e0bd82121fc37038bafca076d121c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30072617_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/e83826fb1f3ad40e2e9e2f4db4730788.webp"
"MediaSize" => 256279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-e83826fb1f3ad40e2e9e2f4db4730788.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30072617_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/30249d2ddd73db927f2c5b759b85da9d.webp"
"MediaSize" => 234667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-30249d2ddd73db927f2c5b759b85da9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30072617_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/c397b145242dbdefd54a4d3fd90e6344.webp"
"MediaSize" => 217802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-c397b145242dbdefd54a4d3fd90e6344.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30072617_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/8d30a354b7746ada9204ace2696bc588.webp"
"MediaSize" => 252909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-8d30a354b7746ada9204ace2696bc588.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30072617_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/0a32041a85b81077537d363eed4fe0d0.webp"
"MediaSize" => 216031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-0a32041a85b81077537d363eed4fe0d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30072617_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/7a865ae5e2ab0c9239136add6d05b23b.webp"
"MediaSize" => 237956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-7a865ae5e2ab0c9239136add6d05b23b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30072617_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/756322682d5c1d696b681cc8aeae31a1.webp"
"MediaSize" => 262750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-756322682d5c1d696b681cc8aeae31a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30072617_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/a9d94ece504a63466cb6c788959ddd44.webp"
"MediaSize" => 276412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-a9d94ece504a63466cb6c788959ddd44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30072617_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/4c1eef6b0cf1cbbd0e8be6ce2540b746.webp"
"MediaSize" => 260325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-4c1eef6b0cf1cbbd0e8be6ce2540b746.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30072617_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/6ef8e58b9b8791cf25df4a16bd723280.webp"
"MediaSize" => 231582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-6ef8e58b9b8791cf25df4a16bd723280.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30072617_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/24dd494b14d38bc69130420689b13050.webp"
"MediaSize" => 211156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-24dd494b14d38bc69130420689b13050.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30072617_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/14b3e098860a559e01d8a2b9cc411306.webp"
"MediaSize" => 430971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-14b3e098860a559e01d8a2b9cc411306.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30072617_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/f1ddea2b922bddd4e4eb5409fcdcafe0.webp"
"MediaSize" => 259509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-f1ddea2b922bddd4e4eb5409fcdcafe0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30072617_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/c1335ea2893927004c776c120d6de1b7.webp"
"MediaSize" => 255053
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-c1335ea2893927004c776c120d6de1b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30072617_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/6aca655408666d2d260fc454b4866218.webp"
"MediaSize" => 282207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-6aca655408666d2d260fc454b4866218.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30072617_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/a0200e44a5d0537ffc357b50dfb75141.webp"
"MediaSize" => 263291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-a0200e44a5d0537ffc357b50dfb75141.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30072617_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/5decb18b4577b637a098eb335ac9dad7.webp"
"MediaSize" => 230977
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-5decb18b4577b637a098eb335ac9dad7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30072617_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/09b9ba36223c91f3bbc3550cf8074231.webp"
"MediaSize" => 294020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-09b9ba36223c91f3bbc3550cf8074231.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30072617_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/89ce8cf42117ba368a9cd9182bae2372.webp"
"MediaSize" => 334096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-89ce8cf42117ba368a9cd9182bae2372.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30072617_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/e00dce50e788c700940605a5d1d7f601.webp"
"MediaSize" => 303575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-e00dce50e788c700940605a5d1d7f601.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30072617_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/10988a64aef2d31cb7a054d67ed434de.webp"
"MediaSize" => 315144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-10988a64aef2d31cb7a054d67ed434de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30072617_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/8bf0dacea67fe857fcc816e64afac3a8.webp"
"MediaSize" => 256830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-8bf0dacea67fe857fcc816e64afac3a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30072617_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072617/a38003e081715eb1899f381ea673f11a.webp"
"MediaSize" => 226795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072617/thumbnail-a38003e081715eb1899f381ea673f11a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13599574"
"ResourceRecordKey" => "30072617"
"ModificationTimestamp" => "2026-07-23T20:39:57.19Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072617')"
+"ID": "1654473"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25374
+post_id: "1652862"
+post_author: 1
+"ListingKey": "30072345"
+"ListingId": "40850466"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:05:19Z"
+"RFModificationTimestamp": "2026-07-23T20:17:06Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1169.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "590 NORTH SERVICE Road Unit# 50, Stoney Creek, Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.6970371
1 => 43.2332173
]
+"Latitude": 43.2332173
+"Longitude": -79.6970371
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 50 at 590 North Service Road in Stoney Creek, a beautifully maintained and affordable home built in 2020, offering modern living in one of the city's most convenient and rapidly growing communities. Whether you're a first time buyer, young professional, downsizer, or investor, this home delivers the perfect combination of style, comfort, and location. Nestled in a prime Stoney Creek setting, this property offers stunning escarpment views and is located just moments from the lake, giving you the best of both natural beauty and urban convenience. Enjoy easy access to waterfront parks, walking and biking trails, local beaches, and scenic outdoor spaces while still being close to everything you need for day to day living. Inside, you’ll find a modern layout designed for today’s lifestyle with bright living spaces, contemporary finishes, and a welcoming atmosphere throughout. Built in 2020, this newer home provides peace of mind delivers the perfect combination of style, comfort, and location. Nestled in a prime Stoney Creek setting, this with updated construction, energy efficiency, and low maintenance living. The location is truly unbeatable. Situated near the popular Costco Plaza, you are just minutes away from shopping, restaurants, cafes, fitness centres, and everyday amenities. Commuters will appreciate the quick access to the QEW, Red Hill Valley Parkway, and major routes connecting you to Hamilton, Niagara, and the GTA. Offering incredible value in an exceptional location, Unit 50 at 590 North Service Road is your opportunity to enjoy modern living surrounded by convenience, nature, and breathtaking escarpment scenery. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "117"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T20:17:01.549035+00:00"
+"Directions": "QEW Exit Fruitland, Left Onto Lakeview Dr, Continue Onto North Service Rd, Left Into Complex, Property On Outer Perimeter Facing Highway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T19:59:37Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T19:59:37Z"
+"Stories": "3.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4098.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1691937626"
"RoomType" => "4pc Bathroom"
"ListingId" => "40850466"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30072345"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T19:59:37.75Z"
]
1 => array:11 [
"RoomKey" => "1691937627"
"RoomType" => "Bedroom"
"ListingId" => "40850466"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30072345"
"RoomLength" => null
"RoomDimensions" => "13'5'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T19:59:37.75Z"
]
2 => array:11 [
"RoomKey" => "1691937628"
"RoomType" => "Primary Bedroom"
"ListingId" => "40850466"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "30072345"
"RoomLength" => null
"RoomDimensions" => "14'11'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T19:59:37.75Z"
]
3 => array:11 [
"RoomKey" => "1691937629"
"RoomType" => "2pc Bathroom"
"ListingId" => "40850466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072345"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T19:59:37.75Z"
]
4 => array:11 [
"RoomKey" => "1691937630"
"RoomType" => "Dining room"
"ListingId" => "40850466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072345"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 7'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T19:59:37.75Z"
]
5 => array:11 [
"RoomKey" => "1691937631"
"RoomType" => "Living room"
"ListingId" => "40850466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072345"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T19:59:37.75Z"
]
6 => array:11 [
"RoomKey" => "1691937632"
"RoomType" => "Kitchen"
"ListingId" => "40850466"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30072345"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T19:59:37.75Z"
]
7 => array:11 [
"RoomKey" => "1691937633"
"RoomType" => "Foyer"
"ListingId" => "40850466"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30072345"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-23T19:59:37.75Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30072345/590-north-service-road-unit-50-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2208479"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299867"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1169
+"OriginalEntryTimestamp": "2026-07-23T19:59:37.73Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1454953"
+"CoListOfficeNationalAssociationId": "1477945"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30072345_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/15ffbdb1fe736e1a4511e09dfbc9dc05.webp"
"MediaSize" => 151966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-15ffbdb1fe736e1a4511e09dfbc9dc05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30072345_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/a9ce850921229c30efec5354d3a58ec5.webp"
"MediaSize" => 98775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-a9ce850921229c30efec5354d3a58ec5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30072345_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/634b55c6f4c5f5933c003e3819d62799.webp"
"MediaSize" => 144775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-634b55c6f4c5f5933c003e3819d62799.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30072345_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/977c8ecb91f7a6041619ed60ddd30116.webp"
"MediaSize" => 157289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-977c8ecb91f7a6041619ed60ddd30116.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30072345_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/3c25cc46f8201c3c1e9b4a1abc62b16e.webp"
"MediaSize" => 98371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-3c25cc46f8201c3c1e9b4a1abc62b16e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30072345_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/177f82a131cd49b63a17d2ea2ded7f0c.webp"
"MediaSize" => 89677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-177f82a131cd49b63a17d2ea2ded7f0c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30072345_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/99a8fc54158a93985e13539f601fd5de.webp"
"MediaSize" => 82113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-99a8fc54158a93985e13539f601fd5de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30072345_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/b53c82ae062eaee261b6d877d2937295.webp"
"MediaSize" => 92748
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-b53c82ae062eaee261b6d877d2937295.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30072345_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/afb33b060d136b7130772057838aacb4.webp"
"MediaSize" => 83546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-afb33b060d136b7130772057838aacb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30072345_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/59fc9a4718d4e763dbd8ee70511ea660.webp"
"MediaSize" => 88315
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-59fc9a4718d4e763dbd8ee70511ea660.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30072345_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/44c3e559e26d53af76241167dbee46b0.webp"
"MediaSize" => 99442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-44c3e559e26d53af76241167dbee46b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30072345_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/ffb7fae736ee1b27c09b1a64f3c5d821.webp"
"MediaSize" => 107709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-ffb7fae736ee1b27c09b1a64f3c5d821.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30072345_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/b242c4268bb3e3c94d09c1aed9372f34.webp"
"MediaSize" => 100646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-b242c4268bb3e3c94d09c1aed9372f34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30072345_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/139b5e95e286b0110868f66649e5dd9e.webp"
"MediaSize" => 89712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-139b5e95e286b0110868f66649e5dd9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30072345_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/3f31252acae474c534e405e93810305f.webp"
"MediaSize" => 82762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-3f31252acae474c534e405e93810305f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30072345_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/eec18f19b320cf20a11d732bb80d4d88.webp"
"MediaSize" => 181310
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-eec18f19b320cf20a11d732bb80d4d88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30072345_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/72b0865833b2452645a90482f0e6439a.webp"
"MediaSize" => 90187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30072345/thumbnail-72b0865833b2452645a90482f0e6439a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40850466"
"ResourceRecordKey" => "30072345"
"ModificationTimestamp" => "2026-07-23T19:59:37.73Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30072345_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30072345/73543f48924c27c0934bf321e5e3ab87.webp"
"MediaSize" => 100787
"MediaType" => "webp"
…8
]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072345')"
+"ID": "1652862"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25371
+post_id: "1646780"
+post_author: 1
+"ListingKey": "30062350"
+"ListingId": "X13590038"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-22T14:15:09Z"
+"RFModificationTimestamp": "2026-07-22T14:19:59Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E4Z8"
+"UnparsedAddress": "3 WATERFORD CRESCENT, Hamilton (Lakeshore), Ontario L8E4Z8"
+"Coordinates": array:2 [
0 => -79.689776
1 => 43.230707
]
+"Latitude": 43.230707
+"Longitude": -79.689776
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "5 Reasons you will love 3 Waterford Crescent! 1. You'll enjoy 3 bedrooms, 3 bathrooms, and 1819sqft of space, giving your family plenty of space to enjoy, or grow. 2. Located within a 5-10 minute drive to restaurants, groceries, elementary schools, high schools, college, the QEW highway, and GO Train access. This is the perfect location. 3. Waterford Park is right across the street, great for your young ones to play and meet new friends, while you can keep a safe eye on them from home. 4. Quick access to the Newport Yacht Club, a boat dock, and 5 minute walk to the Lake Ontario waterfront. 5. Ample space in the backyard, with the included gazebo, for entertaining guests or for your own enjoyment! (id:62650)"
+"Appliances": array:3 [
0 => "Central Vacuum"
1 => "Window Coverings"
2 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T23:01:06.804759+00:00"
+"Directions": "Fruitland / North Service Road"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2046552"
+"ListOfficeKey": "275438"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "21.3 x 116.6 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-07-21T20:40:53Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-22T14:09:55Z"
+"Stories": "2.0"
+"StreetName": "Waterford"
+"StreetNumber": "3"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5090.38"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30062350/3-waterford-crescent-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 21.3
+"OriginalEntryTimestamp": "2026-07-21T20:40:53.63Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1322432"
+"ListOfficeNationalAssociationId": "1265158"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30062350')"
+"ID": "1646780"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+post_id: "1644847"
+post_author: 1
+"ListingKey": "30060200"
+"ListingId": "X13588188"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T00:10:04Z"
+"RFModificationTimestamp": "2026-07-23T00:20:33Z"
+"ListPrice": 619000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "15 - 590 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.6976368
1 => 43.2342295
]
+"Latitude": 43.2342295
+"Longitude": -79.6976368
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To This Beautifully Maintained 2-Bedroom, 3-Bathroom Condo Townhome OfferingApproximately 1,300 Sq. Ft. Of Stylish, Carpet-Free Living In The Highly Sought-After FiftyPoint Waterfront Community. The Bright, Open-Concept Main Floor Features A Modern Kitchen WithQuartz Countertops, Stainless Steel Appliances, Ample Cabinetry And A Breakfast Bar, FlowingSeamlessly Into The Spacious Living And Dining Areas. Enjoy Two Open Balconies On The East AndWest Sides-Perfect For Taking In Both The Sunrise And Sunset and enjoying BBQs. Upstairs Offers A GenerousPrimary Suite With A Walk-In Closet And Private Ensuite, A Spacious Second Bedroom, A FullBathroom And Convenient Upper-Level Laundry. Complete With An Attached Garage And PrivateDriveway. Walking Distance To The Lake Ontario Waterfront, Scenic Trails And Marina, With A Children's Playground Conveniently Located Across The Street. Minutes To Costco, Shopping,Restaurants, The QEW And Future Confederation GO Station. Move-In Ready And Perfect For First-Time Buyers, Professionals, Downsizers Or Investors! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Window Coverings"
]
+"AssociationFee": "411.5"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T16:03:19.666817+00:00"
+"Directions": "Cross Streets: Lakeview/North Service Rd. ** Directions: Lakeview To North Service Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1669786"
+"ListOfficeKey": "256963"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T15:40:07Z"
+"PhotosCount": 23
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T00:03:20Z"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3245.55"
+"Rooms": array:7 [
0 => array:11 [ …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": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30060200/15-590-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Properties Limited"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-07-21T15:40:07.41Z"
+"ListAgentNationalAssociationId": "1170063"
+"ListOfficeNationalAssociationId": "1237568"
+"Media": array:23 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30060200')"
+"ID": "1644847"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+post_id: "1644102"
+post_author: 1
+"ListingKey": "30058432"
+"ListingId": "40849792"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T00:35:16Z"
+"RFModificationTimestamp": "2026-07-21T01:38:34Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1310.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "590 NORTH SERVICE Road Unit# 44, Stoney Creek, Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.6985622
1 => 43.2328637
]
+"Latitude": 43.2328637
+"Longitude": -79.6985622
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stylish freehold townhome steps from the lake. This bright, modern 2-bedroom home offers 1,310 sq. ft. above ground with 9-foot ceilings, an open-concept layout, and a sleek kitchen designed for entertaining. The sun-filled living and dining area walks out to a private balcony, perfect for morning coffee or evening drinks. Located minutes from Confederation Beach Park, the harbour, and the GO Station, this home is ideal for commuters, first-time buyers, or downsizers seeking low-maintenance living in a vibrant lakeside community. Set back within the complex for quiet enjoyment, with quick QEW access when you need it. A move-in-ready alternative to condo living — enjoy space, privacy, and ownership. (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
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T01:38:29.987225+00:00"
+"Directions": "Fruitland/Lakeview/N Service"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2047928"
+"ListOfficeKey": "54949"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-21T00:29:39Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T00:29:39Z"
+"Stories": "3.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4339"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30058432/590-north-service-road-unit-44-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1310
+"OriginalEntryTimestamp": "2026-07-21T00:29:39.58Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1323283"
+"ListOfficeNationalAssociationId": "1003557"
+"Media": array:19 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30058432')"
+"ID": "1644102"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+post_id: "1643788"
+post_author: 1
+"ListingKey": "30058304"
+"ListingId": "X13586290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-20T23:45:02Z"
+"RFModificationTimestamp": "2026-07-21T00:50:02Z"
+"ListPrice": 525000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "44 - 590 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.697576
1 => 43.233855
]
+"Latitude": 43.233855
+"Longitude": -79.697576
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Stylish freehold townhome steps from the lake. This bright, modern 2-bedroom home offers 1,310 sq. ft. above ground with 9-foot ceilings, an open-concept layout, and a sleek kitchen designed for entertaining. The sun-filled living and dining area walks out to a private balcony, perfect for morning coffee or evening drinks. Located minutes from Confederation Beach Park, the harbour, and the GO Station, this home is ideal for commuters, first-time buyers, or downsizers seeking low-maintenance living in a vibrant lakeside community. Set back within the complex for quiet enjoyment, with quick QEW access when you need it. A move-in-ready alternative to condo living - enjoy space, privacy, and ownership. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "117"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T00:49:56.116531+00:00"
+"Directions": "Cross Streets: Fruitland / Lakeview / N Service. ** Directions: -."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Slab"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093886"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.4 x 41.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T23:38:02Z"
+"PhotosCount": 19
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-20T23:38:02Z"
+"Stories": "3.0"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4339"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30058304/44-590-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 20.4
+"OriginalEntryTimestamp": "2026-07-20T23:38:02.46Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1366297"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:19 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30058304')"
+"ID": "1643788"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23542
+post_id: "1638064"
+post_author: 1
+"ListingKey": "30049677"
+"ListingId": "X13578144"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T18:15:06Z"
+"RFModificationTimestamp": "2026-07-21T18:22:15Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0C3"
+"UnparsedAddress": "128 PALACEBEACH TRAIL, Hamilton (Lakeshore), Ontario L8E0C3"
+"Coordinates": array:2 [
0 => -79.677271
1 => 43.22798
]
+"Latitude": 43.22798
+"Longitude": -79.677271
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to lakeside living, just steps from Lake Ontario in Stoney Creek! This immaculate freehold townhome is the perfect home, boasting excellent layout with 3 spacious bedrooms, upstairs laundry, and inside access to the garage. The bright living spaces flow effortlessly to a large, private backyard ideal for entertaining. Loaded with premium updates, the home features brand-new designer light fixtures, a newer roof (2023), and newer stainless steel appliances (2024). Located in a quieter, premium neighbourhood just minutes from Fifty Point, Costco, major retail, and the QEW for an easy commute to Toronto or Niagara-On-The-Lake - This is the ideal home for a family wanting to live in a peaceful lakeside community. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:48:21.074115+00:00"
+"Directions": "Cross Streets: Dartmouth/N.Service. ** Directions: Fruitland - North Service Rd - Dartmouth."
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2147415"
+"ListOfficeKey": "280315"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.5 x 86.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T19:39:30Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T18:10:04Z"
+"Stories": "2.0"
+"StreetName": "Palacebeach"
+"StreetNumber": "128"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "4552.1"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=Xx3Xujnnc6A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30049677/128-palacebeach-trail-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.6
+"OriginalEntryTimestamp": "2026-07-17T19:39:30.72Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1398576"
+"ListOfficeNationalAssociationId": "1312645"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049677')"
+"ID": "1638064"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "1638384"
+post_author: 1
+"ListingKey": "30049316"
+"ListingId": "40848859"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T17:35:20Z"
+"RFModificationTimestamp": "2026-07-21T17:47:42Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1341.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0C3"
+"UnparsedAddress": "128 PALACEBEACH Trail, Stoney Creek, Ontario L8E0C3"
+"Coordinates": array:2 [
0 => -79.6772597
1 => 43.2279711
]
+"Latitude": 43.2279711
+"Longitude": -79.6772597
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to lakeside living, just steps from Lake Ontario in Stoney Creek! This immaculate freehold townhome is the perfect home, boasting excellent layout with 3 spacious bedrooms, upstairs laundry, and inside access to the garage. The bright living spaces flow effortlessly to a large, private backyard ideal for entertaining. Loaded with premium updates, the home features brand-new designer light fixtures, a newer roof (2023), and newer stainless steel appliances (2024). Located in a quieter, premium neighbourhood just minutes from Fifty Point, Costco, major retail, and the QEW for an easy commute to Toronto or Niagara - This is the ideal home for a family wanting to live in a peaceful lakeside community. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T23:15:11.539402+00:00"
+"Directions": "Fruitland - North Service Rd - Dartmouth"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2197911"
+"ListOfficeKey": "294490"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-20T14:41:21Z"
+"PhotosCount": 34
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T17:29:29Z"
+"Stories": "2.0"
+"StreetName": "PALACEBEACH"
+"StreetNumber": "128"
+"StreetSuffix": "Trail"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4552.1"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=Xx3Xujnnc6A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30049316/128-palacebeach-trail-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "RM2-27"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1341
+"OriginalEntryTimestamp": "2026-07-17T18:48:17.15Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1446283"
+"ListOfficeNationalAssociationId": "1439453"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30049316')"
+"ID": "1638384"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25377
+post_id: "1634853"
+post_author: 1
+"ListingKey": "30047332"
+"ListingId": "40849029"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-17T15:05:28Z"
+"RFModificationTimestamp": "2026-07-17T15:16:11Z"
+"ListPrice": 969899.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.34
+"LivingArea": 1874.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5H4"
+"UnparsedAddress": "328 MCNEILLY Road, Stoney Creek, Ontario L8E5H4"
+"Coordinates": array:2 [
0 => -79.6689497
1 => 43.2162397
]
+"Latitude": 43.2162397
+"Longitude": -79.6689497
+"YearBuilt": 1968
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to 328 McNeilly Road—a bright and welcoming 3-bedroom sidesplit set on an oversized lot surrounded by lush landscaping, mature greenery, and fruit trees, offering the perfect blend of privacy and convenience. Filled with natural light, this home features a beautifully updated kitchen with quartz countertops, stainless steel appliances, a stylish tile backsplash, and plenty of space to gather. The lower-level family room offers a cozy retreat with a feature accent wall, built-in cabinetry, and a walk-up to the backyard. This level also features a beautifully updated bathroom with a walk-in tile shower, heated floors, and a convenient laundry area. Relax in the 3-season sunroom overlooking the expansive, beautifully landscaped backyard. Additional highlights include a durable metal roof, updated electrical panel, pot lights, a large concrete driveway, and an attached garage. Ideally located in Stoney Creek with quick access to the QEW, parks, schools, shopping, and everyday amenities, this home is perfect for commuters while offering a peaceful, established setting. This one truly needs to be seen to be appreciated. Book your private showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-17T15:16:08.037206+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1535236"
+"ListOfficeKey": "261116"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Country residential"
]
+"LotSizeDimensions": "0.34"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-17T15:03:01Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-17T15:03:01Z"
+"Stories": "2.0"
+"StreetName": "MCNEILLY"
+"StreetNumber": "328"
+"StreetSuffix": "Road"
+"SubdivisionName": "514 - Winona Industrial"
+"TaxAnnualAmount": "5172.23"
+"VirtualTourURLUnbranded": "https://oatstudio.aryeo.com/sites/edvpokjq/unbranded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30047332/328-mcneilly-road-stoney-creek"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2204990"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "261116"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 105.0
+"AboveGradeFinishedArea": 1280
+"BelowGradeFinishedArea": 594
+"OriginalEntryTimestamp": "2026-07-17T15:00:05.64Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1144187"
+"ListOfficeNationalAssociationId": "1228241"
+"CoListAgentNationalAssociationId": "1453622"
+"CoListOfficeNationalAssociationId": "1228241"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30047332')"
+"ID": "1634853"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 81
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]