array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29957773 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1568953"
+post_author: 1
+"ListingKey": "29957773"
+"ListingId": "X13493372"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T15:30:24Z"
+"RFModificationTimestamp": "2026-06-26T16:03:16Z"
+"ListPrice": 739900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lawfield)"
+"PostalCode": "L8W1A3"
+"UnparsedAddress": "746 LIMERIDGE ROAD E, Hamilton (Lawfield), Ontario L8W1A3"
+"Coordinates": array:2 [
0 => -79.852055
1 => 43.211371
]
+"Latitude": 43.211371
+"Longitude": -79.852055
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This stunning 2-storey detached home offers the perfect blend of modern comfort and incredible investment potential. Boasting a spacious 3+1 bedroom layout and 4 bathrooms, this property is designed to accommodate growing families or those seeking a turnkey multi-generational living setup.The main floor welcomes you with a design that flows seamlessly from the bright living area into the dining room and kitchen with an eat-in area. Newer large windows throughout invite an abundance of natural light, highlighting the thoughtful craftsmanship and neutral palette. Upstairs, you will find three generous bedrooms, including a primary suite featuring a private ensuite bath for ultimate relaxation. The true highlight of this home is the professionally finished basement. Accessible via the main floor or a dedicated separate side entrance, this lower level includes an additional bedroom/office, a 3-Pce bathroom, a kitchen and a versatile living area. Whether you envision a private guest suite, a home office, the possibilities are endless.Located in a vibrant Hamilton community, you are just minutes away from local amenities, top-rated schools, parks, and easy highway access. This home combines suburban tranquility with urban convenience, making it a rare find in today's market. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Dishwasher"
2 => "Dryer"
3 => "Two stoves"
4 => "Window Coverings"
5 => "Two Refrigerators"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T16:03:12.421744+00:00"
+"Directions": "SouthSide Of Limeridge,East Of Sherman"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1819857"
+"ListOfficeKey": "50456"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "32.8 x 113.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T15:21:45Z"
+"PhotosCount": 24
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T15:21:44Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "Limeridge"
+"StreetNumber": "746"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5980"
+"VirtualTourURLUnbranded": "https://www.houssmax.ca/vtournb/h2940460"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Lawfield"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29957773/746-limeridge-road-e-hamilton-lawfield-lawfield"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 32.9
+"OriginalEntryTimestamp": "2026-06-26T15:21:44.92Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1193356"
+"ListOfficeNationalAssociationId": "1002324"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29957773_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/b4a31acd12ea97fefde83d3fec3a224a.webp"
"MediaSize" => 298878
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-b4a31acd12ea97fefde83d3fec3a224a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29957773_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/161cabc0ab278105d9113f16d32a96e8.webp"
"MediaSize" => 140996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-161cabc0ab278105d9113f16d32a96e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29957773_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/e4703fbf5f910d0f42f918b92edf95b4.webp"
"MediaSize" => 186000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-e4703fbf5f910d0f42f918b92edf95b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29957773_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/f35000dcf1439c80e705bf718354d4a0.webp"
"MediaSize" => 165198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-f35000dcf1439c80e705bf718354d4a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29957773_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/de0690b6f63f2b0e2c9f19413539042e.webp"
"MediaSize" => 94623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-de0690b6f63f2b0e2c9f19413539042e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29957773_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/7db63ba62aab0ee84232975616d7c819.webp"
"MediaSize" => 158542
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-7db63ba62aab0ee84232975616d7c819.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29957773_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/16a609129ac409c3fe3361b89e8a228d.webp"
"MediaSize" => 128165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-16a609129ac409c3fe3361b89e8a228d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29957773_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/c34304e5903854e2422b6a7e22fd5bb6.webp"
"MediaSize" => 148398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-c34304e5903854e2422b6a7e22fd5bb6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29957773_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/3808352ebb52bd7c5168fc74735da040.webp"
"MediaSize" => 150520
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-3808352ebb52bd7c5168fc74735da040.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29957773_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/5a090f97532bccb9fdb419dd8f82d2ae.webp"
"MediaSize" => 131068
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-5a090f97532bccb9fdb419dd8f82d2ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29957773_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/91858e5a563a7025779d970efdd9073a.webp"
"MediaSize" => 127280
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-91858e5a563a7025779d970efdd9073a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29957773_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/a9fe020c0b33d2d121756dbfa15cf723.webp"
"MediaSize" => 127022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-a9fe020c0b33d2d121756dbfa15cf723.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29957773_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/832bab1cfb26ba048a3655f5a2c1ce8b.webp"
"MediaSize" => 160668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-832bab1cfb26ba048a3655f5a2c1ce8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29957773_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/e9ece615675c09e792421fe802c9c16d.webp"
"MediaSize" => 318029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-e9ece615675c09e792421fe802c9c16d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29957773_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/ef5a14438ef2a5bd8cb2b5d4316aff78.webp"
"MediaSize" => 132237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-ef5a14438ef2a5bd8cb2b5d4316aff78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29957773_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/5544a4c881a9f062f50a04c03ad7f444.webp"
"MediaSize" => 111873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-5544a4c881a9f062f50a04c03ad7f444.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29957773_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/540164f47be2ff8c6797be3a10ad9d62.webp"
"MediaSize" => 175868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-540164f47be2ff8c6797be3a10ad9d62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29957773_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/15a976426b635f0991fd1fbf6afda85c.webp"
"MediaSize" => 173755
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-15a976426b635f0991fd1fbf6afda85c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29957773_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/fa726ebee5f97c6c181d1a290d8878c2.webp"
"MediaSize" => 130112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-fa726ebee5f97c6c181d1a290d8878c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29957773_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/9f4dfcb86783b980d162d67482b61f1e.webp"
"MediaSize" => 180476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-9f4dfcb86783b980d162d67482b61f1e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29957773_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/e1d1dbe3114b26051ab0d5fc31d248fc.webp"
"MediaSize" => 314325
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-e1d1dbe3114b26051ab0d5fc31d248fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29957773_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/037a399ce84befe5805da9651a0dc601.webp"
"MediaSize" => 309759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-037a399ce84befe5805da9651a0dc601.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29957773_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/dd1f66bef751c4139870ec26b7378f62.webp"
"MediaSize" => 392510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-dd1f66bef751c4139870ec26b7378f62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29957773_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29957773/aa331a6c3df594bcca53b058465d70ed.webp"
"MediaSize" => 320070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29957773/thumbnail-aa331a6c3df594bcca53b058465d70ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13493372"
"ResourceRecordKey" => "29957773"
"ModificationTimestamp" => "2026-06-26T15:21:44.93Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29957773')"
+"ID": "1568953"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 50456" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24841
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1819857" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24844
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29957773'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25220
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29957773'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25236
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29957773' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.852055 43.211371)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25289
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+post_id: "1570816"
+post_author: 1
+"ListingKey": "29959143"
+"ListingId": "40843417"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T17:55:07Z"
+"RFModificationTimestamp": "2026-06-26T19:23:41Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3664.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8W3A3"
+"UnparsedAddress": "489 ACADIA Drive, Hamilton, Ontario L8W3A3"
+"Coordinates": array:2 [
0 => -79.8689101
1 => 43.2049429
]
+"Latitude": 43.2049429
+"Longitude": -79.8689101
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 489 Acadia Drive, a spacious two-storey family home tucked away on a quiet court, offering three finished levels of versatile living space. From the moment you step inside, the grand foyer, elegant curved staircase, and abundance of natural light create a warm and welcoming first impression. Designed for both everyday living and entertaining, the main floor features multiple living and dining areas, hardwood flooring, and a spacious kitchen overlooking the backyard. French patio doors lead to a beautifully landscaped outdoor retreat complete with a large pergola, above-ground pool, mature trees, and plenty of green space to enjoy throughout the summer. Upstairs, you'll find four generously sized bedrooms, including a spacious primary suite featuring a walk-in closet and a five-piece ensuite. The additional bedrooms provide flexibility for growing families, guests, or home office space. The finished basement offers a separate exterior entrance and includes a large recreation area, dining space, spacious bedroom, three-piece bathroom, and an area with potential for a future kitchen, making it well suited for multi-generational living or extended family. Additional features include interior access to the double garage, a wide driveway with parking for multiple vehicles, and an attractive brick exterior that offers timeless curb appeal. This is an exceptional opportunity to own a spacious family home on a generously sized lot in a sought-after neighbourhood close to parks, schools, shopping, and everyday amenities. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T19:23:29.395284+00:00"
+"Directions": "nearest intersection: stone church and upper wentworth, then to Acadia Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2159089"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T17:50:17Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T17:50:16Z"
+"Stories": "2.0"
+"StreetName": "ACADIA"
+"StreetNumber": "489"
+"StreetSuffix": "Drive"
+"SubdivisionName": "186 - Rushdale/Butler"
+"TaxAnnualAmount": "8267"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1668702117"
"RoomType" => "Bedroom"
"ListingId" => "40843417"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 19'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.92Z"
]
1 => array:11 [
"RoomKey" => "1668702118"
"RoomType" => "3pc Bathroom"
"ListingId" => "40843417"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "6'10'' x 10'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.93Z"
]
2 => array:11 [
"RoomKey" => "1668702119"
"RoomType" => "Other"
"ListingId" => "40843417"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 17'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.93Z"
]
3 => array:11 [
"RoomKey" => "1668702120"
"RoomType" => "Family room"
"ListingId" => "40843417"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 19'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.94Z"
]
4 => array:11 [
"RoomKey" => "1668702121"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "7'1'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.94Z"
]
5 => array:11 [
"RoomKey" => "1668702122"
"RoomType" => "5pc Bathroom"
"ListingId" => "40843417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.95Z"
]
6 => array:11 [
"RoomKey" => "1668702123"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 20'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.95Z"
]
7 => array:11 [
"RoomKey" => "1668702124"
"RoomType" => "Bedroom"
"ListingId" => "40843417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.97Z"
]
8 => array:11 [
"RoomKey" => "1668702125"
"RoomType" => "Bedroom"
"ListingId" => "40843417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.97Z"
]
9 => array:11 [
"RoomKey" => "1668702126"
"RoomType" => "Bedroom"
"ListingId" => "40843417"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.98Z"
]
10 => array:11 [
"RoomKey" => "1668702127"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "2'11'' x 6'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.98Z"
]
11 => array:11 [
"RoomKey" => "1668702128"
"RoomType" => "Family room"
"ListingId" => "40843417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.99Z"
]
12 => array:11 [
"RoomKey" => "1668702129"
"RoomType" => "Dining room"
"ListingId" => "40843417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "9'11'' x 17'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:16.99Z"
]
13 => array:11 [
"RoomKey" => "1668702133"
"RoomType" => "Kitchen"
"ListingId" => "40843417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 17'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:17Z"
]
14 => array:11 [
"RoomKey" => "1668702140"
"RoomType" => "Dining room"
"ListingId" => "40843417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:17Z"
]
15 => array:11 [
"RoomKey" => "1668702147"
"RoomType" => "Living room"
"ListingId" => "40843417"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29959143"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 14'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-26T17:50:17.01Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29959143/489-acadia-drive-hamilton"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "D/S-573"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 2784
+"BelowGradeFinishedArea": 880
+"OriginalEntryTimestamp": "2026-06-26T17:50:16.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"BelowGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1410379"
+"ListOfficeNationalAssociationId": "1344652"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29959143_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/f579608bc4de99e3292b414e850084db.webp"
"MediaSize" => 153580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-f579608bc4de99e3292b414e850084db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29959143_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/eb8f8b7d05ad1cc7130ed7159efaeb0e.webp"
"MediaSize" => 136604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-eb8f8b7d05ad1cc7130ed7159efaeb0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29959143_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/1b7d55aa8374256b2b90c69c14b621b7.webp"
"MediaSize" => 60678
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-1b7d55aa8374256b2b90c69c14b621b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29959143_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/92e658732525e607c079886fdfc26309.webp"
"MediaSize" => 69584
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-92e658732525e607c079886fdfc26309.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29959143_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/0838e3b6ee71fcc4fd71e1e4a600c698.webp"
"MediaSize" => 70852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-0838e3b6ee71fcc4fd71e1e4a600c698.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29959143_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/29f1f8257a0d0eeec4009d3f43b7f1f5.webp"
"MediaSize" => 68814
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-29f1f8257a0d0eeec4009d3f43b7f1f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29959143_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/a0710a3f934c1eb2d6c98d0825165864.webp"
"MediaSize" => 67744
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-a0710a3f934c1eb2d6c98d0825165864.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29959143_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/da98c99ae92ca2b0b93b94caba1f52b5.webp"
"MediaSize" => 63311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-da98c99ae92ca2b0b93b94caba1f52b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29959143_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/0e364b925fe3a388edd0483dc8fcf0c2.webp"
"MediaSize" => 57122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-0e364b925fe3a388edd0483dc8fcf0c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29959143_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/b0f7776af21f007258be28539556ae26.webp"
"MediaSize" => 59529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-b0f7776af21f007258be28539556ae26.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29959143_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/f94c0b0edd05bba4ea8ff3e1a90443cb.webp"
"MediaSize" => 67690
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-f94c0b0edd05bba4ea8ff3e1a90443cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29959143_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/2370fef326fd3a67c0d011510627efa0.webp"
"MediaSize" => 67402
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-2370fef326fd3a67c0d011510627efa0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29959143_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/a4b890d38b9f2abe58c8227e7c8664a1.webp"
"MediaSize" => 86427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-a4b890d38b9f2abe58c8227e7c8664a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29959143_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/685998fa30e9694b657cbdf208b9b109.webp"
"MediaSize" => 77916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-685998fa30e9694b657cbdf208b9b109.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29959143_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/c06bdb4ce2745ebe7f5d8df815f897e6.webp"
"MediaSize" => 79669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-c06bdb4ce2745ebe7f5d8df815f897e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29959143_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/132db5425cce70bca2deac69a9ceb127.webp"
"MediaSize" => 60603
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-132db5425cce70bca2deac69a9ceb127.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29959143_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/bb64bceb941e469f5b0e5ec9077e80bc.webp"
"MediaSize" => 55792
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-bb64bceb941e469f5b0e5ec9077e80bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29959143_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/23fcfd9511bdc06f57098f9dac58ad6d.webp"
"MediaSize" => 84721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-23fcfd9511bdc06f57098f9dac58ad6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29959143_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/d8eae2f612132589cc5c6efa14d88c12.webp"
"MediaSize" => 44426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-d8eae2f612132589cc5c6efa14d88c12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29959143_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/a85d37b7af3e2227ba4c95264da255f7.webp"
"MediaSize" => 73376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-a85d37b7af3e2227ba4c95264da255f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29959143_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/4daea7e28740cbab1445410555abcd15.webp"
"MediaSize" => 69946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-4daea7e28740cbab1445410555abcd15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29959143_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/f38a66583e0a3eceed8580cfdebe6da6.webp"
"MediaSize" => 61779
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-f38a66583e0a3eceed8580cfdebe6da6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29959143_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/73ef2e2dcd82e7563e1fea25a671ccdd.webp"
"MediaSize" => 46446
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-73ef2e2dcd82e7563e1fea25a671ccdd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29959143_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/ef330d12c7d26bf793aa7ddfa6ce9af4.webp"
"MediaSize" => 52927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-ef330d12c7d26bf793aa7ddfa6ce9af4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29959143_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/1db0e60f9335ba1c3134deda65b0b9cc.webp"
"MediaSize" => 55559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-1db0e60f9335ba1c3134deda65b0b9cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29959143_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/a9d34a41a904fe3abd1eae86ec644633.webp"
"MediaSize" => 66728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-a9d34a41a904fe3abd1eae86ec644633.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29959143_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/dba57ee82c8ddf1b0f5f4db3609ca29c.webp"
"MediaSize" => 68570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-dba57ee82c8ddf1b0f5f4db3609ca29c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29959143_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/29a81844fb573dd407a5a40297f6908f.webp"
"MediaSize" => 60949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-29a81844fb573dd407a5a40297f6908f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29959143_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/ffa22ff58e2f75663239d156a3c7edf0.webp"
"MediaSize" => 34613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-ffa22ff58e2f75663239d156a3c7edf0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29959143_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/454e91a282ee25e2c027212ece0f55d6.webp"
"MediaSize" => 74461
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-454e91a282ee25e2c027212ece0f55d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29959143_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/3c53d32e23f58cdea9b6418d35b9d779.webp"
"MediaSize" => 77110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-3c53d32e23f58cdea9b6418d35b9d779.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29959143_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29959143/1d0ca47b47bf6bb3e6c60de4813e4d17.webp"
"MediaSize" => 43240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29959143/thumbnail-1d0ca47b47bf6bb3e6c60de4813e4d17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843417"
"ResourceRecordKey" => "29959143"
"ModificationTimestamp" => "2026-06-26T17:50:16.63Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29959143_4890_33"
…11
]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29959143')"
+"ID": "1570816"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "1570832"
+post_author: 1
+"ListingKey": "29959144"
+"ListingId": "40843348"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-26T18:00:02Z"
+"RFModificationTimestamp": "2026-06-26T19:21:21Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.18
+"LivingArea": 967.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V4G8"
+"UnparsedAddress": "452 EAST 38TH Street, Hamilton, Ontario L8V4G8"
+"Coordinates": array:2 [
0 => -79.8435386
1 => 43.221599
]
+"Latitude": 43.221599
+"Longitude": -79.8435386
+"YearBuilt": 1949
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "ROOM TO GROW, BUILD EQUITY, AND MAKE IT YOUR OWN. Affordable Detached Living with Endless Potential in a Convenient Hamilton Mountain Location! Opportunity and location come together in this detached 1.5-storey home, offering an affordable way to enter the Hamilton Mountain market while creating a space that's uniquely yours. Whether you're a first-time buyer looking to build equity or an investor searching for your next project, this home offers flexibility, value, and room to grow. Inside, you'll find a functional layout with three bedrooms and two bathrooms, providing comfortable everyday living with plenty of potential to update and personalize over time. Every improvement offers the opportunity to add value while tailoring the home to suit your own style and needs. One of the standout features is the large insulated detached garage with hydro, offering exceptional flexibility for hobbyists, tradespeople, car enthusiasts, extra storage, or a dedicated workshop. Combined with parking for up to six vehicles, there's plenty of room for family, guests, recreational vehicles, or future projects. Outside, the backyard patio creates a welcoming space to enjoy summer evenings, outdoor dining, or weekend gatherings. Adding even simple landscaping touches can further enhance this outdoor retreat. A durable 50-year metal roof provides lasting peace of mind and helps reduce one of the major long-term maintenance concerns for future homeowners. The location adds even more appeal. Enjoy the convenience of being close to grocery stores, restaurants, shopping, transit, and everyday amenities, while quick highway access makes commuting throughout Hamilton and beyond simple and efficient. Nearby parks and schools further enhance the lifestyle this established neighbourhood has to give. (id:62783)"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T19:21:17.851360+00:00"
+"Directions": "Lincoln Alexander Parkway to Upper Gage Ave Exit, North on Upper Gage Ave, West on Dallas Ave, South on East 38th St"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1991727"
+"ListOfficeKey": "292505"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.18"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T17:50:18Z"
+"PhotosCount": 19
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-26T17:50:18Z"
+"Stories": "1.5"
+"StreetName": "EAST 38TH"
+"StreetNumber": "452"
+"StreetSuffix": "Street"
+"SubdivisionName": "178 - Macassa"
+"TaxAnnualAmount": "4820.77"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29959144/452-east-38th-street-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 51.0
+"AboveGradeFinishedArea": 967
+"OriginalEntryTimestamp": "2026-06-26T17:50:17.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1275196"
+"ListOfficeNationalAssociationId": "1412896"
+"Media": array:19 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29959144')"
+"ID": "1570832"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1567345"
+post_author: 1
+"ListingKey": "29945905"
+"ListingId": "40840432"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T13:45:19Z"
+"RFModificationTimestamp": "2026-06-26T03:50:30Z"
+"ListPrice": 849999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.19
+"LivingArea": 3003.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8W2S9"
+"UnparsedAddress": "400 EAGLEWOOD Drive, Hamilton, Ontario L8W2S9"
+"Coordinates": array:2 [
0 => -79.8540726
1 => 43.197477
]
+"Latitude": 43.197477
+"Longitude": -79.8540726
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This stunning 4+1 bedroom, 2 bathroom detached 2-storey checks every box. The open-concept main floor features a bright kitchen, spacious dining area, and large living room perfect for entertaining. Upstairs offers an oversized primary bedroom, three additional bedrooms, and a full bath. The fully finished basement adds a massive rec room plus a private 5th bedroom — ideal for guests, teens, or a home office. Step outside to your own private retreat — a 200+ foot deep lot backing directly onto a park with no rear neighbors. Room for a pool, workshop, or whatever you can dream up. Single attached garage with inside entry. Forced air gas heat and central air throughout. Both public and Catholic schools are within easy walking distance — a rare find that makes the morning rush a thing of the past. Quiet, family-friendly street minutes to parks, transit, and all amenities. Flexible closing available. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T03:49:42.480348+00:00"
+"Directions": "Upper Gage to Royal Vista to Eaglewood"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2157030"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.19"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T13:31:00Z"
+"PhotosCount": 21
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T13:40:02Z"
+"Stories": "2.0"
+"StreetName": "EAGLEWOOD"
+"StreetNumber": "400"
+"StreetSuffix": "Drive"
+"SubdivisionName": "187 - Randall/Eleanor"
+"TaxAnnualAmount": "6587.39"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945905/400-eaglewood-drive-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C3"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 2093
+"BelowGradeFinishedArea": 910
+"OriginalEntryTimestamp": "2026-06-24T13:31:00.56Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1408370"
+"ListOfficeNationalAssociationId": "1306309"
+"Media": array:21 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29945905')"
+"ID": "1567345"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25286
+post_id: "1565515"
+post_author: 1
+"ListingKey": "29953642"
+"ListingId": "X13489230"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T19:55:03Z"
+"RFModificationTimestamp": "2026-06-26T01:07:30Z"
+"ListPrice": 649850.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Burkholme)"
+"PostalCode": "L8V3K2"
+"UnparsedAddress": "10 HELGA COURT, Hamilton (Burkholme), Ontario L8V3K2"
+"Coordinates": array:2 [
0 => -79.852292
1 => 43.223948
]
+"Latitude": 43.223948
+"Longitude": -79.852292
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 10 Helga Court! Set on a wonderful court in a family-friendly Central Hamilton Mountain neighbourhood, this solid brick 3-bedroomelevated bungalow offers fantastic space, comfort, and convenience. Enjoy being close to parks, soccer fields, Lime Ridge Mall, Fortino's,restaurants, and quick access to the Linc, 403, and QEW-ideal for commuters. Lovingly maintained over the years, the home features beautifullandscaping and perennial gardens. The main level offers a bright living room with a large picture window allowing plenty of natural light, akitchen with dining area, three good-sized bedrooms with ample closet space, and a remodelled 4-piece bathroom. The finished lower level isbright and spacious with lots of windows, offering a rec room, den, laundry area, 3-piece bathroom, and plenty of storage. A separate sideentrance provides excellent in-law potential. Outside, enjoy a fenced yard with patio, a very long private side drive with parking for up to 6 cars,and an oversized 18 x 23 detached garage with hydro. Recent high-efficiency furnace and central air conditioning offer added peace of mind.With 2,190 sq. ft. of finished living space, this home is priced for quick sale and ready for its next owner! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
]
+"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-26T01:07:27.315885+00:00"
+"Directions": "Cross Streets: Upper Sherman. ** Directions: Upper Sherman to Burkholder Dr to Helga Crt."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2166044"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "40 x 125 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T18:36:46Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T19:50:04Z"
+"Stories": "1.0"
+"StreetName": "Helga"
+"StreetNumber": "10"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "4581.86"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/cvtnb/364273"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Burkholme"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29953642/10-helga-court-hamilton-burkholme-burkholme"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-06-25T18:36:45.97Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1416991"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29953642')"
+"ID": "1565515"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: "1565001"
+post_author: 1
+"ListingKey": "29948495"
+"ListingId": "40842751"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T20:00:23Z"
+"RFModificationTimestamp": "2026-06-26T00:29:40Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3594.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8W2Z7"
+"UnparsedAddress": "59 RANDOLF Court, Hamilton, Ontario L8W2Z7"
+"Coordinates": array:2 [
0 => -79.864119
1 => 43.2084642
]
+"Latitude": 43.2084642
+"Longitude": -79.864119
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Thhis family home has been meticulously maintained by the original owner for the past 37 years. Nestled on a quiet court, it offers the privacy, peace, and security your family will appreciate. Boasting 2,518 sq. ft. above grade and 3,594 sq. ft. of total finished living space, this home features 4 bedrooms, 2.5 bathrooms, a finished basement rec room, and plenty of storage throughout. Tastefully updated from top to bottom, it offers hardwood floors, California shutters, new carpeting, a living room with a gas fireplace, central vacuum, a main-floor den/office, and a separate dining room. Additional highlights include a double garage, main-floor laundry with side and garage access, and a beautifully appointed kitchen featuring stainless steel appliances, solid wood cabinetry, pot lights, granite countertops, a stone backsplash, a large island, and an abundance of cabinet space. The second floor offers 4 spacious bedrooms, a full bathroom, and a primary suite complete with a walk-in closet and private ensuite, plus two linen closets. The true showpiece of this home is the backyard. Entertain or unwind in your own private oasis featuring a heated in-ground pool, lush landscaping, and a custom-built covered deck. For added peace of mind, the roof, furnace & AC, windows, and exterior doors have all been recently updated. Conveniently located on the Hamilton Mountain, this home is close to Lime Ridge Mall, T.B. McQuesten Community Park, and the Lincoln M. Alexander Parkway (id:62783)"
+"Appliances": array:1 [
0 => "Central Vacuum"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:28:40.266519+00:00"
+"Directions": "Upper Wentworth to Southpark to Randolf Crt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1595604"
+"ListOfficeKey": "55061"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T19:53:52Z"
+"PhotosCount": 48
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T19:53:52Z"
+"Stories": "2.0"
+"StreetName": "RANDOLF"
+"StreetNumber": "59"
+"StreetSuffix": "Court"
+"SubdivisionName": "186 - Rushdale/Butler"
+"TaxAnnualAmount": "5568.24"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29948495/59-randolf-court-hamilton"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 2518
+"BelowGradeFinishedArea": 1076
+"OriginalEntryTimestamp": "2026-06-24T19:11:03.53Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1155975"
+"ListOfficeNationalAssociationId": "1003659"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29948495')"
+"ID": "1565001"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1561772"
+post_author: 1
+"ListingKey": "29946806"
+"ListingId": "40842691"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:20:10Z"
+"RFModificationTimestamp": "2026-06-25T20:10:21Z"
+"ListPrice": 825000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1690.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9A2P5"
+"UnparsedAddress": "78 STARLING Drive, Hamilton, Ontario L9A2P5"
+"Coordinates": array:2 [
0 => -79.8687446
1 => 43.2208128
]
+"Latitude": 43.2208128
+"Longitude": -79.8687446
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to 78 Starling Dr! Perfectly tucked away on a quiet cul-de-sac corner lot, this stunning 3 bed, 2.5 bath home backs onto a park, offering green space and added privacy, all enjoyed from your fully fenced backyard with premium composite fencing. Inside, the open-concept main floor is loaded with style featuring hardwood flooring, a matching oak staircase, and a gorgeous chef-inspired kitchen with an oversized island, custom cabinetry, built-in microwave/wall oven, pantry, and bonus storage closet off dining area. Upstairs, unwind in your spacious primary bedroom with a walk-in closet and ensuite bath. Plus enjoy the convenience of second-floor laundry with custom built-in cabinetry. Location? It doesn’t get better than this. Schools, groceries, shopping, and the mall are all within walking distance, with quick highway access making commuting a breeze. (id:62650)"
+"Appliances": array:1 [
0 => "Central Vacuum"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:10:11.346776+00:00"
+"Directions": "Mohawk Rd E / Cardinal Dr / Starling Dr"
+"ExteriorFeatures": array:4 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
3 => "Vinyl siding"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2027287"
+"ListOfficeKey": "237129"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T15:52:25Z"
+"PhotosCount": 24
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:11:44Z"
+"Stories": "2.0"
+"StreetName": "STARLING"
+"StreetNumber": "78"
+"StreetSuffix": "Drive"
+"SubdivisionName": "181 - Bruleville"
+"TaxAnnualAmount": "5749"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946806/78-starling-drive-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "I1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 1690
+"OriginalEntryTimestamp": "2026-06-24T15:50:41.83Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1307358"
+"ListOfficeNationalAssociationId": "1283982"
+"Media": array:24 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946806')"
+"ID": "1561772"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1561936"
+post_author: 1
+"ListingKey": "29950928"
+"ListingId": "40837840"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T18:20:10Z"
+"RFModificationTimestamp": "2026-06-25T20:09:59Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.17
+"LivingArea": 3598.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V4B9"
+"UnparsedAddress": "476 EAST 37TH Street, Hamilton, Ontario L8V4B9"
+"Coordinates": array:2 [
0 => -79.8452346
1 => 43.2209575
]
+"Latitude": 43.2209575
+"Longitude": -79.8452346
+"YearBuilt": 1951
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 476 East 37th Street, a rare opportunity to own a spacious family home lovingly maintained by the same owners since 1956! Much larger than it appears, this exceptional residence was expanded in 1977 with the addition of a generous family room and fully finished basement below, creating ideal space for growing families and entertaining. Situated on an impressive 49' x 150' pool size lot, the property offers excellent curb appeal, parking for five vehicles, a separate side entrance, and a private partially fenced backyard. Inside, you will find a bright eat-in kitchen with timeless oak cabinetry, a formal living room, and a spacious family room featuring hardwood flooring, a cozy gas fireplace, and an expansive dining area designed to comfortably host large family gatherings and entertaining. Garden doors lead to the patio and oversized backyard, creating a seamless indoor-outdoor living experience. The main floor offers two bedrooms and a 4-piece bathroom, while the upper-level features two additional bedrooms and a convenient 2-piece bath. The finished lower level provides exceptional flexibility with a recreation room, games room with fireplace, laundry area, 3-piece bathroom, and a bonus room perfect for a home office, storage, or potential future bedroom or kitchen. Located in the desirable Macassa neighbourhood on the Hamilton Mountain, this home is close to schools, parks, shopping, transit, and offers easy access to the LINC, Red Hill Valley Parkway, and Highway 403. Proudly cared for by the same family for seven decades, this cherished home offers outstanding space, versatility, and endless potential for its next family. (id:62650)"
+"Appliances": array:5 [
0 => "Refrigerator"
1 => "Water meter"
2 => "Dishwasher"
3 => "Stove"
4 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:09:49.594999+00:00"
+"Directions": "Mohawk Road to East 37th"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1523905"
+"ListOfficeKey": "277164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Private Yard"
]
+"LotSizeDimensions": "0.17"
+"PhotosChangeTimestamp": "2026-06-25T12:51:03Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T18:12:37Z"
+"Stories": "1.5"
+"StreetName": "EAST 37TH"
+"StreetNumber": "476"
+"StreetSuffix": "Street"
+"SubdivisionName": "178 - Macassa"
+"TaxAnnualAmount": "5465.89"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/476_e_37th_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/29950928/476-east-37th-street-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 2095
+"BelowGradeFinishedArea": 1503
+"OriginalEntryTimestamp": "2026-06-25T12:51:02.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1126121"
+"ListOfficeNationalAssociationId": "1306309"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29950928')"
+"ID": "1561936"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25287
+post_id: "1561717"
+post_author: 1
+"ListingKey": "29945564"
+"ListingId": "40842547"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T16:00:13Z"
+"RFModificationTimestamp": "2026-06-25T20:05:06Z"
+"ListPrice": 879900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.1
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L9A4Z8"
+"UnparsedAddress": "31 PINEWARBLER Drive, Hamilton, Ontario L9A4Z8"
+"Coordinates": array:2 [
0 => -79.8698775
1 => 43.2173413
]
+"Latitude": 43.2173413
+"Longitude": -79.8698775
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Are you looking for a charming single detached backsplit located in the desirable Hamilton Mountain area. Built in 1986 and backing onto peaceful greenspace, this home offers the perfect blend of privacy, comfort, and family friendly living. The exterior features a covered front porch and impressive parking for up to five vehicles, including space in the 1.5 car garage and a double wide, exposed aggregate driveway. The backyard is a true highlight, offering a large fenced yard and a fantastic in ground saltwater pool that creates a private oasis for summer enjoyment. Inside, the home offers approximately 2,000 square feet above grade, along with a finished lower level that adds even more functional living space. Upon entering, you’re welcomed by a spacious foyer that leads left into a large separate living room with hardwood floors, seamlessly connected to the formal dining room. To the right, you’ll find convenient inside entry from the garage. The bright eat in kitchen features white cabinetry, tile flooring, and a skylight that fills the space with natural light. The upper level includes a generous primary bedroom with double closets and a private three piece ensuite, along with two additional bedrooms and a five piece family bathroom with double sinks. The lower level offers a warm and inviting family room complete with a gas fireplace, as well as a fourth bedroom, a full bathroom, and the laundry area. The basement level extends the living space even further with a finished rec room featuring a wet bar. This location is exceptionally convenient to Lime Ridge Mall, the Lincoln Alexander Parkway at Upper Wentworth, schools, parks shopping, dining, commuting routes, and amenities are all close at hand. Please take a moment to review the marketing video, floor plans and the 360 degree photography to get a complete grasp of what the home property has to offer. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
7 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T20:04:58.813910+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750027"
+"ListOfficeKey": "280838"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T11:49:47Z"
+"PhotosCount": 38
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T15:50:48Z"
+"Stories": "3.0"
+"StreetName": "PINEWARBLER"
+"StreetNumber": "31"
+"StreetSuffix": "Drive"
+"SubdivisionName": "181 - Bruleville"
+"TaxAnnualAmount": "6875"
+"VirtualTourURLUnbranded": "https://youtu.be/SJKMxZsmO6s"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29945564/31-pinewarbler-drive-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1888678"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "280838"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2071
+"BelowGradeFinishedArea": 705
+"OriginalEntryTimestamp": "2026-06-24T11:49:47.31Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1174364"
+"ListOfficeNationalAssociationId": "1317747"
+"CoListAgentNationalAssociationId": "1210376"
+"CoListOfficeNationalAssociationId": "1317747"
+"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('29945564')"
+"ID": "1561717"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1557091"
+post_author: 1
+"ListingKey": "29941107"
+"ListingId": "X13477808"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T15:30:10Z"
+"RFModificationTimestamp": "2026-06-23T16:58:44Z"
+"ListPrice": 720000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Templemead)"
+"PostalCode": "L8W1S1"
+"UnparsedAddress": "15 TUNA COURT, Hamilton (Templemead), Ontario L8W1S1"
+"Coordinates": array:2 [
0 => -79.844761
1 => 43.198984
]
+"Latitude": 43.198984
+"Longitude": -79.844761
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Hamilton Mountain! This Fantastic Semi-Detached Home is Located In a Family Friendly Area. Home Features 3 Generously sized Bedrooms, 2 Bahts, Eat -In Kitchen And Large Living Room/Dining Room. The Living Room Opens Onto An Expansive Balcony. Enjoy Your Large Private Yard Perfect For The Family And Entertaining. Conveniently Located Just Minutes From The Lincoln Alexander Parkway and Highway 403, Perfectly Positioned For Commuters while Remaining Close To Schools, Parks, Shopping, Restaurants, Public Transit, Recreation Centres, And Everyday Amenities. Whether You Looking For Your First Home, An Investment Opportunity, Or A Property With The Ability T Add Value Over Time. This House is Full Of Potential In An Exceptional Location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Water purifier"
2 => "Jacuzzi"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T16:58:39.900990+00:00"
+"Directions": "Cross Streets: Stone Church Rd.E / Tunbridge Cres. ** Directions: Tunbridge Cres./Tuna Crt."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1689995"
+"ListOfficeKey": "293485"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "32.5 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T15:21:21Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T15:21:21Z"
+"Stories": "1.0"
+"StreetName": "Tuna"
+"StreetNumber": "15"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "4461.46"
+"VirtualTourURLUnbranded": "https://otido.com/15tuna/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Templemead"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29941107/15-tuna-court-hamilton-templemead-templemead"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 32.6
+"OriginalEntryTimestamp": "2026-06-23T15:07:04.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1219045"
+"ListOfficeNationalAssociationId": "1427673"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941107')"
+"ID": "1557091"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 151
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]