Available for lease: 2-acre yard with detached dwelling (office/employee housing) and a 1, 356 sq ft insulated industrial workshop/garage. Ideal for landscaping companies, pool contractors, builders, and storage yard users (A2 zoning-tenant to verify permitted uses).Located directly across from Connon Nurseries with strong daily exposure. Minutes to Highways 407, 403, and QEW. Landlord open to subleasing. (id:62650)
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:6 [ "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29684982 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408 +post_id: "1373951" +post_author: 1 +"ListingKey": "29684982" +"ListingId": "X13068614" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-05-01T16:05:36Z" +"RFModificationTimestamp": "2026-05-01T16:55:13Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 2.0 +"LivingArea": 2.0 +"BuildingAreaTotal": 0 +"City": "Hamilton (Waterdown)" +"PostalCode": "L0R2H1" +"UnparsedAddress": "623 ROBSON ROAD, Hamilton (Waterdown), Ontario L0R2H1" +"Coordinates": array:2 [ 0 => -79.890154 1 => 43.351164 ] +"Latitude": 43.351164 +"Longitude": -79.890154 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Toronto Regional Real Estate Board" +"PublicRemarks": "Available for lease: 2-acre yard with detached dwelling (office/employee housing) and a 1,356 sq ft insulated industrial workshop/garage. Ideal for landscaping companies, pool contractors, builders, and storage yard users (A2 zoning-tenant to verify permitted uses).Located directly across from Connon Nurseries with strong daily exposure. Minutes to Highways 407, 403, and QEW. Landlord open to subleasing. (id:62650)" +"CreationDate": "2026-05-01T16:54:46.138627+00:00" +"Directions": "Parkside Dr/Robson Rd" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1976142" +"ListOfficeKey": "292146" +"LotFeatures": array:1 [ 0 => "Conservation/green belt" ] +"LotSizeDimensions": "2" +"PhotosChangeTimestamp": "2026-05-01T15:53:19Z" +"PhotosCount": 5 +"Sewer": array:1 [ 0 => "Septic System" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-05-01T15:53:19Z" +"StreetName": "Robson" +"StreetNumber": "623" +"StreetSuffix": "Road" +"TaxAnnualAmount": "5022" +"ListAOR": "Toronto" +"CityRegion": "Waterdown" +"ListAORKey": "82" +"ListingURL": "www.realtor.ca/real-estate/29684982/623-robson-road-hamilton-waterdown-waterdown" +"GeocodeManualYN": false +"TotalActualRent": 13000 +"ZoningDescription": "A2" +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 120.4 +"OriginalEntryTimestamp": "2026-05-01T15:53:19.57Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1293759" +"ListOfficeNationalAssociationId": "1417330" +"Media": array:5 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "6643306601" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29684982/eccd732f2bcf742ef478aff0690e8c77.webp" "MediaSize" => 468639 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29684982/thumbnail-eccd732f2bcf742ef478aff0690e8c77.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "X13068614" "ResourceRecordKey" => "29684982" "ModificationTimestamp" => "2026-05-01T15:53:19.57Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "6643306670" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29684982/1e2aa40aaea7da15939dffac41784910.webp" "MediaSize" => 492569 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29684982/thumbnail-1e2aa40aaea7da15939dffac41784910.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13068614" "ResourceRecordKey" => "29684982" "ModificationTimestamp" => "2026-05-01T15:53:19.57Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "6643306732" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29684982/0c3a49ad8a9d43fd4d19695af450af33.webp" "MediaSize" => 548390 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29684982/thumbnail-0c3a49ad8a9d43fd4d19695af450af33.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13068614" "ResourceRecordKey" => "29684982" "ModificationTimestamp" => "2026-05-01T15:53:19.57Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "6643306747" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29684982/220e5d1219113660f977acbb7f5da456.webp" "MediaSize" => 603692 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29684982/thumbnail-220e5d1219113660f977acbb7f5da456.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13068614" "ResourceRecordKey" => "29684982" "ModificationTimestamp" => "2026-05-01T15:53:19.57Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "6643306878" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29684982/51ebe8df99bd10f201a9938458c9727c.webp" "MediaSize" => 539941 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29684982/thumbnail-51ebe8df99bd10f201a9938458c9727c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "X13068614" "ResourceRecordKey" => "29684982" "ModificationTimestamp" => "2026-05-01T15:53:19.57Z" ] ] +"DaysOnMarket": 51 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29684982')" +"ID": "1373951" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.14 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 292146" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24828 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1976142" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24801 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.17 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29684982'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25105 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.13 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29684982'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25121 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29684982' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.890154 43.351164)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25168 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] ]