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=113985&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113985&$filter=(StandardStatus eq 'Active')&$expand=Media/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113985&$filter=(StandardStatus eq 'Active')/Property?$select=ALL&$orderby=ModificationTimestamp DESC&$top=9&$skip=113985&$filter=(StandardStatus eq 'Active')&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14223 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14217 +post_id: "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": 283 +"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" } 1 => 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": 252 +"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" } 2 => 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": 289 +"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" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14220 +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": 262 +"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" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14218 +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": 270 +"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" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14215 +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": 270 +"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" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14214 +post_id: "161936" +post_author: 1 +"ListingKey": "X10403957" +"ListingId": "X10403957" +"PropertyType": "Commercial" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:58Z" +"RFModificationTimestamp": "2025-04-29T14:53:31Z" +"ListPrice": 1999000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 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": "Huge price reduction - priced to move! Fantastic construction-ready residential conversion! Permits are complete and set to be issued pending payment of DCs and Parkland 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!" +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Beasley" +"CommunityFeatures": "Public Transit" +"Cooling": "Unknown" +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:17:10.799154+00:00" +"CrossStreet": "Immediately east of Wellington Street North on the north side of King Street East" +"DaysOnMarket": 270 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"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:47Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-10-10T10:30:47Z" +"OriginalListPrice": 1999000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40660541" +"ParcelNumber": "171680148" +"PhotosChangeTimestamp": "2024-10-10T10:30:47Z" +"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": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "154688898" +"Exposure": "North" +"SoilTest": "Envirnonmental Audit" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 39.89 +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403957')" +"HoldoverDays": 60 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"RuralUtilities": array:1 [ 0 => "Other" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2021 +"provider_name": "TRREB" +"LotDepth": 103.44 +"ID": "161936" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14221 +post_id: "161939" +post_author: 1 +"ListingKey": "W10404252" +"ListingId": "W10404252" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:44Z" +"RFModificationTimestamp": "2024-11-27T14:59:41Z" +"ListPrice": 1169000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1791.0 +"City": "Oakville" +"PostalCode": "L6H 2H6" +"UnparsedAddress": "1302 Gainsborough Drive, Oakville, On L6h 2h6" +"Coordinates": array:2 [ 0 => -79.6868255 1 => 43.4763341 ] +"Latitude": 43.4763341 +"Longitude": -79.6868255 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sutton Group Quantum Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 1302 Gainsborough Drive located in the established neighbourhood of Falgarwood in Oakville. This brick bungalow features 3 bedrooms, 2 bathrooms and awaits your vision. Situated on a 62’ x 125’ lot that expands out to 85’ across the rear of the property, the opportunities here are endless. The living room and dining room are flooded with natural light from the floor to ceiling windows. The finished basement provides excellent additional living space and features a 3-piece bathroom and a wet bar. The basement can also be converted to an additional unit with access from the backyard. The backyard is fully fenced and has mature tree coverage. Attached garage and long double wide-driveway for ample parking. Conveniently located within walking distance to schools, city pool and parks and in close proximity to all amenities, major highways, downtown Oakville, uptown Oakville and public transit including the GO Train." +"ArchitecturalStyle": "Bungalow" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Iroquois Ridge South" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "1.0" +"CreationDate": "2024-11-03T22:08:37.592837+00:00" +"CrossStreet": "8th Line to Falgarwood to Gainsborough" +"DaysOnMarket": 298 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-01-10" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "All electrical light fixtures, all window coverings, fridge, stove, built-in oven, dishwasher, washer, dryer, central AC, hot water tank, FAG furnace (2020), roof shingles (2014)., Dishwasher, Dryer, Stove, Washer, Window Coverings" +"InteriorFeatures": "Other" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-07" +"LotSizeDimensions": "125 x 62" +"MainOfficeKey": "540900" +"MajorChangeTimestamp": "2024-10-07T07:50:52Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-07T07:50:52Z" +"OriginalListPrice": 1169000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40658864" +"ParcelNumber": "248890041" +"ParkingFeatures": "Private Double" +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2024-10-07T07:50:52Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"Roof": "Asphalt Shingle" +"RoomsTotal": "11" +"Sewer": "Sewer" +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Brokerage" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "GAINSBOROUGH" +"StreetNumber": "1302" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5077.33" +"TaxAssessedValue": 638000 +"TaxBookNumber": "240104024009300" +"TaxLegalDescription": "LT 67, PL 995; S/T THE INTEREST(S) IN 197287 AND 197290; IF ANY; S/T 115962 OAKVILLE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"Zoning": "RL7-9" +"Water": "Municipal" +"RoomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "None" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 4 +"LotWidth": 62.0 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10404252')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 125.0 +"ParkingSpaces": 4 +"PossessionDetails": "30-60 Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "154611652" +"Exposure": "North" +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"WashroomsType2Level": "Basement" +"BedroomsAboveGrade": 3 +"SquareFootSource": "Plans" +"WashroomsType2Pcs": 3 +"LotIrregularities": "Lot is 85' across rear" +"ApproximateAge": "51-99" +"KitchensTotal": 1 +"ID": "161939" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14222 +post_id: "161942" +post_author: 1 +"ListingKey": "W10418222" +"ListingId": "W10418222" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:42Z" +"RFModificationTimestamp": "2024-11-27T15:00:48Z" +"ListPrice": 2580000.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.693086217404 1 => 43.441934571799 ] +"Latitude": 43.441934571799 +"Longitude": -79.693086217404 +"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 foors and a custom-built kitchen w/ high-end 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 foor, a double-sided freplace, and a master ensuite featuring a Juliet balcony, every detail of this home exudes luxury and comfort with high end expertly crafted fnishes. 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 freplace, 3 car, Dishwasher, washer/dryer, microwave, fridge, CVAC, Gasline for BBQ." +"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" +"CoListOfficePhone": "416-960-9995" +"ConstructionMaterials": array:1 [ 0 => "Stone" ] +"Cooling": "Central Air" +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "3.0" +"CreationDate": "2024-11-12T07:40:15.030389+00:00" +"CrossStreet": "Rebecca/Dorval" +"DaysOnMarket": 269 +"DirectionFaces": "West" +"Disclosures": array:1 [ 0 => "Unknown" ] +"ExpirationDate": "2025-01-31" +"ExteriorFeatures": "Porch,Privacy" +"FireplaceFeatures": array:1 [ 0 => "Family Room" ] +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove" +"InteriorFeatures": "Central Vacuum" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"ListingContractDate": "2024-11-04" +"LotSizeDimensions": "59.78 x 23.53" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-11-05T12:35:32Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-11-05T12:35:32Z" +"OriginalListPrice": 2580000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40673754" +"ParcelNumber": "248230241" +"ParkingFeatures": "Other" +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2024-11-05T12:35:32Z" +"PoolFeatures": "None" +"PropertyAttachedYN": true +"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": "2.5% +HST" +"TransactionType": "For Sale" +"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": "For Sale" +"WaterYNA": "Available" +"LotWidth": 23.53 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10418222')" +"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": "155343972" +"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" +"Media": array:37 [ 0 => array:26 [ "ResourceRecordKey" => "W10418222" "MediaModificationTimestamp" => "2024-11-05T11:23:54Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10418222/thumbnail-7e474cfd35b5cdf55e96a43333ea63fe.webp" "ShortDescription" => "" "MediaKey" => "a12f4539-aa2a-45ad-b852-4cc7b4a86ba6" "ImageWidth" => null "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-05T11:23:54Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 0 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W10418222/7e474cfd35b5cdf55e96a43333ea63fe.webp" "MediaSize" => 181060 "SourceSystemMediaKey" => "155343985" "SourceSystemID" => "omdreb" "MediaHTML" => null "PreferredPhotoYN" => true "LongDescription" => "" "ImageHeight" => null ] 1 => array:26 [ "ResourceRecordKey" => "W10418222" "MediaModificationTimestamp" => "2024-11-05T11:23:54Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10418222/thumbnail-42f94a44f0b02b5b9f109cb725b9c08c.webp" "ShortDescription" => "" "MediaKey" => "2d977a85-cf21-4ddb-a560-c7f248d29b30" "ImageWidth" => null "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-05T11:23:54Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null "Order" => 1 "MediaURL" => "https://cdn.realtyfeed.com/cdn/48/W10418222/42f94a44f0b02b5b9f109cb725b9c08c.webp" "MediaSize" => 174367 "SourceSystemMediaKey" => "155343988" "SourceSystemID" => "omdreb" "MediaHTML" => null "PreferredPhotoYN" => false "LongDescription" => "" "ImageHeight" => null ] 2 => array:26 [ "ResourceRecordKey" => "W10418222" "MediaModificationTimestamp" => "2024-11-05T11:23:55Z" "ResourceName" => "Property" "SourceSystemName" => "itso" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/48/W10418222/thumbnail-067c6d0c8336bc4a65ab6ac1ecb0a28f.webp" "ShortDescription" => "" "MediaKey" => "43753ae3-0659-4ac6-aa0c-372a45a98370" "ImageWidth" => null "ClassName" => "ResidentialFree" "Permission" => array:1 [ …1] "MediaType" => "webp" "ImageOf" => null "ModificationTimestamp" => "2024-11-05T11:23:55Z" "MediaCategory" => "Photo" "ImageSizeDescription" => "Largest" "MediaStatus" => "Active" "MediaObjectID" => null …9 ] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] ] +"ID": "161942" } ] +success: true +page_size: 9 +page_count: 13623 +count: 122599 +after_key: "" } "RF Response Time" => "0.21 seconds" ] "RF Cache Key: b100e02f52f74e5c3347bf50e651ade04bd194822daf6bb73682e98d0f51c07d" => array:1 [ "RF Cached Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#14288 +items: array:9 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14238 +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": 283 +"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 } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14201 +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": 252 +"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" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14212 +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": 289 +"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 } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14211 +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": 262 +"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 } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#11409 +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": 270 +"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 } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14234 +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": 270 +"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 } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14235 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "X10403957" +"ListingId": "X10403957" +"PropertyType": "Commercial Sale" +"PropertySubType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:58Z" +"RFModificationTimestamp": "2025-04-29T14:53:31Z" +"ListPrice": 1999000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 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": "Huge price reduction - priced to move! Fantastic construction-ready residential conversion! Permits are complete and set to be issued pending payment of DCs and Parkland 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!" +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Beasley" +"CommunityFeatures": array:1 [ 0 => "Public Transit" ] +"Cooling": array:1 [ 0 => "Unknown" ] +"Country": "CA" +"CountyOrParish": "Hamilton" +"CreationDate": "2024-11-03T23:17:10.799154+00:00" +"CrossStreet": "Immediately east of Wellington Street North on the north side of King Street East" +"DaysOnMarket": 270 +"DirectionFaces": "South" +"ExpirationDate": "2025-01-31" +"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:47Z" +"MlsStatus": "New" +"OriginalEntryTimestamp": "2024-10-10T10:30:47Z" +"OriginalListPrice": 1999000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40660541" +"ParcelNumber": "171680148" +"PhotosChangeTimestamp": "2024-10-10T10:30:47Z" +"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": "Unknown" +"GarageType": "Unknown" +"MediaListingKey": "154688898" +"Exposure": "North" +"SoilTest": "Envirnonmental Audit" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"LotWidth": 39.89 +"HeatType": "Unknown" +"TaxType": "Unknown" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('X10403957')" +"HoldoverDays": 60 +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"RuralUtilities": array:1 [ 0 => "Other" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2021 +"provider_name": "TRREB" +"LotDepth": 103.44 } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14236 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W10404252" +"ListingId": "W10404252" +"PropertyType": "Residential" +"PropertySubType": "Detached" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:44Z" +"RFModificationTimestamp": "2024-11-27T14:59:41Z" +"ListPrice": 1169000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1791.0 +"City": "Oakville" +"PostalCode": "L6H 2H6" +"UnparsedAddress": "1302 Gainsborough Drive, Oakville, On L6h 2h6" +"Coordinates": array:2 [ 0 => -79.6868255 1 => 43.4763341 ] +"Latitude": 43.4763341 +"Longitude": -79.6868255 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListOfficeName": "Sutton Group Quantum Realty Inc., Brokerage" +"OriginatingSystemName": "TRREB" +"PublicRemarks": "Welcome to 1302 Gainsborough Drive located in the established neighbourhood of Falgarwood in Oakville. This brick bungalow features 3 bedrooms, 2 bathrooms and awaits your vision. Situated on a 62’ x 125’ lot that expands out to 85’ across the rear of the property, the opportunities here are endless. The living room and dining room are flooded with natural light from the floor to ceiling windows. The finished basement provides excellent additional living space and features a 3-piece bathroom and a wet bar. The basement can also be converted to an additional unit with access from the backyard. The backyard is fully fenced and has mature tree coverage. Attached garage and long double wide-driveway for ample parking. Conveniently located within walking distance to schools, city pool and parks and in close proximity to all amenities, major highways, downtown Oakville, uptown Oakville and public transit including the GO Train." +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BasementYN": true +"BuildingAreaUnits": "Square Feet" +"CityRegion": "Iroquois Ridge South" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"Country": "CA" +"CountyOrParish": "Halton" +"CoveredSpaces": "1.0" +"CreationDate": "2024-11-03T22:08:37.592837+00:00" +"CrossStreet": "8th Line to Falgarwood to Gainsborough" +"DaysOnMarket": 298 +"DirectionFaces": "Unknown" +"ExpirationDate": "2025-01-10" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"GarageYN": true +"Inclusions": "All electrical light fixtures, all window coverings, fridge, stove, built-in oven, dishwasher, washer, dryer, central AC, hot water tank, FAG furnace (2020), roof shingles (2014)., Dishwasher, Dryer, Stove, Washer, Window Coverings" +"InteriorFeatures": array:1 [ 0 => "Other" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListingContractDate": "2024-10-07" +"LotSizeDimensions": "125 x 62" +"MainOfficeKey": "540900" +"MajorChangeTimestamp": "2024-10-07T07:50:52Z" +"MlsStatus": "New" +"OccupantType": "Vacant" +"OriginalEntryTimestamp": "2024-10-07T07:50:52Z" +"OriginalListPrice": 1169000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40658864" +"ParcelNumber": "248890041" +"ParkingFeatures": array:1 [ 0 => "Private Double" ] +"ParkingTotal": "5.0" +"PhotosChangeTimestamp": "2024-10-07T07:50:52Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PropertyAttachedYN": true +"Roof": array:1 [ 0 => "Asphalt Shingle" ] +"RoomsTotal": "11" +"Sewer": array:1 [ 0 => "Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Showing System" 1 => "List Brokerage" ] +"SourceSystemID": "omdreb" +"SourceSystemName": "itso" +"StateOrProvince": "ON" +"StreetName": "GAINSBOROUGH" +"StreetNumber": "1302" +"StreetSuffix": "Drive" +"TaxAnnualAmount": "5077.33" +"TaxAssessedValue": 638000 +"TaxBookNumber": "240104024009300" +"TaxLegalDescription": "LT 67, PL 995; S/T THE INTEREST(S) IN 197287 AND 197290; IF ANY; S/T 115962 OAKVILLE" +"TaxYear": "2024" +"TransactionBrokerCompensation": "2.5% + HST" +"TransactionType": "For Sale" +"Zoning": "RL7-9" +"Water": "Municipal" +"RoomsAboveGrade": 7 +"KitchensAboveGrade": 1 +"UnderContract": array:1 [ 0 => "None" ] +"WashroomsType1": 1 +"DDFYN": true +"WashroomsType2": 1 +"HeatSource": "Gas" +"ContractStatus": "Available" +"ListPriceUnit": "For Sale" +"RoomsBelowGrade": 4 +"LotWidth": 62.0 +"HeatType": "Forced Air" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10404252')" +"WashroomsType1Pcs": 4 +"WashroomsType1Level": "Main" +"HSTApplication": array:1 [ 0 => "Call LBO" ] +"SpecialDesignation": array:1 [ 0 => "Unknown" ] +"AssessmentYear": 2024 +"provider_name": "TRREB" +"LotDepth": 125.0 +"ParkingSpaces": 4 +"PossessionDetails": "30-60 Days" +"LotSizeRangeAcres": "< .50" +"GarageType": "Attached" +"MediaListingKey": "154611652" +"Exposure": "North" +"LeaseToOwnEquipment": array:1 [ 0 => "None" ] +"WashroomsType2Level": "Basement" +"BedroomsAboveGrade": 3 +"SquareFootSource": "Plans" +"WashroomsType2Pcs": 3 +"LotIrregularities": "Lot is 85' across rear" +"ApproximateAge": "51-99" +"KitchensTotal": 1 } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#14237 +post_id: ? mixed +post_author: ? mixed +"ListingKey": "W10418222" +"ListingId": "W10418222" +"PropertyType": "Residential" +"PropertySubType": "Att/Row/Townhouse" +"StandardStatus": "Active" +"ModificationTimestamp": "2024-11-26T21:07:42Z" +"RFModificationTimestamp": "2024-11-27T15:00:48Z" +"ListPrice": 2580000.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.693086217404 1 => 43.441934571799 ] +"Latitude": 43.441934571799 +"Longitude": -79.693086217404 +"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 foors and a custom-built kitchen w/ high-end 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 foor, a double-sided freplace, and a master ensuite featuring a Juliet balcony, every detail of this home exudes luxury and comfort with high end expertly crafted fnishes. 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 freplace, 3 car, Dishwasher, washer/dryer, microwave, fridge, CVAC, Gasline for BBQ." +"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" +"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-12T07:40:15.030389+00:00" +"CrossStreet": "Rebecca/Dorval" +"DaysOnMarket": 269 +"DirectionFaces": "West" +"Disclosures": array:1 [ 0 => "Unknown" ] +"ExpirationDate": "2025-01-31" +"ExteriorFeatures": array:2 [ 0 => "Porch" 1 => "Privacy" ] +"FireplaceFeatures": array:1 [ 0 => "Family Room" ] +"FoundationDetails": array:1 [ 0 => "Unknown" ] +"GarageYN": true +"Inclusions": "Dishwasher, Dryer, Microwave, Refrigerator, Stove" +"InteriorFeatures": array:1 [ 0 => "Central Vacuum" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Laundry Room" ] +"ListingContractDate": "2024-11-04" +"LotSizeDimensions": "59.78 x 23.53" +"MainOfficeKey": "541000" +"MajorChangeTimestamp": "2024-11-05T12:35:32Z" +"MlsStatus": "New" +"OccupantType": "Owner" +"OriginalEntryTimestamp": "2024-11-05T12:35:32Z" +"OriginalListPrice": 2580000.0 +"OriginatingSystemID": "omdreb" +"OriginatingSystemKey": "40673754" +"ParcelNumber": "248230241" +"ParkingFeatures": array:1 [ 0 => "Other" ] +"ParkingTotal": "3.0" +"PhotosChangeTimestamp": "2024-11-05T12:35:32Z" +"PoolFeatures": array:1 [ 0 => "None" ] +"PropertyAttachedYN": true +"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": "2.5% +HST" +"TransactionType": "For Sale" +"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": "For Sale" +"WaterYNA": "Available" +"LotWidth": 23.53 +"HeatType": "Forced Air" +"WashroomsType3Pcs": 4 +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('W10418222')" +"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": "155343972" +"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" +"Media": array:37 [ 0 => array:26 [ …26] 1 => array:26 [ …26] 2 => array:26 [ …26] 3 => array:26 [ …26] 4 => array:26 [ …26] 5 => array:26 [ …26] 6 => array:26 [ …26] 7 => array:26 [ …26] 8 => array:26 [ …26] 9 => array:26 [ …26] 10 => array:26 [ …26] 11 => array:26 [ …26] 12 => array:26 [ …26] 13 => array:26 [ …26] 14 => array:26 [ …26] 15 => array:26 [ …26] 16 => array:26 [ …26] 17 => array:26 [ …26] 18 => array:26 [ …26] 19 => array:26 [ …26] 20 => array:26 [ …26] 21 => array:26 [ …26] 22 => array:26 [ …26] 23 => array:26 [ …26] 24 => array:26 [ …26] 25 => array:26 [ …26] 26 => array:26 [ …26] 27 => array:26 [ …26] 28 => array:26 [ …26] 29 => array:26 [ …26] 30 => array:26 [ …26] 31 => array:26 [ …26] 32 => array:26 [ …26] 33 => array:26 [ …26] 34 => array:26 [ …26] 35 => array:26 [ …26] 36 => array:26 [ …26] ] } ] +success: true +page_size: 9 +page_count: 13623 +count: 122599 +after_key: "" } ] ]
