3764 Properties
Sort by:
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:1 [ "RF Cache Key: 5c69d110720ca8a39252abc063d1bcb5306c4bb7d9ba3382ed3dd98976ceabf8" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#13012 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13156 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11945610" +"ListingId": "X11945610" +"PropertyType": "Commercial Sale" +"PropertySubType": "Store W Apt/Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T20:56:11Z" +"RFModificationTimestamp": "2025-04-30T21:51:37.236762+00:00" +"ListPrice": 2100000.0 +"BathroomsTotalInteger": 7.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5079.0 +"City": "Hamilton" +"PostalCode": "L8N 2C6" +"UnparsedAddress": "174 John Street, Hamilton, On L8n 2c6" +"Coordinates": array:2 [ 0 => -79.9602802 1 => 43.2665814 ] +"Latitude": 43.2665814 +"Longitude": -79.9602802 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE WEST REALTY GROUP LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rare opportunity to own a prime mixed-use property in the heart of Hamilton, just a 2-minute walk to the GO station, schools, commercial towers, and a thriving residential community. This newly refurbished, four-story (C5-zoned) building offers a lot size of 34.55 ft x 66.00 ft, a total area of 4,582 sq. ft., and includes four residential units and one commercial unit. With a gross income of $170,856, a net operating income (NOI) of over $155,000, and operating expenses under $12,000 per year, this is an exceptional investment opportunity. One unit is currently vacant and available for the buyers use. Flexible ownership options allow you to purchase with the business or simply become a landlord, as one of the sellers is willing to continue operations. **EXTRAS** 2 water heaters, 1 commercial and 1 residential - both rented at $40.00 per month. Fire inspection done in 2024. Clean environmental 2024, Flat roof area done in 2023." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Corktown" +"CommunityFeatures": array:2 [ 0 => "Public Transit" 1 => "Recreation/Community Centre" ] +"Cooling": array:1 [ 0 => "No" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-04-18T12:58:22.525111+00:00" +"CrossStreet": "John St S / Augusta" +"Exclusions": "All items owned by the tenants" +"ExpirationDate": "2025-07-31" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"Inclusions": "All existing appliances and chattels owned by the landlord but having to do with the business." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-29" +"MainOfficeKey": "597500" +"MajorChangeTimestamp": "2025-01-29T17:30:23Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-29T17:30:23Z" +"OriginalListPrice": 2100000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1910000" +"ParcelNumber": "171730014" +"PhotosChangeTimestamp": "2025-01-30T16:56:19Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "S" +"StreetName": "John" +"StreetNumber": "174" +"StreetSuffix": "Street" +"TaxAnnualAmount": "12117.17" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "C5" +"Amps": 400 +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"LotType": "Lot" +"TaxType": "Annual" +"HeatType": "Baseboard" +"LotDepth": 34.62 +"LotWidth": 66.13 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11945610')" +"GarageType": "None" +"RetailArea": 2064.0 +"RollNumber": "251802014201720" +"PropertyUse": "Store With Apt/Office" +"RentalItems": "2 HWT's - $80.00 / month total" +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8N 2C6, CA" +"ContractStatus": "Available" +"FreestandingYN": true +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"WashroomsType1": 7 +"PossessionDetails": "FLEX" +"OfficeApartmentArea": 3015.0 +"MediaChangeTimestamp": "2025-01-30T16:56:19Z" +"OfficeApartmentAreaUnit": "Sq Ft" +"SystemModificationTimestamp": "2025-02-14T20:56:11.549653Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:15 [ 0 => array:26 [ "Order" => 0 "ImageOf" => null "MediaKey" => "aeb356fa-2da0-4c79-9a6f-a0cdde4c4694" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/44eb21770eeb794ad1618080887ccde7.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 746709 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-44eb21770eeb794ad1618080887ccde7.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "aeb356fa-2da0-4c79-9a6f-a0cdde4c4694" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => true "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "aeb356fa-2da0-4c79-9a6f-a0cdde4c4694" "ModificationTimestamp" => "2025-01-30T16:55:57.281839Z" "MediaModificationTimestamp" => "2025-01-30T16:55:57.281839Z" ] 1 => array:26 [ "Order" => 1 "ImageOf" => null "MediaKey" => "15c51a36-66a9-4e10-a037-dc9a958b29a2" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/00cd82d4601810b4533cd4315e6a68a9.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 796471 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-00cd82d4601810b4533cd4315e6a68a9.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "15c51a36-66a9-4e10-a037-dc9a958b29a2" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "15c51a36-66a9-4e10-a037-dc9a958b29a2" "ModificationTimestamp" => "2025-01-30T16:55:58.559393Z" "MediaModificationTimestamp" => "2025-01-30T16:55:58.559393Z" ] 2 => array:26 [ "Order" => 2 "ImageOf" => null "MediaKey" => "af2f6b68-0cd9-4272-8222-d754b6f6f002" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/22fd77868a5c68dc8a6b33f725463b45.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 775976 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-22fd77868a5c68dc8a6b33f725463b45.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "af2f6b68-0cd9-4272-8222-d754b6f6f002" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "af2f6b68-0cd9-4272-8222-d754b6f6f002" "ModificationTimestamp" => "2025-01-30T16:56:00.452443Z" "MediaModificationTimestamp" => "2025-01-30T16:56:00.452443Z" ] 3 => array:26 [ "Order" => 3 "ImageOf" => null "MediaKey" => "87d4758b-e162-4a09-b23c-c3d3f7e00f06" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/75df8934b4d9b185fd3ffd8331cbc304.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 704403 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-75df8934b4d9b185fd3ffd8331cbc304.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "87d4758b-e162-4a09-b23c-c3d3f7e00f06" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "87d4758b-e162-4a09-b23c-c3d3f7e00f06" "ModificationTimestamp" => "2025-01-30T16:56:01.969552Z" "MediaModificationTimestamp" => "2025-01-30T16:56:01.969552Z" ] 4 => array:26 [ "Order" => 4 "ImageOf" => null "MediaKey" => "44c07193-7f0f-4a31-bb1b-c5f381fdca42" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/3f0ca5176648eef535207db3b04605d9.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 656345 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-3f0ca5176648eef535207db3b04605d9.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "44c07193-7f0f-4a31-bb1b-c5f381fdca42" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "44c07193-7f0f-4a31-bb1b-c5f381fdca42" "ModificationTimestamp" => "2025-01-30T16:56:04.173639Z" "MediaModificationTimestamp" => "2025-01-30T16:56:04.173639Z" ] 5 => array:26 [ "Order" => 5 "ImageOf" => null "MediaKey" => "a0479016-30fa-4152-a6a1-9b2affc21fc2" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/8336f753665b7d8a4b975a6c1afbba74.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 522244 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-8336f753665b7d8a4b975a6c1afbba74.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "a0479016-30fa-4152-a6a1-9b2affc21fc2" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "a0479016-30fa-4152-a6a1-9b2affc21fc2" "ModificationTimestamp" => "2025-01-30T16:56:06.1152Z" "MediaModificationTimestamp" => "2025-01-30T16:56:06.1152Z" ] 6 => array:26 [ "Order" => 6 "ImageOf" => null "MediaKey" => "1c92c0ac-4ad9-4666-91f4-7bc240ffbd46" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/4b2b86e8f0a60bd6e5d56d96fca4f1de.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 471829 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-4b2b86e8f0a60bd6e5d56d96fca4f1de.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "1c92c0ac-4ad9-4666-91f4-7bc240ffbd46" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "1c92c0ac-4ad9-4666-91f4-7bc240ffbd46" "ModificationTimestamp" => "2025-01-30T16:56:08.351069Z" "MediaModificationTimestamp" => "2025-01-30T16:56:08.351069Z" ] 7 => array:26 [ "Order" => 7 "ImageOf" => null "MediaKey" => "8936243d-67da-4690-ae4c-7da734fc30e4" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/80ef79a1815fec22abee09dcec2a6938.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 410300 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-80ef79a1815fec22abee09dcec2a6938.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "8936243d-67da-4690-ae4c-7da734fc30e4" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "8936243d-67da-4690-ae4c-7da734fc30e4" "ModificationTimestamp" => "2025-01-30T16:56:09.862454Z" "MediaModificationTimestamp" => "2025-01-30T16:56:09.862454Z" ] 8 => array:26 [ "Order" => 8 "ImageOf" => null "MediaKey" => "975c514d-d202-4480-a34f-83a59f495d6a" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/eb028fd17662e8adbd7e2615a548446f.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 394936 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-eb028fd17662e8adbd7e2615a548446f.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "975c514d-d202-4480-a34f-83a59f495d6a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "975c514d-d202-4480-a34f-83a59f495d6a" "ModificationTimestamp" => "2025-01-30T16:56:11.170441Z" "MediaModificationTimestamp" => "2025-01-30T16:56:11.170441Z" ] 9 => array:26 [ "Order" => 9 "ImageOf" => null "MediaKey" => "0c0b2201-c160-462d-9ac4-d581bfe291a2" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/c3de88c116bf5a161163a34933be3ad3.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 367223 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-c3de88c116bf5a161163a34933be3ad3.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "0c0b2201-c160-462d-9ac4-d581bfe291a2" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "0c0b2201-c160-462d-9ac4-d581bfe291a2" "ModificationTimestamp" => "2025-01-30T16:56:12.613069Z" "MediaModificationTimestamp" => "2025-01-30T16:56:12.613069Z" ] 10 => array:26 [ "Order" => 10 "ImageOf" => null "MediaKey" => "27a7d0c8-08a9-4f91-a711-0f655ba6b9dc" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/78d1c1b40cbd4e3ad86ded489de8bab6.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 431810 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-78d1c1b40cbd4e3ad86ded489de8bab6.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "27a7d0c8-08a9-4f91-a711-0f655ba6b9dc" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "27a7d0c8-08a9-4f91-a711-0f655ba6b9dc" "ModificationTimestamp" => "2025-01-30T16:56:13.713841Z" "MediaModificationTimestamp" => "2025-01-30T16:56:13.713841Z" ] 11 => array:26 [ "Order" => 11 "ImageOf" => null "MediaKey" => "3847d543-8698-4f2e-ac68-d5c6abc83a6b" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/03d5578ce6b9c622e1aed68aa5e7497a.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 283963 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-03d5578ce6b9c622e1aed68aa5e7497a.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1364 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "3847d543-8698-4f2e-ac68-d5c6abc83a6b" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "3847d543-8698-4f2e-ac68-d5c6abc83a6b" "ModificationTimestamp" => "2025-01-30T16:56:15.243754Z" "MediaModificationTimestamp" => "2025-01-30T16:56:15.243754Z" ] 12 => array:26 [ "Order" => 12 "ImageOf" => null "MediaKey" => "4c0ff538-298c-40fe-b4cc-eb246848b7d7" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/5240b5996fd312b64c25e598c1e400d8.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 242684 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-5240b5996fd312b64c25e598c1e400d8.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1364 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "4c0ff538-298c-40fe-b4cc-eb246848b7d7" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "4c0ff538-298c-40fe-b4cc-eb246848b7d7" "ModificationTimestamp" => "2025-01-30T16:56:16.484588Z" "MediaModificationTimestamp" => "2025-01-30T16:56:16.484588Z" ] 13 => array:26 [ "Order" => 13 "ImageOf" => null "MediaKey" => "da761170-2a9d-4905-ae6c-108220ce1259" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/ad39377286ee7b039480d332925620da.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 252300 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-ad39377286ee7b039480d332925620da.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "da761170-2a9d-4905-ae6c-108220ce1259" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "da761170-2a9d-4905-ae6c-108220ce1259" "ModificationTimestamp" => "2025-01-30T16:56:17.419959Z" "MediaModificationTimestamp" => "2025-01-30T16:56:17.419959Z" ] 14 => array:26 [ "Order" => 14 "ImageOf" => null "MediaKey" => "dc688b8e-74a6-4f59-91ec-0f3ebb7941e9" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/1032fc31d147a7da0bba0fa1921cc181.webp" "ClassName" => "Commercial" "MediaHTML" => null "MediaSize" => 549856 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11945610/thumbnail-1032fc31d147a7da0bba0fa1921cc181.webp" "ImageWidth" => 2048 "Permission" => array:1 [ …1] "ImageHeight" => 1365 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "dc688b8e-74a6-4f59-91ec-0f3ebb7941e9" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11945610" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "dc688b8e-74a6-4f59-91ec-0f3ebb7941e9" "ModificationTimestamp" => "2025-01-30T16:56:18.844821Z" "MediaModificationTimestamp" => "2025-01-30T16:56:18.844821Z" ] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13157 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11940542" +"ListingId": "X11940542" +"PropertyType": "Residential Lease" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T20:24:52Z" +"RFModificationTimestamp": "2025-03-30T11:11:28.980598+00:00" +"ListPrice": 9700.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9H 5E3" +"UnparsedAddress": "774 Old Dundas Road, Hamilton, On L9h 5e3" +"Coordinates": array:2 [ 0 => -79.9693095 1 => 43.2419983 ] +"Latitude": 43.2419983 +"Longitude": -79.9693095 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RIGHT AT HOME REALTY, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover a magnificent architectural masterpiece nestled on a private and tranquil two-acre property a true paradise for those seeking the extraordinary. This exceptional residence boasts over 7,700 sq.ft of meticulously crafted living space, with show-stopping indoor heated pool that will leave you in awe. As you step inside, you're greeted by soaring 23 ft cathedral ceilings on the main level, creating a sense of grandeur and space. The open-concept design seamlessly connects the living room and family room to the indoor pool and hot tub area, offering an unparalleled blend of luxury and relaxation. A modern and spacious Scandinavian kitchen provides a perfect setting for family meals, with panoramic views of the surrounding nature. The lower level is an entertainer's dream, complete with direct access to the pool, wet bar, and a walkout to the backyard. The sprawling two-acre property spans across Old Dundas Rd and connects to Lower Lions Club Rd, offering additional parking for your RV and boat. A three-car garage and a generous driveway cater to all your storage needs. **EXTRAS** Tenant agrees to look after the property grounds and keep/pay an existing agreement with the pool maintenance company. Tenants agrees to maintained during the term of the lease an additional liability insurance coverage for the indoor pool." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:1 [ 0 => "Finished with Walk-Out" ] +"CityRegion": "Rural Ancaster" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "3.0" +"CreationDate": "2025-01-26T19:30:10.719196+00:00" +"CrossStreet": "Hwy 403/ Wilson Rd" +"DirectionFaces": "West" +"ExpirationDate": "2025-05-30" +"FireplaceFeatures": array:1 [ 0 => "Propane" ] +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Furnished": "Unfurnished" +"Inclusions": "Existing appliances, window coverings and light fixtures." +"InteriorFeatures": array:4 [ 0 => "Auto Garage Door Remote" 1 => "Central Vacuum" 2 => "In-Law Capability" 3 => "Propane Tank" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Inside" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-25" +"MainOfficeKey": "062200" +"MajorChangeTimestamp": "2025-01-25T14:37:18Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-25T14:37:18Z" +"OriginalListPrice": 9700.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1900276" +"ParcelNumber": "174540247" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "13.0" +"PhotosChangeTimestamp": "2025-01-25T14:37:18Z" +"PoolFeatures": array:1 [ 0 => "Indoor" ] +"RentIncludes": array:1 [ 0 => "Parking" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Old Dundas" +"StreetNumber": "774" +"StreetSuffix": "Road" +"TransactionBrokerCompensation": "Half month rent" +"TransactionType": "For Lease" +"VirtualTourURLUnbranded": "https://view.tours4listings.com/cp/774-old-dundas-road-hamilton/" +"DDFYN": true +"Water": "Other" +"HeatType": "Forced Air" +"LotDepth": 375.0 +"LotShape": "Irregular" +"LotWidth": 562.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11940542')" +"GarageType": "Attached" +"HeatSource": "Ground Source" +"RollNumber": "251814013019600" +"BuyOptionYN": true +"HoldoverDays": 90 +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 10 +"provider_name": "TRREB" +"ContractStatus": "Available" +"PossessionDate": "2025-03-25" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 2 +"WashroomsType4": 1 +"CentralVacuumYN": true +"DenFamilyroomYN": true +"DepositRequired": true +"RoomsAboveGrade": 10 +"RoomsBelowGrade": 1 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"LotSizeRangeAcres": "2-4.99" +"PossessionDetails": "Flexible" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 4 +"WashroomsType4Pcs": 3 +"BedroomsAboveGrade": 5 +"BedroomsBelowGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Second" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Basement" +"MediaChangeTimestamp": "2025-01-25T14:37:18Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-02-14T20:24:52.410471Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:34 [ 0 => array:26 [ "Order" => 0 "ImageOf" => null "MediaKey" => "4f5c81cf-194c-4cbf-963f-ff628fe750a5" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/ec9764f7a68feea27edc799fb9de2877.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 804493 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-ec9764f7a68feea27edc799fb9de2877.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "4f5c81cf-194c-4cbf-963f-ff628fe750a5" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => true "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "4f5c81cf-194c-4cbf-963f-ff628fe750a5" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 1 => array:26 [ "Order" => 1 "ImageOf" => null "MediaKey" => "08f2331d-55f6-4330-a21e-fc058a6fd1a4" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/1ec9a338884c9622633495952cd7755a.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 976173 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-1ec9a338884c9622633495952cd7755a.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "08f2331d-55f6-4330-a21e-fc058a6fd1a4" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "08f2331d-55f6-4330-a21e-fc058a6fd1a4" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 2 => array:26 [ "Order" => 2 "ImageOf" => null "MediaKey" => "99e98ad9-764b-445d-9906-790f220c3f25" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/6ae5265cf272455ac64beed74e5dcfb8.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 555345 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-6ae5265cf272455ac64beed74e5dcfb8.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "99e98ad9-764b-445d-9906-790f220c3f25" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "99e98ad9-764b-445d-9906-790f220c3f25" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 3 => array:26 [ "Order" => 3 "ImageOf" => null "MediaKey" => "270723fc-de11-4ebe-a8d4-a7fb389f8799" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/7a7ce5e7bf6db944b05e60ee42ed76af.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 318554 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-7a7ce5e7bf6db944b05e60ee42ed76af.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "270723fc-de11-4ebe-a8d4-a7fb389f8799" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "270723fc-de11-4ebe-a8d4-a7fb389f8799" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 4 => array:26 [ "Order" => 4 "ImageOf" => null "MediaKey" => "1a7fc7a2-b2c4-4399-ad71-a7775e8ef891" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/78db2e821b839831d090cb7a47ce5af9.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 396988 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-78db2e821b839831d090cb7a47ce5af9.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "1a7fc7a2-b2c4-4399-ad71-a7775e8ef891" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "1a7fc7a2-b2c4-4399-ad71-a7775e8ef891" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 5 => array:26 [ "Order" => 5 "ImageOf" => null "MediaKey" => "d6ae10c2-d356-410c-a573-c488f465e989" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/05f2e37d5e33a71d4486a39a37cf643b.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 388926 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-05f2e37d5e33a71d4486a39a37cf643b.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "d6ae10c2-d356-410c-a573-c488f465e989" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "d6ae10c2-d356-410c-a573-c488f465e989" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 6 => array:26 [ "Order" => 6 "ImageOf" => null "MediaKey" => "60e91684-e48e-4c91-8b81-e5addcff5da4" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/35bc6e350ffcb30a7ca5b28d0fdc1866.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 370823 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-35bc6e350ffcb30a7ca5b28d0fdc1866.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "60e91684-e48e-4c91-8b81-e5addcff5da4" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "60e91684-e48e-4c91-8b81-e5addcff5da4" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 7 => array:26 [ "Order" => 7 "ImageOf" => null "MediaKey" => "6e8d55f9-5a98-4009-b4e5-b250824a4b8d" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/dd1fa20fde19595cdd24c8f5a2c72523.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 312904 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-dd1fa20fde19595cdd24c8f5a2c72523.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "6e8d55f9-5a98-4009-b4e5-b250824a4b8d" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "6e8d55f9-5a98-4009-b4e5-b250824a4b8d" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 8 => array:26 [ "Order" => 8 "ImageOf" => null "MediaKey" => "aa5310ae-3863-4a51-bf40-8aaa253c892a" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/0f640172dff0a4bcb3ac6bfe81921c99.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 365635 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-0f640172dff0a4bcb3ac6bfe81921c99.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "aa5310ae-3863-4a51-bf40-8aaa253c892a" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "aa5310ae-3863-4a51-bf40-8aaa253c892a" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 9 => array:26 [ "Order" => 9 "ImageOf" => null "MediaKey" => "fd6097fd-e9f8-45c9-9af3-2f15843c00cf" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/5cd9ff126160577274e96174fed3b45e.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 327618 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-5cd9ff126160577274e96174fed3b45e.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "fd6097fd-e9f8-45c9-9af3-2f15843c00cf" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "fd6097fd-e9f8-45c9-9af3-2f15843c00cf" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 10 => array:26 [ "Order" => 10 "ImageOf" => null "MediaKey" => "f5201206-a8a7-4910-abf2-848c9366f7cc" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/94dded4e03b18fae587b1eee8ff50d3d.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 348348 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-94dded4e03b18fae587b1eee8ff50d3d.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "f5201206-a8a7-4910-abf2-848c9366f7cc" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "f5201206-a8a7-4910-abf2-848c9366f7cc" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 11 => array:26 [ "Order" => 11 "ImageOf" => null "MediaKey" => "13ba0c53-6b2c-4a2a-9259-8a9e33b85f73" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/24eac6b5635de3e7a07f4fb69c3d5472.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 468866 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-24eac6b5635de3e7a07f4fb69c3d5472.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "13ba0c53-6b2c-4a2a-9259-8a9e33b85f73" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "13ba0c53-6b2c-4a2a-9259-8a9e33b85f73" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 12 => array:26 [ "Order" => 12 "ImageOf" => null "MediaKey" => "63c07f51-7ffa-48de-b5b6-0f29447008b5" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/5ef414bae4900fbe6d5e27607ec85ac5.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 478113 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-5ef414bae4900fbe6d5e27607ec85ac5.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "63c07f51-7ffa-48de-b5b6-0f29447008b5" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "63c07f51-7ffa-48de-b5b6-0f29447008b5" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 13 => array:26 [ "Order" => 13 "ImageOf" => null "MediaKey" => "e313994e-7558-457b-ad22-8d0fbd0e1dd3" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/f33742eee6ed000fb80c17519b4c9827.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 335942 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-f33742eee6ed000fb80c17519b4c9827.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "e313994e-7558-457b-ad22-8d0fbd0e1dd3" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "e313994e-7558-457b-ad22-8d0fbd0e1dd3" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 14 => array:26 [ "Order" => 14 "ImageOf" => null "MediaKey" => "32032503-7c36-44b7-8d0c-1d51751c14f6" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/d588a2552ec634b411999f3297deac4e.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 351012 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-d588a2552ec634b411999f3297deac4e.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "32032503-7c36-44b7-8d0c-1d51751c14f6" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "32032503-7c36-44b7-8d0c-1d51751c14f6" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 15 => array:26 [ "Order" => 15 "ImageOf" => null "MediaKey" => "e883f68e-b54b-4649-98f7-d183ddd77059" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/eaf27a8b996f2f7cb9f33360caed4193.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 263006 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-eaf27a8b996f2f7cb9f33360caed4193.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "e883f68e-b54b-4649-98f7-d183ddd77059" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "e883f68e-b54b-4649-98f7-d183ddd77059" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 16 => array:26 [ "Order" => 16 "ImageOf" => null "MediaKey" => "40c8d0de-bc29-4a5a-be75-3318d1624085" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/bb3d81dc0f8e584bac7515547ff1fbab.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 196119 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-bb3d81dc0f8e584bac7515547ff1fbab.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "40c8d0de-bc29-4a5a-be75-3318d1624085" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "40c8d0de-bc29-4a5a-be75-3318d1624085" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 17 => array:26 [ "Order" => 17 "ImageOf" => null "MediaKey" => "3f5b6d58-ef7f-49a3-aa97-d5aee1f007fc" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/42530b2fdedf7ad776c1a8031f551733.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 364430 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-42530b2fdedf7ad776c1a8031f551733.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "3f5b6d58-ef7f-49a3-aa97-d5aee1f007fc" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "3f5b6d58-ef7f-49a3-aa97-d5aee1f007fc" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 18 => array:26 [ "Order" => 18 "ImageOf" => null "MediaKey" => "3e49de0e-c038-449b-b4a8-740b578d2e9c" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/ef1653b8288cc25b2a4b36f062ca8119.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 310793 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-ef1653b8288cc25b2a4b36f062ca8119.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "3e49de0e-c038-449b-b4a8-740b578d2e9c" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "3e49de0e-c038-449b-b4a8-740b578d2e9c" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 19 => array:26 [ "Order" => 19 "ImageOf" => null "MediaKey" => "b868678d-d1f5-487c-a767-8e1bf72f4855" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/f9de4b3c19496e8f894b6bb6fa67d7c0.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 380448 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-f9de4b3c19496e8f894b6bb6fa67d7c0.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "b868678d-d1f5-487c-a767-8e1bf72f4855" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "b868678d-d1f5-487c-a767-8e1bf72f4855" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 20 => array:26 [ "Order" => 20 "ImageOf" => null "MediaKey" => "55da0e55-068c-4a7a-9959-a5f9ed42d687" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/d1af6f6c173a65d91d6af050548a7132.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 272600 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-d1af6f6c173a65d91d6af050548a7132.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "55da0e55-068c-4a7a-9959-a5f9ed42d687" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "55da0e55-068c-4a7a-9959-a5f9ed42d687" "ModificationTimestamp" => "2025-01-25T14:37:18.697605Z" "MediaModificationTimestamp" => "2025-01-25T14:37:18.697605Z" ] 21 => array:26 [ "Order" => 21 "ImageOf" => null "MediaKey" => "8d24cbdc-03ec-40db-8a45-4604dd81632e" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/72e56ad9790760c3557cecc996c5fcad.webp" "ClassName" => "ResidentialFree" "MediaHTML" => null "MediaSize" => 356927 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/48/X11940542/thumbnail-72e56ad9790760c3557cecc996c5fcad.webp" "ImageWidth" => 1900 "Permission" => array:1 [ …1] "ImageHeight" => 1425 "MediaStatus" => "Active" "ResourceName" => "Property" "MediaCategory" => "Photo" "MediaObjectID" => "8d24cbdc-03ec-40db-8a45-4604dd81632e" "SourceSystemID" => "A00001796" "LongDescription" => null "PreferredPhotoYN" => false "ShortDescription" => null "SourceSystemName" => "Toronto Regional Real Estate Board" "ResourceRecordKey" => "X11940542" "ImageSizeDescription" => "Largest" "SourceSystemMediaKey" => "8d24cbdc-03ec-40db-8a45-4604dd81632e" …2 ] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13163 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11940157" +"ListingId": "X11940157" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T20:22:21Z" +"RFModificationTimestamp": "2025-04-26T06:52:11.581076+00:00" +"ListPrice": 198800.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1000.0 +"City": "Hamilton" +"PostalCode": "L0R 2H0" +"UnparsedAddress": "40 Main Street, Hamilton, On L0r 2h0" +"Coordinates": array:2 [ 0 => -79.9532324 1 => 43.2648396 ] +"Latitude": 43.2648396 +"Longitude": -79.9532324 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX FIND PROPERTIES" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Be Your own Boss-This is a unique opportunity to own a state-of-the-art, legally licensed cannabis retail store in the heart of Waterdown. Situated at the high-traffic intersection of Main and Dundas, this business benefits from excellent exposure, daily foot and vehicle traffic, and a strong reputation for 5-star customer service. Established in December 2021, this turnkey operation has a stabilized income and growing sales, with financial statements available for review. The attractive lease includes 5 years remaining with one 5-year renewal terms, and renovated 1000 sq. ft. space features luxurious finishes like engineered wood floors, custom built-in cabinets with LED pot lights, and a vinyl-wrapped interior. A fully approved security system, including cameras, motion detectors, reinforced security gates, and electronic locks, ensures peace of mind. The well-designed layout includes a delivery and staff entrance, secured storage, bathroom, breakroom, and a spacious managers office. With sales exceeding the Ontario average and consistent monthly growth, this is an exceptional chance to acquire a thriving cannabis retail business in a prime location. **EXTRAS** Monthly Rent $3513 Plus Hst-Annual Sales $506,000 (2023) $525,000 (2024) Open Daily 10-am-10p.m. Purchase Price plus Inventory" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Other" ] +"CityRegion": "Waterdown" +"CoListOfficeName": "RE/MAX FIND PROPERTIES" +"CoListOfficePhone": "416-920-2621" +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-25T08:13:55.009755+00:00" +"CrossStreet": "Main and Dundas" +"ExpirationDate": "2025-08-30" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"HoursDaysOfOperationDescription": "12hrs" +"Inclusions": "All leasehold Improvement-See attached list of inclusions" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-24" +"MainOfficeKey": "301400" +"MajorChangeTimestamp": "2025-01-24T22:01:59Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 4 +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-24T22:02:00Z" +"OriginalListPrice": 198800.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1892042" +"PhotosChangeTimestamp": "2025-01-24T22:02:00Z" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"ShowingRequirements": array:2 [ 0 => "See Brokerage Remarks" 1 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "Main" +"StreetNumber": "40" +"StreetSuffix": "Street" +"TaxYear": "2024" +"TransactionBrokerCompensation": "$10,000 plus HSt" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Available" ] +"Zoning": "commercial" +"DDFYN": true +"Water": "Municipal" +"LotType": "Building" +"TaxType": "N/A" +"Expenses": "Actual" +"HeatType": "Gas Forced Air Open" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11940157')" +"ChattelsYN": true +"GarageType": "None" +"RetailArea": 1000.0 +"PropertyUse": "Without Property" +"RentalItems": "Alarm System-" +"GrossRevenue": 525000.0 +"HoldoverDays": 90 +"ListPriceUnit": "For Sale" +"ParkingSpaces": 4 +"provider_name": "TRREB" +"ContractStatus": "Available" +"FreestandingYN": true +"HSTApplication": array:1 [ 0 => "Yes" ] +"PossessionDate": "2025-03-01" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"MediaChangeTimestamp": "2025-03-04T18:28:16Z" +"SystemModificationTimestamp": "2025-03-04T18:28:16.862873Z" +"EstimatedInventoryValueAtCost": 35000.0 +"FinancialStatementAvailableYN": true +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13160 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9300398" +"ListingId": "X9300398" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T20:10:34Z" +"RFModificationTimestamp": "2025-04-26T05:42:01.062071+00:00" +"ListPrice": 1699900.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N 2Z7" +"UnparsedAddress": "20 Wildan Drive, Hamilton, ON L8N 2Z7" +"Coordinates": array:2 [ 0 => -80.0277939 1 => 43.3979883 ] +"Latitude": 43.3979883 +"Longitude": -80.0277939 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE ROYAL CITY REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "In todays real estate market, buyers are demanding luxury without the premium price tag. 20 Wildan Drive in Flamborough, offers just that. Discover unparalleled quality in this exquisite, executive 1.5 storey, offering a blend of sophistication and comfort at an exceptional value. Ideally located 10 minutes from Guelph, 20 minutes from Hamilton and Burlington, commuter corridors are within easy reach. This home presents a perfect opportunity to enjoy flawless, high-end finishes, comfortable living space over 3 levels ideal for mutli-generational families, with all the modern conveniences, for less! Nestled in a prime .5 acre lot with triple-wide driveway and ample parking, this home offers 4 bedrooms, 4.5 baths, large, spacious living areas and entertaining spaces grounded by thoughtful and well-executed transitional design. Key features include; a main floor primary bedroom retreat with a sleek 5-piece spa ensuite and walkout to private elevated deck; spotless eat-in kitchen with stellar views; a lower level rec room with home theatre, wet bar, and studio space plus workshop; multiple walkouts to landscaped gardens and patios with fire pit and outdoor kitchen, plus exceptionally maintained mechanicals and upgrades that exceed all expectations. I'll let the pictures and video do the talking here, make your move today. Don't miss a golden opportunity to experience upscale living in a convenient location at an unbeatable value." +"ArchitecturalStyle": array:1 [ 0 => "1 1/2 Storey" ] +"Basement": array:1 [ 0 => "Finished with Walk-Out" ] +"CityRegion": "Freelton" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2024-09-25T09:20:02.458431+00:00" +"CrossStreet": "HWY 6 to Hunstman Gate to Wildan Drive" +"DirectionFaces": "West" +"Exclusions": "Chest freezer (laundry room), Lower level shelving and fridge, custom workbench, mounted red tool organizer, stained glass art, fixed artwork and airplane propeller, gun safe, 2 x industrial pendant lights (solarium)" +"ExpirationDate": "2024-12-31" +"ExteriorFeatures": array:4 [ 0 => "Deck" 1 => "Lawn Sprinkler System" 2 => "Patio" 3 => "Porch Enclosed" ] +"FireplaceFeatures": array:6 [ 0 => "Natural Gas" 1 => "Wood" 2 => "Living Room" 3 => "Electric" 4 => "Rec Room" 5 => "Other" ] +"FireplaceYN": true +"FireplacesTotal": "3" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"Inclusions": "Security camera with DVR, Paradigm speakers (home theatre/kitchen), patio sail/string lights, Gazebo upper deck, TV's (1 x lower level studio/ 2 x 2nd Floor BR), wardrobes in Primary BR, Built-in D/W (wet bar), Generator." +"InteriorFeatures": array:5 [ 0 => "Water Heater Owned" 1 => "Water Softener" 2 => "Sump Pump" 3 => "Storage" 4 => "Water Treatment" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-05" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "069900" +"MajorChangeTimestamp": "2024-12-04T21:21:57Z" +"MlsStatus": "Terminated" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-09-05T13:20:50Z" +"OriginalListPrice": 1739900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1460332" +"OtherStructures": array:2 [ 0 => "Garden Shed" 1 => "Greenhouse" ] +"ParcelNumber": "175240121" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "10.0" +"PhotosChangeTimestamp": "2024-09-05T13:20:50Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 1739900.0 +"PriceChangeTimestamp": "2024-11-22T13:39:48Z" +"Roof": array:2 [ 0 => "Asphalt Shingle" 1 => "Flat" ] +"SecurityFeatures": array:3 [ 0 => "Smoke Detector" 1 => "Carbon Monoxide Detectors" 2 => "Security System" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "See Brokerage Remarks" 2 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Wildan" +"StreetNumber": "20" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "7575.79" +"TaxAssessedValue": 701000 +"TaxLegalDescription": "LT 43, PL 1422; BLK G, PL1422; FLAMBOROUGH, CITY OF HAMILTON" +"TaxYear": "2024" +"Topography": array:2 [ 0 => "Level" 1 => "Sloping" ] +"TransactionBrokerCompensation": "2.0% plus HST" +"TransactionType": "For Sale" +"View": array:1 [ 0 => "Garden" ] +"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/20_wildan_dr_hamilton_on/" +"WaterSource": array:1 [ 0 => "Comm Well" ] +"Zoning": "S1" +"UFFI": "No" +"DDFYN": true +"Water": "Municipal" +"GasYNA": "Yes" +"CableYNA": "Yes" +"HeatType": "Forced Air" +"LotDepth": 200.0 +"LotShape": "Rectangular" +"LotWidth": 100.0 +"SewerYNA": "No" +"WaterYNA": "Yes" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9300398')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "251830393026800" +"ElectricYNA": "Yes" +"RentalItems": "None" +"HoldoverDays": 120 +"LaundryLevel": "Main Level" +"TelephoneYNA": "Yes" +"KitchensTotal": 1 +"ParkingSpaces": 8 +"provider_name": "TRREB" +"ApproximateAge": "31-50" +"AssessmentYear": 2024 +"ContractStatus": "Unavailable" +"HSTApplication": array:1 [ 0 => "Included" ] +"PossessionDate": "2024-10-15" +"PriorMlsStatus": "Price Change" +"WashroomsType1": 1 +"WashroomsType2": 1 +"WashroomsType3": 1 +"WashroomsType4": 1 +"WashroomsType5": 1 +"LivingAreaRange": "2500-3000" +"RoomsAboveGrade": 9 +"RoomsBelowGrade": 5 +"ParcelOfTiedLand": "No" +"PropertyFeatures": array:1 [ 0 => "School Bus Route" ] +"SalesBrochureUrl": "https://vastvue.vids.io/videos/d391d2b11819e7c15a/0904-1-1" +"PossessionDetails": "1-29 days" +"WashroomsType1Pcs": 2 +"WashroomsType2Pcs": 5 +"WashroomsType3Pcs": 3 +"WashroomsType4Pcs": 4 +"WashroomsType5Pcs": 3 +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"WashroomsType1Level": "Main" +"WashroomsType2Level": "Main" +"WashroomsType3Level": "Second" +"WashroomsType4Level": "Second" +"WashroomsType5Level": "Lower" +"MediaChangeTimestamp": "2024-09-05T13:20:50Z" +"TerminatedEntryTimestamp": "2024-12-04T21:21:57Z" +"SystemModificationTimestamp": "2025-02-14T20:10:35.585006Z" +"Media": array:40 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] 37 => array:26 [ …26] 38 => array:26 [ …26] 39 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13155 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9298135" +"ListingId": "X9298135" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T20:10:16Z" +"RFModificationTimestamp": "2025-04-26T17:49:03.356434+00:00" +"ListPrice": 599900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8K 3P2" +"UnparsedAddress": "252 Glencairn Avenue, Hamilton, On L8k 3p2" +"Coordinates": array:2 [ 0 => -79.7960494 1 => 43.2296057 ] +"Latitude": 43.2296057 +"Longitude": -79.7960494 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Keller Williams Signature Realty, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 252 Glencairn Ave in Hamilton, a 3-bedroom home with excellent potential. This property is ready for your personal touch and renovation ideas. The main level features a comfortable living space, a kitchen awaiting your updates, and a conveniently located bedroom. Upstairs, youll find two additional bedrooms, offering privacy and flexibility for your familys needs.The home also includes a detached garage, perfect for extra storage or a workshop, and a spacious backyard thats ready for your landscaping or outdoor entertaining plans.Situated in a family-friendly neighborhood, this property is close to essential amenities like shopping centers, grocery stores, and various dining options. Nearby parks provide great opportunities for outdoor activities, while well-regarded schools make it an ideal location for families. With easy access to public transportation and major highways, commuting is simple and convenient.Whether you're a first-time homebuyer looking for a renovation project or an investor seeking a property with great potential, 252 Glencairn Ave offers a unique opportunity to create the home you've always wanted." +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Full" 1 => "Partially Finished" ] +"CityRegion": "Glenview" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2024-10-12T00:06:29.942696+00:00" +"CrossStreet": "King St E & Parkdale Ave S" +"DirectionFaces": "West" +"ExpirationDate": "2025-03-04" +"FoundationDetails": array:1 [ 0 => "Concrete" ] +"Inclusions": "Refrigerator, Stove" +"InteriorFeatures": array:2 [ 0 => "Separate Hydro Meter" 1 => "Primary Bedroom - Main Floor" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-04" +"MainOfficeKey": "534800" +"MajorChangeTimestamp": "2025-02-10T19:03:30Z" +"MlsStatus": "Terminated" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-04T14:27:44Z" +"OriginalListPrice": 599900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1453594" +"ParcelNumber": "172750237" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2024-12-12T22:48:48Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Lockbox" 1 => "Showing System" 2 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Glencairn" +"StreetNumber": "252" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3773.37" +"TaxLegalDescription": "LT 178, PL 786 ; HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% +HST" +"TransactionType": "For Sale" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotDepth": 96.7 +"LotWidth": 40.0 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9298135')" +"GarageType": "Detached" +"HeatSource": "Gas" +"RollNumber": "251805037207310" +"RentalItems": "Water heater" +"HoldoverDays": 60 +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ContractStatus": "Unavailable" +"HSTApplication": array:1 [ 0 => "Included" ] +"PriorMlsStatus": "New" +"WashroomsType1": 1 +"RoomsAboveGrade": 6 +"PossessionDetails": "Flexible" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 3 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"MediaChangeTimestamp": "2024-12-12T22:48:48Z" +"TerminatedEntryTimestamp": "2025-02-10T19:03:30Z" +"SystemModificationTimestamp": "2025-02-14T20:10:17.689523Z" +"Media": array:19 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13134 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11937165" +"ListingId": "X11937165" +"PropertyType": "Residential" +"PropertySubType": "Common Element Condo" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T20:03:23Z" +"RFModificationTimestamp": "2025-05-06T07:45:48.210758+00:00" +"ListPrice": 469999.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8E 0K3" +"UnparsedAddress": "#210 - 125 Shoreview Place, Hamilton, On L8e 0k3" +"Coordinates": array:2 [ 0 => -79.719225 1 => 43.2385914 ] +"Latitude": 43.2385914 +"Longitude": -79.719225 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Stunning 1 Bedroom Plus Den Condo Sought After "Sapphire" Development Built By Award Winning Builder, New Horizon Homes! Features Geo-Thermal Heating And Cooling, Stainless Steel Kitchen Appliances, Quartz Counter, Vinyl And Ceramic Flooring, No Carpet, New Upgraded Light Fixtures And Beautiful Finishes Throughout! One Can Walk To Lake And Natural Trails. The Building Offers Its Residents A Fully Equipped Gym, Party Room And Breathtaking Views Of The Lake From The Rooftop Terrace. Steps Away From Private Beach And Lake Access! **EXTRAS** Ss Fridge, Ss Stove, Ss Dishwasher, Ss B/I Microwave, Stacked Washer And Dryer." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationAmenities": array:2 [ 0 => "Rooftop Deck/Garden" 1 => "Visitor Parking" ] +"AssociationFee": "522.12" +"AssociationFeeIncludes": array:5 [ 0 => "Building Insurance Included" 1 => "Condo Taxes Included" 2 => "CAC Included" 3 => "Parking Included" 4 => "Water Included" ] +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Lakeshore" +"ConstructionMaterials": array:1 [ 0 => "Concrete" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-01-23T20:23:29.665783+00:00" +"CrossStreet": "Shoreview Pl / Millen Rd" +"ExpirationDate": "2025-07-14" +"InteriorFeatures": array:1 [ 0 => "Carpet Free" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In-Suite Laundry" ] +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-20" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2025-01-23T14:46:15Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-23T14:46:15Z" +"OriginalListPrice": 469999.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1869724" +"ParcelNumber": "185890094" +"ParkingFeatures": array:1 [ 0 => "None" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-01-23T14:46:15Z" +"ShowingRequirements": array:1 [ 0 => "See Brokerage Remarks" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Shoreview" +"StreetNumber": "125" +"StreetSuffix": "Place" +"TaxAnnualAmount": "3613.34" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5%- $ 475.00 MKT FEES" +"TransactionType": "For Sale" +"UnitNumber": "210" +"DDFYN": true +"Locker": "Owned" +"Exposure": "South" +"HeatType": "Forced Air" +"LotShape": "Other" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11937165')" +"ElevatorYN": true +"GarageType": "Underground" +"HeatSource": "Gas" +"RollNumber": "251800304020157" +"BalconyType": "Open" +"HoldoverDays": 90 +"LegalStories": "2" +"ParkingType1": "Owned" +"KitchensTotal": 1 +"provider_name": "TRREB" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Included" ] +"PossessionDate": "2025-04-01" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"CondoCorpNumber": 589 +"LivingAreaRange": "600-699" +"RoomsAboveGrade": 4 +"EnsuiteLaundryYN": true +"SquareFootSource": "AS PER SELLER" +"PossessionDetails": "TENANTED" +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 1 +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"StatusCertificateYN": true +"WashroomsType1Level": "Flat" +"LegalApartmentNumber": "10" +"MediaChangeTimestamp": "2025-01-23T14:46:15Z" +"PropertyManagementCompany": "WILSON BLANCHARD" +"SystemModificationTimestamp": "2025-02-14T20:03:23.707506Z" +"VendorPropertyInfoStatement": true +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:12 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13133 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11932997" +"ListingId": "X11932997" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:38:10Z" +"RFModificationTimestamp": "2025-04-30T05:05:39.548124+00:00" +"ListPrice": 1.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L0R 1V0" +"UnparsedAddress": "859 Hwy 6, Hamilton, On L0r 1v0" +"Coordinates": array:2 [ 0 => -79.9517555 1 => 43.3368031 ] +"Latitude": 43.3368031 +"Longitude": -79.9517555 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOMELIFE/MIRACLE REALTY LTD" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Opportunity knocks only Once in a life time. Own a Branded turnkey Gas Station Business on a busiest highway.Branded Inver self serve gas station offering all Gasoline Grades with Diesel, Propane, Lotto and High marginal Convenience store itemes. most recent upgraded Fuel pumps and convenience store with Lottery Terminal.Great fuel volume History and high marginal site. Nestled in a high-traffic area with excellent visibility and easy in/out access, this gas station is perfectly positioned to attract both local customers and passing travelers, Centrally located in 30 minutes away City of Brampton, Mississauga, Oakville, Burlington, Hamilton, Guelph & Waterloo region. Compatible Fuel supply Agreement inplace helps to drive the Gas sales. vary Reasonable rent, New lease available direct from landlord.NO Good-Will required, this offer only available for qualified buyer with endless potentials.This money making thriving site is looking for right candidate. **EXTRAS** Turn key operation.Very east to run,One man show. Family oriented Business. upgraded pumps with card reader. Propane on the site." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Gas Station" ] +"CityRegion": "Rural Flamborough" +"CommunityFeatures": array:1 [ 0 => "Major Highway" ] +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-21T06:03:50.988600+00:00" +"CrossStreet": "Hwy 6 & Millgrove" +"Exclusions": "New Tenant arrange store Inventory such as All Grade of Gasolines, Propane, Lotto, Smokes & all kind of Grocery upon the date of possession." +"ExpirationDate": "2025-12-31" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"HoursDaysOfOperationDescription": "7 Am- 9 Pm" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-20" +"MainOfficeKey": "406000" +"MajorChangeTimestamp": "2025-01-21T01:06:42Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 4 +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-21T01:06:42Z" +"OriginalListPrice": 1.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1883504" +"PhotosChangeTimestamp": "2025-01-21T01:06:42Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Hwy 6" +"StreetNumber": "859" +"StreetSuffix": "N/A" +"TaxLegalDescription": "N/A" +"TaxYear": "2024" +"TransactionBrokerCompensation": "$ 5000" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "Commercial" +"DDFYN": true +"Water": "Well" +"LotType": "Building" +"TaxType": "TMI" +"HeatType": "Baseboard" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11932997')" +"ChattelsYN": true +"GarageType": "Other" +"FranchiseYN": true +"PropertyUse": "Without Property" +"HoldoverDays": 180 +"ListPriceUnit": "For Sale" +"provider_name": "TRREB" +"ContractStatus": "Available" +"HSTApplication": array:1 [ 0 => "Yes" ] +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft" +"WashroomsType1": 1 +"ClearHeightFeet": 9 +"MortgageComment": "Treat as Clear." +"PossessionDetails": "TBA" +"MediaChangeTimestamp": "2025-01-21T01:06:42Z" +"SystemModificationTimestamp": "2025-02-14T19:38:10.706048Z" +"Media": array:6 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13132 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11932329" +"ListingId": "X11932329" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:34:21Z" +"RFModificationTimestamp": "2025-04-26T06:25:54.357811+00:00" +"ListPrice": 20.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 6126.76 +"City": "Hamilton" +"PostalCode": "L8L 4S1" +"UnparsedAddress": "554 John Street, Hamilton, On L8l 4s1" +"Coordinates": array:2 [ 0 => -79.9602802 1 => 43.2665814 ] +"Latitude": 43.2665814 +"Longitude": -79.9602802 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "FREEMAN REAL ESTATE LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Located at 554 John St. North in the north end of Hamilton, the Free Standing building called Afiya Medical Building offers 6,126.76 sq. ft. of versatile main floor space. This area can be leased as a whole if divided into units as small 1000 sq. ft. Currently home to the Afiya Pain Clinic and an on-site pharmacy, this facility presents an ideal opportunity for healthcare providers seeking a collaborative environment. Afya's vision is create a premier hub for top-tier medical services, making it an excellent location for health-related businesses. Permitted uses are restricted to medical and healthcare services. The building is situated in a prime waterfront area undergoing redevelopment, which will include mixed-use residential, commercial and recreational spaces. This priority is being transformed into a state-of-the-art medical facility, providing exceptional opportunity for any medical professional or healthcare service provider to establish their practice in a modern, thriving community. **EXTRAS** Plenty of parking available. Can divide into 1000 square floor units." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Service Related" ] +"CityRegion": "North End" +"Cooling": array:1 [ 0 => "Partial" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-03-30T11:16:28.155622+00:00" +"CrossStreet": "John St N & Burlington St E" +"Exclusions": "To be negotiated." +"ExpirationDate": "2025-05-20" +"Inclusions": "To be negotiated." +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-20" +"MainOfficeKey": "222000" +"MajorChangeTimestamp": "2025-01-20T19:15:00Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2025-01-20T19:15:01Z" +"OriginalListPrice": 20.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1880804" +"PhotosChangeTimestamp": "2025-01-20T19:54:10Z" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"ShowingRequirements": array:2 [ 0 => "Go Direct" 1 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "John" +"StreetNumber": "554" +"StreetSuffix": "Street" +"TaxAnnualAmount": "10.22" +"TaxYear": "2025" +"TransactionBrokerCompensation": "1/2 month base rent for the first 2 yrs" +"TransactionType": "For Lease" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "Commercial Medical Use" +"DDFYN": true +"Water": "Municipal" +"LotType": "Building" +"TaxType": "Annual" +"HeatType": "Gas Forced Air Open" +"LotDepth": 312.29 +"LotWidth": 86.84 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11932329')" +"GarageType": "None" +"RetailArea": 6126.76 +"PropertyUse": "Retail" +"HoldoverDays": 60 +"ListPriceUnit": "Net Lease" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8L 4S1, CA" +"ApproximateAge": "New" +"ContractStatus": "Available" +"FreestandingYN": true +"PossessionDate": "2025-03-17" +"PriorMlsStatus": "Draft" +"RetailAreaCode": "Sq Ft Divisible" +"PossessionDetails": "TBD" +"MediaChangeTimestamp": "2025-01-20T19:54:10Z" +"MaximumRentalMonthsTerm": 60 +"MinimumRentalTermMonths": 36 +"SystemModificationTimestamp": "2025-02-14T19:34:21.852847Z" +"VendorPropertyInfoStatement": true +"Media": array:1 [ 0 => array:26 [ …26] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13131 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11928748" +"ListingId": "X11928748" +"PropertyType": "Residential Lease" +"PropertySubType": "Lower Level" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:16:04Z" +"RFModificationTimestamp": "2025-03-30T11:18:58.678435+00:00" +"ListPrice": 1850.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8W 3E9" +"UnparsedAddress": "#bsmt - 22 Amblecote Pl, Hamilton, On L8w 3e9" +"Coordinates": array:2 [ 0 => -79.8572528 1 => 43.2052747 ] +"Latitude": 43.2052747 +"Longitude": -79.8572528 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE SUPREME REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Beautiful One Bedroom Basement Apartment Located In The Serene And Prestigious Randall Community. This Charming Newly Renovated Unit Is Equipped With Ensuite Washer and Dryer, Large Pantry, 3-Piece Bathroom, Two Driveway Parking Space And Your Very Own Private Gated Outdoor Area. Great Location, Close To Shops And Easy Access To Highway. Don't Miss Out On This Amazing Opportunity! **EXTRAS** ***The Tenant Pays 30% of Utilities.*** Internet/ Cable/ Phone Are Excluded." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"Basement": array:2 [ 0 => "Apartment" 1 => "Separate Entrance" ] +"CityRegion": "Randall" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-19T23:16:50.430346+00:00" +"CrossStreet": "ASHCROFT / AMBLECOTE" +"DirectionFaces": "West" +"ExpirationDate": "2025-06-16" +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Furnished": "Unfurnished" +"Inclusions": "Parking" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-17" +"MainOfficeKey": "095600" +"MajorChangeTimestamp": "2025-01-17T15:26:38Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-01-17T15:26:39Z" +"OriginalListPrice": 1850.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1859266" +"ParcelNumber": "171260054" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2025-01-18T00:32:27Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"RentIncludes": array:1 [ 0 => "Parking" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Amblecote Pl" +"StreetNumber": "22" +"StreetSuffix": "N/A" +"TransactionBrokerCompensation": "1/2 Month's Rent" +"TransactionType": "For Lease" +"UnitNumber": "Bsmt" +"DDFYN": true +"Water": "Municipal" +"HeatType": "Forced Air" +"LotWidth": 37.86 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11928748')" +"GarageType": "None" +"HeatSource": "Gas" +"RollNumber": "251807069101560" +"HoldoverDays": 90 +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 2 +"provider_name": "TRREB" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"WashroomsType1": 1 +"RoomsAboveGrade": 2 +"PaymentFrequency": "Monthly" +"PossessionDetails": "Immediate" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 3 +"BedroomsAboveGrade": 1 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Basement" +"MediaChangeTimestamp": "2025-01-18T00:32:27Z" +"PortionPropertyLease": array:1 [ 0 => "Basement" ] +"ReferencesRequiredYN": true +"SystemModificationTimestamp": "2025-02-14T19:16:04.225632Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#13130 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11927157" +"ListingId": "X11927157" +"PropertyType": "Residential Lease" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T19:08:49Z" +"RFModificationTimestamp": "2025-03-30T14:36:18.234108+00:00" +"ListPrice": 3000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8P 2S4" +"UnparsedAddress": "#ph04 - 427 Aberdeen Avenue, Hamilton, On L8p 2s4" +"Coordinates": array:2 [ 0 => -79.893162 1 => 43.2509412 ] +"Latitude": 43.2509412 +"Longitude": -79.893162 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "IPRO REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover a rare gem in this 1,345sq. ft. three-bedroom, two-bathroom penthouse, ideally situated moments from Highway 403 and steps away from an array of amenities, including hospitals, public transit, esteemed schools, and the vibrant culinary scene of Locke Street. Boasting an impressive ten-foot ceiling height throughout & floor-to-ceiling windows that invite natural light and offer stunning Views. Enjoy the elegance of a Juliette balcony, exquisite quartz countertops, and the convenience of underground parking and a dedicated locker. The building features a luxurious rooftop lounge and BBQ deck, providing a perfect setting to unwind while taking in the captivating views of Hamiltons natural beauty and skyline. Elevate your lifestyle in this magnificent penthouse, where sophistication meets convenience. Unit Available at All Inclusive Rent of $3,300/Month **EXTRAS** Fridge, Stove, Dishwasher, Washer, Dryer, All Elfs & Wall Unit In Living/Great Room." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationYN": true +"AttachedGarageYN": true +"Basement": array:1 [ 0 => "None" ] +"CityRegion": "Kirkendall" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CoolingYN": true +"Country": "CA" +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2025-03-30T11:21:17.983102+00:00" +"CrossStreet": "Dundurn St S" +"Exclusions": "None" +"ExpirationDate": "2025-06-16" +"Furnished": "Unfurnished" +"GarageYN": true +"HeatingYN": true +"Inclusions": "Fridge, Stove, Dishwasher, Washer, Dryer, All Elfs & Wall Unit In Living/Great Room." +"InteriorFeatures": array:2 [ 0 => "Carpet Free" 1 => "Storage" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"LeaseTerm": "12 Months" +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-16" +"MainOfficeKey": "158500" +"MajorChangeTimestamp": "2025-01-16T18:37:20Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-16T18:37:20Z" +"OriginalListPrice": 3000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1869490" +"ParcelNumber": "184960045" +"ParkingFeatures": array:1 [ 0 => "Underground" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-01-16T18:37:20Z" +"PropertyAttachedYN": true +"RentIncludes": array:2 [ 0 => "Water" 1 => "Parking" ] +"RoomsTotal": "6" +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Aberdeen" +"StreetNumber": "427" +"StreetSuffix": "Avenue" +"TransactionBrokerCompensation": "Half Month Rent + Hst" +"TransactionType": "For Lease" +"UnitNumber": "PH04" +"View": array:3 [ 0 => "Mountain" 1 => "Downtown" 2 => "Panoramic" ] +"DDFYN": true +"Locker": "Owned" +"Exposure": "North" +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11927157')" +"PictureYN": true +"GarageType": "Underground" +"HeatSource": "Gas" +"LockerUnit": "32" +"BalconyType": "Juliette" +"RentalItems": "None" +"HoldoverDays": 90 +"LaundryLevel": "Main Level" +"LegalStories": "06" +"ParkingType1": "Owned" +"CreditCheckYN": true +"KitchensTotal": 1 +"ParkingSpaces": 1 +"PaymentMethod": "Cheque" +"provider_name": "TRREB" +"short_address": "Hamilton, ON L8P 2S4, CA" +"ApproximateAge": "6-10" +"ContractStatus": "Available" +"PossessionDate": "2025-02-01" +"PriorMlsStatus": "Draft" +"WashroomsType1": 2 +"CondoCorpNumber": 496 +"DenFamilyroomYN": true +"DepositRequired": true +"LivingAreaRange": "1200-1399" +"RoomsAboveGrade": 6 +"LeaseAgreementYN": true +"PaymentFrequency": "Monthly" +"PropertyFeatures": array:6 [ 0 => "Arts Centre" 1 => "Golf" 2 => "Hospital" 3 => "Library" 4 => "Park" 5 => "Place Of Worship" ] +"SquareFootSource": "Builder Plans" +"StreetSuffixCode": "Ave" +"BoardPropertyType": "Condo" +"PrivateEntranceYN": true +"WashroomsType1Pcs": 4 +"BedroomsAboveGrade": 3 +"EmploymentLetterYN": true +"KitchensAboveGrade": 1 +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RentalApplicationYN": true +"WashroomsType1Level": "Main" +"LegalApartmentNumber": "04" +"MediaChangeTimestamp": "2025-01-16T18:37:20Z" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"ReferencesRequiredYN": true +"MLSAreaDistrictOldZone": "X14" +"PropertyManagementCompany": "Property Management Guild Inc." +"MLSAreaMunicipalityDistrict": "Hamilton" +"SystemModificationTimestamp": "2025-02-14T19:08:49.901313Z" +"PermissionToContactListingBrokerToAdvertise": true +"Media": array:32 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] ] } ] +success: true +page_size: 10 +page_count: 377 +count: 3764 +after_key: "" } ] ]
