array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29982169 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "1587262"
+post_author: 1
+"ListingKey": "29982169"
+"ListingId": "40844657"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T22:40:06Z"
+"RFModificationTimestamp": "2026-07-03T01:16:37Z"
+"ListPrice": 274990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 635.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8H1T7"
+"UnparsedAddress": "81 CAMBRIDGE Avenue, Hamilton, Ontario L8H1T7"
+"Coordinates": array:2 [
0 => -79.8090474
1 => 43.2450587
]
+"Latitude": 43.2450587
+"Longitude": -79.8090474
+"YearBuilt": 1926
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 81 Cambridge Avenue, Hamilton! This 2-bedroom, 1-bathroom home offers a fantastic opportunity for buyers looking to personalize a property and build equity. Recent updates include fresh paint throughout, new lighting, a refreshed kitchen featuring new cabinetry and a stylish backsplash, and a brand-new rear deck that's perfect for outdoor enjoyment. The concrete front driveway provides convenient off-street parking, while the functional layout offers plenty of potential for future improvements and customization. Whether you're a first-time buyer looking to put your own stamp on a home or an investor seeking your next project, this property presents an excellent opportunity. Conveniently located close to parks, schools, shopping, public transit, and major commuter routes, this home is full of potential in a well-established Hamilton neighbourhood. (id:62650)"
+"Appliances": array:1 [
0 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T01:16:26.424905+00:00"
+"Directions": "Turn West on Cambridge from Keniworth"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2061846"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Industrial mall/subdivision"
]
+"PhotosChangeTimestamp": "2026-07-02T22:31:32Z"
+"PhotosCount": 24
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T22:31:31Z"
+"Stories": "1.0"
+"StreetName": "CAMBRIDGE"
+"StreetNumber": "81"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "201 - Crown Point"
+"TaxAnnualAmount": "2595.01"
+"Utilities": array:1 [
0 => "Telephone"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [
"RoomKey" => "1673681258"
"RoomType" => "Living room"
"ListingId" => "40844657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29982169"
"RoomLength" => null
"RoomDimensions" => "16'3'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:31:31.91Z"
]
1 => array:11 [
"RoomKey" => "1673681259"
"RoomType" => "Kitchen"
"ListingId" => "40844657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29982169"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:31:31.91Z"
]
2 => array:11 [
"RoomKey" => "1673681260"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29982169"
"RoomLength" => null
"RoomDimensions" => "17'0'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:31:31.91Z"
]
3 => array:11 [
"RoomKey" => "1673681261"
"RoomType" => "Bedroom"
"ListingId" => "40844657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29982169"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:31:31.91Z"
]
4 => array:11 [
"RoomKey" => "1673681262"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844657"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29982169"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-02T22:31:31.91Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29982169/81-cambridge-avenue-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2230350"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262664"
+"GeocodeManualYN": true
+"ZoningDescription": "D"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 635
+"OriginalEntryTimestamp": "2026-07-02T22:31:31.84Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1336875"
+"ListOfficeNationalAssociationId": "1344650"
+"CoListAgentNationalAssociationId": "1471553"
+"CoListOfficeNationalAssociationId": "1223042"
+"Media": array:24 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29982169_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/c3536fb0bb8039e167dbd7a6ba039185.webp"
"MediaSize" => 136982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-c3536fb0bb8039e167dbd7a6ba039185.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29982169_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/b01dd96b2104fc8bbfc2dff60af4ea9a.webp"
"MediaSize" => 147061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-b01dd96b2104fc8bbfc2dff60af4ea9a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29982169_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/0cc802df40383a17c2084c5c1dbe15f2.webp"
"MediaSize" => 42179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-0cc802df40383a17c2084c5c1dbe15f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29982169_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/83337d2580c255e18976f626610fe526.webp"
"MediaSize" => 49934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-83337d2580c255e18976f626610fe526.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29982169_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/541a8335cf2d8d97c8321fae10712622.webp"
"MediaSize" => 38943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-541a8335cf2d8d97c8321fae10712622.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29982169_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/7a29d5983a71b028735cdf60f35b7bc8.webp"
"MediaSize" => 35768
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-7a29d5983a71b028735cdf60f35b7bc8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29982169_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/21e5f8aa63acaa19b2d79c5d1363af7d.webp"
"MediaSize" => 39301
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-21e5f8aa63acaa19b2d79c5d1363af7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29982169_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/4e7236d7bac89b1b4fb2f643ac394622.webp"
"MediaSize" => 35160
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-4e7236d7bac89b1b4fb2f643ac394622.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29982169_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/5b3799627de63e5d8e505286fde078e4.webp"
"MediaSize" => 40045
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-5b3799627de63e5d8e505286fde078e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29982169_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/6ddabb9acad4acf8adda6c73606ade5a.webp"
"MediaSize" => 35063
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-6ddabb9acad4acf8adda6c73606ade5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29982169_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/672503d2b6a5512b61c6fab6d92f263d.webp"
"MediaSize" => 60615
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-672503d2b6a5512b61c6fab6d92f263d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29982169_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/b2dc0533c9ff185a4f7b180aa9ed2b1a.webp"
"MediaSize" => 58578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-b2dc0533c9ff185a4f7b180aa9ed2b1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29982169_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/bee93d7eb7bdd69c7b802e00f0295aeb.webp"
"MediaSize" => 51346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-bee93d7eb7bdd69c7b802e00f0295aeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29982169_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/1f99cc3ba2d10d292e88e775e6c1709b.webp"
"MediaSize" => 43212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-1f99cc3ba2d10d292e88e775e6c1709b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29982169_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/3b52b61ebfdadbc95390f412a76f11c0.webp"
"MediaSize" => 49282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-3b52b61ebfdadbc95390f412a76f11c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29982169_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/e58deb819c26b63f5f34c5cff71f9f23.webp"
"MediaSize" => 61465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-e58deb819c26b63f5f34c5cff71f9f23.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29982169_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/5f7efd1d812e2f1a611998000d831e19.webp"
"MediaSize" => 49059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-5f7efd1d812e2f1a611998000d831e19.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29982169_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/e83b4174275ca17850c9831e997a314e.webp"
"MediaSize" => 61917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-e83b4174275ca17850c9831e997a314e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29982169_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/3f2b4da8379565f16f63fe0cc652db9f.webp"
"MediaSize" => 75889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-3f2b4da8379565f16f63fe0cc652db9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29982169_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/627bd96f30a070d6d01cdd14d90b93e1.webp"
"MediaSize" => 100541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-627bd96f30a070d6d01cdd14d90b93e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29982169_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/285815c43b5a056230da40a3d4ca17b9.webp"
"MediaSize" => 212673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-285815c43b5a056230da40a3d4ca17b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29982169_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/7c0b1b09e2d7cef8f5b85125040c39e8.webp"
"MediaSize" => 210021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-7c0b1b09e2d7cef8f5b85125040c39e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29982169_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/8d20131c0c3315a839accf49d3f6588c.webp"
"MediaSize" => 210764
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-8d20131c0c3315a839accf49d3f6588c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29982169_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982169/1e0ec4c8b269e9fad28b6a99f899a4ca.webp"
"MediaSize" => 202998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982169/thumbnail-1e0ec4c8b269e9fad28b6a99f899a4ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844657"
"ResourceRecordKey" => "29982169"
"ModificationTimestamp" => "2026-07-02T22:31:31.86Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982169')"
+"ID": "1587262"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 284641" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24873
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2061846" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24842
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29982169'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25217
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29982169'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25233
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29982169' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8090474 43.2450587)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25286
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25280
+post_id: "1587578"
+post_author: 1
+"ListingKey": "29982826"
+"ListingId": "X13516482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T00:50:04Z"
+"RFModificationTimestamp": "2026-07-03T01:35:04Z"
+"ListPrice": 2288888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Sherwood)"
+"PostalCode": "L8T1A6"
+"UnparsedAddress": "274 MOUNTAIN BROW BOULEVARD, Hamilton (Sherwood), Ontario L8T1A6"
+"Coordinates": array:2 [
0 => -79.819477
1 => 43.229595
]
+"Latitude": 43.229595
+"Longitude": -79.819477
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "An Absolute Masterpiece of Mid-Century Inspired Luxury Living. Prepare to be captivated. Reimagined and carefully crafted by the elite team at Exquisite Living Homes, this mid-century gem marries sleek modern luxury with an unbeatable location at the peak of the Hamilton Escarpment. Picture starting your mornings with a coffee on the front porch, watching the sun rise over the Hamilton skyline and Lake Ontario on your massive, half-acre property. Pulling up the grand circular driveway, you'll immediately sense the scale of this unique custom sidesplit. Inside, the home unfolds beautifully, anchored by a jaw-dropping bookmatched marble gas fireplace. The kitchen is the true heart of the home-outfitted with gorgeous two-toned cabinets, endless quartz counters, a sprawling island, and high-end built-in appliances. Whether you're hosting intimate family dinners or grand celebrations, the main floor flows effortlessly with two distinct living areas, rich hardwood floors, and a gorgeous powder room. Your primary suite serves as a daily escape, boasting two walk-in closets and a deep, spa-like bath. The jaw-dropping great room steals the show with its vaulted ceilings and massive windows that flood the space with natural light. Upstairs, you'll find two additional cozy bedrooms and a full bath, while the lower level features a super-sized mudroom-perfect for busy families coming in from the double garage. Outside, the backyard is your own private resort, complete with a covered porch, outdoor wood-ceiling fireplace, and lush, irrigated gardens. Steps from local trails, great schools, and easy highway access, this is the forever home you've been waiting for. Don't miss out on this rare opportunity! (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Freezer"
9 => "Oven - Built-In"
10 => "Hood Fan"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Crawl space"
2 => "None"
3 => "Walk out"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T01:34:57.073299+00:00"
+"Directions": "Cross Streets: Oakcrest Dr. ** Directions: Kenilworth or Sherman Access, up Kenilworth Access, East on Mountain Brow Blvd."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2109882"
+"ListOfficeKey": "284773"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Dry"
2 => "Level"
]
+"LotSizeDimensions": "100 x 250 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-07-03T00:42:11Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T00:42:11Z"
+"StreetName": "Mountain Brow"
+"StreetNumber": "274"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "10573.62"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "City view,View"
+"VirtualTourURLUnbranded": "https://360.api360.ca/tours/8qea7gScB"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1673776407"
"RoomType" => "Living room"
"ListingId" => "X13516482"
"RoomLevel" => "Main level"
"RoomWidth" => 7.72
"ListingKey" => "29982826"
"RoomLength" => 9.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.75Z"
]
1 => array:11 [
"RoomKey" => "1673776408"
"RoomType" => "Mud room"
"ListingId" => "X13516482"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.05
"ListingKey" => "29982826"
"RoomLength" => 6.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.75Z"
]
2 => array:11 [
"RoomKey" => "1673776409"
"RoomType" => "Kitchen"
"ListingId" => "X13516482"
"RoomLevel" => "Main level"
"RoomWidth" => 5.82
"ListingKey" => "29982826"
"RoomLength" => 6.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.75Z"
]
3 => array:11 [
"RoomKey" => "1673776410"
"RoomType" => "Family room"
"ListingId" => "X13516482"
"RoomLevel" => "Main level"
"RoomWidth" => 4.65
"ListingKey" => "29982826"
"RoomLength" => 5.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.76Z"
]
4 => array:11 [
"RoomKey" => "1673776411"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13516482"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29982826"
"RoomLength" => 6.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.76Z"
]
5 => array:11 [
"RoomKey" => "1673776412"
"RoomType" => "Bathroom"
"ListingId" => "X13516482"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29982826"
"RoomLength" => 4.22
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.76Z"
]
6 => array:11 [
"RoomKey" => "1673776413"
"RoomType" => "Office"
"ListingId" => "X13516482"
"RoomLevel" => "Main level"
"RoomWidth" => 3.43
"ListingKey" => "29982826"
"RoomLength" => 3.48
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.76Z"
]
7 => array:11 [
"RoomKey" => "1673776414"
"RoomType" => "Bathroom"
"ListingId" => "X13516482"
"RoomLevel" => "Main level"
"RoomWidth" => 1.47
"ListingKey" => "29982826"
"RoomLength" => 1.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.76Z"
]
8 => array:11 [
"RoomKey" => "1673776415"
"RoomType" => "Bedroom 2"
"ListingId" => "X13516482"
"RoomLevel" => "Second level"
"RoomWidth" => 3.35
"ListingKey" => "29982826"
"RoomLength" => 6.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.76Z"
]
9 => array:11 [
"RoomKey" => "1673776416"
"RoomType" => "Bedroom 3"
"ListingId" => "X13516482"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29982826"
"RoomLength" => 5.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.76Z"
]
10 => array:11 [
"RoomKey" => "1673776417"
"RoomType" => "Bathroom"
"ListingId" => "X13516482"
"RoomLevel" => "Second level"
"RoomWidth" => 2.49
"ListingKey" => "29982826"
"RoomLength" => 3.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-03T00:42:11.76Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Sherwood"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29982826/274-mountain-brow-boulevard-hamilton-sherwood-sherwood"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
2 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"ZoningDescription": "B/S-1669"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 100.0
+"OriginalEntryTimestamp": "2026-07-03T00:42:11.72Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1378640"
+"ListOfficeNationalAssociationId": "1344627"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29982826_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/e87a805c515d8b568b9cf929316343f6.webp"
"MediaSize" => 220219
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-e87a805c515d8b568b9cf929316343f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29982826_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/1bb8cf110fec18c9e3041c59e45e8e51.webp"
"MediaSize" => 168868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-1bb8cf110fec18c9e3041c59e45e8e51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29982826_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/ef8d0fc091ac5c7d190cfda0fdc96de4.webp"
"MediaSize" => 201998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-ef8d0fc091ac5c7d190cfda0fdc96de4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29982826_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/30a47120400e51332f216263a7d15959.webp"
"MediaSize" => 167267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-30a47120400e51332f216263a7d15959.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29982826_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/ce6bfc7fdb973405fd547b18d14fd922.webp"
"MediaSize" => 70922
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-ce6bfc7fdb973405fd547b18d14fd922.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29982826_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/066a28a75d70c8effb54d1c6c3b09e39.webp"
"MediaSize" => 64883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-066a28a75d70c8effb54d1c6c3b09e39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29982826_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/618ff05093997484003fdf41cf8c7313.webp"
"MediaSize" => 68830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-618ff05093997484003fdf41cf8c7313.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29982826_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/d48ed852a7c54a55696593598de546e2.webp"
"MediaSize" => 78619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-d48ed852a7c54a55696593598de546e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29982826_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/8eaacc1531394aa63f591fa470731737.webp"
"MediaSize" => 61930
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-8eaacc1531394aa63f591fa470731737.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29982826_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/f3d03dc3c2231aa81045c7bfab7ed3bf.webp"
"MediaSize" => 77011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-f3d03dc3c2231aa81045c7bfab7ed3bf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29982826_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/9bfec5aa300c11b427ffc5b879e0ffb1.webp"
"MediaSize" => 75166
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-9bfec5aa300c11b427ffc5b879e0ffb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29982826_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/b4a8727001f5cf7abab8f2e302094155.webp"
"MediaSize" => 75618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-b4a8727001f5cf7abab8f2e302094155.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29982826_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/9fbd7f4f313f36ec1725e5b39d482fe5.webp"
"MediaSize" => 66852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-9fbd7f4f313f36ec1725e5b39d482fe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29982826_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/94edcade9cf0be30c366351a4e05cbe5.webp"
"MediaSize" => 83835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-94edcade9cf0be30c366351a4e05cbe5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29982826_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/ca9f95fa0a3f70bb41eeec0018a2a032.webp"
"MediaSize" => 99164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-ca9f95fa0a3f70bb41eeec0018a2a032.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29982826_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/0fc7e37c42e2d381ac91bea90ddc7fb5.webp"
"MediaSize" => 85828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-0fc7e37c42e2d381ac91bea90ddc7fb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29982826_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/c98c184ace8575d39cfc000c69a3e53c.webp"
"MediaSize" => 83235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-c98c184ace8575d39cfc000c69a3e53c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29982826_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/ac85230fa0d4bd9dc1a85c8c5489c321.webp"
"MediaSize" => 87967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-ac85230fa0d4bd9dc1a85c8c5489c321.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29982826_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/339456f54b4e20825b1a403617ad1b41.webp"
"MediaSize" => 72548
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-339456f54b4e20825b1a403617ad1b41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29982826_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/30c8e9e800678c4a4f88650d21917cee.webp"
"MediaSize" => 75354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-30c8e9e800678c4a4f88650d21917cee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29982826_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/663162703e00aefccd2b789681e27594.webp"
"MediaSize" => 66566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-663162703e00aefccd2b789681e27594.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29982826_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/8179c38209853038694091f74b2f4bbf.webp"
"MediaSize" => 64559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-8179c38209853038694091f74b2f4bbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29982826_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/01c144f36bbedf109b9ac03f67790121.webp"
"MediaSize" => 76434
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-01c144f36bbedf109b9ac03f67790121.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29982826_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/43ea60d0a5a79428944c0f1e52c4bded.webp"
"MediaSize" => 78771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-43ea60d0a5a79428944c0f1e52c4bded.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29982826_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/4fcbed8e3b57c3b6d1d2f8493954f20c.webp"
"MediaSize" => 112859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-4fcbed8e3b57c3b6d1d2f8493954f20c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29982826_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/330844de3455225d293966658ec4a2cb.webp"
"MediaSize" => 121331
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-330844de3455225d293966658ec4a2cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29982826_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/706de9adc1246f42b920048e802d457e.webp"
"MediaSize" => 97858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-706de9adc1246f42b920048e802d457e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29982826_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/df2caf187d9de0a7d1ff399c4cec536c.webp"
"MediaSize" => 79167
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-df2caf187d9de0a7d1ff399c4cec536c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29982826_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/192884a44b69980e76ea3797be43278b.webp"
"MediaSize" => 71041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-192884a44b69980e76ea3797be43278b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29982826_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/396c4c5c0092f6c6c8e053487c1c9799.webp"
"MediaSize" => 68101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-396c4c5c0092f6c6c8e053487c1c9799.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29982826_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/4aed28e77be88be726386dbc3113d109.webp"
"MediaSize" => 66404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-4aed28e77be88be726386dbc3113d109.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29982826_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/114b0c210872e8772adf5fc5a441df41.webp"
"MediaSize" => 73343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-114b0c210872e8772adf5fc5a441df41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29982826_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/67da6c06d91587db82815258b6783e13.webp"
"MediaSize" => 48471
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-67da6c06d91587db82815258b6783e13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29982826_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/8a5d92fe9890ca76b118da99e5c9e50c.webp"
"MediaSize" => 78850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-8a5d92fe9890ca76b118da99e5c9e50c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29982826_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/dd33ae05efbc405fb18bf750adad1abd.webp"
"MediaSize" => 69394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-dd33ae05efbc405fb18bf750adad1abd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29982826_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/52976ac21812962b528de8f9b257ffa0.webp"
"MediaSize" => 74859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-52976ac21812962b528de8f9b257ffa0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29982826_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/6b80e5c24fb138c25d3bd0fa6012e445.webp"
"MediaSize" => 56805
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-6b80e5c24fb138c25d3bd0fa6012e445.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29982826_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/92e138e821b7833d6f06ece12c82f1d8.webp"
"MediaSize" => 46085
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-92e138e821b7833d6f06ece12c82f1d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29982826_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/d6efd636b87edc027ada7db3fb3f51c4.webp"
"MediaSize" => 46581
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-d6efd636b87edc027ada7db3fb3f51c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29982826_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/b40e19ed6c108cecc60365197d6d9fcc.webp"
"MediaSize" => 246131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-b40e19ed6c108cecc60365197d6d9fcc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13516482"
"ResourceRecordKey" => "29982826"
"ModificationTimestamp" => "2026-07-03T00:42:11.72Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29982826_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29982826/858b0eb141ba3ed08b5a733abc48fa37.webp"
"MediaSize" => 234695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29982826/thumbnail-858b0eb141ba3ed08b5a733abc48fa37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
…5
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982826')"
+"ID": "1587578"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25282
+post_id: "1587579"
+post_author: 1
+"ListingKey": "29982468"
+"ListingId": "40844756"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T23:20:15Z"
+"RFModificationTimestamp": "2026-07-03T01:13:56Z"
+"ListPrice": 2288888.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.576
+"LivingArea": 3360.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T1A6"
+"UnparsedAddress": "274 MOUNTAIN BROW Boulevard, Hamilton, Ontario L8T1A6"
+"Coordinates": array:2 [
0 => -79.8195323
1 => 43.2295512
]
+"Latitude": 43.2295512
+"Longitude": -79.8195323
+"YearBuilt": 1953
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An Absolute Masterpiece of Mid-Century Inspired Luxury Living. Prepare to be captivated. Reimagined and carefully crafted by the elite team at Exquisite Living Homes, this mid-century gem marries sleek modern luxury with an unbeatable location at the peak of the Hamilton Escarpment. Picture starting your mornings with a coffee on the front porch, watching the sun rise over the Hamilton skyline and Lake Ontario on your massive, half-acre property. Pulling up the grand circular driveway, you'll immediately sense the scale of this unique custom sidesplit. Inside, the home unfolds beautifully, anchored by a jaw-dropping bookmatched marble gas fireplace. The kitchen is the true heart of the home-outfitted with gorgeous two-toned cabinets, endless quartz counters, a sprawling island, and high-end built-in appliances. Whether you're hosting intimate family dinners or grand celebrations, the main floor flows effortlessly with two distinct living areas, rich hardwood floors, and a gorgeous powder room. Your primary suite serves as a daily escape, boasting two walk-in closets and a deep, spa-like bath. The jaw-dropping great room steals the show with its vaulted ceilings and massive windows that flood the space with natural light. Upstairs, you'll find two additional cozy bedrooms and a full bath, while the lower level features a super-sized mudroom-perfect for busy families coming in from the double garage. Outside, the backyard is your own private resort, complete with a covered porch, outdoor wood-ceiling fireplace, and lush, irrigated gardens. Steps from local trails, great schools, and easy highway access, this is the forever home you've been waiting for. Don't miss out on this rare opportunity! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Dryer"
6 => "Freezer"
7 => "Oven - Built-In"
8 => "Hood Fan"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Crawl space"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T00:59:53.340617+00:00"
+"Directions": "From Kenilworth or Sherman Access continue upwards on Kenilworth Access and East onto Mountain Brow Blvd. 2nd house after Oakcrest Dr."
+"ExteriorFeatures": array:3 [
0 => "Wood"
1 => "Brick"
2 => "Stucco"
]
+"FireplaceFeatures": array:3 [
0 => "Electric"
1 => "Other - See remarks"
2 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525446"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.576"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T23:10:17Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T23:10:17Z"
+"Stories": "2.0"
+"StreetName": "MOUNTAIN BROW"
+"StreetNumber": "274"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "251 - Sherwood"
+"TaxAnnualAmount": "10144"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29982468/274-mountain-brow-boulevard-hamilton"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1858916"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55061"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "B/S-1669"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 3360
+"OriginalEntryTimestamp": "2026-07-02T23:10:17.12Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1063105"
+"ListOfficeNationalAssociationId": "1344654"
+"CoListAgentNationalAssociationId": "1200489"
+"CoListOfficeNationalAssociationId": "1003659"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982468')"
+"ID": "1587579"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25279
+post_id: "1585564"
+post_author: 1
+"ListingKey": "29976963"
+"ListingId": "40843657"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T12:20:04Z"
+"RFModificationTimestamp": "2026-07-02T19:52:47Z"
+"ListPrice": 386900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1040.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8H4X5"
+"UnparsedAddress": "65 HARMONY Avenue, Hamilton, Ontario L8H4X5"
+"Coordinates": array:2 [
0 => -79.8045961
1 => 43.2477255
]
+"Latitude": 43.2477255
+"Longitude": -79.8045961
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Brick Bungalow on wide lot with large ,detached garage and long, private driveway and good size backyard. Close to Centre Mall and public transportion . Main floor features shining hardwood floors, newly painted t\out main floor with new vinyl kitchen floor (June 2026) . Bright living and dining room, 2 bedrooms and full bath. Lower level , huge basement with gas fireplace, and new furnace (June 2026) . Newer front door and front deck . Great opporunity for investors,contractors or first time Buyers. (id:62650)"
+"Appliances": array:1 [
0 => "Refrigerator"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-02T19:52:38.034530+00:00"
+"Directions": "ALBANY"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1525329"
+"ListOfficeKey": "103841"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T12:10:44Z"
+"PhotosCount": 14
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T12:10:44Z"
+"Stories": "1.0"
+"StreetName": "HARMONY"
+"StreetNumber": "65"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "231 - Homeside"
+"TaxAnnualAmount": "3413.47"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29976963/65-harmony-avenue-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1040
+"OriginalEntryTimestamp": "2026-07-02T12:10:43.97Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1097773"
+"ListOfficeNationalAssociationId": "1165450"
+"Media": array:14 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29976963')"
+"ID": "1585564"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25283
+post_id: "1584085"
+post_author: 1
+"ListingKey": "29977955"
+"ListingId": "X13512102"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T15:00:17Z"
+"RFModificationTimestamp": "2026-07-02T17:25:16Z"
+"ListPrice": 658000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Delta)"
+"PostalCode": "L8K2E8"
+"UnparsedAddress": "226 OTTAWA STREET S, Hamilton (Delta), Ontario L8K2E8"
+"Coordinates": array:2 [
0 => -79.822479
1 => 43.23659
]
+"Latitude": 43.23659
+"Longitude": -79.822479
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Just steps from the cafes, restaurants, boutiques, and local favourites that make Ottawa Street one of Hamilton's most vibrant neighbourhoods, this well-maintained 4-bedroom, 2-bathroom home offers the perfect balance of character, space, and convenience. Set on a generous 30 x 115 ft lot with private parking, it's an ideal opportunity for families, professionals, or anyone looking to enjoy a walkable, community-focused lifestyle.Inside, bright and inviting living spaces are complemented by a functional layout with room for family, guests, or a home office. Outside, the deep backyard provides plenty of space to relax, entertain, or garden throughout the warmer months.With parks, schools, transit, and everyday amenities all nearby, this is more than just a home-it's a chance to be part of one of Hamilton's most sought-after neighbourhoods. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Water Heater - Tankless"
7 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:25:14.598404+00:00"
+"Directions": "Ottawa St & Lawrence Rd"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2104132"
+"ListOfficeKey": "283551"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "30 x 115.8 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T14:51:10Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T14:51:09Z"
+"Stories": "2.5"
+"StreetDirSuffix": "South"
+"StreetName": "Ottawa"
+"StreetNumber": "226"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3558"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "Delta"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29977955/226-ottawa-street-s-hamilton-delta-delta"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 30.0
+"OriginalEntryTimestamp": "2026-07-02T14:51:09.9Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373610"
+"ListOfficeNationalAssociationId": "1331582"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977955')"
+"ID": "1584085"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25281
+post_id: "1583164"
+post_author: 1
+"ListingKey": "29975912"
+"ListingId": "40844009"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T19:10:11Z"
+"RFModificationTimestamp": "2026-07-01T22:46:08Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1148.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L7H1"
+"UnparsedAddress": "5 ROWANWOOD Street, Hamilton, Ontario L8L7H1"
+"Coordinates": array:2 [
0 => -79.8209383
1 => 43.2565415
]
+"Latitude": 43.2565415
+"Longitude": -79.8209383
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Dreaming of homeownership but looking for ways to make your mortgage more affordable? Welcome to 5 Rowanwood St. This is your opportunity to purchase a home with room to grow, build equity, and create future income potential. Step inside to discover a open-concept main floor featuring a bright living area, convenient main floor laundry, a powder room, and a functional layout designed for everyday living. Upstairs offers three bedrooms, including an oversized primary bedroom, with the flexibility to suit your lifestyle and future needs. The unfinished basement features a separate entrance, providing an incredible opportunity for the next owner to finish the space and create additional living space, a private suite for family, or explore future rental possibilities. Outside, enjoy a private backyard ready to be transformed into your own outdoor retreat. Located just a 2-minute walk to public transit, this home is also close to schools, parks, shopping, and commuter routes, including the upcoming Confederation GO Station, making it an excellent location for commuters and long-term growth. Whether you're a first-time buyer looking to offset your future housing costs, a buyer wanting space for extended family, or someone looking to build equity through thoughtful improvements, this property offers incredible potential to make it your own. Opportunities like this don't come around often. Photos were taken prior to tenancy and have been virtually staged to show the full potential of this home. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-01T22:46:06.932008+00:00"
+"Directions": "Beach St & Ottawa St"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095213"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-07-01T19:02:29Z"
+"PhotosCount": 20
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T19:02:29Z"
+"Stories": "2.0"
+"StreetName": "ROWANWOOD"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"SubdivisionName": "201 - Crown Point"
+"TaxAnnualAmount": "3000"
+"VirtualTourURLUnbranded": "https://5rowanwoodstreet.info/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29975912/5-rowanwood-street-hamilton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "M6"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 25.0
+"AboveGradeFinishedArea": 1148
+"OriginalEntryTimestamp": "2026-07-01T19:02:29.17Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1367399"
+"ListOfficeNationalAssociationId": "1408460"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975912')"
+"ID": "1583164"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25276
+post_id: "1583161"
+post_author: 1
+"ListingKey": "29975994"
+"ListingId": "X13509322"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T19:50:01Z"
+"RFModificationTimestamp": "2026-07-01T22:43:13Z"
+"ListPrice": 572500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Crown Point)"
+"PostalCode": "L8H1G8"
+"UnparsedAddress": "487 DUNSMURE ROAD, Hamilton (Crown Point), Ontario L8H1G8"
+"Coordinates": array:2 [
0 => -79.8178178
1 => 43.2442391
]
+"Latitude": 43.2442391
+"Longitude": -79.8178178
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Set on a prime corner lot in Hamilton's coveted Crown Point, 487 Dunsmure Road is a 3-bed, 1+1-bath home full of character and smart comfort. Beautifully styled interiors blend original charm with modern updates, while an efficient heat pump keeps energy costs low year-round. An open living and dining room anchors everyday life-easy for morning coffee and made for unwinding in the evening-while warm sconce lighting throughout sets the mood from room to room. Three comfortable bedrooms offer restful retreats at day's end. The corner setting delivers a generous side garden with room to entertain, garden, or unwind. With an exceptionally high Walk Score, you're steps from Gage Park, Ottawa Street's shops and cafes, top schools, and transit in one of Hamilton's most walkable, family-friendly neighbourhoods. Move-in ready and rare to market. Welcome home. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T22:43:08.671949+00:00"
+"Directions": "Cross Streets: London and Dunsmure. ** Directions: Ottawa to Dunsmure."
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2143255"
+"ListOfficeKey": "50834"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25 x 68 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T19:43:03Z"
+"PhotosCount": 37
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T19:43:03Z"
+"Stories": "2.0"
+"StreetName": "Dunsmure"
+"StreetNumber": "487"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "2865.31"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Crown Point"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29975994/487-dunsmure-road-hamilton-crown-point-crown-point"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1598177"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "50834"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-07-01T19:43:03.36Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1394877"
+"ListOfficeNationalAssociationId": "1002686"
+"CoListAgentNationalAssociationId": "1293080"
+"CoListOfficeNationalAssociationId": "1002686"
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975994')"
+"ID": "1583161"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1583165"
+post_author: 1
+"ListingKey": "29975995"
+"ListingId": "X13509330"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T19:50:01Z"
+"RFModificationTimestamp": "2026-07-01T22:43:00Z"
+"ListPrice": 499999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Crown Point)"
+"PostalCode": "L8L7H1"
+"UnparsedAddress": "5 ROWANWOOD STREET, Hamilton (Crown Point), Ontario L8L7H1"
+"Coordinates": array:2 [
0 => -79.821056
1 => 43.256582
]
+"Latitude": 43.256582
+"Longitude": -79.821056
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Dreaming of homeownership but looking for ways to make your mortgage more affordable? Welcome to 5 Rowanwood St. This is your opportunity to purchase a home with room to grow, build equity, and create future income potential. Step inside to discover a open-concept main floor featuring a bright living area, convenient main floor laundry, a powder room, and a functional layout designed for everyday living. Upstairs offers three bedrooms, including an oversized primary bedroom, with the flexibility to suit your lifestyle and future needs. The unfinished basement features a separate entrance, providing an incredible opportunity for the next owner to finish the space and create additional living space, a private suite for family, or explore future rental possibilities. Outside, enjoy a private backyard ready to be transformed into your own outdoor retreat. Located just a 2-minute walk to public transit, this home is also close to schools, parks, shopping, and commuter routes, including the upcoming Confederation GO Station, making it an excellent location for commuters and long-term growth. Whether you're a first-time buyer looking to offset your future housing costs, a buyer wanting space for extended family, or someone looking to build equity through thoughtful improvements, this property offers incredible potential to make it your own. Opportunities like this don't come around often. Photos were taken prior to tenancy and have been virtually staged to show the full potential of this home. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Water Heater"
]
+"Basement": array:4 [
0 => "Unfinished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-01T22:42:54.571512+00:00"
+"Directions": "Beach St & Ottawa St"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2137005"
+"ListOfficeKey": "292168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "25 x 116.2 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T19:43:03Z"
+"PhotosCount": 22
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T19:43:03Z"
+"Stories": "2.0"
+"StreetName": "Rowanwood"
+"StreetNumber": "5"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3000"
+"VirtualTourURLUnbranded": "https://5rowanwoodstreet.info/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Crown Point"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29975995/5-rowanwood-street-hamilton-crown-point-crown-point"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-07-01T19:43:03.53Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389137"
+"ListOfficeNationalAssociationId": "1408695"
+"Media": array:22 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975995')"
+"ID": "1583165"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25284
+post_id: "1583077"
+post_author: 1
+"ListingKey": "29976047"
+"ListingId": "40844458"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T20:30:07Z"
+"RFModificationTimestamp": "2026-07-01T22:40:03Z"
+"ListPrice": 549000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1270.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8H4M2"
+"UnparsedAddress": "29 WEXFORD Avenue N, Hamilton, Ontario L8H4M2"
+"Coordinates": array:2 [
0 => -79.8126985
1 => 43.2418054
]
+"Latitude": 43.2418054
+"Longitude": -79.8126985
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IN-LAW SUITE!!! This charming, bright and updated home near Gage Park and Ottawa Street is perfect for investors, first-time buyers or downsizers, multi-generational living, short-term rentals, or to give a private space to teens or college/university goers. A separate side entrance from the driveway leads to the cozy basement in-law suite with its own kitchen, living/dining area, separate bedroom and beautiful 3-piece bathroom! The main floor features 3 bedrooms, including a generously-sized primary bedroom. The fully updated 5-piece bathroom has two sinks, making for easier mornings. The kitchen is updated and bright, with newer appliances and a custom live-edge breakfast bar. This is a truly move-in-ready home with endless potential! The shared laundry room can be found in a common area on the lower level, and is completely separate from both the main floor and in-law suites. The large driveway can accommodate 4 cars, with potential to add a detached garage. Free street parking is also available. Recent updates (within the past two years): Lead pipe from the house to the street fully replaced, Trees overhanging the house removed by an arborist, NEW A/C (2024), Furnace upgraded and “guts” replaced in 2024, making it new other than outside housing (2024), NEW flight of stairs from landing at side door to main floor (2024), Stairs from landing at side door to basement were reinforced (2024), NEW washing machine (2024). (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T22:40:00.317386+00:00"
+"Directions": "Main St. E. to Wexford Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2140170"
+"ListOfficeKey": "268714"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-07-01T20:20:36Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T20:20:36Z"
+"Stories": "1.0"
+"StreetDirSuffix": "North"
+"StreetName": "WEXFORD"
+"StreetNumber": "29"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "201 - Crown Point"
+"TaxAnnualAmount": "2876"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29976047/29-wexford-avenue-n-hamilton"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 760
+"BelowGradeFinishedArea": 510
+"OriginalEntryTimestamp": "2026-07-01T20:20:36.77Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1391915"
+"ListOfficeNationalAssociationId": "1230749"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29976047')"
+"ID": "1583077"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25285
+post_id: "1582498"
+post_author: 1
+"ListingKey": "29975733"
+"ListingId": "X13509174"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T18:20:03Z"
+"RFModificationTimestamp": "2026-07-01T18:42:33Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Crown Point)"
+"PostalCode": "L8H2E1"
+"UnparsedAddress": "25 HOPE AVENUE, Hamilton (Crown Point), Ontario L8H2E1"
+"Coordinates": array:2 [
0 => -79.808121
1 => 43.247628
]
+"Latitude": 43.247628
+"Longitude": -79.808121
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 25 Hope Ave, a solid all-brick home on the market for the first time! This centrally located gem offers easy access to major highways, parks, schools, shopping, and transit, making everyday life a breeze. Inside, enjoy a spacious open-concept layout with 2 bedrooms, a bonus attic addition ideal for extra storage or a 3rd bedroom, a separate laundry room, and an accessibility ramp for added convenience. With a new furnace and A/C already in place, this move-in ready home is a rare opportunity you won't want to miss. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T18:42:28.910042+00:00"
+"Directions": "Kenilworth Ave N & Hope Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2133003"
+"ListOfficeKey": "283291"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T18:12:50Z"
+"PhotosCount": 40
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T18:12:50Z"
+"Stories": "1.0"
+"StreetName": "Hope"
+"StreetNumber": "25"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "2505.24"
+"VirtualTourURLUnbranded": "https://mediatours.ca/property/25-hope-avenue-hamilton/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Crown Point"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29975733/25-hope-avenue-hamilton-crown-point-crown-point"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 25.0
+"OriginalEntryTimestamp": "2026-07-01T18:12:50.82Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1385607"
+"ListOfficeNationalAssociationId": "1326174"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975733')"
+"ID": "1582498"
}
]
+success: true
+page_size: 9
+page_count: 30
+count: 262
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]