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:1 [ "RF Query: /Property?$select=ALL&$orderby=ListingId DESC&$top=12&$skip=165516&$filter=(PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24536 +items: array:12 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24612 +post_id: "797109" +post_author: 1 +"ListingKey": "28251289" +"ListingId": "40723005" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-07T19:30:22Z" +"RFModificationTimestamp": "2026-06-07T19:43:23Z" +"ListPrice": 530000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1917.0 +"BuildingAreaTotal": 0 +"City": "Mount Forest" +"PostalCode": "N0G2L2" +"UnparsedAddress": "271 FOREST GLEN Crescent, Mount Forest, Ontario N0G2L2" +"Coordinates": array:2 [ 0 => -80.7259897 1 => 43.98305393 ] +"Latitude": 43.98305393 +"Longitude": -80.7259897 +"YearBuilt": 1979 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this lovely, move-in ready 3+1 bedroom bungalow nestled in a quiet, mature neighbourhood! Perfectly located just steps from nearby baseball diamonds, a splash pad, and a walking track—this home offers the ideal blend of community charm and everyday convenience. Inside, you’ll appreciate the bright and functional layout, featuring a cozy gas fireplace (new in Jan 2025), an updated kitchen (2016), and double-hung windows in the primary bedroom, kitchen, and living room (2009). The finished lower level provides extra space for a fourth bedroom, home office, or rec room—perfect for growing families or guests. Major updates include a metal roof with a lifetime warranty (2017), a high-efficiency furnace (2021), and Gutter Guards (2022) for low-maintenance living. With Wightman Fibre Optic internet available, you can enjoy fast, reliable service for work or streaming. With Mature trees the back yard has more than enough space for the whole family to enjoy. Just under an hour to Waterloo, Guelph & Orangeville this home offers small town living benefits while still being close enough to all amenities. If you are looking for a small town atmosphere, friendly people, and a lot of opportunity, then Mount Forest is the right place to call home. This well-maintained home is a must-see—don’t miss your chance to settle into a peaceful and family-friendly neighbourhood! (id:62783)" +"Appliances": array:6 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water softener" 3 => "Stove" 4 => "Hood Fan" 5 => "Window Coverings" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Partially finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:3 [ 0 => "Quiet Area" 1 => "School Bus" 2 => "Community Centre" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2025-05-03T03:46:59.869018+00:00" +"Directions": "From Queen St head East on Albert St follow to Forest Glen Cres turn North follow to house" +"ExteriorFeatures": array:2 [ 0 => "Stone" 1 => "Metal" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2053569" +"ListOfficeKey": "289890" +"LivingAreaUnits": "square feet" +"LotFeatures": array:2 [ 0 => "Paved driveway" 1 => "Sump Pump" ] +"PhotosChangeTimestamp": "2026-04-27T23:11:18Z" +"PhotosCount": 36 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-07T19:22:51Z" +"Stories": "1.0" +"StreetName": "FOREST GLEN" +"StreetNumber": "271" +"StreetSuffix": "Crescent" +"SubdivisionName": "72 - Mount Forest" +"TaxAnnualAmount": "2853" +"VirtualTourURLUnbranded": "https://youriguide.com/271_forest_glen_crescent_mount_forest_on/" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:12 [ 0 => array:11 [ "RoomKey" => "1654375621" "RoomType" => "Utility room" "ListingId" => "40723005" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "12'8'' x 11'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.41Z" ] 1 => array:11 [ "RoomKey" => "1654375622" "RoomType" => "Laundry room" "ListingId" => "40723005" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "12'8'' x 12'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.43Z" ] 2 => array:11 [ "RoomKey" => "1654375623" "RoomType" => "Bedroom" "ListingId" => "40723005" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "12'7'' x 9'1''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.44Z" ] 3 => array:11 [ "RoomKey" => "1654375624" "RoomType" => "Recreation room" "ListingId" => "40723005" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "12'11'' x 34'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.44Z" ] 4 => array:11 [ "RoomKey" => "1654375625" "RoomType" => "4pc Bathroom" "ListingId" => "40723005" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "8'1'' x 7'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.45Z" ] 5 => array:11 [ "RoomKey" => "1654375626" "RoomType" => "Bedroom" "ListingId" => "40723005" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "8'10'' x 9'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.46Z" ] 6 => array:11 [ "RoomKey" => "1654375627" "RoomType" => "Bedroom" "ListingId" => "40723005" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "8'10'' x 9'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.47Z" ] 7 => array:11 [ "RoomKey" => "1654375628" "RoomType" => "Primary Bedroom" "ListingId" => "40723005" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "14'7'' x 10'3''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.48Z" ] 8 => array:11 [ "RoomKey" => "1654375629" "RoomType" => "2pc Bathroom" "ListingId" => "40723005" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "5'4'' x 3'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.49Z" ] 9 => array:11 [ "RoomKey" => "1654375630" "RoomType" => "Dining room" "ListingId" => "40723005" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "5'10'' x 8'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.49Z" ] 10 => array:11 [ "RoomKey" => "1654375631" "RoomType" => "Kitchen" "ListingId" => "40723005" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "10'9'' x 8'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.5Z" ] 11 => array:11 [ "RoomKey" => "1654375632" "RoomType" => "Living room" "ListingId" => "40723005" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28251289" "RoomLength" => null "RoomDimensions" => "12'0'' x 14'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-07T19:22:51.5Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28251289/271-forest-glen-crescent-mount-forest" +"ParkingTotal": 5 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1876463" +"CommonInterest": "Freehold" +"CoListOfficeKey": "289890" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R1B" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 60.0 +"AboveGradeFinishedArea": 1031 +"BelowGradeFinishedArea": 886 +"OriginalEntryTimestamp": "2025-05-02T18:17:55.96Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1328851" +"ListOfficeNationalAssociationId": "1382470" +"CoListAgentNationalAssociationId": "1204368" +"CoListOfficeNationalAssociationId": "1382470" +"Media": array:36 [ 0 => array:13 [ "Order" => 0 "MediaKey" => "6425795109" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/8041340cf8df2560313649330975e6b6.webp" "MediaSize" => 147437 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-8041340cf8df2560313649330975e6b6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.91Z" ] 1 => array:13 [ "Order" => 1 "MediaKey" => "6425795113" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/f8c9c25ba38aa47c5e816f6b3773382d.webp" "MediaSize" => 171159 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-f8c9c25ba38aa47c5e816f6b3773382d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.83Z" ] 2 => array:13 [ "Order" => 2 "MediaKey" => "6425795116" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/5fcb44505a75f46745c6f494761a5856.webp" "MediaSize" => 183075 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-5fcb44505a75f46745c6f494761a5856.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.95Z" ] 3 => array:13 [ "Order" => 3 "MediaKey" => "6425795120" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/2cdd7f4b39ae22b6f5ed78d065dd39d8.webp" "MediaSize" => 150490 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-2cdd7f4b39ae22b6f5ed78d065dd39d8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.85Z" ] 4 => array:13 [ "Order" => 4 "MediaKey" => "6425795125" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/6158a77b2ff08c8824766dae33b16a35.webp" "MediaSize" => 122613 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-6158a77b2ff08c8824766dae33b16a35.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.45Z" ] 5 => array:13 [ "Order" => 5 "MediaKey" => "6425795140" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/fcaab2c91bf8f157da0185a572eb2ee1.webp" "MediaSize" => 121537 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-fcaab2c91bf8f157da0185a572eb2ee1.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.87Z" ] 6 => array:13 [ "Order" => 6 "MediaKey" => "6425795149" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/e2d44d43dafeed00e665867a2c369d23.webp" "MediaSize" => 68263 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-e2d44d43dafeed00e665867a2c369d23.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.84Z" ] 7 => array:13 [ "Order" => 7 "MediaKey" => "6425795153" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/42268e888198f689fb9ef3564c6cce66.webp" "MediaSize" => 61255 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-42268e888198f689fb9ef3564c6cce66.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.84Z" ] 8 => array:13 [ "Order" => 8 "MediaKey" => "6425795157" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/5a38dd45e104d95923fc2eaec226953e.webp" "MediaSize" => 63812 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-5a38dd45e104d95923fc2eaec226953e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.84Z" ] 9 => array:13 [ "Order" => 9 "MediaKey" => "6425795161" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/4fac961264d8f4a176835eceaa0f302f.webp" "MediaSize" => 66327 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-4fac961264d8f4a176835eceaa0f302f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.85Z" ] 10 => array:13 [ "Order" => 10 "MediaKey" => "6425795165" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/55f0177bafbac56c1b80fc1ca2ce91f2.webp" "MediaSize" => 55559 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-55f0177bafbac56c1b80fc1ca2ce91f2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.45Z" ] 11 => array:13 [ "Order" => 11 "MediaKey" => "6425795168" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/0d9611781c6b855a0fd9551ce074488a.webp" "MediaSize" => 69366 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-0d9611781c6b855a0fd9551ce074488a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.83Z" ] 12 => array:13 [ "Order" => 12 "MediaKey" => "6425795171" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/9a55b3ebceff3ff471fa2766faa32755.webp" "MediaSize" => 77120 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-9a55b3ebceff3ff471fa2766faa32755.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.83Z" ] 13 => array:13 [ "Order" => 13 "MediaKey" => "6425795174" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/b42473a3910a137269fc93dc4fec02dc.webp" "MediaSize" => 80988 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-b42473a3910a137269fc93dc4fec02dc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.43Z" ] 14 => array:13 [ "Order" => 14 "MediaKey" => "6425795182" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/8deb1e30203ecb107b82e3bc7743aedd.webp" "MediaSize" => 81091 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-8deb1e30203ecb107b82e3bc7743aedd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.83Z" ] 15 => array:13 [ "Order" => 15 "MediaKey" => "6425795185" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/4a1be1b8e5caf8701f58f5eba1fe7eaa.webp" "MediaSize" => 81637 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-4a1be1b8e5caf8701f58f5eba1fe7eaa.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.83Z" ] 16 => array:13 [ "Order" => 16 "MediaKey" => "6425795187" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/460b645c32f4244fb78f3febaeba10c8.webp" "MediaSize" => 61819 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-460b645c32f4244fb78f3febaeba10c8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.83Z" ] 17 => array:13 [ "Order" => 17 "MediaKey" => "6425795189" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/c1134f2ed7268de8f89fdc4d032948a4.webp" "MediaSize" => 51549 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-c1134f2ed7268de8f89fdc4d032948a4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.91Z" ] 18 => array:13 [ "Order" => 18 "MediaKey" => "6425795191" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/ad458d9baa4141125da6b6a0a7e5f450.webp" "MediaSize" => 53280 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-ad458d9baa4141125da6b6a0a7e5f450.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.83Z" ] 19 => array:13 [ "Order" => 19 "MediaKey" => "6425795194" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/606e2d9b5092fd115315aae31afe0222.webp" "MediaSize" => 62866 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-606e2d9b5092fd115315aae31afe0222.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "3rd Bedroom" "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.43Z" ] 20 => array:13 [ "Order" => 20 "MediaKey" => "6425795195" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/c54f2a9ec2f5daf51fb810ee325844d7.webp" "MediaSize" => 41736 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-c54f2a9ec2f5daf51fb810ee325844d7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "4 piece" "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.45Z" ] 21 => array:13 [ "Order" => 21 "MediaKey" => "6425795197" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/f100f5c332f0d422907cd3f8b9a49d73.webp" "MediaSize" => 53620 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-f100f5c332f0d422907cd3f8b9a49d73.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "4 piece" "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.43Z" ] 22 => array:13 [ "Order" => 22 "MediaKey" => "6425795199" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/b83d1d4ca978737659ed6476adc56545.webp" "MediaSize" => 35339 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-b83d1d4ca978737659ed6476adc56545.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Powder room" "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.43Z" ] 23 => array:13 [ "Order" => 23 "MediaKey" => "6425795201" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/9cd142417b2036f27637e7793c755973.webp" "MediaSize" => 53609 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-9cd142417b2036f27637e7793c755973.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.91Z" ] 24 => array:13 [ "Order" => 24 "MediaKey" => "6425795204" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/ff28c327f4b0fe0653dad445abd62f13.webp" "MediaSize" => 52223 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-ff28c327f4b0fe0653dad445abd62f13.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.43Z" ] 25 => array:13 [ "Order" => 25 "MediaKey" => "6425795206" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/9951308f78a001cb0077477690066614.webp" "MediaSize" => 74867 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-9951308f78a001cb0077477690066614.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.91Z" ] 26 => array:13 [ "Order" => 26 "MediaKey" => "6425795208" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/b9a9821bdafc8ebcb9aedf0f069a90b5.webp" "MediaSize" => 53831 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-b9a9821bdafc8ebcb9aedf0f069a90b5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.83Z" ] 27 => array:13 [ "Order" => 27 "MediaKey" => "6425795210" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/6ef3412d66ea44514a3c659f867e75bc.webp" "MediaSize" => 72821 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-6ef3412d66ea44514a3c659f867e75bc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Basement Bedroom/Office" "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.93Z" ] 28 => array:13 [ "Order" => 28 "MediaKey" => "6425795213" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/c2f1527a18f020eca09295c0b56cec1e.webp" "MediaSize" => 150830 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-c2f1527a18f020eca09295c0b56cec1e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.91Z" ] 29 => array:13 [ "Order" => 29 "MediaKey" => "6425795215" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/a2d0e485f2928f5b77d7e3e0f53b847a.webp" "MediaSize" => 157657 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-a2d0e485f2928f5b77d7e3e0f53b847a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.91Z" ] 30 => array:13 [ "Order" => 30 "MediaKey" => "6425795217" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/a3394b6a71f2e630cf86b569c0a3e3f0.webp" "MediaSize" => 169729 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-a3394b6a71f2e630cf86b569c0a3e3f0.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.43Z" ] 31 => array:13 [ "Order" => 31 "MediaKey" => "6425795219" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/16cc15039649248da5bbe0919dd10166.webp" "MediaSize" => 178836 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-16cc15039649248da5bbe0919dd10166.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.82Z" ] 32 => array:13 [ "Order" => 32 "MediaKey" => "6425795221" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/4441f63bf585c7744f7035b3364dc9ff.webp" "MediaSize" => 176237 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-4441f63bf585c7744f7035b3364dc9ff.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.44Z" ] 33 => array:13 [ "Order" => 33 "MediaKey" => "6425795224" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/94f3550425616597f6e307d03ed69a33.webp" "MediaSize" => 155601 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-94f3550425616597f6e307d03ed69a33.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:12.43Z" ] 34 => array:13 [ "Order" => 34 "MediaKey" => "6425795225" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/fae903ca7ce04ec599f1487af4cd7590.webp" "MediaSize" => 48963 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-fae903ca7ce04ec599f1487af4cd7590.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.82Z" ] 35 => array:13 [ "Order" => 35 "MediaKey" => "6425795229" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28251289/a604e521dfba934342003f1ab2e8f5b6.webp" "MediaSize" => 41236 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28251289/thumbnail-a604e521dfba934342003f1ab2e8f5b6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "40723005" "ResourceRecordKey" => "28251289" "ModificationTimestamp" => "2025-08-19T23:21:11.91Z" ] ] +"DaysOnMarket": 415 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28251289')" +"ID": "797109" } 1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24477 +post_id: "942317" +post_author: 1 +"ListingKey": "28220823" +"ListingId": "40721372" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-18T22:20:01Z" +"RFModificationTimestamp": "2026-06-18T22:41:10Z" +"ListPrice": 799000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5.05 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Stoney Creek" +"PostalCode": "L8J2Y2" +"UnparsedAddress": "RIDGE ROAD, STONEY CREEK N/A Road" +"Coordinates": array:2 [ 0 => -79.70840402 1 => 43.20368378 ] +"Latitude": 43.20368378 +"Longitude": -79.70840402 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Prime 5.05-Acre Corner Lot in Sought-After Ridge Road, Stoney Creek. This expansive parcel offers A1 zoning with a range of agricultural and rural residential possibilities—perfect for investors, builders, or those looking to hold land in a high-potential area. The elevated landscape provides beautiful views and the opportunity to create a peaceful retreat or long-term investment. The corner lot configuration allows for easy access, and the location is just minutes from city amenities including shops, restaurants, parks, and schools. A rare opportunity to secure land in one of Hamilton’s most desirable countryside areas. Any future building or development plans must first be approved by the Niagara Escarpment Commission (NEC). Buyers are advised to review any land use restrictions or requirements with the Niagara Escarpment Commission (NEC), as approvals may be required depending on intended use. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2025-04-28T22:16:38.881614+00:00" +"Directions": "Corner Lot at the intersection of Ridge road and Fifth Rd E." +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2223388" +"ListOfficeKey": "268714" +"LotFeatures": array:1 [ 0 => "Country residential" ] +"LotSizeDimensions": "5.05" +"PhotosChangeTimestamp": "2026-06-18T21:51:53Z" +"PhotosCount": 20 +"Sewer": array:1 [ 0 => "No sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-18T22:14:15Z" +"StreetName": "RIDGE" +"StreetNumber": "0" +"StreetSuffix": "Road" +"SubdivisionName": "052 - Stoney Creek Escarpment" +"TaxAnnualAmount": "103.24" +"WaterSource": array:1 [ 0 => "None" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28220823/0-ridge-road-stoney-creek" +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "A1" +"FrontageLengthNumeric": 617.0 +"OriginalEntryTimestamp": "2025-04-26T20:06:46.15Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1466772" +"ListOfficeNationalAssociationId": "1230749" +"Media": array:20 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "28220823_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/c59094ca164b7a0d0268d56524da188d.webp" "MediaSize" => 111720 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-c59094ca164b7a0d0268d56524da188d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view featuring a rural view and a water view. Please note: The red lines in this image are for reference only and indicate the approximate lot area. This is not a survey or an official document" "PreferredPhotoYN" => true "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.74Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "28220823_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/91d1e90ac5159dcfe316fbe91a614d5f.webp" "MediaSize" => 114404 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-91d1e90ac5159dcfe316fbe91a614d5f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view featuring a water view and a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.79Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "28220823_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/a74bf69fe1b416c4c208e5a9a30032bf.webp" "MediaSize" => 102706 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-a74bf69fe1b416c4c208e5a9a30032bf.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Drone / aerial view with a rural view and a water view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.18Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "28220823_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/755e5845e5be810e9e7d0ee7286922d9.webp" "MediaSize" => 110925 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-755e5845e5be810e9e7d0ee7286922d9.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view with a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.18Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "28220823_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/71afb90a7df2bc133cb1879308def02f.webp" "MediaSize" => 56395 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-71afb90a7df2bc133cb1879308def02f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Drone / aerial view featuring a water view and a rural view. Please note: The red lines in this image are for reference only and indicate the approximate lot area. This is not a survey or an official" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.18Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "28220823_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/c861184d1b60b307cdcd2103b94aa34a.webp" "MediaSize" => 98161 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-c861184d1b60b307cdcd2103b94aa34a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bird's eye view with a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.19Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "28220823_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/fca926ec37dcd9527829ffd0fde3b805.webp" "MediaSize" => 101697 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-fca926ec37dcd9527829ffd0fde3b805.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bird's eye view featuring a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.69Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "28220823_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/199cf582f4c3006ec756497518b5265d.webp" "MediaSize" => 77882 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-199cf582f4c3006ec756497518b5265d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view at dusk featuring a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.74Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "28220823_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/0419e520815cad6ada51304576d47dec.webp" "MediaSize" => 82185 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-0419e520815cad6ada51304576d47dec.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view at dusk featuring a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.74Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "28220823_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/276a12c532498f695c42db2ad5772db2.webp" "MediaSize" => 97145 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-276a12c532498f695c42db2ad5772db2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view featuring a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.18Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "28220823_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/16c560f138bc50ccafa432266b805cd5.webp" "MediaSize" => 98168 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-16c560f138bc50ccafa432266b805cd5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view with a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.74Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "28220823_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/53cc84abcf7ab9645349a8240e403e13.webp" "MediaSize" => 89268 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-53cc84abcf7ab9645349a8240e403e13.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bird's eye view featuring a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.69Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "28220823_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/8a405cdfa142c63ee3ab934340a07331.webp" "MediaSize" => 150600 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-8a405cdfa142c63ee3ab934340a07331.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Map location. Please note: The red lines in this image are for reference only and indicate the approximate lot area. This is not a survey or an official document." "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.18Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "28220823_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/58a5871e05be6ce567bbce25e245c54c.webp" "MediaSize" => 103651 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-58a5871e05be6ce567bbce25e245c54c.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Drone / aerial view featuring a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.18Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "28220823_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/9c75d912f2b1690d4805ee60120f7f8d.webp" "MediaSize" => 97750 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-9c75d912f2b1690d4805ee60120f7f8d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bird's eye view featuring a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.18Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "28220823_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/0be878fd0de4302daf99ca5ff9ac76dc.webp" "MediaSize" => 89998 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-0be878fd0de4302daf99ca5ff9ac76dc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view with a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.74Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "28220823_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/56d9dcb8e4866a5c598c1005dbaa6013.webp" "MediaSize" => 131911 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-56d9dcb8e4866a5c598c1005dbaa6013.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Aerial view featuring a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.78Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "28220823_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/7c75323b67ca834bfe01ae75c225bd72.webp" "MediaSize" => 138599 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-7c75323b67ca834bfe01ae75c225bd72.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Bird's eye view with a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.18Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "28220823_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/1b5439ba4a079376c936a4a9eb0acb38.webp" "MediaSize" => 56327 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-1b5439ba4a079376c936a4a9eb0acb38.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "Drone / aerial view with a rural view" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.69Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "28220823_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28220823/e040c40e663cf95c240e1378821a54f2.webp" "MediaSize" => 93718 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28220823/thumbnail-e040c40e663cf95c240e1378821a54f2.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => "View of road" "PreferredPhotoYN" => false "ResourceRecordId" => "40721372" "ResourceRecordKey" => "28220823" "ModificationTimestamp" => "2026-06-18T21:51:53.74Z" ] ] +"DaysOnMarket": 421 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28220823')" +"ID": "942317" } 2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24600 +post_id: "1026937" +post_author: 1 +"ListingKey": "28212845" +"ListingId": "40721316" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-10T00:00:42Z" +"RFModificationTimestamp": "2026-06-10T00:04:52Z" +"ListPrice": 939900.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 3220.0 +"BuildingAreaTotal": 0 +"City": "Niagara Falls" +"PostalCode": "L2H3R8" +"UnparsedAddress": "7776 TUPELO Crescent, Niagara Falls, Ontario L2H3R8" +"Coordinates": array:2 [ 0 => -79.14359777 1 => 43.06304477 ] +"Latitude": 43.06304477 +"Longitude": -79.14359777 +"YearBuilt": 2020 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Featherstone Model. Large pie shaped lot - largest in neighbourhood - with room for a pool and still more room for the kids to play. Roomy deck with a pergola for summer time relaxation. Separate fire pit for those cool summer nights. Fully fenced yard backing onto a forested area. The interior? Vinyl plank flooring with ceramic tile on the main floor with an oak staircase leading to the upstairs. The second floor features quality broadloom and ceramic flooring in all bathrooms and the laundry room. The master bedroom features a retreat area - listed here as sitting for lack of a better designation; walk in closet, and a stunning ensuite featuring a soaker tub, two totally separate vanity areas for early morning prep and a large shower. Two bedrooms are connected via a jack & jill 4 piece bathroom with ensuite privileges for both. The fourth bedroom features a roomy walk in closet and it's own 4 piece ensuite - perfect for in laws, a nanny or guests.. The kitchen features a planning center referred to as a pantry in the listing for lack of a better descriptive; and a mud room off of it with access to the garage and basement (unfinished and ready for your finishing). The main kitchen and planning area have quartz counter tops with under cabinet lighting in the kitchen with a ceramic backsplash. All appliances stay as seen. All brick exterior - one of a few in the entire neighbourhood. (id:62650)" +"Appliances": array:6 [ 0 => "Refrigerator" 1 => "Water meter" 2 => "Dishwasher" 3 => "Stove" 4 => "Dryer" 5 => "Garage door opener" ] +"Basement": array:2 [ 0 => "Unfinished" 1 => "Full" ] +"BathroomsPartial": 1 +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-04-25T13:26:46.609316+00:00" +"Directions": "McLeod Rd., south on Kalar then west on Mulberry, south on Butternut, west on Warren Woods, North on Shagbark, then east on Tupelo." +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FireplaceFeatures": array:2 [ 0 => "Electric" 1 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524139" +"ListOfficeKey": "91227" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Conservation/green belt" 1 => "Paved driveway" 2 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-04-18T04:20:54Z" +"PhotosCount": 50 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:54:22Z" +"Stories": "2.0" +"StreetName": "TUPELO" +"StreetNumber": "7776" +"StreetSuffix": "Crescent" +"SubdivisionName": "222 - Brown" +"TaxAnnualAmount": "9623" +"VirtualTourURLUnbranded": "https://youtu.be/1kCpWBg4JHc" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:18 [ 0 => array:11 [ "RoomKey" => "1656002661" "RoomType" => "Laundry room" "ListingId" => "40721316" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "5'11'' x 8'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.55Z" ] 1 => array:11 [ "RoomKey" => "1656002662" "RoomType" => "4pc Bathroom" "ListingId" => "40721316" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "5'6'' x 10'6''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.55Z" ] 2 => array:11 [ "RoomKey" => "1656002663" "RoomType" => "4pc Bathroom" "ListingId" => "40721316" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "6'4'' x 8'4''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.55Z" ] 3 => array:11 [ "RoomKey" => "1656002664" "RoomType" => "Bedroom" "ListingId" => "40721316" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "10'10'' x 13'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.55Z" ] 4 => array:11 [ "RoomKey" => "1656002665" "RoomType" => "Bedroom" "ListingId" => "40721316" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "14'10'' x 14'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.56Z" ] 5 => array:11 [ "RoomKey" => "1656002666" "RoomType" => "Bedroom" "ListingId" => "40721316" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "12'1'' x 15'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.56Z" ] 6 => array:11 [ "RoomKey" => "1656002667" "RoomType" => "5pc Bathroom" "ListingId" => "40721316" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "10'2'' x 13'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.56Z" ] 7 => array:11 [ "RoomKey" => "1656002668" "RoomType" => "Sitting room" "ListingId" => "40721316" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "9'9'' x 9'9''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.56Z" ] 8 => array:11 [ "RoomKey" => "1656002669" "RoomType" => "Primary Bedroom" "ListingId" => "40721316" "RoomLevel" => "Second level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "12'11'' x 17'10''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.56Z" ] 9 => array:11 [ "RoomKey" => "1656002670" "RoomType" => "Mud room" "ListingId" => "40721316" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "6'5'' x 13'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.56Z" ] 10 => array:11 [ "RoomKey" => "1656002671" "RoomType" => "Pantry" "ListingId" => "40721316" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "6'5'' x 12'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.56Z" ] 11 => array:11 [ "RoomKey" => "1656002672" "RoomType" => "Kitchen" "ListingId" => "40721316" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "11'6'' x 22'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.57Z" ] 12 => array:11 [ "RoomKey" => "1656002673" "RoomType" => "Dining room" "ListingId" => "40721316" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "10'6'' x 14'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.57Z" ] 13 => array:11 [ "RoomKey" => "1656002674" "RoomType" => "Great room" "ListingId" => "40721316" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "16'0'' x 20'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.57Z" ] 14 => array:11 [ "RoomKey" => "1656002675" "RoomType" => "2pc Bathroom" "ListingId" => "40721316" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "5'0'' x 4'8''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.57Z" ] 15 => array:11 [ "RoomKey" => "1656002676" "RoomType" => "Den" "ListingId" => "40721316" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "10'8'' x 10'0''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.57Z" ] 16 => array:11 [ "RoomKey" => "1656002677" "RoomType" => "Foyer" "ListingId" => "40721316" "RoomLevel" => "Main level" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "6'2'' x 9'2''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.57Z" ] 17 => array:11 [ "RoomKey" => "1656002678" "RoomType" => "Utility room" "ListingId" => "40721316" "RoomLevel" => "Basement" "RoomWidth" => null "ListingKey" => "28212845" "RoomLength" => null "RoomDimensions" => "33'5'' x 49'7''" "RoomDescription" => null "RoomLengthWidthUnits" => null "ModificationTimestamp" => "2026-06-09T23:54:22.57Z" ] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28212845/7776-tupelo-crescent-niagara-falls" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R1F" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 35.0 +"AboveGradeFinishedArea": 3220 +"OriginalEntryTimestamp": "2025-04-24T23:27:27.96Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Plans" +"ListAgentNationalAssociationId": "1063186" +"ListOfficeNationalAssociationId": "1155187" +"Media": array:50 [ 0 => array:13 [ "Order" => 1 …12 ] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] 48 => array:13 [ …13] 49 => array:13 [ …13] ] +"DaysOnMarket": 423 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28212845')" +"ID": "1026937" } 3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24491 +post_id: "893492" +post_author: 1 +"ListingKey": "28196159" +"ListingId": "40720160" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:31Z" +"RFModificationTimestamp": "2026-06-02T18:14:14Z" +"ListPrice": 3599000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 3.62 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Waterford" +"PostalCode": "N0E1Y0" +"UnparsedAddress": "822 REGIONAL ROAD 24, Waterford, Ontario N0E1Y0" +"Coordinates": array:2 [ 0 => -80.28759086 1 => 42.92393456 ] +"Latitude": 42.92393456 +"Longitude": -80.28759086 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Attention Developers, Investors and Franchisees! 3.62 Acres, located on the golden strip in Waterford. Currently zoned R1A but designated commercial in the official plan. This land is just north of a large commercial plaza and gas station. Great for offices, auto mobile sales/service, restaurants, higher density residential or a combination. Could be split into parcels. Great Opportunity in a thriving community just 30 minutes from Brantford Hamilton minutes away from Simcoe. Includes bungalow located on the property. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"CreationDate": "2025-04-23T22:50:48.560824+00:00" +"Directions": "Regional Rd 24 south of Thompson Road" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1396633" +"ListOfficeKey": "48556" +"LotSizeDimensions": "3.62" +"PhotosChangeTimestamp": "2025-08-19T22:40:04Z" +"PhotosCount": 8 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T17:04:35Z" +"StreetName": "REGIONAL ROAD 24" +"StreetNumber": "822" +"SubdivisionName": "Waterford" +"TaxAnnualAmount": "3228" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28196159/822-regional-road-24-waterford" +"CoListAgentKey": "1396700" +"CommonInterest": "Freehold" +"CoListOfficeKey": "48556" +"GeocodeManualYN": true +"ZoningDescription": "R1A" +"FrontageLengthNumeric": 540.0 +"OriginalEntryTimestamp": "2025-04-22T16:13:12.09Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1069103" +"ListOfficeNationalAssociationId": "1004256" +"CoListAgentNationalAssociationId": "1069104" +"CoListOfficeNationalAssociationId": "1004256" +"Media": array:8 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] ] +"DaysOnMarket": 425 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28196159')" +"ID": "893492" } 4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24494 +post_id: "1344294" +post_author: 1 +"ListingKey": "28193342" +"ListingId": "40719741" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-10T00:00:42Z" +"RFModificationTimestamp": "2026-06-10T00:04:51Z" +"ListPrice": 1275000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 2126.0 +"BuildingAreaTotal": 0 +"City": "Ancaster" +"PostalCode": "L9K1R7" +"UnparsedAddress": "63 BIGGS Avenue, Ancaster, Ontario L9K1R7" +"Coordinates": array:2 [ 0 => -79.94164854 1 => 43.22203711 ] +"Latitude": 43.22203711 +"Longitude": -79.94164854 +"YearBuilt": 2004 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Welcome to this exquisite Ancaster residence, offering over 3,100 sq. ft. of meticulously finished living space, including a custom in-law suite. This 3+1-bedroom, 3.5 bathroom home seamlessly blends luxury with comfort, providing an unparalleled living experience. Main Level: Elegant Design: Features 9 ft ceilings adorned with crown molding, designer lighting, and California shutters. The main floor showcases White Carrara marble tiles, enhancing the home's sophisticated ambiance. Formal Dining Room: Boasts rich hardwood flooring and detailed crown molding, creating an inviting space for memorable gatherings. Gourmet Kitchen: Equipped with granite countertops and backsplash, a central island, crown molding, pot lights, and premium stainless-steel appliances, this kitchen is a culinary enthusiast's dream. Great Room: Offers hardwood floors, custom 9 ft mirrors, pot lights, and a cozy gas fireplace, perfect for relaxation and entertainment. Upper Level: Primary Suite: Features hardwood flooring, a luxurious ensuite bath, and an expansive walk-in closet. Additional Bedrooms: Two spacious bedrooms complemented by a 4-piece main bath. Convenient Laundry: Second-floor laundry room with custom cabinets and sink for added convenience. Lower Level (In-Law Suite): Modern Kitchen: Showcases quartz countertops and a functional island. Family Room: Includes an electric fireplace and egress window, providing a comfortable living area. Private Bedroom: Comes with a 3-piece ensuite featuring a glass-enclosed shower. Saltwater Inground Pool Installed in 2022. Spa Hot Tub added in 2021. The backyard boasts artificial grass installed in 2023. Additional Features: Concrete Aggregate Driveway, Walkways, Patios and Front Yard Sprinkler System. Epoxy Garage floor and shed with electricity. Schedule a viewing and experience the elegance first hand. (id:62650)" +"Appliances": array:14 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Water meter" 3 => "Hot Tub" 4 => "Satellite Dish" 5 => "Sauna" 6 => "Central Vacuum" 7 => "Dishwasher" 8 => "Stove" 9 => "Dryer" 10 => "Hood Fan" 11 => "Window Coverings" 12 => "Garage door opener" 13 => "Microwave Built-in" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:2 [ 0 => "School Bus" 1 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-04-22T04:43:44.345919+00:00" +"Directions": "Golf Links to Clover Leaf to Biggs" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stucco" 2 => "Vinyl siding" ] +"Fencing": array:1 [ 0 => "Fence" ] +"FireplaceFeatures": array:3 [ 0 => "Insert" 1 => "Electric" 2 => "Other - See remarks" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"Heating": array:1 [ 0 => "Forced air" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2022443" +"ListOfficeKey": "54929" +"LivingAreaUnits": "square feet" +"LotFeatures": array:4 [ 0 => "Conservation/green belt" 1 => "Sump Pump" 2 => "Automatic Garage Door Opener" 3 => "In-Law Suite" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-04-22T17:01:50Z" +"PhotosCount": 27 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:54:23Z" +"Stories": "2.0" +"StreetName": "BIGGS" +"StreetNumber": "63" +"StreetSuffix": "Avenue" +"SubdivisionName": "423 - Meadowlands" +"TaxAnnualAmount": "7594.28" +"Utilities": array:4 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Cable" 3 => "Telephone" ] +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:14 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28193342/63-biggs-avenue-ancaster" +"ParkingTotal": 8 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Alarm system" ] +"ZoningDescription": "R4-481" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 48.0 +"AboveGradeFinishedArea": 2126 +"OriginalEntryTimestamp": "2025-04-21T22:06:32.76Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1302199" +"ListOfficeNationalAssociationId": "1003534" +"Media": array:27 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] ] +"DaysOnMarket": 426 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28193342')" +"ID": "1344294" } 5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24607 +post_id: "702769" +post_author: 1 +"ListingKey": "28187235" +"ListingId": "40719399" +"PropertyType": "Commercial Sale" +"PropertySubType": "Office" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:31Z" +"RFModificationTimestamp": "2026-06-02T18:14:14Z" +"ListPrice": 875000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 7293.0 +"BuildingAreaTotal": 0 +"City": "Dunnville" +"PostalCode": "N1A1S6" +"UnparsedAddress": "111 BROAD Street E, Dunnville, Ontario N1A1S6" +"Coordinates": array:2 [ 0 => -79.618328 1 => 42.904143 ] +"Latitude": 42.904143 +"Longitude": -79.618328 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Former municipal building. New flat roof 2025. Main reception area, includes safe, open staircase, terrazzo flooring, brick and field stone feature walls. Upper level has 5 offices, board room, event room, waiting area and storage. Lower level has 5 offices, board room/mixed use space and several storage spaces. 5 washrooms, and parking for 10 cars, wheelchair accessible with automatic doors, and elevator/lift system. Natural gas forced air heat and central air. Zoned Commercial Downtown. Square footage of 7,293 reflects total of upper, main reception and lower floors (id:62650)" +"Basement": array:1 [ 0 => "Full" ] +"BuildingAreaUnits": "square feet" +"CreationDate": "2025-04-20T02:21:15.635661+00:00" +"Directions": "At intersection Cedar St and Broad St" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524894" +"ListOfficeKey": "291472" +"LivingAreaUnits": "square feet" +"LotFeatures": array:3 [ 0 => "Visual exposure" 1 => "Elevator" 2 => "Passenger elevator" ] +"PhotosChangeTimestamp": "2025-04-18T16:36:31Z" +"PhotosCount": 32 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T17:04:35Z" +"Stories": "2.0" +"StreetDirSuffix": "East" +"StreetName": "BROAD" +"StreetNumber": "111" +"StreetSuffix": "Street" +"SubdivisionName": "061 - Dunnville Municipal" +"TaxAnnualAmount": "1" +"Utilities": array:3 [ 0 => "Natural Gas" 1 => "Electricity" 2 => "Telephone" ] +"WaterSource": array:1 [ 0 => "Municipal water" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28187235/111-broad-street-e-dunnville" +"ParkingTotal": 10 +"StructureType": array:1 [ 0 => "Offices" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Unknown" ] +"ZoningDescription": "CD" +"FrontageLengthNumeric": 110.0 +"OriginalEntryTimestamp": "2025-04-18T16:36:31.1Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1064311" +"ListOfficeNationalAssociationId": "1398404" +"Media": array:32 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] ] +"DaysOnMarket": 429 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28187235')" +"ID": "702769" } 6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24609 +post_id: "897688" +post_author: 1 +"ListingKey": "28172147" +"ListingId": "40717428" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:31Z" +"RFModificationTimestamp": "2026-06-02T18:14:14Z" +"ListPrice": 500000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 24.98 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Madoc" +"PostalCode": "K0K2K0" +"UnparsedAddress": "105400 HIGHWAY 7, Madoc, Ontario K0K2K0" +"Coordinates": array:2 [ 0 => -77.51673403 1 => 44.50246609 ] +"Latitude": 44.50246609 +"Longitude": -77.51673403 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "For more information click the brochure button. Prime 24.90 Acre Commercial Land on Busy Highway 7 – Madoc, ON An incredible opportunity awaits with this 24.90-acre parcel of high-visibility, commercial-zoned land located directly on the bustling Highway 7, just minutes from the charming town of Madoc. Offering approximately 800 feet of prime frontage along one of Eastern Ontario’s key transportation corridors, this property enjoys consistent traffic flow and exceptional exposure—making it ideal for a wide array of commercial developments. Whether you're envisioning a service station, retail plaza, storage facility, restaurant, or a future investment project, this expansive and mostly level lot presents endless potential. The land is development-ready with hydro available at the lot line and convenient highway access that ensures ease of logistics and customer reach. Set against a backdrop of scenic landscapes and close to essential amenities, the property offers the perfect blend of rural tranquility and commercial opportunity. Its strategic location—just 2.5 hours from Toronto and 1 hour from Kingston—positions it as a key midpoint for both business and travelers alike. Don’t miss your chance to invest in one of Eastern Ontario’s rapidly growing commercial corridors. With high traffic volume, incredible visibility, and vast potential, this is a rare opportunity to create something truly impactful. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2025-04-16T23:51:20.978837+00:00" +"Directions": "From hwy62 to hwy 7" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "2220194" +"ListOfficeKey": "296937" +"LotFeatures": array:1 [ 0 => "Country residential" ] +"LotSizeDimensions": "24.98" +"PhotosChangeTimestamp": "2025-08-19T23:11:44Z" +"PhotosCount": 20 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T17:04:36Z" +"StreetName": "HIGHWAY 7" +"StreetNumber": "105400" +"SubdivisionName": "Madoc" +"TaxAnnualAmount": "15750" +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28172147/105400-highway-7-madoc" +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "C" +"FrontageLengthNumeric": 818.0 +"OriginalEntryTimestamp": "2025-04-15T21:28:27.09Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1464325" +"ListOfficeNationalAssociationId": "1464303" +"Media": array:20 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] ] +"DaysOnMarket": 432 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28172147')" +"ID": "897688" } 7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25037 +post_id: "610192" +post_author: 1 +"ListingKey": "28174726" +"ListingId": "40717320" +"PropertyType": "Commercial Sale" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:31Z" +"RFModificationTimestamp": "2026-06-02T18:14:14Z" +"ListPrice": 699900.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 3400.0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L8N1C5" +"UnparsedAddress": "433 KING Street E, Hamilton, Ontario L8N1C5" +"Coordinates": array:2 [ 0 => -79.85592369 1 => 43.25316475 ] +"Latitude": 43.25316475 +"Longitude": -79.85592369 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Prime Development Opportunity at 433 King Street East. Attention Investors & Developers – Don't miss out on this rare opportunity to re-develop in one of the city's most sought-after locations. This high-visibility property is ideally situated in a high foot-traffic area and zoned TOC1, allowing for up to 6 storeys of mixed-use residential and commercial development. Drawings submitted for a proposed 20-unit building, offering a strong foundation for future development. With city incentives available and increasing demand in the area, this is an excellent chance to secure a long-term growth asset for your portfolio. Take advantage of this high-potential site in a thriving urban corridor. Whether you're an experienced developer or new investor, the numbers and location speak for themselves.Property Highlights: Zoning: TOC1 – Mixed-use, up to 6 storeys. Proposed plans: 20-unit residential building. High foot traffic and excellent exposure. Strong long-term growth potential. City incentives available for redevelopment. Seller open to VTB- 90% LTV. Note: The Property is being sold as-is, where-is. Please do not walk the property. (id:62650)" +"Basement": array:1 [ 0 => "Full" ] +"BuildingAreaUnits": "square feet" +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"CreationDate": "2025-06-23T05:26:37.380313+00:00" +"Directions": "King East to Victoria Avenue North" +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1992159" +"ListOfficeKey": "284635" +"LivingAreaUnits": "square feet" +"PhotosChangeTimestamp": "2025-04-16T15:07:01Z" +"PhotosCount": 7 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T17:04:37Z" +"Stories": "2.0" +"StreetDirSuffix": "East" +"StreetName": "KING" +"StreetNumber": "433" +"StreetSuffix": "Street" +"SubdivisionName": "141 - Landsdale" +"TaxAnnualAmount": "5486.88" +"WaterSource": array:1 [ 0 => "None" ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28174726/433-king-street-e-hamilton" +"StructureType": array:1 [ 0 => "Retail" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "TOC1" +"FrontageLengthNumeric": 40.0 +"OriginalEntryTimestamp": "2025-04-16T15:07:01.8Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1275598" +"ListOfficeNationalAssociationId": "1344652" +"Media": array:7 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] ] +"DaysOnMarket": 431 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28174726')" +"ID": "610192" } 8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24565 +post_id: "759230" +post_author: 1 +"ListingKey": "28160944" +"ListingId": "40716483" +"PropertyType": "Farm" +"PropertySubType": "Agriculture" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T17:35:31Z" +"RFModificationTimestamp": "2026-06-02T18:14:25Z" +"ListPrice": 0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Hamilton" +"PostalCode": "L9H5E2" +"UnparsedAddress": "277 ROCK CHAPEL Road, Hamilton, Ontario L9H5E2" +"Coordinates": array:2 [ 0 => -79.94226458 1 => 43.28979819 ] +"Latitude": 43.28979819 +"Longitude": -79.94226458 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "Rare opportunity to lease versatile warehouse / agricultural-industrial space in prime Flamborough location near Hwy 5, Hwy 6 and Hwy 403. Approx. 12,000 Sq.Ft. available with 16.5 ft clear height, loading access, ample parking and flexible layout options. Ideal for warehouse, contractor shop, landscaping business, equipment storage, e-commerce fulfillment, indoor farming, mushroom cultivation, hydroponics, microgreens, food processing, cool storage, produce storage, RV/boat storage, sports training, studio space and other permitted uses. Three-phase power and rural setting provide excellent flexibility for a wide range of business operations. Additional outside land may be available. Competitive lease rate for large flexible space in Hamilton area. Rare multi-use opportunity with excellent accessibility to GTA and surrounding markets. Additional Details: 1. The barn’s existing structure allows tenants to modify or customize the interior based on their specific needs, at their own expense. 2. The lease is priced at $5.50 per square foot, per year and any other fees. Tenants will be responsible for all utility costs. 3.. Approximately 6–7 acres of workable land are available for lease at the rear of the barn. If desired, the land can be rented at a negotiable rate. 4. Application Requirements: Completed rental application, credit and financial verification, employment letter and recent pay stubs or proof of income, and references. Only qualified applicants will be considered. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CreationDate": "2025-09-20T15:06:14.376498+00:00" +"Directions": "Highway 5 to Cambridge, left turn at Rock Chapel Rd" +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1961148" +"ListOfficeKey": "283153" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Conservation/green belt" ] +"NumberOfUnitsTotal": "1" +"PhotosChangeTimestamp": "2026-05-10T13:01:11Z" +"PhotosCount": 24 +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T17:04:38Z" +"StreetName": "ROCK CHAPEL" +"StreetNumber": "277" +"StreetSuffix": "Road" +"SubdivisionName": "040 - Greensville" +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28160944/277-rock-chapel-road-hamilton" +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"TotalActualRent": 6 +"ZoningDescription": "Agri" +"BedroomsAboveGrade": 0 +"BedroomsBelowGrade": 0 +"LeaseAmountFrequency": "Monthly" +"OriginalEntryTimestamp": "2025-04-12T21:16:34.68Z" +"ListAgentNationalAssociationId": "1251075" +"ListOfficeNationalAssociationId": "1325050" +"Media": array:24 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] ] +"DaysOnMarket": 435 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28160944')" +"ID": "759230" } 9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24526 +post_id: "766452" +post_author: 1 +"ListingKey": "28286718" +"ListingId": "40715669" +"PropertyType": "Residential" +"PropertySubType": "Vacant Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-02T15:30:49Z" +"RFModificationTimestamp": "2026-06-02T15:45:11Z" +"ListPrice": 3000000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 5.46 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Brantford" +"PostalCode": "N3T5M1" +"UnparsedAddress": "400 GARDEN Avenue, Brantford, Ontario N3T5M1" +"Coordinates": array:2 [ 0 => -80.21603035 1 => 43.17405393 ] +"Latitude": 43.17405393 +"Longitude": -80.21603035 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc" +"PublicRemarks": "Prime industrial land available in Brantford! This is a fantastic opportunity to own 5.4 acres of land, as shown by GeoWarehouse. The land has M2 and M3 zoning, which means it can be used for many different business purposes. You'll love the location – it's very close to Highway 403, so getting around is easy. Plus, Highway 24 is also easy to get to. This site has great visibility, making it perfect for your business. Don't miss out on this rare chance to invest and build in Brantford. (id:62650)" +"Basement": array:1 [ 0 => "None" ] +"CommunityFeatures": array:1 [ 0 => "High Traffic Area" ] +"CreationDate": "2025-09-22T01:12:18.055469+00:00" +"Directions": "403 to Garden Ave." +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1473238" +"ListOfficeKey": "297489" +"LotFeatures": array:1 [ 0 => "Industrial mall/subdivision" ] +"LotSizeDimensions": "5.46" +"PhotosChangeTimestamp": "2026-04-06T15:51:01Z" +"PhotosCount": 3 +"Sewer": array:1 [ 0 => "No sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-02T15:17:50Z" +"StreetName": "GARDEN" +"StreetNumber": "400" +"StreetSuffix": "Avenue" +"SubdivisionName": "2021 - Lynden Park Mall" +"TaxAnnualAmount": "57657" +"Utilities": array:1 [ 0 => "Natural Gas" ] +"WaterSource": array:1 [ 0 => "None" ] +"ListAOR": "Brantford" +"ListAORKey": "41" +"ListingURL": "www.realtor.ca/real-estate/28286718/400-garden-avenue-brantford" +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"ZoningDescription": "M3-10/M2" +"FrontageLengthNumeric": 415.0 +"OriginalEntryTimestamp": "2025-05-09T14:15:33.45Z" +"FrontageLengthNumericUnits": "feet" +"ListAgentNationalAssociationId": "1129200" +"ListOfficeNationalAssociationId": "1466660" +"Media": array:3 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] ] +"DaysOnMarket": 408 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28286718')" +"ID": "766452" } 10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24497 +post_id: "757801" +post_author: 1 +"ListingKey": "28141622" +"ListingId": "40715176" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-22T03:30:02Z" +"RFModificationTimestamp": "2026-06-22T03:34:48Z" +"ListPrice": 549000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 1056.0 +"BuildingAreaTotal": 0 +"City": "St. Catharines" +"PostalCode": "L2M2X4" +"UnparsedAddress": "9 GAVIN Drive, St. Catharines, Ontario L2M2X4" +"Coordinates": array:2 [ 0 => -79.21506109 1 => 43.19999747 ] +"Latitude": 43.19999747 +"Longitude": -79.21506109 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "THIS WELL MAINTAINED 4 (3+1) BEDROOM,FEATURES 2 FULL BATH BUNGALOW IS NESTLED in a picturesque and HIGHLY DESIRABLE TREE-LINED STREET, IN A SOUGHT AFTER NEIGHBORHOOD, THIS HOUSE SITS ON A WIDE LOT WITH EXTRA LONG DRIVE WAY ALLOWING FOR A LOT OF PARKING ROOM. ADDITIONALLY THERE IS A LARGE DETACHED GARAGE AND A BEAUTIFUL SUN-ROOM. This house boast refinished HARDWOOD FLOORS, fully finished basement and large windows. THE ROOF IS NEWLY REPLACED, CENTRALLY LOCATED WITH EASY ACCESS TO MAJOR HIGHWAY, RESTAURANTS, PARKS, SCHOOLS AND SHOPPING CENTRES. (id:62783)" +"Appliances": array:4 [ 0 => "Washer" 1 => "Dishwasher" 2 => "Stove" 3 => "Dryer" ] +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"CommunityFeatures": array:2 [ 0 => "Quiet Area" 1 => "School Bus" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-04-09T19:41:01.427963+00:00" +"Directions": "FROM NIAGARA ST, TURN RIGHT TO LINWELL, RIGHT TO ROCHELLE, LEFT TO RICE, RIGHT TO GAVIN DRIVE." +"ExteriorFeatures": array:1 [ 0 => "Brick" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1524138" +"ListOfficeKey": "275974" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Paved driveway" ] +"ParkingFeatures": array:1 [ 0 => "Detached Garage" ] +"PhotosChangeTimestamp": "2026-06-22T02:50:36Z" +"PhotosCount": 48 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-22T03:13:03Z" +"Stories": "1.0" +"StreetName": "GAVIN" +"StreetNumber": "9" +"StreetSuffix": "Drive" +"SubdivisionName": "441 - Bunting/Linwell" +"TaxAnnualAmount": "4371" +"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vtnb355068" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:10 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28141622/9-gavin-drive-st-catharines" +"ParkingTotal": 4 +"StructureType": array:1 [ 0 => "House" ] +"CommonInterest": "Freehold" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "None" ] +"ZoningDescription": "R1" +"BedroomsAboveGrade": 3 +"BedroomsBelowGrade": 1 +"FrontageLengthNumeric": 62.0 +"AboveGradeFinishedArea": 1056 +"OriginalEntryTimestamp": "2025-04-09T14:36:34.23Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Other" +"ListAgentNationalAssociationId": "1064361" +"ListOfficeNationalAssociationId": "1269678" +"Media": array:48 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] 8 => array:13 [ …13] 9 => array:13 [ …13] 10 => array:13 [ …13] 11 => array:13 [ …13] 12 => array:13 [ …13] 13 => array:13 [ …13] 14 => array:13 [ …13] 15 => array:13 [ …13] 16 => array:13 [ …13] 17 => array:13 [ …13] 18 => array:13 [ …13] 19 => array:13 [ …13] 20 => array:13 [ …13] 21 => array:13 [ …13] 22 => array:13 [ …13] 23 => array:13 [ …13] 24 => array:13 [ …13] 25 => array:13 [ …13] 26 => array:13 [ …13] 27 => array:13 [ …13] 28 => array:13 [ …13] 29 => array:13 [ …13] 30 => array:13 [ …13] 31 => array:13 [ …13] 32 => array:13 [ …13] 33 => array:13 [ …13] 34 => array:13 [ …13] 35 => array:13 [ …13] 36 => array:13 [ …13] 37 => array:13 [ …13] 38 => array:13 [ …13] 39 => array:13 [ …13] 40 => array:13 [ …13] 41 => array:13 [ …13] 42 => array:13 [ …13] 43 => array:13 [ …13] 44 => array:13 [ …13] 45 => array:13 [ …13] 46 => array:13 [ …13] 47 => array:13 [ …13] ] +"DaysOnMarket": 438 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28141622')" +"ID": "757801" } 11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24540 +post_id: "1022925" +post_author: 1 +"ListingKey": "28133864" +"ListingId": "40714630" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-06-10T00:00:42Z" +"RFModificationTimestamp": "2026-06-10T00:04:51Z" +"ListPrice": 1999000.0 +"BathroomsTotalInteger": 6.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 4720.0 +"BuildingAreaTotal": 0 +"City": "Kitchener" +"PostalCode": "N2A2S5" +"UnparsedAddress": "14 NORTH RIDGE Terrace, Kitchener, Ontario N2A2S5" +"Coordinates": array:2 [ 0 => -80.42346147 1 => 43.43425572 ] +"Latitude": 43.43425572 +"Longitude": -80.42346147 +"YearBuilt": 2025 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Cornerstone Association of REALTORS®" +"PublicRemarks": "BRAND NEW MODERN LUXURY HOME backing onto Chicopee Park & Ski Resort! Proudly presented by Hanna Homes, a reputable high-end luxury builder with successful projects across Ontario. Only 14 homes will be built in this upscale subdivision accessed by a new private road ‘North Ridge Terrace’ surrounded by nature and lush forestry for optimal privacy. Lot 14 offers 3654 square feet of luxurious living space above grade. For a limited time, the builder is also including an additional 1066 square foot finished basement for a total of 4720 square feet. This spectacular two-storey walk-up home is elevator-ready and has a triple car (tandem) garage. Built with superior construction, exceptional quality and a pristine attention to detail using the highest level of materials and craftsmanship – designed for the most discerning buyers. The main level will feature impressive principal rooms with a gas fireplace and floor-to-ceiling windows allowing for beautiful natural light. A stunning gourmet kitchen designed for entertaining or culinary experts will be the perfect accompaniment. The upper level will feature 4 spacious bedrooms each with their own ensuite bathroom including an exquisite primary suite with a private glass balcony to enjoy breathtaking views of Chicopee Park. The Chicopee Heights neighbourhood is conveniently located with easy access to schools, shopping, restaurants, and highways (7, 8, 85 and 401). For outdoor enthusiasts, there is direct access to walking trails literally in your backyard as well as the Chicopee Ski and Tube Park. The private road will offer snow removal, private garage removal and common elements with a $185 per month road fee. This incredible Kitchener location is only an hour from Toronto. A full information package is available including approved home designs and drawings. (id:62650)" +"Appliances": array:10 [ 0 => "Washer" 1 => "Refrigerator" 2 => "Central Vacuum" 3 => "Gas stove(s)" 4 => "Dishwasher" 5 => "Wine Fridge" 6 => "Dryer" 7 => "Hood Fan" 8 => "Garage door opener" 9 => "Microwave Built-in" ] +"AssociationFee": "185" +"AssociationFeeFrequency": "Monthly" +"Basement": array:2 [ 0 => "Finished" 1 => "Full" ] +"BathroomsPartial": 1 +"CommunityFeatures": array:3 [ 0 => "Quiet Area" 1 => "School Bus" 2 => "Community Centre" ] +"Cooling": array:1 [ 0 => "Central air conditioning" ] +"CreationDate": "2025-04-10T14:29:53.459982+00:00" +"Directions": "Take Volta Av to Chicopee Terrace to North Ridge Terrace" +"ExteriorFeatures": array:3 [ 0 => "Brick" 1 => "Stone" 2 => "Stucco" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"FoundationDetails": array:1 [ 0 => "Poured Concrete" ] +"Heating": array:2 [ 0 => "Forced air" 1 => "Natural gas" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1944031" +"ListOfficeKey": "288925" +"LivingAreaUnits": "square feet" +"LotFeatures": array:7 [ 0 => "Cul-de-sac" 1 => "Ravine" 2 => "Conservation/green belt" 3 => "Balcony" 4 => "Paved driveway" 5 => "Sump Pump" 6 => "Automatic Garage Door Opener" ] +"ParkingFeatures": array:1 [ 0 => "Attached Garage" ] +"PhotosChangeTimestamp": "2026-03-02T16:22:38Z" +"PhotosCount": 8 +"Sewer": array:1 [ 0 => "Municipal sewage system" ] +"StateOrProvince": "Ontario" +"StatusChangeTimestamp": "2026-06-09T23:54:23Z" +"Stories": "2.0" +"StreetName": "NORTH RIDGE" +"StreetNumber": "14" +"StreetSuffix": "Terrace" +"SubdivisionName": "228 - Chicopee/Freeport" +"VirtualTourURLUnbranded": "https://vimeo.com/1073377978" +"WaterSource": array:1 [ 0 => "Municipal water" ] +"Rooms": array:19 [ 0 => array:11 [ …11] 1 => array:11 [ …11] 2 => array:11 [ …11] 3 => array:11 [ …11] 4 => array:11 [ …11] 5 => array:11 [ …11] 6 => array:11 [ …11] 7 => array:11 [ …11] 8 => array:11 [ …11] 9 => array:11 [ …11] 10 => array:11 [ …11] 11 => array:11 [ …11] 12 => array:11 [ …11] 13 => array:11 [ …11] 14 => array:11 [ …11] 15 => array:11 [ …11] 16 => array:11 [ …11] 17 => array:11 [ …11] 18 => array:11 [ …11] ] +"ListAOR": "Cornerstone" +"ListAORKey": "14" +"ListingURL": "www.realtor.ca/real-estate/28133864/14-north-ridge-terrace-kitchener" +"ParkingTotal": 7 +"StructureType": array:1 [ 0 => "House" ] +"CoListAgentKey": "1944032" +"CommonInterest": "Freehold" +"CoListOfficeKey": "288925" +"GeocodeManualYN": true +"SecurityFeatures": array:1 [ 0 => "Smoke Detectors" ] +"ZoningDescription": "R3" +"BedroomsAboveGrade": 4 +"BedroomsBelowGrade": 0 +"FrontageLengthNumeric": 68.0 +"AboveGradeFinishedArea": 3654 +"BelowGradeFinishedArea": 1066 +"OriginalEntryTimestamp": "2025-04-08T01:16:30.91Z" +"FrontageLengthNumericUnits": "feet" +"AboveGradeFinishedAreaUnits": "square feet" +"BelowGradeFinishedAreaUnits": "square feet" +"AboveGradeFinishedAreaSource": "Builder" +"BelowGradeFinishedAreaSource": "Builder" +"ListAgentNationalAssociationId": "1239946" +"ListOfficeNationalAssociationId": "1372539" +"CoListAgentNationalAssociationId": "1239947" +"CoListOfficeNationalAssociationId": "1372539" +"Media": array:8 [ 0 => array:13 [ …13] 1 => array:13 [ …13] 2 => array:13 [ …13] 3 => array:13 [ …13] 4 => array:13 [ …13] 5 => array:13 [ …13] 6 => array:13 [ …13] 7 => array:13 [ …13] ] +"DaysOnMarket": 440 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('28133864')" +"ID": "1022925" } ] +success: true +page_size: 12 +page_count: 17186 +count: 206221 +after_key: "" } "RF Response Time" => "0.35 seconds" ] ]