array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29936189 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: "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"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29936189_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/b23006c85cd7c2e620836a7ddce6bd0a.webp"
"MediaSize" => 164337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-b23006c85cd7c2e620836a7ddce6bd0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29936189_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/a8f5e76737d4cc1abec1d2ad5f8193b0.webp"
"MediaSize" => 180955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-a8f5e76737d4cc1abec1d2ad5f8193b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29936189_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/e941819ccc86b9fd2ce0758c62d11502.webp"
"MediaSize" => 199968
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-e941819ccc86b9fd2ce0758c62d11502.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29936189_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/1f465b383f3d7395eb598dc6d79cb972.webp"
"MediaSize" => 51687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-1f465b383f3d7395eb598dc6d79cb972.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29936189_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/c302f346d5d12e5f4e89098e3d2a7b85.webp"
"MediaSize" => 122746
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-c302f346d5d12e5f4e89098e3d2a7b85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29936189_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/823e7fe35d86b28d2aa06802cef9d280.webp"
"MediaSize" => 156157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-823e7fe35d86b28d2aa06802cef9d280.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29936189_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/d869fa5106550eb1d34b7d7a34d07c13.webp"
"MediaSize" => 312190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-d869fa5106550eb1d34b7d7a34d07c13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29936189_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29936189/d01e9857d8cbb743cf8fc35d19e183d1.webp"
"MediaSize" => 148728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29936189/thumbnail-d01e9857d8cbb743cf8fc35d19e183d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13473750"
"ResourceRecordKey" => "29936189"
"ModificationTimestamp" => "2026-06-22T15:55:57.79Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936189')"
+"ID": "1553675"
}
]
+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 300866" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24782
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1420329" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24776
+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 '29936189'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25158
+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 '29936189'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25174
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29936189' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.830748 43.215368)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25227
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25221
+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
…12
]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936149')"
+"ID": "1554335"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25223
+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 {#25220
+post_id: "1550588"
+post_author: 1
+"ListingKey": "29932015"
+"ListingId": "X13469980"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T00:35:24Z"
+"RFModificationTimestamp": "2026-06-20T00:37:37Z"
+"ListPrice": 949000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Trenholme)"
+"PostalCode": "L8W2L4"
+"UnparsedAddress": "35 TRENHOLME CRESCENT, Hamilton (Trenholme), Ontario L8W2L4"
+"Coordinates": array:2 [
0 => -79.825281
1 => 43.203435
]
+"Latitude": 43.203435
+"Longitude": -79.825281
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on a premium 42 x 110 ft lot, this 4+2 bedroom, 4-bath family home delivers over 3,156 sq. ft. of thoughtfully designed living space - including one of the most flexible layouts you'll find at this price point. This home shows 10++. Whether you're housing extended family, generating rental income, or simply growing into the space, this home was built for real life. The main level sets the tone immediately: a refinished white chef's kitchen with quartz countertops, stainless steel appliances, and porcelain tile flows into a bright open-concept living and dining area made for hosting. A separate family room keeps the everyday comfortable and calm. Most impressively, a main-floor bedroom with its own full bath handles multigenerational living, aging parents, guests, or a private home office - without compromise. Upstairs, the primary suite stretches the full width of the home, offering his-and-hers closets, a newly updated ensuite, and room for a private sitting area. The remaining bedrooms are genuinely spacious and sun-filled - not an afterthought. The fully finished basement with a private side entrance is where you'll find an in-law suite: two bedrooms, a full bath, a kitchen, a large recreation area, and in-suite laundry. Live up, rent down - or keep it all for yourself. Recent upgrades include hardwood floors on the main level, refreshed bathrooms (2025), newer roof (2022) and windows (2023), fresh paint throughout, and a carpet-free, newer garage door (2026), smoke-free, pet-free interior ready for immediate occupancy. Tucked into a quiet, established neighbourhood with easy access to parks, schools, shopping, transit, and major highways - this is the kind of home that moves fast when buyers actually walk through the door. Your showing is one call away. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-20T00:23:28.851815+00:00"
+"Directions": "Upper Kenilworth"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2075003"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "41 x 109.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-19T23:47:46Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T00:18:36Z"
+"Stories": "2.0"
+"StreetName": "Trenholme"
+"StreetNumber": "35"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6647"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Trenholme"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29932015/35-trenholme-crescent-hamilton-trenholme-trenholme"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2026-06-19T23:47:45.79Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1350157"
+"ListOfficeNationalAssociationId": "1461559"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29932015')"
+"ID": "1550588"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25224
+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"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25222
+post_id: "1543935"
+post_author: 1
+"ListingKey": "29922805"
+"ListingId": "X13461854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T17:40:02Z"
+"RFModificationTimestamp": "2026-06-18T18:16:33Z"
+"ListPrice": 767777.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Macassa)"
+"PostalCode": "L8V4C1"
+"UnparsedAddress": "487 EAST 37TH STREET, Hamilton (Macassa), Ontario L8V4C1"
+"Coordinates": array:2 [
0 => -79.845015
1 => 43.220324
]
+"Latitude": 43.220324
+"Longitude": -79.845015
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 487 East 37th St, Hamilton- A beautifully remodeled bungalow filled with warmth andmodern charm. Located in the heart of Macassa Hamilton Mountain Area, this move-in-ready home offerscomfort and style throughout. The bright main level features 3 cozy bedrooms, a stylish 4-piece bath withheated floor, and an inviting open-concept kitchen with quartz counters, white cabinets, pot lights, a potfiller, and a lovely fireplace with accent shelving opens to the dining and living rooms, highlighted by ahuge new window that fills the space with natural light. A separate entrance leads to the fully finishedLegal basement (Additional Dwelling Unit) with spacious 2 beds, 1 full bath, custom kitchen , Separatelaundry and plenty of storage-ideal for guests or extended family. Enjoy a fully fenced backyard, a newlybuilt front deck, a driveway for 8 total parking with a detached garage. Close to schools, parks, shopping,and public transit-this home is cozy, updated, and ready to welcome you. (id:62650)"
+"Appliances": array:7 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Water meter"
4 => "Gas stove(s)"
5 => "Wine Fridge"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:16:27.981938+00:00"
+"Directions": "Cross Streets: Mohawk Rd. ** Directions: Upper Gage Ave & Mohawk Rd E."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237766"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "51 x 85 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T17:02:12Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:02:12Z"
+"Stories": "1.0"
+"StreetName": "East 37th"
+"StreetNumber": "487"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4221"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Macassa"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29922805/487-east-37th-street-hamilton-macassa-macassa"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 51.0
+"OriginalEntryTimestamp": "2026-06-18T17:02:12.08Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475810"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922805')"
+"ID": "1543935"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "1543936"
+post_author: 1
+"ListingKey": "29921721"
+"ListingId": "40841071"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T02:00:14Z"
+"RFModificationTimestamp": "2026-06-20T02:02:30Z"
+"ListPrice": 767777.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1788.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V4C1"
+"UnparsedAddress": "487 EAST 37TH Street, Hamilton, Ontario L8V4C1"
+"Coordinates": array:2 [
0 => -79.845029
1 => 43.2203326
]
+"Latitude": 43.2203326
+"Longitude": -79.845029
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 487 East 37th St, Hamilton— A beautifully remodelled bungalow filled with warmth and modern charm. Located in the heart of Macassa Hamilton Mountain Area, this move-in-ready home offers comfort and style throughout. The bright main level features 3 cozy bedrooms, a stylish 4-piece bath with heated floor, and an inviting open-concept kitchen with quartz counters, white cabinets, pot lights, a pot filler, and a lovely fireplace with accent shelving opens to the dining and living rooms, highlighted by a huge new window that fills the space with natural light. A separate entrance leads to the fully finished Legal basement (Additional Dwelling Unit) with spacious 2 beds, 1 full bath, custom kitchen , Separate laundry and plenty of storage—ideal for guests or extended family. Enjoy a fully fenced backyard, a newly built front deck, a driveway for 8 total parking with a detached garage. Close to schools, parks, shopping, and public transit—this home is cozy, updated, and ready to welcome you. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:47:00.104004+00:00"
+"Directions": "Upper Gage Ave & Mohawk Rd E"
+"ExteriorFeatures": array:4 [
0 => "Concrete"
1 => "Vinyl siding"
2 => "Shingles"
3 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078416"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T01:51:20Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T01:51:20Z"
+"Stories": "1.0"
+"StreetName": "EAST 37TH"
+"StreetNumber": "487"
+"StreetSuffix": "Street"
+"SubdivisionName": "178 - Macassa"
+"TaxAnnualAmount": "4221"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://tourwizard.net/487-east-37th-street-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921721/487-east-37th-street-hamilton"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 988
+"BelowGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-06-18T15:32:01.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1353274"
+"ListOfficeNationalAssociationId": "1344651"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921721')"
+"ID": "1543936"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1540175"
+post_author: 1
+"ListingKey": "29916672"
+"ListingId": "40840335"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-20T20:40:17Z"
+"RFModificationTimestamp": "2026-06-20T20:43:50Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1087.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V2J6"
+"UnparsedAddress": "546 MOHAWK Road E, Hamilton, Ontario L8V2J6"
+"Coordinates": array:2 [
0 => -79.8506605
1 => 43.2207644
]
+"Latitude": 43.2207644
+"Longitude": -79.8506605
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 546 Mohawk Road East! This bright open-concept bungalow offers 3 bedrooms, 1.5 bathrooms, and a beautifully finished basement. The main floor features an eat-in kitchen, spacious sun-filled living room, and a versatile 3-season room—perfect as a home office, family room, or man cave. The basement was professionally finished with permits and includes custom built-ins, finished laundry room, office space, and egress windows. Situated on a generous 60 x 106 ft lot with parking for 7 vehicles and over-sized shed. Updates include front bay window and back door (2021), sump pump, waterproofing and back-flow valve (2022), plus electrical and ductwork (2023/2024). A fantastic opportunity for first-time buyers or commuters - close to shopping, green space, amenities, and easy highway access. LET'S GET MOVING! ™ (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T19:02:49.473636+00:00"
+"Directions": "Mohawk Rd E, east of Upper Sherman"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932131"
+"ListOfficeKey": "284639"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-06-17T17:12:48Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-20T20:31:49Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "MOHAWK"
+"StreetNumber": "546"
+"StreetSuffix": "Road"
+"SubdivisionName": "183 - Lawfield"
+"TaxAnnualAmount": "4422.55"
+"VirtualTourURLUnbranded": "https://www.kelsicumberland.com/546-mohawk-rd-e"
+"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/29916672/546-mohawk-road-e-hamilton"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2106644"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2105571"
+"CoListOfficeKey": "279638"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "279638"
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1087
+"OriginalEntryTimestamp": "2026-06-17T17:11:33.67Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1232739"
+"ListOfficeNationalAssociationId": "1344653"
+"CoListAgentNationalAssociationId": "1375709"
+"CoListAgentNationalAssociationId2": "1374844"
+"CoListOfficeNationalAssociationId": "1306586"
+"CoListOfficeNationalAssociationId2": "1306586"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916672')"
+"ID": "1540175"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25225
+post_id: "1539684"
+post_author: 1
+"ListingKey": "29917011"
+"ListingId": "X13457050"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:05:06Z"
+"RFModificationTimestamp": "2026-06-17T18:36:01Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lawfield)"
+"PostalCode": "L8V2J6"
+"UnparsedAddress": "546 MOHAWK ROAD E, Hamilton (Lawfield), Ontario L8V2J6"
+"Coordinates": array:2 [
0 => -79.85046
1 => 43.220668
]
+"Latitude": 43.220668
+"Longitude": -79.85046
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 546 Mohawk Road East! This bright open-concept bungalow offers 3 bedrooms, 1.5 bathrooms, and a beautifully finished basement. The main floor features an eat-in kitchen, spacious sun-filled living room, and a versatile 3-season room-perfect as a home office, family room, or man cave. The basement was professionally finished with permits and includes custom built-ins, finished laundry room, office space, and egress windows. Situated on a generous 60 x 106 ft lot with parking for 7 vehicles and over-sized shed. Updates include front bay window and back door (2021), sump pump, waterproofing and back-flow valve (2022), plus electrical and ductwork (2023/2024). A fantastic opportunity for first-time buyers or commuters - close to shopping, green space, amenities, and easy highway access. LET'S GET MOVING! (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T18:35:57.552207+00:00"
+"Directions": "Cross Streets: Upper Sherman. ** Directions: Mohawk Rd E, east of Upper Sherman."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2067509"
+"ListOfficeKey": "284790"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "60 x 106.1 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T17:56:12Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T17:56:12Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "Mohawk"
+"StreetNumber": "546"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4422.55"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=KPUcNKH3Scv"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Lawfield"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29917011/546-mohawk-road-e-hamilton-lawfield-lawfield"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-17T17:56:12.07Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1342588"
+"ListOfficeNationalAssociationId": "1344892"
+"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('29917011')"
+"ID": "1539684"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25226
+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"
}
]
+success: true
+page_size: 9
+page_count: 15
+count: 130
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]