array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29924553 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1545515"
+post_author: 1
+"ListingKey": "29924553"
+"ListingId": "40841275"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T20:20:31Z"
+"RFModificationTimestamp": "2026-06-18T20:37:49Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 937.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N0B4"
+"UnparsedAddress": "479 CHARLTON Avenue E Unit# 204, Hamilton, Ontario L8N0B4"
+"Coordinates": array:2 [
0 => -79.8534172
1 => 43.2454945
]
+"Latitude": 43.2454945
+"Longitude": -79.8534172
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 204 at Vista Condos — the coveted Poplar floor plan offering 937 sqft and one of the largest balconies in the building at 142 sqft. With only two suites of this size per floor, this 2-bedroom, 2-bathroom corner residence offers a rare blend of privacy, sophistication, and elevated urban living. Wrapped in a soothing designer white palette, the suite feels calm, bright, and beautifully composed. The kitchen features extended white cabinetry, quartz countertops, a designer backsplash, and quality flooring that carries throughout the space. The main bath is finished with a glass shower and striking black accent tile, while the spacious primary suite offers a walk-in closet and oversized ensuite for a refined daily retreat. In-suite laundry adds everyday ease. Step outside to an exceptional private balcony framed by treetop, rail trail, and city views — peaceful, green, and quietly removed, yet moments from the energy of the city. Your new home offers thoughtful amenities including a gym, terrace, bike room, party room, visitor parking, a bbq area, and attentive cleaning staff. A prime underground parking spot beside the elevator and an extra-large locker are both included. Condo fees include heat and water, common elements, and building insurance. Set moments from Corktown, Locke Street dining, St. Joe’s Hospital, the GO Station, 403/QEW/LINC access, McMaster, James North, and the Niagara Escarpment trail system, this is a stylish treetop retreat designed for young professionals and first-time buyers ready for a lifestyle upgrade. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "806.86"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Water"
5 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T20:37:41.838901+00:00"
+"Directions": "403 to Main St W, East on Main, Right on Wentworth"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073224"
+"ListOfficeKey": "283262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-18T20:11:28Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:11:28Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "CHARLTON"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "143 - Stinson"
+"TaxAnnualAmount": "5434.74"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1662388920"
"RoomType" => "Laundry room"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "2'9'' x 2'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
1 => array:11 [
"RoomKey" => "1662388921"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 5'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
2 => array:11 [
"RoomKey" => "1662388922"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
3 => array:11 [
"RoomKey" => "1662388923"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
4 => array:11 [
"RoomKey" => "1662388924"
"RoomType" => "Bedroom"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
5 => array:11 [
"RoomKey" => "1662388925"
"RoomType" => "Living room"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
6 => array:11 [
"RoomKey" => "1662388926"
"RoomType" => "Dining room"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
7 => array:11 [
"RoomKey" => "1662388927"
"RoomType" => "Kitchen"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.09Z"
]
8 => array:11 [
"RoomKey" => "1662388928"
"RoomType" => "Foyer"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "4'1'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.09Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924553/479-charlton-avenue-e-unit-204-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:5 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
3 => "Unknown"
4 => "Monitored Alarm"
]
+"ZoningDescription": "E/S-1710, P5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 937
+"OriginalEntryTimestamp": "2026-06-18T20:11:28Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1414150"
+"ListOfficeNationalAssociationId": "1326249"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29924553_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/b342a4663e97699f0b3d04da8e1d58a8.webp"
"MediaSize" => 167780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-b342a4663e97699f0b3d04da8e1d58a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29924553_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/1f0e5400b40807dc307613789d158133.webp"
"MediaSize" => 173908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-1f0e5400b40807dc307613789d158133.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29924553_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/a10e6b789d5eac39bdd8b1c2ad7ca351.webp"
"MediaSize" => 95704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-a10e6b789d5eac39bdd8b1c2ad7ca351.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29924553_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/f376e3def6175baf4d3718828564be88.webp"
"MediaSize" => 113740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-f376e3def6175baf4d3718828564be88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29924553_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/90a802a847188121fde90d3dba6f7c69.webp"
"MediaSize" => 82972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-90a802a847188121fde90d3dba6f7c69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29924553_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/ccacdfd926d7b5e893481f68bb4a0b58.webp"
"MediaSize" => 28035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-ccacdfd926d7b5e893481f68bb4a0b58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29924553_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/d773ab37654bf277eed37037285b2e9d.webp"
"MediaSize" => 70287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-d773ab37654bf277eed37037285b2e9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29924553_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/d15c3a4a169659eeaa814815c216edba.webp"
"MediaSize" => 58416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-d15c3a4a169659eeaa814815c216edba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29924553_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/8e2feb9de21eba4fb85df73c404746c9.webp"
"MediaSize" => 68529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-8e2feb9de21eba4fb85df73c404746c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29924553_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/222d8b2c114729f9ea0cf5373f5d4ad1.webp"
"MediaSize" => 128156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-222d8b2c114729f9ea0cf5373f5d4ad1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29924553_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/6fceec80f1b29a680f67edbe1aa053e0.webp"
"MediaSize" => 133350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-6fceec80f1b29a680f67edbe1aa053e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29924553_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/d285ddb934a246299ba79b762d832194.webp"
"MediaSize" => 118086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-d285ddb934a246299ba79b762d832194.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29924553_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/1d0d26d663985871859ee362ecd7afe8.webp"
"MediaSize" => 89641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-1d0d26d663985871859ee362ecd7afe8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29924553_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/d1d056ab751ebd79c9e553e1f0f0ede0.webp"
"MediaSize" => 90841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-d1d056ab751ebd79c9e553e1f0f0ede0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29924553_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/18e75960bfff1b42a9ce594676c32264.webp"
"MediaSize" => 93967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-18e75960bfff1b42a9ce594676c32264.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29924553_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/fc5edb8ba934890696fb3155a23e68e3.webp"
"MediaSize" => 59141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-fc5edb8ba934890696fb3155a23e68e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29924553_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/940ed310119360ad4cb0f4f3892bc593.webp"
"MediaSize" => 29972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-940ed310119360ad4cb0f4f3892bc593.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29924553_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/56c03ac1b5c41522c96353e953e76c14.webp"
"MediaSize" => 39954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-56c03ac1b5c41522c96353e953e76c14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29924553_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/e7f46fdbad95c17ee125a3a988483a9c.webp"
"MediaSize" => 54453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-e7f46fdbad95c17ee125a3a988483a9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29924553_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/8bc02f4ed1a4bcaccd459447664b349e.webp"
"MediaSize" => 36065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-8bc02f4ed1a4bcaccd459447664b349e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29924553_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/b15087d4f6388950f714324b50df1aef.webp"
"MediaSize" => 106802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-b15087d4f6388950f714324b50df1aef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29924553_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/372abeb6262c12254fe1f1efaeee4688.webp"
"MediaSize" => 76907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-372abeb6262c12254fe1f1efaeee4688.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29924553_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/e31c4a3774269144496a1faa280cb098.webp"
"MediaSize" => 88137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-e31c4a3774269144496a1faa280cb098.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29924553_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/ba50c5b85d4395a58cce31829adc9cd6.webp"
"MediaSize" => 109228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-ba50c5b85d4395a58cce31829adc9cd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29924553_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/bbbc43279e1cdfe789b93b54918f3d97.webp"
"MediaSize" => 99927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-bbbc43279e1cdfe789b93b54918f3d97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29924553_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/1e3f88b8985a70e66c18f77c74c1b906.webp"
"MediaSize" => 109648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-1e3f88b8985a70e66c18f77c74c1b906.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29924553_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/615a7e23c4ff2b9354a539aad36ecdf5.webp"
"MediaSize" => 170573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-615a7e23c4ff2b9354a539aad36ecdf5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29924553_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/7cba504645b7c5426fdba2a705324dde.webp"
"MediaSize" => 45251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-7cba504645b7c5426fdba2a705324dde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924553')"
+"ID": "1545515"
}
]
+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=OfficeMlsId eq 283262" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24841
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2073224" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24814
+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 '29924553'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25141
+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 '29924553'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25157
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29924553' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8534172 43.2454945)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25210
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25204
+post_id: "1545466"
+post_author: 1
+"ListingKey": "29924961"
+"ListingId": "X13463908"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:05:06Z"
+"RFModificationTimestamp": "2026-06-18T22:56:34Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stinson)"
+"PostalCode": "L8N0B4"
+"UnparsedAddress": "204 - 479 CHARLTON AVENUE E, Hamilton (Stinson), Ontario L8N0B4"
+"Coordinates": array:2 [
0 => -79.853404
1 => 43.245461
]
+"Latitude": 43.245461
+"Longitude": -79.853404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 204 at Vista Condos - the coveted Poplar floor plan offering 937 sqft and one of the largest balconies in the building. With only two suites of this size per floor, this 2-bedroom, 2-bathroom corner residence offers a rare blend of privacy, sophistication, and elevated urban living. Wrapped in a soothing designer white palette, the suite feels calm, bright, and beautifully composed.The kitchen features extended white cabinetry, quartz countertops, a designer backsplash, and quality flooring that carries throughout the space. The main bath is finished with a glass shower and striking black accent tile, while the spacious primary suite offers a walk-in closet and oversized ensuite for a refined daily retreat. In-suite laundry adds everyday ease. Step outside to an exceptional private balcony framed by treetop, rail trail, and city views - peaceful, green, and quietly removed, yet moments from the energy of the city. Your new home offers thoughtful amenities including a gym, terrace, bike room, party room, visitor parking, a BBQ area, and attentive cleaning staff. A prime underground parking spot beside the elevator and an extra-large locker are both included. Condo fees include heat and water, common elements, and building insurance. Set moments from Corktown, Locke Street dining, St. Joe's Hospital, the GO Station, 403/QEW/LINC access, McMaster, James North, and the Niagara Escarpment trail system, this is a stylish treetop retreat designed for young professionals and first-time buyers ready for a lifestyle upgrade. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"AssociationFee": "806.86"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:56:27.342933+00:00"
+"Directions": "Cross Streets: Charlton Ave E & Wentworth St S. ** Directions: 403 to Main St W, East on Main, Right on Wentworth."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2010060"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Hillside"
1 => "Wooded area"
2 => "Elevator"
3 => "Balcony"
4 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T20:59:22Z"
+"PhotosCount": 31
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:59:22Z"
+"StreetDirSuffix": "East"
+"StreetName": "Charlton"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5434.74"
+"View": "City view"
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1662429097"
"RoomType" => "Foyer"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 1.24
"ListingKey" => "29924961"
"RoomLength" => 2.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.23Z"
]
1 => array:11 [
"RoomKey" => "1662429098"
"RoomType" => "Kitchen"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 2.34
"ListingKey" => "29924961"
"RoomLength" => 2.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.23Z"
]
2 => array:11 [
"RoomKey" => "1662429099"
"RoomType" => "Dining room"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 2.79
"ListingKey" => "29924961"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
3 => array:11 [
"RoomKey" => "1662429100"
"RoomType" => "Living room"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29924961"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
4 => array:11 [
"RoomKey" => "1662429101"
"RoomType" => "Bedroom"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 2.79
"ListingKey" => "29924961"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
5 => array:11 [
"RoomKey" => "1662429102"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "29924961"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
6 => array:11 [
"RoomKey" => "1662429103"
"RoomType" => "Bathroom"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "29924961"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
7 => array:11 [
"RoomKey" => "1662429104"
"RoomType" => "Bathroom"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 2.2
"ListingKey" => "29924961"
"RoomLength" => 1.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
8 => array:11 [
"RoomKey" => "1662429105"
"RoomType" => "Laundry room"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 0.83
"ListingKey" => "29924961"
"RoomLength" => 0.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stinson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29924961/204-479-charlton-avenue-e-hamilton-stinson-stinson"
+"ParkingTotal": 1
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-18T20:59:22.2Z"
+"ListAgentNationalAssociationId": "1291647"
+"ListOfficeNationalAssociationId": "1290805"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29924961_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/f0ce23f1fab658e1cd42e1562248fa22.webp"
"MediaSize" => 182706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-f0ce23f1fab658e1cd42e1562248fa22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29924961_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/e3578e5d95ebe2139f2605d7e68f9cff.webp"
"MediaSize" => 189307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-e3578e5d95ebe2139f2605d7e68f9cff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29924961_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/527b9e5823d36a573a72eb8a51786b92.webp"
"MediaSize" => 214982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-527b9e5823d36a573a72eb8a51786b92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29924961_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/5baad21d1e3999af235eed4464b64e7f.webp"
"MediaSize" => 125424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-5baad21d1e3999af235eed4464b64e7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29924961_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/f92d0f6f6dd1bd86497982744e30c8fd.webp"
"MediaSize" => 95267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-f92d0f6f6dd1bd86497982744e30c8fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29924961_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/2946e2c8bddd7ed517b2f4a98e68cb0d.webp"
"MediaSize" => 64916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-2946e2c8bddd7ed517b2f4a98e68cb0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29924961_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/7aec1b500ba95e79a080fb3e4ec32fd6.webp"
"MediaSize" => 78119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-7aec1b500ba95e79a080fb3e4ec32fd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29924961_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/0d6942437a31833811a8c510af583cab.webp"
"MediaSize" => 78215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-0d6942437a31833811a8c510af583cab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29924961_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/e3af0f10acc7b0ae2e97d3d0c98ca224.webp"
"MediaSize" => 65769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-e3af0f10acc7b0ae2e97d3d0c98ca224.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29924961_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/16aba8bd4f3f7b4c4ea21715e0d215cc.webp"
"MediaSize" => 78504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-16aba8bd4f3f7b4c4ea21715e0d215cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29924961_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/c4261523f27e04c4a4bad091e8f0b73b.webp"
"MediaSize" => 139910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-c4261523f27e04c4a4bad091e8f0b73b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29924961_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/43a537b4ae22b94e3dfe4c337cdbdd56.webp"
"MediaSize" => 146018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-43a537b4ae22b94e3dfe4c337cdbdd56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29924961_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/56bbf41533a04fec8d6dfb3051d73047.webp"
"MediaSize" => 129510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-56bbf41533a04fec8d6dfb3051d73047.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29924961_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/16159454515abe2a8fed60d85eac75ef.webp"
"MediaSize" => 211251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-16159454515abe2a8fed60d85eac75ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29924961_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/aaa8be739fe5622430509d759d233e7c.webp"
"MediaSize" => 99671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-aaa8be739fe5622430509d759d233e7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29924961_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/ba31cb034ad61abe36099a4a79df310e.webp"
"MediaSize" => 100839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-ba31cb034ad61abe36099a4a79df310e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29924961_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/1f11a08d9806d94dd7c7b03dabd93b6e.webp"
"MediaSize" => 104091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-1f11a08d9806d94dd7c7b03dabd93b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29924961_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/78685d0232cecabf527b8770bb557f48.webp"
"MediaSize" => 67155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-78685d0232cecabf527b8770bb557f48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29924961_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/539b349e66ab83e7c8bd698476f2e614.webp"
"MediaSize" => 67526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-539b349e66ab83e7c8bd698476f2e614.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29924961_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/d6b99b328931c4e1840e9825426c62f2.webp"
"MediaSize" => 87354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-d6b99b328931c4e1840e9825426c62f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29924961_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/22620d2846b4276838feac306c9b0c05.webp"
"MediaSize" => 63448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-22620d2846b4276838feac306c9b0c05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29924961_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/549d4cf3b2a2c5855c12f47075f09a7f.webp"
"MediaSize" => 82680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-549d4cf3b2a2c5855c12f47075f09a7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29924961_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/e37bf2db2ac2d77f6fc3ccc5fbf13b61.webp"
"MediaSize" => 100997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-e37bf2db2ac2d77f6fc3ccc5fbf13b61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29924961_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/14c3cdd58a1a7b77d9e36bcafdc38765.webp"
"MediaSize" => 117109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-14c3cdd58a1a7b77d9e36bcafdc38765.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29924961_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/7be718e8775c392c8610b89c2e34da53.webp"
"MediaSize" => 85667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-7be718e8775c392c8610b89c2e34da53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29924961_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/b1d3512a02eaee41a975e296905df13b.webp"
"MediaSize" => 97293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-b1d3512a02eaee41a975e296905df13b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29924961_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/7ce48d986ed51ffd2880906b8ddf32e1.webp"
"MediaSize" => 120996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-7ce48d986ed51ffd2880906b8ddf32e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29924961_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/9b4287428e8105085e91e8f8f01140a5.webp"
"MediaSize" => 114969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-9b4287428e8105085e91e8f8f01140a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29924961_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/a85f20fea67e04ae4d7f3da1e66739ba.webp"
"MediaSize" => 123592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-a85f20fea67e04ae4d7f3da1e66739ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29924961_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/fc24944be32cbe20692b23b38b408a6b.webp"
"MediaSize" => 184263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-fc24944be32cbe20692b23b38b408a6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29924961_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/8c6c1a0ac79fe97fd303e27f9eecc16c.webp"
"MediaSize" => 59218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-8c6c1a0ac79fe97fd303e27f9eecc16c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924961')"
+"ID": "1545466"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "1544290"
+post_author: 1
+"ListingKey": "29923615"
+"ListingId": "X13462614"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:40:20Z"
+"RFModificationTimestamp": "2026-06-18T19:31:40Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8L6M4"
+"UnparsedAddress": "86 SHERMAN AVENUE N, Hamilton (Gibson), Ontario L8L6M4"
+"Coordinates": array:2 [
0 => -79.836845
1 => 43.254071
]
+"Latitude": 43.254071
+"Longitude": -79.836845
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into a piece of Hamilton history at 86 Sherman Avenue North. This grand Victorian residence showcases the kind of craftsmanship, character, and architectural detail that simply cannot be replicated today. From its impressive proportions to its timeless charm, this is a home that tells a story. Featuring 6 spacious bedrooms and 2 large bathrooms, the property provides exceptional flexibility for large families, multigenerational living, or those seeking a restoration project with tremendous upside. Original features such as 10 ft ceilings, 12" baseboards & refinished pine floors create a rare foundation for someone with a vision to bring this remarkable home back to its full potential. Convenient rear laneway access provides valuable private parking, while the central location places you just minutes from downtown Hamilton, the vibrant shops and restaurants of Ottawa Street and James Street North, Gage Park, schools, public transit, and easy highway access for commuters. Whether you're an investor, renovator, or buyer searching for a truly unique property, opportunities like this are becoming increasingly rare. Restore, reimagine, and revive one of Hamilton's classic Victorian homes. (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:31:30.958383+00:00"
+"Directions": "Cross Streets: Cannon St. E. ** Directions: West on Cannon St. E., North on Sherman Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036043"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Lane"
1 => "Carpet Free"
]
+"LotSizeDimensions": "32 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T18:33:09Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T18:33:09Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Sherman"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4659"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LwvocnAkqtj"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1662307993"
"RoomType" => "Bathroom"
"ListingId" => "X13462614"
"RoomLevel" => "Second level"
"RoomWidth" => 4.42
"ListingKey" => "29923615"
"RoomLength" => 2.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T18:33:09.78Z"
]
1 => array:11 [
"RoomKey" => "1662307994"
"RoomType" => "Bedroom"
"ListingId" => "X13462614"
"RoomLevel" => "Third level"
"RoomWidth" => 4.32
"ListingKey" => "29923615"
"RoomLength" => 4.06
…4
]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29923615/86-sherman-avenue-n-hamilton-gibson-gibson"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 6
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2026-06-18T18:33:09.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1312659"
+"ListOfficeNationalAssociationId": "1398828"
+"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('29923615')"
+"ID": "1544290"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+post_id: "1544139"
+post_author: 1
+"ListingKey": "29923609"
+"ListingId": "40841202"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:40:19Z"
+"RFModificationTimestamp": "2026-06-18T19:31:16Z"
+"ListPrice": 769777.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9A4A1"
+"UnparsedAddress": "374 EAST 13TH Street, Hamilton, Ontario L9A4A1"
+"Coordinates": array:2 [
0 => -79.8663629
1 => 43.2324648
]
+"Latitude": 43.2324648
+"Longitude": -79.8663629
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Stunning legal duplex in a prime Hamilton Mountain location! This home has been fully renovated top to bottom with incredible craftsmanship and high-end finishes throughout. Features 3+2 bedrooms, 2 beautiful full baths, and 2 stylish kitchens — perfect for families or investors alike. Everything is brand new, including electrical, plumbing, stainless steel appliances, and a new extended driveway with ample parking. Setup includes two separate hydro meters and electrical panels, providing full separation and convenience for both units. Exceptional income potential or ideal multi-generational living opportunity. Situated on an large lot in a beautiful family-friendly neighbourhood. Located close to highways, great schools, parks, shopping, and the hospital — this one truly has it all! (id:62650)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "High Traffic Area"
1 => "School Bus"
2 => "Community Centre"
]
+"ConstructionMaterials": array:2 [
0 => "Concrete block"
1 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:31:13.467402+00:00"
+"Directions": "Upper Wellington & Mohawk"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2026178"
+"ListOfficeKey": "54949"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"PhotosChangeTimestamp": "2026-06-18T18:32:41Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T18:32:41Z"
+"Stories": "1.0"
+"StreetName": "EAST 13TH"
+"StreetNumber": "374"
+"StreetSuffix": "Street"
+"SubdivisionName": "176 - Hill Park"
+"TaxAnnualAmount": "4113.6"
+"VirtualTourURLUnbranded": "https://vimeo.com/1192385697?share=copy&fl=sv&fe=ci"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29923609/374-east-13th-street-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-06-18T18:32:41.69Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1305706"
+"ListOfficeNationalAssociationId": "1003557"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923609')"
+"ID": "1544139"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: "1543934"
+post_author: 1
+"ListingKey": "29923022"
+"ListingId": "40840784"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:00:12Z"
+"RFModificationTimestamp": "2026-06-18T19:07:59Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2657.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L6M4"
+"UnparsedAddress": "86 SHERMAN Avenue N, Hamilton, Ontario L8L6M4"
+"Coordinates": array:2 [
0 => -79.8370126
1 => 43.2541
]
+"Latitude": 43.2541
+"Longitude": -79.8370126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into a piece of Hamilton history at 86 Sherman Avenue North. This grand Victorian residence showcases the kind of craftsmanship, character, and architectural detail that simply cannot be replicated today. From its impressive proportions to its timeless charm, this is a home that tells a story. Featuring 6 spacious bedrooms and 2 large bathrooms, the property provides exceptional flexibility for large families, multigenerational living, or those seeking a restoration project with tremendous upside. Original features such as 10 ft ceilings, 12 baseboards & refinished pine floors create a rare foundation for someone with a vision to bring this remarkable home back to its full potential. Convenient rear laneway access provides valuable private parking, while the central location places you just minutes from downtown Hamilton, the vibrant shops and restaurants of Ottawa Street and James Street North, Gage Park, schools, public transit, and easy highway access for commuters. Whether you're an investor, renovator, or buyer searching for a truly unique property, opportunities like this are becoming increasingly rare. Restore, reimagine, and revive one of Hamilton's classic Victorian homes. (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:07:21.652135+00:00"
+"Directions": "West on Cannon St. E., North on Sherman Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562180"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-18T17:32:47Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:50:33Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "SHERMAN"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "4659"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LwvocnAkqtj"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29923022/86-sherman-avenue-n-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 2657
+"OriginalEntryTimestamp": "2026-06-18T17:32:47.28Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1148101"
+"ListOfficeNationalAssociationId": "1398404"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923022')"
+"ID": "1543934"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25205
+post_id: "1543076"
+post_author: 1
+"ListingKey": "29921729"
+"ListingId": "40839562"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:40:11Z"
+"RFModificationTimestamp": "2026-06-18T19:51:58Z"
+"ListPrice": 810000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1770.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2N4"
+"UnparsedAddress": "33 SAINT CLAIR Avenue, Hamilton, Ontario L8M2N4"
+"Coordinates": array:2 [
0 => -79.8396012
1 => 43.2502561
]
+"Latitude": 43.2502561
+"Longitude": -79.8396012
+"YearBuilt": 1910
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located on a famously family-friendly street lined with mature trees, this 2 1/2 storey, 1770 sq ft, three bedroom + den family home is perfectly situated away from busy streets. Exuding timeless character, the original millwork, trim, doors and floors throughout the foyer, living room and dining room create a warm and welcoming atmosphere. The cozy living room with fireplace and bay window can be separated from the dining room with the classic sliding pocket doors that this era of homes is know for. Morning coffee, summer evenings and simply unwinding can be enjoyed on the large, covered front porch. Upstairs, three bedrooms, a full bathroom and den (that can be a small bedroom or office), offer plenty of space for any growing family or guests. Walkout from the den to a beautiful rooftop deck adds even more outdoor living space. The top storey is over 400 sq ft, finished, easily accessible by stairs and contains an amazing child-friendly “secret” treehouse style playroom. The loft could also serve as an additional bedroom, the choice is yours. The spacious kitchen comes with a convenient walkout to a very private and comfortable backyard. Front yard parking means never looking for a spot and comes with a NEMA 14-50 EV car charger. Full Basement with multiple storage rooms, cold room, and 3-Pc bathroom. Forced air furnace and central air means no radiators to bleed. Waterline replaced in 2025. Electrical and plumbing upgraded in 2015-2016. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:46:40.695416+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235618"
+"ListOfficeKey": "106156"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-18T15:32:20Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:31:32Z"
+"Stories": "2.5"
+"StreetName": "SAINT CLAIR"
+"StreetNumber": "33"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "4562.7"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/33-St-Clair-Ave"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921729/33-saint-clair-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1770
+"OriginalEntryTimestamp": "2026-06-18T15:32:20.02Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1473446"
+"ListOfficeNationalAssociationId": "1223962"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921729')"
+"ID": "1543076"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25200
+post_id: "1542891"
+post_author: 1
+"ListingKey": "29922111"
+"ListingId": "X13461424"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:05:05Z"
+"RFModificationTimestamp": "2026-06-18T21:10:54Z"
+"ListPrice": 810000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8M2N4"
+"UnparsedAddress": "33 SAINT CLAIR AVENUE, Hamilton (Gibson), Ontario L8M2N4"
+"Coordinates": array:2 [
0 => -79.8396496
1 => 43.250259
]
+"Latitude": 43.250259
+"Longitude": -79.8396496
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located on a famously family-friendly street lined with mature trees, this 2 1/2 storey, 1770 sq ft, three bedroom + den family home is perfectly situated away from busy streets. Exuding timeless character, the original millwork, trim, doors and floors throughout the foyer, living room and dining room create a warm and welcoming atmosphere. The cozy living room with fireplace and bay window can be separated from the dining room with the classic sliding pocket doors that this era of homes is know for. Morning coffee, summer evenings and simply unwinding can be enjoyed on the large, covered front porch. Upstairs, three bedrooms, a full bathroom and den (that can be a small bedroom or office), offer plenty of space for any growing family or guests. Walkout from the den to a beautiful rooftop deck adds even more outdoor living space. The top storey is over 400 sq ft, finished, easily accessible by stairs and contains an amazing child-friendly "secret" treehouse style playroom. The loft could also serve as an additional bedroom, the choice is yours. The spacious kitchen comes with a convenient walkout to a very private and comfortable backyard. Front yard parking means never looking for a spot and comes with a NEMA 14-50 EV car charger. Full Basement with multiple storage rooms, cold room, and 3-Pc bathroom. Forced air furnace and central air means no radiators to bleed. Waterline replaced in 2025. Electrical and plumbing upgraded in 2015-2016. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:42:11.953852+00:00"
+"Directions": "King St E & Sherman Ave S"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1980677"
+"ListOfficeKey": "290193"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "29 x 88.7 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T16:05:42Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:59:17Z"
+"Stories": "2.5"
+"StreetName": "Saint Clair"
+"StreetNumber": "33"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4562.7"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/33-St-Clair-Ave"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29922111/33-saint-clair-avenue-hamilton-gibson-gibson"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 29.0
+"OriginalEntryTimestamp": "2026-06-18T16:05:42.46Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1266299"
+"ListOfficeNationalAssociationId": "1384630"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922111')"
+"ID": "1542891"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1542161"
+post_author: 1
+"ListingKey": "29920011"
+"ListingId": "40840564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T02:35:16Z"
+"RFModificationTimestamp": "2026-06-18T05:47:40Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0.1
+"LivingArea": 842.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9A3T7"
+"UnparsedAddress": "280 EAST 11TH Street, Hamilton, Ontario L9A3T7"
+"Coordinates": array:2 [
0 => -79.8671573
1 => 43.2356859
]
+"Latitude": 43.2356859
+"Longitude": -79.8671573
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated, freshly painted, brick bungalow on a quiet cul-de-sac in Hamilton Mountain's desirable neighbourhood. Perfect for first-time buyers, this move-in ready home offers 2 bedrooms, 2 full bathrooms. The main floor showcases hardwood floors, cove mouldings, a bay window, and a cozy fireplace. Enjoy the BRAND-NEW KITCHEN with QUARTZ countertops and a FULLY RENOVATED MODERN 3-PIECE BATHROOM (BOTH 2025). The FINISHED BASEMENT adds valuable living space with a spacious rec room, large den, 3-piece bathroom, laundry area, and plenty of storage. Step outside to a private, fully fenced large backyard with a two-tier deck—ideal for relaxing or entertaining. Conveniently located close to parks, schools, shopping, restaurants, and major highways. Recent updates include: kitchen, main bath, fridge & dishwasher (2025), Google Nest thermostat (2025), dryer (2025), owned water heater (2024), eavestroughs (2024), shed shingles (2023), a NEMA 14-50 EV charging outlet (2023) and stove (~2023). (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T05:47:37.368783+00:00"
+"Directions": "Upper Wellington St to Brucedale Avenue E to East 11th street"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:3 [
0 => "Insert"
1 => "Electric"
2 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1602852"
+"ListOfficeKey": "289618"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "0.1"
+"PhotosChangeTimestamp": "2026-06-18T02:20:27Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T02:20:26Z"
+"Stories": "1.0"
+"StreetName": "EAST 11TH"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"SubdivisionName": "172 - Inch Park"
+"TaxAnnualAmount": "4341.69"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29920011/280-east-11th-street-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 842
+"OriginalEntryTimestamp": "2026-06-18T02:20:25.66Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1159135"
+"ListOfficeNationalAssociationId": "1379562"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920011')"
+"ID": "1542161"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1542014"
+post_author: 1
+"ListingKey": "29920004"
+"ListingId": "X13459436"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T03:25:10Z"
+"RFModificationTimestamp": "2026-06-18T03:26:00Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Inch Park)"
+"PostalCode": "L9A3T7"
+"UnparsedAddress": "280 EAST 11TH STREET, Hamilton (Inch Park), Ontario L9A3T7"
+"Coordinates": array:2 [
0 => -79.86719
1 => 43.235663
]
+"Latitude": 43.235663
+"Longitude": -79.86719
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this beautifully updated, freshly painted, brick bungalow on a quiet cul-de-sac in Hamilton Mountain's desirable neighbourhood. Perfect for first-time buyers, this move-in ready home offers 2 bedrooms, 2 full bathrooms. The main floor showcases hardwood floors, cove mouldings, a bay window, and a cozy fireplace. Enjoy the BRAND-NEW KITCHEN with QUARTZ countertops and a FULLY RENOVATED MODERN 3-PIECE BATHROOM (BOTH 2025). The FINISHED BASEMENT adds valuable living space with a spacious rec room, large den, 3-piece bathroom, laundry area, and plenty of storage. Step outside to a private, fully fenced large backyard with a two-tier deck-ideal for relaxing or entertaining. Conveniently located close to parks, schools, shopping, restaurants, and major highways. Recent updates include: kitchen, main bath, fridge & dishwasher (2025), Google Nest thermostat (2025), dryer (2025), owned water heater (2024), eavestroughs (2024), shed shingles (2023), a NEMA 14-50 EV charging outlet (2023) and stove (~2023). (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T03:25:52.905017+00:00"
+"Directions": "Cross Streets: Upper Wellington St. & Brucedale Ave E. ** Directions: Upper Wellington St. to Brucedale Avenue E. to East 11th Street."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1958188"
+"ListOfficeKey": "289645"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "42.5 x 102 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T02:13:54Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T03:17:29Z"
+"Stories": "1.0"
+"StreetName": "East 11th"
+"StreetNumber": "280"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4341.69"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Inch Park"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29920004/280-east-11th-street-hamilton-inch-park-inch-park"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.6
+"OriginalEntryTimestamp": "2026-06-18T02:13:54.29Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1249125"
+"ListOfficeNationalAssociationId": "1379865"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920004')"
+"ID": "1542014"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: "1541658"
+post_author: 1
+"ListingKey": "29919492"
+"ListingId": "X13458962"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T00:55:07Z"
+"RFModificationTimestamp": "2026-06-18T00:58:30Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Macassa)"
+"PostalCode": "L8V3M4"
+"UnparsedAddress": "627 UPPER SHERMAN AVENUE, Hamilton (Macassa), Ontario L8V3M4"
+"Coordinates": array:2 [
0 => -79.848469
1 => 43.228597
]
+"Latitude": 43.228597
+"Longitude": -79.848469
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this extensively renovated and move-in-ready home located in a desirable Hamilton Mountain neighbourhood. Offering 3+2 bedrooms, 2 full bathrooms, 2 kitchens, a separate entrance to the finished lower level, excellent parking, and a highly functional backyard setup, this property is ideal for families, multi-generational living, and investors alike. The bright main level features 3 spacious bedrooms, a stylish renovated bathroom with modern tub, upgraded fixtures and faucets, an updated kitchen with modern cabinetry, countertops and backsplash, and an inviting living area highlighted by a modern fireplace and pot lights throughout. The fully finished lower level offers excellent flexibility with 2 additional bedrooms, a separate entrance, kitchen, and renovated bathroom with modern shower and upgraded fixtures, making it perfect for extended family, guests, or additional living space. Recent upgrades include new flooring throughout, fresh paint, new doors and modern hardware, updated windows, renovated kitchens and bathrooms, new pot lights, updated electrical wiring and outlets where required, ESA-certified electrical work with certificate available, and modern finishes throughout. The property offers parking for up to 5 vehicles, including a large driveway and secure gated rear parking area. The spacious backyard offers incredible versatility with a detached serviced garage/workshop equipped with electrical service, water supply, drainage, heating and HVAC connections, plus an additional shed with electrical service, a second storage shed, landscape lighting with timers throughout the front and rear yards, and a sprinkler system ready for connection. Conveniently located close to schools, parks, shopping, transit, amenities, and major highway access, this extensively upgraded Hamilton Mountain home offers a rare combination of modern living, flexible space, exceptional parking, functional outdoor features, and future potential. Move in and enjoy! (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Full"
1 => "Separate entrance"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T00:30:41.699980+00:00"
+"Directions": "Cross Streets: Fennell Ave E/Upper Sherman Ave. ** Directions: Fennell to Upper Sherman."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993784"
+"ListOfficeKey": "294997"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "46 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T23:18:37Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T00:47:00Z"
+"Stories": "1.0"
+"StreetName": "Upper Sherman"
+"StreetNumber": "627"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3982"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Macassa"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29919492/627-upper-sherman-avenue-hamilton-macassa-macassa"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 46.0
+"OriginalEntryTimestamp": "2026-06-17T23:18:37.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276930"
+"ListOfficeNationalAssociationId": "1451359"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919492')"
+"ID": "1541658"
}
]
+success: true
+page_size: 9
+page_count: 56
+count: 500
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]