array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29113081/Property?$select=ALL&$top=20&$filter=ListingKey eq 29113081&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 29113081/Property?$select=ALL&$top=20&$filter=ListingKey eq 29113081&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23309
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23311
+post_id: "426493"
+post_author: 1
+"ListingKey": "29113081"
+"ListingId": "40787175"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-25T22:45:15Z"
+"RFModificationTimestamp": "2025-11-25T22:49:42Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.2
+"LivingArea": 2689.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A1B7"
+"UnparsedAddress": "112 JACOB Street, New Hamburg, Ontario N3A1B7"
+"Coordinates": array:2 [
0 => -80.7094735
1 => 43.379731
]
+"Latitude": 43.379731
+"Longitude": -80.7094735
+"YearBuilt": 1895
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in the heart of picturesque New Hamburg, steps from the scenic Nith River, this updated and well maintained 3 bed, 3 full bath home with heated pool on a deep lot combines small-town charm with modern comfort. The potential for income or multi-generational living lives in the front living room and main entrance on the main floor and a 1 bed, 1 bath setup on the second floor to create a private suite. A long covered porch gives a welcoming and relaxed impression to this move in ready family home. The main entrance offers an outstanding architectural feature of a custom stone archway leading into the den with gas fireplace, bay window and views through to the lush backyard. A mud room offers a flex space leading to both the garage/workshop and the backyard. The spacious kitchen boasts crushed granite countertops and a brand new island. Just off the kitchen is a full 3 pc bath with claw foot tub. The expansive living room offers one of 2 wood burning fireplaces, wooden shutters, built in office, pantry and a storage closet with hatch to the basement. The back room hosts the 2nd wood burning fireplace and has the best views of the backyard oasis. Main floor laundry is tucked out of sight but convenient. 3 well appointed bedrooms are bright and airy with one being used as a music room. The front staircase landing is large and ideal for a yoga or flex space. A 4pc cheater ensuite and 4pc full bath round out the second floor with walk out balcony. The fully fenced and gated yard boasts a pool, outdoor bar, and 3 sheds surrounded by mature trees and gardens. With thoughtful updates, and plenty of space to entertain indoors and out, this home offers a rare opportunity to enjoy the charm of New Hamburg just minutes from local shops, grocery store, restaurants, rec facilities, sports fields, trails. Quick access to hwy 7/8 makes your 10 min drive to Kitchener a breeze. Discover the character and natural beauty of this unique home set in a friendly neighborhood. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-18T14:52:07.309978+00:00"
+"Directions": "Peel St turns into Mill St then turn right onto Jacob St"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1915283"
+"ListOfficeKey": "283386"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Private Yard"
]
+"LotSizeDimensions": "0.2"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-18T14:08:44Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-25T22:30:52Z"
+"Stories": "2.0"
+"StreetName": "JACOB"
+"StreetNumber": "112"
+"StreetSuffix": "Street"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "4223.67"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/112_jacob_street_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1540121331"
"RoomType" => "Bedroom"
"ListingId" => "40787175"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 11'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.53Z"
]
1 => array:11 [
"RoomKey" => "1540121332"
"RoomType" => "Bedroom"
"ListingId" => "40787175"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => "10'2'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.53Z"
]
2 => array:11 [
"RoomKey" => "1540121333"
"RoomType" => "4pc Bathroom"
"ListingId" => "40787175"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.53Z"
]
3 => array:11 [
"RoomKey" => "1540121334"
"RoomType" => "4pc Bathroom"
"ListingId" => "40787175"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.53Z"
]
4 => array:11 [
"RoomKey" => "1540121335"
"RoomType" => "Primary Bedroom"
"ListingId" => "40787175"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.54Z"
]
5 => array:11 [
"RoomKey" => "1540121336"
"RoomType" => "Mud room"
"ListingId" => "40787175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.54Z"
]
6 => array:11 [
"RoomKey" => "1540121337"
"RoomType" => "3pc Bathroom"
"ListingId" => "40787175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.54Z"
]
7 => array:11 [
"RoomKey" => "1540121338"
"RoomType" => "Dining room"
"ListingId" => "40787175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.54Z"
]
8 => array:11 [
"RoomKey" => "1540121339"
"RoomType" => "Den"
"ListingId" => "40787175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.54Z"
]
9 => array:11 [
"RoomKey" => "1540121340"
"RoomType" => "Family room"
"ListingId" => "40787175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.54Z"
]
10 => array:11 [
"RoomKey" => "1540121341"
"RoomType" => "Living room"
"ListingId" => "40787175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 22'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.54Z"
]
11 => array:11 [
"RoomKey" => "1540121342"
"RoomType" => "Kitchen"
"ListingId" => "40787175"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29113081"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-25T22:30:52.54Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29113081/112-jacob-street-new-hamburg"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 2689
+"OriginalEntryTimestamp": "2025-11-18T14:08:43.98Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:50 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6327116472"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/ed9803aa306966176c0fda6cc40bb49f.webp"
"MediaSize" => 206524
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-ed9803aa306966176c0fda6cc40bb49f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6327116482"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/a48835b29597d362c393b0b746383a38.webp"
"MediaSize" => 130448
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-a48835b29597d362c393b0b746383a38.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "entry looking into family room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6327116491"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/3861fa24dfd37b986a5687cfa233fd8b.webp"
"MediaSize" => 129027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-3861fa24dfd37b986a5687cfa233fd8b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "wood fireplace in living room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6327116509"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/b10843106d376ef314ae377f4e23a9f8.webp"
"MediaSize" => 101369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-b10843106d376ef314ae377f4e23a9f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6327116520"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/5472cee6520665fa0f9451ebdd241631.webp"
"MediaSize" => 138152
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-5472cee6520665fa0f9451ebdd241631.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6327116535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/9175ddd08a168cf2b3155ec4e3c5bbb2.webp"
"MediaSize" => 138619
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-9175ddd08a168cf2b3155ec4e3c5bbb2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6327116546"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/a430c8fcd343680e54cb94b3d8bc8243.webp"
"MediaSize" => 135889
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-a430c8fcd343680e54cb94b3d8bc8243.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6327116559"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/6b80173e6977e309f802ae3a827ca66d.webp"
"MediaSize" => 115076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-6b80173e6977e309f802ae3a827ca66d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "one year old wood burning fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6327116576"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/03e035a753a9ab721c79a4f3d08da0b8.webp"
"MediaSize" => 127948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-03e035a753a9ab721c79a4f3d08da0b8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "wood fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6327116590"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/176c2693e7d1e4a7e5f485f8f29649ac.webp"
"MediaSize" => 121288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-176c2693e7d1e4a7e5f485f8f29649ac.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6327116600"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/7e9f6906677087aa6cd5449e8f9c7f5d.webp"
"MediaSize" => 96956
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-7e9f6906677087aa6cd5449e8f9c7f5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "custom glass door separating the living/office and kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6327116632"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/d52303e762364c2baf1ca3c7151ce8aa.webp"
"MediaSize" => 96763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-d52303e762364c2baf1ca3c7151ce8aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "custom glass door separating the living/office and kitchen"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6327116643"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/ba91ec2038a00c244b900b1c02a24971.webp"
"MediaSize" => 126428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-ba91ec2038a00c244b900b1c02a24971.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6327116655"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/c9726733116a9db24ef0972fdbe3fe17.webp"
"MediaSize" => 131884
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-c9726733116a9db24ef0972fdbe3fe17.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6327116668"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/af78e73516b2305d7386cf3823bc1106.webp"
"MediaSize" => 134709
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-af78e73516b2305d7386cf3823bc1106.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6327116680"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/5c2e42bf1bab966445c66cba40203d21.webp"
"MediaSize" => 98850
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-5c2e42bf1bab966445c66cba40203d21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "main floor 3 pc full bath"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6327116696"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/613a2225ac27f306b7bf3024c6588cb1.webp"
"MediaSize" => 73842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-613a2225ac27f306b7bf3024c6588cb1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "entrance to back yard and garage/storage rooms"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6327116708"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/5c8c0b289f59aeae35b850ebc94f0b96.webp"
"MediaSize" => 150996
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-5c8c0b289f59aeae35b850ebc94f0b96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Den with wood fireplace and dining room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6327116723"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/4792c2fb270431709ecee9004e8559f2.webp"
"MediaSize" => 166559
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-4792c2fb270431709ecee9004e8559f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6327116737"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/aa096f6a0d711114764b3aa273822830.webp"
"MediaSize" => 157905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-aa096f6a0d711114764b3aa273822830.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6327116749"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/49ab63b44b1b18dda29dfb7aacb89737.webp"
"MediaSize" => 148522
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-49ab63b44b1b18dda29dfb7aacb89737.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6327116764"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/f2f69556ba28833ae756445ad841f5b6.webp"
"MediaSize" => 160139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-f2f69556ba28833ae756445ad841f5b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "wood burning fireplace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6327116768"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/26778d6d84cb4a14e1c6b44fd9ecb201.webp"
"MediaSize" => 86838
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-26778d6d84cb4a14e1c6b44fd9ecb201.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "second bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6327116778"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/e9876191a2e08e9a456ab766d7358e72.webp"
"MediaSize" => 54070
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-e9876191a2e08e9a456ab766d7358e72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6327116788"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/9aa269448be8398278ba41dd70e1f40c.webp"
"MediaSize" => 64957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-9aa269448be8398278ba41dd70e1f40c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6327116799"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/fc439984a3724c430b7d5cf4c545c40b.webp"
"MediaSize" => 99267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-fc439984a3724c430b7d5cf4c545c40b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "third bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6327116811"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/9d82a9b44c657d74f9ef9f9f8cff6b81.webp"
"MediaSize" => 96220
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-9d82a9b44c657d74f9ef9f9f8cff6b81.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "third bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6327116820"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/d55821bf8449e038c92b9638080101c6.webp"
"MediaSize" => 80788
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-d55821bf8449e038c92b9638080101c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "upstairs back landing to second floor and balcony"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6327116828"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/5b52f863717307d2f2bb535109893806.webp"
"MediaSize" => 92326
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-5b52f863717307d2f2bb535109893806.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "upstairs front landing to second floor currently used as a yoga space"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6327116838"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/cc7b2c53ccd3b48c5c47d0e796fa515e.webp"
"MediaSize" => 100637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-cc7b2c53ccd3b48c5c47d0e796fa515e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6327116846"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/889fd3c7b75be0c17ff17470078a1cdc.webp"
"MediaSize" => 81304
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-889fd3c7b75be0c17ff17470078a1cdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6327116858"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/ed8b34bcb5fef544b1d3588f9f170b0f.webp"
"MediaSize" => 78621
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-ed8b34bcb5fef544b1d3588f9f170b0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6327116866"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/efdc53388daba71b43738e58597716ff.webp"
"MediaSize" => 101469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-efdc53388daba71b43738e58597716ff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "primary bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6327116878"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/1428f6b6b2071ce433292b1bd5db383d.webp"
"MediaSize" => 147566
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-1428f6b6b2071ce433292b1bd5db383d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6327116886"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/5d33db7259bd940c8c0eaaf015071baf.webp"
"MediaSize" => 127638
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-5d33db7259bd940c8c0eaaf015071baf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6327116891"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/c72e48ceb1277d6617dfa7679415d012.webp"
"MediaSize" => 82821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-c72e48ceb1277d6617dfa7679415d012.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6327116899"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/310ef2cd36ebdf9d4ac2d1e8d5eb9a7f.webp"
"MediaSize" => 113835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-310ef2cd36ebdf9d4ac2d1e8d5eb9a7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6327116914"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/ce6087968abfdd4de94fb301b97ad622.webp"
"MediaSize" => 161057
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-ce6087968abfdd4de94fb301b97ad622.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "winterized pool"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
"ModificationTimestamp" => "2025-11-18T14:08:43.98Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6327116919"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29113081/970b674692388f2a902e8cc2c91f5df7.webp"
"MediaSize" => 223151
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29113081/thumbnail-970b674692388f2a902e8cc2c91f5df7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40787175"
"ResourceRecordKey" => "29113081"
…1
]
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29113081')"
+"ID": "426493"
}
]
+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=OfficeKey eq 283386/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283386&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283386/Office?$select=ALL&$top=10&$filter=OfficeKey eq 283386&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25185
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "Re/Max Icon Realty"
+"OfficeEmail": null
+"OfficePhone": "226-777-5833"
+"OfficeMlsId": "KW38"
+"ModificationTimestamp": "2025-08-19T15:50:12Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "283386"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "33-620 Davenport Rd"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "Waterloo"
+"OfficePostalCode": "N2V2C"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone - Hamilton-Burlington"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1328478"
+"OriginalEntryTimestamp": "2018-04-24T17:39:00Z"
+"Media": array:1 [
0 => array:10 [ …10]
]
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [ …6]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1379496"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('283386')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1915283/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1915283&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1915283/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1915283&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25190
+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 29113081" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24769
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29113081/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29113081&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29113081/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 29113081&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24695
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24725
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29128760"
+"ListingKey": "29113081"
+"ListingId": "40787175"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-11-23"
+"OpenHouseStartTime": "2025-11-23T14:00:00Z"
+"OpenHouseEndTime": "2025-11-23T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-11-23T19:14:47Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29128760')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24727
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "29207625"
+"ListingKey": "29113081"
+"ListingId": "40787175"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2025-11-29"
+"OpenHouseStartTime": "2025-11-29T14:00:00Z"
+"OpenHouseEndTime": "2025-11-29T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2025-11-28T19:30:33Z"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/OpenHouse('29207625')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29113081 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7094735 43.379731)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29113081 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7094735 43.379731)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29113081 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7094735 43.379731)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 29113081 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7094735 43.379731)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25209
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24657
+post_id: "447043"
+post_author: 1
+"ListingKey": "29138871"
+"ListingId": "X12578462"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T17:41:06Z"
+"RFModificationTimestamp": "2025-11-26T19:12:03Z"
+"ListPrice": 1049999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A4N5"
+"UnparsedAddress": "49 THEODORE SCHULER BOULEVARD, Wilmot, Ontario N3A4N5"
+"Coordinates": array:2 [
0 => -80.718739
1 => 43.3889238
]
+"Latitude": 43.3889238
+"Longitude": -80.718739
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this meticulously maintained 3-bedroom, 2.5-bathroom home offering 2,185 sq. ft. above grade plus a 912 sq. ft. unfinished basement, located in the highly desirable community of New Hamburg in the Township of Wilmot. Built in 2016 and beautifully updated throughout, this home features a premium 151 ft deep reverse pie-shaped lot and a stunning backyard oasis with an inground pool and hot tub. The main floor offers a bright and spacious open-concept living, dining, and kitchen area, highlighted by large windows that flood the home with natural light. Enjoy the new custom kitchen (July 2025) by Millbank Family Furniture, featuring high-end cabinetry, KitchenAid appliances, a large island, a custom pantry, and a custom mudroom with direct garage access. The living room features a stunning stone gas fireplace (2020) with custom-built-in cabinets on both sides. A vaulted foyer with a walk-in closet and fresh paint throughout (2024-2025) completes the main level. The second floor includes a convenient laundry room, a spacious primary suite with a beautiful ensuite and walk-in closet, and two additional large bedrooms-one with a walk-in closet and the other with a deep, oversized closet. A versatile flex space is perfect for a home office, lounge, or can be easily converted into a fourth bedroom. Deep closets throughout provide exceptional storage. Step outside to your fully landscaped backyard oasis, featuring a stunning inground pool (2020), Arctic Spa Aurora hot tub (2021), and a custom SpaShed built during the pool installation. The premium lot offers exceptional privacy and space for entertaining. Additional features include: Bosch dishwasher; gas stove and gas fireplace; water softener and hot water tank (Reliance); furnace, AC, and roof (2016). This home has been impeccably cared for and is truly move-in ready. A must-see property combining luxury, comfort, and modern upgrades in one of Wilmot Township's most sought-after neighbourhoods. (id:62650)"
+"Appliances": array:16 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Hot Tub"
5 => "Dishwasher"
6 => "Stove"
7 => "Range"
8 => "Oven"
9 => "Dryer"
10 => "Microwave"
11 => "Hood Fan"
12 => "Window Coverings"
13 => "Garage door opener"
14 => "Garage door opener remote(s)"
15 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2025-11-26T19:11:42.544618+00:00"
+"Directions": "Cross Streets: Theodore Schuler Blvd & Forrest Ave E. ** Directions: Forrest Ave To Theodore Schuler Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2190528"
+"ListOfficeKey": "291795"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Flat site"
1 => "Conservation/green belt"
2 => "Gazebo"
3 => "Sump Pump"
]
+"LotSizeDimensions": "41.4 x 151.5 FT ; 60.79 x 151.46 x 27.59 x 13.88 ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T17:32:24Z"
+"PhotosCount": 50
+"PoolFeatures": array:2 [
0 => "Inground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T17:32:24Z"
+"Stories": "2.0"
+"StreetName": "Theodore Schuler"
+"StreetNumber": "49"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "6054.74"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youtu.be/IZ8tYuF-LPw"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29138871/49-theodore-schuler-boulevard-wilmot"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"ZoningDescription": "Z2B"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 41.4
+"OriginalEntryTimestamp": "2025-11-26T17:32:23.49Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138871')"
+"ID": "447043"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25031
+post_id: "447044"
+post_author: 1
+"ListingKey": "29138110"
+"ListingId": "40789796"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T15:05:54Z"
+"RFModificationTimestamp": "2025-11-26T17:26:31Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3107.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N2A1K8"
+"UnparsedAddress": "466 HILLVIEW Crescent, New Hamburg, Ontario N2A1K8"
+"Coordinates": array:2 [
0 => -80.7183191
1 => 43.3733436
]
+"Latitude": 43.3733436
+"Longitude": -80.7183191
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This unique property offers two fully independent dwellings—a spacious 4-bedroom main home and a charming 1-bedroom cottage—providing exceptional flexibility for multigenerational living, rental income, or a dedicated studio or workspace. The main house is bright, welcoming, and beautifully updated, featuring a stunning great room with new windows that fill the space with natural light and a cozy fireplace that can be converted back to gas if desired. Surrounded by beautifully maintained gardens, the outdoor space feels like a private retreat, complete with a covered area equipped with a gas line for year-round BBQing or the perfect spot for a future hot tub. Tucked at the back of the property, the separate cottage functions as a fully self-sufficient 1-bedroom unit with its own private gate and pathway. It includes a full kitchen with a gas line ready for a future gas range, an ensuite bath, a new furnace and AC, and an unfinished second level with windows offering a simple opportunity for additional living space. With extensive updates completed over the last few years, pride of ownership is evident throughout both dwellings—allowing you to move in, settle comfortably, and take advantage of all the possibilities this versatile property offers. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T17:26:23.650242+00:00"
+"Directions": "Hwy 8 to Peel Street to Huron Street to Hillview Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1944030"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Skylight"
1 => "Automatic Garage Door Opener"
2 => "In-Law Suite"
]
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T14:59:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T14:59:42Z"
+"Stories": "1.0"
+"StreetName": "HILLVIEW"
+"StreetNumber": "466"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "5798"
+"VirtualTourURLUnbranded": "https://youriguide.com/466_hillview_crescent_new_hamburg_on/"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29138110/466-hillview-crescent-new-hamburg"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Z3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 84.0
+"AboveGradeFinishedArea": 2073
+"BelowGradeFinishedArea": 1034
+"OriginalEntryTimestamp": "2025-11-26T14:59:42.9Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138110')"
+"ID": "447044"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24656
+post_id: "447045"
+post_author: 1
+"ListingKey": "29138538"
+"ListingId": "40790448"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T21:15:17Z"
+"RFModificationTimestamp": "2025-11-26T21:20:06Z"
+"ListPrice": 1049999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 3097.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A4N5"
+"UnparsedAddress": "49 THEODORE SCHULER Boulevard, New Hamburg, Ontario N3A4N5"
+"Coordinates": array:2 [
0 => -80.7186813
1 => 43.3889275
]
+"Latitude": 43.3889275
+"Longitude": -80.7186813
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to this meticulously maintained 3-bedroom, 2.5-bathroom home offering 2,185 sq. ft. above grade plus a 912 sq. ft. unfinished basement, located in the highly desirable community of New Hamburg in the Township of Wilmot. Built in 2016 and beautifully updated throughout, this home features a premium 151 ft deep reverse pie-shaped lot and a stunning backyard oasis with an inground pool and hot tub. The main floor offers a bright and spacious open-concept living, dining, and kitchen area, highlighted by large windows that flood the home with natural light. Enjoy the new custom kitchen (July 2025) by Millbank Family Furniture, featuring high-end cabinetry, KitchenAid appliances, a large island, a custom pantry, and a custom mudroom with direct garage access. The living room features a stunning stone gas fireplace (2020) with custom-built-in cabinets on both sides. A vaulted foyer with a walk-in closet and fresh paint throughout (2024–2025) completes the main level. The second floor includes a convenient laundry room, a spacious primary suite with a beautiful ensuite and walk-in closet, and two additional large bedrooms—one with a walk-in closet and the other with a deep, oversized closet. A versatile flex space is perfect for a home office, lounge, or can be easily converted into a fourth bedroom. Deep closets throughout provide exceptional storage. Step outside to your fully landscaped backyard oasis, featuring a stunning inground pool (2020), Arctic Spa Aurora hot tub (2021), and a custom SpaShed built during the pool installation. The premium lot offers exceptional privacy and space for entertaining. Additional features include: Bosch dishwasher; gas stove and gas fireplace; water softener and hot water tank (Reliance); furnace, AC, and roof (2016). This home has been impeccably cared for and is truly move-in ready. A must-see property combining luxury, comfort, and modern upgrades in one of Wilmot Township’s most sought-after neighbourhoods. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Gas stove(s)"
5 => "Range - Gas"
6 => "Dishwasher"
7 => "Dryer"
8 => "Central Vacuum - Roughed In"
9 => "Hood Fan"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T17:00:12.869038+00:00"
+"Directions": "Forrest Ave To Theodore Schuler Blvd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2070856"
+"ListOfficeKey": "291786"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Gazebo"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T16:25:21Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T21:04:03Z"
+"Stories": "2.0"
+"StreetName": "THEODORE SCHULER"
+"StreetNumber": "49"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "6054.74"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youtu.be/G7M6MVhzm00"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29138538/49-theodore-schuler-boulevard-new-hamburg"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "None"
]
+"ZoningDescription": "Z2B"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 41.0
+"AboveGradeFinishedArea": 2185
+"BelowGradeFinishedArea": 912
+"OriginalEntryTimestamp": "2025-11-26T16:25:21.04Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138538')"
+"ID": "447045"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24699
+post_id: "445472"
+post_author: 1
+"ListingKey": "29138361"
+"ListingId": "X12577930"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-26T16:05:44Z"
+"RFModificationTimestamp": "2025-11-26T16:51:56Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A1K8"
+"UnparsedAddress": "466 HILLVIEW CRESCENT, Wilmot, Ontario N3A1K8"
+"Coordinates": array:2 [
0 => -80.7183773
1 => 43.3730298
]
+"Latitude": 43.3730298
+"Longitude": -80.7183773
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This unique property offers two fully independent dwellings-a spacious 4-bedroom main home and a charming 1-bedroom cottage-providing exceptional flexibility for multigenerational living, rental income, or a dedicated studio or workspace. The main house is bright, welcoming, and beautifully updated, featuring a stunning great room with new windows that fill the space with natural light and a cozy fireplace that can be converted back to gas if desired. Surrounded by beautifully maintained gardens, the outdoor space feels like a private retreat, complete with a covered area equipped with a gas line for year-round BBQing or the perfect spot for a future hot tub. Tucked at the back of the property, the separate cottage functions as a fully self-sufficient 1-bedroom unit with its own private gate and pathway. It includes a full kitchen with a gas line ready for a future gas range, an ensuite bath, a new furnace and AC, and an unfinished second level with windows offering a simple opportunity for additional living space. With extensive updates completed over the last few years, pride of ownership is evident throughout both dwellings-allowing you to move in, settle comfortably, and take advantage of all the possibilities this versatile property offers. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-26T16:51:45.016061+00:00"
+"Directions": "Cross Streets: Huron Street & Hillview Cres. ** Directions: Hwy 8 to Peel Street to Huron Street to Hillview Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2138804"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "83.9 x 108.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-26T15:59:04Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-26T15:59:04Z"
+"Stories": "1.0"
+"StreetName": "Hillview"
+"StreetNumber": "466"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "5798"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/466_hillview_crescent_new_hamburg_on/"
+"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": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29138361/466-hillview-crescent-wilmot"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "Z3"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 83.1
+"OriginalEntryTimestamp": "2025-11-26T15:59:04.46Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29138361')"
+"ID": "445472"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24714
+post_id: "435048"
+post_author: 1
+"ListingKey": "29123438"
+"ListingId": "40788727"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T15:15:33Z"
+"RFModificationTimestamp": "2025-11-24T15:19:17Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.43
+"LivingArea": 2108.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A1M2"
+"UnparsedAddress": "407 FAIRVIEW Street, New Hamburg, Ontario N3A1M2"
+"Coordinates": array:2 [
0 => -80.707101
1 => 43.3718046
]
+"Latitude": 43.3718046
+"Longitude": -80.707101
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Beautiful Bungalow-Style Rental in New Hamburg – All Utilities Included. This bright and spacious bungalow offers comfortable family living in a desirable New Hamburg location close to the river, parks, trails, and local amenities. The main floor features two well-sized bedrooms, two bathrooms, gorgeous hardwood flooring throughout, and triple-paned windows that create a quiet, energy-efficient living environment. The kitchen showcases a cool rustic aesthetic with concrete countertops and plenty of character, adding warmth and charm to the heart of the home. A furnished home office sits just off the main living area and features a stunning brick accent wall. With views overlooking the backyard, it provides an ideal work-from-home setup with style and natural light. The fully finished basement offers excellent flexibility a full bathroom, and an additional room that can be used as either a bedroom or storage—perfect for guests, extended family, or a dedicated workspace. All utilities, including hydro, electricity, water, and internet, are included in the rent, and two driveway parking spaces are available. Quarterly furnace and filter maintenance is completed by the landlord, and all landscaping and lawn care are fully handled. The shared yard includes a vegetable garden, a chicken coop available for tenant use if desired, and plenty of outdoor space to enjoy. Triple-paned windows and solid construction provide excellent sound insulation throughout the home. This rental is ideal for families seeking a quiet, well-cared-for property with character, flexible living space, and a welcoming sense of community. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:3 [
0 => "Heat"
1 => "Electricity"
2 => "Water"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"ConstructionMaterials": array:3 [
0 => "Wood frame"
1 => "Concrete block"
2 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-20T23:46:42.461105+00:00"
+"Directions": "Peel St to Bleams Rd to Fairview"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1902312"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.43"
+"PhotosChangeTimestamp": "2025-11-20T20:19:34Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T15:00:24Z"
+"Stories": "2.0"
+"StreetName": "FAIRVIEW"
+"StreetNumber": "407"
+"StreetSuffix": "Street"
+"SubdivisionName": "660 - New Hamburg"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29123438/407-fairview-street-new-hamburg"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"TotalActualRent": 3200
+"ZoningDescription": "Z2"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 133.0
+"AboveGradeFinishedArea": 1296
+"BelowGradeFinishedArea": 812
+"OriginalEntryTimestamp": "2025-11-20T20:19:34.55Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"Media": array:42 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29123438')"
+"ID": "435048"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25038
+post_id: "430020"
+post_author: 1
+"ListingKey": "29117950"
+"ListingId": "X12558316"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-19T17:10:23Z"
+"RFModificationTimestamp": "2025-11-19T17:41:41Z"
+"ListPrice": 1600000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A0B1"
+"UnparsedAddress": "215 HOSTETLER ROAD, Wilmot, Ontario N3A0B1"
+"Coordinates": array:2 [
0 => -80.7111358
1 => 43.3927199
]
+"Latitude": 43.3927199
+"Longitude": -80.7111358
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Exquisite Custom-Built Home with Walkout Basement & Inground Pool, set on a picturesque quarter-acre lot! This exceptional residence offers nearly 5,000 sq. ft. of luxurious living space, including a fully finished walkout basement. From the moment you step inside, the craftsmanship is unmistakable, with soaring ceilings, French doors, crown moulding, elegant wainscoting, and gleaming hardwood floors defining the main level. Just off the foyer, a private home office provides the perfect space for work or study. The grand two-storey living and dining area showcases a cast stone fireplace with floor-to-ceiling mantle, creating an impressive focal point. The adjacent chef's kitchen is both stylish and functional, with granite countertops, a tile backsplash, gas range, abundant cabinetry, island seating and a bright breakfast area with sliding doors to the upper deck. A cozy family room, powder room, laundry area, and mudroom with access to the triple-car garage complete the main floor. Upstairs, the primary suite is a true retreat, complete with a private balcony overlooking the backyard, a walk-in closet, and a spa-like 5-piece ensuite with double vanity, soaker tub, and glass shower. The three additional bedrooms include one with a private ensuite and walk-in closet, and two more joined by a Jack-and-Jill bathroom-all overlooking the stunning great room below. The fully finished walkout basement offers excellent in-law suite potential, complete with a kitchenette/wet bar, large recreation room, bedroom with ensuite and walk-in closet, home gym or den, and a powder room. Outside, you'll find a private backyard oasis with a glass-paneled deck, lower patio, and inground pool surrounded by beautifully landscaped gardens. This remarkable property offers the perfect blend of elegance, space, and resort-style living. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Garage door opener remote(s)"
]
+"Basement": array:4 [
0 => "Partially finished"
1 => "Walk out"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T17:41:17.325870+00:00"
+"Directions": "Waterloo"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2100955"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "74 x 195 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T17:01:41Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-19T17:01:41Z"
+"Stories": "2.0"
+"StreetName": "Hostetler"
+"StreetNumber": "215"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "8512"
+"VirtualTourURLUnbranded": "https://youriguide.com/215_hostetler_road_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29117950/215-hostetler-road-wilmot"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 5
+"FrontageLengthNumeric": 74.0
+"OriginalEntryTimestamp": "2025-11-19T17:01:41.18Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29117950')"
+"ID": "430020"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23323
+post_id: "430021"
+post_author: 1
+"ListingKey": "29117475"
+"ListingId": "40788777"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-19T15:55:45Z"
+"RFModificationTimestamp": "2025-11-19T16:43:19Z"
+"ListPrice": 1600000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.26
+"LivingArea": 4889.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A0B1"
+"UnparsedAddress": "215 HOSTETLER Road, New Hamburg, Ontario N3A0B1"
+"Coordinates": array:2 [
0 => -80.7111512
1 => 43.3927298
]
+"Latitude": 43.3927298
+"Longitude": -80.7111512
+"YearBuilt": 2011
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Exquisite Custom-Built Home with Walkout Basement & Inground Pool, set on a picturesque quarter-acre lot! This exceptional residence offers nearly 5,000 sq. ft. of luxurious living space, including a fully finished walkout basement. From the moment you step inside, the craftsmanship is unmistakable, with soaring ceilings, French doors, crown moulding, elegant wainscoting, and gleaming hardwood floors defining the main level. Just off the foyer, a private home office provides the perfect space for work or study. The grand two-storey living and dining area showcases a cast stone fireplace with floor-to-ceiling mantle, creating an impressive focal point. The adjacent chef’s kitchen is both stylish and functional, with granite countertops, a tile backsplash, gas range, abundant cabinetry, island seating and a bright breakfast area with sliding doors to the upper deck. A cozy family room, powder room, laundry area, and mudroom with access to the triple-car garage complete the main floor. Upstairs, the primary suite is a true retreat, complete with a private balcony overlooking the backyard, a walk-in closet, and a spa-like 5-piece ensuite with double vanity, soaker tub, and glass shower. The three additional bedrooms include one with a private ensuite and walk-in closet, and two more joined by a Jack-and-Jill bathroom—all overlooking the stunning great room below. The fully finished walkout basement offers excellent in-law suite potential, complete with a kitchenette/wet bar, large recreation room, bedroom with ensuite and walk-in closet, home gym or den, and a powder room. Outside, you'll find a private backyard oasis with a glass-paneled deck, lower patio, and inground pool surrounded by beautifully landscaped gardens. This remarkable property offers the perfect blend of elegance, space, and resort-style living. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-19T16:43:09.202663+00:00"
+"Directions": "Waterloo St / Hostetler Rd"
+"ExteriorFeatures": array:4 [
0 => "Wood"
1 => "Brick"
2 => "Stone"
3 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564479"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.26"
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-19T15:49:42Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-19T15:49:42Z"
+"Stories": "2.0"
+"StreetName": "HOSTETLER"
+"StreetNumber": "215"
+"StreetSuffix": "Road"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "8512"
+"VirtualTourURLUnbranded": "https://youriguide.com/215_hostetler_road_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29117475/215-hostetler-road-new-hamburg"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 74.0
+"AboveGradeFinishedArea": 3594
+"BelowGradeFinishedArea": 1295
+"OriginalEntryTimestamp": "2025-11-19T15:49:42.47Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29117475')"
+"ID": "430021"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "424028"
+post_author: 1
+"ListingKey": "29109845"
+"ListingId": "40788728"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T14:10:23Z"
+"RFModificationTimestamp": "2025-11-24T14:14:11Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1325.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A2B8"
+"UnparsedAddress": "166 ASTOR Crescent Unit# 302, New Hamburg, Ontario N3A2B8"
+"Coordinates": array:2 [
0 => -80.7181173
1 => 43.3871142
]
+"Latitude": 43.3871142
+"Longitude": -80.7181173
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Newly constructed boutique style condo building in New Hamburg, ON close to highway, schools, parks and shopping. Two bedrooms plus den, two baths and private balcony. Spacious kitchen with island, stainless appliances, laundry room in unit, seperate master bedroom with WIC and ensuite. Oversized ceiling height and large windows throughout. One level living (bungalow style)! Separate den/dining room, living room and laundry/storage/utility. Approx 1325 sq ft, carpet free, A/C. Unit is on the second floor. Parking spot, hot water heater rental, property taxes, garbage removal and lawn maintenance and water use are included for added convenience. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Window Coverings"
]
+"AssociationFeeIncludes": array:5 [
0 => "Exterior Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Water"
4 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-17T17:36:18.883087+00:00"
+"Directions": "Forrest Ave to Astor Cres"
+"ExteriorFeatures": array:4 [
0 => "Brick"
1 => "Aluminum siding"
2 => "Vinyl siding"
3 => "Shingles"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1922290"
+"ListOfficeKey": "275976"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Corner Site"
1 => "Balcony"
]
+"PhotosChangeTimestamp": "2025-11-17T17:11:50Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T13:59:17Z"
+"Stories": "1.0"
+"StreetName": "ASTOR"
+"StreetNumber": "166"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "660 - New Hamburg"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29109845/166-astor-crescent-unit-202-new-hamburg"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Freehold"
+"TotalActualRent": 2350
+"ZoningDescription": "z3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 119.0
+"AboveGradeFinishedArea": 1325
+"OriginalEntryTimestamp": "2025-11-17T17:00:21.18Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"Media": array:26 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29109845')"
+"ID": "424028"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: "422735"
+post_author: 1
+"ListingKey": "29109185"
+"ListingId": "40788649"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-17T15:05:22Z"
+"RFModificationTimestamp": "2025-11-17T18:57:12Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2869.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A4J7"
+"UnparsedAddress": "152 DEVONSHIRE Drive Unit# 18, New Hamburg, Ontario N3A4J7"
+"Coordinates": array:2 [
0 => -80.7001512
1 => 43.3674282
]
+"Latitude": 43.3674282
+"Longitude": -80.7001512
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 152 Devonshire Dr, a beautifully updated home in the coveted community of Stonecroft. This property is one of only a handful of lots offering premium greenspace views-an exceptionally rare find. W/ no rear neighbors & landscaped grounds it provides unmatched privacy & a spectacular setting. An oversized composite deck, perennial gardens, & sweeping views, all w/ southern exposure fills the yard & home w/ natural light. This strikingly beautiful move-in ready home (no renos required!) features new glass panel railings w/ nearly 3,000 SF of finished living space enhanced by approx. $70K in recent updates. A grand great rm w/ vaulted ceilings is anchored by a porcelain-surround gas fireplace & wall of windows framing private greenspace. The kitchen boasts new granite counters and appliances & a lrg centre island, under-cabinet lighting, & integrated dining area w/ walkout to the deck. The den/home office has built-in cabinetry, hickory flrs through the main lvl, new flring in the den, 2nd bath & primary suite. Freshly painted, w/ pot lights, California shutters, & designer light fixtures throughout. The primary suite offers backyard views, dual closets, & a spa-like ensuite w/ barn door, tiled glass shower, & oversized bubbler tub. A 2nd bdrm with vaulted ceiling, 4-pc bath, & laundry/mudrm w/ 2-car garage & yard access completes the main lvl. The finished lower lvl features a spacious rec rm w/ gas fireplace, wet bar w/ full-size fridge+freezer, workshop/hobby rm, 3rd bdrm, & 3-pc bath-ideal for entertaining/guests. Lrg capacity storage rooms offer built-in shelving. Furnace & A/C (2023), roof (2019). At Stonecroft, the lifestyle is as appealing as the home. Residents enjoy an 18,000 SF rec centre w/ indoor pool, fitness, party & games rms, billiards, library, media lounge, tennis courts, & 5 km of walking trails. Stonecroft is Waterloo Region’s premier destination for adult living, combining modern homes, a vibrant community, & a beautiful natural setting. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "239.83"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-17T15:32:14.071291+00:00"
+"Directions": "TOWNSHIP RD 12 TO STONECROFT WAY, THEN DEVONSHIRE DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932106"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-17T14:59:17Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-17T14:59:17Z"
+"Stories": "1.0"
+"StreetName": "DEVONSHIRE"
+"StreetNumber": "152"
+"StreetSuffix": "Drive"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "5249.07"
+"VirtualTourURLUnbranded": "https://youriguide.com/npp77_152_devonshire_dr_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29109185/152-devonshire-drive-unit-18-new-hamburg"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975048"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "76789"
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "Z15"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1458
+"BelowGradeFinishedArea": 1412
+"OriginalEntryTimestamp": "2025-11-17T14:59:17.28Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29109185')"
+"ID": "422735"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 44
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]
