array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29898659 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408
+post_id: "1526539"
+post_author: 1
+"ListingKey": "29898659"
+"ListingId": "40838555"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:20:27Z"
+"RFModificationTimestamp": "2026-06-12T23:37:50Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1082.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T1W3"
+"UnparsedAddress": "33 KENWOOD Crescent, Hamilton, Ontario L8T1W3"
+"Coordinates": array:2 [
0 => -79.8274619
1 => 43.2236656
]
+"Latitude": 43.2236656
+"Longitude": -79.8274619
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 33 Kenwood Cres, a tastefully updated 3+2 bdrm, 2 bath bungalow w/ 2 kitchens (in-law suite) located on the Hamilton Mountain. Blending timeless architectural charm w/ contemporary design, this charming residence offers a versatile layout, quality finishes, & exceptional flex to suit a wide range of lifestyles. Step inside to discover a bright, open-concept main lvl where medium-toned flooring & recessed lighting create a warm, contemporary atmosphere. The sun-filled liv rm feat a large bay window that fills the space w/ natural light & flows effortlessly into the heart of the home - a beautifully reno'd kitch w/ white cab, premium countertops, S/S app, a gas range, & a generous island w/ breakfast seating for 2+. Adjacent to the kitch, the inviting din area is anchored by a striking white-brick FP w/ an attractive mantle & modern reeded wood-slat feat wall, creating the perfect backdrop for family gatherings/entertaining. 3 spacious bdrms & a beautifully reno'd 4-pc bath w/ stackable laund complete the main lvl. A sep entrance from the rear leads to the fin lower lvl, feat an in-law suite w/ a kitch, comfortable liv area, modern 3-pc bath, 2 bdrms (1 currently utilized as a home gym), & dedicated laund/utility space, providing flex for a variety of needs. A private 3-season sunroom overlooks the mature yard, offering a peaceful setting for morning coffee, summer evenings, and outdoor entertaining. The spacious yard provides plenty of room for children, pets, gardening, & recreation, while a storage shed adds practical convenience. Surfaced parking for 3+ vehicles.\u{A0}Ideally situated within walking distance of schools, parks, trails, shopping, dining, and transit, this location combines everyday convenience with a strong sense of community. With quick access to major transportation routes, this home offers an outstanding opportunity to enjoy comfortable, turnkey living in one of the Hamilton Mountain's most established family neighbourhoods. (id:62783)"
+"Appliances": array:1 [
0 => "Water meter"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T23:37:41.841687+00:00"
+"Directions": "From Fennell E/Upper Ottawa, E on Fennell E, S on High, E on Idlewood which turns into Kingslea, W on Kenwood"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1900653"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "In-Law Suite"
2 => "Private Yard"
]
+"PhotosChangeTimestamp": "2026-06-12T22:10:02Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-12T22:10:02Z"
+"Stories": "1.0"
+"StreetName": "KENWOOD"
+"StreetNumber": "33"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "253 - Huntington"
+"TaxAnnualAmount": "5138.87"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1658032291"
"RoomType" => "Laundry room"
"ListingId" => "40838555"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.58Z"
]
1 => array:11 [
"RoomKey" => "1658032292"
"RoomType" => "3pc Bathroom"
"ListingId" => "40838555"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "5'7'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.58Z"
]
2 => array:11 [
"RoomKey" => "1658032293"
"RoomType" => "Bedroom"
"ListingId" => "40838555"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.58Z"
]
3 => array:11 [
"RoomKey" => "1658032294"
"RoomType" => "Bedroom"
"ListingId" => "40838555"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.58Z"
]
4 => array:11 [
"RoomKey" => "1658032295"
"RoomType" => "Living room"
"ListingId" => "40838555"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 16'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.58Z"
]
5 => array:11 [
"RoomKey" => "1658032296"
"RoomType" => "Utility room"
"ListingId" => "40838555"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 17'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.58Z"
]
6 => array:11 [
"RoomKey" => "1658032297"
"RoomType" => "Kitchen"
"ListingId" => "40838555"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.58Z"
]
7 => array:11 [
"RoomKey" => "1658032298"
"RoomType" => "4pc Bathroom"
"ListingId" => "40838555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.58Z"
]
8 => array:11 [
"RoomKey" => "1658032299"
"RoomType" => "Bedroom"
"ListingId" => "40838555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.58Z"
]
9 => array:11 [
"RoomKey" => "1658032300"
"RoomType" => "Bedroom"
"ListingId" => "40838555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.59Z"
]
10 => array:11 [
"RoomKey" => "1658032301"
"RoomType" => "Primary Bedroom"
"ListingId" => "40838555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.59Z"
]
11 => array:11 [
"RoomKey" => "1658032302"
"RoomType" => "Kitchen"
"ListingId" => "40838555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.59Z"
]
12 => array:11 [
"RoomKey" => "1658032303"
"RoomType" => "Dining room"
"ListingId" => "40838555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 16'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.59Z"
]
13 => array:11 [
"RoomKey" => "1658032304"
"RoomType" => "Living room"
"ListingId" => "40838555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.59Z"
]
14 => array:11 [
"RoomKey" => "1658032305"
"RoomType" => "Foyer"
"ListingId" => "40838555"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29898659"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T22:10:02.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898659/33-kenwood-crescent-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1082
+"OriginalEntryTimestamp": "2026-06-12T22:10:02.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1217131"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:40 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29898659_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/5c9aed301f1aa305749c0e53599d3c74.webp"
"MediaSize" => 157300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-5c9aed301f1aa305749c0e53599d3c74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29898659_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/82494817d641119ac032c44716f90e22.webp"
"MediaSize" => 145163
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-82494817d641119ac032c44716f90e22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29898659_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/9eba0822dfc3266f540d873a2149fa33.webp"
"MediaSize" => 158821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-9eba0822dfc3266f540d873a2149fa33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29898659_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/b6f7d6baf2f4d0d6d7db172fcf0d3a8c.webp"
"MediaSize" => 46422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-b6f7d6baf2f4d0d6d7db172fcf0d3a8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29898659_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/99aea23578aaeb811d15c5d384029d18.webp"
"MediaSize" => 62958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-99aea23578aaeb811d15c5d384029d18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29898659_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/16b230fea73d7aa0a4d89116bca6bd99.webp"
"MediaSize" => 66810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-16b230fea73d7aa0a4d89116bca6bd99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29898659_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/6199027565c98e4a8665d04df285aad9.webp"
"MediaSize" => 84830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-6199027565c98e4a8665d04df285aad9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29898659_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/4000b8522c789cb3496b9dbe7c8ede7c.webp"
"MediaSize" => 63546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-4000b8522c789cb3496b9dbe7c8ede7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29898659_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/d230cbe046aa6ce297683e6f87430f37.webp"
"MediaSize" => 81129
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-d230cbe046aa6ce297683e6f87430f37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29898659_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/04a2fe207ffd12af1339fe55dbf8a53c.webp"
"MediaSize" => 64203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-04a2fe207ffd12af1339fe55dbf8a53c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29898659_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/a120137bb99bbedf616565af2849c37f.webp"
"MediaSize" => 62070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-a120137bb99bbedf616565af2849c37f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29898659_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/46c601febae8d17d279e19c3116a5dce.webp"
"MediaSize" => 82833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-46c601febae8d17d279e19c3116a5dce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29898659_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/050d6d68d9eeee98ae8c7b91bd544b59.webp"
"MediaSize" => 71219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-050d6d68d9eeee98ae8c7b91bd544b59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29898659_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/9917c0d7d317dd9031d49dc410d2468a.webp"
"MediaSize" => 91835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-9917c0d7d317dd9031d49dc410d2468a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29898659_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/5ea4b6d196cadf9ac0f915a7ed20ad9a.webp"
"MediaSize" => 88132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-5ea4b6d196cadf9ac0f915a7ed20ad9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29898659_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/7ff1174bd40ded22eae7257b06d90c86.webp"
"MediaSize" => 80255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-7ff1174bd40ded22eae7257b06d90c86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29898659_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/25540886070b412e4659e85513eca972.webp"
"MediaSize" => 77398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-25540886070b412e4659e85513eca972.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29898659_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/2e6cfb58b8647c4f8b211b4ec1999aed.webp"
"MediaSize" => 79791
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-2e6cfb58b8647c4f8b211b4ec1999aed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29898659_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/7ce5a85cfdb90a7be3619ebdac781966.webp"
"MediaSize" => 52321
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-7ce5a85cfdb90a7be3619ebdac781966.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29898659_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/1ed854178bcdde3f7b66b18707f9f0d9.webp"
"MediaSize" => 62670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-1ed854178bcdde3f7b66b18707f9f0d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29898659_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/510160a71e54438136fd497c53955364.webp"
"MediaSize" => 46554
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-510160a71e54438136fd497c53955364.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29898659_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/597b6c079cdda0a892dd8c66f79de41e.webp"
"MediaSize" => 78702
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-597b6c079cdda0a892dd8c66f79de41e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29898659_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/4da889c9b1b77c5e6bc53fb59fb603e3.webp"
"MediaSize" => 52145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-4da889c9b1b77c5e6bc53fb59fb603e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29898659_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/4f780099f3a14ef3798a52fc7c7f624b.webp"
"MediaSize" => 65037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-4f780099f3a14ef3798a52fc7c7f624b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29898659_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/b3874a6da58ee3c30d564b7a33621134.webp"
"MediaSize" => 64971
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-b3874a6da58ee3c30d564b7a33621134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29898659_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/abd1408862daf7c008e8aed6ccecb457.webp"
"MediaSize" => 68325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-abd1408862daf7c008e8aed6ccecb457.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29898659_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/8f49d20f0191f73f285852ef2e8197da.webp"
"MediaSize" => 50537
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-8f49d20f0191f73f285852ef2e8197da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29898659_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/ff2a777b79420aed6e53d875295f79b7.webp"
"MediaSize" => 50274
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-ff2a777b79420aed6e53d875295f79b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29898659_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/e0cc7d90965c3fdda30f66a325ead523.webp"
"MediaSize" => 47631
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-e0cc7d90965c3fdda30f66a325ead523.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29898659_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/12667797105939c37b71ab9398647ffe.webp"
"MediaSize" => 63530
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-12667797105939c37b71ab9398647ffe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29898659_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/e41bed874c2ae1c568ddfb84b1638f17.webp"
"MediaSize" => 69080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-e41bed874c2ae1c568ddfb84b1638f17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29898659_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/f5b7a3226ce655f6034fb1c56ee0e57f.webp"
"MediaSize" => 99443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-f5b7a3226ce655f6034fb1c56ee0e57f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29898659_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/8851868a5777e8f3f19eb7f0af3be89e.webp"
"MediaSize" => 93149
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-8851868a5777e8f3f19eb7f0af3be89e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29898659_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/49aebac1bf63cd19afb27073086f0fd4.webp"
"MediaSize" => 142875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-49aebac1bf63cd19afb27073086f0fd4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29898659_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/32366fa825836168a30ee9e5354b1d6b.webp"
"MediaSize" => 185017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-32366fa825836168a30ee9e5354b1d6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29898659_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/fe8c1540a13a695d24e2d3c7fd8a0801.webp"
"MediaSize" => 169058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-fe8c1540a13a695d24e2d3c7fd8a0801.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29898659_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/50f5ecaeea2c6c86519f8a730be92de6.webp"
"MediaSize" => 200762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-50f5ecaeea2c6c86519f8a730be92de6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29898659_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/c492fbf3942031a16a9d1b920355b675.webp"
"MediaSize" => 152539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-c492fbf3942031a16a9d1b920355b675.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29898659_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/ecb895144862bae00181242fee7bcd4a.webp"
"MediaSize" => 205485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-ecb895144862bae00181242fee7bcd4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29898659_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29898659/9b2e36159b77968692d47bc83fe5d535.webp"
"MediaSize" => 238035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29898659/thumbnail-9b2e36159b77968692d47bc83fe5d535.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40838555"
"ResourceRecordKey" => "29898659"
"ModificationTimestamp" => "2026-06-12T22:10:02.54Z"
]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898659')"
+"ID": "1526539"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 288925" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24905
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1900653" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24878
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29898659'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25217
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29898659'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25233
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29898659' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8274619 43.2236656)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25305
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+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 [
"Order" => 1
"MediaKey" => "29931023_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/a033f08324e7001de80aa102cffa584f.webp"
"MediaSize" => 268929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-a033f08324e7001de80aa102cffa584f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29931023_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/e6a047bb1023afe8cd4e4ca81eb9701f.webp"
"MediaSize" => 176983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-e6a047bb1023afe8cd4e4ca81eb9701f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29931023_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/2209dd620a219ca9ffa38feb671947c1.webp"
"MediaSize" => 115675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-2209dd620a219ca9ffa38feb671947c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29931023_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/654feda8fa9668b0266017f481fac6c9.webp"
"MediaSize" => 123573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-654feda8fa9668b0266017f481fac6c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29931023_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/8247ee20f0394d2f0c5aeb21db4702bd.webp"
"MediaSize" => 123485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-8247ee20f0394d2f0c5aeb21db4702bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29931023_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/41683fbd301d9cbc065b73a0e8cd6d0f.webp"
"MediaSize" => 123261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-41683fbd301d9cbc065b73a0e8cd6d0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29931023_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/4d8238333d07198471b76230fb59eebe.webp"
"MediaSize" => 103898
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-4d8238333d07198471b76230fb59eebe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29931023_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/5275030455114cfd2408d388b3443387.webp"
"MediaSize" => 144902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-5275030455114cfd2408d388b3443387.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29931023_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/88746257af1e629cea0ddf2496a93416.webp"
"MediaSize" => 123001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-88746257af1e629cea0ddf2496a93416.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29931023_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/61472486ed68021f72ca25f4fb6bc7bd.webp"
"MediaSize" => 123001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-61472486ed68021f72ca25f4fb6bc7bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29931023_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/2f74cb951354640929dabc1570a3bfa3.webp"
"MediaSize" => 148337
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-2f74cb951354640929dabc1570a3bfa3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29931023_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/2a21fe1b76efbf0ecf50ae0fc6a5e82f.webp"
"MediaSize" => 118001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-2a21fe1b76efbf0ecf50ae0fc6a5e82f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29931023_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/f4a32c5e5d243a5cf1f94a21e6e64049.webp"
"MediaSize" => 134792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-f4a32c5e5d243a5cf1f94a21e6e64049.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29931023_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/7ec144162bd10dcb68fd71c2431a032c.webp"
"MediaSize" => 152083
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-7ec144162bd10dcb68fd71c2431a032c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29931023_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/4fddd5abd35cce4d89959b4c34424f0e.webp"
"MediaSize" => 215439
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-4fddd5abd35cce4d89959b4c34424f0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29931023_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/61f19292a137a1b372c4b013dbc9b03e.webp"
"MediaSize" => 148067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-61f19292a137a1b372c4b013dbc9b03e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29931023_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/0b0337aef1160931ca50d91393953874.webp"
"MediaSize" => 137926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-0b0337aef1160931ca50d91393953874.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13469052"
"ResourceRecordKey" => "29931023"
"ModificationTimestamp" => "2026-06-19T20:55:56.47Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29931023_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29931023/c674f2d4db66269aa5080ea4bd6f6102.webp"
"MediaSize" => 150722
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29931023/thumbnail-c674f2d4db66269aa5080ea4bd6f6102.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29931023')"
+"ID": "1549846"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930555')"
+"ID": "1549407"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1548496"
+post_author: 1
+"ListingKey": "29929790"
+"ListingId": "40839924"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T18:45:01Z"
+"RFModificationTimestamp": "2026-06-19T19:47:14Z"
+"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 a 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-19T18:33:18Z"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29929790')"
+"ID": "1548496"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+post_id: "1543935"
+post_author: 1
+"ListingKey": "29922805"
+"ListingId": "X13461854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T17:40:02Z"
+"RFModificationTimestamp": "2026-06-18T18:16:33Z"
+"ListPrice": 767777.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Macassa)"
+"PostalCode": "L8V4C1"
+"UnparsedAddress": "487 EAST 37TH STREET, Hamilton (Macassa), Ontario L8V4C1"
+"Coordinates": array:2 [
0 => -79.845015
1 => 43.220324
]
+"Latitude": 43.220324
+"Longitude": -79.845015
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 487 East 37th St, Hamilton- A beautifully remodeled bungalow filled with warmth andmodern charm. Located in the heart of Macassa Hamilton Mountain Area, this move-in-ready home offerscomfort and style throughout. The bright main level features 3 cozy bedrooms, a stylish 4-piece bath withheated floor, and an inviting open-concept kitchen with quartz counters, white cabinets, pot lights, a potfiller, and a lovely fireplace with accent shelving opens to the dining and living rooms, highlighted by ahuge new window that fills the space with natural light. A separate entrance leads to the fully finishedLegal basement (Additional Dwelling Unit) with spacious 2 beds, 1 full bath, custom kitchen , Separatelaundry and plenty of storage-ideal for guests or extended family. Enjoy a fully fenced backyard, a newlybuilt front deck, a driveway for 8 total parking with a detached garage. Close to schools, parks, shopping,and public transit-this home is cozy, updated, and ready to welcome you. (id:62650)"
+"Appliances": array:7 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Water meter"
4 => "Gas stove(s)"
5 => "Wine Fridge"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T18:16:27.981938+00:00"
+"Directions": "Cross Streets: Mohawk Rd. ** Directions: Upper Gage Ave & Mohawk Rd E."
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237766"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "51 x 85 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T17:02:12Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:02:12Z"
+"Stories": "1.0"
+"StreetName": "East 37th"
+"StreetNumber": "487"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4221"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Macassa"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29922805/487-east-37th-street-hamilton-macassa-macassa"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 51.0
+"OriginalEntryTimestamp": "2026-06-18T17:02:12.08Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475810"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29922805')"
+"ID": "1543935"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1543936"
+post_author: 1
+"ListingKey": "29921721"
+"ListingId": "40841071"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T15:40:08Z"
+"RFModificationTimestamp": "2026-06-18T16:47:06Z"
+"ListPrice": 767777.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1788.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V4C1"
+"UnparsedAddress": "487 EAST 37TH Street, Hamilton, Ontario L8V4C1"
+"Coordinates": array:2 [
0 => -79.845029
1 => 43.2203326
]
+"Latitude": 43.2203326
+"Longitude": -79.845029
+"YearBuilt": 1956
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 487 East 37th St, Hamilton— A beautifully remodelled bungalow filled with warmth and modern charm. Located in the heart of Macassa Hamilton Mountain Area, this move-in-ready home offers comfort and style throughout. The bright main level features 3 cozy bedrooms, a stylish 4-piece bath with heated floor, and an inviting open-concept kitchen with quartz counters, white cabinets, pot lights, a pot filler, and a lovely fireplace with accent shelving opens to the dining and living rooms, highlighted by a huge new window that fills the space with natural light. A separate entrance leads to the fully finished Legal basement (Additional Dwelling Unit) with spacious 2 beds, 1 full bath, custom kitchen , Separate laundry and plenty of storage—ideal for guests or extended family. Enjoy a fully fenced backyard, a newly built front deck, a driveway for 8 total parking with a detached garage. Close to schools, parks, shopping, and public transit—this home is cozy, updated, and ready to welcome you. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:47:00.104004+00:00"
+"Directions": "Upper Gage Ave & Mohawk Rd E"
+"ExteriorFeatures": array:4 [
0 => "Concrete"
1 => "Vinyl siding"
2 => "Shingles"
3 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078416"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T15:32:02Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T15:32:01Z"
+"Stories": "1.0"
+"StreetName": "EAST 37TH"
+"StreetNumber": "487"
+"StreetSuffix": "Street"
+"SubdivisionName": "178 - Macassa"
+"TaxAnnualAmount": "4221"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://tourwizard.net/487-east-37th-street-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29921721/487-east-37th-street-hamilton"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 988
+"BelowGradeFinishedArea": 800
+"OriginalEntryTimestamp": "2026-06-18T15:32:01.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1353274"
+"ListOfficeNationalAssociationId": "1344651"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921721')"
+"ID": "1543936"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1541658"
+post_author: 1
+"ListingKey": "29919492"
+"ListingId": "X13458962"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T00:55:07Z"
+"RFModificationTimestamp": "2026-06-18T00:58:30Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Macassa)"
+"PostalCode": "L8V3M4"
+"UnparsedAddress": "627 UPPER SHERMAN AVENUE, Hamilton (Macassa), Ontario L8V3M4"
+"Coordinates": array:2 [
0 => -79.848469
1 => 43.228597
]
+"Latitude": 43.228597
+"Longitude": -79.848469
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this extensively renovated and move-in-ready home located in a desirable Hamilton Mountain neighbourhood. Offering 3+2 bedrooms, 2 full bathrooms, 2 kitchens, a separate entrance to the finished lower level, excellent parking, and a highly functional backyard setup, this property is ideal for families, multi-generational living, and investors alike. The bright main level features 3 spacious bedrooms, a stylish renovated bathroom with modern tub, upgraded fixtures and faucets, an updated kitchen with modern cabinetry, countertops and backsplash, and an inviting living area highlighted by a modern fireplace and pot lights throughout. The fully finished lower level offers excellent flexibility with 2 additional bedrooms, a separate entrance, kitchen, and renovated bathroom with modern shower and upgraded fixtures, making it perfect for extended family, guests, or additional living space. Recent upgrades include new flooring throughout, fresh paint, new doors and modern hardware, updated windows, renovated kitchens and bathrooms, new pot lights, updated electrical wiring and outlets where required, ESA-certified electrical work with certificate available, and modern finishes throughout. The property offers parking for up to 5 vehicles, including a large driveway and secure gated rear parking area. The spacious backyard offers incredible versatility with a detached serviced garage/workshop equipped with electrical service, water supply, drainage, heating and HVAC connections, plus an additional shed with electrical service, a second storage shed, landscape lighting with timers throughout the front and rear yards, and a sprinkler system ready for connection. Conveniently located close to schools, parks, shopping, transit, amenities, and major highway access, this extensively upgraded Hamilton Mountain home offers a rare combination of modern living, flexible space, exceptional parking, functional outdoor features, and future potential. Move in and enjoy! (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Full"
1 => "Separate entrance"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T00:30:41.699980+00:00"
+"Directions": "Cross Streets: Fennell Ave E/Upper Sherman Ave. ** Directions: Fennell to Upper Sherman."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993784"
+"ListOfficeKey": "294997"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "46 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T23:18:37Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T00:47:00Z"
+"Stories": "1.0"
+"StreetName": "Upper Sherman"
+"StreetNumber": "627"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "3982"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Macassa"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29919492/627-upper-sherman-avenue-hamilton-macassa-macassa"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 46.0
+"OriginalEntryTimestamp": "2026-06-17T23:18:37.71Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1276930"
+"ListOfficeNationalAssociationId": "1451359"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919492')"
+"ID": "1541658"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1540579"
+post_author: 1
+"ListingKey": "29918118"
+"ListingId": "40840836"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T16:30:37Z"
+"RFModificationTimestamp": "2026-06-19T16:43:38Z"
+"ListPrice": 649000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1875.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V3M4"
+"UnparsedAddress": "627 UPPER SHERMAN Avenue, Hamilton, Ontario L8V3M4"
+"Coordinates": array:2 [
0 => -79.8485058
1 => 43.2286397
]
+"Latitude": 43.2286397
+"Longitude": -79.8485058
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this extensively renovated and move-in-ready home located in a desirable Hamilton Mountain neighbourhood. Offering 3+2 bedrooms, 2 full bathrooms, 2 kitchens, a separate entrance to the finished lower level, excellent parking, and a highly functional backyard setup, this property is ideal for families, multi-generational living, and investors alike. The bright main level features 3 spacious bedrooms, a stylish renovated bathroom with modern tub, upgraded fixtures and faucets, an updated kitchen with modern cabinetry, countertops and backsplash, and an inviting living area highlighted by a modern fireplace and pot lights throughout. The fully finished lower level offers excellent flexibility with 2 additional bedrooms, a separate entrance, kitchen, and renovated bathroom with modern shower and upgraded fixtures, making it perfect for extended family, guests, or additional living space. Recent upgrades include new flooring throughout, fresh paint, new doors and modern hardware, updated windows, renovated kitchens and bathrooms, new pot lights, updated electrical wiring and outlets where required, ESA-certified electrical work with certificate available, and modern finishes throughout. The property offers parking for up to 5 vehicles, including a large driveway and secure gated rear parking area. The spacious backyard offers incredible versatility with a detached serviced garage/workshop equipped with electrical service, water supply, drainage, heating and HVAC connections, plus an additional shed with electrical service, a second storage shed, landscape lighting with timers throughout the front and rear yards, and a sprinkler system ready for connection. Conveniently located close to schools, parks, shopping, transit, amenities, and major highway access, this extensively upgraded Hamilton Mountain home offers a rare combination of modern living, flexible space, exceptional parking, functional outdoor features, and future potential. Move in and enjoy! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T21:17:56.111677+00:00"
+"Directions": "Fennell to Upper Sherman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2226340"
+"ListOfficeKey": "291669"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-19T16:11:34Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T16:11:33Z"
+"Stories": "1.0"
+"StreetName": "UPPER SHERMAN"
+"StreetNumber": "627"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "178 - Macassa"
+"TaxAnnualAmount": "3982"
+"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/29918118/627-upper-sherman-avenue-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 1000
+"BelowGradeFinishedArea": 875
+"OriginalEntryTimestamp": "2026-06-17T20:02:24.13Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1469738"
+"ListOfficeNationalAssociationId": "1401824"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29918118')"
+"ID": "1540579"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29917454')"
+"ID": "1539922"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "1540175"
+post_author: 1
+"ListingKey": "29916672"
+"ListingId": "40840335"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T17:30:30Z"
+"RFModificationTimestamp": "2026-06-17T19:02:52Z"
+"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:62783)"
+"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-17T17:12:48Z"
+"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:35 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916672')"
+"ID": "1540175"
}
]
+success: true
+page_size: 9
+page_count: 20
+count: 177
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]