array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29247190/Property?$select=ALL&$top=20&$filter=ListingKey eq 29247190&$expand=Office,Member,Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29247190/Property?$select=ALL&$top=20&$filter=ListingKey eq 29247190&$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: "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 [
"RoomKey" => "1560037673"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247190"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:18:58.01Z"
]
1 => array:11 [
"RoomKey" => "1560037674"
"RoomType" => "3pc Bathroom"
"ListingId" => "40798194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247190"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:18:58.02Z"
]
2 => array:11 [
"RoomKey" => "1560037675"
"RoomType" => "Bedroom"
"ListingId" => "40798194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247190"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:18:58.02Z"
]
3 => array:11 [
"RoomKey" => "1560037676"
"RoomType" => "Primary Bedroom"
"ListingId" => "40798194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247190"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:18:58.02Z"
]
4 => array:11 [
"RoomKey" => "1560037677"
"RoomType" => "Living room"
"ListingId" => "40798194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247190"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:18:58.02Z"
]
5 => array:11 [
"RoomKey" => "1560037678"
"RoomType" => "Kitchen"
"ListingId" => "40798194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247190"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:18:58.02Z"
]
6 => array:11 [
"RoomKey" => "1560037679"
"RoomType" => "Laundry room"
"ListingId" => "40798194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247190"
"RoomLength" => null
"RoomDimensions" => "4'0'' x 4'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:18:58.02Z"
]
7 => array:11 [
"RoomKey" => "1560037680"
"RoomType" => "Foyer"
"ListingId" => "40798194"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29247190"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-13T21:18:58.02Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6403459441"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/9b344b4cb12d7324ed49c8280a5bb13c.webp"
"MediaSize" => 42020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-9b344b4cb12d7324ed49c8280a5bb13c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.9Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6403459520"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/e34cfe0e4a9ce475a9ea5d3aa403f3a3.webp"
"MediaSize" => 37413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-e34cfe0e4a9ce475a9ea5d3aa403f3a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.9Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6403459553"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/9928c82dd66e344f1c11c283665cd36c.webp"
"MediaSize" => 39280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-9928c82dd66e344f1c11c283665cd36c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.93Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6403459579"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/5a36771b7c4369597830d387dc0ea1ca.webp"
"MediaSize" => 45718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-5a36771b7c4369597830d387dc0ea1ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.92Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6403459621"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/d3682ed9f55f5c8f27175b507605f355.webp"
"MediaSize" => 43027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-d3682ed9f55f5c8f27175b507605f355.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:08.69Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6403459672"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/4c94516cadcee6e91ba44e2217c2cd40.webp"
"MediaSize" => 52766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-4c94516cadcee6e91ba44e2217c2cd40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.92Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6403459681"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/0b6133fcd95cfa8676c4b453446c5b42.webp"
"MediaSize" => 45324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-0b6133fcd95cfa8676c4b453446c5b42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.88Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6403459734"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/df891290ab5ee7c89cb689dda19a7447.webp"
"MediaSize" => 47847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-df891290ab5ee7c89cb689dda19a7447.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.92Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6403459791"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/748e2a01bb5f42925b3cc7b6fef27f03.webp"
"MediaSize" => 31322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-748e2a01bb5f42925b3cc7b6fef27f03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.88Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6403459820"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/7ae6474e7fce0d4058c4891ef0600745.webp"
"MediaSize" => 27976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-7ae6474e7fce0d4058c4891ef0600745.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.98Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6403459883"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/9fd908af9a466cb0f2e3b9e87743647f.webp"
"MediaSize" => 35164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-9fd908af9a466cb0f2e3b9e87743647f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.97Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6403459910"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29247190/b707375918e54fd3e1c1d64237daf4a7.webp"
"MediaSize" => 39805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29247190/thumbnail-b707375918e54fd3e1c1d64237daf4a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798194"
"ResourceRecordKey" => "29247190"
"ModificationTimestamp" => "2026-01-13T21:21:05.91Z"
]
]
+"Member": array:1 [
0 => array:22 [
"MemberFullName" => "Massimo Iudica"
"MemberFirstName" => "Massimo"
"MemberLastName" => "Iudica"
"MemberMlsId" => "HBIUDICMA"
"OriginatingSystemName" => 26
"MemberKey" => "1524358"
"ModificationTimestamp" => "2025-10-28T23:12:53Z"
"MemberStatus" => "Active"
"OfficeKey" => "291472"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "HAMILTON"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-574-4600"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"MemberNationalAssociationId" => "1064607"
"OfficeNationalAssociationId" => "1398404"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Royal LePage State Realty Inc."
"OfficePhone" => "905-574-4600"
"OfficeMlsId" => "HBRLPSTATERS"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "291472"
"ModificationTimestamp" => "2025-07-09T19:37:07Z"
"OfficeAddress1" => "987 Rymal Road Suite 100"
"OfficeCity" => "HAMILTON"
"OfficePostalCode" => "L8W3M"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone - Hamilton-Burlington"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2021-10-05T19:41:00Z"
"OfficeNationalAssociationId" => "1398404"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1063185"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247190')"
+"ID": "532460"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 291472/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291472&$expand=Office,Member,Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291472/Office?$select=ALL&$top=10&$filter=OfficeKey eq 291472&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25273
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Royal LePage State Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-574-4600"
+"OfficeMlsId": "HBRLPSTATERS"
+"ModificationTimestamp": "2025-07-09T19:37:07Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "291472"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "987 Rymal Road Suite 100"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "HAMILTON"
+"OfficePostalCode": "L8W3M"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1398404"
+"OriginalEntryTimestamp": "2021-10-05T19:41:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439684"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "291472"
"SocialMediaUrlOrId" => "https://www.royallepagestate.ca/"
"ModificationTimestamp" => "2025-07-09T19:27:00Z"
]
]
+"FranchiseNationalAssociationId": "1146708"
+"OfficeBrokerNationalAssociationId": "1063185"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('291472')"
}
]
+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 1524358/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524358&$expand=Office,Member,Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524358/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524358&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25278
+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 29247190" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24918
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29247190/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29247190&$expand=Office,Member,Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29247190/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29247190&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24900
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29247190 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.697019 43.234159)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29247190 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.697019 43.234159)) le 2000m&$expand=Office,Member,Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29247190 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.697019 43.234159)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29247190 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.697019 43.234159)) le 2000m&$expand=Office,Member,Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24814
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24855
+post_id: "535552"
+post_author: 1
+"ListingKey": "29251089"
+"ListingId": "40798532"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T19:45:51Z"
+"RFModificationTimestamp": "2026-01-15T00:04:47Z"
+"ListPrice": 3100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2841.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0C1"
+"UnparsedAddress": "100 WATERSHORE Drive Unit# 19, Stoney Creek, Ontario L8E0C1"
+"Coordinates": array:2 [
0 => -79.675003
1 => 43.229989
]
+"Latitude": 43.229989
+"Longitude": -79.675003
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't Miss This Rare Lakefront Bungalow on the Shores of Lake Ontario. Welcome to a truly exceptional opportunity— an exquisite 2,841 sq. ft. lakefront bungalow perfectly positioned along the sparkling shoreline of Lake Ontario offering breathtaking panoramic views. This brand-new floor plan has been meticulously crafted to maximize lake views and everyday livability. With 10' ceilings, 8' solid-core interior doors, hardwood floors, upgraded tile throughout, and an elegant oak staircase- this home exudes sophistication. The chef-inspired kitchen is as functional as it is striking, featuring extended-height cabinetry with crown moulding, premium quartz countertops, a stylish backsplash, and a large central island— ideal for both casual meals and upscale entertaining. As a purchaser, you’ll have the rare opportunity to fully customize your finishes at our brand-new design studio, guided by our expert design consultant and curated selection of elevated materials. An open-concept layout anchors the home’s living and dining areas, centered around a 46” gas fireplace with a stained wood beam mantle. Floor-to-ceiling lake-facing windows flood the space with natural light and showcase the unmatched views. Step through to the covered rear patio and enjoy year-round relaxation beside the water. Wake up to panoramic lake views from the luxurious primary bedroom, complete with a spa-like ensuite featuring a freestanding soaker tub, custom glass shower, dual vanities, and quartz countertops. Not to mention two additional bedrooms offering ensuite privilege and premium finishes, and a stylish 2-piece powder room. This home offers both peaceful lakeside living and convenient access to QEW, top-rated schools, shopping, and daily amenities. Enjoy the security of a sloped, granite capped revetment wall designed by a coastal engineer— a premium shoreline upgrade designed to safeguard your investment. *This home is pre-construction. Estimated closing 12 months after purchase. (id:62650)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-15T00:04:22.760439+00:00"
+"Directions": "Fruitland to N. Service to Glover to Watershore."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Other"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2025165"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T19:38:15Z"
+"PhotosCount": 12
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T19:38:15Z"
+"Stories": "1.0"
+"StreetName": "WATERSHORE"
+"StreetNumber": "100"
+"StreetSuffix": "Drive"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"View": "Lake view"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1560357716"
"RoomType" => "Laundry room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
1 => array:11 [
"RoomKey" => "1560357717"
"RoomType" => "4pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
2 => array:11 [
"RoomKey" => "1560357718"
"RoomType" => "5pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
3 => array:11 [
"RoomKey" => "1560357719"
"RoomType" => "2pc Bathroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
4 => array:11 [
"RoomKey" => "1560357720"
"RoomType" => "Den"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
5 => array:11 [
"RoomKey" => "1560357721"
"RoomType" => "Bedroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
6 => array:11 [
"RoomKey" => "1560357722"
"RoomType" => "Bedroom"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
7 => array:11 [
"RoomKey" => "1560357723"
"RoomType" => "Primary Bedroom"
"ListingId" => "40798532"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "18'0'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.14Z"
]
8 => array:11 [
"RoomKey" => "1560357724"
"RoomType" => "Dining room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "19'0'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.15Z"
]
9 => array:11 [
"RoomKey" => "1560357725"
"RoomType" => "Kitchen"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.15Z"
]
10 => array:11 [
"RoomKey" => "1560357726"
"RoomType" => "Living room"
"ListingId" => "40798532"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29251089"
"RoomLength" => null
"RoomDimensions" => "20'8'' x 18'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-01-14T19:38:15.15Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29251089/100-watershore-drive-unit-19-stoney-creek"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1986960"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "55053"
+"GeocodeManualYN": true
+"ZoningDescription": "R2-66"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2841
+"OriginalEntryTimestamp": "2026-01-14T19:38:15.11Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404573772"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/2bd6871eee548767ce3cb5fafb7b366f.webp"
"MediaSize" => 83613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-2bd6871eee548767ce3cb5fafb7b366f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404573776"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/e8a7696e337da1eb4ce40ebd7f99c45a.webp"
"MediaSize" => 167406
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-e8a7696e337da1eb4ce40ebd7f99c45a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404573778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/9cbbdf0d3af16e1f85ea6fd9a72e0cff.webp"
"MediaSize" => 172811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-9cbbdf0d3af16e1f85ea6fd9a72e0cff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404573781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/07251fc8783b3ef0197b92e10af6edbf.webp"
"MediaSize" => 128225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-07251fc8783b3ef0197b92e10af6edbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404573788"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/5469ca2078454c5e5f424f36d3958c25.webp"
"MediaSize" => 137645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-5469ca2078454c5e5f424f36d3958c25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404573792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/b84932083c291312022e39320429c199.webp"
"MediaSize" => 79951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-b84932083c291312022e39320429c199.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inspiration photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404573796"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/14409ce29620198cf31d87bc62d6e496.webp"
"MediaSize" => 85549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-14409ce29620198cf31d87bc62d6e496.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inspiration photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404573801"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/85759c11eb4cdfbfa123570316b24e30.webp"
"MediaSize" => 98054
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-85759c11eb4cdfbfa123570316b24e30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inspiration photo"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404573805"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/21d59776cdab194d5f1c5af373f0aace.webp"
"MediaSize" => 74902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-21d59776cdab194d5f1c5af373f0aace.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404573810"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/09aa05aff7cc975c8262cc4b7342b399.webp"
"MediaSize" => 161765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-09aa05aff7cc975c8262cc4b7342b399.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404573814"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/073a8f63ad996b203834a6ee9073ebfa.webp"
"MediaSize" => 49718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-073a8f63ad996b203834a6ee9073ebfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404573819"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251089/7d2c7f43641578cf40a04d6748223aae.webp"
"MediaSize" => 56281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251089/thumbnail-7d2c7f43641578cf40a04d6748223aae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40798532"
"ResourceRecordKey" => "29251089"
"ModificationTimestamp" => "2026-01-14T19:38:15.11Z"
]
]
+"Member": array:1 [
0 => array:23 [
"MemberFullName" => "Deanna Bodden"
"MemberFirstName" => "Deanna"
"MemberLastName" => "Bodden"
"MemberMlsId" => "HBBODDEDE"
"OriginatingSystemName" => 26
"MemberKey" => "2025165"
"ModificationTimestamp" => "2025-10-28T23:23:51Z"
"MemberStatus" => "Active"
"OfficeKey" => "288925"
"MemberAOR" => "Cornerstone - Hamilton-Burlington"
"Media" => array:1 [ …1]
"JobTitle" => "Salesperson"
"MemberCity" => "Ancaster"
"MemberType" => "Salesperson"
"MemberAORKey" => "14"
"MemberCountry" => "Canada"
"MemberEmailYN" => true
"MemberOfficePhone" => "905-648-4451"
"MemberSocialMedia" => array:1 [ …1]
"MemberStateOrProvince" => "Ontario"
"OriginalEntryTimestamp" => "2017-01-20T15:23:00Z"
"MemberNationalAssociationId" => "1304829"
"OfficeNationalAssociationId" => "1372539"
]
]
+"Office": array:1 [
0 => array:21 [
"OfficeName" => "Royal LePage State Realty Inc."
"OfficePhone" => "905-648-4451"
"OfficeMlsId" => "HBRLPSTATEA2"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "288925"
"ModificationTimestamp" => "2025-12-30T03:00:56Z"
"OfficeAddress1" => "1122 Wilson Street W Suite 200"
"OfficeCity" => "Ancaster"
"OfficePostalCode" => "L9G3K"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Cornerstone"
"OfficeType" => "Firm"
"OfficeAORKey" => "14"
"OfficeCountry" => "Canada"
"OfficeSocialMedia" => array:1 [ …1]
"OriginalEntryTimestamp" => "2020-11-03T19:13:00Z"
"OfficeNationalAssociationId" => "1372539"
"FranchiseNationalAssociationId" => "1230730"
"OfficeBrokerNationalAssociationId" => "1063185"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251089')"
+"ID": "535552"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24749
+post_id: "534950"
+post_author: 1
+"ListingKey": "29251667"
+"ListingId": "X12696554"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T20:56:05Z"
+"RFModificationTimestamp": "2026-01-14T23:21:02Z"
+"ListPrice": 3100000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0C1"
+"UnparsedAddress": "19 - 100 WATERSHORE DRIVE, Hamilton (Stoney Creek), Ontario L8E0C1"
+"Coordinates": array:2 [
0 => -79.678046
1 => 43.231402
]
+"Latitude": 43.231402
+"Longitude": -79.678046
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Don't Miss This Rare Lakefront Bungalow on the Shores of Lake Ontario. Welcome to a truly exceptional opportunity- an exquisite 2,841 sq. ft. lakefront bungalow perfectly positioned along the sparkling shoreline of Lake Ontario offering breathtaking panoramic views. This brand-new floor plan has been meticulously crafted to maximize lake views and everyday livability. With 10' ceilings, 8' solid-core interior doors, hardwood floors, upgraded tile throughout, and an elegant oak staircase- this home exudes sophistication. The chef-inspired kitchen is as functional as it is striking, featuring extended-height cabinetry with crown moulding, premium quartz countertops, a stylish backsplash, and a large central island- ideal for both casual meals and upscale entertaining. As a purchaser, you'll have the rare opportunity to fully customize your finishes at our brand-new design studio, guided by our expert design consultant and curated selection of elevated materials. An open-concept layout anchors the home's living and dining areas, centered around a 46" gas fireplace with a stained wood beam mantle. Floor-to-ceiling lake-facing windows flood the space with natural light and showcase the unmatched views. Step through to the covered rear patio and enjoy year-round relaxation beside the water. Wake up to panoramic lake views from the luxurious primary bedroom, complete with a spa-like ensuite featuring a freestanding soaker tub, custom glass shower, dual vanities, and quartz countertops. Not to mention two additional bedrooms offering ensuite privilege and premium finishes, and a stylish 2-piece powder room. This home offers both peaceful lakeside living and convenient access to QEW, top-rated schools, shopping, and daily amenities. Enjoy the security of a sloped, granite capped revetment wall designed by a coastal engineer- a premium shoreline upgrade designed to safeguard your investment. *This home is pre-construction. Estimated closing 12 months after purchase. (id:62650)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "95"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T23:20:40.192642+00:00"
+"Directions": "Cross Streets: Watershore & Aquamarine. ** Directions: Fruitland to N. Service to Glover to Watershore."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2234697"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "In suite Laundry"
2 => "Sump Pump"
]
+"LotSizeDimensions": "."
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T20:47:44Z"
+"PhotosCount": 12
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T20:47:44Z"
+"Stories": "1.0"
+"StreetName": "Watershore"
+"StreetNumber": "100"
+"StreetSuffix": "Drive"
+"View": "Lake view,View of water,Direct Water View"
+"WaterBodyName": "Lake Ontario"
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1560390237"
"RoomType" => "Living room"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 6.1
"ListingKey" => "29251667"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.83Z"
]
1 => array:11 [
"RoomKey" => "1560390238"
"RoomType" => "Kitchen"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 4.27
"ListingKey" => "29251667"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.83Z"
]
2 => array:11 [
"RoomKey" => "1560390239"
"RoomType" => "Dining room"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 5.79
"ListingKey" => "29251667"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.84Z"
]
3 => array:11 [
"RoomKey" => "1560390240"
"RoomType" => "Den"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "29251667"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.84Z"
]
4 => array:11 [
"RoomKey" => "1560390241"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 5.49
"ListingKey" => "29251667"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.85Z"
]
5 => array:11 [
"RoomKey" => "1560390242"
"RoomType" => "Bedroom 2"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29251667"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.85Z"
]
6 => array:11 [
"RoomKey" => "1560390243"
"RoomType" => "Bedroom 3"
"ListingId" => "X12696554"
"RoomLevel" => "Main level"
"RoomWidth" => 3.66
"ListingKey" => "29251667"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T20:47:44.86Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29251667/19-100-watershore-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 4
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2999
+"LivingAreaMinimum": 2750
+"ZoningDescription": "R2-66"
+"BedroomsAboveGrade": 3
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"OriginalEntryTimestamp": "2026-01-14T20:47:44.78Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6404691322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/647ead6954a5f0111ca2417157bbd68f.webp"
"MediaSize" => 86387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-647ead6954a5f0111ca2417157bbd68f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404691336"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/5ae9382d75761bee2fe8fecd8c66b64e.webp"
"MediaSize" => 169374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-5ae9382d75761bee2fe8fecd8c66b64e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404691379"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/a1852f8ef52cabdd7a5a6d558dc2ab17.webp"
"MediaSize" => 174724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-a1852f8ef52cabdd7a5a6d558dc2ab17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404691409"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/a80b2ec3da82ee7c84cc8ed6d4848959.webp"
"MediaSize" => 129692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-a80b2ec3da82ee7c84cc8ed6d4848959.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6404691445"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/27008c2bc58079a3c9519161a148b4b0.webp"
"MediaSize" => 139024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-27008c2bc58079a3c9519161a148b4b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6404691486"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/82d7fc712ad8bfde984108b3b1028eed.webp"
"MediaSize" => 82992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-82d7fc712ad8bfde984108b3b1028eed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6404691489"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/9f8c4ca667afdf9c40aff4dabeb31d14.webp"
"MediaSize" => 89698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-9f8c4ca667afdf9c40aff4dabeb31d14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6404691501"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/68184a55220eaece59d5e48f99f9c7f7.webp"
"MediaSize" => 102031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-68184a55220eaece59d5e48f99f9c7f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6404691525"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/26aae1ec2f98dcaf8f376c1fe8593265.webp"
"MediaSize" => 76506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-26aae1ec2f98dcaf8f376c1fe8593265.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6404691575"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/4313ffa024bb12af3759b6427ac754d6.webp"
"MediaSize" => 163372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-4313ffa024bb12af3759b6427ac754d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6404691599"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/15154dd2eac6571e66c5628d8961318a.webp"
"MediaSize" => 54407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-15154dd2eac6571e66c5628d8961318a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6404691639"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29251667/8c7a8bac277feeb5d4025bde4e71071b.webp"
"MediaSize" => 58911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29251667/thumbnail-8c7a8bac277feeb5d4025bde4e71071b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696554"
"ResourceRecordKey" => "29251667"
"ModificationTimestamp" => "2026-01-14T20:47:44.79Z"
]
]
+"Member": array:1 [
0 => array:4 [
"MemberMlsId" => "2234697"
"OriginatingSystemName" => 26
"MemberKey" => "2234697"
"ModificationTimestamp" => "2024-12-14T15:51:44Z"
]
]
+"Office": array:1 [
0 => array:20 [
"OfficeName" => "ROYAL LEPAGE STATE REALTY"
"OfficePhone" => "905-648-4451"
"OfficeMlsId" => "288001"
"OriginatingSystemName" => 26
"rf_group_id" => 0
"OfficeKey" => "288936"
"ModificationTimestamp" => "2024-06-19T08:31:11Z"
"OfficeAddress1" => "1122 WILSON ST WEST #200"
"OfficeCity" => "ANCASTER"
"OfficePostalCode" => "L9G3K9"
"OfficeStateOrProvince" => "Ontario"
"OfficeStatus" => "Active"
"OfficeAOR" => "Toronto"
"OfficeFax" => "905-648-7393"
"OfficeType" => "Firm"
"OfficeAORKey" => "82"
"OriginalEntryTimestamp" => "2020-11-05T23:29:00Z"
"OfficeNationalAssociationId" => "1374261"
"FranchiseNationalAssociationId" => "1146708"
"OfficeBrokerNationalAssociationId" => "1312646"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29251667')"
+"ID": "534950"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24856
+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 [
"RoomKey" => "1560412635"
"RoomType" => "Foyer"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 1.95
"ListingKey" => "29252026"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
1 => array:11 [
"RoomKey" => "1560412636"
"RoomType" => "Cold room"
"ListingId" => "X12696964"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29252026"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
2 => array:11 [
"RoomKey" => "1560412637"
"RoomType" => "Living room"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 3.15
"ListingKey" => "29252026"
"RoomLength" => 6.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
3 => array:11 [
"RoomKey" => "1560412638"
"RoomType" => "Dining room"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 3.15
"ListingKey" => "29252026"
"RoomLength" => 6.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
4 => array:11 [
"RoomKey" => "1560412639"
"RoomType" => "Bathroom"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 0.0
"ListingKey" => "29252026"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
5 => array:11 [
"RoomKey" => "1560412640"
"RoomType" => "Kitchen"
"ListingId" => "X12696964"
"RoomLevel" => "Main level"
"RoomWidth" => 2.8
"ListingKey" => "29252026"
"RoomLength" => 5.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
6 => array:11 [
"RoomKey" => "1560412641"
"RoomType" => "Family room"
"ListingId" => "X12696964"
"RoomLevel" => "Second level"
"RoomWidth" => 3.0
"ListingKey" => "29252026"
"RoomLength" => 3.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
7 => array:11 [
"RoomKey" => "1560412642"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12696964"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "29252026"
"RoomLength" => 5.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
8 => array:11 [
"RoomKey" => "1560412643"
"RoomType" => "Bedroom 2"
"ListingId" => "X12696964"
"RoomLevel" => "Second level"
"RoomWidth" => 2.87
"ListingKey" => "29252026"
"RoomLength" => 4.3
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
9 => array:11 [
"RoomKey" => "1560412644"
"RoomType" => "Recreational, Games room"
"ListingId" => "X12696964"
"RoomLevel" => "Basement"
"RoomWidth" => 2.8
"ListingKey" => "29252026"
"RoomLength" => 9.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
10 => array:11 [
"RoomKey" => "1560412645"
"RoomType" => "Laundry room"
"ListingId" => "X12696964"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29252026"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-01-14T21:45:59.39Z"
]
]
+"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 [
"Order" => 0
"MediaKey" => "6404775491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/dd7403773f0d92709a5e4ace0a32dbe2.webp"
"MediaSize" => 393840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-dd7403773f0d92709a5e4ace0a32dbe2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "B/I Single car garage"
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6404775581"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/9dbaf861366c04a2c066bc7a77868277.webp"
"MediaSize" => 454602
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-9dbaf861366c04a2c066bc7a77868277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "End unit on large lot"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6404775611"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/8d644c98fa683ce1c78348407efb20a1.webp"
"MediaSize" => 319713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29252026/thumbnail-8d644c98fa683ce1c78348407efb20a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front Entrance"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12696964"
"ResourceRecordKey" => "29252026"
"ModificationTimestamp" => "2026-01-14T21:45:59.37Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6404775671"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29252026/81f7ae1668c86bff43f9a160c65d03a6.webp"
…10
]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29252026')"
+"ID": "534850"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25125
+post_id: "533893"
+post_author: 1
+"ListingKey": "29249920"
+"ListingId": "X12694942"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T17:05:38Z"
+"RFModificationTimestamp": "2026-01-14T19:42:40Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0L2"
+"UnparsedAddress": "306 - 600 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0L2"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This sophisticated 1-bedroom residence is situated on the third floor of a nearly new boutique condominium. A rare opportunity, it includes an owned parking space and a secure storage locker for exceptional convenience. Inside, you'll find soaring ceilings, abundant natural light, upgraded designer lighting, and a thoughtfully crafted open-concept layout tailored for contemporary living. The inviting entryway offers a full-sized closet for coats and additional storage. The bright, well-appointed kitchen features ample counter space, stainless steel appliances, and a generous peninsula ideal for meal preparation or casual dining. (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Central Vacuum"
2 => "Window Coverings"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T19:42:23.816818+00:00"
+"Directions": "FRUITLAND RD & NORTH SERVICE RD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127500"
+"ListOfficeKey": "274354"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-14T16:56:17Z"
+"PhotosCount": 21
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T16:56:17Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29249920/306-600-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Properties Ltd"
+"GeocodeManualYN": false
+"TotalActualRent": 2000
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-14T16:56:17.07Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:21 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29249920')"
+"ID": "533893"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24854
+post_id: "533981"
+post_author: 1
+"ListingKey": "29250796"
+"ListingId": "X12695858"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-14T19:00:27Z"
+"RFModificationTimestamp": "2026-01-14T19:36:10Z"
+"ListPrice": 459000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0K3"
+"UnparsedAddress": "227 - 125 SHOREVIEW PLACE, Hamilton (Lakeshore), Ontario L8E0K3"
+"Coordinates": array:2 [
0 => -79.720692
1 => 43.238951
]
+"Latitude": 43.238951
+"Longitude": -79.720692
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Discover Lakeside Living. This bright and beautiful designed 564 sq. ft. condo offers an inviting open-concept layout. Large windows that fill the space with natural and peaceful views of the lake. Master Bed features a walk - in -closet. Enjoy the convenience of in-suite laundry and building amenities, including a modern gym, party room and rooftop. (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Microwave"
]
+"AssociationFee": "448.04"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-14T19:36:03.696242+00:00"
+"Directions": "Cross Streets: Millen Rd/Shoreview Pl. ** Directions: From north Service Rd turn south on Millen Rd and right onto Shoreview Pl."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Brick Veneer"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1528247"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-01-14T18:46:47Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-14T18:46:47Z"
+"StreetName": "Shoreview"
+"StreetNumber": "125"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "2772"
+"View": "Lake view"
+"Rooms": array:3 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29250796/227-125-shoreview-place-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-01-14T18:46:47.67Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:8 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
]
+"Member": []
+"Office": array:1 [
0 => array:19 [ …19]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29250796')"
+"ID": "533981"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24859
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23498
+post_id: "532252"
+post_author: 1
+"ListingKey": "29247006"
+"ListingId": "40797950"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T20:55:46Z"
+"RFModificationTimestamp": "2026-01-13T23:23:11Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1064.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5V2"
+"UnparsedAddress": "610 BARTON Street Unit# 46, Stoney Creek, Ontario L8E5V2"
+"Coordinates": array:2 [
0 => -79.703288
1 => 43.2221018
]
+"Latitude": 43.2221018
+"Longitude": -79.703288
+"YearBuilt": 1993
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Gorgeous end-unit townhouse in a fantastic Stoney Creek location! Just minutes to the QEW (Fruitland) and close to schools, parks, restaurants, and all amenities. This home is extremely well maintained, spotless, and loaded with updates. Stunning open-concept kitchen featuring white soft-close cabinetry, quartz countertops, backsplash, centre island, and wine fridge—perfect for everyday living and entertaining. Updated bathrooms, ceramic and hardwood flooring, pot lights, California shutters, and convenient inside entry from the garage. Major updates include furnace and A/C (August 2022) and a garage door opener (August 2022). Unspoiled unfinished basement offers endless potential. Enjoy a private rear yard surrounded by trees with patio, deck, and professional landscaping. Outstanding location, great complex—shows 10+! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFee": "324.96"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Water"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T23:22:55.259352+00:00"
+"Directions": "Fruitland Rd to Barton St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524652"
+"ListOfficeKey": "294490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T20:48:53Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T20:48:53Z"
+"Stories": "2.0"
+"StreetName": "BARTON"
+"StreetNumber": "610"
+"StreetSuffix": "Street"
+"SubdivisionName": "512 - Guernsey/Westmeria/Industrial"
+"TaxAnnualAmount": "3432.5"
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/610bartonstreetl8e5v2"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29247006/610-barton-street-unit-46-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1910452"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "294490"
+"GeocodeManualYN": true
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1064
+"OriginalEntryTimestamp": "2026-01-13T20:48:53.7Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:22 [ …22]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247006')"
+"ID": "532252"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24791
+post_id: "532253"
+post_author: 1
+"ListingKey": "29247330"
+"ListingId": "X12692886"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T21:50:37Z"
+"RFModificationTimestamp": "2026-01-13T22:51:08Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E5V2"
+"UnparsedAddress": "46 - 610 BARTON STREET, Hamilton (Stoney Creek), Ontario L8E5V2"
+"Coordinates": array:2 [
0 => -79.703296
1 => 43.222185
]
+"Latitude": 43.222185
+"Longitude": -79.703296
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Gorgeous end-unit townhouse in a fantastic Stoney Creek location! Just minutes to the QEW (Fruitland) and close to schools, parks, restaurants, and all amenities. This home is extremely well maintained, spotless, and loaded with updates. Stunning open-concept kitchen featuring white soft-close cabinetry, quartz countertops, backsplash, centre island, and wine fridge-perfect for everyday living and entertaining. Updated bathrooms, ceramic and hardwood flooring, pot lights, California shutters, and convenient inside entry from the garage. Major updates include furnace and A/C (August 2022) and a garage door opener (August 2022). Unspoiled unfinished basement offers endless potential. Enjoy a private rear yard surrounded by trees with patio, deck, and professional landscaping. Outstanding location, great complex-shows 10+! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "324.96"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T22:50:45.105628+00:00"
+"Directions": "Cross Streets: Fruitland Rd. ** Directions: Fruitland Rd to Barton St."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038160"
+"ListOfficeKey": "280315"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T21:40:39Z"
+"PhotosCount": 43
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T21:40:39Z"
+"Stories": "2.0"
+"StreetName": "Barton"
+"StreetNumber": "610"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3432.5"
+"VirtualTourURLUnbranded": "https://sites.nomorecowboys.media/mls/227708841"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29247330/46-610-barton-street-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2106038"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"CoListOfficeKey": "280315"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "RM3"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-01-13T21:40:39.2Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:43 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:21 [ …21]
]
+"Office": array:1 [
0 => array:23 [ …23]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247330')"
+"ID": "532253"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24807
+post_id: "531722"
+post_author: 1
+"ListingKey": "29247455"
+"ListingId": "X12693050"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-01-13T22:20:50Z"
+"RFModificationTimestamp": "2026-01-13T22:32:08Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E5A7"
+"UnparsedAddress": "309 - 600 NORTH SERVICE ROAD, Hamilton (Lakeshore), Ontario L8E5A7"
+"Coordinates": array:2 [
0 => -79.697532
1 => 43.234311
]
+"Latitude": 43.234311
+"Longitude": -79.697532
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fantastic 2 bedroom corner unit with large bright windows with lake view. Located on 3rd floor, unit comes with 2 parking spaces. Open style kitchen and living room, 2 baths, large balcony, numerous amenities. parking space under ground #42, parking space above ground #265. Looking for A+++ tenant. Rental application, pay stubs & photo ID, up-to-date Equifax credit report, employment letter, reference letter, bank statement. No smoking. Tenant pays all utilities. Tenants need tenant insurance. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-01-13T22:31:50.312880+00:00"
+"Directions": "Cross Streets: Fruitland Road. ** Directions: Fruitland Rd and North Service Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Not known"
2 => "Electric"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2163724"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-01-13T22:11:25Z"
+"PhotosCount": 12
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-01-13T22:11:25Z"
+"StreetName": "North Service"
+"StreetNumber": "600"
+"StreetSuffix": "Road"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29247455/309-600-north-service-road-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Shabri Property Management"
+"GeocodeManualYN": false
+"TotalActualRent": 2495
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"OriginalEntryTimestamp": "2026-01-13T22:11:25.42Z"
+"MapCoordinateVerifiedYN": false
+"Media": array:12 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
]
+"Member": array:1 [
0 => array:20 [ …20]
]
+"Office": array:1 [
0 => array:21 [ …21]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29247455')"
+"ID": "531722"
}
]
+success: true
+page_size: 9
+page_count: 13
+count: 113
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
]