array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29810554 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1464291"
+post_author: 1
+"ListingKey": "29810554"
+"ListingId": "40833168"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T20:20:08Z"
+"RFModificationTimestamp": "2026-06-28T20:27:18Z"
+"ListPrice": 929000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2362.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "155 GIBBONS Street, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2972258
1 => 42.942493
]
+"Latitude": 42.942493
+"Longitude": -80.2972258
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 2-storey home offering over 2,300 sq. ft. of beautifully designed living space with 5 bedrooms and room for the whole family! From the moment you step inside, you’ll appreciate the spacious foyer with convenient access to the garage and plenty of room to welcome guests. At the front of the home, the versatile main floor bedroom is perfect for guests, a home office, or a playroom to suit your family’s needs. Continuing through the home, prepare to be impressed by the abundance of windows along the back of the house, filling the space with natural light and creating a warm, inviting atmosphere. The open-concept main floor is ideal for entertaining, featuring a large living room that flows seamlessly into the gorgeous kitchen and dining area. The chef in the family will love preparing meals here, complete with ample workspace, stylish finishes, and a large walk-in pantry for all your storage needs. The dining area offers quick access to the backyard, making indoor-outdoor entertaining effortless. Luxury Vinyl Plank flooring runs throughout the main floor, adding both style and durability. Upstairs, the spacious primary bedroom is privately situated at the back of the home and features stunning views along with a luxurious 5-piece ensuite. The second level also offers a convenient laundry room, a 4-piece bathroom, and 3 additional generously sized bedrooms. The partially finished basement provides even more living space with endless opportunities to customize to your needs, that includes a rough in bathroom and wet bar area. Step outside and enjoy the beautifully landscaped backyard complete with a deck off the home, cozy fire pit area, and an above-ground pool — the perfect setting for relaxing or entertaining all summer long! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Range - Gas"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Dryer"
8 => "Oven - Built-In"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-27T17:25:31.534922+00:00"
+"Directions": "old HYW 24 turn Right on to Gibbons Street to 155"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1967495"
+"ListOfficeKey": "292150"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-27T13:42:17Z"
+"PhotosCount": 36
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T20:14:24Z"
+"Stories": "2.0"
+"StreetName": "GIBBONS"
+"StreetNumber": "155"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "6799.46"
+"VirtualTourURLUnbranded": "https://stoic-media.aryeo.com/videos/019e5cbe-8626-72ca-b3d3-cdc5c56cc79d?v=364"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1670564301"
"RoomType" => "4pc Bathroom"
"ListingId" => "40833168"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 5'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.57Z"
]
1 => array:11 [
"RoomKey" => "1670564302"
"RoomType" => "Storage"
"ListingId" => "40833168"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.57Z"
]
2 => array:11 [
"RoomKey" => "1670564303"
"RoomType" => "Recreation room"
"ListingId" => "40833168"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "9'2'' x 21'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.57Z"
]
3 => array:11 [
"RoomKey" => "1670564304"
"RoomType" => "Other"
"ListingId" => "40833168"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "34'0'' x 30'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.57Z"
]
4 => array:11 [
"RoomKey" => "1670564305"
"RoomType" => "Bedroom"
"ListingId" => "40833168"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "9'9'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.57Z"
]
5 => array:11 [
"RoomKey" => "1670564306"
"RoomType" => "Bedroom"
"ListingId" => "40833168"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "9'5'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.57Z"
]
6 => array:11 [
"RoomKey" => "1670564307"
"RoomType" => "Bedroom"
"ListingId" => "40833168"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 10'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.57Z"
]
7 => array:11 [
"RoomKey" => "1670564308"
"RoomType" => "Laundry room"
"ListingId" => "40833168"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "7'6'' x 8'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.58Z"
]
8 => array:11 [
"RoomKey" => "1670564309"
"RoomType" => "Full bathroom"
"ListingId" => "40833168"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "10'3'' x 14'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.58Z"
]
9 => array:11 [
"RoomKey" => "1670564310"
"RoomType" => "Primary Bedroom"
"ListingId" => "40833168"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "12'9'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.58Z"
]
10 => array:11 [
"RoomKey" => "1670564311"
"RoomType" => "Pantry"
"ListingId" => "40833168"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "6'9'' x 10'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.58Z"
]
11 => array:11 [
"RoomKey" => "1670564312"
"RoomType" => "Kitchen"
"ListingId" => "40833168"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "15'7'' x 21'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.59Z"
]
12 => array:11 [
"RoomKey" => "1670564313"
"RoomType" => "Living room"
"ListingId" => "40833168"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "18'8'' x 19'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.59Z"
]
13 => array:11 [
"RoomKey" => "1670564314"
"RoomType" => "2pc Bathroom"
"ListingId" => "40833168"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 5'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.59Z"
]
14 => array:11 [
"RoomKey" => "1670564315"
"RoomType" => "Bedroom"
"ListingId" => "40833168"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29810554"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-28T20:14:24.59Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29810554/155-gibbons-street-waterford"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2214844"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2073455"
+"CoListOfficeKey": "293165"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "292150"
+"ZoningDescription": "R1-B"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 46.0
+"AboveGradeFinishedArea": 2159
+"BelowGradeFinishedArea": 203
+"OriginalEntryTimestamp": "2026-05-27T13:39:03.37Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1255506"
+"ListOfficeNationalAssociationId": "1408460"
+"CoListAgentNationalAssociationId": "1460548"
+"CoListAgentNationalAssociationId2": "1348640"
+"CoListOfficeNationalAssociationId": "1423396"
+"CoListOfficeNationalAssociationId2": "1408460"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29810554_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/159ded159ea61d9a25a22d52d99ae958.webp"
"MediaSize" => 83766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-159ded159ea61d9a25a22d52d99ae958.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary two-story residence featuring light siding, a spacious two-car garage with a dark wood-finish door, covered front porch, and stone accents"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:17.6Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29810554_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/4da0d98279dbf78d45d93b7e84de3461.webp"
"MediaSize" => 118865
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-4da0d98279dbf78d45d93b7e84de3461.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inviting front porch featuring a wood-finish entry door with sidelights, white board-and-batten siding, stone accents, and a triple-pane window with grids"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.66Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29810554_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/d6bf194ad3c55fc05f0db829b0ac574f.webp"
"MediaSize" => 62043
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-d6bf194ad3c55fc05f0db829b0ac574f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring wood-finish flooring, recessed lighting, and a white paneled front door with decorative glass inserts"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:17.38Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29810554_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/251b70b50a94bd0676e0d12fcb041cdc.webp"
"MediaSize" => 79882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-251b70b50a94bd0676e0d12fcb041cdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space with wide plank wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.66Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29810554_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/8a0de5ab14787332ac7e8d46a7e57236.webp"
"MediaSize" => 62122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-8a0de5ab14787332ac7e8d46a7e57236.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive hallway featuring wood-finish flooring, recessed lighting, white interior doors with dark hardware, and bright natural light from the distant window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29810554_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/4ab52ce4273ef84c57b8ea0bfcb0b8f1.webp"
"MediaSize" => 87955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-4ab52ce4273ef84c57b8ea0bfcb0b8f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, recessed lighting, and multiple large windows"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.69Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29810554_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/28e70c9f80589e61814616d2be21e2a4.webp"
"MediaSize" => 79588
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-28e70c9f80589e61814616d2be21e2a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living area featuring wood-finish flooring and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.52Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29810554_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/461568c929341adad7b401afe3d16241.webp"
"MediaSize" => 89889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-461568c929341adad7b401afe3d16241.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white toilet, wood-finish flooring, and a vanity with a teal cabinet, white countertop, and gold-toned faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.58Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29810554_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/05c0c774e4b724e93fe21b6b39839fa1.webp"
"MediaSize" => 91138
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-05c0c774e4b724e93fe21b6b39839fa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright kitchen featuring wood-finish flooring and a central island with integrated seating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.71Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29810554_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/b638b76d67fce5a039fa2a073d309266.webp"
"MediaSize" => 51504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-b638b76d67fce5a039fa2a073d309266.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stainless steel gas range with six burners, integrated into white shaker-style cabinetry with brass-tone hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.66Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29810554_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/e7bdc53ab0b57ea99e40113e18b303f9.webp"
"MediaSize" => 82842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-e7bdc53ab0b57ea99e40113e18b303f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring wood-finish cabinetry, a white countertop, and a stainless steel dishwasher"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.66Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29810554_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/c7f710d688728837a2e2bf479e5d9dd8.webp"
"MediaSize" => 66552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-c7f710d688728837a2e2bf479e5d9dd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gourmet kitchen featuring a stainless steel gas range with a wood-hooded vent, white shaker cabinetry with bronze hardware, white countertops, floating wood shelves, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.67Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29810554_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/473da7881dacc12be72e2b08129f770a.webp"
"MediaSize" => 71699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-473da7881dacc12be72e2b08129f770a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stainless steel French door refrigerator and double wall ovens integrated into white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.7Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29810554_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/b6278337c3517de7c6f4027741f6b7af.webp"
"MediaSize" => 72897
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-b6278337c3517de7c6f4027741f6b7af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Built-in cabinetry featuring wood-finish paneling and gold-tone hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.7Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29810554_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/c06f95dfaa59ae46c08e76454b5ae57c.webp"
"MediaSize" => 77264
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-c06f95dfaa59ae46c08e76454b5ae57c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Integrated beverage cooler set within rich wood-finish cabinetry, complemented by a light-toned countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.72Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29810554_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/0526c016764a53e9549a9fae28ec64b9.webp"
"MediaSize" => 84942
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-0526c016764a53e9549a9fae28ec64b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring a multi-pane window, wood-finish flooring, and a contemporary sputnik chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.66Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29810554_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/247205aabc2a78817593c93e4247c567.webp"
"MediaSize" => 97294
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-247205aabc2a78817593c93e4247c567.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a large grid-pane window, dark accent wall, wood-finish wainscoting, and neutral carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.72Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29810554_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/4ab3c7b875c09c9ecffa9694d29a8deb.webp"
"MediaSize" => 88596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-4ab3c7b875c09c9ecffa9694d29a8deb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring two windows with white trim, a geometric pendant light fixture, and textured carpet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.7Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29810554_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/85396999209259554a4ebeb9cfb2d9f5.webp"
"MediaSize" => 59905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-85396999209259554a4ebeb9cfb2d9f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom with light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.7Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29810554_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/56b52f8a8ac7d6ebd94e4f546d386e65.webp"
"MediaSize" => 109696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-56b52f8a8ac7d6ebd94e4f546d386e65.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated room featuring built-in shelving, organized clothing racks, dual windows, carpeted flooring, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.72Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29810554_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/83087de04e71071e0f1db97f2779d3fa.webp"
"MediaSize" => 90393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-83087de04e71071e0f1db97f2779d3fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom featuring a dark accent wall, recessed lighting, and a ceiling fan with light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.7Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29810554_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/1ce3c7d6ad4145778a32705baf969b2c.webp"
"MediaSize" => 81683
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-1ce3c7d6ad4145778a32705baf969b2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright interior space featuring a multi-pane window, flush-mount ceiling fan with caged light fixture, soft gray carpet flooring, and a built-in closet with shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.66Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29810554_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/0ea06b9f4f5c7800f610b58e2dff7ea9.webp"
"MediaSize" => 78576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-0ea06b9f4f5c7800f610b58e2dff7ea9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious bathroom featuring dual wood-finish vanities with solid surface countertops, a freestanding soaking tub, a large walk-in shower with glass enclosure, and contemporary lighting fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.66Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29810554_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/3b0ba87cc428c15edc5d10066fc93369.webp"
"MediaSize" => 56862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-3b0ba87cc428c15edc5d10066fc93369.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Freestanding soaking tub with matte black fixtures"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:17.38Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29810554_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/2e1474084a808d19a74038deb8073551.webp"
"MediaSize" => 73891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-2e1474084a808d19a74038deb8073551.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk-in shower with clear glass enclosure and black hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.72Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29810554_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/03bc3c786b6cb7d5efffbdcffe8359e6.webp"
"MediaSize" => 32134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-03bc3c786b6cb7d5efffbdcffe8359e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room featuring a white toilet, light gray walls, white baseboards, and a towel bar with a white hand towel"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.73Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29810554_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/1cb5e55e684ae231f02126215c474425.webp"
"MediaSize" => 130237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-1cb5e55e684ae231f02126215c474425.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Basement space featuring exposed wood joists, recessed lighting, and durable interlocking floor mats"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.72Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29810554_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/88bc5c837433d43083e8e20e1327e0be.webp"
"MediaSize" => 116519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-88bc5c837433d43083e8e20e1327e0be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Unfinished basement space featuring exposed wood joists and ductwork, resilient flooring, recessed lighting, and a partially framed staircase"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:17.38Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29810554_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/5300cafff21401640815cf3529fdc75a.webp"
"MediaSize" => 96739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-5300cafff21401640815cf3529fdc75a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with dark teal walls and an exposed ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.7Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29810554_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/9545d1282d0e0f6e5cb197326c4b0d49.webp"
"MediaSize" => 122152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-9545d1282d0e0f6e5cb197326c4b0d49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Utility room with extensive built-in wooden shelving, concrete flooring, exposed ceiling joists, and a window providing natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.66Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29810554_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/00e03cd7be4e5b2ccb7fc8a96840dd64.webp"
"MediaSize" => 94858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-00e03cd7be4e5b2ccb7fc8a96840dd64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive wood deck with a built-in fire pit, privacy landscaping, and field views"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:17.69Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29810554_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/33087fc14abf52b615b3b9ecfdfaa048.webp"
"MediaSize" => 131106
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-33087fc14abf52b615b3b9ecfdfaa048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive fenced backyard featuring a substantial above-ground pool with a surrounding sand base"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:17.6Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29810554_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/e33e68f27ba6807310dd11eea1ddaa22.webp"
"MediaSize" => 123251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-e33e68f27ba6807310dd11eea1ddaa22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gravel patio area featuring a metal fire pit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.72Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29810554_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/8b513a723b44f671f7db1ee8a6abe9e0.webp"
"MediaSize" => 127373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-8b513a723b44f671f7db1ee8a6abe9e0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring a multi-level wood deck with a covered patio area, white siding, and double glass French doors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.66Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29810554_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/502d078a6a3563e5c215a6b92655a300.webp"
"MediaSize" => 181686
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-502d078a6a3563e5c215a6b92655a300.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rear exterior featuring a multi-level wood deck, an above-ground swimming pool, and a gravel patio area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:11.67Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29810554_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29810554/c77def071a3dab7e134f7e515b20e482.webp"
"MediaSize" => 100679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29810554/thumbnail-c77def071a3dab7e134f7e515b20e482.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a large above-ground pool, a spacious wood deck, and a gravel patio with fire pit"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40833168"
"ResourceRecordKey" => "29810554"
"ModificationTimestamp" => "2026-05-27T13:42:12.7Z"
]
]
+"DaysOnMarket": 41
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29810554')"
+"ID": "1464291"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 292150" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24900
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1967495" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24869
+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 '29810554'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25256
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29810554'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25273
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25272
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31191309"
+"ListingKey": "29810554"
+"ListingId": "40833168"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-31T17:48:06Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31191309')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25274
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31396697"
+"ListingKey": "29810554"
+"ListingId": "40833168"
+"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-09T21:10:48Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31396697')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25271
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31403217"
+"ListingKey": "29810554"
+"ListingId": "40833168"
+"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-14T19:59:54Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31403217')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25275
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31627103"
+"ListingKey": "29810554"
+"ListingId": "40833168"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-28"
+"OpenHouseStartTime": "2026-06-28T14:00:00Z"
+"OpenHouseEndTime": "2026-06-28T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-28T19:56:59Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31627103')"
}
]
+success: true
+page_size: 4
+page_count: 1
+count: 4
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29810554' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.2972258 42.942493)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25353
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25347
+post_id: "1601042"
+post_author: 1
+"ListingKey": "29998239"
+"ListingId": "40845613"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:05:13Z"
+"RFModificationTimestamp": "2026-07-07T17:53:27Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1787.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "103 AMBER Street, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2949626
1 => 42.9413757
]
+"Latitude": 42.9413757
+"Longitude": -80.2949626
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 103 Amber Street, Waterford – a newly built semi-detached home that blends modern design with small-town charm. With 1787 sq. ft. of thoughtfully designed living space, this 2-storey semi-detached home offers the perfect balance of comfort, style, and functionality, making it ideal for today’s growing families. Step inside from the covered front entrance into a spacious foyer that opens into a bright, open-concept main floor. The kitchen is a true showpiece, featuring custom cabinetry, quartz countertops and a breakfast island, all designed with modern convenience in mind. The dining area and great room flow seamlessly together, creating an inviting space for gatherings and everyday living. Luxury vinyl plank flooring throughout the main level ensures both durability and style. Upstairs, you’ll find three generously sized bedrooms, including a primary suite complete with a 4-piece ensuite and walk-in closet. Practical details such as an upper-level laundry room with sink, 9-ft main floor ceilings, and an attached double-car garage with 8-ft door add everyday convenience. The unfinished basement with large windows and a rough-in bath is ready for your personal touch. Beyond the home, Waterford is a community that truly shines. Known for its friendly atmosphere, and welcoming downtown, local stores and restaurants, and Waterford North Conservation Area with three ponds and trails, it offers the best of small-town living while keeping you close to everything you need. Larger centres like Simcoe, Brantford, and Hamilton are just a short drive away, giving you easy access to shopping, healthcare, and major highways while letting you come home to peace and charm. With modern finishes, energy-efficient systems, and fibre-optic internet already in place, 103 Amber Street offers more than just a house—it offers a lifestyle. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Central Vacuum - Roughed In"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:53:13.944073+00:00"
+"Directions": "Take Old Highway 24 and turn onto Amber Street. Continue until reaching property number 103."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"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:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T13:59:19Z"
+"PhotosCount": 28
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T13:59:19Z"
+"Stories": "2.0"
+"StreetName": "AMBER"
+"StreetNumber": "103"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1677313984"
"RoomType" => "Utility room"
"ListingId" => "40845613"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "20'3'' x 10'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.26Z"
]
1 => array:11 [
"RoomKey" => "1677313985"
"RoomType" => "Storage"
"ListingId" => "40845613"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "4'8'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.26Z"
]
2 => array:11 [
"RoomKey" => "1677313986"
"RoomType" => "Other"
"ListingId" => "40845613"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 11'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.26Z"
]
3 => array:11 [
"RoomKey" => "1677313987"
"RoomType" => "Other"
"ListingId" => "40845613"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "28'1'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.26Z"
]
4 => array:11 [
"RoomKey" => "1677313988"
"RoomType" => "Full bathroom"
"ListingId" => "40845613"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 5'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.26Z"
]
5 => array:11 [
"RoomKey" => "1677313989"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845613"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 15'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.26Z"
]
6 => array:11 [
"RoomKey" => "1677313990"
"RoomType" => "Laundry room"
"ListingId" => "40845613"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.27Z"
]
7 => array:11 [
"RoomKey" => "1677313991"
"RoomType" => "4pc Bathroom"
"ListingId" => "40845613"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "5'10'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.27Z"
]
8 => array:11 [
"RoomKey" => "1677313992"
"RoomType" => "Bedroom"
"ListingId" => "40845613"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "14'4'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.27Z"
]
9 => array:11 [
"RoomKey" => "1677313993"
"RoomType" => "Bedroom"
"ListingId" => "40845613"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.27Z"
]
10 => array:11 [
"RoomKey" => "1677313994"
"RoomType" => "Kitchen"
"ListingId" => "40845613"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "17'8'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.27Z"
]
11 => array:11 [
"RoomKey" => "1677313995"
"RoomType" => "Living room"
"ListingId" => "40845613"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "21'6'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.27Z"
]
12 => array:11 [
"RoomKey" => "1677313996"
"RoomType" => "2pc Bathroom"
"ListingId" => "40845613"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.27Z"
]
13 => array:11 [
"RoomKey" => "1677313997"
"RoomType" => "Foyer"
"ListingId" => "40845613"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998239"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:59:19.27Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29998239/103-amber-street-waterford"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R1-B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 31.0
+"AboveGradeFinishedArea": 1787
+"OriginalEntryTimestamp": "2026-07-07T13:59:19.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1457486"
+"ListOfficeNationalAssociationId": "1218974"
+"Media": array:28 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29998239_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998239/2cb80e5f648e779e96cb4b6c3b10bb5f.webp"
"MediaSize" => 115923
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998239/thumbnail-2cb80e5f648e779e96cb4b6c3b10bb5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845613"
"ResourceRecordKey" => "29998239"
"ModificationTimestamp" => "2026-07-07T13:59:19.24Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29998239_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998239/6a2a72e51a538d776a16a7c354690e66.webp"
"MediaSize" => 106877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998239/thumbnail-6a2a72e51a538d776a16a7c354690e66.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845613"
"ResourceRecordKey" => "29998239"
"ModificationTimestamp" => "2026-07-07T13:59:19.24Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29998239_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998239/2ee74c759d83f89a72cf446fbd0276a9.webp"
"MediaSize" => 124902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998239/thumbnail-2ee74c759d83f89a72cf446fbd0276a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845613"
"ResourceRecordKey" => "29998239"
"ModificationTimestamp" => "2026-07-07T13:59:19.24Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29998239_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998239/6490fde1387112a61995f7c3b80c86d7.webp"
"MediaSize" => 34886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998239/thumbnail-6490fde1387112a61995f7c3b80c86d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845613"
"ResourceRecordKey" => "29998239"
"ModificationTimestamp" => "2026-07-07T13:59:19.24Z"
]
4 => array:13 [
"Order" => 5
…12
]
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998239')"
+"ID": "1601042"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25349
+post_id: "1599663"
+post_author: 1
+"ListingKey": "29999811"
+"ListingId": "40845896"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T16:50:07Z"
+"RFModificationTimestamp": "2026-07-07T17:06:32Z"
+"ListPrice": 680000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1460.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "105 VANROOY Trail, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.3002357
1 => 42.927124
]
+"Latitude": 42.927124
+"Longitude": -80.3002357
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to Modern Comfort in Waterford! Step into this beautifully crafted two-bedroom 1460 square foot bungalow. Designed with both elegance and functionality in mind, this home features a modern open concept layout that blends everyday living with effortless entertaining. From the moment you arrive, the full brick exterior and double car garage set a tone of timeless curb appeal. Inside, 9-foot ceilings elevate the sense of space and light, while luxury vinyl flooring offers style and low-maintenance living throughout the main floor. The kitchen is the heart of the home, complete with quartz countertops that continue into both bathrooms for a cohesive, upscale finish. The primary bedroom serves as a private retreat, boasting a walk-in closet and a spa-like three-piece ensuite with dual sinks. The main bathroom has the additional convenience of a bath/shower set-up and the laundry room is conveniently located on the main floor. Additional features include: covered rear deck perfect for relaxing or entertaining, Sliding glass doors leading to the deck area, paved driveway with space for two additional vehicles, fully sodded yard for move-in-ready landscape, 9’ high basement with potential for custom finishing, and exterior entrance directly to the basement. But the home itself is just the beginning. Located in the charming town of Waterford, you’ll enjoy the serenity of small-town living with the convenience of nearby urban amenities. Waterford is surrounded by natural beauty and is only a short drive from Ontario’s South Coast—including Port Dover, Turkey Point, Long Point, and more. This impressive home offers modern comfort, thoughtful upgrades, and exceptional value—all in a location where community, convenience, and nature meet. Don’t miss your chance to call this beautiful property home. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T17:06:18.811712+00:00"
+"Directions": "Travelling North on Washington Street, turn left onto Charles Street, and right onto Vanrooy Trail."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058096"
+"ListOfficeKey": "280719"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T16:43:33Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T16:43:32Z"
+"Stories": "1.0"
+"StreetName": "VANROOY"
+"StreetNumber": "105"
+"StreetSuffix": "Trail"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "5900"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/-BXZZrNzkbQ?feature=share"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
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]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29999811/105-vanrooy-trail-waterford"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 49.0
+"AboveGradeFinishedArea": 1460
+"OriginalEntryTimestamp": "2026-07-07T16:43:32.9Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1333265"
+"ListOfficeNationalAssociationId": "1316868"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999811')"
+"ID": "1599663"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1596524"
+post_author: 1
+"ListingKey": "29993588"
+"ListingId": "40842708"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T16:40:15Z"
+"RFModificationTimestamp": "2026-07-06T19:43:46Z"
+"ListPrice": 529000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.18
+"LivingArea": 1618.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "43 TEMPERANCE Street E, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.288006
1 => 42.9333039
]
+"Latitude": 42.9333039
+"Longitude": -80.288006
+"YearBuilt": 1890
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in Waterford, this 2-storey brick character residence at 43 Temperance Street East sits on a corner lot shaded by mature trees. Built in 1893 and bordered by thoughtful landscaping, the property features a covered side porch and a detached garage, with other attractive character homes in the neighborhood. Inside, you’ll find a spacious living room and formal dining area with high ceilings and original hardwood floors, an eat-in kitchen, and a versatile family room just off the kitchen and at the rear of the home. The main floor also includes a bedroom and a 4-piece bathroom. The upper-level hosts two additional bedrooms, and the basement remains clean and dry with a practical laundry space. Recent upgrades include a comprehensive electrical overhaul (panel, wiring, plugs, switches, and lighting), drywalled ceilings, interior painting throughout (including kitchen cabinets), new carpeting on the stairs and upper level, and new vinyl plank flooring in the kitchen, family room, bathroom, and rear entrance, along with a complete bathroom remodel. Two new overhead garage doors were also installed. Waterford is a welcoming, family-friendly community with excellent schools, an arena, and easy access to shopping, employment, and entertainment hubs. Enjoy the pumpkin festival, local wineries and breweries, the Waterford antique market, Waterford Ponds, and the Waterford Heritage Trail for jogging, walking and cycling. This home is move-in ready and awaiting your personal viewing. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-07-06T19:43:37.886359+00:00"
+"Directions": "Main Street South, Waterford to Temperance Street. Turn east on Temperance Street. Property on the corner of Temperance Street East and Nursery Street."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127441"
+"ListOfficeKey": "289745"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Corner Site"
]
+"LotSizeDimensions": "0.18"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T16:30:26Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T16:30:26Z"
+"Stories": "2.0"
+"StreetDirSuffix": "East"
+"StreetName": "TEMPERANCE"
+"StreetNumber": "43"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "2935.38"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youtu.be/ed-OuMIyjkQ"
+"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/29993588/43-temperance-street-e-waterford"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 65.0
+"AboveGradeFinishedArea": 1618
+"OriginalEntryTimestamp": "2026-07-06T16:30:26.03Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1380672"
+"ListOfficeNationalAssociationId": "1380671"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29993588')"
+"ID": "1596524"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25350
+post_id: "1587589"
+post_author: 1
+"ListingKey": "29981406"
+"ListingId": "40844482"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T22:05:06Z"
+"RFModificationTimestamp": "2026-07-02T22:10:38Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.19
+"LivingArea": 1729.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "168 MONTCLAIR Crescent, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2842208
1 => 42.9310806
]
+"Latitude": 42.9310806
+"Longitude": -80.2842208
+"YearBuilt": 1960
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to 168 Montclair Circle in Waterford, ideally located in town and backing directly onto Waterford Public School. This immaculate brick bungalow with an attached oversized single-car garage offers 3 main-floor bedrooms and 2 full bathrooms, combining comfort, functionality, and thoughtful updates throughout. Perfect for hosting family and friends, the home features ample street parking along with a double-wide concrete and paved driveway, while the spacious garage provides an excellent workspace for hobbyists. Inside, you’ll find gleaming hardwood floors, a bright open-concept kitchen and living area ideal for entertaining, and a large finished basement rec room highlighted by a cozy gas fireplace set against a striking brick feature wall. Extensive recent upgrades include a new furnace and A/C (2024/25), leaf and gutter guards on the eavestroughs (2025), updated lighting throughout the home and garage (2024), a fully renovated 3-piece basement bathroom (2025), new doors in the rec room, laundry room, and basement bath (2025), blackout blinds in the primary bedroom, kitchen, and bathroom (2024), a new kitchen island and pantry (2024), new wood fencing in the backyard (2024), fresh front landscaping with a beach-stone rock bed (2025), a poured concrete pad/deck (2023), gas fireplace (2019), new washer, dryer, and range hood (2024), and the entire home professionally painted in 2024. Simply move in and enjoy this beautifully maintained home. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T22:10:29.335865+00:00"
+"Directions": "Thompson Road East, Waterford to Duncombe Road. Turn north. Pass the first access to Montclair Cres on left, continuing north to the second access point. Turn west onto Montclair Cres., property on north side of road."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964570"
+"ListOfficeKey": "289711"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.19"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T20:55:16Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:55:19Z"
+"Stories": "1.0"
+"StreetName": "MONTCLAIR"
+"StreetNumber": "168"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "3478"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/WaUOrL8Iyio?si=rwdWCWbzlT0Y0BWi"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29981406/168-montclair-crescent-waterford"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 71.0
+"AboveGradeFinishedArea": 993
+"BelowGradeFinishedArea": 736
+"OriginalEntryTimestamp": "2026-07-02T20:55:15.27Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1253211"
+"ListOfficeNationalAssociationId": "1380321"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981406')"
+"ID": "1587589"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25348
+post_id: "1587590"
+post_author: 1
+"ListingKey": "29981418"
+"ListingId": "X13515234"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T12:20:33Z"
+"RFModificationTimestamp": "2026-07-06T14:01:49Z"
+"ListPrice": 1039900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Norfolk (Waterford)"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "270 CHARLES STREET, Norfolk (Waterford), Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2981234
1 => 42.9248313
]
+"Latitude": 42.9248313
+"Longitude": -80.2981234
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "270 Charles St is a custom-built bungalow in Waterfords Cedar Park community, completed in 2023. The home offers over 3,200 sq ft of finished living space, with 4 bedrooms, 3 bathrooms, and 2 kitchens, including a full in-law suite with a separate entrance. The main floor features a quartz kitchen with centre island, a great room with gas fireplace, and a primary bedroom with ensuite and laundry. The lower level includes 2 bedrooms, a full bath, family room, and second kitchen, with access through the double garage. Additional features include remote-controlled blinds, a covered rear patio, and a private backyard. The property is located minutes from Waterford Ponds, Heritage Trails, and downtown shops. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Blinds"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T21:45:05.558748+00:00"
+"Directions": "Cross Streets: Washington Street. ** Directions: Cockshutt Road > Thompson Road West > Washington Street > Charles Street."
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1963790"
+"ListOfficeKey": "284787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Carpet Free"
2 => "In-Law Suite"
]
+"LotSizeDimensions": "42.2 x 129.3 FT ; 129.29 x 89.01 x 113.64 x 42.22 ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T20:56:12Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T12:14:39Z"
+"Stories": "1.0"
+"StreetName": "Charles"
+"StreetNumber": "270"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5382.3"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=D5-Z1U35Dso"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Waterford"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29981418/270-charles-street-norfolk-waterford-waterford"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1-A"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 42.2
+"OriginalEntryTimestamp": "2026-07-02T20:56:12.09Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1252736"
+"ListOfficeNationalAssociationId": "1344854"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29981418')"
+"ID": "1587590"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25343
+post_id: "1587591"
+post_author: 1
+"ListingKey": "29980957"
+"ListingId": "40836029"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T20:30:08Z"
+"RFModificationTimestamp": "2026-07-05T20:41:45Z"
+"ListPrice": 1039900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3205.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "270 CHARLES Street, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2981225
1 => 42.9248392
]
+"Latitude": 42.9248392
+"Longitude": -80.2981225
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "An absolute Stunner! 270 Charles St is a custom built bungalow in scenic Waterford, where modern elegance meets small-town soul. Boasting 4 Bedrooms, 3 baths and 2 Kitchens, this tailor-made residence was built in 2023 and is nestled in the brand-new Cedar Park community. Enjoy over 3,200 sq ft of luxe living from top to bottom, with the distinct advantage of a full In Law Suite. Step inside and immediately be captivated by the gourmet quartz kitchen with centre island opening up to a great room with exquisitely tiled gas fireplace. Remote controlled blinds cover gorgeous windows overlooking your rear covered patio and private backyard. Main floor primary Bedroom with elegant ensuite paired with convenient main floor laundry creates the ultimate in everyday ease. The lower level is just as exceptional! Another gorgeous kitchen, two bedrooms, family room and full bathroom along with a completely separate entrance leading out through the massive double garage. Minutes from Waterford Ponds, Heritage Trails, and downtown shops. This residence unites everything you've been longing for, refined in every exquisite detail. Don't wait to start living your best life in this beautiful community! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T20:30:50.724972+00:00"
+"Directions": "Cockshutt Road > Thompson Road West > Washington Street > Charles Street"
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Stucco"
2 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1938787"
+"ListOfficeKey": "284641"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
3 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:53:24Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T20:20:27Z"
+"Stories": "1.0"
+"StreetName": "CHARLES"
+"StreetNumber": "270"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "5382.3"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=D5-Z1U35Dso"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29980957/270-charles-street-waterford"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1991321"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "262664"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 1605
+"BelowGradeFinishedArea": 1600
+"OriginalEntryTimestamp": "2026-07-02T19:53:23.23Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1236676"
+"ListOfficeNationalAssociationId": "1344650"
+"CoListAgentNationalAssociationId": "1274907"
+"CoListOfficeNationalAssociationId": "1223042"
+"Media": array:49 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29980957')"
+"ID": "1587591"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1587592"
+post_author: 1
+"ListingKey": "29977560"
+"ListingId": "40844133"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T14:35:14Z"
+"RFModificationTimestamp": "2026-07-02T18:08:42Z"
+"ListPrice": 899900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2974.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "192 GIBBONS Street, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2960849
1 => 42.9425131
]
+"Latitude": 42.9425131
+"Longitude": -80.2960849
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to this exquisite 2-storey home nestled in the charming town of Waterford—where timeless elegance meets modern luxury. Meticulously crafted and beautifully maintained, this stunning residence seamlessly blends contemporary design with refined comfort. The thoughtfully designed open-concept main floor provides effortless flow between the kitchen, dining area, and living room—an ideal layout for both everyday living and unforgettable entertaining. At the heart of the home is the chef-inspired kitchen, a true showstopper designed to impress. Featuring a spacious centre island with seating, sleek quartz countertops, a classic subway tile backsplash, premium stainless steel appliances, under-mount lighting, and refined crown moldings, this kitchen combines beauty and functionality in every detail. Whether preparing family meals or hosting guests, this space is sure to inspire. The living room exudes warmth and style with its striking stone-surround gas fireplace—perfect for cozy evenings—while the dining area offers sliding glass doors that lead to a covered deck, extending your living space outdoors for effortless indoor-outdoor entertaining. The fully finished lower level adds exceptional versatility, offering a spacious recreation room, convenient kitchenette, additional bedroom, and 2-piece bathroom—making it perfectly suited for an in-law suite or multi-generational living arrangement. Step outside to a fully fenced backyard designed for both relaxation and recreation. With ample space for entertaining, gardening, or letting children and pets play freely, this private outdoor retreat truly enhances the home’s appeal. The property also features an updated aggregate driveway, eye-catching glow-in-the-dark safety stones on the steps for added nighttime visibility, and a concrete and turf enclosed dog run—designed with both style and practicality in mind. Luxury living in a welcoming community, don’t miss this rare opportunity! Some photos virtually staged. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Central Vacuum - Roughed In"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:50:56.426345+00:00"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2174157"
+"ListOfficeKey": "280719"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T14:25:13Z"
+"PhotosCount": 27
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T14:25:12Z"
+"Stories": "2.0"
+"StreetName": "GIBBONS"
+"StreetNumber": "192"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "5901.65"
+"VirtualTourURLUnbranded": "https://youtu.be/ejF0qJh3r4c"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29977560/192-gibbons-street-waterford"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2184461"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "280719"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-B"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2217
+"BelowGradeFinishedArea": 757
+"OriginalEntryTimestamp": "2026-07-02T14:25:12.91Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1424546"
+"ListOfficeNationalAssociationId": "1316868"
+"CoListAgentNationalAssociationId": "1434034"
+"CoListOfficeNationalAssociationId": "1316868"
+"Media": array:27 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977560')"
+"ID": "1587592"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25351
+post_id: "1579218"
+post_author: 1
+"ListingKey": "29970410"
+"ListingId": "40842500"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T19:20:03Z"
+"RFModificationTimestamp": "2026-07-03T19:34:35Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1351.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "122 TEMPERANCE Street W, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2952965
1 => 42.9315659
]
+"Latitude": 42.9315659
+"Longitude": -80.2952965
+"YearBuilt": 1969
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 122 Temperance Street, conveniently located in the heart of Waterford, Ontario. This affordable home has just hit the market and has endless potential, located just steps from the downtown core and waterfront, where you can enjoy everything Waterford has to offer, including shopping, local brewery, food trucks, antique shops, paddleboarding, scenic walking and biking trails, and so much more. This charming home offers three bedrooms, two bathrooms, and a traditional main floor layout featuring a spacious eat-in kitchen, a generous dining room, and living room and a convenient mudroom with access to the rear deck. The lower level boasts great potential with a large recreation room and includes rough-ins for a second kitchen, offering excellent potential for extended family living or additional convenience. Step outside to discover beautifully landscaped grounds featuring mature perennial gardens, interlocking brick walkways, wooden trellises, and a private rear deck off the mudroom. The gardens have been lovingly maintained for many years and were once proudly featured on the Waterford Garden Tour, making this property a true gardener's delight. Don't miss this affordable opportunity to own a home with great potential in one of Waterford's most desirable and walkable locations. Immediate possession available. (id:62650)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Microwave"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-30T16:59:29.485556+00:00"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2257405"
+"ListOfficeKey": "289745"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"PhotosChangeTimestamp": "2026-07-03T19:12:29Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T19:18:36Z"
+"Stories": "1.0"
+"StreetDirSuffix": "West"
+"StreetName": "TEMPERANCE"
+"StreetNumber": "122"
+"StreetSuffix": "Street"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "3181.57"
+"Utilities": array:1 [
0 => "Natural Gas"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29970410/122-temperance-street-w-waterford"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 1351
+"OriginalEntryTimestamp": "2026-06-30T15:31:46.19Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1496236"
+"ListOfficeNationalAssociationId": "1380671"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29970410')"
+"ID": "1579218"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25352
+post_id: "1566675"
+post_author: 1
+"ListingKey": "29946805"
+"ListingId": "40842694"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T18:55:17Z"
+"RFModificationTimestamp": "2026-07-07T19:09:47Z"
+"ListPrice": 635000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.217
+"LivingArea": 1480.0
+"BuildingAreaTotal": 0
+"City": "Waterford"
+"PostalCode": "N0E1Y0"
+"UnparsedAddress": "10 BALTIC Circle, Waterford, Ontario N0E1Y0"
+"Coordinates": array:2 [
0 => -80.2846599
1 => 42.9275516
]
+"Latitude": 42.9275516
+"Longitude": -80.2846599
+"YearBuilt": 1989
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "10 Baltic Circle is a bungalow built circa 1989, tucked away in a quiet cul-de-sac in the charming town of Waterford, Ontario. This home is a classic all-brick bungalow with an attached single car garage and a fully fenced backyard. Main floor features include 3 bedrooms, an ensuite 3-piece bathroom, a common 4-piece bathroom, living room w/doors to the back deck, a formal dining room, a fully renovated kitchen and main floor laundry. There is access to the garage, as well as a side entrance to the home. There's potential for a seperate family residence in the basement. There's a large rec-room area, an entertainment/quiet room, a 2-piece bathroom, a large utility room and additional living space that could be converted to another bedroom or office space. Updates to this home include, new windows (Dayside Windows w/35 year transferrable warranty), leaf guards for the eavestroughs, water softener (owned) approx. 2 years old, pool heater (owned) approx. 3 years old. Outside is where you will want to live this summer. Enjoy the large composite deck, the above ground pool! It's the perfect place for family gatherings. There's also a small pond with goldfish, a storage shed with a playhouse on the top and a side yard with artificial turf. If you love Waterford and everything Norfolk County has to offer, we are sure 10 Baltic Circle will be the place for you and your family to enjoy all the days of your lives. Book your viewing today! Write your offer and make this your new home. (id:62650)"
+"Appliances": array:1 [
0 => "Central Vacuum"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T02:47:51.953588+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1585148"
+"ListOfficeKey": "48563"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Cul-de-sac"
]
+"LotSizeDimensions": "0.217"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T00:52:11Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T18:49:03Z"
+"Stories": "1.0"
+"StreetName": "BALTIC"
+"StreetNumber": "10"
+"StreetSuffix": "Circle"
+"SubdivisionName": "Waterford"
+"TaxAnnualAmount": "4234"
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=B5LXkfXhims"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29946805/10-baltic-circle-waterford"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1480
+"OriginalEntryTimestamp": "2026-06-24T15:50:41.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1152484"
+"ListOfficeNationalAssociationId": "1004257"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29946805')"
+"ID": "1566675"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 42
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]