array:2 [
"RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=94266&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=94266&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=94266&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=94266&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14238
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14243
+post_id: "165607"
+post_author: 1
+"ListingKey": "X10403362"
+"ListingId": "X10403362"
+"PropertyType": "Commercial"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:20:34Z"
+"RFModificationTimestamp": "2025-04-25T20:50:47Z"
+"ListPrice": 24.3
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 10000.0
+"City": "Hamilton"
+"PostalCode": "L8P 4Y4"
+"UnparsedAddress": "10 George Street Unit 300, Hamilton, On L8p 4y4"
+"Coordinates": array:2 [
0 => -79.8758562
1 => 43.2576852
]
+"Latitude": 43.2576852
+"Longitude": -79.8758562
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Move-in ready! Contemporary office space near the corner of Bay and George. Hamilton's Textile Building is a completely rebuilt office building that mixes Hamilton's industrial charm with modern design elements. A former warehouse that retains its brick & beam construction, this Hamilton landmark has become a jewel among Hamilton's office spaces. A four-storey atrium and marble-encased elevator treat your eyes as your enter the lobby and secure fob access controls elevator and unit entry. This third-floor unit offers 10,000 square feet of space and provides glass-enclosed meeting rooms and offices, as well as an open concept central office area. The unit also includes a large kitchenette, break room and private washrooms. Hardwood floors, exposed ductwork and brick, glass boardroom and office walls, and the building's post and beam construction all add to the unit's invited and comfortable ambience. This ideal location is steps from the financial core, courthouses, City Hall, transit, restaurants, and much more! Note: Furniture in existing photos former tenants' belongings, not included as part of lease offering. 4,440 SF and 5,560 SF options also available."
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "Central"
+"CoListOfficeKey": "541005"
+"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"CoListOfficePhone": "905-296-3930"
+"CommunityFeatures": "Public Transit"
+"Cooling": "Unknown"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-04T05:44:41.942039+00:00"
+"CrossStreet": "On George Street, just up from Bay Street"
+"DaysOnMarket": 440
+"ExpirationDate": "2024-11-29"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-08-01"
+"LotSizeDimensions": "100 x 143.01"
+"MainOfficeKey": "541000"
+"MajorChangeTimestamp": "2024-08-01T11:02:36Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2024-08-01T11:02:36Z"
+"OriginalListPrice": 24.3
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40628246"
+"ParcelNumber": "171430136"
+"PhotosChangeTimestamp": "2024-11-02T17:40:59Z"
+"PoolFeatures": "None"
+"Roof": "Unknown"
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [
0 => "Showing System"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetName": "GEORGE"
+"StreetNumber": "10"
+"StreetSuffix": "Street"
+"TaxBookNumber": "251802012250460"
+"TaxLegalDescription": "PT BLK BTN KING ST, GEORGE ST, BAY ST, CAROLINE ST G.S. TIFFANY SURVEY CITY OF HAMILTON (UNREGISTERED) AS IN VM228950; CITY OF HAMILTON"
+"TransactionBrokerCompensation": "2.5%+HST of total lease base rent"
+"TransactionType": "For Lease"
+"UnitNumber": "300"
+"Utilities": "Unknown"
+"Zoning": "D2 - Downtown Mixed Use"
+"Water": "Municipal"
+"DDFYN": true
+"LotType": "Unknown"
+"PropertyUse": "Unknown"
+"ContractStatus": "Available"
+"ListPriceUnit": "Other"
+"LotWidth": 143.01
+"HeatType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403362')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"MinimumRentalTermMonths": 36
+"AssessmentYear": 2016
+"provider_name": "TRREB"
+"ElevatorYN": true
+"LotDepth": 100.0
+"PossessionDetails": "Immediate"
+"MaximumRentalMonthsTerm": 120
+"LotSizeRangeAcres": "< .50"
+"GarageType": "Unknown"
+"MediaListingKey": "152626783"
+"TaxType": "Unknown"
+"HoldoverDays": 30
+"ElevatorType": "Public"
+"OfficeApartmentArea": 10000.0
+"ID": "165607"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14242
+post_id: "165611"
+post_author: 1
+"ListingKey": "X10403840"
+"ListingId": "X10403840"
+"PropertyType": "Commercial"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:19:13Z"
+"RFModificationTimestamp": "2024-11-17T12:10:01Z"
+"ListPrice": 900000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R 2H0"
+"UnparsedAddress": "287 Dundas E Street, Hamilton, On L0r 2h0"
+"Coordinates": array:2 [
0 => -79.9177691
1 => 43.3122446
]
+"Latitude": 43.3122446
+"Longitude": -79.9177691
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Royal Le Page Meadowtowne Realty Inc., Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Seize this rare opportunity to own a thriving pet supply retail store in the bustling community of Waterdown. This well-established business, which has been operating successfully for 8.5 years, is located in a high-traffic area, ensuring maximum visibility and footfall. The property boasts approximately 1608 sq. ft. of retail space with an open floor plan, featuring designated sections for pet food, toys, accessories, and more. Customers will appreciate the ample space for browsing and the modern fixtures, shelving units, and point-of-sale systems that are included.The store offers dedicated parking with plenty of spaces for both customers and staff. Large storefront windows provide excellent opportunities for attractive product displays and signage. An extensive range of high-quality pet products, including popular brands and unique items, is available, with the inventory included as part of the sale.Situated in a prime retail corridor, the store benefits from significant foot traffic driven by neighbouring businesses. It is also conveniently located near residential neighbourhoods, parks, veterinary clinics, and other pet-related services. With a loyal and growing customer base, a strong reputation in the community, and an active social media presence with a customer loyalty program, this business is poised for continued success. Detailed financials are available upon request for serious inquiries, demonstrating consistent revenue growth and profitability. Competitive pricing is offered for this turnkey operation in a desirable location. Don't miss out on this fantastic business opportunity in the vibrant Waterdown community. Invest in a business that not only brings joy to pets and their owners but also promises a rewarding and profitable venture. Act now and become a part of Waterdown's thriving retail landscape!"
+"BuildingAreaUnits": "Square Feet"
+"BusinessName": "Chews Raw Inc"
+"BusinessType": array:1 [
0 => "Other"
]
+"CityRegion": "Waterdown"
+"CoListOfficeKey": "540403"
+"CoListOfficeName": "Royal Le Page Meadowtowne Realty Inc., Brokerage"
+"CoListOfficePhone": "905-878-8101"
+"Cooling": "Unknown"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-04T05:44:55.943177+00:00"
+"CrossStreet": "Hamilton St and Dundas St"
+"DaysOnMarket": 435
+"DirectionFaces": "South"
+"ExpirationDate": "2025-01-06"
+"HoursDaysOfOperation": array:1 [
0 => "Open 7 Days"
]
+"HoursDaysOfOperationDescription": """
Mon-Fri 10am-7pm\r\n
Sat-10am-5pm\r\n
Sun 11am-4pm
"""
+"Inclusions": "All equipment and inventory"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-08-06"
+"LotSizeDimensions": "x"
+"MainOfficeKey": "540400"
+"MajorChangeTimestamp": "2024-10-08T09:54:46Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2024-08-06T16:15:36Z"
+"OriginalListPrice": 1050000.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40629428"
+"PhotosChangeTimestamp": "2024-11-02T17:39:59Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 1050000.0
+"PriceChangeTimestamp": "2024-10-08T09:54:46Z"
+"Roof": "Unknown"
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": "Unknown"
+"ShowingRequirements": array:1 [
0 => "Showing System"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "DUNDAS"
+"StreetNumber": "287"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "2%"
+"Utilities": "Unknown"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/0190ebdc-62ba-7397-94cd-2af2c414e7ca"
+"Water": "Unknown"
+"PossessionDetails": "30-59Days"
+"DDFYN": true
+"LotType": "Unknown"
+"PropertyUse": "Unknown"
+"GarageType": "Unknown"
+"MediaListingKey": "152701036"
+"Exposure": "North"
+"ContractStatus": "Available"
+"HeatType": "Unknown"
+"TMI": "7898.00"
+"TaxType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403840')"
+"HoldoverDays": 60
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"FinancialStatementAvailableYN": true
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"provider_name": "TRREB"
+"ID": "165611"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14070
+post_id: "165622"
+post_author: 1
+"ListingKey": "X10403402"
+"ListingId": "X10403402"
+"PropertyType": "Commercial"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:12:11Z"
+"RFModificationTimestamp": "2024-11-17T12:14:35Z"
+"ListPrice": 2799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 4600.0
+"City": "Hamilton"
+"PostalCode": "L8V 3L8"
+"UnparsedAddress": "520-522 Upper Sherman Avenue, Hamilton, On L8v 3l8"
+"Coordinates": array:2 [
0 => -79.8499101
1 => 43.2260616
]
+"Latitude": 43.2260616
+"Longitude": -79.8499101
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Real Estate Centre Inc, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Turn key opportunity For Investors & Landlords to Purchase income producing freestanding (Building) Retail Property zoned C2 located in Hamilton. Current Tenant is PT Healthcare Solutions, AAA tenant, physiotherapist Clinic situated in a prime area of Hamilton. The property is fully leased to a single tenant. Property has 10 parking Spots, 5 spots in front & 5 parking spots at the back of the building. Tenant pays all the expenses which includes utility, hydro, taxes & insurance etc. for the the period of 5 years ending in 2028 and Tenant has 3 additional renewal option and lease can be extended for another term of 5 years each after the expiry of lease term in 2028. Condition of the Building is AAA.Do not miss the opportunity. Once It's Gone Cannot Be Replicated. Property is close to Mountain Medical Centre, Juravinski Hospital, St Peter's Hospital, St Joseph Healthcare Hospital."
+"BuildingAreaUnits": "Square Feet"
+"BuildingName": "Pt Health Physiotherapy"
+"CityRegion": "Eastmount"
+"CommunityFeatures": "Public Transit"
+"Cooling": "Unknown"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-04T05:35:55.180985+00:00"
+"CrossStreet": "upper sherman & Brucedale Ave E"
+"DaysOnMarket": 514
+"ExpirationDate": "2024-11-20"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-05-19"
+"LotSizeDimensions": "108.23 x 70.14"
+"MainOfficeKey": "543400"
+"MajorChangeTimestamp": "2024-08-18T11:56:18Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2024-05-19T08:45:40Z"
+"OriginalListPrice": 2899000.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40591612"
+"ParcelNumber": "170590190"
+"PhotosChangeTimestamp": "2024-11-02T17:59:01Z"
+"PoolFeatures": "None"
+"PreviousListPrice": 2899000.0
+"PriceChangeTimestamp": "2024-08-18T11:56:18Z"
+"Roof": "Unknown"
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [
0 => "Showing System"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetName": "UPPER SHERMAN"
+"StreetNumber": "520-522"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "18678.0"
+"TaxAssessedValue": 583000
+"TaxBookNumber": "251807067607660"
+"TaxLegalDescription": "LTS 701 & 702, PL 608 ; HAMILTON"
+"TaxYear": "2023"
+"TransactionBrokerCompensation": "2.5% plus HST"
+"TransactionType": "For Sale"
+"Utilities": "Unknown"
+"Zoning": "C2 COMMERCIAL"
+"Water": "Municipal"
+"DDFYN": true
+"LotType": "Unknown"
+"PropertyUse": "Unknown"
+"ContractStatus": "Available"
+"ListPriceUnit": "For Sale"
+"PropertyFeatures": array:1 [
0 => "Hospital"
]
+"LotWidth": 70.14
+"HeatType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403402')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"MortgageComment": "Treat as clear"
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"AssessmentYear": 2016
+"provider_name": "TRREB"
+"LotDepth": 108.23
+"PossessionDetails": "IMMEDIATE"
+"LotSizeRangeAcres": "< .50"
+"GarageType": "Unknown"
+"MediaListingKey": "150039113"
+"TaxType": "Unknown"
+"UFFI": "No"
+"HoldoverDays": 365
+"ElevatorType": "None"
+"ParkingSpot1": "10"
+"ID": "165622"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14234
+post_id: "165627"
+post_author: 1
+"ListingKey": "X10403394"
+"ListingId": "X10403394"
+"PropertyType": "Commercial"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:08:19Z"
+"RFModificationTimestamp": "2025-04-27T02:50:39Z"
+"ListPrice": 2000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1000.0
+"City": "Hamilton"
+"PostalCode": "L8R 2J9"
+"UnparsedAddress": "12 James N Street Unit 201a, Hamilton, On L8r 2j9"
+"Coordinates": array:2 [
0 => -79.8687264
1 => 43.2570819
]
+"Latitude": 43.2570819
+"Longitude": -79.8687264
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "1,000 square foot office available at the prestigious King-James building! As part of the Core Works Office Suites, the second floor and common area include kitchen, washrooms, boardroom, lounge, and access to the fifth floor common area terrace! The building itself has been completely redeveloped by Core Urban; known for their brilliant combination of preserved heritage features and character with modern features and building systems. Located in the heart of downtown Hamilton, this suite is literal steps away from the major banks, City Hall, the court houses, Mc Master University's downtown campus, the James North Arts district, Jackson Square, and the King William restaurant district!"
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "Beasley"
+"CoListOfficeKey": "541005"
+"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"CoListOfficePhone": "905-296-3930"
+"CommunityFeatures": "Public Transit"
+"Cooling": "Unknown"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-04T05:37:41.864251+00:00"
+"CrossStreet": "On James Street N just up from King Street"
+"DaysOnMarket": 427
+"ExpirationDate": "2024-11-29"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-08-14"
+"LotSizeDimensions": "x 0"
+"MainOfficeKey": "541000"
+"MajorChangeTimestamp": "2024-08-15T10:01:56Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2024-08-15T10:01:56Z"
+"OriginalListPrice": 2000.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40633232"
+"ParcelNumber": "171670249"
+"PhotosChangeTimestamp": "2024-11-02T17:55:30Z"
+"PoolFeatures": "None"
+"Roof": "Unknown"
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": "Sewer"
+"ShowingRequirements": array:3 [
0 => "List Salesperson"
1 => "Showing System"
2 => "List Brokerage"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "JAMES"
+"StreetNumber": "12"
+"StreetSuffix": "Street"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5% + HST of total net rent"
+"TransactionType": "For Lease"
+"UnitNumber": "201A"
+"Utilities": "Unknown"
+"Zoning": "Commercial"
+"Water": "Municipal"
+"PossessionDetails": "Flexible"
+"MaximumRentalMonthsTerm": 60
+"DDFYN": true
+"LotType": "Unknown"
+"LotSizeRangeAcres": "< .50"
+"PropertyUse": "Unknown"
+"GarageType": "Unknown"
+"MediaListingKey": "152936138"
+"ContractStatus": "Available"
+"ListPriceUnit": "Net Lease"
+"HeatType": "Unknown"
+"TaxType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403394')"
+"HoldoverDays": 30
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"MinimumRentalTermMonths": 12
+"provider_name": "TRREB"
+"ID": "165627"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14233
+post_id: "165628"
+post_author: 1
+"ListingKey": "X10404168"
+"ListingId": "X10404168"
+"PropertyType": "Commercial"
+"PropertySubType": "Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:05:40Z"
+"RFModificationTimestamp": "2025-04-25T20:50:47Z"
+"ListPrice": 250000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Norfolk County"
+"PostalCode": "N0A 1N0"
+"UnparsedAddress": "N/a St George Street, Norfolk County, On N0a 1n0"
+"Coordinates": array:2 [
0 => -80.39003
1 => 42.637637
]
+"Latitude": 42.637637
+"Longitude": -80.39003
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Lee & Associates Commercial Real Estate Inc."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": """
Opportunity to invest and develop a custom home in Port Dover! Discover the potential to create your dream home in the charming town of Port Dover. This prime location offers immediate access to Main Street and is just minute away from a variety of amenities in downtown port Dover. Enjoy the convenience of nearby shops, restaurants, and entertainment options, all within a vibrant and friendly community. This investment opportunity provides a perfect blend of small-town charm and modern conveniences, making it an ideal spot for your custom home development. Don't miss out on the chance to be a part of this growing and desirable area!\r\n
\r\n
*Legal Description Continued: COUNTY, The Property Is Being Sold On An "As Is" Basis. Seller is Selling Surface Rights Only (SRO).
"""
+"BuildingAreaUnits": "Square Feet"
+"Cooling": "Unknown"
+"Country": "CA"
+"CountyOrParish": "Haldimand-Norfolk"
+"CreationDate": "2024-11-03T22:31:26.797869+00:00"
+"CrossStreet": "St. George St & Dover Ave"
+"DaysOnMarket": 400
+"ExpirationDate": "2024-12-19"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-09-10"
+"LotSizeDimensions": "189 x 120"
+"MainOfficeKey": "333500"
+"MajorChangeTimestamp": "2024-09-10T14:03:58Z"
+"MlsStatus": "New"
+"OriginalEntryTimestamp": "2024-09-10T14:03:58Z"
+"OriginalListPrice": 250000.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40645055"
+"ParcelNumber": "502410138"
+"PhotosChangeTimestamp": "2024-11-02T20:43:13Z"
+"PoolFeatures": "None"
+"Roof": "Unknown"
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": "Sewer"
+"ShowingRequirements": array:1 [
0 => "List Brokerage"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetName": "ST GEORGE"
+"StreetNumber": "N/A"
+"StreetSuffix": "Street"
+"TaxAssessedValue": 92000
+"TaxBookNumber": "331033402005460"
+"TaxLegalDescription": "PT RAILWAY LT 19 PL 207 SRO PT 4 37R213; NORFOLK COUNTY"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "1.5% + HST"
+"TransactionType": "For Sale"
+"Utilities": "None"
+"Zoning": "R1-A-Residential"
+"Water": "Municipal"
+"PossessionDetails": "TBC"
+"DDFYN": true
+"LotType": "Unknown"
+"LotSizeRangeAcres": "< .50"
+"PropertyUse": "Unknown"
+"GarageType": "Unknown"
+"MediaListingKey": "153815032"
+"Exposure": "West"
+"SoilTest": "No"
+"ContractStatus": "Available"
+"ListPriceUnit": "For Sale"
+"LotWidth": 120.0
+"HeatType": "Unknown"
+"TaxType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404168')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"AssessmentYear": 2024
+"provider_name": "TRREB"
+"LotDepth": 189.0
+"ID": "165628"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14009
+post_id: "165643"
+post_author: 1
+"ListingKey": "X10404078"
+"ListingId": "X10404078"
+"PropertyType": "Commercial"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T18:57:19Z"
+"RFModificationTimestamp": "2025-04-25T20:50:47Z"
+"ListPrice": 1450.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 859.0
+"City": "Hamilton"
+"PostalCode": "L8P 3A2"
+"UnparsedAddress": "148 James S Street Unit Lwr, Hamilton, On L8p 3a2"
+"Coordinates": array:2 [
0 => -79.871071
1 => 43.25242
]
+"Latitude": 43.25242
+"Longitude": -79.871071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to the Stone Terrace heritage district on historic James Street South! Home to many restaurants, bars, and cafes, this is one of Hamilton's premier, burgeoning hospitality districts. A stone's throw to Hamilton's Downtown GO Station and the Cooke Transit Terminal and located in one of Hamilton's most sought after residential neighbourhoods, Durand South. Located steps to St. Joseph's hospital, Core Urban's new 135-unit residential development, as well as the Connolly condo development site and LIUNA's twin tower project at James and Jackson, as well as City Hall, the Hamilton Club, Hamilton's Conservatory for the Arts, the Hamilton Convention Centre. Be among the apartment and office towers in one of the higher-density areas of the city, with young professionals, medical professional, office workers, independent businesses, and homeowner and tenant residents all within walking distance to the site of your business's new home! This lower level is perfect for service retail or coffee shop, ready for your touches. Generous tenant incentive packages available as provided by the landlord. Main floor and lower level can be rented together or separately. Listed rent is gross monthly rent, inclusive of base rent and TMI - subject lease is to be structured as gross plus utilities. Posted rent based on $15.01 PSF net with TMI for 2023 estimated as $5.25 PSF. Gross rent of $20.26 PSF on 859 SF. Come start your next project!"
+"BasementYN": true
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "Corktown"
+"CommunityFeatures": "Public Transit,Park"
+"Cooling": "Unknown"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-03T22:48:45.214383+00:00"
+"CrossStreet": "Located on the west side of James Street South between Bold and Duke streets"
+"DaysOnMarket": 365
+"ExpirationDate": "2025-01-31"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-10-15"
+"LotSizeDimensions": "120 x 24.5"
+"MainOfficeKey": "541000"
+"MajorChangeTimestamp": "2024-10-15T10:06:39Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2024-10-15T10:06:39Z"
+"OriginalListPrice": 1450.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40662723"
+"ParcelNumber": "171710039"
+"PhotosChangeTimestamp": "2024-11-02T19:52:44Z"
+"PoolFeatures": "None"
+"RentIncludes": array:1 [
0 => "Building Insurance"
]
+"Roof": "Unknown"
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": "Sanitary+Storm"
+"ShowingRequirements": array:1 [
0 => "Go Direct"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "JAMES"
+"StreetNumber": "148"
+"StreetSuffix": "Street"
+"TaxAssessedValue": 513000
+"TaxBookNumber": "251802013905340"
+"TaxLegalDescription": "PT LT 14 PL 1270 (AKA P. HAMILTON SURVEY) AS IN CD464174, S/T INTEREST IN VM261396, T/W VM261396; CITY OF HAMILTON"
+"TaxYear": "2022"
+"TransactionBrokerCompensation": "4% of year 1 net rent, 2% of remaining term, cappe"
+"TransactionType": "For Lease"
+"UnitNumber": "Lwr"
+"Utilities": "Unknown"
+"Zoning": "D2 - Downtown Mixed Use - Pedestrian Focus"
+"Water": "Municipal"
+"DDFYN": true
+"LotType": "Unknown"
+"PropertyUse": "Unknown"
+"GasYNA": "Yes"
+"ContractStatus": "Available"
+"ListPriceUnit": "Gross Lease"
+"PropertyFeatures": array:1 [
0 => "Hospital"
]
+"LotWidth": 24.5
+"HeatType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404078')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"MinimumRentalTermMonths": 36
+"RetailArea": 859.0
+"AssessmentYear": 2016
+"provider_name": "TRREB"
+"LotDepth": 120.0
+"PossessionDetails": "Flexible"
+"LotSizeRangeAcres": "< .50"
+"GarageType": "Unknown"
+"MediaListingKey": "154807922"
+"ElectricYNA": "Yes"
+"TaxType": "Unknown"
+"HoldoverDays": 30
+"ID": "165643"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14239
+post_id: "165658"
+post_author: 1
+"ListingKey": "X10403496"
+"ListingId": "X10403496"
+"PropertyType": "Commercial"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T18:41:13Z"
+"RFModificationTimestamp": "2025-04-26T00:02:09Z"
+"ListPrice": 2690.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1200.0
+"City": "Hamilton"
+"PostalCode": "L8R 2J9"
+"UnparsedAddress": "12 James N Street Unit 201h, Hamilton, On L8r 2j9"
+"Coordinates": array:2 [
0 => -79.8687264
1 => 43.2570819
]
+"Latitude": 43.2570819
+"Longitude": -79.8687264
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "1,200 square foot office available at the prestigious King-James building! As part of the Core Works Office Suites, the second floor and common area include kitchen, washrooms, boardroom, lounge, and access to the fifth floor common area terrace! The building itself has been completely redeveloped by Core Urban; known for their brilliant combination of preserved heritage features and character with modern features and building systems. Located in the heart of downtown Hamilton, this suite is literal steps away from the major banks, City Hall, the court houses, Mc Master University's downtown campus, the James North Arts district, Jackson Square, and the King William restaurant district!"
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "Beasley"
+"CoListOfficeKey": "541005"
+"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"CoListOfficePhone": "905-296-3930"
+"CommunityFeatures": "Public Transit"
+"Cooling": "Unknown"
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-03T23:14:58.512254+00:00"
+"CrossStreet": "On James Street N just up from King Street"
+"DaysOnMarket": 427
+"ExpirationDate": "2024-11-29"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-08-14"
+"LotSizeDimensions": "x 0"
+"MainOfficeKey": "541000"
+"MajorChangeTimestamp": "2024-08-15T10:07:35Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2024-08-15T10:07:35Z"
+"OriginalListPrice": 2690.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40633238"
+"ParcelNumber": "171670249"
+"PhotosChangeTimestamp": "2024-11-02T18:48:12Z"
+"PoolFeatures": "None"
+"Roof": "Unknown"
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": "Sewer"
+"ShowingRequirements": array:3 [
0 => "List Salesperson"
1 => "Showing System"
2 => "List Brokerage"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "JAMES"
+"StreetNumber": "12"
+"StreetSuffix": "Street"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5% + HST of total net rent"
+"TransactionType": "For Lease"
+"UnitNumber": "201H"
+"Utilities": "Unknown"
+"Zoning": "Commercial"
+"Water": "Municipal"
+"PossessionDetails": "Flexible"
+"MaximumRentalMonthsTerm": 60
+"DDFYN": true
+"LotType": "Unknown"
+"LotSizeRangeAcres": "< .50"
+"PropertyUse": "Unknown"
+"GarageType": "Unknown"
+"MediaListingKey": "152936238"
+"ContractStatus": "Available"
+"ListPriceUnit": "Net Lease"
+"HeatType": "Unknown"
+"TaxType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403496')"
+"HoldoverDays": 30
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"MinimumRentalTermMonths": 12
+"OfficeApartmentArea": 1200.0
+"provider_name": "TRREB"
+"ID": "165658"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14235
+post_id: "165671"
+post_author: 1
+"ListingKey": "X10402639"
+"ListingId": "X10402639"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T18:23:36Z"
+"RFModificationTimestamp": "2025-04-25T23:22:25Z"
+"ListPrice": 129000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Tay Valley"
+"PostalCode": "K7H 3C6"
+"UnparsedAddress": "516 Christie Lake Road Unit 2, Tay Valley, On K7h 3c6"
+"Coordinates": array:2 [
0 => -76.2920819
1 => 44.8929474
]
+"Latitude": 44.8929474
+"Longitude": -76.2920819
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 SYNERGY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This level, treed ,lot is in Tay Valley Township which is a leader in tiny homes planning. So YES this is where you can feel welcomed creating your efficient living space that you have dreamed of. This terrific lot is minutes from the winner of "the prettiest town in Ontario" award.- Perth. The town has a number of grocery stores, pharmacies, an accredited hospital ,choices of veterinarians, and many other essential services. Perth has an active live music and theatre population and has many festivals and events over the year: Maple Fest , Garlic Festival and a three day Stewart Park music festival that is free to the public thanks in large part to our many fine local merchants. Don't forget the 175 year old Perth Fair. We welcome you to your new home. The lot is awaiting it's PIN and tax assessment"
+"ArchitecturalStyle": "Unknown"
+"Basement": array:1 [
0 => "Unknown"
]
+"CityRegion": "906 - Bathurst/Burgess & Sherbrooke (Bathurst) Twp"
+"ConstructionMaterials": array:1 [
0 => "Unknown"
]
+"Cooling": "Unknown"
+"Country": "CA"
+"CountyOrParish": "Lanark"
+"CreationDate": "2024-11-05T03:40:32.778725+00:00"
+"CrossStreet": "From Perth, take Christie Lake Road to pin #516 on right . Lot 2 is at end of new road on the left --(just past the hydro pole)"
+"DaysOnMarket": 1067
+"DirectionFaces": "South"
+"ExpirationDate": "2024-12-05"
+"FrontageLength": "49.99"
+"Furnished": "[Unknown]"
+"InteriorFeatures": "Unknown"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2022-11-09"
+"MainOfficeKey": "485600"
+"MlsStatus": "New"
+"OriginalEntryTimestamp": "2022-11-09T22:14:56Z"
+"OriginalListPrice": 129000.0
+"OriginatingSystemID": "oreb"
+"OriginatingSystemKey": "1321411"
+"ParcelNumber": "051870218"
+"ParkingFeatures": "Unknown"
+"PetsAllowed": array:1 [
0 => "Unknown"
]
+"PhotosChangeTimestamp": "2024-11-05T03:36:36Z"
+"PoolFeatures": "None"
+"Roof": "Unknown"
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": "None"
+"ShowingRequirements": array:1 [
0 => "List Brokerage"
]
+"SourceSystemID": "oreb"
+"SourceSystemName": "oreb"
+"StateOrProvince": "ON"
+"StreetName": "CHRISTIE LAKE"
+"StreetNumber": "516"
+"StreetSuffix": "Road"
+"TaxLegalDescription": "LOT 2 PT LT 23 CON 3 BATHURST AS IN RS198643; BATH-BURG-SHERB"
+"TaxYear": "2020"
+"TransactionBrokerCompensation": "2"
+"TransactionType": "For Sale"
+"UnitNumber": "2"
+"Zoning": "rural res"
+"Water": "Unknown"
+"PossessionDetails": "upon closing"
+"DDFYN": true
+"AccessToProperty": array:1 [
0 => "Private Road"
]
+"LotSizeRangeAcres": "2-4.99"
+"PropertyUse": "[Unknown]"
+"GarageType": "Unknown"
+"MediaListingKey": "35170793"
+"HeatSource": "Unknown"
+"ContractStatus": "Available"
+"PropertyFeatures": array:1 [
0 => "Wooded/Treed"
]
+"PortionPropertyLease": array:1 [
0 => "Unknown"
]
+"LotWidth": 164.0
+"HeatType": "Unknown"
+"TaxType": "[Unknown]"
+"LotIrregularities": "1"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10402639')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"RollNumber": "091191601530804"
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"provider_name": "TRREB"
+"LotDepth": 765.0
+"ID": "165671"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14236
+post_id: "165676"
+post_author: 1
+"ListingKey": "X10409428"
+"ListingId": "X10409428"
+"PropertyType": "Commercial"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T18:09:17Z"
+"RFModificationTimestamp": "2024-11-17T15:24:15Z"
+"ListPrice": 3999900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Merrickville-wolford"
+"PostalCode": "K0G 1N0"
+"UnparsedAddress": "111 St Lawrence Street, Merrickville-wolford, On K0g 1n0"
+"Coordinates": array:2 [
0 => -75.8366597
1 => 44.9159313
]
+"Latitude": 44.9159313
+"Longitude": -75.8366597
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "3.5 REALTY LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Popular Historical building in the Heart of Merrickville. This building includes a complete and fully operating restaurant that you can operate, or lease out! 12 private hotel rooms with amenities, including an 800 sq ft Bridal Suite. A one-bedroom apartment, one smaller retail/office store and one 6,000 sq ft. retail store, plus a popular courtyard garden patio. The potential of this building and location is promising and should not be overlooked! The Baldachin Inn business was established in the early 80's and has been the corner stone of the Village, along with the two popular retail stores, it is the largest retail building in the Village and located on the busiest corner of County Rd 43 and St. Lawrence St. The building has been the venue for numerous weddings in the 6,000 sq ft Ballroom on the third floor with access by its own elevator. A comfortable dining room and lounge area for luncheons and dinners! The building has over 30,000 sq ft of floor space in total!"
+"BusinessName": "Baldachin Inn"
+"BusinessType": array:1 [
0 => "Hospitality"
]
+"CityRegion": "804 - Merrickville"
+"Cooling": "Unknown"
+"Country": "CA"
+"CountyOrParish": "Leeds & Grenville"
+"CreationDate": "2024-11-11T23:32:32.218641+00:00"
+"CrossStreet": "Follow Highway #416 from Ottawa to Cty Rd 43 turnoff , go west to the Village of Merrickville."
+"DaysOnMarket": 1237
+"DirectionFaces": "East"
+"ExpirationDate": "2024-11-30"
+"FrontageLength": "31.09"
+"Furnished": "[Unknown]"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2022-05-23"
+"MainOfficeKey": "505600"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2022-05-23T14:35:39Z"
+"OriginalListPrice": 3999900.0
+"OriginatingSystemID": "oreb"
+"OriginatingSystemKey": "1293409"
+"ParcelNumber": "681060149"
+"PetsAllowed": array:1 [
0 => "Unknown"
]
+"PhotosChangeTimestamp": "2024-11-06T05:22:16Z"
+"PoolFeatures": "None"
+"Roof": "Unknown"
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": "Unknown"
+"ShowingRequirements": array:1 [
0 => "List Brokerage"
]
+"SourceSystemID": "oreb"
+"SourceSystemName": "oreb"
+"StateOrProvince": "ON"
+"StreetName": "ST LAWRENCE"
+"StreetNumber": "111"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "30000.0"
+"TaxLegalDescription": "LT 5 RANGE 1 PL 6 MERRICKVILLE; MERRICKVILLE-WOLFORD"
+"TaxYear": "2021"
+"TransactionBrokerCompensation": "1.5"
+"TransactionType": "For Sale"
+"Utilities": "Unknown"
+"VirtualTourURLUnbranded": "http://www.baldachin.com/"
+"Zoning": "C1"
+"Water": "Unknown"
+"PossessionDetails": "TBA"
+"DDFYN": true
+"LotType": "Unknown"
+"LotSizeRangeAcres": "< .50"
+"PropertyUse": "With Property"
+"GarageType": "Unknown"
+"MediaListingKey": "34041462"
+"ContractStatus": "Available"
+"TaxesExpense": 30800.0
+"PortionPropertyLease": array:1 [
0 => "Unknown"
]
+"LotWidth": 102.0
+"HeatType": "Unknown"
+"TaxType": "Unknown"
+"LotIrregularities": "0"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10409428')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"RollNumber": "071471401500200"
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"provider_name": "TRREB"
+"LotDepth": 91.0
+"ParkingSpaces": 12
+"ID": "165676"
}
]
+success: true
+page_size: 9
+page_count: 10890
+count: 98003
+after_key: ""
}
"RF Response Time" => "0.35 seconds"
]
"RF Cache Key: d53fafee41030e40e955e48ffde7282aa99a21782f5be544d6f1a99b895ac189" => array:1 [
"RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14190
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15171
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X10403362"
+"ListingId": "X10403362"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:20:34Z"
+"RFModificationTimestamp": "2025-04-25T20:50:47Z"
+"ListPrice": 24.3
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 10000.0
+"City": "Hamilton"
+"PostalCode": "L8P 4Y4"
+"UnparsedAddress": "10 George Street Unit 300, Hamilton, On L8p 4y4"
+"Coordinates": array:2 [
0 => -79.8758562
1 => 43.2576852
]
+"Latitude": 43.2576852
+"Longitude": -79.8758562
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Move-in ready! Contemporary office space near the corner of Bay and George. Hamilton's Textile Building is a completely rebuilt office building that mixes Hamilton's industrial charm with modern design elements. A former warehouse that retains its brick & beam construction, this Hamilton landmark has become a jewel among Hamilton's office spaces. A four-storey atrium and marble-encased elevator treat your eyes as your enter the lobby and secure fob access controls elevator and unit entry. This third-floor unit offers 10,000 square feet of space and provides glass-enclosed meeting rooms and offices, as well as an open concept central office area. The unit also includes a large kitchenette, break room and private washrooms. Hardwood floors, exposed ductwork and brick, glass boardroom and office walls, and the building's post and beam construction all add to the unit's invited and comfortable ambience. This ideal location is steps from the financial core, courthouses, City Hall, transit, restaurants, and much more! Note: Furniture in existing photos former tenants' belongings, not included as part of lease offering. 4,440 SF and 5,560 SF options also available."
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "Central"
+"CoListOfficeKey": "541005"
+"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"CoListOfficePhone": "905-296-3930"
+"CommunityFeatures": array:1 [
0 => "Public Transit"
]
+"Cooling": array:1 [
0 => "Unknown"
]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-04T05:44:41.942039+00:00"
+"CrossStreet": "On George Street, just up from Bay Street"
+"DaysOnMarket": 440
+"ExpirationDate": "2024-11-29"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-08-01"
+"LotSizeDimensions": "100 x 143.01"
+"MainOfficeKey": "541000"
+"MajorChangeTimestamp": "2024-08-01T11:02:36Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2024-08-01T11:02:36Z"
+"OriginalListPrice": 24.3
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40628246"
+"ParcelNumber": "171430136"
+"PhotosChangeTimestamp": "2024-11-02T17:40:59Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"Roof": array:1 [
0 => "Unknown"
]
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": array:1 [
0 => "Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Showing System"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetName": "GEORGE"
+"StreetNumber": "10"
+"StreetSuffix": "Street"
+"TaxBookNumber": "251802012250460"
+"TaxLegalDescription": "PT BLK BTN KING ST, GEORGE ST, BAY ST, CAROLINE ST G.S. TIFFANY SURVEY CITY OF HAMILTON (UNREGISTERED) AS IN VM228950; CITY OF HAMILTON"
+"TransactionBrokerCompensation": "2.5%+HST of total lease base rent"
+"TransactionType": "For Lease"
+"UnitNumber": "300"
+"Utilities": array:1 [
0 => "Unknown"
]
+"Zoning": "D2 - Downtown Mixed Use"
+"Water": "Municipal"
+"DDFYN": true
+"LotType": "Unknown"
+"PropertyUse": "Unknown"
+"ContractStatus": "Available"
+"ListPriceUnit": "Other"
+"LotWidth": 143.01
+"HeatType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403362')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"MinimumRentalTermMonths": 36
+"AssessmentYear": 2016
+"provider_name": "TRREB"
+"ElevatorYN": true
+"LotDepth": 100.0
+"PossessionDetails": "Immediate"
+"MaximumRentalMonthsTerm": 120
+"LotSizeRangeAcres": "< .50"
+"GarageType": "Unknown"
+"MediaListingKey": "152626783"
+"TaxType": "Unknown"
+"HoldoverDays": 30
+"ElevatorType": "Public"
+"OfficeApartmentArea": 10000.0
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15170
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X10403840"
+"ListingId": "X10403840"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:19:13Z"
+"RFModificationTimestamp": "2024-11-17T12:10:01Z"
+"ListPrice": 900000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Hamilton"
+"PostalCode": "L0R 2H0"
+"UnparsedAddress": "287 Dundas E Street, Hamilton, On L0r 2h0"
+"Coordinates": array:2 [
0 => -79.9177691
1 => 43.3122446
]
+"Latitude": 43.3122446
+"Longitude": -79.9177691
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Royal Le Page Meadowtowne Realty Inc., Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Seize this rare opportunity to own a thriving pet supply retail store in the bustling community of Waterdown. This well-established business, which has been operating successfully for 8.5 years, is located in a high-traffic area, ensuring maximum visibility and footfall. The property boasts approximately 1608 sq. ft. of retail space with an open floor plan, featuring designated sections for pet food, toys, accessories, and more. Customers will appreciate the ample space for browsing and the modern fixtures, shelving units, and point-of-sale systems that are included.The store offers dedicated parking with plenty of spaces for both customers and staff. Large storefront windows provide excellent opportunities for attractive product displays and signage. An extensive range of high-quality pet products, including popular brands and unique items, is available, with the inventory included as part of the sale.Situated in a prime retail corridor, the store benefits from significant foot traffic driven by neighbouring businesses. It is also conveniently located near residential neighbourhoods, parks, veterinary clinics, and other pet-related services. With a loyal and growing customer base, a strong reputation in the community, and an active social media presence with a customer loyalty program, this business is poised for continued success. Detailed financials are available upon request for serious inquiries, demonstrating consistent revenue growth and profitability. Competitive pricing is offered for this turnkey operation in a desirable location. Don't miss out on this fantastic business opportunity in the vibrant Waterdown community. Invest in a business that not only brings joy to pets and their owners but also promises a rewarding and profitable venture. Act now and become a part of Waterdown's thriving retail landscape!"
+"BuildingAreaUnits": "Square Feet"
+"BusinessName": "Chews Raw Inc"
+"BusinessType": array:1 [
0 => "Other"
]
+"CityRegion": "Waterdown"
+"CoListOfficeKey": "540403"
+"CoListOfficeName": "Royal Le Page Meadowtowne Realty Inc., Brokerage"
+"CoListOfficePhone": "905-878-8101"
+"Cooling": array:1 [
0 => "Unknown"
]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-04T05:44:55.943177+00:00"
+"CrossStreet": "Hamilton St and Dundas St"
+"DaysOnMarket": 435
+"DirectionFaces": "South"
+"ExpirationDate": "2025-01-06"
+"HoursDaysOfOperation": array:1 [
0 => "Open 7 Days"
]
+"HoursDaysOfOperationDescription": """
Mon-Fri 10am-7pm\r\n
Sat-10am-5pm\r\n
Sun 11am-4pm
"""
+"Inclusions": "All equipment and inventory"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-08-06"
+"LotSizeDimensions": "x"
+"MainOfficeKey": "540400"
+"MajorChangeTimestamp": "2024-10-08T09:54:46Z"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2024-08-06T16:15:36Z"
+"OriginalListPrice": 1050000.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40629428"
+"PhotosChangeTimestamp": "2024-11-02T17:39:59Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"PreviousListPrice": 1050000.0
+"PriceChangeTimestamp": "2024-10-08T09:54:46Z"
+"Roof": array:1 [
0 => "Unknown"
]
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": array:1 [
0 => "Unknown"
]
+"ShowingRequirements": array:1 [
0 => "Showing System"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "E"
+"StreetName": "DUNDAS"
+"StreetNumber": "287"
+"StreetSuffix": "Street"
+"TransactionBrokerCompensation": "2%"
+"Utilities": array:1 [
0 => "Unknown"
]
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/0190ebdc-62ba-7397-94cd-2af2c414e7ca"
+"Water": "Unknown"
+"PossessionDetails": "30-59Days"
+"DDFYN": true
+"LotType": "Unknown"
+"PropertyUse": "Unknown"
+"GarageType": "Unknown"
+"MediaListingKey": "152701036"
+"Exposure": "North"
+"ContractStatus": "Available"
+"HeatType": "Unknown"
+"TMI": "7898.00"
+"TaxType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403840')"
+"HoldoverDays": 60
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"FinancialStatementAvailableYN": true
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"provider_name": "TRREB"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15169
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X10403402"
+"ListingId": "X10403402"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:12:11Z"
+"RFModificationTimestamp": "2024-11-17T12:14:35Z"
+"ListPrice": 2799000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 4600.0
+"City": "Hamilton"
+"PostalCode": "L8V 3L8"
+"UnparsedAddress": "520-522 Upper Sherman Avenue, Hamilton, On L8v 3l8"
+"Coordinates": array:2 [
0 => -79.8499101
1 => 43.2260616
]
+"Latitude": 43.2260616
+"Longitude": -79.8499101
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "RE/MAX Real Estate Centre Inc, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Turn key opportunity For Investors & Landlords to Purchase income producing freestanding (Building) Retail Property zoned C2 located in Hamilton. Current Tenant is PT Healthcare Solutions, AAA tenant, physiotherapist Clinic situated in a prime area of Hamilton. The property is fully leased to a single tenant. Property has 10 parking Spots, 5 spots in front & 5 parking spots at the back of the building. Tenant pays all the expenses which includes utility, hydro, taxes & insurance etc. for the the period of 5 years ending in 2028 and Tenant has 3 additional renewal option and lease can be extended for another term of 5 years each after the expiry of lease term in 2028. Condition of the Building is AAA.Do not miss the opportunity. Once It's Gone Cannot Be Replicated. Property is close to Mountain Medical Centre, Juravinski Hospital, St Peter's Hospital, St Joseph Healthcare Hospital."
+"BuildingAreaUnits": "Square Feet"
+"BuildingName": "Pt Health Physiotherapy"
+"CityRegion": "Eastmount"
+"CommunityFeatures": array:1 [
0 => "Public Transit"
]
+"Cooling": array:1 [
0 => "Unknown"
]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-04T05:35:55.180985+00:00"
+"CrossStreet": "upper sherman & Brucedale Ave E"
+"DaysOnMarket": 514
+"ExpirationDate": "2024-11-20"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-05-19"
+"LotSizeDimensions": "108.23 x 70.14"
+"MainOfficeKey": "543400"
+"MajorChangeTimestamp": "2024-08-18T11:56:18Z"
+"MlsStatus": "New"
+"OccupantType": "Tenant"
+"OriginalEntryTimestamp": "2024-05-19T08:45:40Z"
+"OriginalListPrice": 2899000.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40591612"
+"ParcelNumber": "170590190"
+"PhotosChangeTimestamp": "2024-11-02T17:59:01Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"PreviousListPrice": 2899000.0
+"PriceChangeTimestamp": "2024-08-18T11:56:18Z"
+"Roof": array:1 [
0 => "Unknown"
]
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": array:1 [
0 => "Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Showing System"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetName": "UPPER SHERMAN"
+"StreetNumber": "520-522"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "18678.0"
+"TaxAssessedValue": 583000
+"TaxBookNumber": "251807067607660"
+"TaxLegalDescription": "LTS 701 & 702, PL 608 ; HAMILTON"
+"TaxYear": "2023"
+"TransactionBrokerCompensation": "2.5% plus HST"
+"TransactionType": "For Sale"
+"Utilities": array:1 [
0 => "Unknown"
]
+"Zoning": "C2 COMMERCIAL"
+"Water": "Municipal"
+"DDFYN": true
+"LotType": "Unknown"
+"PropertyUse": "Unknown"
+"ContractStatus": "Available"
+"ListPriceUnit": "For Sale"
+"PropertyFeatures": array:1 [
0 => "Hospital"
]
+"LotWidth": 70.14
+"HeatType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403402')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"MortgageComment": "Treat as clear"
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"AssessmentYear": 2016
+"provider_name": "TRREB"
+"LotDepth": 108.23
+"PossessionDetails": "IMMEDIATE"
+"LotSizeRangeAcres": "< .50"
+"GarageType": "Unknown"
+"MediaListingKey": "150039113"
+"TaxType": "Unknown"
+"UFFI": "No"
+"HoldoverDays": 365
+"ElevatorType": "None"
+"ParkingSpot1": "10"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15168
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X10403394"
+"ListingId": "X10403394"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:08:19Z"
+"RFModificationTimestamp": "2025-04-27T02:50:39Z"
+"ListPrice": 2000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1000.0
+"City": "Hamilton"
+"PostalCode": "L8R 2J9"
+"UnparsedAddress": "12 James N Street Unit 201a, Hamilton, On L8r 2j9"
+"Coordinates": array:2 [
0 => -79.8687264
1 => 43.2570819
]
+"Latitude": 43.2570819
+"Longitude": -79.8687264
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "1,000 square foot office available at the prestigious King-James building! As part of the Core Works Office Suites, the second floor and common area include kitchen, washrooms, boardroom, lounge, and access to the fifth floor common area terrace! The building itself has been completely redeveloped by Core Urban; known for their brilliant combination of preserved heritage features and character with modern features and building systems. Located in the heart of downtown Hamilton, this suite is literal steps away from the major banks, City Hall, the court houses, Mc Master University's downtown campus, the James North Arts district, Jackson Square, and the King William restaurant district!"
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "Beasley"
+"CoListOfficeKey": "541005"
+"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"CoListOfficePhone": "905-296-3930"
+"CommunityFeatures": array:1 [
0 => "Public Transit"
]
+"Cooling": array:1 [
0 => "Unknown"
]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-04T05:37:41.864251+00:00"
+"CrossStreet": "On James Street N just up from King Street"
+"DaysOnMarket": 427
+"ExpirationDate": "2024-11-29"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-08-14"
+"LotSizeDimensions": "x 0"
+"MainOfficeKey": "541000"
+"MajorChangeTimestamp": "2024-08-15T10:01:56Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2024-08-15T10:01:56Z"
+"OriginalListPrice": 2000.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40633232"
+"ParcelNumber": "171670249"
+"PhotosChangeTimestamp": "2024-11-02T17:55:30Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"Roof": array:1 [
0 => "Unknown"
]
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": array:1 [
0 => "Sewer"
]
+"ShowingRequirements": array:3 [
0 => "List Salesperson"
1 => "Showing System"
2 => "List Brokerage"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "JAMES"
+"StreetNumber": "12"
+"StreetSuffix": "Street"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5% + HST of total net rent"
+"TransactionType": "For Lease"
+"UnitNumber": "201A"
+"Utilities": array:1 [
0 => "Unknown"
]
+"Zoning": "Commercial"
+"Water": "Municipal"
+"PossessionDetails": "Flexible"
+"MaximumRentalMonthsTerm": 60
+"DDFYN": true
+"LotType": "Unknown"
+"LotSizeRangeAcres": "< .50"
+"PropertyUse": "Unknown"
+"GarageType": "Unknown"
+"MediaListingKey": "152936138"
+"ContractStatus": "Available"
+"ListPriceUnit": "Net Lease"
+"HeatType": "Unknown"
+"TaxType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403394')"
+"HoldoverDays": 30
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"MinimumRentalTermMonths": 12
+"provider_name": "TRREB"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15167
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X10404168"
+"ListingId": "X10404168"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T19:05:40Z"
+"RFModificationTimestamp": "2025-04-25T20:50:47Z"
+"ListPrice": 250000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Norfolk County"
+"PostalCode": "N0A 1N0"
+"UnparsedAddress": "N/a St George Street, Norfolk County, On N0a 1n0"
+"Coordinates": array:2 [
0 => -80.39003
1 => 42.637637
]
+"Latitude": 42.637637
+"Longitude": -80.39003
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Lee & Associates Commercial Real Estate Inc."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": """
Opportunity to invest and develop a custom home in Port Dover! Discover the potential to create your dream home in the charming town of Port Dover. This prime location offers immediate access to Main Street and is just minute away from a variety of amenities in downtown port Dover. Enjoy the convenience of nearby shops, restaurants, and entertainment options, all within a vibrant and friendly community. This investment opportunity provides a perfect blend of small-town charm and modern conveniences, making it an ideal spot for your custom home development. Don't miss out on the chance to be a part of this growing and desirable area!\r\n
\r\n
*Legal Description Continued: COUNTY, The Property Is Being Sold On An "As Is" Basis. Seller is Selling Surface Rights Only (SRO).
"""
+"BuildingAreaUnits": "Square Feet"
+"Cooling": array:1 [
0 => "Unknown"
]
+"Country": "CA"
+"CountyOrParish": "Haldimand-Norfolk"
+"CreationDate": "2024-11-03T22:31:26.797869+00:00"
+"CrossStreet": "St. George St & Dover Ave"
+"DaysOnMarket": 400
+"ExpirationDate": "2024-12-19"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-09-10"
+"LotSizeDimensions": "189 x 120"
+"MainOfficeKey": "333500"
+"MajorChangeTimestamp": "2024-09-10T14:03:58Z"
+"MlsStatus": "New"
+"OriginalEntryTimestamp": "2024-09-10T14:03:58Z"
+"OriginalListPrice": 250000.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40645055"
+"ParcelNumber": "502410138"
+"PhotosChangeTimestamp": "2024-11-02T20:43:13Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"Roof": array:1 [
0 => "Unknown"
]
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": array:1 [
0 => "Sewer"
]
+"ShowingRequirements": array:1 [
0 => "List Brokerage"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetName": "ST GEORGE"
+"StreetNumber": "N/A"
+"StreetSuffix": "Street"
+"TaxAssessedValue": 92000
+"TaxBookNumber": "331033402005460"
+"TaxLegalDescription": "PT RAILWAY LT 19 PL 207 SRO PT 4 37R213; NORFOLK COUNTY"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "1.5% + HST"
+"TransactionType": "For Sale"
+"Utilities": array:1 [
0 => "None"
]
+"Zoning": "R1-A-Residential"
+"Water": "Municipal"
+"PossessionDetails": "TBC"
+"DDFYN": true
+"LotType": "Unknown"
+"LotSizeRangeAcres": "< .50"
+"PropertyUse": "Unknown"
+"GarageType": "Unknown"
+"MediaListingKey": "153815032"
+"Exposure": "West"
+"SoilTest": "No"
+"ContractStatus": "Available"
+"ListPriceUnit": "For Sale"
+"LotWidth": 120.0
+"HeatType": "Unknown"
+"TaxType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404168')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"AssessmentYear": 2024
+"provider_name": "TRREB"
+"LotDepth": 189.0
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15166
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X10404078"
+"ListingId": "X10404078"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T18:57:19Z"
+"RFModificationTimestamp": "2025-04-25T20:50:47Z"
+"ListPrice": 1450.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 859.0
+"City": "Hamilton"
+"PostalCode": "L8P 3A2"
+"UnparsedAddress": "148 James S Street Unit Lwr, Hamilton, On L8p 3a2"
+"Coordinates": array:2 [
0 => -79.871071
1 => 43.25242
]
+"Latitude": 43.25242
+"Longitude": -79.871071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Welcome to the Stone Terrace heritage district on historic James Street South! Home to many restaurants, bars, and cafes, this is one of Hamilton's premier, burgeoning hospitality districts. A stone's throw to Hamilton's Downtown GO Station and the Cooke Transit Terminal and located in one of Hamilton's most sought after residential neighbourhoods, Durand South. Located steps to St. Joseph's hospital, Core Urban's new 135-unit residential development, as well as the Connolly condo development site and LIUNA's twin tower project at James and Jackson, as well as City Hall, the Hamilton Club, Hamilton's Conservatory for the Arts, the Hamilton Convention Centre. Be among the apartment and office towers in one of the higher-density areas of the city, with young professionals, medical professional, office workers, independent businesses, and homeowner and tenant residents all within walking distance to the site of your business's new home! This lower level is perfect for service retail or coffee shop, ready for your touches. Generous tenant incentive packages available as provided by the landlord. Main floor and lower level can be rented together or separately. Listed rent is gross monthly rent, inclusive of base rent and TMI - subject lease is to be structured as gross plus utilities. Posted rent based on $15.01 PSF net with TMI for 2023 estimated as $5.25 PSF. Gross rent of $20.26 PSF on 859 SF. Come start your next project!"
+"BasementYN": true
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "Corktown"
+"CommunityFeatures": array:2 [
0 => "Public Transit"
1 => "Park"
]
+"Cooling": array:1 [
0 => "Unknown"
]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-03T22:48:45.214383+00:00"
+"CrossStreet": "Located on the west side of James Street South between Bold and Duke streets"
+"DaysOnMarket": 365
+"ExpirationDate": "2025-01-31"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-10-15"
+"LotSizeDimensions": "120 x 24.5"
+"MainOfficeKey": "541000"
+"MajorChangeTimestamp": "2024-10-15T10:06:39Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2024-10-15T10:06:39Z"
+"OriginalListPrice": 1450.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40662723"
+"ParcelNumber": "171710039"
+"PhotosChangeTimestamp": "2024-11-02T19:52:44Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"RentIncludes": array:1 [
0 => "Building Insurance"
]
+"Roof": array:1 [
0 => "Unknown"
]
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": array:1 [
0 => "Sanitary+Storm"
]
+"ShowingRequirements": array:1 [
0 => "Go Direct"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "S"
+"StreetName": "JAMES"
+"StreetNumber": "148"
+"StreetSuffix": "Street"
+"TaxAssessedValue": 513000
+"TaxBookNumber": "251802013905340"
+"TaxLegalDescription": "PT LT 14 PL 1270 (AKA P. HAMILTON SURVEY) AS IN CD464174, S/T INTEREST IN VM261396, T/W VM261396; CITY OF HAMILTON"
+"TaxYear": "2022"
+"TransactionBrokerCompensation": "4% of year 1 net rent, 2% of remaining term, cappe"
+"TransactionType": "For Lease"
+"UnitNumber": "Lwr"
+"Utilities": array:1 [
0 => "Unknown"
]
+"Zoning": "D2 - Downtown Mixed Use - Pedestrian Focus"
+"Water": "Municipal"
+"DDFYN": true
+"LotType": "Unknown"
+"PropertyUse": "Unknown"
+"GasYNA": "Yes"
+"ContractStatus": "Available"
+"ListPriceUnit": "Gross Lease"
+"PropertyFeatures": array:1 [
0 => "Hospital"
]
+"LotWidth": 24.5
+"HeatType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404078')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"MinimumRentalTermMonths": 36
+"RetailArea": 859.0
+"AssessmentYear": 2016
+"provider_name": "TRREB"
+"LotDepth": 120.0
+"PossessionDetails": "Flexible"
+"LotSizeRangeAcres": "< .50"
+"GarageType": "Unknown"
+"MediaListingKey": "154807922"
+"ElectricYNA": "Yes"
+"TaxType": "Unknown"
+"HoldoverDays": 30
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15165
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X10403496"
+"ListingId": "X10403496"
+"PropertyType": "Commercial Lease"
+"PropertySubType": "Commercial Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T18:41:13Z"
+"RFModificationTimestamp": "2025-04-26T00:02:09Z"
+"ListPrice": 2690.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 1200.0
+"City": "Hamilton"
+"PostalCode": "L8R 2J9"
+"UnparsedAddress": "12 James N Street Unit 201h, Hamilton, On L8r 2j9"
+"Coordinates": array:2 [
0 => -79.8687264
1 => 43.2570819
]
+"Latitude": 43.2570819
+"Longitude": -79.8687264
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "1,200 square foot office available at the prestigious King-James building! As part of the Core Works Office Suites, the second floor and common area include kitchen, washrooms, boardroom, lounge, and access to the fifth floor common area terrace! The building itself has been completely redeveloped by Core Urban; known for their brilliant combination of preserved heritage features and character with modern features and building systems. Located in the heart of downtown Hamilton, this suite is literal steps away from the major banks, City Hall, the court houses, Mc Master University's downtown campus, the James North Arts district, Jackson Square, and the King William restaurant district!"
+"BuildingAreaUnits": "Square Feet"
+"CityRegion": "Beasley"
+"CoListOfficeKey": "541005"
+"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage"
+"CoListOfficePhone": "905-296-3930"
+"CommunityFeatures": array:1 [
0 => "Public Transit"
]
+"Cooling": array:1 [
0 => "Unknown"
]
+"Country": "CA"
+"CountyOrParish": "Hamilton"
+"CreationDate": "2024-11-03T23:14:58.512254+00:00"
+"CrossStreet": "On James Street N just up from King Street"
+"DaysOnMarket": 427
+"ExpirationDate": "2024-11-29"
+"RFTransactionType": "For Rent"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2024-08-14"
+"LotSizeDimensions": "x 0"
+"MainOfficeKey": "541000"
+"MajorChangeTimestamp": "2024-08-15T10:07:35Z"
+"MlsStatus": "New"
+"OccupantType": "Vacant"
+"OriginalEntryTimestamp": "2024-08-15T10:07:35Z"
+"OriginalListPrice": 2690.0
+"OriginatingSystemID": "omdreb"
+"OriginatingSystemKey": "40633238"
+"ParcelNumber": "171670249"
+"PhotosChangeTimestamp": "2024-11-02T18:48:12Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"Roof": array:1 [
0 => "Unknown"
]
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": array:1 [
0 => "Sewer"
]
+"ShowingRequirements": array:3 [
0 => "List Salesperson"
1 => "Showing System"
2 => "List Brokerage"
]
+"SourceSystemID": "omdreb"
+"SourceSystemName": "itso"
+"StateOrProvince": "ON"
+"StreetDirSuffix": "N"
+"StreetName": "JAMES"
+"StreetNumber": "12"
+"StreetSuffix": "Street"
+"TaxYear": "2024"
+"TransactionBrokerCompensation": "2.5% + HST of total net rent"
+"TransactionType": "For Lease"
+"UnitNumber": "201H"
+"Utilities": array:1 [
0 => "Unknown"
]
+"Zoning": "Commercial"
+"Water": "Municipal"
+"PossessionDetails": "Flexible"
+"MaximumRentalMonthsTerm": 60
+"DDFYN": true
+"LotType": "Unknown"
+"LotSizeRangeAcres": "< .50"
+"PropertyUse": "Unknown"
+"GarageType": "Unknown"
+"MediaListingKey": "152936238"
+"ContractStatus": "Available"
+"ListPriceUnit": "Net Lease"
+"HeatType": "Unknown"
+"TaxType": "Unknown"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403496')"
+"HoldoverDays": 30
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"MinimumRentalTermMonths": 12
+"OfficeApartmentArea": 1200.0
+"provider_name": "TRREB"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15164
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X10402639"
+"ListingId": "X10402639"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T18:23:36Z"
+"RFModificationTimestamp": "2025-04-25T23:22:25Z"
+"ListPrice": 129000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Tay Valley"
+"PostalCode": "K7H 3C6"
+"UnparsedAddress": "516 Christie Lake Road Unit 2, Tay Valley, On K7h 3c6"
+"Coordinates": array:2 [
0 => -76.2920819
1 => 44.8929474
]
+"Latitude": 44.8929474
+"Longitude": -76.2920819
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "CENTURY 21 SYNERGY REALTY INC."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "This level, treed ,lot is in Tay Valley Township which is a leader in tiny homes planning. So YES this is where you can feel welcomed creating your efficient living space that you have dreamed of. This terrific lot is minutes from the winner of "the prettiest town in Ontario" award.- Perth. The town has a number of grocery stores, pharmacies, an accredited hospital ,choices of veterinarians, and many other essential services. Perth has an active live music and theatre population and has many festivals and events over the year: Maple Fest , Garlic Festival and a three day Stewart Park music festival that is free to the public thanks in large part to our many fine local merchants. Don't forget the 175 year old Perth Fair. We welcome you to your new home. The lot is awaiting it's PIN and tax assessment"
+"ArchitecturalStyle": array:1 [
0 => "Unknown"
]
+"Basement": array:1 [
0 => "Unknown"
]
+"CityRegion": "906 - Bathurst/Burgess & Sherbrooke (Bathurst) Twp"
+"ConstructionMaterials": array:1 [
0 => "Unknown"
]
+"Cooling": array:1 [
0 => "Unknown"
]
+"Country": "CA"
+"CountyOrParish": "Lanark"
+"CreationDate": "2024-11-05T03:40:32.778725+00:00"
+"CrossStreet": "From Perth, take Christie Lake Road to pin #516 on right . Lot 2 is at end of new road on the left --(just past the hydro pole)"
+"DaysOnMarket": 1067
+"DirectionFaces": "South"
+"ExpirationDate": "2024-12-05"
+"FrontageLength": "49.99"
+"Furnished": "[Unknown]"
+"InteriorFeatures": array:1 [
0 => "Unknown"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2022-11-09"
+"MainOfficeKey": "485600"
+"MlsStatus": "New"
+"OriginalEntryTimestamp": "2022-11-09T22:14:56Z"
+"OriginalListPrice": 129000.0
+"OriginatingSystemID": "oreb"
+"OriginatingSystemKey": "1321411"
+"ParcelNumber": "051870218"
+"ParkingFeatures": array:1 [
0 => "Unknown"
]
+"PetsAllowed": array:1 [
0 => "Unknown"
]
+"PhotosChangeTimestamp": "2024-11-05T03:36:36Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"Roof": array:1 [
0 => "Unknown"
]
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": array:1 [
0 => "None"
]
+"ShowingRequirements": array:1 [
0 => "List Brokerage"
]
+"SourceSystemID": "oreb"
+"SourceSystemName": "oreb"
+"StateOrProvince": "ON"
+"StreetName": "CHRISTIE LAKE"
+"StreetNumber": "516"
+"StreetSuffix": "Road"
+"TaxLegalDescription": "LOT 2 PT LT 23 CON 3 BATHURST AS IN RS198643; BATH-BURG-SHERB"
+"TaxYear": "2020"
+"TransactionBrokerCompensation": "2"
+"TransactionType": "For Sale"
+"UnitNumber": "2"
+"Zoning": "rural res"
+"Water": "Unknown"
+"PossessionDetails": "upon closing"
+"DDFYN": true
+"AccessToProperty": array:1 [
0 => "Private Road"
]
+"LotSizeRangeAcres": "2-4.99"
+"PropertyUse": "[Unknown]"
+"GarageType": "Unknown"
+"MediaListingKey": "35170793"
+"HeatSource": "Unknown"
+"ContractStatus": "Available"
+"PropertyFeatures": array:1 [
0 => "Wooded/Treed"
]
+"PortionPropertyLease": array:1 [
0 => "Unknown"
]
+"LotWidth": 164.0
+"HeatType": "Unknown"
+"TaxType": "[Unknown]"
+"LotIrregularities": "1"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10402639')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"RollNumber": "091191601530804"
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"provider_name": "TRREB"
+"LotDepth": 765.0
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#15163
+post_id: ? mixed
+post_author: ? mixed
+"ListingKey": "X10409428"
+"ListingId": "X10409428"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Sale Of Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2024-11-16T18:09:17Z"
+"RFModificationTimestamp": "2024-11-17T15:24:15Z"
+"ListPrice": 3999900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Merrickville-wolford"
+"PostalCode": "K0G 1N0"
+"UnparsedAddress": "111 St Lawrence Street, Merrickville-wolford, On K0g 1n0"
+"Coordinates": array:2 [
0 => -75.8366597
1 => 44.9159313
]
+"Latitude": 44.9159313
+"Longitude": -75.8366597
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListOfficeName": "3.5 REALTY LTD."
+"OriginatingSystemName": "TRREB"
+"PublicRemarks": "Popular Historical building in the Heart of Merrickville. This building includes a complete and fully operating restaurant that you can operate, or lease out! 12 private hotel rooms with amenities, including an 800 sq ft Bridal Suite. A one-bedroom apartment, one smaller retail/office store and one 6,000 sq ft. retail store, plus a popular courtyard garden patio. The potential of this building and location is promising and should not be overlooked! The Baldachin Inn business was established in the early 80's and has been the corner stone of the Village, along with the two popular retail stores, it is the largest retail building in the Village and located on the busiest corner of County Rd 43 and St. Lawrence St. The building has been the venue for numerous weddings in the 6,000 sq ft Ballroom on the third floor with access by its own elevator. A comfortable dining room and lounge area for luncheons and dinners! The building has over 30,000 sq ft of floor space in total!"
+"BusinessName": "Baldachin Inn"
+"BusinessType": array:1 [
0 => "Hospitality"
]
+"CityRegion": "804 - Merrickville"
+"Cooling": array:1 [
0 => "Unknown"
]
+"Country": "CA"
+"CountyOrParish": "Leeds & Grenville"
+"CreationDate": "2024-11-11T23:32:32.218641+00:00"
+"CrossStreet": "Follow Highway #416 from Ottawa to Cty Rd 43 turnoff , go west to the Village of Merrickville."
+"DaysOnMarket": 1237
+"DirectionFaces": "East"
+"ExpirationDate": "2024-11-30"
+"FrontageLength": "31.09"
+"Furnished": "[Unknown]"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListingContractDate": "2022-05-23"
+"MainOfficeKey": "505600"
+"MlsStatus": "New"
+"OccupantType": "Owner"
+"OriginalEntryTimestamp": "2022-05-23T14:35:39Z"
+"OriginalListPrice": 3999900.0
+"OriginatingSystemID": "oreb"
+"OriginatingSystemKey": "1293409"
+"ParcelNumber": "681060149"
+"PetsAllowed": array:1 [
0 => "Unknown"
]
+"PhotosChangeTimestamp": "2024-11-06T05:22:16Z"
+"PoolFeatures": array:1 [
0 => "None"
]
+"Roof": array:1 [
0 => "Unknown"
]
+"SecurityFeatures": array:1 [
0 => "Unknown"
]
+"Sewer": array:1 [
0 => "Unknown"
]
+"ShowingRequirements": array:1 [
0 => "List Brokerage"
]
+"SourceSystemID": "oreb"
+"SourceSystemName": "oreb"
+"StateOrProvince": "ON"
+"StreetName": "ST LAWRENCE"
+"StreetNumber": "111"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "30000.0"
+"TaxLegalDescription": "LT 5 RANGE 1 PL 6 MERRICKVILLE; MERRICKVILLE-WOLFORD"
+"TaxYear": "2021"
+"TransactionBrokerCompensation": "1.5"
+"TransactionType": "For Sale"
+"Utilities": array:1 [
0 => "Unknown"
]
+"VirtualTourURLUnbranded": "http://www.baldachin.com/"
+"Zoning": "C1"
+"Water": "Unknown"
+"PossessionDetails": "TBA"
+"DDFYN": true
+"LotType": "Unknown"
+"LotSizeRangeAcres": "< .50"
+"PropertyUse": "With Property"
+"GarageType": "Unknown"
+"MediaListingKey": "34041462"
+"ContractStatus": "Available"
+"TaxesExpense": 30800.0
+"PortionPropertyLease": array:1 [
0 => "Unknown"
]
+"LotWidth": 102.0
+"HeatType": "Unknown"
+"TaxType": "Unknown"
+"LotIrregularities": "0"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10409428')"
+"HSTApplication": array:1 [
0 => "Call LBO"
]
+"RollNumber": "071471401500200"
+"SpecialDesignation": array:1 [
0 => "Unknown"
]
+"provider_name": "TRREB"
+"LotDepth": 91.0
+"ParkingSpaces": 12
}
]
+success: true
+page_size: 9
+page_count: 10890
+count: 98003
+after_key: ""
}
]
]
