4055 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: d4cf349d3e36740eaf2db9b9f78539d1734ba689d232d0a9dcedce974550373b" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14619 +items: array:10 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14448 +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:03Z" +"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" +"Water": "Municipal" +"RoomsAboveGrade": 6 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"HeatSource": "Gas" +"ContractStatus": "Unavailable" +"LotWidth": 40.0 +"HeatType": "Forced Air" +"TerminatedEntryTimestamp": "2025-02-10T19:03:30Z" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9298135')" +"WashroomsType1Pcs": 4 +"HSTApplication": array:1 [ 0 => "Included" ] +"RollNumber": "251805037207310" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-02-14T20:10:17.689523Z" +"provider_name": "TRREB" +"LotDepth": 96.7 +"ParkingSpaces": 2 +"PossessionDetails": "Flexible" +"GarageType": "Detached" +"PriorMlsStatus": "New" +"BedroomsAboveGrade": 3 +"MediaChangeTimestamp": "2024-12-12T22:48:48Z" +"RentalItems": "Water heater" +"HoldoverDays": 60 +"KitchensTotal": 1 +"Media": array:19 [ 0 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-f49b636a27fd56ca0ea1a24f2dbcd7cc.webp" "ShortDescription" => null "MediaKey" => "fc1df004-5052-4509-9162-274ab3627339" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "fc1df004-5052-4509-9162-274ab3627339" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/f49b636a27fd56ca0ea1a24f2dbcd7cc.webp" "MediaSize" => 218740 "SourceSystemMediaKey" => "fc1df004-5052-4509-9162-274ab3627339" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 682 ] 1 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-be48b95f05c10cb9b746cb33986d9041.webp" "ShortDescription" => null "MediaKey" => "1be65abe-499b-41b1-8916-e33fca777ba8" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "1be65abe-499b-41b1-8916-e33fca777ba8" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/be48b95f05c10cb9b746cb33986d9041.webp" "MediaSize" => 222929 "SourceSystemMediaKey" => "1be65abe-499b-41b1-8916-e33fca777ba8" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 2 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-6b286d441708a9c521bb87a8f690445e.webp" "ShortDescription" => null "MediaKey" => "6d88d77a-0e65-4c65-988f-86812c9e271c" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "6d88d77a-0e65-4c65-988f-86812c9e271c" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/6b286d441708a9c521bb87a8f690445e.webp" "MediaSize" => 224808 "SourceSystemMediaKey" => "6d88d77a-0e65-4c65-988f-86812c9e271c" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 3 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-ac55d5fb4364fee48321c4e578023762.webp" "ShortDescription" => null "MediaKey" => "4026fc5a-0c91-4a9d-9724-d198d55714a2" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "4026fc5a-0c91-4a9d-9724-d198d55714a2" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/ac55d5fb4364fee48321c4e578023762.webp" "MediaSize" => 189659 "SourceSystemMediaKey" => "4026fc5a-0c91-4a9d-9724-d198d55714a2" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 4 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-ecf6be369dea92c57d443cc2c93b4236.webp" "ShortDescription" => null "MediaKey" => "8403ee84-cf9e-43bc-b43a-5934ed586819" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8403ee84-cf9e-43bc-b43a-5934ed586819" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/ecf6be369dea92c57d443cc2c93b4236.webp" "MediaSize" => 189060 "SourceSystemMediaKey" => "8403ee84-cf9e-43bc-b43a-5934ed586819" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 5 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-9916ea9f2e74ae47ad2ee93a10dff8e8.webp" "ShortDescription" => null "MediaKey" => "79612e9b-828a-4e38-b2a1-bec8e31858ac" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "79612e9b-828a-4e38-b2a1-bec8e31858ac" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/9916ea9f2e74ae47ad2ee93a10dff8e8.webp" "MediaSize" => 223495 "SourceSystemMediaKey" => "79612e9b-828a-4e38-b2a1-bec8e31858ac" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 6 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-3a3d25787f6abae87b0f57a69826f19c.webp" "ShortDescription" => null "MediaKey" => "4b382d87-dd58-4038-8bbc-ba5e768ede60" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "4b382d87-dd58-4038-8bbc-ba5e768ede60" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/3a3d25787f6abae87b0f57a69826f19c.webp" "MediaSize" => 179690 "SourceSystemMediaKey" => "4b382d87-dd58-4038-8bbc-ba5e768ede60" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 7 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-097f1f3a84a20fc7d3c4d86233fde4a9.webp" "ShortDescription" => null "MediaKey" => "da53aca2-4f90-4108-b5b6-08a012e1c4d6" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "da53aca2-4f90-4108-b5b6-08a012e1c4d6" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/097f1f3a84a20fc7d3c4d86233fde4a9.webp" "MediaSize" => 196920 "SourceSystemMediaKey" => "da53aca2-4f90-4108-b5b6-08a012e1c4d6" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 8 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-c990cf3d81bb7f2a4f22dbea76c7ece4.webp" "ShortDescription" => null "MediaKey" => "709303f5-f472-4905-ba43-bb618ea83b44" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "709303f5-f472-4905-ba43-bb618ea83b44" "Order" => 8 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/c990cf3d81bb7f2a4f22dbea76c7ece4.webp" "MediaSize" => 191008 "SourceSystemMediaKey" => "709303f5-f472-4905-ba43-bb618ea83b44" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 9 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-a38f3edb995a3a5a2069fb36cfd4e089.webp" "ShortDescription" => null "MediaKey" => "3d7c3d44-8d23-4fc5-ab52-a28c65216eb7" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "3d7c3d44-8d23-4fc5-ab52-a28c65216eb7" "Order" => 9 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/a38f3edb995a3a5a2069fb36cfd4e089.webp" "MediaSize" => 199785 "SourceSystemMediaKey" => "3d7c3d44-8d23-4fc5-ab52-a28c65216eb7" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 10 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-3774b95030b4c11d7340846fa99e4224.webp" "ShortDescription" => null "MediaKey" => "a2d490c5-69bd-48ff-9243-b893196c8e92" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a2d490c5-69bd-48ff-9243-b893196c8e92" "Order" => 10 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/3774b95030b4c11d7340846fa99e4224.webp" "MediaSize" => 186526 "SourceSystemMediaKey" => "a2d490c5-69bd-48ff-9243-b893196c8e92" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 11 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-6791f6de4a32fda072e718b1f7077490.webp" "ShortDescription" => null "MediaKey" => "455a4728-14d5-464f-8c4e-a751d5ef6e5e" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "455a4728-14d5-464f-8c4e-a751d5ef6e5e" "Order" => 11 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/6791f6de4a32fda072e718b1f7077490.webp" "MediaSize" => 203591 "SourceSystemMediaKey" => "455a4728-14d5-464f-8c4e-a751d5ef6e5e" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 12 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-f3d6914566a619d893973a342cd112d4.webp" "ShortDescription" => null "MediaKey" => "cc64b4cb-6c17-48d6-bec0-6dfc59c36151" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "cc64b4cb-6c17-48d6-bec0-6dfc59c36151" "Order" => 12 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/f3d6914566a619d893973a342cd112d4.webp" "MediaSize" => 179523 "SourceSystemMediaKey" => "cc64b4cb-6c17-48d6-bec0-6dfc59c36151" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 13 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-9f9446f2dbc221d75347a0d4961ff505.webp" "ShortDescription" => null "MediaKey" => "ced8f53d-fe3b-4b7e-9903-14ed557fd2dd" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "ced8f53d-fe3b-4b7e-9903-14ed557fd2dd" "Order" => 13 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/9f9446f2dbc221d75347a0d4961ff505.webp" "MediaSize" => 184036 "SourceSystemMediaKey" => "ced8f53d-fe3b-4b7e-9903-14ed557fd2dd" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 14 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-63a3b430490fbc0e556fc02647fa8c42.webp" "ShortDescription" => null "MediaKey" => "90af7ee6-fc10-480b-a9f7-a3b4197121a4" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "90af7ee6-fc10-480b-a9f7-a3b4197121a4" "Order" => 14 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/63a3b430490fbc0e556fc02647fa8c42.webp" "MediaSize" => 190258 "SourceSystemMediaKey" => "90af7ee6-fc10-480b-a9f7-a3b4197121a4" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 15 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-bca629b829f6f732220a5e27bd236e75.webp" "ShortDescription" => null "MediaKey" => "5d1af613-5ab9-4aed-a0e9-8e3d5f0ab279" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "5d1af613-5ab9-4aed-a0e9-8e3d5f0ab279" "Order" => 15 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/bca629b829f6f732220a5e27bd236e75.webp" "MediaSize" => 194106 "SourceSystemMediaKey" => "5d1af613-5ab9-4aed-a0e9-8e3d5f0ab279" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 16 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-f762d0584cbb1fc71d61027b80a80e70.webp" "ShortDescription" => null "MediaKey" => "7a7de06c-7023-4027-8b1f-b63fd886e01f" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "7a7de06c-7023-4027-8b1f-b63fd886e01f" "Order" => 16 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/f762d0584cbb1fc71d61027b80a80e70.webp" "MediaSize" => 211016 "SourceSystemMediaKey" => "7a7de06c-7023-4027-8b1f-b63fd886e01f" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 17 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-0643d61c5d56236f9d5662a11cdc4f21.webp" "ShortDescription" => null "MediaKey" => "7e8aabb1-ab0f-4934-9b54-d45aec5080a0" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "7e8aabb1-ab0f-4934-9b54-d45aec5080a0" "Order" => 17 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/0643d61c5d56236f9d5662a11cdc4f21.webp" "MediaSize" => 209108 "SourceSystemMediaKey" => "7e8aabb1-ab0f-4934-9b54-d45aec5080a0" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] 18 => array:26 [ "ResourceRecordKey" => "X9298135" "MediaModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9298135/thumbnail-94795f7b1b3788680b8bb68b82aa8d39.webp" "ShortDescription" => null "MediaKey" => "0b33050e-9b44-4970-86d7-06ade3e1f660" "ImageWidth" => 1024 "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-12-12T22:48:48.4022Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "0b33050e-9b44-4970-86d7-06ade3e1f660" "Order" => 18 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9298135/94795f7b1b3788680b8bb68b82aa8d39.webp" "MediaSize" => 210873 "SourceSystemMediaKey" => "0b33050e-9b44-4970-86d7-06ade3e1f660" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 682 ] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14447 +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:39Z" +"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" +"Water": "Well" +"PossessionDetails": "TBA" +"WashroomsType1": 1 +"DDFYN": true +"LotType": "Building" +"PropertyUse": "Without Property" +"GarageType": "Other" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"ListPriceUnit": "For Sale" +"MediaChangeTimestamp": "2025-01-21T01:06:42Z" +"HeatType": "Baseboard" +"TaxType": "TMI" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11932997')" +"HoldoverDays": 180 +"HSTApplication": array:1 [ 0 => "Yes" ] +"ClearHeightFeet": 9 +"MortgageComment": "Treat as Clear." +"FranchiseYN": true +"RetailAreaCode": "Sq Ft" +"ChattelsYN": true +"SystemModificationTimestamp": "2025-02-14T19:38:10.706048Z" +"provider_name": "TRREB" +"Media": array:6 [ 0 => array:26 [ "ResourceRecordKey" => "X11932997" "MediaModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11932997/thumbnail-bfaacc9f76a308850a631589a429d0aa.webp" "ShortDescription" => null "MediaKey" => "b6659796-2914-410f-a4bc-36f73a8b1f26" "ImageWidth" => 665 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "b6659796-2914-410f-a4bc-36f73a8b1f26" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11932997/bfaacc9f76a308850a631589a429d0aa.webp" "MediaSize" => 31665 "SourceSystemMediaKey" => "b6659796-2914-410f-a4bc-36f73a8b1f26" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 408 ] 1 => array:26 [ "ResourceRecordKey" => "X11932997" "MediaModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11932997/thumbnail-5401408b71e6eacde06a87edd05ad73b.webp" "ShortDescription" => null "MediaKey" => "9bb8f67c-f307-4183-820b-552e0a7f3eed" "ImageWidth" => 1900 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "9bb8f67c-f307-4183-820b-552e0a7f3eed" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11932997/5401408b71e6eacde06a87edd05ad73b.webp" "MediaSize" => 280901 "SourceSystemMediaKey" => "9bb8f67c-f307-4183-820b-552e0a7f3eed" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 996 ] 2 => array:26 [ "ResourceRecordKey" => "X11932997" "MediaModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11932997/thumbnail-74777925d0710b15ffb4c0ddc8b2b6dc.webp" "ShortDescription" => null "MediaKey" => "1be2de35-897b-447e-a3e7-6738165342ec" "ImageWidth" => 1900 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "1be2de35-897b-447e-a3e7-6738165342ec" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11932997/74777925d0710b15ffb4c0ddc8b2b6dc.webp" "MediaSize" => 239839 "SourceSystemMediaKey" => "1be2de35-897b-447e-a3e7-6738165342ec" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1116 ] 3 => array:26 [ "ResourceRecordKey" => "X11932997" "MediaModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11932997/thumbnail-269310a7957725a46ef0d788eecc4a3f.webp" "ShortDescription" => null "MediaKey" => "278c58cb-042a-499f-b49b-a966be2200c6" "ImageWidth" => 1900 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "278c58cb-042a-499f-b49b-a966be2200c6" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11932997/269310a7957725a46ef0d788eecc4a3f.webp" "MediaSize" => 270348 "SourceSystemMediaKey" => "278c58cb-042a-499f-b49b-a966be2200c6" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1153 ] 4 => array:26 [ "ResourceRecordKey" => "X11932997" "MediaModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11932997/thumbnail-f4c8f523a5399be3cd868ccae711bd06.webp" "ShortDescription" => null "MediaKey" => "20d48edc-7161-4070-b236-6cc9114a5093" "ImageWidth" => 1900 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "20d48edc-7161-4070-b236-6cc9114a5093" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11932997/f4c8f523a5399be3cd868ccae711bd06.webp" "MediaSize" => 260421 "SourceSystemMediaKey" => "20d48edc-7161-4070-b236-6cc9114a5093" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1140 ] 5 => array:26 [ "ResourceRecordKey" => "X11932997" "MediaModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11932997/thumbnail-2fbb779ed0e11792c627b6ebe1ea3303.webp" "ShortDescription" => null "MediaKey" => "8e96aadf-5681-4568-85f7-7abc8803f90e" "ImageWidth" => 1637 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-21T01:06:42.184979Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8e96aadf-5681-4568-85f7-7abc8803f90e" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11932997/2fbb779ed0e11792c627b6ebe1ea3303.webp" "MediaSize" => 426513 "SourceSystemMediaKey" => "8e96aadf-5681-4568-85f7-7abc8803f90e" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 1238 ] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14418 +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:54Z" +"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" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Building" +"PropertyUse": "Retail" +"VendorPropertyInfoStatement": true +"ContractStatus": "Available" +"ListPriceUnit": "Net Lease" +"LotWidth": 86.84 +"HeatType": "Gas Forced Air Open" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11932329')" +"MinimumRentalTermMonths": 36 +"RetailArea": 6126.76 +"SystemModificationTimestamp": "2025-02-14T19:34:21.852847Z" +"provider_name": "TRREB" +"LotDepth": 312.29 +"PossessionDetails": "TBD" +"MaximumRentalMonthsTerm": 60 +"GarageType": "None" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-20T19:54:10Z" +"TaxType": "Annual" +"ApproximateAge": "New" +"HoldoverDays": 60 +"RetailAreaCode": "Sq Ft Divisible" +"PossessionDate": "2025-03-17" +"short_address": "Hamilton, ON L8L 4S1, CA" +"Media": array:1 [ 0 => array:26 [ "ResourceRecordKey" => "X11932329" "MediaModificationTimestamp" => "2025-01-20T19:54:10.446732Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11932329/thumbnail-392837f8d838e970285936a56239c2aa.webp" "ShortDescription" => null "MediaKey" => "600fd51a-1e52-4a2f-96de-dca11853d4a6" "ImageWidth" => 2412 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-20T19:54:10.446732Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "600fd51a-1e52-4a2f-96de-dca11853d4a6" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11932329/392837f8d838e970285936a56239c2aa.webp" "MediaSize" => 451560 "SourceSystemMediaKey" => "600fd51a-1e52-4a2f-96de-dca11853d4a6" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 1608 ] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14491 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11925452" +"ListingId": "X11925452" +"PropertyType": "Commercial Sale" +"PropertySubType": "Industrial" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T18:58:28Z" +"RFModificationTimestamp": "2025-04-18T15:14:01Z" +"ListPrice": 2100000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 25671.9 +"City": "Hamilton" +"PostalCode": "L8L 4H4" +"UnparsedAddress": "350 Burlington Street, Hamilton, On L8l 4h4" +"Coordinates": array:2 [ 0 => -79.8499315 1 => 43.2696415 ] +"Latitude": 43.2696415 +"Longitude": -79.8499315 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "GFA REALTY LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Unlock a rare opportunity with this prime 0.589-acre industrial property, perfectly suited for both investors and owner-occupiers. Situated at the doorstep of the highly anticipated STEELPORT DEVELOPMENT, this corner lot offers unmatched potential for growth, profitability, and long-term success With its strategic location and access from both Burlington St. & Victoria Ave. Fully operational and turnkey, the property boasts a licensed body shop, automotive mechanical shop, auto repair facility, and paint shop. Equipped with a compressor, hoist, and three large bay doors, the site is ready for immediate use.Additionally, a portable building at the rear of the property generates consistent rental income, further enhancing its investment appeal. With tenants on a month-to-month lease, the property offers flexibility for both immediate use or future leasing opportunities.Whether you're looking to invest or occupy, don't miss this chance to secure a high-potential industrial asset with immediate functionality and long-term value. **EXTRAS** Environmental assessment or due diligence related to the property will be the sole responsibility of the buyer and conducted at their expense." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Other" ] +"CityRegion": "Industrial Sector" +"CommunityFeatures": array:1 [ 0 => "Major Highway" ] +"Cooling": array:1 [ 0 => "No" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-16T00:00:39.010771+00:00" +"CrossStreet": "Burlington St.,E & Victoria Ave., N" +"ExpirationDate": "2025-04-30" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-15" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "348800" +"MajorChangeTimestamp": "2025-01-15T20:58:58Z" +"MlsStatus": "New" +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2025-01-15T20:58:59Z" +"OriginalListPrice": 2100000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1864018" +"ParcelNumber": "171900008" +"PhotosChangeTimestamp": "2025-01-18T14:40:08Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:3 [ 0 => "Showing System" 1 => "List Brokerage" 2 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Burlington" +"StreetNumber": "350" +"StreetSuffix": "Street" +"TaxAnnualAmount": "10257.0" +"TaxAssessedValue": 302000 +"TaxLegalDescription": "CON 1 PT LOT 12 BTN HAM RP 62R1871 PART 1" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "M6" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Free Standing" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 150.0 +"HeatType": "Radiant" +"LotShape": "Rectangular" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11925452')" +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Yes" ] +"MortgageComment": "Treat as Clear" +"RollNumber": "251803022505820" +"AssessmentYear": 2024 +"SystemModificationTimestamp": "2025-02-14T18:58:28.670811Z" +"provider_name": "TRREB" +"LotDepth": 165.0 +"PossessionDetails": "Flexible" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Outside/Surface" +"PriorMlsStatus": "Draft" +"IndustrialAreaCode": "Sq Ft" +"MediaChangeTimestamp": "2025-01-30T15:21:14Z" +"TaxType": "Annual" +"HoldoverDays": 60 +"PossessionDate": "2025-03-31" +"Media": array:1 [ 0 => array:26 [ "ResourceRecordKey" => "X11925452" "MediaModificationTimestamp" => "2025-01-18T14:40:08.367402Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11925452/thumbnail-bb6fd2a17b4dc651d076bd93491202c4.webp" "ShortDescription" => null "MediaKey" => "79d3bc48-e22f-4c6b-af1a-2e2b1e440a21" "ImageWidth" => 1200 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-18T14:40:08.367402Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "79d3bc48-e22f-4c6b-af1a-2e2b1e440a21" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11925452/bb6fd2a17b4dc651d076bd93491202c4.webp" "MediaSize" => 79553 "SourceSystemMediaKey" => "79d3bc48-e22f-4c6b-af1a-2e2b1e440a21" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 672 ] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14449 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11924365" +"ListingId": "X11924365" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T18:50:44Z" +"RFModificationTimestamp": "2025-03-30T11:23:56Z" +"ListPrice": 445000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5200.0 +"City": "Hamilton" +"PostalCode": "L8G 1B7" +"UnparsedAddress": "940 Queenston Road, Hamilton, On L8g 1b7" +"Coordinates": array:2 [ 0 => -79.7528294 1 => 43.2250433 ] +"Latitude": 43.2250433 +"Longitude": -79.7528294 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ULTIMATE REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "MULTIPLE INCOME STREAMS!!! Beloved and Well Established Restaurant & Banquet Hall with extremely loyal following in Stoney Creek. Easy accessibility, plenty of parking and excellent visibility. Sharp Industry Veterans can simultaneously run the banquet hall while operating the restaurant space in the front. Restaurant space itself also features a fully private dining area so 2-3 events can be run on-site at the same time. **EXTRAS** on-site at the same time. Rent $5,229. Lease expires June 30, 2027." +"BuildingAreaUnits": "Square Feet" +"BusinessName": "SPASSO" +"BusinessType": array:1 [ 0 => "Restaurant" ] +"CityRegion": "Stoney Creek" +"CommunityFeatures": array:2 [ 0 => "Major Highway" 1 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-15T19:20:44.599417+00:00" +"CrossStreet": "HWY 8 & Lake Ave. N" +"ExpirationDate": "2025-04-15" +"HoursDaysOfOperation": array:1 [ 0 => "Open 3 Days" ] +"HoursDaysOfOperationDescription": "4-10" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-15" +"MainOfficeKey": "498700" +"MajorChangeTimestamp": "2025-01-15T15:23:52Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 15 +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-15T15:23:52Z" +"OriginalListPrice": 445000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1863974" +"PhotosChangeTimestamp": "2025-01-15T15:23:52Z" +"SeatingCapacity": "243" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"Sewer": array:1 [ 0 => "Sanitary+Storm" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Queenston" +"StreetNumber": "940" +"StreetSuffix": "Road" +"TaxYear": "2024" +"TransactionBrokerCompensation": "4% + HST on the Final Sale Price" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Available" ] +"Zoning": "Commercial / Retail" +"Water": "Municipal" +"LiquorLicenseYN": true +"WashroomsType1": 3 +"DDFYN": true +"LotType": "Unit" +"PropertyUse": "Without Property" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11924365')" +"HSTApplication": array:1 [ 0 => "No" ] +"RetailArea": 5200.0 +"ChattelsYN": true +"SystemModificationTimestamp": "2025-02-14T18:50:44.301044Z" +"provider_name": "TRREB" +"PossessionDetails": "TBA" +"ShowingAppointments": "Brokerbay" +"OutsideStorageYN": true +"GarageType": "Plaza" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-15T15:23:52Z" +"TaxType": "N/A" +"HoldoverDays": 180 +"ElevatorType": "None" +"RetailAreaCode": "Sq Ft" +"Media": array:4 [ 0 => array:26 [ "ResourceRecordKey" => "X11924365" "MediaModificationTimestamp" => "2025-01-15T15:23:52.319083Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11924365/thumbnail-746062fdcb4572f91ae17cf6cef76894.webp" "ShortDescription" => null "MediaKey" => "b2e96212-39ad-49f9-8db3-a4574a9cd7b3" "ImageWidth" => 1440 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-15T15:23:52.319083Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "b2e96212-39ad-49f9-8db3-a4574a9cd7b3" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11924365/746062fdcb4572f91ae17cf6cef76894.webp" "MediaSize" => 223364 "SourceSystemMediaKey" => "b2e96212-39ad-49f9-8db3-a4574a9cd7b3" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 813 ] 1 => array:26 [ "ResourceRecordKey" => "X11924365" "MediaModificationTimestamp" => "2025-01-15T15:23:52.319083Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11924365/thumbnail-fd4a843a19c7a3a327bf8cfeec8a425a.webp" "ShortDescription" => null "MediaKey" => "ff0dd264-fe67-4489-8e91-db86878f65eb" "ImageWidth" => 2958 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-15T15:23:52.319083Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "ff0dd264-fe67-4489-8e91-db86878f65eb" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11924365/fd4a843a19c7a3a327bf8cfeec8a425a.webp" "MediaSize" => 1631171 "SourceSystemMediaKey" => "ff0dd264-fe67-4489-8e91-db86878f65eb" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 3024 ] 2 => array:26 [ "ResourceRecordKey" => "X11924365" "MediaModificationTimestamp" => "2025-01-15T15:23:52.319083Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11924365/thumbnail-cc913afba2e805c96bd9176cdc6de4e6.webp" "ShortDescription" => null "MediaKey" => "96a11f0f-6d64-443c-87be-9ee9de795eb4" "ImageWidth" => 4032 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-15T15:23:52.319083Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "96a11f0f-6d64-443c-87be-9ee9de795eb4" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11924365/cc913afba2e805c96bd9176cdc6de4e6.webp" "MediaSize" => 1437126 "SourceSystemMediaKey" => "96a11f0f-6d64-443c-87be-9ee9de795eb4" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2268 ] 3 => array:26 [ "ResourceRecordKey" => "X11924365" "MediaModificationTimestamp" => "2025-01-15T15:23:52.319083Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11924365/thumbnail-b16bfb3a841ce9613aae8a3e84df482b.webp" "ShortDescription" => null "MediaKey" => "8cf20877-f40d-4010-8819-8d2df5baef36" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-15T15:23:52.319083Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8cf20877-f40d-4010-8819-8d2df5baef36" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11924365/b16bfb3a841ce9613aae8a3e84df482b.webp" "MediaSize" => 1588427 "SourceSystemMediaKey" => "8cf20877-f40d-4010-8819-8d2df5baef36" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14450 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11961161" +"ListingId": "X11961161" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T18:46:39Z" +"RFModificationTimestamp": "2025-04-18T15:23:08Z" +"ListPrice": 1749000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 6.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8B 1Y9" +"UnparsedAddress": "76 Elstone Place, Hamilton, On L8b 1y9" +"Coordinates": array:2 [ 0 => -79.873776158221 1 => 43.3377955606 ] +"Latitude": 43.3377955606 +"Longitude": -79.873776158221 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX GOLD REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 76 Elstone place. This 5-bedroom 4 Washroom detached home with Ravine lot that sits in a desirable neighborhood. Upon entry into this sophisticated home, you'll be greeted with 10 feet ceilings that carry into the formal living room and dining room. Enjoy your morning in a beautiful kitchen with walkout to the deck. The open concept living room is filled with sunlight with a cozy fire place. As we walk up through wood staircase, we are greeted with a perfect Ensuite to unwind with double sinks and free-standing tub, as well as walk-in closet. Heading down to the 9ft ceiling basement, offering large costume windows is an incredible bonus. Turn your basement into perfect entertainment place, or even a personal gym with side entrance. It's a perfect place to start your new chapter! Side entrance from Builder" +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Separate Entrance" 1 => "Unfinished" ] +"CityRegion": "Waterdown" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Stucco (Plaster)" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "2.0" +"CreationDate": "2025-02-07T11:45:16.765097+00:00" +"CrossStreet": "Great Fls Blvd and Skinner Rd" +"DirectionFaces": "North" +"ExpirationDate": "2025-09-30" +"FireplaceYN": true +"FoundationDetails": array:1 [ 0 => "Other" ] +"Inclusions": "Fridge, stove, D/W, Washer/Dryer, Curtains, Binds, and all light Fixtures attached." +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-02-05" +"MainOfficeKey": "187100" +"MajorChangeTimestamp": "2025-02-06T23:15:38Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-02-06T23:15:39Z" +"OriginalListPrice": 1749000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1942894" +"ParkingFeatures": array:1 [ 0 => "Available" ] +"ParkingTotal": "6.0" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Other" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Elstone" +"StreetNumber": "76" +"StreetSuffix": "Place" +"TaxAnnualAmount": "9351.0" +"TaxLegalDescription": "LOT 175 PLAN 62M1266" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5%" +"TransactionType": "For Sale" +"Water": "Municipal" +"RoomsAboveGrade": 10 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "3000-3500" +"HeatSource": "Gas" +"ContractStatus": "Available" +"PropertyFeatures": array:6 [ 0 => "Fenced Yard" 1 => "Hospital" 2 => "Library" 3 => "Park" 4 => "Public Transit" 5 => "Ravine" ] +"WashroomsType4Pcs": 5 +"LotWidth": 44.29 +"HeatType": "Forced Air" +"WashroomsType4Level": "Upper" +"WashroomsType3Pcs": 3 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11961161')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Included In" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"SystemModificationTimestamp": "2025-02-14T18:46:39.210388Z" +"provider_name": "TRREB" +"LotDepth": 107.19 +"ParkingSpaces": 4 +"PossessionDetails": "TBD" +"PermissionToContactListingBrokerToAdvertise": true +"BedroomsBelowGrade": 1 +"GarageType": "Attached" +"PriorMlsStatus": "Draft" +"WashroomsType2Level": "Upper" +"BedroomsAboveGrade": 5 +"MediaChangeTimestamp": "2025-02-12T21:50:57Z" +"WashroomsType2Pcs": 4 +"RentalItems": "Hot Water Tank" +"DenFamilyroomYN": true +"ApproximateAge": "0-5" +"HoldoverDays": 90 +"LaundryLevel": "Upper Level" +"WashroomsType3": 1 +"WashroomsType3Level": "Upper" +"WashroomsType4": 1 +"KitchensTotal": 1 } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14451 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11918563" +"ListingId": "X11918563" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T18:19:35Z" +"RFModificationTimestamp": "2025-05-06T07:45:48Z" +"ListPrice": 324900.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2080.0 +"City": "Hamilton" +"PostalCode": "L0R 2H6" +"UnparsedAddress": "##4 - 287 Dundas Street, Hamilton, On L0r 2h6" +"Coordinates": array:2 [ 0 => -79.9468008 1 => 43.2643777 ] +"Latitude": 43.2643777 +"Longitude": -79.9468008 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX GOLD REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "***Pharmacy For Sale in Waterdown with Walk-In Clinic having 4 Doctors*** Excellent Opportunity To Own A Well Established Turn Key Business on Busy Dundas St E with High Street Exposure, Pharmacy with Medical Walk-in Clinic & Protein Sales and extra space to add more services, Thousands of New and existing Homes and many Multi Storey Buildings around, and Very Fast Growing Town, Easy Road & Hwy Access, Public Transit on Door Steps, Free Onsite Parking, Busy Area with All Major Food & Retail Franchise Stores, The Ground Floor Unit, Pharmacy With Counters, Display, Counselling Rm, Office & A Washroom and Medical Walk-in Clinic with Reception, 4 Rooms & 2 Washrooms, Low Rent, Lots of opportunities to Grow the business. ***ALL VISITS BY APPOINTMENT ONLY *** PLEASE DO NOT GO DIRECT & DON'T TALK TO EMPLOYEES*** **EXTRAS** Great Location In The Heart Of Waterdown, Busy Street, Surrounded By Residential Neighborhoods, Business For Sale In Leased Premises Medical Clinic Sub Leased, Inventory Not Included, Easily Accessible From Major Roads & Hwys 6, 403 & 407." +"BuildingAreaUnits": "Square Feet" +"BusinessName": "Waterdown Village Pharmacy" +"BusinessType": array:1 [ 0 => "Retail Store Related" ] +"CityRegion": "Waterdown" +"CommunityFeatures": array:2 [ 0 => "Major Highway" 1 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-11T06:40:45.225316+00:00" +"CrossStreet": "Dundas St E & Hamilton St" +"Exclusions": "Inventory is not included in the price. *** PLEASE DO NOT GO DIRECT & DON'T TALK TO EMPLOYEES***" +"ExpirationDate": "2025-06-30" +"HoursDaysOfOperation": array:1 [ 0 => "Open 6 Days" ] +"HoursDaysOfOperationDescription": "9AM - 6PM" +"Inclusions": "Business for Sale in Leased Premises. All Business Chattels (Pharmacy and walk-in Clinic) are Included in the price. A list will be provided after the offer is accepted. *** PLEASE DO NOT GO DIRECT & DON'T TALK TO EMPLOYEES***" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-01-10" +"MainOfficeKey": "187100" +"MajorChangeTimestamp": "2025-01-11T00:20:37Z" +"MlsStatus": "New" +"NumberOfFullTimeEmployees": 3 +"OccupantType": "Owner+Tenant" +"OriginalEntryTimestamp": "2025-01-11T00:20:38Z" +"OriginalListPrice": 324900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1849848" +"ParcelNumber": "175070149" +"PhotosChangeTimestamp": "2025-01-14T16:39:59Z" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"Sewer": array:1 [ 0 => "Sanitary+Storm" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Dundas" +"StreetNumber": "287" +"StreetSuffix": "Street" +"TaxAnnualAmount": "12.14" +"TaxYear": "2025" +"TransactionBrokerCompensation": "4%" +"TransactionType": "For Sale" +"UnitNumber": "#4" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "Commercial Use" +"Water": "Municipal" +"WashroomsType1": 3 +"DDFYN": true +"LotType": "Unit" +"PropertyUse": "Multi-Use" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"Amps": 200 +"HeatType": "Gas Forced Air Open" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11918563')" +"HandicappedEquippedYN": true +"HSTApplication": array:1 [ 0 => "Yes" ] +"RetailArea": 100.0 +"SystemModificationTimestamp": "2025-02-14T18:19:35.602008Z" +"provider_name": "TRREB" +"Volts": 600 +"PossessionDetails": "60 days/Flex" +"PermissionToContactListingBrokerToAdvertise": true +"ShowingAppointments": "Brokerbay/LBO" +"GarageType": "Outside/Surface" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-14T16:39:59Z" +"TaxType": "TMI" +"HoldoverDays": 180 +"FranchiseYN": true +"RetailAreaCode": "%" +"Media": array:40 [ 0 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.129336Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-b9ecb083945e662109b447252e43ba89.webp" "ShortDescription" => null "MediaKey" => "5faccd2a-2a16-4727-95b2-60bae33f98a7" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.129336Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "5faccd2a-2a16-4727-95b2-60bae33f98a7" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/b9ecb083945e662109b447252e43ba89.webp" "MediaSize" => 1814586 "SourceSystemMediaKey" => "5faccd2a-2a16-4727-95b2-60bae33f98a7" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 2880 ] 1 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:58.53367Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-a54464619881f7c2cff30b429fba554c.webp" "ShortDescription" => null "MediaKey" => "76917797-46a2-4e4d-83cd-88df54831f83" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:58.53367Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "76917797-46a2-4e4d-83cd-88df54831f83" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/a54464619881f7c2cff30b429fba554c.webp" "MediaSize" => 1768329 "SourceSystemMediaKey" => "76917797-46a2-4e4d-83cd-88df54831f83" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 2 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:58.564388Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-6219e74bcc178e9160577ebd6cdeaae7.webp" "ShortDescription" => null "MediaKey" => "a13b81e3-508f-48f2-81c0-3ab71085f946" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:58.564388Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a13b81e3-508f-48f2-81c0-3ab71085f946" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/6219e74bcc178e9160577ebd6cdeaae7.webp" "MediaSize" => 1651349 "SourceSystemMediaKey" => "a13b81e3-508f-48f2-81c0-3ab71085f946" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 3 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.295564Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-a6a6a01ad216581ac1c247728285b4d1.webp" "ShortDescription" => null "MediaKey" => "d783e2bd-9b1e-4d25-bf82-43d738c603e3" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.295564Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "d783e2bd-9b1e-4d25-bf82-43d738c603e3" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/a6a6a01ad216581ac1c247728285b4d1.webp" "MediaSize" => 1753034 "SourceSystemMediaKey" => "d783e2bd-9b1e-4d25-bf82-43d738c603e3" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 4 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.34991Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-7d5ca311ba5373a75ec9c2e4bcb7a243.webp" "ShortDescription" => null "MediaKey" => "5d68a22c-03d8-4c4d-ae55-054544139b10" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.34991Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "5d68a22c-03d8-4c4d-ae55-054544139b10" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/7d5ca311ba5373a75ec9c2e4bcb7a243.webp" "MediaSize" => 1831867 "SourceSystemMediaKey" => "5d68a22c-03d8-4c4d-ae55-054544139b10" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 5 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.403918Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-bf4af76eed63c7ec2d6c9f1cc841d647.webp" "ShortDescription" => null "MediaKey" => "9db6e95d-d2ce-4904-9daf-6b92847c303d" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.403918Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "9db6e95d-d2ce-4904-9daf-6b92847c303d" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/bf4af76eed63c7ec2d6c9f1cc841d647.webp" "MediaSize" => 1783146 "SourceSystemMediaKey" => "9db6e95d-d2ce-4904-9daf-6b92847c303d" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 6 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.458724Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-d25fd15da83bcfca8012e876a8bfb41d.webp" "ShortDescription" => null "MediaKey" => "7c4c41e6-5df2-4279-951f-40e4932877f4" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.458724Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "7c4c41e6-5df2-4279-951f-40e4932877f4" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/d25fd15da83bcfca8012e876a8bfb41d.webp" "MediaSize" => 1443748 "SourceSystemMediaKey" => "7c4c41e6-5df2-4279-951f-40e4932877f4" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 7 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.51259Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-865d4b036c7acc2c366af54309edddc8.webp" "ShortDescription" => null "MediaKey" => "0e5bdaed-887e-4c5b-9211-98ce9d1598b4" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.51259Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "0e5bdaed-887e-4c5b-9211-98ce9d1598b4" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/865d4b036c7acc2c366af54309edddc8.webp" "MediaSize" => 1275652 "SourceSystemMediaKey" => "0e5bdaed-887e-4c5b-9211-98ce9d1598b4" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 8 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.566364Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-6677af2c06a3221e6705ade287b4a1e9.webp" "ShortDescription" => null "MediaKey" => "84e95134-ec49-4c12-9d06-91029d44459a" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.566364Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "84e95134-ec49-4c12-9d06-91029d44459a" "Order" => 8 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/6677af2c06a3221e6705ade287b4a1e9.webp" "MediaSize" => 1708093 "SourceSystemMediaKey" => "84e95134-ec49-4c12-9d06-91029d44459a" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 9 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.620639Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-847dd6e288f8c98038f970a77564607b.webp" "ShortDescription" => null "MediaKey" => "e024790b-de62-4890-8ba3-f933250b0a1f" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.620639Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "e024790b-de62-4890-8ba3-f933250b0a1f" "Order" => 9 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/847dd6e288f8c98038f970a77564607b.webp" "MediaSize" => 1729104 "SourceSystemMediaKey" => "e024790b-de62-4890-8ba3-f933250b0a1f" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 10 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.674614Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-a809fdc8664e3cb74b7318cb825bd6c8.webp" "ShortDescription" => null "MediaKey" => "03f61453-d4ba-42e8-9222-4e6a2f49a5a9" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.674614Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "03f61453-d4ba-42e8-9222-4e6a2f49a5a9" "Order" => 10 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/a809fdc8664e3cb74b7318cb825bd6c8.webp" "MediaSize" => 1309765 "SourceSystemMediaKey" => "03f61453-d4ba-42e8-9222-4e6a2f49a5a9" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 11 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.728636Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-09fd58014df47be2a6aca4c96c819995.webp" "ShortDescription" => null "MediaKey" => "a5e250fe-e221-4132-9308-7d4d701497ce" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.728636Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a5e250fe-e221-4132-9308-7d4d701497ce" "Order" => 11 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/09fd58014df47be2a6aca4c96c819995.webp" "MediaSize" => 1633426 "SourceSystemMediaKey" => "a5e250fe-e221-4132-9308-7d4d701497ce" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 12 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.783721Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-9bbaa6719e163335443ecda89e3f49ff.webp" "ShortDescription" => null "MediaKey" => "8af77972-5415-4fa8-97b9-ba545278fde5" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.783721Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8af77972-5415-4fa8-97b9-ba545278fde5" "Order" => 12 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/9bbaa6719e163335443ecda89e3f49ff.webp" "MediaSize" => 1870510 "SourceSystemMediaKey" => "8af77972-5415-4fa8-97b9-ba545278fde5" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 13 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.842007Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-1643a6f2b2e0ff772fb733485b12f6d0.webp" "ShortDescription" => null "MediaKey" => "5b47257a-4714-429f-a726-2c790f84bf49" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.842007Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "5b47257a-4714-429f-a726-2c790f84bf49" "Order" => 13 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/1643a6f2b2e0ff772fb733485b12f6d0.webp" "MediaSize" => 1794569 "SourceSystemMediaKey" => "5b47257a-4714-429f-a726-2c790f84bf49" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 14 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.898671Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-cff1c1ff439db56a158b6770a71ab0d9.webp" "ShortDescription" => null "MediaKey" => "aa94663c-1282-4057-bae6-2ce1cf279344" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.898671Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "aa94663c-1282-4057-bae6-2ce1cf279344" "Order" => 14 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/cff1c1ff439db56a158b6770a71ab0d9.webp" "MediaSize" => 946659 "SourceSystemMediaKey" => "aa94663c-1282-4057-bae6-2ce1cf279344" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 15 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:40.957853Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-64d932bbe548d9ca4360093de30a7293.webp" "ShortDescription" => null "MediaKey" => "8796c15b-ebaa-4dd6-8ca4-c63b70e8c37c" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:40.957853Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "8796c15b-ebaa-4dd6-8ca4-c63b70e8c37c" "Order" => 15 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11918563/64d932bbe548d9ca4360093de30a7293.webp" "MediaSize" => 899042 "SourceSystemMediaKey" => "8796c15b-ebaa-4dd6-8ca4-c63b70e8c37c" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2880 ] 16 => array:26 [ "ResourceRecordKey" => "X11918563" "MediaModificationTimestamp" => "2025-01-14T16:39:41.012098Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11918563/thumbnail-0c011a619b79b9ca772a2fbeb017a7d9.webp" "ShortDescription" => null "MediaKey" => "99ccad76-91c7-44c8-90c5-a41ce180c41e" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-14T16:39:41.012098Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" …10 ] 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] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14452 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9257068" +"ListingId": "X9257068" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T18:03:56Z" +"RFModificationTimestamp": "2025-02-15T04:28:54Z" +"ListPrice": 15500000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1750.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9G 3K9" +"UnparsedAddress": "1048 E Garner Rd, Hamilton, Ontario L9G 3K9" +"Coordinates": array:2 [ 0 => -79.9347709 1 => 43.2092977 ] +"Latitude": 43.2092977 +"Longitude": -79.9347709 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "KELLER WILLIAMS EDGE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention Developers and Builders! Land banking opportunity just across from new residential development. 19.5 acre land parcel surrounded by Residential redevelopment and schools. Close to John C Munro airport and 403 interchange. Lot sizes as per plan provided by Seller. Stream running through part of land. A2 Zoning. Note: two parcels being sold together with two access points off Garner Rd. Please do not walk property without notifying Listing Brokerage." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Full" 1 => "Partially Finished" ] +"CityRegion": "Airport Employment Area" +"CoListOfficeKey": "190600" +"CoListOfficeName": "KELLER WILLIAMS EDGE REALTY" +"CoListOfficePhone": "905-335-8808" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "None" ] +"CountyOrParish": "Hamilton" +"CoveredSpaces": "1.0" +"CreationDate": "2024-08-17T16:16:12.268975+00:00" +"CrossStreet": "Garner/Glancaster" +"DirectionFaces": "East" +"ExpirationDate": "2025-08-15" +"FoundationDetails": array:1 [ 0 => "Concrete Block" ] +"InteriorFeatures": array:2 [ 0 => "Primary Bedroom - Main Floor" 1 => "In-Law Capability" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2024-08-15" +"MainOfficeKey": "190600" +"MajorChangeTimestamp": "2025-02-13T15:36:07Z" +"MlsStatus": "Extension" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-08-16T01:06:46Z" +"OriginalListPrice": 15500000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1376880" +"ParcelNumber": "170810045" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "11.0" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Garner" +"StreetNumber": "1048" +"StreetSuffix": "Road" +"TaxAnnualAmount": "9638.0" +"TaxAssessedValue": 404000 +"TaxLegalDescription": "*See Supplements" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2.0" +"TransactionType": "For Sale" +"Zoning": "A2" +"Area Code": "07" +"Assessment": "404000" +"Municipality Code": "07.01" +"Approx Age": "51-99" +"Approx Square Footage": "1500-2000" +"Assessment Year": "2024" +"Kitchens": "1" +"Elevator": "N" +"Drive": "Pvt Double" +"Seller Property Info Statement": "N" +"class_name": "ResidentialProperty" +"Retirement": "N" +"Parcel of Tied Land": "N" +"Municipality District": "Hamilton" +"Special Designation1": "Unknown" +"Community Code": "07.01.0170" +"Sewers": "Septic" +"Fronting On (NSEW)": "E" +"Lot Front": "0.00" +"Possession Remarks": "Flexible" +"Type": ".D." +"UFFI": "No" +"Heat Source": "Gas" +"Garage Spaces": "1.0" +"Green Property Information Statement": "N" +"Energy Certification": "N" +"lease": "Sale" +"Lot Depth": "19.50" +"Link": "N" +"Water": "Municipal" +"RoomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"LivingAreaRange": "1500-2000" +"ExtensionEntryTimestamp": "2025-02-13T15:36:07Z" +"HeatSource": "Gas" +"ContractStatus": "Available" +"RoomsBelowGrade": 1 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9257068')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"RollNumber": "251814042027100" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"SystemModificationTimestamp": "2025-02-14T18:03:56.827182Z" +"provider_name": "TRREB" +"LotDepth": 19.5 +"ParkingSpaces": 10 +"PossessionDetails": "Flexible" +"PermissionToContactListingBrokerToAdvertise": true +"LotSizeRangeAcres": "10-24.99" +"BedroomsBelowGrade": 1 +"GarageType": "Detached" +"ParcelOfTiedLand": "No" +"PriorMlsStatus": "New" +"BedroomsAboveGrade": 3 +"RentalItems": "Hot Water Heater, Furnance" +"ApproximateAge": "51-99" +"HoldoverDays": 60 +"KitchensTotal": 1 } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14453 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11904388" +"ListingId": "X11904388" +"PropertyType": "Commercial Sale" +"PropertySubType": "Store W Apt/Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T17:17:19Z" +"RFModificationTimestamp": "2025-04-18T15:54:39Z" +"ListPrice": 1495000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5227.0 +"City": "Hamilton" +"PostalCode": "L8R 1H1" +"UnparsedAddress": "29 John Street, Hamilton, On L8r 1h1" +"Coordinates": array:2 [ 0 => -75.542465857143 1 => 42.826079714286 ] +"Latitude": 42.826079714286 +"Longitude": -75.542465857143 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "HOME STANDARDS BRICKSTONE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 3 Storey Brick Office Building With 1st Floor Commercial Unit, Busy Brunch Restaurant. 2nd Floor Leased Apartment with 2 Bedroom & 1 Washroom Over 1,500 Sqft. 3rd Floor Apartment with Rough-In. This Corner Building is Close To Highway & Public Transit, Location Has Potential Growth Opportunity. Don't Miss This Incredible Investment Property! **EXTRAS** Do Not Go Direct To Property Or Speak With Tenants Or Staff. Treat Financing As Clear. Commercial Unit and Residential Units Need 24 Hrs Notice. Showing Times For Units 10am-2pm." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Beasley" +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T07:11:11.975422+00:00" +"CrossStreet": "St. John St. and Main St." +"ExpirationDate": "2025-07-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"MainOfficeKey": "263000" +"MajorChangeTimestamp": "2025-01-02T18:08:22Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-02T18:08:23Z" +"OriginalListPrice": 1495000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1815746" +"PhotosChangeTimestamp": "2025-01-02T18:08:23Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "John" +"StreetNumber": "29" +"StreetSuffix": "Street" +"TaxAnnualAmount": "12734.86" +"TaxLegalDescription": "PT LT 25 NATHANIEL HUGHSON SURVEY (UNREGISTERED) S/S KING WILLIAM ST BTN HUGHSON ST & JOHN ST, AS IN CD39051; CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5%+HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Available" ] +"Zoning": "Mixed (Commercial and Residential)" +"Water": "Municipal" +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Store With Apt/Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 22.72 +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904388')" +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Included" ] +"RetailArea": 1742.0 +"SystemModificationTimestamp": "2025-02-14T17:17:19.846403Z" +"provider_name": "TRREB" +"LotDepth": 79.64 +"PossessionDetails": "TBD" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Outside/Surface" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-02T18:08:23Z" +"TaxType": "Annual" +"HoldoverDays": 90 +"FinancialStatementAvailableYN": true +"ElevatorType": "None" +"RetailAreaCode": "Sq Ft" +"OfficeApartmentArea": 3495.0 +"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] ] } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14454 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11973217" +"ListingId": "X11973217" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-02-14T16:45:48Z" +"RFModificationTimestamp": "2025-03-30T14:36:18Z" +"ListPrice": 14.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5817.0 +"City": "Hamilton" +"PostalCode": "L8L 3C4" +"UnparsedAddress": "959 Barton Street, Hamilton, On L8l 3c4" +"Coordinates": array:2 [ 0 => -79.67374155492 1 => 43.216329701664 ] +"Latitude": 43.216329701664 +"Longitude": -79.67374155492 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime Commercial Space for Lease - High-Traffic Barton Street East. Don't miss this incredible opportunity to establish your business in a prime commercial space on bustling Barton Street in Hamilton. Located in a high-exposure area with steady pedestrian and vehicle traffic, this property is ideal for retail or service based businesses. Grab the chance to grow your business in one of Hamilton's busiest corridors." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Retail Store Related" ] +"CityRegion": "Crown Point" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-03-30T11:40:10.629739+00:00" +"CrossStreet": "East of Gage Ave, on Barton" +"ExpirationDate": "2025-06-30" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListAOR": "Toronto Regional Real Estate Board" +"ListingContractDate": "2025-02-13" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-02-14T16:45:48Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-02-14T16:45:48Z" +"OriginalListPrice": 14.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1975694" +"ParcelNumber": "172200138" +"PhotosChangeTimestamp": "2025-02-14T16:45:48Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "Barton" +"StreetNumber": "959" +"StreetSuffix": "Street" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST of Total Net Lease Amount" +"TransactionType": "For Lease" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "C5" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Retail" +"ContractStatus": "Available" +"ListPriceUnit": "Per Sq Ft" +"LotWidth": 40.08 +"HeatType": "Gas Forced Air Open" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11973217')" +"RollNumber": "251804028602160" +"MinimumRentalTermMonths": 12 +"RetailArea": 5817.0 +"SystemModificationTimestamp": "2025-02-14T16:45:48.496364Z" +"provider_name": "TRREB" +"LotDepth": 100.26 +"MaximumRentalMonthsTerm": 24 +"PermissionToContactListingBrokerToAdvertise": true +"ShowingAppointments": "905-592-7777" +"GarageType": "None" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-02-14T16:45:48Z" +"TaxType": "N/A" +"ApproximateAge": "51-99" +"UFFI": "No" +"HoldoverDays": 90 +"RetailAreaCode": "Sq Ft" +"PossessionDate": "2025-04-01" +"short_address": "Hamilton, ON L8L 3C4, CA" +"Media": array:7 [ 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] ] } ] +success: true +page_size: 10 +page_count: 406 +count: 4055 +after_key: "" } ] ]
