array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29936149 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: "1554335"
+post_author: 1
+"ListingKey": "29936149"
+"ListingId": "40840794"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T19:00:14Z"
+"RFModificationTimestamp": "2026-06-22T19:04:53Z"
+"ListPrice": 599999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2120.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T4G2"
+"UnparsedAddress": "314 UPPER KENILWORTH Avenue, Hamilton, Ontario L8T4G2"
+"Coordinates": array:2 [
0 => -79.8195278
1 => 43.2227008
]
+"Latitude": 43.2227008
+"Longitude": -79.8195278
+"YearBuilt": 1962
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this solid raised ranch presenting exceptional potential for families, investors or those looking to create a two-family home. The separate side entrance and large basement windows provide an ideal layout for an in-law suite or multi-generational living. This well-built home features hardwood floors, a bright kitchen with a skylight, updated windows, shingles, furnace and central air conditioning. Attractive flagstone accents add curb appeal to the exterior. One of the property's standout features is the impressive detached 28' x 25' three-car garage with double garage doors-perfect for hobbyist, mechanics, contractors or additional storage. Ideally located within walking distance of the Margate Stairs, Mountain Brow Walkway, Rail Trail and Bruce Trail, this home offers easy access to some of Hamilton's most popular outdoor recreation. You'll also enjoy close proximity to churches, schools and Mohawk Sports Park. An excellent opportunity for handymen, renovators or buyers looking to add their own personal touches. This home has great bones and endless potential. Property is being sold in as is condition (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Wet Bar"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T17:24:33.294141+00:00"
+"Directions": "Go South on Upper Kenilworth from Fennell and it is the first house on the West side of the street"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524553"
+"ListOfficeKey": "289686"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wet bar"
1 => "Skylight"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T15:51:38Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T18:51:49Z"
+"Stories": "1.0"
+"StreetName": "UPPER KENILWORTH"
+"StreetNumber": "314"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "253 - Huntington"
+"TaxAnnualAmount": "5170.02"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1665546610"
"RoomType" => "Workshop"
"ListingId" => "40840794"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.08Z"
]
1 => array:11 [
"RoomKey" => "1665546611"
"RoomType" => "Laundry room"
"ListingId" => "40840794"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.08Z"
]
2 => array:11 [
"RoomKey" => "1665546612"
"RoomType" => "3pc Bathroom"
"ListingId" => "40840794"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.09Z"
]
3 => array:11 [
"RoomKey" => "1665546613"
"RoomType" => "Recreation room"
"ListingId" => "40840794"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 16'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.09Z"
]
4 => array:11 [
"RoomKey" => "1665546614"
"RoomType" => "Bedroom"
"ListingId" => "40840794"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.09Z"
]
5 => array:11 [
"RoomKey" => "1665546615"
"RoomType" => "Cold room"
"ListingId" => "40840794"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 3'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.1Z"
]
6 => array:11 [
"RoomKey" => "1665546616"
"RoomType" => "Bedroom"
"ListingId" => "40840794"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.1Z"
]
7 => array:11 [
"RoomKey" => "1665546617"
"RoomType" => "Bedroom"
"ListingId" => "40840794"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "8'8'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.11Z"
]
8 => array:11 [
"RoomKey" => "1665546618"
"RoomType" => "Primary Bedroom"
"ListingId" => "40840794"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.11Z"
]
9 => array:11 [
"RoomKey" => "1665546619"
"RoomType" => "4pc Bathroom"
"ListingId" => "40840794"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.12Z"
]
10 => array:11 [
"RoomKey" => "1665546620"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "40840794"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 16'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.12Z"
]
11 => array:11 [
"RoomKey" => "1665546621"
"RoomType" => "Living room"
"ListingId" => "40840794"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29936149"
"RoomLength" => null
"RoomDimensions" => "13'0'' x 18'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-22T18:51:49.13Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29936149/314-upper-kenilworth-avenue-hamilton"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524554"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55098"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1060
+"BelowGradeFinishedArea": 1060
+"OriginalEntryTimestamp": "2026-06-22T15:51:38.13Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063702"
+"ListOfficeNationalAssociationId": "1384827"
+"CoListAgentNationalAssociationId": "1063632"
+"CoListOfficeNationalAssociationId": "1003698"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29936149_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/7579f61852807f5c15424a6e8fa1cf11.webp"
"MediaSize" => 194332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-7579f61852807f5c15424a6e8fa1cf11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29936149_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/eece9b2b8295d7e7124352673dd3d832.webp"
"MediaSize" => 182048
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-eece9b2b8295d7e7124352673dd3d832.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29936149_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/0f46395fed17ae14e907a216cd45041e.webp"
"MediaSize" => 178187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-0f46395fed17ae14e907a216cd45041e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29936149_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/98e0a9e683d99e3874176aad887dc683.webp"
"MediaSize" => 178871
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-98e0a9e683d99e3874176aad887dc683.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29936149_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/1858c2f051eae5b00d5c225891bde8b1.webp"
"MediaSize" => 166059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-1858c2f051eae5b00d5c225891bde8b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29936149_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/e3831c4905bd58f17c98d65bbb71821c.webp"
"MediaSize" => 115987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-e3831c4905bd58f17c98d65bbb71821c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29936149_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/7526e047226ee1c8a966be48ea4e64d6.webp"
"MediaSize" => 101950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-7526e047226ee1c8a966be48ea4e64d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29936149_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/540efd7fe162fff506ad7534974dd823.webp"
"MediaSize" => 82516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-540efd7fe162fff506ad7534974dd823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29936149_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/1e48a06ca87e486a6acb88fd983ece0f.webp"
"MediaSize" => 91690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-1e48a06ca87e486a6acb88fd983ece0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29936149_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/09d4226a6cab134196f172105bd5f375.webp"
"MediaSize" => 136290
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-09d4226a6cab134196f172105bd5f375.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29936149_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/b251756880f4fe0da4beae2189d4473f.webp"
"MediaSize" => 131809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-b251756880f4fe0da4beae2189d4473f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29936149_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/66f14f5d06d2c570d0fefa08c8a0eb42.webp"
"MediaSize" => 103109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-66f14f5d06d2c570d0fefa08c8a0eb42.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29936149_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/1d8b8030381e1fb268998654f8d54791.webp"
"MediaSize" => 73708
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-1d8b8030381e1fb268998654f8d54791.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29936149_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/3d7df723b14cb4dc15642b20011e571e.webp"
"MediaSize" => 100782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-3d7df723b14cb4dc15642b20011e571e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29936149_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/bd03689aeb30a372570e976ba8fdd73a.webp"
"MediaSize" => 113151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-bd03689aeb30a372570e976ba8fdd73a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29936149_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/7b3e20dbd11258915243ebd281acc650.webp"
"MediaSize" => 114040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-7b3e20dbd11258915243ebd281acc650.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29936149_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/93fbac7f3a6d39c70adac5aee04b7da8.webp"
"MediaSize" => 65586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-93fbac7f3a6d39c70adac5aee04b7da8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29936149_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/13ae5acca73c68c224635680ea803a4c.webp"
"MediaSize" => 157643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-13ae5acca73c68c224635680ea803a4c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29936149_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/9f5216144902b7d696dbcba651c63bf8.webp"
"MediaSize" => 141211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-9f5216144902b7d696dbcba651c63bf8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29936149_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/2ec318923cf300319c97854903016e35.webp"
"MediaSize" => 125457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-2ec318923cf300319c97854903016e35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29936149_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/6f684a3c867d4aa785bc944b6e2c7c23.webp"
"MediaSize" => 127822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-6f684a3c867d4aa785bc944b6e2c7c23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29936149_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/3ef04a1afd4fe6dc410dbc09222663d7.webp"
"MediaSize" => 110637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-3ef04a1afd4fe6dc410dbc09222663d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29936149_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/2ec5c570fa71510894f10abd4975f27e.webp"
"MediaSize" => 88997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-2ec5c570fa71510894f10abd4975f27e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29936149_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/683a958e4378d5cb468efd34d1f7ba79.webp"
"MediaSize" => 52162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-683a958e4378d5cb468efd34d1f7ba79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29936149_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/88fa7484f150d97e5552a503910b9d92.webp"
"MediaSize" => 119605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-88fa7484f150d97e5552a503910b9d92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29936149_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/27d94e2f604a9787eef0516e29f7fb75.webp"
"MediaSize" => 93601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-27d94e2f604a9787eef0516e29f7fb75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29936149_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/a86e334a72a4aaf8d68cb148a0a07235.webp"
"MediaSize" => 217082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-a86e334a72a4aaf8d68cb148a0a07235.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29936149_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/8fbb87532d5b79470807ee10a7c724bb.webp"
"MediaSize" => 124281
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-8fbb87532d5b79470807ee10a7c724bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29936149_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/b7f3514300c319fee22a4d3f39fb4b13.webp"
"MediaSize" => 98943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-b7f3514300c319fee22a4d3f39fb4b13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29936149_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/d551c78967ce24f539990cababf672e3.webp"
"MediaSize" => 103937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-d551c78967ce24f539990cababf672e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29936149_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/c0825056ce7792f0070126280a7a6db9.webp"
"MediaSize" => 219556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-c0825056ce7792f0070126280a7a6db9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29936149_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/40977dfe4e4979b44b2d6b9e617ba1c3.webp"
"MediaSize" => 228089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-40977dfe4e4979b44b2d6b9e617ba1c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29936149_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/7c1fb4865df7cac54404bcf147642b2d.webp"
"MediaSize" => 227256
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-7c1fb4865df7cac54404bcf147642b2d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29936149_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/dacff676d47fe00eec0075e12469ff8d.webp"
"MediaSize" => 216469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-dacff676d47fe00eec0075e12469ff8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29936149_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/e4c1576b0ad931ce3d4fbbd2707dd625.webp"
"MediaSize" => 220545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-e4c1576b0ad931ce3d4fbbd2707dd625.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29936149_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936149/572b69a7aff849f15f27432e7325e401.webp"
"MediaSize" => 95588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936149/thumbnail-572b69a7aff849f15f27432e7325e401.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40840794"
"ResourceRecordKey" => "29936149"
"ModificationTimestamp" => "2026-06-22T15:51:38.14Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936149')"
+"ID": "1554335"
}
]
+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 289686" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24814
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1524553" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24901
+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 '29936149'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25212
+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 '29936149'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25230
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25228
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31606988"
+"ListingKey": "29936149"
+"ListingId": "40840794"
+"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-22T21:00:58Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31606988')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29936149' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8195278 43.2227008)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25303
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25277
+post_id: "1553675"
+post_author: 1
+"ListingKey": "29936189"
+"ListingId": "X13473750"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T16:05:10Z"
+"RFModificationTimestamp": "2026-06-22T17:19:57Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lisgar)"
+"PostalCode": "L8T2S9"
+"UnparsedAddress": "2 RIDEAU CRESCENT, Hamilton (Lisgar), Ontario L8T2S9"
+"Coordinates": array:2 [
0 => -79.830748
1 => 43.215368
]
+"Latitude": 43.215368
+"Longitude": -79.830748
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 2 Rideau Crescent, a charming three-level backsplit situated on a generous corner lot in Hamilton's desirable Lisgar community. This well-maintained home offers 3+3 bedrooms, two full Renovated bathrooms, a bright and inviting main living area, and a spacious kitchen ideal for everyday living. The lower level features a cozy family room, three additional bedrooms, and a separate entrance, providing excellent in-law or investment potential. Outside, enjoy the convenience of a detached single-car garage, parking for up to six vehicles, and a large private yard. Ideally located just steps from Lisgar Park, schools, shopping, and transit, this home offers both comfort and convenience. Whether you're a growing family or an investor. 2 Rideau Crescent presents an outstanding opportunity. Notable upgrades include a newer furnace, select updated windows, and a tankless water heater. Don't miss this gem on the Hamilton Mountain! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T17:19:44.351550+00:00"
+"Directions": "Mohawk Rd/ Moxley Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1420329"
+"ListOfficeKey": "300866"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 101.8 FT ; 100.21 x 53.79 ft x 102.00 x 35.75 ft"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T15:55:57Z"
+"PhotosCount": 17
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T15:55:57Z"
+"StreetName": "Rideau"
+"StreetNumber": "2"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4490"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1665421385"
"RoomType" => "Living room"
"ListingId" => "X13473750"
"RoomLevel" => "Main level"
"RoomWidth" => 1.13
"ListingKey" => "29936189"
"RoomLength" => 1.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.82Z"
]
1 => array:11 [
"RoomKey" => "1665421386"
"RoomType" => "Bedroom"
"ListingId" => "X13473750"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.82
"ListingKey" => "29936189"
"RoomLength" => 0.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.82Z"
]
2 => array:11 [
"RoomKey" => "1665421387"
"RoomType" => "Dining room"
"ListingId" => "X13473750"
"RoomLevel" => "Main level"
"RoomWidth" => 1.13
"ListingKey" => "29936189"
"RoomLength" => 1.86
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.83Z"
]
3 => array:11 [
"RoomKey" => "1665421388"
"RoomType" => "Kitchen"
"ListingId" => "X13473750"
"RoomLevel" => "Main level"
"RoomWidth" => 0.67
"ListingKey" => "29936189"
"RoomLength" => 1.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.84Z"
]
4 => array:11 [
"RoomKey" => "1665421389"
"RoomType" => "Bedroom"
"ListingId" => "X13473750"
"RoomLevel" => "Main level"
"RoomWidth" => 1.07
"ListingKey" => "29936189"
"RoomLength" => 1.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.85Z"
]
5 => array:11 [
"RoomKey" => "1665421390"
"RoomType" => "Bedroom"
"ListingId" => "X13473750"
"RoomLevel" => "Main level"
"RoomWidth" => 0.82
"ListingKey" => "29936189"
"RoomLength" => 1.16
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.85Z"
]
6 => array:11 [
"RoomKey" => "1665421391"
"RoomType" => "Bedroom"
"ListingId" => "X13473750"
"RoomLevel" => "Main level"
"RoomWidth" => 0.86
"ListingKey" => "29936189"
"RoomLength" => 0.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.85Z"
]
7 => array:11 [
"RoomKey" => "1665421392"
"RoomType" => "Kitchen"
"ListingId" => "X13473750"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.8
"ListingKey" => "29936189"
"RoomLength" => 1.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.85Z"
]
8 => array:11 [
"RoomKey" => "1665421393"
"RoomType" => "Living room"
"ListingId" => "X13473750"
"RoomLevel" => "Lower level"
"RoomWidth" => 1.07
"ListingKey" => "29936189"
"RoomLength" => 1.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.85Z"
]
9 => array:11 [
"RoomKey" => "1665421394"
"RoomType" => "Bedroom"
"ListingId" => "X13473750"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.85
"ListingKey" => "29936189"
"RoomLength" => 1.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.85Z"
]
10 => array:11 [
"RoomKey" => "1665421395"
"RoomType" => "Bedroom"
"ListingId" => "X13473750"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.8
"ListingKey" => "29936189"
"RoomLength" => 1.13
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-22T15:55:57.85Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Lisgar"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29936189/2-rideau-crescent-hamilton-lisgar-lisgar"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-22T15:55:57.78Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1047401"
+"ListOfficeNationalAssociationId": "1494808"
+"Media": array:17 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29936189_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/52b25d10d4d5984f7f606d51631e8f9c.webp"
"MediaSize" => 315747
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-52b25d10d4d5984f7f606d51631e8f9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29936189_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/236c443b472e5414b3b2d8b94e8f80fb.webp"
"MediaSize" => 247716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-236c443b472e5414b3b2d8b94e8f80fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29936189_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/da60e1083ab7a71272b256e5310babc0.webp"
"MediaSize" => 365869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-da60e1083ab7a71272b256e5310babc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29936189_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/caca28d939ba46af9b42c87e92f55f8f.webp"
"MediaSize" => 205552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-caca28d939ba46af9b42c87e92f55f8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29936189_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/86a1c6dcfd5b9f0bb23fbaa33efd4cc6.webp"
"MediaSize" => 163926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-86a1c6dcfd5b9f0bb23fbaa33efd4cc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29936189_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/ef190ed1898c64f65bb991635beaa217.webp"
"MediaSize" => 165398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-ef190ed1898c64f65bb991635beaa217.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29936189_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/23231cc0286a7b7943d687f4cf1bd996.webp"
"MediaSize" => 152220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-23231cc0286a7b7943d687f4cf1bd996.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29936189_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/b548a8395adc7699adef734f8627d5de.webp"
"MediaSize" => 159527
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-b548a8395adc7699adef734f8627d5de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29936189_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/71207c290c24d7958af109c69335d818.webp"
"MediaSize" => 153302
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-71207c290c24d7958af109c69335d818.webp"
"ResourceName" => "Property"
…6
]
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('29936189')"
+"ID": "1553675"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1551961"
+post_author: 1
+"ListingKey": "29933401"
+"ListingId": "X13471262"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T18:25:09Z"
+"RFModificationTimestamp": "2026-06-20T19:34:39Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Berrisfield)"
+"PostalCode": "L8T3N6"
+"UnparsedAddress": "31 SYCAMORE STREET, Hamilton (Berrisfield), Ontario L8T3N6"
+"Coordinates": array:2 [
0 => -79.8374
1 => 43.213176
]
+"Latitude": 43.213176
+"Longitude": -79.8374
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this well-maintained 3-bedroom bungalow situated on a generous 50 x 100 ft lot in a convenient, family-friendly neighbourhood. Featuring original hardwood flooring throughout the living room and bedrooms, this home offers warmth, character, and plenty of potential. The detached garage and private driveway provide parking for up to 4 vehicles. The finished basement, complete with a separate side entrance, offers excellent flexibility for multi-generational living, an in-law suite, or potential secondary unit. The lower level features a full kitchen, a spacious rec room with a fireplace, 3 piece bathroom, and an additional room ideal as a bedroom, home office, or guest space. Additional features include 100-amp electrical service, a water filtration system, dehumidifier, updated windows (approximately 15 years old), and a furnace & hot water tank (2025). Ideally located close to the Lincoln M. Alexander Parkway, schools, parks, shopping, public transit, and everyday amenities, this home is perfect for families, investors, or anyone seeking versatile living space in a great location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Oven"
6 => "Dryer"
7 => "Freezer"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T19:34:36.370407+00:00"
+"Directions": "Upper Ottawa/ Larch"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2057763"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T18:18:53Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T18:18:53Z"
+"Stories": "1.0"
+"StreetName": "Sycamore"
+"StreetNumber": "31"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4718.42"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/31_sycamore_st_hamilton_on"
+"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": "Berrisfield"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29933401/31-sycamore-street-hamilton-berrisfield-berrisfield"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-06-20T18:18:53.16Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1332943"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29933401')"
+"ID": "1551961"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1549846"
+post_author: 1
+"ListingKey": "29931023"
+"ListingId": "X13469052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T21:10:05Z"
+"RFModificationTimestamp": "2026-06-19T22:48:15Z"
+"ListPrice": 679850.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Delta)"
+"PostalCode": "L8K2M9"
+"UnparsedAddress": "101 HOUGHTON AVENUE S, Hamilton (Delta), Ontario L8K2M9"
+"Coordinates": array:2 [
0 => -79.814722
1 => 43.238382
]
+"Latitude": 43.238382
+"Longitude": -79.814722
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A fresh opportunity to own this beautifully renovated home in a sought-after, family-friendly Hamilton neighbourhood! Offering nearly 2,000 sq ft of finished living space, 101 Houghton Avenue South blends stylish updates, quality craftsmanship, and an ideal location just steps to A.M. Cunningham Elementary School, with Gage Park and the vibrant shops, restaurants, and boutiques of Ottawa Street North just a short stroll away. The inviting main floor features a new front porch, enclosed entry with leaded glass windows, spacious foyer, wide-plank flooring, pot lighting, and a bright open living room with picture window, shiplap feature wall, and linear fireplace. The dining area offers built-in cabinetry, a stained glass window, and walkout to a fully finished four-season sunroom overlooking the private rear yard. The updated open-concept kitchen is designed for everyday living and entertaining, featuring modern cabinetry, quartz counters, ceramic backsplash, stainless steel appliances, and a peninsula with seating. Upstairs offers two generous bedrooms and a 4-piece bath with convenient laundry. The finished lower level provides excellent additional living space with a rec room, bedroom, and 3-piece bath-ideal for guests, teens, or extended family. Private side drive leads to a detached garage with hydro and automatic opener. Extensive updates include flooring, trim, pot lights, fresh paint, electrical, plumbing, vinyl siding on house and garage, appliances, furnace, central air, 100-amp breakers, and professionally waterproofed basement with sump. Move-in ready, stylishly finished, and now offered at a new price-don't miss it! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Garage door opener"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T22:48:03.925928+00:00"
+"Directions": "Cross Streets: King St E. ** Directions: Between Maple Av & Central Av."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2166044"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "32 x 110.2 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T20:55:56Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T20:55:56Z"
+"Stories": "1.5"
+"StreetDirSuffix": "South"
+"StreetName": "Houghton"
+"StreetNumber": "101"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3883"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=8sLUDBNRZG8"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Delta"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29931023/101-houghton-avenue-s-hamilton-delta-delta"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2026-06-19T20:55:56.46Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1416991"
+"ListOfficeNationalAssociationId": "1344707"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931023')"
+"ID": "1549846"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1549407"
+post_author: 1
+"ListingKey": "29930555"
+"ListingId": "40841553"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T20:10:02Z"
+"RFModificationTimestamp": "2026-06-19T21:33:38Z"
+"ListPrice": 679850.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1775.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K2M9"
+"UnparsedAddress": "101 HOUGHTON Avenue S, Hamilton, Ontario L8K2M9"
+"Coordinates": array:2 [
0 => -79.8149882
1 => 43.2384698
]
+"Latitude": 43.2384698
+"Longitude": -79.8149882
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "A fresh opportunity to own this beautifully renovated home in a sought-after, family-friendly Hamilton neighbourhood! Offering nearly 2,000 sq ft of finished living space, 101 Houghton Avenue South blends stylish updates, quality craftsmanship, and an ideal location just steps to A.M. Cunningham Elementary School, with Gage Park and the vibrant shops, restaurants, and boutiques of Ottawa Street North just a short stroll away. The inviting main floor features a new front porch, enclosed entry with leaded glass windows, spacious foyer, wide-plank flooring, pot lighting, and a bright open living room with picture window, shiplap feature wall, and linear fireplace. The dining area offers built-in cabinetry, a stained glass window, and walkout to a fully finished four-season sunroom overlooking the private rear yard. The updated open-concept kitchen is designed for everyday living and entertaining, featuring modern cabinetry, quartz counters, ceramic backsplash, stainless steel appliances, and a peninsula with seating. Upstairs offers two generous bedrooms and a 4-piece bath with convenient laundry. The finished lower level provides excellent additional living space with a rec room, bedroom, and 3-piece bath-ideal for guests, teens, or extended family. Private side drive leads to a detached garage with hydro and automatic opener. Extensive updates include flooring, trim, pot lights, fresh paint, electrical, plumbing, vinyl siding on house and garage, appliances, furnace, central air, 100-amp breakers, and professionally waterproofed basement with sump. Move-in ready, stylishly finished, and now offered at a new price-don't miss it! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Garage door opener"
6 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:33:27.002869+00:00"
+"Directions": "Between Maple Ave and Central Ave"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524687"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T19:52:40Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T19:52:40Z"
+"Stories": "1.5"
+"StreetDirSuffix": "South"
+"StreetName": "HOUGHTON"
+"StreetNumber": "101"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "222 - Delta"
+"TaxAnnualAmount": "3883"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=8sLUDBNRZG8"
+"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/29930555/101-houghton-avenue-s-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1628810"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1138
+"BelowGradeFinishedArea": 637
+"OriginalEntryTimestamp": "2026-06-19T19:51:10.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063164"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1161564"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930555')"
+"ID": "1549407"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25278
+post_id: "1548496"
+post_author: 1
+"ListingKey": "29929790"
+"ListingId": "40839924"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T15:45:12Z"
+"RFModificationTimestamp": "2026-06-20T16:03:18Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.11
+"LivingArea": 1181.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T3N6"
+"UnparsedAddress": "31 SYCAMORE Street, Hamilton, Ontario L8T3N6"
+"Coordinates": array:2 [
0 => -79.8374365
1 => 43.2131962
]
+"Latitude": 43.2131962
+"Longitude": -79.8374365
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this well-maintained 3-bedroom bungalow situated on a generous 50 x 100 ft lot in a convenient, family-friendly neighbourhood. Featuring original hardwood flooring throughout the living room and bedrooms, this home offers warmth, character, and plenty of potential. The detached garage and private driveway provide parking for up to 4 vehicles. The finished basement, complete with a separate side entrance, offers excellent flexibility for multi-generational living, an in-law suite, or potential secondary unit. The lower level features a full kitchen, a spacious rec room with a fireplace, 3 piece bathroom, and an additional room ideal as a bedroom, home office, or guest space. Additional features include 100-amp electrical service, a water filtration system, dehumidifier, updated windows (approximately 15 years old), and furnance and hot water tank (2025). Ideally located close to the Lincoln M. Alexander Parkway, schools, parks, shopping, public transit, and everyday amenities, this home is perfect for families, investors, or anyone seeking versatile living space in a great location. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Range - Gas"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Freezer"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T19:47:10.049824+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525447"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.11"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T18:33:18Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T15:39:46Z"
+"Stories": "1.0"
+"StreetName": "SYCAMORE"
+"StreetNumber": "31"
+"StreetSuffix": "Street"
+"SubdivisionName": "260 - Berrisfield"
+"TaxAnnualAmount": "4718.42"
+"VirtualTourURLUnbranded": "https://youriguide.com/31_sycamore_st_hamilton_on"
+"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/29929790/31-sycamore-street-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "c"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1181
+"OriginalEntryTimestamp": "2026-06-19T18:33:18.24Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1102258"
+"ListOfficeNationalAssociationId": "1344652"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929790')"
+"ID": "1548496"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25273
+post_id: "1539922"
+post_author: 1
+"ListingKey": "29917454"
+"ListingId": "40840814"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T16:20:04Z"
+"RFModificationTimestamp": "2026-06-18T16:37:45Z"
+"ListPrice": 674900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 1918.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8K2R1"
+"UnparsedAddress": "148 HUXLEY Avenue S, Hamilton, Ontario L8K2R1"
+"Coordinates": array:2 [
0 => -79.8138917
1 => 43.2366261
]
+"Latitude": 43.2366261
+"Longitude": -79.8138917
+"YearBuilt": 1945
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to a truly unique opportunity in Hamilton’s charming east end. This versatile property features two fully separate living spaces, making it an ideal fit for growing families, multi-generational living, or savvy buyers looking to offset their mortgage. At the front, the bright and welcoming 1.5-storey home offers 4 bedrooms and 2 full bathrooms, with a functional layout designed for everyday family life. You’ll love the natural light, generous storage throughout, and the high, dry basement—complete with a separate laundry room, partially finished kids’ playroom, and a roughed-in 3-piece bathroom ready for your finishing touches. Tucked privately at the rear, the self-contained 1+1 bedroom unit provides incredible flexibility. With its own side entrance, this space includes a full kitchen, bedroom, and bathroom on the main level, plus a cozy lower level featuring a living room, additional bedroom or office, and its own laundry. Whether you’re looking to create space for extended family, generate rental income, or step into homeownership with added financial support, this property offers options that are hard to find. For buyers seeking a larger family home, the layout also lends itself well to conversion back to a single-family residence, creating even more possibilities for future use. Set in a well-kept, established neighbourhood close to parks, schools, and everyday amenities, this is a home that combines character, flexibility, and long-term value. (id:62650)"
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T19:17:47.161683+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Other"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2005282"
+"ListOfficeKey": "289424"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"PhotosChangeTimestamp": "2026-06-17T18:40:13Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T16:11:16Z"
+"Stories": "1.5"
+"StreetDirSuffix": "South"
+"StreetName": "HUXLEY"
+"StreetNumber": "148"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "222 - Delta"
+"TaxAnnualAmount": "5295"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
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]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29917454/148-huxley-avenue-s-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 33.0
+"AboveGradeFinishedArea": 1918
+"OriginalEntryTimestamp": "2026-06-17T18:40:12.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1287615"
+"ListOfficeNationalAssociationId": "1377637"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917454')"
+"ID": "1539922"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1537398"
+post_author: 1
+"ListingKey": "29913674"
+"ListingId": "X13453782"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T00:55:08Z"
+"RFModificationTimestamp": "2026-06-17T01:32:21Z"
+"ListPrice": 734900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Huntington)"
+"PostalCode": "L8T3Z8"
+"UnparsedAddress": "9 KINGSLEA DRIVE, Hamilton (Huntington), Ontario L8T3Z8"
+"Coordinates": array:2 [
0 => -79.825086
1 => 43.223258
]
+"Latitude": 43.223258
+"Longitude": -79.825086
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set in one of Hamilton Mountain's most sought-after family-friendly neighbourhoods, 9 Kingsley Drive offers the ease of bungalow living, thoughtful updates throughout, and the flexibility today's families are looking for. The bright, open-concept main floor is designed for everyday living and entertaining, featuring a spacious living room, dining area, and updated kitchen that flow seamlessly together. Updated flooring, modern lighting, pot lights, renovated bathrooms, quality finishes, and an abundance of natural light create a warm and inviting space where there is truly nothing to do but move in, place your furniture, and enjoy. The main level is complemented by a beautifully updated spa-inspired 4-piece bathroom and comfortable living spaces that feel both functional and welcoming. A separate rear entrance leads to the fully finished lower level, offering outstanding flexibility for multi-generational living, an in-law suite, a teenage retreat, or extended family accommodations. The basement features a second kitchen, spacious living area, bedroom, updated 3-piece bathroom with oversized shower, laundry area, storage space, and utility room. Outside, you'll appreciate the home's attractive setback from the street, a double-wide concrete driveway with ample parking, and mature landscaping that enhances the curb appeal. The private backyard is lush, green, and ready for summer barbecues, family gatherings, children, pets, and quiet evenings outdoors. Located close to the Mountain Brow, parks, schools, shopping, transit, and everyday conveniences, this move-in-ready bungalow combines location, updates, and versatility in a package that's increasingly hard to find. Whether you're upsizing, downsizing, accommodating family, or simply looking for a turnkey home in an exceptional neighbourhood, 9 Kingsley Drive is ready for its next chapter. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Window Coverings"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:7 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk-up"
4 => "N/A"
5 => "N/A"
6 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T01:32:12.250828+00:00"
+"Directions": "Cross Streets: Broker Drive. ** Directions: Kingslea Dr. between High St. and Broker Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2040128"
+"ListOfficeKey": "280718"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "52.5 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T00:48:16Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T00:48:15Z"
+"Stories": "1.0"
+"StreetName": "Kingslea"
+"StreetNumber": "9"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4507"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://rainforest-media.aryeo.com/videos/019ec882-f666-7115-b27d-36793d6dc31b"
+"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": "Huntington"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29913674/9-kingslea-drive-hamilton-huntington-huntington"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 52.6
+"OriginalEntryTimestamp": "2026-06-17T00:48:15.92Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1316163"
+"ListOfficeNationalAssociationId": "1316852"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913674')"
+"ID": "1537398"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1537399"
+post_author: 1
+"ListingKey": "29913215"
+"ListingId": "40840533"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T00:40:08Z"
+"RFModificationTimestamp": "2026-06-17T00:41:50Z"
+"ListPrice": 734900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.121
+"LivingArea": 1793.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T3Z8"
+"UnparsedAddress": "9 KINGSLEA Drive, Hamilton, Ontario L8T3Z8"
+"Coordinates": array:2 [
0 => -79.8249603
1 => 43.2231782
]
+"Latitude": 43.2231782
+"Longitude": -79.8249603
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set in one of Hamilton Mountain’s most sought-after family-friendly neighbourhoods, 9 Kingsley Drive offers the ease of bungalow living, thoughtful updates throughout, and the flexibility today’s families are looking for. The bright, open-concept main floor is designed for everyday living and entertaining, featuring a spacious living room, dining area, and updated kitchen that flow seamlessly together. Updated flooring, modern lighting, pot lights, renovated bathrooms, quality finishes, and an abundance of natural light create a warm and inviting space where there is truly nothing to do but move in, place your furniture, and enjoy. The main level is complemented by a beautifully updated spa-inspired 4-piece bathroom and comfortable living spaces that feel both functional and welcoming. A separate rear entrance leads to the fully finished lower level, offering outstanding flexibility for multi-generational living, an in-law suite, a teenage retreat, or extended family accommodations. The basement features a second kitchen, spacious living area, bedroom, updated 3-piece bathroom with oversized shower, laundry area, storage space, and utility room. Outside, you’ll appreciate the home’s attractive setback from the street, a double-wide concrete driveway with ample parking, and mature landscaping that enhances the curb appeal. The private backyard is lush, green, and ready for summer barbecues, family gatherings, children, pets, and quiet evenings outdoors. Located close to the Mountain Brow, parks, schools, shopping, transit, and everyday conveniences, this move-in-ready bungalow combines location, updates, and versatility in a package that’s increasingly hard to find. Whether you’re upsizing, downsizing, accommodating family, or simply looking for a turnkey home in an exceptional neighbourhood, 9 Kingsley Drive is ready for its next chapter. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T00:31:53.210803+00:00"
+"Directions": "Kingslea Dr. between High St. and Broker Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1533669"
+"ListOfficeKey": "229734"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "In-Law Suite"
2 => "Private Yard"
]
+"LotSizeDimensions": "0.121"
+"PhotosChangeTimestamp": "2026-06-16T22:51:18Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T00:32:01Z"
+"Stories": "1.0"
+"StreetName": "KINGSLEA"
+"StreetNumber": "9"
+"StreetSuffix": "Drive"
+"SubdivisionName": "253 - Huntington"
+"TaxAnnualAmount": "4507"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://rainforest-media.aryeo.com/videos/019ec882-f666-7115-b27d-36793d6dc31b"
+"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/29913215/9-kingslea-drive-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 52.0
+"AboveGradeFinishedArea": 900
+"BelowGradeFinishedArea": 893
+"OriginalEntryTimestamp": "2026-06-16T22:51:17.89Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1143306"
+"ListOfficeNationalAssociationId": "1201977"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29913215')"
+"ID": "1537399"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25301
+post_id: "1534811"
+post_author: 1
+"ListingKey": "29910110"
+"ListingId": "40840161"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T17:40:46Z"
+"RFModificationTimestamp": "2026-06-22T17:53:16Z"
+"ListPrice": 1199850.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.21
+"LivingArea": 2901.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T1C5"
+"UnparsedAddress": "99 ELMHURST Drive, Hamilton, Ontario L8T1C5"
+"Coordinates": array:2 [
0 => -79.8172542
1 => 43.2268279
]
+"Latitude": 43.2268279
+"Longitude": -79.8172542
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 99 Elmhurst Drive, a rare opportunity in Hamilton’s highly sought-after Sherwood neighbourhood. Set on an impressive 70’ x 127’ lot, this lovingly maintained and meticulously cared-for 4.5-level side split offers gorgeous curb appeal, a double car garage, and a double-wide driveway with parking for four vehicles. Step through the beautiful leaded glass double doors with matching sidelights into a spacious, and large welcoming foyer. The main level features a warm and inviting family room with beamed ceilings, a cozy wood-burning fireplace, patio doors to a bright three-season sunroom, and a convenient two-piece bath. The sunroom is surrounded by windows and offers sliding door access to the private rear yard. A few steps up, you’ll find a formal living room and dining room with hardwood floors, plus an eat-in kitchen with quartz counters overlooking the family room. The bedroom level boasts four bedrooms, including a generous primary bedroom with his-and-hers closets, plus a four-piece bath with Jacuzzi tub and ensuite privilege. The lower level offers even more living space with a large recreation room featuring a wood-burning fireplace with Angel Stone mantel, a three-piece bath, and a spacious laundry room. The basement level includes a workshop, utility room, and large crawl space ideal for seasonal storage. Enjoy your own private backyard oasis complete with a large 20’ x 40’ inground pool and plenty of space to entertain family and friends. Located just one block from the scenic Mountain Brow Trail, a paved multi-use route along the Niagara Escarpment offering breathtaking views of the city, Lake Ontario, and beyond. Also nearby are the Escarpment Rail Trail, Kings Forest Golf Club, Mohawk Sports Park, parks, recreation centres, and quick access to the lower mountain. Updates include roof shingles in 2019, furnace in 2014, and 200 amp electrical service. A truly special home in one of Hamilton’s most desirable neighbourhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Freezer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T17:25:57.921593+00:00"
+"Directions": "Mountain Brow Blvd to Margate Av, one block north to Elmhurst Dr"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524687"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Paved driveway"
]
+"LotSizeDimensions": "0.21"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T17:12:24Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T17:12:24Z"
+"Stories": "3.0"
+"StreetName": "ELMHURST"
+"StreetNumber": "99"
+"StreetSuffix": "Drive"
+"SubdivisionName": "251 - Sherwood"
+"TaxAnnualAmount": "7895.17"
+"VirtualTourURLUnbranded": "https://youtu.be/zzh8qG3cPcw"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:20 [
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]
18 => array:11 [ …11]
19 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29910110/99-elmhurst-drive-hamilton"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1628810"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 2252
+"BelowGradeFinishedArea": 649
+"OriginalEntryTimestamp": "2026-06-16T16:33:19.24Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063164"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1161564"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29910110')"
+"ID": "1534811"
}
]
+success: true
+page_size: 9
+page_count: 18
+count: 156
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
]