array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29235240/Property?$select=ALL&$top=20&$filter=ListingKey eq 29235240&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29235240/Property?$select=ALL&$top=20&$filter=ListingKey eq 29235240&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23484
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23486
+post_id: "523151"
+post_author: 1
+"ListingKey": "29235240"
+"ListingId": "X12681882"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T14:41:05Z"
+"RFModificationTimestamp": "2026-01-13T14:46:51Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E5C2"
+"UnparsedAddress": "39 SUNROW GATE, Hamilton (Lakeshore), Ontario L8E5C2"
+"Coordinates": array:2 [
0 => -79.6835545
1 => 43.2333366
]
+"Latitude": 43.2333366
+"Longitude": -79.6835545
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Executive detached home offering over 3,600 sq. ft. of refined above grade living space, ideally positioned just steps from the shores of Lake Ontario. From the moment you arrive, this home impresses with it's grand foyer featuring elegant tiled flooring, double front-entry closets and a main floor office framed by custom glass doors and panoramic windows. The main level is thoughtfully designed for both upscale entertaining and everyday living, anchored by a dramatic living room with soaring cathedral ceilings, gas fireplace and hardwood flooring throughout. An oversized formal dining area seamlessly flows through to the custom kitchen showcasing sleek lacquer cabinetry, an abundance of pot lighting, quartz countertops, tiled flooring, built-in wall oven, gas range and a commercial style refrigerator and freezer. Luxury continues throughout with built-in surround sound on every level, including the garage. The main floor is completed by a spacious walk-in pantry, stylish two-piece powder room and a main floor laundry room. An open riser staircase leads to the second level, where a sun filled family room overlooks the main living space and opens to a balcony that enhances the home's open and airy architectural design. The primary retreat offers space not only for rest but relaxation with room for a private sitting area, a spa-inspired five-piece ensuite, custom walk-in closet and full surround sound system. Three additional generously sized bedrooms include one with a private four piece ensuite, while the remaining two are serviced by a beautifully finished shared 4 piece bath. The backyard is a great size to be able to enjoy the outdoor space but small enough where is won't consume lots of upkeep. Ideally located with quick access to the QEW, parks, schools, waterfront trails and the Fifty Point Yacht Club. This distinguished residence delivers an exceptional blend of luxury, lifestyle and convenience in one of Stoney Creek's most sought after neighbourhoods. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-01-09T21:11:52.765066+00:00"
+"Directions": "Cross Streets: North Service Rd. ** Directions: North Service Rd to Jones Rd to Sunrow Gate."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2032323"
+"ListOfficeKey": "283968"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "47.5 x 90.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-09T20:26:32Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T14:26:49Z"
+"Stories": "2.0"
+"StreetName": "Sunrow"
+"StreetNumber": "39"
+"StreetSuffix": "Gate"
+"TaxAnnualAmount": "12859"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/VHlSvyl5qR4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1559881033"
"RoomType" => "Office"
"ListingId" => "X12681882"
"RoomLevel" => "Main level"
"RoomWidth" => 3.51
"ListingKey" => "29235240"
"RoomLength" => 4.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.57Z"
]
1 => array:11 [
"RoomKey" => "1559881034"
"RoomType" => "Other"
"ListingId" => "X12681882"
"RoomLevel" => "Basement"
"RoomWidth" => 10.9
"ListingKey" => "29235240"
"RoomLength" => 17.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.58Z"
]
2 => array:11 [
"RoomKey" => "1559881035"
"RoomType" => "Dining room"
"ListingId" => "X12681882"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29235240"
"RoomLength" => 5.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.59Z"
]
3 => array:11 [
"RoomKey" => "1559881036"
"RoomType" => "Other"
"ListingId" => "X12681882"
"RoomLevel" => "Basement"
"RoomWidth" => 2.01
"ListingKey" => "29235240"
"RoomLength" => 6.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.6Z"
]
4 => array:11 [
"RoomKey" => "1559881037"
"RoomType" => "Family room"
"ListingId" => "X12681882"
"RoomLevel" => "Main level"
"RoomWidth" => 4.22
"ListingKey" => "29235240"
"RoomLength" => 4.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.61Z"
]
5 => array:11 [
"RoomKey" => "1559881038"
"RoomType" => "Kitchen"
"ListingId" => "X12681882"
"RoomLevel" => "Main level"
"RoomWidth" => 6.45
"ListingKey" => "29235240"
"RoomLength" => 10.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.61Z"
]
6 => array:11 [
"RoomKey" => "1559881039"
"RoomType" => "Laundry room"
"ListingId" => "X12681882"
"RoomLevel" => "Main level"
"RoomWidth" => 1.93
"ListingKey" => "29235240"
"RoomLength" => 3.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.62Z"
]
7 => array:11 [
"RoomKey" => "1559881040"
"RoomType" => "Sitting room"
"ListingId" => "X12681882"
"RoomLevel" => "Second level"
"RoomWidth" => 3.66
"ListingKey" => "29235240"
"RoomLength" => 5.44
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.63Z"
]
8 => array:11 [
"RoomKey" => "1559881041"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12681882"
"RoomLevel" => "Second level"
"RoomWidth" => 5.94
"ListingKey" => "29235240"
"RoomLength" => 6.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.63Z"
]
9 => array:11 [
"RoomKey" => "1559881042"
"RoomType" => "Bedroom"
"ListingId" => "X12681882"
"RoomLevel" => "Second level"
"RoomWidth" => 3.56
"ListingKey" => "29235240"
"RoomLength" => 5.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.63Z"
]
10 => array:11 [
"RoomKey" => "1559881043"
"RoomType" => "Bedroom"
"ListingId" => "X12681882"
"RoomLevel" => "Second level"
"RoomWidth" => 4.42
"ListingKey" => "29235240"
"RoomLength" => 5.72
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.63Z"
]
11 => array:11 [
"RoomKey" => "1559881044"
"RoomType" => "Bedroom"
"ListingId" => "X12681882"
"RoomLevel" => "Second level"
"RoomWidth" => 3.51
"ListingKey" => "29235240"
"RoomLength" => 6.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-13T14:26:49.64Z"
]
]
+"ListAOR": "Niagara"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29235240/39-sunrow-gate-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "R2-62"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 47.6
+"OriginalEntryTimestamp": "2026-01-09T20:26:32.22Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:41 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6398399000"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/fc3a7b4a188c5d852ab9d6059225d08f.webp"
"MediaSize" => 253320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-fc3a7b4a188c5d852ab9d6059225d08f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6398399014"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/9daaf227cae3d4ef1953e2088ca88857.webp"
"MediaSize" => 238879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-9daaf227cae3d4ef1953e2088ca88857.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6398399049"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/95e52d8e5d9196556d1a4088f0df732c.webp"
"MediaSize" => 304564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-95e52d8e5d9196556d1a4088f0df732c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6398399070"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/601dec1bd89078ebe51342fd3b3a2ecb.webp"
"MediaSize" => 313441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-601dec1bd89078ebe51342fd3b3a2ecb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6398399095"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/65b65da47ceaa4686cf19b02ba02966b.webp"
"MediaSize" => 300427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-65b65da47ceaa4686cf19b02ba02966b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6398399127"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/9d28a7b75bd912089da04a00b6a80f53.webp"
"MediaSize" => 135546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-9d28a7b75bd912089da04a00b6a80f53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6398399169"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/59e9ec810c81ac8743d0236d7039bb1a.webp"
"MediaSize" => 126744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-59e9ec810c81ac8743d0236d7039bb1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6398399215"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/c205255a0bd37dcd38f2ae08f6e79eca.webp"
"MediaSize" => 129661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-c205255a0bd37dcd38f2ae08f6e79eca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6398399220"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/8633d6eaeb429d7165ee5cd68794db2f.webp"
"MediaSize" => 181794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-8633d6eaeb429d7165ee5cd68794db2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6398399253"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/fe55b80b3d8165b0432ee7681a61022f.webp"
"MediaSize" => 116231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-fe55b80b3d8165b0432ee7681a61022f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6398399279"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/84d279c748787c52517ecee254be7fb9.webp"
"MediaSize" => 167786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-84d279c748787c52517ecee254be7fb9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6398399309"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/e1e53a28f7849718b0cdfdf7c8e4b030.webp"
"MediaSize" => 129280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-e1e53a28f7849718b0cdfdf7c8e4b030.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6398399322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/58a442f304aadca537a8e57e4e2aa079.webp"
"MediaSize" => 189022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-58a442f304aadca537a8e57e4e2aa079.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6398399361"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/415a2f3540bb8b9193868f7514d64b4b.webp"
"MediaSize" => 190038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-415a2f3540bb8b9193868f7514d64b4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6398399383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/ddd7a58ee711ff984814366a2093591b.webp"
"MediaSize" => 176557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-ddd7a58ee711ff984814366a2093591b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6398399397"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/bc6acaeecd0b0d50b6d9f0ae8af0d3de.webp"
"MediaSize" => 151704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-bc6acaeecd0b0d50b6d9f0ae8af0d3de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6398399408"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/f8b147230bf43e782a1aaf8fc952972d.webp"
"MediaSize" => 142372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-f8b147230bf43e782a1aaf8fc952972d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6398399441"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/fc219e56d1dc6b0e5f755ef4f2596a48.webp"
"MediaSize" => 105724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-fc219e56d1dc6b0e5f755ef4f2596a48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6398399498"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/160b0b48ccab03d7ba45820a5171c076.webp"
"MediaSize" => 82952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-160b0b48ccab03d7ba45820a5171c076.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6398399510"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/c3561f7b7cee95c0e074ab960e259d39.webp"
"MediaSize" => 104550
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-c3561f7b7cee95c0e074ab960e259d39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6398399519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/94fee35ee10f6794f4098a761342475a.webp"
"MediaSize" => 108386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-94fee35ee10f6794f4098a761342475a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6398399535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/43aeb23f1ba8ddbc84fb5dc46243a401.webp"
"MediaSize" => 179380
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-43aeb23f1ba8ddbc84fb5dc46243a401.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6398399560"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/91de651234637b9c6084fd1318d40cca.webp"
"MediaSize" => 120740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-91de651234637b9c6084fd1318d40cca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6398399582"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/c337450aef20dcb24f5b3f9e3b46a0b7.webp"
"MediaSize" => 180190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-c337450aef20dcb24f5b3f9e3b46a0b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6398399590"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/4cf713491c8589d6bd384e29a2f5a584.webp"
"MediaSize" => 90283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-4cf713491c8589d6bd384e29a2f5a584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6398399605"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/9662766da70031d07ab4d3187efcea39.webp"
"MediaSize" => 84452
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-9662766da70031d07ab4d3187efcea39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6398399627"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/cc4c408329cbf33f0afcbe496a3d4f02.webp"
"MediaSize" => 147653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-cc4c408329cbf33f0afcbe496a3d4f02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6398399650"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/828b1e901e28304d3c8fffd117c3bf2b.webp"
"MediaSize" => 146179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-828b1e901e28304d3c8fffd117c3bf2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6398399671"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/ec5d4d73d67cd95351470b56f24b6988.webp"
"MediaSize" => 73524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-ec5d4d73d67cd95351470b56f24b6988.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6398399680"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/bfd75b0427c3b92865e98804a004f3e0.webp"
"MediaSize" => 95066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-bfd75b0427c3b92865e98804a004f3e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6398399684"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/a0dd0f6ba3c3d17cc77c6d62f6e5520b.webp"
"MediaSize" => 160321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-a0dd0f6ba3c3d17cc77c6d62f6e5520b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6398399689"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/6458ef142e39f67b4d784f0a4312f40b.webp"
"MediaSize" => 80826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-6458ef142e39f67b4d784f0a4312f40b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6398399707"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/1c0105b11073cd6a17359e1ff1a0a5e2.webp"
"MediaSize" => 95367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-1c0105b11073cd6a17359e1ff1a0a5e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6398399717"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/2af8be6bc4c25b74a21b466ee468ea94.webp"
"MediaSize" => 194279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-2af8be6bc4c25b74a21b466ee468ea94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6398399732"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/ded69bfc09199eca9e6cb2103c5e9e9d.webp"
"MediaSize" => 105919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-ded69bfc09199eca9e6cb2103c5e9e9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6398399749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/057ed548d0b35efbf496291509722ef9.webp"
"MediaSize" => 209459
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-057ed548d0b35efbf496291509722ef9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6398399762"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/2e1b74dffe801b811f996c3bb121dca3.webp"
"MediaSize" => 254848
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-2e1b74dffe801b811f996c3bb121dca3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6398399770"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/923f6edbeeab08162f28dcc5b2ff8877.webp"
"MediaSize" => 281868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-923f6edbeeab08162f28dcc5b2ff8877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6398399784"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/0f9c735691f6d6626c541449f47b03b3.webp"
"MediaSize" => 112429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-0f9c735691f6d6626c541449f47b03b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6398399800"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/c3b190a77dd7fe9bb2ef55f725924830.webp"
"MediaSize" => 124220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-c3b190a77dd7fe9bb2ef55f725924830.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
40 => array:13 [
"Order" => 40
"MediaKey" => "6398399811"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29235240/0d36f55ce4c89822abf6281027aac67f.webp"
"MediaSize" => 69006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29235240/thumbnail-0d36f55ce4c89822abf6281027aac67f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12681882"
"ResourceRecordKey" => "29235240"
"ModificationTimestamp" => "2026-01-09T20:26:32.23Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Chris Hendriks"
"MemberFirstName" => "Chris"
"MemberLastName" => "Hendriks"
"MemberMlsId" => "9641517"
"OriginatingSystemName" => 26
"MemberKey" => "2032323"
"ModificationTimestamp" => "2025-12-26T20:36:39Z"
"MemberStatus" => "Active"
"OfficeKey" => "283968"
"MemberAOR" => "Niagara"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "114"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:1 [ …1]
"MemberOfficePhone" => "905-650-5221"
"MemberSocialMedia" => array:6 [ …6]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2017-05-03T13:04:00Z"
"MemberNationalAssociationId" => "1309530"
"OfficeNationalAssociationId" => "1337412"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "RE/MAX HENDRIKS TEAM REALTY"
"OfficePhone" => "289-723-2132"
"OfficeMlsId" => "467900"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "283968"
"ModificationTimestamp" => "2025-10-11T08:46:49Z"
"OfficeAddress1" => "145 King Street"
"OfficeCity" => "ST. CATHARINES"
"OfficePostalCode" => "L2R3J"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Niagara"
"OfficeType" => "Firm"
"OfficeAORKey" => "114"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2018-09-20T15:29:00Z"
"OfficeNationalAssociationId" => "1337412"
"FranchiseNationalAssociationId" => "1183864"
"OfficeBrokerNationalAssociationId" => "1066650"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29235240')"
+"ID": "523151"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 283968/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283968&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283968/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283968&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25326
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25328
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX HENDRIKS TEAM REALTY"
+"OfficeEmail": null
+"OfficePhone": "289-723-2132"
+"OfficeMlsId": "467900"
+"ModificationTimestamp": "2025-10-11T08:46:49Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283968"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "145 King Street"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "ST. CATHARINES"
+"OfficePostalCode": "L2R3J"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Niagara"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1337412"
+"OriginalEntryTimestamp": "2018-09-20T15:29:00Z"
+"OfficeAORKey": "114"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "377539"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "283968"
"SocialMediaUrlOrId" => "http://www.niagarahomes.com/"
"ModificationTimestamp" => "2025-10-11T05:24:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1066650"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('283968')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2032323/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2032323&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2032323/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2032323&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25331
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 29235240" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24942
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235240/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235240&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235240/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29235240&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24924
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235240 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6835545 43.2333366)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235240 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6835545 43.2333366)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235240 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6835545 43.2333366)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29235240 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.6835545 43.2333366)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24859
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24793
+post_id: "535505"
+post_author: 1
+"ListingKey": "29252813"
+"ListingId": "X12697634"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-15T00:20:31Z"
+"RFModificationTimestamp": "2026-01-15T00:42:05Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0G1"
+"UnparsedAddress": "20 - 45 SEABREEZE CRESCENT, Hamilton (Stoney Creek), Ontario L8E0G1"
+"Coordinates": array:2 [
0 => -79.66767
1 => 43.225385
]
+"Latitude": 43.225385
+"Longitude": -79.66767
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful 3 Bedrooms, 3 washrooms home steps to the lake, very convenient family neighbourhood, close to shopping, schools, parks and highways, spacious bedrooms with lake view flawless laid our main floor with a fireplace and breakfast and dining areas, open to above foyer, spacious partly finished basement. Great scenery of Lake Ontario you will love going for a walk. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "200"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parcel of Tied Land"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Partially finished"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T00:41:56.201348+00:00"
+"Directions": "Mcneilly/North Service"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972788"
+"ListOfficeKey": "300374"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "23.1 x 83.1 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-15T00:13:51Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-15T00:13:51Z"
+"Stories": "2.0"
+"StreetName": "Seabreeze"
+"StreetNumber": "45"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4800"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [
"RoomKey" => "1560467490"
"RoomType" => "Great room"
"ListingId" => "X12697634"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29252813"
"RoomLength" => 6.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
1 => array:11 [
"RoomKey" => "1560467491"
"RoomType" => "Kitchen"
"ListingId" => "X12697634"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29252813"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
2 => array:11 [
"RoomKey" => "1560467492"
"RoomType" => "Foyer"
"ListingId" => "X12697634"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29252813"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
3 => array:11 [
"RoomKey" => "1560467493"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12697634"
"RoomLevel" => "Second level"
"RoomWidth" => 3.05
"ListingKey" => "29252813"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
4 => array:11 [
"RoomKey" => "1560467494"
"RoomType" => "Bedroom 2"
"ListingId" => "X12697634"
"RoomLevel" => "Second level"
"RoomWidth" => 2.74
"ListingKey" => "29252813"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
5 => array:11 [
"RoomKey" => "1560467495"
"RoomType" => "Bedroom 3"
"ListingId" => "X12697634"
"RoomLevel" => "Second level"
"RoomWidth" => 2.79
"ListingKey" => "29252813"
"RoomLength" => 4.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
6 => array:11 [
"RoomKey" => "1560467496"
"RoomType" => "Laundry room"
"ListingId" => "X12697634"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29252813"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
7 => array:11 [
"RoomKey" => "1560467497"
"RoomType" => "Utility room"
"ListingId" => "X12697634"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29252813"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-15T00:13:51.09Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252813/20-45-seabreeze-crescent-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 23.1
+"OriginalEntryTimestamp": "2026-01-15T00:13:51.05Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404962780"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/3ed74f6bc421e114d3b623ac732a489b.webp"
"MediaSize" => 383809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-3ed74f6bc421e114d3b623ac732a489b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404962793"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/74b4d1243cf9bd4ec638801e97c4670b.webp"
"MediaSize" => 231555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-74b4d1243cf9bd4ec638801e97c4670b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404962804"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/3060391c1a6913f347a1e349f2b900db.webp"
"MediaSize" => 130102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-3060391c1a6913f347a1e349f2b900db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404962816"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/4feb0efcf5f8f8cb96709903dfe8c030.webp"
"MediaSize" => 251815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-4feb0efcf5f8f8cb96709903dfe8c030.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404962828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/8a4f67f44c9eed2538b0b0bfda3498f2.webp"
"MediaSize" => 248190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-8a4f67f44c9eed2538b0b0bfda3498f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404962854"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/638b285cec74c68b6e4f6df57eaff4e7.webp"
"MediaSize" => 233179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-638b285cec74c68b6e4f6df57eaff4e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404962868"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/dc9db09cd9b580ff5363c0c1748558f7.webp"
"MediaSize" => 240982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-dc9db09cd9b580ff5363c0c1748558f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404962882"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/1269421b18640bff06843e1648603cd7.webp"
"MediaSize" => 237064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-1269421b18640bff06843e1648603cd7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404962897"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/fdf3bc6e909123fab99b553660e225a2.webp"
"MediaSize" => 388975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-fdf3bc6e909123fab99b553660e225a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404962912"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/364a055d8e3ea2ed4e34856899fddd6c.webp"
"MediaSize" => 301566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-364a055d8e3ea2ed4e34856899fddd6c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404962923"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/bf4645dc589ac38eed852ca093004ecc.webp"
"MediaSize" => 263424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-bf4645dc589ac38eed852ca093004ecc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404962941"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252813/ac99c714108b773690eefa66fb083df9.webp"
"MediaSize" => 358318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252813/thumbnail-ac99c714108b773690eefa66fb083df9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12697634"
"ResourceRecordKey" => "29252813"
"ModificationTimestamp" => "2026-01-15T00:13:51.06Z"
]
]
+"Member": array:1 [
0 => array:24 [
"MemberFullName" => "SAM GHOBRIAL"
"MemberFirstName" => "SAM"
"MemberLastName" => "GHOBRIAL"
"MemberMlsId" => "9558507"
"OriginatingSystemName" => 26
"MemberKey" => "1972788"
"ModificationTimestamp" => "2025-12-15T06:02:37Z"
"MemberStatus" => "Active"
"OfficeKey" => "300374"
"MemberAOR" => "Toronto"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberType" => "Salesperson"
"MemberAORKey" => "82"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberLanguages" => array:2 [ …2]
"MemberOfficePhone" => "416-918-0048"
"MemberSocialMedia" => array:1 [ …1]
"MemberTollFreePhone" => "416-918-0048"
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2014-04-09T00:28:00Z"
"MemberNationalAssociationId" => "1259832"
"OfficeNationalAssociationId" => "1487162"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "iCloud Realty Ltd."
"OfficePhone" => "905-507-4776"
"OfficeMlsId" => "20015510"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "300374"
"ModificationTimestamp" => "2025-11-14T00:54:17Z"
"OfficeAddress1" => "30 Eglinton Ave West Unit C12"
"OfficeCity" => "Mississauga"
"OfficePostalCode" => "L5R3E"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"OfficeFax" => "905-507-4779"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OfficeCountry" => "Canada"
"OriginalEntryTimestamp" => "2025-08-18T19:14:00Z"
"OfficeNationalAssociationId" => "1487162"
"OfficeBrokerNationalAssociationId" => "1125533"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252813')"
+"ID": "535505"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24871
+post_id: "535552"
+post_author: 1
+"ListingKey": "29251089"
+"ListingId": "40798532"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T19:45:51Z"
+"RFModificationTimestamp": "2026-01-15T00:04:47Z"
+"ListPrice": 3100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2841.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0C1"
+"UnparsedAddress": "100 WATERSHORE Drive Unit# 19, Stoney Creek, Ontario L8E0C1"
+"Coordinates": array:2 [
0 => -79.675003
1 => 43.229989
]
+"Latitude": 43.229989
+"Longitude": -79.675003
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't Miss This Rare Lakefront Bungalow on the Shores of Lake Ontario. Welcome to a truly exceptional opportunity— an exquisite 2,841 sq. ft. lakefront bungalow perfectly positioned along the sparkling shoreline of Lake Ontario offering breathtaking panoramic views. This brand-new floor plan has been meticulously crafted to maximize lake views and everyday livability. With 10' ceilings, 8' solid-core interior doors, hardwood floors, upgraded tile throughout, and an elegant oak staircase- this home exudes sophistication. The chef-inspired kitchen is as functional as it is striking, featuring extended-height cabinetry with crown moulding, premium quartz countertops, a stylish backsplash, and a large central island— ideal for both casual meals and upscale entertaining. As a purchaser, you’ll have the rare opportunity to fully customize your finishes at our brand-new design studio, guided by our expert design consultant and curated selection of elevated materials. An open-concept layout anchors the home’s living and dining areas, centered around a 46” gas fireplace with a stained wood beam mantle. Floor-to-ceiling lake-facing windows flood the space with natural light and showcase the unmatched views. Step through to the covered rear patio and enjoy year-round relaxation beside the water. Wake up to panoramic lake views from the luxurious primary bedroom, complete with a spa-like ensuite featuring a freestanding soaker tub, custom glass shower, dual vanities, and quartz countertops. Not to mention two additional bedrooms offering ensuite privilege and premium finishes, and a stylish 2-piece powder room. This home offers both peaceful lakeside living and convenient access to QEW, top-rated schools, shopping, and daily amenities. Enjoy the security of a sloped, granite capped revetment wall designed by a coastal engineer— a premium shoreline upgrade designed to safeguard your investment. *This home is pre-construction. Estimated closing 12 months after purchase. (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T00:04:22.760439+00:00"
+"Directions": "Fruitland to N. Service to Glover to Watershore."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Other"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025165"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T19:38:15Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T19:38:15Z"
+"Stories": "1.0"
+"StreetName": "WATERSHORE"
+"StreetNumber": "100"
+"StreetSuffix": "Drive"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"View": "Lake view"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1560357716"
"RoomType" => "Laundry room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
1 => array:11 [
"RoomKey" => "1560357717"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
2 => array:11 [
"RoomKey" => "1560357718"
"RoomType" => "5pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
3 => array:11 [
"RoomKey" => "1560357719"
"RoomType" => "2pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
4 => array:11 [
"RoomKey" => "1560357720"
"RoomType" => "Den"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
…4
]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29251089/100-watershore-drive-unit-19-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1986960"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55053"
+"GeocodeManualYN": true
+"ZoningDescription": "R2-66"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2841
+"OriginalEntryTimestamp": "2026-01-14T19:38:15.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:23 [ …23]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251089')"
+"ID": "535552"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24800
+post_id: "534950"
+post_author: 1
+"ListingKey": "29251667"
+"ListingId": "X12696554"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T20:56:05Z"
+"RFModificationTimestamp": "2026-01-14T23:21:02Z"
+"ListPrice": 3100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0C1"
+"UnparsedAddress": "19 - 100 WATERSHORE DRIVE, Hamilton (Stoney Creek), Ontario L8E0C1"
+"Coordinates": array:2 [
0 => -79.678046
1 => 43.231402
]
+"Latitude": 43.231402
+"Longitude": -79.678046
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Don't Miss This Rare Lakefront Bungalow on the Shores of Lake Ontario. Welcome to a truly exceptional opportunity- an exquisite 2,841 sq. ft. lakefront bungalow perfectly positioned along the sparkling shoreline of Lake Ontario offering breathtaking panoramic views. This brand-new floor plan has been meticulously crafted to maximize lake views and everyday livability. With 10' ceilings, 8' solid-core interior doors, hardwood floors, upgraded tile throughout, and an elegant oak staircase- this home exudes sophistication. The chef-inspired kitchen is as functional as it is striking, featuring extended-height cabinetry with crown moulding, premium quartz countertops, a stylish backsplash, and a large central island- ideal for both casual meals and upscale entertaining. As a purchaser, you'll have the rare opportunity to fully customize your finishes at our brand-new design studio, guided by our expert design consultant and curated selection of elevated materials. An open-concept layout anchors the home's living and dining areas, centered around a 46" gas fireplace with a stained wood beam mantle. Floor-to-ceiling lake-facing windows flood the space with natural light and showcase the unmatched views. Step through to the covered rear patio and enjoy year-round relaxation beside the water. Wake up to panoramic lake views from the luxurious primary bedroom, complete with a spa-like ensuite featuring a freestanding soaker tub, custom glass shower, dual vanities, and quartz countertops. Not to mention two additional bedrooms offering ensuite privilege and premium finishes, and a stylish 2-piece powder room. This home offers both peaceful lakeside living and convenient access to QEW, top-rated schools, shopping, and daily amenities. Enjoy the security of a sloped, granite capped revetment wall designed by a coastal engineer- a premium shoreline upgrade designed to safeguard your investment. *This home is pre-construction. Estimated closing 12 months after purchase. (id:62650)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T23:20:40.192642+00:00"
+"Directions": "Cross Streets: Watershore & Aquamarine. ** Directions: Fruitland to N. Service to Glover to Watershore."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2234697"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "In suite Laundry"
2 => "Sump Pump"
]
+"LotSizeDimensions": "."
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T20:47:44Z"
+"PhotosCount": 12
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T20:47:44Z"
+"Stories": "1.0"
+"StreetName": "Watershore"
+"StreetNumber": "100"
+"StreetSuffix": "Drive"
+"View": "Lake view,View of water,Direct Water View"
+"WaterBodyName": "Lake Ontario"
+"Rooms": array:7 [
0 => array:11 [ …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": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29251667/19-100-watershore-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2999
+"LivingAreaMinimum": 2750
+"ZoningDescription": "R2-66"
+"BedroomsAboveGrade": 3
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"OriginalEntryTimestamp": "2026-01-14T20:47:44.78Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:4 [ …4]
]
+"Office": array:1 [
0 => array:20 [ …20]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251667')"
+"ID": "534950"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24866
+post_id: "534850"
+post_author: 1
+"ListingKey": "29252026"
+"ListingId": "X12696964"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T21:55:43Z"
+"RFModificationTimestamp": "2026-01-14T22:52:09Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E5W8"
+"UnparsedAddress": "469 DEWITT ROAD, Hamilton (Stoney Creek), Ontario L8E5W8"
+"Coordinates": array:2 [
0 => -79.705193
1 => 43.234605
]
+"Latitude": 43.234605
+"Longitude": -79.705193
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this bright and cheerful freehold, end-unit 2 storey townhouse designed to feel like a semi-detached. Just steps away from the Lake, it offers amazing views from the deck, living room and master bedroom. The large lot boasts great curb appeal, and a spacious layout that includes direct access to the garage and a practical open concept floor plan. The large deck, off the kitchen, spans the back of the house, ideal for entertaining, bbqs and relaxation. The second floor open concept family room features gleaming hardwood floors, large windows that allow lots of sunshine; and it can potentially be converted into a 3rd bedroom. The finished basement has so much more potential, it contains abundant storage space, the laundry room, a cold cellar and a 2 piece bathroom. It is the location that makes this home so desirable! This home awaits your creative touch! Do not miss this great opportunity! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T22:51:51.592966+00:00"
+"Directions": "Cross Streets: North Service Road. ** Directions: QEW to Centennial, right on Service Rd, Left on Dewitt."
+"ExteriorFeatures": array:1 [
0 => "Brick Facing"
]
+"FireplaceYN": true
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1405690"
+"ListOfficeKey": "271789"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32.2 x 101.7 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T21:45:59Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T21:45:59Z"
+"Stories": "2.0"
+"StreetName": "Dewitt"
+"StreetNumber": "469"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4952.39"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29252026/469-dewitt-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 32.2
+"OriginalEntryTimestamp": "2026-01-14T21:45:59.36Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252026')"
+"ID": "534850"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24852
+post_id: "533893"
+post_author: 1
+"ListingKey": "29249920"
+"ListingId": "X12694942"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:05:38Z"
+"RFModificationTimestamp": "2026-01-14T19:42:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "306 - 600 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This sophisticated 1-bedroom residence is situated on the third floor of a nearly new boutique condominium. A rare opportunity, it includes an owned parking space and a secure storage locker for exceptional convenience. Inside, you'll find soaring ceilings, abundant natural light, upgraded designer lighting, and a thoughtfully crafted open-concept layout tailored for contemporary living. The inviting entryway offers a full-sized closet for coats and additional storage. The bright, well-appointed kitchen features ample counter space, stainless steel appliances, and a generous peninsula ideal for meal preparation or casual dining. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Central Vacuum"
2 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T19:42:23.816818+00:00"
+"Directions": "FRUITLAND RD & NORTH SERVICE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127500"
+"ListOfficeKey": "274354"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T16:56:17Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T16:56:17Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29249920/306-600-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Properties Ltd"
+"GeocodeManualYN": false
+"TotalActualRent": 2000
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-14T16:56:17.07Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249920')"
+"ID": "533893"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24864
+post_id: "533995"
+post_author: 1
+"ListingKey": "29250319"
+"ListingId": "40798505"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:55:10Z"
+"RFModificationTimestamp": "2026-01-14T18:50:38Z"
+"ListPrice": 599995.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1355.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5H6"
+"UnparsedAddress": "288 GLOVER Road Unit# 21, Stoney Creek, Ontario L8E5H6"
+"Coordinates": array:2 [
0 => -79.6800639
1 => 43.2161908
]
+"Latitude": 43.2161908
+"Longitude": -79.6800639
+"YearBuilt": 2019
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning Branthaven-Built 3-Storey Townhome in Sought-After Winona/Fruitland Neighbourhood. 10 mins to the New Go Train Station Opening at the end of October! Welcome to this beautifully upgraded townhome located in one of Hamilton’s fastest-growing communities. Ideally situated just minutes from the QEW and Red Hill Valley Parkway, you'll enjoy easy access to everything you need—including trendy new restaurants, shopping, Costco, and more. This home features a bright and airy open-concept layout, complete with wide plank vinyl flooring and stylish upgraded lighting throughout. The gourmet kitchen boasts sleek white cabinetry, stainless steel appliances, granite countertops, and a modern tile backsplash. The main floor also includes a spacious family room with a charming shiplap feature wall, separate dining area, and access to a private balcony—perfect for entertaining or relaxing. The powder room has been tastefully updated with new tile flooring and contemporary fixtures. Upstairs, you’ll find two generously sized bedrooms, a convenient laundry closet, and a spacious 4-piece bathroom with a relaxing soaker tub. The primary bedroom features a walk-in closet and its own private balcony. Lovingly maintained, this exceptional home is built by award-winning Branthaven and offers quality craftsmanship, thoughtful upgrades, and a truly move-in-ready experience. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"AssociationFee": "183.69"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T18:50:12.547536+00:00"
+"Directions": "South of QEW on Fruitland Rd. 4km/turn east on Barton St. 4km/turn left - Glover Rd."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T17:51:30Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T17:51:30Z"
+"Stories": "3.0"
+"StreetName": "GLOVER"
+"StreetNumber": "288"
+"StreetSuffix": "Road"
+"SubdivisionName": "518 - Fruitland"
+"TaxAnnualAmount": "4150.79"
+"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/29250319/288-glover-road-unit-21-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3-59b, RM3-59c, RM3-59a"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1355
+"OriginalEntryTimestamp": "2026-01-14T17:49:31.48Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:28 [
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]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29250319')"
+"ID": "533995"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "533463"
+post_author: 1
+"ListingKey": "29249089"
+"ListingId": "40798135"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T14:55:25Z"
+"RFModificationTimestamp": "2026-01-14T17:25:07Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 653.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "600 NORTH SERVICE Road Unit# 419, Hamilton, Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.697041
1 => 43.234195
]
+"Latitude": 43.234195
+"Longitude": -79.697041
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Experience the epitome of modern coastal living in the newly completed and vibrant CoMo Condos. This beautifully designed 1-bedroom, 1-washroom unit has stunning waterfront views that create a calming ambiance throughout. The spacious layout features a sleek kitchen with a breakfast bar, an enclosed balcony ideal for relaxation, and a generously sized washroom. For added convenience, the unit includes one parking space and one locker. CoMo Condos also has an exceptional amenities such as a pet spa, an off-leash pet area, a media and gaming room, a party room, automated package pick-up, and a rooftop patio perfect for entertaining or unwinding. Ideally located with easy access to highways, schools, shopping, and dining, this home is perfect for those seeking style, comfort, and convenience. Don’t miss your chance to enjoy breathtaking waterfront living every day. (id:62650)"
+"Appliances": array:6 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Garage door opener"
5 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:1 [
0 => "Water"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T17:24:56.938712+00:00"
+"Directions": "Lakeview and Fruitland"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525060"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-01-14T14:49:02Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T14:49:02Z"
+"Stories": "1.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29249089/600-north-service-road-unit-419-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2100
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "RM3-64, C5"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 653
+"OriginalEntryTimestamp": "2026-01-14T14:49:02.17Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:22 [ …22]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249089')"
+"ID": "533463"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24865
+post_id: "532460"
+post_author: 1
+"ListingKey": "29247190"
+"ListingId": "40798194"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T21:25:19Z"
+"RFModificationTimestamp": "2026-01-13T23:03:48Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 806.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5A7"
+"UnparsedAddress": "600 NORTH SERVICE Road Unit# 309, Stoney Creek, Ontario L8E5A7"
+"Coordinates": array:2 [
0 => -79.697019
1 => 43.234159
]
+"Latitude": 43.234159
+"Longitude": -79.697019
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Fantastic 2 bedroom corner unit with large bright windows with lake view. Located on 3rd floor, unit comes with 2 parking spaces. Open style kitchen and living room, 2 baths, large balcony, numerous amenities. parking space under ground #42, parking space above ground #265. Looking for A+++ tenant. Rental application, pay stubs & photo ID, up-to-date Equifax credit report, employment letter, reference letter, bank statement. No smoking. Tenant pays all utilities. Tenants need tenant insurance. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:03:24.375923+00:00"
+"Directions": "Fruitland Rd and North Service Rd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524358"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Corner Site"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-13T21:21:08Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T21:21:08Z"
+"Stories": "1.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4135"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29247190/600-north-service-road-unit-309-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"TotalActualRent": 2495
+"ZoningDescription": "C5, RM3-64"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"AboveGradeFinishedArea": 806
+"OriginalEntryTimestamp": "2026-01-13T21:18:57.99Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247190')"
+"ID": "532460"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24858
+post_id: "531722"
+post_author: 1
+"ListingKey": "29247455"
+"ListingId": "X12693050"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T22:20:50Z"
+"RFModificationTimestamp": "2026-01-13T22:32:08Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E5A7"
+"UnparsedAddress": "309 - 600 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E5A7"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic 2 bedroom corner unit with large bright windows with lake view. Located on 3rd floor, unit comes with 2 parking spaces. Open style kitchen and living room, 2 baths, large balcony, numerous amenities. parking space under ground #42, parking space above ground #265. Looking for A+++ tenant. Rental application, pay stubs & photo ID, up-to-date Equifax credit report, employment letter, reference letter, bank statement. No smoking. Tenant pays all utilities. Tenants need tenant insurance. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T22:31:50.312880+00:00"
+"Directions": "Cross Streets: Fruitland Road. ** Directions: Fruitland Rd and North Service Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2163724"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T22:11:25Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T22:11:25Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29247455/309-600-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2495
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-13T22:11:25.42Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247455')"
+"ID": "531722"
}
]
+success: true
+page_size: 9
+page_count: 7
+count: 58
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]