array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29989512 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23444
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23446
+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
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-f6d0b4499a4c414faba48bd728dae361.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29989512_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/9887770def58db66e3f2bb9b56585235.webp"
"MediaSize" => 165835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-9887770def58db66e3f2bb9b56585235.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29989512_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/2908841c0f4a015d8c4b791654ab5eda.webp"
"MediaSize" => 104262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-2908841c0f4a015d8c4b791654ab5eda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29989512_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/a0fa5785f5a0a508f8d61be4c668970d.webp"
"MediaSize" => 101412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-a0fa5785f5a0a508f8d61be4c668970d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29989512_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/5c3974d3ac7ae3e538272f7b52abbb28.webp"
"MediaSize" => 98368
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-5c3974d3ac7ae3e538272f7b52abbb28.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29989512_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/1bc28446e95f36cc3095c42043333fee.webp"
"MediaSize" => 86519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-1bc28446e95f36cc3095c42043333fee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29989512_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/6aeb2f722111e8ba50634ea40c8ef699.webp"
"MediaSize" => 77076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-6aeb2f722111e8ba50634ea40c8ef699.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29989512_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/a842c0e135d8cc895f4b2d718f71540a.webp"
"MediaSize" => 102749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-a842c0e135d8cc895f4b2d718f71540a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29989512_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/2df360b9a12b88adc7032390af561ff4.webp"
"MediaSize" => 106590
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-2df360b9a12b88adc7032390af561ff4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29989512_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/cf030ff29029ec6b605707f39acae02e.webp"
"MediaSize" => 81457
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-cf030ff29029ec6b605707f39acae02e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29989512_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/1283c91e01949b88c0036cf357a95a4f.webp"
"MediaSize" => 95361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-1283c91e01949b88c0036cf357a95a4f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29989512_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/935c550b9620a6d7456b1951439aea5e.webp"
"MediaSize" => 100956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-935c550b9620a6d7456b1951439aea5e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29989512_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/d83f0953273e69e89b4504969acf695d.webp"
"MediaSize" => 107022
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-d83f0953273e69e89b4504969acf695d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29989512_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/010f0e2441e828cf1829fbdb56d2dfec.webp"
"MediaSize" => 97759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-010f0e2441e828cf1829fbdb56d2dfec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29989512_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/aa461696cb37262c23377d498e5c5453.webp"
"MediaSize" => 102628
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-aa461696cb37262c23377d498e5c5453.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29989512_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/dc36beb255601b3754ba8e1c4112b94a.webp"
"MediaSize" => 91246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-dc36beb255601b3754ba8e1c4112b94a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29989512_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/7b680300ea9363fa20f00e563e477802.webp"
"MediaSize" => 83381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-7b680300ea9363fa20f00e563e477802.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29989512_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/038f475a74f2f33c11bb21ce4e6a2e03.webp"
"MediaSize" => 76519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-038f475a74f2f33c11bb21ce4e6a2e03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29989512_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/1932857e1d444e09c0dc7b7e9ab4cbca.webp"
"MediaSize" => 85433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-1932857e1d444e09c0dc7b7e9ab4cbca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29989512_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/25b338d233b1302678b72a314cf36137.webp"
"MediaSize" => 84144
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-25b338d233b1302678b72a314cf36137.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29989512_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/31cac25ac94abd4b6374fcb79bd1f0af.webp"
"MediaSize" => 100794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-31cac25ac94abd4b6374fcb79bd1f0af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29989512_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/eda2b1b27b3705790c03bcf97dad5a22.webp"
"MediaSize" => 89689
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-eda2b1b27b3705790c03bcf97dad5a22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29989512_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/5911af84b2e7b32ee9be02d5fc7c16c7.webp"
"MediaSize" => 63087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-5911af84b2e7b32ee9be02d5fc7c16c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29989512_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/5a02b6f7f3cdb621aef4f2c920926b0d.webp"
"MediaSize" => 60959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-5a02b6f7f3cdb621aef4f2c920926b0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29989512_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/0be8a3fbf10b0d0c553c1dfccf00705a.webp"
"MediaSize" => 206934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-0be8a3fbf10b0d0c553c1dfccf00705a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29989512_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/5e760bf313dd77ff0627c1ce3c29feaf.webp"
"MediaSize" => 219774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-5e760bf313dd77ff0627c1ce3c29feaf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29989512_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/3f83996c51306f6f348d626b3a6be1ab.webp"
"MediaSize" => 63673
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-3f83996c51306f6f348d626b3a6be1ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29989512_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/c8fb44737ec26e83b902b000d352b6ec.webp"
"MediaSize" => 119421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-c8fb44737ec26e83b902b000d352b6ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29989512_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/3b237e08e815e4a727f32eafa035619c.webp"
"MediaSize" => 115877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-3b237e08e815e4a727f32eafa035619c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29989512_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/2d68c46404511b68309a8e31c406faa7.webp"
"MediaSize" => 74347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-2d68c46404511b68309a8e31c406faa7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29989512_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/9c5e85eb3a6c2c01beb0e1f58e0a73b7.webp"
"MediaSize" => 83706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-9c5e85eb3a6c2c01beb0e1f58e0a73b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29989512_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/24b5b6e3c1297f347cc1c8cbf58ac64b.webp"
"MediaSize" => 73360
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-24b5b6e3c1297f347cc1c8cbf58ac64b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29989512_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/a99b69ad09fa4a27ebfcf20f4330aa15.webp"
"MediaSize" => 83175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-a99b69ad09fa4a27ebfcf20f4330aa15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29989512_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/b13524dc958574e8ec62e7301b5e1044.webp"
"MediaSize" => 82116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-b13524dc958574e8ec62e7301b5e1044.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29989512_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/debfb4bc84d1761402c603a737c9067a.webp"
"MediaSize" => 110399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-debfb4bc84d1761402c603a737c9067a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29989512_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/7da72c33222121296186bec8c897e145.webp"
"MediaSize" => 209231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-7da72c33222121296186bec8c897e145.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29989512_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/2747ca089287690083dca12f2d9fd358.webp"
"MediaSize" => 188488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-2747ca089287690083dca12f2d9fd358.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29989512_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29989512/95eecce6ca31ec18d69755cbc4bc8548.webp"
"MediaSize" => 243479
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29989512/thumbnail-95eecce6ca31ec18d69755cbc4bc8548.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13522770"
"ResourceRecordKey" => "29989512"
"ModificationTimestamp" => "2026-07-04T16:08:56.21Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989512')"
+"ID": "1593558"
}
]
+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 296729" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24907
+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 2075003" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24865
+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 '29989512'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25263
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29989512'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25279
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29989512' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.825281 43.203435)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25352
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25326
+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"
…7
]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29989226')"
+"ID": "1593119"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25328
+post_id: "1587630"
+post_author: 1
+"ListingKey": "29982823"
+"ListingId": "X13516444"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T00:50:03Z"
+"RFModificationTimestamp": "2026-07-03T01:35:47Z"
+"ListPrice": 625000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stoney Creek Mountain)"
+"PostalCode": "L8J1P3"
+"UnparsedAddress": "29 HOPEWELL CRESCENT, Hamilton (Stoney Creek Mountain), Ontario L8J1P3"
+"Coordinates": array:2 [
0 => -79.805651
1 => 43.194979
]
+"Latitude": 43.194979
+"Longitude": -79.805651
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 29 Hopewell Crescent, where exceptional location, thoughtful updates, and family living come together in one of Stoney Creek's most desirable neighbourhoods. Perfectly positioned just steps from top-rated schools, Valley Park Community Centre, parks, shopping, restaurants, and everyday amenities, this location also offers quick access to Felker's Falls, the Red Hill Valley Parkway, and the LINC. Lovingly maintained and thoughtfully updated throughout, this immaculate move-in-ready home offers three generous bedrooms, a timeless white kitchen with an inviting eat-in dining area, a bright living room ideal for everyday living and entertaining, and a beautifully renovated four-piece bathroom. The finished lower level expands your living space with a versatile recreation room perfect for movie nights, a playroom, home office, or gym. A generous workshop provides excellent storage and the potential for a future bathroom. Step outside to your private backyard retreat, beautifully landscaped with no rear neighbours, a spacious deck, above-ground pool, hot tub, and plenty of room to relax or entertain. Immaculate inside and out, this is the kind of home buyers wait for. Simply move in, unpack, and enjoy everything this exceptional property and unbeatable location have to offer. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Microwave"
6 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T01:35:45.814992+00:00"
+"Directions": "Cross Streets: Winterberry Dr. ** Directions: Mud St W and Winterberry Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241040"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "35 x 105 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T00:42:10Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T00:42:10Z"
+"Stories": "2.0"
+"StreetName": "Hopewell"
+"StreetNumber": "29"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3547.96"
+"VirtualTourURLUnbranded": "https://viralrealestate.media/29-hopewell-cres-stoney-creek"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stoney Creek Mountain"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29982823/29-hopewell-crescent-hamilton-stoney-creek-mountain-stoney-creek-mountain"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 35.0
+"OriginalEntryTimestamp": "2026-07-03T00:42:10.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1479231"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982823')"
+"ID": "1587630"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: "1587666"
+post_author: 1
+"ListingKey": "29982354"
+"ListingId": "X13516072"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T20:20:10Z"
+"RFModificationTimestamp": "2026-07-03T20:23:44Z"
+"ListPrice": 489900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Quinndale)"
+"PostalCode": "L8W1R1"
+"UnparsedAddress": "27 - 1396 UPPER OTTAWA STREET, Hamilton (Quinndale), Ontario L8W1R1"
+"Coordinates": array:2 [
0 => -79.841643
1 => 43.20013
]
+"Latitude": 43.20013
+"Longitude": -79.841643
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This fabulous end-unit townhouse is conveniently located close to schools, parks, shopping, and all amenities. The main floor features an updated kitchen, and a living and dining room with a walkout to the fenced backyard patio. Upstairs, you'll find three spacious bedrooms and a beautifully updated 4-piece bathroom. The finished basement offers additional living space with a versatile recreation room, a 2-piece bathroom, and a separate laundry room. Recent updatesinclude fresh paint throughout, new carpeting (2026), AC (2026), furnace (2026), kitchencountertops (2026), and renovated upstairs bathroom (2026). (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "511.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T01:08:17.118105+00:00"
+"Directions": "STONE CHURCH RD E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160208"
+"ListOfficeKey": "290165"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T22:44:47Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:06:28Z"
+"Stories": "2.0"
+"StreetName": "UPPER OTTAWA"
+"StreetNumber": "1396"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3192"
+"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": "Quinndale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29982354/27-1396-upper-ottawa-street-hamilton-quinndale-quinndale"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "PROPERTY MANAGEMENT GUILD"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"ZoningDescription": "E2"
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-02T22:44:47.77Z"
+"ListAgentNationalAssociationId": "1411366"
+"ListOfficeNationalAssociationId": "1384282"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982354')"
+"ID": "1587666"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25329
+post_id: "1586616"
+post_author: 1
+"ListingKey": "29981552"
+"ListingId": "40842992"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T21:05:14Z"
+"RFModificationTimestamp": "2026-07-03T21:08:21Z"
+"ListPrice": 489900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1332.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8W1R1"
+"UnparsedAddress": "1396 UPPER OTTAWA Street Unit# 27, Hamilton, Ontario L8W1R1"
+"Coordinates": array:2 [
0 => -79.841485
1 => 43.2000594
]
+"Latitude": 43.2000594
+"Longitude": -79.841485
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This fabulous end-unit townhouse is conveniently located close to schools, parks, shopping, and all amenities. The main floor features an updated kitchen, and a living and dining room with a walkout to the fenced backyard patio. Upstairs, you'll find three spacious bedrooms and a beautifully updated 4-piece bathroom. The finished basement offers additional living space with a versatile recreation room, a 2-piece bathroom, and a separate laundry room. Recent updates include fresh paint throughout, new carpeting (2026), AC (2026), furnace (2026), kitchen countertops (2026), and renovated upstairs bathroom (2026). (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
]
+"AssociationFee": "511.01"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Water"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T22:59:13.073262+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1734276"
+"ListOfficeKey": "290163"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T21:12:18Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T20:59:11Z"
+"Stories": "2.0"
+"StreetName": "UPPER OTTAWA"
+"StreetNumber": "1396"
+"StreetSuffix": "Street"
+"SubdivisionName": "262 - Quinndale"
+"TaxAnnualAmount": "3192"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29981552/1396-upper-ottawa-street-unit-27-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "E2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 961
+"BelowGradeFinishedArea": 371
+"OriginalEntryTimestamp": "2026-07-02T21:12:18.22Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1177451"
+"ListOfficeNationalAssociationId": "1384185"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981552')"
+"ID": "1586616"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25327
+post_id: "1586680"
+post_author: 1
+"ListingKey": "29980942"
+"ListingId": "40844768"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T20:00:18Z"
+"RFModificationTimestamp": "2026-07-02T20:44:31Z"
+"ListPrice": 649999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1646.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J1P3"
+"UnparsedAddress": "45 HOPEWELL Crescent, Stoney Creek, Ontario L8J1P3"
+"Coordinates": array:2 [
0 => -79.8056613
1 => 43.1958209
]
+"Latitude": 43.1958209
+"Longitude": -79.8056613
+"YearBuilt": 1977
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained semi-detached backsplit, tucked away on a quiet, family-friendly crescent in the highly desirable Stoney Creek Mountain community. Offering approximately 1,600 sq. ft. of finished living space, this move-in ready home features 3 bedrooms, 2 bathrooms, and a functional layout that's ideal for families, first-time buyers, or those looking to downsize without compromise. The fully finished lower level offers additional living space and includes a convenient walk-up to the backyard, providing added flexibility for everyday living and entertaining. Step outside to the true highlight of the property - a rare, oversized pie-shaped lot with an impressive 187.43-ft depth. Enjoy summer days in the above-ground pool, relax around the fire pit, or take advantage of the expansive yard with plenty of space for kids, pets, gardening, and outdoor entertaining. Ideally located just minutes from highway access, shopping, schools, parks, community centres, and public transit, this is an exceptional opportunity to get into the market with a move-in ready home on the Stoney Creek Mountain. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T20:32:01.413273+00:00"
+"Directions": "Paramount to Chilton to Hopewell"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2076427"
+"ListOfficeKey": "284634"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-02T19:51:32Z"
+"PhotosCount": 30
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T19:51:32Z"
+"Stories": "2.0"
+"StreetName": "HOPEWELL"
+"StreetNumber": "45"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "501 - Valley Park"
+"TaxAnnualAmount": "3583"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29980942/45-hopewell-crescent-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 1125
+"BelowGradeFinishedArea": 521
+"OriginalEntryTimestamp": "2026-07-02T19:51:32.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1351552"
+"ListOfficeNationalAssociationId": "1344654"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980942')"
+"ID": "1586680"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
+post_id: "1585246"
+post_author: 1
+"ListingKey": "29980106"
+"ListingId": "40844699"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T22:00:17Z"
+"RFModificationTimestamp": "2026-07-02T22:10:51Z"
+"ListPrice": 625000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1126.0
+"BuildingAreaTotal": 0
+"City": "Stoney Creek"
+"PostalCode": "L8J1P3"
+"UnparsedAddress": "29 HOPEWELL Crescent, Stoney Creek, Ontario L8J1P3"
+"Coordinates": array:2 [
0 => -79.8053405
1 => 43.1950789
]
+"Latitude": 43.1950789
+"Longitude": -79.8053405
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 29 Hopewell Crescent, where exceptional location, thoughtful updates, and family living come together in one of Stoney Creek's most desirable neighbourhoods. Perfectly positioned just steps from top-rated schools, Valley Park Community Centre, parks, shopping, restaurants, Cineplex, Home Depot, HomeSense, and everyday amenities, this location also offers quick access to Felker's Falls, the Red Hill Valley Parkway, and the LINC. Lovingly maintained and thoughtfully updated throughout, this immaculate move-in-ready home offers three generous bedrooms, a timeless white kitchen with an inviting eat-in dining area, a bright living room ideal for everyday living and entertaining, and a beautifully renovated four-piece bathroom. The finished lower level expands your living space with a versatile recreation room perfect for movie nights, a playroom, home office, or gym. A generous workshop provides excellent storage and the potential for a future bathroom. Step outside to your private backyard retreat, beautifully landscaped with no rear neighbours, a spacious deck, above-ground pool, hot tub, and plenty of room to relax or entertain. Immaculate inside and out, this is the kind of home buyers wait for. Simply move in, unpack, and enjoy everything this exceptional property and unbeatable location have to offer. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Microwave"
6 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:12:26.922492+00:00"
+"Directions": "WINTERBERRY"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1986897"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-07-02T18:33:34Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:50:42Z"
+"Stories": "2.0"
+"StreetName": "HOPEWELL"
+"StreetNumber": "29"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "501 - Valley Park"
+"TaxAnnualAmount": "3547.96"
+"VirtualTourURLUnbranded": "https://viralrealestate.media/29-hopewell-cres-stoney-creek"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29980106/29-hopewell-crescent-stoney-creek"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2143995"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"ZoningDescription": "R5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 35.0
+"AboveGradeFinishedArea": 1126
+"OriginalEntryTimestamp": "2026-07-02T18:33:34.13Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1271234"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1395501"
+"CoListOfficeNationalAssociationId": "1223032"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980106')"
+"ID": "1585246"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23458
+post_id: "1584038"
+post_author: 1
+"ListingKey": "29977536"
+"ListingId": "X13511668"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T21:25:08Z"
+"RFModificationTimestamp": "2026-07-02T21:44:31Z"
+"ListPrice": 709500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lisgar)"
+"PostalCode": "L8T4L5"
+"UnparsedAddress": "79 LOCHEED DRIVE, Hamilton (Lisgar), Ontario L8T4L5"
+"Coordinates": array:2 [
0 => -79.832057
1 => 43.20789
]
+"Latitude": 43.20789
+"Longitude": -79.832057
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exceptional opportunity to own a well maintained and upgraded home in one of Hamilton's most desirable MOUNTAIN area. Offering over 2,000 sq ft of total living space, this raised bungalow/backsplit blends character, functionality, and modern comfort ideal for families, professionals, or investors. Large lot, features large private driveway with parking for up to six cars. The fully fenced backyard offers privacy and space to enjoy, complete with a covered deck, gazebo, garden shed, and fruit trees, perfect for entertaining or relaxing. Potential to add a walkout basement entrance. Bright main level filled with natural light from large windows finished with seamless engineered hardwood floors. Large living room with a formal dining room and an updated kitchen with stainless steel appliances and a walkout to the backyard. Well-sized bedrooms and updated bathrooms, Potential to sperate a room and have and extra room. Fully finished basement adds incredible versatility with a potential to add a separate entrance, making it ideal for in-law living or income potential. It features additional bedrooms, a cozy family room with a fireplace perfect for extended family or multi-functional living. Located just steps from Plaza, parks, schools, shopping, and transit, and the Mountain, this home offers both convenience and lifestyle. With easy highway access and proximity to scenic trails and outdoor attractions, it's perfectly positioned for both daily living and recreation. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T15:54:12.555300+00:00"
+"Directions": "Cross Streets: Upper Ottawa & Carson. ** Directions: : Upper Ottawa & Carson."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1417634"
+"ListOfficeKey": "270338"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "49.2 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T21:16:13Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:16:13Z"
+"Stories": "1.0"
+"StreetName": "Locheed"
+"StreetNumber": "79"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4400"
+"View": "View"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/79_locheed_dr_hamilton_on/"
+"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": "Lisgar"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29977536/79-locheed-drive-hamilton-lisgar-lisgar"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1994184"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "270338"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 49.2
+"OriginalEntryTimestamp": "2026-07-02T14:19:41.95Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1035732"
+"ListOfficeNationalAssociationId": "1235224"
+"CoListAgentNationalAssociationId": "1277257"
+"CoListOfficeNationalAssociationId": "1235224"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977536')"
+"ID": "1584038"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25349
+post_id: "1581549"
+post_author: 1
+"ListingKey": "29974304"
+"ListingId": "X13507888"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T03:00:10Z"
+"RFModificationTimestamp": "2026-07-01T03:04:47Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Trenholme)"
+"PostalCode": "L8W1P1"
+"UnparsedAddress": "43 - 1250 LIMERIDGE ROAD E, Hamilton (Trenholme), Ontario L8W1P1"
+"Coordinates": array:2 [
0 => -79.831369
1 => 43.205458
]
+"Latitude": 43.205458
+"Longitude": -79.831369
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Elegant, move-in ready upgraded townhome in a quiet, family-friendly community. Renovated top to bottom, this3-bedroom home features a bright, spacious layout with separate living and dining rooms and modern finishesthroughout. Eat-in kitchen with custom cabinetry and granite countertops. Oversized great room with soaring ceilingsbeautifully done with floor-to-ceiling wainscoting. Main floor office completely private perfect for working from home,can easily be used as 4th bedroom. Walk-out family room to fully enclosed backyard. Turnkey opportunity! Stunningtop-to-bottom. Enjoy the best of Hamilton Mountain living in this beautifully renovated townhome! Set in a quietcommunity with easy access to Mohawk Sports Park, the Mountain Brow, and endless hiking trails, plus nearbyshopping and great schools.Walking distance to schools, parks, and all amenities. Basic cable/internet included; upgrade to premium TVpackage, high-speed Bell Fibe internet, and home phone available for $10/month. Total living space approx. 1,820sq ft as per MPAC - According to the seller, monthly hydro costs are approximately $200 during the winter months and $70 in the summer for a family of four. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Heater"
]
+"AssociationFee": "483"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Cable TV"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:3 [
0 => "Finished"
1 => "Walk out"
2 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Wall unit"
]
+"CreationDate": "2026-07-01T03:04:38.883970+00:00"
+"Directions": "Cross Streets: Upper Ottawa & Limeridge Rd E. ** Directions: Upper Ottawa to Limeridge Rd E."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1535194"
+"ListOfficeKey": "50262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T02:32:17Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T02:52:48Z"
+"Stories": "3.0"
+"StreetDirSuffix": "East"
+"StreetName": "Limeridge"
+"StreetNumber": "1250"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "3188.99"
+"VirtualTourURLUnbranded": "https://www.winsold.com/tour/214504"
+"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"
+"CityRegion": "Trenholme"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29974304/43-1250-limeridge-road-e-hamilton-trenholme-trenholme"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Separate Heating Controls"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1999
+"LivingAreaMinimum": 1800
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-07-01T02:32:17.27Z"
+"ListAgentNationalAssociationId": "1144180"
+"ListOfficeNationalAssociationId": "1003226"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974304')"
+"ID": "1581549"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25351
+post_id: "1579203"
+post_author: 1
+"ListingKey": "29970165"
+"ListingId": "X13504036"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T15:00:10Z"
+"RFModificationTimestamp": "2026-06-30T17:13:19Z"
+"ListPrice": 819900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lisgar)"
+"PostalCode": "L8T4W4"
+"UnparsedAddress": "102 MARKSON CRESCENT, Hamilton (Lisgar), Ontario L8T4W4"
+"Coordinates": array:2 [
0 => -79.827007
1 => 43.21103
]
+"Latitude": 43.21103
+"Longitude": -79.827007
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rare Opportunity - Meticulously Built Italian-Style Backsplit | Original Owner | 4 Bedrooms | In-Law Suite Potential. Welcome to this stunning, one-of-a-kind backsplit built with exceptional Italian craftsmanship and lovingly maintained by its original owner. Spacious, thoughtfully designed, and move-in ready - this home offers versatile living across multiple levels, ideal for growing families or multi-generational living. Main Floor features a grand entrance that sets the tone with timeless elegance. The heart of the home is a large, well-appointed kitchen, a formal dining room perfect for entertaining, and a beautifully living room that radiates warmth and sophistication. Upper Level offers three generously sized bedrooms and a luxurious 5-piece bathroom - a true retreat for the whole family. Lower Level boasts an expansive family room anchored by a wood-burning fireplace, creating the perfect gathering space and 1 bedroom. Walk out directly to the backyard and sideyard - a layout that lends itself beautifully to a private in-law suite, complete with its own separate entrance and a 3-piece bathroom. Basement provides incredible additional living space, ideal as a recreation room, home office, or extended family quarters. Also features a fully equipped utility area with washer & dryer and a kitchen with gas hookup, plus a large cold room for extra storage. An impressive crawl space measuring 19'8" x 29' offers an extraordinary amount of additional storage rarely found in homes today. Outdoor Living - Enjoy a beautifully landscaped backyard with lush sod, perfect for relaxing or entertaining, along with a good-sized garage to complete the package. Roof changed in 2024, furnace and hot water tank owned - 2025. This is the kind of home that's been built with pride and maintained with care, a true gem that doesn't come to market often. Don't miss your chance to own a piece of craftsmanship and character. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T17:13:05.108047+00:00"
+"Directions": "Cross Streets: Mohawk & Upper Kenilworth. ** Directions: East on MOhawk, Sotuh on Upper Kenilworth, West on Landron, North on Markson Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2086746"
+"ListOfficeKey": "283948"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "In-Law Suite"
]
+"LotSizeDimensions": "44 x 98.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T14:52:07Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T14:52:06Z"
+"StreetName": "Markson"
+"StreetNumber": "102"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6244.99"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=SgYYTaVhbNs&feature=youtu.be"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Lisgar"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29970165/102-markson-crescent-hamilton-lisgar-lisgar"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 44.0
+"OriginalEntryTimestamp": "2026-06-30T14:52:06.84Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1360041"
+"ListOfficeNationalAssociationId": "1337191"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970165')"
+"ID": "1579203"
}
]
+success: true
+page_size: 9
+page_count: 10
+count: 84
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]