array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 28705384/Property?$select=ALL&$top=20&$filter=ListingKey eq 28705384&$expand=Media/Property?$select=ALL&$top=20&$filter=ListingKey eq 28705384/Property?$select=ALL&$top=20&$filter=ListingKey eq 28705384&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23307
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23309
+post_id: "84447"
+post_author: 1
+"ListingKey": "28705384"
+"ListingId": "X12331613"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-10-23T00:45:59Z"
+"RFModificationTimestamp": "2025-10-23T00:59:11Z"
+"ListPrice": 1499999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A1M6"
+"UnparsedAddress": "477 FAIRVIEW STREET, Wilmot, Ontario N3A1M6"
+"Coordinates": array:2 [
0 => -80.7086563
1 => 43.3701324
]
+"Latitude": 43.3701324
+"Longitude": -80.7086563
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Ottawa Real Estate Board"
+"PublicRemarks": "Welcome to 477 Fairview Street located in the up and coming charming town of New Hamburg.This private home with no rear neighbors was completely gutted to bare frame and redesigned from the attic to the basement with new Plumbing, electrical, insulation, drywall, doors, lighting and electrical features to name a few! Only a 15-20 minute drive to K-W and within walking distance to downtown shops, restaurants, cafes, supermarkets, Licensing office. An entertainers dream home with ample parking for 12 + cars and an oversized 2 car garage to fit your cars + toys. Step out to the beautifully landscaped just under an acre backyard and take a swim in the large pool with diving board or enjoy some time in your enclosed hot tub with plugin for t.v. Enjoy some apple, pear or grapes from your very own trees. Two large sheds for all your storage needs. Close proximity to Catholic and Public schools for all ages. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Satellite Dish"
3 => "Dishwasher"
4 => "Range"
5 => "Oven"
6 => "Dryer"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Partially finished"
1 => "Unfinished"
2 => "N/A"
3 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-08-08T06:34:20.894451+00:00"
+"Directions": "Cross Streets: Peel St to Bleams Rd to Fairview St. ** Directions: Bleams road."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241186"
+"ListOfficeKey": "299944"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Irregular lot size"
1 => "Conservation/green belt"
2 => "Carpet Free"
]
+"LotSizeDimensions": "153.1 x 136.5 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Covered"
]
+"PhotosChangeTimestamp": "2025-08-07T22:25:06Z"
+"PhotosCount": 40
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-10-23T00:29:15Z"
+"Stories": "1.0"
+"StreetName": "Fairview"
+"StreetNumber": "477"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7547"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Tmgrji7KhpN"
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1520770253"
"RoomType" => "Primary Bedroom"
"ListingId" => "X12331613"
"RoomLevel" => "Main level"
"RoomWidth" => 4.88
"ListingKey" => "28705384"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.95Z"
]
1 => array:11 [
"RoomKey" => "1520770254"
"RoomType" => "Bedroom"
"ListingId" => "X12331613"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "28705384"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.95Z"
]
2 => array:11 [
"RoomKey" => "1520770255"
"RoomType" => "Other"
"ListingId" => "X12331613"
"RoomLevel" => "Basement"
"RoomWidth" => 2.13
"ListingKey" => "28705384"
"RoomLength" => 3.35
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.95Z"
]
3 => array:11 [
"RoomKey" => "1520770256"
"RoomType" => "Loft"
"ListingId" => "X12331613"
"RoomLevel" => "Upper Level"
"RoomWidth" => 2.74
"ListingKey" => "28705384"
"RoomLength" => 5.79
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.95Z"
]
4 => array:11 [
"RoomKey" => "1520770257"
"RoomType" => "Bedroom"
"ListingId" => "X12331613"
"RoomLevel" => "Main level"
"RoomWidth" => 3.05
"ListingKey" => "28705384"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.96Z"
]
5 => array:11 [
"RoomKey" => "1520770258"
"RoomType" => "Kitchen"
"ListingId" => "X12331613"
"RoomLevel" => "Main level"
"RoomWidth" => 7.01
"ListingKey" => "28705384"
"RoomLength" => 4.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.96Z"
]
6 => array:11 [
"RoomKey" => "1520770259"
"RoomType" => "Living room"
"ListingId" => "X12331613"
"RoomLevel" => "Main level"
"RoomWidth" => 6.71
"ListingKey" => "28705384"
"RoomLength" => 6.7
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.96Z"
]
7 => array:11 [
"RoomKey" => "1520770260"
"RoomType" => "Family room"
"ListingId" => "X12331613"
"RoomLevel" => "Main level"
"RoomWidth" => 4.88
"ListingKey" => "28705384"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.96Z"
]
8 => array:11 [
"RoomKey" => "1520770261"
"RoomType" => "Laundry room"
"ListingId" => "X12331613"
"RoomLevel" => "Main level"
"RoomWidth" => 5.79
"ListingKey" => "28705384"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.96Z"
]
9 => array:11 [
"RoomKey" => "1520770262"
"RoomType" => "Other"
"ListingId" => "X12331613"
"RoomLevel" => "Main level"
"RoomWidth" => 2.44
"ListingKey" => "28705384"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.96Z"
]
10 => array:11 [
"RoomKey" => "1520770263"
"RoomType" => "Family room"
"ListingId" => "X12331613"
"RoomLevel" => "Basement"
"RoomWidth" => 3.96
"ListingKey" => "28705384"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.97Z"
]
11 => array:11 [
"RoomKey" => "1520770264"
"RoomType" => "Other"
"ListingId" => "X12331613"
"RoomLevel" => "Basement"
"RoomWidth" => 3.05
"ListingKey" => "28705384"
"RoomLength" => 3.05
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2025-10-23T00:29:15.97Z"
]
]
+"ListAOR": "Ottawa"
+"TaxYear": 2024
+"ListAORKey": "76"
+"ListingURL": "www.realtor.ca/real-estate/28705384/477-fairview-street-wilmot"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 153.1
+"OriginalEntryTimestamp": "2025-08-07T22:25:05.51Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:40 [
0 => array:13 [
"Order" => 0
"MediaKey" => "6113980313"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/4ad10c43472923c13aaa84f9812c303d.webp"
"MediaSize" => 301393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-4ad10c43472923c13aaa84f9812c303d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
1 => array:13 [
"Order" => 1
"MediaKey" => "6113980378"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/6de4a8fa46fbc148739b95eb225c5ec3.webp"
"MediaSize" => 249761
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-6de4a8fa46fbc148739b95eb225c5ec3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
2 => array:13 [
"Order" => 2
"MediaKey" => "6113980502"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/1fb723d2194342e3b3dc1e9d072f462e.webp"
"MediaSize" => 177433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-1fb723d2194342e3b3dc1e9d072f462e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
3 => array:13 [
"Order" => 3
"MediaKey" => "6113980535"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/7e1afc79251a1894ca444bdc0801de58.webp"
"MediaSize" => 153012
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-7e1afc79251a1894ca444bdc0801de58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
4 => array:13 [
"Order" => 4
"MediaKey" => "6113980616"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/883c47a012614735c4ece03b2c421ddb.webp"
"MediaSize" => 169260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-883c47a012614735c4ece03b2c421ddb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
5 => array:13 [
"Order" => 5
"MediaKey" => "6113980700"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/7614e266308d240f7d1b0c5f10d525de.webp"
"MediaSize" => 131257
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-7614e266308d240f7d1b0c5f10d525de.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
6 => array:13 [
"Order" => 6
"MediaKey" => "6113980748"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/24c99b60de1053e4a02b96d2abdc15fe.webp"
"MediaSize" => 152242
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-24c99b60de1053e4a02b96d2abdc15fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
7 => array:13 [
"Order" => 7
"MediaKey" => "6113980866"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/6a7a32043c19e025a7185341a4c2f8e6.webp"
"MediaSize" => 166543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-6a7a32043c19e025a7185341a4c2f8e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
8 => array:13 [
"Order" => 8
"MediaKey" => "6113980918"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/d035bb661a9703b5fb554f0ea33f4860.webp"
"MediaSize" => 151295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-d035bb661a9703b5fb554f0ea33f4860.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
9 => array:13 [
"Order" => 9
"MediaKey" => "6113980973"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/71f60eb964a55ffde79eaa1f780da933.webp"
"MediaSize" => 151857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-71f60eb964a55ffde79eaa1f780da933.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
10 => array:13 [
"Order" => 10
"MediaKey" => "6113981012"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/c7bf5933c71df12379418c074a30bdfd.webp"
"MediaSize" => 159127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-c7bf5933c71df12379418c074a30bdfd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
11 => array:13 [
"Order" => 11
"MediaKey" => "6113981038"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/3691b0abe36a233570a19d0debf78f49.webp"
"MediaSize" => 130830
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-3691b0abe36a233570a19d0debf78f49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
12 => array:13 [
"Order" => 12
"MediaKey" => "6113981084"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/1ee7f4759688bbe53bbe8549655adbe6.webp"
"MediaSize" => 139247
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-1ee7f4759688bbe53bbe8549655adbe6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
13 => array:13 [
"Order" => 13
"MediaKey" => "6113981102"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/4293c164480e1aab39aa1e07dae0c73b.webp"
"MediaSize" => 133992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-4293c164480e1aab39aa1e07dae0c73b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
14 => array:13 [
"Order" => 14
"MediaKey" => "6113981149"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/12841e11d79524399f01dbb06e962987.webp"
"MediaSize" => 123729
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-12841e11d79524399f01dbb06e962987.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
15 => array:13 [
"Order" => 15
"MediaKey" => "6113981181"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/f099bce0963ee13ce463beb51daab50f.webp"
"MediaSize" => 143472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-f099bce0963ee13ce463beb51daab50f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
16 => array:13 [
"Order" => 16
"MediaKey" => "6113981214"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/f536344e72e17e9c6c659a0defc5a8df.webp"
"MediaSize" => 129506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-f536344e72e17e9c6c659a0defc5a8df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
17 => array:13 [
"Order" => 17
"MediaKey" => "6113981240"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/2d04b1c572fd155008982f019facbfb3.webp"
"MediaSize" => 164687
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-2d04b1c572fd155008982f019facbfb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
18 => array:13 [
"Order" => 18
"MediaKey" => "6113981269"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/4cca7bbbad9ec38e371b8bdee29749e3.webp"
"MediaSize" => 122193
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-4cca7bbbad9ec38e371b8bdee29749e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
19 => array:13 [
"Order" => 19
"MediaKey" => "6113981301"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/e546cedc9e4e0da19946d485d21ceb44.webp"
"MediaSize" => 129772
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-e546cedc9e4e0da19946d485d21ceb44.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
20 => array:13 [
"Order" => 20
"MediaKey" => "6113981339"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/e60a6009ca4be6a5129a98243fcec798.webp"
"MediaSize" => 158324
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-e60a6009ca4be6a5129a98243fcec798.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
21 => array:13 [
"Order" => 21
"MediaKey" => "6113981364"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/6869b180bcd8715e5f162fe2dc279982.webp"
"MediaSize" => 192936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-6869b180bcd8715e5f162fe2dc279982.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
22 => array:13 [
"Order" => 22
"MediaKey" => "6113981388"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/380b3eb3dd37c40e51117d27e4a86462.webp"
"MediaSize" => 120008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-380b3eb3dd37c40e51117d27e4a86462.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
23 => array:13 [
"Order" => 23
"MediaKey" => "6113981408"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/594dd802f277b743d9a20c57257086cf.webp"
"MediaSize" => 148715
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-594dd802f277b743d9a20c57257086cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
24 => array:13 [
"Order" => 24
"MediaKey" => "6113981440"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/b842e8f4dcb7c85f14664df60a66fc74.webp"
"MediaSize" => 160044
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-b842e8f4dcb7c85f14664df60a66fc74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
25 => array:13 [
"Order" => 25
"MediaKey" => "6113981470"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/a6eec233a38e03483f742a3832dab2a6.webp"
"MediaSize" => 128338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-a6eec233a38e03483f742a3832dab2a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
26 => array:13 [
"Order" => 26
"MediaKey" => "6113981494"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/3af0b976095c2c76ece267d9a6af8bdc.webp"
"MediaSize" => 205031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-3af0b976095c2c76ece267d9a6af8bdc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
27 => array:13 [
"Order" => 27
"MediaKey" => "6113981519"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/463c28dade2f01068018a6677c974e49.webp"
"MediaSize" => 129862
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-463c28dade2f01068018a6677c974e49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
28 => array:13 [
"Order" => 28
"MediaKey" => "6113981541"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/5081c8e7f22c858440e718674c3a43e6.webp"
"MediaSize" => 116112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-5081c8e7f22c858440e718674c3a43e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
29 => array:13 [
"Order" => 29
"MediaKey" => "6113981557"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/af4e35b82bd2fa38d64640398810b64d.webp"
"MediaSize" => 169905
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-af4e35b82bd2fa38d64640398810b64d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
30 => array:13 [
"Order" => 30
"MediaKey" => "6113981584"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/0053bf0acc4b633c2b8411e3c32e74ba.webp"
"MediaSize" => 137935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-0053bf0acc4b633c2b8411e3c32e74ba.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
31 => array:13 [
"Order" => 31
"MediaKey" => "6113981609"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/2bdd0434bb217725705e144a5a83c7c3.webp"
"MediaSize" => 144988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-2bdd0434bb217725705e144a5a83c7c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
32 => array:13 [
"Order" => 32
"MediaKey" => "6113981628"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/59104fe8b5a0a626460db6224d4b538e.webp"
"MediaSize" => 152808
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-59104fe8b5a0a626460db6224d4b538e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
33 => array:13 [
"Order" => 33
"MediaKey" => "6113981637"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/489b00b381a3e9890b2729b20d779654.webp"
"MediaSize" => 146449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-489b00b381a3e9890b2729b20d779654.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
34 => array:13 [
"Order" => 34
"MediaKey" => "6113981646"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/a349cdafadb3591513cb8e2aa715d048.webp"
"MediaSize" => 164191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-a349cdafadb3591513cb8e2aa715d048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
35 => array:13 [
"Order" => 35
"MediaKey" => "6113981653"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/cdb62f92fdfe27e25aabb8b50b9d86d1.webp"
"MediaSize" => 167846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-cdb62f92fdfe27e25aabb8b50b9d86d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
36 => array:13 [
"Order" => 36
"MediaKey" => "6113981665"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/5bdac9e880365577292115bb1720a96c.webp"
"MediaSize" => 277691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-5bdac9e880365577292115bb1720a96c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
37 => array:13 [
"Order" => 37
"MediaKey" => "6113981670"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/79ab8a2caf675031446ec2ca991a9001.webp"
"MediaSize" => 242136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-79ab8a2caf675031446ec2ca991a9001.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
38 => array:13 [
"Order" => 38
"MediaKey" => "6113981693"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/b6fad1ff8a278a5ea96a2693bebb2cf1.webp"
"MediaSize" => 255221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-b6fad1ff8a278a5ea96a2693bebb2cf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
39 => array:13 [
"Order" => 39
"MediaKey" => "6113981697"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/28705384/55b3acf2105061ae420979a464801bd6.webp"
"MediaSize" => 382671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/28705384/thumbnail-55b3acf2105061ae420979a464801bd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X12331613"
"ResourceRecordKey" => "28705384"
"ModificationTimestamp" => "2025-08-07T22:25:05.52Z"
]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('28705384')"
+"ID": "84447"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 299944/Office?$select=ALL&$top=10&$filter=OfficeKey eq 299944&$expand=Media/Office?$select=ALL&$top=10&$filter=OfficeKey eq 299944/Office?$select=ALL&$top=10&$filter=OfficeKey eq 299944&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25162
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25164
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "COMFREE"
+"OfficeEmail": null
+"OfficePhone": "877-297-1188"
+"OfficeMlsId": "577300"
+"ModificationTimestamp": "2025-06-27T20:50:17Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "299944"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "151 YONGE STREET UNIT 1500"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "TORONTO"
+"OfficePostalCode": "M5C2W"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Ottawa"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1479343"
+"OriginalEntryTimestamp": "2025-04-01T13:46:00Z"
+"OfficeAORKey": "76"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "436550"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "299944"
"SocialMediaUrlOrId" => "http://comfree.com/"
"ModificationTimestamp" => "2025-06-27T20:42:00Z"
]
]
+"OfficeBrokerNationalAssociationId": "1479346"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Office('299944')"
+"Media": []
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2241186/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2241186&$expand=Media/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2241186/Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2241186&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25167
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq 28705384" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24754
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFPropertyAdditionalInfo {#24756
+"OriginatingSystemName": "CREA"
+"ListingKey": "28705384"
+"AdditionalInfo": array:2 [
"email" => "claudiavrivera@icloud.com"
"phoneNumber" => "1-519-716-3125"
]
+"ModificationTimestamp": "2025-09-04T00:22:28Z"
+"PropertyAdditionalInfoKey": "5460_26_28705384_377"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/PropertyAdditionalInfo('5460_26_28705384_377')"
}
]
+success: true
+page_size: 1
+page_count: 2
+count: 2
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28705384/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28705384&$expand=Media/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28705384/OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq 28705384&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24622
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28705384 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7086563 43.3701324)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28705384 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7086563 43.3701324)) le 2000m&$expand=Media/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28705384 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7086563 43.3701324)) le 2000m/Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne 28705384 AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.7086563 43.3701324)) le 2000m&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25011
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25004
+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 [
"RoomKey" => "1540401366"
"RoomType" => "3pc Bathroom"
"ListingId" => "40789796"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29138110"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 4'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T14:59:42.97Z"
]
1 => array:11 [
"RoomKey" => "1540401367"
"RoomType" => "Living room"
"ListingId" => "40789796"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29138110"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T14:59:42.97Z"
]
2 => array:11 [
"RoomKey" => "1540401368"
"RoomType" => "Kitchen"
"ListingId" => "40789796"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29138110"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T14:59:42.97Z"
]
3 => array:11 [
"RoomKey" => "1540401369"
"RoomType" => "Bedroom"
"ListingId" => "40789796"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29138110"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2025-11-26T14:59:42.98Z"
]
4 => array:11 [
"RoomKey" => "1540401370"
"RoomType" => "Utility room"
"ListingId" => "40789796"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29138110"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 11'3''"
"RoomDescription" => null
…2
]
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"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25006
+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"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25003
+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"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25007
+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 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/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 [ …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('29113081')"
+"ID": "426493"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25005
+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"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24705
+post_id: "411311"
+post_author: 1
+"ListingKey": "29092908"
+"ListingId": "40787613"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-12T16:01:05Z"
+"RFModificationTimestamp": "2025-11-14T08:01:46Z"
+"ListPrice": 0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1500.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A2B6"
+"UnparsedAddress": "88 CONESTOGA Road, New Hamburg, Ontario N3A2B6"
+"Coordinates": array:2 [
0 => -80.7150652
1 => 43.3856807
]
+"Latitude": 43.3856807
+"Longitude": -80.7150652
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover the charm of small-town living at 88 Conestoga Road in beautiful New Hamburg! This well-kept semi-detached home offers over 2,000 sq. ft. of finished living space, featuring four spacious bedrooms and a welcoming atmosphere throughout. The open-concept main floor is perfect for entertaining, with a bright kitchen offering ample counter and cupboard space for the chef in your family. The living and dining areas flow seamlessly to a large covered deck and a generous backyard — ideal for family gatherings and summer barbecues. Downstairs, you’ll find a cozy finished basement complete with a corner gas fireplace — the perfect space to relax or host guests. Upstairs, the impressive primary suite addition over the garage features a vaulted ceiling, walk-in closet, and private 2-piece ensuite. Three additional bedrooms and a 4-piece family bathroom complete the upper level. Enjoy the outdoors with a large backyard and storage shed, offering plenty of room for everyone. Additional highlights include an attached garage with opener, central air, and a water softener. Ideally located close to Hwy 7/8 for easy access to Kitchener-Waterloo and Stratford, this home is near schools, parks, shopping, restaurants, and the scenic Mike Schout Wetlands. Come experience the perfect blend of comfort, convenience, and small-town charm — welcome home to 88 Conestoga Road. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeIncludes": array:1 [
0 => "Property Management"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-12T00:27:01.013055+00:00"
+"Directions": "Forrest Ave E to Conestoga Rd"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180308"
+"ListOfficeKey": "283397"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
2 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-11-11T23:31:39Z"
+"PhotosCount": 22
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-12T15:49:32Z"
+"Stories": "2.0"
+"StreetName": "CONESTOGA"
+"StreetNumber": "88"
+"StreetSuffix": "Road"
+"SubdivisionName": "660 - New Hamburg"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29092908/88-conestoga-road-new-hamburg"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"TotalActualRent": 2750
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"LeaseAmountFrequency": "Monthly"
+"FrontageLengthNumeric": 39.0
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2025-11-11T23:31:39.08Z"
+"MapCoordinateVerifiedYN": true
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"Media": array:22 [
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]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29092908')"
+"ID": "411311"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23321
+post_id: "390217"
+post_author: 1
+"ListingKey": "29068094"
+"ListingId": "X12510218"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-24T13:40:51Z"
+"RFModificationTimestamp": "2025-11-24T13:46:24Z"
+"ListPrice": 574900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A1V7"
+"UnparsedAddress": "58 VICTORIA STREET, Wilmot, Ontario N3A1V7"
+"Coordinates": array:2 [
0 => -80.7096618
1 => 43.3861012
]
+"Latitude": 43.3861012
+"Longitude": -80.7096618
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this charming bungalow in the heart of New Hamburg, the perfect place to start your homeownership journey or enjoy the ease of downsized living. Ideally situated close to schools, parks, shopping, and restaurants, this home offers the best of both worlds: convenient access to amenities while nestled in a quiet, family friendly neighborhood. The main floor features 3 comfortable bedrooms, a bright and spacious living room, and an updated eat-in kitchen with a side entrance leading to the carport. The primary bedroom offers direct access to the back deck and partially fenced yard, perfect for relaxing or entertaining outdoors. The unfinished basement provides excellent potential for a future recreation room, and includes a 2-piece bath (shower & toilet), laundry area, and ample storage. With parking for up to 5-6 vehicles, a newer furnace and A/C (2019), water heater owned (2019) and updated laminate flooring, this home is move-in ready and full of potential. Don't miss the opportunity to make this lovely property your own in one of New Hamburg's most welcoming communities! (id:62650)"
+"Appliances": array:11 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Window Coverings"
10 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-11-05T05:56:39.372506+00:00"
+"Directions": "Cross Streets: Waterloo. ** Directions: Turn onto Victoria St. off Waterloo Stand house will be on the right side."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235952"
+"ListOfficeKey": "290667"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "60.1 x 108.1 FT"
+"ParkingFeatures": array:3 [
0 => "Carport"
1 => "Covered"
2 => "No Garage"
]
+"PhotosChangeTimestamp": "2025-11-04T23:54:39Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-24T13:23:07Z"
+"Stories": "1.0"
+"StreetName": "Victoria"
+"StreetNumber": "58"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "3308.13"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/58_victoria_st_new_hamburg_on/"
+"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/29068094/58-victoria-street-wilmot"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Z2B"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 60.1
+"OriginalEntryTimestamp": "2025-11-04T23:54:39.3Z"
+"MapCoordinateVerifiedYN": false
+"FrontageLengthNumericUnits": "feet"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('29068094')"
+"ID": "390217"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25009
+post_id: "375481"
+post_author: 1
+"ListingKey": "29049295"
+"ListingId": "X12492014"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T22:40:59Z"
+"RFModificationTimestamp": "2025-11-28T22:55:14Z"
+"ListPrice": 884900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Wilmot"
+"PostalCode": "N3A4P5"
+"UnparsedAddress": "62 THIMBLEBERRY CROSS, Wilmot, Ontario N3A4P5"
+"Coordinates": array:2 [
0 => -80.697797
1 => 43.367559
]
+"Latitude": 43.367559
+"Longitude": -80.697797
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 62 Thimbleberry Crossing - a meticulously maintained Hampshire I model, ideally located in the heart of the community just a short walk from the recreation centre. This desirable lot offers extra space and privacy, bordered by walking trails along both the rear and side yards. Step out back to a partially covered interlocking patio, perfect for relaxing, dining, or enjoying the peaceful surroundings. The home's charming front elevation features an enclosed porch - perfect for keeping the weather out on rainy or snowy days - while also adding excellent curb appeal. Inside, the main floor showcases a bright and open layout with a cathedral ceiling and two sided fireplace in the living room. The kitchen is beautifully appointed with stone countertops, stainless steel appliances including a cooktop and wall oven, and a dinette area where you can enjoy your morning coffee in the natural sunlight streaming through large windows. The spacious primary bedroom (13'10" x 16') features his and hers closets and a 4-piece ensuite. A second bedroom, 3-piece bath, and convenient main floor laundry complete this level. The oversized double garage (19'2" x 21') is fully insulated - perfect for hobbies, storage, or year-round parking. The unfinished basement includes a 3-piece rough-in and HRV system, offering potential for future development. Stonecroft Boasts an 18,000 sq. ft. rec center offers an indoor pool, fitness room, games/media rooms, library, party room, billiards, tennis courts, and 5 km of walking trails. In summary, this is a beautifully maintained home on a premium lot, featuring an insulated double garage, excellent location, and fantastic value. Come live the lifestyle at Stonecroft! (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Range"
6 => "Oven"
7 => "Dryer"
8 => "Garburator"
9 => "Hood Fan"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
12 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "247.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:3 [
0 => "Unfinished"
1 => "Full"
2 => "N/A"
]
+"CommunityFeatures": array:2 [
0 => "Community Centre"
1 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-30T19:42:31.896327+00:00"
+"Directions": "Cross Streets: Haysville Road. ** Directions: Haysville Road / Stonecroft Way / Bonaventure Drive / Thimbleberry Crossing."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145750"
+"ListOfficeKey": "290667"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Conservation/green belt"
2 => "Balcony"
3 => "Sump Pump"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2025-10-30T18:39:49Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T22:26:00Z"
+"Stories": "1.0"
+"StreetName": "Thimbleberry"
+"StreetNumber": "62"
+"StreetSuffix": "Cross"
+"TaxAnnualAmount": "5163.62"
+"VirtualTourURLUnbranded": "https://youriguide.com/62_thimbleberry_crossing_new_hamburg_on/"
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29049295/62-thimbleberry-cross-wilmot"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Onyx"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Exercise Centre"
1 => "Recreation Centre"
2 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"ZoningDescription": "Z15"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2025-10-30T18:39:48.9Z"
+"MapCoordinateVerifiedYN": false
+"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('29049295')"
+"ID": "375481"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25010
+post_id: "370176"
+post_author: 1
+"ListingKey": "29044470"
+"ListingId": "40781134"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-11-28T21:20:39Z"
+"RFModificationTimestamp": "2025-11-28T21:51:32Z"
+"ListPrice": 884900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1602.0
+"BuildingAreaTotal": 0
+"City": "New Hamburg"
+"PostalCode": "N3A4P5"
+"UnparsedAddress": "62 THIMBLEBERRY Crossing, New Hamburg, Ontario N3A4P5"
+"Coordinates": array:2 [
0 => -80.69857115
1 => 43.36750217
]
+"Latitude": 43.36750217
+"Longitude": -80.69857115
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 62 Thimbleberry Crossing — a meticulously maintained Hampshire I model, ideally located in the heart of the community just a short walk from the recreation centre. This desirable lot offers extra space and privacy, bordered by walking trails along both the rear and side yards. Step out back to a partially covered interlocking patio, perfect for relaxing, dining, or enjoying the peaceful surroundings. The home’s charming front elevation features an enclosed porch — perfect for keeping the weather out on rainy or snowy days — while also adding excellent curb appeal. Inside, the main floor showcases a bright and open layout with a cathedral ceiling and two sided fireplace in the living room. The kitchen is beautifully appointed with stone countertops, stainless steel appliances including a cooktop and wall oven, and a dinette area where you can enjoy your morning coffee in the natural sunlight streaming through large windows. The spacious primary bedroom (13'10 x 16') features his and hers closets and a 4-piece ensuite. A second bedroom, 3-piece bath, and convenient main floor laundry complete this level. The oversized double garage (19'2 x 21') is fully insulated — perfect for hobbies, storage, or year-round parking. The unfinished basement includes a 3-piece rough-in and HRV system, offering potential for future development. Stonecroft Boasts an 18,000 sq. ft. rec center offers an indoor pool, fitness room, games/media rooms, library, party room, billiards, tennis courts, and 5 km of walking trails. In summary, this is a beautifully maintained home on a premium lot, featuring an insulated double garage, excellent location, and fantastic value. Come live the lifestyle at Stonecroft! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garburator"
7 => "Central Vacuum - Roughed In"
8 => "Hood Fan"
9 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"AssociationFee": "247.88"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Property Management"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2025-10-29T20:24:21.226124+00:00"
+"Directions": "Haysville Road / Stonecroft Way / Bonaventure Drive / Thimbleberry Crossing"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1816506"
+"ListOfficeKey": "290620"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2025-10-29T18:09:20Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2025-11-28T21:10:05Z"
+"Stories": "1.0"
+"StreetName": "THIMBLEBERRY"
+"StreetNumber": "62"
+"StreetSuffix": "Crossing"
+"SubdivisionName": "660 - New Hamburg"
+"TaxAnnualAmount": "5163.62"
+"VirtualTourURLUnbranded": "https://youriguide.com/62_thimbleberry_crossing_new_hamburg_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29044470/62-thimbleberry-crossing-new-hamburg"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "Z15"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1602
+"OriginalEntryTimestamp": "2025-10-29T18:09:19.6Z"
+"MapCoordinateVerifiedYN": true
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "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('29044470')"
+"ID": "370176"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 31
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]