array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29654538 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1353925"
+post_author: 1
+"ListingKey": "29654538"
+"ListingId": "X13042270"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T12:05:10Z"
+"RFModificationTimestamp": "2026-06-01T18:31:00Z"
+"ListPrice": 999000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Town)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "561 KING STREET, Niagara-on-the-Lake (Town), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.0788134
1 => 43.2468956
]
+"Latitude": 43.2468956
+"Longitude": -79.0788134
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "This ideally situated back-split is located on a corner lot in Old Town Niagara-on-the-Lake, a short stroll to iconic Queen Street, local shops and amenities. With a newly updated principal ensuite featuring a soaker tub and premium fixtures, and 2 generous bedrooms up, and an additional guest bath this home suits many family configurations. The lower level offers a family room with fireplace, and a seperate entrance to the rear yard. An additional 4 piece bathroom completes the functionality, and rear facing windows make the space bright and full of opportunity. A single car garage, mature trees and an expansive deck make this centrally located home a perfect candidate for your next transition. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
]
+"Basement": array:6 [
0 => "Partially finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-04-24T20:58:41.640349+00:00"
+"Directions": "Cross Streets: Anne Street. ** Directions: Located at corner of Anne and King."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Partially fenced"
]
+"FireplaceFeatures": array:1 [
0 => "Insert"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2006774"
+"ListOfficeKey": "272269"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "100 x 120 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-24T19:26:50Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-01T11:58:04Z"
+"StreetName": "King"
+"StreetNumber": "561"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5464"
+"Utilities": array:3 [
0 => "Sewer"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://www.myvisuallistings.com/vt/363089"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1648447257"
"RoomType" => "Living room"
"ListingId" => "X13042270"
"RoomLevel" => "Ground level"
"RoomWidth" => 3.84
"ListingKey" => "29654538"
"RoomLength" => 5.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.08Z"
]
1 => array:11 [
"RoomKey" => "1648447258"
"RoomType" => "Furnace"
"ListingId" => "X13042270"
"RoomLevel" => "Basement"
"RoomWidth" => 2.84
"ListingKey" => "29654538"
"RoomLength" => 7.19
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.08Z"
]
2 => array:11 [
"RoomKey" => "1648447259"
"RoomType" => "Cold room"
"ListingId" => "X13042270"
"RoomLevel" => "Basement"
"RoomWidth" => 2.89
"ListingKey" => "29654538"
"RoomLength" => 2.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.08Z"
]
3 => array:11 [
"RoomKey" => "1648447260"
"RoomType" => "Other"
"ListingId" => "X13042270"
"RoomLevel" => "Basement"
"RoomWidth" => 1.83
"ListingKey" => "29654538"
"RoomLength" => 1.46
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.08Z"
]
4 => array:11 [
"RoomKey" => "1648447261"
"RoomType" => "Dining room"
"ListingId" => "X13042270"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.49
"ListingKey" => "29654538"
"RoomLength" => 2.47
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.08Z"
]
5 => array:11 [
"RoomKey" => "1648447262"
"RoomType" => "Kitchen"
"ListingId" => "X13042270"
"RoomLevel" => "Ground level"
"RoomWidth" => 2.7
"ListingKey" => "29654538"
"RoomLength" => 4.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.08Z"
]
6 => array:11 [
"RoomKey" => "1648447263"
"RoomType" => "Family room"
"ListingId" => "X13042270"
"RoomLevel" => "Lower level"
"RoomWidth" => 4.5
"ListingKey" => "29654538"
"RoomLength" => 9.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.08Z"
]
7 => array:11 [
"RoomKey" => "1648447264"
"RoomType" => "Bathroom"
"ListingId" => "X13042270"
"RoomLevel" => "Lower level"
"RoomWidth" => 1.37
"ListingKey" => "29654538"
"RoomLength" => 2.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.08Z"
]
8 => array:11 [
"RoomKey" => "1648447265"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13042270"
"RoomLevel" => "Second level"
"RoomWidth" => 3.53
"ListingKey" => "29654538"
"RoomLength" => 3.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.08Z"
]
9 => array:11 [
"RoomKey" => "1648447266"
"RoomType" => "Bathroom"
"ListingId" => "X13042270"
"RoomLevel" => "Second level"
"RoomWidth" => 3.1
"ListingKey" => "29654538"
"RoomLength" => 3.87
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.09Z"
]
10 => array:11 [
"RoomKey" => "1648447267"
"RoomType" => "Bedroom 2"
"ListingId" => "X13042270"
"RoomLevel" => "Second level"
"RoomWidth" => 3.0
"ListingKey" => "29654538"
"RoomLength" => 4.6
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.09Z"
]
11 => array:11 [
"RoomKey" => "1648447268"
"RoomType" => "Bathroom"
"ListingId" => "X13042270"
"RoomLevel" => "Second level"
"RoomWidth" => 1.4
"ListingKey" => "29654538"
"RoomLength" => 2.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.09Z"
]
12 => array:11 [
"RoomKey" => "1648447269"
"RoomType" => "Laundry room"
"ListingId" => "X13042270"
"RoomLevel" => "Basement"
"RoomWidth" => 3.72
"ListingKey" => "29654538"
"RoomLength" => 5.82
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-01T11:58:04.09Z"
]
]
+"ListAOR": "Niagara"
+"TaxYear": 2026
+"CityRegion": "101 - Town"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29654538/561-king-street-niagara-on-the-lake-town-101-town"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2141442"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "272269"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"FrontageLengthNumeric": 100.0
+"OriginalEntryTimestamp": "2026-04-24T19:26:50.32Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1288967"
+"ListOfficeNationalAssociationId": "1243338"
+"CoListAgentNationalAssociationId": "1393125"
+"CoListOfficeNationalAssociationId": "1243338"
+"Media": array:36 [
0 => array:13 [
"Order" => 1
"MediaKey" => "6625435463"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/0b2eacc506dd2b790fe9f25d8cf5199e.webp"
"MediaSize" => 521228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-0b2eacc506dd2b790fe9f25d8cf5199e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "6625435591"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/763cfa420a604589bfc5b68415038927.webp"
"MediaSize" => 495670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-763cfa420a604589bfc5b68415038927.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "6625435595"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/e1d2c9102e8201cb15cb68365989471a.webp"
"MediaSize" => 178283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-e1d2c9102e8201cb15cb68365989471a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "6625435635"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/7d82ba3309af96612c1303a4b1a5a307.webp"
"MediaSize" => 209426
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-7d82ba3309af96612c1303a4b1a5a307.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "6625435714"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/8952a0e2c26dfb001dba9ca63c1345ab.webp"
"MediaSize" => 210480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-8952a0e2c26dfb001dba9ca63c1345ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "6625435792"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/f05498f2d9abba7affd4900dcf7f8b75.webp"
"MediaSize" => 203965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-f05498f2d9abba7affd4900dcf7f8b75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "6625435804"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/0a19423eed1f805253b6abdbc6117652.webp"
"MediaSize" => 234901
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-0a19423eed1f805253b6abdbc6117652.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "6625435825"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/60ffd43b05e05d28bd43aa23297fe2d1.webp"
"MediaSize" => 225002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-60ffd43b05e05d28bd43aa23297fe2d1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "6625435869"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/cee94a50111cfe61e88390b9c233d6ad.webp"
"MediaSize" => 199091
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-cee94a50111cfe61e88390b9c233d6ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "6625435955"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/c4c0c29e817bea8991bea2913a8839da.webp"
"MediaSize" => 238141
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-c4c0c29e817bea8991bea2913a8839da.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "6625435987"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/17810f8c3c468a58f703ed8a53bc7299.webp"
"MediaSize" => 237786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-17810f8c3c468a58f703ed8a53bc7299.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "6625436067"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/29943181d3fa467397a2faa3dddbe335.webp"
"MediaSize" => 157663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-29943181d3fa467397a2faa3dddbe335.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "6625436084"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/ff47c5cca20c235286add577cfb7f86e.webp"
"MediaSize" => 141598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-ff47c5cca20c235286add577cfb7f86e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "6625436132"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/8b478c5f56f5a4ac77439f549eb7cdef.webp"
"MediaSize" => 163696
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-8b478c5f56f5a4ac77439f549eb7cdef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "6625436146"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/43b5ed0bdcf9dc05e976badf3fed1542.webp"
"MediaSize" => 149980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-43b5ed0bdcf9dc05e976badf3fed1542.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "6625436204"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/f3505d6242251863b2bfdeaa4bc91b02.webp"
"MediaSize" => 241341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-f3505d6242251863b2bfdeaa4bc91b02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "6625436247"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/1cad0942f820070a4a42eeb054f5d151.webp"
"MediaSize" => 226097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-1cad0942f820070a4a42eeb054f5d151.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "6625436265"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/7274d5a036387f6fdfb17e498674f740.webp"
"MediaSize" => 229994
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-7274d5a036387f6fdfb17e498674f740.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "6625436322"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/a0ed3807c88180246a363bcae8f9dbbb.webp"
"MediaSize" => 186401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-a0ed3807c88180246a363bcae8f9dbbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "6625436360"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/70fdeff9aa1885b35fe6215dae948af5.webp"
"MediaSize" => 189229
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-70fdeff9aa1885b35fe6215dae948af5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "6625436429"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/c8f22e7181af6d09e8657f3a4fc014b7.webp"
"MediaSize" => 194817
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-c8f22e7181af6d09e8657f3a4fc014b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "6625436467"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/922fcf873a1d67888314416132ca513b.webp"
"MediaSize" => 172762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-922fcf873a1d67888314416132ca513b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "6625436517"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/a53ce79da155082e1475275a467813db.webp"
"MediaSize" => 208314
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-a53ce79da155082e1475275a467813db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "6625436549"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/5086a13b5f062ae491344b3dd28c2c4a.webp"
"MediaSize" => 197959
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-5086a13b5f062ae491344b3dd28c2c4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "6625436557"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/fbf668235f9ebe2286881709f4d58c2f.webp"
"MediaSize" => 159249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-fbf668235f9ebe2286881709f4d58c2f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "6625436592"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/c248823f0517f49054531829d7afe32c.webp"
"MediaSize" => 182623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-c248823f0517f49054531829d7afe32c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "6625436643"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/73e42cf7be456d53c402f13ebc236cb7.webp"
"MediaSize" => 109786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-73e42cf7be456d53c402f13ebc236cb7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "6625436702"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/6f27585676d9c8efa7b4e4c1a8ebca3b.webp"
"MediaSize" => 587873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-6f27585676d9c8efa7b4e4c1a8ebca3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "6625436741"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/48298f976dae460c945d7cb21e8fab86.webp"
"MediaSize" => 417322
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-48298f976dae460c945d7cb21e8fab86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "6625436769"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/b65e38022929944a01a181c20c50dd8d.webp"
"MediaSize" => 560578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-b65e38022929944a01a181c20c50dd8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "6625436806"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/f951632372ab68e8b588f1529784b870.webp"
"MediaSize" => 572769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-f951632372ab68e8b588f1529784b870.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "6625436829"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/cf4bb6d69162a5d3c8339e925d7e7a9c.webp"
"MediaSize" => 521455
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-cf4bb6d69162a5d3c8339e925d7e7a9c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "6625436859"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/4dfd9a807eb61db2b90c4979032bb510.webp"
"MediaSize" => 389245
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-4dfd9a807eb61db2b90c4979032bb510.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "6625436867"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/7b0142e64bc1d013a0701d258653babc.webp"
"MediaSize" => 544244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-7b0142e64bc1d013a0701d258653babc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "6625436908"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/87b2031ab1b6722c80ddac26cdaee4bb.webp"
"MediaSize" => 600251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-87b2031ab1b6722c80ddac26cdaee4bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "6625436939"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29654538/4b16b309dbdf23f986938e6c30a9a650.webp"
"MediaSize" => 512721
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29654538/thumbnail-4b16b309dbdf23f986938e6c30a9a650.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13042270"
"ResourceRecordKey" => "29654538"
"ModificationTimestamp" => "2026-04-24T19:26:50.33Z"
]
]
+"DaysOnMarket": 51
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29654538')"
+"ID": "1353925"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.18 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 272269" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24799
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.17 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2006774" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24772
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29654538'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25109
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29654538'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25127
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25125
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31164913"
+"ListingKey": "29654538"
+"ListingId": "X13042270"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-01T02:55:18Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31164913')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29654538' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.0788134 43.2468956)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25180
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25174
+post_id: "1528532"
+post_author: 1
+"ListingKey": "29900530"
+"ListingId": "40839585"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T16:45:04Z"
+"RFModificationTimestamp": "2026-06-13T17:03:21Z"
+"ListPrice": 1650000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2930.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "8 CAMPBELL Street, Niagara-on-the-Lake, Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.0803381
1 => 43.2406658
]
+"Latitude": 43.2406658
+"Longitude": -79.0803381
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Tucked away on one of Niagara-on-the-Lake's best-kept secret streets, this luxury custom bungalow offers the perfect blend of quality craftsmanship, thoughtful design, and a stunning park-like backyard setting. With 4 bedrooms and 3 full bathrooms, this beautifully finished home provides exceptional space (nearly 3,000 sq.ft finished) for families, retirees, and those who love to entertain.Built in 2012 and showcasing timeless Hardie board and stone construction, the home features approximately 1,776 sq. ft. on the main level. The bright, open-concept design is highlighted by oversized windows, rich hardwood flooring, custom built-ins, abundant pot lighting, a welcoming gas fireplace, and tasteful neutral décor throughout.The main floor offers 2 spacious bedrooms and 2 full bathrooms, including a private primary suite with a 4-piece ensuite. The well-appointed kitchen features a centre island, bright dining area, and sliding doors leading to a covered porch overlooking the beautifully landscaped backyard. A convenient mudroom/laundry room with direct access to the attached double garage completes the level.The professionally finished lower level dramatically expands the living space with 2 additional bedrooms, a beautiful full bathroom, and a massive rec room perfect for family gatherings, guests, hobbies, or movie nights.Additional features include a water softener, sump pump with battery backup, and a rough-in ready for a future 200-amp electrical upgrade right to the panel.Outside, enjoy professional landscaping, walkways, sitting areas, and a generous backyard that feels like your own private retreat. Located just a short walk to Peller Estates and Two Sisters Vineyards, the waterfront trail, tennis courts, restaurants, theatres, shops, the library, community centre, and dog parks, with golf just minutes away.A rare opportunity to own a luxury custom bungalow on one of Niagara-on-the-Lake's quietest and most desirable hidden gem streets. (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T17:03:10.775109+00:00"
+"Directions": "NIAGARA - CHARLOTTE - CAMPBELL"
+"ExteriorFeatures": array:1 [
0 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738832"
+"ListOfficeKey": "299401"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-13T16:39:38Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T16:39:38Z"
+"Stories": "1.0"
+"StreetName": "CAMPBELL"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"SubdivisionName": "101 - Town"
+"TaxAnnualAmount": "7986.81"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/K0Fr9xsNCbs?si=6mdT8PMi8AQfxuWGhttps://youtube.com/shorts/K0Fr9xsNCbs?si=6mdT8PMi8AQfxuWG"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1658604992"
"RoomType" => "Storage"
"ListingId" => "40839585"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 7'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.29Z"
]
1 => array:11 [
"RoomKey" => "1658604993"
"RoomType" => "Storage"
"ListingId" => "40839585"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "13'1'' x 8'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.29Z"
]
2 => array:11 [
"RoomKey" => "1658604994"
"RoomType" => "Storage"
"ListingId" => "40839585"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.29Z"
]
3 => array:11 [
"RoomKey" => "1658604995"
"RoomType" => "3pc Bathroom"
"ListingId" => "40839585"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.29Z"
]
4 => array:11 [
"RoomKey" => "1658604996"
"RoomType" => "Bedroom"
"ListingId" => "40839585"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.29Z"
]
5 => array:11 [
"RoomKey" => "1658604997"
"RoomType" => "Bedroom"
"ListingId" => "40839585"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "17'2'' x 13'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.29Z"
]
6 => array:11 [
"RoomKey" => "1658604998"
"RoomType" => "Other"
"ListingId" => "40839585"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "29'2'' x 23'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.29Z"
]
7 => array:11 [
"RoomKey" => "1658604999"
"RoomType" => "4pc Bathroom"
"ListingId" => "40839585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.29Z"
]
8 => array:11 [
"RoomKey" => "1658605000"
"RoomType" => "Laundry room"
"ListingId" => "40839585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.3Z"
]
9 => array:11 [
"RoomKey" => "1658605001"
"RoomType" => "Bedroom"
"ListingId" => "40839585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "18'11'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.3Z"
]
10 => array:11 [
"RoomKey" => "1658605002"
"RoomType" => "Full bathroom"
"ListingId" => "40839585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.3Z"
]
11 => array:11 [
"RoomKey" => "1658605003"
"RoomType" => "Primary Bedroom"
"ListingId" => "40839585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "26'6'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.3Z"
]
12 => array:11 [
"RoomKey" => "1658605004"
"RoomType" => "Kitchen"
"ListingId" => "40839585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.3Z"
]
13 => array:11 [
"RoomKey" => "1658605005"
"RoomType" => "Dining room"
"ListingId" => "40839585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "14'6'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.3Z"
]
14 => array:11 [
"RoomKey" => "1658605006"
"RoomType" => "Living room"
"ListingId" => "40839585"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29900530"
"RoomLength" => null
"RoomDimensions" => "22'11'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-13T16:39:38.31Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29900530/8-campbell-street-niagara-on-the-lake"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 64.0
+"AboveGradeFinishedArea": 1737
+"BelowGradeFinishedArea": 1193
+"OriginalEntryTimestamp": "2026-06-13T16:39:38.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1178468"
+"ListOfficeNationalAssociationId": "1472476"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29900530_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29900530/00b3b0281920b8400086b337e69173b1.webp"
"MediaSize" => 184318
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29900530/thumbnail-00b3b0281920b8400086b337e69173b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40839585"
"ResourceRecordKey" => "29900530"
"ModificationTimestamp" => "2026-06-13T16:39:38.15Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29900530_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29900530/e989418c46918269c85db1d6cffaa729.webp"
"MediaSize" => 181298
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29900530/thumbnail-e989418c46918269c85db1d6cffaa729.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Virtually Landscaped"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839585"
"ResourceRecordKey" => "29900530"
"ModificationTimestamp" => "2026-06-13T16:39:38.15Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29900530_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29900530/00737632113d87ccde0d57f629c8ad04.webp"
"MediaSize" => 195526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29900530/thumbnail-00737632113d87ccde0d57f629c8ad04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839585"
"ResourceRecordKey" => "29900530"
"ModificationTimestamp" => "2026-06-13T16:39:38.15Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29900530_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29900530/e8c518a4e59f991d4a2b92ee8901dee5.webp"
"MediaSize" => 185267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29900530/thumbnail-e8c518a4e59f991d4a2b92ee8901dee5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40839585"
"ResourceRecordKey" => "29900530"
"ModificationTimestamp" => "2026-06-13T16:39:38.15Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29900530_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29900530/12ed102d7100b500292faf847c29e6a9.webp"
"MediaSize" => 247974
"MediaType" => "webp"
…8
]
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29900530')"
+"ID": "1528532"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25176
+post_id: "1525756"
+post_author: 1
+"ListingKey": "29898595"
+"ListingId": "X13440176"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T17:30:10Z"
+"RFModificationTimestamp": "2026-06-13T17:30:41Z"
+"ListPrice": 1650000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Town)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "8 CAMPBELL STREET, Niagara-on-the-Lake (Town), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.08008
1 => 43.240818
]
+"Latitude": 43.240818
+"Longitude": -79.08008
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Tucked away on one of Niagara-on-the-Lake's best-kept secret streets, this luxury custom bungalow offers the perfect blend of quality craftsmanship, thoughtful design, and a stunning park-like backyard setting. With 4 bedrooms and 3 full bathrooms, this beautifully finished home provides exceptional space (nearly 3,000 sq.ft finished) for families, retirees, and those who love to entertain.Built in 2012 and showcasing timeless Hardie board and stone construction, the home features approximately 1,776 sq. ft. on the main level. The bright, open-concept design is highlighted by oversized windows, rich hardwood flooring, custom built-ins, abundant pot lighting, a welcoming gas fireplace, and tasteful neutral décor throughout.The main floor offers 2 spacious bedrooms and 2 full bathrooms, including a private primary suite with a 4-piece ensuite. The well-appointed kitchen features a centre island, bright dining area, and sliding doors leading to a covered porch overlooking the beautifully landscaped backyard. A convenient mudroom/laundry room with direct access to the attached double garage completes the level.The professionally finished lower level dramatically expands the living space with 2 additional bedrooms, a beautiful full bathroom, and a massive rec room perfect for family gatherings, guests, hobbies, or movie nights.Additional features include a water softener, sump pump with battery backup, and a rough-in ready for a future 200-amp electrical upgrade right to the panel.Outside, enjoy professional landscaping, walkways, sitting areas, and a generous backyard that feels like your own private retreat. Located just a short walk to Peller Estates and Two Sisters Vineyards, the waterfront trail, tennis courts, restaurants, theatres, shops, the library, community centre, and dog parks, with golf just minutes away.A rare opportunity to own a luxury custom bungalow on one of Niagara-on-the-Lake's quietest and most desirable hidden gem streets. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T23:40:23.692231+00:00"
+"Directions": "Cross Streets: NIAGARA & CHARLOTTE. ** Directions: NIAGARA - CHARLOTTE - CAMPBELL."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stone"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738832"
+"ListOfficeKey": "283840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Irregular lot size"
1 => "Sump Pump"
]
+"LotSizeDimensions": "64 x 174.3 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T23:21:41Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T16:56:51Z"
+"Stories": "1.0"
+"StreetName": "CAMPBELL"
+"StreetNumber": "8"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7986.81"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/K0Fr9xsNCbs?si=6mdT8PMi8AQfxuWGhttps://youtube.com/shorts/K0Fr9xsNCbs?si=6mdT8PMi8AQfxuWG"
+"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": "Niagara"
+"CityRegion": "101 - Town"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29898595/8-campbell-street-niagara-on-the-lake-town-101-town"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 64.0
+"OriginalEntryTimestamp": "2026-06-12T21:57:06.56Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1178468"
+"ListOfficeNationalAssociationId": "1335712"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898595')"
+"ID": "1525756"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25173
+post_id: "1525317"
+post_author: 1
+"ListingKey": "29898151"
+"ListingId": "40839505"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T20:45:06Z"
+"RFModificationTimestamp": "2026-06-13T20:48:50Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 1899.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "27 OAK Drive, Niagara-on-the-Lake, Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.0917601
1 => 43.257435
]
+"Latitude": 43.257435
+"Longitude": -79.0917601
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to a truly special home in one of Niagara-on-the-Lake's most desirable locations. Set on a jumbo, uniquely shaped lot directly across from a park and just a short stroll to the waterfront, you'll enjoy evening walks to the water's edge to take in some of the most breathtaking sunsets Niagara has to offer.From the moment you arrive, the home's stunning curb appeal makes a lasting impression. The beautifully landscaped grounds and private garden create a charming European-inspired atmosphere that feels both peaceful and timeless. Perfectly positioned on its expansive lot, this property offers a rare combination of privacy, character, and location.Inside, you'll find a home that has been lovingly maintained by its original owner since the day it was built. Quality craftsmanship and thoughtful updates completed over the years provide a solid foundation while still offering the opportunity to customize and modernize to suit your own vision and lifestyle.Additional features include a large garage and a separate entrance to the lower level, creating exciting potential for an in-law suite or multigenerational living arrangement. Whether you're looking for a forever home, a retirement retreat, or a property with room to grow, this is a rare opportunity to make something truly special your own.Homes that combine this level of pride of ownership, a jumbo, uniquely shaped lot, beautiful gardens, and an unbeatable Niagara-on-the-Lake location are few and far between. (id:62650)"
+"Appliances": array:4 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T21:37:13.751983+00:00"
+"Directions": "Near: CHATTAQUA CIRCLE"
+"ExteriorFeatures": array:3 [
0 => "Aluminum siding"
1 => "Vinyl siding"
2 => "Metal"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738832"
+"ListOfficeKey": "299401"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T21:10:16Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-13T20:39:31Z"
+"Stories": "1.5"
+"StreetName": "OAK"
+"StreetNumber": "27"
+"StreetSuffix": "Drive"
+"SubdivisionName": "101 - Town"
+"TaxAnnualAmount": "7651"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/pZFbfS52h5Y?si=ihzFX_CGwqTp0Qochttps://youtube.com/shorts/pZFbfS52h5Y?si=ihzFX_CGwqTp0Qoc"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29898151/27-oak-drive-niagara-on-the-lake"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 84.0
+"AboveGradeFinishedArea": 1899
+"OriginalEntryTimestamp": "2026-06-12T21:10:14.83Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1178468"
+"ListOfficeNationalAssociationId": "1472476"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29898151')"
+"ID": "1525317"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25177
+post_id: "1522158"
+post_author: 1
+"ListingKey": "29890853"
+"ListingId": "40838905"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T19:10:10Z"
+"RFModificationTimestamp": "2026-06-12T01:45:53Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1803.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "727 RYE Street, Niagara-on-the-Lake, Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.0823147
1 => 43.2433604
]
+"Latitude": 43.2433604
+"Longitude": -79.0823147
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Rustic charm meets unbeatable potential at 727 Rye Street! This 3 bed, 3 bath rustic gem sits on a RARE 110 FT WIDE LOT in the heart of Niagara-on-the-Lake's Old Town. Surrounded by multi-million dollar homes and mature greenery. Interior highlights include a spacious open concept kitchen with large island and massive picture window overlooking your private backyard. Traditional character throughout featuring rustic wood floors and 2 wood burning fireplaces (one in the living room, and the other in the formal dining room). Flexible potential, the main floor family room can easily be used as a main floor primary suite. There are 2 bathrooms on the main floor. A pine staircase leads you to the upper level featuring natural, newer cherry flooring, 3 bedrooms and full bathroom. Finished lower level offers a functional rec room, private office, laundry room, and work bench. Peace of mind - upgrades include major mechanicals (Furnace + A/C 2022/2023). Newer windows (2014) and the roof is approx. 10 years old. This prime old town location is around the corner from Rye Heritage Park and scenic Niagara Parkway, wine and culture from world-class wineries, 15 minute walk to Shaw Festival Theatre and iconic Queen Street for cafes and restaurants. Fabulous investment potential, rare 110 ft frontage, offers a significant double lot for possible severance in one of Ontario's most sought-after markets. Don't miss this chance to own a piece of wine country - ready for you to move-in, renovate, or build your grand vision! (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Microwave"
7 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"ConstructionMaterials": array:1 [
0 => "Wood frame"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-12T01:45:49.632771+00:00"
+"Directions": "HWY 55 TO EAST WEST LINE TO NIAGARA STREET TO RYE STREET"
+"ExteriorFeatures": array:1 [
0 => "Wood"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2020021"
+"ListOfficeKey": "283153"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Country residential"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:00:43Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:00:43Z"
+"Stories": "1.5"
+"StreetName": "RYE"
+"StreetNumber": "727"
+"StreetSuffix": "Street"
+"SubdivisionName": "101 - Town"
+"TaxAnnualAmount": "7345.11"
+"VirtualTourURLUnbranded": "https://youtu.be/AHxAXmgEjKk"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29890853/727-rye-street-niagara-on-the-lake"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 110.0
+"AboveGradeFinishedArea": 1803
+"OriginalEntryTimestamp": "2026-06-11T18:51:55.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1300782"
+"ListOfficeNationalAssociationId": "1325050"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29890853')"
+"ID": "1522158"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25175
+post_id: "1520969"
+post_author: 1
+"ListingKey": "29891431"
+"ListingId": "X13433432"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T20:00:09Z"
+"RFModificationTimestamp": "2026-06-11T21:50:19Z"
+"ListPrice": 1099000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Town)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "727 RYE STREET, Niagara-on-the-Lake (Town), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.082298
1 => 43.243359
]
+"Latitude": 43.243359
+"Longitude": -79.082298
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Rustic charm meets unbeatable potential at 727 Rye Street! This 3 bed, 3 bath rustic gem sits on a RARE 110 FT WIDE LOT in the heart of Niagara-on-the-Lake's Old Town. Surrounded by multi-million dollar homes and mature greenery. Interior highlights include a spacious open concept kitchen with large island and massive picture window overlooking your private backyard. Traditional character throughout featuring rustic wood floors and 2 wood burning fireplaces (one in the living room, and the other in the formal dining room). Flexible potential, the main floor family room can easily be used as a main floor primary suite. There are 2 bathrooms on the main floor. A pine staircase leads you to the upper level featuring natural, newer cherry flooring, 3 bedrooms and full bathroom. Finished lower level offers a functional rec room, private office, laundry room, and work bench. Peace of mind - upgrades include major mechanicals (Furnace + A/C 2022/2023). Newer windows (2014) and the roof is approx. 10 years old. This prime old town location is around the corner from Rye Heritage Park and scenic Niagara Parkway, wine and culture from world-class wineries, 15 minute walk to Shaw Festival Theatre and iconic Queen Street for cafes and restaurants. Fabulous investment potential, rare 110 ft frontage, offers a significant double lot for possible severance in one of Ontario's most sought-after markets. Don't miss this chance to own a piece of wine country - ready for you to move-in, renovate, or build your grand vision! (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Gas stove(s)"
3 => "Dishwasher"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T21:50:09.729225+00:00"
+"Directions": "Cross Streets: Niagara St & E&W Line. ** Directions: EAST WEST LINE TO NIAGARA STREET TO RYE STREET."
+"ExteriorFeatures": array:1 [
0 => "Wood"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2153000"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "110.2 x 104.1 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:54:51Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T19:54:51Z"
+"Stories": "1.5"
+"StreetName": "Rye"
+"StreetNumber": "727"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "7345.11"
+"VirtualTourURLUnbranded": "https://youtu.be/AHxAXmgEjKk"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Toronto"
+"CityRegion": "101 - Town"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891431/727-rye-street-niagara-on-the-lake-town-101-town"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 110.2
+"OriginalEntryTimestamp": "2026-06-11T19:54:51.88Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1404689"
+"ListOfficeNationalAssociationId": "1300540"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891431')"
+"ID": "1520969"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25170
+post_id: "1520217"
+post_author: 1
+"ListingKey": "29891198"
+"ListingId": "X13433468"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T12:05:07Z"
+"RFModificationTimestamp": "2026-06-14T12:07:19Z"
+"ListPrice": 995000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Town)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "27 OAK DRIVE, Niagara-on-the-Lake (Town), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.091551
1 => 43.257269
]
+"Latitude": 43.257269
+"Longitude": -79.091551
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to a truly special home in one of Niagara-on-the-Lake's most desirable locations. Set on a jumbo, uniquely shaped lot directly across from a park and just a short stroll to the waterfront, you'll enjoy evening walks to the water's edge to take in some of the most breathtaking sunsets Niagara has to offer.From the moment you arrive, the home's stunning curb appeal makes a lasting impression. The beautifully landscaped grounds and private garden create a charming European-inspired atmosphere that feels both peaceful and timeless. Perfectly positioned on its expansive lot, this property offers a rare combination of privacy, character, and location.Inside, you'll find a home that has been lovingly maintained by its original owner since the day it was built. Quality craftsmanship and thoughtful updates completed over the years provide a solid foundation while still offering the opportunity to customize and modernize to suit your own vision and lifestyle.Additional features include a large garage and a separate entrance to the lower level, creating exciting potential for an in-law suite or multigenerational living arrangement. Whether you're looking for a forever home, a retirement retreat, or a property with room to grow, this is a rare opportunity to make something truly special your own.Homes that combine this level of pride of ownership, a jumbo, uniquely shaped lot, beautiful gardens, and an unbeatable Niagara-on-the-Lake location are few and far between. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Oven"
5 => "Dryer"
6 => "Oven - Built-In"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-11T20:00:17.750977+00:00"
+"Directions": "LAKESHORE - OAK"
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738832"
+"ListOfficeKey": "283840"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "84 x 158.6 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T19:26:57Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-14T11:56:15Z"
+"Stories": "2.0"
+"StreetName": "Oak"
+"StreetNumber": "27"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "7651"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/pZFbfS52h5Y?si=ihzFX_CGwqTp0Qochttps://youtube.com/shorts/pZFbfS52h5Y?si=ihzFX_CGwqTp0Qoc"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"TaxYear": 2026
+"CityRegion": "101 - Town"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29891198/27-oak-drive-niagara-on-the-lake-town-101-town"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 84.0
+"OriginalEntryTimestamp": "2026-06-11T19:26:57.79Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1178468"
+"ListOfficeNationalAssociationId": "1335712"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891198')"
+"ID": "1520217"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1512909"
+post_author: 1
+"ListingKey": "29878295"
+"ListingId": "X13422064"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T20:30:14Z"
+"RFModificationTimestamp": "2026-06-09T22:39:37Z"
+"ListPrice": 925000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Town)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "S14 - 14 ST. ANDREWS LANE S, Niagara-on-the-Lake (Town), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.088518
1 => 43.249194
]
+"Latitude": 43.249194
+"Longitude": -79.088518
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Luxury 2-storey end-unit townhome with the convenience of bungalow-style living in the heart of Old Town Niagara-on-the-Lake. Complete with a private elevator, this beautifully maintained residence offers a rare combination of elegance, accessibility, and low-maintenance living just moments from Queen Street. Enjoy the lifestyle so many dream of, with boutique shopping, acclaimed restaurants, the Shaw Festival Theatre, cafés, art galleries, waterfront parks, and world-class wineries all within walking distance. This attractive home features 2 bedrooms, 3 bathrooms, a single-car garage, private driveway, and a fully finished lower level. Designed with comfort and convenience in mind, the elevator provides access to the main living level, allowing the home to function much like a bungalow while still offering the spaciousness of a 2-storey design. The bright open-concept living and dining space is filled with natural light and flows seamlessly into the well-appointed kitchen. The spacious primary suite serves as a private retreat, featuring a walk-in closet, ensuite bath, and its own private balcony. A second bedroom and full bathroom complete the main living level, while a second balcony off the living area provides the perfect place to relax and enjoy the surroundings. The fully finished lower level offers exceptional flexibility with a large recreation room ( or potential) third bedroom, full bathroom, oversized storage room ( or potential walk in closet), making it ideal for guests, extended family, a home office, or hobby space. As an end unit, the home enjoys added privacy and an abundance of natural light throughout. Whether you're downsizing, relocating, or simply looking to enjoy the unmatched charm of Niagara-on-the-Lake, this move-in-ready residence offers the perfect blend of luxury, space, and location. Available immediately. A rare opportunity in one of Niagara-on-the-Lake's most sought-after communities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Window Coverings"
]
+"AssociationFee": "533.17"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:1 [
0 => "Common Area Maintenance"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T22:39:30.962062+00:00"
+"Directions": "Cross Streets: Balmoral. ** Directions: HWY 55/ Niagara Stone RD-Balmoral-St Andrews Lane."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2021039"
+"ListOfficeKey": "300053"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T20:27:47Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T20:27:47Z"
+"Stories": "2.0"
+"StreetDirSuffix": "South"
+"StreetName": "St. Andrews"
+"StreetNumber": "14"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "7213.01"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/5WpwEpy62Wc"
+"ListAOR": "Niagara"
+"TaxYear": 2026
+"CityRegion": "101 - Town"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29878295/s14-14-st-andrews-lane-s-niagara-on-the-lake-town-101-town"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2204347"
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard Management"
+"CoListOfficeKey": "282726"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1799
+"LivingAreaMinimum": 1600
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-09T19:56:41.52Z"
+"ListAgentNationalAssociationId": "1300859"
+"ListOfficeNationalAssociationId": "1482107"
+"CoListAgentNationalAssociationId": "1452939"
+"CoListOfficeNationalAssociationId": "1320650"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29878295')"
+"ID": "1512909"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25178
+post_id: "1510598"
+post_author: 1
+"ListingKey": "29875280"
+"ListingId": "X13419164"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T17:35:27Z"
+"RFModificationTimestamp": "2026-06-11T17:53:47Z"
+"ListPrice": 1177000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Town)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "107 - 225 RICARDO STREET, Niagara-on-the-Lake (Town), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.061087
1 => 43.25391
]
+"Latitude": 43.25391
+"Longitude": -79.061087
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to King's Point -- luxury condominium waterfront living along the Niagara River and in the heart of the Old Town. This upgraded ground floor 1,500 sq ft, 2 bed, 2 bath suite features a spacious living and dining area with a walk out to a large private terrace with a view of the Niagara River. A contemporary, open concept kitchen features over 20 ft of granite countertop with breakfast bar. Included are 9-foot ceilings, gas fireplace, in-suite separate laundry closet, a large pantry and floor to ceiling windows. The primary bedroom offers an extra large walk in closet and ensuite with a large walk-in shower and linen closet. The second bedroom overlooks a private atrium and easily serves as a home office or den. This secluded side of the King's Point complex provides a treed landscape and relaxing "cottage" feel. Enjoy the morning sun with this south east exposure. King's Point amenities include an outdoor salt water pool and spa, Muskoka Chair Terrace overlooking the Niagara River, BBQ Terrace, award-winning gardens, exercise room, Guest Suite booking privileges, underground parking, bike storage, and underground car washing bay. Bell Fibe Internet and TV is included in your condo fees. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Intercom"
3 => "Dishwasher"
4 => "Wine Fridge"
5 => "Stove"
6 => "Dryer"
7 => "Window Coverings"
]
+"AssociationFee": "1239"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Cable TV"
2 => "Water"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T17:24:29.839984+00:00"
+"Directions": "Cross Streets: Ricardo & Melville. ** Directions: Niagara Pky to Ricardo or King St to Ricardo."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1974164"
+"ListOfficeKey": "272269"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-11T00:22:54Z"
+"PhotosCount": 35
+"PoolFeatures": array:1 [
0 => "Outdoor pool"
]
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-11T17:26:35Z"
+"StreetName": "Ricardo"
+"StreetNumber": "225"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "8033"
+"View": "View of water,Direct Water View"
+"WaterBodyName": "Niagara River"
+"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": "Niagara"
+"CityRegion": "101 - Town"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29875280/107-225-ricardo-street-niagara-on-the-lake-town-101-town"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Wilson Blanchard"
+"GeocodeManualYN": false
+"BuildingFeatures": array:4 [
0 => "Storage - Locker"
1 => "Car Wash"
2 => "Exercise Centre"
3 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1599
+"LivingAreaMinimum": 1400
+"BedroomsAboveGrade": 2
+"WaterfrontFeatures": array:1 [
0 => "Waterfront on river"
]
+"OriginalEntryTimestamp": "2026-06-09T14:31:14.94Z"
+"ListAgentNationalAssociationId": "1261132"
+"ListOfficeNationalAssociationId": "1243338"
+"Media": array:35 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875280')"
+"ID": "1510598"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25179
+post_id: "1510272"
+post_author: 1
+"ListingKey": "29875797"
+"ListingId": "X13419564"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T15:35:25Z"
+"RFModificationTimestamp": "2026-06-09T16:59:00Z"
+"ListPrice": 1999900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Town)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "235 SIMCOE STREET, Niagara-on-the-Lake (Town), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.07811
1 => 43.257024
]
+"Latitude": 43.257024
+"Longitude": -79.07811
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Nestled in the heart of Old Town Niagara-on-the-Lake, this stunning heritage home offers a rare blend of historic charm and thoughtful modern updates. Featuring 3 bedrooms, 2 bathrooms, original hardwood floors, five fireplaces, and elegant living spaces, the home is designed for both comfort and entertaining. Expansive bifold doors open completely to create a seamless indoor-outdoor experience, connecting the home to beautifully landscaped gardens and a private backyard retreat featuring a built-in natural gas fireplace and BBQ. A detached coach house provides additional space for guests, a studio, or home office. Enjoy an unmatched walkable lifestyle just steps to Queen Street's boutiques, cafés, restaurants, wineries, the Shaw Festival, Canada's oldest golf course, and scenic lakefront dining. A truly exceptional Niagara-on-the-Lake offering. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T16:58:51.775648+00:00"
+"Directions": "Cross Streets: CORNER OF JOHNSON & SIMCOE. ** Directions: Mississagua St to Johnson St to Simcoe St."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Stucco"
]
+"FireplaceYN": true
+"FireplacesTotal": "5"
+"FoundationDetails": array:1 [
0 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2022523"
+"ListOfficeKey": "283409"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "109.4 x 95.2 FT"
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T15:29:11Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T15:29:11Z"
+"Stories": "2.0"
+"StreetName": "Simcoe"
+"StreetNumber": "235"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "11000"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/sLuHJ7V7Vc8"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"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": "Niagara"
+"CityRegion": "101 - Town"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29875797/235-simcoe-street-niagara-on-the-lake-town-101-town"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 109.4
+"OriginalEntryTimestamp": "2026-06-09T15:29:11.41Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1302254"
+"ListOfficeNationalAssociationId": "1328620"
+"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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875797')"
+"ID": "1510272"
}
]
+success: true
+page_size: 9
+page_count: 11
+count: 91
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]