array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29898739 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23380
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23382
+post_id: "1526064"
+post_author: 1
+"ListingKey": "29898739"
+"ListingId": "X13440156"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:30:10Z"
+"RFModificationTimestamp": "2026-06-13T00:50:49Z"
+"ListPrice": 579900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Raleigh)"
+"PostalCode": "L8V4H3"
+"UnparsedAddress": "128 EAST 39TH STREET, Hamilton (Raleigh), Ontario L8V4H3"
+"Coordinates": array:2 [
0 => -79.838229
1 => 43.233018
]
+"Latitude": 43.233018
+"Longitude": -79.838229
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautifully updated and newly painted 1 1/2 storey home in a family-friendly East Mountain neighbourhood. This spacious property offers great curb appeal with a new driveway, new windows, new fence, new 3pc batheroom and a large private yard perfect for families, entertaining, or future potential. Inside features 3 bedrooms, a 4-piece bathroom, large living room, eat-in kitchen, and a finished recreation room for added living space. Conveniently located close to schools, parks, shopping, amenities, the escarpment, and vibrant Concession Street. A fantastic opportunity in a great location! *Note- some pictures are virtually staged** (id:62783)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:48:32.433045+00:00"
+"Directions": "Cross Streets: Queensdale Ave E. ** Directions: East."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2170779"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "45 x 82 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T22:24:34Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T22:24:34Z"
+"Stories": "1.5"
+"StreetName": "East 39th"
+"StreetNumber": "128"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3861.94"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1658048318"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13440156"
"RoomLevel" => "Basement"
"RoomWidth" => 1.09
"ListingKey" => "29898739"
"RoomLength" => 6.85
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:24:34.44Z"
]
1 => array:11 [
"RoomKey" => "1658048319"
"RoomType" => "Laundry room"
"ListingId" => "X13440156"
"RoomLevel" => "Basement"
"RoomWidth" => 5.0
"ListingKey" => "29898739"
"RoomLength" => 4.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:24:34.44Z"
]
2 => array:11 [
"RoomKey" => "1658048320"
"RoomType" => "Utility room"
"ListingId" => "X13440156"
"RoomLevel" => "Basement"
"RoomWidth" => 0.0
"ListingKey" => "29898739"
"RoomLength" => 5.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:24:34.45Z"
]
3 => array:11 [
"RoomKey" => "1658048321"
"RoomType" => "Kitchen"
"ListingId" => "X13440156"
"RoomLevel" => "Main level"
"RoomWidth" => 2.31
"ListingKey" => "29898739"
"RoomLength" => 4.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:24:34.45Z"
]
4 => array:11 [
"RoomKey" => "1658048322"
"RoomType" => "Living room"
"ListingId" => "X13440156"
"RoomLevel" => "Main level"
"RoomWidth" => 3.16
"ListingKey" => "29898739"
"RoomLength" => 4.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:24:34.45Z"
]
5 => array:11 [
"RoomKey" => "1658048323"
"RoomType" => "Bedroom"
"ListingId" => "X13440156"
"RoomLevel" => "Main level"
"RoomWidth" => 2.68
"ListingKey" => "29898739"
"RoomLength" => 3.62
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:24:34.45Z"
]
6 => array:11 [
"RoomKey" => "1658048324"
"RoomType" => "Bathroom"
"ListingId" => "X13440156"
"RoomLevel" => "Main level"
"RoomWidth" => 6.0
"ListingKey" => "29898739"
"RoomLength" => 4.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:24:34.45Z"
]
7 => array:11 [
"RoomKey" => "1658048325"
"RoomType" => "Bedroom"
"ListingId" => "X13440156"
"RoomLevel" => "Second level"
"RoomWidth" => 3.5
"ListingKey" => "29898739"
"RoomLength" => 4.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:24:34.45Z"
]
8 => array:11 [
"RoomKey" => "1658048326"
"RoomType" => "Bedroom"
"ListingId" => "X13440156"
"RoomLevel" => "Second level"
"RoomWidth" => 2.68
"ListingKey" => "29898739"
"RoomLength" => 4.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-12T22:24:34.45Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Raleigh"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29898739/128-east-39th-street-hamilton-raleigh-raleigh"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-12T22:24:34.42Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1421398"
+"ListOfficeNationalAssociationId": "1344854"
+"Media": array:22 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29898739_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/c72ee71b89ccfbdff5e4450fd8073f81.webp"
"MediaSize" => 195361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-c72ee71b89ccfbdff5e4450fd8073f81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29898739_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/9285ae95efe978ccd9db06004c569755.webp"
"MediaSize" => 197595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-9285ae95efe978ccd9db06004c569755.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29898739_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/808d1fa7e71e303a63138657b36a50bb.webp"
"MediaSize" => 157761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-808d1fa7e71e303a63138657b36a50bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29898739_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/13931a62185067aa1452fa763f717bfc.webp"
"MediaSize" => 134131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-13931a62185067aa1452fa763f717bfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29898739_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/f19be763cccd0e75f2f52c8cce980c54.webp"
"MediaSize" => 172909
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-f19be763cccd0e75f2f52c8cce980c54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29898739_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/2e8157e0a6a29b0dbf6633293f0033d2.webp"
"MediaSize" => 95271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-2e8157e0a6a29b0dbf6633293f0033d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29898739_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/97b77c07357f23e6a1d4fcc6751c059f.webp"
"MediaSize" => 108042
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-97b77c07357f23e6a1d4fcc6751c059f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29898739_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/3b64885f8cccd2f73582df83bac0f238.webp"
"MediaSize" => 81413
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-3b64885f8cccd2f73582df83bac0f238.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29898739_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/6236ede1da682952f99aa6827f2c4883.webp"
"MediaSize" => 145772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-6236ede1da682952f99aa6827f2c4883.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29898739_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/f937579afe8541235f10bfd4191e11ec.webp"
"MediaSize" => 166079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-f937579afe8541235f10bfd4191e11ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29898739_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/509e39c74b8b7539fab88282b0375bea.webp"
"MediaSize" => 161793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-509e39c74b8b7539fab88282b0375bea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29898739_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/3489c9d4fd3ade0c826fd5a0efe0777b.webp"
"MediaSize" => 188186
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-3489c9d4fd3ade0c826fd5a0efe0777b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29898739_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/52092d214ebcc7b76c2c70e6b1413cfb.webp"
"MediaSize" => 177146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-52092d214ebcc7b76c2c70e6b1413cfb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29898739_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/2912c5cc0e967793d62feba28ffa9b2a.webp"
"MediaSize" => 152927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-2912c5cc0e967793d62feba28ffa9b2a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29898739_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/250ccf03cad494fbb24598be0931bb70.webp"
"MediaSize" => 105816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-250ccf03cad494fbb24598be0931bb70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29898739_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/9bb5e3624e4ef36218ddfa2019bd4c8a.webp"
"MediaSize" => 126444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-9bb5e3624e4ef36218ddfa2019bd4c8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29898739_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/9596e55d81dbcbf2bd43c4d783124c0d.webp"
"MediaSize" => 142537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-9596e55d81dbcbf2bd43c4d783124c0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29898739_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/76cdc4350fd9dbed91063e53efa59222.webp"
"MediaSize" => 136137
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-76cdc4350fd9dbed91063e53efa59222.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29898739_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/205e7a159f24cf6630151a3605f4f9cf.webp"
"MediaSize" => 203471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-205e7a159f24cf6630151a3605f4f9cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29898739_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/143ea1bdad8bc905a85fb8a12c289247.webp"
"MediaSize" => 221070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-143ea1bdad8bc905a85fb8a12c289247.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29898739_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/a173ed215de50d663ef397e6cdf929c9.webp"
"MediaSize" => 272303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-a173ed215de50d663ef397e6cdf929c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29898739_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898739/b54c3301543c23a7465a63c14375cbcc.webp"
"MediaSize" => 270517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898739/thumbnail-b54c3301543c23a7465a63c14375cbcc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13440156"
"ResourceRecordKey" => "29898739"
"ModificationTimestamp" => "2026-06-12T22:24:34.43Z"
]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898739')"
+"ID": "1526064"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284787" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24762
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2170779" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24756
+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 '29898739'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25143
+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 '29898739'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25159
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29898739' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.838229 43.233018)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25212
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "1547780"
+post_author: 1
+"ListingKey": "29928374"
+"ListingId": "40841344"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:20:07Z"
+"RFModificationTimestamp": "2026-06-19T17:02:59Z"
+"ListPrice": 539000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1625.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L7E1"
+"UnparsedAddress": "21 EAST BEND Avenue, Hamilton, Ontario L8L7E1"
+"Coordinates": array:2 [
0 => -79.8268695
1 => 43.247562
]
+"Latitude": 43.247562
+"Longitude": -79.8268695
+"YearBuilt": 1920
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 21 East Bend Avenue N, a beautifully refreshed detached home in Hamilton’s sought-after Crown Point neighbourhood. Offering over 1600 sq. ft. of finished living space across 2.5 storeys, this move-in-ready property combines character, flexibility, and thoughtful updates throughout. The bright and inviting interior features a versatile main-floor bedroom, spacious living and dining areas, fresh paint throughout and new interior finishes. The eat-in kitchen offers abundant cabinetry, generous counter space, stainless steel appliances, and custom banquette seating. A bright main floor office overlooks the private backyard with mature trees. Upstairs, you’ll find two spacious bedrooms, convenient second-floor laundry, and a well-appointed 4-piece bathroom. The finished third floor loft/bonus room adds valuable living space, for a studio, playroom, office, fitness area, or guest retreat. Major improvements completed in 2026 include replacement of the lead water service line, new appliances, electrical upgrades, HVAC improvements, interior updates throughout the home, and a new front walkway. Outside, enjoy a fully fenced backyard with a deck, garden space, storage shed, and driveway parking. Ideally located just steps from Ottawa Street’s shops and restaurants, Gage Park, schools, and transit. This home offers an exceptional opportunity for first-time buyers, growing families, professionals, or investors. Come and take a look today! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T17:02:55.046577+00:00"
+"Directions": "From King Street East, North onto East Bend North"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006979"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-19T15:52:48Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:52:48Z"
+"Stories": "2.5"
+"StreetName": "EAST BEND"
+"StreetNumber": "21"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "201 - Crown Point"
+"TaxAnnualAmount": "3461.49"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1663032775"
"RoomType" => "Recreation room"
"ListingId" => "40841344"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 28'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.38Z"
]
1 => array:11 [
"RoomKey" => "1663032776"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841344"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.38Z"
]
2 => array:11 [
"RoomKey" => "1663032777"
"RoomType" => "Bedroom"
"ListingId" => "40841344"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.39Z"
]
3 => array:11 [
"RoomKey" => "1663032779"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841344"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.39Z"
]
4 => array:11 [
"RoomKey" => "1663032780"
"RoomType" => "Laundry room"
"ListingId" => "40841344"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 6'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.39Z"
]
5 => array:11 [
"RoomKey" => "1663032781"
"RoomType" => "2pc Bathroom"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "4'0'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.39Z"
]
6 => array:11 [
"RoomKey" => "1663032783"
"RoomType" => "Office"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "6'5'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.4Z"
]
7 => array:11 [
"RoomKey" => "1663032786"
"RoomType" => "Dining room"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 12'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.4Z"
]
8 => array:11 [
"RoomKey" => "1663032788"
"RoomType" => "Kitchen"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "7'9'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.41Z"
]
9 => array:11 [
"RoomKey" => "1663032790"
"RoomType" => "Living room"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.41Z"
]
10 => array:11 [
"RoomKey" => "1663032792"
"RoomType" => "Bedroom"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.42Z"
]
11 => array:11 [
"RoomKey" => "1663032793"
"RoomType" => "Foyer"
"ListingId" => "40841344"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29928374"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:50:30.43Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29928374/21-east-bend-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1625
+"OriginalEntryTimestamp": "2026-06-19T15:50:30.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1289115"
+"ListOfficeNationalAssociationId": "1344653"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29928374_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/18837bc02e0b1713d9730071a5a4785c.webp"
"MediaSize" => 159369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-18837bc02e0b1713d9730071a5a4785c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29928374_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/144d60a76a2ad0865454dda59e524755.webp"
"MediaSize" => 196664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-144d60a76a2ad0865454dda59e524755.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29928374_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/10f7a251a8c7b6b6b264ad10354045cc.webp"
"MediaSize" => 172058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-10f7a251a8c7b6b6b264ad10354045cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.48Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29928374_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/3c18001db673812ab87b92fd9ea38e30.webp"
"MediaSize" => 159451
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-3c18001db673812ab87b92fd9ea38e30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29928374_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/2a6cda344325f81abe3cd502f9968ae2.webp"
"MediaSize" => 146727
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-2a6cda344325f81abe3cd502f9968ae2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.11Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29928374_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/c4ad229a5271051028f6264bd14dba58.webp"
"MediaSize" => 51737
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-c4ad229a5271051028f6264bd14dba58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.43Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29928374_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/d209adf5bea82b099b882b4c8f7f5a2c.webp"
"MediaSize" => 51881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-d209adf5bea82b099b882b4c8f7f5a2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.97Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29928374_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/5e2a078889979f2ba2158e05abf165ba.webp"
"MediaSize" => 78620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-5e2a078889979f2ba2158e05abf165ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29928374_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/4512830cfc3a7d64b3de419c6d4d5ea6.webp"
"MediaSize" => 50975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-4512830cfc3a7d64b3de419c6d4d5ea6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.92Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29928374_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/de55cd21dd50a4048a3f9c8835ea2722.webp"
"MediaSize" => 40056
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-de55cd21dd50a4048a3f9c8835ea2722.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.49Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29928374_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/eac42b2e9f98c6a541272b96c9b7c8c8.webp"
"MediaSize" => 88824
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-eac42b2e9f98c6a541272b96c9b7c8c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.92Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29928374_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/14b1f7ee994da041e5fe2928a17bfbca.webp"
"MediaSize" => 57870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-14b1f7ee994da041e5fe2928a17bfbca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.45Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29928374_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/a2a6be3089e3db63372fd83b4320beaa.webp"
"MediaSize" => 49350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-a2a6be3089e3db63372fd83b4320beaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29928374_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/dd19d7be6093616becfee48600116fe4.webp"
"MediaSize" => 57433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-dd19d7be6093616becfee48600116fe4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.46Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29928374_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/77193b6047b347cb62764c9157c1ea2d.webp"
"MediaSize" => 61795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-77193b6047b347cb62764c9157c1ea2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29928374_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/590494d60c749ec52b66f0e4c88d8237.webp"
"MediaSize" => 64225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-590494d60c749ec52b66f0e4c88d8237.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29928374_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/e4de171717dfb7a62928609aa533d92a.webp"
"MediaSize" => 75500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-e4de171717dfb7a62928609aa533d92a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.49Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29928374_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/0d26a73c5855151becec8eb48f741294.webp"
"MediaSize" => 64975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-0d26a73c5855151becec8eb48f741294.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.44Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29928374_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/5ae5b25f304bab38eeaa86c8a44f08d5.webp"
"MediaSize" => 69808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-5ae5b25f304bab38eeaa86c8a44f08d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.99Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29928374_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/ef3daafce1907b3b640ef5f557f415bc.webp"
"MediaSize" => 56641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-ef3daafce1907b3b640ef5f557f415bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29928374_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/6b897914aca412086941e7190059f860.webp"
"MediaSize" => 59269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-6b897914aca412086941e7190059f860.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.97Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29928374_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/5faa32d205ae4dee869b55d339c6b187.webp"
"MediaSize" => 64151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-5faa32d205ae4dee869b55d339c6b187.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.26Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29928374_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/96791f57561261f399d8b8381b8928b3.webp"
"MediaSize" => 121765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-96791f57561261f399d8b8381b8928b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29928374_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/bcd858390b6c3db44c9b37b09e66c053.webp"
"MediaSize" => 81635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-bcd858390b6c3db44c9b37b09e66c053.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.97Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29928374_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/d97c81d3736a7b10b964590a6256333c.webp"
"MediaSize" => 32719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-d97c81d3736a7b10b964590a6256333c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:43.14Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29928374_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/f9e1177e413ecc748f1cf76debc33ec9.webp"
"MediaSize" => 44800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-f9e1177e413ecc748f1cf76debc33ec9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:43.14Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29928374_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/0e5edff2be4b4b57d9e60a167884aceb.webp"
"MediaSize" => 73871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-0e5edff2be4b4b57d9e60a167884aceb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:43.14Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29928374_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/e96c8af846a789cd7f4b97827657d0b0.webp"
"MediaSize" => 63849
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-e96c8af846a789cd7f4b97827657d0b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29928374_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/a38a1614144b5f8a8c48f1a2690f83c8.webp"
"MediaSize" => 71515
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-a38a1614144b5f8a8c48f1a2690f83c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.44Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29928374_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/77ddf90fb40735788214a7748f9d80ce.webp"
"MediaSize" => 54425
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-77ddf90fb40735788214a7748f9d80ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.97Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29928374_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/c214915d93def2044fbfde7715522f06.webp"
"MediaSize" => 50273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-c214915d93def2044fbfde7715522f06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.26Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29928374_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/e5efb4857bffd7130ee1f2b01534b2e5.webp"
"MediaSize" => 52000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-e5efb4857bffd7130ee1f2b01534b2e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:39.96Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29928374_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/8288e1de7cc25c762d4ab5a18fea46c6.webp"
"MediaSize" => 84889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-8288e1de7cc25c762d4ab5a18fea46c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841344"
"ResourceRecordKey" => "29928374"
"ModificationTimestamp" => "2026-06-19T15:52:40.44Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29928374_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29928374/997f0104e7584d8712d70fa4b6ffb45e.webp"
"MediaSize" => 69364
…9
]
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('29928374')"
+"ID": "1547780"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1547607"
+post_author: 1
+"ListingKey": "29927864"
+"ListingId": "40841321"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T15:10:02Z"
+"RFModificationTimestamp": "2026-06-19T16:01:33Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1530.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2N3"
+"UnparsedAddress": "28 ST CLAIR Avenue, Hamilton, Ontario L8M2N3"
+"Coordinates": array:2 [
0 => -79.8398953
1 => 43.2505414
]
+"Latitude": 43.2505414
+"Longitude": -79.8398953
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Prestigious St. Clair Avenue! This one-of-a-kind on the street, character-filled home offers timeless elegance and exceptional warmth throughout. Featuring beautiful leaded and bevelled glass windows, a unique turret feature, custom built-ins, and a separate formal dining room, this home is full of unique charm. The inviting den just off the kitchen provides the perfect space for a home office, reading nook, or family retreat. The basement adds valuable living space with a walk-up to a private backyard ideal for relaxing or entertaining. A rare opportunity to own a distinguished home in one of the area’s most sought-after locations. Schedule your private viewing today! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:01:30.372018+00:00"
+"Directions": "King St E to St. Clair"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1948261"
+"ListOfficeKey": "287174"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T14:52:59Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T14:52:59Z"
+"Stories": "2.0"
+"StreetName": "ST CLAIR"
+"StreetNumber": "28"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "202 - Gibson/Stipley South"
+"TaxAnnualAmount": "4547.12"
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70336"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29927864/28-st-clair-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1523817"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55168"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1530
+"OriginalEntryTimestamp": "2026-06-19T14:50:25.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1242828"
+"ListOfficeNationalAssociationId": "1373445"
+"CoListAgentNationalAssociationId": "1063492"
+"CoListOfficeNationalAssociationId": "1116022"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927864')"
+"ID": "1547607"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25205
+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 [ …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"
+"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 [ …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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924961')"
+"ID": "1545466"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924553')"
+"ID": "1545515"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: "1543935"
+post_author: 1
+"ListingKey": "29922805"
+"ListingId": "X13461854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T17:40:02Z"
+"RFModificationTimestamp": "2026-06-18T18:16:33Z"
+"ListPrice": 767777.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Macassa)"
+"PostalCode": "L8V4C1"
+"UnparsedAddress": "487 EAST 37TH STREET, Hamilton (Macassa), Ontario L8V4C1"
+"Coordinates": array:2 [
0 => -79.845015
1 => 43.220324
]
+"Latitude": 43.220324
+"Longitude": -79.845015
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 487 East 37th St, Hamilton- A beautifully remodeled bungalow filled with warmth andmodern charm. Located in the heart of Macassa Hamilton Mountain Area, this move-in-ready home offerscomfort and style throughout. The bright main level features 3 cozy bedrooms, a stylish 4-piece bath withheated floor, and an inviting open-concept kitchen with quartz counters, white cabinets, pot lights, a potfiller, and a lovely fireplace with accent shelving opens to the dining and living rooms, highlighted by ahuge new window that fills the space with natural light. A separate entrance leads to the fully finishedLegal basement (Additional Dwelling Unit) with spacious 2 beds, 1 full bath, custom kitchen , Separatelaundry and plenty of storage-ideal for guests or extended family. Enjoy a fully fenced backyard, a newlybuilt front deck, a driveway for 8 total parking with a detached garage. Close to schools, parks, shopping,and public transit-this home is cozy, updated, and ready to welcome you. (id:62650)"
+"Appliances": array:7 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Water meter"
4 => "Gas stove(s)"
5 => "Wine Fridge"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:16:27.981938+00:00"
+"Directions": "Cross Streets: Mohawk Rd. ** Directions: Upper Gage Ave & Mohawk Rd E."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237766"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "51 x 85 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T17:02:12Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:02:12Z"
+"Stories": "1.0"
+"StreetName": "East 37th"
+"StreetNumber": "487"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4221"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Macassa"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29922805/487-east-37th-street-hamilton-macassa-macassa"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 51.0
+"OriginalEntryTimestamp": "2026-06-18T17:02:12.08Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475810"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922805')"
+"ID": "1543935"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
+post_id: "1543936"
+post_author: 1
+"ListingKey": "29921721"
+"ListingId": "40841071"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T15:40:08Z"
+"RFModificationTimestamp": "2026-06-18T16:47:06Z"
+"ListPrice": 767777.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1788.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V4C1"
+"UnparsedAddress": "487 EAST 37TH Street, Hamilton, Ontario L8V4C1"
+"Coordinates": array:2 [
0 => -79.845029
1 => 43.2203326
]
+"Latitude": 43.2203326
+"Longitude": -79.845029
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 487 East 37th St, Hamilton— A beautifully remodelled bungalow filled with warmth and modern charm. Located in the heart of Macassa Hamilton Mountain Area, this move-in-ready home offers comfort and style throughout. The bright main level features 3 cozy bedrooms, a stylish 4-piece bath with heated floor, and an inviting open-concept kitchen with quartz counters, white cabinets, pot lights, a pot filler, and a lovely fireplace with accent shelving opens to the dining and living rooms, highlighted by a huge new window that fills the space with natural light. A separate entrance leads to the fully finished Legal basement (Additional Dwelling Unit) with spacious 2 beds, 1 full bath, custom kitchen , Separate laundry and plenty of storage—ideal for guests or extended family. Enjoy a fully fenced backyard, a newly built front deck, a driveway for 8 total parking with a detached garage. Close to schools, parks, shopping, and public transit—this home is cozy, updated, and ready to welcome you. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:47:00.104004+00:00"
+"Directions": "Upper Gage Ave & Mohawk Rd E"
+"ExteriorFeatures": array:4 [
0 => "Concrete"
1 => "Vinyl siding"
2 => "Shingles"
3 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078416"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T15:32:02Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T15:32:01Z"
+"Stories": "1.0"
+"StreetName": "EAST 37TH"
+"StreetNumber": "487"
+"StreetSuffix": "Street"
+"SubdivisionName": "178 - Macassa"
+"TaxAnnualAmount": "4221"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://tourwizard.net/487-east-37th-street-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921721/487-east-37th-street-hamilton"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 988
+"BelowGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-06-18T15:32:01.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1353274"
+"ListOfficeNationalAssociationId": "1344651"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921721')"
+"ID": "1543936"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23394
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921729')"
+"ID": "1543076"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922111')"
+"ID": "1542891"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+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: 32
+count: 284
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]