array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30060273 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23528
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23530
+post_id: "1645734"
+post_author: 1
+"ListingKey": "30060273"
+"ListingId": "40849930"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-21T21:05:19Z"
+"RFModificationTimestamp": "2026-07-21T21:13:28Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2325.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E6G4"
+"UnparsedAddress": "484 MILLEN Road Unit# 15, Stoney Creek, Ontario L8E6G4"
+"Coordinates": array:2 [
0 => -79.7141601
1 => 43.2376077
]
+"Latitude": 43.2376077
+"Longitude": -79.7141601
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to prestigious Bal Harbour Estates, where luxury waterfront living meets effortless everyday comfort. This extensively renovated bungalow style end unit condo townhouse offers over 2,300 sq. ft. of beautifully finished living space, showcasing exceptional craftsmanship and premium finishes throughout. Completely transformed from top to bottom, this turnkey residence features a stunning designer kitchen, elegant bathrooms, premium flooring, upgraded lighting, and high end finishes at every turn. The bright, open concept main level is thoughtfully designed to capture breathtaking views of Lake Ontario, featuring a walk out that seamlessly blends indoor and outdoor living while framing the Toronto skyline in the distance. Step outside to the newly installed concrete pad, the perfect place to unwind, entertain, or simply relax while taking in the ever changing waterfront scenery. Premium European engineered motorized blinds provide effortless light control and privacy without compromising the spectacular views. The finished lower level offers exceptional additional living space, ideal for a recreation room, home office, gym, or guest retreat. As a desirable end unit, the home is flooded with natural light and offers added privacy, along with the rare convenience of three parking spaces, including an attached garage, private driveway, and an exclusive parking space located directly in front of the home, plus ample visitor parking for family and guests. Enjoy direct access to the waterfront trail and private beach, while being just minutes from Fifty Point Marina, shopping, dining, and convenient QEW access. Perfect for professionals, commuters, retirees, and boating enthusiasts seeking a maintenance free waterfront lifestyle. The recently fortified shoreline provides long-term peace of mind, allowing you to simply relax and enjoy one of Stoney Creek's most sought after lakefront communities. Luxury. Location. Lifestyle. Welcome home. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "647"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-21T16:44:25.443320+00:00"
+"Directions": "NORTH SERVICE RD AND DRIVING EAST TURN ON MILLER RD TOWARDS THE WATER AND HOME IS ON THE NORTHEAST SIDE"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2060544"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-21T18:08:29Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-21T20:59:38Z"
+"Stories": "1.0"
+"StreetName": "MILLEN"
+"StreetNumber": "484"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "6424.8"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/sites/484-millen-rd-15-hamilton-on-l8e-6g4-26671344/branded"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1690246309"
"RoomType" => "Laundry room"
"ListingId" => "40849930"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.71Z"
]
1 => array:11 [
"RoomKey" => "1690246310"
"RoomType" => "Full bathroom"
"ListingId" => "40849930"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.71Z"
]
2 => array:11 [
"RoomKey" => "1690246311"
"RoomType" => "Bedroom"
"ListingId" => "40849930"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 20'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.71Z"
]
3 => array:11 [
"RoomKey" => "1690246312"
"RoomType" => "4pc Bathroom"
"ListingId" => "40849930"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.71Z"
]
4 => array:11 [
"RoomKey" => "1690246313"
"RoomType" => "Bedroom"
"ListingId" => "40849930"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "12'7'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
5 => array:11 [
"RoomKey" => "1690246314"
"RoomType" => "Eat in kitchen"
"ListingId" => "40849930"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 17'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
6 => array:11 [
"RoomKey" => "1690246315"
"RoomType" => "Living room"
"ListingId" => "40849930"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 20'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
7 => array:11 [
"RoomKey" => "1690246316"
"RoomType" => "Foyer"
"ListingId" => "40849930"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
8 => array:11 [
"RoomKey" => "1690246317"
"RoomType" => "Other"
"ListingId" => "40849930"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
9 => array:11 [
"RoomKey" => "1690246318"
"RoomType" => "Utility room"
"ListingId" => "40849930"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "3'0'' x 3'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
10 => array:11 [
"RoomKey" => "1690246319"
"RoomType" => "Recreation room"
"ListingId" => "40849930"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 22'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
11 => array:11 [
"RoomKey" => "1690246320"
"RoomType" => "Storage"
"ListingId" => "40849930"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 3'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
12 => array:11 [
"RoomKey" => "1690246321"
"RoomType" => "2pc Bathroom"
"ListingId" => "40849930"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "3'5'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
13 => array:11 [
"RoomKey" => "1690246322"
"RoomType" => "Other"
"ListingId" => "40849930"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
14 => array:11 [
"RoomKey" => "1690246323"
"RoomType" => "Foyer"
"ListingId" => "40849930"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30060273"
"RoomLength" => null
"RoomDimensions" => "4'2'' x 16'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-21T20:59:38.72Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30060273/484-millen-road-unit-15-stoney-creek"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "RM4-4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"AboveGradeFinishedArea": 1550
+"BelowGradeFinishedArea": 775
+"OriginalEntryTimestamp": "2026-07-21T16:00:00.5Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1335689"
+"ListOfficeNationalAssociationId": "1344652"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30060273_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/eb83ce023ee3c09c5172150bebb8875d.webp"
"MediaSize" => 161767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-eb83ce023ee3c09c5172150bebb8875d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30060273_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/75fc601810986d9fcc20886f36f73b3c.webp"
"MediaSize" => 162973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-75fc601810986d9fcc20886f36f73b3c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30060273_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/797ea50f8338d5eb215e37fdcb59637d.webp"
"MediaSize" => 126745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-797ea50f8338d5eb215e37fdcb59637d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T17:23:16.27Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30060273_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/670c51a2fb2ac2406a165161f21c3b44.webp"
"MediaSize" => 94890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-670c51a2fb2ac2406a165161f21c3b44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T17:23:15.53Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30060273_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/a8df5586fee40cdf621ea3589c912bb2.webp"
"MediaSize" => 111881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-a8df5586fee40cdf621ea3589c912bb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T17:23:15.51Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30060273_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/f7acdb8b57f608fb1053c0b67ea26af1.webp"
"MediaSize" => 158001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-f7acdb8b57f608fb1053c0b67ea26af1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T17:23:16.4Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30060273_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/32ed7cee70465502596238dd6443942e.webp"
"MediaSize" => 157790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-32ed7cee70465502596238dd6443942e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T17:23:16.4Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30060273_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/4d9218f3d6b20375e186803a84fbdc72.webp"
"MediaSize" => 148680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-4d9218f3d6b20375e186803a84fbdc72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T17:23:15.59Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30060273_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/83f0d3bd908b65c4b4ef71227eb9d175.webp"
"MediaSize" => 114547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-83f0d3bd908b65c4b4ef71227eb9d175.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T17:23:15.51Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30060273_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/e17e1d565e353d75400f9bf3d2b98457.webp"
"MediaSize" => 120545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-e17e1d565e353d75400f9bf3d2b98457.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T17:23:15.51Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30060273_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/8e71a7bf623bd7a1b22dbf5cfb57d2a4.webp"
"MediaSize" => 63930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-8e71a7bf623bd7a1b22dbf5cfb57d2a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T17:23:15.54Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30060273_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/b896f104f7be66fc22190a86a975b69b.webp"
"MediaSize" => 42413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-b896f104f7be66fc22190a86a975b69b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30060273_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/c3ea16600a973b757133e5ecef5daa41.webp"
"MediaSize" => 62055
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-c3ea16600a973b757133e5ecef5daa41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30060273_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/3867bb4f6c969f43543bfe4ddcd34ca1.webp"
"MediaSize" => 63456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-3867bb4f6c969f43543bfe4ddcd34ca1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30060273_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/ea32d4ef251b055a647da15e4a28dd57.webp"
"MediaSize" => 72549
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-ea32d4ef251b055a647da15e4a28dd57.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30060273_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/dac2710e08be2b4642ee5c6859c67811.webp"
"MediaSize" => 63094
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-dac2710e08be2b4642ee5c6859c67811.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30060273_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/92e991830fec560527fe7c3916302685.webp"
"MediaSize" => 54857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-92e991830fec560527fe7c3916302685.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30060273_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/d1270fb1c670b07dff221d6d4416e9d6.webp"
"MediaSize" => 53400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-d1270fb1c670b07dff221d6d4416e9d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30060273_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/063d18ef99a17055a388bc359f96d864.webp"
"MediaSize" => 56495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-063d18ef99a17055a388bc359f96d864.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30060273_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/84de5e4eb7841cba6ea6205cd5823ec5.webp"
"MediaSize" => 47644
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-84de5e4eb7841cba6ea6205cd5823ec5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30060273_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/b49987baf3209a97064319a380b9bae7.webp"
"MediaSize" => 56498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-b49987baf3209a97064319a380b9bae7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30060273_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/920d6fa602cf41ed3f08e68d1cfd8976.webp"
"MediaSize" => 50950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-920d6fa602cf41ed3f08e68d1cfd8976.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30060273_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/b5d68af99d6d19de8b0efdf6f3eddf3e.webp"
"MediaSize" => 52071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-b5d68af99d6d19de8b0efdf6f3eddf3e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30060273_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/0aca4760baa436922f3e165075ad3ba7.webp"
"MediaSize" => 51296
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-0aca4760baa436922f3e165075ad3ba7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30060273_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/14baa36a11994f2e81472a2a159152a7.webp"
"MediaSize" => 66835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-14baa36a11994f2e81472a2a159152a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30060273_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/d51fcbc6416a1bcf45b50d1cad9c8aae.webp"
"MediaSize" => 59027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-d51fcbc6416a1bcf45b50d1cad9c8aae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30060273_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/8b79587d13ec2ebf2eb62e3c32bfd77f.webp"
"MediaSize" => 68063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-8b79587d13ec2ebf2eb62e3c32bfd77f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30060273_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/7ebef72eabefb05131a6080ec957ecc7.webp"
"MediaSize" => 54019
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-7ebef72eabefb05131a6080ec957ecc7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30060273_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/6b5cea4821b201126dbca5fff58bf496.webp"
"MediaSize" => 52568
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-6b5cea4821b201126dbca5fff58bf496.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30060273_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/5e68886ffdd1022b49314c21b19e8587.webp"
"MediaSize" => 27837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-5e68886ffdd1022b49314c21b19e8587.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30060273_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/e4935ac640f1fd5a1cdb39ec6986adaa.webp"
"MediaSize" => 77336
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-e4935ac640f1fd5a1cdb39ec6986adaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30060273_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/740c652049920e73f68ce9f370f8d742.webp"
"MediaSize" => 80757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-740c652049920e73f68ce9f370f8d742.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30060273_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/c46cfe6e204ec07469163e0701cb9758.webp"
"MediaSize" => 72633
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-c46cfe6e204ec07469163e0701cb9758.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30060273_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/ed82195437aeed45a36f745967a7efaf.webp"
"MediaSize" => 52174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-ed82195437aeed45a36f745967a7efaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30060273_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/619c6192fa76d86fd81f3c7dbfb3fca1.webp"
"MediaSize" => 48272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-619c6192fa76d86fd81f3c7dbfb3fca1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T16:00:00.51Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30060273_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/815a251e555235f1876d7f8ba23ec6d4.webp"
"MediaSize" => 117044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-815a251e555235f1876d7f8ba23ec6d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor patio with a covered section, concrete surface, and direct access through a sliding glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T18:03:15.65Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30060273_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/61d5e844ca20b7fa251d561985b6819c.webp"
"MediaSize" => 96106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-61d5e844ca20b7fa251d561985b6819c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T18:03:15.9Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30060273_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/071db1e2b3f3fd70d16599b456809a0f.webp"
"MediaSize" => 90106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-071db1e2b3f3fd70d16599b456809a0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive concrete patio offering open-air living with water frontage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T18:03:15.7Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30060273_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/4aaea5391e2ecdaff45dfcd85241abe3.webp"
"MediaSize" => 97953
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-4aaea5391e2ecdaff45dfcd85241abe3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive concrete patio offering open-air living"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T18:03:15.91Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30060273_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/cb1396ae60dccc8a7b23642dde4a4968.webp"
"MediaSize" => 128718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-cb1396ae60dccc8a7b23642dde4a4968.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T18:03:15.58Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30060273_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/f567f9ca1d19089b4e202cd64ab40488.webp"
"MediaSize" => 111866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-f567f9ca1d19089b4e202cd64ab40488.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T18:03:16.46Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30060273_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/5f2c2dc3f5dc2dc03e7448c94a89d34c.webp"
"MediaSize" => 55607
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-5f2c2dc3f5dc2dc03e7448c94a89d34c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T18:03:15.65Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30060273_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/182b44e1ea8d4e3b1ad2f25d87aa4a82.webp"
"MediaSize" => 42672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-182b44e1ea8d4e3b1ad2f25d87aa4a82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T18:03:15.65Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30060273_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30060273/7f5ef82acb74877fbd76b8660ed370a5.webp"
"MediaSize" => 52197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30060273/thumbnail-7f5ef82acb74877fbd76b8660ed370a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40849930"
"ResourceRecordKey" => "30060273"
"ModificationTimestamp" => "2026-07-21T18:03:15.59Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30060273')"
+"ID": "1645734"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 284635" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25040
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24983
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Escarpment Realty Inc."
+"OfficeEmail": null
+"OfficePhone": "905-575-5478"
+"OfficeMlsId": "HBREMAESUP4B"
+"ModificationTimestamp": "2026-06-18T15:38:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "284635"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "1595 Upper James St Unit 4B"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Hamilton"
+"OfficePostalCode": "L9B0H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1344652"
+"OriginalEntryTimestamp": "2019-01-30T20:05:00Z"
+"OfficeFax": "905-575-7217"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439663"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "284635"
"SocialMediaUrlOrId" => "https://www.remaxescarpment.com/"
"ModificationTimestamp" => "2026-06-18T14:28:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1064286"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('284635')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2060544" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25063
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30060273'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25370
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30060273' AND OpenHouseDate ge '2026-07-23'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25478
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30060273' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.7141601 43.2376077)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25404
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25398
+post_id: "1654241"
+post_author: 1
+"ListingKey": "30073642"
+"ListingId": "X13600486"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T00:30:01Z"
+"RFModificationTimestamp": "2026-07-24T01:39:01Z"
+"ListPrice": 774900.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-07-24T01:38:51.305676+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-07-24T00:24:54Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T00:24:54Z"
+"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"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1692108091"
"RoomType" => "Living room"
"ListingId" => "X13600486"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "30073642"
"RoomLength" => 7.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T00:24:54.12Z"
]
1 => array:11 [
"RoomKey" => "1692108092"
"RoomType" => "Dining room"
"ListingId" => "X13600486"
"RoomLevel" => "Main level"
"RoomWidth" => 2.64
"ListingKey" => "30073642"
"RoomLength" => 2.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T00:24:54.13Z"
]
2 => array:11 [
"RoomKey" => "1692108093"
"RoomType" => "Kitchen"
"ListingId" => "X13600486"
"RoomLevel" => "Main level"
"RoomWidth" => 2.64
"ListingKey" => "30073642"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T00:24:54.13Z"
]
3 => array:11 [
"RoomKey" => "1692108094"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13600486"
"RoomLevel" => "Second level"
"RoomWidth" => 3.81
"ListingKey" => "30073642"
"RoomLength" => 4.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T00:24:54.13Z"
]
4 => array:11 [
"RoomKey" => "1692108095"
"RoomType" => "Bedroom 2"
"ListingId" => "X13600486"
"RoomLevel" => "Second level"
"RoomWidth" => 3.2
"ListingKey" => "30073642"
"RoomLength" => 4.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T00:24:54.13Z"
]
5 => array:11 [
"RoomKey" => "1692108096"
"RoomType" => "Bedroom 3"
"ListingId" => "X13600486"
"RoomLevel" => "Second level"
"RoomWidth" => 2.87
"ListingKey" => "30073642"
"RoomLength" => 3.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T00:24:54.13Z"
]
6 => array:11 [
"RoomKey" => "1692108097"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13600486"
"RoomLevel" => "Basement"
"RoomWidth" => 5.94
"ListingKey" => "30073642"
"RoomLength" => 7.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T00:24:54.13Z"
]
7 => array:11 [
"RoomKey" => "1692108098"
"RoomType" => "Utility room"
"ListingId" => "X13600486"
"RoomLevel" => "Basement"
"RoomWidth" => 3.25
"ListingKey" => "30073642"
"RoomLength" => 2.01
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T00:24:54.13Z"
]
8 => array:11 [
"RoomKey" => "1692108099"
"RoomType" => "Other"
"ListingId" => "X13600486"
"RoomLevel" => "Basement"
"RoomWidth" => 2.64
"ListingKey" => "30073642"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-24T00:24:54.13Z"
]
]
+"ListAOR": "Oakville-Milton"
+"CityRegion": "Lakeshore"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/30073642/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-07-24T00:24:54.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1245775"
+"ListOfficeNationalAssociationId": "1347969"
+"CoListAgentNationalAssociationId": "1325722"
+"CoListOfficeNationalAssociationId": "1347969"
+"Media": array:35 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30073642_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073642/b012b96c33aa7d2a0cf5da57d2dfb94f.webp"
"MediaSize" => 402693
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073642/thumbnail-b012b96c33aa7d2a0cf5da57d2dfb94f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13600486"
"ResourceRecordKey" => "30073642"
"ModificationTimestamp" => "2026-07-24T00:24:54.08Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30073642_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073642/8f1c49615446f756d7c99869a7b9a7d8.webp"
"MediaSize" => 373679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073642/thumbnail-8f1c49615446f756d7c99869a7b9a7d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600486"
"ResourceRecordKey" => "30073642"
"ModificationTimestamp" => "2026-07-24T00:24:54.08Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30073642_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30073642/9871a97fa426ebc06d4c534d575c29a1.webp"
"MediaSize" => 349637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30073642/thumbnail-9871a97fa426ebc06d4c534d575c29a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13600486"
"ResourceRecordKey" => "30073642"
…1
]
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('30073642')"
+"ID": "1654241"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25400
+post_id: "1653975"
+post_author: 1
+"ListingKey": "30073605"
+"ListingId": "40850719"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-24T00:15:05Z"
+"RFModificationTimestamp": "2026-07-24T00:43:52Z"
+"ListPrice": 774900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2175.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E6A3"
+"UnparsedAddress": "117 FRANCES Avenue, Stoney Creek, Ontario L8E6A3"
+"Coordinates": array:2 [
0 => -79.7257631
1 => 43.2408152
]
+"Latitude": 43.2408152
+"Longitude": -79.7257631
+"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:62650)"
+"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-07-24T00:43:46.258560+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"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-24T00:12:54Z"
+"PhotosCount": 35
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-24T00:12:54Z"
+"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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30073605/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-07-24T00:08:27.37Z"
+"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 [ …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('30073605')"
+"ID": "1653975"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25397
+post_id: "1654473"
+post_author: 1
+"ListingKey": "30072617"
+"ListingId": "X13599574"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:45:06Z"
+"RFModificationTimestamp": "2026-07-23T23:08:40Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "590 NORTH SERVICE ROAD, Hamilton (Stoney Creek), Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.697576
1 => 43.233855
]
+"Latitude": 43.233855
+"Longitude": -79.697576
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 50 at 590 North Service Road in Stoney Creek, a beautifully maintained and affordable home built in 2020, offering modern living in one of the city's most convenient and rapidly growing communities. Whether you're a first time buyer, young professional, downsizer, or investor, this home delivers the perfect combination of style, comfort, and location.Nestled in a prime Stoney Creek setting, this property offers stunning escarpment views and is located just moments from the lake, giving you the best of both natural beauty and urban convenience. Enjoy easy access to waterfront parks, walking and biking trails, local beaches, and scenic outdoor spaces while still being close to everything you need for day to day living.Inside, you'll find a modern layout designed for today's lifestyle with bright living spaces, contemporary finishes, and a welcoming atmosphere throughout. Built in 2020, this newer home provides peace of mind with updated construction, energy efficiency, and low maintenance living.The location is truly unbeatable. Situated near the popular Costco Plaza, you are just minutes away from shopping, restaurants, cafes, fitness centres, and everyday amenities. Commuters will appreciate the quick access to the QEW, Red Hill Valley Parkway, and major routes connecting you to Hamilton, Niagara, and the GTA.Offering incredible value in an exceptional location, Unit 50 at 590 North Service Road is your opportunity to enjoy modern living surrounded by convenience, nature, and breathtaking escarpment scenery. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T23:08:31.364952+00:00"
+"Directions": "Cross Streets: Lakeview Drive. ** Directions: QEW exit Fruitland Rd, left onto Lakeview Dr, continue onto N. Service Rd, left into complex, property on outer perimeter facing highway."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20.4 x 41.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T20:39:57Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T20:39:57Z"
+"Stories": "3.0"
+"StreetName": "North Service"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4098.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30072617/590-north-service-road-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 20.4
+"OriginalEntryTimestamp": "2026-07-23T20:39:57.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:24 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072617')"
+"ID": "1654473"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25401
+post_id: "1652862"
+post_author: 1
+"ListingKey": "30072345"
+"ListingId": "40850466"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:05:19Z"
+"RFModificationTimestamp": "2026-07-23T20:17:06Z"
+"ListPrice": 499000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1169.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0K5"
+"UnparsedAddress": "590 NORTH SERVICE Road Unit# 50, Stoney Creek, Ontario L8E0K5"
+"Coordinates": array:2 [
0 => -79.6970371
1 => 43.2332173
]
+"Latitude": 43.2332173
+"Longitude": -79.6970371
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 50 at 590 North Service Road in Stoney Creek, a beautifully maintained and affordable home built in 2020, offering modern living in one of the city's most convenient and rapidly growing communities. Whether you're a first time buyer, young professional, downsizer, or investor, this home delivers the perfect combination of style, comfort, and location. Nestled in a prime Stoney Creek setting, this property offers stunning escarpment views and is located just moments from the lake, giving you the best of both natural beauty and urban convenience. Enjoy easy access to waterfront parks, walking and biking trails, local beaches, and scenic outdoor spaces while still being close to everything you need for day to day living. Inside, you’ll find a modern layout designed for today’s lifestyle with bright living spaces, contemporary finishes, and a welcoming atmosphere throughout. Built in 2020, this newer home provides peace of mind delivers the perfect combination of style, comfort, and location. Nestled in a prime Stoney Creek setting, this with updated construction, energy efficiency, and low maintenance living. The location is truly unbeatable. Situated near the popular Costco Plaza, you are just minutes away from shopping, restaurants, cafes, fitness centres, and everyday amenities. Commuters will appreciate the quick access to the QEW, Red Hill Valley Parkway, and major routes connecting you to Hamilton, Niagara, and the GTA. Offering incredible value in an exceptional location, Unit 50 at 590 North Service Road is your opportunity to enjoy modern living surrounded by convenience, nature, and breathtaking escarpment scenery. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "117"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T20:17:01.549035+00:00"
+"Directions": "QEW Exit Fruitland, Left Onto Lakeview Dr, Continue Onto North Service Rd, Left Into Complex, Property On Outer Perimeter Facing Highway"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T19:59:37Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T19:59:37Z"
+"Stories": "3.0"
+"StreetName": "NORTH SERVICE"
+"StreetNumber": "590"
+"StreetSuffix": "Road"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4098.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30072345/590-north-service-road-unit-50-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2208479"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299867"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1169
+"OriginalEntryTimestamp": "2026-07-23T19:59:37.73Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1454953"
+"CoListOfficeNationalAssociationId": "1477945"
+"Media": array:26 [
0 => array:13 [ …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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30072345')"
+"ID": "1652862"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25399
+post_id: "1652171"
+post_author: 1
+"ListingKey": "30071338"
+"ListingId": "X13598556"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T20:20:06Z"
+"RFModificationTimestamp": "2026-07-23T20:24:52Z"
+"ListPrice": 379900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek)"
+"PostalCode": "L8E0K2"
+"UnparsedAddress": "502 - 101 SHOREVIEW PLACE, Hamilton (Stoney Creek), Ontario L8E0K2"
+"Coordinates": array:2 [
0 => -79.719283
1 => 43.238795
]
+"Latitude": 43.238795
+"Longitude": -79.719283
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Wake up to spectacular, uninterrupted views of Lake Ontario from the living room, bedroom, and private balcony in this sun-filled fifth-floor condo offering the perfect blend of luxury, comfort, and waterfront living. Boasting 564 sq. ft. of thoughtfully designed interior space plus a 53 sq. ft. private terrace, this bright open-concept home features elegant wood flooring throughout, a modern kitchen with quartz countertops, ample cabinetry, a breakfast bar, upgraded ceramic flooring, and premium stainless steel appliances. The spacious bedroom offers serene lake views and generous closet space, while the suite also includes convenient ensuite laundry with full-size stacked washer and dryer. Complete with one owned underground parking space, a locker, and bike storage, residents enjoy exceptional amenities including a rooftop terrace with breathtaking panoramic lake views, a fully equipped fitness centre, party room, parcel lockers, and direct access to the scenic waterfront trail. Ideally located close to shopping, major highways, and the GO Station, this is an outstanding opportunity to experience lakeside living at its finest. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Multi-level"
]
+"AssociationFee": "460.75"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T18:19:48.703551+00:00"
+"Directions": "N. Service Rd to Millen Rd to Shoreview Pl"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1940894"
+"ListOfficeKey": "289187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T17:39:28Z"
+"PhotosCount": 41
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T20:10:17Z"
+"StreetName": "Shoreview"
+"StreetNumber": "101"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "3092.74"
+"View": "Lake view,View"
+"VirtualTourURLUnbranded": "https://unbranded.iguidephotos.com/502_101_shoreview_pl_hamilton_on/"
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30071338/502-101-shoreview-place-hamilton-stoney-creek-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Storage - Locker"
]
+"LivingAreaMaximum": 599
+"LivingAreaMinimum": 500
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-07-23T17:39:28.41Z"
+"ListAgentNationalAssociationId": "1238254"
+"ListOfficeNationalAssociationId": "1375388"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30071338')"
+"ID": "1652171"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25394
+post_id: "1651666"
+post_author: 1
+"ListingKey": "30070587"
+"ListingId": "X13597652"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T16:20:07Z"
+"RFModificationTimestamp": "2026-07-23T16:36:45Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E5V6"
+"UnparsedAddress": "6 - 44 FRANCES AVENUE, Hamilton (Lakeshore), Ontario L8E5V6"
+"Coordinates": array:2 [
0 => -79.729757
1 => 43.2404
]
+"Latitude": 43.2404
+"Longitude": -79.729757
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 6-44 Frances Avenue, a beautifully maintained 2-storey townhome nestled in one of Stoney Creek's most desirable lakeside communities. Built by Marz Homes, this inviting residence offers the perfect blend of comfort, style, and convenience, making it an excellent choice for families, first-time buyers, or those looking to enjoy the freedom of low-maintenance living! Featuring 3 spacious bedrooms, 2 bathrooms, and a fully finished basement, this home offers functional living space from top to bottom. The bright main level showcases hardwood flooring and an inviting layout ideal for both everyday living and entertaining. The finished lower level provides additional living space perfect for a recreation room, home office, or gym. Enjoy the convenience of an attached garage with inside entry, private driveway parking, and a spacious rear deck ideal for relaxing or summer BBQs. Thoughtful updates include the roof (approx. 2 years), windows scheduled for replacement in 2025, updated flooring, kitchen, bathrooms, and patio door, allowing buyers to move in with confidence. Low condo fees include water, building insurance, exterior maintenance, parking, and visitor parking. Located just steps from parks, the waterfront, trails, shopping, restaurants, schools, and quick QEW access, this exceptional home offers the perfect lifestyle in an unbeatable location. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"AssociationFee": "493.94"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T16:36:10.148918+00:00"
+"Directions": "Cross Streets: Teal Ave. ** Directions: North Service Rd to Green Rd, left onto Frances Ave, left into complex."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2038160"
+"ListOfficeKey": "280315"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T16:12:41Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T16:12:41Z"
+"Stories": "2.0"
+"StreetName": "Frances"
+"StreetNumber": "44"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4061.2"
+"VirtualTourURLUnbranded": "https://sites.tylerdavies.ca/mls/257854486"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30070587/6-44-frances-avenue-hamilton-lakeshore-lakeshore"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2106038"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Enfield Group Inc."
+"CoListOfficeKey": "280315"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "OS, RM3-8"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-23T16:12:41.22Z"
+"ListAgentNationalAssociationId": "1314350"
+"ListOfficeNationalAssociationId": "1312645"
+"CoListAgentNationalAssociationId": "1375256"
+"CoListOfficeNationalAssociationId": "1312645"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070587')"
+"ID": "1651666"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23542
+post_id: "1651605"
+post_author: 1
+"ListingKey": "30070115"
+"ListingId": "40850233"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T15:35:38Z"
+"RFModificationTimestamp": "2026-07-23T15:36:59Z"
+"ListPrice": 669900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1352.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E5V6"
+"UnparsedAddress": "44 FRANCES Avenue Unit# 6, Stoney Creek, Ontario L8E5V6"
+"Coordinates": array:2 [
0 => -79.7299497
1 => 43.2408418
]
+"Latitude": 43.2408418
+"Longitude": -79.7299497
+"YearBuilt": 1996
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 6-44 Frances Avenue, a beautifully maintained 2-storey townhome nestled in one of Stoney Creek's most desirable lakeside communities. Built by Marz Homes, this inviting residence offers the perfect blend of comfort, style, and convenience, making it an excellent choice for families, first-time buyers, or those looking to enjoy the freedom of low-maintenance living! Featuring 3 spacious bedrooms, 2 bathrooms, and a fully finished basement, this home offers functional living space from top to bottom. The bright main level showcases hardwood flooring and an inviting layout ideal for both everyday living and entertaining. The finished lower level provides additional living space perfect for a recreation room, home office, or gym. Enjoy the convenience of an attached garage with inside entry, private driveway parking, and a spacious rear deck ideal for relaxing or summer BBQs. Thoughtful updates include the roof (approx. 2 years), windows scheduled for replacement in 2025, updated flooring, kitchen, bathrooms, and patio door, allowing buyers to move in with confidence. Low condo fees include water, building insurance, exterior maintenance, parking, and visitor parking. Located just steps from parks, the waterfront, trails, shopping, restaurants, schools, and quick QEW access, this exceptional home offers the perfect lifestyle in an unbeatable location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"AssociationFee": "493.94"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T15:36:53.634140+00:00"
+"Directions": "North Service Rd to Green Rd, left onto Frances Ave, left into complex"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524652"
+"ListOfficeKey": "294490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-23T15:14:16Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T15:29:11Z"
+"Stories": "2.0"
+"StreetName": "FRANCES"
+"StreetNumber": "44"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "4061.2"
+"VirtualTourURLUnbranded": "https://sites.tylerdavies.ca/44francesavenue6"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30070115/44-frances-avenue-unit-6-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1910452"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "294490"
+"GeocodeManualYN": true
+"ZoningDescription": "OS, RM3-8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1352
+"OriginalEntryTimestamp": "2026-07-23T15:08:22.61Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063221"
+"ListOfficeNationalAssociationId": "1439453"
+"CoListAgentNationalAssociationId": "1222460"
+"CoListOfficeNationalAssociationId": "1439453"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30070115')"
+"ID": "1651605"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25402
+post_id: "1651611"
+post_author: 1
+"ListingKey": "30069935"
+"ListingId": "X13596934"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T15:15:07Z"
+"RFModificationTimestamp": "2026-07-23T15:20:14Z"
+"ListPrice": 374900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lakeshore)"
+"PostalCode": "L8E0J2"
+"UnparsedAddress": "221 - 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": "Resort-style lakeside living meets modern urban convenience at Waterfront Trails Boutique Condo located at 35 Southshore Crescent in Stoney Creek. This immaculate, carpet-free 1+1 bed, 1-bath suite features 707 sq ft of beautifully optimized living space, significantly larger than standard building models. Perfect for remote work, the floor plan showcases a separate, large den ideal for a quiet home office or guest space. The bright, open-concept living area walks out to a private balcony catching evening breezes. A modern kitchen boasts ample cabinetry, tiled flooring, and stainless Whirlpool appliances. Unwind in the spacious primary bedroom with a spacious walk-in closet. Enjoy in-suite laundry, secure underground parking, and an owned storage locker. Waterfront Trails is a boutique building of four levels with a fifth-level rooftop terrace overlooking the water, offering panoramic views of Lake Ontario and the Toronto skyline. Ground-floor amenities include a gym, yoga studio, and party room with BBQ access. For outdoor enthusiasts, the main-level bike room allows you to come right in from the trail, store your gear, or grab your bike and go for a stroll. Step right onto the Great Lakes Waterfront Trail and local beach paths. Commuting is effortless with fast access to the QEW and the upcoming Confederation Park GO Station, while premium dining and Niagara wineries are just a short drive away. Monthly condo fees cover management, maintenance, insurance, heat, and water, leaving you with only a small hydro bill. This pet-friendly building offers the ultimate lakeside lifestyle. (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)"
]
+"AssociationFee": "703.48"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T15:20:05.558667+00:00"
+"Directions": "Green/Francis"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2004945"
+"ListOfficeKey": "283586"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Elevator"
2 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-07-23T14:40:20Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T15:09:48Z"
+"StreetName": "Southshore"
+"StreetNumber": "35"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3814.5"
+"VirtualTourURLUnbranded": "https://vimeo.com/1212103540?share=copy&fl=sv&fe=ci"
+"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"
+"TaxYear": 2026
+"CityRegion": "Lakeshore"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30069935/221-35-southshore-crescent-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": 799
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"OriginalEntryTimestamp": "2026-07-23T14:40:20.14Z"
+"ListAgentNationalAssociationId": "1293035"
+"ListOfficeNationalAssociationId": "1331925"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30069935')"
+"ID": "1651611"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25403
+post_id: "1651616"
+post_author: 1
+"ListingKey": "30069547"
+"ListingId": "40846758"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-23T14:30:03Z"
+"RFModificationTimestamp": "2026-07-23T14:34:55Z"
+"ListPrice": 374900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 707.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8E0J2"
+"UnparsedAddress": "35 SOUTHSHORE Crescent Unit# 221, Stoney Creek, Ontario L8E0J2"
+"Coordinates": array:2 [
0 => -79.7222532
1 => 43.2406553
]
+"Latitude": 43.2406553
+"Longitude": -79.7222532
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Resort-style lakeside living meets modern urban convenience at Waterfront Trails Boutique Condo located at 35 Southshore Crescent in Stoney Creek. This immaculate, carpet-free 1+1 bed, 1-bath suite features 707 sq ft of beautifully optimized living space, significantly larger than standard building models. Perfect for remote work, the floor plan showcases a separate, large den ideal for a quiet home office or guest space. The bright, open-concept living area walks out to a private balcony catching evening breezes. A modern kitchen boasts ample cabinetry, tiled flooring, and stainless Whirlpool appliances. Unwind in the spacious primary bedroom with a spacious walk-in closet. Enjoy in-suite laundry, secure underground parking, and an owned storage locker. Waterfront Trails is a boutique building of four levels with a fifth-level rooftop terrace overlooking the water, offering panoramic views of Lake Ontario and the Toronto skyline. Ground-floor amenities include a gym, yoga studio, and party room with BBQ access. For outdoor enthusiasts, the main-level bike room allows you to come right in from the trail, store your gear, or grab your bike and go for a stroll. Step right onto the Great Lakes Waterfront Trail and local beach paths. Commuting is effortless with fast access to the QEW and the upcoming Confederation Park GO Station, while premium dining and Niagara wineries are just a short drive away. Monthly condo fees cover management, maintenance, insurance, heat, and water, leaving you with only a small hydro bill. This pet-friendly building offers the ultimate lakeside lifestyle. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"AssociationFee": "703.48"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-23T14:34:51.436041+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1999707"
+"ListOfficeKey": "283187"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:3 [
0 => "Underground"
1 => "None"
2 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-23T14:22:33Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-23T14:22:33Z"
+"Stories": "1.0"
+"StreetName": "SOUTHSHORE"
+"StreetNumber": "35"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "510 - Community Beach/Fifty Point"
+"TaxAnnualAmount": "3814.5"
+"View": "No Water View"
+"VirtualTourURLUnbranded": "https://vimeo.com/1212103540?share=copy&fl=sv&fe=ci"
+"WaterBodyName": "Lake Ontario"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30069547/35-southshore-crescent-unit-221-stoney-creek"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "R6-5, RM3-40, RM3-41"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"AboveGradeFinishedArea": 707
+"OriginalEntryTimestamp": "2026-07-23T13:59:38.53Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1282013"
+"ListOfficeNationalAssociationId": "1325425"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30069547')"
+"ID": "1651616"
}
]
+success: true
+page_size: 9
+page_count: 16
+count: 142
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]