Bright and self-contained studio ADU available in Hamilton – perfect for a single professional or student seeking comfort, convenience, and value. This thoughtfully designed unit features a full bathroom, a functional kitchen with ample cabinetry, and an open-concept living/sleeping space that’s easy to personalize. Enjoy the added benefit of one dedicated parking spot and the simplicity of ALL UTILITIES INCLUDED
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:6 [ "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29647258 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449 +post_id: "1348520" +post_author: 1 +"ListingKey": "29647258" +"ListingId": "X13035784" +"PropertyType": "Residential Income" +"PropertySubType": "Multi-family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-18T00:50:21Z" +"RFModificationTimestamp": "2026-05-18T00:51:03Z" +"ListPrice": 0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton (McQuesten)" +"PostalCode": "L8H2L8" +"UnparsedAddress": "477 MELVIN AVENUE, Hamilton (McQuesten), Ontario L8H2L8" +"Coordinates": array:2 [ 0 => -79.7767013 1 => 43.2408007 ] +"Latitude": 43.2408007 +"Longitude": -79.7767013 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Toronto Regional Real Estate Board" +"PublicRemarks": "Bright and self-contained studio ADU available in Hamilton - perfect for a single professional or student seeking comfort, convenience, and value. This thoughtfully designed unit features a full bathroom, a functional kitchen with ample cabinetry, and an open-concept living/sleeping space that's easy to personalize. Enjoy the added benefit of one dedicated parking spot and the simplicity of ALL UTILITIES INCLUDED IN THE RENT, making budgeting straightforward and stress-free.Located in Hamilton's east end, the home offers quick access to everyday essentials and great connectivity. You're just minutes from parks, local shops, and dining options along Barton Street, with easy access to public transit and major routes like the Red Hill Valley Parkway. Nature lovers will appreciate nearby green spaces and trails, while commuters benefit from a convenient drive to downtown Hamilton or the QEW. (id:62783)" +"Appliances": array:2 [ 0 => "Water meter" 1 => "Water Heater" ] +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2026-04-23T19:10:29.073606+00:00" +"Directions": "Woodward Ave & Barton St E" +"ExteriorFeatures": array:2 [ 0 => "Brick" 1 => "Stucco" ] +"Heating": array:2 [ 0 => "Baseboard heaters" 1 => "Other" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2185068" +"ListOfficeKey": "293109" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Carpet Free" ] +"LotSizeDimensions": "70 x 100 FT" +"ParkingFeatures": array:1 [ 0 => "No Garage" ] +"PhotosChangeTimestamp": "2026-04-23T16:57:07Z" +"PhotosCount": 10 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Sanitary sewer" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-05-18T00:44:20Z" +"Stories": "1.5" +"StreetName": "Melvin" +"StreetNumber": "477" +"StreetSuffix": "Avenue" +"Utilities": array:2 [ 0 => "Sewer" 1 => "Electricity" ] +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Toronto" +"CityRegion": "McQuesten" +"ListAORKey": "82" +"ListingURL": "www.realtor.ca/real-estate/29647258/477-melvin-avenue-hamilton-mcquesten-mcquesten" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Duplex" ] +"CoListAgentKey": "2134092" +"CoListOfficeKey": "293109" +"GeocodeManualYN": false +"TotalActualRent": 1299 +"BuildingFeatures": array:1 [ 0 => "Separate Heating Controls" ] +"LivingAreaMaximum": 2500 +"LivingAreaMinimum": 2000 +"BedroomsAboveGrade": 0 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 70.0 +"OriginalEntryTimestamp": "2026-04-23T16:57:07.34Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1434776" +"ListOfficeNationalAssociationId": "1422605" +"CoListAgentNationalAssociationId": "1386484" +"CoListOfficeNationalAssociationId": "1422605" +"Media": array:10 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "6621794186" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/beadd716be0d153977820475c5dfb1b6.webp" "MediaSize" => 118118 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-beadd716be0d153977820475c5dfb1b6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Front" "PreferredPhotoYN" => true "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "6621794218" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/f938f96ab9359212832986a27a222c2b.webp" "MediaSize" => 141662 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-f938f96ab9359212832986a27a222c2b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Entrance" "PreferredPhotoYN" => false "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "6621794345" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/26e8457f659ceed87bf16d4b2f8fa8ea.webp" "MediaSize" => 83950 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-26e8457f659ceed87bf16d4b2f8fa8ea.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen" "PreferredPhotoYN" => false "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "6621794424" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/8e315642b88b513dd48095a2e1e0791e.webp" "MediaSize" => 57742 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-8e315642b88b513dd48095a2e1e0791e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Studio" "PreferredPhotoYN" => false "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "6621794521" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/4c65c9eacb202a856a6ef41b94a98248.webp" "MediaSize" => 52614 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-4c65c9eacb202a856a6ef41b94a98248.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Studio" "PreferredPhotoYN" => false "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "6621794637" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/0d89540597ef8f3748fd55f85efa5014.webp" "MediaSize" => 51593 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-0d89540597ef8f3748fd55f85efa5014.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Studio" "PreferredPhotoYN" => false "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "6621794747" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/91962aaee0dad91478d1f240ea46adef.webp" "MediaSize" => 61198 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-91962aaee0dad91478d1f240ea46adef.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Studio" "PreferredPhotoYN" => false "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "6621794810" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/d96118197cb2897c38f5f7f5025cd587.webp" "MediaSize" => 72212 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-d96118197cb2897c38f5f7f5025cd587.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen" "PreferredPhotoYN" => false "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "6621794865" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/7cb4bfc073f687a34bb55f4957b82f88.webp" "MediaSize" => 68080 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-7cb4bfc073f687a34bb55f4957b82f88.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Washroom" "PreferredPhotoYN" => false "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "6621795002" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29647258/87cd990313c3bfa721eb0d20f1ed108b.webp" "MediaSize" => 74215 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29647258/thumbnail-87cd990313c3bfa721eb0d20f1ed108b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Washroom" "PreferredPhotoYN" => false "ResourceRecordId" => "X13035784" "ResourceRecordKey" => "29647258" "ModificationTimestamp" => "2026-04-23T16:57:07.35Z" ] ] +"DaysOnMarket": 76 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29647258')" +"ID": "1348520" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.27 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293109" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24901 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24845 +post_id: ? mixed +post_author: ? mixed +"OfficeName": "CENTURY 21 PROPERTY ZONE REALTY INC." +"OfficeEmail": null +"OfficePhone": "647-910-9999" +"OfficeMlsId": "420400" +"ModificationTimestamp": "2026-02-17T23:14:29Z" +"OriginatingSystemName": "CREA" +"OfficeKey": "293109" +"IDXOfficeParticipationYN": null +"MainOfficeKey": null +"MainOfficeMlsId": null +"OfficeAddress1": "8975 MCCLAUGHLIN RD #6" +"OfficeAddress2": null +"OfficeBrokerKey": null +"OfficeCity": "BRAMPTON" +"OfficePostalCode": "L6Y0Z" +"OfficePostalCodePlus4": null +"OfficeStateOrProvince": "Ontario" +"OfficeStatus": "Active" +"OfficeAOR": "Toronto" +"OfficeType": "Firm" +"OfficePhoneExt": null +"OfficeNationalAssociationId": "1422605" +"OriginalEntryTimestamp": "2022-08-05T17:43:00Z" +"OfficeAORKey": "82" +"OfficeCountry": "Canada" +"FranchiseNationalAssociationId": "1205554" +"OfficeBrokerNationalAssociationId": "1344911" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('293109')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2185068" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24855 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29647258'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25171 +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 '29647258' AND OpenHouseDate ge '2026-07-08'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25187 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29647258' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential+Income' AND geo.distance(Coordinates, POINT(-79.7767013 43.2408007)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25234 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] ]