array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29947003 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1562138"
+post_author: 1
+"ListingKey": "29947003"
+"ListingId": "40842443"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:00:05Z"
+"RFModificationTimestamp": "2026-06-25T20:44:59Z"
+"ListPrice": 489900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1230.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L5X8"
+"UnparsedAddress": "19 HUNTLEY Street, Hamilton, Ontario L8L5X8"
+"Coordinates": array:2 [
0 => -79.8465163
1 => 43.2563063
]
+"Latitude": 43.2563063
+"Longitude": -79.8465163
+"YearBuilt": 1910
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Tucked at the end of a quiet cul-de-sac, This super clean, move in ready, All brick 2.5 storey 3 bed 2 bath home is 90% carpet free. It features a rare double wide front driveway, and a waterproofed basement. The kind of home that instantly feels warm, welcoming, and well cared for. Hardwood flooring runs throughout most of the interior, The main floor includes an open living room and dinning area. Stainless Steel appliances in the kitchen there is space here to grow, gather, work from home, or simply settle into a home that feels established and welcoming. The second floor features two freshly painted good sized rooms and a 4 piece bathroom with a tiled shower. Up top you will find the third bedroom a large finished loft with vinyl plank flooring and a ton storage The unfinished basement, mainly for storage is super dry and completely waterproofed with an extra 2 piece bathroom Beyond the front door, the lifestyle this location offers is just as compelling. Cathy Wever Elementary School is only steps away, while Pinky Lewis Recreation Centre & Pool, Bayfront Park, the GO Station, downtown restaurants, shops, and convenient highway access are all close at hand. It’s a setting that makes day-to-day living easier while keeping you connected to some of Hamilton’s best amenities, green spaces, and community attractions. Significant updates over the years add lasting value and peace of mind, including windows and doors, backflow valve, furnace, central air and hot water heater (2018), along with bathroom updates and stair carpeting (2021). With parking for 2 cars in the front drive and a home that has been genuinely cherished over time, 19 Huntley Street offers something buyers are always searching for but rarely find: character, care, and a location that truly works for real life. A home with soul, substance, and a setting to match. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:44:36.156003+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1623259"
+"ListOfficeKey": "275165"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2026-06-24T16:11:06Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:51:31Z"
+"Stories": "2.5"
+"StreetName": "HUNTLEY"
+"StreetNumber": "19"
+"StreetSuffix": "Street"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "2560.28"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1667929206"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842443"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.37Z"
]
1 => array:11 [
"RoomKey" => "1667929207"
"RoomType" => "Bedroom"
"ListingId" => "40842443"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => "13'11'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.37Z"
]
2 => array:11 [
"RoomKey" => "1667929208"
"RoomType" => "Attic"
"ListingId" => "40842443"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => "17'0'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.37Z"
]
3 => array:11 [
"RoomKey" => "1667929209"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842443"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 4'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.37Z"
]
4 => array:11 [
"RoomKey" => "1667929210"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842443"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.37Z"
]
5 => array:11 [
"RoomKey" => "1667929211"
"RoomType" => "Bedroom"
"ListingId" => "40842443"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.37Z"
]
6 => array:11 [
"RoomKey" => "1667929212"
"RoomType" => "Kitchen"
"ListingId" => "40842443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 9'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.38Z"
]
7 => array:11 [
"RoomKey" => "1667929213"
"RoomType" => "Dining room"
"ListingId" => "40842443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.38Z"
]
8 => array:11 [
"RoomKey" => "1667929214"
"RoomType" => "Living room"
"ListingId" => "40842443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.38Z"
]
9 => array:11 [
"RoomKey" => "1667929215"
"RoomType" => "Foyer"
"ListingId" => "40842443"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29947003"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 4'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T18:51:31.38Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29947003/19-huntley-street-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1230
+"OriginalEntryTimestamp": "2026-06-24T16:11:05.73Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1161082"
+"ListOfficeNationalAssociationId": "1262401"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29947003_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/2d8aa6149df748405004950e3ad7b403.webp"
"MediaSize" => 116128
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-2d8aa6149df748405004950e3ad7b403.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29947003_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/edadc893c10f740b610030a008ab7724.webp"
"MediaSize" => 130691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-edadc893c10f740b610030a008ab7724.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29947003_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/94e2060151303eb72795c39b0c6e41f7.webp"
"MediaSize" => 135397
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-94e2060151303eb72795c39b0c6e41f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29947003_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/85401e6c7ff137878bc0e7ca39573af6.webp"
"MediaSize" => 141894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-85401e6c7ff137878bc0e7ca39573af6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29947003_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/bedfbb432e816e7228a44e152a40e0a3.webp"
"MediaSize" => 164626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-bedfbb432e816e7228a44e152a40e0a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29947003_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/c50486b63c5a5a9cfdfae15a6d7b7996.webp"
"MediaSize" => 52392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-c50486b63c5a5a9cfdfae15a6d7b7996.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29947003_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/28423f85535d8573266ef7b3c1aa1ca6.webp"
"MediaSize" => 54832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-28423f85535d8573266ef7b3c1aa1ca6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29947003_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/83ca36e3cbf5e6cc1234c2cdc1fe394d.webp"
"MediaSize" => 77590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-83ca36e3cbf5e6cc1234c2cdc1fe394d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29947003_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/682892658d3ecb595095163a5f115fe2.webp"
"MediaSize" => 92284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-682892658d3ecb595095163a5f115fe2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29947003_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/1844a37c196723753ccf37653f7084ff.webp"
"MediaSize" => 72990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-1844a37c196723753ccf37653f7084ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29947003_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/0d1e1498f3ea150157c7573d9026cf92.webp"
"MediaSize" => 77207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-0d1e1498f3ea150157c7573d9026cf92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29947003_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/1c90c93a89e53a5402a3cacb530f3030.webp"
"MediaSize" => 63857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-1c90c93a89e53a5402a3cacb530f3030.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29947003_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/d957827814315b441a49f003ce7db837.webp"
"MediaSize" => 68399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-d957827814315b441a49f003ce7db837.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29947003_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/54e9c6491d00b851d1a838b7cd78b639.webp"
"MediaSize" => 53671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-54e9c6491d00b851d1a838b7cd78b639.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29947003_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/2c414bcad0776a3cfebccacada5f26dc.webp"
"MediaSize" => 70023
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-2c414bcad0776a3cfebccacada5f26dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29947003_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/1bd4e735042897ff50195ee2722426df.webp"
"MediaSize" => 71868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-1bd4e735042897ff50195ee2722426df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29947003_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/a06ecafdd239fb411fa81c5839344e20.webp"
"MediaSize" => 61940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-a06ecafdd239fb411fa81c5839344e20.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29947003_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/b8bf3fe9f4f6ddba2c520221116c985c.webp"
"MediaSize" => 57076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-b8bf3fe9f4f6ddba2c520221116c985c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29947003_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/f102a60cd549b0a2bb6d93a2063cc9f7.webp"
"MediaSize" => 53402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-f102a60cd549b0a2bb6d93a2063cc9f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29947003_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/e22e6e106c8b7aeac0a015f451dfca67.webp"
"MediaSize" => 59878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-e22e6e106c8b7aeac0a015f451dfca67.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29947003_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/3a0e6dda4c97026d4a1062e4bc92d000.webp"
"MediaSize" => 47981
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-3a0e6dda4c97026d4a1062e4bc92d000.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29947003_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/6d3cf1f70c09f5eec071573a7e2b2812.webp"
"MediaSize" => 67879
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-6d3cf1f70c09f5eec071573a7e2b2812.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29947003_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/4d242c02d957203cf3bb5dd22e563c5b.webp"
"MediaSize" => 67556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-4d242c02d957203cf3bb5dd22e563c5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29947003_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/424a99cdfc15467ffe04b0438c370f26.webp"
"MediaSize" => 59483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-424a99cdfc15467ffe04b0438c370f26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29947003_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/78c7054518add349fcef5658cc334243.webp"
"MediaSize" => 63635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-78c7054518add349fcef5658cc334243.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29947003_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/244053136e65f4d62ea6e567e0dd2f49.webp"
"MediaSize" => 48542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-244053136e65f4d62ea6e567e0dd2f49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29947003_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/037b4e4c5a4ab9dfde52658796c8c33e.webp"
"MediaSize" => 46851
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-037b4e4c5a4ab9dfde52658796c8c33e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29947003_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/f5faafeb66ed3433b4e8407c6f26d48b.webp"
"MediaSize" => 57483
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-f5faafeb66ed3433b4e8407c6f26d48b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29947003_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/7083af1f6f40a1b31dbe62e05945114f.webp"
"MediaSize" => 131317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-7083af1f6f40a1b31dbe62e05945114f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29947003_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/628c87b51873757909b2ccce17714a61.webp"
"MediaSize" => 109434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-628c87b51873757909b2ccce17714a61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29947003_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/b94e7d3193bba76a82d6ccf2bcdde4e3.webp"
"MediaSize" => 121675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-b94e7d3193bba76a82d6ccf2bcdde4e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29947003_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/622e60e1c0f66f2603f6352f1b2bec7a.webp"
"MediaSize" => 157488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-622e60e1c0f66f2603f6352f1b2bec7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29947003_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/3e03d4fc4dfc1fff8c9b6ca64e1e7b68.webp"
"MediaSize" => 141980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-3e03d4fc4dfc1fff8c9b6ca64e1e7b68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29947003_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/546c8d735903e11c6e733e98517870f0.webp"
"MediaSize" => 163454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-546c8d735903e11c6e733e98517870f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29947003_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/9b237a58cf15e707ca3ef3a8c9dc5185.webp"
"MediaSize" => 181199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-9b237a58cf15e707ca3ef3a8c9dc5185.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29947003_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29947003/a64ed7f3bec869ed1b33c14d1bc18a53.webp"
"MediaSize" => 178214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29947003/thumbnail-a64ed7f3bec869ed1b33c14d1bc18a53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842443"
"ResourceRecordKey" => "29947003"
"ModificationTimestamp" => "2026-06-24T16:11:05.75Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947003')"
+"ID": "1562138"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 275165" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24821
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1623259" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24820
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29947003'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25214
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29947003'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25229
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25230
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31650490"
+"ListingKey": "29947003"
+"ListingId": "40842443"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-28"
+"OpenHouseStartTime": "2026-06-28T14:00:00Z"
+"OpenHouseEndTime": "2026-06-28T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-26T08:09:14Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31650490')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25232
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31650491"
+"ListingKey": "29947003"
+"ListingId": "40842443"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-27"
+"OpenHouseStartTime": "2026-06-27T14:00:00Z"
+"OpenHouseEndTime": "2026-06-27T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-26T08:09:14Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31650491')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29947003' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8465163 43.2563063)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25307
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1566963"
+post_author: 1
+"ListingKey": "29946528"
+"ListingId": "40842299"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:20:12Z"
+"RFModificationTimestamp": "2026-06-26T03:11:20Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0.05
+"LivingArea": 2510.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L1Z3"
+"UnparsedAddress": "9 SENATOR Avenue, Hamilton, Ontario L8L1Z3"
+"Coordinates": array:2 [
0 => -79.8344115
1 => 43.2518194
]
+"Latitude": 43.2518194
+"Longitude": -79.8344115
+"YearBuilt": 1911
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Investors, this one is for you! Incredible opportunity to live in the home and have one or more tenants help with the mortgage. This house was once a full triplex and could be easily converted back. Pride of ownership is beaming here! Step inside to the cozy enclosed front porch. On the main floor you will find the living room (with original pocket doors), kitchen and separate large dining room. There is a lively back deck and steps down to the fenced rear yard with shed. The second level offers 3 bedrooms and the second kitchen and a full bath. The very top level features 2 more bedrooms. The basement has been finished with a second bathroom and 2 additional rooms (possible bedrooms/office etc). Amazing opportunity to live in a very central location (steps to Tim Hortons Field). Electrical and plumbing have been updated. Furnace, new in 2026, is currently a rental and will be paid out in full on closing. Air conditioner approx. 5 years old. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Range - Gas"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:10:56.781890+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524280"
+"ListOfficeKey": "67816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Southern exposure"
]
+"LotSizeDimensions": "0.05"
+"PhotosChangeTimestamp": "2026-06-24T15:10:51Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T15:10:51Z"
+"Stories": "2.5"
+"StreetName": "SENATOR"
+"StreetNumber": "9"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "3643.93"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70328"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1666904162"
"RoomType" => "Utility room"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.5Z"
]
1 => array:11 [
"RoomKey" => "1666904163"
"RoomType" => "Laundry room"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.5Z"
]
2 => array:11 [
"RoomKey" => "1666904164"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
3 => array:11 [
"RoomKey" => "1666904165"
"RoomType" => "Recreation room"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
4 => array:11 [
"RoomKey" => "1666904166"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
5 => array:11 [
"RoomKey" => "1666904167"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
6 => array:11 [
"RoomKey" => "1666904168"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
7 => array:11 [
"RoomKey" => "1666904169"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 6'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
8 => array:11 [
"RoomKey" => "1666904170"
"RoomType" => "Kitchen"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
9 => array:11 [
"RoomKey" => "1666904171"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
10 => array:11 [
"RoomKey" => "1666904172"
"RoomType" => "Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
11 => array:11 [
"RoomKey" => "1666904173"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842299"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
12 => array:11 [
"RoomKey" => "1666904174"
"RoomType" => "Kitchen"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "14'10'' x 8'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.51Z"
]
13 => array:11 [
"RoomKey" => "1666904175"
"RoomType" => "Dining room"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.52Z"
]
14 => array:11 [
"RoomKey" => "1666904176"
"RoomType" => "Living room"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.52Z"
]
15 => array:11 [
"RoomKey" => "1666904177"
"RoomType" => "Foyer"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.52Z"
]
16 => array:11 [
"RoomKey" => "1666904178"
"RoomType" => "Mud room"
"ListingId" => "40842299"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29946528"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T15:10:51.52Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946528/9-senator-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 2006
+"BelowGradeFinishedArea": 504
+"OriginalEntryTimestamp": "2026-06-24T15:10:51.44Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1129172"
+"ListOfficeNationalAssociationId": "1132083"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29946528_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/c331b60da761644a208e92976ea1df5a.webp"
"MediaSize" => 105439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-c331b60da761644a208e92976ea1df5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29946528_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/c6cfeb9335c1155807f223b6e867bea1.webp"
"MediaSize" => 115707
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-c6cfeb9335c1155807f223b6e867bea1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29946528_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/b3f748f3a9f1bd2177da2cbce6bdc43f.webp"
"MediaSize" => 123341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-b3f748f3a9f1bd2177da2cbce6bdc43f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29946528_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/cc393639474eced7243552d6c8f73514.webp"
"MediaSize" => 87070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-cc393639474eced7243552d6c8f73514.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29946528_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/63aa28f6e24bc0382d228937b379f9e9.webp"
"MediaSize" => 87213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-63aa28f6e24bc0382d228937b379f9e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29946528_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/a9de763b4c418dd33fd648791d320ac7.webp"
"MediaSize" => 81554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-a9de763b4c418dd33fd648791d320ac7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29946528_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/bd4733bf48770078bd3a6cee537c025a.webp"
"MediaSize" => 74059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-bd4733bf48770078bd3a6cee537c025a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29946528_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/b52cbc7b48c690f924bfbe92ce9a98d4.webp"
"MediaSize" => 80745
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-b52cbc7b48c690f924bfbe92ce9a98d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29946528_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/479bf0e6a5ddf9071ba55a0f04181a93.webp"
"MediaSize" => 77266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-479bf0e6a5ddf9071ba55a0f04181a93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29946528_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/d91ab32bba13308be64535f3723f0e78.webp"
"MediaSize" => 82408
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-d91ab32bba13308be64535f3723f0e78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
"ResourceRecordKey" => "29946528"
"ModificationTimestamp" => "2026-06-24T15:10:51.45Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29946528_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29946528/eb5ae1f2292ae59843cad3141e6ec124.webp"
"MediaSize" => 63832
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29946528/thumbnail-eb5ae1f2292ae59843cad3141e6ec124.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842299"
…2
]
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('29946528')"
+"ID": "1566963"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25302
+post_id: "1566980"
+post_author: 1
+"ListingKey": "29946674"
+"ListingId": "40842631"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:40:15Z"
+"RFModificationTimestamp": "2026-06-26T02:58:15Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L4R3"
+"UnparsedAddress": "414 JOHN Street, Hamilton, Ontario L8L4R3"
+"Coordinates": array:2 [
0 => -79.8609361
1 => 43.2685538
]
+"Latitude": 43.2685538
+"Longitude": -79.8609361
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exceptional custom-built (2016) industrial-modern detached home in Hamilton’s premier North End. This architectural standout transitions seamlessly from a dedicated main-floor professional gym into an expansive living space defined by soaring ceilings, exposed structural ductwork, and floating open-tread stairs. A chef-inspired kitchen features a massive butcher-block island and designer lighting, perfect for entertaining. The primary retreat offers a private sanctuary with its own walk-out balcony and a luxurious 5-piece stone-clad ensuite with a soaking tub. Rare for the area, the property includes a double-wide driveway and a commercial-grade glass garage door with extra height for oversized vehicles and adventure rigs. Step outside to a low-maintenance turf yard or walk minutes to West Harbour GO, Bayfront Park, and the vibrant James St N district. High-efficiency modern construction throughout. RSA. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:57:56.622055+00:00"
+"Directions": "JOHN ST N, BETWEEN FERRIE & PICTON"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Metal"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738902"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T15:32:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T15:32:08Z"
+"Stories": "3.0"
+"StreetName": "JOHN"
+"StreetNumber": "414"
+"StreetSuffix": "Street"
+"SubdivisionName": "132 - North End"
+"TaxAnnualAmount": "9087"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/videos/019d0c95-e7ed-735e-a0bc-49538dbe3656"
+"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/29946674/414-john-street-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 3200
+"OriginalEntryTimestamp": "2026-06-24T15:32:08.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1179053"
+"ListOfficeNationalAssociationId": "1344652"
+"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('29946674')"
+"ID": "1566980"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1566336"
+post_author: 1
+"ListingKey": "29946903"
+"ListingId": "X13483454"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:25:13Z"
+"RFModificationTimestamp": "2026-06-26T02:33:54Z"
+"ListPrice": 569900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stipley)"
+"PostalCode": "L8M3E4"
+"UnparsedAddress": "39 EAST BEND AVENUE S, Hamilton (Stipley), Ontario L8M3E4"
+"Coordinates": array:2 [
0 => -79.828126
1 => 43.245455
]
+"Latitude": 43.245455
+"Longitude": -79.828126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This 2.5-storey home sits in the heart of Central Hamilton, just steps from Gage Park. Thoughtfully updated, it blends timeless character with modern comfort across 3 bedrooms and 2.5 baths. A covered front porch welcomes you into a spacious foyer that opens to a bright living and dining area, where pot lighting highlights updated flooring and a striking feature wall. The updated kitchen impresses with white cabinetry, stainless steel appliances, and butcher block countertops-perfect for family meals or entertaining. A piano-style staircase leads to the second level, offering two generous bedrooms, including one with a sun-filled bay window. An exterior door accesses the flat roof over the kitchen-a space full of potential. The elegant 3-piece bath features an oversized glass shower. The third level is a true primary retreat with two closets and a spa-inspired 3-piece bath with a stand-up glass shower. The lower level adds excellent storage, laundry, and a finished 2-piece powder room. Outside, enjoy a low-maintenance turf yard with a deck, leading to an oversized 1.5-car garage with an updated door. Recent updates include windows, roof shingles and eavestroughs (2017), flooring and light fixtures (2020), central air (2020), electrical panel (2020), main drain replacement (2020), and furnace (2023). California shutters and oversized mouldings throughout preserve the home's original character. With cafes, shops, and transit just steps away, 39 East Bend Avenue South is the perfect blend of location, character, and quality upgrades. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:32:55.880532+00:00"
+"Directions": "Cross Streets: Dunsmure Road. ** Directions: From Main E/Gage S, E on Main E, N on East Bend Ave S."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1761819"
+"ListOfficeKey": "290358"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "20 x 95 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T16:17:39Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:17:39Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "East Bend"
+"StreetNumber": "39"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4012.33"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=cvjEII5anB4&feature=youtu.be"
+"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": "Toronto"
+"CityRegion": "Stipley"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29946903/39-east-bend-avenue-s-hamilton-stipley-stipley"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.0
+"OriginalEntryTimestamp": "2026-06-24T15:58:51.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1184762"
+"ListOfficeNationalAssociationId": "1386142"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946903')"
+"ID": "1566336"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25304
+post_id: "1566342"
+post_author: 1
+"ListingKey": "29947057"
+"ListingId": "X13483750"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:25:13Z"
+"RFModificationTimestamp": "2026-06-26T02:33:22Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (North End)"
+"PostalCode": "L8L4R3"
+"UnparsedAddress": "414 JOHN STREET, Hamilton (North End), Ontario L8L4R3"
+"Coordinates": array:2 [
0 => -79.860699
1 => 43.268509
]
+"Latitude": 43.268509
+"Longitude": -79.860699
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional custom-built (2016) industrial-modern detached home in Hamilton's premier North End. This architectural standout transitions seamlessly from a dedicated main-floor professional gym into an expansive living space defined by soaring ceilings, exposed structural ductwork, and floating open-tread stairs. A chef-inspired kitchen features a massive butcher-block island and designer lighting, perfect for entertaining. The primary retreat offers a private sanctuary with its own walk-out balcony and a luxurious 5-piece stone-clad ensuite with a soaking tub. Rare for the area, the property includes a double-wide driveway and a commercial-grade glass garage door with extra height for oversized vehicles and adventure rigs. Step outside to a low-maintenance turf yard or walk minutes to West Harbour GO, Bayfront Park, and the vibrant James St N district. High-efficiency modern construction throughout. RSA. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
8 => "Water Heater - Tankless"
]
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:31:57.326242+00:00"
+"Directions": "Cross Streets: FERRIE ST. ** Directions: John St N, between Ferrie and Picton."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Slab"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2240345"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level"
1 => "Carpet Free"
]
+"LotSizeDimensions": "27.6 x 106.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T16:17:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:17:48Z"
+"Stories": "3.0"
+"StreetName": "JOHN"
+"StreetNumber": "414"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "9087"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/414-john-st-n-hamilton-on-l8l-4r3-22876084/unbranded"
+"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": "Toronto"
+"CityRegion": "North End"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29947057/414-john-street-hamilton-north-end-north-end"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 27.7
+"OriginalEntryTimestamp": "2026-06-24T16:17:48.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1478315"
+"ListOfficeNationalAssociationId": "1344891"
+"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('29947057')"
+"ID": "1566342"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1566053"
+post_author: 1
+"ListingKey": "29947138"
+"ListingId": "40842598"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T16:40:12Z"
+"RFModificationTimestamp": "2026-06-26T02:24:39Z"
+"ListPrice": 370000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1238.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L6L9"
+"UnparsedAddress": "35 SHERMAN Avenue N, Hamilton, Ontario L8L6L9"
+"Coordinates": array:2 [
0 => -79.8380841
1 => 43.252454
]
+"Latitude": 43.252454
+"Longitude": -79.8380841
+"YearBuilt": 1911
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into the charm of this solid brick 2.5 brick home built in 1911, brimming with character and ready for your personal touch. The enclosed front porch features a warm welcome and showcases the home's timeless appeal. Inside, you'll find a spacious layout with generous bedrooms on the second floor and a bright 4-piece bathroom. The third floor adds two additional bedrooms, perfect for guests, a home office, or creative space. The kitchen opens to a private backyard, providing the ideal setting for future gardens or outdoor entertaining. A separate side entrance leads to the unfinished basement, which includes an existing bathroom-offering excellent potential for additional living space. ich in history and full of opportunity, this home is waiting for someone with vision to restore its original beauty and make it shine once again (id:62783)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:23:46.069204+00:00"
+"Directions": "Wilson St N on Sherman Ave N"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1803927"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-24T16:32:47Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T16:32:46Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "SHERMAN"
+"StreetNumber": "35"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "210 - North Sherman"
+"TaxAnnualAmount": "2590.04"
+"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/29947138/35-sherman-avenue-n-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 21.0
+"AboveGradeFinishedArea": 1238
+"OriginalEntryTimestamp": "2026-06-24T16:32:46.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1190947"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29947138')"
+"ID": "1566053"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1565833"
+post_author: 1
+"ListingKey": "29955723"
+"ListingId": "40843253"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T23:10:29Z"
+"RFModificationTimestamp": "2026-06-26T01:50:25Z"
+"ListPrice": 829900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2886.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2P8"
+"UnparsedAddress": "103 SHERMAN Avenue S, Hamilton, Ontario L8M2P8"
+"Coordinates": array:2 [
0 => -79.8393806
1 => 43.2481979
]
+"Latitude": 43.2481979
+"Longitude": -79.8393806
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stunning Victorian residence seamlessly blends timeless character with modern upgrades, offering over 3,000 sq ft of beautifully finished living space. Featuring 6 bedrooms, 2 kitchens, 3 bathrooms, and multiple private entrances, this property is ideal for large families, multi-generational living, or savvy investors. The fully renovated main floor kitchen is a true showpiece-bright and modern with crisp white cabinetry, stainless steel appliances & gas range. Original architectural details add warmth and charm throughout, including hardwood floors, pocket doors, leaded glass windows, natural slate, Carrera marble countertops and vaulted ceilings. Step outside to a low maintenance backyard filled with perennials. A rare opportunity to own a truly stately home. Parking for up to 5 cars. Excellent location close to all amenities and bus route. (id:62650)"
+"Appliances": array:2 [
0 => "Refrigerator"
1 => "Gas stove(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "High Traffic Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:50:14.363178+00:00"
+"Directions": "Main St E & North on Sherman Ave S"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Heating": array:2 [
0 => "Natural gas"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976293"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-25T23:02:07Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T23:02:07Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "SHERMAN"
+"StreetNumber": "103"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "202 - Gibson/Stipley South"
+"TaxAnnualAmount": "11336.99"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
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]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29955723/103-sherman-avenue-s-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 2886
+"OriginalEntryTimestamp": "2026-06-25T23:02:07.1Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1262753"
+"ListOfficeNationalAssociationId": "1344654"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29955723')"
+"ID": "1565833"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1565834"
+post_author: 1
+"ListingKey": "29955787"
+"ListingId": "X13491484"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T23:25:17Z"
+"RFModificationTimestamp": "2026-06-26T01:41:29Z"
+"ListPrice": 719900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (St. Clair)"
+"PostalCode": "L8M2Z6"
+"UnparsedAddress": "225 PROSPECT STREET S, Hamilton (St. Clair), Ontario L8M2Z6"
+"Coordinates": array:2 [
0 => -79.834587
1 => 43.243319
]
+"Latitude": 43.243319
+"Longitude": -79.834587
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptionally tall basement, open concept main floor & parking for up to 3! Welcome to 225 Prospect St S in St. Clair! Located just minutes to Gage Park, this charming 2.5-storey detached home blends modern updates with incredible potential for a growing family. The main floor features hardwood flooring, electric fireplace & a spacious dining room w/ custom feature wall of cabinetry - ideal for family dinners and entertaining. The open-concept kitchen makes life easy with a sink overlooking the backyard and seamless access to the back deck for summer BBQs. Upstairs, the second level boasts a 17-ft primary bedroom and a spacious second bedroom, both featuring double closets. A smart conversion created a dream upper-level laundry room and a luxurious, structurally reinforced 4-piece bathroom (2019) complete with heated marble floors and ample built-in storage. The third-floor offers a third bedroom and a bright flex space. It's the perfect family hang out room, playroom or home office. Need more space? The unfinished basement boasts a rare 8'5" ceiling height, a separate side entrance, and a fully completed, modern 3-piece bathroom with heated floors. Whether you're considering income-options or simply expanding your living space, this basement offers huge potential. Outside, enjoy a fully fenced, family-friendly yard with an upper deck, lower patio, and mature gardens. The detached garage with laneway is currently used as storage, but with a little work for a new garage door, you've got yourself a secured 3rd parking space in addition to the 2 on the front double wide drive. Located within minutes walking distance to Gage Park, the 74-acre muti-use park featuring extensive rose gardens, tropical greenhouses, playground, splash pad, bandshell, tennis courts, lawn bowling, baseball diamonds, and Children's Museum. If restaurants and shopping is more your vibe, you've got what you need on nearby Ottawa St. 225 Prospect St S is the perfect home to plant your roots! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Water Heater - Tankless"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:41:20.091979+00:00"
+"Directions": "Cross Streets: Main St E / Prospect St S. ** Directions: Main St E to Prospect St S, go South on Prospect St S."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Cedar Siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Marble"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2063982"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "26 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T23:19:16Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T23:19:16Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "Prospect"
+"StreetNumber": "225"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4356.66"
+"VirtualTourURLUnbranded": "https://youriguide.com/225_prospect_st_s_hamilton_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "St. Clair"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29955787/225-prospect-street-s-hamilton-st-clair-st-clair"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 26.0
+"OriginalEntryTimestamp": "2026-06-25T23:19:15.84Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1339062"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29955787')"
+"ID": "1565834"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25305
+post_id: "1565343"
+post_author: 1
+"ListingKey": "29954363"
+"ListingId": "X13490380"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:55:04Z"
+"RFModificationTimestamp": "2026-06-26T01:05:33Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Crown Point)"
+"PostalCode": "L8L7E6"
+"UnparsedAddress": "125 CAVELL AVENUE, Hamilton (Crown Point), Ontario L8L7E6"
+"Coordinates": array:2 [
0 => -79.825004
1 => 43.251307
]
+"Latitude": 43.251307
+"Longitude": -79.825004
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Clean and affordable 2 story 3 bedroom family home with living room & dining room combination with updated floors, updated kitchen, 2 full baths, partly finished basement, newer roof shingles (2023), Furnace (2015), A/C (2015), hot water tank (2023). Fully fenced yard, private front parking, garage. Convenient location near shopping & public transit. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Garage door opener remote(s)"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T01:02:43.388420+00:00"
+"Directions": "Cross Streets: GAGE AVE/BARTON ST. E. ** Directions: East on Barton St E cross Gage Ave South on Cavell Ave."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2259210"
+"ListOfficeKey": "266588"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Flat site"
]
+"LotSizeDimensions": "20.7 x 115 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T19:50:11Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T19:50:11Z"
+"Stories": "2.0"
+"StreetName": "Cavell"
+"StreetNumber": "125"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3384.21"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Crown Point"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29954363/125-cavell-avenue-hamilton-crown-point-crown-point"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 20.8
+"OriginalEntryTimestamp": "2026-06-25T19:50:11.4Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1499122"
+"ListOfficeNationalAssociationId": "1274323"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954363')"
+"ID": "1565343"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25306
+post_id: "1563999"
+post_author: 1
+"ListingKey": "29954924"
+"ListingId": "40842610"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:20:05Z"
+"RFModificationTimestamp": "2026-06-25T23:40:04Z"
+"ListPrice": 719900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1793.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N2J6"
+"UnparsedAddress": "135 CATHARINE Street S, Hamilton, Ontario L8N2J6"
+"Coordinates": array:2 [
0 => -79.8669616
1 => 43.2510787
]
+"Latitude": 43.2510787
+"Longitude": -79.8669616
+"YearBuilt": 1900
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautifully enhanced 4 bdrm, 1.5 bath, 2.5-stry Victorian brick residence offering an exceptional blend of historic character and modern updates in one of Hamilton's most walkable urban neighbourhoods. Situated in the heart of the Corktown neighbourhood w/ surfaced parking for 1 vehicle on an attractive interlock driveway, this stunning home showcases exposed brick, soaring ceilings, hardwood flrs, upgraded lighting, & thoughtfully preserved architectural details throughout. The main lvl feat a welcoming foyer w/ a transom window, an inviting liv rm w/ a natural gas FP, custom built-ins, & a beautiful front bay window. A stunning ornamental archway w/ decorative fretwork connects the liv & din rms, while extensive wall mouldings add elegance to the formal dining space. The updated kitchen offers custom cabinetry, exposed brick, quality appliances, and a versatile built-in enclosure currently used as a dog retreat that could easily function as a desk or additional storage. A stylish powder room completes the level. The second floor offers 3 bedrooms and an updated 4-piece bathroom featuring a clawfoot tub. The spacious primary bedroom includes a front bay window and bonus dressing area. The finished third floor provides incredible flexibility as a 4th bedroom, office, studio, recreation room, or family retreat, with impressive ceiling height and abundant character. Outdoor features include a multi-level deck, terrace area, mature landscaping, detached storage shed, and a private backyard setting ideal for entertaining. Notable updates include furnace ('14), central air ('14), windows ('16), electrical panel ('23), wiring ('23), roof shingles ('26), and refrigerator, stove, washer & dryer ('25). Ideally located near downtown Hamilton, GO Transit, St. Joseph's Hospital, trail systems, restaurants, cafés, parks, shopping, and major commuter routes. A rare opportunity to own a beautifully updated character home in one of the city's most vibrant neighbourhoods. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:39:56.370040+00:00"
+"Directions": "From John S/Augusta, E on Augusta, S on Catharine S"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1900653"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-25T21:11:01Z"
+"PhotosCount": 42
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:11:01Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "CATHARINE"
+"StreetNumber": "135"
+"StreetSuffix": "Street"
+"SubdivisionName": "142 - Corktown"
+"TaxAnnualAmount": "4177.82"
+"VirtualTourURLUnbranded": "https://youtu.be/vnsVvAhr_7E"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29954924/135-catharine-street-s-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1793
+"OriginalEntryTimestamp": "2026-06-25T21:11:01.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1217131"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954924')"
+"ID": "1563999"
}
]
+success: true
+page_size: 9
+page_count: 52
+count: 467
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]