array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29825205 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23406
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23408
+post_id: "1474537"
+post_author: 1
+"ListingKey": "29825205"
+"ListingId": "X13214622"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T11:55:08Z"
+"RFModificationTimestamp": "2026-06-15T11:59:24Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City North of 401)"
+"PostalCode": "K7L4V4"
+"UnparsedAddress": "1470 SYDENHAM ROAD, Kingston (City North of 401), Ontario K7L4V4"
+"Coordinates": array:2 [
0 => -76.541267
1 => 44.283785
]
+"Latitude": 44.283785
+"Longitude": -76.541267
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Welcome to 1470 Sydenham Road, where country charm meets city convenience in this beautifully finished Kingston property. Ideally located just minutes to Highway 401 and everyday amenities, this exceptional home offers the perfect "city in the country" lifestyle on a spacious lot with extensive parking for vehicles, trailers, recreational toys, and guests. Inside, the bright and functional main floor is designed for comfortable living and entertaining, featuring a spacious kitchen with breakfast area, formal dining room, and inviting living space filled with natural light. Upstairs, you'll find three generously sized bedrooms, including a primary retreat complete with walk-in closet and convenient 2-piece ensuite, along with a large 4-piece family bath. The finished lower level adds incredible versatility with a spacious recreation room, dedicated office, 3-piece bathroom, and abundant storage and utility space with walk-up access to the oversized garage. The garage itself is a standout feature, offering workshop space, heating and cooling, and previously serving as a salon, making it ideal for hobbyists, home-based businesses, or additional flexible use. Beautifully maintained from top to bottom, this property delivers exceptional space, functionality, and lifestyle both inside and out. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Play structure"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:5 [
0 => "Finished"
1 => "None"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T19:26:23.639988+00:00"
+"Directions": "Cross Streets: Sydenham Road and Aley St. ** Directions: Sydenham Road, north of 401."
+"Electric": "Generator"
+"ExteriorFeatures": array:1 [
0 => "Hardboard"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1502125"
+"ListOfficeKey": "290674"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Flat site"
1 => "Carpet Free"
2 => "Sump Pump"
]
+"LotSizeDimensions": "91.9 x 300 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T17:20:55Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T11:40:33Z"
+"StreetName": "Sydenham"
+"StreetNumber": "1470"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4314"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtu.be/6d6QiYzpJxs"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1659710460"
"RoomType" => "Kitchen"
"ListingId" => "X13214622"
"RoomLevel" => "Main level"
"RoomWidth" => 4.67
"ListingKey" => "29825205"
"RoomLength" => 3.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
1 => array:11 [
"RoomKey" => "1659710461"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13214622"
"RoomLevel" => "Basement"
"RoomWidth" => 7.83
"ListingKey" => "29825205"
"RoomLength" => 5.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
2 => array:11 [
"RoomKey" => "1659710462"
"RoomType" => "Office"
"ListingId" => "X13214622"
"RoomLevel" => "Basement"
"RoomWidth" => 2.29
"ListingKey" => "29825205"
"RoomLength" => 2.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
3 => array:11 [
"RoomKey" => "1659710463"
"RoomType" => "Bathroom"
"ListingId" => "X13214622"
"RoomLevel" => "Basement"
"RoomWidth" => 2.31
"ListingKey" => "29825205"
"RoomLength" => 1.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
4 => array:11 [
"RoomKey" => "1659710464"
"RoomType" => "Other"
"ListingId" => "X13214622"
"RoomLevel" => "Basement"
"RoomWidth" => 1.57
"ListingKey" => "29825205"
"RoomLength" => 2.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
5 => array:11 [
"RoomKey" => "1659710465"
"RoomType" => "Other"
"ListingId" => "X13214622"
"RoomLevel" => "Basement"
"RoomWidth" => 6.8
"ListingKey" => "29825205"
"RoomLength" => 8.93
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
6 => array:11 [
"RoomKey" => "1659710466"
"RoomType" => "Other"
"ListingId" => "X13214622"
"RoomLevel" => "Basement"
"RoomWidth" => 1.43
"ListingKey" => "29825205"
"RoomLength" => 1.23
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
7 => array:11 [
"RoomKey" => "1659710467"
"RoomType" => "Eating area"
"ListingId" => "X13214622"
"RoomLevel" => "Main level"
"RoomWidth" => 2.23
"ListingKey" => "29825205"
"RoomLength" => 1.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
8 => array:11 [
"RoomKey" => "1659710468"
"RoomType" => "Dining room"
"ListingId" => "X13214622"
"RoomLevel" => "Main level"
"RoomWidth" => 3.09
"ListingKey" => "29825205"
"RoomLength" => 3.53
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
9 => array:11 [
"RoomKey" => "1659710469"
"RoomType" => "Living room"
"ListingId" => "X13214622"
"RoomLevel" => "Main level"
"RoomWidth" => 5.1
"ListingKey" => "29825205"
"RoomLength" => 3.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
10 => array:11 [
"RoomKey" => "1659710470"
"RoomType" => "Foyer"
"ListingId" => "X13214622"
"RoomLevel" => "Main level"
"RoomWidth" => 1.8
"ListingKey" => "29825205"
"RoomLength" => 1.61
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
11 => array:11 [
"RoomKey" => "1659710471"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13214622"
"RoomLevel" => "Upper Level"
"RoomWidth" => 4.33
"ListingKey" => "29825205"
"RoomLength" => 3.64
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
12 => array:11 [
"RoomKey" => "1659710472"
"RoomType" => "Bathroom"
"ListingId" => "X13214622"
"RoomLevel" => "Upper Level"
"RoomWidth" => 0.69
"ListingKey" => "29825205"
"RoomLength" => 1.97
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.73Z"
]
13 => array:11 [
"RoomKey" => "1659710473"
"RoomType" => "Bathroom"
"ListingId" => "X13214622"
"RoomLevel" => "Upper Level"
"RoomWidth" => 2.62
"ListingKey" => "29825205"
"RoomLength" => 3.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.74Z"
]
14 => array:11 [
"RoomKey" => "1659710474"
"RoomType" => "Bedroom"
"ListingId" => "X13214622"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.09
"ListingKey" => "29825205"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.74Z"
]
15 => array:11 [
"RoomKey" => "1659710475"
"RoomType" => "Bedroom"
"ListingId" => "X13214622"
"RoomLevel" => "Upper Level"
"RoomWidth" => 3.01
"ListingKey" => "29825205"
"RoomLength" => 3.25
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-15T11:40:33.74Z"
]
]
+"ListAOR": "Kingston"
+"CityRegion": "44 - City North of 401"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29825205/1470-sydenham-road-kingston-city-north-of-401-44-city-north-of-401"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2065699"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1995184"
+"CoListAgentKey3": "2238451"
+"CoListOfficeKey": "290674"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"CoListOfficeKey2": "290674"
+"CoListOfficeKey3": "290674"
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 91.1
+"OriginalEntryTimestamp": "2026-05-29T17:20:49.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1136057"
+"ListOfficeNationalAssociationId": "1390169"
+"CoListAgentNationalAssociationId": "1340864"
+"CoListAgentNationalAssociationId2": "1278129"
+"CoListAgentNationalAssociationId3": "1476285"
+"CoListOfficeNationalAssociationId": "1390169"
+"CoListOfficeNationalAssociationId2": "1390169"
+"CoListOfficeNationalAssociationId3": "1390169"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29825205_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/b48b0447dc2143ae79762dccd35acc0f.webp"
"MediaSize" => 369359
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-b48b0447dc2143ae79762dccd35acc0f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29825205_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/13ffddd853b310b9651391329794820c.webp"
"MediaSize" => 261944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-13ffddd853b310b9651391329794820c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29825205_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/41259b1f353c9aa631f8de426286a6cc.webp"
"MediaSize" => 379332
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-41259b1f353c9aa631f8de426286a6cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29825205_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/5fca1caf6707987a603287c49bd6ab40.webp"
"MediaSize" => 227496
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-5fca1caf6707987a603287c49bd6ab40.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29825205_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/9364e16a79a7959abaaa715a89caaf9c.webp"
"MediaSize" => 151721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-9364e16a79a7959abaaa715a89caaf9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29825205_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/faa46f70ff8cdcaf61d5340923daa15d.webp"
"MediaSize" => 221564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-faa46f70ff8cdcaf61d5340923daa15d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29825205_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/c6301e8696468f17085b3e25cf97e9f3.webp"
"MediaSize" => 219285
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-c6301e8696468f17085b3e25cf97e9f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29825205_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/3e9eb9bf69899adb32f45608ced13e84.webp"
"MediaSize" => 234517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-3e9eb9bf69899adb32f45608ced13e84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29825205_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/2108943dc990291fafd4557a63ebe902.webp"
"MediaSize" => 271230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-2108943dc990291fafd4557a63ebe902.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29825205_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/c22fe3fa6cfa8b08df495a9475b29197.webp"
"MediaSize" => 227945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-c22fe3fa6cfa8b08df495a9475b29197.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29825205_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/40ee9ef3b2dc1437b1adcb9bbe3f568b.webp"
"MediaSize" => 233543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-40ee9ef3b2dc1437b1adcb9bbe3f568b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29825205_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/f3a909992c22263958c84bf0b7043b96.webp"
"MediaSize" => 218835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-f3a909992c22263958c84bf0b7043b96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29825205_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/641937bd4418f5b483c940e62527b686.webp"
"MediaSize" => 266021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-641937bd4418f5b483c940e62527b686.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29825205_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/0947eb37319991744d5c9beb1211dfbc.webp"
"MediaSize" => 235958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-0947eb37319991744d5c9beb1211dfbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29825205_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/26de10c819809e0c747abbf336563494.webp"
"MediaSize" => 112340
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-26de10c819809e0c747abbf336563494.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29825205_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/69382d4be509a52f663c2bed1574e37c.webp"
"MediaSize" => 169799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-69382d4be509a52f663c2bed1574e37c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29825205_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/83ebc1e8714c689fce3b360d1098102c.webp"
"MediaSize" => 165208
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-83ebc1e8714c689fce3b360d1098102c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29825205_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/25962f1b6167273fb9a904ed1618e8f3.webp"
"MediaSize" => 129390
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-25962f1b6167273fb9a904ed1618e8f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29825205_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/732912ef9c5ad63d717910869bc3affe.webp"
"MediaSize" => 151480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-732912ef9c5ad63d717910869bc3affe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29825205_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/0e15fee0ba08e2ae4745cbef9e5b0bef.webp"
"MediaSize" => 166266
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-0e15fee0ba08e2ae4745cbef9e5b0bef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29825205_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/50494378f47dbbd75b48951a0d3cf6a4.webp"
"MediaSize" => 162843
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-50494378f47dbbd75b48951a0d3cf6a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29825205_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/d7e8c6ffa5bdd97c2237799c19c1b367.webp"
"MediaSize" => 204375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-d7e8c6ffa5bdd97c2237799c19c1b367.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29825205_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/515af11715136f45c6fef8bdc94faa01.webp"
"MediaSize" => 180351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-515af11715136f45c6fef8bdc94faa01.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29825205_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/30752058502cfdf0a6508bd00378f5b2.webp"
"MediaSize" => 200858
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-30752058502cfdf0a6508bd00378f5b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29825205_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/e3a696afa0ac2d96088eac01b545cfc5.webp"
"MediaSize" => 208104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-e3a696afa0ac2d96088eac01b545cfc5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29825205_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/abf8ca4a0c79d54d6c047abf878e2153.webp"
"MediaSize" => 146014
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-abf8ca4a0c79d54d6c047abf878e2153.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29825205_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/3fab65e7523e59f154330abb658104df.webp"
"MediaSize" => 125191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-3fab65e7523e59f154330abb658104df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29825205_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/25505574af5850d213e4ffcb96ae36c5.webp"
"MediaSize" => 271150
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-25505574af5850d213e4ffcb96ae36c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29825205_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/94e978a6f985a84109ab34c2dcbe4b70.webp"
"MediaSize" => 336255
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-94e978a6f985a84109ab34c2dcbe4b70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29825205_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/41e6178a50b1ccb758e115895cce270a.webp"
"MediaSize" => 266338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-41e6178a50b1ccb758e115895cce270a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29825205_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/90a1e7023e1fa19c9564faeda8252f86.webp"
"MediaSize" => 263861
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-90a1e7023e1fa19c9564faeda8252f86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29825205_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/631531bd845948b801c7155e5218c46c.webp"
"MediaSize" => 428261
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-631531bd845948b801c7155e5218c46c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29825205_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/553dde56a3e20345bdbe5bfcc4bed153.webp"
"MediaSize" => 278473
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-553dde56a3e20345bdbe5bfcc4bed153.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29825205_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/c3f8f91bfa7a9443af0ee993f9a3cb68.webp"
"MediaSize" => 472714
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-c3f8f91bfa7a9443af0ee993f9a3cb68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29825205_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/5826f24020a07b71eacbc4bb0dcf601a.webp"
"MediaSize" => 396145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-5826f24020a07b71eacbc4bb0dcf601a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29825205_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825205/345aa30d419c5acbaf2a45f73496c7d8.webp"
"MediaSize" => 377355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825205/thumbnail-345aa30d419c5acbaf2a45f73496c7d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13214622"
"ResourceRecordKey" => "29825205"
"ModificationTimestamp" => "2026-05-29T17:20:49.57Z"
]
36 => array:13 [
"Order" => 37
…12
]
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": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29825205')"
+"ID": "1474537"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 290674" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24927
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1502125" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24900
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29825205'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25249
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29825205'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25264
+items: array:2 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25265
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31415529"
+"ListingKey": "29825205"
+"ListingId": "X13214622"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T15:30:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-11T14:28:46Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31415529')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31430101"
+"ListingKey": "29825205"
+"ListingId": "X13214622"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-14"
+"OpenHouseStartTime": "2026-06-14T14:00:00Z"
+"OpenHouseEndTime": "2026-06-14T15:30:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-15T05:10:14Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31430101')"
}
]
+success: true
+page_size: 2
+page_count: 1
+count: 2
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29825205' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-76.541267 44.283785)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25342
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25336
+post_id: "1519919"
+post_author: 1
+"ListingKey": "29889659"
+"ListingId": "X13432254"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T11:50:16Z"
+"RFModificationTimestamp": "2026-06-15T11:53:37Z"
+"ListPrice": 824000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City North of 401)"
+"PostalCode": "K7L4V4"
+"UnparsedAddress": "1611 SUNNYSIDE ROAD, Kingston (City North of 401), Ontario K7L4V4"
+"Coordinates": array:2 [
0 => -76.521153
1 => 44.288579
]
+"Latitude": 44.288579
+"Longitude": -76.521153
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "1611 Sunnyside Road offers a beautifully updated sprawling bungalow with exceptional versatility. Renovated extensively over the past five years, this move-in ready home features an open-concept layout, sunroom, and a fully fenced private backyard oasis with an in-ground pool, hot tub, composite deck, and detached self-contained guest house. The walk-up lower level is set up as an ideal in-law suite with a bedroom, full bath, wet bar, and recreation room - making this property especially appealing for multi-generational families, investors, or those seeking additional income potential. Just 5 minutes from Highway 401. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Water Treatment"
8 => "Furniture"
9 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Separate entrance"
1 => "Walk-up"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T18:18:42.664321+00:00"
+"Directions": "Sydenham Road to Sunnyside Road"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2168958"
+"ListOfficeKey": "55430"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Open space"
1 => "Flat site"
2 => "Lighting"
3 => "Level"
4 => "Sump Pump"
]
+"LotSizeDimensions": "90 x 167 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-11T16:52:17Z"
+"PhotosCount": 45
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T11:40:50Z"
+"Stories": "1.0"
+"StreetName": "SUNNYSIDE"
+"StreetNumber": "1611"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4225.67"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Wireless"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/3lg2b_17_n_bartlett_st_kingston_on/"
+"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": "44 - City North of 401"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29889659/1611-sunnyside-road-kingston-city-north-of-401-44-city-north-of-401"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "ER"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 90.0
+"OriginalEntryTimestamp": "2026-06-11T16:52:17.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1419605"
+"ListOfficeNationalAssociationId": "1003849"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29889659')"
+"ID": "1519919"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25338
+post_id: "1506891"
+post_author: 1
+"ListingKey": "29870928"
+"ListingId": "X13415524"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T20:30:50Z"
+"RFModificationTimestamp": "2026-06-08T20:43:33Z"
+"ListPrice": 839900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City Northwest)"
+"PostalCode": "K7P0P6"
+"UnparsedAddress": "828 CELESTE DRIVE, Kingston (City Northwest), Ontario K7P0P6"
+"Coordinates": array:2 [
0 => -76.549796
1 => 44.268514
]
+"Latitude": 44.268514
+"Longitude": -76.549796
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Welcome home to 828 Celeste Drive where thoughtful design, timeless luxury and exceptional attention to detail come together. This upgraded Pearson model offers 2,050 sq/ft of beautifully curated living space with 3 bedrooms, 2.5 baths, and a level of finish that truly sets it apart from the rest. From the moment you arrive, it's clear this home is something special. Inside, the bright open concept layout is both elegant and inviting, featuring 9 ft ceilings, rich hardwood and tile flooring, designer lighting, and a stunning gas fireplace that anchors the main living space. Every finish has been carefully selected to create a home that feels refined, warm, and effortlessly functional. The heart of the home is the beautifully upgraded kitchen, complete with quartz countertops, upgraded cabinetry, pendant lighting, and an oversized island designed for gathering, entertaining, and everyday living. The seamless flow between the kitchen, dining, and living areas creates a space that is equally suited for hosting guests or enjoying quiet nights at home. Upstairs, the spacious primary retreat offers the perfect place to unwind, while two additional bedrooms, stylish bathrooms, and convenient second floor laundry provide functionality for growing families, professionals, or those simply looking for turnkey living without compromise. Outside, the thoughtful upgrades continue, further elevating the home's curb appeal and outdoor enjoyment. Every inch of this property has been intentionally designed and meticulously maintained, showcasing a level of pride of ownership rarely seen. Just minutes to shopping, restaurants, parks, recreation, downtown Kingston, and easy access to Highway 401, this is more than just a home, it's a lifestyle. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Hood Fan"
6 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-08T19:02:13.761710+00:00"
+"Directions": "Cross Streets: Atkinson Street & Celeste Drive| Delmar Street & Celeste Drive. ** Directions: Cataraqui Woods to Andersen Drive to Delmar Street to Celeste Drive."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1949849"
+"ListOfficeKey": "55458"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Level lot"
1 => "Flat site"
2 => "Dry"
]
+"LotSizeDimensions": "38.1 x 114.8 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-08T17:51:35Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-08T20:20:54Z"
+"Stories": "2.0"
+"StreetName": "Celeste"
+"StreetNumber": "828"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6057.81"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/828_celeste_dr_kingston_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Kingston"
+"CityRegion": "42 - City Northwest"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29870928/828-celeste-drive-kingston-city-northwest-42-city-northwest"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1639512"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55458"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "LDR"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 38.1
+"OriginalEntryTimestamp": "2026-06-08T17:51:35.11Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1244112"
+"ListOfficeNationalAssociationId": "1003863"
+"CoListAgentNationalAssociationId": "1164749"
+"CoListOfficeNationalAssociationId": "1003863"
+"Media": array:47 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
]
+"DaysOnMarket": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29870928')"
+"ID": "1506891"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25335
+post_id: "1475542"
+post_author: 1
+"ListingKey": "29824916"
+"ListingId": "X13214546"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-29T21:30:46Z"
+"RFModificationTimestamp": "2026-05-29T21:35:52Z"
+"ListPrice": 594900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City Northwest)"
+"PostalCode": "K7P0P2"
+"UnparsedAddress": "1201 MAX CRESCENT, Kingston (City Northwest), Ontario K7P0P2"
+"Coordinates": array:2 [
0 => -76.547509
1 => 44.268014
]
+"Latitude": 44.268014
+"Longitude": -76.547509
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Welcome to this stunning Calgary Model by CaraCo house, offering 1,750 sq. ft. of comfortable living space with 3 bedrooms, 2.5 bathrooms, and an attached garage. Located on a quiet street in a desirable neighborhood, this home combines modern style with everyday convenience. The main floor features soaring 9-foot ceilings, sleek laminate flooring, and an open-concept design filled with natural light. The contemporary kitchen boasts a spacious island with breakfast bar, ample cabinetry, and a walk-in pantry - perfect for both cooking and entertaining. A laundry/mudroom with direct garage access and a 2-piece bath complete this level. Upstairs, the spacious primary suite offers a walk-in closet and a 4-piece ensuite with soaker tub, walk-in shower, and bright vanity. Two additional bedrooms and another full bathroom provide plenty of space for family or guests. ideally situated in the highly desirable Trails Edge community in Kingston. Ideally situated in the highly desirable Trails Edge community in Kingston, close to all amenities. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-29T17:27:24.942290+00:00"
+"Directions": "Cross Streets: Andersen Dr and Cataraqui Woods Dr. ** Directions: Cataraqui Woods Dr or Princess St Andersen Dr to max Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006130"
+"ListOfficeKey": "285264"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "25.6 x 118 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T21:21:09Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-29T21:21:09Z"
+"Stories": "2.0"
+"StreetName": "Max"
+"StreetNumber": "1201"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4787.14"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Kingston"
+"TaxYear": 2025
+"CityRegion": "42 - City Northwest"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29824916/1201-max-crescent-kingston-city-northwest-42-city-northwest"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 25.7
+"OriginalEntryTimestamp": "2026-05-29T16:51:28.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1288440"
+"ListOfficeNationalAssociationId": "1349581"
+"Media": array:31 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
]
+"DaysOnMarket": 23
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29824916')"
+"ID": "1475542"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25339
+post_id: "1466182"
+post_author: 1
+"ListingKey": "29812367"
+"ListingId": "X13193466"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T18:00:07Z"
+"RFModificationTimestamp": "2026-06-10T18:03:47Z"
+"ListPrice": 879900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 3
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City North of 401)"
+"PostalCode": "K7L4V4"
+"UnparsedAddress": "1380 SUNNYSIDE ROAD, Kingston (City North of 401), Ontario K7L4V4"
+"Coordinates": array:2 [
0 => -76.529644
1 => 44.28023
]
+"Latitude": 44.28023
+"Longitude": -76.529644
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Set on a stunning private lot backing onto the picturesque Little Cataraqui Creek Conservation Area, this beautifully maintained bungalow offers the perfect balance of peaceful country living and unbeatable city convenience. Nestled on a quiet paved road surrounded by mature trees and nature, this exceptional property feels like a private retreat while being just minutes from Highway 401, downtown Kingston, shopping, restaurants, and everyday amenities. Rarely does a property offer this level of privacy, natural beauty, and accessibility all within city limits. Designed with both comfort and functionality in mind, the spacious home features 3 bedrooms, 4 bathrooms, and a flexible main-floor office that could easily serve as a guest bedroom or additional living space. The primary suite offers a peaceful escape complete with a walk-in closet and private ensuite bath. The bright, inviting layout is ideal for family living and entertaining alike. A grand living room with rustic wood beams and a cozy gas fireplace creates a warm and welcoming atmosphere, while the adjoining three-season sunroom provides the perfect place to relax and take in breath taking views of the landscaped gardens, tranquil ponds, forest, and surrounding wildlife. Downstairs, the fully finished lower level adds exceptional versatility with a large rec room, additional bathroom, bonus living areas, and excellent in-law or guest suite potential thanks to a separate entrance. Pride of ownership is evident throughout, with meticulous maintenance and thoughtful updates completed over the years. Additional highlights include municipal water, natural gas heating, an attached two-car garage, ample parking, and beautifully maintained grounds with no rear or side neighbours for added privacy. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Garage door opener remote(s)"
6 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"BathroomsPartial": 3
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-27T19:07:59.952570+00:00"
+"Directions": "Cross Streets: Sydenham & Sunnyside. ** Directions: North on Sydenham Rd to Sunnyside Rd. Turn right. or 401 to Sydenham Rd - North to first right turn."
+"ExteriorFeatures": array:2 [
0 => "Steel"
1 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1970470"
+"ListOfficeKey": "55447"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:6 [
0 => "Wooded area"
1 => "Rolling"
2 => "Partially cleared"
3 => "Backs on greenbelt"
4 => "Conservation/green belt"
5 => "Sump Pump"
]
+"LotSizeDimensions": "93 x 771 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-05-27T16:51:38Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-10T17:52:01Z"
+"Stories": "1.0"
+"StreetName": "Sunnyside"
+"StreetNumber": "1380"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5940"
+"Utilities": array:1 [
0 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/1380_sunnyside_rd_kingston_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Kingston"
+"TaxYear": 2025
+"CityRegion": "44 - City North of 401"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29812367/1380-sunnyside-road-kingston-city-north-of-401-44-city-north-of-401"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "Hamlet"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 93.0
+"OriginalEntryTimestamp": "2026-05-27T16:51:38.53Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1257788"
+"ListOfficeNationalAssociationId": "1003869"
+"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": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29812367')"
+"ID": "1466182"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25337
+post_id: "1440281"
+post_author: 1
+"ListingKey": "29776977"
+"ListingId": "X13149464"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:00:03Z"
+"RFModificationTimestamp": "2026-06-16T14:03:01Z"
+"ListPrice": 839900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City Northwest)"
+"PostalCode": "K7P0H9"
+"UnparsedAddress": "2772 DELMAR STREET, Kingston (City Northwest), Ontario K7P0H9"
+"Coordinates": array:2 [
0 => -76.551093
1 => 44.269317
]
+"Latitude": 44.269317
+"Longitude": -76.551093
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Welcome to Sands Edge! This stunning 3-year-old home offers the perfect blend of modern style, thoughtful upgrades, and functional family living - completely finished top to bottom, including a basement bathroom to be completed prior to closing. The bright open-concept main floor is designed for both everyday living and entertaining, featuring quartz countertops, tile backsplash, beautiful mouldings and trim work, custom light fixtures, and a cozy gas fireplace that anchors the living space. The kitchen, dining, and living areas flow seamlessly together, creating an inviting atmosphere filled with natural light. Offering 4 bedrooms plus a den/office and 3 full bathrooms, including a gorgeous ensuite, this home provides flexibility and space for growing families, guests, or those working from home. The fully finished lower level adds even more living space with a spacious rec room and stylish wet bar - perfect for entertaining or relaxing. Outside, enjoy impressive curb appeal with a paved driveway with curbs, landscaped gardens, and a well-maintained exterior in one of the area's most family-friendly communities. This isa true turnkey opportunity with quality finishes and attention to detail throughout. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Blinds"
6 => "Garage door opener remote(s)"
7 => "Water Heater - Tankless"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-20T19:46:41.533464+00:00"
+"Directions": "Cross Streets: Delmar and Celeste. ** Directions: Celeste to Delmar."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1890793"
+"ListOfficeKey": "277109"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Level lot"
]
+"LotSizeDimensions": "40 x 101.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-20T16:42:50Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T13:51:02Z"
+"Stories": "1.0"
+"StreetName": "Delmar"
+"StreetNumber": "2772"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5319"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/2772_delmar_st_kingston_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Kingston"
+"CityRegion": "42 - City Northwest"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29776977/2772-delmar-street-kingston-city-northwest-42-city-northwest"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 40.0
+"OriginalEntryTimestamp": "2026-05-20T16:42:50.18Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1211410"
+"ListOfficeNationalAssociationId": "1306303"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 32
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29776977')"
+"ID": "1440281"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25332
+post_id: "1438789"
+post_author: 1
+"ListingKey": "29775716"
+"ListingId": "X13148362"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T11:55:06Z"
+"RFModificationTimestamp": "2026-06-15T11:59:26Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City North of 401)"
+"PostalCode": "K7L4V4"
+"UnparsedAddress": "2112 BURBROOK ROAD, Kingston (City North of 401), Ontario K7L4V4"
+"Coordinates": array:2 [
0 => -76.53983
1 => 44.300163
]
+"Latitude": 44.300163
+"Longitude": -76.53983
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Just minutes North of Kingston, this meticulously maintained family home offers the perfect blend of space, comfort, and functionality. The heart of the home is the updated kitchen, complete with abundant counter space, rich cabinetry, and modern appliances that make both everyday cooking and entertaining effortless. A spacious dining area provides the ideal setting for large family gatherings and special occasions. Adjacent to the kitchen, the bright and welcoming living room offers an inviting atmosphere with its open layout, electric fireplace, hardwood floors and natural light-filled space - perfect for relaxing or hosting guests. One full three-piece bathroom completes the main level. Second floor features three generously sized bedrooms and two beautifully updated bathrooms, one including a soaker tub in the primary bedroom and second floor laundry. The fully finished lower level adds exceptional versatility with a large rec room that can easily serve as a playroom, media lounge, home gym, or entertainment space, adding even more functionality to this already impressive home. Outside, the beautifully landscaped backyard is complemented by a spacious two car garage, multiple storage sheds, dual driveways, and extensive parking options to comfortably accommodate family and visitors alike along with three decks around the front, side and backyard with a beautiful gazebo to relax in at the end of the day. Ideally located just outside Kingston, this exceptional property combines modern updates with practical family living, creating a wonderful place to call home. (id:62783)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Freezer"
9 => "Window Coverings"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-20T16:30:51.667402+00:00"
+"Directions": "Cross Streets: Sydenham Road and Burbrook Road. ** Directions: North of Kingston on the northeast corner of Sydenham Road and Burbrook Road."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Partially fenced"
1 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Forced air"
2 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1526877"
+"ListOfficeKey": "55459"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Lighting"
1 => "Carpet Free"
2 => "Gazebo"
3 => "Sump Pump"
]
+"LotSizeDimensions": "129.6 x 160 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-05-20T14:42:22Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T11:40:26Z"
+"Stories": "2.0"
+"StreetName": "Burbrook"
+"StreetNumber": "2112"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5304.26"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/349542"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Kingston"
+"CityRegion": "44 - City North of 401"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29775716/2112-burbrook-road-kingston-city-north-of-401-44-city-north-of-401"
+"ParkingTotal": 11
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1526121"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2173820"
+"CoListOfficeKey": "55459"
+"GeocodeManualYN": false
+"BuildingFeatures": array:3 [
0 => "Separate Electricity Meters"
1 => "Separate Heating Controls"
2 => "Fireplace(s)"
]
+"CoListOfficeKey2": "55459"
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 129.7
+"OriginalEntryTimestamp": "2026-05-20T14:42:22.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1139332"
+"ListOfficeNationalAssociationId": "1003853"
+"CoListAgentNationalAssociationId": "1138853"
+"CoListAgentNationalAssociationId2": "1424197"
+"CoListOfficeNationalAssociationId": "1003853"
+"CoListOfficeNationalAssociationId2": "1003853"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 32
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29775716')"
+"ID": "1438789"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23420
+post_id: "1436395"
+post_author: 1
+"ListingKey": "29769415"
+"ListingId": "X13143006"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T11:55:06Z"
+"RFModificationTimestamp": "2026-06-15T11:59:26Z"
+"ListPrice": 839999.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City Northwest)"
+"PostalCode": "K7P0P5"
+"UnparsedAddress": "1369 ANDERSEN DRIVE, Kingston (City Northwest), Ontario K7P0P5"
+"Coordinates": array:2 [
0 => -76.5492987
1 => 44.2681134
]
+"Latitude": 44.2681134
+"Longitude": -76.5492987
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "WOW! EXECUTIVE STYLE FAMILY HOME PRICED TO SELL QUICKLY. Conveniently located in Kingston's growing Trails Edge subdivision, this nearly new Caraco Parkridge model offers 2,600 sq/ft, 4 bedrooms, 3 baths and a family friendly open concept design. Bright and spacious with an impressive list of features like hardwood and ceramic tile flooring, 9 ft ceilings, C/Air, family room fireplace and more. A formal living room welcomes family and friends upon entry and flows beautifully into the open family room, dining area, and kitchen, creating a "great room style" family space. Preparing meals is easy and fun in the upgraded kitchen, which features a center island, quartz countertops, and huge walk-in pantry. Main floor laundry, bathroom and access to the double garage complete the main floor. The upper level offers 4 spacious bedrooms and 2 full baths (with quartz countertops), including a large primary suite with a walk-in closet and a luxurious ensuite bath featuring ceramic tile floors, a soaker tub, and a separate tiled shower. The fully insulated lower level is ready for your finishing and houses the high-efficiency furnace, HRV, on-demand hot water and a bathroom rough-in. Benefits of this "nearly new" property include landscaping, paved driveway, stamped concrete walk-way, fencing, deck with a hardtop gazebo and underneath covered storage, window blinds/dressings, garage door equipment, and more. Watch the children play in the park across the street from the spacious covered front deck. On a school and public bus routes and so easy to the 401 and downtown, this home offers and spacious and features you deserve. Two remaining years on the Tarion New Home Warranty. Welcome Home! (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Freezer"
6 => "Garage door opener remote(s)"
7 => "Water Heater - Tankless"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-19T16:58:23.677459+00:00"
+"Directions": "Cross Streets: Andersen Drive and Cataraqui Woods Drive. ** Directions: Sydenham Road to Cataraqui Woods Drive to Andersen Drive."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1453868"
+"ListOfficeKey": "55458"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Lighting"
1 => "Level"
]
+"LotSizeDimensions": "38.1 x 108.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-19T17:58:16Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T11:40:24Z"
+"Stories": "2.0"
+"StreetName": "Andersen"
+"StreetNumber": "1369"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7003"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youtu.be/grfJYjoxv4A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Kingston"
+"CityRegion": "42 - City Northwest"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29769415/1369-andersen-drive-kingston-city-northwest-42-city-northwest"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2038286"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55458"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"ZoningDescription": "LDR"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 38.1
+"OriginalEntryTimestamp": "2026-05-19T15:41:30.9Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1065620"
+"ListOfficeNationalAssociationId": "1003863"
+"CoListAgentNationalAssociationId": "1314484"
+"CoListOfficeNationalAssociationId": "1003863"
+"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": 33
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29769415')"
+"ID": "1436395"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25340
+post_id: "1430098"
+post_author: 1
+"ListingKey": "29762865"
+"ListingId": "X13137336"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-28T14:25:23Z"
+"RFModificationTimestamp": "2026-05-28T14:31:03Z"
+"ListPrice": 1350000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City North of 401)"
+"PostalCode": "K7L4V4"
+"UnparsedAddress": "1863 SYDENHAM ROAD, Kingston (City North of 401), Ontario K7L4V4"
+"Coordinates": array:2 [
0 => -76.5404657
1 => 44.3001283
]
+"Latitude": 44.3001283
+"Longitude": -76.5404657
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Rarely does a property offer such a unique blend of historic charm, spacious living, and flexible commercial opportunity. Thoughtfully updated while preserving its original charm, the home features wide plank pine floors, exposed limestone, multiple fireplaces, slate countertops, built-in storage, and bright, inviting spaces throughout. The private, fully fenced backyard includes perennial gardens and a screened-in porch perfect for entertaining. Upstairs offers three spacious bedrooms, including a stunning primary suite, plus a third-floor loft with exposed limestone walls and BC fir beams. The dedicated commercial space, complete with separate heating and cooling, meeting room, and two-second floor offices, offers endless potential for professional offices, studios, creative work spaces, or home-based businesses - or convert into many other possibilities! See commercial listing - X13137346 (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Range"
7 => "Oven"
8 => "Dryer"
9 => "Freezer"
10 => "Oven - Built-In"
11 => "Water Treatment"
12 => "Window Coverings"
]
+"Basement": array:3 [
0 => "Unfinished"
1 => "Full"
2 => "N/A"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"CreationDate": "2026-05-16T01:00:03.851315+00:00"
+"Directions": "Cross Streets: Sydenham Road & Burbrook Road. ** Directions: Property is located on the corner of Sydenham Road & Burbrook Road."
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "4"
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2200289"
+"ListOfficeKey": "55459"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Level lot"
1 => "Flat site"
2 => "Wheelchair access"
3 => "Carpet Free"
4 => "Sump Pump"
]
+"LotSizeDimensions": "110.4 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T14:18:12Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-28T14:18:12Z"
+"Stories": "2.5"
+"StreetName": "Sydenham"
+"StreetNumber": "1863"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5935.38"
+"Utilities": array:2 [
0 => "Electricity"
1 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/1863_sydenham_rd_kingston_on/"
+"WaterSource": array:1 [
0 => "Artesian Well"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Kingston"
+"CityRegion": "44 - City North of 401"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29762865/1863-sydenham-road-kingston-city-north-of-401-44-city-north-of-401"
+"ParkingTotal": 9
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1527394"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "55459"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 100000
+"LivingAreaMinimum": 5000
+"ZoningDescription": "C2-7"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 110.4
+"OriginalEntryTimestamp": "2026-05-15T23:21:24.9Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1449226"
+"ListOfficeNationalAssociationId": "1003853"
+"CoListAgentNationalAssociationId": "1139663"
+"CoListOfficeNationalAssociationId": "1003853"
+"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": 36
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29762865')"
+"ID": "1430098"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25341
+post_id: "1423207"
+post_author: 1
+"ListingKey": "29753605"
+"ListingId": "X13129128"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T11:50:13Z"
+"RFModificationTimestamp": "2026-06-14T11:53:39Z"
+"ListPrice": 1875000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Kingston (City North of 401)"
+"PostalCode": "K7L4V4"
+"UnparsedAddress": "1800 SYDENHAM ROAD, Kingston (City North of 401), Ontario K7L4V4"
+"Coordinates": array:2 [
0 => -76.539454
1 => 44.2968375
]
+"Latitude": 44.2968375
+"Longitude": -76.539454
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Kingston & Area Real Estate Association"
+"PublicRemarks": "Experience true exclusivity with this one-of-a-kind, custom-designed estate just minutes from Hwy. 401 on Sydenham Road. Thoughtfully crafted with exceptional attention to detail, this impressive home showcases elegant architectural design and luxurious finishes throughout. The kitchen is a chef's dream with gorgeous granite countertops and stunning custom cabinets. Overlooking the family room makes this open space great for entertaining family and friends. Then you will love stepping into the screened-in porch overlooking the deer grazing in the woods. Upstairs, you will find a great separate area that could be for the kids or even used as a secondary living area with 2 more bedrooms, a living room and an ensuite bathroom. Set on just under 10 acres of beautifully treed land, the property offers outstanding privacy and a peaceful natural setting. Adding to its appeal is an extraordinary 4,800 sq/ft two-storey shop with potential for two separate suites (separate septic already installed), ideal for a home-based business, hobbyist, extended family, or additional income opportunities. This remarkable property is designed for the discerning buyer seeking luxury, privacy, and endless possibilities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Garage door opener remote(s)"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-14T19:15:51.395457+00:00"
+"Directions": "Sydenham Road North to 1800, turn right."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Brick"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:4 [
0 => "Radiant heat"
1 => "Forced air"
2 => "Natural gas"
3 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1454298"
+"ListOfficeKey": "284755"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Lighting"
]
+"LotSizeDimensions": "293.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-14T18:32:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T11:40:25Z"
+"Stories": "2.0"
+"StreetName": "SYDENHAM"
+"StreetNumber": "1800"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "9766"
+"Utilities": array:1 [
0 => "Electricity"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/qrwdj_1800_sydenham_rd_kingston_on/"
+"WaterSource": array:1 [
0 => "Drilled Well"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Kingston"
+"TaxYear": 2025
+"CityRegion": "44 - City North of 401"
+"ListAORKey": "37"
+"ListingURL": "www.realtor.ca/real-estate/29753605/1800-sydenham-road-kingston-city-north-of-401-44-city-north-of-401"
+"ParkingTotal": 14
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "A1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 293.1
+"OriginalEntryTimestamp": "2026-05-14T18:32:20.55Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1120174"
+"ListOfficeNationalAssociationId": "1344368"
+"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": 38
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29753605')"
+"ID": "1423207"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 19
+after_key: ""
}
"RF Response Time" => "0.2 seconds"
]
]