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=113949&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113949&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113949&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113949&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14224 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14218 +post_id: "161915" +post_author: 1 +"ListingKey": "W10343470" +"ListingId": "W10343470" +"PropertyType": "Commercial" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:18:54Z" +"RFModificationTimestamp": "2024-11-27T14:46:44Z" +"ListPrice": 36000000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 109106.0 +"City": "Oakville" +"PostalCode": "L6H 1A7" +"UnparsedAddress": "1375-* North Service Road, Oakville, On L6h 1a7" +"Coordinates": array:2 [ 0 => -79.7613358 1 => 43.3988969 ] +"Latitude": 43.3988969 +"Longitude": -79.7613358 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Introducing a rare investment opportunity: 100% fully leased flex office building with exceptional visibility to the QEW. The Joshua Creek Corporate (JCC) centre spans 8.38 acres and boasts 109,106 SF of prime office space. Home to some of Oakville's most prestigious tenants, JCC features attractive in-place rents, long-term leases, and versatile unit sizes to accommodate diverse tenancy needs. Each unit is meticulously built to the highest standards, offering an outstanding environment for businesses. The property provides ample parking, excellent exposure to the QEW, and convenient access to transit and a variety of amenities." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Iroquois Ridge South" +"Cooling": "Yes" +"CountyOrParish": "Halton" +"CreationDate": "2024-11-02T20:10:09.162951+00:00" +"CrossStreet": "Eigth Line / North Service Rd" +"ExpirationDate": "2025-03-24" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-11-01" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2024-11-01T18:54:05Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-11-01T18:54:05Z" +"OriginalListPrice": 36000000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1663190" +"ParcelNumber": "249000403" +"PhotosChangeTimestamp": "2024-11-26T21:18:54Z" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"Sewer": "Sanitary+Storm" +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "North Service" +"StreetNumber": "1375-*" +"StreetSuffix": "Road" +"TaxAnnualAmount": "490931.76" +"TaxLegalDescription": "PT LT 7, CON 2 TRAF SDS, PTS 2,3 20R19939 SUBJECT TO AN EASEMENT AS IN 283292 TOGETHER WITH AN EASEMENT OVER PTS 2,3 20R19404 AS IN HR1126781 TOGETHER WITH AN EASEMENT OVER PTS 2,3 20R19577 & PT 2 20R19577 & PT 2 20R19731 AS IN HR1214095 TOGETHER WITH AN EASEMENT OVER PT 1 20R19577 & PT 1 20R19731 AS IN HR 1214096 SUBJECT TO AN EASEMENT IN GROSS AS IN HR1027592 TOGETHER WITH AN EASEMENT OVER PT 1 20R20107 AS IN HR1282829 TOWN OF OAKVILLE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "0.5% of sale price" +"TransactionType": "For Sale" +"Utilities": "Yes" +"Zoning": "E2" +"Water": "Municipal" +"PossessionDetails": "TBD" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"GarageType": "Outside/Surface" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"ListPriceUnit": "For Sale" +"LotWidth": 601.5 +"MediaChangeTimestamp": "2024-11-26T21:18:54Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "Annual" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10343470')" +"HoldoverDays": 60 +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Yes" ] +"RollNumber": "240104025012905" +"ElevatorType": "None" +"OfficeApartmentArea": 109106.0 +"provider_name": "TRREB" +"LotDepth": 674.96 +"Media": array:7 [ 0 => array:26 [ "ResourceRecordKey" => "W10343470" "MediaModificationTimestamp" => "2024-11-01T18:54:05.472126Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10343470/thumbnail-f16a043106a50a9d8fe1f6eefd6bfbad.webp" "ShortDescription" => null "MediaKey" => "f948fc4e-7d44-4af9-b731-262839735663" "ImageWidth" => 688 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-01T18:54:05.472126Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "f948fc4e-7d44-4af9-b731-262839735663" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W10343470/f16a043106a50a9d8fe1f6eefd6bfbad.webp" "MediaSize" => 109318 "SourceSystemMediaKey" => "f948fc4e-7d44-4af9-b731-262839735663" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 475 ] 1 => array:26 [ "ResourceRecordKey" => "W10343470" "MediaModificationTimestamp" => "2024-11-26T21:18:48.559806Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10343470/thumbnail-64c8d94575f74252fa06e56afba4d925.webp" "ShortDescription" => null "MediaKey" => "49d289b3-6c46-45ce-ad96-11bf840fe73b" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-26T21:18:48.559806Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "49d289b3-6c46-45ce-ad96-11bf840fe73b" "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W10343470/64c8d94575f74252fa06e56afba4d925.webp" "MediaSize" => 1869028 "SourceSystemMediaKey" => "49d289b3-6c46-45ce-ad96-11bf840fe73b" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2560 ] 2 => array:26 [ "ResourceRecordKey" => "W10343470" "MediaModificationTimestamp" => "2024-11-26T21:18:49.589629Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10343470/thumbnail-3c36c99966d5f23a524496233c76e5f8.webp" "ShortDescription" => null "MediaKey" => "53f16276-724f-4a9f-b781-251ec4b3296e" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-26T21:18:49.589629Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "53f16276-724f-4a9f-b781-251ec4b3296e" "Order" => 2 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W10343470/3c36c99966d5f23a524496233c76e5f8.webp" "MediaSize" => 1723848 "SourceSystemMediaKey" => "53f16276-724f-4a9f-b781-251ec4b3296e" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2560 ] 3 => array:26 [ "ResourceRecordKey" => "W10343470" "MediaModificationTimestamp" => "2024-11-26T21:18:50.870323Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10343470/thumbnail-496e78c69186a8326ec3a1cc1fca39d0.webp" "ShortDescription" => null "MediaKey" => "91035048-db18-48cf-b93e-80d3e3339893" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-26T21:18:50.870323Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "91035048-db18-48cf-b93e-80d3e3339893" "Order" => 3 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W10343470/496e78c69186a8326ec3a1cc1fca39d0.webp" "MediaSize" => 1536906 "SourceSystemMediaKey" => "91035048-db18-48cf-b93e-80d3e3339893" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2560 ] 4 => array:26 [ "ResourceRecordKey" => "W10343470" "MediaModificationTimestamp" => "2024-11-26T21:18:51.824096Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10343470/thumbnail-034f402aa87f109e7d769ddf16b9dd5c.webp" "ShortDescription" => null "MediaKey" => "9ee20535-a38a-482e-a579-af2fbbadcee9" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-26T21:18:51.824096Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "9ee20535-a38a-482e-a579-af2fbbadcee9" "Order" => 4 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W10343470/034f402aa87f109e7d769ddf16b9dd5c.webp" "MediaSize" => 1252967 "SourceSystemMediaKey" => "9ee20535-a38a-482e-a579-af2fbbadcee9" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2560 ] 5 => array:26 [ "ResourceRecordKey" => "W10343470" "MediaModificationTimestamp" => "2024-11-26T21:18:53.139735Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10343470/thumbnail-b7b20172f41164d6fc2bc37bea61029a.webp" "ShortDescription" => null "MediaKey" => "342e75cf-4005-41f3-a68d-3f192fc84832" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-26T21:18:53.139735Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "342e75cf-4005-41f3-a68d-3f192fc84832" "Order" => 5 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W10343470/b7b20172f41164d6fc2bc37bea61029a.webp" "MediaSize" => 1356402 "SourceSystemMediaKey" => "342e75cf-4005-41f3-a68d-3f192fc84832" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2560 ] 6 => array:26 [ "ResourceRecordKey" => "W10343470" "MediaModificationTimestamp" => "2024-11-26T21:18:53.850993Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10343470/thumbnail-eea53207c6826368f6727be92e67eff8.webp" "ShortDescription" => null "MediaKey" => "60dfcfff-b7bd-4b81-9995-994c0550b388" "ImageWidth" => 3840 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-26T21:18:53.850993Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "60dfcfff-b7bd-4b81-9995-994c0550b388" "Order" => 6 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W10343470/eea53207c6826368f6727be92e67eff8.webp" "MediaSize" => 1605034 "SourceSystemMediaKey" => "60dfcfff-b7bd-4b81-9995-994c0550b388" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => null "ImageHeight" => 2160 ] ] +"ID": "161915" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14220 +post_id: "161917" +post_author: 1 +"ListingKey": "X9357293" +"ListingId": "X9357293" +"PropertyType": "Commercial" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:15:21Z" +"RFModificationTimestamp": "2025-04-30T05:47:09Z" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1016.0 +"City": "Welland" +"PostalCode": "L3C 1E8" +"UnparsedAddress": "20 Patricia Ave, Welland, Ontario L3C 1E8" +"Coordinates": array:2 [ 0 => -79.2509505 1 => 43.0041574 ] +"Latitude": 43.0041574 +"Longitude": -79.2509505 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER ADVANTAGE REAL ESTATE INC" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This legal duplex is a 4-level backsplit located on a quiet dead-end street, and is surrounded by an array of amenities. The upper unit has an open-concept main floor layout with 3 bedrooms and a bathroom located on the upper level. The lower unit has an abundance of natural light and is a 2 bedroom apartment complete with stainless steel, and a stackable washer and dryer. The furnace and AC are only 2 years, and the lower unit is rented at market rent plus hydro. Take advantage of this great opportunity to own multigenerational home or investment property in one of the most desirable areas of Welland." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Apts - 2 To 5 Units" ] +"CityRegion": "N. Welland" +"Cooling": "Yes" +"CountyOrParish": "Niagara" +"CreationDate": "2024-09-29T22:14:17.485278+00:00" +"CrossStreet": "Off Thorold Road between Niagara St. and Aqueduct" +"Exclusions": "Tenants' belongings" +"ExpirationDate": "2024-12-18" +"Inclusions": "Stove x2, Fridge x2, Dishwasher x2, Washer x2, Dryer 2" +"InsuranceExpense": 2400.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-19" +"LotSizeSource": "MPAC" +"MainOfficeKey": "449200" +"MajorChangeTimestamp": "2024-11-26T21:00:07Z" +"MlsStatus": "New" +"NetOperatingIncome": 35128.0 +"OccupantType": "Tenant" +"OperatingExpense": "10172.0" +"OriginalEntryTimestamp": "2024-09-19T13:07:06Z" +"OriginalListPrice": 599000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1512364" +"ParcelNumber": "640860299" +"PhotosChangeTimestamp": "2024-11-26T21:00:07Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "See Brokerage Remarks" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Patricia" +"StreetNumber": "20" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3572.0" +"TaxAssessedValue": 198000 +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% + HST" +"TransactionType": "For Sale" +"Utilities": "Available" +"Zoning": "RL1" +"TotalAreaCode": "Sq Ft" +"lease": "Sale" +"class_name": "CommercialProperty" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"Expenses": "Estimated" +"PropertyUse": "Apartment" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 37.3 +"HeatType": "Gas Forced Air Open" +"YearExpenses": 2024 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9357293')" +"HSTApplication": array:1 [ 0 => "Included" ] +"RollNumber": "271901000409300" +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 114.0 +"PossessionDetails": "Imm W/Tenant" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "None" +"PriorMlsStatus": "Draft" +"TaxesExpense": 3572.0 +"MediaChangeTimestamp": "2024-11-26T21:00:07Z" +"TaxType": "Annual" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 60 +"HeatingExpenses": 2400.0 +"GrossRevenue": 45300.0 +"Media": array:31 [ 0 => array:26 [ "ResourceRecordKey" => "X9357293" "MediaModificationTimestamp" => "2024-11-26T21:00:07.07101Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9357293/thumbnail-345f644caf1cc782cb9148acffd4f425.webp" "ShortDescription" => null "MediaKey" => "1eb980b6-3eff-49de-bc16-6d6f21633b1f" "ImageWidth" => 1024 "ClassName" => "Commercial" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-26T21:00:07.07101Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => "1eb980b6-3eff-49de-bc16-6d6f21633b1f" "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/X9357293/345f644caf1cc782cb9148acffd4f425.webp" "MediaSize" => 141153 "SourceSystemMediaKey" => "1eb980b6-3eff-49de-bc16-6d6f21633b1f" "SourceSystemID" => "A00001796" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => null "ImageHeight" => 666 ] 1 => array:26 [ "ResourceRecordKey" => "X9357293" "MediaModificationTimestamp" => "2024-11-26T21:00:07.07101Z" "ResourceName" => "Property" "SourceSystemName" => "Toronto Regional Real Estate Board" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/X9357293/thumbnail-252f5d03b8cea8522770ae805c4dbd1d.webp" "ShortDescription" => null "MediaKey" => "41531e80-17da-4506-8fe4-05675b62209c" "ImageWidth" => 1024 …18 ] 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] ] +"ID": "161917" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14217 +post_id: "161920" +post_author: 1 +"ListingKey": "X9380021" +"ListingId": "X9380021" +"PropertyType": "Commercial" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:13:32Z" +"RFModificationTimestamp": "2025-04-26T02:48:27Z" +"ListPrice": 2995.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2628.0 +"City": "Welland" +"PostalCode": "L3C 3W9" +"UnparsedAddress": "#4 - 547 Thorold Road, Welland, On L3c 3w9" +"Coordinates": array:2 [ 0 => -79.2812199 1 => 43.0037372 ] +"Latitude": 43.0037372 +"Longitude": -79.2812199 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER ADVANTAGE REAL ESTATE INC" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A COST_SHARING medical space is available for lease, currently set up for use as a dental office. This versatile space is ideal for a range of healthcare professionals, including dentists, orthodontists, chiropractors, physiotherapists, and more. The layout includes 3 private patient rooms, an employee washroom, a private office, and access to shared facilities such as a welcoming reception area, a laboratory, and a washroom for patients. With a total unit size of 2,628 sq ft, this property offers a professional setting designed to support seamless patient care and daily operations. The cost-sharing structure allows for shared expenses on utilities and common areas, making it an excellent opportunity for professionals seeking a collaborative and cost-efficient environment." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Other" ] +"CityRegion": "N. Welland" +"Cooling": "Yes" +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-04T12:59:37.788425+00:00" +"CrossStreet": "S. PELHAM RD TO THOROLD RD." +"ExpirationDate": "2025-01-01" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-03" +"MainOfficeKey": "449200" +"MajorChangeTimestamp": "2024-11-26T21:13:32Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-03T14:46:03Z" +"OriginalListPrice": 3200.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1568098" +"ParcelNumber": "649840004" +"PhotosChangeTimestamp": "2024-11-26T20:56:07Z" +"PreviousListPrice": 3200.0 +"PriceChangeTimestamp": "2024-11-26T21:13:32Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:2 [ 0 => "See Brokerage Remarks" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Thorold" +"StreetNumber": "547" +"StreetSuffix": "Road" +"TaxAssessedValue": 288000 +"TaxLegalDescription": "UNIT 4, LEVEL 1, NIAGARA SOUTH STANDARD CONDOMINIUM PLAN NO. 184 AND ITS APPURTENANT INTEREST CITY OF WELLAND" +"TaxYear": "2024" +"TransactionBrokerCompensation": "ONE HALF OF ONE MONTHS' RENT" +"TransactionType": "For Lease" +"UnitNumber": "4" +"Utilities": "Available" +"Zoning": "CC1, O1" +"Water": "Municipal" +"FreestandingYN": true +"WashroomsType1": 1 +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Month" +"HeatType": "Electric Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9380021')" +"RollNumber": "271901001109804" +"MinimumRentalTermMonths": 12 +"AssessmentYear": 2024 +"provider_name": "TRREB" +"ParkingSpaces": 1 +"PossessionDetails": "Immediate" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Reserved/Assignd" +"PriorMlsStatus": "New" +"MediaChangeTimestamp": "2024-11-26T20:56:07Z" +"TaxType": "N/A" +"HoldoverDays": 90 +"ElevatorType": "None" +"OfficeApartmentArea": 2628.0 +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] +"ID": "161920" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14221 +post_id: "161928" +post_author: 1 +"ListingKey": "X10403678" +"ListingId": "X10403678" +"PropertyType": "Commercial" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:08:27Z" +"RFModificationTimestamp": "2025-04-26T02:52:58Z" +"ListPrice": 1599000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 4200.0 +"City": "Hamilton" +"PostalCode": "L8H 4S8" +"UnparsedAddress": "289-293 Kenilworth N Avenue, Hamilton, On L8h 4s8" +"Coordinates": array:2 [ 0 => -79.805823 1 => 43.2503014 ] +"Latitude": 43.2503014 +"Longitude": -79.805823 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime investment opportunity located at one of the highest-traffic corners in the city! This fully-renovated, fully-tenanted building is well-positioned for either the experienced or first-time investor. Includes 4 beautifully renovated apartments, a strong anchor commercial tenant on the ground floor, and a brand new tenancy with a strong lease in the previously-vacant commercial unit. Additional income comes from rooftop billboards. Currently priced based on a 6.3% cap rate, this property is capable of achieving a stronger cap rate with minimal effort in the short-term. In exceptional condition, this property comes with a recent, clean Phase II Environmental. Plus, there are no parking spots, balconies, or elevators to maintain or cause issues! With significant opportunity for upside as well, this is an excellent, low-maintenance investment with a strong returns and more upside to be realized!" +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Crown Point" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T22:34:01.435444+00:00" +"CrossStreet": "SW Corner of Barton and Kenilworth" +"DaysOnMarket": 284 +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-26" +"LotSizeDimensions": "35 x 64.66" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-09-26T11:25:12Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-26T11:25:12Z" +"OriginalListPrice": 1599000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40653611" +"ParcelNumber": "172480089" +"PhotosChangeTimestamp": "2024-09-26T13:21:48Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "List Salesperson" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "KENILWORTH" +"StreetNumber": "289-293" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "10180.79" +"TaxAssessedValue": 331000 +"TaxBookNumber": "251804031555850" +"TaxLegalDescription": "PT LT 20, BLK T, PL 395 , AS IN CD182423 ; HAMILTON" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "C5a" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "154325762" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 64.66 +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403678')" +"HoldoverDays": 30 +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RetailArea": 4200.0 +"AssessmentYear": 2016 +"provider_name": "TRREB" +"LotDepth": 35.0 +"ID": "161928" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14219 +post_id: "161930" +post_author: 1 +"ListingKey": "W10404508" +"ListingId": "W10404508" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:08:08Z" +"RFModificationTimestamp": "2024-11-27T14:56:51Z" +"ListPrice": 6700.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3129.0 +"City": "Oakville" +"PostalCode": "L6K 0H4" +"UnparsedAddress": "184 Dorval Drive, Oakville, On L6k 0h4" +"Coordinates": array:2 [ 0 => -79.6975039 1 => 43.4446744 ] +"Latitude": 43.4446744 +"Longitude": -79.6975039 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rarely offered, unique Luxury 4-bedroom, 4-bathroom townhouse boasting the epitome of sophistication and elegance. This gem features a private elevator with access to all floors and a custom-built kitchen w/ highend appliances, an island and a butler's pantry. The cozy family room seamlessly merges with the dining area, leading to an outdoor terrace equipped with a gas line, ideal for year-round BBQs and al fresco dining experiences. Ascend to the magical rooftop vistas, a haven for outdoor gatherings and breathtaking views of the surrounding cityscape. With a 4th bedroom option on the main floor, a double-sided fireplace, and a master ensuite featuring a Juliet balcony, every detail of this home exudes luxury and comfort with high end expertly crafted finishes. Complementing its lavish amenities is a rare 3-car garage. Designed for minimum maintenance and maximum enjoyment, this townhouse presents the ultimate lifestyle home. Minutes away from the shores of Lake Ontario, It is located in Oakville's most coveted and luxurious community. Schedule your private viewing today and unlock the door to your exquisite new home. Central, Near private college, Public schools parks, shops restaurants. Min from lakeshore, double-sided fireplace, 3car , dishwasher, washer/dryer, microwave, fridge, CVAC, Gasline for BBQ. Optional: Furniture can be included in the Rent." +"AccessibilityFeatures": array:1 [ 0 => "Other" ] +"ArchitecturalStyle": "3-Storey" +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Old Oakville" +"CoListOfficeKey": "NONMEM" +"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"CoListOfficePhone": "416-960-9995" +"ConstructionMaterials": array:1 [ 0 => "Stone" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "3.0" +"CreationDate": "2024-11-03T23:03:33.993177+00:00" +"CrossStreet": "Rebecca/Dorval" +"DaysOnMarket": 253 +"DirectionFaces": "West" +"Disclosures": array:1 [ 0 => "Unknown" ] +"ExpirationDate": "2024-12-31" +"ExteriorFeatures": "Porch,Privacy" +"FireplaceFeatures": array:1 [ 0 => "Family Room" ] +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove" +"InteriorFeatures": "Central Vacuum" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"LeaseTerm": "12 Months" +"ListingContractDate": "2024-10-27" +"LotSizeDimensions": "59.78 x 23.53" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-27T15:54:22Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-27T15:54:22Z" +"OriginalListPrice": 6700.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40669734" +"ParcelNumber": "248230241" +"ParkingFeatures": "Other" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2024-10-27T15:54:22Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"RentIncludes": array:1 [ 0 => "Unknown" ] +"Roof": "Asphalt Rolled" +"RoomsTotal": "11" +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "DORVAL" +"StreetNumber": "184" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "7336.24" +"TaxAssessedValue": 970000 +"TaxBookNumber": "240103021000423" +"TaxLegalDescription": "PT BLOCK 64, PLAN 20M1130 DES AS PTS 36 & 37 ON 20" +"TaxYear": "2024" +"TransactionBrokerCompensation": "1/2 month rent + hst" +"TransactionType": "For Lease" +"Zoning": "SP:318" +"Water": "Municipal" +"RoomsAboveGrade": 11 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"GasYNA": "Available" +"HeatSource": "Unknown" +"ContractStatus": "Available" +"ListPriceUnit": "Month" +"WaterYNA": "Available" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"LotWidth": 23.53 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10404508')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 59.78 +"PossessionDetails": "60-89Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "155135228" +"Exposure": "West" +"ElectricYNA": "Available" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "Other" +"WashroomsType2Pcs": 2 +"ApproximateAge": "6-15" +"HoldoverDays": 120 +"WashroomsType3": 1 +"WashroomsType3Level": "Third" +"KitchensTotal": 1 +"PossessionDate": "2024-07-01" +"ID": "161930" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14216 +post_id: "161931" +post_author: 1 +"ListingKey": "X10403815" +"ListingId": "X10403815" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:08:08Z" +"RFModificationTimestamp": "2024-11-27T14:56:51Z" +"ListPrice": 299900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 710.0 +"City": "Haldimand County" +"PostalCode": "N0A 1K0" +"UnparsedAddress": "28 Derner Line, Haldimand County, On N0a 1k0" +"Coordinates": array:2 [ 0 => -79.504929269565 1 => 42.847387791304 ] +"Latitude": 42.847387791304 +"Longitude": -79.504929269565 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Search Realty Corp." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover your chance to own a slice of lakeside serenity! 28 Derner Lane boasts a spacious 54' x 174' lot on a peaceful, private road just steps from Lake Erie, offering a calm and picturesque environment with partial water views. Ideally located near the Haldimand-Niagara border, it’s positioned between Port Colborne and Dunnville, with just a 5-minute drive to Mohawk Marina and Hippo's Restaurant. Enjoy nearby attractions like Long Beach, local golf courses, Rock Point Provincial Park, Long Beach Conservation Area, and Niagara’s finest beaches and amenities. The true value is in the land—an ideal opportunity to create your dream oasis, whether for year-round living or a weekend escape. Your "Lake Escape" awaits!" +"ArchitecturalStyle": "Bungalow" +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ 0 => "Wood" 1 => "Vinyl Siding" ] +"Cooling": "None" +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-02T17:34:55.834379+00:00" +"CrossStreet": "North Shore Drive / South on Dickhout / Left onto Derner" +"DaysOnMarket": 290 +"DirectionFaces": "North" +"ExpirationDate": "2025-06-30" +"ExteriorFeatures": "Porch" +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Inclusions": "Dishwasher, Refrigerator, Stove" +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-02" +"LotSizeDimensions": "174 x 54" +"MainOfficeKey": "188700" +"MajorChangeTimestamp": "2024-10-28T11:56:35Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-02T15:48:00Z" +"OriginalListPrice": 329900.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40657057" +"ParcelNumber": "381260297" +"ParkingFeatures": "Front Yard Parking,Other" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-10-02T15:48:00Z" +"PoolFeatures": "None" +"PreviousListPrice": 329900.0 +"PriceChangeTimestamp": "2024-10-28T11:56:35Z" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "4" +"Sewer": "Septic" +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "DERNER" +"StreetNumber": "28" +"StreetSuffix": "Line" +"TaxAnnualAmount": "1637.0" +"TaxAssessedValue": 112000 +"TaxBookNumber": "281002500209800" +"TaxLegalDescription": "PT LT 13 CON Broken Front Sherbrooke As in HC1676" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"Zoning": "D A10F1" +"Water": "Other" +"RoomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"AccessToProperty": array:1 [ 0 => "Private Road" ] +"HeatSource": "Electric" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 54.0 +"HeatType": "Baseboard" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403815')" +"WashroomsType1Pcs": 3 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 174.0 +"ParkingSpaces": 4 +"PossessionDetails": "Immediate" +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "154509651" +"Exposure": "North" +"ElectricYNA": "Yes" +"BedroomsAboveGrade": 2 +"SquareFootSource": "Appraiser" +"RuralUtilities": array:1 [ 0 => "Other" ] +"KitchensTotal": 1 +"ID": "161931" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14215 +post_id: "161933" +post_author: 1 +"ListingKey": "X10404098" +"ListingId": "X10404098" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:08:01Z" +"RFModificationTimestamp": "2024-11-27T14:57:12Z" +"ListPrice": 739000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2220.92 +"City": "Woodstock" +"PostalCode": "L4T 0J3" +"UnparsedAddress": "1389 Caen Avenue, Woodstock, On L4t 0j3" +"Coordinates": array:2 [ 0 => -80.7186787 1 => 43.1460668 ] +"Latitude": 43.1460668 +"Longitude": -80.7186787 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Search Realty Corp." +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Look no further!! Welcome to this beautiful Corner Lot detached 3 bed + 3 bath\r\n home located in a mature sought after neighborhood in the north end of Woodstock.\r\n Upon entry, you are greeted by tall ceilings and abundant charm. The house proudly\r\n boasts a spacious formal living room and a separate dining room which leads to a\r\n functional kitchen with ample cupboard space and stainless steel appliances. The\r\n living room takes you to a patio walking out to a huge deck overlooking the back\r\n yard. Conveniently located on the main floor is your half bath. Upstairs leads you\r\n to the spacious 3 bedrooms with two bath one being you private ensuite and a huge\r\n laundry room giving you both luxury and convenience. The unfinished basement\r\n presents endless possibilities. Close to all amenities, schools, parks, Thames\r\n River, Pittoc Conservation Area, Innerkip Highland Golf Club, the Toyota Plant and\r\n minutes to 401 Opportunities like this are rare, do not miss the chance to make\r\n this exceptional family home your Home Sweet Home!! """ +"ArchitecturalStyle": "2-Storey" +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Woodstock - North" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Oxford" +"CoveredSpaces": "1.0" +"CreationDate": "2024-11-03T22:42:08.174543+00:00" +"CrossStreet": "Follow Oxford 2, Oxford Road 4/County Rd 4 and Devonshire Ave/Township Rd 2 to Caen Ave in Woodstock" +"DaysOnMarket": 263 +"DirectionFaces": "Unknown" +"Exclusions": "All Furniture and Curtains ( if any) belong to the stager" +"ExpirationDate": "2025-07-31" +"FoundationDetails": array:2 [ 0 => "Concrete" 1 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Included are all the stainless-steel appliances - Build In Microwave, Gas Range, Fridge & Dishwasher, Along with the White Washer Dryer, None" +"InteriorFeatures": "None" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"ListingContractDate": "2024-10-17" +"LotSizeDimensions": "103.9 x 42.43" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "188700" +"MajorChangeTimestamp": "2024-10-17T10:34:49Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-17T10:34:49Z" +"OriginalListPrice": 739000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40663921" +"ParcelNumber": "001101257" +"ParkingFeatures": "Private" +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-10-17T10:34:49Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"Roof": "Shingles" +"RoomsTotal": "11" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CAEN" +"StreetNumber": "1389" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4507.87" +"TaxAssessedValue": 262000 +"TaxBookNumber": "324202008511130" +"TaxLegalDescription": "PLAN 41M291 , LOT 31, SUBJECT TO AN EASEMENT FOR ENTRY AS IN C0182043 , CITY OF WOODSTOCK" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"Zoning": "RESIDENTIAL" +"Water": "Municipal" +"RoomsAboveGrade": 10 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 2 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 1 +"PropertyFeatures": array:1 [ 0 => "Fenced Yard" ] +"LotWidth": 42.43 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404098')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MortgageComment": "TREAT AS FREE AND CLEAR" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 103.9 +"ParkingSpaces": 1 +"PossessionDetails": "30-59Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "154866745" +"Exposure": "West" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 3 +"SquareFootSource": "Owner" +"WashroomsType2Pcs": 4 +"ApproximateAge": "6-15" +"HoldoverDays": 120 +"KitchensTotal": 1 +"ID": "161933" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14222 +post_id: "161934" +post_author: 1 +"ListingKey": "X10403955" +"ListingId": "X10403955" +"PropertyType": "Commercial" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:59Z" +"RFModificationTimestamp": "2025-04-29T14:53:31Z" +"ListPrice": 1779000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5184.0 +"City": "Hamilton" +"PostalCode": "L8P 3A2" +"UnparsedAddress": "148 James S Street, Hamilton, On L8p 3a2" +"Coordinates": array:2 [ 0 => -79.8711768 1 => 43.2523395 ] +"Latitude": 43.2523395 +"Longitude": -79.8711768 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "An incredible property that is ideal for investors and end-users alike. This mixed-use commercial building includes a basement commercial unit, a stunning, newly-leased main floor commercial unit, and three beautiful apartments on the top two floors (1 X Studio, 1 X 1-bed, 1 X 2-Bed). The building has been significantly renovated in the last five years: with complete reconstruction of the residential units. Electrical, plumbing, and mechanical has been replaced or updated. Rear parking is accessible from laneway. This beautiful property enjoys tremendous exposure on James Street South, and is situated in the heart of the growing Augusta restaurant district; surrounded by new development. This prime location is steps from St. Joseph's hospital and less than 300 metres from the Hunter Street GO Train and Bus station. With only the basement unit currently vacant, the income on this property is strong, and upside remains to be realized! Seller willing to negotiate competitive VTB options. Don't miss this opportunity to own a magnificent property in the heart of Hamilton!" +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Durand" +"CommunityFeatures": "Public Transit" +"ConstructionMaterials": array:1 [ 0 => "Stone" ] +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:17:23.093479+00:00" +"CrossStreet": "Located on the west side of James Street South between Bold and Duke streets." +"DaysOnMarket": 271 +"DirectionFaces": "East" +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:1 [ 0 => "Stone" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-09" +"LotSizeDimensions": "120 x 24.51" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-10T10:31:22Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-10-10T10:31:22Z" +"OriginalListPrice": 1779000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40660510" +"ParcelNumber": "171710039" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-10-10T10:31:22Z" +"PoolFeatures": "None" +"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" +"TaxAnnualAmount": "9355.64" +"TaxAssessedValue": 518000 +"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": "2%+HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "D2 - Downtown Mixed Use - Pedestrian Focus" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "154687679" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotWidth": 24.51 +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403955')" +"HoldoverDays": 60 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"provider_name": "TRREB" +"LotDepth": 120.0 +"ID": "161934" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14223 +post_id: "161935" +post_author: 1 +"ListingKey": "X10403956" +"ListingId": "X10403956" +"PropertyType": "Commercial" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:58Z" +"RFModificationTimestamp": "2025-04-30T05:47:09Z" +"ListPrice": 1999000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 10242.0 +"City": "Hamilton" +"PostalCode": "L8N 1C1" +"UnparsedAddress": "323-327 King E Street, Hamilton, On L8n 1c1" +"Coordinates": array:2 [ 0 => -79.8596178 1 => 43.2537637 ] +"Latitude": 43.2537637 +"Longitude": -79.8596178 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Fantastic construction-ready residential conversion! Permits are complete and set to be issued pending payment of fees! If you're looking for a profitable redevelopment project that is truly hammer-ready, this is it. Plans include retaining main floor commercial while developing 8 new residential units (5 X 2-bed, 3 X 1-bed). Take it a step further by dividing the main floor into smaller units for a higher PSF lease value. Situated steps from a future LRT station, this building has significant cashflow and appreciation value. If development isn't your thing, the existing structure is ready to lease in its current state as offices, retail, hospitality, etc. thanks to generous D2 zoning! Tremendous potential for investors, end-users, and developers alike. Clean Phase 1 Environmental on-hand. Plans, proforma, and additional information available upon request. This amount of usable square footage is incredibly rare on the LRT route. Don't miss this remarkable opportunity!" +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Beasley" +"CommunityFeatures": "Public Transit" +"ConstructionMaterials": array:2 [ 0 => "Stucco (Plaster)" 1 => "Stone" ] +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:17:12.414996+00:00" +"CrossStreet": "Immediately east of Wellington Street North on the north side of King Street East" +"DaysOnMarket": 271 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:2 [ 0 => "Stone" 1 => "Concrete" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-09" +"LotSizeDimensions": "103.44 x 39.89" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-10T10:30:58Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-10T10:30:58Z" +"OriginalListPrice": 1999000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40660532" +"ParcelNumber": "171680148" +"PhotosChangeTimestamp": "2024-10-10T10:30:58Z" +"PoolFeatures": "None" +"Roof": "Unknown" +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"Sewer": "Unknown" +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "KING" +"StreetNumber": "323-327" +"StreetSuffix": "Street" +"TaxAnnualAmount": "23921.0" +"TaxAssessedValue": 641000 +"TaxBookNumber": "251802018103640" +"TaxLegalDescription": "LT 5 PL 214; PT LT 4, 6 PL 214 AS IN VM277370, S/T INTEREST IN VM277370; CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": "Unknown" +"Zoning": "D2 - Downtown Mixed Use - Pedestrian Focus" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "154688489" +"Exposure": "North" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 39.89 +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403956')" +"HoldoverDays": 30 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RetailArea": 4148.0 +"AssessmentYear": 2021 +"OfficeApartmentArea": 6094.0 +"provider_name": "TRREB" +"LotDepth": 103.44 +"ID": "161935" } ] +success: true +page_size: 9 +page_count: 13619 +count: 122566 +after_key: "" } "RF Response Time" => "0.49 seconds" ] "RF Cache Key: 47ff4795cc57f57f6f974e3a6acd5b3d29cbe903c48c9c18f3819e818ceb2562" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14265 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14239 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W10343470" +"ListingId": "W10343470" +"PropertyType": "Commercial Sale" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:18:54Z" +"RFModificationTimestamp": "2024-11-27T14:46:44Z" +"ListPrice": 36000000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 109106.0 +"City": "Oakville" +"PostalCode": "L6H 1A7" +"UnparsedAddress": "1375-* North Service Road, Oakville, On L6h 1a7" +"Coordinates": array:2 [ 0 => -79.7613358 1 => 43.3988969 ] +"Latitude": 43.3988969 +"Longitude": -79.7613358 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLLIERS" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Introducing a rare investment opportunity: 100% fully leased flex office building with exceptional visibility to the QEW. The Joshua Creek Corporate (JCC) centre spans 8.38 acres and boasts 109,106 SF of prime office space. Home to some of Oakville's most prestigious tenants, JCC features attractive in-place rents, long-term leases, and versatile unit sizes to accommodate diverse tenancy needs. Each unit is meticulously built to the highest standards, offering an outstanding environment for businesses. The property provides ample parking, excellent exposure to the QEW, and convenient access to transit and a variety of amenities." +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Iroquois Ridge South" +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Halton" +"CreationDate": "2024-11-02T20:10:09.162951+00:00" +"CrossStreet": "Eigth Line / North Service Rd" +"ExpirationDate": "2025-03-24" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-11-01" +"MainOfficeKey": "336800" +"MajorChangeTimestamp": "2024-11-01T18:54:05Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-11-01T18:54:05Z" +"OriginalListPrice": 36000000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1663190" +"ParcelNumber": "249000403" +"PhotosChangeTimestamp": "2024-11-26T21:18:54Z" +"SecurityFeatures": array:1 [ 0 => "Yes" ] +"Sewer": array:1 [ 0 => "Sanitary+Storm" ] +"ShowingRequirements": array:1 [ 0 => "List Salesperson" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "North Service" +"StreetNumber": "1375-*" +"StreetSuffix": "Road" +"TaxAnnualAmount": "490931.76" +"TaxLegalDescription": "PT LT 7, CON 2 TRAF SDS, PTS 2,3 20R19939 SUBJECT TO AN EASEMENT AS IN 283292 TOGETHER WITH AN EASEMENT OVER PTS 2,3 20R19404 AS IN HR1126781 TOGETHER WITH AN EASEMENT OVER PTS 2,3 20R19577 & PT 2 20R19577 & PT 2 20R19731 AS IN HR1214095 TOGETHER WITH AN EASEMENT OVER PT 1 20R19577 & PT 1 20R19731 AS IN HR 1214096 SUBJECT TO AN EASEMENT IN GROSS AS IN HR1027592 TOGETHER WITH AN EASEMENT OVER PT 1 20R20107 AS IN HR1282829 TOWN OF OAKVILLE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "0.5% of sale price" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Yes" ] +"Zoning": "E2" +"Water": "Municipal" +"PossessionDetails": "TBD" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"GarageType": "Outside/Surface" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"PriorMlsStatus": "Draft" +"ListPriceUnit": "For Sale" +"LotWidth": 601.5 +"MediaChangeTimestamp": "2024-11-26T21:18:54Z" +"HeatType": "Gas Forced Air Closed" +"TaxType": "Annual" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10343470')" +"HoldoverDays": 60 +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Yes" ] +"RollNumber": "240104025012905" +"ElevatorType": "None" +"OfficeApartmentArea": 109106.0 +"provider_name": "TRREB" +"LotDepth": 674.96 +"Media": array:7 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] ] } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14202 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9357293" +"ListingId": "X9357293" +"PropertyType": "Commercial Sale" +"PropertySubType": "Investment" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:15:21Z" +"RFModificationTimestamp": "2025-04-30T05:47:09Z" +"ListPrice": 599000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1016.0 +"City": "Welland" +"PostalCode": "L3C 1E8" +"UnparsedAddress": "20 Patricia Ave, Welland, Ontario L3C 1E8" +"Coordinates": array:2 [ 0 => -79.2509505 1 => 43.0041574 ] +"Latitude": 43.0041574 +"Longitude": -79.2509505 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER ADVANTAGE REAL ESTATE INC" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "This legal duplex is a 4-level backsplit located on a quiet dead-end street, and is surrounded by an array of amenities. The upper unit has an open-concept main floor layout with 3 bedrooms and a bathroom located on the upper level. The lower unit has an abundance of natural light and is a 2 bedroom apartment complete with stainless steel, and a stackable washer and dryer. The furnace and AC are only 2 years, and the lower unit is rented at market rent plus hydro. Take advantage of this great opportunity to own multigenerational home or investment property in one of the most desirable areas of Welland." +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Apts - 2 To 5 Units" ] +"CityRegion": "N. Welland" +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Niagara" +"CreationDate": "2024-09-29T22:14:17.485278+00:00" +"CrossStreet": "Off Thorold Road between Niagara St. and Aqueduct" +"Exclusions": "Tenants' belongings" +"ExpirationDate": "2024-12-18" +"Inclusions": "Stove x2, Fridge x2, Dishwasher x2, Washer x2, Dryer 2" +"InsuranceExpense": 2400.0 +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-19" +"LotSizeSource": "MPAC" +"MainOfficeKey": "449200" +"MajorChangeTimestamp": "2024-11-26T21:00:07Z" +"MlsStatus": "New" +"NetOperatingIncome": 35128.0 +"OccupantType": "Tenant" +"OperatingExpense": "10172.0" +"OriginalEntryTimestamp": "2024-09-19T13:07:06Z" +"OriginalListPrice": 599000.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1512364" +"ParcelNumber": "640860299" +"PhotosChangeTimestamp": "2024-11-26T21:00:07Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:1 [ 0 => "See Brokerage Remarks" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Patricia" +"StreetNumber": "20" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "3572.0" +"TaxAssessedValue": 198000 +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.0% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Available" ] +"Zoning": "RL1" +"TotalAreaCode": "Sq Ft" +"lease": "Sale" +"class_name": "CommercialProperty" +"Water": "Municipal" +"FreestandingYN": true +"DDFYN": true +"LotType": "Lot" +"Expenses": "Estimated" +"PropertyUse": "Apartment" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 37.3 +"HeatType": "Gas Forced Air Open" +"YearExpenses": 2024 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9357293')" +"HSTApplication": array:1 [ 0 => "Included" ] +"RollNumber": "271901000409300" +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 114.0 +"PossessionDetails": "Imm W/Tenant" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "None" +"PriorMlsStatus": "Draft" +"TaxesExpense": 3572.0 +"MediaChangeTimestamp": "2024-11-26T21:00:07Z" +"TaxType": "Annual" +"RentalItems": "Hot Water Heater" +"HoldoverDays": 60 +"HeatingExpenses": 2400.0 +"GrossRevenue": 45300.0 +"Media": array:31 [ 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] ] } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14213 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X9380021" +"ListingId": "X9380021" +"PropertyType": "Commercial Lease" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:13:32Z" +"RFModificationTimestamp": "2025-04-26T02:48:27Z" +"ListPrice": 2995.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2628.0 +"City": "Welland" +"PostalCode": "L3C 3W9" +"UnparsedAddress": "#4 - 547 Thorold Road, Welland, On L3c 3w9" +"Coordinates": array:2 [ 0 => -79.2812199 1 => 43.0037372 ] +"Latitude": 43.0037372 +"Longitude": -79.2812199 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "COLDWELL BANKER ADVANTAGE REAL ESTATE INC" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "A COST_SHARING medical space is available for lease, currently set up for use as a dental office. This versatile space is ideal for a range of healthcare professionals, including dentists, orthodontists, chiropractors, physiotherapists, and more. The layout includes 3 private patient rooms, an employee washroom, a private office, and access to shared facilities such as a welcoming reception area, a laboratory, and a washroom for patients. With a total unit size of 2,628 sq ft, this property offers a professional setting designed to support seamless patient care and daily operations. The cost-sharing structure allows for shared expenses on utilities and common areas, making it an excellent opportunity for professionals seeking a collaborative and cost-efficient environment." +"BuildingAreaUnits": "Square Feet" +"BusinessType": array:1 [ 0 => "Other" ] +"CityRegion": "N. Welland" +"Cooling": array:1 [ 0 => "Yes" ] +"CountyOrParish": "Niagara" +"CreationDate": "2024-10-04T12:59:37.788425+00:00" +"CrossStreet": "S. PELHAM RD TO THOROLD RD." +"ExpirationDate": "2025-01-01" +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-03" +"MainOfficeKey": "449200" +"MajorChangeTimestamp": "2024-11-26T21:13:32Z" +"MlsStatus": "Price Change" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-03T14:46:03Z" +"OriginalListPrice": 3200.0 +"OriginatingSystemID": "A00001796" +"OriginatingSystemKey": "Draft1568098" +"ParcelNumber": "649840004" +"PhotosChangeTimestamp": "2024-11-26T20:56:07Z" +"PreviousListPrice": 3200.0 +"PriceChangeTimestamp": "2024-11-26T21:13:32Z" +"SecurityFeatures": array:1 [ 0 => "No" ] +"ShowingRequirements": array:2 [ 0 => "See Brokerage Remarks" 1 => "Showing System" ] +"SourceSystemID": "A00001796" +"SourceSystemName": "Toronto Regional Real Estate Board" +"StateOrProvince": "ON" +"StreetName": "Thorold" +"StreetNumber": "547" +"StreetSuffix": "Road" +"TaxAssessedValue": 288000 +"TaxLegalDescription": "UNIT 4, LEVEL 1, NIAGARA SOUTH STANDARD CONDOMINIUM PLAN NO. 184 AND ITS APPURTENANT INTEREST CITY OF WELLAND" +"TaxYear": "2024" +"TransactionBrokerCompensation": "ONE HALF OF ONE MONTHS' RENT" +"TransactionType": "For Lease" +"UnitNumber": "4" +"Utilities": array:1 [ 0 => "Available" ] +"Zoning": "CC1, O1" +"Water": "Municipal" +"FreestandingYN": true +"WashroomsType1": 1 +"DDFYN": true +"LotType": "Lot" +"PropertyUse": "Office" +"OfficeApartmentAreaUnit": "Sq Ft" +"ContractStatus": "Available" +"ListPriceUnit": "Month" +"HeatType": "Electric Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X9380021')" +"RollNumber": "271901001109804" +"MinimumRentalTermMonths": 12 +"AssessmentYear": 2024 +"provider_name": "TRREB" +"ParkingSpaces": 1 +"PossessionDetails": "Immediate" +"PermissionToContactListingBrokerToAdvertise": true +"GarageType": "Reserved/Assignd" +"PriorMlsStatus": "New" +"MediaChangeTimestamp": "2024-11-26T20:56:07Z" +"TaxType": "N/A" +"HoldoverDays": 90 +"ElevatorType": "None" +"OfficeApartmentArea": 2628.0 +"Media": array:14 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] ] } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14212 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403678" +"ListingId": "X10403678" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:08:27Z" +"RFModificationTimestamp": "2025-04-26T02:52:58Z" +"ListPrice": 1599000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 4200.0 +"City": "Hamilton" +"PostalCode": "L8H 4S8" +"UnparsedAddress": "289-293 Kenilworth N Avenue, Hamilton, On L8h 4s8" +"Coordinates": array:2 [ 0 => -79.805823 1 => 43.2503014 ] +"Latitude": 43.2503014 +"Longitude": -79.805823 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Prime investment opportunity located at one of the highest-traffic corners in the city! This fully-renovated, fully-tenanted building is well-positioned for either the experienced or first-time investor. Includes 4 beautifully renovated apartments, a strong anchor commercial tenant on the ground floor, and a brand new tenancy with a strong lease in the previously-vacant commercial unit. Additional income comes from rooftop billboards. Currently priced based on a 6.3% cap rate, this property is capable of achieving a stronger cap rate with minimal effort in the short-term. In exceptional condition, this property comes with a recent, clean Phase II Environmental. Plus, there are no parking spots, balconies, or elevators to maintain or cause issues! With significant opportunity for upside as well, this is an excellent, low-maintenance investment with a strong returns and more upside to be realized!" +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Crown Point" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T22:34:01.435444+00:00" +"CrossStreet": "SW Corner of Barton and Kenilworth" +"DaysOnMarket": 284 +"ExpirationDate": "2024-12-31" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-09-26" +"LotSizeDimensions": "35 x 64.66" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-09-26T11:25:12Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-09-26T11:25:12Z" +"OriginalListPrice": 1599000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40653611" +"ParcelNumber": "172480089" +"PhotosChangeTimestamp": "2024-09-26T13:21:48Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"Roof": array:1 [ 0 => "Unknown" ] +"SecurityFeatures": array:1 [ 0 => "Carbon Monoxide Detectors" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "List Salesperson" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "N" +"StreetName": "KENILWORTH" +"StreetNumber": "289-293" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "10180.79" +"TaxAssessedValue": 331000 +"TaxBookNumber": "251804031555850" +"TaxLegalDescription": "PT LT 20, BLK T, PL 395 , AS IN CD182423 ; HAMILTON" +"TaxYear": "2023" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "C5a" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "154325762" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 64.66 +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403678')" +"HoldoverDays": 30 +"Rail": "No" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RetailArea": 4200.0 +"AssessmentYear": 2016 +"provider_name": "TRREB" +"LotDepth": 35.0 } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#11409 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W10404508" +"ListingId": "W10404508" +"PropertyType": "Residential Lease" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:08:08Z" +"RFModificationTimestamp": "2024-11-27T14:56:51Z" +"ListPrice": 6700.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 3129.0 +"City": "Oakville" +"PostalCode": "L6K 0H4" +"UnparsedAddress": "184 Dorval Drive, Oakville, On L6k 0h4" +"Coordinates": array:2 [ 0 => -79.6975039 1 => 43.4446744 ] +"Latitude": 43.4446744 +"Longitude": -79.6975039 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Rarely offered, unique Luxury 4-bedroom, 4-bathroom townhouse boasting the epitome of sophistication and elegance. This gem features a private elevator with access to all floors and a custom-built kitchen w/ highend appliances, an island and a butler's pantry. The cozy family room seamlessly merges with the dining area, leading to an outdoor terrace equipped with a gas line, ideal for year-round BBQs and al fresco dining experiences. Ascend to the magical rooftop vistas, a haven for outdoor gatherings and breathtaking views of the surrounding cityscape. With a 4th bedroom option on the main floor, a double-sided fireplace, and a master ensuite featuring a Juliet balcony, every detail of this home exudes luxury and comfort with high end expertly crafted finishes. Complementing its lavish amenities is a rare 3-car garage. Designed for minimum maintenance and maximum enjoyment, this townhouse presents the ultimate lifestyle home. Minutes away from the shores of Lake Ontario, It is located in Oakville's most coveted and luxurious community. Schedule your private viewing today and unlock the door to your exquisite new home. Central, Near private college, Public schools parks, shops restaurants. Min from lakeshore, double-sided fireplace, 3car , dishwasher, washer/dryer, microwave, fridge, CVAC, Gasline for BBQ. Optional: Furniture can be included in the Rent." +"AccessibilityFeatures": array:1 [ 0 => "Other" ] +"ArchitecturalStyle": array:1 [ 0 => "3-Storey" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Old Oakville" +"CoListOfficeKey": "NONMEM" +"CoListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"CoListOfficePhone": "416-960-9995" +"ConstructionMaterials": array:1 [ 0 => "Stone" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "3.0" +"CreationDate": "2024-11-03T23:03:33.993177+00:00" +"CrossStreet": "Rebecca/Dorval" +"DaysOnMarket": 253 +"DirectionFaces": "West" +"Disclosures": array:1 [ 0 => "Unknown" ] +"ExpirationDate": "2024-12-31" +"ExteriorFeatures": array:2 [ 0 => "Porch" 1 => "Privacy" ] +"FireplaceFeatures": array:1 [ 0 => "Family Room" ] +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Furnished": "Unfurnished" +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove" +"InteriorFeatures": array:1 [ 0 => "Central Vacuum" ] +"RFTransactionType": "For Rent" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"LeaseTerm": "12 Months" +"ListingContractDate": "2024-10-27" +"LotSizeDimensions": "59.78 x 23.53" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-27T15:54:22Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-10-27T15:54:22Z" +"OriginalListPrice": 6700.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40669734" +"ParcelNumber": "248230241" +"ParkingFeatures": array:1 [ 0 => "Other" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2024-10-27T15:54:22Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PropertyAttachedYN": true +"RentIncludes": array:1 [ 0 => "Unknown" ] +"Roof": array:1 [ 0 => "Asphalt Rolled" ] +"RoomsTotal": "11" +"SecurityFeatures": array:1 [ 0 => "Smoke Detector" ] +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "DORVAL" +"StreetNumber": "184" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "7336.24" +"TaxAssessedValue": 970000 +"TaxBookNumber": "240103021000423" +"TaxLegalDescription": "PT BLOCK 64, PLAN 20M1130 DES AS PTS 36 & 37 ON 20" +"TaxYear": "2024" +"TransactionBrokerCompensation": "1/2 month rent + hst" +"TransactionType": "For Lease" +"Zoning": "SP:318" +"Water": "Municipal" +"RoomsAboveGrade": 11 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"GasYNA": "Available" +"HeatSource": "Unknown" +"ContractStatus": "Available" +"ListPriceUnit": "Month" +"WaterYNA": "Available" +"PortionPropertyLease": array:1 [ 0 => "Entire Property" ] +"LotWidth": 23.53 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10404508')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 59.78 +"PossessionDetails": "60-89Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "155135228" +"Exposure": "West" +"ElectricYNA": "Available" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 4 +"SquareFootSource": "Other" +"WashroomsType2Pcs": 2 +"ApproximateAge": "6-15" +"HoldoverDays": 120 +"WashroomsType3": 1 +"WashroomsType3Level": "Third" +"KitchensTotal": 1 +"PossessionDate": "2024-07-01" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14235 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403815" +"ListingId": "X10403815" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:08:08Z" +"RFModificationTimestamp": "2024-11-27T14:56:51Z" +"ListPrice": 299900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 710.0 +"City": "Haldimand County" +"PostalCode": "N0A 1K0" +"UnparsedAddress": "28 Derner Line, Haldimand County, On N0a 1k0" +"Coordinates": array:2 [ 0 => -79.504929269565 1 => 42.847387791304 ] +"Latitude": 42.847387791304 +"Longitude": -79.504929269565 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Search Realty Corp." +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Discover your chance to own a slice of lakeside serenity! 28 Derner Lane boasts a spacious 54' x 174' lot on a peaceful, private road just steps from Lake Erie, offering a calm and picturesque environment with partial water views. Ideally located near the Haldimand-Niagara border, it’s positioned between Port Colborne and Dunnville, with just a 5-minute drive to Mohawk Marina and Hippo's Restaurant. Enjoy nearby attractions like Long Beach, local golf courses, Rock Point Provincial Park, Long Beach Conservation Area, and Niagara’s finest beaches and amenities. The true value is in the land—an ideal opportunity to create your dream oasis, whether for year-round living or a weekend escape. Your "Lake Escape" awaits!" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "None" ] +"BuildingAreaUnits": "Square Feet" +"ConstructionMaterials": array:2 [ 0 => "Wood" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "None" ] +"Country": "CA" +"CountyOrParish": "Haldimand-Norfolk" +"CreationDate": "2024-11-02T17:34:55.834379+00:00" +"CrossStreet": "North Shore Drive / South on Dickhout / Left onto Derner" +"DaysOnMarket": 290 +"DirectionFaces": "North" +"ExpirationDate": "2025-06-30" +"ExteriorFeatures": array:1 [ 0 => "Porch" ] +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"Inclusions": "Dishwasher, Refrigerator, Stove" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-02" +"LotSizeDimensions": "174 x 54" +"MainOfficeKey": "188700" +"MajorChangeTimestamp": "2024-10-28T11:56:35Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-02T15:48:00Z" +"OriginalListPrice": 329900.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40657057" +"ParcelNumber": "381260297" +"ParkingFeatures": array:2 [ 0 => "Front Yard Parking" 1 => "Other" ] +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-10-02T15:48:00Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PreviousListPrice": 329900.0 +"PriceChangeTimestamp": "2024-10-28T11:56:35Z" +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "4" +"Sewer": array:1 [ 0 => "Septic" ] +"ShowingRequirements": array:1 [ 0 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "DERNER" +"StreetNumber": "28" +"StreetSuffix": "Line" +"TaxAnnualAmount": "1637.0" +"TaxAssessedValue": 112000 +"TaxBookNumber": "281002500209800" +"TaxLegalDescription": "PT LT 13 CON Broken Front Sherbrooke As in HC1676" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"Zoning": "D A10F1" +"Water": "Other" +"RoomsAboveGrade": 4 +"KitchensAboveGrade": 1 +"WashroomsType1": 1 +"DDFYN": true +"AccessToProperty": array:1 [ 0 => "Private Road" ] +"HeatSource": "Electric" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 54.0 +"HeatType": "Baseboard" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403815')" +"WashroomsType1Pcs": 3 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 174.0 +"ParkingSpaces": 4 +"PossessionDetails": "Immediate" +"LotSizeRangeAcres": "< .50" +"GarageType": "Unknown" +"MediaListingKey": "154509651" +"Exposure": "North" +"ElectricYNA": "Yes" +"BedroomsAboveGrade": 2 +"SquareFootSource": "Appraiser" +"RuralUtilities": array:1 [ 0 => "Other" ] +"KitchensTotal": 1 } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14236 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10404098" +"ListingId": "X10404098" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:08:01Z" +"RFModificationTimestamp": "2024-11-27T14:57:12Z" +"ListPrice": 739000.0 +"BathroomsTotalInteger": 3.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 2220.92 +"City": "Woodstock" +"PostalCode": "L4T 0J3" +"UnparsedAddress": "1389 Caen Avenue, Woodstock, On L4t 0j3" +"Coordinates": array:2 [ 0 => -80.7186787 1 => 43.1460668 ] +"Latitude": 43.1460668 +"Longitude": -80.7186787 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Search Realty Corp." +"OriginatingSystemName": "TRREB" +"PublicRemarks": """ Look no further!! Welcome to this beautiful Corner Lot detached 3 bed + 3 bath\r\n home located in a mature sought after neighborhood in the north end of Woodstock.\r\n Upon entry, you are greeted by tall ceilings and abundant charm. The house proudly\r\n boasts a spacious formal living room and a separate dining room which leads to a\r\n functional kitchen with ample cupboard space and stainless steel appliances. The\r\n living room takes you to a patio walking out to a huge deck overlooking the back\r\n yard. Conveniently located on the main floor is your half bath. Upstairs leads you\r\n to the spacious 3 bedrooms with two bath one being you private ensuite and a huge\r\n laundry room giving you both luxury and convenience. The unfinished basement\r\n presents endless possibilities. Close to all amenities, schools, parks, Thames\r\n River, Pittoc Conservation Area, Innerkip Highland Golf Club, the Toyota Plant and\r\n minutes to 401 Opportunities like this are rare, do not miss the chance to make\r\n this exceptional family home your Home Sweet Home!! """ +"ArchitecturalStyle": array:1 [ 0 => "2-Storey" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Woodstock - North" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Oxford" +"CoveredSpaces": "1.0" +"CreationDate": "2024-11-03T22:42:08.174543+00:00" +"CrossStreet": "Follow Oxford 2, Oxford Road 4/County Rd 4 and Devonshire Ave/Township Rd 2 to Caen Ave in Woodstock" +"DaysOnMarket": 263 +"DirectionFaces": "Unknown" +"Exclusions": "All Furniture and Curtains ( if any) belong to the stager" +"ExpirationDate": "2025-07-31" +"FoundationDetails": array:2 [ 0 => "Concrete" 1 => "Concrete Block" ] +"GarageYN": true +"Inclusions": "Included are all the stainless-steel appliances - Build In Microwave, Gas Range, Fridge & Dishwasher, Along with the White Washer Dryer, None" +"InteriorFeatures": array:1 [ 0 => "None" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"ListingContractDate": "2024-10-17" +"LotSizeDimensions": "103.9 x 42.43" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "188700" +"MajorChangeTimestamp": "2024-10-17T10:34:49Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-17T10:34:49Z" +"OriginalListPrice": 739000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40663921" +"ParcelNumber": "001101257" +"ParkingFeatures": array:1 [ 0 => "Private" ] +"ParkingTotal": "2.0" +"PhotosChangeTimestamp": "2024-10-17T10:34:49Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Shingles" ] +"RoomsTotal": "11" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Lockbox" 1 => "Showing System" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "CAEN" +"StreetNumber": "1389" +"StreetSuffix": "Avenue" +"TaxAnnualAmount": "4507.87" +"TaxAssessedValue": 262000 +"TaxBookNumber": "324202008511130" +"TaxLegalDescription": "PLAN 41M291 , LOT 31, SUBJECT TO AN EASEMENT FOR ENTRY AS IN C0182043 , CITY OF WOODSTOCK" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2%+HST" +"TransactionType": "For Sale" +"Zoning": "RESIDENTIAL" +"Water": "Municipal" +"RoomsAboveGrade": 10 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "Hot Water Heater" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 2 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 1 +"PropertyFeatures": array:1 [ 0 => "Fenced Yard" ] +"LotWidth": 42.43 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10404098')" +"WashroomsType1Pcs": 2 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"MortgageComment": "TREAT AS FREE AND CLEAR" +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 103.9 +"ParkingSpaces": 1 +"PossessionDetails": "30-59Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "154866745" +"Exposure": "West" +"WashroomsType2Level": "Second" +"BedroomsAboveGrade": 3 +"SquareFootSource": "Owner" +"WashroomsType2Pcs": 4 +"ApproximateAge": "6-15" +"HoldoverDays": 120 +"KitchensTotal": 1 } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14237 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403955" +"ListingId": "X10403955" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:59Z" +"RFModificationTimestamp": "2025-04-29T14:53:31Z" +"ListPrice": 1779000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 5184.0 +"City": "Hamilton" +"PostalCode": "L8P 3A2" +"UnparsedAddress": "148 James S Street, Hamilton, On L8p 3a2" +"Coordinates": array:2 [ 0 => -79.8711768 1 => 43.2523395 ] +"Latitude": 43.2523395 +"Longitude": -79.8711768 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "An incredible property that is ideal for investors and end-users alike. This mixed-use commercial building includes a basement commercial unit, a stunning, newly-leased main floor commercial unit, and three beautiful apartments on the top two floors (1 X Studio, 1 X 1-bed, 1 X 2-Bed). The building has been significantly renovated in the last five years: with complete reconstruction of the residential units. Electrical, plumbing, and mechanical has been replaced or updated. Rear parking is accessible from laneway. This beautiful property enjoys tremendous exposure on James Street South, and is situated in the heart of the growing Augusta restaurant district; surrounded by new development. This prime location is steps from St. Joseph's hospital and less than 300 metres from the Hunter Street GO Train and Bus station. With only the basement unit currently vacant, the income on this property is strong, and upside remains to be realized! Seller willing to negotiate competitive VTB options. Don't miss this opportunity to own a magnificent property in the heart of Hamilton!" +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Durand" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"ConstructionMaterials": array:1 [ 0 => "Stone" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:17:23.093479+00:00" +"CrossStreet": "Located on the west side of James Street South between Bold and Duke streets." +"DaysOnMarket": 271 +"DirectionFaces": "East" +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:1 [ 0 => "Stone" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-09" +"LotSizeDimensions": "120 x 24.51" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-10T10:31:22Z" +"MlsStatus": "New" +"OccupantType": "Tenant" +"OriginalEntryTimestamp": "2024-10-10T10:31:22Z" +"OriginalListPrice": 1779000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40660510" +"ParcelNumber": "171710039" +"ParkingTotal": "4.0" +"PhotosChangeTimestamp": "2024-10-10T10:31:22Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"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" +"TaxAnnualAmount": "9355.64" +"TaxAssessedValue": 518000 +"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": "2%+HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "D2 - Downtown Mixed Use - Pedestrian Focus" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "154687679" +"Exposure": "West" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"PropertyFeatures": array:1 [ 0 => "Hospital" ] +"LotWidth": 24.51 +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403955')" +"HoldoverDays": 60 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2016 +"provider_name": "TRREB" +"LotDepth": 120.0 } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14238 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403956" +"ListingId": "X10403956" +"PropertyType": "Commercial Sale" +"PropertySubType": "Sale Of Business" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:58Z" +"RFModificationTimestamp": "2025-04-30T05:47:09Z" +"ListPrice": 1999000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 10242.0 +"City": "Hamilton" +"PostalCode": "L8N 1C1" +"UnparsedAddress": "323-327 King E Street, Hamilton, On L8n 1c1" +"Coordinates": array:2 [ 0 => -79.8596178 1 => 43.2537637 ] +"Latitude": 43.2537637 +"Longitude": -79.8596178 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sotheby's International Realty Canada, Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Fantastic construction-ready residential conversion! Permits are complete and set to be issued pending payment of fees! If you're looking for a profitable redevelopment project that is truly hammer-ready, this is it. Plans include retaining main floor commercial while developing 8 new residential units (5 X 2-bed, 3 X 1-bed). Take it a step further by dividing the main floor into smaller units for a higher PSF lease value. Situated steps from a future LRT station, this building has significant cashflow and appreciation value. If development isn't your thing, the existing structure is ready to lease in its current state as offices, retail, hospitality, etc. thanks to generous D2 zoning! Tremendous potential for investors, end-users, and developers alike. Clean Phase 1 Environmental on-hand. Plans, proforma, and additional information available upon request. This amount of usable square footage is incredibly rare on the LRT route. Don't miss this remarkable opportunity!" +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Beasley" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"ConstructionMaterials": array:2 [ 0 => "Stucco (Plaster)" 1 => "Stone" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:17:12.414996+00:00" +"CrossStreet": "Immediately east of Wellington Street North on the north side of King Street East" +"DaysOnMarket": 271 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"FoundationDetails": array:2 [ 0 => "Stone" 1 => "Concrete" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-09" +"LotSizeDimensions": "103.44 x 39.89" +"LotSizeSource": "Geo Warehouse" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-10-10T10:30:58Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-10T10:30:58Z" +"OriginalListPrice": 1999000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40660532" +"ParcelNumber": "171680148" +"PhotosChangeTimestamp": "2024-10-10T10:30:58Z" +"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 Salesperson" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetDirSuffix": "E" +"StreetName": "KING" +"StreetNumber": "323-327" +"StreetSuffix": "Street" +"TaxAnnualAmount": "23921.0" +"TaxAssessedValue": 641000 +"TaxBookNumber": "251802018103640" +"TaxLegalDescription": "LT 5 PL 214; PT LT 4, 6 PL 214 AS IN VM277370, S/T INTEREST IN VM277370; CITY OF HAMILTON" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2% + HST" +"TransactionType": "For Sale" +"Utilities": array:1 [ 0 => "Unknown" ] +"Zoning": "D2 - Downtown Mixed Use - Pedestrian Focus" +"Water": "Municipal" +"PossessionDetails": "Flexible" +"DDFYN": true +"LotType": "Unknown" +"LotSizeRangeAcres": "< .50" +"PropertyUse": "With Property" +"GarageType": "Unknown" +"MediaListingKey": "154688489" +"Exposure": "North" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 39.89 +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403956')" +"HoldoverDays": 30 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"RetailArea": 4148.0 +"AssessmentYear": 2021 +"OfficeApartmentArea": 6094.0 +"provider_name": "TRREB" +"LotDepth": 103.44 } ] +success: true +page_size: 9 +page_count: 13619 +count: 122566 +after_key: "" } ] ]
