Fullscreen
Compare listings
ComparePlease enter your username or email address. You will receive a link to create a new password via email.
array:2 [ "RF Query: /Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=110376&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=110376&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=110376&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=110376&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14223 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14217 +post_id: "142354" +post_author: 1 +"ListingKey": "X11904233" +"ListingId": "X11904233" +"PropertyType": "Commercial" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T17:01:12Z" +"RFModificationTimestamp": "2025-05-06T11:50:33Z" +"ListPrice": 14.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2248.0 +"City": "Hamilton" +"PostalCode": "L9C 6X6" +"UnparsedAddress": "#400 - 1030 Upper James Street, Hamilton, On L9c 6x6" +"Coordinates": array:2 [ 0 => -79.883631365509 1 => 43.2223405 ] +"Latitude": 43.2223405 +"Longitude": -79.883631365509 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Professional Office Space Located On One Of The Most Desirable Business Streets Of Hamilton. Fourth Floor Unit With Lots Of Recent Upgrades Including All Newer Lighting Fixtures, Power Outlets & Network Ports All Throughout the Unit, Newer Laminate flooring, And High End Window Blinds. Features An Open Concept Layout With A Storage Room. Elevator & Public Washrooms Available (Men, Women & Handicap).Excellent Exposure And Nearby Highway Access." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Professional Office" ] +"CityRegion": "Rolston" +"CommunityFeatures": "Major Highway,Public Transit" +"Cooling": "Yes" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T11:56:19.984639+00:00" +"CrossStreet": "Aldridge St & Upper James St" +"ExpirationDate": "2025-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-01-02T17:01:12Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-01-02T17:01:12Z" +"OriginalListPrice": 14.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1814690" +"PhotosChangeTimestamp": "2025-01-02T17:01:12Z" +"SecurityFeatures": array:1 [ 0 => "Partial" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Upper James" +"StreetNumber": "1030" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9.5" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3.5% 1st Year + 2% Balance" +"TransactionType": "For Lease" +"UnitNumber": "400" +"Utilities": "Yes" +"Zoning": "HH" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Net Lease" +"LotWidth": 125.0 +"HeatType": "Electric Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904233')" +"HandicappedEquippedYN": true +"Rail": "No" +"MinimumRentalTermMonths": 12 +"provider_name": "TRREB" +"LotDepth": 140.0 +"PossessionDetails": "Immediate" +"MaximumRentalMonthsTerm": 60 +"ShowingAppointments": "905-592-7777" +"GarageType": "Underground" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-02T17:01:12Z" +"TaxType": "TMI" +"HoldoverDays": 90 +"ElevatorType": "Public" +"OfficeApartmentArea": 2248.0 +"short_address": "Hamilton, ON L9C 6X6, CA" +"Media": array:17 [ 0 => array:26 [ "ResourceRecordKey" => "X11904233" "MediaModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11904233/thumbnail-b5fbf1be9390a6f26a7921703c879054.webp" "ShortDescription" => null "MediaKey" => "a63356ce-5e56-4465-8436-2bfb7dbcaf5b" "ImageWidth" => 1024 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "a63356ce-5e56-4465-8436-2bfb7dbcaf5b" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11904233/b5fbf1be9390a6f26a7921703c879054.webp" "MediaSize" => 106127 "SourceSystemMediaKey" => "a63356ce-5e56-4465-8436-2bfb7dbcaf5b" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 768 ] 1 => array:26 [ "ResourceRecordKey" => "X11904233" "MediaModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11904233/thumbnail-0314f67feb0aebb87596d5eed2370d36.webp" "ShortDescription" => null "MediaKey" => "0c7f21d5-8bea-46ec-a7d2-4d19c7808e2c" "ImageWidth" => 1024 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "0c7f21d5-8bea-46ec-a7d2-4d19c7808e2c" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11904233/0314f67feb0aebb87596d5eed2370d36.webp" "MediaSize" => 151495 "SourceSystemMediaKey" => "0c7f21d5-8bea-46ec-a7d2-4d19c7808e2c" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 2 => array:26 [ "ResourceRecordKey" => "X11904233" "MediaModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11904233/thumbnail-184161758a8d2b7daf620ba95e251dba.webp" "ShortDescription" => null "MediaKey" => "65d9754a-37ea-4e9e-b6fa-34a994d8e26d" "ImageWidth" => 1024 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "65d9754a-37ea-4e9e-b6fa-34a994d8e26d" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11904233/184161758a8d2b7daf620ba95e251dba.webp" "MediaSize" => 95581 "SourceSystemMediaKey" => "65d9754a-37ea-4e9e-b6fa-34a994d8e26d" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 3 => array:26 [ "ResourceRecordKey" => "X11904233" "MediaModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11904233/thumbnail-cc35c7a6d9d280957076fd00a31c76c7.webp" "ShortDescription" => null "MediaKey" => "bc2038ac-9657-4972-9860-2a54a5c1a1e1" "ImageWidth" => 1024 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "bc2038ac-9657-4972-9860-2a54a5c1a1e1" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11904233/cc35c7a6d9d280957076fd00a31c76c7.webp" "MediaSize" => 109287 "SourceSystemMediaKey" => "bc2038ac-9657-4972-9860-2a54a5c1a1e1" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 4 => array:26 [ "ResourceRecordKey" => "X11904233" "MediaModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11904233/thumbnail-6f2ca3be8c7ce5d451a9df694dc140bb.webp" "ShortDescription" => null "MediaKey" => "5259b53d-5d33-4692-a877-cabfd4f50519" "ImageWidth" => 576 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "5259b53d-5d33-4692-a877-cabfd4f50519" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11904233/6f2ca3be8c7ce5d451a9df694dc140bb.webp" "MediaSize" => 46991 "SourceSystemMediaKey" => "5259b53d-5d33-4692-a877-cabfd4f50519" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 5 => array:26 [ "ResourceRecordKey" => "X11904233" "MediaModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11904233/thumbnail-ec144e30fe3d572b6da7e10802e83962.webp" "ShortDescription" => null "MediaKey" => "de57b46d-7ce2-4496-bcc9-0abf070fba66" "ImageWidth" => 576 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "de57b46d-7ce2-4496-bcc9-0abf070fba66" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11904233/ec144e30fe3d572b6da7e10802e83962.webp" "MediaSize" => 105284 "SourceSystemMediaKey" => "de57b46d-7ce2-4496-bcc9-0abf070fba66" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 6 => array:26 [ "ResourceRecordKey" => "X11904233" "MediaModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11904233/thumbnail-d6efc7c1c14718d6d63864a8e567d2a8.webp" "ShortDescription" => null "MediaKey" => "3a820bdb-e99e-4fa4-892f-7d7a59b4c3a3" "ImageWidth" => 576 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "3a820bdb-e99e-4fa4-892f-7d7a59b4c3a3" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11904233/d6efc7c1c14718d6d63864a8e567d2a8.webp" "MediaSize" => 50619 "SourceSystemMediaKey" => "3a820bdb-e99e-4fa4-892f-7d7a59b4c3a3" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 7 => array:26 [ "ResourceRecordKey" => "X11904233" "MediaModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X11904233/thumbnail-3038bae7ec10e4b0868147996528cd43.webp" "ShortDescription" => null "MediaKey" => "d28e1acd-6ebd-42ad-9a34-129bd268f8a2" "ImageWidth" => 1024 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2025-01-02T17:01:12.416255Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "d28e1acd-6ebd-42ad-9a34-129bd268f8a2" "Order" => 7 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X11904233/3038bae7ec10e4b0868147996528cd43.webp" "MediaSize" => 74644 "SourceSystemMediaKey" => "d28e1acd-6ebd-42ad-9a34-129bd268f8a2" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 768 ] 8 => array:26 [ "ResourceRecordKey" => "X11904233" "MediaModificationTimestamp" => "2025-01-02T17:01:12.416255Z" …24 ] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] ] +"ID": "142354" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14219 +post_id: "142358" +post_author: 1 +"ListingKey": "X11904223" +"ListingId": "X11904223" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:58:37Z" +"RFModificationTimestamp": "2025-01-03T12:22:14Z" +"ListPrice": 3099900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 7400.0 +"City": "Hamilton" +"PostalCode": "L8W 3P7" +"UnparsedAddress": "230 Pritchard Road, Hamilton, On L8w 3p7" +"Coordinates": array:2 [ 0 => -79.81962987333 1 => 43.193260612791 ] +"Latitude": 43.193260612791 +"Longitude": -79.81962987333 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "KELLER WILLIAMS COMPLETE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Presenting an exceptional commercial property opportunity! Owned by the first and only owner, this well-maintained property with 7400 total sq ft. was built 36 years ago and has been a standout in the community ever since. Featuring below-market rents, this property offers tremendous upside potential for savvy investors looking to capitalize on its prime location and steady cash flow. The roof was completely redone earlier this year, ensuring long-term peace of mind, and the exterior was freshly painted just two years ago, enhancing its curb appeal. There is a skylight in every unit. Situated in an amazing location near shopping centers, major highways, and bustling commercial areas, this property offers convenience and high visibility, making it a perfect addition to any investment portfolio. Don't miss out on this rare opportunity to own a piece of prime real estate with untapped potential!" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Service Related" ] +"CityRegion": "Hannon" +"Cooling": "No" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T12:02:55.836268+00:00" +"CrossStreet": "Stonechurch Rd E" +"ExpirationDate": "2025-03-03" +"InsuranceExpense": 4000.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"MainOfficeKey": "270600" +"MaintenanceExpense": 1000.0 +"MajorChangeTimestamp": "2025-01-02T16:58:37Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OperatingExpense": "21991.0" +"OriginalEntryTimestamp": "2025-01-02T16:58:37Z" +"OriginalListPrice": 3099900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1815100" +"ParcelNumber": "169310048" +"PhotosChangeTimestamp": "2025-01-02T16:58:37Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"Sewer": "Septic" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Pritchard" +"StreetNumber": "230" +"StreetSuffix": "Road" +"TaxAnnualAmount": "16370.36" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": "Available" +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/pngvkjp/unbranded" +"Zoning": "M3" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"Expenses": "Estimated" +"GradeLevelShippingDoorsWidthFeet": 12 +"PropertyUse": "Service" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 100.23 +"HeatType": "Electric Forced Air" +"YearExpenses": 21991 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904223')" +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Included" ] +"RetailArea": 7400.0 +"GradeLevelShippingDoorsHeightFeet": 14 +"ChattelsYN": true +"provider_name": "TRREB" +"LotDepth": 150.32 +"ParkingSpaces": 36 +"PossessionDetails": "Flexible" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Other" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-02T16:58:37Z" +"TaxType": "Annual" +"ApproximateAge": "31-50" +"HoldoverDays": 90 +"ElevatorType": "None" +"RetailAreaCode": "Sq Ft" +"short_address": "Hamilton, ON L8W 3P7, CA" +"Media": array:34 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] ] +"ID": "142358" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14216 +post_id: "142362" +post_author: 1 +"ListingKey": "X11898077" +"ListingId": "X11898077" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:56:25Z" +"RFModificationTimestamp": "2025-01-14T20:22:13Z" +"ListPrice": 2950.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2000.0 +"City": "Niagara Falls" +"PostalCode": "L2E 2L9" +"UnparsedAddress": "#4685 - 4685 Queen Street, Niagara Falls, On L2e 2l9" +"Coordinates": array:2 [ 0 => -79.0750649 1 => 43.0772492 ] +"Latitude": 43.0772492 +"Longitude": -79.0750649 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER MOMENTUM REALTY, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime Commercial Space for Lease on Queen Street, Niagara Falls Located in the heart of Niagara Falls, this versatile commercial space offers an all-inclusive lease, covering taxes, maintenance, and insurance (plus HST). The property features a spacious layout, including a large retail or reception area, four additional rooms or offices, and two washrooms, making it perfectly suited for a wide range of office or service-based businesses.Zoned as Central Commercial Business, this space accommodates numerous permitted uses, such as offices, retail stores, restaurants, clinics, personal service shops, art galleries, dance studios, libraries, and more. Situated just down the road from the quickly expanding University of Niagara Falls and the Seneca Theatre, which is undergoing renovations with an exciting spring opening planned, this location is surrounded by energy and opportunity.Queen Street is a dynamic area with plenty of activity and growth, making it the ideal spot for businesses looking to establish or expand in Downtown Niagara Falls. Take advantage of this turnkey opportunity and secure the perfect space for your growing enterprise. Book a showing today!" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Retail Store Related" ] +"CityRegion": "210 - Downtown" +"Cooling": "Yes" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-12-21T23:11:18.904320+00:00" +"CrossStreet": "Queen Street & Victoria Avenue" +"ExpirationDate": "2025-02-28" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-12-20" +"MainOfficeKey": "391800" +"MajorChangeTimestamp": "2024-12-20T15:28:02Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-12-20T15:28:02Z" +"OriginalListPrice": 2950.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1793822" +"PhotosChangeTimestamp": "2024-12-20T15:28:03Z" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Queen" +"StreetNumber": "4685" +"StreetSuffix": "Street" +"TaxLegalDescription": "PT LTS 4, 9 & 10 BLK Y PL 999-1000" +"TaxYear": "2024" +"TransactionBrokerCompensation": "1/2 Months Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "4685" +"Utilities": "Yes" +"Zoning": "Central Business Commercial Zone 2" +"Water": "Municipal" +"MaximumRentalMonthsTerm": 60 +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Multi-Use" +"GarageType": "None" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"ListPriceUnit": "Gross Lease" +"LotWidth": 42.0 +"MediaChangeTimestamp": "2025-01-02T21:33:45Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "N/A" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11898077')" +"HoldoverDays": 30 +"MinimumRentalTermMonths": 24 +"RetailArea": 2000.0 +"RetailAreaCode": "Sq Ft" +"provider_name": "TRREB" +"PossessionDate": "2025-02-01" +"LotDepth": 150.0 +"Media": array:6 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] ] +"ID": "142362" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14220 +post_id: "142368" +post_author: 1 +"ListingKey": "X11904213" +"ListingId": "X11904213" +"PropertyType": "Commercial" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:53:59Z" +"RFModificationTimestamp": "2025-01-03T12:22:14Z" +"ListPrice": 17.5 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 846.0 +"City": "Hamilton" +"PostalCode": "L9C 6X6" +"UnparsedAddress": "#207 - 1030 Upper James Street, Hamilton, On L9c 6x6" +"Coordinates": array:2 [ 0 => -79.8850961 1 => 43.2217844 ] +"Latitude": 43.2217844 +"Longitude": -79.8850961 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Professional Office Space Located On One Of The Most Desirable Business Streets Of Hamilton. Second Floor Unit Includes Reception Area , 2 Offices, Board Room (Or 3rd Office), And A Kitchenette. Elevator& Public Washrooms Available (Men, Women & Handicap). Excellent Exposure And Highway Access. Building Signage Available. Utilities Included. High Traffic Area With Bus Route Stop Right In Front Of Building.846 Sq Ft. Immediate Possession Available!" +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Professional Office" ] +"CityRegion": "Yeoville" +"CommunityFeatures": "Public Transit" +"Cooling": "Yes" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T12:07:17.265960+00:00" +"CrossStreet": "Alderidge" +"ExpirationDate": "2025-12-31" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-01-02T16:53:59Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-01-02T16:53:59Z" +"OriginalListPrice": 17.5 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1812222" +"ParcelNumber": "169680218" +"PhotosChangeTimestamp": "2025-01-02T16:53:59Z" +"SecurityFeatures": array:1 [ 0 => "Partial" ] +"Sewer": "Sanitary" +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Upper James" +"StreetNumber": "1030" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9.5" +"TaxLegalDescription": "LT 62 & 63, REGISTRAR'S COMPILED PLAN 1469 ; HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3.5% first year + 2% balance" +"TransactionType": "For Lease" +"UnitNumber": "207" +"Utilities": "Yes" +"Zoning": "HH" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Sq Ft Net" +"LotWidth": 125.0 +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904213')" +"Rail": "No" +"RollNumber": "251808093109380" +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"LotDepth": 140.0 +"PossessionDetails": "Immediate" +"MaximumRentalMonthsTerm": 60 +"ShowingAppointments": "905-592-7777" +"GarageType": "Underground" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-02T16:53:59Z" +"TaxType": "TMI" +"HoldoverDays": 90 +"ElevatorType": "Public" +"OfficeApartmentArea": 846.0 +"short_address": "Hamilton, ON L9C 6X6, CA" +"Media": array:21 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] ] +"ID": "142368" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14218 +post_id: "142376" +post_author: 1 +"ListingKey": "X11904201" +"ListingId": "X11904201" +"PropertyType": "Commercial" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:50:48Z" +"RFModificationTimestamp": "2025-01-03T12:22:14Z" +"ListPrice": 4000000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5253.0 +"City": "London" +"PostalCode": "N6P 1H8" +"UnparsedAddress": "5653 Colonel Talbot Road, London, On N6p 1h8" +"Coordinates": array:2 [ 0 => -81.317454475576 1 => 42.937268572077 ] +"Latitude": 42.937268572077 +"Longitude": -81.317454475576 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE TRILAND REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Incredible investment opportunity conveniently situated in between, and seconds away from Highway 401 and 402. This premium location offers almost 4 acres of land with a fully secure perimeter and totally upgraded, well-constructed building. Featuring a massive shop, upper mezzanine, 3 offices, 2 bathrooms and a huge front foyer. Perfect for any business venture or the option to take over a turnkey, fully operational RV dealership. Flexible long closing date and lease to current owner options available. This is a rare opportunity in a rapidly growing economic area." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Other" ] +"CityRegion": "South GG" +"Cooling": "Yes" +"CountyOrParish": "Middlesex" +"CreationDate": "2025-01-03T12:10:11.229128+00:00" +"CrossStreet": "DECKER DRIVE" +"ExpirationDate": "2025-06-29" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-12-30" +"MainOfficeKey": "355000" +"MajorChangeTimestamp": "2025-01-02T16:50:48Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-02T16:50:48Z" +"OriginalListPrice": 4000000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1815132" +"PhotosChangeTimestamp": "2025-01-02T16:50:48Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"Sewer": "Septic" +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Colonel Talbot" +"StreetNumber": "5653" +"StreetSuffix": "Road" +"TaxAnnualAmount": "18896.24" +"TaxLegalDescription": "PART LOT 61 WTR WESTMINSTER TWP DESIGNATED PART 1,33R3411 CITY OF LONDON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": "Yes" +"Zoning": "AGC1 (2)" +"Water": "Well" +"FreestandingYN": true +"GradeLevelShippingDoors": 2 +"DDFYN": true +"LotType": "Building" +"GradeLevelShippingDoorsWidthFeet": 11 +"DriveInLevelShippingDoorsWidthInches": 11 +"PropertyUse": "Multi-Use" +"OfficeApartmentAreaUnit": "%" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"DriveInLevelShippingDoors": 1 +"LotWidth": 335.56 +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904201')" +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Yes" ] +"MortgageComment": "SELLER TO DISCHARGE" +"RollNumber": "393608006014300" +"RetailArea": 5253.0 +"GradeLevelShippingDoorsHeightFeet": 10 +"provider_name": "TRREB" +"LotDepth": 434.14 +"PossessionDetails": "FLEXIBLE" +"GradeLevelShippingDoorsHeightInches": 3 +"DriveInLevelShippingDoorsHeightInches": 11 +"GarageType": "None" +"DriveInLevelShippingDoorsWidthFeet": 13 +"PriorMlsStatus": "Draft" +"ClearHeightInches": 11 +"IndustrialAreaCode": "%" +"MediaChangeTimestamp": "2025-01-02T16:50:48Z" +"TaxType": "Annual" +"HoldoverDays": 60 +"DriveInLevelShippingDoorsHeightFeet": 13 +"ClearHeightFeet": 13 +"ElevatorType": "None" +"RetailAreaCode": "Sq Ft" +"short_address": "London, ON N6P 1H8, CA" +"GradeLevelShippingDoorsWidthInches": 10 +"Media": array:5 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] ] +"ID": "142376" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14215 +post_id: "142377" +post_author: 1 +"ListingKey": "X9413821" +"ListingId": "X9413821" +"PropertyType": "Commercial" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:50:12Z" +"RFModificationTimestamp": "2025-04-26T23:31:15Z" +"ListPrice": 749900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Wainfleet" +"PostalCode": "L3K 5V4" +"UnparsedAddress": "N/a Cement Road, Wainfleet, On L3k 5v4" +"Coordinates": array:2 [ 0 => -79.3764231 1 => 42.9238093 ] +"Latitude": 42.9238093 +"Longitude": -79.3764231 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER MOMENTUM REALTY, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "2.61 Acres of vacant commercial property in a high traffic + highly visible area. Situated on the corner of HWY 3 and Cement rd. this corner lot is a prime location and has zoning to support many desirable commercial uses. Endless potential." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "879 - Marshville/Winger" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T19:00:13.138068+00:00" +"CrossStreet": """ Travelling West from Port Colborne on Highway 3 Turn Left on Cement Rd.\r\n \r\n Travelling East from Wainfleet turn right onto Cement Rd.\r\n \r\n Located on corner of Cement & HWY 3 """ +"ExpirationDate": "2025-03-01" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-16" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "418.11 x 288.95" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "391800" +"MajorChangeTimestamp": "2024-09-16T13:08:47Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-16T13:08:47Z" +"OriginalListPrice": 749900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40647225" +"ParcelNumber": "641570136" +"PhotosChangeTimestamp": "2024-11-17T05:52:39Z" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "None" +"ShowingRequirements": array:3 [ 0 => "Go Direct" 1 => "List Salesperson" 2 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CEMENT" +"StreetNumber": "N/A" +"StreetSuffix": "Road" +"TaxAnnualAmount": "1456.13" +"TaxAssessedValue": 84000 +"TaxBookNumber": "271400000123725" +"TaxLegalDescription": "PT LT 1 CON 1 WFLT & PT RDAL BTN TWP HUMB & WFLT (CLOSED BY WF9687A) BEING PT 1 59R3511 EXCEPT PTS 1, 2, 3 & 4 59R11025; T/W RT OF WAY OVER PT 3 59R11025 AS IN LT162263; T/W EASEMENT OVER PART 4, 59R11025 AS IN LT168032; WAINFLEET" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "C1" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GasYNA": "Available" +"SoilTest": "No" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 288.95 +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413821')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"DevelopmentChargesPaid": array:1 [ 0 => "No" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 418.11 +"PossessionDetails": "Flexible" +"GarageType": "Unknown" +"MediaListingKey": "153971202" +"Exposure": "East" +"ElectricYNA": "Available" +"MediaChangeTimestamp": "2025-01-02T21:11:44Z" +"TaxType": "Unknown" +"HoldoverDays": 90 +"Media": array:11 [ 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] ] +"ID": "142377" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14214 +post_id: "142378" +post_author: 1 +"ListingKey": "X11904195" +"ListingId": "X11904195" +"PropertyType": "Commercial" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:48:53Z" +"RFModificationTimestamp": "2025-05-10T17:23:27Z" +"ListPrice": 17.5 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1000.0 +"City": "Hamilton" +"PostalCode": "L9C 6X6" +"UnparsedAddress": "#308 - 1030 Upper James Street, Hamilton, On L9c 6x6" +"Coordinates": array:2 [ 0 => -94.0007801 1 => 39.7371654 ] +"Latitude": 39.7371654 +"Longitude": -94.0007801 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Professional Office space located on one of the desirable business streets of Hamilton. Second floor Unit includes reception area, 2 spacious offices and a kitchenette. Elevator and Public washrooms area available (Men, Women & Handicap). Excellent exposure and Highway access. Building signage available. Utilities included. High traffic area with bus route stop right in front of building. 1,000 sq ft. Immediate possession available." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Professional Office" ] +"CityRegion": "Yeoville" +"CommunityFeatures": "Public Transit" +"Cooling": "Yes" +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T12:11:53.296927+00:00" +"CrossStreet": "Alderidge" +"ExpirationDate": "2025-12-31" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-01-02T16:48:53Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-02T16:48:53Z" +"OriginalListPrice": 17.5 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1812186" +"ParcelNumber": "169680218" +"PhotosChangeTimestamp": "2025-01-02T16:48:53Z" +"SecurityFeatures": array:1 [ 0 => "Partial" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Upper James" +"StreetNumber": "1030" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9.5" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3.5% 1st year + 2% balance" +"TransactionType": "For Lease" +"UnitNumber": "308" +"Utilities": "Yes" +"Zoning": "HH" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Sq Ft Net" +"LotWidth": 125.0 +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904195')" +"RollNumber": "251808093109380" +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"LotDepth": 140.0 +"PossessionDetails": "Immediate" +"MaximumRentalMonthsTerm": 60 +"ShowingAppointments": "905-592-7777" +"GarageType": "Underground" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-02T16:48:53Z" +"TaxType": "TMI" +"HoldoverDays": 90 +"ElevatorType": "Public" +"OfficeApartmentArea": 1000.0 +"short_address": "Hamilton, ON L9C 6X6, CA" +"Media": array:21 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] ] +"ID": "142378" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14221 +post_id: "142380" +post_author: 1 +"ListingKey": "W11904018" +"ListingId": "W11904018" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:47:59Z" +"RFModificationTimestamp": "2025-04-26T19:36:23Z" +"ListPrice": 725000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Toronto" +"PostalCode": "M6L 2N8" +"UnparsedAddress": "#512 - 2522 Keele Street, Toronto, On M6l 2n8" +"Coordinates": array:2 [ 0 => -79.4892023 1 => 43.7563495 ] +"Latitude": 43.7563495 +"Longitude": -79.4892023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CITY ALLIANCE REAL ESTATE SERVICES LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Visto Condos in the Heart of the City. This 897sq ft. 2 Split Bedroom + Den, 2 Bathroom suite offers all the luxuries of home. This Condo provides an Excellent to Downsize and remain in this Incredible, Sought After Community. This Home Features 9' Ceilings, Laminate Floors; Upgraded Kitchen W/Granite Counter Tops, Stainless Steel Appliances, Double Sink, Track Lighting; Floor To Ceiling Windows And Private Balcony. One Parking Space. Locker plus 10'x10' Storage Room conveniently located behind parking space. Amenities Include Roof Top Terrace, Gym, Party Room, Visitor Parking, Lounge And Unobstructed Views Of The City. Located Just South Of The 401 at Maple Leaf Dr. Minutes to Yorkdale, Humber Hospital, Schools, Shopping and Churches. Ttc At Front Door." +"ArchitecturalStyle": "Apartment" +"AssociationAmenities": array:4 [ 0 => "Exercise Room" 1 => "Party Room/Meeting Room" 2 => "Rooftop Deck/Garden" 3 => "Visitor Parking" ] +"AssociationFee": "878.15" +"AssociationFeeIncludes": array:6 [ 0 => "Water Included" 1 => "Common Elements Included" 2 => "Building Insurance Included" 3 => "Parking Included" 4 => "Heat Included" 5 => "Cable TV Included" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingName": "Visto Condos" +"CityRegion": "Maple Leaf" +"ConstructionMaterials": array:1 [ 0 => "Concrete" ] +"Cooling": "Central Air" +"CountyOrParish": "Toronto" +"CoveredSpaces": "1.0" +"CreationDate": "2025-01-02T16:20:08.210671+00:00" +"CrossStreet": "Keele/Maple Leaf" +"ExpirationDate": "2025-12-31" +"Inclusions": "All Appliances: Fridge, Stove, Dishwasher, Fan, Washer & Dryer. All Light Fixures and Custom Window Coverings." +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2025-01-02" +"LotSizeSource": "Other" +"MainOfficeKey": "147300" +"MajorChangeTimestamp": "2025-01-02T15:47:05Z" +"MlsStatus": "New" +"OccupantType": "Partial" +"OriginalEntryTimestamp": "2025-01-02T15:47:06Z" +"OriginalListPrice": 725000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1814722" +"ParcelNumber": "766770082" +"ParkingFeatures": "Underground" +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-01-02T16:29:44Z" +"SecurityFeatures": array:1 [ 0 => "Other" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Keele" +"StreetNumber": "2522" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2833.32" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"UnitNumber": "512" +"View": array:1 [ 0 => "Skyline" ] +"RoomsAboveGrade": 6 +"PropertyManagementCompany": "Percel Property Management" +"Locker": "Owned" +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "800-899" +"HeatSource": "Gas" +"ContractStatus": "Available" +"LockerUnit": "83" +"PropertyFeatures": array:6 [ 0 => "Public Transit" 1 => "Place Of Worship" 2 => "Park" 3 => "School" 4 => "Wooded/Treed" 5 => "Ravine" ] +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W11904018')" +"WashroomsType1Pcs": 4 +"HandicappedEquippedYN": true +"HSTApplication": array:1 [ 0 => "No" ] +"RollNumber": "190802249004778" +"LegalApartmentNumber": "12" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"provider_name": "TRREB" +"ElevatorYN": true +"ParkingSpaces": 1 +"LegalStories": "5" +"PossessionDetails": "Immediate" +"ParkingType1": "Owned" +"PermissionToContactListingBrokerToAdvertise": true +"LockerLevel": "B-P205" +"LockerNumber": "27" +"BedroomsBelowGrade": 1 +"GarageType": "Underground" +"BalconyType": "Open" +"Exposure": "East" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 2 +"SquareFootSource": "Floor Plan" +"MediaChangeTimestamp": "2025-01-02T16:29:44Z" +"WashroomsType2Pcs": 3 +"RentalItems": "None" +"ApproximateAge": "6-10" +"ParkingLevelUnit1": "B" +"HoldoverDays": 180 +"CondoCorpNumber": 2677 +"LaundryLevel": "Main Level" +"ParkingSpot1": "27" +"KitchensTotal": 1 +"Media": array:25 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] ] +"ID": "142380" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14222 +post_id: "142382" +post_author: 1 +"ListingKey": "N10402842" +"ListingId": "N10402842" +"PropertyType": "Commercial" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:46:26Z" +"RFModificationTimestamp": "2025-01-03T12:14:38Z" +"ListPrice": 9990000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2.0 +"City": "Newmarket" +"PostalCode": "L3Y 8G8" +"UnparsedAddress": "415 Pickering Crescent, Newmarket, On L3y 8g8" +"Coordinates": array:2 [ 0 => -79.4353718 1 => 44.0496186 ] +"Latitude": 44.0496186 +"Longitude": -79.4353718 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE GOLDEN RIDGE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention to Builders/Investors! Zoning Approved By Town of Newmarket For 4 Detached Houses & 24 Townhouses. Ready To Build. Excellent Location Beside Newmarket High School. Surrounded By Mutual Residential Communities. Minutes To HWY 404, Magna Community Centre, Shopping Plaza & Schools. Back On Ravine and Natural Trails." +"BuildingAreaUnits": "Acres" +"CityRegion": "Gorham-College Manor" +"CommunityFeatures": "Greenbelt/Conservation,Major Highway" +"Cooling": "Yes" +"CountyOrParish": "York" +"CreationDate": "2024-11-02T06:43:35.037056+00:00" +"CrossStreet": "Mulock/Pickering Cres" +"Exclusions": "all chattels belong to current tenant." +"ExpirationDate": "2025-06-30" +"Inclusions": "Everything beside the Current Tenant's Belongings." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-11-01" +"MainOfficeKey": "162100" +"MajorChangeTimestamp": "2024-11-02T00:58:19Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-11-02T00:58:19Z" +"OriginalListPrice": 9990000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1664834" +"ParcelNumber": "036130285" +"PhotosChangeTimestamp": "2024-11-02T00:58:19Z" +"Sewer": "Sanitary+Storm" +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Pickering" +"StreetNumber": "415" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "32235.01" +"TaxLegalDescription": "PCL 34-1 SEC 65M2836; BLK 34 PL 65M2836 ; S/T LT717516 NEWMARKET" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": "Available" +"Zoning": "(H)R4-R-167; (H)R4-F-168" +"Water": "Municipal" +"PossessionDetails": "TBA" +"PermissionToContactListingBrokerToAdvertise": true +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Designated" +"GarageType": "Outside/Surface" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"ListPriceUnit": "For Sale" +"LotWidth": 2.0 +"MediaChangeTimestamp": "2024-11-02T00:58:19Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "Annual" +"LotIrregularities": "Irregular" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N10402842')" +"HoldoverDays": 120 +"HSTApplication": array:1 [ 0 => "No" ] +"MortgageComment": "TAC" +"RollNumber": "194801005027750" +"provider_name": "TRREB" +"Media": array:4 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] ] +"ID": "142382" } ] +success: true +page_size: 9 +page_count: 13627 +count: 122635 +after_key: "" } "RF Response Time" => "0.23 seconds" ] "RF Cache Key: 767ae2e8d1d79b9a969955020ce224ca2855d52821efce3dcd9fd853000cf9be" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14405 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14238 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11904233" +"ListingId": "X11904233" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T17:01:12Z" +"RFModificationTimestamp": "2025-05-06T11:50:33Z" +"ListPrice": 14.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2248.0 +"City": "Hamilton" +"PostalCode": "L9C 6X6" +"UnparsedAddress": "#400 - 1030 Upper James Street, Hamilton, On L9c 6x6" +"Coordinates": array:2 [ 0 => -79.883631365509 1 => 43.2223405 ] +"Latitude": 43.2223405 +"Longitude": -79.883631365509 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Professional Office Space Located On One Of The Most Desirable Business Streets Of Hamilton. Fourth Floor Unit With Lots Of Recent Upgrades Including All Newer Lighting Fixtures, Power Outlets & Network Ports All Throughout the Unit, Newer Laminate flooring, And High End Window Blinds. Features An Open Concept Layout With A Storage Room. Elevator & Public Washrooms Available (Men, Women & Handicap).Excellent Exposure And Nearby Highway Access." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Professional Office" ] +"CityRegion": "Rolston" +"CommunityFeatures": array:2 [ 0 => "Major Highway" 1 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T11:56:19.984639+00:00" +"CrossStreet": "Aldridge St & Upper James St" +"ExpirationDate": "2025-12-31" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-01-02T17:01:12Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-01-02T17:01:12Z" +"OriginalListPrice": 14.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1814690" +"PhotosChangeTimestamp": "2025-01-02T17:01:12Z" +"SecurityFeatures": array:1 [ 0 => "Partial" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Upper James" +"StreetNumber": "1030" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9.5" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3.5% 1st Year + 2% Balance" +"TransactionType": "For Lease" +"UnitNumber": "400" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "HH" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Net Lease" +"LotWidth": 125.0 +"HeatType": "Electric Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904233')" +"HandicappedEquippedYN": true +"Rail": "No" +"MinimumRentalTermMonths": 12 +"provider_name": "TRREB" +"LotDepth": 140.0 +"PossessionDetails": "Immediate" +"MaximumRentalMonthsTerm": 60 +"ShowingAppointments": "905-592-7777" +"GarageType": "Underground" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-02T17:01:12Z" +"TaxType": "TMI" +"HoldoverDays": 90 +"ElevatorType": "Public" +"OfficeApartmentArea": 2248.0 +"short_address": "Hamilton, ON L9C 6X6, CA" +"Media": array:17 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14201 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11904223" +"ListingId": "X11904223" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:58:37Z" +"RFModificationTimestamp": "2025-01-03T12:22:14Z" +"ListPrice": 3099900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 7400.0 +"City": "Hamilton" +"PostalCode": "L8W 3P7" +"UnparsedAddress": "230 Pritchard Road, Hamilton, On L8w 3p7" +"Coordinates": array:2 [ 0 => -79.81962987333 1 => 43.193260612791 ] +"Latitude": 43.193260612791 +"Longitude": -79.81962987333 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "KELLER WILLIAMS COMPLETE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Presenting an exceptional commercial property opportunity! Owned by the first and only owner, this well-maintained property with 7400 total sq ft. was built 36 years ago and has been a standout in the community ever since. Featuring below-market rents, this property offers tremendous upside potential for savvy investors looking to capitalize on its prime location and steady cash flow. The roof was completely redone earlier this year, ensuring long-term peace of mind, and the exterior was freshly painted just two years ago, enhancing its curb appeal. There is a skylight in every unit. Situated in an amazing location near shopping centers, major highways, and bustling commercial areas, this property offers convenience and high visibility, making it a perfect addition to any investment portfolio. Don't miss out on this rare opportunity to own a piece of prime real estate with untapped potential!" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Service Related" ] +"CityRegion": "Hannon" +"Cooling": array:1 [ 0 => "No" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T12:02:55.836268+00:00" +"CrossStreet": "Stonechurch Rd E" +"ExpirationDate": "2025-03-03" +"InsuranceExpense": 4000.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"MainOfficeKey": "270600" +"MaintenanceExpense": 1000.0 +"MajorChangeTimestamp": "2025-01-02T16:58:37Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OperatingExpense": "21991.0" +"OriginalEntryTimestamp": "2025-01-02T16:58:37Z" +"OriginalListPrice": 3099900.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1815100" +"ParcelNumber": "169310048" +"PhotosChangeTimestamp": "2025-01-02T16:58:37Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Pritchard" +"StreetNumber": "230" +"StreetSuffix": "Road" +"TaxAnnualAmount": "16370.36" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Available" ] +"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/pngvkjp/unbranded" +"Zoning": "M3" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"Expenses": "Estimated" +"GradeLevelShippingDoorsWidthFeet": 12 +"PropertyUse": "Service" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 100.23 +"HeatType": "Electric Forced Air" +"YearExpenses": 21991 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904223')" +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Included" ] +"RetailArea": 7400.0 +"GradeLevelShippingDoorsHeightFeet": 14 +"ChattelsYN": true +"provider_name": "TRREB" +"LotDepth": 150.32 +"ParkingSpaces": 36 +"PossessionDetails": "Flexible" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Other" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-02T16:58:37Z" +"TaxType": "Annual" +"ApproximateAge": "31-50" +"HoldoverDays": 90 +"ElevatorType": "None" +"RetailAreaCode": "Sq Ft" +"short_address": "Hamilton, ON L8W 3P7, CA" +"Media": array:34 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14212 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11898077" +"ListingId": "X11898077" +"PropertyType": "Commercial Lease" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:56:25Z" +"RFModificationTimestamp": "2025-01-14T20:22:13Z" +"ListPrice": 2950.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2000.0 +"City": "Niagara Falls" +"PostalCode": "L2E 2L9" +"UnparsedAddress": "#4685 - 4685 Queen Street, Niagara Falls, On L2e 2l9" +"Coordinates": array:2 [ 0 => -79.0750649 1 => 43.0772492 ] +"Latitude": 43.0772492 +"Longitude": -79.0750649 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER MOMENTUM REALTY, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime Commercial Space for Lease on Queen Street, Niagara Falls Located in the heart of Niagara Falls, this versatile commercial space offers an all-inclusive lease, covering taxes, maintenance, and insurance (plus HST). The property features a spacious layout, including a large retail or reception area, four additional rooms or offices, and two washrooms, making it perfectly suited for a wide range of office or service-based businesses.Zoned as Central Commercial Business, this space accommodates numerous permitted uses, such as offices, retail stores, restaurants, clinics, personal service shops, art galleries, dance studios, libraries, and more. Situated just down the road from the quickly expanding University of Niagara Falls and the Seneca Theatre, which is undergoing renovations with an exciting spring opening planned, this location is surrounded by energy and opportunity.Queen Street is a dynamic area with plenty of activity and growth, making it the ideal spot for businesses looking to establish or expand in Downtown Niagara Falls. Take advantage of this turnkey opportunity and secure the perfect space for your growing enterprise. Book a showing today!" +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Retail Store Related" ] +"CityRegion": "210 - Downtown" +"Cooling": array:1 [ 0 => "Yes" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-12-21T23:11:18.904320+00:00" +"CrossStreet": "Queen Street & Victoria Avenue" +"ExpirationDate": "2025-02-28" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-12-20" +"MainOfficeKey": "391800" +"MajorChangeTimestamp": "2024-12-20T15:28:02Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-12-20T15:28:02Z" +"OriginalListPrice": 2950.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1793822" +"PhotosChangeTimestamp": "2024-12-20T15:28:03Z" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Queen" +"StreetNumber": "4685" +"StreetSuffix": "Street" +"TaxLegalDescription": "PT LTS 4, 9 & 10 BLK Y PL 999-1000" +"TaxYear": "2024" +"TransactionBrokerCompensation": "1/2 Months Rent + HST" +"TransactionType": "For Lease" +"UnitNumber": "4685" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "Central Business Commercial Zone 2" +"Water": "Municipal" +"MaximumRentalMonthsTerm": 60 +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Multi-Use" +"GarageType": "None" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"ListPriceUnit": "Gross Lease" +"LotWidth": 42.0 +"MediaChangeTimestamp": "2025-01-02T21:33:45Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "N/A" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11898077')" +"HoldoverDays": 30 +"MinimumRentalTermMonths": 24 +"RetailArea": 2000.0 +"RetailAreaCode": "Sq Ft" +"provider_name": "TRREB" +"PossessionDate": "2025-02-01" +"LotDepth": 150.0 +"Media": array:6 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14211 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11904213" +"ListingId": "X11904213" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:53:59Z" +"RFModificationTimestamp": "2025-01-03T12:22:14Z" +"ListPrice": 17.5 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 846.0 +"City": "Hamilton" +"PostalCode": "L9C 6X6" +"UnparsedAddress": "#207 - 1030 Upper James Street, Hamilton, On L9c 6x6" +"Coordinates": array:2 [ 0 => -79.8850961 1 => 43.2217844 ] +"Latitude": 43.2217844 +"Longitude": -79.8850961 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Professional Office Space Located On One Of The Most Desirable Business Streets Of Hamilton. Second Floor Unit Includes Reception Area , 2 Offices, Board Room (Or 3rd Office), And A Kitchenette. Elevator& Public Washrooms Available (Men, Women & Handicap). Excellent Exposure And Highway Access. Building Signage Available. Utilities Included. High Traffic Area With Bus Route Stop Right In Front Of Building.846 Sq Ft. Immediate Possession Available!" +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Professional Office" ] +"CityRegion": "Yeoville" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T12:07:17.265960+00:00" +"CrossStreet": "Alderidge" +"ExpirationDate": "2025-12-31" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-01-02T16:53:59Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2025-01-02T16:53:59Z" +"OriginalListPrice": 17.5 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1812222" +"ParcelNumber": "169680218" +"PhotosChangeTimestamp": "2025-01-02T16:53:59Z" +"SecurityFeatures": array:1 [ 0 => "Partial" ] +"Sewer": array:1 [ 0 => "Sanitary" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Upper James" +"StreetNumber": "1030" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9.5" +"TaxLegalDescription": "LT 62 & 63, REGISTRAR'S COMPILED PLAN 1469 ; HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3.5% first year + 2% balance" +"TransactionType": "For Lease" +"UnitNumber": "207" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "HH" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Sq Ft Net" +"LotWidth": 125.0 +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904213')" +"Rail": "No" +"RollNumber": "251808093109380" +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"LotDepth": 140.0 +"PossessionDetails": "Immediate" +"MaximumRentalMonthsTerm": 60 +"ShowingAppointments": "905-592-7777" +"GarageType": "Underground" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-02T16:53:59Z" +"TaxType": "TMI" +"HoldoverDays": 90 +"ElevatorType": "Public" +"OfficeApartmentArea": 846.0 +"short_address": "Hamilton, ON L9C 6X6, CA" +"Media": array:21 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] ] } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#11409 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11904201" +"ListingId": "X11904201" +"PropertyType": "Commercial Sale" +"PropertySubType": "Commercial Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:50:48Z" +"RFModificationTimestamp": "2025-01-03T12:22:14Z" +"ListPrice": 4000000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5253.0 +"City": "London" +"PostalCode": "N6P 1H8" +"UnparsedAddress": "5653 Colonel Talbot Road, London, On N6p 1h8" +"Coordinates": array:2 [ 0 => -81.317454475576 1 => 42.937268572077 ] +"Latitude": 42.937268572077 +"Longitude": -81.317454475576 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE TRILAND REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Incredible investment opportunity conveniently situated in between, and seconds away from Highway 401 and 402. This premium location offers almost 4 acres of land with a fully secure perimeter and totally upgraded, well-constructed building. Featuring a massive shop, upper mezzanine, 3 offices, 2 bathrooms and a huge front foyer. Perfect for any business venture or the option to take over a turnkey, fully operational RV dealership. Flexible long closing date and lease to current owner options available. This is a rare opportunity in a rapidly growing economic area." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Other" ] +"CityRegion": "South GG" +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Middlesex" +"CreationDate": "2025-01-03T12:10:11.229128+00:00" +"CrossStreet": "DECKER DRIVE" +"ExpirationDate": "2025-06-29" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-12-30" +"MainOfficeKey": "355000" +"MajorChangeTimestamp": "2025-01-02T16:50:48Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2025-01-02T16:50:48Z" +"OriginalListPrice": 4000000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1815132" +"PhotosChangeTimestamp": "2025-01-02T16:50:48Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Colonel Talbot" +"StreetNumber": "5653" +"StreetSuffix": "Road" +"TaxAnnualAmount": "18896.24" +"TaxLegalDescription": "PART LOT 61 WTR WESTMINSTER TWP DESIGNATED PART 1,33R3411 CITY OF LONDON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "AGC1 (2)" +"Water": "Well" +"FreestandingYN": true +"GradeLevelShippingDoors": 2 +"DDFYN": true +"LotType": "Building" +"GradeLevelShippingDoorsWidthFeet": 11 +"DriveInLevelShippingDoorsWidthInches": 11 +"PropertyUse": "Multi-Use" +"OfficeApartmentAreaUnit": "%" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"DriveInLevelShippingDoors": 1 +"LotWidth": 335.56 +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904201')" +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Yes" ] +"MortgageComment": "SELLER TO DISCHARGE" +"RollNumber": "393608006014300" +"RetailArea": 5253.0 +"GradeLevelShippingDoorsHeightFeet": 10 +"provider_name": "TRREB" +"LotDepth": 434.14 +"PossessionDetails": "FLEXIBLE" +"GradeLevelShippingDoorsHeightInches": 3 +"DriveInLevelShippingDoorsHeightInches": 11 +"GarageType": "None" +"DriveInLevelShippingDoorsWidthFeet": 13 +"PriorMlsStatus": "Draft" +"ClearHeightInches": 11 +"IndustrialAreaCode": "%" +"MediaChangeTimestamp": "2025-01-02T16:50:48Z" +"TaxType": "Annual" +"HoldoverDays": 60 +"DriveInLevelShippingDoorsHeightFeet": 13 +"ClearHeightFeet": 13 +"ElevatorType": "None" +"RetailAreaCode": "Sq Ft" +"short_address": "London, ON N6P 1H8, CA" +"GradeLevelShippingDoorsWidthInches": 10 +"Media": array:5 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] ] } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14234 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9413821" +"ListingId": "X9413821" +"PropertyType": "Commercial Sale" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:50:12Z" +"RFModificationTimestamp": "2025-04-26T23:31:15Z" +"ListPrice": 749900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Wainfleet" +"PostalCode": "L3K 5V4" +"UnparsedAddress": "N/a Cement Road, Wainfleet, On L3k 5v4" +"Coordinates": array:2 [ 0 => -79.3764231 1 => 42.9238093 ] +"Latitude": 42.9238093 +"Longitude": -79.3764231 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER MOMENTUM REALTY, BROKERAGE" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "2.61 Acres of vacant commercial property in a high traffic + highly visible area. Situated on the corner of HWY 3 and Cement rd. this corner lot is a prime location and has zoning to support many desirable commercial uses. Endless potential." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "879 - Marshville/Winger" +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-19T19:00:13.138068+00:00" +"CrossStreet": """ Travelling West from Port Colborne on Highway 3 Turn Left on Cement Rd.\r\n \r\n Travelling East from Wainfleet turn right onto Cement Rd.\r\n \r\n Located on corner of Cement & HWY 3 """ +"ExpirationDate": "2025-03-01" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-16" +"LotFeatures": array:1 [ 0 => "Irregular Lot" ] +"LotSizeDimensions": "418.11 x 288.95" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "391800" +"MajorChangeTimestamp": "2024-09-16T13:08:47Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-09-16T13:08:47Z" +"OriginalListPrice": 749900.0 +"OriginatingSystemID": "nar" +"OriginatingSystemKey": "40647225" +"ParcelNumber": "641570136" +"PhotosChangeTimestamp": "2024-11-17T05:52:39Z" +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": array:1 [ 0 => "None" ] +"ShowingRequirements": array:3 [ 0 => "Go Direct" 1 => "List Salesperson" 2 => "Showing System" ] +"SourceSystemID": "nar" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CEMENT" +"StreetNumber": "N/A" +"StreetSuffix": "Road" +"TaxAnnualAmount": "1456.13" +"TaxAssessedValue": 84000 +"TaxBookNumber": "271400000123725" +"TaxLegalDescription": "PT LT 1 CON 1 WFLT & PT RDAL BTN TWP HUMB & WFLT (CLOSED BY WF9687A) BEING PT 1 59R3511 EXCEPT PTS 1, 2, 3 & 4 59R11025; T/W RT OF WAY OVER PT 3 59R11025 AS IN LT162263; T/W EASEMENT OVER PART 4, 59R11025 AS IN LT168032; WAINFLEET" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "C1" +"Water": "Municipal" +"DDFYN": true +"LotType": "Unknown" +"PropertyUse": "Unknown" +"GasYNA": "Available" +"SoilTest": "No" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 288.95 +"HeatType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9413821')" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"DevelopmentChargesPaid": array:1 [ 0 => "No" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 418.11 +"PossessionDetails": "Flexible" +"GarageType": "Unknown" +"MediaListingKey": "153971202" +"Exposure": "East" +"ElectricYNA": "Available" +"MediaChangeTimestamp": "2025-01-02T21:11:44Z" +"TaxType": "Unknown" +"HoldoverDays": 90 +"Media": array:11 [ 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] ] } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14235 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X11904195" +"ListingId": "X11904195" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:48:53Z" +"RFModificationTimestamp": "2025-05-10T17:23:27Z" +"ListPrice": 17.5 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1000.0 +"City": "Hamilton" +"PostalCode": "L9C 6X6" +"UnparsedAddress": "#308 - 1030 Upper James Street, Hamilton, On L9c 6x6" +"Coordinates": array:2 [ 0 => -94.0007801 1 => 39.7371654 ] +"Latitude": 39.7371654 +"Longitude": -94.0007801 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "RE/MAX ESCARPMENT REALTY INC." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Professional Office space located on one of the desirable business streets of Hamilton. Second floor Unit includes reception area, 2 spacious offices and a kitchenette. Elevator and Public washrooms area available (Men, Women & Handicap). Excellent exposure and Highway access. Building signage available. Utilities included. High traffic area with bus route stop right in front of building. 1,000 sq ft. Immediate possession available." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Professional Office" ] +"CityRegion": "Yeoville" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Hamilton" +"CreationDate": "2025-01-03T12:11:53.296927+00:00" +"CrossStreet": "Alderidge" +"ExpirationDate": "2025-12-31" +"HoursDaysOfOperation": array:1 [ 0 => "Open 7 Days" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2025-01-02" +"MainOfficeKey": "184000" +"MajorChangeTimestamp": "2025-01-02T16:48:53Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2025-01-02T16:48:53Z" +"OriginalListPrice": 17.5 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1812186" +"ParcelNumber": "169680218" +"PhotosChangeTimestamp": "2025-01-02T16:48:53Z" +"SecurityFeatures": array:1 [ 0 => "Partial" ] +"ShowingRequirements": array:1 [ 0 => "List Brokerage" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Upper James" +"StreetNumber": "1030" +"StreetSuffix": "Street" +"TaxAnnualAmount": "9.5" +"TaxYear": "2024" +"TransactionBrokerCompensation": "3.5% 1st year + 2% balance" +"TransactionType": "For Lease" +"UnitNumber": "308" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "HH" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Sq Ft Net" +"LotWidth": 125.0 +"HeatType": "Gas Forced Air Closed" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X11904195')" +"RollNumber": "251808093109380" +"MinimumRentalTermMonths": 36 +"provider_name": "TRREB" +"LotDepth": 140.0 +"PossessionDetails": "Immediate" +"MaximumRentalMonthsTerm": 60 +"ShowingAppointments": "905-592-7777" +"GarageType": "Underground" +"PriorMlsStatus": "Draft" +"MediaChangeTimestamp": "2025-01-02T16:48:53Z" +"TaxType": "TMI" +"HoldoverDays": 90 +"ElevatorType": "Public" +"OfficeApartmentArea": 1000.0 +"short_address": "Hamilton, ON L9C 6X6, CA" +"Media": array:21 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] ] } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14236 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W11904018" +"ListingId": "W11904018" +"PropertyType": "Residential" +"PropertySubType": "Condo Apartment" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:47:59Z" +"RFModificationTimestamp": "2025-04-26T19:36:23Z" +"ListPrice": 725000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Toronto W04" +"PostalCode": "M6L 2N8" +"UnparsedAddress": "#512 - 2522 Keele Street, Toronto, On M6l 2n8" +"Coordinates": array:2 [ 0 => -79.4892023 1 => 43.7563495 ] +"Latitude": 43.7563495 +"Longitude": -79.4892023 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "CITY ALLIANCE REAL ESTATE SERVICES LTD." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to Visto Condos in the Heart of the City. This 897sq ft. 2 Split Bedroom + Den, 2 Bathroom suite offers all the luxuries of home. This Condo provides an Excellent to Downsize and remain in this Incredible, Sought After Community. This Home Features 9' Ceilings, Laminate Floors; Upgraded Kitchen W/Granite Counter Tops, Stainless Steel Appliances, Double Sink, Track Lighting; Floor To Ceiling Windows And Private Balcony. One Parking Space. Locker plus 10'x10' Storage Room conveniently located behind parking space. Amenities Include Roof Top Terrace, Gym, Party Room, Visitor Parking, Lounge And Unobstructed Views Of The City. Located Just South Of The 401 at Maple Leaf Dr. Minutes to Yorkdale, Humber Hospital, Schools, Shopping and Churches. Ttc At Front Door." +"ArchitecturalStyle": array:1 [ 0 => "Apartment" ] +"AssociationAmenities": array:4 [ 0 => "Exercise Room" 1 => "Party Room/Meeting Room" 2 => "Rooftop Deck/Garden" 3 => "Visitor Parking" ] +"AssociationFee": "878.15" +"AssociationFeeIncludes": array:6 [ 0 => "Water Included" 1 => "Common Elements Included" 2 => "Building Insurance Included" 3 => "Parking Included" 4 => "Heat Included" 5 => "Cable TV Included" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingName": "Visto Condos" +"CityRegion": "Maple Leaf" +"ConstructionMaterials": array:1 [ 0 => "Concrete" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "Toronto" +"CoveredSpaces": "1.0" +"CreationDate": "2025-01-02T16:20:08.210671+00:00" +"CrossStreet": "Keele/Maple Leaf" +"ExpirationDate": "2025-12-31" +"Inclusions": "All Appliances: Fridge, Stove, Dishwasher, Fan, Washer & Dryer. All Light Fixures and Custom Window Coverings." +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Ensuite" ] +"ListingContractDate": "2025-01-02" +"LotSizeSource": "Other" +"MainOfficeKey": "147300" +"MajorChangeTimestamp": "2025-01-02T15:47:05Z" +"MlsStatus": "New" +"OccupantType": "Partial" +"OriginalEntryTimestamp": "2025-01-02T15:47:06Z" +"OriginalListPrice": 725000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1814722" +"ParcelNumber": "766770082" +"ParkingFeatures": array:1 [ 0 => "Underground" ] +"ParkingTotal": "1.0" +"PetsAllowed": array:1 [ 0 => "Restricted" ] +"PhotosChangeTimestamp": "2025-01-02T16:29:44Z" +"SecurityFeatures": array:1 [ 0 => "Other" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Keele" +"StreetNumber": "2522" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2833.32" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"UnitNumber": "512" +"View": array:1 [ 0 => "Skyline" ] +"RoomsAboveGrade": 6 +"PropertyManagementCompany": "Percel Property Management" +"Locker": "Owned" +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"LivingAreaRange": "800-899" +"HeatSource": "Gas" +"ContractStatus": "Available" +"LockerUnit": "83" +"PropertyFeatures": array:6 [ 0 => "Public Transit" 1 => "Place Of Worship" 2 => "Park" 3 => "School" 4 => "Wooded/Treed" 5 => "Ravine" ] +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W11904018')" +"WashroomsType1Pcs": 4 +"HandicappedEquippedYN": true +"HSTApplication": array:1 [ 0 => "No" ] +"RollNumber": "190802249004778" +"LegalApartmentNumber": "12" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"provider_name": "TRREB" +"ElevatorYN": true +"ParkingSpaces": 1 +"LegalStories": "5" +"PossessionDetails": "Immediate" +"ParkingType1": "Owned" +"PermissionToContactListingBrokerToAdvertise": true +"LockerLevel": "B-P205" +"LockerNumber": "27" +"BedroomsBelowGrade": 1 +"GarageType": "Underground" +"BalconyType": "Open" +"Exposure": "East" +"PriorMlsStatus": "Draft" +"BedroomsAboveGrade": 2 +"SquareFootSource": "Floor Plan" +"MediaChangeTimestamp": "2025-01-02T16:29:44Z" +"WashroomsType2Pcs": 3 +"RentalItems": "None" +"ApproximateAge": "6-10" +"ParkingLevelUnit1": "B" +"HoldoverDays": 180 +"CondoCorpNumber": 2677 +"LaundryLevel": "Main Level" +"ParkingSpot1": "27" +"KitchensTotal": 1 +"Media": array:25 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] ] } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14237 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "N10402842" +"ListingId": "N10402842" +"PropertyType": "Commercial Sale" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-01-02T16:46:26Z" +"RFModificationTimestamp": "2025-01-03T12:14:38Z" +"ListPrice": 9990000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2.0 +"City": "Newmarket" +"PostalCode": "L3Y 8G8" +"UnparsedAddress": "415 Pickering Crescent, Newmarket, On L3y 8g8" +"Coordinates": array:2 [ 0 => -79.4353718 1 => 44.0496186 ] +"Latitude": 44.0496186 +"Longitude": -79.4353718 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "ROYAL LEPAGE GOLDEN RIDGE REALTY" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Attention to Builders/Investors! Zoning Approved By Town of Newmarket For 4 Detached Houses & 24 Townhouses. Ready To Build. Excellent Location Beside Newmarket High School. Surrounded By Mutual Residential Communities. Minutes To HWY 404, Magna Community Centre, Shopping Plaza & Schools. Back On Ravine and Natural Trails." +"BuildingAreaUnits": "Acres" +"CityRegion": "Gorham-College Manor" +"CommunityFeatures": array:2 [ 0 => "Greenbelt/Conservation" 1 => "Major Highway" ] +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "York" +"CreationDate": "2024-11-02T06:43:35.037056+00:00" +"CrossStreet": "Mulock/Pickering Cres" +"Exclusions": "all chattels belong to current tenant." +"ExpirationDate": "2025-06-30" +"Inclusions": "Everything beside the Current Tenant's Belongings." +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-11-01" +"MainOfficeKey": "162100" +"MajorChangeTimestamp": "2024-11-02T00:58:19Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-11-02T00:58:19Z" +"OriginalListPrice": 9990000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1664834" +"ParcelNumber": "036130285" +"PhotosChangeTimestamp": "2024-11-02T00:58:19Z" +"Sewer": array:1 [ 0 => "Sanitary+Storm" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Pickering" +"StreetNumber": "415" +"StreetSuffix": "Crescent" +"TaxAnnualAmount": "32235.01" +"TaxLegalDescription": "PCL 34-1 SEC 65M2836; BLK 34 PL 65M2836 ; S/T LT717516 NEWMARKET" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Available" ] +"Zoning": "(H)R4-R-167; (H)R4-F-168" +"Water": "Municipal" +"PossessionDetails": "TBA" +"PermissionToContactListingBrokerToAdvertise": true +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Designated" +"GarageType": "Outside/Surface" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"ListPriceUnit": "For Sale" +"LotWidth": 2.0 +"MediaChangeTimestamp": "2024-11-02T00:58:19Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "Annual" +"LotIrregularities": "Irregular" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('N10402842')" +"HoldoverDays": 120 +"HSTApplication": array:1 [ 0 => "No" ] +"MortgageComment": "TAC" +"RollNumber": "194801005027750" +"provider_name": "TRREB" +"Media": array:4 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] ] } ] +success: true +page_size: 9 +page_count: 13627 +count: 122635 +after_key: "" } ] ]
