array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29890548 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: "1520846"
+post_author: 1
+"ListingKey": "29890548"
+"ListingId": "40839082"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:05:29Z"
+"RFModificationTimestamp": "2026-06-19T16:17:24Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2180.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M1P8"
+"UnparsedAddress": "71 AIKMAN Avenue, Hamilton, Ontario L8M1P8"
+"Coordinates": array:2 [
0 => -79.8464647
1 => 43.2504632
]
+"Latitude": 43.2504632
+"Longitude": -79.8464647
+"YearBuilt": 1910
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 71 Aikman Avenue, a charming home that has been lovingly owned and enjoyed by the same family for nearly 20 years. Offering a warm and inviting atmosphere, this home blends character, comfort, and convenience in a desirable Hamilton location. The updated kitchen serves as the heart of the home and features beautiful granite countertops installed in 2020. Perfectly situated beside the rear entrance, it offers easy access to the backyard, making outdoor entertaining and everyday living a breeze. Gather with family and friends in the formal dining room or unwind in the private backyard, an ideal space for relaxing, gardening, or enjoying summer evenings. A unique loft area adds valuable flexibility and can be used as a home office, creative studio, reading nook, or additional living space. Equipped with its own mini-split system providing both heating and cooling, this versatile area can be enjoyed comfortably throughout the year. Important updates include windows replaced in 2017, a roof completed in 2017, and granite kitchen countertops installed in 2020, offering added value and peace of mind. Parking is conveniently available on both sides of the street for residents and guests alike. (id:62783)"
+"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-11T19:12:31.015337+00:00"
+"Directions": "Main St E or King St E to Sanford. Turn onto Aikman from Sanford"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-11T18:31:37Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:32:42Z"
+"Stories": "2.5"
+"StreetName": "AIKMAN"
+"StreetNumber": "71"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "202 - Gibson/Stipley South"
+"TaxAnnualAmount": "4952"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1663017702"
"RoomType" => "Den"
"ListingId" => "40839082"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 5'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.53Z"
]
1 => array:11 [
"RoomKey" => "1663017703"
"RoomType" => "Bedroom"
"ListingId" => "40839082"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "15'10'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.54Z"
]
2 => array:11 [
"RoomKey" => "1663017704"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839082"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.54Z"
]
3 => array:11 [
"RoomKey" => "1663017705"
"RoomType" => "Bedroom"
"ListingId" => "40839082"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.54Z"
]
4 => array:11 [
"RoomKey" => "1663017706"
"RoomType" => "Bedroom"
"ListingId" => "40839082"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.54Z"
]
5 => array:11 [
"RoomKey" => "1663017707"
"RoomType" => "Bedroom"
"ListingId" => "40839082"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.54Z"
]
6 => array:11 [
"RoomKey" => "1663017708"
"RoomType" => "Bedroom"
"ListingId" => "40839082"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "9'10'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.55Z"
]
7 => array:11 [
"RoomKey" => "1663017709"
"RoomType" => "2pc Bathroom"
"ListingId" => "40839082"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.55Z"
]
8 => array:11 [
"RoomKey" => "1663017710"
"RoomType" => "Kitchen"
"ListingId" => "40839082"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "10'9'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.55Z"
]
9 => array:11 [
"RoomKey" => "1663017711"
"RoomType" => "Dining room"
"ListingId" => "40839082"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 14'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.55Z"
]
10 => array:11 [
"RoomKey" => "1663017712"
"RoomType" => "Living room"
"ListingId" => "40839082"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.55Z"
]
11 => array:11 [
"RoomKey" => "1663017713"
"RoomType" => "Foyer"
"ListingId" => "40839082"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29890548"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-19T15:32:42.56Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29890548/71-aikman-avenue-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "E"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 2180
+"OriginalEntryTimestamp": "2026-06-11T18:31:37.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:20 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29890548_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/55eb0efa8e37c5a5ea0fb91229928a4e.webp"
"MediaSize" => 194024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-55eb0efa8e37c5a5ea0fb91229928a4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29890548_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/57b23622d3810ae4d9c76308a495826f.webp"
"MediaSize" => 68691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-57b23622d3810ae4d9c76308a495826f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29890548_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/2357dee74c96c25d94158dbf17a6b407.webp"
"MediaSize" => 82547
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-2357dee74c96c25d94158dbf17a6b407.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29890548_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/1369c225aa85686f9490e63f0cb32f2b.webp"
"MediaSize" => 73400
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-1369c225aa85686f9490e63f0cb32f2b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29890548_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/2a2bdf83a58ea15e064310b902fc4027.webp"
"MediaSize" => 74426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-2a2bdf83a58ea15e064310b902fc4027.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29890548_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/a8320288544c5dc65dd48b7f29fbab60.webp"
"MediaSize" => 72531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-a8320288544c5dc65dd48b7f29fbab60.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29890548_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/d943dbb0a9a93b65edbae7cb6b7d9fb4.webp"
"MediaSize" => 76658
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-d943dbb0a9a93b65edbae7cb6b7d9fb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29890548_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/1f4c793ab733c895578516adfd5ee514.webp"
"MediaSize" => 66751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-1f4c793ab733c895578516adfd5ee514.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29890548_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/d73a44c43c1961665456b845de560b03.webp"
"MediaSize" => 70983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-d73a44c43c1961665456b845de560b03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29890548_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/a299bcf777b04ce775fd46d370696ca6.webp"
"MediaSize" => 87772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-a299bcf777b04ce775fd46d370696ca6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29890548_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/8b76dad0aa3470b03f49b444c26e655d.webp"
"MediaSize" => 68747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-8b76dad0aa3470b03f49b444c26e655d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29890548_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/391d7ae0aa7659a1489623a7918b3329.webp"
"MediaSize" => 41558
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-391d7ae0aa7659a1489623a7918b3329.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29890548_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/2d54a728c355acaba2c479077b2ca0fb.webp"
"MediaSize" => 60123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-2d54a728c355acaba2c479077b2ca0fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29890548_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/8ec8df73d530b9dbfa8d3ca02d86a91d.webp"
"MediaSize" => 53162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-8ec8df73d530b9dbfa8d3ca02d86a91d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29890548_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/0c4bee10b88fee38290cced547642248.webp"
"MediaSize" => 64143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-0c4bee10b88fee38290cced547642248.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29890548_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/14d3256cbd85413588f445e8f95a0534.webp"
"MediaSize" => 58151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-14d3256cbd85413588f445e8f95a0534.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29890548_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/1aec3b239d1a2bd00b086ac91a264164.webp"
"MediaSize" => 82162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-1aec3b239d1a2bd00b086ac91a264164.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29890548_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/74ffb7fd615f589f708a54f7215dbd97.webp"
"MediaSize" => 63942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-74ffb7fd615f589f708a54f7215dbd97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29890548_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/484b2700ef82413b62acf69366819a81.webp"
"MediaSize" => 155439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-484b2700ef82413b62acf69366819a81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29890548_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29890548/19710fc995afd12a4549df4380fc90d1.webp"
"MediaSize" => 152121
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29890548/thumbnail-19710fc995afd12a4549df4380fc90d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839082"
"ResourceRecordKey" => "29890548"
"ModificationTimestamp" => "2026-06-11T18:31:37.33Z"
]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890548')"
+"ID": "1520846"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 275989" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24759
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524224" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24753
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29890548'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25138
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29890548'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25156
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25154
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31520382"
+"ListingKey": "29890548"
+"ListingId": "40839082"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T14:00:00Z"
+"OpenHouseEndTime": "2026-06-20T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-19T14:45:56Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31520382')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29890548' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8464647 43.2504632)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25209
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25203
+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
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29928374/thumbnail-997f0104e7584d8712d70fa4b6ffb45e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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 {#25205
+post_id: "1547606"
+post_author: 1
+"ListingKey": "29928216"
+"ListingId": "X13466508"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T15:50:02Z"
+"RFModificationTimestamp": "2026-06-19T16:47:35Z"
+"ListPrice": 499990.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Landsdale)"
+"PostalCode": "L8L5V6"
+"UnparsedAddress": "137 WENTWORTH STREET N, Hamilton (Landsdale), Ontario L8L5V6"
+"Coordinates": array:2 [
0 => -79.847391
1 => 43.256623
]
+"Latitude": 43.256623
+"Longitude": -79.847391
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A rare opportunity to own a character-filled home with modern bones in one of Hamilton's established neighbourhoods. Built in 1903, this fully updated 4+ bedroom, 2-bathroom property blends timeless charm with extensive mechanical and cosmetic upgrades, offering the best of both worlds for a growing family or savvy buyer. Inside, you'll find four generous bedrooms, a dedicated office space, two full bathrooms, and a spacious basement recreation room with a wood-burning fireplace. The lower level offers excellent potential for additional finished living space, with rough-in potential for a third bathroom already in place. Outside, the property truly shines. Enjoy a fenced front yard, covered and gated front porch, and a private backyard with both front and rear access. Perfect for entertaining, the outdoor space features a large patio with a natural gas BBQ hookup, ambient lighting, thoughtful landscaping, a garden shed, and a detached two-car garage accessed from the rear concrete laneway. A three-car side driveway provides plenty of parking. The updates speak for themselves: all-new electrical with a 200-amp service and surge protection, a 60-amp underground service to the garage with cable, phone, and internet connectivity, updated plumbing, an owned tankless water heater (2021), new A/C and ductwork (2020), new windows and doors (2020), and a fully refreshed exterior including the roof, soffits, fascia, eavestroughs, leaf guards, and downspouts. New flooring throughout and a wired alarm system connecting the house and garage add further value and peace of mind. With exceptional space, flexibility, and a long list of major improvements already completed, 137 Wentworth Street North is truly move-in ready-all that's left is to make it your own. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T16:47:30.917152+00:00"
+"Directions": "Cross Streets: Cannon and Wentworth. ** Directions: Cannon St E to Wentworth St N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027760"
+"ListOfficeKey": "299902"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "29 x 139 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T15:33:17Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T15:33:17Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Wentworth"
+"StreetNumber": "137"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3285.76"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Landsdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29928216/137-wentworth-street-n-hamilton-landsdale-landsdale"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 29.0
+"OriginalEntryTimestamp": "2026-06-19T15:33:17.24Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1307105"
+"ListOfficeNationalAssociationId": "1478673"
+"Media": array:17 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29928216')"
+"ID": "1547606"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "1547307"
+post_author: 1
+"ListingKey": "29927681"
+"ListingId": "40841177"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T14:55:06Z"
+"RFModificationTimestamp": "2026-06-19T15:24:37Z"
+"ListPrice": 499990.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1633.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L5V6"
+"UnparsedAddress": "137 WENTWORTH Street N, Hamilton, Ontario L8L5V6"
+"Coordinates": array:2 [
0 => -79.8472102
1 => 43.2566582
]
+"Latitude": 43.2566582
+"Longitude": -79.8472102
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A rare opportunity to own a character-filled home with modern bones in one of Hamilton’s established neighbourhoods. Built in 1903, this fully updated 4+ bedroom, 2-bathroom property blends timeless charm with extensive mechanical and cosmetic upgrades, offering the best of both worlds for a growing family or savvy buyer. Inside, you'll find four generous bedrooms, a dedicated office space, two full bathrooms, and a spacious basement recreation room with a wood-burning fireplace. The lower level offers excellent potential for additional finished living space, with rough-in potential for a third bathroom already in place. Outside, the property truly shines. Enjoy a fenced front yard, covered and gated front porch, and a private backyard with both front and rear access. Perfect for entertaining, the outdoor space features a large patio with a natural gas BBQ hookup, ambient lighting, thoughtful landscaping, a garden shed, and a detached two-car garage accessed from the rear concrete laneway. A three-car side driveway provides plenty of parking. The updates speak for themselves: all-new electrical with a 200-amp service and surge protection, a 60-amp underground service to the garage with cable, phone, and internet connectivity, updated plumbing, an owned tankless water heater (2021), new A/C and ductwork (2020), new windows and doors (2020), and a fully refreshed exterior including the roof, soffits, fascia, eavestroughs, leaf guards, and downspouts. New flooring throughout and a wired alarm system connecting the house and garage add further value and peace of mind. With exceptional space, flexibility, and a long list of major improvements already completed, 137 Wentworth Street North is truly move-in ready—all that's left is to make it your own. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T15:24:03.515737+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981716"
+"ListOfficeKey": "299866"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T14:33:47Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T14:33:47Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "WENTWORTH"
+"StreetNumber": "137"
+"StreetSuffix": "Street"
+"SubdivisionName": "141 - Landsdale"
+"TaxAnnualAmount": "3285.76"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29927681/137-wentworth-street-n-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2068350"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299867"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1633
+"OriginalEntryTimestamp": "2026-06-19T14:33:47.06Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267128"
+"ListOfficeNationalAssociationId": "1477944"
+"CoListAgentNationalAssociationId": "1343399"
+"CoListOfficeNationalAssociationId": "1477945"
+"Media": array:17 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29927681')"
+"ID": "1547307"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25204
+post_id: "1545466"
+post_author: 1
+"ListingKey": "29924961"
+"ListingId": "X13463908"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:05:06Z"
+"RFModificationTimestamp": "2026-06-18T22:56:34Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stinson)"
+"PostalCode": "L8N0B4"
+"UnparsedAddress": "204 - 479 CHARLTON AVENUE E, Hamilton (Stinson), Ontario L8N0B4"
+"Coordinates": array:2 [
0 => -79.853404
1 => 43.245461
]
+"Latitude": 43.245461
+"Longitude": -79.853404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 204 at Vista Condos - the coveted Poplar floor plan offering 937 sqft and one of the largest balconies in the building. With only two suites of this size per floor, this 2-bedroom, 2-bathroom corner residence offers a rare blend of privacy, sophistication, and elevated urban living. Wrapped in a soothing designer white palette, the suite feels calm, bright, and beautifully composed.The kitchen features extended white cabinetry, quartz countertops, a designer backsplash, and quality flooring that carries throughout the space. The main bath is finished with a glass shower and striking black accent tile, while the spacious primary suite offers a walk-in closet and oversized ensuite for a refined daily retreat. In-suite laundry adds everyday ease. Step outside to an exceptional private balcony framed by treetop, rail trail, and city views - peaceful, green, and quietly removed, yet moments from the energy of the city. Your new home offers thoughtful amenities including a gym, terrace, bike room, party room, visitor parking, a BBQ area, and attentive cleaning staff. A prime underground parking spot beside the elevator and an extra-large locker are both included. Condo fees include heat and water, common elements, and building insurance. Set moments from Corktown, Locke Street dining, St. Joe's Hospital, the GO Station, 403/QEW/LINC access, McMaster, James North, and the Niagara Escarpment trail system, this is a stylish treetop retreat designed for young professionals and first-time buyers ready for a lifestyle upgrade. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"AssociationFee": "806.86"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:56:27.342933+00:00"
+"Directions": "Cross Streets: Charlton Ave E & Wentworth St S. ** Directions: 403 to Main St W, East on Main, Right on Wentworth."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2010060"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Hillside"
1 => "Wooded area"
2 => "Elevator"
3 => "Balcony"
4 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T20:59:22Z"
+"PhotosCount": 31
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:59:22Z"
+"StreetDirSuffix": "East"
+"StreetName": "Charlton"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5434.74"
+"View": "City view"
+"Rooms": array:9 [
0 => array:11 [ …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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25199
+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"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23394
+post_id: "1544290"
+post_author: 1
+"ListingKey": "29923615"
+"ListingId": "X13462614"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:40:20Z"
+"RFModificationTimestamp": "2026-06-18T19:31:40Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8L6M4"
+"UnparsedAddress": "86 SHERMAN AVENUE N, Hamilton (Gibson), Ontario L8L6M4"
+"Coordinates": array:2 [
0 => -79.836845
1 => 43.254071
]
+"Latitude": 43.254071
+"Longitude": -79.836845
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into a piece of Hamilton history at 86 Sherman Avenue North. This grand Victorian residence showcases the kind of craftsmanship, character, and architectural detail that simply cannot be replicated today. From its impressive proportions to its timeless charm, this is a home that tells a story. Featuring 6 spacious bedrooms and 2 large bathrooms, the property provides exceptional flexibility for large families, multigenerational living, or those seeking a restoration project with tremendous upside. Original features such as 10 ft ceilings, 12" baseboards & refinished pine floors create a rare foundation for someone with a vision to bring this remarkable home back to its full potential. Convenient rear laneway access provides valuable private parking, while the central location places you just minutes from downtown Hamilton, the vibrant shops and restaurants of Ottawa Street and James Street North, Gage Park, schools, public transit, and easy highway access for commuters. Whether you're an investor, renovator, or buyer searching for a truly unique property, opportunities like this are becoming increasingly rare. Restore, reimagine, and revive one of Hamilton's classic Victorian homes. (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:31:30.958383+00:00"
+"Directions": "Cross Streets: Cannon St. E. ** Directions: West on Cannon St. E., North on Sherman Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036043"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Lane"
1 => "Carpet Free"
]
+"LotSizeDimensions": "32 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T18:33:09Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T18:33:09Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Sherman"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4659"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LwvocnAkqtj"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29923615/86-sherman-avenue-n-hamilton-gibson-gibson"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 6
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2026-06-18T18:33:09.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1312659"
+"ListOfficeNationalAssociationId": "1398828"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923615')"
+"ID": "1544290"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: "1543934"
+post_author: 1
+"ListingKey": "29923022"
+"ListingId": "40840784"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:00:12Z"
+"RFModificationTimestamp": "2026-06-18T19:07:59Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2657.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L6M4"
+"UnparsedAddress": "86 SHERMAN Avenue N, Hamilton, Ontario L8L6M4"
+"Coordinates": array:2 [
0 => -79.8370126
1 => 43.2541
]
+"Latitude": 43.2541
+"Longitude": -79.8370126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into a piece of Hamilton history at 86 Sherman Avenue North. This grand Victorian residence showcases the kind of craftsmanship, character, and architectural detail that simply cannot be replicated today. From its impressive proportions to its timeless charm, this is a home that tells a story. Featuring 6 spacious bedrooms and 2 large bathrooms, the property provides exceptional flexibility for large families, multigenerational living, or those seeking a restoration project with tremendous upside. Original features such as 10 ft ceilings, 12 baseboards & refinished pine floors create a rare foundation for someone with a vision to bring this remarkable home back to its full potential. Convenient rear laneway access provides valuable private parking, while the central location places you just minutes from downtown Hamilton, the vibrant shops and restaurants of Ottawa Street and James Street North, Gage Park, schools, public transit, and easy highway access for commuters. Whether you're an investor, renovator, or buyer searching for a truly unique property, opportunities like this are becoming increasingly rare. Restore, reimagine, and revive one of Hamilton's classic Victorian homes. (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:07:21.652135+00:00"
+"Directions": "West on Cannon St. E., North on Sherman Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562180"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-18T17:32:47Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:50:33Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "SHERMAN"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "4659"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LwvocnAkqtj"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29923022/86-sherman-avenue-n-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 2657
+"OriginalEntryTimestamp": "2026-06-18T17:32:47.28Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1148101"
+"ListOfficeNationalAssociationId": "1398404"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923022')"
+"ID": "1543934"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+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"
}
]
+success: true
+page_size: 9
+page_count: 53
+count: 469
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]