array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29922862 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1544963"
+post_author: 1
+"ListingKey": "29922862"
+"ListingId": "40840990"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:40:15Z"
+"RFModificationTimestamp": "2026-06-18T22:58:05Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.05
+"LivingArea": 2175.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E6A3"
+"UnparsedAddress": "117 FRANCES Avenue, Stoney Creek, Ontario L8E6A3"
+"Coordinates": array:2 [
0 => -79.7257671
1 => 43.2408267
]
+"Latitude": 43.2408267
+"Longitude": -79.7257671
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 117 Frances Avenue, where lakeside living meets everyday convenience. Just moments from Lake Ontario, this beautifully maintained freehold townhome offers a rare double-car garage, PLUS parking for four vehicles in the driveway, and over 2100sqft of finished living space. Designed for both busy families and those who love to entertain, the bright open-concept main floor features spacious living and dining areas that flow seamlessly into the kitchen, with sliding doors leading to your private, maintenance-free backyard retreat. Upstairs, you’ll find three generous bedrooms, including a spacious primary suite complete with a walk-in closet and private ensuite. Two additional bedrooms and a full bath provide plenty of room for family, guests, or a growing household. The fully finished basement adds valuable living space with a large rec room featuring engineered hardwood flooring - perfect for movie nights, a home office, gym, or playroom. Outside, the upgrades continue with a stunning two-tier composite deck, maintenance-free landscaping, aggregate concrete along the side walkway, and stamped concrete accents at the front entrance and driveway. One of the most unique features of this home is that it’s connected only at the garages, offering the feel and privacy of a detached home. Located in a quiet, family-friendly neighbourhood, you’re just a short walk to Confederation Park, waterfront trails, schools, shopping, and everyday amenities. With quick access to the QEW, Red Hill Parkway, and the future Confederation GO Station, commuting couldn’t be easier. Move-in ready, meticulously maintained, and perfectly positioned near the lake - this is the lifestyle you’ve been waiting for. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:30:30.768448+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239450"
+"ListOfficeKey": "299790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.05"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T17:09:59Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T22:31:38Z"
+"Stories": "2.0"
+"StreetName": "FRANCES"
+"StreetNumber": "117"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "5055.51"
+"VirtualTourURLUnbranded": "https://youriguide.com/117_frances_ave_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1662500113"
"RoomType" => "Storage"
"ListingId" => "40840990"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.36Z"
]
1 => array:11 [
"RoomKey" => "1662500114"
"RoomType" => "Utility room"
"ListingId" => "40840990"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.36Z"
]
2 => array:11 [
"RoomKey" => "1662500115"
"RoomType" => "Recreation room"
"ListingId" => "40840990"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => "19'6'' x 25'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
3 => array:11 [
"RoomKey" => "1662500116"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
4 => array:11 [
"RoomKey" => "1662500117"
"RoomType" => "Bedroom"
"ListingId" => "40840990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
5 => array:11 [
"RoomKey" => "1662500118"
"RoomType" => "Bedroom"
"ListingId" => "40840990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
6 => array:11 [
"RoomKey" => "1662500119"
"RoomType" => "Full bathroom"
"ListingId" => "40840990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
7 => array:11 [
"RoomKey" => "1662500120"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840990"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
8 => array:11 [
"RoomKey" => "1662500121"
"RoomType" => "2pc Bathroom"
"ListingId" => "40840990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
9 => array:11 [
"RoomKey" => "1662500122"
"RoomType" => "Kitchen"
"ListingId" => "40840990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
10 => array:11 [
"RoomKey" => "1662500123"
"RoomType" => "Dining room"
"ListingId" => "40840990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
11 => array:11 [
"RoomKey" => "1662500124"
"RoomType" => "Living room"
"ListingId" => "40840990"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29922862"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 25'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T22:31:38.37Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29922862/117-frances-avenue-stoney-creek"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2050273"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299790"
+"GeocodeManualYN": true
+"ZoningDescription": "RM2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1585
+"BelowGradeFinishedArea": 590
+"OriginalEntryTimestamp": "2026-06-18T17:09:59.01Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1477386"
+"ListOfficeNationalAssociationId": "1476846"
+"CoListAgentNationalAssociationId": "1325722"
+"CoListOfficeNationalAssociationId": "1476846"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29922862_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/4ab3c423ca5c7b362c8718e1569aedb4.webp"
"MediaSize" => 148723
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-4ab3c423ca5c7b362c8718e1569aedb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29922862_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/d1ada631fbb260a6dee67e0ef8c744a0.webp"
"MediaSize" => 141242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-d1ada631fbb260a6dee67e0ef8c744a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29922862_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/4e353c20b54853d2ba5d0681e7f1bc48.webp"
"MediaSize" => 134975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-4e353c20b54853d2ba5d0681e7f1bc48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29922862_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/c2ad28ee734281d89e17ad240a23edf3.webp"
"MediaSize" => 92321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-c2ad28ee734281d89e17ad240a23edf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29922862_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/a745cb35b349b9c663eda0a36a79b040.webp"
"MediaSize" => 77223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-a745cb35b349b9c663eda0a36a79b040.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29922862_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/dec94eb1469e5f8295871ffb508cf370.webp"
"MediaSize" => 74272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-dec94eb1469e5f8295871ffb508cf370.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29922862_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/a5c30280d5c566b088337e13b67716bf.webp"
"MediaSize" => 79796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-a5c30280d5c566b088337e13b67716bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29922862_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/0993f93d37c4738e74b7f30bc0f40387.webp"
"MediaSize" => 84468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-0993f93d37c4738e74b7f30bc0f40387.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29922862_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/6ee312d97e186c827ef88c656bc6251f.webp"
"MediaSize" => 76507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-6ee312d97e186c827ef88c656bc6251f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29922862_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/58c8938801289ee1f9e61eb5701d9bc1.webp"
"MediaSize" => 80908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-58c8938801289ee1f9e61eb5701d9bc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29922862_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/b8ca20cb5822c4477f6c9a59a7c60dfa.webp"
"MediaSize" => 70217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-b8ca20cb5822c4477f6c9a59a7c60dfa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29922862_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/d9499d78f7fe96ad87e774157684a69e.webp"
"MediaSize" => 66538
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-d9499d78f7fe96ad87e774157684a69e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29922862_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/7c47affbeeac5064fa4ee65e410faf4e.webp"
"MediaSize" => 83478
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-7c47affbeeac5064fa4ee65e410faf4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29922862_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/555ce512946a2212762667a6f23c4e53.webp"
"MediaSize" => 75467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-555ce512946a2212762667a6f23c4e53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29922862_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/fe9a3964cf5308bc23a6cda1ec6e1fd1.webp"
"MediaSize" => 52255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-fe9a3964cf5308bc23a6cda1ec6e1fd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29922862_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/786ac6f2c61215b9874d824726b8272f.webp"
"MediaSize" => 87066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-786ac6f2c61215b9874d824726b8272f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29922862_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/cf6e709d380d2058df3d80aea34bc16d.webp"
"MediaSize" => 65266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-cf6e709d380d2058df3d80aea34bc16d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29922862_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/c159709504e753e47d6e6bc8a5947a43.webp"
"MediaSize" => 54410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-c159709504e753e47d6e6bc8a5947a43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29922862_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/f2d29856ed11aa28a933fb454f1058bf.webp"
"MediaSize" => 62414
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-f2d29856ed11aa28a933fb454f1058bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29922862_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/cc1616b0db91f767911cc16c8122cdac.webp"
"MediaSize" => 52961
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-cc1616b0db91f767911cc16c8122cdac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29922862_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/ed537e6dd89362e9cf155c2a06d6142c.webp"
"MediaSize" => 66155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-ed537e6dd89362e9cf155c2a06d6142c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29922862_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/a9e3f975dfed12190faf6794a3cd60a7.webp"
"MediaSize" => 53556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-a9e3f975dfed12190faf6794a3cd60a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29922862_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/c06d69888a94a70c9f4d4ce8291523ac.webp"
"MediaSize" => 68844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-c06d69888a94a70c9f4d4ce8291523ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29922862_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/7d0824841e5f066f7fe5cc9dc71258c7.webp"
"MediaSize" => 53090
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-7d0824841e5f066f7fe5cc9dc71258c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29922862_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/016ad4e81c6ad4f31bfca6930a1157a6.webp"
"MediaSize" => 74364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-016ad4e81c6ad4f31bfca6930a1157a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29922862_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/edb6439fa5ab1a11a79bba64e4f9433f.webp"
"MediaSize" => 66777
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-edb6439fa5ab1a11a79bba64e4f9433f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29922862_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/b939a5210d64275e31f7da80028d26e4.webp"
"MediaSize" => 55226
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-b939a5210d64275e31f7da80028d26e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29922862_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/34847f19646d196b264296d884c21fd8.webp"
"MediaSize" => 182112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-34847f19646d196b264296d884c21fd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29922862_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/a70f75992549ce3137156b67277135be.webp"
"MediaSize" => 144158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-a70f75992549ce3137156b67277135be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29922862_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/cc0be449fb7a681ebcce104903a42e78.webp"
"MediaSize" => 142384
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-cc0be449fb7a681ebcce104903a42e78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29922862_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/2ed43ac1c7cf1d2d2a21d2c094bf5013.webp"
"MediaSize" => 129517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-2ed43ac1c7cf1d2d2a21d2c094bf5013.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29922862_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/1e36e1b58c8dfc46d50c37b7b64116e0.webp"
"MediaSize" => 138248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-1e36e1b58c8dfc46d50c37b7b64116e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29922862_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/00af44991204d6f8eee83cc547e7954f.webp"
"MediaSize" => 150562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-00af44991204d6f8eee83cc547e7954f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29922862_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/811186cf753e44a5cd453db24450ef01.webp"
"MediaSize" => 172759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-811186cf753e44a5cd453db24450ef01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29922862_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29922862/eecf7f4836130c9f546ec94eeab69807.webp"
"MediaSize" => 130492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29922862/thumbnail-eecf7f4836130c9f546ec94eeab69807.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840990"
"ResourceRecordKey" => "29922862"
"ModificationTimestamp" => "2026-06-18T17:09:59.02Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922862')"
+"ID": "1544963"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 299790" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24852
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2239450" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24825
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29922862'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25159
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29922862'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25177
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25175
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31539903"
+"ListingKey": "29922862"
+"ListingId": "40840990"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T14:00:00Z"
+"OpenHouseEndTime": "2026-06-20T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-19T05:35:19Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31539903')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29922862' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7257671 43.2408267)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25230
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25224
+post_id: "1545522"
+post_author: 1
+"ListingKey": "29925512"
+"ListingId": "X13464252"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:05:19Z"
+"RFModificationTimestamp": "2026-06-18T22:47:57Z"
+"ListPrice": 599999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0J3"
+"UnparsedAddress": "38 SOUTHSHORE CRESCENT, Hamilton (Stoney Creek), Ontario L8E0J3"
+"Coordinates": array:2 [
0 => -79.722471
1 => 43.240611
]
+"Latitude": 43.240611
+"Longitude": -79.722471
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This beautiful upgraded, executive 2 bedroom townhouse is in the peaceful but well connected Waterfront Trails neighbourhood that is steps from the beach and walking trail. The modern kitchen with stainless steel appliances, quartz countertop top, backsplash and upgraded light fixtures makes it easy to prepare your meals. The spacious living and dining rooms have upgraded lights, hardwood floors and extra large windows that provide lots of natural light. The two large bedrooms, both also with extra large windows, are upstairs along with the laundry and a full bathroom. The main level has a spacious den that gives additional space to hang out and access to the garage. Extra cabinets in both bathrooms, upgraded lights throughout the home, and electronic blinds on all the windows add ease and comfort to this home. This home delivers exceptional value in an unbeatable location just minutes from the highway, multiple plazas including Costco, restaurants, the GO Station and much more. The beach is a short 1-2 minute walk while both Fifty Point Conservation Area and Confederation Beach Park are a few minutes drive. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Blinds"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:47:49.305355+00:00"
+"Directions": "Green Rd & North Service Rd"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2046633"
+"ListOfficeKey": "150284"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "21.2 x 42.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T21:59:14Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T21:59:14Z"
+"Stories": "3.0"
+"StreetName": "Southshore"
+"StreetNumber": "38"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4217.39"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1662477759"
"RoomType" => "Den"
"ListingId" => "X13464252"
"RoomLevel" => "Ground level"
"RoomWidth" => 4.34
"ListingKey" => "29925512"
"RoomLength" => 2.98
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:14.47Z"
]
1 => array:11 [
"RoomKey" => "1662477760"
"RoomType" => "Kitchen"
"ListingId" => "X13464252"
"RoomLevel" => "Second level"
"RoomWidth" => 3.27
"ListingKey" => "29925512"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:14.47Z"
]
2 => array:11 [
"RoomKey" => "1662477761"
"RoomType" => "Living room"
"ListingId" => "X13464252"
"RoomLevel" => "Second level"
"RoomWidth" => 5.23
"ListingKey" => "29925512"
"RoomLength" => 3.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:14.48Z"
]
3 => array:11 [
"RoomKey" => "1662477762"
"RoomType" => "Dining room"
"ListingId" => "X13464252"
"RoomLevel" => "Second level"
"RoomWidth" => 3.78
"ListingKey" => "29925512"
"RoomLength" => 2.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:14.48Z"
]
4 => array:11 [
"RoomKey" => "1662477763"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13464252"
"RoomLevel" => "Third level"
"RoomWidth" => 4.34
"ListingKey" => "29925512"
"RoomLength" => 3.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:14.48Z"
]
5 => array:11 [
"RoomKey" => "1662477764"
"RoomType" => "Bedroom 2"
"ListingId" => "X13464252"
"RoomLevel" => "Third level"
"RoomWidth" => 3.39
"ListingKey" => "29925512"
"RoomLength" => 2.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:14.48Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29925512/38-southshore-crescent-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 21.2
+"OriginalEntryTimestamp": "2026-06-18T21:59:14.44Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1322063"
+"ListOfficeNationalAssociationId": "1178579"
+"Media": array:26 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29925512_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/38cf1af92ed18fdfea18e192edfcda20.webp"
"MediaSize" => 310858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-38cf1af92ed18fdfea18e192edfcda20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29925512_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/1de126c13fded84003d459e6f2cfe7e3.webp"
"MediaSize" => 403137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-1de126c13fded84003d459e6f2cfe7e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29925512_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/7f0c08cba73dd1d282e27b76db497f5f.webp"
"MediaSize" => 147622
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-7f0c08cba73dd1d282e27b76db497f5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29925512_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/ffd86be48cacc174c1ab6b012f0f9350.webp"
"MediaSize" => 163102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-ffd86be48cacc174c1ab6b012f0f9350.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29925512_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/305702552974ccc9e5c5cb5b2032a92f.webp"
"MediaSize" => 129573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-305702552974ccc9e5c5cb5b2032a92f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29925512_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/58522e2a7e7583474a8c94617e489633.webp"
"MediaSize" => 212870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-58522e2a7e7583474a8c94617e489633.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29925512_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/5714e645039e8ed56400d2dfc4ebed5d.webp"
"MediaSize" => 181613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-5714e645039e8ed56400d2dfc4ebed5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29925512_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/d271ea31a1bf9682fad73e2827a2bdb6.webp"
"MediaSize" => 178092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-d271ea31a1bf9682fad73e2827a2bdb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29925512_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/e89f5d325e29e8a728fd03fcc9fd0391.webp"
"MediaSize" => 199704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-e89f5d325e29e8a728fd03fcc9fd0391.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29925512_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/b458b9e07eb7b75827e6365dc5690eeb.webp"
"MediaSize" => 166393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-b458b9e07eb7b75827e6365dc5690eeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29925512_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/8a333f1ddfff746b64afc9aaa399f48c.webp"
"MediaSize" => 165819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-8a333f1ddfff746b64afc9aaa399f48c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29925512_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/45be1404392b890051e4164a787b7ac4.webp"
"MediaSize" => 154358
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-45be1404392b890051e4164a787b7ac4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29925512_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/335462334e7da755dabb1f4502bcea55.webp"
"MediaSize" => 164147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-335462334e7da755dabb1f4502bcea55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29925512_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/8a54d4ace4a735d3803dc02efa5f8658.webp"
"MediaSize" => 175197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-8a54d4ace4a735d3803dc02efa5f8658.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29925512_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/300dbd1ba8473797e70606192ccbbf17.webp"
"MediaSize" => 332753
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-300dbd1ba8473797e70606192ccbbf17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29925512_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/4f3c7355d7c82a1de72cc51b2bb9637d.webp"
"MediaSize" => 56195
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-4f3c7355d7c82a1de72cc51b2bb9637d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13464252"
"ResourceRecordKey" => "29925512"
"ModificationTimestamp" => "2026-06-18T21:59:14.45Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29925512_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29925512/a4d9a0a36a0f793d176b9120855a6d19.webp"
"MediaSize" => 50964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29925512/thumbnail-a4d9a0a36a0f793d176b9120855a6d19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29925512')"
+"ID": "1545522"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+post_id: "1544962"
+post_author: 1
+"ListingKey": "29922961"
+"ListingId": "X13462536"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T23:05:02Z"
+"RFModificationTimestamp": "2026-06-18T23:13:38Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E6A3"
+"UnparsedAddress": "117 FRANCES AVENUE, Hamilton (Lakeshore), Ontario L8E6A3"
+"Coordinates": array:2 [
0 => -79.732447
1 => 43.241965
]
+"Latitude": 43.241965
+"Longitude": -79.732447
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Welcome to 117 Frances Avenue, where lakeside living meets everyday convenience. Just moments from Lake Ontario, this beautifully maintained freehold townhome offers a rare double-car garage, PLUS parking for four vehicles in the driveway, and over 2100sqft of finished living space. Designed for both busy families and those who love to entertain, the bright open-concept main floor features spacious living and dining areas that flow seamlessly into the kitchen, with sliding doors leading to your private, maintenance-free backyard retreat. Upstairs, you'll find three generous bedrooms, including a spacious primary suite complete with a walk-in closet and private ensuite. Two additional bedrooms and a full bath provide plenty of room for family, guests, or a growing household. The fully finished basement adds valuable living space with a large rec room featuring engineered hardwood flooring - perfect for movie nights, a home office, gym, or playroom. Outside, the upgrades continue with a stunning two-tier composite deck, maintenance-free landscaping, aggregate concrete along the side walkway, and stamped concrete accents at the front entrance and driveway. One of the most unique features of this home is that it's connected only at the garages, offering the feel and privacy of a detached home. Located in a quiet, family-friendly neighbourhood, you're just a short walk to Confederation Park, waterfront trails, schools, shopping, and everyday amenities. With quick access to the QEW, Red Hill Parkway, and the future Confederation GO Station, commuting couldn't be easier. Move-in ready, meticulously maintained, and perfectly positioned near the lake - this is the lifestyle you've been waiting for. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:23:04.760936+00:00"
+"Directions": "Cross Streets: Green Rd & Frances Ave. ** Directions: North Service Rd & Green Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952102"
+"ListOfficeKey": "285151"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25.3 x 87.3 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T17:26:33Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T22:56:18Z"
+"Stories": "2.0"
+"StreetName": "Frances"
+"StreetNumber": "117"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5055.51"
+"VirtualTourURLUnbranded": "https://youriguide.com/117_frances_ave_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Lakeshore"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29922961/117-frances-avenue-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2050273"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285151"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.3
+"OriginalEntryTimestamp": "2026-06-18T17:26:33.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1245775"
+"ListOfficeNationalAssociationId": "1347969"
+"CoListAgentNationalAssociationId": "1325722"
+"CoListOfficeNationalAssociationId": "1347969"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922961')"
+"ID": "1544962"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25223
+post_id: "1543025"
+post_author: 1
+"ListingKey": "29921081"
+"ListingId": "X13460336"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T16:55:17Z"
+"RFModificationTimestamp": "2026-06-18T17:10:44Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E3W6"
+"UnparsedAddress": "802 - 301 FRANCES AVENUE, Hamilton (Lakeshore), Ontario L8E3W6"
+"Coordinates": array:2 [
0 => -79.723716
1 => 43.240716
]
+"Latitude": 43.240716
+"Longitude": -79.723716
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to The Bayliner, a sought-after building where location, comfort, convenience, & a maintenance-free lifestyle come together by the lake. This beautiful 2 bedrm plus den, 1.5-bathrm corner suite offers 1105sqft + a 77sqft private balcony directly overlooking the lake. This unit is perfectly positioned within the building to capture some of the most spectacular unobstructed lake views in the building. Dare to compare the views w/other units currently for sale in the building - the panoramic waterfront vistas T/O this suite are exceptional. As a corner unit, the additional east-facing window welcomes beautiful sunrises & provides additional natural light T/O the day. Every principal room overlooks the lake, creating a truly picturesque setting. The open-concept layout includes a kitchen w/quartz CT, 4 SS appl., tile backsplash,under-cabinet lighting, a centre island, &lots of cupboard & countertop space, large living rmw/sliding doors to the private balcony, offering a front-row seat to the lake & distant Toronto skyline views, spacious dining area, & a den w/flexibility as an office, reading rm, or additional sitting area. The suite also has 2 bedrms, the primary w/ a walk-in closet & ensuite bath, & the 2nd bedrm w/double closet, a 4pce main bathrm, laundry rm w/linen closet, & a small storage rm.Additional features include quality laminate flooring, fresh paint T/O, ceiling fans, central air,underground parking, & a storage locker. The building is well managed, has a social club & anice community feel, & outstanding amenities which include an outdoor pool, gym, exercise rm,sauna, party rm, games rm, library, workshop, car wash, community BBQ area, & lots of visitor parking. The condo fees include all utilities, as well as cable & internet. Ideally located steps to the lake, & close to the beach, trails, parks, conservation area, shops, dining, transit, the GO,, & much more. Don't miss your chance to call this beautiful condo home. Welcome Home! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Blinds"
]
+"AssociationFee": "1181.22"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:7 [
0 => "Common Area Maintenance"
1 => "Cable TV"
2 => "Heat"
3 => "Electricity"
4 => "Water"
5 => "Insurance"
6 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:50:02.402625+00:00"
+"Directions": "Cross Streets: QEW & Green Road. ** Directions: North Service Rd, north on Green Rd, east on Frances Avenue."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2003014"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Balcony"
1 => "Level"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T16:48:30Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Outdoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:48:30Z"
+"StreetName": "Frances"
+"StreetNumber": "301"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2999.03"
+"View": "Lake view,View of water,Direct Water View,Unobstructed Water View"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvt/364338"
+"WaterBodyName": "Lake Ontario"
+"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": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29921081/802-301-frances-avenue-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Maple Ridge Community Managment"
+"GeocodeManualYN": false
+"BuildingFeatures": array:6 [
0 => "Storage - Locker"
1 => "Car Wash"
2 => "Exercise Centre"
3 => "Party Room"
4 => "Sauna"
5 => "Visitor Parking"
]
+"SecurityFeatures": array:2 [
0 => "Security system"
1 => "Controlled entry"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"OriginalEntryTimestamp": "2026-06-18T14:19:54.86Z"
+"ListAgentNationalAssociationId": "1285937"
+"ListOfficeNationalAssociationId": "1231482"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921081')"
+"ID": "1543025"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25227
+post_id: "1542914"
+post_author: 1
+"ListingKey": "29920798"
+"ListingId": "40840798"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T16:20:05Z"
+"RFModificationTimestamp": "2026-06-18T16:37:43Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1105.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8E3W6"
+"UnparsedAddress": "301 FRANCES Avenue Unit# 802, Hamilton, Ontario L8E3W6"
+"Coordinates": array:2 [
0 => -79.7240247
1 => 43.2406269
]
+"Latitude": 43.2406269
+"Longitude": -79.7240247
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to The Bayliner, a sought-after building where location, comfort, convenience, & a maintenance-free lifestyle come together by the lake. This beautiful 2 bedrm plus den, 1.5- bathrm corner suite offers 1105 sqft + a 77 sqft private balcony directly overlooking the lake. This unit is perfectly positioned within the building to capture some of the most spectacular unobstructed lake views in the building. Dare to compare the views w/other units currently for sale in the building - the panoramic waterfront vistas T/O this suite are exceptional. As a corner unit, the additional east-facing window welcomes beautiful sunrises & provides additional natural light T/O the day. Every principal room overlooks the lake, creating a truly picturesque setting. The open-concept layout includes a kitchen w/quartz CT, 4 SS appl., tile backsplash, under-cabinet lighting, a centre island, & lots of cupboard & countertop space, large living rm w/sliding doors to the private balcony, offering a front-row seat to the lake & distant Toronto skyline views, spacious dining area, & a den w/flexibility as an office, reading rm, or additional sitting area. The suite also has 2 bedrms, the primary w/ a walk-in closet & ensuite bath, & the 2nd bedrm w/double closet, a 4pce main bathrm, laundry rm w/linen closet, & a small storage rm. Additional features include quality laminate flooring, fresh paint T/O, ceiling fans, central air, underground parking, & a storage locker. The building is well managed, has a social club & a nice community feel, & outstanding amenities which include an outdoor pool, gym, exercise rm, sauna, party rm, games rm, library, workshop, car wash, community BBQ area, & lots of visitor parking. The condo fees include all utilities, as well as cable & internet. Ideally located steps to the lake, & close to the beach, trails, parks, conservation area, shops, dining, transit, the GO, QEW, & much more. Dont miss your chance to call this beautiful condo home. Welcome Home! (id:62650)"
+"AssociationFee": "1181.22"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Cable TV"
1 => "Heat"
2 => "Electricity"
3 => "Water"
4 => "Insurance"
5 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T15:22:28.175190+00:00"
+"Directions": "North Service Rd, north on Green Rd, east on Frances Avenue"
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Brick"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1946359"
+"ListOfficeKey": "55164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Visual exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-18T16:04:27Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:11:16Z"
+"Stories": "1.0"
+"StreetName": "FRANCES"
+"StreetNumber": "301"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "2999.03"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/364338"
+"WaterBodyName": "Lake Ontario"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29920798/301-frances-avenue-unit-802-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:3 [
0 => "Car Wash"
1 => "Exercise Centre"
2 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"ZoningDescription": "RM5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"AboveGradeFinishedArea": 1105
+"OriginalEntryTimestamp": "2026-06-18T13:31:08.48Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1241423"
+"ListOfficeNationalAssociationId": "1003546"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920798')"
+"ID": "1542914"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: "1536921"
+post_author: 1
+"ListingKey": "29912225"
+"ListingId": "X13452554"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T20:40:12Z"
+"RFModificationTimestamp": "2026-06-16T23:06:19Z"
+"ListPrice": 419900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8K0K3"
+"UnparsedAddress": "519 - 125 SHOREVIEW PLACE, Hamilton (Lakeshore), Ontario L8K0K3"
+"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": "Beautiful And Very Well Laid Out 1 Bedroom Plus Den Suite! "Sapphire" Building On The Shores Of Lake Ontario. Upper Level Suite With Good Size Bedroom With A Walk-In Closet, Large Living Room With Walk-Out To Balcony And Overlooking Greenbelt. Den Is Perfect For A Small Office, For Those Working From Home Or Can Be Used As A Small Second Bedroom. Very Spacious And Functional Layout! Convenient Storage Locker On Same Level As The Suite. Beautiful Rooftop Deck With Great View! Walking Trails And A Convenient Beach Just Outside! Very Well Maintained Building Offering Great Views, Functional Living In The Suite, And Great Outdoor Spaces For Those That Love To Be Outside! Minutes To The QEW And The New GO Station. Upper Level Suite Overlooking Green Space, 1 Underground Parking Spot, Convenient Locker on 5th Floor, This Is A Must See Suite! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"AssociationFee": "526.98"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T23:06:15.512854+00:00"
+"Directions": "Shoreview and Millen"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Ceramic"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1408477"
+"ListOfficeKey": "90198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-16T20:30:59Z"
+"PhotosCount": 30
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T20:30:59Z"
+"StreetName": "Shoreview"
+"StreetNumber": "125"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "4083.51"
+"View": "View"
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912225/519-125-shoreview-place-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Visitor Parking"
]
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"OriginalEntryTimestamp": "2026-06-16T20:30:59.1Z"
+"ListAgentNationalAssociationId": "1059725"
+"ListOfficeNationalAssociationId": "1153615"
+"Media": array:30 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912225')"
+"ID": "1536921"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25220
+post_id: "1523135"
+post_author: 1
+"ListingKey": "29893846"
+"ListingId": "X13435480"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T01:50:01Z"
+"RFModificationTimestamp": "2026-06-15T01:52:51Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0K3"
+"UnparsedAddress": "322 - 125 SHOREVIEW PLACE, Hamilton (Lakeshore), Ontario L8E0K3"
+"Coordinates": array:2 [
0 => -79.7202798
1 => 43.2391201
]
+"Latitude": 43.2391201
+"Longitude": -79.7202798
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to one of the largest 2+1 bedroom, 2 bathroom units in this sought-after waterfront condominium, offering over 1,000 sq. ft. of beautifully finished living space plus a spacious den. The primary bedroom features partial water views, while the balcony overlooks green space and a scenic walking path, creating the perfect place to relax and unwind. A rare and highly desirable feature, this unit includes 2 owned underground parking spaces, both conveniently located directly beside the elevator for exceptional everyday convenience. Residents enjoy an impressive selection of amenities, including a fitness centre, party room, rooftop terrace with stunning water views, beach access, and picturesque waterfront walking trails. Combining generous living space, premium amenities, and an unbeatable waterfront lifestyle, this condo offers exceptional value. Don't miss your opportunity to own one of the few units with 2 owned parking spaces in this desirable lakeside community. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"AssociationFee": "819.96"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Insurance"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T07:09:27.993955+00:00"
+"Directions": "Cross Streets: Shoreview & North Service. ** Directions: West of Shoreview."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2068952"
+"ListOfficeKey": "292897"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-12T05:16:05Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T01:42:00Z"
+"StreetName": "Shoreview"
+"StreetNumber": "125"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "5730.3"
+"View": "Direct Water View"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/geqjowr/unbranded"
+"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"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29893846/322-125-shoreview-place-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"OriginalEntryTimestamp": "2026-06-12T05:16:05.05Z"
+"ListAgentNationalAssociationId": "1344236"
+"ListOfficeNationalAssociationId": "1419084"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29893846')"
+"ID": "1523135"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1522550"
+post_author: 1
+"ListingKey": "29892464"
+"ListingId": "X13434370"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T20:30:16Z"
+"RFModificationTimestamp": "2026-06-15T20:31:15Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E3B4"
+"UnparsedAddress": "104 TEAL AVENUE, Hamilton (Stoney Creek), Ontario L8E3B4"
+"Coordinates": array:2 [
0 => -79.729741
1 => 43.242645
]
+"Latitude": 43.242645
+"Longitude": -79.729741
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this charming cottage-in-the-city home nestled in the sought-after Community Beach neighbourhood of Stoney Creek. Just a short stroll from the shores of Lake Ontario, residents enjoy beautiful waterfront views, beaches, trails and waterways while remaining close to everyday conveniences. This 1.5-storey brick home offers approximately 1,200 sq. ft. of living space with 4 bedrooms, 1 full bathroom and 1 half bath. The bright living room overlooks the inviting front porch, the perfect place to relax and enjoy the peaceful atmosphere of lakeside living. The spacious eat-in kitchen provides plenty of room for family meals and gatherings. Step outside to a private side patio sheltered by mature trees, creating an ideal setting for entertaining or unwinding outdoors. Two main-floor bedrooms and a full bathroom provide flexibility for growing families, while the upper level features a generous primary bedroom with excellent closet space and an equally sized fourth bedroom across the hall. The fully finished basement expands the living space with a cozy stove fireplace, laundry area, utility room, abundant storage and a convenient one-piece bathroom. A walkout leads to the deep, private backyard backing directly onto a community park featuring tennis and basketball courts and a newly constructed playground. Ideally located just minutes from Confederation Park, residents can enjoy swimming, sailing, hiking and cycling along the Waterfront Trail, two children's playgrounds and newly completed pickleball courts. With quick access to the QEW, commuting to Toronto or Niagara is effortless. Experience the perfect blend of cottage charm and city convenience in one of Stoney Creek's most desirable lakeside communities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Full"
1 => "Walk-up"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:03:32.130578+00:00"
+"Directions": "Cross Streets: Frances Ave. ** Directions: North Service Rd to Teal Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Wooded area"
2 => "Flat site"
]
+"LotSizeDimensions": "50 x 108 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T21:53:55Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T20:22:46Z"
+"Stories": "1.5"
+"StreetName": "Teal"
+"StreetNumber": "104"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4752.68"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/364176"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29892464/104-teal-avenue-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-11T21:53:55.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29892464')"
+"ID": "1522550"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: "1521277"
+post_author: 1
+"ListingKey": "29891447"
+"ListingId": "X13433702"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:48:43Z"
+"ListPrice": 339900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0J2"
+"UnparsedAddress": "413 - 35 SOUTHSHORE CRESCENT, Hamilton (Lakeshore), Ontario L8E0J2"
+"Coordinates": array:2 [
0 => -79.722273
1 => 43.240809
]
+"Latitude": 43.240809
+"Longitude": -79.722273
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this stylish and affordable 1-bedroom penthouse featuring stunning escarpment views and soaring ceilings. This is your opportunity to step into homeownership instead of continuing to rent-perfect for first-time buyers or savvy investors looking for solid value in one of the city's most competitively priced communities. Inside, you'll find a spacious, well-designed layout with a generous bedroom complete with a walk-in closet, a cozy living area, and a functional kitchen equipped with ample cabinetry, granite countertops, and stainless steel appliances including a dishwasher, stove, microwave, and fridge. The unit also offers geothermal heating and cooling, a modern 4-piece bathroom, in-unit laundry, and carpet-free flooring throughout for a clean, contemporary feel. Residents enjoy access to excellent building amenities, including a fully equipped gym, a stylish party room, and a large rooftop patio with breathtaking lake views-ideal for relaxing or entertaining. This is a smart move into a home that offers comfort, convenience, and real value. Don't miss it. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Microwave"
5 => "Window Coverings"
]
+"AssociationFee": "599.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:48:32.095203+00:00"
+"Directions": "Cross Streets: Green Rd & N Service Rd. ** Directions: West Nort Service Road North Green road, East Frances, North Southshore Cred."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2086746"
+"ListOfficeKey": "283948"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:54Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:54Z"
+"StreetName": "Southshore"
+"StreetNumber": "35"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3491.25"
+"View": "Direct Water View"
+"WaterBodyName": "Lake Ontario"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891447/413-35-southshore-crescent-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wentworth Standard Condo"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"OriginalEntryTimestamp": "2026-06-11T19:54:54.06Z"
+"ListAgentNationalAssociationId": "1360041"
+"ListOfficeNationalAssociationId": "1337191"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891447')"
+"ID": "1521277"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25229
+post_id: "1520822"
+post_author: 1
+"ListingKey": "29891899"
+"ListingId": "X13433986"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T21:30:09Z"
+"RFModificationTimestamp": "2026-06-11T21:33:53Z"
+"ListPrice": 3699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E3T7"
+"UnparsedAddress": "7 LAKEGATE DRIVE, Hamilton (Stoney Creek), Ontario L8E3T7"
+"Coordinates": array:2 [
0 => -79.733339
1 => 43.244782
]
+"Latitude": 43.244782
+"Longitude": -79.733339
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 7 Lakegate Drive, an extraordinary waterfront estate showcasing luxury, privacy, and rare direct access to Lake Ontario. Situated on a spectacular double lakefront lot with approximately 175 feet of shoreline, this custom-built bungalow presents a truly unique opportunity to own one of the area's most remarkable waterfront properties. Boasting over 3,800 sq ft of elegant main-floor living space, plus a fully finished lower level, this home is designed for both comfortable family living and effortless entertaining. Timeless finishes include wide-plank oak flooring, granite countertops, cathedral ceilings with skylights, crown moulding, and expansive living spaces filled with natural light. The chef-inspired kitchen flows seamlessly into the principal living areas, while the formal dining room with wet bar provides the perfect setting for hosting family and friends. The private bedroom wing features three spacious bedrooms, including a beautifully updated primary retreat complete with a custom walk-in closet, spa-inspired ensuite, and walkout to a private patio. Outside, a resort-style backyard awaits with a heated inground pool featuring a new liner installed in spring 2026, multiple entertaining areas, breathtaking lake views, and direct access to a private beach. A concrete boat ramp provides convenient water access for boating enthusiasts. Completing the property is an oversized 36' x 25' triple garage with rear access, ideal for storing boats, vehicles, and recreational equipment. Additional recent updates include two new furnaces, enhancing comfort and efficiency throughout the home. Adding further appeal, the property includes potential to sever an additional 70-foot lakefront lot to the west. A rare opportunity to enjoy luxury waterfront living, unmatched outdoor amenities, and future potential in one exceptional property. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:21:12.986759+00:00"
+"Directions": "Cross Streets: Grays Rd. ** Directions: QEW to North Service Rd, onto Grays Rd, right onto Lakegate Dr."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038160"
+"ListOfficeKey": "280315"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "177.5 x 192.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T20:54:17Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T21:20:35Z"
+"Stories": "1.0"
+"StreetName": "Lakegate"
+"StreetNumber": "7"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "23615.6"
+"View": "Lake view,Direct Water View"
+"VirtualTourURLUnbranded": "https://sites.tylerdavies.ca/vd/251194056"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891899/7-lakegate-drive-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "C, R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 177.6
+"OriginalEntryTimestamp": "2026-06-11T20:54:17.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1314350"
+"ListOfficeNationalAssociationId": "1312645"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891899')"
+"ID": "1520822"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 142
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]