array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29888922 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1527593"
+post_author: 1
+"ListingKey": "29888922"
+"ListingId": "X13431802"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T23:00:05Z"
+"RFModificationTimestamp": "2026-06-11T23:04:14Z"
+"ListPrice": 524900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Frontenac (Frontenac South)"
+"PostalCode": "K0H2W0"
+"UnparsedAddress": "6104 HIGHWAY 38, Frontenac (Frontenac South), Ontario K0H2W0"
+"Coordinates": array:2 [
0 => -76.690209
1 => 44.465112
]
+"Latitude": 44.465112
+"Longitude": -76.690209
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Tucked away on over an acre of land and surrounded by conservation lands, this property offers a lifestyle that's increasingly difficult to find. Enjoy stunning views over Hambly Lake, where you can spend countless hours fishing from the dock, boating, watching wildlife, and taking in the ever-changing scenery. While ownership does not extend to the waterfront itself, the surrounding conservation lands create an incredible sense of privacy, natural beauty, and connection to the outdoors. Hambly Lake forms part of a beautiful chain of lakes in the Verona area, offering excellent opportunities for boating, paddling, fishing, and enjoying nature.Adding to the appeal, a private gate from the property provides direct access to the surrounding conservation lands and trail system. Step out your back door for a morning walk, explore nature with the dog, snowshoe in the winter, or simply enjoy the peace and quiet of the protected green space next door.The bungalow offers 3 bedrooms, 1 bathroom, and numerous updates completed over the years, including updated doors and windows, a newer roof, drilled well with newer submersible pump, and a strapped and insulated basement. The separate basement walk-up entrance creates excellent potential for an in-law suite, multi-generational living arrangement, or future income opportunity.A heated detached garage provides the perfect workshop, hobby space, or storage for all your outdoor toys.Whether you're an avid angler, nature enthusiast, boater, investor, or simply seeking a quieter pace of life, this property delivers. Located just minutes from Verona, you'll enjoy the convenience of local amenities while still feeling worlds away from the hustle and bustle, with an easy commute to Kingston. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:5 [
0 => "Unfinished"
1 => "Full"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
]
+"CommunityFeatures": array:1 [
0 => "Fishing"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-11T16:42:15.178263+00:00"
+"Directions": "Cross Streets: Quinte Conservation Lane. ** Directions: Highway 38 just south of the village of Verona."
+"ExteriorFeatures": array:1 [
0 => "Wood"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:4 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Propane"
3 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1952839"
+"ListOfficeKey": "293623"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Wooded area"
1 => "Open space"
2 => "Conservation/green belt"
3 => "Dry"
]
+"LotSizeDimensions": "289.2 x 200 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T15:51:52Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T22:51:16Z"
+"Stories": "1.0"
+"StreetName": "Highway 38"
+"StreetNumber": "6104"
+"TaxAnnualAmount": "2052"
+"Utilities": array:2 [
0 => "Telephone"
1 => "Wireless"
]
+"View": "Lake view,View of water,Unobstructed Water View"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=pUXFvaAUsKk&brand=0"
+"WaterBodyName": "Hambly Lake"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"ListAOR": "Kingston"
+"TaxYear": 2025
+"CityRegion": "47 - Frontenac South"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29888922/6104-highway-38-frontenac-frontenac-south-47-frontenac-south"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2067085"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "293623"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "EP"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 289.2
+"OriginalEntryTimestamp": "2026-06-11T15:51:52.04Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1246289"
+"ListOfficeNationalAssociationId": "1429326"
+"CoListAgentNationalAssociationId": "1342160"
+"CoListOfficeNationalAssociationId": "1429326"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29888922_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/045ce6fd6463a9d7c02ea5d41eb924c9.webp"
"MediaSize" => 331002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-045ce6fd6463a9d7c02ea5d41eb924c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29888922_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/9d9ff11a60c51b1433deff6458c4bf22.webp"
"MediaSize" => 338771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-9d9ff11a60c51b1433deff6458c4bf22.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29888922_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/588cdc7b01773134b2511f85edf6cefd.webp"
"MediaSize" => 501468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-588cdc7b01773134b2511f85edf6cefd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29888922_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/157d6f8ade8f8afdf77de82db97c84a6.webp"
"MediaSize" => 487514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-157d6f8ade8f8afdf77de82db97c84a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29888922_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/e38aa87f052e34bd856d116714c06c7a.webp"
"MediaSize" => 475912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-e38aa87f052e34bd856d116714c06c7a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29888922_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/310c844e967b39ff2b906122a2b5a4b7.webp"
"MediaSize" => 438743
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-310c844e967b39ff2b906122a2b5a4b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29888922_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/eb6be7660413fb0f83103060433c790f.webp"
"MediaSize" => 447858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-eb6be7660413fb0f83103060433c790f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29888922_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/fa6c1f3ba9eabde0346130dc4fc88b99.webp"
"MediaSize" => 528357
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-fa6c1f3ba9eabde0346130dc4fc88b99.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29888922_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/6ff6ed1080849120e7baa5f9f7eba1f9.webp"
"MediaSize" => 543988
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-6ff6ed1080849120e7baa5f9f7eba1f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29888922_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/34f6a20184711f757a7d535d7bb06635.webp"
"MediaSize" => 542217
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-34f6a20184711f757a7d535d7bb06635.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29888922_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/e4e5fe6e7d462f258293378a52ba8567.webp"
"MediaSize" => 411801
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-e4e5fe6e7d462f258293378a52ba8567.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29888922_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/5cb23bbb0577201161f857bb06a1195b.webp"
"MediaSize" => 339636
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-5cb23bbb0577201161f857bb06a1195b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29888922_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/b01cb82445bae9590841f8a0007d4dad.webp"
"MediaSize" => 483385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-b01cb82445bae9590841f8a0007d4dad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29888922_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/d473a5c2827b90bcd84e3c5090a989c5.webp"
"MediaSize" => 430508
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-d473a5c2827b90bcd84e3c5090a989c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29888922_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/75cfd6a59808d9b43d20fe32d02755aa.webp"
"MediaSize" => 512354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-75cfd6a59808d9b43d20fe32d02755aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29888922_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/c97da9d968ef35957e4f0d9c5998fb78.webp"
"MediaSize" => 444024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-c97da9d968ef35957e4f0d9c5998fb78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29888922_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/071ffe145599a64f9b25f5ae20318524.webp"
"MediaSize" => 447822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-071ffe145599a64f9b25f5ae20318524.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29888922_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/03728d51ebdbe744763ced4bb8b36609.webp"
"MediaSize" => 520089
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-03728d51ebdbe744763ced4bb8b36609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gate to access trails in Quinte Conservation"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29888922_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/64e661dbd0f8ad088ba7505d6c0bb60d.webp"
"MediaSize" => 476771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-64e661dbd0f8ad088ba7505d6c0bb60d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29888922_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/730c549a4e2096e1ec07527e5a792221.webp"
"MediaSize" => 223356
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-730c549a4e2096e1ec07527e5a792221.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29888922_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/6575aff9d11486a23eae14826f52360d.webp"
"MediaSize" => 161556
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-6575aff9d11486a23eae14826f52360d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29888922_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/9d11b30b619631828c2db3822775bb46.webp"
"MediaSize" => 204536
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-9d11b30b619631828c2db3822775bb46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29888922_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/606a69d7344169ed04925adb3f55363f.webp"
"MediaSize" => 205110
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-606a69d7344169ed04925adb3f55363f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29888922_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/bd326377c5202bc836eac6b2df67e61d.webp"
"MediaSize" => 238288
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-bd326377c5202bc836eac6b2df67e61d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29888922_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/dc62a4bfde7877ac341aea0aa463dcfc.webp"
"MediaSize" => 287248
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-dc62a4bfde7877ac341aea0aa463dcfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29888922_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/54b9e777073f5bfecdd552fe327dedff.webp"
"MediaSize" => 247951
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-54b9e777073f5bfecdd552fe327dedff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29888922_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/125bfe1ebbe6d225254396c76a52502a.webp"
"MediaSize" => 262168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-125bfe1ebbe6d225254396c76a52502a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29888922_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/d57f008e26c09817f444f5fd8bada8cc.webp"
"MediaSize" => 262429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-d57f008e26c09817f444f5fd8bada8cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29888922_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/2f18044eac3ef2235378a29b4b1fc300.webp"
"MediaSize" => 283430
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-2f18044eac3ef2235378a29b4b1fc300.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29888922_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/89d2f788b1de1453125044c734640bf9.webp"
"MediaSize" => 241812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-89d2f788b1de1453125044c734640bf9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29888922_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/686b1c1c5daa07c7f70b35059b69018b.webp"
"MediaSize" => 155963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-686b1c1c5daa07c7f70b35059b69018b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29888922_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/489219e59bc2f3e2c2ade415945cd69b.webp"
"MediaSize" => 180076
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-489219e59bc2f3e2c2ade415945cd69b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29888922_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/2fda25b36d1a344690533d2af0281952.webp"
"MediaSize" => 256229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-2fda25b36d1a344690533d2af0281952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29888922_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/74c9ea58b2d985e2fa58129027cd1e56.webp"
"MediaSize" => 230649
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-74c9ea58b2d985e2fa58129027cd1e56.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29888922_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/8c8834694653575e292c8f2d0ad0d7e2.webp"
"MediaSize" => 178175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-8c8834694653575e292c8f2d0ad0d7e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29888922_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/80c5dca5d92e059592bb05b00fa6248c.webp"
"MediaSize" => 184156
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-80c5dca5d92e059592bb05b00fa6248c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29888922_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/a7fc6a7c79ebaad2fa5eef4d248575d4.webp"
"MediaSize" => 257052
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-a7fc6a7c79ebaad2fa5eef4d248575d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29888922_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/1c3f567b5244759fdbc196ce611e2ea2.webp"
"MediaSize" => 315677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-1c3f567b5244759fdbc196ce611e2ea2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29888922_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/4766573be491cee26751995e953e12ad.webp"
"MediaSize" => 293423
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-4766573be491cee26751995e953e12ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29888922_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/18b43d90ec5c3e7a8f2d2f3eae39d237.webp"
"MediaSize" => 324698
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-18b43d90ec5c3e7a8f2d2f3eae39d237.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk Up from Basement"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29888922_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/bf732f6fe840103f7663df699ccb135a.webp"
"MediaSize" => 309362
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-bf732f6fe840103f7663df699ccb135a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29888922_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/23a52359ad8ca764483e8d3d6ab4befd.webp"
"MediaSize" => 441926
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-23a52359ad8ca764483e8d3d6ab4befd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29888922_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/df49be12945fa743686fb4cba091e5c2.webp"
"MediaSize" => 322319
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-df49be12945fa743686fb4cba091e5c2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29888922_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/3c41720d2ae9f5110ecd00d4f096a35d.webp"
"MediaSize" => 248006
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-3c41720d2ae9f5110ecd00d4f096a35d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rough outline of property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29888922_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/fe9d332eb5d0f52c57254638dbf13bff.webp"
"MediaSize" => 137503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-fe9d332eb5d0f52c57254638dbf13bff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29888922_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/187226a3addbc9674a874adea8532ac2.webp"
"MediaSize" => 86757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-187226a3addbc9674a874adea8532ac2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29888922_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29888922/347a5688a33af0446870ab82bb00fb2f.webp"
"MediaSize" => 111985
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29888922/thumbnail-347a5688a33af0446870ab82bb00fb2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13431802"
"ResourceRecordKey" => "29888922"
"ModificationTimestamp" => "2026-06-11T15:51:52.05Z"
]
]
+"DaysOnMarket": 28
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29888922')"
+"ID": "1527593"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 293623" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24980
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24888
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "CENTURY 21 HERITAGE GROUP LTD., BROKERAGE"
+"OfficeEmail": null
+"OfficePhone": "613-817-8380"
+"OfficeMlsId": "470900"
+"ModificationTimestamp": "2025-01-12T14:03:26Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "293623"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "914 PRINCESS STREET"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "KINGSTON"
+"OfficePostalCode": "K7L1H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Kingston"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1429326"
+"OriginalEntryTimestamp": "2022-11-17T18:13:00Z"
+"OfficeFax": "613-817-8390"
+"OfficeAORKey": "37"
+"FranchiseNationalAssociationId": "1205554"
+"OfficeBrokerNationalAssociationId": "1429341"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('293623')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1952839" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24928
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24961
+post_id: ? mixed
+post_author: ? mixed
+"MemberMlsId": "1952839"
+"ModificationTimestamp": "2024-08-27T14:58:34Z"
+"OriginatingSystemName": "CREA"
+"MemberKey": "1952839"
+"MemberPreferredPhoneExt": null
+"MemberMlsSecurityClass": null
+"MemberNationalAssociationId": null
+"MemberAddress1": null
+"MemberType": null
+"MemberDesignation": null
+"MemberCity": null
+"MemberStateOrProvince": null
+"MemberPostalCode": null
+"OriginalEntryTimestamp": null
+"MemberOfficePhone": null
+"MemberOfficePhoneExt": null
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('1952839')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29888922'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25291
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29888922' AND OpenHouseDate ge '2026-07-08'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25307
+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 '29888922' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-76.690209 44.465112)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25379
+items: array:8 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25374
+post_id: "1603457"
+post_author: 1
+"ListingKey": "29999163"
+"ListingId": "X13532032"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T14:15:06Z"
+"RFModificationTimestamp": "2026-07-09T14:18:18Z"
+"ListPrice": 919900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Frontenac (Frontenac South)"
+"PostalCode": "K0H2W0"
+"UnparsedAddress": "2038 VALLEYVIEW DRIVE, Frontenac (Frontenac South), Ontario K0H2W0"
+"Coordinates": array:2 [
0 => -76.6922881
1 => 44.4687972
]
+"Latitude": 44.4687972
+"Longitude": -76.6922881
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Welcome to this exceptional luxury country estate, where timeless elegance meets modern comfort. Set on a picturesque 2-acre lot surrounded by natural beauty, this remarkable home offers an outstanding lifestyle. A spacious foyer leads to the elegant living room, filled with natural light from oversized windows and flowing through stately columns into the formal dining room-perfect for entertaining. The chef's kitchen features quartz countertops, abundant cabinetry, generous workspace, and opens seamlessly to the warm family room with a cozy fireplace. Step out from the Family room onto the expansive deck to enjoy peaceful country views, ideal for family gatherings, summer barbecues, or quiet evenings under the stars. The main level also includes a private home office and a spacious laundry room. Upstairs, the luxurious primary suite offers a beautifully appointed en-suite, while two additional bedrooms provide comfortable accommodations for family or guests. The upper bonus level features a games room and fourth bedroom, perfect for guests, teens, hobbies, or relaxation. Luxurious finishes throughout, an attached double garage with inside entry, and a sought-after location just 20 minutes from Kingston in the village of Verona and walking distance to two lakes and the KP trail complete this exceptional offering. Experience estate living at its finest. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Range"
7 => "Oven"
8 => "Dryer"
9 => "Oven - Built-In"
10 => "Garage door opener remote(s)"
11 => "Water Heater"
]
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T16:53:46.398423+00:00"
+"Directions": "Cross Streets: Cedarwoods Dr. ** Directions: Road 38 north from Kingston, Right on Cedarwoods Dr., Right on Valleyview Dr."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1572578"
+"ListOfficeKey": "277109"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Wooded area"
2 => "Irregular lot size"
3 => "Lighting"
]
+"LotSizeDimensions": "245.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T15:40:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T14:01:09Z"
+"Stories": "2.0"
+"StreetName": "Valleyview"
+"StreetNumber": "2038"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4271.78"
+"Utilities": array:5 [
0 => "Electricity"
1 => "Cable"
2 => "Telephone"
3 => "Wireless"
4 => "Electricity Connected"
]
+"VirtualTourURLUnbranded": "https://www.youtube.com/watch?v=IegX5IZbaSE"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1679073665"
"RoomType" => "Living room"
"ListingId" => "X13532032"
"RoomLevel" => "Main level"
"RoomWidth" => 4.22
"ListingKey" => "29999163"
"RoomLength" => 5.89
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
1 => array:11 [
"RoomKey" => "1679073666"
"RoomType" => "Dining room"
"ListingId" => "X13532032"
"RoomLevel" => "Main level"
"RoomWidth" => 4.22
"ListingKey" => "29999163"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
2 => array:11 [
"RoomKey" => "1679073667"
"RoomType" => "Bedroom 2"
"ListingId" => "X13532032"
"RoomLevel" => "Second level"
"RoomWidth" => 3.58
"ListingKey" => "29999163"
"RoomLength" => 4.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
3 => array:11 [
"RoomKey" => "1679073668"
"RoomType" => "Bedroom 3"
"ListingId" => "X13532032"
"RoomLevel" => "Second level"
"RoomWidth" => 3.4
"ListingKey" => "29999163"
"RoomLength" => 4.14
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
4 => array:11 [
"RoomKey" => "1679073669"
"RoomType" => "Bathroom"
"ListingId" => "X13532032"
"RoomLevel" => "Second level"
"RoomWidth" => 1.52
"ListingKey" => "29999163"
"RoomLength" => 3.2
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
5 => array:11 [
"RoomKey" => "1679073670"
"RoomType" => "Games room"
"ListingId" => "X13532032"
"RoomLevel" => "Second level"
"RoomWidth" => 3.4
"ListingKey" => "29999163"
"RoomLength" => 5.74
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
6 => array:11 [
"RoomKey" => "1679073671"
"RoomType" => "Bedroom 4"
"ListingId" => "X13532032"
"RoomLevel" => "Second level"
"RoomWidth" => 3.89
"ListingKey" => "29999163"
"RoomLength" => 4.57
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
7 => array:11 [
"RoomKey" => "1679073672"
"RoomType" => "Kitchen"
"ListingId" => "X13532032"
"RoomLevel" => "Main level"
"RoomWidth" => 3.02
"ListingKey" => "29999163"
"RoomLength" => 4.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
8 => array:11 [
"RoomKey" => "1679073673"
"RoomType" => "Eating area"
"ListingId" => "X13532032"
"RoomLevel" => "Main level"
"RoomWidth" => 2.74
"ListingKey" => "29999163"
"RoomLength" => 5.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
9 => array:11 [
"RoomKey" => "1679073674"
"RoomType" => "Family room"
"ListingId" => "X13532032"
"RoomLevel" => "Main level"
"RoomWidth" => 3.61
"ListingKey" => "29999163"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
10 => array:11 [
"RoomKey" => "1679073675"
"RoomType" => "Laundry room"
"ListingId" => "X13532032"
"RoomLevel" => "Main level"
"RoomWidth" => 1.47
"ListingKey" => "29999163"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
11 => array:11 [
"RoomKey" => "1679073676"
"RoomType" => "Office"
"ListingId" => "X13532032"
"RoomLevel" => "Main level"
"RoomWidth" => 3.5
"ListingKey" => "29999163"
"RoomLength" => 3.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
12 => array:11 [
"RoomKey" => "1679073677"
"RoomType" => "Partial bathroom"
"ListingId" => "X13532032"
"RoomLevel" => "Main level"
"RoomWidth" => 1.5
"ListingKey" => "29999163"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
13 => array:11 [
"RoomKey" => "1679073678"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13532032"
"RoomLevel" => "Second level"
"RoomWidth" => 4.29
"ListingKey" => "29999163"
"RoomLength" => 4.55
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
14 => array:11 [
"RoomKey" => "1679073679"
"RoomType" => "Bathroom"
"ListingId" => "X13532032"
"RoomLevel" => "Second level"
"RoomWidth" => 2.89
"ListingKey" => "29999163"
"RoomLength" => 3.94
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-09T14:01:09.1Z"
]
]
+"ListAOR": "Kingston"
+"CityRegion": "47 - Frontenac South"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29999163/2038-valleyview-drive-frontenac-frontenac-south-47-frontenac-south"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1834647"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "277109"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "ER2"
+"BedroomsAboveGrade": 4
+"FrontageLengthNumeric": 245.3
+"OriginalEntryTimestamp": "2026-07-07T15:40:53.85Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1152045"
+"ListOfficeNationalAssociationId": "1306303"
+"CoListAgentNationalAssociationId": "1196795"
+"CoListOfficeNationalAssociationId": "1306303"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29999163_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/4a88a3620424cc70757b0d152bb804ca.webp"
"MediaSize" => 108612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-4a88a3620424cc70757b0d152bb804ca.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29999163_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/41004a0910538dab51a88e924575cc7e.webp"
"MediaSize" => 90886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-41004a0910538dab51a88e924575cc7e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29999163_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/2262bee35482b15621bd697ae92b44e9.webp"
"MediaSize" => 99190
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-2262bee35482b15621bd697ae92b44e9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29999163_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/e1176e52a7238d4ee1b2cb3329a66398.webp"
"MediaSize" => 65482
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-e1176e52a7238d4ee1b2cb3329a66398.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29999163_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/b239adf008d4c33ab90b911cbf8e4d41.webp"
"MediaSize" => 44363
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-b239adf008d4c33ab90b911cbf8e4d41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29999163_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/20f65fcc846df7a89ea71550187977f6.webp"
"MediaSize" => 48291
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-20f65fcc846df7a89ea71550187977f6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29999163_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/c2698b491925b319b83391d70b2f36e4.webp"
"MediaSize" => 38282
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-c2698b491925b319b83391d70b2f36e4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29999163_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/2572839b483bb42e9cded77c21210e35.webp"
"MediaSize" => 66749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-2572839b483bb42e9cded77c21210e35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29999163_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/ea6420b135e76ea4c55faa6a301c8bd0.webp"
"MediaSize" => 72498
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-ea6420b135e76ea4c55faa6a301c8bd0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29999163_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/72b7c5ef45452d6f4e64b1bc2c2986fd.webp"
"MediaSize" => 65088
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-72b7c5ef45452d6f4e64b1bc2c2986fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29999163_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/aa46f724738260d97e436820e2eea11c.webp"
"MediaSize" => 70950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-aa46f724738260d97e436820e2eea11c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29999163_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/9e4a5478aeca69c0b34184bea418acfc.webp"
"MediaSize" => 56241
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-9e4a5478aeca69c0b34184bea418acfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13532032"
"ResourceRecordKey" => "29999163"
"ModificationTimestamp" => "2026-07-07T15:40:53.85Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29999163_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29999163/2c7f2b2fc276bbe887d320bc30ca8e5d.webp"
"MediaSize" => 60079
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29999163/thumbnail-2c7f2b2fc276bbe887d320bc30ca8e5d.webp"
…7
]
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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29999163')"
+"ID": "1603457"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25376
+post_id: "1583903"
+post_author: 1
+"ListingKey": "29978459"
+"ListingId": "X13512994"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T17:55:19Z"
+"RFModificationTimestamp": "2026-07-06T18:15:37Z"
+"ListPrice": 899000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Frontenac (Frontenac South)"
+"PostalCode": "K0H1W0"
+"UnparsedAddress": "2097 HAMBLY LANE, Frontenac (Frontenac South), Ontario K0H1W0"
+"Coordinates": array:2 [
0 => -76.678238
1 => 44.477997
]
+"Latitude": 44.477997
+"Longitude": -76.678238
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Welcome to your own waterfront retreat on spectacular Hambly Lake. Nestled on a beautifully terraced 2/3-acre lot just 25 minutes north of Highway 401, this meticulously maintained 3-bedroom, 2-bath home offers the perfect blend of comfort, privacy and year-round lakeside living.Designed to capture the beauty of its surroundings, the bright, open main level is filled with natural light and stunning lake views. A full-length screened porch extends your living space outdoors, creating the perfect place to enjoy morning coffee, family dinners or a quiet evening listening to the sounds of the lake. The spacious primary suite offers a walk-in closet and convenient access to the main bath, while a pocket door allows the bedroom, bath and laundry area to become a private retreat.The walk-out lower level is ideal for family and guests, featuring a warm and inviting family room with a pellet stove, two additional bedrooms with a Jack-and-Jill bath, a flexible office area for working from home, and a sunroom with easy access to the backyard and waterfront.Outside, the gently terraced property invites you to embrace everything waterfront living has to offer. Spend summer days swimming, boating, paddling or fishing right from your shoreline, then relax in the hot tub or unwind in the sauna as the sun sets over the lake. In winter, enjoy skating, sledding and cross-country skiing just steps from your door.Hambly Lake connects to Verona and Howes Lakes through Hardwood Creek, expanding your boating and paddling adventures while offering the peaceful atmosphere that makes this area so special.Over the years, the home has been thoughtfully updated inside and out, providing both modern comfort and peace of mind. A complete list of features and improvements is available in the Documents section. (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Sauna"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Microwave"
9 => "Water Treatment"
10 => "Garage door opener remote(s)"
11 => "Water Heater - Tankless"
12 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Crawl space"
3 => "Walk out"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T16:48:39.708878+00:00"
+"Directions": "Cross Streets: Hinchinbrooke. ** Directions: Road 38 to Hinchinbrooke Road, left on Silver Rock Lane, left on Hambly Lane."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Pellet"
1 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Electric"
3 => "Propane"
4 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2143947"
+"ListOfficeKey": "293623"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sauna"
]
+"LotSizeDimensions": "103 x 270.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T15:51:52Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T17:49:54Z"
+"Stories": "1.0"
+"StreetName": "Hambly"
+"StreetNumber": "2097"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "3482"
+"View": "Lake view,Direct Water View"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/2097_hambly_ln_hartington_on/"
+"WaterBodyName": "Hambly Lake"
+"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": "Kingston"
+"TaxYear": 2025
+"CityRegion": "47 - Frontenac South"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29978459/2097-hambly-lane-frontenac-frontenac-south-47-frontenac-south"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "RU-F"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 103.0
+"OriginalEntryTimestamp": "2026-07-02T15:51:51.89Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1395495"
+"ListOfficeNationalAssociationId": "1429326"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978459')"
+"ID": "1583903"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25373
+post_id: "1570977"
+post_author: 1
+"ListingKey": "29958700"
+"ListingId": "X13494354"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T11:50:22Z"
+"RFModificationTimestamp": "2026-07-05T11:52:41Z"
+"ListPrice": 499900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Frontenac (Frontenac South)"
+"PostalCode": "K0H2W0"
+"UnparsedAddress": "4470 VERONA SAND ROAD, Frontenac (Frontenac South), Ontario K0H2W0"
+"Coordinates": array:2 [
0 => -76.7022139
1 => 44.4779314
]
+"Latitude": 44.4779314
+"Longitude": -76.7022139
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Are you looking to get your kids off their devices and spend more time in the outdoors? Well, this is the place for you! Welcome to this beautifully maintained family home, where comfort, style, and outdoor living come together perfectly. Featuring 3 generous bedrooms, 2 full bathrooms, an attached garage with convenient inside entry, a spacious eat-in kitchen, and a functional mudroom, this home is designed for everyday living. Step outside and discover your own private backyard retreat. Set on a large lot, this incredible outdoor space is packed with amenities for family fun, entertaining, and relaxing all summer long, making every day feel like a vacation at home. Pick your teams, play a friendly or competitive game of beach volleyball, rinse off in the outdoor shower, take a dip in the above group pool, have a fun game of outdoor pool or horseshoes, and then relax by a fire and enjoy the opportunity to watch the wildlife surrounding you. From Moose, deer and turkeys to turtles and woodpeckers, you will have hours of enjoying nature right from your own backyard. Ideally located just minutes from Verona, you'll enjoy the perfect balance of small-town charm and easy access to local amenities, schools, recreation, and lakes. A fantastic opportunity for families, first-time buyers, or anyone looking to enjoy the best of country living with modern convenience. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Partial"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"CreationDate": "2026-06-26T18:24:50.616931+00:00"
+"Directions": "Cross Streets: Hwy 38. ** Directions: Hwy 38 to Sand rd (Verona Sand Rd)."
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FireplaceFeatures": array:1 [
0 => "Woodstove"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2089374"
+"ListOfficeKey": "293623"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "170.6 x 264.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T16:51:56Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T11:39:55Z"
+"Stories": "2.0"
+"StreetName": "Verona Sand"
+"StreetNumber": "4470"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "1855"
+"Utilities": array:1 [
0 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=n8BbDqRurXC"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"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": "Kingston"
+"TaxYear": 2025
+"CityRegion": "47 - Frontenac South"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29958700/4470-verona-sand-road-frontenac-frontenac-south-47-frontenac-south"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Canopy"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 170.7
+"OriginalEntryTimestamp": "2026-06-26T16:51:56.51Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1362635"
+"ListOfficeNationalAssociationId": "1429326"
+"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('29958700')"
+"ID": "1570977"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25377
+post_id: "1558190"
+post_author: 1
+"ListingKey": "29940353"
+"ListingId": "X13477494"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T01:30:08Z"
+"RFModificationTimestamp": "2026-06-24T01:32:58Z"
+"ListPrice": 49900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Frontenac (Frontenac South)"
+"PostalCode": "K0H2W0"
+"UnparsedAddress": "LOT 8 QUINTE CONSERVATION LANE, Frontenac (Frontenac South), Ontario K0H2W0"
+"Coordinates": array:2 [
0 => -76.6876212
1 => 44.4656042
]
+"Latitude": 44.4656042
+"Longitude": -76.6876212
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Here is your opportunity to get a waterfront lot at a really good price! Although this lot CANNOT be built on at this time because of its size it does offer the opportunity to explore alternative decisions with the township/conservation authority. The lot is nicely treed and offers a gradual slope to the waterfront on Hambly Lake with over 159' of shoreline and totals close to a 1/4 acre in size. The property is surrounded by 26 acres of Conservation land with the exception of the one year-round neighbor making the lot feel much larger. Access to this property is excellent with being only 1 +/- km off Road #38 South of Verona and only 20 min to the 401. Call today to explore this unique opportunity. (id:62650)"
+"CreationDate": "2026-06-23T17:31:37.569588+00:00"
+"Directions": "Cross Streets: Road #38. ** Directions: K0H2W0."
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1800621"
+"ListOfficeKey": "55430"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Irregular lot size"
]
+"LotSizeDimensions": "100.42 x 150.73 FT"
+"PhotosChangeTimestamp": "2026-06-23T12:20:29Z"
+"PhotosCount": 20
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T01:20:44Z"
+"StreetName": "Quinte Conservation"
+"StreetNumber": "LOT 8"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "797.99"
+"Utilities": array:1 [
0 => "Electricity"
]
+"View": "Direct Water View"
+"WaterBodyName": "Hambly Lake"
+"ListAOR": "Kingston"
+"TaxYear": 2025
+"CityRegion": "47 - Frontenac South"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29940353/lot-8-quinte-conservation-lane-frontenac-frontenac-south-47-frontenac-south"
+"CoListAgentKey": "2213171"
+"CoListOfficeKey": "55430"
+"GeocodeManualYN": true
+"ZoningDescription": "Limited Service Residential Waterfront"
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 100.5
+"OriginalEntryTimestamp": "2026-06-23T12:20:29.87Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1190514"
+"ListOfficeNationalAssociationId": "1003849"
+"CoListAgentNationalAssociationId": "1458974"
+"CoListOfficeNationalAssociationId": "1003849"
+"Media": array:20 [
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]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29940353')"
+"ID": "1558190"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25375
+post_id: "1546606"
+post_author: 1
+"ListingKey": "29924907"
+"ListingId": "X13464018"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T14:00:05Z"
+"RFModificationTimestamp": "2026-06-30T14:02:26Z"
+"ListPrice": 374900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Frontenac (Frontenac South)"
+"PostalCode": "K0H1W0"
+"UnparsedAddress": "2077 HAMBLY LANE, Frontenac (Frontenac South), Ontario K0H1W0"
+"Coordinates": array:2 [
0 => -76.677487
1 => 44.479296
]
+"Latitude": 44.479296
+"Longitude": -76.677487
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Central Lakes Association of REALTORS®"
+"PublicRemarks": "Welcome to 2077 Hambly Lane, a charming waterfront bungalow nestled along the shores of beautiful Hambly Lake in Frontenac. Offering direct waterfront access, peaceful surroundings, and seasonal enjoyment, this property is the perfect escape for those seeking a cottage retreat, recreational getaway, or tranquil lakeside living. Set on a picturesque lot with over 65 feet of waterfront frontage, this cozy bungalow offers a bright and inviting interior designed to make the most of its stunning natural setting. The open-concept living and dining area provides a comfortable space to relax and gather, while large windows invite natural light and showcase beautiful lake views. The kitchen offers functional workspace and ample cabinetry, making meal preparation easy. The home features two comfortable bedrooms and a well-appointed three-piece bathroom, providing practical accommodations for family and guests. Recent updates completed within the last five years include new flooring, pine accent walls, updated light fixtures, kitchen cabinets and countertops, as well as a new pressure tank, water pump, sewage pump, and owned hot water tank, offering peace of mind and modern comfort. Step outside to enjoy everything waterfront living has to offer. A spacious deck overlooks the property and provides the perfect setting for outdoor dining, entertaining, or simply relaxing while taking in the peaceful lake views. The private dock offers direct access to Hambly Lake for swimming, fishing, paddling, and boating, while the gently sloping lot creates an inviting connection to the shoreline. With year-round road access, private parking, and a quiet location surrounded by nature, this property offers a rare opportunity to enjoy affordable waterfront ownership. Whether you're looking for a seasonal getaway, weekend retreat, or a place to create lasting family memories, 2077 Hambly Lane is ready to welcome you to life at the lake. (id:62783)"
+"Appliances": array:3 [
0 => "Refrigerator"
1 => "Stove"
2 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Fishing"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-18T23:09:55.179164+00:00"
+"Directions": "Silver Lake Lane/Hambly Lane"
+"ExteriorFeatures": array:1 [
0 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Slab"
]
+"Heating": array:2 [
0 => "Other"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2050619"
+"ListOfficeKey": "293959"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Hilly"
1 => "Carpet Free"
]
+"LotSizeDimensions": "65.6 x 185.9 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-20T00:20:49Z"
+"PhotosCount": 38
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T13:50:40Z"
+"Stories": "1.0"
+"StreetName": "Hambly"
+"StreetNumber": "2077"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "1731"
+"Utilities": array:1 [
0 => "Electricity"
]
+"View": "Direct Water View"
+"WaterBodyName": "Hambly Lake"
+"WaterSource": array:1 [
0 => "Lake/River Water Intake"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Central Lakes"
+"CityRegion": "47 - Frontenac South"
+"ListAORKey": "88"
+"ListingURL": "www.realtor.ca/real-estate/29924907/2077-hambly-lane-frontenac-frontenac-south-47-frontenac-south"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2179014"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "293959"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 699
+"LivingAreaMinimum": 0
+"ZoningDescription": "RU-F"
+"BedroomsAboveGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on lake"
]
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-06-18T20:53:39.55Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1325925"
+"ListOfficeNationalAssociationId": "1433654"
+"CoListAgentNationalAssociationId": "1428906"
+"CoListOfficeNationalAssociationId": "1433654"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29924907')"
+"ID": "1546606"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25370
+post_id: "1511863"
+post_author: 1
+"ListingKey": "29877146"
+"ListingId": "X13421118"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T11:55:14Z"
+"RFModificationTimestamp": "2026-06-14T11:57:57Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Frontenac (Frontenac South)"
+"PostalCode": "K0H2W0"
+"UnparsedAddress": "6045 VERONA STREET, Frontenac (Frontenac South), Ontario K0H2W0"
+"Coordinates": array:2 [
0 => -76.6957455
1 => 44.4801672
]
+"Latitude": 44.4801672
+"Longitude": -76.6957455
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Welcome to this well-maintained 2-storey home in the village of Verona, offering 3 bedrooms, 1 bathroom and an exceptional opportunity to own under $500,000. Situated on a quiet street on just under half an acre, this property combines rural surroundings with convenient access to local amenities, all within walking distance, including shops, school, and restaurants. The K&P trail is directly across the road, providing immediate access to walking and cycling. Nearby amenities include a public beach, boat launch, golf course, arena and ball diamond. The fully fenced yard offers privacy and space for outdoor enjoyment, complete with a large fire pit area, patio, and gazebo. There is a detached 2-car garage/workshop. The main portion of the home features a durable metal roof. Inside the home offers a large living room on the main, a kitchen with all appliances included and a bonus room off the back adding tons of natural light. The upper level includes three bedrooms, providing functional space for families or guests and an updated 4-piece washroom. This home is functional, well-maintained, and spacious, offering a great opportunity to enjoy small-town living with convenient access to everyday amenities and outdoor recreation. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"Cooling": array:1 [
0 => "None"
]
+"CreationDate": "2026-06-09T18:45:23.142581+00:00"
+"Directions": "Cross Streets: Sand Road & Verona Street. ** Directions: Highway 38 to Sand Road to Verona Street."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:5 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Wood"
3 => "Other"
4 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2072522"
+"ListOfficeKey": "55459"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Flat site"
1 => "Carpet Free"
]
+"LotSizeDimensions": "152 x 128 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:50:53Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T11:40:47Z"
+"Stories": "2.0"
+"StreetName": "Verona"
+"StreetNumber": "6045"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "1503"
+"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": "Kingston"
+"CityRegion": "47 - Frontenac South"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29877146/6045-verona-street-frontenac-frontenac-south-47-frontenac-south"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1646682"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55459"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 152.0
+"OriginalEntryTimestamp": "2026-06-09T17:50:53.41Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1347710"
+"ListOfficeNationalAssociationId": "1003853"
+"CoListAgentNationalAssociationId": "1166665"
+"CoListOfficeNationalAssociationId": "1003853"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 30
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29877146')"
+"ID": "1511863"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1501074"
+post_author: 1
+"ListingKey": "29863034"
+"ListingId": "X13252692"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T16:25:01Z"
+"RFModificationTimestamp": "2026-07-02T16:34:03Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Frontenac (Frontenac South)"
+"PostalCode": "K0H2W0"
+"UnparsedAddress": "5895 DAVEY DRIVE, Frontenac (Frontenac South), Ontario K0H2W0"
+"Coordinates": array:2 [
0 => -76.692302
1 => 44.473168
]
+"Latitude": 44.473168
+"Longitude": -76.692302
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "More than just a bungalow in the country, this beautifully maintained property offers the perfect blend of comfort, privacy, and outdoor enjoyment. Lovingly cared for by its owners, the home has been well maintained over the years with numerous updates and improvements, providing peace of mind for years to come. Set on 2 private acres with a long paved driveway, the property is surrounded by tasteful landscaping, mature trees, and manicured grounds, creating a truly park-like setting. Inside, you'll find spacious principal rooms designed for comfortable everyday living. The finished lower level features a large recreation room and an oversized fourth bedroom, providing plenty of space for family, guests, hobbies, or a home office. Step outside to enjoy the expansive deck overlooking the peaceful backyard, ideal for entertaining or simply relaxing in nature. Wander through your own wooded trails to a private dock on Hardwood Creek, where you can boat directly into Verona Lake and access two additional lakes for extended boating, fishing, and exploring. Whether you're looking for a year-round home or a country retreat, this property offers a rare combination of quality, privacy, and waterfront access in a picturesque country setting. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Freezer"
8 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T20:57:05.609019+00:00"
+"Directions": "Cross Streets: Davey Dr and Maple Dr. ** Directions: Maple Dr to Davey Dr."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Cedar Siding"
]
+"FireplaceFeatures": array:2 [
0 => "Pellet"
1 => "Stove"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1453984"
+"ListOfficeKey": "299990"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Wooded area"
1 => "Open space"
]
+"LotSizeDimensions": "195 x 522 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T16:18:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T16:18:20Z"
+"Stories": "1.0"
+"StreetName": "Davey"
+"StreetNumber": "5895"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3533.95"
+"Utilities": array:3 [
0 => "Electricity"
1 => "Wireless"
2 => "Electricity Connected"
]
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=FfkZoT3zBav"
+"WaterBodyName": "Hardwood Creek"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"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": "Kingston"
+"CityRegion": "47 - Frontenac South"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29863034/5895-davey-drive-frontenac-frontenac-south-47-frontenac-south"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on creek"
]
+"FrontageLengthNumeric": 195.0
+"OriginalEntryTimestamp": "2026-06-05T20:20:48.32Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1102267"
+"ListOfficeNationalAssociationId": "1480339"
+"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": 34
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29863034')"
+"ID": "1501074"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25378
+post_id: "1494910"
+post_author: 1
+"ListingKey": "29853958"
+"ListingId": "X13241012"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T11:50:20Z"
+"RFModificationTimestamp": "2026-06-28T11:52:11Z"
+"ListPrice": 529900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Frontenac (Frontenac South)"
+"PostalCode": "K0H2W0"
+"UnparsedAddress": "6074 BANK STREET, Frontenac (Frontenac South), Ontario K0H2W0"
+"Coordinates": array:2 [
0 => -76.695447
1 => 44.481651
]
+"Latitude": 44.481651
+"Longitude": -76.695447
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Welcome to 6074 Bank Street! This beautifully updated country property offers the space, privacy, and potential so many dream about. Set on just under 1.4 acres in peaceful South Frontenac, this move-in-ready home is perfect for those craving a slower pace and a more self-sufficient lifestyle. Just a 20-minute commute from Kingston, yet comfortably distant from Highway 38,making for peaceful evenings.If you've ever imagined growing your own food, collecting fresh eggs each morning, planting expansive gardens, or simply having room to breathe, this property is full of opportunity. The flat land and rich soil offers excellent potential for vegetable gardens, fruit trees, chickens, or a backyard oasis. Surrounded by mature trees for privacy, the property also features a fenced yard, new side gate, refreshed driveway, and charming interlock walkway. There's ample space for future outbuildings, a workshop, greenhouse, detached garage, or additional outdoor living areas. Inside, the home has been extensively renovated with a bright, welcoming layout featuring 3 bedrooms and 2 fully updated bathrooms. Thoughtful improvements throughout blend modern comfort with country living, making it easy to settle in and enjoy from day one. Major upgrades have already been completed, including a new heat pump and propane furnace (2023), upgraded 200-amp electrical service, enhanced water systems with UV filtration and sediment filters, updated plumbing lines, and professionally spray-foamed basement insulation for improved efficiency. Additional exterior improvements, including a new deck (2025), updated fascia and eavestroughs, and durable steel roofing elements, add long-term peace of mind. Whether you're dreaming of abundant gardens, a more self-sufficient lifestyle, or simply a peaceful property with room to grow, 6074 Bank Street offers the perfect blend of modern updates, usable land, and country charm. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Heater"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T18:36:07.842816+00:00"
+"Directions": "Cross Streets: BANK ST AND VERONA ST. ** Directions: HIGHWAY 38 TO BANK ST."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2031326"
+"ListOfficeKey": "277109"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level lot"
1 => "Irregular lot size"
]
+"LotSizeDimensions": "117 x 487 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T16:51:17Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T11:40:38Z"
+"Stories": "2.0"
+"StreetName": "Bank"
+"StreetNumber": "6074"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "1813.62"
+"Utilities": array:4 [
0 => "Electricity"
1 => "Cable"
2 => "Wireless"
3 => "Electricity Connected"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/6074_bank_st_verona_on"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"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": "Kingston"
+"CityRegion": "47 - Frontenac South"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29853958/6074-bank-street-frontenac-frontenac-south-47-frontenac-south"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"PropertyCondition": array:1 [
0 => "Insulation upgraded"
]
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 117.0
+"OriginalEntryTimestamp": "2026-06-04T16:51:17.38Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1308855"
+"ListOfficeNationalAssociationId": "1306303"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 35
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29853958')"
+"ID": "1494910"
}
]
+success: true
+page_size: 8
+page_count: 1
+count: 8
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]