Listings - ComFree Realty

Back to Map

$899,900

Ontario,Waterford

For Sale Active

100 MECHANIC Street W, Waterford, Ontario N0E1Y0

3
3
1,648 Sqft

Contact Seller

Feature Sheet

Basic Details

Description

DIRECTLY ON WATERFORD PONDS – 71FT OF WATER FRONTAGE! This is a beautiful unique property that is truly one of a kind. Offering 3 bedrooms, 3 bathrooms and over 2000 sq ft of finished living space. The main level features a spacious formal dining room, large primary bedroom (with walk in closet and ensuite bathroom), laundry & mudroom (with access

to the two car tandem garage). Moving up a level you will find an open-concept living room, dining area & kitchen and bathroom – with lots of natural light, waterfront views, fireplace, and stainless steel appliances. The lower level offers an additional living area, 2 bedrooms and utility room/storage space. Fronting on 71ft of the Waterford Ponds, this stunning property is also on an extra deep lot (357ft) – all that’s left to do is move in! (id:62650)

Basic Details

Property Type: Residential
Listing Type: For Sale
Listing ID: 40834524
Price: $899,900
Bedrooms: 3
Bathrooms: 3
Half Bathrooms: 1
View: Direct Water View
Square Footage: 1,648 Sqft
Status: Active
Property Sub Type: Single Family
Office Key: 92544

Features & Appliances

Features

Heating System: Forced air, Natural gas
Cooling System: Central air conditioning
Basement: Finished, Full
Parking: Attached Garage
Exterior Features: Vinyl siding
Sewer: Municipal sewage system
Waterfront Features: Waterfront

Address Map

Location: CA, Ontario, Waterford, Waterford, N0E1Y0
Street: MECHANIC
Street Number: 100
Street Suffix: Street
Longitude: W81° 42' 11.9''
Latitude: N42° 56' 8.6''
Street Dir Suffix: West

Additional Information

Water Body Name: Waterford Ponds
Water Source:
Community Features:
Foundation Details:

Financial

Tax Annual Amount: 5200

Listing updated: 2026-06-22 13:02:11

Schedule a Tour

List Your Property

Mortgage Calculator

Get Pre-Approved

Home Price $

Down Payment

Interest Rate %

Mortgage Term years

Monthly Payment (Est.) $

MLS On The Fly Debug Panel

 Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
  +post_id: "1553298"
  +post_author: 1
  +"ListingKey": "29935119"
  +"ListingId": "40841738"
  +"PropertyType": "Residential"
  +"PropertySubType": "Single Family"
  +"StandardStatus": "Active"
  +"ModificationTimestamp": "2026-06-22T15:20:10Z"
  +"RFModificationTimestamp": "2026-06-22T15:29:25Z"
  +"ListPrice": 989500.0
  +"BathroomsTotalInteger": 2.0
  +"BathroomsHalf": 0
  +"BedroomsTotal": 3.0
  +"LotSizeArea": 0
  +"LivingArea": 1971.0
  +"BuildingAreaTotal": 0
  +"City": "Waterford"
  +"PostalCode": "N0E1Y0"
  +"UnparsedAddress": "163 GIBBONS Street, Waterford, Ontario N0E1Y0"
  +"Coordinates": array:2 [
    0 => -80.2974462
    1 => 42.9425213
  ]
  +"Latitude": 42.9425213
  +"Longitude": -80.2974462
  +"YearBuilt": 0
  +"InternetAddressDisplayYN": true
  +"FeedTypes": "IDX"
  +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
  +"PublicRemarks": "To Be Built - This 3-bedroom, 2-bath brick and stone bungalow with main-floor laundry is a true showstopper on one of the last remaining premium lots in the Villages of Waterford. The open-concept floorplan features a gourmet kitchen with custom cabinetry, a large island, quartz counters, and backsplash. The dining and living rooms showcase 9' ceilings complemented by your choice of hardwood or luxury vinyl flooring throughout. The primary bedroom has a tray ceiling and offers a walk-in closet and a spacious ensuite with a standalone tub and tiled shower with glass doors. Enjoy entertaining on the back covered composite deck or relaxing on the front porch. Fully sodded, with a Tarion warranty. Optional appliance package available. (id:62650)"
  +"Appliances": array:3 [
    0 => "Hood Fan"
    1 => "Garage door opener"
    2 => "Microwave Built-in"
  ]
  +"Basement": array:2 [
    0 => "Unfinished"
    1 => "Full"
  ]
  +"Cooling": array:1 [
    0 => "Central air conditioning"
  ]
  +"CreationDate": "2026-06-22T14:41:07.061451+00:00"
  +"ExteriorFeatures": array:2 [
    0 => "Brick"
    1 => "Stone"
  ]
  +"FoundationDetails": array:1 [
    0 => "Poured Concrete"
  ]
  +"Heating": array:2 [
    0 => "Forced air"
    1 => "Natural gas"
  ]
  +"InternetEntireListingDisplayYN": true
  +"ListAgentKey": "2211588"
  +"ListOfficeKey": "48560"
  +"LivingAreaUnits": "square feet"
  +"LotFeatures": array:2 [
    0 => "Crushed stone driveway"
    1 => "Automatic Garage Door Opener"
  ]
  +"ParkingFeatures": array:1 [
    0 => "Attached Garage"
  ]
  +"PhotosChangeTimestamp": "2026-06-22T12:30:51Z"
  +"PhotosCount": 1
  +"Sewer": array:1 [
    0 => "Municipal sewage system"
  ]
  +"StateOrProvince": "Ontario"
  +"StatusChangeTimestamp": "2026-06-22T15:11:27Z"
  +"Stories": "1.0"
  +"StreetName": "GIBBONS"
  +"StreetNumber": "163"
  +"StreetSuffix": "Street"
  +"SubdivisionName": "Waterford"
  +"Utilities": array:2 [
    0 => "Natural Gas"
    1 => "Electricity"
  ]
  +"WaterSource": array:1 [
    0 => "Municipal water"
  ]
  +"Rooms": array:11 [
    0 => array:11 [
      "RoomKey" => "1665395072"
      "RoomType" => "Bedroom"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => "10'0'' x 12'2''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
    ]
    1 => array:11 [
      "RoomKey" => "1665395073"
      "RoomType" => "Bedroom"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => "10'4'' x 12'2''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
    ]
    2 => array:11 [
      "RoomKey" => "1665395074"
      "RoomType" => "Full bathroom"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
    ]
    3 => array:11 [
      "RoomKey" => "1665395075"
      "RoomType" => "Primary Bedroom"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => "13'8'' x 16'2''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
    ]
    4 => array:11 [
      "RoomKey" => "1665395076"
      "RoomType" => "4pc Bathroom"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => null
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
    ]
    5 => array:11 [
      "RoomKey" => "1665395077"
      "RoomType" => "Mud room"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => "5'0'' x 10'0''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
    ]
    6 => array:11 [
      "RoomKey" => "1665395078"
      "RoomType" => "Laundry room"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => "6'0'' x 10'8''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.72Z"
    ]
    7 => array:11 [
      "RoomKey" => "1665395079"
      "RoomType" => "Foyer"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => "8'10'' x 10'0''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.72Z"
    ]
    8 => array:11 [
      "RoomKey" => "1665395080"
      "RoomType" => "Living room"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => "16'8'' x 17'6''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.73Z"
    ]
    9 => array:11 [
      "RoomKey" => "1665395081"
      "RoomType" => "Dining room"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => "11'2'' x 12'0''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.73Z"
    ]
    10 => array:11 [
      "RoomKey" => "1665395082"
      "RoomType" => "Kitchen"
      "ListingId" => "40841738"
      "RoomLevel" => "Main level"
      "RoomWidth" => null
      "ListingKey" => "29935119"
      "RoomLength" => null
      "RoomDimensions" => "10'3'' x 15'2''"
      "RoomDescription" => null
      "RoomLengthWidthUnits" => null
      "ModificationTimestamp" => "2026-06-22T15:11:27.74Z"
    ]
  ]
  +"ListAOR": "Cornerstone"
  +"ListAORKey": "14"
  +"ListingURL": "www.realtor.ca/real-estate/29935119/163-gibbons-street-waterford"
  +"ParkingTotal": 4
  +"StructureType": array:1 [
    0 => "House"
  ]
  +"CommonInterest": "Freehold"
  +"GeocodeManualYN": true
  +"ZoningDescription": "R1-B"
  +"BedroomsAboveGrade": 3
  +"BedroomsBelowGrade": 0
  +"FrontageLengthNumeric": 40.0
  +"AboveGradeFinishedArea": 1971
  +"OriginalEntryTimestamp": "2026-06-22T12:30:50.96Z"
  +"FrontageLengthNumericUnits": "feet"
  +"AboveGradeFinishedAreaUnits": "square feet"
  +"AboveGradeFinishedAreaSource": "Builder"
  +"ListAgentNationalAssociationId": "1457486"
  +"ListOfficeNationalAssociationId": "1218974"
  +"Media": array:1 [
    0 => array:13 [
      "Order" => 1
      "MediaKey" => "29935119_4890_1"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935119/e8f26452fa043998de5669b584ed4430.webp"
      "MediaSize" => 57682
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935119/thumbnail-e8f26452fa043998de5669b584ed4430.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Property Photo"
      "LongDescription" => null
      "PreferredPhotoYN" => true
      "ResourceRecordId" => "40841738"
      "ResourceRecordKey" => "29935119"
      "ModificationTimestamp" => "2026-06-22T12:30:50.96Z"
    ]
  ]
  +"DaysOnMarket": 0
  +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935119')"
  +"ID": "1553298"
}

MLS On The Fly Debug Panel

 array:6 [
  "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29831302 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23410
      +items: array:1 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23412
          +post_id: "1482663"
          +post_author: 1
          +"ListingKey": "29831302"
          +"ListingId": "40834524"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-14T20:30:01Z"
          +"RFModificationTimestamp": "2026-06-14T20:33:08Z"
          +"ListPrice": 899900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 1648.0
          +"BuildingAreaTotal": 0
          +"City": "Waterford"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "100 MECHANIC Street W, Waterford, Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.2966815
            1 => 42.9357105
          ]
          +"Latitude": 42.9357105
          +"Longitude": -80.2966815
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
          +"PublicRemarks": "DIRECTLY ON WATERFORD PONDS - 71FT OF WATER FRONTAGE! This is a beautiful unique property that is truly one of a kind. Offering 3 bedrooms, 3 bathrooms and over 2000 sq ft of finished living space. The main level features a spacious formal dining room, large primary bedroom (with walk in closet and ensuite bathroom), laundry & mudroom (with access to the two car tandem garage). Moving up a level you will find an open-concept living room, dining area & kitchen and bathroom - with lots of natural light, waterfront views, fireplace, and stainless steel appliances. The lower level offers an additional living area, 2 bedrooms and utility room/storage space. Fronting on 71ft of the Waterford Ponds, this stunning property is also on an extra deep lot (357ft) - all that’s left to do is move in! (id:62650)"
          +"Appliances": array:1 [
            0 => "Water meter"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:1 [
            0 => "Quiet Area"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-01T18:37:37.307856+00:00"
          +"Directions": "old hwy 24 to mechanic st"
          +"ExteriorFeatures": array:1 [
            0 => "Vinyl siding"
          ]
          +"FoundationDetails": array:1 [
            0 => "Block"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1982983"
          +"ListOfficeKey": "92544"
          +"LivingAreaUnits": "square feet"
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-01T11:34:03Z"
          +"PhotosCount": 38
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-14T20:24:56Z"
          +"StreetDirSuffix": "West"
          +"StreetName": "MECHANIC"
          +"StreetNumber": "100"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "Waterford"
          +"TaxAnnualAmount": "5200"
          +"View": "Direct Water View"
          +"WaterBodyName": "Waterford Ponds"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:14 [
            0 => array:11 [
              "RoomKey" => "1659427444"
              "RoomType" => "2pc Bathroom"
              "ListingId" => "40834524"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.44Z"
            ]
            1 => array:11 [
              "RoomKey" => "1659427445"
              "RoomType" => "Utility room"
              "ListingId" => "40834524"
              "RoomLevel" => "Lower level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "11'5'' x 21'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.45Z"
            ]
            2 => array:11 [
              "RoomKey" => "1659427446"
              "RoomType" => "Bedroom"
              "ListingId" => "40834524"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "10'2'' x 10'11''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.46Z"
            ]
            3 => array:11 [
              "RoomKey" => "1659427447"
              "RoomType" => "Bedroom"
              "ListingId" => "40834524"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "10'2'' x 10'9''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.46Z"
            ]
            4 => array:11 [
              "RoomKey" => "1659427448"
              "RoomType" => "Recreation room"
              "ListingId" => "40834524"
              "RoomLevel" => "Basement"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "17'8'' x 18'8''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.46Z"
            ]
            5 => array:11 [
              "RoomKey" => "1659427449"
              "RoomType" => "3pc Bathroom"
              "ListingId" => "40834524"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.47Z"
            ]
            6 => array:11 [
              "RoomKey" => "1659427450"
              "RoomType" => "Living room/Dining room"
              "ListingId" => "40834524"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "13'0'' x 30'3''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.47Z"
            ]
            7 => array:11 [
              "RoomKey" => "1659427451"
              "RoomType" => "Kitchen"
              "ListingId" => "40834524"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "10'3'' x 15'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.48Z"
            ]
            8 => array:11 [
              "RoomKey" => "1659427452"
              "RoomType" => "Full bathroom"
              "ListingId" => "40834524"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.48Z"
            ]
            9 => array:11 [
              "RoomKey" => "1659427453"
              "RoomType" => "Other"
              "ListingId" => "40834524"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "5'2'' x 12'2''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.49Z"
            ]
            10 => array:11 [
              "RoomKey" => "1659427454"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "40834524"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "12'1'' x 16'1''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.5Z"
            ]
            11 => array:11 [
              "RoomKey" => "1659427455"
              "RoomType" => "Dining room"
              "ListingId" => "40834524"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "9'5'' x 16'2''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.5Z"
            ]
            12 => array:11 [
              "RoomKey" => "1659427456"
              "RoomType" => "Laundry room"
              "ListingId" => "40834524"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "11'5'' x 12'6''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.51Z"
            ]
            13 => array:11 [
              "RoomKey" => "1659427457"
              "RoomType" => "Foyer"
              "ListingId" => "40834524"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29831302"
              "RoomLength" => null
              "RoomDimensions" => "5'10'' x 17'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-14T20:24:56.51Z"
            ]
          ]
          +"ListAOR": "Brantford"
          +"ListAORKey": "41"
          +"ListingURL": "www.realtor.ca/real-estate/29831302/100-mechanic-street-w-waterford"
          +"ParkingTotal": 6
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R1,HL"
          +"BedroomsAboveGrade": 1
          +"BedroomsBelowGrade": 2
          +"WaterfrontFeatures": array:1 [
            0 => "Waterfront"
          ]
          +"FrontageLengthNumeric": 56.0
          +"AboveGradeFinishedArea": 1648
          +"OriginalEntryTimestamp": "2026-06-01T11:34:03.13Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Owner"
          +"ListAgentNationalAssociationId": "1267987"
          +"ListOfficeNationalAssociationId": "1183612"
          +"Media": array:38 [
            0 => array:13 [
              "Order" => 1
              "MediaKey" => "29831302_4890_1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/dd121fbfa3a0678f3d34d9935be428e8.webp"
              "MediaSize" => 166131
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-dd121fbfa3a0678f3d34d9935be428e8.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Aerial perspective showcasing a residential property with a waterfront setting"
              "PreferredPhotoYN" => true
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            1 => array:13 [
              "Order" => 2
              "MediaKey" => "29831302_4890_2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/24e83d2d9db36a19b6ead03c5d3385d4.webp"
              "MediaSize" => 175211
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-24e83d2d9db36a19b6ead03c5d3385d4.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Single-story residence featuring a front lawn and paved driveway"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            2 => array:13 [
              "Order" => 3
              "MediaKey" => "29831302_4890_3"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/278647c22c3dc595b201ed4a1939550f.webp"
              "MediaSize" => 175586
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-278647c22c3dc595b201ed4a1939550f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive property featuring a spacious driveway, mature trees, and a substantial green lawn"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            3 => array:13 [
              "Order" => 4
              "MediaKey" => "29831302_4890_4"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/074e7877402ba06a3bf3cac43741a271.webp"
              "MediaSize" => 168703
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-074e7877402ba06a3bf3cac43741a271.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Lakeside property featuring a spacious lot with mature trees, expansive green lawn, and proximity to water"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            4 => array:13 [
              "Order" => 5
              "MediaKey" => "29831302_4890_5"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/e6621da046c691d803eedb5196441073.webp"
              "MediaSize" => 114687
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-e6621da046c691d803eedb5196441073.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Single-story residence featuring light brown vertical siding and a dark shingle roof"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            5 => array:13 [
              "Order" => 6
              "MediaKey" => "29831302_4890_6"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/020bcd8f5ba202a9339c071f1e20260e.webp"
              "MediaSize" => 99895
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-020bcd8f5ba202a9339c071f1e20260e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Ranch-style exterior featuring a single-car garage, bay window, and a spacious paved driveway"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            6 => array:13 [
              "Order" => 7
              "MediaKey" => "29831302_4890_7"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/14a5afbf0dc9baeb915b61c9b3e01b20.webp"
              "MediaSize" => 79383
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-14a5afbf0dc9baeb915b61c9b3e01b20.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            7 => array:13 [
              "Order" => 8
              "MediaKey" => "29831302_4890_8"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/48f885734ee9eb398dac4db86323b17a.webp"
              "MediaSize" => 79106
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-48f885734ee9eb398dac4db86323b17a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Hardwood-finish flooring throughout, featuring a ceiling fan with integrated lighting"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            8 => array:13 [
              "Order" => 9
              "MediaKey" => "29831302_4890_9"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/b4d9f84a32d6e6f89d1293cf9267addd.webp"
              "MediaSize" => 54476
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-b4d9f84a32d6e6f89d1293cf9267addd.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bathroom featuring a white vanity with integrated sink, chrome faucet, and rectangular mirror"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            9 => array:13 [
              "Order" => 10
              "MediaKey" => "29831302_4890_10"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/25c02fa7b21f89d3ccdc1bdd654c945f.webp"
              "MediaSize" => 99564
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-25c02fa7b21f89d3ccdc1bdd654c945f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Carpeted bedroom featuring a corner fireplace, ceiling fan with integrated lighting, and a window with drapes"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            10 => array:13 [
              "Order" => 11
              "MediaKey" => "29831302_4890_11"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/c53f1dc9e6af748026a2fe0d574b0164.webp"
              "MediaSize" => 98512
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-c53f1dc9e6af748026a2fe0d574b0164.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Kitchen and dining area featuring dark wood cabinetry, stainless steel appliances, and an island with bar seating"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            11 => array:13 [
              "Order" => 12
              "MediaKey" => "29831302_4890_12"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/1182b72d7338fc3f83d15163f66e6644.webp"
              "MediaSize" => 112200
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-1182b72d7338fc3f83d15163f66e6644.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            12 => array:13 [
              "Order" => 13
              "MediaKey" => "29831302_4890_13"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/9be843f5f468e05c84eb8003371311cf.webp"
              "MediaSize" => 106563
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-9be843f5f468e05c84eb8003371311cf.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Open-concept living space featuring wood-finish flooring, a kitchen with dark cabinetry and stainless steel appliances, a central island with seating, recessed lighting, and a dining area with a chand"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            13 => array:13 [
              "Order" => 14
              "MediaKey" => "29831302_4890_14"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/da2b1efc986b043cececfa08ed02cb0d.webp"
              "MediaSize" => 96116
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-da2b1efc986b043cececfa08ed02cb0d.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Kitchen featuring dark wood cabinetry, stainless steel appliances, a double basin sink, recessed lighting, and tile flooring"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            14 => array:13 [
              "Order" => 15
              "MediaKey" => "29831302_4890_15"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/d01529259224903324581cc2e9c6c891.webp"
              "MediaSize" => 104149
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-d01529259224903324581cc2e9c6c891.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Open-concept living area featuring wood-finish flooring, a contemporary fireplace with a white mantel, and recessed ceiling lighting"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            15 => array:13 [
              "Order" => 16
              "MediaKey" => "29831302_4890_16"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/e731d5270587657ed94355b35fb73fd1.webp"
              "MediaSize" => 101626
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-e731d5270587657ed94355b35fb73fd1.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Open-concept living area featuring wood-finish flooring, a dining space with chandelier lighting, a kitchen with dark cabinetry and stainless steel appliances, and a tiled entryway"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            16 => array:13 [
              "Order" => 17
              "MediaKey" => "29831302_4890_17"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/61c29e0485641a5671dd24d243c2b33f.webp"
              "MediaSize" => 81919
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-61c29e0485641a5671dd24d243c2b33f.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bathroom featuring a shower/tub combination, floor-set toilet, and a vanity with a dark countertop and under-sink storage"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            17 => array:13 [
              "Order" => 18
              "MediaKey" => "29831302_4890_18"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/c5d18141886bab0d5c8b0ce6c27e3a3a.webp"
              "MediaSize" => 74978
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-c5d18141886bab0d5c8b0ce6c27e3a3a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Utility area featuring built-in shelving, recessed lighting, and neutral-toned wall paint"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            18 => array:13 [
              "Order" => 19
              "MediaKey" => "29831302_4890_19"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/77ff2bef0224f26ae27bd787aacab5aa.webp"
              "MediaSize" => 95481
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-77ff2bef0224f26ae27bd787aacab5aa.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Spacious recreational room featuring wood-finish flooring and a partial wall with display ledge"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            19 => array:13 [
              "Order" => 20
              "MediaKey" => "29831302_4890_20"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/6798fd49651dbbffeda788fa7397318b.webp"
              "MediaSize" => 86972
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-6798fd49651dbbffeda788fa7397318b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Finished lower level featuring wood-finish flooring, recessed lighting, a built-in media console, a staircase with dark treads, and a white interior door"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            20 => array:13 [
              "Order" => 21
              "MediaKey" => "29831302_4890_21"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/2e811e7c7e428b8c9e0632e89bbdbc90.webp"
              "MediaSize" => 69626
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-2e811e7c7e428b8c9e0632e89bbdbc90.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Compact room with dark wood-finish flooring, light tan walls, and white trim"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            21 => array:13 [
              "Order" => 22
              "MediaKey" => "29831302_4890_22"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/76ea2f7810135f9b9be2a0a9f0f8e7ee.webp"
              "MediaSize" => 90102
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-76ea2f7810135f9b9be2a0a9f0f8e7ee.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            22 => array:13 [
              "Order" => 23
              "MediaKey" => "29831302_4890_23"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/9abb6551fbc3a50c26338fc37f4745ca.webp"
              "MediaSize" => 47338
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-9abb6551fbc3a50c26338fc37f4745ca.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Bathroom featuring light green walls, white crown molding, a white toilet, a white porcelain sink, and a gray vanity cabinet"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            23 => array:13 [
              "Order" => 24
              "MediaKey" => "29831302_4890_24"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/247acd0dfc367fc8abccfa53c9dc0151.webp"
              "MediaSize" => 167279
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-247acd0dfc367fc8abccfa53c9dc0151.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            24 => array:13 [
              "Order" => 25
              "MediaKey" => "29831302_4890_25"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/280b804f56df23263abc55ce4431daf7.webp"
              "MediaSize" => 203508
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-280b804f56df23263abc55ce4431daf7.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive grassy lawn extending towards a body of water, bordered by mature trees and lush foliage"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            25 => array:13 [
              "Order" => 26
              "MediaKey" => "29831302_4890_26"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/8bcb3529b9664c9ed3777e943cb68c48.webp"
              "MediaSize" => 162415
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-8bcb3529b9664c9ed3777e943cb68c48.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive backyard with a large grass area, wood privacy fencing, and mature perimeter trees"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            26 => array:13 [
              "Order" => 27
              "MediaKey" => "29831302_4890_27"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/f6261eafc9850907b9321c87a6b61f4a.webp"
              "MediaSize" => 214005
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-f6261eafc9850907b9321c87a6b61f4a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive green lawn with mature trees and a tranquil body of water in the background"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            27 => array:13 [
              "Order" => 28
              "MediaKey" => "29831302_4890_28"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/469143815cd81484b489a90cd8671648.webp"
              "MediaSize" => 220858
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-469143815cd81484b489a90cd8671648.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive green lawn extending to a body of water, bordered by mature trees and evergreen shrubs"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            28 => array:13 [
              "Order" => 29
              "MediaKey" => "29831302_4890_29"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/f56b5df017f1ffbcab47a6d1b94aaec6.webp"
              "MediaSize" => 212384
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-f56b5df017f1ffbcab47a6d1b94aaec6.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive waterfront lawn with mature trees and a stone-lined fire pit"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            29 => array:13 [
              "Order" => 30
              "MediaKey" => "29831302_4890_30"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/9f29b7b7df7afa5398d3a2d7b6205dac.webp"
              "MediaSize" => 207730
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-9f29b7b7df7afa5398d3a2d7b6205dac.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive lakeside property featuring a large grassy lawn, mature shade trees, and a wooden privacy fence"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            30 => array:13 [
              "Order" => 31
              "MediaKey" => "29831302_4890_31"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/1c7404c1dcbad136a22dede725049cf0.webp"
              "MediaSize" => 230568
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-1c7404c1dcbad136a22dede725049cf0.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive waterfront backyard featuring mature trees, a manicured lawn, a block-built fire pit, and a wooden fence"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            31 => array:13 [
              "Order" => 32
              "MediaKey" => "29831302_4890_32"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/e5afbc650077035fe5d6bd633b66ffd6.webp"
              "MediaSize" => 206117
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-e5afbc650077035fe5d6bd633b66ffd6.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive waterfront property featuring a manicured lawn, established perimeter fencing, and mature trees"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            32 => array:13 [
              "Order" => 33
              "MediaKey" => "29831302_4890_33"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/05aa8ff6e7d15390f2e7d717e42dcd32.webp"
              "MediaSize" => 208310
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-05aa8ff6e7d15390f2e7d717e42dcd32.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive green lawn with mature trees providing dappled shade"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            33 => array:13 [
              "Order" => 34
              "MediaKey" => "29831302_4890_34"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/5d4d425cac7406bb254ae70f45b51c47.webp"
              "MediaSize" => 203021
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-5d4d425cac7406bb254ae70f45b51c47.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Expansive green lawn with mature trees and a partial water feature visible in the background"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            34 => array:13 [
              "Order" => 35
              "MediaKey" => "29831302_4890_35"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/3ed80d6994525ab14448cc29bc9ff15b.webp"
              "MediaSize" => 191239
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-3ed80d6994525ab14448cc29bc9ff15b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Aerial perspective showcasing a residential area with varied housing styles"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            35 => array:13 [
              "Order" => 36
              "MediaKey" => "29831302_4890_36"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/b9681655f06508df1307a2b29f49ca29.webp"
              "MediaSize" => 206426
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-b9681655f06508df1307a2b29f49ca29.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Image quality insufficient for description"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            36 => array:13 [
              "Order" => 37
              "MediaKey" => "29831302_4890_37"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/522d0167e12dd33995d771cc127087e5.webp"
              "MediaSize" => 190213
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-522d0167e12dd33995d771cc127087e5.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Aerial perspective highlighting a waterfront property with a tree-lined perimeter and lush green lawns"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
            37 => array:13 [
              "Order" => 38
              "MediaKey" => "29831302_4890_38"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29831302/04fb2033a7f5a369d1782db143126441.webp"
              "MediaSize" => 196873
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29831302/thumbnail-04fb2033a7f5a369d1782db143126441.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => "Waterfront properties along a winding river, bordered by established residential areas and abundant green spaces"
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40834524"
              "ResourceRecordKey" => "29831302"
              "ModificationTimestamp" => "2026-06-01T11:34:03.18Z"
            ]
          ]
          +"DaysOnMarket": 21
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29831302')"
          +"ID": "1482663"
        }
      ]
      +success: true
      +page_size: 1
      +page_count: 1
      +count: 1
      +after_key: ""
    }
    "RF Response Time" => "0.12 seconds"
  ]
  "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 92544" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24828
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.11 seconds"
  ]
  "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1982983" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24832
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.1 seconds"
  ]
  "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29831302'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25233
      +items: []
      +success: true
      +page_size: 0
      +page_count: 0
      +count: 0
      +after_key: ""
    }
    "RF Response Time" => "0.1 seconds"
  ]
  "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29831302'" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25252
      +items: array:3 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25249
          +post_id: ? mixed
          +post_author: ? mixed
          +"OpenHouseKey": "31387599"
          +"ListingKey": "29831302"
          +"ListingId": "40834524"
          +"OpenHouseStatus": "Active"
          +"OpenHouseType": "Open House"
          +"OpenHouseDate": "2026-06-14"
          +"OpenHouseStartTime": "2026-06-14T14:00:00Z"
          +"OpenHouseEndTime": "2026-06-14T16:00:00Z"
          +"OpenHouseRemarks": null
          +"OriginatingSystemName": "CREA"
          +"ModificationTimestamp": "2026-06-13T16:36:30Z"
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31387599')"
        }
        1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25251
          +post_id: ? mixed
          +post_author: ? mixed
          +"OpenHouseKey": "31387600"
          +"ListingKey": "29831302"
          +"ListingId": "40834524"
          +"OpenHouseStatus": "Active"
          +"OpenHouseType": "Open House"
          +"OpenHouseDate": "2026-06-13"
          +"OpenHouseStartTime": "2026-06-13T14:00:00Z"
          +"OpenHouseEndTime": "2026-06-13T16:00:00Z"
          +"OpenHouseRemarks": null
          +"OriginatingSystemName": "CREA"
          +"ModificationTimestamp": "2026-06-13T16:36:30Z"
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31387600')"
        }
        2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
          +post_id: ? mixed
          +post_author: ? mixed
          +"OpenHouseKey": "31469564"
          +"ListingKey": "29831302"
          +"ListingId": "40834524"
          +"OpenHouseStatus": "Active"
          +"OpenHouseType": "Open House"
          +"OpenHouseDate": "2026-06-14"
          +"OpenHouseStartTime": "2026-06-14T14:00:00Z"
          +"OpenHouseEndTime": "2026-06-14T16:00:00Z"
          +"OpenHouseRemarks": null
          +"OriginatingSystemName": "CREA"
          +"ModificationTimestamp": "2026-06-14T20:01:27Z"
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31469564')"
        }
      ]
      +success: true
      +page_size: 3
      +page_count: 1
      +count: 3
      +after_key: ""
    }
    "RF Response Time" => "0.11 seconds"
  ]
  "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29831302' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.2966815 42.9357105)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25336
      +items: array:9 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25322
          +post_id: "1553298"
          +post_author: 1
          +"ListingKey": "29935119"
          +"ListingId": "40841738"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-22T15:20:10Z"
          +"RFModificationTimestamp": "2026-06-22T15:29:25Z"
          +"ListPrice": 989500.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 1971.0
          +"BuildingAreaTotal": 0
          +"City": "Waterford"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "163 GIBBONS Street, Waterford, Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.2974462
            1 => 42.9425213
          ]
          +"Latitude": 42.9425213
          +"Longitude": -80.2974462
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "To Be Built - This 3-bedroom, 2-bath brick and stone bungalow with main-floor laundry is a true showstopper on one of the last remaining premium lots in the Villages of Waterford. The open-concept floorplan features a gourmet kitchen with custom cabinetry, a large island, quartz counters, and backsplash. The dining and living rooms showcase 9' ceilings complemented by your choice of hardwood or luxury vinyl flooring throughout. The primary bedroom has a tray ceiling and offers a walk-in closet and a spacious ensuite with a standalone tub and tiled shower with glass doors. Enjoy entertaining on the back covered composite deck or relaxing on the front porch. Fully sodded, with a Tarion warranty. Optional appliance package available. (id:62650)"
          +"Appliances": array:3 [
            0 => "Hood Fan"
            1 => "Garage door opener"
            2 => "Microwave Built-in"
          ]
          +"Basement": array:2 [
            0 => "Unfinished"
            1 => "Full"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-22T14:41:07.061451+00:00"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Stone"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2211588"
          +"ListOfficeKey": "48560"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:2 [
            0 => "Crushed stone driveway"
            1 => "Automatic Garage Door Opener"
          ]
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-22T12:30:51Z"
          +"PhotosCount": 1
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-22T15:11:27Z"
          +"Stories": "1.0"
          +"StreetName": "GIBBONS"
          +"StreetNumber": "163"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "Waterford"
          +"Utilities": array:2 [
            0 => "Natural Gas"
            1 => "Electricity"
          ]
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:11 [
            0 => array:11 [
              "RoomKey" => "1665395072"
              "RoomType" => "Bedroom"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => "10'0'' x 12'2''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
            ]
            1 => array:11 [
              "RoomKey" => "1665395073"
              "RoomType" => "Bedroom"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => "10'4'' x 12'2''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
            ]
            2 => array:11 [
              "RoomKey" => "1665395074"
              "RoomType" => "Full bathroom"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
            ]
            3 => array:11 [
              "RoomKey" => "1665395075"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => "13'8'' x 16'2''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
            ]
            4 => array:11 [
              "RoomKey" => "1665395076"
              "RoomType" => "4pc Bathroom"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
            ]
            5 => array:11 [
              "RoomKey" => "1665395077"
              "RoomType" => "Mud room"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => "5'0'' x 10'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.71Z"
            ]
            6 => array:11 [
              "RoomKey" => "1665395078"
              "RoomType" => "Laundry room"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => "6'0'' x 10'8''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.72Z"
            ]
            7 => array:11 [
              "RoomKey" => "1665395079"
              "RoomType" => "Foyer"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => "8'10'' x 10'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.72Z"
            ]
            8 => array:11 [
              "RoomKey" => "1665395080"
              "RoomType" => "Living room"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => "16'8'' x 17'6''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.73Z"
            ]
            9 => array:11 [
              "RoomKey" => "1665395081"
              "RoomType" => "Dining room"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => "11'2'' x 12'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.73Z"
            ]
            10 => array:11 [
              "RoomKey" => "1665395082"
              "RoomType" => "Kitchen"
              "ListingId" => "40841738"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29935119"
              "RoomLength" => null
              "RoomDimensions" => "10'3'' x 15'2''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-22T15:11:27.74Z"
            ]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29935119/163-gibbons-street-waterford"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R1-B"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 40.0
          +"AboveGradeFinishedArea": 1971
          +"OriginalEntryTimestamp": "2026-06-22T12:30:50.96Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Builder"
          +"ListAgentNationalAssociationId": "1457486"
          +"ListOfficeNationalAssociationId": "1218974"
          +"Media": array:1 [
            0 => array:13 [
              "Order" => 1
              "MediaKey" => "29935119_4890_1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29935119/e8f26452fa043998de5669b584ed4430.webp"
              "MediaSize" => 57682
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29935119/thumbnail-e8f26452fa043998de5669b584ed4430.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => true
              "ResourceRecordId" => "40841738"
              "ResourceRecordKey" => "29935119"
              "ModificationTimestamp" => "2026-06-22T12:30:50.96Z"
            ]
          ]
          +"DaysOnMarket": 0
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935119')"
          +"ID": "1553298"
        }
        1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25324
          +post_id: "1545128"
          +post_author: 1
          +"ListingKey": "29924884"
          +"ListingId": "40841272"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-19T11:55:10Z"
          +"RFModificationTimestamp": "2026-06-19T11:57:32Z"
          +"ListPrice": 520000.0
          +"BathroomsTotalInteger": 1.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 4.0
          +"LotSizeArea": 0.25
          +"LivingArea": 1248.0
          +"BuildingAreaTotal": 0
          +"City": "Waterford"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "97 MECHANIC Street W, Waterford, Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.296337
            1 => 42.9365675
          ]
          +"Latitude": 42.9365675
          +"Longitude": -80.296337
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Great opportunity! 2 Storey, 4 Bedroom Home Sitting on an amazing  77 x 126 foot lot. Massive 20 x 40 foot Garage/Workshop with Hydro and a bonus Woodstove. Main Floor Consists of Large Eat-In Kitchen w/ Side Door Access, 4  pc Bath w/ Laundry, Living Room. Recent Improvements Include Fence 2020, Hot Water Tank Owned and Purchased in 2024, and Exterior House Painted in 2024, wood floors refinished, new trim, NEW kitchen and doors! Waterford is located centrally to Simcoe, Brantford, Port Dover, Delhi and with the 403 (which is about a 15-20 minute drive) it is close to Hamilton and beyond. Lake Erie is only a 20 minute drive away for the beach, fishing and boating enthusiasts in the family. Don't Miss Out!! This is a must see. (id:62783)"
          +"Appliances": array:5 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Stove"
            3 => "Dryer"
            4 => "Hood Fan"
          ]
          +"Basement": array:2 [
            0 => "Partially finished"
            1 => "Crawl space"
          ]
          +"ConstructionMaterials": array:1 [
            0 => "Wood frame"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-18T21:26:02.627093+00:00"
          +"Directions": "From main St go west on mechanic"
          +"ExteriorFeatures": array:2 [
            0 => "Wood"
            1 => "Aluminum siding"
          ]
          +"FoundationDetails": array:1 [
            0 => "Stone"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1944913"
          +"ListOfficeKey": "292789"
          +"LivingAreaUnits": "square feet"
          +"LotSizeDimensions": "0.25"
          +"ParkingFeatures": array:1 [
            0 => "Detached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-18T20:55:51Z"
          +"PhotosCount": 36
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-19T11:50:11Z"
          +"Stories": "2.0"
          +"StreetDirSuffix": "West"
          +"StreetName": "MECHANIC"
          +"StreetNumber": "97"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "Waterford"
          +"TaxAnnualAmount": "2959"
          +"Utilities": array:3 [
            0 => "Natural Gas"
            1 => "Electricity"
            2 => "Telephone"
          ]
          +"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=W48mQlkZuqY"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:7 [
            0 => array:11 [
              "RoomKey" => "1662859708"
              "RoomType" => "Bedroom"
              "ListingId" => "40841272"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29924884"
              "RoomLength" => null
              "RoomDimensions" => "8'4'' x 9'5''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
            ]
            1 => array:11 [
              "RoomKey" => "1662859709"
              "RoomType" => "Bedroom"
              "ListingId" => "40841272"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29924884"
              "RoomLength" => null
              "RoomDimensions" => "9'0'' x 9'0''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
            ]
            2 => array:11 [
              "RoomKey" => "1662859710"
              "RoomType" => "Primary Bedroom"
              "ListingId" => "40841272"
              "RoomLevel" => "Second level"
              "RoomWidth" => null
              "ListingKey" => "29924884"
              "RoomLength" => null
              "RoomDimensions" => "9'0'' x 13'9''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
            ]
            3 => array:11 [
              "RoomKey" => "1662859711"
              "RoomType" => "4pc Bathroom"
              "ListingId" => "40841272"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29924884"
              "RoomLength" => null
              "RoomDimensions" => null
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
            ]
            4 => array:11 [
              "RoomKey" => "1662859712"
              "RoomType" => "Bedroom"
              "ListingId" => "40841272"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29924884"
              "RoomLength" => null
              "RoomDimensions" => "8'6'' x 9'2''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
            ]
            5 => array:11 [
              "RoomKey" => "1662859713"
              "RoomType" => "Living room"
              "ListingId" => "40841272"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29924884"
              "RoomLength" => null
              "RoomDimensions" => "14'2'' x 14'3''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
            ]
            6 => array:11 [
              "RoomKey" => "1662859714"
              "RoomType" => "Eat in kitchen"
              "ListingId" => "40841272"
              "RoomLevel" => "Main level"
              "RoomWidth" => null
              "ListingKey" => "29924884"
              "RoomLength" => null
              "RoomDimensions" => "11'6'' x 17'5''"
              "RoomDescription" => null
              "RoomLengthWidthUnits" => null
              "ModificationTimestamp" => "2026-06-19T11:50:11.37Z"
            ]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29924884/97-mechanic-street-w-waterford"
          +"ParkingTotal": 6
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"SecurityFeatures": array:1 [
            0 => "None"
          ]
          +"ZoningDescription": "R1"
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 84.0
          +"AboveGradeFinishedArea": 1248
          +"OriginalEntryTimestamp": "2026-06-18T20:51:03.14Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1240500"
          +"ListOfficeNationalAssociationId": "1417429"
          +"Media": array:36 [
            0 => array:13 [
              "Order" => 1
              "MediaKey" => "29924884_4890_1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/fb9bcd55e487c288f5708af6f645ada5.webp"
              "MediaSize" => 115791
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-fb9bcd55e487c288f5708af6f645ada5.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => true
              "ResourceRecordId" => "40841272"
              "ResourceRecordKey" => "29924884"
              "ModificationTimestamp" => "2026-06-18T20:55:49.32Z"
            ]
            1 => array:13 [
              "Order" => 2
              "MediaKey" => "29924884_4890_2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/728e9f2549a37731ef82f73412ac122a.webp"
              "MediaSize" => 138392
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-728e9f2549a37731ef82f73412ac122a.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841272"
              "ResourceRecordKey" => "29924884"
              "ModificationTimestamp" => "2026-06-18T20:55:49.61Z"
            ]
            2 => array:13 [
              "Order" => 3
              "MediaKey" => "29924884_4890_3"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/f24697110c509c524ac35e63f22002c7.webp"
              "MediaSize" => 128328
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-f24697110c509c524ac35e63f22002c7.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841272"
              "ResourceRecordKey" => "29924884"
              "ModificationTimestamp" => "2026-06-18T20:55:49.8Z"
            ]
            3 => array:13 [
              "Order" => 4
              "MediaKey" => "29924884_4890_4"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/7e57379caf894e8154b10296bdd5924e.webp"
              "MediaSize" => 124991
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-7e57379caf894e8154b10296bdd5924e.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841272"
              "ResourceRecordKey" => "29924884"
              "ModificationTimestamp" => "2026-06-18T20:55:49.88Z"
            ]
            4 => array:13 [
              "Order" => 5
              "MediaKey" => "29924884_4890_5"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/fc95334860e9d02b3b330d6f73053d98.webp"
              "MediaSize" => 204779
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-fc95334860e9d02b3b330d6f73053d98.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841272"
              "ResourceRecordKey" => "29924884"
              "ModificationTimestamp" => "2026-06-18T20:55:49.8Z"
            ]
            5 => array:13 [
              "Order" => 6
              "MediaKey" => "29924884_4890_6"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/bcb86afbd47a80583ec4efaa047d7cde.webp"
              "MediaSize" => 169321
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-bcb86afbd47a80583ec4efaa047d7cde.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841272"
              "ResourceRecordKey" => "29924884"
              "ModificationTimestamp" => "2026-06-18T20:55:49.33Z"
            ]
            6 => array:13 [
              "Order" => 7
              "MediaKey" => "29924884_4890_7"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29924884/3a52b3f42449a900062327e42b90cd78.webp"
              "MediaSize" => 141815
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29924884/thumbnail-3a52b3f42449a900062327e42b90cd78.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Property Photo"
              "LongDescription" => null
              "PreferredPhotoYN" => false
              "ResourceRecordId" => "40841272"
              "ResourceRecordKey" => "29924884"
              "ModificationTimestamp" => "2026-06-18T20:55:49.31Z"
            ]
            7 => array:13 [
              "Order" => 8
              "MediaKey" => "29924884_4890_8"
               …11
            ]
            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]
          ]
          +"DaysOnMarket": 3
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924884')"
          +"ID": "1545128"
        }
        2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25321
          +post_id: "1543148"
          +post_author: 1
          +"ListingKey": "29921679"
          +"ListingId": "40839371"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-21T20:30:04Z"
          +"RFModificationTimestamp": "2026-06-21T20:33:34Z"
          +"ListPrice": 499900.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 4.0
          +"LotSizeArea": 0.21
          +"LivingArea": 2026.0
          +"BuildingAreaTotal": 0
          +"City": "Waterford"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "121 MAIN Street N, Waterford, Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.2933571
            1 => 42.9402224
          ]
          +"Latitude": 42.9402224
          +"Longitude": -80.2933571
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
          +"PublicRemarks": "Some homes check the boxes. Others make you stop the car. Welcome to 121 Main Street North in Waterford. Set on a large 0.21-acre lot in one of Norfolk County’s most charming communities, this beautifully maintained vintage home offers over 2,000 square feet of above-grade living space, 4 bedrooms, 2 bathrooms, and craftsmanship that’s increasingly difficult to find. Lovingly cared for by its owner, this home is exceptionally clean, well-maintained, and features numerous major updates completed over time, allowing you to enjoy its character with confidence. From the moment you arrive, the attractive brick exterior and inviting curb appeal set the tone. The original front door with transom window welcomes you into a home filled with warmth and personality. Inside you’ll find tall ceilings, thick baseboards, original trim and woodwork, oversized windows, exposed brick, French doors, and timeless architectural detail throughout. The main kitchen offers classic oak cabinetry, while a second kitchenette adds flexibility for large families or multi-generational living. The sunroom stands out with exposed brick and natural light, and the parlour-style living room is ideal for quiet evenings and family gatherings. Outside, a fully fenced backyard framed by mature trees offers a private retreat. A carport and parking for four vehicles complete the package. This is a home with true character and presence, the kind that leaves a lasting impression. Offered at $499,900. Welcome home. Home Buyer Protection Plan included covering the central heating system, ductwork, central air conditioning or heat pump (up to $10,000 in year one), plus interior plumbing and electrical for added peace of mind. (id:62650)"
          +"Appliances": array:8 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Dryer"
            6 => "Microwave"
            7 => "Window Coverings"
          ]
          +"Basement": array:2 [
            0 => "Unfinished"
            1 => "Full"
          ]
          +"ConstructionMaterials": array:1 [
            0 => "Wood frame"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-18T16:50:24.292332+00:00"
          +"ExteriorFeatures": array:2 [
            0 => "Wood"
            1 => "Brick"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:1 [
            0 => "Forced air"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2204020"
          +"ListOfficeKey": "92520"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:1 [
            0 => "Paved driveway"
          ]
          +"LotSizeDimensions": "0.21"
          +"ParkingFeatures": array:1 [
            0 => "Carport"
          ]
          +"PhotosChangeTimestamp": "2026-06-18T15:24:56Z"
          +"PhotosCount": 47
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-21T20:25:00Z"
          +"Stories": "2.0"
          +"StreetDirSuffix": "North"
          +"StreetName": "MAIN"
          +"StreetNumber": "121"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "Waterford"
          +"TaxAnnualAmount": "2942.96"
          +"VirtualTourURLUnbranded": "https://vimeo.com/1202261145?share=copy&fl=sv&fe=ci"
          +"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": "Brantford"
          +"ListAORKey": "41"
          +"ListingURL": "www.realtor.ca/real-estate/29921679/121-main-street-n-waterford"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CoListAgentKey": "2153963"
          +"CommonInterest": "Freehold"
          +"CoListAgentKey2": "1941010"
          +"CoListAgentKey3": "2130098"
          +"CoListOfficeKey": "291581"
          +"GeocodeManualYN": true
          +"CoListOfficeKey2": "92520"
          +"CoListOfficeKey3": "92520"
          +"ZoningDescription": "R2"
          +"BedroomsAboveGrade": 4
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 68.0
          +"AboveGradeFinishedArea": 2026
          +"OriginalEntryTimestamp": "2026-06-18T15:24:55.94Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Other"
          +"ListAgentNationalAssociationId": "1452607"
          +"ListOfficeNationalAssociationId": "1191923"
          +"CoListAgentNationalAssociationId": "1405496"
          +"CoListAgentNationalAssociationId2": "1238374"
          +"CoListAgentNationalAssociationId3": "1383021"
          +"CoListOfficeNationalAssociationId": "1400487"
          +"CoListOfficeNationalAssociationId2": "1191923"
          +"CoListOfficeNationalAssociationId3": "1191923"
          +"Media": array:47 [
            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]
          ]
          +"DaysOnMarket": 4
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29921679')"
          +"ID": "1543148"
        }
        3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25333
          +post_id: "1522517"
          +post_author: 1
          +"ListingKey": "29891970"
          +"ListingId": "X13434222"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-11T21:10:14Z"
          +"RFModificationTimestamp": "2026-06-11T21:41:51Z"
          +"ListPrice": 1799900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Norfolk (Waterford)"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "276 MECHANIC STREET W, Norfolk (Waterford), Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.3042611
            1 => 42.933974
          ]
          +"Latitude": 42.933974
          +"Longitude": -80.3042611
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "OnePoint Association of REALTORS®"
          +"PublicRemarks": "Welcome to a truly rare waterfront offering where the tranquility of cottage living meets the convenience of town amenities. Set on nearly 4 acres with over 700 feet of shoreline on beautiful Shadow Lake, this exceptional property provides a private retreat surrounded by mature trees, abundant wildlife, and breathtaking natural scenery. The thoughtfully updated bungalow offers approximately 1,800 sq. ft. of comfortable main-floor living, featuring an inviting open-concept layout designed for both everyday living and entertaining. The renovated kitchen serves as the heart of the home, while generous living spaces and large windows capture stunning views of the surrounding property. The fully finished walkout lower level provides additional living and guest space with direct access to the outdoor entertaining area and pool deck. Step outside and enjoy a lifestyle that feels more like a lakeside cottage than a residence in town. Spend your mornings paddleboarding or kayaking, afternoons exploring the shoreline and nearby trails, and evenings relaxing by the water while taking in spectacular sunsets. Properties offering this level of privacy, waterfront access, and natural beauty are seldom available. A spacious attached 4-car garage is fully insulated and heated, complete with a rare drive-through design, making it ideal for hobbyists, car enthusiasts, recreational equipment, or additional storage. Numerous recent updates provide peace of mind, including improvements to the roof, furnace, air conditioning, pool liner, pool pump, and extensive interior renovations. Located just over an hour from Toronto and minutes from the Waterford Ponds, Trans Canada Trail, and local amenities, this is a unique opportunity to enjoy the best of both worlds -- a cottage lifestyle with the convenience of town living. (id:59439)"
          +"Appliances": array:11 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water meter"
            3 => "Central Vacuum"
            4 => "Dishwasher"
            5 => "Stove"
            6 => "Range"
            7 => "Dryer"
            8 => "Garburator"
            9 => "Garage door opener"
            10 => "Water Heater"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "Bungalow"
          ]
          +"Basement": array:6 [
            0 => "Finished"
            1 => "Separate entrance"
            2 => "Walk out"
            3 => "N/A"
            4 => "N/A"
            5 => "N/A"
          ]
          +"BathroomsPartial": 1
          +"CommunityFeatures": array:1 [
            0 => "Fishing"
          ]
          +"Cooling": array:2 [
            0 => "Central air conditioning"
            1 => "Air exchanger"
          ]
          +"CreationDate": "2026-06-11T21:41:48.736059+00:00"
          +"Directions": "Cross Streets: Concession 8 Townsend Rd/Mechanic St W. ** Directions: Hwy 24 to Concession 8 Townsend Rd/Mechanic St W."
          +"ExteriorFeatures": array:1 [
            0 => "Brick"
          ]
          +"FireplaceYN": true
          +"FoundationDetails": array:1 [
            0 => "Block"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1570202"
          +"ListOfficeKey": "65141"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:5 [
            0 => "Irregular lot size"
            1 => "Backs on greenbelt"
            2 => "Carpet Free"
            3 => "Gazebo"
            4 => "In-Law Suite"
          ]
          +"LotSizeDimensions": "48.8 x 733.1 FT   ; Irregular"
          +"ParkingFeatures": array:2 [
            0 => "Attached Garage"
            1 => "Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-11T21:03:44Z"
          +"PhotosCount": 50
          +"PoolFeatures": array:1 [
            0 => "Inground pool"
          ]
          +"Sewer": array:1 [
            0 => "Sanitary sewer"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-11T21:03:44Z"
          +"Stories": "1.0"
          +"StreetDirSuffix": "West"
          +"StreetName": "Mechanic"
          +"StreetNumber": "276"
          +"StreetSuffix": "Street"
          +"TaxAnnualAmount": "6729"
          +"View": "Lake view,View of water,Direct Water View"
          +"VirtualTourURLUnbranded": "https://pictureyourhome.hd.pics/276-Mechanic-St-W"
          +"WaterBodyName": "Waterford Ponds"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:13 [
            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]
          ]
          +"ListAOR": "OnePoint"
          +"TaxYear": 2025
          +"CityRegion": "Waterford"
          +"ListAORKey": "47"
          +"ListingURL": "www.realtor.ca/real-estate/29891970/276-mechanic-street-w-norfolk-waterford-waterford"
          +"ParkingTotal": 14
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"SecurityFeatures": array:1 [
            0 => "Smoke Detectors"
          ]
          +"LivingAreaMaximum": 1500
          +"LivingAreaMinimum": 1100
          +"ZoningDescription": "R1"
          +"BedroomsAboveGrade": 1
          +"BedroomsBelowGrade": 2
          +"WaterfrontFeatures": array:1 [
            0 => "Waterfront on pond"
          ]
          +"FrontageLengthNumeric": 48.9
          +"OriginalEntryTimestamp": "2026-06-11T21:03:44.04Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1150973"
          +"ListOfficeNationalAssociationId": "1129731"
          +"Media": array:50 [
            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]
            48 => array:13 [ …13]
            49 => array:13 [ …13]
          ]
          +"DaysOnMarket": 10
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891970')"
          +"ID": "1522517"
        }
        4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25323
          +post_id: "1517206"
          +post_author: 1
          +"ListingKey": "29882414"
          +"ListingId": "40838565"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-13T20:45:04Z"
          +"RFModificationTimestamp": "2026-06-13T20:48:52Z"
          +"ListPrice": 1079900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 2389.0
          +"BuildingAreaTotal": 0
          +"City": "Waterford"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "48 TEMPERANCE Street E, Waterford, Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.2879279
            1 => 42.9331162
          ]
          +"Latitude": 42.9331162
          +"Longitude": -80.2879279
          +"YearBuilt": 1900
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Welcome to your summer escape in the heart of Waterford — a move-in ready century home designed for outdoor living, entertaining, and making memories all season long. Imagine long evenings in the beautifully landscaped, private backyard, where there’s room for kids to play, friends to gather, and summer nights to stretch on. The standout two-storey barn adds incredible lifestyle space, featuring a finished and insulated room that’s perfect for a home gym, studio, workshop, or the ultimate hangout zone for guests and teens. Inside, the home is just as inviting for hosting. The bright, open kitchen and dining area is made for summer meals, weekend brunches, and holiday celebrations. A warm family room with a gas fireplace offers the perfect place to unwind after a day outside, while the separate living room with a classic woodburning fireplace adds timeless charm and cozy character. Upstairs, oversized windows fill the home with natural light and lead to a spacious landing. The primary bedroom connects directly to a beautifully updated bathroom with heated floors, and two additional bedrooms plus a second bath provide plenty of room for family or guests. With many updates already completed, this is your chance to settle in before summer truly begins and enjoy everything this home — and Waterford — has to offer (id:62650)"
          +"Appliances": array:6 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Water softener"
            3 => "Dishwasher"
            4 => "Stove"
            5 => "Dryer"
          ]
          +"Basement": array:2 [
            0 => "Unfinished"
            1 => "Partial"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-10T22:00:22.656756+00:00"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1965936"
          +"ListOfficeKey": "48558"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:1 [
            0 => "Private Yard"
          ]
          +"NumberOfUnitsTotal": "1"
          +"PhotosChangeTimestamp": "2026-06-10T16:10:03Z"
          +"PhotosCount": 48
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-13T20:39:45Z"
          +"Stories": "2.0"
          +"StreetDirSuffix": "East"
          +"StreetName": "TEMPERANCE"
          +"StreetNumber": "48"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "Waterford"
          +"TaxAnnualAmount": "4690"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:12 [
            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]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29882414/48-temperance-street-e-waterford"
          +"ParkingTotal": 10
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R3"
          +"BedroomsAboveGrade": 3
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 82.0
          +"AboveGradeFinishedArea": 2389
          +"OriginalEntryTimestamp": "2026-06-10T16:10:03.23Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Listing Brokerage"
          +"ListAgentNationalAssociationId": "1254154"
          +"ListOfficeNationalAssociationId": "1004255"
          +"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": 12
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882414')"
          +"ID": "1517206"
        }
        5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25318
          +post_id: "1506653"
          +post_author: 1
          +"ListingKey": "29869037"
          +"ListingId": "40836926"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-08T14:30:17Z"
          +"RFModificationTimestamp": "2026-06-08T17:29:44Z"
          +"ListPrice": 1900000.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 1.0
          +"LotSizeArea": 0
          +"LivingArea": 1346.0
          +"BuildingAreaTotal": 0
          +"City": "Waterford"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "136-160 MECHANIC Street W, Waterford, Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.2986096
            1 => 42.9353977
          ]
          +"Latitude": 42.9353977
          +"Longitude": -80.2986096
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
          +"PublicRemarks": "Residential Home with additional land which includes 2 parcels totalling 4.42 acres.  The home was built in 2017 and is a 1,346sf executive home with walkout onto the pond. 3rd garage door to additional double deep garage bay.  In-floor heating. Close proximity to schools, local restaurants, backing onto Waterford Ponds makes it a great choice to live. Future Residential townhouse development opportunity. Preliminary Site Plan available with potential for 32 townhouse style lots backing onto to Waterford ponds. Current plan incorporates the existing one story residence.  Potential Site Plan includes an opportunity for 11 additional guest parking spaces.  Property being sold “As Is, Where is”. (id:62650)"
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-08T17:29:35.847896+00:00"
          +"ExteriorFeatures": array:1 [
            0 => "Brick"
          ]
          +"FoundationDetails": array:1 [
            0 => "Poured Concrete"
          ]
          +"Heating": array:1 [
            0 => "Forced air"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1398808"
          +"ListOfficeKey": "289711"
          +"LivingAreaUnits": "square feet"
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-08T14:25:02Z"
          +"PhotosCount": 42
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-08T14:25:02Z"
          +"Stories": "1.0"
          +"StreetDirSuffix": "West"
          +"StreetName": "MECHANIC"
          +"StreetNumber": "136"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "Waterford"
          +"TaxAnnualAmount": "20474.79"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:5 [
            0 => array:11 [ …11]
            1 => array:11 [ …11]
            2 => array:11 [ …11]
            3 => array:11 [ …11]
            4 => array:11 [ …11]
          ]
          +"ListAOR": "Brantford"
          +"ListAORKey": "41"
          +"ListingURL": "www.realtor.ca/real-estate/29869037/136-160-mechanic-street-w-waterford"
          +"ParkingTotal": 6
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R1-A/R4(H)"
          +"BedroomsAboveGrade": 1
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 188.0
          +"AboveGradeFinishedArea": 1346
          +"OriginalEntryTimestamp": "2026-06-08T14:25:02.15Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Plans"
          +"ListAgentNationalAssociationId": "1038750"
          +"ListOfficeNationalAssociationId": "1380321"
          +"Media": array:42 [
            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]
          ]
          +"DaysOnMarket": 14
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29869037')"
          +"ID": "1506653"
        }
        6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23424
          +post_id: "1501702"
          +post_author: 1
          +"ListingKey": "29862636"
          +"ListingId": "40835602"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-11T00:40:10Z"
          +"RFModificationTimestamp": "2026-06-11T00:56:53Z"
          +"ListPrice": 519900.0
          +"BathroomsTotalInteger": 1.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 2.0
          +"LotSizeArea": 0
          +"LivingArea": 1401.0
          +"BuildingAreaTotal": 0
          +"City": "Waterford"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "86 GREEN Street, Waterford, Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.2928635
            1 => 42.9288358
          ]
          +"Latitude": 42.9288358
          +"Longitude": -80.2928635
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "Move-in ready brick bungalow offering over 1,400 sq ft of finished living space in a desirable Waterford location. The main floor features 2 bedrooms plus a versatile office that could serve as a third bedroom, abundant natural light, and a beautifully updated custom kitchen (2021) with premium cabinetry, soft-close drawers, slide-out shelves, new quartz countertops, and corner pull-outs for exceptional storage and convenience. Additional 2021 updates include new flooring throughout, subfloor, 4-piece bathroom, and upgraded lighting with dimmers. The finished basement provides additional living space, a cold room, and ample storage. Recent 2023 improvements include new exterior insulation, siding, basement ceiling, and windows. Enjoy the fully fenced backyard with plenty of room to relax, entertain, or play, plus a spacious shed for bikes, tools, and lawn equipment. Ideally located near the Waterford Heritage Trail, Waterford Ponds, arena, ballpark, and within walking distance to elementary and secondary schools. (id:62650)"
          +"Appliances": array:6 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Dishwasher"
            3 => "Stove"
            4 => "Dryer"
            5 => "Window Coverings"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "Bungalow"
          ]
          +"Basement": array:2 [
            0 => "Partially finished"
            1 => "Full"
          ]
          +"CommunityFeatures": array:1 [
            0 => "Quiet Area"
          ]
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-05T23:01:48.744235+00:00"
          +"Directions": "Old Highway 24 to Green Street"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Vinyl siding"
          ]
          +"Fencing": array:1 [
            0 => "Fence"
          ]
          +"FoundationDetails": array:1 [
            0 => "Stone"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1470071"
          +"ListOfficeKey": "48558"
          +"LivingAreaUnits": "square feet"
          +"LotFeatures": array:1 [
            0 => "Conservation/green belt"
          ]
          +"PhotosChangeTimestamp": "2026-06-11T00:31:57Z"
          +"PhotosCount": 32
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-11T00:31:57Z"
          +"Stories": "1.0"
          +"StreetName": "GREEN"
          +"StreetNumber": "86"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "Waterford"
          +"TaxAnnualAmount": "2785.58"
          +"Utilities": array:4 [
            0 => "Natural Gas"
            1 => "Electricity"
            2 => "Cable"
            3 => "Telephone"
          ]
          +"VirtualTourURLUnbranded": "https://visithome.ai/C7n5h49cQgS6gP3QBnKdyH?mu=ft"
          +"WaterSource": array:1 [
            0 => "Municipal water"
          ]
          +"Rooms": array:8 [
            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]
          ]
          +"ListAOR": "Cornerstone"
          +"ListAORKey": "14"
          +"ListingURL": "www.realtor.ca/real-estate/29862636/86-green-street-waterford"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "House"
          ]
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"SecurityFeatures": array:1 [
            0 => "Smoke Detectors"
          ]
          +"ZoningDescription": "R1"
          +"BedroomsAboveGrade": 2
          +"BedroomsBelowGrade": 0
          +"FrontageLengthNumeric": 59.0
          +"AboveGradeFinishedArea": 1081
          +"BelowGradeFinishedArea": 320
          +"OriginalEntryTimestamp": "2026-06-05T19:39:33.59Z"
          +"FrontageLengthNumericUnits": "feet"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"BelowGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Listing Brokerage"
          +"BelowGradeFinishedAreaSource": "Listing Brokerage"
          +"ListAgentNationalAssociationId": "1127015"
          +"ListOfficeNationalAssociationId": "1004255"
          +"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": 16
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29862636')"
          +"ID": "1501702"
        }
        7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25334
          +post_id: "1497596"
          +post_author: 1
          +"ListingKey": "29856241"
          +"ListingId": "40834172"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-14T19:40:06Z"
          +"RFModificationTimestamp": "2026-06-14T19:42:50Z"
          +"ListPrice": 824900.0
          +"BathroomsTotalInteger": 3.0
          +"BathroomsHalf": 1
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 0
          +"LivingArea": 1475.0
          +"BuildingAreaTotal": 0
          +"City": "Waterford"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "15 WINTERBERRY Lane, Waterford, Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.2856016
            1 => 42.9211293
          ]
          +"Latitude": 42.9211293
          +"Longitude": -80.2856016
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Cornerstone Association of REALTORS®"
          +"PublicRemarks": "END UNIT luxury bungalow townhome in sought-after Waterford, proudly built by Prominent Homes Inc. This beautiful 2+1 bedroom open-concept home offers upscale, low-maintenance living with quality finishes throughout. Features include 9-foot ceilings, rich hardwood floors, rounded corners, decorative ceilings, pot lights, and elegant custom details throughout. Quality construction includes 9” poured concrete foundation walls with reinforced walls and footings. The gourmet kitchen is a showpiece featuring granite countertops, spacious island, custom cabinetry, and ample storage space. Additional upgrades include stained stringers with rod iron railings, colonial-style doors and trim, HRV system, humidifier, central air conditioning, and central vac rough-in. Main floor laundry with direct access to the insulated 2-car garage. The fully finished basement offers exceptional additional living space with a spacious third bedroom, large rec room, separate office, and 4-piece bathroom, ideal for guests, extended family, or working from home. Enjoy the covered composite deck with tile patio stone sitting area, extended rear privacy fencing between units, attractive landscaping, and no-maintenance aluminum soffit, fascia, and troughs. Conveniently located very close to visitor parking. Condo corporation handles grass cutting, snow removal, landscaping, and exterior maintenance for easy living. Located close to schools, churches, Waterford Ponds, Lynn Valley Trail, golf, downtown amenities, wineries, breweries, and just a short drive to Port Dover Beach. A must-see home offering custom style, modern finishes, quality construction, and a prime location. (id:62650)"
          +"Appliances": array:5 [
            0 => "Washer"
            1 => "Refrigerator"
            2 => "Dishwasher"
            3 => "Stove"
            4 => "Dryer"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "Bungalow"
          ]
          +"AssociationFee": "395"
          +"AssociationFeeFrequency": "Monthly"
          +"AssociationFeeIncludes": array:2 [
            0 => "Landscaping"
            1 => "Insurance"
          ]
          +"Basement": array:2 [
            0 => "Finished"
            1 => "Full"
          ]
          +"BathroomsPartial": 1
          +"Cooling": array:1 [
            0 => "Central air conditioning"
          ]
          +"CreationDate": "2026-06-04T21:08:24.329421+00:00"
          +"ExteriorFeatures": array:2 [
            0 => "Brick"
            1 => "Stucco"
          ]
          +"Heating": array:2 [
            0 => "Forced air"
            1 => "Natural gas"
          ]
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "2079582"
          +"ListOfficeKey": "285770"
          +"LivingAreaUnits": "square feet"
          +"ParkingFeatures": array:1 [
            0 => "Attached Garage"
          ]
          +"PhotosChangeTimestamp": "2026-06-05T21:50:16Z"
          +"PhotosCount": 41
          +"PropertyAttachedYN": true
          +"Sewer": array:1 [
            0 => "Municipal sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-14T19:32:23Z"
          +"Stories": "1.0"
          +"StreetName": "WINTERBERRY"
          +"StreetNumber": "15"
          +"StreetSuffix": "Lane"
          +"SubdivisionName": "Town of Simcoe"
          +"TaxAnnualAmount": "5024"
          +"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/29856241/15-winterberry-lane-waterford"
          +"ParkingTotal": 4
          +"StructureType": array:1 [
            0 => "Row / Townhouse"
          ]
          +"CommonInterest": "Condo/Strata"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R4 (H)"
          +"BedroomsAboveGrade": 2
          +"BedroomsBelowGrade": 1
          +"AboveGradeFinishedArea": 1475
          +"OriginalEntryTimestamp": "2026-06-04T20:32:20.68Z"
          +"AboveGradeFinishedAreaUnits": "square feet"
          +"AboveGradeFinishedAreaSource": "Builder"
          +"ListAgentNationalAssociationId": "1354478"
          +"ListOfficeNationalAssociationId": "1354408"
          +"Media": array:41 [
            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]
          ]
          +"DaysOnMarket": 17
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29856241')"
          +"ID": "1497596"
        }
        8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25335
          +post_id: "1494556"
          +post_author: 1
          +"ListingKey": "29853923"
          +"ListingId": "40836242"
          +"PropertyType": "Residential"
          +"PropertySubType": "Vacant Land"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2026-06-05T21:20:34Z"
          +"RFModificationTimestamp": "2026-06-05T21:35:31Z"
          +"ListPrice": 1900000.0
          +"BathroomsTotalInteger": 0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 0
          +"LotSizeArea": 0
          +"LivingArea": 0
          +"BuildingAreaTotal": 0
          +"City": "Waterford"
          +"PostalCode": "N0E1Y0"
          +"UnparsedAddress": "136/160 MECHANIC Street W, Waterford, Ontario N0E1Y0"
          +"Coordinates": array:2 [
            0 => -80.29863
            1 => 42.9355588
          ]
          +"Latitude": 42.9355588
          +"Longitude": -80.29863
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
          +"PublicRemarks": "Residential townhouse development opportunity. 2 parcels totalling 4.42 acres Preliminary Site Plan available with potential for 32 townhouse style lots backing onto to Waterford ponds. Current plan incorporates the existing one story residence, built in 2017 is a 1,346sf executive home with walkout onto the pond. Details available with signed Confidentiality Agreement (CA). Close proximity to schools, local restaurants, backing onto Waterford Ponds makes it a great choice to live. Site plan includes an opportunity for 11 additional guest parking spaces, potential site plan and additional information can be provided upon signing of a Confidentiality Agreement. Property being sold “As Is, Where is”. (id:62650)"
          +"Basement": array:1 [
            0 => "None"
          ]
          +"CreationDate": "2026-06-04T18:07:52.922455+00:00"
          +"InternetEntireListingDisplayYN": true
          +"ListAgentKey": "1398808"
          +"ListOfficeKey": "289711"
          +"PhotosChangeTimestamp": "2026-06-04T16:44:32Z"
          +"PhotosCount": 21
          +"Sewer": array:1 [
            0 => "No sewage system"
          ]
          +"StateOrProvince": "Ontario"
          +"StatusChangeTimestamp": "2026-06-05T21:14:58Z"
          +"StreetDirSuffix": "West"
          +"StreetName": "MECHANIC"
          +"StreetNumber": "136"
          +"StreetSuffix": "Street"
          +"SubdivisionName": "Waterford"
          +"TaxAnnualAmount": "20474.79"
          +"WaterSource": array:1 [
            0 => "None"
          ]
          +"ListAOR": "Brantford"
          +"ListAORKey": "41"
          +"ListingURL": "www.realtor.ca/real-estate/29853923/136160-mechanic-street-w-waterford"
          +"CommonInterest": "Freehold"
          +"GeocodeManualYN": true
          +"ZoningDescription": "R1-A/R4(H)"
          +"FrontageLengthNumeric": 188.0
          +"OriginalEntryTimestamp": "2026-06-04T16:44:32.16Z"
          +"FrontageLengthNumericUnits": "feet"
          +"ListAgentNationalAssociationId": "1038750"
          +"ListOfficeNationalAssociationId": "1380321"
          +"Media": array:21 [
            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]
          ]
          +"DaysOnMarket": 18
          +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29853923')"
          +"ID": "1494556"
        }
      ]
      +success: true
      +page_size: 9
      +page_count: 5
      +count: 43
      +after_key: ""
    }
    "RF Response Time" => "0.14 seconds"
  ]
]

1-877-888-3131

We will help you sell your home, commission free.

Save Thousands When You Sell Your Home

Menu

Resources

Get Started

Contact us

Offer to Purchase Forms

Offer to Lease

Offer to Purchase Forms

Offer to Purchase Forms

Offer to Lease

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel

Menu

Resources

Get Started

Contact us

Offer to Purchase Forms

Offer to Lease

Offer to Purchase Forms

Offer to Purchase Forms

Offer to Lease

How It Works

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel

MLS On The Fly Debug Panel