array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29891159 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23524
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23526
+post_id: "1521298"
+post_author: 1
+"ListingKey": "29891159"
+"ListingId": "X13433232"
+"PropertyType": "Residential"
+"PropertySubType": "Vacant Land"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-23T20:00:14Z"
+"RFModificationTimestamp": "2026-06-23T20:06:39Z"
+"ListPrice": 3999999.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 1.892
+"LivingArea": 2.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Glendale)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "0 COUNSELL STREET N, Niagara-on-the-Lake (Glendale), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.159777
1 => 43.159916
]
+"Latitude": 43.159916
+"Longitude": -79.159777
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Location, Location, Location. A Great development Site Approximately 2 Acres. Zoned RC1. New Secondary Plan In Place For Mix Use Development Up To 8 Storeys. Build A Retirement Home, Or Purpose Built Rental Apartments And Many More Commercial Uses Available. New Hotels Being Built Around The Property. (id:62650)"
+"CreationDate": "2026-06-11T21:36:07.010752+00:00"
+"Directions": "York Road Glendale Ave to York Rd to Counsell St next to Holiday Inn Express Hotel"
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2078874"
+"ListOfficeKey": "259310"
+"LotFeatures": array:1 [
0 => "Irregular lot size"
]
+"LotSizeDimensions": "1.892"
+"PhotosChangeTimestamp": "2026-06-11T19:22:08Z"
+"PhotosCount": 1
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-23T19:53:39Z"
+"StreetDirSuffix": "North"
+"StreetName": "COUNSELL"
+"StreetNumber": "0"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "13904.96"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "107 - Glendale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29891159/0-counsell-street-n-niagara-on-the-lake-glendale-107-glendale"
+"GeocodeManualYN": false
+"ZoningDescription": "RC1"
+"FrontageLengthNumeric": 280.0
+"OriginalEntryTimestamp": "2026-06-11T19:22:08.39Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1353740"
+"ListOfficeNationalAssociationId": "1217765"
+"Media": array:1 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29891159_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29891159/750b29adf0270b8b849381d57532b125.webp"
"MediaSize" => 19873
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29891159/thumbnail-750b29adf0270b8b849381d57532b125.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13433232"
"ResourceRecordKey" => "29891159"
"ModificationTimestamp" => "2026-06-11T19:22:08.4Z"
]
]
+"DaysOnMarket": 40
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29891159')"
+"ID": "1521298"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 259310" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24936
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24880
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "TRI-CITY PROFESSIONAL REALTY INC."
+"OfficeEmail": null
+"OfficePhone": "905-793-5777"
+"OfficeMlsId": "175500"
+"ModificationTimestamp": "2026-03-03T10:56:50Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "259310"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "31 MELANIE DRIVE UNIT 4"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "BRAMPTON"
+"OfficePostalCode": "L6T5H"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Toronto"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1217765"
+"OriginalEntryTimestamp": "2010-11-25T03:14:00Z"
+"OfficeFax": "905-793-6222"
+"OfficeAORKey": "82"
+"OfficeCountry": "Canada"
+"OfficeBrokerNationalAssociationId": "1144375"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('259310')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2078874" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24874
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29891159'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25229
+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 '29891159' AND OpenHouseDate ge '2026-07-21'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29891159' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.159777 43.159916)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25298
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25292
+post_id: "1543679"
+post_author: 1
+"ListingKey": "29920446"
+"ListingId": "X13459798"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:30:01Z"
+"RFModificationTimestamp": "2026-07-07T14:41:24Z"
+"ListPrice": 1289999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Glendale)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "404 WRIGHT CRESCENT, Niagara-on-the-Lake (Glendale), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.1714055
1 => 43.1494004
]
+"Latitude": 43.1494004
+"Longitude": -79.1714055
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to one of Niagara's premier neighbourhoods! Nestled within Niagara-on-the-Green and backing on the 27th hole of the Royal Niagara Golf Course, this neighbourhood has been featured on HGTV's House Hunters. The inviting front porch gives views of the manicured street, and leads into the first of 5 bedrooms or the perfect office location. Experience the open concept of the living and dining area, leading you into the spacious kitchen. The kitchen has stylized cabinetry, and features beautiful quartz counter space, with a breakfast bar that sits 6. Sliding doors off the kitchen lead you to a pristine back yard with views of the golf course and pond. The covered patio with gas BBQ line, A private gate and bridge to the course allows you access to load your clubs on the cart in style. The family room has a gas fireplace, high windows, a vaulted ceilings, views of the backyard and golf course and beyond.Have adult children? In-laws? Interested in running a B&B?...The lower level is beautifully finished with an impressively large recreation room with a gas fireplace, two additional bedrooms, two beautiful bathrooms - featuring a double sink vanity complete with a steam shower, and finally a second full kitchen. Roof 2019, AC 2023. HWT owned. Property taxes are calculated using the regional tax calculator. All interior furnishings for sale additionally, excepting the dining room table. (id:62650)"
+"Appliances": array:17 [
0 => "All"
1 => "Washer"
2 => "Refrigerator"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Wine Fridge"
7 => "Stove"
8 => "Range"
9 => "Oven"
10 => "Dryer"
11 => "Microwave"
12 => "Hood Fan"
13 => "Window Coverings"
14 => "Garage door opener"
15 => "Garage door opener remote(s)"
16 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T16:46:02.536077+00:00"
+"Directions": "Cross Streets: TAYLOR ROAD & GLENDALE AVE. ** Directions: Glendale Ave to Niagara-on-the-Green Blvd to Wright Cres."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058789"
+"ListOfficeKey": "290582"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "60 x 129.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T11:56:44Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T14:21:32Z"
+"Stories": "1.0"
+"StreetName": "Wright"
+"StreetNumber": "404"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "6290.59"
+"View": "View"
+"VirtualTourURLUnbranded": "https://youriguide.com/5hzkp_404_wright_crescent_niagara_on_the_lake_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1677326600"
"RoomType" => "Bedroom 2"
"ListingId" => "X13459798"
"RoomLevel" => "Main level"
"RoomWidth" => 3.1
"ListingKey" => "29920446"
"RoomLength" => 4.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.96Z"
]
1 => array:11 [
"RoomKey" => "1677326601"
"RoomType" => "Bedroom 4"
"ListingId" => "X13459798"
"RoomLevel" => "Basement"
"RoomWidth" => 3.15
"ListingKey" => "29920446"
"RoomLength" => 4.11
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.96Z"
]
2 => array:11 [
"RoomKey" => "1677326602"
"RoomType" => "Utility room"
"ListingId" => "X13459798"
"RoomLevel" => "Basement"
"RoomWidth" => 1.8
"ListingKey" => "29920446"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.96Z"
]
3 => array:11 [
"RoomKey" => "1677326603"
"RoomType" => "Other"
"ListingId" => "X13459798"
"RoomLevel" => "Basement"
"RoomWidth" => 2.79
"ListingKey" => "29920446"
"RoomLength" => 3.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.96Z"
]
4 => array:11 [
"RoomKey" => "1677326604"
"RoomType" => "Living room"
"ListingId" => "X13459798"
"RoomLevel" => "Main level"
"RoomWidth" => 3.68
"ListingKey" => "29920446"
"RoomLength" => 4.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.96Z"
]
5 => array:11 [
"RoomKey" => "1677326605"
"RoomType" => "Bedroom 5"
"ListingId" => "X13459798"
"RoomLevel" => "Basement"
"RoomWidth" => 5.18
"ListingKey" => "29920446"
"RoomLength" => 2.9
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.96Z"
]
6 => array:11 [
"RoomKey" => "1677326606"
"RoomType" => "Kitchen"
"ListingId" => "X13459798"
"RoomLevel" => "Basement"
"RoomWidth" => 3.78
"ListingKey" => "29920446"
"RoomLength" => 4.09
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.96Z"
]
7 => array:11 [
"RoomKey" => "1677326607"
"RoomType" => "Dining room"
"ListingId" => "X13459798"
"RoomLevel" => "Main level"
"RoomWidth" => 3.45
"ListingKey" => "29920446"
"RoomLength" => 5.36
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.96Z"
]
8 => array:11 [
"RoomKey" => "1677326608"
"RoomType" => "Kitchen"
"ListingId" => "X13459798"
"RoomLevel" => "Main level"
"RoomWidth" => 4.5
"ListingKey" => "29920446"
"RoomLength" => 5.69
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.96Z"
]
9 => array:11 [
"RoomKey" => "1677326609"
"RoomType" => "Eating area"
"ListingId" => "X13459798"
"RoomLevel" => "Main level"
"RoomWidth" => 1.93
"ListingKey" => "29920446"
"RoomLength" => 3.18
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.97Z"
]
10 => array:11 [
"RoomKey" => "1677326610"
"RoomType" => "Family room"
"ListingId" => "X13459798"
"RoomLevel" => "Main level"
"RoomWidth" => 6.25
"ListingKey" => "29920446"
"RoomLength" => 5.56
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.97Z"
]
11 => array:11 [
"RoomKey" => "1677326611"
"RoomType" => "Laundry room"
"ListingId" => "X13459798"
"RoomLevel" => "Main level"
"RoomWidth" => 2.57
"ListingKey" => "29920446"
"RoomLength" => 2.26
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.97Z"
]
12 => array:11 [
"RoomKey" => "1677326612"
"RoomType" => "Bedroom 3"
"ListingId" => "X13459798"
"RoomLevel" => "Main level"
"RoomWidth" => 3.71
"ListingKey" => "29920446"
"RoomLength" => 3.66
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.97Z"
]
13 => array:11 [
"RoomKey" => "1677326613"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13459798"
"RoomLevel" => "Main level"
"RoomWidth" => 6.25
"ListingKey" => "29920446"
"RoomLength" => 4.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.97Z"
]
14 => array:11 [
"RoomKey" => "1677326614"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13459798"
"RoomLevel" => "Basement"
"RoomWidth" => 10.49
"ListingKey" => "29920446"
"RoomLength" => 8.28
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-07T14:21:32.97Z"
]
]
+"ListAOR": "Niagara"
+"CityRegion": "107 - Glendale"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29920446/404-wright-crescent-niagara-on-the-lake-glendale-107-glendale"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:2 [
0 => "Alarm system"
1 => "Smoke Detectors"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-18T11:56:44.31Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1333878"
+"ListOfficeNationalAssociationId": "1389351"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29920446_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/c7b0d7a53160dc41f2e6bab5696a75b2.webp"
"MediaSize" => 378790
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-c7b0d7a53160dc41f2e6bab5696a75b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29920446_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/aef647e13543f5ed90598cbc52eea347.webp"
"MediaSize" => 199021
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-aef647e13543f5ed90598cbc52eea347.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29920446_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/766febbf43b04717a0f8d43fc727c5f3.webp"
"MediaSize" => 173869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-766febbf43b04717a0f8d43fc727c5f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29920446_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/5a747495e3ea69473a6461348bbf70a8.webp"
"MediaSize" => 200267
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-5a747495e3ea69473a6461348bbf70a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29920446_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/b644f31c1fc20c82aaa21972a9dfc334.webp"
"MediaSize" => 136049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-b644f31c1fc20c82aaa21972a9dfc334.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29920446_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/1d74728d66b68445e590e7f9b781939e.webp"
"MediaSize" => 138035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-1d74728d66b68445e590e7f9b781939e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29920446_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/e0e53b34f7386c36d1c704c18353b522.webp"
"MediaSize" => 140799
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-e0e53b34f7386c36d1c704c18353b522.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29920446_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/61b6c5288149ee3e37452444efb38551.webp"
"MediaSize" => 165140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-61b6c5288149ee3e37452444efb38551.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29920446_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/0474a049dfffef572488aca22fc879a5.webp"
"MediaSize" => 172787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-0474a049dfffef572488aca22fc879a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29920446_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/e40890663e7ad41366b4b2b3e23b5e12.webp"
"MediaSize" => 154058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-e40890663e7ad41366b4b2b3e23b5e12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29920446_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/f0c6de41b5e863b4e7b8f13aabd80de2.webp"
"MediaSize" => 184543
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-f0c6de41b5e863b4e7b8f13aabd80de2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29920446_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/3b44436820fa49721530906622d09441.webp"
"MediaSize" => 185576
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-3b44436820fa49721530906622d09441.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29920446_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/f2a7c1d002c338473da973907d84aa9f.webp"
"MediaSize" => 198899
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-f2a7c1d002c338473da973907d84aa9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29920446_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/19ec87672736613d212740cc3daa85c6.webp"
"MediaSize" => 181005
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-19ec87672736613d212740cc3daa85c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29920446_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/3772c090cb214573baaf94b9bca1568b.webp"
"MediaSize" => 159688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-3772c090cb214573baaf94b9bca1568b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29920446_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/b3854b4ac17ccfa97c5bce5b41a96506.webp"
"MediaSize" => 136131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-b3854b4ac17ccfa97c5bce5b41a96506.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29920446_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/fe1dd0afdb4b3d43eb831051263b647a.webp"
"MediaSize" => 179355
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-fe1dd0afdb4b3d43eb831051263b647a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29920446_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/bdfcb31e4738f0437131c7dffba42416.webp"
"MediaSize" => 206625
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-bdfcb31e4738f0437131c7dffba42416.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29920446_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/147f224764a3d7a4879b82c9478f6de1.webp"
"MediaSize" => 190854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-147f224764a3d7a4879b82c9478f6de1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29920446_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/3ee9d03da6dbb39db664a743ecdae413.webp"
"MediaSize" => 158082
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-3ee9d03da6dbb39db664a743ecdae413.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29920446_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/45a314efc91bdfa03442348f7fe7b192.webp"
"MediaSize" => 15305
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-45a314efc91bdfa03442348f7fe7b192.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29920446_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/bcb382a0949319b8b8b2a7525cc65930.webp"
"MediaSize" => 257637
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-bcb382a0949319b8b8b2a7525cc65930.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29920446_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/2cc8943d4ce7b7491b2556848823e1be.webp"
"MediaSize" => 356677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-2cc8943d4ce7b7491b2556848823e1be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29920446_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/9e8d07bde909b37a2eda7cef1f272305.webp"
"MediaSize" => 349171
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-9e8d07bde909b37a2eda7cef1f272305.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29920446_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/61a5c2d8ac185bcebc6e19998addf80b.webp"
"MediaSize" => 359105
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-61a5c2d8ac185bcebc6e19998addf80b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29920446_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/54b6dff55a02cfcb7f4860be8e14fad6.webp"
"MediaSize" => 452507
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-54b6dff55a02cfcb7f4860be8e14fad6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29920446_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/a6efd8e7a4b01f6eaa98aecd75309198.webp"
"MediaSize" => 419277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-a6efd8e7a4b01f6eaa98aecd75309198.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29920446_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/5d7e9b76996318d4e8220345a897487c.webp"
"MediaSize" => 369060
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-5d7e9b76996318d4e8220345a897487c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29920446_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/ee62b8b0f0ae6feb0a64a39d0bd077c5.webp"
"MediaSize" => 395564
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-ee62b8b0f0ae6feb0a64a39d0bd077c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29920446_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29920446/741722b60445b70e3d0d839fe24f5ee1.webp"
"MediaSize" => 80800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29920446/thumbnail-741722b60445b70e3d0d839fe24f5ee1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459798"
"ResourceRecordKey" => "29920446"
"ModificationTimestamp" => "2026-06-18T11:56:44.33Z"
]
]
+"DaysOnMarket": 34
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29920446')"
+"ID": "1543679"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25294
+post_id: "1537977"
+post_author: 1
+"ListingKey": "29912428"
+"ListingId": "X13452860"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-15T16:15:05Z"
+"RFModificationTimestamp": "2026-07-15T16:20:04Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Glendale)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "33 STEVENS DRIVE, Niagara-on-the-Lake (Glendale), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.170097
1 => 43.151321
]
+"Latitude": 43.151321
+"Longitude": -79.170097
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 33 Stevens! This one owner home with pride of ownership is a charming two-storey home nestled in the Glendale neighbourhood of Niagara-on-the-Lake, close to the famous Niagara Outlet Mall, Niagara College, and the QEW. A short drive to Niagara-on-the-Lake Old Town with world-class wineries and theatre! Situated on a beautifully landscaped lot in a mature, tree-lined community with parks and green space nearby, this meticulously maintained home offers exceptional pride of ownership throughout. A large covered front porch provides a warm welcome, while the double-car garage and double-wide driveway offer ample parking. Inside, you'll find bright, spacious living areas designed for comfortable family living. The main floor features a welcoming living room with a cozy fireplace and a convenient powder room. The kitchen features newer stainless steel appliances and a walkout to the private, professionally landscaped yard and patio, complete with gorgeous stone pavers -perfect for relaxing or entertaining. Upstairs, there are three generous sized bedrooms with large windows and 2 full bathrooms. The spacious primary suite includes a walk-in closet and a private ensuite bath. The finished basement provides valuable additional living space, including a fourth bedroom and 2 pc bathroom, making it ideal for a guest suite or a home office. Total of approx. 2100 SQFT. Every detail of this home reflects exceptional care and maintenance. With updated finishes, immaculate condition, and a convenient location, 33 Stevens Drive is truly move-in ready - come see it for yourself today! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Dryer"
4 => "Window Coverings"
5 => "Water Heater"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T21:24:25.831258+00:00"
+"Directions": "Cross Streets: Glendale Ave. ** Directions: Glendale Ave to Niagara-on-the-Green Blvd to Stevens."
+"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": "2153000"
+"ListOfficeKey": "279033"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "49.1 x 76.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T20:55:41Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-15T16:09:07Z"
+"Stories": "2.0"
+"StreetName": "Stevens"
+"StreetNumber": "33"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "4500"
+"VirtualTourURLUnbranded": "https://youtu.be/04x7xiXlNJg"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1685013341"
"RoomType" => "Living room"
"ListingId" => "X13452860"
"RoomLevel" => "Main level"
"RoomWidth" => 4.93
"ListingKey" => "29912428"
"RoomLength" => 5.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.97Z"
]
1 => array:11 [
"RoomKey" => "1685013342"
"RoomType" => "Bedroom"
"ListingId" => "X13452860"
"RoomLevel" => "Basement"
"RoomWidth" => 5.46
"ListingKey" => "29912428"
"RoomLength" => 11.07
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.97Z"
]
2 => array:11 [
"RoomKey" => "1685013343"
"RoomType" => "Bathroom"
"ListingId" => "X13452860"
"RoomLevel" => "Basement"
"RoomWidth" => 1.35
"ListingKey" => "29912428"
"RoomLength" => 2.06
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.97Z"
]
3 => array:11 [
"RoomKey" => "1685013344"
"RoomType" => "Utility room"
"ListingId" => "X13452860"
"RoomLevel" => "Basement"
"RoomWidth" => 4.04
"ListingKey" => "29912428"
"RoomLength" => 3.0
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.97Z"
]
4 => array:11 [
"RoomKey" => "1685013345"
"RoomType" => "Other"
"ListingId" => "X13452860"
"RoomLevel" => "Basement"
"RoomWidth" => 4.93
"ListingKey" => "29912428"
"RoomLength" => 2.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
5 => array:11 [
"RoomKey" => "1685013346"
"RoomType" => "Bathroom"
"ListingId" => "X13452860"
"RoomLevel" => "Main level"
"RoomWidth" => 0.94
"ListingKey" => "29912428"
"RoomLength" => 1.91
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
6 => array:11 [
"RoomKey" => "1685013347"
"RoomType" => "Kitchen"
"ListingId" => "X13452860"
"RoomLevel" => "Main level"
"RoomWidth" => 3.43
"ListingKey" => "29912428"
"RoomLength" => 2.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
7 => array:11 [
"RoomKey" => "1685013348"
"RoomType" => "Dining room"
"ListingId" => "X13452860"
"RoomLevel" => "Main level"
"RoomWidth" => 3.43
"ListingKey" => "29912428"
"RoomLength" => 2.92
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
8 => array:11 [
"RoomKey" => "1685013349"
"RoomType" => "Family room"
"ListingId" => "X13452860"
"RoomLevel" => "Main level"
"RoomWidth" => 3.68
"ListingKey" => "29912428"
"RoomLength" => 5.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
9 => array:11 [
"RoomKey" => "1685013350"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13452860"
"RoomLevel" => "Second level"
"RoomWidth" => 3.68
"ListingKey" => "29912428"
"RoomLength" => 6.27
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
10 => array:11 [
"RoomKey" => "1685013351"
"RoomType" => "Bathroom"
"ListingId" => "X13452860"
"RoomLevel" => "Second level"
"RoomWidth" => 2.41
"ListingKey" => "29912428"
"RoomLength" => 2.21
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
11 => array:11 [
"RoomKey" => "1685013352"
"RoomType" => "Bedroom"
"ListingId" => "X13452860"
"RoomLevel" => "Second level"
"RoomWidth" => 4.04
"ListingKey" => "29912428"
"RoomLength" => 3.84
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
12 => array:11 [
"RoomKey" => "1685013353"
"RoomType" => "Bathroom"
"ListingId" => "X13452860"
"RoomLevel" => "Second level"
"RoomWidth" => 2.44
"ListingKey" => "29912428"
"RoomLength" => 1.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
13 => array:11 [
"RoomKey" => "1685013354"
"RoomType" => "Bedroom"
"ListingId" => "X13452860"
"RoomLevel" => "Second level"
"RoomWidth" => 3.43
"ListingKey" => "29912428"
"RoomLength" => 3.1
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-07-15T16:09:07.98Z"
]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "107 - Glendale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912428/33-stevens-drive-niagara-on-the-lake-glendale-107-glendale"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 49.1
+"OriginalEntryTimestamp": "2026-06-16T20:55:41.49Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1404689"
+"ListOfficeNationalAssociationId": "1300540"
+"Media": array:46 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29912428_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/f742c6c34f65daa458ec54ea9679b4ea.webp"
"MediaSize" => 356187
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-f742c6c34f65daa458ec54ea9679b4ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29912428_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/969cefdb15817b4ecf5e379ad9a99687.webp"
"MediaSize" => 346495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-969cefdb15817b4ecf5e379ad9a99687.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29912428_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/454a9fc96e6a16c23c3fb9dab714d9d5.webp"
"MediaSize" => 428184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-454a9fc96e6a16c23c3fb9dab714d9d5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29912428_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/72489939354fcf82db9415d34095c07c.webp"
"MediaSize" => 302373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-72489939354fcf82db9415d34095c07c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29912428_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/53a39ad81004470775a19d607e35d6b7.webp"
"MediaSize" => 429194
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-53a39ad81004470775a19d607e35d6b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29912428_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/b785528136928b1fa12342304aefecb3.webp"
"MediaSize" => 342385
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-b785528136928b1fa12342304aefecb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29912428_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/c136d9373b176c9ecfeee9decaf9bcae.webp"
"MediaSize" => 325011
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-c136d9373b176c9ecfeee9decaf9bcae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29912428_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/4510b614beb1e9d32da0b34083b29dff.webp"
"MediaSize" => 109273
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-4510b614beb1e9d32da0b34083b29dff.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29912428_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/b75e7eba1490fe482fd51a5861c87e48.webp"
"MediaSize" => 175200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-b75e7eba1490fe482fd51a5861c87e48.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29912428_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/84376ad549774af8d3b7ca6214549dc2.webp"
"MediaSize" => 203653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-84376ad549774af8d3b7ca6214549dc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29912428_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/dba1305e56f66e920050a0bbaac2d704.webp"
"MediaSize" => 183364
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-dba1305e56f66e920050a0bbaac2d704.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29912428_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/45770975d00c353d9f04171a951fdbab.webp"
"MediaSize" => 126775
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-45770975d00c353d9f04171a951fdbab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29912428_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/b818ff839487cf520468f4ae99d4f1b1.webp"
"MediaSize" => 174066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-b818ff839487cf520468f4ae99d4f1b1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29912428_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/f1c98ca1217aed31b993f1bee931c654.webp"
"MediaSize" => 155617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-f1c98ca1217aed31b993f1bee931c654.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29912428_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/cf59204b4df0b9adf046fe925f52fa4a.webp"
"MediaSize" => 153902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-cf59204b4df0b9adf046fe925f52fa4a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29912428_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/8bddfc89eed2eb48b231c7a8e0d3e9d6.webp"
"MediaSize" => 168575
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-8bddfc89eed2eb48b231c7a8e0d3e9d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29912428_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/16707601b6f7b902b66c5a210d86bcc2.webp"
"MediaSize" => 199286
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-16707601b6f7b902b66c5a210d86bcc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29912428_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/a331871072ca112c18a19121e4e6e056.webp"
"MediaSize" => 229376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-a331871072ca112c18a19121e4e6e056.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29912428_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/f5e75cf32e7151d0955d0eee4cffeff9.webp"
"MediaSize" => 198231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-f5e75cf32e7151d0955d0eee4cffeff9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29912428_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/d0eac04661a2ce96787c4d0f07be6947.webp"
"MediaSize" => 181117
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-d0eac04661a2ce96787c4d0f07be6947.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29912428_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/2a38f210ba9126346a1b980a6af55b31.webp"
"MediaSize" => 104782
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-2a38f210ba9126346a1b980a6af55b31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13452860"
"ResourceRecordKey" => "29912428"
"ModificationTimestamp" => "2026-06-16T20:55:41.49Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29912428_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29912428/a22577ee00bee03b3dfcc0507ce1a099.webp"
"MediaSize" => 138499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29912428/thumbnail-a22577ee00bee03b3dfcc0507ce1a099.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
…3
]
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]
]
+"DaysOnMarket": 35
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912428')"
+"ID": "1537977"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25291
+post_id: "1511348"
+post_author: 1
+"ListingKey": "29876483"
+"ListingId": "40838190"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T16:45:14Z"
+"RFModificationTimestamp": "2026-06-09T19:15:15Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1841.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "519 QUEENSTON Road, Niagara-on-the-Lake, Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.1541258
1 => 43.1643242
]
+"Latitude": 43.1643242
+"Longitude": -79.1541258
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 519 Queenston Road, a rare and remarkable offering set on a stunning 1.2-acre lot in the heart of Niagara-on-the-Lake. Just moments from award-winning wineries, renowned dining, The Shaw Festival Theatre, and world-class golf, this exceptional property captures the very best of the region’s celebrated lifestyle. This charming two-storey home radiates pride of ownership, blending timeless character with thoughtful modern upgrades. Inside, a chef-inspired redesigned kitchen (2023) anchors the home, while sophisticated principal rooms, built-in living room shelving, and tasteful finishes throughout create warmth, function, and style. Custom exterior awnings add both charm and comfort, enhancing the home’s inviting indoor-outdoor appeal. Step outside to enjoy serene mornings on the private terrace or relaxed summer days by the recently added 20' x 40' inground pool (2022), surrounded by professionally landscaped gardens filled with vibrant perennials and mature shrubbery. A spacious detached two-storey garage with finished upper level offers incredible flexibility as a home office, creative studio, or future guest suite. All south-facing windows have been treated with 3M UV film protection, helping preserve interior finishes and improve energy efficiency. Additional upgrades include an elegant upstairs bathroom (2022), new main level bath (2023), furnace and AC (2024), heat pump (2023), numerous new windows, and a complete septic system (2022). Whether envisioned as a full-time residence, a country retreat in wine country, or a stylish pied-a-terre for a Toronto buyer seeking a refined escape in NOTL, this property also holds exceptional appeal as a cottage or second home. Peaceful yet connected, it offers a rare opportunity to own a truly special retreat in one of Ontario’s most desirable communities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Range - Gas"
4 => "Dishwasher"
5 => "Oven - Built-In"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"ConstructionMaterials": array:3 [
0 => "Wood frame"
1 => "Concrete block"
2 => "Concrete Walls"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T19:14:46.198094+00:00"
+"Directions": "Take Townline Rd to Queenston Rd."
+"ExteriorFeatures": array:3 [
0 => "Concrete"
1 => "Wood"
2 => "Shingles"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1976456"
+"ListOfficeKey": "292003"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Conservation/green belt"
1 => "Crushed stone driveway"
2 => "Country residential"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T16:44:05Z"
+"PhotosCount": 47
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T16:44:05Z"
+"Stories": "2.0"
+"StreetName": "QUEENSTON"
+"StreetNumber": "519"
+"StreetSuffix": "Road"
+"SubdivisionName": "104 - Rural"
+"TaxAnnualAmount": "5665.37"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/519-queenston-rd-niagara-on-the-lake-on-l0s-1j0-16597567/branded"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29876483/519-queenston-road-niagara-on-the-lake"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 200.0
+"AboveGradeFinishedArea": 1841
+"OriginalEntryTimestamp": "2026-06-09T16:39:55.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1262871"
+"ListOfficeNationalAssociationId": "1407357"
+"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": 42
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876483')"
+"ID": "1511348"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25295
+post_id: "1527811"
+post_author: 1
+"ListingKey": "29876924"
+"ListingId": "X13420718"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T17:36:08Z"
+"RFModificationTimestamp": "2026-06-09T17:53:17Z"
+"ListPrice": 1149000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Rural)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "519 QUEENSTON ROAD, Niagara-on-the-Lake (Rural), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.1541314
1 => 43.1642995
]
+"Latitude": 43.1642995
+"Longitude": -79.1541314
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to 519 Queenston Road, a rare and remarkable offering nestled on a stunning 1.2-acre lot in the heart of Niagara-on-the-Lake. Perfectly positioned just moments from an array of coveted amenities, this exceptional property invites you to fully embrace the region's celebrated lifestyle-enjoy award-winning wineries, renowned local cuisine, The Shaw Festival Theatre, and world-class golf, all just minutes from your doorstep. This charming two-storey family home radiates pride of ownership, beautifully blending timeless character with modern upgrades. Step inside to discover a chef-inspired, fully redesigned kitchen (2023) ideal for entertaining, complemented by a sophisticated dining space and tasteful finishes throughout. Enjoy serene mornings or relaxed evenings on the private terrace or by the recently added 20' x 40' inground pool (2022), surrounded by professionally landscaped gardens bursting with vibrant perennials and mature shrubbery. A spacious detached two storey garage with finished upper level offers incredible flexibility-perfect as a home office, creative studio, or future guest suite. All south facing windows have been treated with 3M UV film protection, preserving interior finishes and enhancing energy efficiency. Additional recent upgrades include a new elegant upstairs bathroom (2022), new main level bath (2023), new furnace and AC (2024), heat pump (2023), numerous new windows, and a complete septic system (2022), ensuring both comfort and peace of mind. Whether you're seeking a peaceful retreat or an entertainer's dream, this property delivers the best of both worlds in one of Ontario's most desirable communities. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Range"
5 => "Oven"
6 => "Oven - Built-In"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Partial"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T17:53:11.588980+00:00"
+"Directions": "Cross Streets: Townline Rd. ** Directions: Take Townline Rd to Queenston Rd."
+"ExteriorFeatures": array:2 [
0 => "Concrete Block"
1 => "Shingles"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2086685"
+"ListOfficeKey": "292142"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "200.5 x 275.6 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-09T17:27:14Z"
+"PhotosCount": 46
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-09T17:27:14Z"
+"Stories": "2.0"
+"StreetName": "Queenston"
+"StreetNumber": "519"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5665.37"
+"VirtualTourURLUnbranded": "https://listings.northernsprucemedia.com/sites/519-queenston-rd-niagara-on-the-lake-on-l0s-1j0-16597567/branded"
+"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": "104 - Rural"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29876924/519-queenston-road-niagara-on-the-lake-rural-104-rural"
+"ParkingTotal": 10
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 200.6
+"OriginalEntryTimestamp": "2026-06-09T17:27:14.2Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1359976"
+"ListOfficeNationalAssociationId": "1408366"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 42
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29876924')"
+"ID": "1527811"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25293
+post_id: "1502991"
+post_author: 1
+"ListingKey": "29862541"
+"ListingId": "X13249858"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T23:20:03Z"
+"RFModificationTimestamp": "2026-06-30T23:22:07Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Glendale)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "11 KEITH CRESCENT, St. Catharines (Burleigh Hill), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.177269
1 => 43.149597
]
+"Latitude": 43.149597
+"Longitude": -79.177269
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Property is being sold under Power of Sale and in "AS IS" condition. No representations or warranties are made of any kind by the Seller. (id:62783)"
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T23:07:08.558447+00:00"
+"Directions": "Glendale Ave"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2106841"
+"ListOfficeKey": "284780"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "27.3 x 78.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-05T19:30:22Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T23:10:38Z"
+"Stories": "2.0"
+"StreetName": "Keith"
+"StreetNumber": "11"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "3466.75"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"CityRegion": "107 - Glendale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29862541/11-keith-crescent-niagara-on-the-lake-glendale-107-glendale"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 27.3
+"OriginalEntryTimestamp": "2026-06-05T19:30:22Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1375881"
+"ListOfficeNationalAssociationId": "1344707"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 46
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29862541')"
+"ID": "1502991"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25288
+post_id: "1500291"
+post_author: 1
+"ListingKey": "29860436"
+"ListingId": "40831343"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-16T19:00:01Z"
+"RFModificationTimestamp": "2026-07-16T19:05:11Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1543.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "11 KEITH Crescent, Niagara-on-the-Lake, Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.1764381
1 => 43.1482078
]
+"Latitude": 43.1482078
+"Longitude": -79.1764381
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Property being sold under Power of Sale and in AS IS condition. No representations or warranties are made of any kind by the Seller. (id:62650)"
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T17:39:27.695052+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1829888"
+"ListOfficeKey": "284640"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Shared Driveway"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-16T18:51:41Z"
+"PhotosCount": 27
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-16T18:51:41Z"
+"Stories": "2.0"
+"StreetName": "KEITH"
+"StreetNumber": "11"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "107 - Glendale"
+"TaxAnnualAmount": "3466.75"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29860436/11-keith-crescent-niagara-on-the-lake"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1756268"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1525374"
+"CoListOfficeKey": "262629"
+"GeocodeManualYN": true
+"CoListOfficeKey2": "262629"
+"ZoningDescription": "RM5"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 27.0
+"AboveGradeFinishedArea": 1543
+"OriginalEntryTimestamp": "2026-06-05T16:11:45.33Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1195588"
+"ListOfficeNationalAssociationId": "1344651"
+"CoListAgentNationalAssociationId": "1183377"
+"CoListAgentNationalAssociationId2": "1064262"
+"CoListOfficeNationalAssociationId": "1223032"
+"CoListOfficeNationalAssociationId2": "1223032"
+"Media": array:27 [
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]
]
+"DaysOnMarket": 46
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860436')"
+"ID": "1500291"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23538
+post_id: "1486213"
+post_author: 1
+"ListingKey": "29839979"
+"ListingId": "X13227958"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T16:40:35Z"
+"RFModificationTimestamp": "2026-06-02T18:15:58Z"
+"ListPrice": 868000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Glendale)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "412 WRIGHT CRESCENT, Niagara-on-the-Lake (Glendale), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.1710564
1 => 43.1496667
]
+"Latitude": 43.1496667
+"Longitude": -79.1710564
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Fabulous detached 2-storey home on a premium 60' x 137' lot backing directly onto the Royal Niagara Golf Course! A grand foyer leads into a light-filled, spacious layout featuring a sunken family room with a fireplace and a gourmet kitchen with abundant cupboard space and a walk-out to the backyard. Enjoy multiple outdoor living areas, including a welcoming front porch and a second-floor terrace. The upper level boasts 4 large bedrooms, highlighted by a primary suite with double doors and a spa-like ensuite. The fully finished lower level offers an ideal in-law suite setup, complete with two additional large bedrooms, a 4-piece bath, and a kitchenette. Incredible location just down the street from the Niagara Outlets, world-class wineries, Niagara Falls, and quick access to the QEW. (id:62783)"
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T18:15:43.562263+00:00"
+"Directions": "Cross Streets: Glendale & Taylor. ** Directions: Near Royal Niagara Golf Course."
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fenced yard"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1964364"
+"ListOfficeKey": "282967"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "Gazebo"
]
+"LotSizeDimensions": "60 x 137.8 FT"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T16:33:18Z"
+"PhotosCount": 18
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-02T16:33:18Z"
+"Stories": "2.0"
+"StreetName": "Wright"
+"StreetNumber": "412"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "7213.01"
+"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": "Toronto"
+"CityRegion": "107 - Glendale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29839979/412-wright-crescent-niagara-on-the-lake-glendale-107-glendale"
+"ParkingTotal": 8
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 3000
+"LivingAreaMinimum": 2500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-02T16:33:18.32Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1253112"
+"ListOfficeNationalAssociationId": "1323141"
+"Media": array:18 [
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]
]
+"DaysOnMarket": 49
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839979')"
+"ID": "1486213"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25296
+post_id: "1457178"
+post_author: 1
+"ListingKey": "29799285"
+"ListingId": "X13168676"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-24T19:00:10Z"
+"RFModificationTimestamp": "2026-06-26T01:06:09Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Glendale)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "36 HAYNES COURT, Niagara-on-the-Lake (Glendale), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.174735
1 => 43.149634
]
+"Latitude": 43.149634
+"Longitude": -79.174735
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Beautiful 2-storey semi-detached home in Niagara-on-the-Lake, ideally situated in a family-friendly neighbourhood surrounded by parks, walking trails, and green space. Located on a quiet dead-end street, this home is just steps from Niagara-on-the-Green Park and its basketball court, offering the perfect setting for families to enjoy an active outdoor lifestyle. You are also within walking distance to Niagara College Daniel J. Patterson Campus, with the Niagara Escarpment and Royal Niagara Golf Club nearby. Inside, the main floor features a spacious kitchen and dining area with walkout access to a private deck, pergola, and garden shed, along with a bright and inviting living room complete with a cozy gas fireplace. Upstairs, you will find three generously sized bedrooms, including a primary retreat with a large walk-in closet and ensuite featuring a separate shower and soaker tub. The additional bedrooms are bright, spacious, and well-suited for a growing family. The finished basement adds even more versatility with two bedrooms, an office, and a 4-piece bathroom. Complete with a one-car garage and driveway parking, this home is also just minutes from the outlet mall, major highways, and all the attractions of Niagara Falls. A fantastic opportunity for families, first-time buyers, or investors alike. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Blinds"
7 => "Furniture"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-25T16:43:20.965036+00:00"
+"Directions": "Cross Streets: Glendale Rd. & Taylor Rd. ** Directions: QEW to Regional Rd 89/Glendale Ave. exit and turn onto Haynes Crt."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1894363"
+"ListOfficeKey": "51280"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Carpet Free"
1 => "Sump Pump"
]
+"LotSizeDimensions": "25.1 x 113.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-25T14:51:20Z"
+"PhotosCount": 20
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-24T18:54:27Z"
+"Stories": "2.0"
+"StreetName": "Haynes"
+"StreetNumber": "36"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "3980.8"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"CityRegion": "107 - Glendale"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29799285/36-haynes-court-niagara-on-the-lake-glendale-107-glendale"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Separate Electricity Meters"
1 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 25.1
+"OriginalEntryTimestamp": "2026-05-25T14:51:19.65Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1213466"
+"ListOfficeNationalAssociationId": "1003016"
+"Media": array:20 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
]
+"DaysOnMarket": 57
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29799285')"
+"ID": "1457178"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25297
+post_id: "1446207"
+post_author: 1
+"ListingKey": "29782084"
+"ListingId": "X13153608"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-24T12:05:21Z"
+"RFModificationTimestamp": "2026-05-24T12:09:29Z"
+"ListPrice": 999900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (Glendale)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "196 WARNER ROAD, Niagara-on-the-Lake (Glendale), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.1446274
1 => 43.1459251
]
+"Latitude": 43.1459251
+"Longitude": -79.1446274
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to 196 Warner Road, Niagara-on-the-Lake! Situated on just shy of an acre, this property offers privacy, space, and the feeling of escaping it all without sacrificing convenience. This beautifully maintained home features 3 bedrooms and 2 bathrooms on the main level. The open-concept main floor showcases a gorgeous kitchen, fully renovated in 2021, featuring a peninsula island, formal dining area, and cozy living room with two walkouts to the terrace running the entire width of the home, the perfect place to enjoy your morning coffee or unwind at the end of the day. Off the kitchen, you'll also find convenient access to a fully enclosed dog patio and clothesline area.The spacious primary suite complete with 2 closets and ensuite also has its own access to the terrace.The lower level offers a large rec room featuring a wood-burning fireplace and sliding glass doors leading to a versatile three-season sunroom. Additional space includes a generous laundry room with updated flooring (2025), a 3-piece bathroom, and office area, offering flexibility for growing families, hobbies, or work-from-home needs.The backyard is truly something special. Beautifully landscaped and thoughtfully designed, it features space for a home garden, chicken coop, playground, storage sheds, and even a charming pond complete with a small bridge. Recent updates also include: new front porch and parging (2025), updated basement flooring (2025), new weeping tile(2024), and a new window above the front entry (2025). The home is also equipped with a UV water treatment system for added confidence and convenience.This is the Canadian dream, grow your own fruits and vegetables, collect fresh eggs, and enjoy the peace and privacy of country living, all while being just a short drive to Niagara College, the Outlet Collection, White Oaks gym, the QEW, Niagara Falls, and everyday amenities. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Water Treatment"
6 => "Hood Fan"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk out"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-21T13:51:12.183140+00:00"
+"Directions": "Cross Streets: Mountain Road and Taylor Road. ** Directions: Heading West on Mountain Road from QEW, turn North onto Garner road, then right onto Warner Road."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2145199"
+"ListOfficeKey": "282726"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "210.5 x 200.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-21T18:30:51Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Septic System"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-05-24T11:56:39Z"
+"Stories": "1.0"
+"StreetName": "Warner"
+"StreetNumber": "196"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5708.5"
+"ListAOR": "Niagara"
+"TaxYear": 2026
+"CityRegion": "107 - Glendale"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29782084/196-warner-road-niagara-on-the-lake-glendale-107-glendale"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 210.6
+"OriginalEntryTimestamp": "2026-05-21T13:26:26.55Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1396614"
+"ListOfficeNationalAssociationId": "1320650"
+"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": 62
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29782084')"
+"ID": "1446207"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 14
+after_key: ""
}
"RF Response Time" => "0.19 seconds"
]
]