Located in the centre of the quaint town of Waterford within walking distance to antique shops, restaurants, library, trails and Waterford Ponds, a rare opportunity to enjoy a unique living space in a beautiful, historic stone mansion (circa 1840). Thie 1 bedroom, 1 bathroom apartment unit has been recently renovated, retaining interior stone wall features which adds character and interest
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 29860603 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23407 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23409 +post_id: "1502493" +post_author: 1 +"ListingKey": "29860603" +"ListingId": "40836768" +"PropertyType": "Residential Lease" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-05T19:45:21Z" +"RFModificationTimestamp": "2026-06-05T19:48:54Z" +"ListPrice": 0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 0 +"LivingArea": 800.0 +"BuildingAreaTotal": 0 +"City": "Waterford" +"PostalCode": "L0E1Y0" +"UnparsedAddress": "59 MAIN ST N Street N Unit# 2, Waterford, Ontario L0E1Y0" +"Coordinates": array:2 [ 0 => -80.2922959 1 => 42.9381019 ] +"Latitude": 42.9381019 +"Longitude": -80.2922959 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Located in the centre of the quaint town of Waterford within walking distance to antique shops, restaurants, library, trails and Waterford Ponds, a rare opportunity to enjoy a unique living space in a beautiful, historic stone mansion (circa 1840). Thie 1 bedroom, 1 bathroom apartment unit has been recently renovated, retaining interior stone wall features which adds character and interest to the unit. Approx. 800 sq. ft., this unit has its own. separate entrance and small patio. The ground floor suite is perfectly designed with a sunroom or office space to work from home. Fibe internet available. The building is fully equipped with fire alarm system and security cameras with a controlled entry. Parking included is an outdoor parking space. Possible EV charging could be available as is garage parking at additional charge. Small pets permitted upon approval. 30-45 minutes to Hamilton/Guelph/Kitchener/Brantford. Applicants should prepare Rental Application Form, Equifax Credit Report, Employment or Income verification and References. Allow 24 hours to arrange showing. Landlord will conduct all showings. Available July 3rd. Coin shared Laundry is located in newly renovated basement space. Tenant to pay heat and hydro. (id:62650)" +"Appliances": array:2 [ 0 => "Refrigerator" 1 => "Stove" ] +"AssociationFeeIncludes": array:1 [ 0 => "Water" ] +"Basement": array:1 [ 0 => "None" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-06-05T18:35:34.073539+00:00" +"Directions": "Old Highway 24 or Main Street to Sovereign." +"ExteriorFeatures": array:1 [ 0 => "Stone" ] +"Heating": array:1 [ 0 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1474189" +"ListOfficeKey": "283457" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Corner Site" 1 => "Conservation/green belt" 2 => "Paved driveway" 3 => "Laundry- Coin operated" ] +"ParkingFeatures": array:1 [ 0 => "Open" ] +"PhotosChangeTimestamp": "2026-06-05T16:32:11Z" +"PhotosCount": 15 +"PropertyAttachedYN": true +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-05T19:39:21Z" +"Stories": "1.0" +"StreetDirSuffix": "North" +"StreetName": "MAIN" +"StreetNumber": "59" +"StreetSuffix": "Street" +"SubdivisionName": "Waterford" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:5 [ 0 => array:11 [ "RoomKey" => "1652605114" "RoomType" => "4pc Bathroom" "ListingId" => "40836768" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29860603" "RoomLength" => null "RoomDimensions" => "10' x 8'" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-05T19:39:21.28Z" ] 1 => array:11 [ "RoomKey" => "1652605115" "RoomType" => "Office" "ListingId" => "40836768" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29860603" "RoomLength" => null "RoomDimensions" => "10'0'' x 8'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-05T19:39:21.28Z" ] 2 => array:11 [ "RoomKey" => "1652605116" "RoomType" => "Primary Bedroom" "ListingId" => "40836768" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29860603" "RoomLength" => null "RoomDimensions" => "12'0'' x 12'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-05T19:39:21.28Z" ] 3 => array:11 [ "RoomKey" => "1652605117" "RoomType" => "Eat in kitchen" "ListingId" => "40836768" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29860603" "RoomLength" => null "RoomDimensions" => "14' x 12'" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-05T19:39:21.28Z" ] 4 => array:11 [ "RoomKey" => "1652605118" "RoomType" => "Living room" "ListingId" => "40836768" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "29860603" "RoomLength" => null "RoomDimensions" => "14'0'' x 12'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-05T19:39:21.29Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/29860603/59-main-street-n-unit-2-waterford" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 2195 +"SecurityFeatures": array:2 [ 0 => "Alarm system" 1 => "Security system" ] +"ZoningDescription": "R5" +"BedroomsAboveGrade": 1 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"FrontageLengthNumeric": 201.0 +"AboveGradeFinishedArea": 800 +"OriginalEntryTimestamp": "2026-06-05T16:32:11.13Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Owner" +"ListAgentNationalAssociationId": "1129681" +"ListOfficeNationalAssociationId": "1330157" +"Media": array:15 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29860603_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/5f4545fe81af84fd9113d00973300bfb.webp" "MediaSize" => 95494 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-5f4545fe81af84fd9113d00973300bfb.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Large stone address marker with black lettering" "PreferredPhotoYN" => true "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29860603_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/831bed1502862deb3d8b69f063105fb9.webp" "MediaSize" => 67475 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-831bed1502862deb3d8b69f063105fb9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Historic Stone Mansion" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29860603_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/ede59364368662b507c1b18931e6e071.webp" "MediaSize" => 49627 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-ede59364368662b507c1b18931e6e071.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Side Property Parking" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29860603_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/e08f8010b3cc9d173756f8159f40b732.webp" "MediaSize" => 68756 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-e08f8010b3cc9d173756f8159f40b732.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Private suite enetry" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29860603_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/493e8baf5938175025bd80b90f7ebfbd.webp" "MediaSize" => 29823 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-493e8baf5938175025bd80b90f7ebfbd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Open-concept kitchen featuring dark cabinetry, a central island with a granite-style countertop, full-size white appliances, and wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29860603_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/2d80cfcc80a721fba40ff805c934d91e.webp" "MediaSize" => 29615 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-2d80cfcc80a721fba40ff805c934d91e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring a central island with a speckled countertop, dark cabinetry, and wood-finish flooring" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29860603_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/b8594d3a5c2f0ad8d4f9c21ca8eca56f.webp" "MediaSize" => 26885 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-b8594d3a5c2f0ad8d4f9c21ca8eca56f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View to living room" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29860603_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/0f52cf54e718ea35376f764c352db387.webp" "MediaSize" => 33134 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-0f52cf54e718ea35376f764c352db387.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Kitchen featuring dark cabinetry, light countertops, and a central island with a contrasting stone surface" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29860603_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/afe1f2c735a114ecfbc88c829a72e47c.webp" "MediaSize" => 36436 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-afe1f2c735a114ecfbc88c829a72e47c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29860603_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/d0759271f00abc2fc68154193dc05e02.webp" "MediaSize" => 46435 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-d0759271f00abc2fc68154193dc05e02.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Exposed stone wall with horizontal wood accents" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29860603_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/7a414daac82a926c09518c374ded82e2.webp" "MediaSize" => 44945 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-7a414daac82a926c09518c374ded82e2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29860603_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/1bcc4482e208a2809201669dfc8d3b04.webp" "MediaSize" => 30992 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-1bcc4482e208a2809201669dfc8d3b04.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29860603_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/52cf1a3612c2c9d6ab2498cce10dafb5.webp" "MediaSize" => 25396 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-52cf1a3612c2c9d6ab2498cce10dafb5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a white bathtub with a tiled surround, a white toilet, and light-toned floor tiling" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29860603_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/d56fff2e885b8ef97f1fe03e7052ca4a.webp" "MediaSize" => 47823 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-d56fff2e885b8ef97f1fe03e7052ca4a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Vanity with an integrated sink, dark countertop, and brushed nickel fixtures" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29860603_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29860603/05ccb07e9cfb70ab2532113f959636f1.webp" "MediaSize" => 28226 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29860603/thumbnail-05ccb07e9cfb70ab2532113f959636f1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bathroom featuring a stone accent wall, tile flooring, and a white vanity with drawer storage" "PreferredPhotoYN" => false "ResourceRecordId" => "40836768" "ResourceRecordKey" => "29860603" "ModificationTimestamp" => "2026-06-05T16:32:11.13Z" ] ] +"DaysOnMarket": 16 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860603')" +"ID": "1502493" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.13 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 283457" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24857 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1474189" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24830 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29860603'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25144 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29860603'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25160 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29860603' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential Lease' AND geo.distance(Coordinates, POINT(-80.2922959 42.9381019)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25207 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.12 seconds" ] ]