array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29964041 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1574580"
+post_author: 1
+"ListingKey": "29964041"
+"ListingId": "40843641"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T17:00:25Z"
+"RFModificationTimestamp": "2026-06-30T17:06:17Z"
+"ListPrice": 1499000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 3.0
+"LivingArea": 1882.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A3G9"
+"UnparsedAddress": "1814 NAFZIGER Road, New Hamburg, Ontario N3A3G9"
+"Coordinates": array:2 [
0 => -80.7052508
1 => 43.4067733
]
+"Latitude": 43.4067733
+"Longitude": -80.7052508
+"YearBuilt": 1980
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to “RIVERBEND” — a truly one-of-a-kind riverside retreat nestled on a breathtaking 3-acre property just minutes from New Hamburg, and only 10 minutes to Kitchener-Waterloo. With over 750 feet of frontage along the Nith River, this spectacular property offers the perfect blend of privacy, nature, recreation, and modern comfort. If you’re searching for a peaceful family home and entertainer’s paradise, 'Riverbend' delivers a lifestyle rarely offered this close to the city. The beautifully updated 2-storey home features 3 bedrooms, 2.5 bathrooms, and finished basement with a large cold room. The spacious primary suite includes a walk-through closet and private 3-piece ensuite. The home is completely carpet-free and extensively renovated throughout with luxury vinyl flooring, updated bathrooms, lighting, trim, doors, paint, and more. The stunning kitchen was fully upgraded in 2021 with new cooktop, wall oven, refrigerator, microwave, and dishwasher. Step outside and experience your own private outdoor oasis. Explore the property trails through hundreds of trees, launch a kayak or canoe directly from your property, or unwind beside the riverside bonfire pit under the stars. The professionally landscaped gardens showcase countless perennials, flowering shrubs, and ornamental trees. The backyard was also designed for entertaining with a stunning two-level deck (2022) featuring hard plumbed BBQ propane, multiple electrical circuits, a large gazebo with metal roof and lighting, and a 7-person 'step-in' hot tub overlooking the river. Additional highlights include climatized double garage, ample parking, covered front porch, insulated and wired “She Shed” perfect for a home office or playhouse, storage shed, UV water system, and efficient electric heat pump/AC system. Properties like this are exceptionally rare. A true Muskoka-like setting without leaving Waterloo Region. Must be experienced in person to fully appreciate what Riverbend has to offer! (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Freezer"
9 => "Hood Fan"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T18:45:10.047546+00:00"
+"Directions": "Snyders Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:4 [
0 => "Wood"
1 => "Wood"
2 => "Other - See remarks"
3 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:5 [
0 => "Stove"
1 => "Forced air"
2 => "Space Heater"
3 => "Electric"
4 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1908116"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Crushed stone driveway"
2 => "Country residential"
]
+"LotSizeDimensions": "3"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-28T17:39:33Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T16:51:33Z"
+"Stories": "2.0"
+"StreetName": "NAFZIGER"
+"StreetNumber": "1814"
+"StreetSuffix": "Road"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "7977.85"
+"Utilities": array:1 [
0 => "Cable"
]
+"View": "River view"
+"VirtualTourURLUnbranded": "https://youriguide.com/1814_nafziger_rd_new_hamburg_on"
+"WaterBodyName": "Nith River"
+"WaterSource": array:2 [
0 => "Bored Well"
1 => "Well"
]
+"Rooms": array:11 [
0 => array:11 [
"RoomKey" => "1671989832"
"RoomType" => "Full bathroom"
"ListingId" => "40843641"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.08Z"
]
1 => array:11 [
"RoomKey" => "1671989833"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843641"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.08Z"
]
2 => array:11 [
"RoomKey" => "1671989834"
"RoomType" => "Bedroom"
"ListingId" => "40843641"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.08Z"
]
3 => array:11 [
"RoomKey" => "1671989835"
"RoomType" => "Bedroom"
"ListingId" => "40843641"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => "14'0'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.09Z"
]
4 => array:11 [
"RoomKey" => "1671989836"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843641"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.09Z"
]
5 => array:11 [
"RoomKey" => "1671989837"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843641"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.09Z"
]
6 => array:11 [
"RoomKey" => "1671989838"
"RoomType" => "Family room"
"ListingId" => "40843641"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 20'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.09Z"
]
7 => array:11 [
"RoomKey" => "1671989839"
"RoomType" => "Sitting room"
"ListingId" => "40843641"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.09Z"
]
8 => array:11 [
"RoomKey" => "1671989840"
"RoomType" => "Kitchen"
"ListingId" => "40843641"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => "16'2'' x 15'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.09Z"
]
9 => array:11 [
"RoomKey" => "1671989841"
"RoomType" => "Dining room"
"ListingId" => "40843641"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.09Z"
]
10 => array:11 [
"RoomKey" => "1671989842"
"RoomType" => "Recreation room"
"ListingId" => "40843641"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964041"
"RoomLength" => null
"RoomDimensions" => "23'2'' x 25'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T16:51:33.09Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964041/1814-nafziger-road-new-hamburg"
+"ParkingTotal": 20
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Security system"
]
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on river"
]
+"FrontageLengthNumeric": 597.0
+"AboveGradeFinishedArea": 1882
+"OriginalEntryTimestamp": "2026-06-28T17:39:32.99Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1221116"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29964041_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/bf8f1104cd43944e681d67f4d692a8cb.webp"
"MediaSize" => 115719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-bf8f1104cd43944e681d67f4d692a8cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29964041_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/1e3274fa552e8eb163740db6e18bde62.webp"
"MediaSize" => 156890
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-1e3274fa552e8eb163740db6e18bde62.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29964041_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/70950ccf8da668185dc378c481993b1a.webp"
"MediaSize" => 173578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-70950ccf8da668185dc378c481993b1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29964041_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/ca02d09845ed0f85b02f4195f95028fe.webp"
"MediaSize" => 206838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-ca02d09845ed0f85b02f4195f95028fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29964041_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/3de01e5e7dd99dbb8b4db50ad0769d87.webp"
"MediaSize" => 145177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-3de01e5e7dd99dbb8b4db50ad0769d87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29964041_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/01c822b7ae53f8ef6b16f502b15274c4.webp"
"MediaSize" => 226300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-01c822b7ae53f8ef6b16f502b15274c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29964041_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/23e4b78f34d4679d84928346173041dd.webp"
"MediaSize" => 79855
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-23e4b78f34d4679d84928346173041dd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29964041_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/529a84a21da8e0a66e9f46d150b7b3af.webp"
"MediaSize" => 113757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-529a84a21da8e0a66e9f46d150b7b3af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29964041_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/bd4ba9c7d17a6d7e510a42b4a00ee13e.webp"
"MediaSize" => 119074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-bd4ba9c7d17a6d7e510a42b4a00ee13e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29964041_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/8f8e9aa7cd8d88ecb1b1cb98b50bb64e.webp"
"MediaSize" => 71352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-8f8e9aa7cd8d88ecb1b1cb98b50bb64e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29964041_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/13d733080d7c569e35a569c6b53ac6a6.webp"
"MediaSize" => 68721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-13d733080d7c569e35a569c6b53ac6a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29964041_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/f330e42549e8fc094efd551478cc6e97.webp"
"MediaSize" => 102288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-f330e42549e8fc094efd551478cc6e97.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29964041_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/d64a0dc683b50907ff2dba8646ca392c.webp"
"MediaSize" => 52204
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-d64a0dc683b50907ff2dba8646ca392c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29964041_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/dd3106147a51f5b474e5e2a92cde09a5.webp"
"MediaSize" => 71312
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-dd3106147a51f5b474e5e2a92cde09a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29964041_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/a3bf481798970378e7015621518371cc.webp"
"MediaSize" => 75132
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-a3bf481798970378e7015621518371cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29964041_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/19cce611ba9b4f625f9f15b28acf5e4e.webp"
"MediaSize" => 79146
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-19cce611ba9b4f625f9f15b28acf5e4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29964041_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/88671faad99b20d6ad4c34ccdcb0a8fc.webp"
"MediaSize" => 83964
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-88671faad99b20d6ad4c34ccdcb0a8fc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29964041_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/f66b0e5ce0791a6faca5459d0c56c873.webp"
"MediaSize" => 74773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-f66b0e5ce0791a6faca5459d0c56c873.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29964041_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/bfb53cbc070140a5b184185bdea92c58.webp"
"MediaSize" => 79442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-bfb53cbc070140a5b184185bdea92c58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29964041_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/9a886b66fbcca0138fc39969f3d5fe7e.webp"
"MediaSize" => 85601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-9a886b66fbcca0138fc39969f3d5fe7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29964041_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/cdd47a9e3328914168959bb0032114cf.webp"
"MediaSize" => 85903
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-cdd47a9e3328914168959bb0032114cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29964041_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/801789a0dfd436a361e2b0e1b3e08ef3.webp"
"MediaSize" => 36398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-801789a0dfd436a361e2b0e1b3e08ef3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29964041_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/17e1fcfd48ffcfc7d48b9ddd8c45dbb2.webp"
"MediaSize" => 70934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-17e1fcfd48ffcfc7d48b9ddd8c45dbb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29964041_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/63da67d00e432a837cea1b8c19bfa82b.webp"
"MediaSize" => 86015
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-63da67d00e432a837cea1b8c19bfa82b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29964041_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/2942c23ecb631402b010e5a394dbc3ea.webp"
"MediaSize" => 101752
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-2942c23ecb631402b010e5a394dbc3ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29964041_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/0865fc5009ccd4c1e317ce9bf173bde0.webp"
"MediaSize" => 108762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-0865fc5009ccd4c1e317ce9bf173bde0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29964041_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/2f3f5ba1119b45bb3a778fc9f3672145.webp"
"MediaSize" => 197179
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-2f3f5ba1119b45bb3a778fc9f3672145.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29964041_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/cda6306ed873baed3c2ce65c5388840e.webp"
"MediaSize" => 205443
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-cda6306ed873baed3c2ce65c5388840e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29964041_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/f2c4fe18aae721bbe42a6c3b321aec68.webp"
"MediaSize" => 104320
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-f2c4fe18aae721bbe42a6c3b321aec68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29964041_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/edfdd5a9580224287458c4351e538282.webp"
"MediaSize" => 108858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-edfdd5a9580224287458c4351e538282.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29964041_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/b65305a4f2bff68f06a66af84735f0a0.webp"
"MediaSize" => 147192
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-b65305a4f2bff68f06a66af84735f0a0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29964041_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/3d7dfa4365b3a5b6207de20ec6e75d89.webp"
"MediaSize" => 199031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-3d7dfa4365b3a5b6207de20ec6e75d89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29964041_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/93a46e06eeb6a061b0782c55d0b67866.webp"
"MediaSize" => 170403
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-93a46e06eeb6a061b0782c55d0b67866.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29964041_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/71f24ba072cd7b81c92cccf35d410a43.webp"
"MediaSize" => 204880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-71f24ba072cd7b81c92cccf35d410a43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29964041_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/c28ed3f7a94c2e45fdd37bcae2bd1bb0.webp"
"MediaSize" => 199017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-c28ed3f7a94c2e45fdd37bcae2bd1bb0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29964041_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/aaaadb8d8224363df55b6f2ecc2cdb8d.webp"
"MediaSize" => 178361
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-aaaadb8d8224363df55b6f2ecc2cdb8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29964041_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/d0b05809082c5b5b40df5dda803ef412.webp"
"MediaSize" => 164107
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-d0b05809082c5b5b40df5dda803ef412.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29964041_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/ebd5fe83e2d0b002bf8c2da29e6f154c.webp"
"MediaSize" => 210489
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-ebd5fe83e2d0b002bf8c2da29e6f154c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29964041_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/e2a8b8368a7da91bc224733dbafd325b.webp"
"MediaSize" => 190319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-e2a8b8368a7da91bc224733dbafd325b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29964041_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/a3e5a32aa6bfd49135b65cac0733dcb5.webp"
"MediaSize" => 181433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-a3e5a32aa6bfd49135b65cac0733dcb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29964041_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/bb518b5efbfeef8d00210e41c7feeb31.webp"
"MediaSize" => 181780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-bb518b5efbfeef8d00210e41c7feeb31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29964041_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/9928ab0a078c9dc820b6b8cc2edb0f63.webp"
"MediaSize" => 234211
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-9928ab0a078c9dc820b6b8cc2edb0f63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29964041_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/f375dc6ef49b5a54dd04c13a2ad055db.webp"
"MediaSize" => 128376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-f375dc6ef49b5a54dd04c13a2ad055db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29964041_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/5f00d5593233e8d834a46805317171cc.webp"
"MediaSize" => 94546
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-5f00d5593233e8d834a46805317171cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29964041_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/ed9fe1d19a1d4b122020dcde201d0ff1.webp"
"MediaSize" => 83938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-ed9fe1d19a1d4b122020dcde201d0ff1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29964041_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/db4e39798ebac7bbac5a69ca1219c2c5.webp"
"MediaSize" => 78713
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-db4e39798ebac7bbac5a69ca1219c2c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29964041_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964041/c06cce5bacd9628a6fa3929654bddd51.webp"
"MediaSize" => 110233
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964041/thumbnail-c06cce5bacd9628a6fa3929654bddd51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843641"
"ResourceRecordKey" => "29964041"
"ModificationTimestamp" => "2026-06-28T17:39:32.99Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964041')"
+"ID": "1574580"
}
]
+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 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24881
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1908116" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24872
+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 '29964041'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25282
+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 '29964041'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25298
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29964041' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7052508 43.4067733)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25369
+items: array:7 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25365
+post_id: "1582054"
+post_author: 1
+"ListingKey": "29974182"
+"ListingId": "40842905"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T01:20:05Z"
+"RFModificationTimestamp": "2026-07-01T01:41:14Z"
+"ListPrice": 850000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2233.0
+"BuildingAreaTotal": 0
+"City": "Baden"
+"PostalCode": "N3A3P8"
+"UnparsedAddress": "11 SUN VALLEY Drive, Baden, Ontario N3A3P8"
+"Coordinates": array:2 [
0 => -80.6944985
1 => 43.4149802
]
+"Latitude": 43.4149802
+"Longitude": -80.6944985
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the highly desirable Foxboro Green Adult Lifestyle Community, a countryside setting, beautifully nestled beside Foxwood Golf Course. This inviting “Willow” model offers comfortable, carpet-free living across 1514 sq ft, with 2 bedrooms, 3 bathrooms, and serene views of green space. You will appreciate the upgraded fibreglass front door with decorative lite and a convenient swinging sidelite for easy access when moving larger items. Inside, luxury vinyl and Brazilian tigerwood flooring flow throughout, complementing elegant living and dining areas with soaring cathedral ceilings. The open-concept layout includes a beautifully remodelled kitchen (approx. 2022) with duo-tone cabinetry, under/over-cabinet lighting, a breakfast bar, and a bright dining area that opens onto a spacious deck—perfect for enjoying peaceful views and mature gardens. The main floor features a generous primary suite with walk-through vanity area, walk-in closet, and pocket door access to a 3-piece ensuite. A second bedroom makes an ideal home office, with a 4-piece main bath and convenient main floor laundry area completing the level. Downstairs, discover a spacious family/reading room with bookshelves, Media Room with glass panel doors and projector, 3-piece bath, fitness/flex space, ample storage, and a cold/wine cellar. Additional highlights include: whole home electrical surge suppressor; HRV for fresh air circulation; plus UV window film and California shutters for energy efficiency and sun protection. Enjoy full access to the Foxboro Green amenities with indoor pool, sauna, whirlpool, tennis/pickleball courts, gym, party room, craft room, woodworking shop, library, a servery area, as well as a large salon for activities and private functions. Stroll the 4.5 km of walking trails with pond and waterfall on the manicured grounds. Just 10 minutes to Waterloo, Costco, and The Boardwalk, plus close to medical facilities. Live the lifestyle you've been waiting for...at Foxboro Green. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Microwave Built-in"
]
+"AssociationFee": "337"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Common Area Maintenance"
1 => "Property Management"
2 => "Water"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-01T01:41:05.385135+00:00"
+"Directions": "Enter off Erb's Rd. between Foxboro Green Golf Course and Philipsburg."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Propane"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976313"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:7 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
4 => "Country residential"
5 => "Sump Pump"
6 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T01:12:11Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T01:12:11Z"
+"Stories": "1.0"
+"StreetName": "SUN VALLEY"
+"StreetNumber": "11"
+"StreetSuffix": "Drive"
+"SubdivisionName": "666 - Foxboro"
+"TaxAnnualAmount": "5092"
+"VirtualTourURLUnbranded": "https://youriguide.com/11_sun_valley_drive_foxboro_on/"
+"WaterSource": array:1 [
0 => "Community Water System"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1672366049"
"RoomType" => "Bonus Room"
"ListingId" => "40842905"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "19'3'' x 25'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.12Z"
]
1 => array:11 [
"RoomKey" => "1672366050"
"RoomType" => "Recreation room"
"ListingId" => "40842905"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "18'3'' x 20'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.12Z"
]
2 => array:11 [
"RoomKey" => "1672366051"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842905"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 8'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.12Z"
]
3 => array:11 [
"RoomKey" => "1672366052"
"RoomType" => "Family room"
"ListingId" => "40842905"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "17'4'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.13Z"
]
4 => array:11 [
"RoomKey" => "1672366053"
"RoomType" => "Bedroom"
"ListingId" => "40842905"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "12'8'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.13Z"
]
5 => array:11 [
"RoomKey" => "1672366054"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842905"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.13Z"
]
6 => array:11 [
"RoomKey" => "1672366055"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842905"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "14'3'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.13Z"
]
7 => array:11 [
"RoomKey" => "1672366056"
"RoomType" => "3pc Bathroom"
"ListingId" => "40842905"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.13Z"
]
8 => array:11 [
"RoomKey" => "1672366057"
"RoomType" => "Laundry room"
"ListingId" => "40842905"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "7'0'' x 7'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.13Z"
]
9 => array:11 [
"RoomKey" => "1672366058"
"RoomType" => "Kitchen"
"ListingId" => "40842905"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.13Z"
]
10 => array:11 [
"RoomKey" => "1672366059"
"RoomType" => "Dining room"
"ListingId" => "40842905"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.13Z"
]
11 => array:11 [
"RoomKey" => "1672366060"
"RoomType" => "Living room"
"ListingId" => "40842905"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29974182"
"RoomLength" => null
"RoomDimensions" => "15'9'' x 23'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-01T01:12:11.13Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29974182/11-sun-valley-drive-baden"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "Z1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 0.0
+"AboveGradeFinishedArea": 1514
+"BelowGradeFinishedArea": 719
+"OriginalEntryTimestamp": "2026-07-01T01:12:11.07Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1262777"
+"ListOfficeNationalAssociationId": "1473831"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29974182_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/24eb0fbe99a531d83d89a0c3c1f7fd51.webp"
"MediaSize" => 153339
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-24eb0fbe99a531d83d89a0c3c1f7fd51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Nicely landscaped with excellent curb appeal"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29974182_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/79e349e001e378dbcc836b828c27cb44.webp"
"MediaSize" => 148208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-79e349e001e378dbcc836b828c27cb44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "double drive, double car(t) garage."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29974182_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/b6895f58b50e357f71ffd17ca4c60f5f.webp"
"MediaSize" => 131000
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-b6895f58b50e357f71ffd17ca4c60f5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Welcoming front entry. Magic screen concealed."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29974182_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/ac88de88fb482d30f25e392fb59962af.webp"
"MediaSize" => 74741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-ac88de88fb482d30f25e392fb59962af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Upgraded fibreglass front entry, with swinging sidelite."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29974182_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/836d2a439b34361a565f1f5a7b2aa88a.webp"
"MediaSize" => 64027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-836d2a439b34361a565f1f5a7b2aa88a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Abundant natural light."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29974182_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/3cdeb8d95ea9a0679b3023baaf5036ca.webp"
"MediaSize" => 86512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-3cdeb8d95ea9a0679b3023baaf5036ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29974182_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/890948b94ff7f78ace960f0d1e0fe104.webp"
"MediaSize" => 77859
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-890948b94ff7f78ace960f0d1e0fe104.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gleaming Brazilian tigerwood."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29974182_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/3c5562b55350eeb04ddbe93f196fb34f.webp"
"MediaSize" => 85140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-3c5562b55350eeb04ddbe93f196fb34f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Cathedral ceilings with pot lights."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29974182_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/a48b6d64d749fbcd0beb2acf35221022.webp"
"MediaSize" => 64856
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-a48b6d64d749fbcd0beb2acf35221022.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open concept to kitchen."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29974182_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/2d5178b34fb1d9ee29e15985faf5feef.webp"
"MediaSize" => 71088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-2d5178b34fb1d9ee29e15985faf5feef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Natural gas fireplace, big window and slider to deck."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29974182_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/3309e6d54221a5308291701f433f0eeb.webp"
"MediaSize" => 67921
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-3309e6d54221a5308291701f433f0eeb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Duo-tone cabinets are sharp!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29974182_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/d37653951a4d79856d75bee99d3681ac.webp"
"MediaSize" => 74476
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-d37653951a4d79856d75bee99d3681ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29974182_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/cac8f57a0147f0780ed0b97cf0324a01.webp"
"MediaSize" => 66875
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-cac8f57a0147f0780ed0b97cf0324a01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "breakfast bar at counter--just add stools."
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842905"
"ResourceRecordKey" => "29974182"
"ModificationTimestamp" => "2026-07-01T01:12:11.08Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29974182_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29974182/4bb69236fc8fac87d3403692edfd8254.webp"
"MediaSize" => 64991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29974182/thumbnail-4bb69236fc8fac87d3403692edfd8254.webp"
"ResourceName" => "Property"
…6
]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29974182')"
+"ID": "1582054"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25367
+post_id: "1566566"
+post_author: 1
+"ListingKey": "29954380"
+"ListingId": "40842921"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-01T03:50:08Z"
+"RFModificationTimestamp": "2026-07-01T03:55:04Z"
+"ListPrice": 897500.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.16
+"LivingArea": 1941.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A2G8"
+"UnparsedAddress": "258 LASCHINGER Boulevard, New Hamburg, Ontario N3A2G8"
+"Coordinates": array:2 [
0 => -80.7056486
1 => 43.3910195
]
+"Latitude": 43.3910195
+"Longitude": -80.7056486
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional custom-built family home by renowned builder Frank Reis, perfectly situated on a premium lot in one of the area's most sought-after mature subdivisions. Offering timeless craftsmanship, modern comfort, and an outstanding location, this impressive 4-bedroom residence is designed for everyday family living and elegant entertaining. Backing onto open farmland, this beautifully landscaped property offers exceptional privacy with mature cedar hedges, towering trees, fragrant lilacs, and stunning perennial beds that create a true backyard oasis. Nature lovers will appreciate being just steps from Laschinger Woods walking trails and minutes from Schout Wetlands and the extensive Wilmot trail system. Inside, superior quality shows throughout: warm designer taupe decor, rounded bull-nose corners, rich oak hardwood flooring, custom oak cabinetry, and an elegant oak staircase. The sun-filled gourmet kitchen is the heart of the home, featuring a spacious centre island, abundant custom cabinetry, and quality finishes, perfect for family gatherings and entertaining. The main floor offers a spacious great room and dinette area, formal dining room/den/home office, laundry room, and mudroom, plus garage walk down access to the basement. Upstairs, the luxurious primary suite is a peaceful retreat with a walk-in closet and 3 pc ensuite. Three additional bedrooms and a 4 pc bath provide plenty of space for a growing family. Outside, exceptional living spaces await. The exposed aggregate concrete driveway, walkway, and rear patio with room for a hot tub deliver great curb appeal. Enjoy summer evenings under the gazebo on this pool-sized lot, taking in peaceful countryside ambiance. This AAA+ home is a rare opportunity to enjoy executive-quality construction, exceptional privacy, beautiful natural surroundings, and a family-friendly neighbourhood. A remarkable combination of comfort, craftsmanship, and outdoor living, this is the perfect place to call home. (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T00:57:52.569240+00:00"
+"Directions": "TURN LEFT/RIGHT OFF OF WATERLOO ST. ONTO LASCHINGER BLVD. TURN LEFT ONTO LASCHINGER BLVD. AND HOUSE IS ON LEFT A BLOCK UP"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600718"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"LotSizeDimensions": "0.16"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-01T03:40:21Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-01T03:40:21Z"
+"Stories": "2.0"
+"StreetName": "LASCHINGER"
+"StreetNumber": "258"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "5713"
+"VirtualTourURLUnbranded": "https://youriguide.com/258_laschinger_blvd_new_hamburg_on/"
+"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/29954380/258-laschinger-boulevard-new-hamburg"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 56.0
+"AboveGradeFinishedArea": 1941
+"OriginalEntryTimestamp": "2026-06-25T19:50:38.28Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1146794"
+"ListOfficeNationalAssociationId": "1389824"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954380')"
+"ID": "1566566"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25364
+post_id: "1565076"
+post_author: 1
+"ListingKey": "29954992"
+"ListingId": "X13490962"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T21:30:12Z"
+"RFModificationTimestamp": "2026-06-25T23:29:06Z"
+"ListPrice": 897500.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A2G8"
+"UnparsedAddress": "258 LASCHINGER BOULEVARD, Wilmot, Ontario N3A2G8"
+"Coordinates": array:2 [
0 => -80.705622
1 => 43.390879
]
+"Latitude": 43.390879
+"Longitude": -80.705622
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this exceptional custom-built family home by renowned builder Frank Reis, perfectly situated on a premium lot in one of the area's most sought-after mature subdivisions. Offering timeless craftsmanship, modern comfort, and an outstanding location, this impressive 4-bedroom residence is designed for everyday family living and elegant entertaining. Backing onto open farmland, this beautifully landscaped property offers exceptional privacy with mature cedar hedges, towering trees, fragrant lilacs, and stunning perennial beds that create a true backyard oasis. Nature lovers will appreciate being just steps from Laschinger Woods walking trails and minutes from Schout Wetlands and the extensive Wilmot trail system. Inside, superior quality shows throughout: warm designer taupe decor, rounded bull-nose corners, rich oak hardwood flooring, custom oak cabinetry, and an elegant oak staircase. The sun-filled gourmet kitchen is the heart of the home, featuring a spacious centre island, abundant custom cabinetry, and quality finishes, perfect for family gatherings and entertaining. The main floor offers a spacious great room and dinette area, formal dining room/den/home office, laundry room, and mudroom, plus garage walk down access to the basement. Upstairs, the luxurious primary suite is a peaceful retreat with a walk-in closet and 3 pc ensuite. Three additional bedrooms and a 4 pc bath provide plenty of space for a growing family. Outside, exceptional living spaces await. The exposed aggregate concrete driveway, walkway, and rear patio with room for a hot tub deliver great curb appeal. Enjoy summer evenings under the gazebo on this pool-sized lot, taking in peaceful countryside ambiance. This AAA+ home is a rare opportunity to enjoy executive-quality construction, exceptional privacy, beautiful natural surroundings, and a family-friendly neighbourhood. A remarkable combination of comfort, craftsmanship, and outdoor living, this is the perfect place to call home. (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Garage door opener remote(s)"
]
+"Basement": array:5 [
0 => "Full"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-25T23:29:00.256809+00:00"
+"Directions": "Cross Streets: Waterloo/Ingold. ** Directions: TURN LEFT/RIGHT OFF OF WATERLOO ST ONTO LASHINGER. KEEP LEFT AND PROPERTY UP A BLOCK ON LEFT."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235240"
+"ListOfficeKey": "290667"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "55.8 x 124.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-25T21:21:59Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T21:21:59Z"
+"Stories": "2.0"
+"StreetName": "Laschinger"
+"StreetNumber": "258"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5713"
+"VirtualTourURLUnbranded": "https://youriguide.com/258_laschinger_blvd_new_hamburg_on/"
+"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": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29954992/258-laschinger-boulevard-wilmot"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 55.9
+"OriginalEntryTimestamp": "2026-06-25T21:21:59.13Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1473101"
+"ListOfficeNationalAssociationId": "1390130"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 6
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954992')"
+"ID": "1565076"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25368
+post_id: "1560892"
+post_author: 1
+"ListingKey": "29935371"
+"ListingId": "40839185"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T14:00:02Z"
+"RFModificationTimestamp": "2026-06-22T17:20:20Z"
+"ListPrice": 950000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3020.0
+"BuildingAreaTotal": 0
+"City": "Baden"
+"PostalCode": "N3A3N2"
+"UnparsedAddress": "137 FOXBORO Drive, Baden, Ontario N3A3N2"
+"Coordinates": array:2 [
0 => -80.6974693
1 => 43.4171546
]
+"Latitude": 43.4171546
+"Longitude": -80.6974693
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Foxboro Green, a mature adult community just minutes from Kitchener & Waterloo. Residents of Foxboro enjoy a fabulous Rec Centre complete with pool, sauna, exercise room, tennis/pickleball courts, billiard room, scenic walking trails, and many other activities available to residents. This customized Juniper model sits on a very desirable lot and boasts almost 2,000 sq ft of living space on the main level. A main feature of the home is the four seasons sunroom where you can enjoy stunning views of nature year-round. Similar to the sunroom, the primary bedroom with ensuite overlooks the gardens and has a walkout to the spacious covered porch. This tranquil and private setting is a rare find in Foxboro. On the main level, you will also find the living and dining rooms, the family room with gas fireplace, the updated kitchen with skylight, breakfast nook and main bath room. There is a second bedroom, powder room and laundry/mud room. The lower level has a large recroom, third bedroom and bathroom. There is also a workshop, coldroom and plenty of storage on the lower level. Other features include a lawn sprinkler system, Central Vac, and HRV system. This original owner home has been meticulously maintained since it was built in 1995. Foxboro Green offers a lifestyle unlike any other with very reasonable condo fees, a wide variety of community events, close proximity to many amenities and beautifully landscaped grounds. Call today for a viewing – you will be impressed! (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "352"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Water"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T17:20:08.698865+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1672317"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Conservation/green belt"
1 => "Country residential"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T13:51:48Z"
+"PhotosCount": 50
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T13:51:48Z"
+"Stories": "1.0"
+"StreetName": "FOXBORO"
+"StreetNumber": "137"
+"StreetSuffix": "Drive"
+"SubdivisionName": "666 - Foxboro"
+"TaxAnnualAmount": "5615"
+"VirtualTourURLUnbranded": "https://youriguide.com/137_foxboro_dr_wilmot_on/"
+"WaterSource": array:1 [
0 => "Community Water System"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29935371/137-foxboro-drive-baden"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1944830"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "Z1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 2120
+"BelowGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-06-22T13:51:48.22Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1170621"
+"ListOfficeNationalAssociationId": "1004387"
+"CoListAgentNationalAssociationId": "1240421"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935371')"
+"ID": "1560892"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25366
+post_id: "1458791"
+post_author: 1
+"ListingKey": "29803324"
+"ListingId": "40833475"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T01:40:02Z"
+"RFModificationTimestamp": "2026-06-14T01:44:04Z"
+"ListPrice": 1400000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.242
+"LivingArea": 3556.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A0B1"
+"UnparsedAddress": "198 HOSTETLER Road, New Hamburg, Ontario N3A0B1"
+"Coordinates": array:2 [
0 => -80.7120198
1 => 43.39215
]
+"Latitude": 43.39215
+"Longitude": -80.7120198
+"YearBuilt": 2012
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Big home, big lot, big lifestyle. Triple car garage. Almost a quarter-acre lot. 5 upper-level bedrooms. 3 upper-level bathrooms. Set on an immaculate street of beautifully cared-for homes in sought-after New Hamburg, this address offers small-town charm with everyday convenience. Offering over 5,200 sqft across 3 levels, it impresses from the covered front porch and double entry doors into a wide foyer with beautifully updated staircase. Recent flooring updates include hardwood in 2023-2024 and carpet in 2026.The main floor is designed for real life, with stylish front sitting room and dramatic feature wall, formal dining area, 15'x11' dedicated office, laundry, powder room, and rear family room open to the kitchen. The eat-in kitchen is both impressive and practical, featuring granite counters, large island with bar seating for 6, walk-in pantry, coffee bar zone, separate sinks, stainless appliances, double gas range, and sliders with custom California shutters to the full-width covered deck. The adjoining family room, with built-ins and fireplace, creates an easy gathering space, while the deck extends living outdoors with room to dine, lounge, barbecue, and unwind in the 7-person hot tub. Upstairs is where this home truly stands apart: 5 oversized bedrooms and 3 bathrooms on one level. The primary suite spans the full width with 2 walk-in closets and 5-pc ensuite with separate vanities and private toilet area. The 4 additional bedrooms are smartly divided on each side of the home, each with a walk-in closet, and access to one of two Jack-and-Jill baths. A bright landing adds bonus space for homework, reading or kids' lounge. The unfinished basement offers flexibility for play, storage, gym space or future living area, with a bathroom rough-in in place. Outside, enjoy a deep fully fenced yard, expansive deck, triple garage and triple-wide driveway. Enjoy parks, trails, the Nith River, local shops, restaurants, and community amenities, all with easy access to KW. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-25T23:34:16.975052+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1565504"
+"ListOfficeKey": "86262"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.242"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-14T01:31:02Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T01:31:02Z"
+"Stories": "2.0"
+"StreetName": "HOSTETLER"
+"StreetNumber": "198"
+"StreetSuffix": "Road"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "8398.51"
+"VirtualTourURLUnbranded": "https://youriguide.com/198_hostetler_road_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29803324/198-hostetler-road-new-hamburg"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1565503"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1565502"
+"CoListOfficeKey": "283852"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "289848"
+"ZoningDescription": "Z2b 22.224"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 61.0
+"AboveGradeFinishedArea": 3556
+"OriginalEntryTimestamp": "2026-05-25T23:00:19.03Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1070271"
+"ListOfficeNationalAssociationId": "1004415"
+"CoListAgentNationalAssociationId": "1093094"
+"CoListAgentNationalAssociationId2": "1070272"
+"CoListOfficeNationalAssociationId": "1335957"
+"CoListOfficeNationalAssociationId2": "1381908"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 37
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29803324')"
+"ID": "1458791"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25361
+post_id: "1399810"
+post_author: 1
+"ListingKey": "29720137"
+"ListingId": "40828292"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T13:40:06Z"
+"RFModificationTimestamp": "2026-06-23T13:47:26Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1657.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A0E4"
+"UnparsedAddress": "250 HOSTETLER Road Unit# 7, New Hamburg, Ontario N3A0E4"
+"Coordinates": array:2 [
0 => -80.7095885
1 => 43.3918338
]
+"Latitude": 43.3918338
+"Longitude": -80.7095885
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This 2013 bungalow townhome is ideal for those looking for low-maintenance living backing onto green space! The covered front porch is a welcoming entry, or come through the wheelchair lift in the garage (protecting you from the weather). Both lead into a spacious foyer and into the open concept living space. With hardwood floors, potlights and California knock down ceilings. The kitchen is the heart of the home here, with dark wood cabinetry, granite countertops, stainless steel appliances, and convenient 3 seater island. Made for gatherings, the living areas include enough space for a proper dining table, as well as a stone-clad gas fireplace creating a beautiful feature. The room is flooded with natural light from the wide sliding patio doors. The home backs onto the arboretum, creating a lovely view and feel of privacy and serenity right from your home. Off the living room, you'll find an oversized primary suite complete with a view of the back garden and arboretum, double closets, and it's own ensuite bath. The ensuite has a barrier-free roll in shower, double sinks, and built in linen storage. A second main floor bedroom and second full bathroom complete the main floor. It's a straight run downstairs, leading to a large cozy rec room. Another bedroom and full bath are located just at the bottom of the stairs, providing room for a small family to spread out or a great guest space. The remainder of the basement remains mostly unfinished for your personal touch. With an area currently set up as a bedroom, it would make an ideal office! The back basement would be a great play room, home gym, or huge storage area. The home has a variety of features to accommodate wheelchair accessible needs if required, a list is available. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "676"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [
0 => "Landscaping"
1 => "Property Management"
2 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-08T03:10:29.423642+00:00"
+"Directions": "Waterloo St to Hostetler Rd, turn into complex ""Wrens Arbour"""
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1997295"
+"ListOfficeKey": "283457"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T13:31:20Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T13:31:20Z"
+"Stories": "1.0"
+"StreetName": "HOSTETLER"
+"StreetNumber": "250"
+"StreetSuffix": "Road"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "4334.95"
+"VirtualTourURLUnbranded": "https://youriguide.com/7_250_hostetler_rd_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29720137/250-hostetler-road-unit-7-new-hamburg"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1234
+"BelowGradeFinishedArea": 423
+"OriginalEntryTimestamp": "2026-05-08T01:49:48.88Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1279814"
+"ListOfficeNationalAssociationId": "1330157"
+"Media": array:44 [
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]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29720137')"
+"ID": "1399810"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1399811"
+post_author: 1
+"ListingKey": "29718239"
+"ListingId": "X13098416"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-07T20:35:47Z"
+"RFModificationTimestamp": "2026-05-07T23:01:03Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A0E4"
+"UnparsedAddress": "7 - 250 HOSTETLER ROAD, Wilmot, Ontario N3A0E4"
+"Coordinates": array:2 [
0 => -80.709797
1 => 43.391793
]
+"Latitude": 43.391793
+"Longitude": -80.709797
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This 2013 bungalow townhome is ideal for those looking for low-maintenance living backing onto green space! The covered front porch is a welcoming entry, or come through the wheelchair lift in the garage (protecting you from the weather). Both lead into a spacious foyer and into the open concept living space. With hardwood floors, potlights and California knock down ceilings. The kitchen is the heart of the home here, with dark wood cabinetry, granite countertops, stainless steel appliances, and convenient 3 seater island. Made for gatherings, the living areas include enough space for a proper dining table, as well as a stone-clad gas fireplace creating a beautiful feature. The room is flooded with natural light from the wide sliding patio doors. The home backs onto the arboretum, creating a lovely view and feel of privacy and serenity right from your home. Off the living room, you'll find an oversized primary suite complete with a view of the back garden and arboretum, double closets, and it's own ensuite bath. The ensuite has a barrier-free roll in shower, double sinks, and built in linen storage. A second main floor bedroom and second full bathroom complete the main floor. It's a straight run downstairs, leading to a large cozy rec room. Another bedroom and full bath are located just at the bottom of the stairs, providing room for a small family to spread out or a great guest space. The remainder of the basement remains mostly unfinished for your personal touch. With an area currently set up as a bedroom, it would make an ideal office! The back basement would be a great play room, workshop, or huge storage area. The home has a variety of features to accommodate wheelchair accessible needs if required, a list is available. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Garage door opener remote(s)"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "676"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Parking"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-07T23:00:55.736014+00:00"
+"Directions": "Cross Streets: Waterloo St/Hostetler Rd. ** Directions: Waterloo St to Hostetler Rd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2063982"
+"ListOfficeKey": "269164"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Wooded area"
2 => "Wheelchair access"
3 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-07T20:25:22Z"
+"PhotosCount": 46
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-07T20:25:22Z"
+"Stories": "1.0"
+"StreetName": "Hostetler"
+"StreetNumber": "250"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4334.95"
+"VirtualTourURLUnbranded": "https://youriguide.com/7_250_hostetler_rd_new_hamburg_on/"
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29718239/7-250-hostetler-road-wilmot"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Weigel Property Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Fireplace(s)"
1 => "Visitor Parking"
]
+"LivingAreaMaximum": 1399
+"LivingAreaMinimum": 1200
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"OriginalEntryTimestamp": "2026-05-07T20:25:22.55Z"
+"ListAgentNationalAssociationId": "1339062"
+"ListOfficeNationalAssociationId": "1243249"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 55
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29718239')"
+"ID": "1399811"
}
]
+success: true
+page_size: 7
+page_count: 1
+count: 7
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]