array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29943250 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23409
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23411
+post_id: "1558463"
+post_author: 1
+"ListingKey": "29943250"
+"ListingId": "40842157"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T23:20:12Z"
+"RFModificationTimestamp": "2026-06-25T23:08:02Z"
+"ListPrice": 779500.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1658.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A4N7"
+"UnparsedAddress": "236 THEODORE SCHULER Boulevard, New Hamburg, Ontario N3A4N7"
+"Coordinates": array:2 [
0 => -80.7155691
1 => 43.3891415
]
+"Latitude": 43.3891415
+"Longitude": -80.7155691
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your new home! This 3 bed 2 1/2 bath home is waiting for you in a very desirable child friendly neighbourhood. The wide spacious foyer welcomes you in. The living and dining rooms are bright and cheerful with hardwood floors. The kitchen has granite counters, stainless steel appliances, reverse osmosis, and lots of counter space for those great get togethers. The upper floor has a bonus room with large windows which allows lots of natural light to flood in. Your primary bedroom with an en-suite bathroom is perfect to laze away a day. There are 2 additional bedrooms for your family. The basement is wide open to anything you want to have, additional bedrooms, office, play space or anything you can dream up. Step outside to enjoy your above ground pool on those scorching hot summer days or sit back and enjoy the garden. The steel roof will assure years of peace of mind. The bbq has a hook up for an easy bbq experience. You are minutes from the Scram and local shops. Come and see it for yourself. (id:62783)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Central Vacuum - Roughed In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T20:33:56.693908+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1807733"
+"ListOfficeKey": "76830"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sump Pump"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-23T19:12:21Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T23:10:34Z"
+"Stories": "2.0"
+"StreetName": "THEODORE SCHULER"
+"StreetNumber": "236"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "4128"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [
"RoomKey" => "1667267941"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842157"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.06Z"
]
1 => array:11 [
"RoomKey" => "1667267942"
"RoomType" => "Bedroom"
"ListingId" => "40842157"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 9'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.06Z"
]
2 => array:11 [
"RoomKey" => "1667267943"
"RoomType" => "Full bathroom"
"ListingId" => "40842157"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.06Z"
]
3 => array:11 [
"RoomKey" => "1667267944"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842157"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.06Z"
]
4 => array:11 [
"RoomKey" => "1667267945"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842157"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.06Z"
]
5 => array:11 [
"RoomKey" => "1667267946"
"RoomType" => "Bedroom"
"ListingId" => "40842157"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.06Z"
]
6 => array:11 [
"RoomKey" => "1667267947"
"RoomType" => "Bonus Room"
"ListingId" => "40842157"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => "17'6'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.07Z"
]
7 => array:11 [
"RoomKey" => "1667267948"
"RoomType" => "Foyer"
"ListingId" => "40842157"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => "5'8'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.07Z"
]
8 => array:11 [
"RoomKey" => "1667267949"
"RoomType" => "Kitchen"
"ListingId" => "40842157"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => "19'2'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.07Z"
]
9 => array:11 [
"RoomKey" => "1667267950"
"RoomType" => "Living room"
"ListingId" => "40842157"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29943250"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 19'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-24T23:10:34.07Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29943250/236-theodore-schuler-boulevard-new-hamburg"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1600653"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76830"
+"GeocodeManualYN": true
+"ZoningDescription": "2c"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 1658
+"OriginalEntryTimestamp": "2026-06-23T19:12:21.42Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1191478"
+"ListOfficeNationalAssociationId": "1004392"
+"CoListAgentNationalAssociationId": "1150780"
+"CoListOfficeNationalAssociationId": "1004392"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29943250_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/6a8d41d3d1df155f900ddf5ab91a7491.webp"
"MediaSize" => 135370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-6a8d41d3d1df155f900ddf5ab91a7491.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick and siding exterior, a two-car garage, and a covered front entry with a dark door"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29943250_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/06f30a8c5186310e33202e2c3b85230a.webp"
"MediaSize" => 138151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-06f30a8c5186310e33202e2c3b85230a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring a covered front entry with white columns, an attached two-car garage, established landscaping, and a paved driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29943250_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/4a932a31e576d7d8f6533a31f65bd1b2.webp"
"MediaSize" => 148915
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-4a932a31e576d7d8f6533a31f65bd1b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring a covered front entrance with a dark door, an attached garage, and an upper arched window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29943250_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/ca868f062e4396c53a68b3b82041f6d5.webp"
"MediaSize" => 121247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-ca868f062e4396c53a68b3b82041f6d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Inviting front porch featuring a multi-tone brick facade, concrete flooring, and white support columns"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29943250_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/9c31619656d92fc377702159a0d539c5.webp"
"MediaSize" => 32906
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-9c31619656d92fc377702159a0d539c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance featuring a white door with decorative glass inserts, light neutral-toned walls, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29943250_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/2bb725db903e318c4a426d550f58943c.webp"
"MediaSize" => 44950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-2bb725db903e318c4a426d550f58943c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29943250_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/c83789e0405a05f031922d2f2a00fda7.webp"
"MediaSize" => 53928
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-c83789e0405a05f031922d2f2a00fda7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring white cabinetry, light-toned granite countertops, and stainless steel appliances"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29943250_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/00bbd040047b64df1dd9408714ad03b1.webp"
"MediaSize" => 69202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-00bbd040047b64df1dd9408714ad03b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring an island with a light-toned stone-finish countertop, white cabinetry, stainless steel appliances, and a sliding glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29943250_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/d8b59297f7f0e25867a677916b189b34.webp"
"MediaSize" => 58497
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-d8b59297f7f0e25867a677916b189b34.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchenette with granite-finish countertop, white cabinetry, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29943250_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/d100c41ef97aea2c32c31d8caf9339b1.webp"
"MediaSize" => 57444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-d100c41ef97aea2c32c31d8caf9339b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Galley kitchen featuring white cabinetry, light granite countertops, stainless steel appliances, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29943250_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/1563fbad2da114520132a2aafa6a98cf.webp"
"MediaSize" => 59819
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-1563fbad2da114520132a2aafa6a98cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29943250_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/a77af7d1b65df32535662d39a8234df9.webp"
"MediaSize" => 75025
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-a77af7d1b65df32535662d39a8234df9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring a contemporary ceiling fan with integrated lighting, light wood-finish flooring, and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29943250_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/e39ef05b8b2bbd956269778013a973d5.webp"
"MediaSize" => 70692
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-e39ef05b8b2bbd956269778013a973d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living and dining area featuring light wood-finish flooring, light blue wall tones, and a modern ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29943250_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/cf87591cea7fa779d290f5efa1e5c56e.webp"
"MediaSize" => 71411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-cf87591cea7fa779d290f5efa1e5c56e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living and dining area featuring light wood-finish flooring, a contemporary black ceiling fan with integrated lighting, and a staircase with dark wood banister and white risers"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29943250_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/adfb59335e851f984c7180f73249ada7.webp"
"MediaSize" => 68720
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-adfb59335e851f984c7180f73249ada7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring extends through the main living area, complemented by a contemporary ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29943250_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/d73078735d9390b43f8f0d7eee6b1e07.webp"
"MediaSize" => 64739
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-d73078735d9390b43f8f0d7eee6b1e07.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring and a ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29943250_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/e48aeb8242026a3fe1ec54960e2931d7.webp"
"MediaSize" => 69899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-e48aeb8242026a3fe1ec54960e2931d7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vanity with an integrated white sink, chrome faucet, and spacious countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29943250_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/5f151c8271d2fb6691029fd1b2ac2b0d.webp"
"MediaSize" => 56776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-5f151c8271d2fb6691029fd1b2ac2b0d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted staircase with dark wood-finish balusters and handrails"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29943250_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/55de706fb79a2a24039d3a67d181bfc1.webp"
"MediaSize" => 72468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-55de706fb79a2a24039d3a67d181bfc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted ceiling space featuring wood-finish flooring, an arched window with plantation shutters, and a built-in electric fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29943250_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/8a9d79cb5d3a1be7326a6bf9f696df16.webp"
"MediaSize" => 68775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-8a9d79cb5d3a1be7326a6bf9f696df16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, a ceiling fan with integrated lighting, a dark wood-toned fireplace surround, light blue wall paint, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29943250_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/5044791100fd9ad46dfe344dc64b2ee0.webp"
"MediaSize" => 61295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-5044791100fd9ad46dfe344dc64b2ee0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, a window with plantation shutters, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29943250_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/da30d167ea752512cda8e2999e700ae2.webp"
"MediaSize" => 71837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-da30d167ea752512cda8e2999e700ae2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, plantation shutters, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29943250_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/b58d6cdf9a07c574ff7c9c507e871e10.webp"
"MediaSize" => 70268
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-b58d6cdf9a07c574ff7c9c507e871e10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, white walls, and a recessed ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29943250_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/b74a5527cdb8ab3948c8b3c81566e17c.webp"
"MediaSize" => 73738
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-b74a5527cdb8ab3948c8b3c81566e17c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with a speckled countertop, undermount sink, and chrome faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29943250_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/e857514806b18652fb3644efbf4f51c8.webp"
"MediaSize" => 68437
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-e857514806b18652fb3644efbf4f51c8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring a window with white louvered shutters, wood-finish flooring, and a ceiling-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29943250_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/4a1cff53c6de8c890e78225f3c8cfcbd.webp"
"MediaSize" => 58119
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-4a1cff53c6de8c890e78225f3c8cfcbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light yellow walls and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29943250_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/48593c1fb56937288fe247c6a448ef5a.webp"
"MediaSize" => 54260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-48593c1fb56937288fe247c6a448ef5a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright room featuring wood-finish flooring and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29943250_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/69eb38978df0244fad7a2d166be2bda9.webp"
"MediaSize" => 58216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-69eb38978df0244fad7a2d166be2bda9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, white walls, and a window with white louvered shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29943250_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/2b1aa4a897a06b445aa1cb0a5fe99f08.webp"
"MediaSize" => 78651
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-2b1aa4a897a06b445aa1cb0a5fe99f08.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a single vanity with a granite countertop, undermount sink, and white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29943250_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/affabd33e6dd0089dc2561b6df40e8e8.webp"
"MediaSize" => 135130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-affabd33e6dd0089dc2561b6df40e8e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Patio featuring a black metal gazebo, concrete flooring, and brick exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29943250_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/3cee40f777c722cb6c50976e39c192b6.webp"
"MediaSize" => 123786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-3cee40f777c722cb6c50976e39c192b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Outdoor patio area featuring a fixed gazebo structure with integrated string lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29943250_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/1b8677c8a4df58da4ff18e757f253b22.webp"
"MediaSize" => 124808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-1b8677c8a4df58da4ff18e757f253b22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Private backyard featuring a concrete patio, wood fence, and a built-in outdoor fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29943250_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/48850a40e6460fa637bf79c82ae3d2c7.webp"
"MediaSize" => 108014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-48850a40e6460fa637bf79c82ae3d2c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29943250_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/d2924e4c757a7c64806328af947ea3de.webp"
"MediaSize" => 119026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-d2924e4c757a7c64806328af947ea3de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Above-ground pool with a white surround and integrated entry system, bordered by a wood fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29943250_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/9afce5e40231cd130f669d8937c5c3a5.webp"
"MediaSize" => 130512
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-9afce5e40231cd130f669d8937c5c3a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Manicured lawn with a detached storage shed, wood fence, and above-ground pool with a wood deck"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29943250_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/877ebca517adb1542d4d00e4efccd8b6.webp"
"MediaSize" => 140902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-877ebca517adb1542d4d00e4efccd8b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious backyard featuring a large green lawn, a multi-level wooden deck, and a patio area with a sliding glass door entry to the home"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29943250_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/97fe9853dcf5979cfd4fee589a1a5998.webp"
"MediaSize" => 126684
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-97fe9853dcf5979cfd4fee589a1a5998.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a lush lawn, above-ground pool, and a dedicated storage shed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29943250_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29943250/913cbf72f5caf1a26bb6fc89c83c02eb.webp"
"MediaSize" => 158996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29943250/thumbnail-913cbf72f5caf1a26bb6fc89c83c02eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Fenced backyard with manicured lawn and stone-bordered garden beds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842157"
"ResourceRecordKey" => "29943250"
"ModificationTimestamp" => "2026-06-23T19:12:21.43Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29943250')"
+"ID": "1558463"
}
]
+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 76830" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24825
+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 1807733" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24824
+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 '29943250'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25220
+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 '29943250'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25339
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25307
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31637237"
+"ListingKey": "29943250"
+"ListingId": "40842157"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-28"
+"OpenHouseStartTime": "2026-06-28T14:00:00Z"
+"OpenHouseEndTime": "2026-06-28T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-26T08:07:52Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31637237')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25325
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31637236"
+"ListingKey": "29943250"
+"ListingId": "40842157"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-27"
+"OpenHouseStartTime": "2026-06-27T14:00:00Z"
+"OpenHouseEndTime": "2026-06-27T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-26T08:07:52Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31637236')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29943250' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7155691 43.3891415)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25258
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25252
+post_id: "1566566"
+post_author: 1
+"ListingKey": "29954380"
+"ListingId": "40842921"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T20:00:08Z"
+"RFModificationTimestamp": "2026-06-26T01:04:37Z"
+"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-06-25T19:50:38Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T19:50:38Z"
+"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 [
"RoomKey" => "1667976636"
"RoomType" => "Living room"
"ListingId" => "40842921"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 19'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
1 => array:11 [
"RoomKey" => "1667976637"
"RoomType" => "Laundry room"
"ListingId" => "40842921"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "8'0'' x 10'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
2 => array:11 [
"RoomKey" => "1667976638"
"RoomType" => "Kitchen"
"ListingId" => "40842921"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 9'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
3 => array:11 [
"RoomKey" => "1667976639"
"RoomType" => "Foyer"
"ListingId" => "40842921"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
4 => array:11 [
"RoomKey" => "1667976640"
"RoomType" => "Dining room"
"ListingId" => "40842921"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
5 => array:11 [
"RoomKey" => "1667976641"
"RoomType" => "2pc Bathroom"
"ListingId" => "40842921"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "3'0'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
6 => array:11 [
"RoomKey" => "1667976642"
"RoomType" => "Storage"
"ListingId" => "40842921"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "30'11'' x 39'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
7 => array:11 [
"RoomKey" => "1667976643"
"RoomType" => "Cold room"
"ListingId" => "40842921"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "4'6'' x 18'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
8 => array:11 [
"RoomKey" => "1667976644"
"RoomType" => "Primary Bedroom"
"ListingId" => "40842921"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 12'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
9 => array:11 [
"RoomKey" => "1667976645"
"RoomType" => "Bedroom"
"ListingId" => "40842921"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 13'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.39Z"
]
10 => array:11 [
"RoomKey" => "1667976646"
"RoomType" => "Bedroom"
"ListingId" => "40842921"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "10'6'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.4Z"
]
11 => array:11 [
"RoomKey" => "1667976647"
"RoomType" => "Bedroom"
"ListingId" => "40842921"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.4Z"
]
12 => array:11 [
"RoomKey" => "1667976648"
"RoomType" => "4pc Bathroom"
"ListingId" => "40842921"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.4Z"
]
13 => array:11 [
"RoomKey" => "1667976649"
"RoomType" => "Full bathroom"
"ListingId" => "40842921"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29954380"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-25T19:50:38.4Z"
]
]
+"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 [
"Order" => 1
"MediaKey" => "29954380_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954380/f9fb708c1585142330553a35d53607ec.webp"
"MediaSize" => 79367
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954380/thumbnail-f9fb708c1585142330553a35d53607ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40842921"
"ResourceRecordKey" => "29954380"
"ModificationTimestamp" => "2026-06-25T19:50:38.29Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29954380_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954380/a43750a7854a1028a3be7b4579e4f6c5.webp"
"MediaSize" => 89001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954380/thumbnail-a43750a7854a1028a3be7b4579e4f6c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842921"
"ResourceRecordKey" => "29954380"
"ModificationTimestamp" => "2026-06-25T19:50:38.29Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29954380_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954380/75cbe9b0f318122193e1550284625d0f.webp"
"MediaSize" => 89663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954380/thumbnail-75cbe9b0f318122193e1550284625d0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842921"
"ResourceRecordKey" => "29954380"
"ModificationTimestamp" => "2026-06-25T19:50:38.29Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29954380_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954380/0bf5d9b63045c945172094134722e63a.webp"
"MediaSize" => 88124
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954380/thumbnail-0bf5d9b63045c945172094134722e63a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842921"
"ResourceRecordKey" => "29954380"
"ModificationTimestamp" => "2026-06-25T19:50:38.29Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29954380_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954380/43e75c18c2bf738def0aa585a3d61aa0.webp"
"MediaSize" => 92150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954380/thumbnail-43e75c18c2bf738def0aa585a3d61aa0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842921"
"ResourceRecordKey" => "29954380"
"ModificationTimestamp" => "2026-06-25T19:50:38.29Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29954380_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954380/e2b3da65f4f1d66a2ba7987a28d6e696.webp"
"MediaSize" => 124349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954380/thumbnail-e2b3da65f4f1d66a2ba7987a28d6e696.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842921"
"ResourceRecordKey" => "29954380"
"ModificationTimestamp" => "2026-06-25T19:50:38.29Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29954380_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954380/0fd631311930bf6c73a3324672c73db1.webp"
"MediaSize" => 99573
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954380/thumbnail-0fd631311930bf6c73a3324672c73db1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842921"
"ResourceRecordKey" => "29954380"
"ModificationTimestamp" => "2026-06-25T19:50:38.29Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29954380_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954380/6d906bf977a6acbfdce7862d6d6d7375.webp"
"MediaSize" => 63802
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954380/thumbnail-6d906bf977a6acbfdce7862d6d6d7375.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40842921"
"ResourceRecordKey" => "29954380"
"ModificationTimestamp" => "2026-06-25T19:50:38.29Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29954380_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29954380/47058124c47d200bc157684beef9ee13.webp"
"MediaSize" => 63391
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29954380/thumbnail-47058124c47d200bc157684beef9ee13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
…4
]
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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954380')"
+"ID": "1566566"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25254
+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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29954992')"
+"ID": "1565076"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25251
+post_id: "1554307"
+post_author: 1
+"ListingKey": "29936252"
+"ListingId": "40841842"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T16:20:08Z"
+"RFModificationTimestamp": "2026-06-22T17:33:57Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2352.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A0B5"
+"UnparsedAddress": "105 CAPTAIN MCCALLUM Drive, New Hamburg, Ontario N3A0B5"
+"Coordinates": array:2 [
0 => -80.6986976
1 => 43.3827677
]
+"Latitude": 43.3827677
+"Longitude": -80.6986976
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Curb appeal plus!! Welcome to this well cared for home at 105 Captain McCallum Drive in New Hamburg. Situated in a family friendly neighbourhood this home offers a perfect blend of comfort and functionality. The open concept main floor boasts a cozy living room with a wall feature and electric fireplace, sliders to a deck make it ideal for relaxing or hosting guests. The dining area flows effortlessly into the oversized kitchen, making meal preparation and gatherings a breeze. Kitchen highlights include granite counters, updated backsplash and stainless appliances. For added convenience the main floor also offers a powder room with pocket door and a standout updated oversized laundry room with custom shelves, storage and front loading washer and dryer. California shutters can be found throughout the home. Upstairs you'll find 3 spacious bedrooms, including a massive primary, featuring vaulted ceilings, another feature wall with electric fireplace, ensuite and walk-in closet. The finished basement adds more living space, rec room or theatre room if you prefer, featuring luxury vinyl plank flooring, stylish bar area, 3-piece bath, and a generous storage room. Outside, enjoy the large deck, perfect for entertaining, complete with a BBQ gas line and fully fenced backyard, whether you're enjoying a quiet evening on the back deck or taking a stroll through the neighbourhood, this home provides ample space for families of all sizes. You'll love the convenience of being located with easy access to schools, parks, and shopping. Don't miss the opportunity to own this perfect place to call home! (id:62783)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T17:33:55.190800+00:00"
+"Directions": "Hamilton Rd to Captain McCallum Dr"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1911516"
+"ListOfficeKey": "76826"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T16:11:01Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T16:11:01Z"
+"Stories": "2.0"
+"StreetName": "CAPTAIN MCCALLUM"
+"StreetNumber": "105"
+"StreetSuffix": "Drive"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "4468"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Electricity"
]
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29936252/105-captain-mccallum-drive-new-hamburg"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "Z2B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1864
+"BelowGradeFinishedArea": 488
+"OriginalEntryTimestamp": "2026-06-22T16:11:01.71Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1222803"
+"ListOfficeNationalAssociationId": "1004387"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936252')"
+"ID": "1554307"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25255
+post_id: "1554308"
+post_author: 1
+"ListingKey": "29936199"
+"ListingId": "X13473934"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T17:35:08Z"
+"RFModificationTimestamp": "2026-06-26T02:07:34Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A4J2"
+"UnparsedAddress": "140 SHADE STREET, Wilmot, Ontario N3A4J2"
+"Coordinates": array:2 [
0 => -80.7199652
1 => 43.3773624
]
+"Latitude": 43.3773624
+"Longitude": -80.7199652
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "FOLLOW THE YELLOW BRICK ROAD. CHARMING 2 STOREY YELLOW BRICK HOME ON ONE OF THE MOST COVETED STREETS IN TOWN. COUNTRY VIEWS FROM THE FRONT PORCH WITH YOUR MORNING COFFEE IN HAND. LARGE FOYER WITH EXTENSIVE WOODWORK OPENS ONTO THE LIVING ROOM WITH POCKET DOORS SEPARATING THE DINING ROOM FEATURING A LARGE BAY WINDOW. BRIGHT AND AIRY KITCHEN WITH PLENTY OF WINDOWS AND A DOOR TO THE BACK PORCH AND REAR YARD. 4 GOOD SIZED BEDROOMS AND A FULL BATH UPSTAIRS. THE BASEMENT HAS A FINISHED OFFICE ROOM. THE HOME IS SURROUNDED BY MATURE PINE AND SPRUCE TREES GIVING YOU LOTS OF PRIVACY IN BOTH THE FRONT AND BACK YARDS. DETACHED GARAGE HAS A WORKSHOP AREA IN ADDITION TO THE GARAGE SPACE. BRAND NEW ROOF IN 2026, SLATE PATIO IN BACK YARD, PERFECT FOR ENTERTAINING. GAS LINE TO BBQ. IMPRESSIVE PROPERTY WITH A COUNTRY FEEL AND ONLY AN 8 MINUTE WALK TO SCHOOLS AND DOWNTOWN CORE. BE SURE TO VIEW! (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T17:21:04.798306+00:00"
+"Directions": "Cross Streets: Waterloo St. ** Directions: Waterloo St to Shade St."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2238866"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "66.1 x 114.4 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T23:11:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T17:17:22Z"
+"Stories": "2.0"
+"StreetName": "Shade"
+"StreetNumber": "140"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4041"
+"VirtualTourURLUnbranded": "https://youriguide.com/140_shade_street_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29936199/140-shade-street-wilmot"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2241753"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "290246"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 66.1
+"OriginalEntryTimestamp": "2026-06-22T15:55:59.48Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1476741"
+"ListOfficeNationalAssociationId": "1385020"
+"CoListAgentNationalAssociationId": "1479901"
+"CoListOfficeNationalAssociationId": "1385020"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29936199')"
+"ID": "1554308"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25253
+post_id: "1553312"
+post_author: 1
+"ListingKey": "29935774"
+"ListingId": "40840928"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T15:40:14Z"
+"RFModificationTimestamp": "2026-06-26T02:58:03Z"
+"ListPrice": 650000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1590.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A4J2"
+"UnparsedAddress": "140 SHADE Street, New Hamburg, Ontario N3A4J2"
+"Coordinates": array:2 [
0 => -80.7199619
1 => 43.3773698
]
+"Latitude": 43.3773698
+"Longitude": -80.7199619
+"YearBuilt": 1905
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "FOLLOW THE YELLOW BRICK ROAD. CHARMING 2 STOREY YELLOW BRICK HOME ON ONE OF THE MOST COVETED STREETS IN TOWN. COUNTRY VIEWS FROM THE FRONT PORCH WITH YOUR MORNING COFFEE IN HAND. LARGE FOYER WITH EXTENSIVE WOODWORK OPENS ONTO THE LIVING ROOM WITH POCKET DOORS SEPARATING THE DINING ROOM FEATURING A LARGE BAY WINDOW. BRIGHT AND AIRY KITCHEN WITH PLENTY OF WINDOWS AND A DOOR TO THE BACK PORCH AND REAR YARD. 4 GOOD SIZED BEDROOMS AND A FULL BATH UPSTAIRS. THE BASEMENT HAS A FINISHED OFFICE ROOM. THE HOME IS SURROUNDED BY MATURE PINE AND SPRUCE TREES GIVING YOU LOTS OF PRIVACY IN BOTH THE FRONT AND BACK YARDS. DETACHED GARAGE HAS A WORKSHOP AREA IN ADDITION TO THE GARAGE SPACE. BRAND NEW ROOF IN 2026, SLATE PATIO IN BACK YARD, PERFECT FOR ENTERTAINING. GAS LINE TO BBQ. IMPRESSIVE PROPERTY WITH A COUNTRY FEEL AND ONLY AN 8 MINUTE WALK TO SCHOOLS AND DOWNTOWN CORE. BE SURE TO VIEW! (id:62783)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-22T15:29:06.110838+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564419"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-22T14:51:44Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T15:32:28Z"
+"Stories": "2.0"
+"StreetName": "SHADE"
+"StreetNumber": "140"
+"StreetSuffix": "Street"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "4041"
+"VirtualTourURLUnbranded": "https://youriguide.com/140_shade_street_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29935774/140-shade-street-new-hamburg"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1889502"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "290168"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1440
+"BelowGradeFinishedArea": 150
+"OriginalEntryTimestamp": "2026-06-22T14:51:44.63Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1069731"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1210732"
+"CoListOfficeNationalAssociationId": "1384313"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29935774')"
+"ID": "1553312"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25248
+post_id: "1533159"
+post_author: 1
+"ListingKey": "29906485"
+"ListingId": "40840074"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-19T22:25:28Z"
+"RFModificationTimestamp": "2026-06-19T22:31:36Z"
+"ListPrice": 550000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1718.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A1P1"
+"UnparsedAddress": "11 BYRON Street, New Hamburg, Ontario N3A1P1"
+"Coordinates": array:2 [
0 => -80.7149982
1 => 43.3778626
]
+"Latitude": 43.3778626
+"Longitude": -80.7149982
+"YearBuilt": 1889
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to the heart of downtown New Hamburg and the original rectory built for St George's Anglican Church in 1889. Rich in history and timeless character, this solid home features a charming full-width front porch and is ideally situated just steps from schools, medical and dental offices, shopping, and everyday amenities. Currently configured as a legal duplex, this unique property offers exceptional flexibility for investors, multi-generational living, or buyers seeking a mortgage helper. The upper level was converted into a self-contained apartment in 2000, while the main floor has most recently served as church office space, presenting an opportunity to complete a second apartment or thoughtfully restore the home into a lovely single-family residence. Filled with potential and located in one of New Hamburg's most desirable downtown settings, this versatile property is perfect for those looking to generate rental income, create flexible living arrangements, or bring new life to a historic home with strong long-term investment value. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-15T22:58:42.711297+00:00"
+"Directions": "Waterloo St to Byron"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1470725"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Crushed stone driveway"
]
+"NumberOfUnitsTotal": "2"
+"ParkingFeatures": array:1 [
0 => "Open"
]
+"PhotosChangeTimestamp": "2026-06-15T20:51:52Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-19T21:51:16Z"
+"Stories": "2.0"
+"StreetName": "BYRON"
+"StreetNumber": "11"
+"StreetSuffix": "Street"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "3381"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/11a_byron_st_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29906485/11-byron-street-new-hamburg"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1624482"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76826"
+"GeocodeManualYN": true
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 61.0
+"AboveGradeFinishedArea": 1718
+"OriginalEntryTimestamp": "2026-06-15T20:50:47.98Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1127571"
+"ListOfficeNationalAssociationId": "1389824"
+"CoListAgentNationalAssociationId": "1161311"
+"CoListOfficeNationalAssociationId": "1004387"
+"Media": array:34 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29906485')"
+"ID": "1533159"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23423
+post_id: "1526068"
+post_author: 1
+"ListingKey": "29857591"
+"ListingId": "X13245432"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-22T17:40:36Z"
+"RFModificationTimestamp": "2026-06-22T17:54:51Z"
+"ListPrice": 995800.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A0B3"
+"UnparsedAddress": "56 SMITH'S CREEK DRIVE, Wilmot, Ontario N3A0B3"
+"Coordinates": array:2 [
0 => -80.718034
1 => 43.38266
]
+"Latitude": 43.38266
+"Longitude": -80.718034
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "The Oakville, Milton & District Real Estate Board"
+"PublicRemarks": "Beautifully updated 3+2 bedroom home on a quiet street in a desirable New Hamburg neighborhood, offering country-style living with easy access to top schools, shops, and amenities! Freshly painted, the main level boasts an open-concept design with high ceilings, a cozy gas fireplace, large windows filling the space with natural light, and a smart Nest security system & thermostat. The chef's kitchen features premium stainless steel appliances, a gas stove, dual oven, a walk-in pantry, and extensive counter space. Directly off the dining area, sliding doors lead to an ultra-private backyard with a deck backing onto a peaceful wetlands preserve with nature trails and no rear neighbors! Upstairs offers 3 generous bedrooms, including a primary retreat with a walk-in closet and a 5-piece ensuite with a soaker tub, plus a spacious bonus loft perfect for family movie nights. The garage is fully equipped with a Tesla Fast Charger and a MyQ smart garage opener. The standout feature is a fully private, legal 2-bedroom basement apartment ($70K in updates!) featuring a separate entrance, independent laundry, and full kitchen-generating $2,000/month in income. An incredible opportunity to offset your mortgage while living in luxury! (id:62650)"
+"Appliances": array:3 [
0 => "All"
1 => "Water meter"
2 => "Alarm System"
]
+"Basement": array:4 [
0 => "Apartment in basement"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:37:29.328129+00:00"
+"Directions": "Cross Streets: Catherine St/Smith's Creek Dr. ** Directions: Waterloo St to Steinman St to Catherine St to Smith's Creek Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2043569"
+"ListOfficeKey": "300091"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Ravine"
1 => "Backs on greenbelt"
]
+"LotSizeDimensions": "36.1 x 120.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T16:02:23Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-22T17:25:50Z"
+"Stories": "2.0"
+"StreetName": "Smith's Creek"
+"StreetNumber": "56"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "5400"
+"VirtualTourURLUnbranded": "https://listing.at-photo.ca/sites/56-smiths-creek-dr-new-hamburg-on-n3a-0b3-25386851/branded"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Oakville-Milton"
+"ListAORKey": "15"
+"ListingURL": "www.realtor.ca/real-estate/29857591/56-smiths-creek-drive-wilmot"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Security system"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Z2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 36.1
+"OriginalEntryTimestamp": "2026-06-04T23:26:10.41Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1319406"
+"ListOfficeNationalAssociationId": "1482797"
+"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": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29857591')"
+"ID": "1526068"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25256
+post_id: "1510650"
+post_author: 1
+"ListingKey": "29875585"
+"ListingId": "X13419246"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-25T01:20:05Z"
+"RFModificationTimestamp": "2026-06-25T22:23:45Z"
+"ListPrice": 676020.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A2A3"
+"UnparsedAddress": "125 CATHERINE STREET, Wilmot, Ontario N3A2A3"
+"Coordinates": array:2 [
0 => -80.718039
1 => 43.384303
]
+"Latitude": 43.384303
+"Longitude": -80.718039
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "QUICK CLOSINGS AVAILABLE (move-in and avoid occupancy fees!). Welcome to New Hamburg's latest townhouse development, Cassel Crossing! Featuring the quality "now under construction" traditional street front townhouse "The Park" 3 bed layout interior unit by a local builder. PICK YOUR FINISHES WHILE YOU CAN; quartz countertops throughout, main floor luxury vinyl plank, 9ft main floor ceilings, central air & ERV and wood deck. Enjoy small town living with big city comforts (Wilmot Rec Centre, Mike Schout Wetlands Preserve, Downtown Shops, Restaurants) & much more! Conveniently located only 15 minutes to KW and 45 minutes to the GTA. BONUS: This unit comes with over $5,600 in extra upgrades already included (double sinks in main & primary bath, additional pot lights throughout, two piece basement rough-in and sanitary back flow preventer) and limited time offer (6pc appliance package) with purchase and $15,000 in additional FREE UPGRADES!!! (id:62783)"
+"Appliances": array:2 [
0 => "Water meter"
1 => "Water Heater"
]
+"AssociationFee": "285"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-06-09T17:13:02.057594+00:00"
+"Directions": "Waterloo Street to Catherine Street"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2147249"
+"ListOfficeKey": "300667"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T14:55:42Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-25T01:11:36Z"
+"Stories": "2.0"
+"StreetName": "Catherine"
+"StreetNumber": "125"
+"StreetSuffix": "Street"
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29875585/125-catherine-street-wilmot"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 3
+"OriginalEntryTimestamp": "2026-06-09T14:55:42.05Z"
+"ListAgentNationalAssociationId": "1398484"
+"ListOfficeNationalAssociationId": "1491608"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875585')"
+"ID": "1510650"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25257
+post_id: "1511691"
+post_author: 1
+"ListingKey": "29875200"
+"ListingId": "40837556"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-21T19:40:07Z"
+"RFModificationTimestamp": "2026-06-21T19:44:27Z"
+"ListPrice": 676020.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1476.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A2A3"
+"UnparsedAddress": "125 CATHERINE Street, New Hamburg, Ontario N3A2A3"
+"Coordinates": array:2 [
0 => -80.7174897
1 => 43.3841664
]
+"Latitude": 43.3841664
+"Longitude": -80.7174897
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "QUICK CLOSINGS AVAILABLE (move-in and avoid occupancy fees!). Welcome to New Hamburg's latest townhouse development, Cassel Crossing! Featuring the quality now under construction traditional street front townhouse The Park 3 bed layout interior unit by a local builder. PICK YOUR FINISHES WHILE YOU CAN; quartz countertops throughout, main floor luxury vinyl plank, 9ft main floor ceilings, central air & ERV and wood deck. Enjoy small town living with big city comforts (Wilmot Rec Centre, Mike Schout Wetlands Preserve, Downtown Shops, Restaurants) & much more! Conveniently located only 15 minutes to KW and 45 minutes to the GTA. BONUS: This unit comes with over $5,600 in extra upgrades already included (double sinks in main & primary bath, additional pot lights throughout, two piece basement rough-in and sanitary back flow preventer) and limited time offer (6pc appliance package) with purchase and $15,000 in additional FREE UPGRADES!!! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave Built-in"
]
+"AssociationFee": "285"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Other, See Remarks"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T14:58:46.579578+00:00"
+"Directions": "Waterloo Street to Catherine Street"
+"ExteriorFeatures": array:5 [
0 => "Concrete"
1 => "Brick"
2 => "Aluminum siding"
3 => "Vinyl siding"
4 => "Shingles"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2080956"
+"ListOfficeKey": "300660"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T14:20:15Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-21T19:32:40Z"
+"Stories": "2.0"
+"StreetName": "CATHERINE"
+"StreetNumber": "125"
+"StreetSuffix": "Street"
+"SubdivisionName": "660 - New Hamburg"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29875200/125-catherine-street-new-hamburg"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2248795"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "300896"
+"GeocodeManualYN": true
+"ZoningDescription": "Z10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1476
+"OriginalEntryTimestamp": "2026-06-09T14:20:14.95Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1355792"
+"ListOfficeNationalAssociationId": "1491536"
+"CoListAgentNationalAssociationId": "1487649"
+"CoListOfficeNationalAssociationId": "1494469"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875200')"
+"ID": "1511691"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 36
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]