array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29845522 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1489018"
+post_author: 1
+"ListingKey": "29845522"
+"ListingId": "X13232624"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T14:41:05Z"
+"RFModificationTimestamp": "2026-06-03T17:10:22Z"
+"ListPrice": 779900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Landsdale)"
+"PostalCode": "L8L5E7"
+"UnparsedAddress": "155 VICTORIA AVENUE N, Hamilton (Landsdale), Ontario L8L5E7"
+"Coordinates": array:2 [
0 => -79.855017
1 => 43.25723
]
+"Latitude": 43.25723
+"Longitude": -79.855017
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Excellent opportunity to own a free-standing commercial/residential property in a prime corner location within a mature residential neighborhood. This property is primarily valued for the real estate itself, with the existing convenience store business included as an added bonus and future upside opportunity. The property offers approximately 2,000 sq ft and features multiple potential income streams, including a main floor retail space with attached 1-bedroom unit, a spacious second-floor 3-bedroom apartment with private entry and the estimated rental potential of approximately $2,400/month, plus a basement with 1 bedroom and 1 bathroom. Property also benefits from a city-issued legal separate entrance, adding flexibility and excellent long-term value with potential for additional permitted uses subject to buyer verification. The convenience store has been owner-operated for approximately 12 years and has built a loyal neighborhood customer base. This creates a strong opportunity for a hands-on buyer to revitalize the business and unlock additional income potential. Existing business and clientele are included in the sale, but the true value lies in the free-standing mixed-use property itself. Ideal for owner-operators, investors, or buyers seeking a versatile property with residential income and future commercial upside. Rare opportunity to acquire a free-standing building with substantial potential in an established Hamilton neighborhood. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T17:10:14.212775+00:00"
+"Directions": "Victoria Ave N & Cannon St E"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1986356"
+"ListOfficeKey": "274978"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "66 x 30 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T14:34:11Z"
+"PhotosCount": 2
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T14:34:11Z"
+"Stories": "2.0"
+"StreetDirSuffix": "North"
+"StreetName": "Victoria"
+"StreetNumber": "155"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4800"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "Landsdale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29845522/155-victoria-avenue-n-hamilton-landsdale-landsdale"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "Commercial"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 66.0
+"OriginalEntryTimestamp": "2026-06-03T14:34:11.17Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1270835"
+"ListOfficeNationalAssociationId": "1260218"
+"Media": array:2 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29845522_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29845522/51117c361acaf25911a4051618fee3a7.webp"
"MediaSize" => 53500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29845522/thumbnail-51117c361acaf25911a4051618fee3a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13232624"
"ResourceRecordKey" => "29845522"
"ModificationTimestamp" => "2026-06-03T14:34:11.18Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29845522_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29845522/f1a48f28e222037f5e0f0c82bd335f86.webp"
"MediaSize" => 187246
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29845522/thumbnail-f1a48f28e222037f5e0f0c82bd335f86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13232624"
"ResourceRecordKey" => "29845522"
"ModificationTimestamp" => "2026-06-03T14:34:11.18Z"
]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29845522')"
+"ID": "1489018"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.32 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 274978" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24787
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1986356" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24760
+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 '29845522'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25061
+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 '29845522'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25077
+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 '29845522' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.855017 43.25723)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25130
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25124
+post_id: "1545466"
+post_author: 1
+"ListingKey": "29924961"
+"ListingId": "X13463908"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:05:06Z"
+"RFModificationTimestamp": "2026-06-18T22:56:34Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Stinson)"
+"PostalCode": "L8N0B4"
+"UnparsedAddress": "204 - 479 CHARLTON AVENUE E, Hamilton (Stinson), Ontario L8N0B4"
+"Coordinates": array:2 [
0 => -79.853404
1 => 43.245461
]
+"Latitude": 43.245461
+"Longitude": -79.853404
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 204 at Vista Condos - the coveted Poplar floor plan offering 937 sqft and one of the largest balconies in the building. With only two suites of this size per floor, this 2-bedroom, 2-bathroom corner residence offers a rare blend of privacy, sophistication, and elevated urban living. Wrapped in a soothing designer white palette, the suite feels calm, bright, and beautifully composed.The kitchen features extended white cabinetry, quartz countertops, a designer backsplash, and quality flooring that carries throughout the space. The main bath is finished with a glass shower and striking black accent tile, while the spacious primary suite offers a walk-in closet and oversized ensuite for a refined daily retreat. In-suite laundry adds everyday ease. Step outside to an exceptional private balcony framed by treetop, rail trail, and city views - peaceful, green, and quietly removed, yet moments from the energy of the city. Your new home offers thoughtful amenities including a gym, terrace, bike room, party room, visitor parking, a BBQ area, and attentive cleaning staff. A prime underground parking spot beside the elevator and an extra-large locker are both included. Condo fees include heat and water, common elements, and building insurance. Set moments from Corktown, Locke Street dining, St. Joe's Hospital, the GO Station, 403/QEW/LINC access, McMaster, James North, and the Niagara Escarpment trail system, this is a stylish treetop retreat designed for young professionals and first-time buyers ready for a lifestyle upgrade. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Range"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"AssociationFee": "806.86"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T22:56:27.342933+00:00"
+"Directions": "Cross Streets: Charlton Ave E & Wentworth St S. ** Directions: 403 to Main St W, East on Main, Right on Wentworth."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2010060"
+"ListOfficeKey": "278195"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Hillside"
1 => "Wooded area"
2 => "Elevator"
3 => "Balcony"
4 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T20:59:22Z"
+"PhotosCount": 31
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:59:22Z"
+"StreetDirSuffix": "East"
+"StreetName": "Charlton"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5434.74"
+"View": "City view"
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1662429097"
"RoomType" => "Foyer"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 1.24
"ListingKey" => "29924961"
"RoomLength" => 2.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.23Z"
]
1 => array:11 [
"RoomKey" => "1662429098"
"RoomType" => "Kitchen"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 2.34
"ListingKey" => "29924961"
"RoomLength" => 2.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.23Z"
]
2 => array:11 [
"RoomKey" => "1662429099"
"RoomType" => "Dining room"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 2.79
"ListingKey" => "29924961"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
3 => array:11 [
"RoomKey" => "1662429100"
"RoomType" => "Living room"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29924961"
"RoomLength" => 3.51
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
4 => array:11 [
"RoomKey" => "1662429101"
"RoomType" => "Bedroom"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 2.79
"ListingKey" => "29924961"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
5 => array:11 [
"RoomKey" => "1662429102"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 3.38
"ListingKey" => "29924961"
"RoomLength" => 3.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
6 => array:11 [
"RoomKey" => "1662429103"
"RoomType" => "Bathroom"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 3.3
"ListingKey" => "29924961"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
7 => array:11 [
"RoomKey" => "1662429104"
"RoomType" => "Bathroom"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 2.2
"ListingKey" => "29924961"
"RoomLength" => 1.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
8 => array:11 [
"RoomKey" => "1662429105"
"RoomType" => "Laundry room"
"ListingId" => "X13463908"
"RoomLevel" => "Main level"
"RoomWidth" => 0.83
"ListingKey" => "29924961"
"RoomLength" => 0.68
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T20:59:22.24Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Stinson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29924961/204-479-charlton-avenue-e-hamilton-stinson-stinson"
+"ParkingTotal": 1
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Property Management Guild"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
]
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"LivingAreaMaximum": 999
+"LivingAreaMinimum": 900
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-18T20:59:22.2Z"
+"ListAgentNationalAssociationId": "1291647"
+"ListOfficeNationalAssociationId": "1290805"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29924961_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/f0ce23f1fab658e1cd42e1562248fa22.webp"
"MediaSize" => 182706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-f0ce23f1fab658e1cd42e1562248fa22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29924961_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/e3578e5d95ebe2139f2605d7e68f9cff.webp"
"MediaSize" => 189307
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-e3578e5d95ebe2139f2605d7e68f9cff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29924961_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/527b9e5823d36a573a72eb8a51786b92.webp"
"MediaSize" => 214982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-527b9e5823d36a573a72eb8a51786b92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29924961_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/5baad21d1e3999af235eed4464b64e7f.webp"
"MediaSize" => 125424
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-5baad21d1e3999af235eed4464b64e7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29924961_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/f92d0f6f6dd1bd86497982744e30c8fd.webp"
"MediaSize" => 95267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-f92d0f6f6dd1bd86497982744e30c8fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29924961_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/2946e2c8bddd7ed517b2f4a98e68cb0d.webp"
"MediaSize" => 64916
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-2946e2c8bddd7ed517b2f4a98e68cb0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29924961_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/7aec1b500ba95e79a080fb3e4ec32fd6.webp"
"MediaSize" => 78119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-7aec1b500ba95e79a080fb3e4ec32fd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29924961_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/0d6942437a31833811a8c510af583cab.webp"
"MediaSize" => 78215
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-0d6942437a31833811a8c510af583cab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29924961_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/e3af0f10acc7b0ae2e97d3d0c98ca224.webp"
"MediaSize" => 65769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-e3af0f10acc7b0ae2e97d3d0c98ca224.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29924961_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/16aba8bd4f3f7b4c4ea21715e0d215cc.webp"
"MediaSize" => 78504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-16aba8bd4f3f7b4c4ea21715e0d215cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29924961_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/c4261523f27e04c4a4bad091e8f0b73b.webp"
"MediaSize" => 139910
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-c4261523f27e04c4a4bad091e8f0b73b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29924961_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/43a537b4ae22b94e3dfe4c337cdbdd56.webp"
"MediaSize" => 146018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-43a537b4ae22b94e3dfe4c337cdbdd56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29924961_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/56bbf41533a04fec8d6dfb3051d73047.webp"
"MediaSize" => 129510
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-56bbf41533a04fec8d6dfb3051d73047.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29924961_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/16159454515abe2a8fed60d85eac75ef.webp"
"MediaSize" => 211251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-16159454515abe2a8fed60d85eac75ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29924961_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/aaa8be739fe5622430509d759d233e7c.webp"
"MediaSize" => 99671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-aaa8be739fe5622430509d759d233e7c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29924961_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/ba31cb034ad61abe36099a4a79df310e.webp"
"MediaSize" => 100839
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-ba31cb034ad61abe36099a4a79df310e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29924961_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/1f11a08d9806d94dd7c7b03dabd93b6e.webp"
"MediaSize" => 104091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-1f11a08d9806d94dd7c7b03dabd93b6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29924961_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/78685d0232cecabf527b8770bb557f48.webp"
"MediaSize" => 67155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-78685d0232cecabf527b8770bb557f48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29924961_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/539b349e66ab83e7c8bd698476f2e614.webp"
"MediaSize" => 67526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-539b349e66ab83e7c8bd698476f2e614.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29924961_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/d6b99b328931c4e1840e9825426c62f2.webp"
"MediaSize" => 87354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-d6b99b328931c4e1840e9825426c62f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29924961_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/22620d2846b4276838feac306c9b0c05.webp"
"MediaSize" => 63448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-22620d2846b4276838feac306c9b0c05.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29924961_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/549d4cf3b2a2c5855c12f47075f09a7f.webp"
"MediaSize" => 82680
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-549d4cf3b2a2c5855c12f47075f09a7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29924961_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/e37bf2db2ac2d77f6fc3ccc5fbf13b61.webp"
"MediaSize" => 100997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-e37bf2db2ac2d77f6fc3ccc5fbf13b61.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29924961_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/14c3cdd58a1a7b77d9e36bcafdc38765.webp"
"MediaSize" => 117109
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-14c3cdd58a1a7b77d9e36bcafdc38765.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29924961_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/7be718e8775c392c8610b89c2e34da53.webp"
"MediaSize" => 85667
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-7be718e8775c392c8610b89c2e34da53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29924961_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/b1d3512a02eaee41a975e296905df13b.webp"
"MediaSize" => 97293
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-b1d3512a02eaee41a975e296905df13b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29924961_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/7ce48d986ed51ffd2880906b8ddf32e1.webp"
"MediaSize" => 120996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-7ce48d986ed51ffd2880906b8ddf32e1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29924961_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/9b4287428e8105085e91e8f8f01140a5.webp"
"MediaSize" => 114969
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-9b4287428e8105085e91e8f8f01140a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29924961_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/a85f20fea67e04ae4d7f3da1e66739ba.webp"
"MediaSize" => 123592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-a85f20fea67e04ae4d7f3da1e66739ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29924961_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/fc24944be32cbe20692b23b38b408a6b.webp"
"MediaSize" => 184263
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-fc24944be32cbe20692b23b38b408a6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29924961_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924961/8c6c1a0ac79fe97fd303e27f9eecc16c.webp"
"MediaSize" => 59218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924961/thumbnail-8c6c1a0ac79fe97fd303e27f9eecc16c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463908"
"ResourceRecordKey" => "29924961"
"ModificationTimestamp" => "2026-06-18T20:59:22.2Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924961')"
+"ID": "1545466"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25126
+post_id: "1545065"
+post_author: 1
+"ListingKey": "29924745"
+"ListingId": "X13463608"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T22:05:19Z"
+"RFModificationTimestamp": "2026-06-18T22:06:01Z"
+"ListPrice": 423500.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Central)"
+"PostalCode": "L8P1H8"
+"UnparsedAddress": "715 - 150 MAIN STREET W, Hamilton (Central), Ontario L8P1H8"
+"Coordinates": array:2 [
0 => -79.8757162
1 => 43.2570311
]
+"Latitude": 43.2570311
+"Longitude": -79.8757162
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 715 at 150 Main Street West, where modern downtown living meets convenience and value in the heart of Hamilton. This bright and spacious 1-bedroom, 1-bathroom condo offers an open-concept layout designed for comfortable everyday living, featuring a contemporary kitchen with granite countertops, stainless steel appliances, in-suite laundry, and floor-to-ceiling windows that fill the space with natural light. Perfect for first-time buyers, professionals, students, investors, or those looking to downsize without compromise, this well-maintained building offers an impressive collection of amenities including concierge service, fitness centre, indoor pool, party room, rooftop terrace with BBQ area, visitor parking, and more. Step outside and enjoy everything downtown Hamilton has to offer. Located just minutes from Hess Village, Locke Street, restaurants, cafes, shopping, entertainment, hospitals, McMaster University, and the Hamilton GO Centre, this location is ideal for commuters and urban lifestyle enthusiasts alike. Easy access to Highway 403 and major transit routes makes travelling throughout Hamilton and the GTA effortless. Whether you're looking for your first home, a low-maintenance lifestyle, or a fantastic investment opportunity in one of Hamilton's most vibrant and growing downtown communities, Unit 715 offers exceptional value in a highly desirable location. Move in and enjoy everything city living has to offer. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "483.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets not Allowed"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T21:38:33.652298+00:00"
+"Directions": "Main St W & Caroline St S"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2194116"
+"ListOfficeKey": "293406"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T21:59:12Z"
+"PhotosCount": 8
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T21:59:12Z"
+"StreetDirSuffix": "West"
+"StreetName": "Main"
+"StreetNumber": "150"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3799.66"
+"Rooms": array:3 [
0 => array:11 [
"RoomKey" => "1662477674"
"RoomType" => "Kitchen"
"ListingId" => "X13463608"
"RoomLevel" => "Main level"
"RoomWidth" => 3.25
"ListingKey" => "29924745"
"RoomLength" => 4.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:12.33Z"
]
1 => array:11 [
"RoomKey" => "1662477675"
"RoomType" => "Living room"
"ListingId" => "X13463608"
"RoomLevel" => "Main level"
"RoomWidth" => 3.35
"ListingKey" => "29924745"
"RoomLength" => 4.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:12.33Z"
]
2 => array:11 [
"RoomKey" => "1662477676"
"RoomType" => "Bedroom"
"ListingId" => "X13463608"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29924745"
"RoomLength" => 4.32
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T21:59:12.33Z"
]
]
+"ListAOR": "Toronto"
+"CityRegion": "Central"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29924745/715-150-main-street-w-hamilton-central-central"
+"ParkingTotal": 0
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wentworth Standard Condominium Corporation"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 600
+"BedroomsAboveGrade": 1
+"OriginalEntryTimestamp": "2026-06-18T20:33:25.34Z"
+"ListAgentNationalAssociationId": "1466930"
+"ListOfficeNationalAssociationId": "1426616"
+"Media": array:8 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29924745_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924745/eb34e039f8fc6c4a00a4a78a4fb44d68.webp"
"MediaSize" => 243002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924745/thumbnail-eb34e039f8fc6c4a00a4a78a4fb44d68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13463608"
"ResourceRecordKey" => "29924745"
"ModificationTimestamp" => "2026-06-18T20:33:25.35Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29924745_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924745/32fce2e44d4c9012a825e68f0448b1c5.webp"
"MediaSize" => 208052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924745/thumbnail-32fce2e44d4c9012a825e68f0448b1c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463608"
"ResourceRecordKey" => "29924745"
"ModificationTimestamp" => "2026-06-18T20:33:25.35Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29924745_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924745/67798bfbe91fb91286d63fc4dad8ba2e.webp"
"MediaSize" => 63236
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924745/thumbnail-67798bfbe91fb91286d63fc4dad8ba2e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463608"
"ResourceRecordKey" => "29924745"
"ModificationTimestamp" => "2026-06-18T21:27:37.49Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29924745_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924745/11b2ce53c3daaba77d02d78ea9115708.webp"
"MediaSize" => 125203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924745/thumbnail-11b2ce53c3daaba77d02d78ea9115708.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463608"
"ResourceRecordKey" => "29924745"
"ModificationTimestamp" => "2026-06-18T21:27:45.27Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29924745_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924745/e73beb553a5099712d8d7ed3377245fc.webp"
"MediaSize" => 134661
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924745/thumbnail-e73beb553a5099712d8d7ed3377245fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463608"
"ResourceRecordKey" => "29924745"
"ModificationTimestamp" => "2026-06-18T21:27:23.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29924745_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924745/25522c6c4bf19dcf7ad6ae9f8c6ac533.webp"
"MediaSize" => 105240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924745/thumbnail-25522c6c4bf19dcf7ad6ae9f8c6ac533.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463608"
"ResourceRecordKey" => "29924745"
"ModificationTimestamp" => "2026-06-18T21:27:33.93Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29924745_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924745/3b1edd20e10b8b085ed0640f691359fc.webp"
"MediaSize" => 126618
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924745/thumbnail-3b1edd20e10b8b085ed0640f691359fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463608"
"ResourceRecordKey" => "29924745"
"ModificationTimestamp" => "2026-06-18T21:27:44.2Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29924745_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924745/6cd998d1f3e5ad1bf33726523b37a592.webp"
"MediaSize" => 57374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924745/thumbnail-6cd998d1f3e5ad1bf33726523b37a592.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13463608"
"ResourceRecordKey" => "29924745"
"ModificationTimestamp" => "2026-06-18T21:27:55.05Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924745')"
+"ID": "1545065"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25123
+post_id: "1545515"
+post_author: 1
+"ListingKey": "29924553"
+"ListingId": "40841275"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T20:20:31Z"
+"RFModificationTimestamp": "2026-06-18T20:37:49Z"
+"ListPrice": 450000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 937.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8N0B4"
+"UnparsedAddress": "479 CHARLTON Avenue E Unit# 204, Hamilton, Ontario L8N0B4"
+"Coordinates": array:2 [
0 => -79.8534172
1 => 43.2454945
]
+"Latitude": 43.2454945
+"Longitude": -79.8534172
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 204 at Vista Condos — the coveted Poplar floor plan offering 937 sqft and one of the largest balconies in the building at 142 sqft. With only two suites of this size per floor, this 2-bedroom, 2-bathroom corner residence offers a rare blend of privacy, sophistication, and elevated urban living. Wrapped in a soothing designer white palette, the suite feels calm, bright, and beautifully composed. The kitchen features extended white cabinetry, quartz countertops, a designer backsplash, and quality flooring that carries throughout the space. The main bath is finished with a glass shower and striking black accent tile, while the spacious primary suite offers a walk-in closet and oversized ensuite for a refined daily retreat. In-suite laundry adds everyday ease. Step outside to an exceptional private balcony framed by treetop, rail trail, and city views — peaceful, green, and quietly removed, yet moments from the energy of the city. Your new home offers thoughtful amenities including a gym, terrace, bike room, party room, visitor parking, a bbq area, and attentive cleaning staff. A prime underground parking spot beside the elevator and an extra-large locker are both included. Condo fees include heat and water, common elements, and building insurance. Set moments from Corktown, Locke Street dining, St. Joe’s Hospital, the GO Station, 403/QEW/LINC access, McMaster, James North, and the Niagara Escarpment trail system, this is a stylish treetop retreat designed for young professionals and first-time buyers ready for a lifestyle upgrade. (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"AssociationFee": "806.86"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:6 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Heat"
4 => "Water"
5 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T20:37:41.838901+00:00"
+"Directions": "403 to Main St W, East on Main, Right on Wentworth"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073224"
+"ListOfficeKey": "283262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-18T20:11:28Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:11:28Z"
+"Stories": "1.0"
+"StreetDirSuffix": "East"
+"StreetName": "CHARLTON"
+"StreetNumber": "479"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "143 - Stinson"
+"TaxAnnualAmount": "5434.74"
+"View": "City view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [
"RoomKey" => "1662388920"
"RoomType" => "Laundry room"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "2'9'' x 2'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
1 => array:11 [
"RoomKey" => "1662388921"
"RoomType" => "3pc Bathroom"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "7'3'' x 5'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
2 => array:11 [
"RoomKey" => "1662388922"
"RoomType" => "4pc Bathroom"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "10'10'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
3 => array:11 [
"RoomKey" => "1662388923"
"RoomType" => "Primary Bedroom"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
4 => array:11 [
"RoomKey" => "1662388924"
"RoomType" => "Bedroom"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
5 => array:11 [
"RoomKey" => "1662388925"
"RoomType" => "Living room"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "11'0'' x 11'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
6 => array:11 [
"RoomKey" => "1662388926"
"RoomType" => "Dining room"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.08Z"
]
7 => array:11 [
"RoomKey" => "1662388927"
"RoomType" => "Kitchen"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 7'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.09Z"
]
8 => array:11 [
"RoomKey" => "1662388928"
"RoomType" => "Foyer"
"ListingId" => "40841275"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29924553"
"RoomLength" => null
"RoomDimensions" => "4'1'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T20:11:28.09Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29924553/479-charlton-avenue-e-unit-204-hamilton"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:5 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
3 => "Unknown"
4 => "Monitored Alarm"
]
+"ZoningDescription": "E/S-1710, P5"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 937
+"OriginalEntryTimestamp": "2026-06-18T20:11:28Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1414150"
+"ListOfficeNationalAssociationId": "1326249"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29924553_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/b342a4663e97699f0b3d04da8e1d58a8.webp"
"MediaSize" => 167780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-b342a4663e97699f0b3d04da8e1d58a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29924553_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/1f0e5400b40807dc307613789d158133.webp"
"MediaSize" => 173908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-1f0e5400b40807dc307613789d158133.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29924553_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/a10e6b789d5eac39bdd8b1c2ad7ca351.webp"
"MediaSize" => 95704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-a10e6b789d5eac39bdd8b1c2ad7ca351.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29924553_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/f376e3def6175baf4d3718828564be88.webp"
"MediaSize" => 113740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-f376e3def6175baf4d3718828564be88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29924553_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/90a802a847188121fde90d3dba6f7c69.webp"
"MediaSize" => 82972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-90a802a847188121fde90d3dba6f7c69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29924553_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/ccacdfd926d7b5e893481f68bb4a0b58.webp"
"MediaSize" => 28035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-ccacdfd926d7b5e893481f68bb4a0b58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29924553_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/d773ab37654bf277eed37037285b2e9d.webp"
"MediaSize" => 70287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-d773ab37654bf277eed37037285b2e9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29924553_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/d15c3a4a169659eeaa814815c216edba.webp"
"MediaSize" => 58416
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-d15c3a4a169659eeaa814815c216edba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29924553_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/8e2feb9de21eba4fb85df73c404746c9.webp"
"MediaSize" => 68529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-8e2feb9de21eba4fb85df73c404746c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29924553_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/222d8b2c114729f9ea0cf5373f5d4ad1.webp"
"MediaSize" => 128156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-222d8b2c114729f9ea0cf5373f5d4ad1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29924553_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/6fceec80f1b29a680f67edbe1aa053e0.webp"
"MediaSize" => 133350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-6fceec80f1b29a680f67edbe1aa053e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29924553_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/d285ddb934a246299ba79b762d832194.webp"
"MediaSize" => 118086
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-d285ddb934a246299ba79b762d832194.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29924553_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/1d0d26d663985871859ee362ecd7afe8.webp"
"MediaSize" => 89641
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-1d0d26d663985871859ee362ecd7afe8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29924553_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/d1d056ab751ebd79c9e553e1f0f0ede0.webp"
"MediaSize" => 90841
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-d1d056ab751ebd79c9e553e1f0f0ede0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29924553_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/18e75960bfff1b42a9ce594676c32264.webp"
"MediaSize" => 93967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-18e75960bfff1b42a9ce594676c32264.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29924553_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/fc5edb8ba934890696fb3155a23e68e3.webp"
"MediaSize" => 59141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-fc5edb8ba934890696fb3155a23e68e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29924553_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/940ed310119360ad4cb0f4f3892bc593.webp"
"MediaSize" => 29972
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-940ed310119360ad4cb0f4f3892bc593.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29924553_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/56c03ac1b5c41522c96353e953e76c14.webp"
"MediaSize" => 39954
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-56c03ac1b5c41522c96353e953e76c14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29924553_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/e7f46fdbad95c17ee125a3a988483a9c.webp"
"MediaSize" => 54453
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-e7f46fdbad95c17ee125a3a988483a9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29924553_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/8bc02f4ed1a4bcaccd459447664b349e.webp"
"MediaSize" => 36065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-8bc02f4ed1a4bcaccd459447664b349e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29924553_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/b15087d4f6388950f714324b50df1aef.webp"
"MediaSize" => 106802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-b15087d4f6388950f714324b50df1aef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40841275"
"ResourceRecordKey" => "29924553"
"ModificationTimestamp" => "2026-06-18T20:11:28.01Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29924553_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924553/372abeb6262c12254fe1f1efaeee4688.webp"
"MediaSize" => 76907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924553/thumbnail-372abeb6262c12254fe1f1efaeee4688.webp"
…7
]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924553')"
+"ID": "1545515"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25127
+post_id: "1544595"
+post_author: 1
+"ListingKey": "29924226"
+"ListingId": "40841054"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:30:05Z"
+"RFModificationTimestamp": "2026-06-19T01:26:38Z"
+"ListPrice": 423500.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 672.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8P1H8"
+"UnparsedAddress": "150 MAIN Street W Unit# 715, Hamilton, Ontario L8P1H8"
+"Coordinates": array:2 [
0 => -79.8756163
1 => 43.2571719
]
+"Latitude": 43.2571719
+"Longitude": -79.8756163
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to Unit 715 at 150 Main Street West, where modern downtown living meets convenience and value in the heart of Hamilton. This bright and spacious 1-bedroom, 1-bathroom condo offers an open-concept layout designed for comfortable everyday living, featuring a contemporary kitchen with granite countertops, stainless steel appliances, in-suite laundry, and floor-to-ceiling windows that fill the space with natural light. Perfect for first-time buyers, professionals, students, investors, or those looking to downsize without compromise, this well-maintained building offers an impressive collection of amenities including concierge service, fitness centre, indoor pool, party room, rooftop terrace with BBQ area, visitor parking, and more. Step outside and enjoy everything downtown Hamilton has to offer. Located just minutes from Hess Village, Locke Street, restaurants, cafes, shopping, entertainment, hospitals, McMaster University, and the Hamilton GO Centre, this location is ideal for commuters and urban lifestyle enthusiasts alike. Easy access to Highway 403 and major transit routes makes travelling throughout Hamilton and the GTA effortless. Whether you're looking for your first home, a low-maintenance lifestyle, or a fantastic investment opportunity in one of Hamilton's most vibrant and growing downtown communities, Unit 715 offers exceptional value in a highly desirable location. Move in and enjoy everything city living has to offer. (id:62650)"
+"AssociationFee": "483.87"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Water"
2 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:58:13.193855+00:00"
+"Directions": "Intersection of Main Street West and Caroline St S in Hamilton"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1999374"
+"ListOfficeKey": "293198"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "None"
]
+"PhotosChangeTimestamp": "2026-06-18T21:24:48Z"
+"PhotosCount": 8
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T21:24:48Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "MAIN"
+"StreetNumber": "150"
+"StreetSuffix": "Street"
+"SubdivisionName": "104 - Central South"
+"TaxAnnualAmount": "3799.66"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29924226/150-main-street-w-unit-715-hamilton"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "2131414"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "292265"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Exercise Centre"
]
+"ZoningDescription": "D3"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 672
+"OriginalEntryTimestamp": "2026-06-18T19:24:47.81Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1281693"
+"ListOfficeNationalAssociationId": "1423711"
+"CoListAgentNationalAssociationId": "1384171"
+"CoListOfficeNationalAssociationId": "1409992"
+"Media": array:8 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924226')"
+"ID": "1544595"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25125
+post_id: "1544290"
+post_author: 1
+"ListingKey": "29923615"
+"ListingId": "X13462614"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:40:20Z"
+"RFModificationTimestamp": "2026-06-18T19:31:40Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8L6M4"
+"UnparsedAddress": "86 SHERMAN AVENUE N, Hamilton (Gibson), Ontario L8L6M4"
+"Coordinates": array:2 [
0 => -79.836845
1 => 43.254071
]
+"Latitude": 43.254071
+"Longitude": -79.836845
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Step into a piece of Hamilton history at 86 Sherman Avenue North. This grand Victorian residence showcases the kind of craftsmanship, character, and architectural detail that simply cannot be replicated today. From its impressive proportions to its timeless charm, this is a home that tells a story. Featuring 6 spacious bedrooms and 2 large bathrooms, the property provides exceptional flexibility for large families, multigenerational living, or those seeking a restoration project with tremendous upside. Original features such as 10 ft ceilings, 12" baseboards & refinished pine floors create a rare foundation for someone with a vision to bring this remarkable home back to its full potential. Convenient rear laneway access provides valuable private parking, while the central location places you just minutes from downtown Hamilton, the vibrant shops and restaurants of Ottawa Street and James Street North, Gage Park, schools, public transit, and easy highway access for commuters. Whether you're an investor, renovator, or buyer searching for a truly unique property, opportunities like this are becoming increasingly rare. Restore, reimagine, and revive one of Hamilton's classic Victorian homes. (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:31:30.958383+00:00"
+"Directions": "Cross Streets: Cannon St. E. ** Directions: West on Cannon St. E., North on Sherman Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2036043"
+"ListOfficeKey": "291490"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Lane"
1 => "Carpet Free"
]
+"LotSizeDimensions": "32 x 110 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T18:33:09Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T18:33:09Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "Sherman"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4659"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LwvocnAkqtj"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29923615/86-sherman-avenue-n-hamilton-gibson-gibson"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 6
+"FrontageLengthNumeric": 32.0
+"OriginalEntryTimestamp": "2026-06-18T18:33:09.74Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1312659"
+"ListOfficeNationalAssociationId": "1398828"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923615')"
+"ID": "1544290"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25120
+post_id: "1543934"
+post_author: 1
+"ListingKey": "29923022"
+"ListingId": "40840784"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T18:00:12Z"
+"RFModificationTimestamp": "2026-06-18T19:07:59Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2657.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8L6M4"
+"UnparsedAddress": "86 SHERMAN Avenue N, Hamilton, Ontario L8L6M4"
+"Coordinates": array:2 [
0 => -79.8370126
1 => 43.2541
]
+"Latitude": 43.2541
+"Longitude": -79.8370126
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Step into a piece of Hamilton history at 86 Sherman Avenue North. This grand Victorian residence showcases the kind of craftsmanship, character, and architectural detail that simply cannot be replicated today. From its impressive proportions to its timeless charm, this is a home that tells a story. Featuring 6 spacious bedrooms and 2 large bathrooms, the property provides exceptional flexibility for large families, multigenerational living, or those seeking a restoration project with tremendous upside. Original features such as 10 ft ceilings, 12 baseboards & refinished pine floors create a rare foundation for someone with a vision to bring this remarkable home back to its full potential. Convenient rear laneway access provides valuable private parking, while the central location places you just minutes from downtown Hamilton, the vibrant shops and restaurants of Ottawa Street and James Street North, Gage Park, schools, public transit, and easy highway access for commuters. Whether you're an investor, renovator, or buyer searching for a truly unique property, opportunities like this are becoming increasingly rare. Restore, reimagine, and revive one of Hamilton's classic Victorian homes. (id:62650)"
+"Appliances": array:2 [
0 => "Washer"
1 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T19:07:21.652135+00:00"
+"Directions": "West on Cannon St. E., North on Sherman Ave. N."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1562180"
+"ListOfficeKey": "291472"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-18T17:32:47Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T17:50:33Z"
+"Stories": "2.5"
+"StreetDirSuffix": "North"
+"StreetName": "SHERMAN"
+"StreetNumber": "86"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "4659"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LwvocnAkqtj"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29923022/86-sherman-avenue-n-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 2657
+"OriginalEntryTimestamp": "2026-06-18T17:32:47.28Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1148101"
+"ListOfficeNationalAssociationId": "1398404"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29923022')"
+"ID": "1543934"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1543076"
+post_author: 1
+"ListingKey": "29921729"
+"ListingId": "40839562"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T19:40:11Z"
+"RFModificationTimestamp": "2026-06-18T19:51:58Z"
+"ListPrice": 810000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1770.0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L8M2N4"
+"UnparsedAddress": "33 SAINT CLAIR Avenue, Hamilton, Ontario L8M2N4"
+"Coordinates": array:2 [
0 => -79.8396012
1 => 43.2502561
]
+"Latitude": 43.2502561
+"Longitude": -79.8396012
+"YearBuilt": 1910
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Located on a famously family-friendly street lined with mature trees, this 2 1/2 storey, 1770 sq ft, three bedroom + den family home is perfectly situated away from busy streets. Exuding timeless character, the original millwork, trim, doors and floors throughout the foyer, living room and dining room create a warm and welcoming atmosphere. The cozy living room with fireplace and bay window can be separated from the dining room with the classic sliding pocket doors that this era of homes is know for. Morning coffee, summer evenings and simply unwinding can be enjoyed on the large, covered front porch. Upstairs, three bedrooms, a full bathroom and den (that can be a small bedroom or office), offer plenty of space for any growing family or guests. Walkout from the den to a beautiful rooftop deck adds even more outdoor living space. The top storey is over 400 sq ft, finished, easily accessible by stairs and contains an amazing child-friendly “secret” treehouse style playroom. The loft could also serve as an additional bedroom, the choice is yours. The spacious kitchen comes with a convenient walkout to a very private and comfortable backyard. Front yard parking means never looking for a spot and comes with a NEMA 14-50 EV car charger. Full Basement with multiple storage rooms, cold room, and 3-Pc bathroom. Forced air furnace and central air means no radiators to bleed. Waterline replaced in 2025. Electrical and plumbing upgraded in 2015-2016. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
5 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:46:40.695416+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235618"
+"ListOfficeKey": "106156"
+"LivingAreaUnits": "square feet"
+"PhotosChangeTimestamp": "2026-06-18T15:32:20Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T19:31:32Z"
+"Stories": "2.5"
+"StreetName": "SAINT CLAIR"
+"StreetNumber": "33"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "200 - Gibson/Stipley"
+"TaxAnnualAmount": "4562.7"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/33-St-Clair-Ave"
+"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/29921729/33-saint-clair-avenue-hamilton"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 29.0
+"AboveGradeFinishedArea": 1770
+"OriginalEntryTimestamp": "2026-06-18T15:32:20.02Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1473446"
+"ListOfficeNationalAssociationId": "1223962"
+"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('29921729')"
+"ID": "1543076"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25128
+post_id: "1542919"
+post_author: 1
+"ListingKey": "29921604"
+"ListingId": "X13460776"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T15:45:19Z"
+"RFModificationTimestamp": "2026-06-18T16:44:05Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Durand)"
+"PostalCode": "L8P4S5"
+"UnparsedAddress": "606 - 222 JACKSON STREET W, Hamilton (Durand), Ontario L8P4S5"
+"Coordinates": array:2 [
0 => -79.87894
1 => 43.256866
]
+"Latitude": 43.256866
+"Longitude": -79.87894
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located in the sought-after Village Hill, in the heart of Hamilton's prestigious Durand neighbourhood, this spacious 1,350 square foot residence offers an exceptional blend of size, elegance and walkable urban convenience. The suite features two generous bedrooms, including a primary retreat with private ensuite, plus a well-appointed living room and separate dining room accented with classic wainscotting, creating a refined yet welcoming space for both everyday living and entertaining. Large windows fill the home with natural light and the balcony captures beautiful water views, perfect for morning coffee or relaxing evenings. The unit includes one underground parking space and a private locker, while the well-managed, pet-friendly building also offers visitor parking, a fitness room, sauna, a penthouse-level party/meeting room with sweeping views and a designated "doggie" park for resident dogs. Condo fees include heat, air conditioning and water, offering excellent value and predictable monthly expenses. With a Walk Score of 98, this is about as central as Hamilton living gets; steps to Hess Village, Locke Street's boutiques and cafés, the Hamilton Farmers' Market and an easy walk to local restaurants, coffee shops and parks, with quick access to the GO Centre, Highway 403 and the future LRT for effortless commuting. Day-to-day essentials are equally close at hand with nearby grocery and pharmacy options and transit keeps car-optional living simple. A rare opportunity to enjoy generous square portage, classic detailing and a prime downtown location in one exceptional package. RSA. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "1536.45"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Water"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:42:59.974096+00:00"
+"Directions": "Cross Streets: Queen St S. ** Directions: Hwy 8 to Queen St S to Jackson St W - before Hess St S."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1979013"
+"ListOfficeKey": "293273"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-18T15:15:23Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T15:37:16Z"
+"StreetDirSuffix": "West"
+"StreetName": "Jackson"
+"StreetNumber": "222"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3091"
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Durand"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29921604/606-222-jackson-street-w-hamilton-durand-durand"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Condo Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Exercise Centre"
2 => "Party Room"
3 => "Sauna"
]
+"SecurityFeatures": array:1 [
0 => "Controlled entry"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"ZoningDescription": "E3"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-18T15:15:23.3Z"
+"ListAgentNationalAssociationId": "1264940"
+"ListOfficeNationalAssociationId": "1424812"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921604')"
+"ID": "1542919"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25129
+post_id: "1542891"
+post_author: 1
+"ListingKey": "29922111"
+"ListingId": "X13461424"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T21:05:05Z"
+"RFModificationTimestamp": "2026-06-18T21:10:54Z"
+"ListPrice": 810000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton (Gibson)"
+"PostalCode": "L8M2N4"
+"UnparsedAddress": "33 SAINT CLAIR AVENUE, Hamilton (Gibson), Ontario L8M2N4"
+"Coordinates": array:2 [
0 => -79.8396496
1 => 43.250259
]
+"Latitude": 43.250259
+"Longitude": -79.8396496
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Located on a famously family-friendly street lined with mature trees, this 2 1/2 storey, 1770 sq ft, three bedroom + den family home is perfectly situated away from busy streets. Exuding timeless character, the original millwork, trim, doors and floors throughout the foyer, living room and dining room create a warm and welcoming atmosphere. The cozy living room with fireplace and bay window can be separated from the dining room with the classic sliding pocket doors that this era of homes is know for. Morning coffee, summer evenings and simply unwinding can be enjoyed on the large, covered front porch. Upstairs, three bedrooms, a full bathroom and den (that can be a small bedroom or office), offer plenty of space for any growing family or guests. Walkout from the den to a beautiful rooftop deck adds even more outdoor living space. The top storey is over 400 sq ft, finished, easily accessible by stairs and contains an amazing child-friendly "secret" treehouse style playroom. The loft could also serve as an additional bedroom, the choice is yours. The spacious kitchen comes with a convenient walkout to a very private and comfortable backyard. Front yard parking means never looking for a spot and comes with a NEMA 14-50 EV car charger. Full Basement with multiple storage rooms, cold room, and 3-Pc bathroom. Forced air furnace and central air means no radiators to bleed. Waterline replaced in 2025. Electrical and plumbing upgraded in 2015-2016. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:42:11.953852+00:00"
+"Directions": "King St E & Sherman Ave S"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1980677"
+"ListOfficeKey": "290193"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "29 x 88.7 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T16:05:42Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T20:59:17Z"
+"Stories": "2.5"
+"StreetName": "Saint Clair"
+"StreetNumber": "33"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "4562.7"
+"VirtualTourURLUnbranded": "https://media.otbxair.com/33-St-Clair-Ave"
+"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"
+"TaxYear": 2026
+"CityRegion": "Gibson"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29922111/33-saint-clair-avenue-hamilton-gibson-gibson"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1a"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 29.0
+"OriginalEntryTimestamp": "2026-06-18T16:05:42.46Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1266299"
+"ListOfficeNationalAssociationId": "1384630"
+"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('29922111')"
+"ID": "1542891"
}
]
+success: true
+page_size: 9
+page_count: 60
+count: 540
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]