array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29989226 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23446
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23448
+post_id: "1593119"
+post_author: 1
+"ListingKey": "29989226"
+"ListingId": "40845052"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T14:05:24Z"
+"RFModificationTimestamp": "2026-07-04T16:47:45Z"
+"ListPrice": 599000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V3K5"
+"UnparsedAddress": "151 WINCHESTER Boulevard, Hamilton, Ontario L8V3K5"
+"Coordinates": array:2 [
0 => -79.8373146
1 => 43.2184493
]
+"Latitude": 43.2184493
+"Longitude": -79.8373146
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Opportunity, potential, and an incredible backyard!! This is your chance to make a great home your own in one of Hamilton East Mountain's most sought-after neighbourhoods. Whether you're a first-time buyer looking to build equity, an investor searching for your next project, a handyman ready to add value, or a downsizer wanting the convenience of bungalow living, this 3+1 bedroom home offers endless possibilities. The bright and functional main floor provides a practical layout with three bedrooms and a kitchen that's ready for your personal vision. One of the home's biggest advantages is that all windows have already been replaced, allowing you to focus your investment where it matters most while enjoying improved comfort and energy efficiency. The partially finished basement features a fourth bedroom and an abundance of untapped space, offering the flexibility to create a spacious family room, home office, gym, hobby area, or additional living space to suit your lifestyle. Step outside and fall in love with the backyard! Beautifully designed for making memories, this private outdoor retreat features an above-ground pool, hot tub and plenty of room to entertain, and space for family gatherings, summer barbecues, or simply relaxing at the end of the day. It's the kind of backyard that's becoming increasingly difficult to find. Adding even more value is the detached 2-car garage, offering the perfect space for a workshop, hobbyist, extra storage, or the ultimate man cave. Situated in a quiet, family-friendly East Mountain neighbourhood close to parks, schools, shopping, transit, and major commuter routes, this property is full of potential in a location you'll love. Homes with this combination of solid bones, endless possibilities, and a backyard this exceptional don't come along often. Don't miss your chance to unlock the full potential of this fantastic property. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T16:47:40.788584+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2126582"
+"ListOfficeKey": "282362"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T13:59:10Z"
+"PhotosCount": 41
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T13:59:10Z"
+"Stories": "1.0"
+"StreetName": "WINCHESTER"
+"StreetNumber": "151"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "150 - Mountview"
+"TaxAnnualAmount": "4835.75"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1674965228"
"RoomType" => "Dining room"
"ListingId" => "40845052"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989226"
"RoomLength" => null
"RoomDimensions" => "3'2'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:10.24Z"
]
1 => array:11 [
"RoomKey" => "1674965229"
"RoomType" => "Laundry room"
"ListingId" => "40845052"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29989226"
"RoomLength" => null
"RoomDimensions" => "3'0'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:10.24Z"
]
2 => array:11 [
"RoomKey" => "1674965230"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845052"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989226"
"RoomLength" => null
"RoomDimensions" => "1'0'' x 6'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:10.24Z"
]
3 => array:11 [
"RoomKey" => "1674965231"
"RoomType" => "Bedroom"
"ListingId" => "40845052"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989226"
"RoomLength" => null
"RoomDimensions" => "3'2'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:10.25Z"
]
4 => array:11 [
"RoomKey" => "1674965232"
"RoomType" => "Bedroom"
"ListingId" => "40845052"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989226"
"RoomLength" => null
"RoomDimensions" => "3'3'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:10.25Z"
]
5 => array:11 [
"RoomKey" => "1674965233"
"RoomType" => "Bedroom"
"ListingId" => "40845052"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29989226"
"RoomLength" => null
"RoomDimensions" => "2'2'' x 9'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:10.25Z"
]
6 => array:11 [
"RoomKey" => "1674965234"
"RoomType" => "Bedroom"
"ListingId" => "40845052"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29989226"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 16'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-04T13:59:10.25Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29989226/151-winchester-boulevard-hamilton"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 100.0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-07-04T13:59:10.2Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1379908"
+"ListOfficeNationalAssociationId": "1320359"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29989226_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/8d4d41022399dc609896a69329c21c3a.webp"
"MediaSize" => 135591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-8d4d41022399dc609896a69329c21c3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a covered wood deck with cable railing"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29989226_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/178bf2dd12b595eaf4ab79f5ea0f0e25.webp"
"MediaSize" => 138933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-178bf2dd12b595eaf4ab79f5ea0f0e25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a covered porch with exposed timber framing, wood decking, and metal railing accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29989226_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/dbebcfe8fff8f92bbbd0f5005cf52ce0.webp"
"MediaSize" => 144728
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-dbebcfe8fff8f92bbbd0f5005cf52ce0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with a covered front porch featuring wood posts and railings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29989226_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/5ca9804570d949e6e2b2d5e1879d24b3.webp"
"MediaSize" => 169241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-5ca9804570d949e6e2b2d5e1879d24b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and stone facade with a covered porch featuring wood beam accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29989226_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/68f69a510b9337549c144d03302f4d41.webp"
"MediaSize" => 154304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-68f69a510b9337549c144d03302f4d41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a covered wood-frame porch with horizontal railing, a stone-edged garden bed, a concrete driveway, and a wood privacy fence with gate"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29989226_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/95945a8fbb5f33954a960ea16d311e5e.webp"
"MediaSize" => 143345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-95945a8fbb5f33954a960ea16d311e5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood-finish porch featuring a red entry door, multi-tone brick and stone facade, and a dark soffit with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29989226_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/30f38de050a733dd0e8ab1242541650c.webp"
"MediaSize" => 79692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-30f38de050a733dd0e8ab1242541650c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a decorative glass-paneled door, white panel door, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29989226_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/9cfc506ca293fd34d68ddfbaecd9607a.webp"
"MediaSize" => 84246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-9cfc506ca293fd34d68ddfbaecd9607a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living area featuring light wood-finish flooring, a kitchen with blue cabinetry and a white tiled backsplash, and white tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29989226_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/e4d488260beec4f87736328ab9262a46.webp"
"MediaSize" => 101170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-e4d488260beec4f87736328ab9262a46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29989226_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/7ef8e70a863c954f1a82aca0137889c6.webp"
"MediaSize" => 90250
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-7ef8e70a863c954f1a82aca0137889c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring complements the neutral wall color"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29989226_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/e30711a37b534ccd1eac6b0437b3d7cf.webp"
"MediaSize" => 107455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-e30711a37b534ccd1eac6b0437b3d7cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a large picture window, and direct access to a kitchen area with blue cabinetry, a built-in oven, and a tiled floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29989226_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/5daec0bf78be437ffe2bc34fe5cf669b.webp"
"MediaSize" => 91044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-5daec0bf78be437ffe2bc34fe5cf669b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring blue cabinetry and a tiled floor"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29989226_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/3fe967f0d342fc6f22c8af30806b5941.webp"
"MediaSize" => 89396
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-3fe967f0d342fc6f22c8af30806b5941.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29989226_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/50b03b45be1128069c48ae85e7939f78.webp"
"MediaSize" => 97741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-50b03b45be1128069c48ae85e7939f78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright entry area featuring a decorative glass panel door and tiled flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29989226_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/954ae3f8b1357464a08266acc564fa4e.webp"
"MediaSize" => 83975
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-954ae3f8b1357464a08266acc564fa4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen and dining area featuring blue cabinetry, white tiled flooring, a built-in oven, and overhead lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29989226_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/84bdd33b76e15d42171d991ca5f795f9.webp"
"MediaSize" => 81962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-84bdd33b76e15d42171d991ca5f795f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring blue cabinetry, light-toned countertops, white tile backsplash, and ceramic tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29989226_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/1457af8e04efe282070e41b80441d7b9.webp"
"MediaSize" => 79212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-1457af8e04efe282070e41b80441d7b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring blue cabinetry, light tile backsplash, and a stainless steel dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29989226_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/ba9d70995a513714af169e0fefdb75f8.webp"
"MediaSize" => 83026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-ba9d70995a513714af169e0fefdb75f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring blue cabinetry, a stainless steel dishwasher, white tile flooring, L-shaped countertops, and a white tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29989226_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/8dddfe284072c5e2e8dfe3a86d1b6da1.webp"
"MediaSize" => 82526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-8dddfe284072c5e2e8dfe3a86d1b6da1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring a half-wall partition, white tile flooring, wood-finish flooring, and a dining area with bar-height seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29989226_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/35367e8514ca10093aa2d457c681d0de.webp"
"MediaSize" => 84785
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-35367e8514ca10093aa2d457c681d0de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring blue cabinetry, a black side-by-side refrigerator, and a stainless steel dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29989226_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/06d6a267c0fe9d2ecd41a07cb28e7c97.webp"
"MediaSize" => 92139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-06d6a267c0fe9d2ecd41a07cb28e7c97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light wood-finish flooring, light gray wall paint, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29989226_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/78e20016ec9758edcb5be3743922d359.webp"
"MediaSize" => 94940
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-78e20016ec9758edcb5be3743922d359.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29989226_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/8cb2a1cc5c0f28031dff2ba46ecea366.webp"
"MediaSize" => 57157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-8cb2a1cc5c0f28031dff2ba46ecea366.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring light wood-finish flooring, light gray wall paint, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29989226_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/b3a60bca55763d09e5b0deae6dce1973.webp"
"MediaSize" => 114101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-b3a60bca55763d09e5b0deae6dce1973.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with integrated sink, chrome faucet, and a large framed mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29989226_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/f67ef6f4d159c82eaef28ed9e9e02b37.webp"
"MediaSize" => 93082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-f67ef6f4d159c82eaef28ed9e9e02b37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29989226_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/3480ee6d9f581f11d68a909801449667.webp"
"MediaSize" => 89341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-3480ee6d9f581f11d68a909801449667.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious area featuring light wood-finish flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29989226_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/541a9dd17e9f8338711e062aad1ca9de.webp"
"MediaSize" => 107426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-541a9dd17e9f8338711e062aad1ca9de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Recreational space featuring a built-in electric fireplace with a shiplap surround, recessed lighting, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29989226_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/7c342d0a8711c013071fb33ab8d0a6b8.webp"
"MediaSize" => 78450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-7c342d0a8711c013071fb33ab8d0a6b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished basement area featuring recessed lighting, light wood-finish flooring, a contemporary fireplace with a decorative surround, and a rectangular window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29989226_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/f52bb058059ed5f9d7b0343d673c1624.webp"
"MediaSize" => 89978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-f52bb058059ed5f9d7b0343d673c1624.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, recessed lighting, and a ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29989226_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/0ec94f8b107fd99d299ce08f1f5f66f2.webp"
"MediaSize" => 92297
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-0ec94f8b107fd99d299ce08f1f5f66f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, a ceiling fan, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29989226_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/aaf798388d0485fd15eff989ceff21c8.webp"
"MediaSize" => 130525
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-aaf798388d0485fd15eff989ceff21c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area with a utility sink and a gas water heater"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29989226_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/ac1c010334a669935a52970ff11b9016.webp"
"MediaSize" => 132749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-ac1c010334a669935a52970ff11b9016.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29989226_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/d70019f765e293474efe88fbc20dc4ad.webp"
"MediaSize" => 136284
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-d70019f765e293474efe88fbc20dc4ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29989226_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/eb38e13fca2d0041c0a10a75919cf5f6.webp"
"MediaSize" => 129555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-eb38e13fca2d0041c0a10a75919cf5f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29989226_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/f9c7617c4b11310c5e85175151a27d66.webp"
"MediaSize" => 135884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-f9c7617c4b11310c5e85175151a27d66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29989226_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/7f998984b8734c4281e808d11d352c53.webp"
"MediaSize" => 142950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-7f998984b8734c4281e808d11d352c53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29989226_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/09849643c11ff5fe4d1f2e1a4ce9a116.webp"
"MediaSize" => 148862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-09849643c11ff5fe4d1f2e1a4ce9a116.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive outdoor deck with a wooden pergola, built-in hot tub, and a privacy wall with integrated greenery"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29989226_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/567a8bc08b6b94a8d00cba4b5821ae99.webp"
"MediaSize" => 135075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-567a8bc08b6b94a8d00cba4b5821ae99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Backyard featuring an above-ground pool with a surrounding wood deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29989226_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/2c342310e7a388d4cddeefe0c56d830d.webp"
"MediaSize" => 133995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-2c342310e7a388d4cddeefe0c56d830d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Above-ground pool surrounded by a wooden deck, featuring a nearby shed with board and batten siding and a covered outdoor entertainment area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29989226_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/d5ffd191c4f3de8c1c5d4ca614122719.webp"
"MediaSize" => 118081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-d5ffd191c4f3de8c1c5d4ca614122719.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29989226_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989226/5757568833ad3c8fd0a38b6a7bb3b2e8.webp"
"MediaSize" => 117279
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989226/thumbnail-5757568833ad3c8fd0a38b6a7bb3b2e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845052"
"ResourceRecordKey" => "29989226"
"ModificationTimestamp" => "2026-07-04T13:59:10.21Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989226')"
+"ID": "1593119"
}
]
+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 282362" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24904
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2126582" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24862
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29989226'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25260
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29989226'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25276
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29989226' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.8373146 43.2184493)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25349
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
+post_id: "1593558"
+post_author: 1
+"ListingKey": "29989512"
+"ListingId": "X13522770"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T16:15:03Z"
+"RFModificationTimestamp": "2026-07-04T19:00:18Z"
+"ListPrice": 1.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Trenholme)"
+"PostalCode": "L8W2L4"
+"UnparsedAddress": "35 TRENHOLME CRESCENT, Hamilton (Trenholme), Ontario L8W2L4"
+"Coordinates": array:2 [
0 => -79.825281
1 => 43.203435
]
+"Latitude": 43.203435
+"Longitude": -79.825281
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "A rare find: a home that works as hard as you do. Set on a premium 42 x 110 ft lot, this 4+2 bedroom, 4-bath residence delivers over 3,156 sq. ft. of purposefully designed space, anchored by one of the most versatile layouts on the market at this price point. Extended family, rental income, or room to grow - this home is built to move with your life, not against it. The main level opens with a fully refinished white chef's kitchen - quartz counters, stainless appliances, porcelain tile and crown moulding - flowing into an open-concept living and dining space designed for entertaining, complemented by a separate family room for everyday living and privacy. A main-floor bedroom with a private full bath with standing tub, solves what most homes can't: multigenerational living, guest privacy, disabled friendly living, or a dedicated home office. Upstairs, the primary suite commands the full width of the home, featuring his-and-hers closets, a newly updated ensuite, and space for a private sitting area. The remaining bedrooms are generously sized and filled with natural light. The fully finished basement, with its own private side entrance, houses a complete in-law suite: two bedrooms, a full bath, kitchen, spacious rec room, and in-suite laundry. Live up and rent down, house extended family, or claim the entire home - the flexibility is yours. Extensively upgraded and move-in ready: hardwood flooring on the main level, refreshed bathrooms (2025), roof (2022), concrete driveway (2022), most windows (2023), fresh paint throughout (2025), and a new garage door (2026). Smoke-free, pet-free interior. Located in a quiet, established neighbourhood minutes from parks, schools, shopping, transit, and major highways - this is the kind of home buyers are actively searching for and rarely find. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-04T19:00:09.544934+00:00"
+"Directions": "Upper Kenilworth"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2075003"
+"ListOfficeKey": "296729"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "41 x 109.9 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T16:08:56Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T16:08:56Z"
+"Stories": "2.0"
+"StreetName": "Trenholme"
+"StreetNumber": "35"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6647"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [
"RoomKey" => "1675033539"
"RoomType" => "Living room"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 4.9
"ListingKey" => "29989512"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.23Z"
]
1 => array:11 [
"RoomKey" => "1675033540"
"RoomType" => "Bathroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 2.16
"ListingKey" => "29989512"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.23Z"
]
2 => array:11 [
"RoomKey" => "1675033541"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.11
"ListingKey" => "29989512"
"RoomLength" => 8.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
3 => array:11 [
"RoomKey" => "1675033542"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.38
"ListingKey" => "29989512"
"RoomLength" => 2.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
4 => array:11 [
"RoomKey" => "1675033543"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 6.09
"ListingKey" => "29989512"
"RoomLength" => 2.77
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
5 => array:11 [
"RoomKey" => "1675033544"
"RoomType" => "Kitchen"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.07
"ListingKey" => "29989512"
"RoomLength" => 4.17
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
6 => array:11 [
"RoomKey" => "1675033545"
"RoomType" => "Laundry room"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.0
"ListingKey" => "29989512"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
7 => array:11 [
"RoomKey" => "1675033546"
"RoomType" => "Bathroom"
"ListingId" => "X13522770"
"RoomLevel" => "Lower level"
"RoomWidth" => 0.0
"ListingKey" => "29989512"
"RoomLength" => 0.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
8 => array:11 [
"RoomKey" => "1675033547"
"RoomType" => "Dining room"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 3.32
"ListingKey" => "29989512"
"RoomLength" => 4.5
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
9 => array:11 [
"RoomKey" => "1675033548"
"RoomType" => "Kitchen"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 3.07
"ListingKey" => "29989512"
"RoomLength" => 4.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
10 => array:11 [
"RoomKey" => "1675033549"
"RoomType" => "Family room"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 6.58
"ListingKey" => "29989512"
"RoomLength" => 5.24
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
11 => array:11 [
"RoomKey" => "1675033550"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "29989512"
"RoomLength" => 3.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
12 => array:11 [
"RoomKey" => "1675033551"
"RoomType" => "Bathroom"
"ListingId" => "X13522770"
"RoomLevel" => "Main level"
"RoomWidth" => 1.9
"ListingKey" => "29989512"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.24Z"
]
13 => array:11 [
"RoomKey" => "1675033552"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 3.74
"ListingKey" => "29989512"
"RoomLength" => 7.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.25Z"
]
14 => array:11 [
"RoomKey" => "1675033553"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29989512"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.25Z"
]
15 => array:11 [
"RoomKey" => "1675033554"
"RoomType" => "Bedroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 3.38
"ListingKey" => "29989512"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.25Z"
]
16 => array:11 [
"RoomKey" => "1675033555"
"RoomType" => "Bathroom"
"ListingId" => "X13522770"
"RoomLevel" => "Second level"
"RoomWidth" => 1.86
"ListingKey" => "29989512"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-04T16:08:56.25Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Trenholme"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29989512/35-trenholme-crescent-hamilton-trenholme-trenholme"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 41.0
+"OriginalEntryTimestamp": "2026-07-04T16:08:56.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1350157"
+"ListOfficeNationalAssociationId": "1461559"
+"Media": array:41 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29989512_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/d8bd332a781b1f968b973fa88b4ae992.webp"
"MediaSize" => 150756
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-d8bd332a781b1f968b973fa88b4ae992.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29989512_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/d9a38c9769475c9490f1a5b8b1e2fe9e.webp"
"MediaSize" => 176738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-d9a38c9769475c9490f1a5b8b1e2fe9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29989512_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/36494c68d3b4e634a0d5bc1363d14b6f.webp"
"MediaSize" => 147612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-36494c68d3b4e634a0d5bc1363d14b6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29989512_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/f6d0b4499a4c414faba48bd728dae361.webp"
"MediaSize" => 192686
…9
]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989512')"
+"ID": "1593558"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1590875"
+post_author: 1
+"ListingKey": "29987469"
+"ListingId": "40845149"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T21:25:16Z"
+"RFModificationTimestamp": "2026-07-03T23:00:27Z"
+"ListPrice": 614900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1096.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V3J3"
+"UnparsedAddress": "302 EAST 28TH Street, Hamilton, Ontario L8V3J3"
+"Coordinates": array:2 [
0 => -79.8492095
1 => 43.2310659
]
+"Latitude": 43.2310659
+"Longitude": -79.8492095
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 302 East 28th! This move-in ready 4-bedroom, 1-bath home offers approximately 1,100 sq ft of bright, well-proportioned living space. Each room is generously sized and filled with natural light, reflecting genuine pride of ownership throughout. The fourth bedroom is currently used as a formal dining room, offering flexibility to suit your needs. The basement is unspoiled with a separate entrance, presenting excellent potential for an in-law suite or additional living space. Enjoy a private backyard, perfect for outdoor relaxation, plus a large, detached garage for parking or storage. Ideally located close to Juravinski Hospital, the Linc, shopping, bus routes, and good schools. A fantastic opportunity for buyers or investors alike. Some photos are adjusted via AI. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "High Traffic Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T23:00:17.540087+00:00"
+"Directions": "Fennell to East 28th"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1756636"
+"ListOfficeKey": "288925"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T21:18:14Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T21:18:14Z"
+"Stories": "1.0"
+"StreetName": "EAST 28TH"
+"StreetNumber": "302"
+"StreetSuffix": "Street"
+"SubdivisionName": "173 - Eastmount"
+"TaxAnnualAmount": "4190"
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/364690"
+"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/29987469/302-east-28th-street-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1096
+"OriginalEntryTimestamp": "2026-07-03T21:18:14.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1183428"
+"ListOfficeNationalAssociationId": "1372539"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987469')"
+"ID": "1590875"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1590817"
+post_author: 1
+"ListingKey": "29987710"
+"ListingId": "X13521102"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T21:50:04Z"
+"RFModificationTimestamp": "2026-07-03T22:48:21Z"
+"ListPrice": 614900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Eastmount)"
+"PostalCode": "L8V3J3"
+"UnparsedAddress": "302 EAST 28TH STREET, Hamilton (Eastmount), Ontario L8V3J3"
+"Coordinates": array:2 [
0 => -79.84919
1 => 43.2310564
]
+"Latitude": 43.2310564
+"Longitude": -79.84919
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 302 East 28th! This move-in ready 4-bedroom, 1-bath home offers approximately 1,100 sq ft of bright, well-proportioned living space. Each room is generously sized and filled with natural light, reflecting genuine pride of ownership throughout. The fourth bedroom is currently used as a formal dining room, offering flexibility to suit your needs. The basement is unspoiled with a separate entrance, presenting excellent potential for an in-law suite or additional living space. Enjoy a private backyard, perfect for outdoor relaxation, plus a large, detached garage for parking or storage. Ideally located close to Juravinski Hospital, the Linc, shopping, bus routes, and good schools. A fantastic opportunity for buyers or investors alike. Some photos are adjusted via AI. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Unfinished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T22:48:02.888621+00:00"
+"Directions": "Cross Streets: Fennell. ** Directions: Fennell to E 28th."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2128612"
+"ListOfficeKey": "288936"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40 x 108 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T21:40:25Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T21:40:25Z"
+"Stories": "1.0"
+"StreetName": "East 28th"
+"StreetNumber": "302"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4190"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vtnb/364690"
+"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": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Eastmount"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29987710/302-east-28th-street-hamilton-eastmount-eastmount"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-07-03T21:40:25.1Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1381721"
+"ListOfficeNationalAssociationId": "1374261"
+"Media": array:29 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29987710')"
+"ID": "1590817"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+post_id: "1590475"
+post_author: 1
+"ListingKey": "29986043"
+"ListingId": "40844791"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:25:13Z"
+"RFModificationTimestamp": "2026-07-03T19:52:22Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2059.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T3B3"
+"UnparsedAddress": "456 EAST 42ND Street, Hamilton, Ontario L8T3B3"
+"Coordinates": array:2 [
0 => -79.8409617
1 => 43.220058
]
+"Latitude": 43.220058
+"Longitude": -79.8409617
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 456 East 42nd Street, a bungalow offering 4 bedrooms, 2 bathrooms, and 2059 sf of finished living space on Hamilton Mountain. Situated on an approx. impressive 50 x 150 ft lot, this property features a long private driveway with parking for multiple vehicles and a heated tandem detached garage measuring 13'3 x 38'0, ideal for vehicles, a workshop, hobbies, or additional storage. Backing onto mature trees with no direct rear neighbours, the home enjoys a private setting close to parks, schools, shopping, transit, and the Lincoln M. Alexander Parkway. The main level features a bright, functional layout designed for everyday living. The living room is filled with natural light and flows seamlessly into the adjoining dining area, creating an inviting space for family gatherings. The kitchen offers ample cabinetry, generous counter space, and a practical layout with convenient access to the backyard. Three well-appointed bedrooms and a 4pc bathroom complete the main level. The fully finished lower level extends the living space with a generous family room centered around a gas fireplace/stove, creating a warm and inviting retreat. A fourth bedroom, 3pc bathroom, laundry area, and abundant storage provide exceptional flexibility for extended family, guests, or a home office. Step outside to enjoy the expansive backyard, where the impressive lot depth provides endless opportunities for entertaining, gardening, or future enjoyment. Mature trees along the rear of the property create a peaceful backdrop and enhance the sense of privacy. Combining a functional bungalow layout, an exceptional lot, a heated tandem garage, and parking for multiple vehicles, this Hamilton Mountain home offers outstanding versatility in a convenient family-friendly location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:52:17.499869+00:00"
+"Directions": "Mohawk Rd East to East 42nd St"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Metal"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1567201"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:18:25Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:18:25Z"
+"Stories": "1.0"
+"StreetName": "EAST 42ND"
+"StreetNumber": "456"
+"StreetSuffix": "Street"
+"SubdivisionName": "252 - Hampton Heights"
+"TaxAnnualAmount": "4874.14"
+"VirtualTourURLUnbranded": "https://youtu.be/uS2RmSZ1IcM"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986043/456-east-42nd-street-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1863243"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1157
+"BelowGradeFinishedArea": 902
+"OriginalEntryTimestamp": "2026-07-03T18:18:25.27Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1149561"
+"ListOfficeNationalAssociationId": "1324631"
+"CoListAgentNationalAssociationId": "1201229"
+"CoListOfficeNationalAssociationId": "1324631"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986043')"
+"ID": "1590475"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
+post_id: "1590193"
+post_author: 1
+"ListingKey": "29985357"
+"ListingId": "X13518854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T16:15:03Z"
+"RFModificationTimestamp": "2026-07-04T16:17:02Z"
+"ListPrice": 639000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Huntington)"
+"PostalCode": "L8T1W3"
+"UnparsedAddress": "3 KENWOOD CRESCENT, Hamilton (Huntington), Ontario L8T1W3"
+"Coordinates": array:2 [
0 => -79.825516
1 => 43.223114
]
+"Latitude": 43.223114
+"Longitude": -79.825516
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this meticulously maintained home on a quiet dead-end street in the highly desirable Huntington neighbourhood. Proudly owned by the same family for 26 years, this move-in-ready property has been extensively renovated inside and out, offering exceptional quality, comfort, and outdoor living.The stunning interior was completely rebuilt in 2009 and features solid maple cabinetry with granite countertops in the kitchen and bathrooms, beautifully updated spa-inspired bathrooms with glass-enclosed showers, jetted tubs, and whisper-quiet timer exhaust fans, solid oak staircase, custom blinds throughout, luxury vinyl flooring (2024), and premium 100 oz carpet in the finished lower level (2021). The kitchen is equipped with high-end KitchenAid appliances, a gas stove, new Whirlpool microwave (2023), and matching Whirlpool washer and dryer (2023). Entertain with ease thanks to the custom maple wet bar with granite counters.Step outside to your private backyard retreat featuring approximately 1,900 sq. ft. of stamped coloured concrete, an inground pool with new liner, coping and natural gas heater (2023), aluminum Sojag gazebo, separate BBQ gazebo with included gas Weber BBQ, large storage shed (2023), pool shed, and professionally refreshed fencing (2023). Additional updates include windows and roof (2016), steel entry doors, and Anderson front screen door.Perfectly situated within walking distance to public, Catholic, and French Immersion schools (JK-Grade 8), high school, parks, recreation centre, shopping, pharmacies, and public transit. Enjoy the charm of an established, family-friendly neighbourhood where great neighbours and a true sense of community make this an exceptional place to call home. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:27:06.898437+00:00"
+"Directions": "Fennell Ave E & Upper Ottawa St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1477197"
+"ListOfficeKey": "279771"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40.2 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T16:41:35Z"
+"PhotosCount": 37
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T16:08:53Z"
+"Stories": "1.0"
+"StreetName": "Kenwood"
+"StreetNumber": "3"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4687.28"
+"VirtualTourURLUnbranded": "https://youtu.be/_929Nl9ZQLk?si=F4i6GPdyOOmiif8Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Huntington"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985357/3-kenwood-crescent-hamilton-huntington-huntington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.2
+"OriginalEntryTimestamp": "2026-07-03T16:41:35.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1131407"
+"ListOfficeNationalAssociationId": "1308754"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985357')"
+"ID": "1590193"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25319
+post_id: "1590476"
+post_author: 1
+"ListingKey": "29986345"
+"ListingId": "X13519910"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:50:06Z"
+"RFModificationTimestamp": "2026-07-03T19:33:44Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Hampton Heights)"
+"PostalCode": "L8T3B3"
+"UnparsedAddress": "456 EAST 42ND STREET, Hamilton (Hampton Heights), Ontario L8T3B3"
+"Coordinates": array:2 [
0 => -79.8408989
1 => 43.2200445
]
+"Latitude": 43.2200445
+"Longitude": -79.8408989
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 456 East 42nd Street, a bungalow offering 4 bedrooms, 2 bathrooms, and 2059 sf of finished living space on Hamilton Mountain. Situated on an approx. impressive 50 x 150 ft lot, this property features a long private driveway with parking for multiple vehicles and a heated tandem detached garage measuring 13'3" x 38'0", ideal for vehicles, a workshop, hobbies, or additional storage. Backing onto mature trees with no direct rear neighbours, the home enjoys a private setting close to parks, schools, shopping, transit, and the Lincoln M. Alexander Parkway. The main level features a bright, functional layout designed for everyday living. The living room is filled with natural light and flows seamlessly into the adjoining dining area, creating an inviting space for family gatherings. The kitchen offers ample cabinetry, generous counter space, and a practical layout with convenient access to the backyard. Three well-appointed bedrooms and a 4pc bathroom complete the main level. The fully finished lower level extends the living space with a generous family room centered around a gas fireplace/stove, creating a warm and inviting retreat. A fourth bedroom, 3pc bathroom, laundry area, and abundant storage provide exceptional flexibility for extended family, guests, or a home office. Step outside to enjoy the expansive backyard, where the impressive lot depth provides endless opportunities for entertaining, gardening, or future enjoyment. Mature trees along the rear of the property create a peaceful backdrop and enhance the sense of privacy. Combining a functional bungalow layout, an exceptional lot, a heated tandem garage, and parking for multiple vehicles, this Hamilton Mountain home offers outstanding versatility in a convenient family-friendly location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:17:40.045093+00:00"
+"Directions": "Cross Streets: Mohawk Rd. East. ** Directions: Mohawk Rd East to East 42nd St."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933866"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "50 x 149.3 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:41:49Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:41:49Z"
+"Stories": "1.0"
+"StreetName": "East 42nd"
+"StreetNumber": "456"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4874.14"
+"VirtualTourURLUnbranded": "https://youtu.be/uS2RmSZ1IcM"
+"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": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Hampton Heights"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29986345/456-east-42nd-street-hamilton-hampton-heights-hampton-heights"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2197585"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-03T18:41:49.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1281797"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1446001"
+"CoListOfficeNationalAssociationId": "1231482"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986345')"
+"ID": "1590476"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1589185"
+post_author: 1
+"ListingKey": "29984607"
+"ListingId": "40844731"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T15:35:13Z"
+"RFModificationTimestamp": "2026-07-03T17:03:50Z"
+"ListPrice": 629000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 1841.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V4G3"
+"UnparsedAddress": "282 EAST 38TH Street, Hamilton, Ontario L8V4G3"
+"Coordinates": array:2 [
0 => -79.840836
1 => 43.2291001
]
+"Latitude": 43.2291001
+"Longitude": -79.840836
+"YearBuilt": 1954
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Wonderful opportunity to own this 3+2 bedroom, 2 bath all brick bungalow with a full in-law suite with its own entrance. Both kitchens have SS appliances and have been updated as well as both bathrooms. Laminate flooring has just gone in throughout. Other features: upgraded electrical, heated lower bath floor, gas fp, upgraded heating system, 5 ceiling fans, lovely private yard, garage (as is) & inside steps all recently redone as well as a freshly paved driveway. and all this in a family friendly neighbourhood close to all amenities. This is a fabulous opportunity for home ownership!!! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T17:03:44.199235+00:00"
+"Directions": "Exit Upper Gage, North on Upper Gage, West on Fennell, Turn Right East 38th"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Radiant heat"
2 => "Forced air"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1981578"
+"ListOfficeKey": "55005"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T15:29:47Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T15:29:46Z"
+"Stories": "1.0"
+"StreetName": "EAST 38TH"
+"StreetNumber": "282"
+"StreetSuffix": "Street"
+"SubdivisionName": "174 - Raleigh"
+"TaxAnnualAmount": "4391"
+"Utilities": array:4 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
3 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://www.venturehomes.ca/virtualtour.asp?tourid=70393"
+"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/29984607/282-east-38th-street-hamilton"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1524265"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55005"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 1010
+"BelowGradeFinishedArea": 831
+"OriginalEntryTimestamp": "2026-07-03T15:29:46.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267003"
+"ListOfficeNationalAssociationId": "1003711"
+"CoListAgentNationalAssociationId": "1064115"
+"CoListOfficeNationalAssociationId": "1003711"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29984607')"
+"ID": "1589185"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1587578"
+post_author: 1
+"ListingKey": "29982826"
+"ListingId": "X13516482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:50:03Z"
+"RFModificationTimestamp": "2026-07-03T20:52:33Z"
+"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! Luxury Certified. (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-03T20:40:28Z"
+"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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "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 [ …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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982826')"
+"ID": "1587578"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25348
+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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982468')"
+"ID": "1587579"
}
]
+success: true
+page_size: 9
+page_count: 17
+count: 151
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]