array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29977536 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445
+post_id: "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 [
"RoomKey" => "1673618892"
"RoomType" => "Bathroom"
"ListingId" => "X13511668"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.05
"ListingKey" => "29977536"
"RoomLength" => 1.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.63Z"
]
1 => array:11 [
"RoomKey" => "1673618893"
"RoomType" => "Laundry room"
"ListingId" => "X13511668"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.04
"ListingKey" => "29977536"
"RoomLength" => 3.38
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.63Z"
]
2 => array:11 [
"RoomKey" => "1673618894"
"RoomType" => "Living room"
"ListingId" => "X13511668"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29977536"
"RoomLength" => 5.08
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.63Z"
]
3 => array:11 [
"RoomKey" => "1673618895"
"RoomType" => "Dining room"
"ListingId" => "X13511668"
"RoomLevel" => "Main level"
"RoomWidth" => 3.16
"ListingKey" => "29977536"
"RoomLength" => 5.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.63Z"
]
4 => array:11 [
"RoomKey" => "1673618896"
"RoomType" => "Kitchen"
"ListingId" => "X13511668"
"RoomLevel" => "Main level"
"RoomWidth" => 3.16
"ListingKey" => "29977536"
"RoomLength" => 5.88
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.63Z"
]
5 => array:11 [
"RoomKey" => "1673618897"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13511668"
"RoomLevel" => "Main level"
"RoomWidth" => 3.48
"ListingKey" => "29977536"
"RoomLength" => 6.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.63Z"
]
6 => array:11 [
"RoomKey" => "1673618898"
"RoomType" => "Bedroom 2"
"ListingId" => "X13511668"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29977536"
"RoomLength" => 3.12
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.63Z"
]
7 => array:11 [
"RoomKey" => "1673618899"
"RoomType" => "Family room"
"ListingId" => "X13511668"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.58
"ListingKey" => "29977536"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.63Z"
]
8 => array:11 [
"RoomKey" => "1673618900"
"RoomType" => "Great room"
"ListingId" => "X13511668"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.58
"ListingKey" => "29977536"
"RoomLength" => 4.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.64Z"
]
9 => array:11 [
"RoomKey" => "1673618901"
"RoomType" => "Bedroom 3"
"ListingId" => "X13511668"
"RoomLevel" => "Lower level"
"RoomWidth" => 3.01
"ListingKey" => "29977536"
"RoomLength" => 3.22
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.64Z"
]
10 => array:11 [
"RoomKey" => "1673618902"
"RoomType" => "Bedroom 4"
"ListingId" => "X13511668"
"RoomLevel" => "Lower level"
"RoomWidth" => 2.74
"ListingKey" => "29977536"
"RoomLength" => 3.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-02T21:16:13.64Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29977536_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/09c3d152d236f62f1e9fee7d5e6becab.webp"
"MediaSize" => 309868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-09c3d152d236f62f1e9fee7d5e6becab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29977536_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/c47f7fd6efca9d36956e6015527ebeae.webp"
"MediaSize" => 412962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-c47f7fd6efca9d36956e6015527ebeae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29977536_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/0367b20d5fdc0fe2dd9cdf37048ff25e.webp"
"MediaSize" => 213071
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-0367b20d5fdc0fe2dd9cdf37048ff25e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29977536_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/26bc5104cba5169129dc951f0031da99.webp"
"MediaSize" => 359925
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-26bc5104cba5169129dc951f0031da99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29977536_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/cadf9da86cdf520319e4271afe2a8aa0.webp"
"MediaSize" => 351399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-cadf9da86cdf520319e4271afe2a8aa0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29977536_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/bcfb12b74347c8a67cae70e2205687bc.webp"
"MediaSize" => 335962
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-bcfb12b74347c8a67cae70e2205687bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29977536_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/4d7f7acadbcd5f788f47ea67cfde730e.webp"
"MediaSize" => 155927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-4d7f7acadbcd5f788f47ea67cfde730e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29977536_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/ed4eaa5afdf4799b57c27779685af883.webp"
"MediaSize" => 189269
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-ed4eaa5afdf4799b57c27779685af883.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29977536_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/d73686fd0f5d93c42e4b8ee47d97a49d.webp"
"MediaSize" => 208595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-d73686fd0f5d93c42e4b8ee47d97a49d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29977536_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/8e12f1c8b402b4e4c76718c4a34cb591.webp"
"MediaSize" => 201142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-8e12f1c8b402b4e4c76718c4a34cb591.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29977536_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/88085314c5ef3f9ac0132b7ea0147e8f.webp"
"MediaSize" => 215252
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-88085314c5ef3f9ac0132b7ea0147e8f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29977536_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/faad5ceab10e90b0cca23f77fd937db2.webp"
"MediaSize" => 207943
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-faad5ceab10e90b0cca23f77fd937db2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29977536_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/3b66bfb6d193b70804fff9b218cfe1d6.webp"
"MediaSize" => 173724
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-3b66bfb6d193b70804fff9b218cfe1d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29977536_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/714003a6fd28394a80504a83c8510a6f.webp"
"MediaSize" => 197047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-714003a6fd28394a80504a83c8510a6f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29977536_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/52bf67d71ecf8f7489a7f2241083e4a1.webp"
"MediaSize" => 213185
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-52bf67d71ecf8f7489a7f2241083e4a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29977536_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/18245847dedd56ec24b19c07ead227b9.webp"
"MediaSize" => 158005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-18245847dedd56ec24b19c07ead227b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29977536_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/90389da2137af0e90cdadc35430f1522.webp"
"MediaSize" => 171346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-90389da2137af0e90cdadc35430f1522.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29977536_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/bef72551fe045118b00041aec1577867.webp"
"MediaSize" => 185845
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-bef72551fe045118b00041aec1577867.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29977536_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/ea032dbdb76b01b2e766ace708e2461b.webp"
"MediaSize" => 189765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-ea032dbdb76b01b2e766ace708e2461b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29977536_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/a5f0c5868da4208645f0fc14547ae15c.webp"
"MediaSize" => 213262
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-a5f0c5868da4208645f0fc14547ae15c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29977536_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/6ae675d3bc9ac844b884e9b4c0f4c1e7.webp"
"MediaSize" => 192044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-6ae675d3bc9ac844b884e9b4c0f4c1e7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29977536_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/f1764b0ca7b77226b426125a642899a8.webp"
"MediaSize" => 211164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-f1764b0ca7b77226b426125a642899a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29977536_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/fe370f12a27d99e66e1f5e010487aebb.webp"
"MediaSize" => 230795
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-fe370f12a27d99e66e1f5e010487aebb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29977536_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/059fd10dd25c90a1804596ee0ad1dd7a.webp"
"MediaSize" => 226304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-059fd10dd25c90a1804596ee0ad1dd7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29977536_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/7411df0c49bdaa5923bae80dc873443c.webp"
"MediaSize" => 141788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-7411df0c49bdaa5923bae80dc873443c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29977536_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/8a39ba6b2ad54ef46dfd6de7d1f7fd8a.webp"
"MediaSize" => 215119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-8a39ba6b2ad54ef46dfd6de7d1f7fd8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29977536_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/044f473606dd9b3128e233fcc2d8f0ca.webp"
"MediaSize" => 234188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-044f473606dd9b3128e233fcc2d8f0ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29977536_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/351f7bd8bc9814d8ef9c0d24961bae32.webp"
"MediaSize" => 245539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-351f7bd8bc9814d8ef9c0d24961bae32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29977536_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/d97ada1f9d7ea049941dc1f490cab08d.webp"
"MediaSize" => 126017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-d97ada1f9d7ea049941dc1f490cab08d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29977536_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/d00deab71f570347c04fbd538c73b636.webp"
"MediaSize" => 212816
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-d00deab71f570347c04fbd538c73b636.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T14:19:41.96Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29977536_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/0db5e82e6ec6e31d6f331fb883377729.webp"
"MediaSize" => 237852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-0db5e82e6ec6e31d6f331fb883377729.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:56.74Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29977536_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/1760327e398c9ae4884085a87869581b.webp"
"MediaSize" => 302348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-1760327e398c9ae4884085a87869581b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:54.34Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29977536_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/0dcc2571339a8f25fa6fd64a7f77178c.webp"
"MediaSize" => 280118
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-0dcc2571339a8f25fa6fd64a7f77178c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:58.37Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29977536_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/1cbca360780c6f130d283acd3828c16d.webp"
"MediaSize" => 277289
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-1cbca360780c6f130d283acd3828c16d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:54.26Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29977536_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/0d9cb878246363488a97ca9048fefdff.webp"
"MediaSize" => 332125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-0d9cb878246363488a97ca9048fefdff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:58.16Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29977536_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/17acc4d70629c6b9bcd98358f8cc096a.webp"
"MediaSize" => 333577
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-17acc4d70629c6b9bcd98358f8cc096a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:54.02Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29977536_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/5196bafb4e041692deccce4c5d9727b8.webp"
"MediaSize" => 389835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-5196bafb4e041692deccce4c5d9727b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:58.34Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29977536_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/48a09e45643a5bf070e8cfe2aa3cdc68.webp"
"MediaSize" => 422759
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-48a09e45643a5bf070e8cfe2aa3cdc68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:54.67Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29977536_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/591a0c2f499c5331d95660745e3191d6.webp"
"MediaSize" => 411675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-591a0c2f499c5331d95660745e3191d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:58.32Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29977536_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/d5b26e78aab5043b8fc794b077eb4381.webp"
"MediaSize" => 297057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-d5b26e78aab5043b8fc794b077eb4381.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:54.91Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29977536_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/e5ae423aecbd43d7521dd31b807c8a38.webp"
"MediaSize" => 338896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-e5ae423aecbd43d7521dd31b807c8a38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:58.4Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29977536_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/f9b9a7f5e5555a16317b24bfaaa6af33.webp"
"MediaSize" => 333474
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-f9b9a7f5e5555a16317b24bfaaa6af33.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:54.06Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29977536_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/258277a9c7b90988861e22e2ce8c16a2.webp"
"MediaSize" => 335418
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-258277a9c7b90988861e22e2ce8c16a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:56.17Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29977536_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/9a5e03b8b943cc416b6e523f11ed0d78.webp"
"MediaSize" => 390591
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-9a5e03b8b943cc416b6e523f11ed0d78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:56.26Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29977536_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29977536/484dde4a1fe44045d83731b340239ee4.webp"
"MediaSize" => 303151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29977536/thumbnail-484dde4a1fe44045d83731b340239ee4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13511668"
"ResourceRecordKey" => "29977536"
"ModificationTimestamp" => "2026-07-02T20:27:58.5Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977536')"
+"ID": "1584038"
}
]
+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 270338" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24915
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1417634" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24873
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29977536'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25275
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29977536'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25291
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29977536' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.832057 43.20789)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25364
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25357
+post_id: "1590475"
+post_author: 1
+"ListingKey": "29986043"
+"ListingId": "40844791"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:25:13Z"
+"RFModificationTimestamp": "2026-07-03T19:52:22Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2059.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8T3B3"
+"UnparsedAddress": "456 EAST 42ND Street, Hamilton, Ontario L8T3B3"
+"Coordinates": array:2 [
0 => -79.8409617
1 => 43.220058
]
+"Latitude": 43.220058
+"Longitude": -79.8409617
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 456 East 42nd Street, a bungalow offering 4 bedrooms, 2 bathrooms, and 2059 sf of finished living space on Hamilton Mountain. Situated on an approx. impressive 50 x 150 ft lot, this property features a long private driveway with parking for multiple vehicles and a heated tandem detached garage measuring 13'3 x 38'0, ideal for vehicles, a workshop, hobbies, or additional storage. Backing onto mature trees with no direct rear neighbours, the home enjoys a private setting close to parks, schools, shopping, transit, and the Lincoln M. Alexander Parkway. The main level features a bright, functional layout designed for everyday living. The living room is filled with natural light and flows seamlessly into the adjoining dining area, creating an inviting space for family gatherings. The kitchen offers ample cabinetry, generous counter space, and a practical layout with convenient access to the backyard. Three well-appointed bedrooms and a 4pc bathroom complete the main level. The fully finished lower level extends the living space with a generous family room centered around a gas fireplace/stove, creating a warm and inviting retreat. A fourth bedroom, 3pc bathroom, laundry area, and abundant storage provide exceptional flexibility for extended family, guests, or a home office. Step outside to enjoy the expansive backyard, where the impressive lot depth provides endless opportunities for entertaining, gardening, or future enjoyment. Mature trees along the rear of the property create a peaceful backdrop and enhance the sense of privacy. Combining a functional bungalow layout, an exceptional lot, a heated tandem garage, and parking for multiple vehicles, this Hamilton Mountain home offers outstanding versatility in a convenient family-friendly location. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:52:17.499869+00:00"
+"Directions": "Mohawk Rd East to East 42nd St"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Metal"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1567201"
+"ListOfficeKey": "283099"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:18:25Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:18:25Z"
+"Stories": "1.0"
+"StreetName": "EAST 42ND"
+"StreetNumber": "456"
+"StreetSuffix": "Street"
+"SubdivisionName": "252 - Hampton Heights"
+"TaxAnnualAmount": "4874.14"
+"VirtualTourURLUnbranded": "https://youtu.be/uS2RmSZ1IcM"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1674297171"
"RoomType" => "Utility room"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.31Z"
]
1 => array:11 [
"RoomKey" => "1674297172"
"RoomType" => "Other"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "9'0'' x 5'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.31Z"
]
2 => array:11 [
"RoomKey" => "1674297173"
"RoomType" => "4pc Bathroom"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "6'3'' x 4'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.31Z"
]
3 => array:11 [
"RoomKey" => "1674297174"
"RoomType" => "Laundry room"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.31Z"
]
4 => array:11 [
"RoomKey" => "1674297175"
"RoomType" => "Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
5 => array:11 [
"RoomKey" => "1674297176"
"RoomType" => "Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
6 => array:11 [
"RoomKey" => "1674297177"
"RoomType" => "Family room"
"ListingId" => "40844791"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "22'3'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
7 => array:11 [
"RoomKey" => "1674297178"
"RoomType" => "Storage"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
8 => array:11 [
"RoomKey" => "1674297179"
"RoomType" => "2pc Bathroom"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 5'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
9 => array:11 [
"RoomKey" => "1674297180"
"RoomType" => "Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
10 => array:11 [
"RoomKey" => "1674297181"
"RoomType" => "Primary Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
11 => array:11 [
"RoomKey" => "1674297182"
"RoomType" => "Bedroom"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
12 => array:11 [
"RoomKey" => "1674297183"
"RoomType" => "Foyer"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "25'3'' x 5'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.32Z"
]
13 => array:11 [
"RoomKey" => "1674297184"
"RoomType" => "Kitchen"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "14'5'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.33Z"
]
14 => array:11 [
"RoomKey" => "1674297185"
"RoomType" => "Living room"
"ListingId" => "40844791"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29986043"
"RoomLength" => null
"RoomDimensions" => "19'9'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-03T18:18:25.33Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986043/456-east-42nd-street-hamilton"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1863243"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283099"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1157
+"BelowGradeFinishedArea": 902
+"OriginalEntryTimestamp": "2026-07-03T18:18:25.27Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1149561"
+"ListOfficeNationalAssociationId": "1324631"
+"CoListAgentNationalAssociationId": "1201229"
+"CoListOfficeNationalAssociationId": "1324631"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29986043_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/49cf9b2568bb9da76b89336110fb3164.webp"
"MediaSize" => 144041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-49cf9b2568bb9da76b89336110fb3164.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29986043_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/4130f562038bd07cae7d4cf1c1683aaa.webp"
"MediaSize" => 165950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-4130f562038bd07cae7d4cf1c1683aaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29986043_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/b82115413482c0f0f4a3d5eeaede75e9.webp"
"MediaSize" => 165721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-b82115413482c0f0f4a3d5eeaede75e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29986043_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/fc55025c8dedf93c5033dca038d6e33f.webp"
"MediaSize" => 60040
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-fc55025c8dedf93c5033dca038d6e33f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29986043_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/ce477e71adec071ae36aa05b04eb0165.webp"
"MediaSize" => 51738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-ce477e71adec071ae36aa05b04eb0165.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29986043_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29986043/117949ee787ac8e962f663d9dddacbf1.webp"
"MediaSize" => 93362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29986043/thumbnail-117949ee787ac8e962f663d9dddacbf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40844791"
"ResourceRecordKey" => "29986043"
"ModificationTimestamp" => "2026-07-03T18:18:25.28Z"
]
6 => array:13 [
"Order" => 7
…12
]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986043')"
+"ID": "1590475"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25360
+post_id: "1590193"
+post_author: 1
+"ListingKey": "29985357"
+"ListingId": "X13518854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T16:50:10Z"
+"RFModificationTimestamp": "2026-07-03T19:35:13Z"
+"ListPrice": 639000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Huntington)"
+"PostalCode": "L8T1W3"
+"UnparsedAddress": "3 KENWOOD CRESCENT, Hamilton (Huntington), Ontario L8T1W3"
+"Coordinates": array:2 [
0 => -79.825516
1 => 43.223114
]
+"Latitude": 43.223114
+"Longitude": -79.825516
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this meticulously maintained home on a quiet dead-end street in the highly desirable Huntington neighbourhood. Proudly owned by the same family for 26 years, this move-in-ready property has been extensively renovated inside and out, offering exceptional quality, comfort, and outdoor living.The stunning interior was completely rebuilt in 2009 and features solid maple cabinetry with granite countertops in the kitchen and bathrooms, beautifully updated spa-inspired bathrooms with glass-enclosed showers, jetted tubs, and whisper-quiet timer exhaust fans, solid oak staircase, custom blinds throughout, luxury vinyl flooring (2024), and premium 100 oz carpet in the finished lower level (2021). The kitchen is equipped with high-end KitchenAid appliances, a gas stove, new Whirlpool microwave (2023), and matching Whirlpool washer and dryer (2023). Entertain with ease thanks to the custom maple wet bar with granite counters.Step outside to your private backyard retreat featuring approximately 1,900 sq. ft. of stamped coloured concrete, an inground pool with new liner, coping and natural gas heater (2023), aluminum Sojag gazebo, separate BBQ gazebo with included gas Weber BBQ, large storage shed (2023), pool shed, and professionally refreshed fencing (2023). Additional updates include windows and roof (2016), steel entry doors, and Anderson front screen door.Perfectly situated within walking distance to public, Catholic, and French Immersion schools (JK-Grade 8), high school, parks, recreation centre, shopping, pharmacies, and public transit. Enjoy the charm of an established, family-friendly neighbourhood where great neighbours and a true sense of community make this an exceptional place to call home. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:27:06.898437+00:00"
+"Directions": "Fennell Ave E & Upper Ottawa St"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1477197"
+"ListOfficeKey": "279771"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "40.2 x 100 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T16:41:35Z"
+"PhotosCount": 37
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T16:41:35Z"
+"Stories": "1.0"
+"StreetName": "Kenwood"
+"StreetNumber": "3"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4687.28"
+"VirtualTourURLUnbranded": "https://youtu.be/_929Nl9ZQLk?si=F4i6GPdyOOmiif8Y"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Huntington"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29985357/3-kenwood-crescent-hamilton-huntington-huntington"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 40.2
+"OriginalEntryTimestamp": "2026-07-03T16:41:35.5Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1131407"
+"ListOfficeNationalAssociationId": "1308754"
+"Media": array:37 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29985357')"
+"ID": "1590193"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+post_id: "1590476"
+post_author: 1
+"ListingKey": "29986345"
+"ListingId": "X13519910"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:50:06Z"
+"RFModificationTimestamp": "2026-07-03T19:33:44Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Hampton Heights)"
+"PostalCode": "L8T3B3"
+"UnparsedAddress": "456 EAST 42ND STREET, Hamilton (Hampton Heights), Ontario L8T3B3"
+"Coordinates": array:2 [
0 => -79.8408989
1 => 43.2200445
]
+"Latitude": 43.2200445
+"Longitude": -79.8408989
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 456 East 42nd Street, a bungalow offering 4 bedrooms, 2 bathrooms, and 2059 sf of finished living space on Hamilton Mountain. Situated on an approx. impressive 50 x 150 ft lot, this property features a long private driveway with parking for multiple vehicles and a heated tandem detached garage measuring 13'3" x 38'0", ideal for vehicles, a workshop, hobbies, or additional storage. Backing onto mature trees with no direct rear neighbours, the home enjoys a private setting close to parks, schools, shopping, transit, and the Lincoln M. Alexander Parkway. The main level features a bright, functional layout designed for everyday living. The living room is filled with natural light and flows seamlessly into the adjoining dining area, creating an inviting space for family gatherings. The kitchen offers ample cabinetry, generous counter space, and a practical layout with convenient access to the backyard. Three well-appointed bedrooms and a 4pc bathroom complete the main level. The fully finished lower level extends the living space with a generous family room centered around a gas fireplace/stove, creating a warm and inviting retreat. A fourth bedroom, 3pc bathroom, laundry area, and abundant storage provide exceptional flexibility for extended family, guests, or a home office. Step outside to enjoy the expansive backyard, where the impressive lot depth provides endless opportunities for entertaining, gardening, or future enjoyment. Mature trees along the rear of the property create a peaceful backdrop and enhance the sense of privacy. Combining a functional bungalow layout, an exceptional lot, a heated tandem garage, and parking for multiple vehicles, this Hamilton Mountain home offers outstanding versatility in a convenient family-friendly location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:17:40.045093+00:00"
+"Directions": "Cross Streets: Mohawk Rd. East. ** Directions: Mohawk Rd East to East 42nd St."
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933866"
+"ListOfficeKey": "269020"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "50 x 149.3 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-03T18:41:49Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:41:49Z"
+"Stories": "1.0"
+"StreetName": "East 42nd"
+"StreetNumber": "456"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4874.14"
+"VirtualTourURLUnbranded": "https://youtu.be/uS2RmSZ1IcM"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Hampton Heights"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29986345/456-east-42nd-street-hamilton-hampton-heights-hampton-heights"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2197585"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "269020"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-03T18:41:49.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1281797"
+"ListOfficeNationalAssociationId": "1231482"
+"CoListAgentNationalAssociationId": "1446001"
+"CoListOfficeNationalAssociationId": "1231482"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986345')"
+"ID": "1590476"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29982354')"
+"ID": "1587666"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25359
+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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981552')"
+"ID": "1586616"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
+post_id: "1583605"
+post_author: 1
+"ListingKey": "29976828"
+"ListingId": "40831318"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T05:00:02Z"
+"RFModificationTimestamp": "2026-07-04T05:11:15Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.1
+"LivingArea": 1113.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8V2K8"
+"UnparsedAddress": "34 WINDRUSH Crescent, Hamilton, Ontario L8V2K8"
+"Coordinates": array:2 [
0 => -79.8481765
1 => 43.2197804
]
+"Latitude": 43.2197804
+"Longitude": -79.8481765
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Incredible opportunity on the Hamilton Mountain. Detached split-level home with attached garage in a sought-after family neighbourhood surrounded by homes with significantly higher values. Ideal for investors, contractors, renovators or buyers looking for their next project. Property requires extensive renovation and is being sold strictly in “as is, where is” condition with no representations or warranties by the Seller. A rare chance to transform a home in an established neighbourhood. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T06:43:07.527255+00:00"
+"Directions": "From Upper Gage, go west on Mohawk. Turn left on Lawfield Dr and right on Windrush Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2158770"
+"ListOfficeKey": "289424"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T04:59:50Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T04:59:50Z"
+"Stories": "1.0"
+"StreetName": "WINDRUSH"
+"StreetNumber": "34"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "183 - Lawfield"
+"TaxAnnualAmount": "4899.93"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29976828/34-windrush-crescent-hamilton"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 50.0
+"AboveGradeFinishedArea": 1113
+"OriginalEntryTimestamp": "2026-07-02T05:21:23.21Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Assessor"
+"ListAgentNationalAssociationId": "1410091"
+"ListOfficeNationalAssociationId": "1377637"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29976828')"
+"ID": "1583605"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23457
+post_id: "1582296"
+post_author: 1
+"ListingKey": "29975314"
+"ListingId": "X13508754"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-04T05:40:00Z"
+"RFModificationTimestamp": "2026-07-04T05:47:28Z"
+"ListPrice": 399999.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Lawfield)"
+"PostalCode": "L8V2K8"
+"UnparsedAddress": "34 WINDRUSH CRESCENT, Hamilton (Lawfield), Ontario L8V2K8"
+"Coordinates": array:2 [
0 => -79.848369
1 => 43.21977
]
+"Latitude": 43.21977
+"Longitude": -79.848369
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Incredible opportunity on the Hamilton Mountain. Detached split-level home with attached garage in a sought-after family neighbourhood surrounded by homes with significantly higher values. Ideal for investors, contractors, renovators or buyers looking for their next project. Property requires extensive renovation and is being sold strictly in "as is, where is" condition with no representations or warranties by the Seller. A rare chance to transform a home in an established neighbourhood! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:4 [
0 => "Partially 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-01T16:36:42.732068+00:00"
+"Directions": "Cross Streets: Upper Gage & Mohawk. ** Directions: From Upper Gage, go west on Mohawk. Turn left on Lawfield Dr and right on Windrush Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2246937"
+"ListOfficeKey": "279481"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "50 x 90 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-04T05:33:11Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-04T05:33:11Z"
+"Stories": "1.0"
+"StreetName": "Windrush"
+"StreetNumber": "34"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4899.93"
+"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"
+"TaxYear": 2026
+"CityRegion": "Lawfield"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29975314/34-windrush-crescent-hamilton-lawfield-lawfield"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "C"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 50.0
+"OriginalEntryTimestamp": "2026-07-01T15:45:37.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1485801"
+"ListOfficeNationalAssociationId": "1304915"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29975314')"
+"ID": "1582296"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25362
+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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974304')"
+"ID": "1581549"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25363
+post_id: "1580673"
+post_author: 1
+"ListingKey": "29973434"
+"ListingId": "X13507312"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T03:45:14Z"
+"RFModificationTimestamp": "2026-07-01T03:50:17Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Randall)"
+"PostalCode": "L8W2W6"
+"UnparsedAddress": "23 MILLPOND PLACE, Hamilton (Randall), Ontario L8W2W6"
+"Coordinates": array:2 [
0 => -79.854012
1 => 43.209251
]
+"Latitude": 43.209251
+"Longitude": -79.854012
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 23 Millpond Place, a meticulously maintained 4-level backsplit tucked away on a quiet court in one of Hamilton Mountain's most family-friendly neighbourhoods. Offering 3 bedrooms, 2 full bathrooms, an attached garage, and parking for up to 4 vehicles, this move-in ready home combines pride of ownership with exceptional functionality. Conveniently located close to schools, parks, public transit, Limeridge Mall, The Linc, Red Hill Parkway, and everyday amenities. The bright and updated kitchen features quartz countertops and matching backsplash, stainless steel appliances, gas stove, built-in dishwasher, updated cabinetry with modern hardware, and a large skylight that fills the space with natural light. The spacious family room is the perfect place to relax, offering a cozy gas fireplace, pot lights, California shutters, ample storage, and large above-grade lookout windows that provide plenty of natural light. A separate side entrance provides excellent potential for an in-law suite or future income generating rental suite. The lower levels feature a renovated full bathroom with a large walk in shower, a spacious recreation room, workshop with built-in workbench and corkboard, laundry room with cabinetry and additional fridge, cold cellar, crawl space, double closets, and an abundance of storage throughout. Step outside to enjoy the private backyard complete with a stone patio and storage shed, ideal for entertaining or relaxing outdoors. Additional features include a smart lock with keypad entry, attached single-car garage, private 3-car driveway, and no sidewalk in front of the home for added parking convenience. As an added bonus, the future Walmart planned for the Limeridge Mall redevelopment is just minutes away, further enhancing the convenience and long ter, appeal of this fantastic location. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-30T22:51:27.327797+00:00"
+"Directions": "Cross Streets: Upper Sherman Ave & Stone Church Rd E. ** Directions: Upper Sherman Ave - Princip St - Rexford Dr -Millpond PL."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Laminate"
1 => "Carpeted"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1888646"
+"ListOfficeKey": "269129"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "35.1 x 104.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T03:38:54Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T03:38:54Z"
+"StreetName": "Millpond"
+"StreetNumber": "23"
+"StreetSuffix": "Place"
+"TaxAnnualAmount": "5528.18"
+"VirtualTourURLUnbranded": "http://youtube.com/watch?v=ZPKVCjSCqI8&source_ve_path=MTc4NDI0"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Randall"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29973434/23-millpond-place-hamilton-randall-randall"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 35.1
+"OriginalEntryTimestamp": "2026-06-30T22:12:19.04Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1210325"
+"ListOfficeNationalAssociationId": "1231804"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29973434')"
+"ID": "1580673"
}
]
+success: true
+page_size: 9
+page_count: 12
+count: 107
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]