array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29640374 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24415
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24417
+post_id: "1346199"
+post_author: 1
+"ListingKey": "29640374"
+"ListingId": "40822271"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:56:36Z"
+"RFModificationTimestamp": "2026-06-02T17:42:58Z"
+"ListPrice": 2899000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.253
+"LivingArea": 3908.0
+"BuildingAreaTotal": 0
+"City": "Puslinch"
+"PostalCode": "N3C2V4"
+"UnparsedAddress": "9 LAKE Avenue E, Puslinch, Ontario N3C2V4"
+"Coordinates": array:2 [
0 => -80.2568098
1 => 43.4209532
]
+"Latitude": 43.4209532
+"Longitude": -80.2568098
+"YearBuilt": 1915
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set along the shores of Puslinch Lake, this exceptional waterfront home offers over 70 feet of owned shoreline and a truly rare lifestyle. Originally built in 1915, the home blends timeless stone exterior charm with a fully modernized interior featuring high-end finishes and thoughtfully designed living spaces. Inside, the home unfolds with a natural, easy flow designed for both everyday living and hosting. The kitchen connects seamlessly to the dining and living areas, creating a bright, welcoming central space enhanced by the home’s sun-filled southern exposure. Tucked to one side, the main floor primary bedroom features a 4-piece ensuite and its own laundry. A separate office offers flexibility, easily functioning as a guest room or additional bedroom. Upstairs, a quiet and private space captures some of the best views in the home. The generously sized bedroom is framed by a large picture window overlooking the lake, paired with its own 4-piece bathroom to create a peaceful retreat, ideal for guests. The fully finished basement extends the living space with an impressive recreation room, stylish wet bar, dedicated wine cellar and two-piece bathroom . Step outside and enjoy everything this lakeside retreat has to offer, stunning water views, hot tub, fire pit, mutli-level seating areas, pergola, outdoor kitchen, Tiki bar, the multi-tiered backyard is designed for unforgettable lakeside living. At the water’s edge, a two-storey boathouse includes a self-contained accessory apartment with a private deck. With expansive dock space, even accommodating a seaplane. This property is truly one-of-a-kind. Move in and enjoy a seamless blend of history, luxury, and breathtaking waterfront views. Every detail has been carefully curated to maximize comfort, function, and the beauty of lakeside living, creating an unmatched retreat just minutes from everyday amenities. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Stove"
4 => "Dryer"
5 => "Wet Bar"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"CreationDate": "2026-04-22T16:43:20.178623+00:00"
+"Directions": "Lake Road to Butler Ave"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Propane"
1 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750193"
+"ListOfficeKey": "156288"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:8 [
0 => "Cul-de-sac"
1 => "Corner Site"
2 => "Visual exposure"
3 => "Conservation/green belt"
4 => "Wet bar"
5 => "Country residential"
6 => "Sump Pump"
7 => "In-Law Suite"
]
+"LotSizeDimensions": "0.253"
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-27T13:00:50Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:40:01Z"
+"Stories": "1.5"
+"StreetDirSuffix": "East"
+"StreetName": "LAKE"
+"StreetNumber": "9"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "73 - Puslinch Lake Settlement Areas"
+"TaxAnnualAmount": "7715"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://tours.eyefimedia.com/317322"
+"WaterBodyName": "Puslinch Lake"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:22 [
0 => array:11 [
"RoomKey" => "1649878780"
"RoomType" => "2pc Bathroom"
"ListingId" => "40822271"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 4'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.87Z"
]
1 => array:11 [
"RoomKey" => "1649878781"
"RoomType" => "4pc Bathroom"
"ListingId" => "40822271"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.87Z"
]
2 => array:11 [
"RoomKey" => "1649878782"
"RoomType" => "Bedroom"
"ListingId" => "40822271"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.87Z"
]
3 => array:11 [
"RoomKey" => "1649878783"
"RoomType" => "Bedroom"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "18'6'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.87Z"
]
4 => array:11 [
"RoomKey" => "1649878784"
"RoomType" => "Kitchen"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "6'8'' x 5'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.87Z"
]
5 => array:11 [
"RoomKey" => "1649878785"
"RoomType" => "3pc Bathroom"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.87Z"
]
6 => array:11 [
"RoomKey" => "1649878786"
"RoomType" => "Workshop"
"ListingId" => "40822271"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "20'0'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.87Z"
]
7 => array:11 [
"RoomKey" => "1649878787"
"RoomType" => "Workshop"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "20'6'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.87Z"
]
8 => array:11 [
"RoomKey" => "1649878788"
"RoomType" => "Sitting room"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
9 => array:11 [
"RoomKey" => "1649878789"
"RoomType" => "Primary Bedroom"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "12'0'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
10 => array:11 [
"RoomKey" => "1649878790"
"RoomType" => "Office"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
11 => array:11 [
"RoomKey" => "1649878791"
"RoomType" => "Living room"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 23'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
12 => array:11 [
"RoomKey" => "1649878792"
"RoomType" => "Laundry room"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 11'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
13 => array:11 [
"RoomKey" => "1649878793"
"RoomType" => "Kitchen"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "13'8'' x 15'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
14 => array:11 [
"RoomKey" => "1649878794"
"RoomType" => "Family room"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "15'5'' x 12'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
15 => array:11 [
"RoomKey" => "1649878795"
"RoomType" => "Dining room"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "8'3'' x 15'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
16 => array:11 [
"RoomKey" => "1649878796"
"RoomType" => "4pc Bathroom"
"ListingId" => "40822271"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
17 => array:11 [
"RoomKey" => "1649878797"
"RoomType" => "Wine Cellar"
"ListingId" => "40822271"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 8'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
18 => array:11 [
"RoomKey" => "1649878798"
"RoomType" => "Utility room"
"ListingId" => "40822271"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 5'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
19 => array:11 [
"RoomKey" => "1649878799"
"RoomType" => "Utility room"
"ListingId" => "40822271"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "5'3'' x 15'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
20 => array:11 [
"RoomKey" => "1649878800"
"RoomType" => "Recreation room"
"ListingId" => "40822271"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "17'7'' x 33'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
21 => array:11 [
"RoomKey" => "1649878801"
"RoomType" => "Gym"
"ListingId" => "40822271"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29640374"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 11'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T16:40:01.88Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29640374/9-lake-avenue-e-puslinch"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 70.0
+"AboveGradeFinishedArea": 2834
+"BelowGradeFinishedArea": 1074
+"OriginalEntryTimestamp": "2026-04-22T16:01:42.78Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1112497"
+"ListOfficeNationalAssociationId": "1112493"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6620003408"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/9188c4ca8674f50e7d72f755ec2d0bae.webp"
"MediaSize" => 152102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-9188c4ca8674f50e7d72f755ec2d0bae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6620003555"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/9a6e9a5dd12db3e4e642ad0caddce637.webp"
"MediaSize" => 170672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-9a6e9a5dd12db3e4e642ad0caddce637.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.11Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6620003630"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/c474ba92f701e45cdbf65678526fd74e.webp"
"MediaSize" => 103643
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-c474ba92f701e45cdbf65678526fd74e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.36Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6620003740"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/9c52af44a654059db9b79841b3259531.webp"
"MediaSize" => 78033
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-9c52af44a654059db9b79841b3259531.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.13Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6620003824"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/0ab5aca7706b4d0b96c83cbe6c5c693f.webp"
"MediaSize" => 95877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-0ab5aca7706b4d0b96c83cbe6c5c693f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.36Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6620003923"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/d525d1c3df9278c2f5bf84b89c1b811d.webp"
"MediaSize" => 90726
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-d525d1c3df9278c2f5bf84b89c1b811d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.37Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6620004022"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/57d60e2143d24306d5c098e3c1a4de51.webp"
"MediaSize" => 92610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-57d60e2143d24306d5c098e3c1a4de51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.36Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6620004113"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/6f9d4d3f8acc7aab76be9c3b45d56a8c.webp"
"MediaSize" => 91143
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-6f9d4d3f8acc7aab76be9c3b45d56a8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.29Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6620004148"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/30c6f4c4caff75b05073f0a37f344075.webp"
"MediaSize" => 79695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-30c6f4c4caff75b05073f0a37f344075.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.37Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6620004251"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/e61dd23f7717849d6482ed1c227a7a88.webp"
"MediaSize" => 100037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-e61dd23f7717849d6482ed1c227a7a88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.37Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6620004331"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/aee714ecb03df33852499f17d827d3b5.webp"
"MediaSize" => 77600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-aee714ecb03df33852499f17d827d3b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.4Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6620004457"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/29c0ff1adeff62ef9733651d6f20d25a.webp"
"MediaSize" => 67837
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-29c0ff1adeff62ef9733651d6f20d25a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.39Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6620004549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/48ba5314351cf0db966f81e8a016d98c.webp"
"MediaSize" => 59300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-48ba5314351cf0db966f81e8a016d98c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.27Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6620004662"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/7c5ddb9810fd92fe957b4b0dabb19e59.webp"
"MediaSize" => 84982
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-7c5ddb9810fd92fe957b4b0dabb19e59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.27Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6620004784"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/4a23584f5d660c767b45e7378ca8146e.webp"
"MediaSize" => 73731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-4a23584f5d660c767b45e7378ca8146e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.37Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6620004866"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/ce06c2926eb0c5d1cc7069d18a08e304.webp"
"MediaSize" => 70075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-ce06c2926eb0c5d1cc7069d18a08e304.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.14Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6620004920"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/c73422e32d2cb6ff5f3a5489d97561f5.webp"
"MediaSize" => 97202
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-c73422e32d2cb6ff5f3a5489d97561f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.29Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6620004941"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/fd91009c27587f938e14b165ee99051e.webp"
"MediaSize" => 97177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-fd91009c27587f938e14b165ee99051e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.37Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6620005041"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/6da62c5f14de6e32cecdff3855b5a208.webp"
"MediaSize" => 93694
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-6da62c5f14de6e32cecdff3855b5a208.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.37Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6620005153"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/cd8efbcab156b53209abd35711599cd8.webp"
"MediaSize" => 136552
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-cd8efbcab156b53209abd35711599cd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.55Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6620005173"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/b8096ba578e1dfaeb8d46544729a4b32.webp"
"MediaSize" => 81810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-b8096ba578e1dfaeb8d46544729a4b32.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.27Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6620005288"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/5b4d85c1728af4f9d5147fdbed950b7e.webp"
"MediaSize" => 87005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-5b4d85c1728af4f9d5147fdbed950b7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.14Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6620005383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/ddd6d52a50a2bcfadbf9c4880560ff29.webp"
"MediaSize" => 110766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-ddd6d52a50a2bcfadbf9c4880560ff29.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:01.14Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6620005456"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/000a25eac562763108a2d92e097e7990.webp"
"MediaSize" => 80882
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-000a25eac562763108a2d92e097e7990.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.28Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6620005552"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/939cb10e7d3ddec6161a690dd2a2d4ec.webp"
"MediaSize" => 78601
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-939cb10e7d3ddec6161a690dd2a2d4ec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-22T17:15:00.55Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6634265616"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/2041303c7ee01facf482234c339dfd50.webp"
"MediaSize" => 89171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-2041303c7ee01facf482234c339dfd50.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:52.87Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6634265718"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/ce36bb5bac6ae68a6294976d0a97a713.webp"
"MediaSize" => 47575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-ce36bb5bac6ae68a6294976d0a97a713.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:53.63Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6634265739"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/ac037b9f9571cc851b13fee6a4dc64a2.webp"
"MediaSize" => 88381
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-ac037b9f9571cc851b13fee6a4dc64a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:53.65Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6634265751"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/87c2f6c6a760285761bdeb0324ef8d95.webp"
"MediaSize" => 121511
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-87c2f6c6a760285761bdeb0324ef8d95.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:53.65Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6634265781"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/066db2e6fa4fa57facb30d67aea8fc59.webp"
"MediaSize" => 89388
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-066db2e6fa4fa57facb30d67aea8fc59.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:53.65Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6634265799"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/dfed0cfff8992151d3b7863f18406fec.webp"
"MediaSize" => 67047
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-dfed0cfff8992151d3b7863f18406fec.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:53.68Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6634265832"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/df945dceab9816a21b3ce49e8bc7831f.webp"
"MediaSize" => 113285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-df945dceab9816a21b3ce49e8bc7831f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:52.86Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6634265876"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/c7853aba0111bf0ed365a3dc8a16529e.webp"
"MediaSize" => 119122
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-c7853aba0111bf0ed365a3dc8a16529e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:53.65Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6634265930"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/28e56cc7ebb51019b9460394d0ab852d.webp"
"MediaSize" => 143796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-28e56cc7ebb51019b9460394d0ab852d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:54.57Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6634266047"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/f305ae1ccebd98a080a365c7d6f9fd5d.webp"
"MediaSize" => 124080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-f305ae1ccebd98a080a365c7d6f9fd5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:54.57Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6634266101"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/48b8aef5ceb16f36bd4ffcc60cae876c.webp"
"MediaSize" => 105177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-48b8aef5ceb16f36bd4ffcc60cae876c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:53.63Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "6634266141"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/e52a513f6fdab1fbbb25bb3f47999aad.webp"
"MediaSize" => 112260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-e52a513f6fdab1fbbb25bb3f47999aad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:52.88Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "6634266286"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/d94fa975c34e88625d26e4daaf11e394.webp"
"MediaSize" => 145386
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-d94fa975c34e88625d26e4daaf11e394.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:52.86Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "6634266343"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/00445c67617729d517805f653753d6e8.webp"
"MediaSize" => 130466
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-00445c67617729d517805f653753d6e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:52.86Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "6634266383"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/0efe99d3535fb8a124dd898c2b35fa2f.webp"
"MediaSize" => 118927
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-0efe99d3535fb8a124dd898c2b35fa2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:53.66Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "6634266429"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/8d959a93728ae8bbd897242a8561670f.webp"
"MediaSize" => 153626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29640374/thumbnail-8d959a93728ae8bbd897242a8561670f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40822271"
"ResourceRecordKey" => "29640374"
"ModificationTimestamp" => "2026-04-28T14:40:53.64Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "6634266516"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29640374/e4ebefc4b7f18a72a2be9df57b03bc96.webp"
…10
]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 43
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29640374')"
+"ID": "1346199"
}
]
+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=OfficeMlsId eq 156288" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25796
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1750193" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25793
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29640374'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#26214
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29640374'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#26230
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29640374' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.2568098 43.4209532)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#26320
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#26297
+post_id: "1487617"
+post_author: 1
+"ListingKey": "29844050"
+"ListingId": "X13231384"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T15:46:09Z"
+"RFModificationTimestamp": "2026-06-04T15:59:10Z"
+"ListPrice": 3099000.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Puslinch (Puslinch Lake Settlement Areas)"
+"PostalCode": "N3C2V4"
+"UnparsedAddress": "6805 CONCESSION 2, Puslinch (Puslinch Lake Settlement Areas), Ontario N3C2V4"
+"Coordinates": array:2 [
0 => -80.2577082
1 => 43.4263833
]
+"Latitude": 43.4263833
+"Longitude": -80.2577082
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Behind a private gated entrance lies one of Puslinch's most remarkable custom estates! Built by Frey Building Contractors, this residence combines craftsmanship and luxury amenities rarely found under one roof. Set on a meticulously landscaped 1.47-acre property featuring a custom irrigation system throughout! The exterior features Arriscraft stone, mature trees, curated gardens, a waterfall, a pond, and natural stone features that create an unforgettable first impression! Inside, exposed timber beams, cherry hardwood flooring, heated floors, Restoration Hardware lighting, and multiple fireplaces create a warm atmosphere. The kitchen was designed for entertaining, featuring solid cherry cabinetry, quartz countertops, Portuguese porcelain tile, walk-in pantry, dedicated butler's pantry, and a wraparound covered porch overlooking the pond and backyard oasis. The main floor offers a versatile layout, featuring a spacious primary suite with fireplace and walk-in closet, connected by a Jack-and-Jill ensuite to a second bedroom, as well as a private office with a large bay window and its own fireplace. Upstairs, all three bedrooms feature private ensuites, including a primary retreat with fireplace and walk-in closet. A library and upper-level laundry complete the second floor. The lower level features an indoor heated swimming pool supported by a dedicated HRV air exchange system, a professionally certified 11.2-channel Dolby Atmos theatre room with power reclining seating, home gym, wet bar with wine fridges, large linear fireplace, walkout access, and 8.5-foot ceilings. Outside, the enclosed entertainment pavilion/lounge is complete with a bar, television, and fridge. Attached and detached garages provide exceptional space for vehicles, hobbies, workshop use, or storage. Modern conveniences include smart Nest climate control, full Lutron Caseta lighting system, 200-amp service, and EV-ready infrastructure. Properties of this caliber are rare. A true legacy property! (id:62783)"
+"Appliances": array:2 [
0 => "Water purifier"
1 => "Water softener"
]
+"Basement": array:8 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "Walk out"
4 => "Walk-up"
5 => "N/A"
6 => "N/A"
7 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Air exchanger"
]
+"CreationDate": "2026-06-03T01:21:33.385662+00:00"
+"Directions": "Cross Streets: Sideroad 10 S. ** Directions: From Wellington Rd 32, travel east on Concession Rd 2. Property is located on the south side approximately 3 km east of the intersection."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "6"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Radiant heat"
2 => "Forced air"
3 => "Propane"
4 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2243117"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "196.9 x 328.1 Acre"
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Other"
]
+"PhotosChangeTimestamp": "2026-06-03T00:44:00Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Indoor pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T15:38:38Z"
+"Stories": "2.0"
+"StreetName": "CONCESSION 2"
+"StreetNumber": "6805"
+"TaxAnnualAmount": "12097"
+"VirtualTourURLUnbranded": "https://youriguide.com/6805_concession_2_cambridge_on/"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:21 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"CityRegion": "Puslinch Lake Settlement Areas"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29844050/6805-concession-2-puslinch-puslinch-lake-settlement-areas-puslinch-lake-settlement-areas"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Security system"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"ZoningDescription": "A & H"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"OriginalEntryTimestamp": "2026-06-03T00:44:00.62Z"
+"ListAgentNationalAssociationId": "1481187"
+"ListOfficeNationalAssociationId": "1336772"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29844050')"
+"ID": "1487617"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#26299
+post_id: "1481980"
+post_author: 1
+"ListingKey": "29398719"
+"ListingId": "40807420"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T17:25:15Z"
+"RFModificationTimestamp": "2026-06-02T18:28:37Z"
+"ListPrice": 695500.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.09
+"LivingArea": 1013.0
+"BuildingAreaTotal": 0
+"City": "Puslinch"
+"PostalCode": "N3C2V4"
+"UnparsedAddress": "32 HOLLY Trail, Puslinch, Ontario N3C2V4"
+"Coordinates": array:2 [
0 => -80.274675
1 => 43.4201438
]
+"Latitude": 43.4201438
+"Longitude": -80.274675
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this delightful 3-bedroom bungalow in the highly desirable Puslinch Lake community - a tranquil setting that perfectly blends relaxed, small-town living with convenient access to nearby city amenities. Surrounded by thoughtfully curated landscaping, this home offers charm, comfort, and exceptional care throughout.Step inside to a bright, beautifully maintained interior where a cozy gas fireplace anchors the inviting living space. The spacious kitchen is designed with both functionality and entertaining in mind, offering generous prep space and seamless flow into the dining and living areas - ideal for everyday living and hosting family and friends.The partial basement includes a versatile workshop area, perfect for hobbies, creative projects, or additional storage.Outdoors, the meticulously landscaped lot showcases mature trees, perennial gardens, and a concrete double driveway with ample parking. Just steps from the lake, you'll have easy access to boating, fishing, or simply enjoying the peaceful waterfront surroundings.Located only minutes from Guelph and Cambridge, with convenient access to Highway 401, this home offers the best of both worlds - serene lakeside living with excellent commuter connections. Don't miss your chance to become part of this welcoming and picturesque community near Puslinch Lake. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T22:33:32.690654+00:00"
+"Directions": "Lake Road to Travelled Road"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235303"
+"ListOfficeKey": "300660"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Country residential"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.09"
+"PhotosChangeTimestamp": "2026-02-25T19:38:54Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:54:17Z"
+"Stories": "1.0"
+"StreetName": "HOLLY"
+"StreetNumber": "32"
+"StreetSuffix": "Trail"
+"SubdivisionName": "73 - Puslinch Lake Settlement Areas"
+"TaxAnnualAmount": "3411"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/32-Holly-trail-puslinch"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29398719/32-holly-trail-puslinch"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 39.0
+"AboveGradeFinishedArea": 1013
+"OriginalEntryTimestamp": "2026-02-25T19:38:54.41Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1473131"
+"ListOfficeNationalAssociationId": "1491536"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 99
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29398719')"
+"ID": "1481980"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#26296
+post_id: "1479883"
+post_author: 1
+"ListingKey": "29832327"
+"ListingId": "40834790"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:21:12Z"
+"RFModificationTimestamp": "2026-06-02T16:49:18Z"
+"ListPrice": 1375000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.09
+"LivingArea": 2236.0
+"BuildingAreaTotal": 0
+"City": "Puslinch"
+"PostalCode": "N3C2V4"
+"UnparsedAddress": "39 HOLLY Trail, Puslinch, Ontario N3C2V4"
+"Coordinates": array:2 [
0 => -80.2746131
1 => 43.4199547
]
+"Latitude": 43.4199547
+"Longitude": -80.2746131
+"YearBuilt": 1992
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to your turnkey retreat on the shores of Puslinch Lake — the largest kettle lake in Canada, renowned for its exceptional water clarity and tranquil, tree-lined shores. This extensively renovated waterfront property offers the rare combination of move-in-ready luxury and true four-season lakeside living, complete with your own private dock. No detail has been overlooked in this renovated water front view property. This 1992 all brick home features a new Carrier furnace, new A/C unit, 200-amp electrical panel, new electric hot water tank, new roof (2018), new well pump liner and a new well pump (shared) — giving buyers complete peace of mind on all major mechanicals. Inside, enjoy updated quartz countertops, renovated bathrooms, updated flooring, skylights that flood the space with natural light, and brand new appliances including washer and dryer. new Triple-pane vinyl windows provide exceptional energy efficiency and comfort year-round and gas fireplace. Conveniently located 5 minutes from the 401, and close to Cambridge shopping centre on Heslper. Water quality is a priority with an owned water softener and a reverse osmosis water system. Stay connected with high-speed fibre optic internet — perfect for remote work without sacrificing the cottage lifestyle. Pull up to a striking new stamped concrete driveway that sets the tone from the moment you arrive. Whether you're seeking a full-time residence or a weekend escape, this property delivers it all — waterfront view, total renovation, and one of Ontario's most sought-after lakes. Properties like this rarely come available. Don't miss your opportunity to own a piece of Puslinch Lake. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Hood Fan"
8 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-01T15:58:44.831597+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2069063"
+"ListOfficeKey": "283975"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0.09"
+"NumberOfUnitsTotal": "1"
+"PhotosChangeTimestamp": "2026-06-01T14:50:41Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:12:43Z"
+"Stories": "1.0"
+"StreetName": "HOLLY"
+"StreetNumber": "39"
+"StreetSuffix": "Trail"
+"SubdivisionName": "73 - Puslinch Lake Settlement Areas"
+"TaxAnnualAmount": "5840.06"
+"View": "View of water"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/39-Holly-Trl/idx"
+"WaterBodyName": "Puslinch Lake"
+"WaterSource": array:1 [
0 => "Shared Well"
]
+"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/29832327/39-holly-trail-puslinch"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "Residental"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1148
+"BelowGradeFinishedArea": 1088
+"OriginalEntryTimestamp": "2026-06-01T14:50:40.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1344281"
+"ListOfficeNationalAssociationId": "1337478"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29832327')"
+"ID": "1479883"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#26300
+post_id: "1483129"
+post_author: 1
+"ListingKey": "29832092"
+"ListingId": "40820779"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T15:25:31Z"
+"RFModificationTimestamp": "2026-06-02T15:32:04Z"
+"ListPrice": 999919.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1336.0
+"BuildingAreaTotal": 0
+"City": "Puslinch"
+"PostalCode": "N3C2V4"
+"UnparsedAddress": "43 MCCLINTOCK Drive, Puslinch, Ontario N3C2V4"
+"Coordinates": array:2 [
0 => -80.2652488
1 => 43.4200809
]
+"Latitude": 43.4200809
+"Longitude": -80.2652488
+"YearBuilt": 1950
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Brantford Regional Real Estate Assn Inc"
+"PublicRemarks": "Welcome to your island paradise on Somme Island, located on the largest Kettle Lake in all of Ontario, Puslinch Lake. This one-of-a-kind property offers the ultimate in seclusion and natural beauty, with a picturesque setting and modern comforts throughout. Accessible only by water, the island features three separate boat docks for arrival, while a spacious parking lot on the mainland offers convenient vehicle access for you and your guests. As you step into the main residence, you'll be greeted by the warm charm of pine wood flooring that flows throughout the main level, creating a cozy, rustic ambiance. The kitchen is a chef’s dream, featuring granite countertops, a travertine tile backsplash, stainless steel appliances, under-cabinet lighting, and a large center island perfect for both meal prep and casual dining. The stunning living room is highlighted by a wood-burning fireplace set against a dramatic stone wall with a large hearth – the perfect spot to unwind on cool lake evenings. The main-level primary bedroom offers sliding glass doors that open directly onto the deck offering seamless indoor-outdoor living. Large windows frame tranquil lake views, making every morning feel like a getaway. Relax in your stunning sunroom, complete with a hot tub, skylights, and breathtaking lake views. A unique spiral staircase leads to the upper level, where you'll find two additional bedrooms, each with pine wood flooring. One of these charming rooms includes a walkout to a private balcony – the perfect place to sip your morning coffee while taking in the serene surroundings. Surrounding the home is over 7 km of private shoreline, a grassy area, docks, fire pit, and 3 decks, all ideal for playing, fishing, swimming, sunbathing, and lakeside relaxation. Whether you're looking for a summer escape or a year-round sanctuary, this exceptional island property offers a rare opportunity to own your own slice of paradise! (id:62783)"
+"Appliances": array:4 [
0 => "Refrigerator"
1 => "Hot Tub"
2 => "Dishwasher"
3 => "Stove"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-06-01T15:58:44.316407+00:00"
+"Directions": "Boat from Mainland."
+"ExteriorFeatures": array:1 [
0 => "Shingles"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2013964"
+"ListOfficeKey": "280719"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2026-06-01T14:25:11Z"
+"PhotosCount": 26
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T15:16:30Z"
+"Stories": "1.0"
+"StreetName": "MCCLINTOCK"
+"StreetNumber": "43"
+"StreetSuffix": "Drive"
+"SubdivisionName": "73 - Puslinch Lake Settlement Areas"
+"TaxAnnualAmount": "3710"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://youtu.be/54KvmaoRPW0"
+"WaterBodyName": "Puslinch Lake"
+"WaterSource": array:1 [
0 => "Lake/River Water Intake"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "Brantford"
+"ListAORKey": "41"
+"ListingURL": "www.realtor.ca/real-estate/29832092/43-mcclintock-drive-puslinch"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1336
+"OriginalEntryTimestamp": "2026-06-01T14:25:11.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1295404"
+"ListOfficeNationalAssociationId": "1316868"
+"Media": array:26 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29832092')"
+"ID": "1483129"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#26298
+post_id: "1450052"
+post_author: 1
+"ListingKey": "29792467"
+"ListingId": "X13162646"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-22T19:25:56Z"
+"RFModificationTimestamp": "2026-05-22T19:30:56Z"
+"ListPrice": 1799000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 9.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Puslinch (Puslinch Lake Settlement Areas)"
+"PostalCode": "N3C2V4"
+"UnparsedAddress": "17 MAPLE TRAIL, Puslinch (Puslinch Lake Settlement Areas), Ontario N3C2V4"
+"Coordinates": array:2 [
0 => -80.276069
1 => 43.420006
]
+"Latitude": 43.420006
+"Longitude": -80.276069
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Custom-built in 2021 this stunning 5-bedroom, 4-bathroom executive home offers the rare opportunity to enjoy peaceful cottage-style lakeside living just 3 minutes from Highway 401 and Townline Road. Designed with both luxury and lifestyle in mind, the open-concept layout is flooded with natural light through expansive European windows and oversized 8-foot sliding glass doors, showcasing beautiful lake views from every level. With the purchase of this home comes deeded water access to the private, non-public, Lake Puslinch, perfect for launching kayaks or canoes. The chef-inspired kitchen is built to impress with premium Fisher & Paykel appliances, a stunning oversized chef's island, and seamlessly flows into the main living spaces. Thoughtfully constructed well beyond standard expectations, the entire third floor features the incredible primary retreat that feels like your private penthouse complete with dual walk-in closets, a spa-inspired ensuite featuring a freestanding soaker tub, glass walk-in shower, separate water closet, extensive soundproofing for the entire primary level, and a covered balcony overlooking Lake Puslinch. Outside you will find the 6 car driveway and 2.5-car garage. A truly rare offering combining luxury construction, and an everyday resort-style lifestyle in one of the area's most sought-after settings. (id:62650)"
+"Appliances": array:15 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water purifier"
4 => "Water softener"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Water Treatment"
10 => "Hood Fan"
11 => "Garage door opener"
12 => "Garage door opener remote(s)"
13 => "Water Heater - Tankless"
14 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-22T19:30:36.274003+00:00"
+"Directions": "Cross Streets: Elm Trail to Maple Trail. ** Directions: Elm Trail."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2093590"
+"ListOfficeKey": "294121"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "40 x 100 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-22T19:16:38Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-22T19:16:38Z"
+"Stories": "3.0"
+"StreetName": "Maple"
+"StreetNumber": "17"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "6957"
+"View": "Lake view,View of water"
+"VirtualTourURLUnbranded": "https://youriguide.com/2xsc3_17_maple_trail_cambridge_on/"
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "Puslinch Lake Settlement Areas"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29792467/17-maple-trail-puslinch-puslinch-lake-settlement-areas-puslinch-lake-settlement-areas"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 4
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-05-22T18:58:31.58Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1366110"
+"ListOfficeNationalAssociationId": "1435796"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29792467')"
+"ID": "1450052"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#26293
+post_id: "1450854"
+post_author: 1
+"ListingKey": "29790829"
+"ListingId": "40832114"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:30:34Z"
+"RFModificationTimestamp": "2026-06-02T16:31:46Z"
+"ListPrice": 1799000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.09
+"LivingArea": 3734.0
+"BuildingAreaTotal": 0
+"City": "Puslinch"
+"PostalCode": "N3C2V4"
+"UnparsedAddress": "17 MAPLE TRAIL Trail, Puslinch, Ontario N3C2V4"
+"Coordinates": array:2 [
0 => -80.2758409
1 => 43.4199615
]
+"Latitude": 43.4199615
+"Longitude": -80.2758409
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Custom-built in 2021 this stunning 5-bedroom, 4-bathroom executive home offers the rare opportunity to enjoy peaceful cottage-style lakeside living just 3 minutes from Highway 401 and Townline Road. Designed with both luxury and lifestyle in mind, the open-concept layout is flooded with natural light through expansive European windows and oversized 8-foot sliding glass doors, showcasing beautiful lake views from every level. Ownership of this home includes deeded access to the private waters of Lake Puslinch, perfect for launching kayaks, canoes, and enjoying peaceful days on the water. The chef-inspired kitchen is built to impress with premium Fisher & Paykel appliances, a stunning oversized chef's island, and seamlessly flows into the main living spaces. Thoughtfully constructed well beyond standard expectations, the entire third floor features the incredible primary retreat that feels like a private penthouse complete with dual walk-in closets, a spa-inspired ensuite featuring a freestanding soaker tub, glass walk-in shower, separate water closet, extensive soundproofing for the entire primary level, and a covered balcony overlooking Lake Puslinch. Outside you will find the 6-car driveway and 2.5-car garage. A truly rare offering combining luxury construction and an everyday resort-style lifestyle in one of the area’s most sought-after settings. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water purifier"
4 => "Water softener"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Hood Fan"
10 => "Garage door opener"
11 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-22T17:10:59.559295+00:00"
+"ExteriorFeatures": array:5 [
0 => "Steel"
1 => "Concrete"
2 => "Wood"
3 => "Aluminum siding"
4 => "Metal"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2126970"
+"ListOfficeKey": "292918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Country residential"
2 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.09"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-27T18:23:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Holding Tank"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:19:26Z"
+"Stories": "3.0"
+"StreetName": "MAPLE TRAIL"
+"StreetNumber": "17"
+"StreetSuffix": "Trail"
+"SubdivisionName": "73 - Puslinch Lake Settlement Areas"
+"TaxAnnualAmount": "6957"
+"View": "Lake view"
+"VirtualTourURLUnbranded": "https://youriguide.com/2xsc3_17_maple_trail_cambridge_on/"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29790829/17-maple-trail-trail-puslinch"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1600677"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "294047"
+"GeocodeManualYN": true
+"SecurityFeatures": array:3 [
0 => "Alarm system"
1 => "Security system"
2 => "Smoke Detectors"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 3170
+"BelowGradeFinishedArea": 564
+"OriginalEntryTimestamp": "2026-05-22T16:32:08.02Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1380207"
+"ListOfficeNationalAssociationId": "1419429"
+"CoListAgentNationalAssociationId": "1148143"
+"CoListOfficeNationalAssociationId": "1435346"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29790829')"
+"ID": "1450854"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24429
+post_id: "1422094"
+post_author: 1
+"ListingKey": "29752914"
+"ListingId": "40829656"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:36:08Z"
+"RFModificationTimestamp": "2026-06-02T17:03:45Z"
+"ListPrice": 679900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0.092
+"LivingArea": 1145.0
+"BuildingAreaTotal": 0
+"City": "Puslinch"
+"PostalCode": "N3C2V4"
+"UnparsedAddress": "15 POPLAR Trail, Puslinch, Ontario N3C2V4"
+"Coordinates": array:2 [
0 => -80.2769956
1 => 43.4193415
]
+"Latitude": 43.4193415
+"Longitude": -80.2769956
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Immaculate year-round home located in a highly desirable lakeside community just minutes from Cambridge, K-W, and Guelph. This lovely one-bedroom property is the perfect turnkey retreat or permanent lakeside residence for those searching for cottage-style living without the exhausting multi-hour drive. Set on an easy-to-maintain lot with views of beautiful Puslinch Lake from the front deck and a mature forest at the rear, the cottage vibes are unmistakable. The spotless interior features a handsomely remodelled kitchen complete with stone countertops, dark wood cabinetry, and stainless steel appliances. The adjoining dining area flows seamlessly into a bright living room anchored by a cozy gas fireplace. Upstairs, the spacious primary bedroom offers multiple closets and a dedicated nook perfect for a home office. Entertaining large groups is a breeze in the massive three-season sunroom addition at the rear. Outdoor living is equally impressive, featuring an expansive deck with a built-in tiki bar, a fire pit area, and a secluded hot tub. Additional features include two garden sheds (one easily convertible into a bunkie), paved parking for six vehicles, and deeded access to Puslinch Lake. Call your agent today to arrange a private viewing of this fantastic lakeside gem! (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Satellite Dish"
5 => "Central Vacuum"
6 => "Dishwasher"
7 => "Stove"
8 => "Dryer"
9 => "Window Coverings"
10 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Crawl space"
]
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-14T17:54:31.963632+00:00"
+"Directions": "Off Holly Trail"
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:4 [
0 => "Baseboard heaters"
1 => "Forced air"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1520451"
+"ListOfficeKey": "156357"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Country residential"
]
+"LotSizeDimensions": "0.092"
+"PhotosChangeTimestamp": "2026-05-28T13:32:13Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:26:00Z"
+"Stories": "1.0"
+"StreetName": "POPLAR"
+"StreetNumber": "15"
+"StreetSuffix": "Trail"
+"SubdivisionName": "73 - Puslinch Lake Settlement Areas"
+"TaxAnnualAmount": "2992"
+"Utilities": array:2 [
0 => "Natural Gas"
1 => "Telephone"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/15_poplar_trl_cambridge_on/"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Shared Well"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29752914/15-poplar-trail-puslinch"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 40.0
+"AboveGradeFinishedArea": 1145
+"OriginalEntryTimestamp": "2026-05-14T17:20:38.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1066107"
+"ListOfficeNationalAssociationId": "1003908"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29752914')"
+"ID": "1422094"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#26301
+post_id: "1419193"
+post_author: 1
+"ListingKey": "29747618"
+"ListingId": "X13123850"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-14T21:41:04Z"
+"RFModificationTimestamp": "2026-05-14T21:42:59Z"
+"ListPrice": 2149000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Puslinch (Puslinch Lake Settlement Areas)"
+"PostalCode": "N3C2V4"
+"UnparsedAddress": "11 LAKE AVENUE E, Puslinch (Puslinch Lake Settlement Areas), Ontario N3C2V4"
+"Coordinates": array:2 [
0 => -80.2572236
1 => 43.4208972
]
+"Latitude": 43.4208972
+"Longitude": -80.2572236
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Ottawa Real Estate Board"
+"PublicRemarks": "Welcome to 11 Lake Ave East, a beautiful lakefront bungalow on one of Ontarios most iconic coveted and private lakes, Puslinch Lake. Nestled on owned waterfront with breathtaking southern exposure with south/west facing views, this meticulously maintained 3 bedroom with office, 1bathroom retreat offers the ultimate in lakeside living, just 2 minutes from Cambridge and the 401.Set on a beautifully landscaped lot, this charming home features an elevated porch, perfect for morning coffees, lush perennial gardens, and a warm cottage-casual interior with hardwood styled flooring, a stone fireplace, and an abundance of natural light. Step outside and the property truly shines. A concrete self cleaning self leveling pool overlooks the shimmering lake, surrounded by a generous patio, lounge seating, and mature gardens-an entertainers dream by day and pure magic by moonlight. Private owned waterfront with boat ramp gives you direct lake access, while the expansive dock with Adirondack seating is the perfect spot to watch the beautiful sunset. (id:62650)"
+"Appliances": array:7 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Microwave"
5 => "Furniture"
6 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Crawl space"
]
+"Cooling": array:1 [
0 => "Window air conditioner"
]
+"CreationDate": "2026-05-13T23:16:44.538103+00:00"
+"Directions": "Cross Streets: Lake Ave E. ** Directions: See map."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2241186"
+"ListOfficeKey": "299944"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "104 x 187.4 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-05-13T19:34:32Z"
+"PhotosCount": 32
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-14T21:34:24Z"
+"Stories": "1.0"
+"StreetName": "Lake"
+"StreetNumber": "11"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5512"
+"View": "Direct Water View"
+"WaterBodyName": "Puslinch Lake"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Ottawa"
+"TaxYear": 2025
+"CityRegion": "Puslinch Lake Settlement Areas"
+"ListAORKey": "76"
+"ListingURL": "www.realtor.ca/real-estate/29747618/11-lake-avenue-puslinch-puslinch-lake-settlement-areas-puslinch-lake-settlement-areas"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"BedroomsAboveGrade": 3
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 104.0
+"OriginalEntryTimestamp": "2026-05-13T19:34:31.96Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1479347"
+"ListOfficeNationalAssociationId": "1479343"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 22
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29747618')"
+"ID": "1419193"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#26302
+post_id: "1335056"
+post_author: 1
+"ListingKey": "29628983"
+"ListingId": "X13019806"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-20T22:50:44Z"
+"RFModificationTimestamp": "2026-04-20T22:59:20Z"
+"ListPrice": 2498000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Puslinch (Puslinch Lake Settlement Areas)"
+"PostalCode": "N0B2J0"
+"UnparsedAddress": "8 OAK DRIVE, Puslinch (Puslinch Lake Settlement Areas), Ontario N0B2J0"
+"Coordinates": array:2 [
0 => -80.2546802
1 => 43.4132358
]
+"Latitude": 43.4132358
+"Longitude": -80.2546802
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Serene Lakefront retreat on Puslinch Lake. Nestled just an hour from the city, this exceptional lakefront property offers nearly 1.5 acres of tranquil privacy with 169 feet of pristine shoreline on the peaceful waters of Puslinch Lake. This beautiful winding wooded roads leads to an idyllic sanctuary where the beauty of nature invites you to slow down and savour life's quiet moments. Imagine serene mornings on the expansive deck, watching the sunrise over the lake, and evenings spent enjoying stunning sunsets and the gentle sounds of nature. This timeless 2-bedroom, 2 bathroom home, originally built in 1947 and thoughtfully updated, combines character with comfort. Whether you choose to move in as is, renovate, or build your dream home, this setting provides the perfect canvas, the possibilities are endless. The property features panoramic lake views, a spacious deck ideal for relaxing or entertaining, and a generous 3-car garage with ample space for vehicles, hobbies, or storage. Surrounded by mature trees and close to nature trails, you are also conveniently near Hwy 401, top-rated schools, and excellent opportunities for recreational hiking and golfing. The nearby Starkey Hills Trail and Mountsberg Conservation Area further enrich this remarkable lifestyle. Please note these are virtually staged interior photos of the layout possibilities, kitchen cabinetry virtually painted white. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-20T17:34:57.965731+00:00"
+"Directions": "Pioneer Grove"
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Unknown"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1465261"
+"ListOfficeKey": "50834"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "168.6 x 90 FT ; Right of way"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-20T22:42:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-04-20T22:42:06Z"
+"Stories": "1.0"
+"StreetName": "Oak"
+"StreetNumber": "8"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "8859"
+"Utilities": array:1 [
0 => "Electricity"
]
+"View": "View of water,Direct Water View"
+"VirtualTourURLUnbranded": "https://www.youtube.com/shorts/doL3U8SeAxY?feature=share"
+"WaterBodyName": "Puslinch Lake"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "Puslinch Lake Settlement Areas"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29628983/8-oak-drive-puslinch-puslinch-lake-settlement-areas-puslinch-lake-settlement-areas"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 168.7
+"OriginalEntryTimestamp": "2026-04-20T16:48:13.29Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1124807"
+"ListOfficeNationalAssociationId": "1002686"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 45
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29628983')"
+"ID": "1335056"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 10
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]