array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 30017245 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23469
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23471
+post_id: "1613483"
+post_author: 1
+"ListingKey": "30017245"
+"ListingId": "40846523"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T16:10:01Z"
+"RFModificationTimestamp": "2026-07-10T16:45:13Z"
+"ListPrice": 1225000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2986.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1P0"
+"UnparsedAddress": "24 RED HAVEN Drive, Niagara-on-the-Lake, Ontario L0S1P0"
+"Coordinates": array:2 [
0 => -79.1060309
1 => 43.150979
]
+"Latitude": 43.150979
+"Longitude": -79.1060309
+"YearBuilt": 2007
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Inspired by the signature elegance of interior designer Jillian Harris, this extraordinary open-concept residence redefines luxury living in the heart of Wine Country. A one-owner custom masterpiece designed by an award-winning architect, this exceptional residence has been impeccably transformed through extensive, high-end renovations completed in 2026. From the moment you enter, soaring 18-foot ceilings and the grand open-to-below design create a breathtaking sense of scale and light, extending seamlessly from the front to the back of the home. A dramatic central catwalk overlooks the expansive living space, while refined designer finishes, rich hardwood flooring, elegant porcelain tile, and a thoughtfully curated open-concept layout deliver a sophisticated yet welcoming atmosphere. At the heart of the home, the chef-inspired kitchen is designed to impress, featuring a massive statement island, stunning quartz countertops, premium finishes, and exceptional space for entertaining and everyday living. Offering 4 spacious bedrooms and 3.5 beautifully appointed bathrooms, this residence perfectly balances luxury, comfort, and functionality. The upper-level primary retreat is a private sanctuary complete with a spa-inspired ensuite and an oversized walk-in closet spacious enough to accommodate a private office. Positioned across the catwalk, two additional bedrooms provide an ideal layout for family privacy and comfort. The fully finished basement further expands the living space with additional bedrooms and versatile areas perfect for guests, recreation, or multi-generational living. Step outside to your own private backyard oasis, where an expansive deck creates the ultimate setting for seamless indoor-outdoor living and entertaining. Completing this remarkable property is an oversized 3-car garage complementing the striking Hollywood-inspired exterior with exceptional curb appeal. This is a rare opportunity to own a truly turnkey luxury home. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T16:44:57.083524+00:00"
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Other"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"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-07-10T15:48:15Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T15:48:15Z"
+"Stories": "2.0"
+"StreetName": "RED HAVEN"
+"StreetNumber": "24"
+"StreetSuffix": "Drive"
+"SubdivisionName": "105 - St. Davids"
+"TaxAnnualAmount": "6866.8"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/1VLKPhDXvNs?si=-rCLxyI2NJv-LlgN"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [
"RoomKey" => "1680097001"
"RoomType" => "4pc Bathroom"
"ListingId" => "40846523"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.17Z"
]
1 => array:11 [
"RoomKey" => "1680097003"
"RoomType" => "Storage"
"ListingId" => "40846523"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.17Z"
]
2 => array:11 [
"RoomKey" => "1680097004"
"RoomType" => "Utility room"
"ListingId" => "40846523"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 7'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.17Z"
]
3 => array:11 [
"RoomKey" => "1680097005"
"RoomType" => "Bedroom"
"ListingId" => "40846523"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 16'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
4 => array:11 [
"RoomKey" => "1680097006"
"RoomType" => "3pc Bathroom"
"ListingId" => "40846523"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
5 => array:11 [
"RoomKey" => "1680097007"
"RoomType" => "Family room"
"ListingId" => "40846523"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 35'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
6 => array:11 [
"RoomKey" => "1680097008"
"RoomType" => "Bedroom"
"ListingId" => "40846523"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "9'6'' x 13'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
7 => array:11 [
"RoomKey" => "1680097009"
"RoomType" => "Bedroom"
"ListingId" => "40846523"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
8 => array:11 [
"RoomKey" => "1680097010"
"RoomType" => "5pc Bathroom"
"ListingId" => "40846523"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
9 => array:11 [
"RoomKey" => "1680097011"
"RoomType" => "Primary Bedroom"
"ListingId" => "40846523"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 17'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
10 => array:11 [
"RoomKey" => "1680097012"
"RoomType" => "Laundry room"
"ListingId" => "40846523"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
11 => array:11 [
"RoomKey" => "1680097013"
"RoomType" => "2pc Bathroom"
"ListingId" => "40846523"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
12 => array:11 [
"RoomKey" => "1680097014"
"RoomType" => "Dining room"
"ListingId" => "40846523"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "15'2'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
13 => array:11 [
"RoomKey" => "1680097015"
"RoomType" => "Kitchen"
"ListingId" => "40846523"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 13'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
14 => array:11 [
"RoomKey" => "1680097016"
"RoomType" => "Living room"
"ListingId" => "40846523"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 16'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
15 => array:11 [
"RoomKey" => "1680097017"
"RoomType" => "Foyer"
"ListingId" => "40846523"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "30017245"
"RoomLength" => null
"RoomDimensions" => "9'7'' x 15'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-10T15:48:15.18Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30017245/24-red-haven-drive-niagara-on-the-lake"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 69.0
+"AboveGradeFinishedArea": 2249
+"BelowGradeFinishedArea": 737
+"OriginalEntryTimestamp": "2026-07-10T15:48:15.13Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1178468"
+"ListOfficeNationalAssociationId": "1472476"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30017245_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/8a51aeb6bc138ba9af07105690eb95b9.webp"
"MediaSize" => 106844
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-8a51aeb6bc138ba9af07105690eb95b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30017245_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/bc95f7591e3e0ac7262cb519d617653e.webp"
"MediaSize" => 164394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-bc95f7591e3e0ac7262cb519d617653e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30017245_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/24ac9b11c0d18f7ffe56fa530276c296.webp"
"MediaSize" => 133123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-24ac9b11c0d18f7ffe56fa530276c296.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30017245_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/0f7e124b59e0ba7895be43f5c9530e93.webp"
"MediaSize" => 105734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-0f7e124b59e0ba7895be43f5c9530e93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "30017245_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/db4b99223161c5d26c2997b6b3720e86.webp"
"MediaSize" => 143463
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-db4b99223161c5d26c2997b6b3720e86.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "30017245_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/6f4b179e6e777a4241199486b565c404.webp"
"MediaSize" => 154379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-6f4b179e6e777a4241199486b565c404.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "30017245_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/1ef7f7a42081e56154bf766ef51a37c7.webp"
"MediaSize" => 79230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-1ef7f7a42081e56154bf766ef51a37c7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "30017245_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/b3a281c026623075102731a631ef80b5.webp"
"MediaSize" => 87949
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-b3a281c026623075102731a631ef80b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "30017245_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/4acf9a7bd71eeb065e049cac4b8ab38a.webp"
"MediaSize" => 85771
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-4acf9a7bd71eeb065e049cac4b8ab38a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "30017245_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/44e940167eb846ed7d3da74368f9b0fe.webp"
"MediaSize" => 82480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-44e940167eb846ed7d3da74368f9b0fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "30017245_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/eacb3993dd9ca32fc765a28edd73ce74.webp"
"MediaSize" => 70944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-eacb3993dd9ca32fc765a28edd73ce74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "30017245_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/650a08acdb8fa2b1046dcf17b9a04b1d.webp"
"MediaSize" => 78796
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-650a08acdb8fa2b1046dcf17b9a04b1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "30017245_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/0a732ae17385991baaf98ed00d3912b3.webp"
"MediaSize" => 66963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-0a732ae17385991baaf98ed00d3912b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "30017245_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/4cf3b0f152873bea2d2b1ec98bf31b9d.webp"
"MediaSize" => 80039
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-4cf3b0f152873bea2d2b1ec98bf31b9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "30017245_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/4661d21f8d1ba48a4f12cdb3f09c516e.webp"
"MediaSize" => 89582
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-4661d21f8d1ba48a4f12cdb3f09c516e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "30017245_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/a4eb10cc6bb2ea24ab62d3ddb858574b.webp"
"MediaSize" => 67333
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-a4eb10cc6bb2ea24ab62d3ddb858574b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "30017245_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/215237f0e1756992aba56be525ed4048.webp"
"MediaSize" => 55613
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-215237f0e1756992aba56be525ed4048.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "30017245_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/d4d2566756150fdf0e415508fa67d02f.webp"
"MediaSize" => 69695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-d4d2566756150fdf0e415508fa67d02f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "30017245_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/598f10bd863dc725ed8b7276452f7d6b.webp"
"MediaSize" => 79810
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-598f10bd863dc725ed8b7276452f7d6b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "30017245_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/8b4a55f59885caaca86183ec93babddc.webp"
"MediaSize" => 82762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-8b4a55f59885caaca86183ec93babddc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "30017245_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/95edcab92574d49637e59111f160e6ef.webp"
"MediaSize" => 85199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-95edcab92574d49637e59111f160e6ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "30017245_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/58e9716cfb43b2ed843879ca0fc28f12.webp"
"MediaSize" => 71997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-58e9716cfb43b2ed843879ca0fc28f12.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "30017245_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/b1ff5f990341e5cc7b483c0f988787c5.webp"
"MediaSize" => 64604
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-b1ff5f990341e5cc7b483c0f988787c5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "30017245_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/91ae2aa2d0c21120d1d528f6e30e5376.webp"
"MediaSize" => 65415
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-91ae2aa2d0c21120d1d528f6e30e5376.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "30017245_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/9ad50a32e3c8e17259076be4a2d7d60d.webp"
"MediaSize" => 50409
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-9ad50a32e3c8e17259076be4a2d7d60d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "30017245_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/89b8765a423fdb1fd8cd1dc940a8ac49.webp"
"MediaSize" => 70334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-89b8765a423fdb1fd8cd1dc940a8ac49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "30017245_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/c3de7bf9f31c7c52b4fbc33bfdf8e7d4.webp"
"MediaSize" => 60223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-c3de7bf9f31c7c52b4fbc33bfdf8e7d4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "30017245_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/cda68a21a5bfbf8a0f385f2c9fa3d6a7.webp"
"MediaSize" => 77668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-cda68a21a5bfbf8a0f385f2c9fa3d6a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "30017245_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/c15819fa6ddfe728f7c942080805e364.webp"
"MediaSize" => 49080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-c15819fa6ddfe728f7c942080805e364.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "30017245_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/eb2e92d7d7240d8b974bc0ad5f4927b0.webp"
"MediaSize" => 79191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-eb2e92d7d7240d8b974bc0ad5f4927b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "30017245_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/5a1af1cf6de8cfe9bccda265b1f3fc72.webp"
"MediaSize" => 61334
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-5a1af1cf6de8cfe9bccda265b1f3fc72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "30017245_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/367dd21e692ee377d7f140fdaeb9d4ce.webp"
"MediaSize" => 74198
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-367dd21e692ee377d7f140fdaeb9d4ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "30017245_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/02340b185acbc95a4f03b6185529538c.webp"
"MediaSize" => 70200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-02340b185acbc95a4f03b6185529538c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "30017245_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/de8a5777028c487464d812ccd9c26a69.webp"
"MediaSize" => 72864
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-de8a5777028c487464d812ccd9c26a69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "30017245_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/a5b8fbd1b691f8264646a08ecfbe1f70.webp"
"MediaSize" => 69140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-a5b8fbd1b691f8264646a08ecfbe1f70.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "30017245_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/d396305075cf20585d98f68a44598e6e.webp"
"MediaSize" => 86038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-d396305075cf20585d98f68a44598e6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "30017245_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/a21cc53ebc5ca25db0f0069412675744.webp"
"MediaSize" => 84058
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-a21cc53ebc5ca25db0f0069412675744.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "30017245_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/43a6989221198669a21e5977d1d1a1fa.webp"
"MediaSize" => 88965
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-43a6989221198669a21e5977d1d1a1fa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "30017245_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/f579e0148833228c2db4f7b8affb9265.webp"
"MediaSize" => 161429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-f579e0148833228c2db4f7b8affb9265.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "30017245_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/80341767b42d5e90b45d36974043f9c0.webp"
"MediaSize" => 175828
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-80341767b42d5e90b45d36974043f9c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "30017245_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/b01e79af7ee02a0adc40f159ab20637b.webp"
"MediaSize" => 152842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-b01e79af7ee02a0adc40f159ab20637b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "30017245_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/00b4e9dee29e861a5f1c4329533ba944.webp"
"MediaSize" => 151716
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-00b4e9dee29e861a5f1c4329533ba944.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "30017245_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/33f1d64f19d5c23d70dae83a8bf47fc0.webp"
"MediaSize" => 142410
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-33f1d64f19d5c23d70dae83a8bf47fc0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "30017245_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017245/d4165904d0ac9ae8e33fde438fa0cb30.webp"
"MediaSize" => 186945
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017245/thumbnail-d4165904d0ac9ae8e33fde438fa0cb30.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40846523"
"ResourceRecordKey" => "30017245"
"ModificationTimestamp" => "2026-07-10T15:48:15.14Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017245')"
+"ID": "1613483"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeKey eq 299401" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24990
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24935
+post_id: ? mixed
+post_author: ? mixed
+"OfficeName": "RE/MAX Niagara Realty Ltd."
+"OfficeEmail": null
+"OfficePhone": "905-687-9600"
+"OfficeMlsId": "HBREMAXNIAST"
+"ModificationTimestamp": "2026-02-17T23:15:03Z"
+"OriginatingSystemName": "CREA"
+"OfficeKey": "299401"
+"IDXOfficeParticipationYN": null
+"MainOfficeKey": null
+"MainOfficeMlsId": null
+"OfficeAddress1": "261 Martindale Rd 12A"
+"OfficeAddress2": null
+"OfficeBrokerKey": null
+"OfficeCity": "St.Catharines"
+"OfficePostalCode": "L2W1A"
+"OfficePostalCodePlus4": null
+"OfficeStateOrProvince": "Ontario"
+"OfficeStatus": "Active"
+"OfficeAOR": "Cornerstone"
+"OfficeType": "Firm"
+"OfficePhoneExt": null
+"OfficeNationalAssociationId": "1472476"
+"OriginalEntryTimestamp": "2024-11-19T16:10:00Z"
+"OfficeAORKey": "14"
+"OfficeCountry": "Canada"
+"OfficeSocialMedia": array:1 [
0 => array:6 [
"ResourceName" => "Office"
"SocialMediaKey" => "439733"
"SocialMediaType" => "Website"
"ResourceRecordKey" => "299401"
"SocialMediaUrlOrId" => "https://www.rmxniagara.com/"
"ModificationTimestamp" => "2026-02-05T18:57:00Z"
]
]
+"FranchiseNationalAssociationId": "1183864"
+"OfficeBrokerNationalAssociationId": "1178468"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Office('299401')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1738832" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24886
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '30017245'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25300
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '30017245' AND OpenHouseDate ge '2026-07-10'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '30017245' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-79.1060309 43.150979)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25427
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25421
+post_id: "1613706"
+post_author: 1
+"ListingKey": "30017516"
+"ListingId": "X13549028"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T16:50:01Z"
+"RFModificationTimestamp": "2026-07-10T19:09:32Z"
+"ListPrice": 1225000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (St. Davids)"
+"PostalCode": "L0S1P0"
+"UnparsedAddress": "24 RED HAVEN DRIVE, Niagara-on-the-Lake (St. Davids), Ontario L0S1P0"
+"Coordinates": array:2 [
0 => -79.106241
1 => 43.150238
]
+"Latitude": 43.150238
+"Longitude": -79.106241
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Inspired by the signature elegance of interior designer Jillian Harris, this extraordinary open-concept residence redefines luxury living in the heart of Wine Country. A one-owner custom masterpiece designed by an award-winning architect, this exceptional residence has been impeccably transformed through extensive, high-end renovations completed in 2026. From the moment you enter, soaring 18-foot ceilings and the grand open-to-below design create a breathtaking sense of scale and light, extending seamlessly from the front to the back of the home. A dramatic central catwalk overlooks the expansive living space, while refined designer finishes, rich hardwood flooring, elegant porcelain tile, and a thoughtfully curated open-concept layout deliver a sophisticated yet welcoming atmosphere. At the heart of the home, the chef-inspired kitchen is designed to impress, featuring a massive statement island, stunning quartz countertops, premium finishes, and exceptional space for entertaining and everyday living. Offering 4 spacious bedrooms and 3.5 beautifully appointed bathrooms, this residence perfectly balances luxury, comfort, and functionality. The upper-level primary retreat is a private sanctuary complete with a spa-inspired ensuite and an oversized walk-in closet spacious enough to accommodate a private office. Positioned across the catwalk, two additional bedrooms provide an ideal layout for family privacy and comfort. The fully finished basement further expands the living space with additional bedrooms and versatile areas perfect for guests, recreation, or multi-generational living. Step outside to your own private backyard oasis, where an expansive deck creates the ultimate setting for seamless indoor-outdoor living and entertaining. Completing this remarkable property is an oversized 3-car garage complementing the striking Hollywood-inspired exterior with exceptional curb appeal. This is a rare opportunity to own a truly turnkey luxury home. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-10T19:09:22.461207+00:00"
+"Directions": "FOUR MILE CREEK - CREEKSIDE - RED HAVEN"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Stucco"
]
+"FireplaceYN": true
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2180143"
+"ListOfficeKey": "271450"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "68.9 x 97.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-10T16:25:13Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T16:25:13Z"
+"Stories": "2.0"
+"StreetName": "Red Haven"
+"StreetNumber": "24"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6866.8"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/1VLKPhDXvNs?si=-rCLxyI2NJv-LlgN"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Niagara"
+"CityRegion": "105 - St. Davids"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/30017516/24-red-haven-drive-niagara-on-the-lake-st-davids-105-st-davids"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1738832"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283840"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 68.1
+"OriginalEntryTimestamp": "2026-07-10T16:25:13.54Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1430037"
+"ListOfficeNationalAssociationId": "1239071"
+"CoListAgentNationalAssociationId": "1178468"
+"CoListOfficeNationalAssociationId": "1335712"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "30017516_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017516/1bb7616b9ed891460c739460b37616d0.webp"
"MediaSize" => 377237
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017516/thumbnail-1bb7616b9ed891460c739460b37616d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13549028"
"ResourceRecordKey" => "30017516"
"ModificationTimestamp" => "2026-07-10T16:25:13.55Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "30017516_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017516/b367d28dd8c247d5131a8f7e67edae46.webp"
"MediaSize" => 249108
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017516/thumbnail-b367d28dd8c247d5131a8f7e67edae46.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549028"
"ResourceRecordKey" => "30017516"
"ModificationTimestamp" => "2026-07-10T16:25:13.55Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "30017516_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017516/8bcb465a16925fd5b8954152efff0fc1.webp"
"MediaSize" => 341456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017516/thumbnail-8bcb465a16925fd5b8954152efff0fc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549028"
"ResourceRecordKey" => "30017516"
"ModificationTimestamp" => "2026-07-10T16:25:13.55Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "30017516_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/30017516/51d7cfadade2c11d42787655ed6ed445.webp"
"MediaSize" => 270583
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/30017516/thumbnail-51d7cfadade2c11d42787655ed6ed445.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13549028"
"ResourceRecordKey" => "30017516"
…1
]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30017516')"
+"ID": "1613706"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25423
+post_id: "1610577"
+post_author: 1
+"ListingKey": "30013125"
+"ListingId": "X13544786"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T00:45:03Z"
+"RFModificationTimestamp": "2026-07-11T00:45:48Z"
+"ListPrice": 1449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake (St. Davids)"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "75 MILLPOND ROAD, Niagara-on-the-Lake (St. Davids), Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.101035
1 => 43.163163
]
+"Latitude": 43.163163
+"Longitude": -79.101035
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 75 Millpond Road, an exceptional custom-built bungalow by DRT Homes, ideally situated on one of the most prestigious streets in the charming village of St. Davids. Offering almost 3000 sq. ft. of beautifully finished living space, this elegant residence blends timeless craftsmanship with modern comfort. A grand foyer with custom wainscoting welcomes you into the impressive great room, where soaring 20-foot ceilings and a striking floor-to-ceiling tiled fireplace create a spectacular focal point. The thoughtfully designed main level features a spacious primary retreat complete with a walk-in closet and luxurious ensuite, a second bedroom currently configured as a home office with its own 3-piece bath, and a bright, designer kitchen finished with premium cabinetry, quality countertops, and upscale finishes. Step outside to a covered patio overlooking professionally landscaped grounds, creating the perfect space for outdoor entertaining or quiet relaxation. The fully finished lower level offers exceptional additional living space, including a large recreation room, stylish bar and kitchenette with stone countertops, an additional bedroom, a full bathroom, and a generous home gym. Located in one of Niagara's most sought-after communities, Millpond Road is renowned for its executive homes and tranquil setting, all within walking distance to Ravine Vineyard Estate Winery, boutique cafés, restaurants, and the picturesque village of St. Davids. Just minutes from historic Old Town Niagara-on-the-Lake, championship golf courses, the Shaw Festival Theatre, Queen Street's renowned shopping and dining, the Outlet Collection at Niagara, White Oaks Resort, and countless world-class wineries, this location also offers convenient highway access for commuting throughout the Niagara Region, including Niagara Falls and St. Catharines. An outstanding opportunity to own a meticulously crafted home in one of Niagara's most desirable and prestigious neighbourhoods. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:43:23.556589+00:00"
+"Directions": "York Road & Creek Road"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"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": "2095008"
+"ListOfficeKey": "284792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level lot"
1 => "Carpet Free"
]
+"LotSizeDimensions": "44.6 x 110.8 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T19:10:55Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-11T00:35:16Z"
+"Stories": "1.0"
+"StreetName": "Millpond"
+"StreetNumber": "75"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "7157.27"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019f3d2f-68b5-7396-ae80-067f734a4581"
+"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": "Toronto"
+"CityRegion": "105 - St. Davids"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30013125/75-millpond-road-niagara-on-the-lake-st-davids-105-st-davids"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 44.7
+"OriginalEntryTimestamp": "2026-07-09T19:10:55.66Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1367251"
+"ListOfficeNationalAssociationId": "1344891"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30013125')"
+"ID": "1610577"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25420
+post_id: "1611612"
+post_author: 1
+"ListingKey": "30012434"
+"ListingId": "40846777"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-11T00:05:21Z"
+"RFModificationTimestamp": "2026-07-11T00:07:10Z"
+"ListPrice": 1449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2680.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "75 MILLPOND Road, Niagara-on-the-Lake, Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.1009765
1 => 43.1631673
]
+"Latitude": 43.1631673
+"Longitude": -79.1009765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 75 Millpond Road, an exceptional custom-built bungalow by DRT Homes, ideally situated on one of the most prestigious streets in the charming village of St. Davids. Offering almost 3000 sq. ft. of beautifully finished living space, this elegant residence blends timeless craftsmanship with modern comfort. A grand foyer with custom wainscoting welcomes you into the impressive great room, where soaring 20-foot ceilings and a striking floor-to-ceiling tiled fireplace create a spectacular focal point. The thoughtfully designed main level features a spacious primary retreat complete with a walk-in closet and luxurious ensuite, a second bedroom currently configured as a home office with its own 3-piece bath, and a bright, designer kitchen finished with premium cabinetry, quality countertops, and upscale finishes. Step outside to a covered patio overlooking professionally landscaped grounds, creating the perfect space for outdoor entertaining or quiet relaxation. The fully finished lower level offers exceptional additional living space, including a large recreation room, stylish bar and kitchenette with stone countertops, an additional bedroom, a full bathroom, and a generous home gym. Located in one of Niagara's most sought-after communities, Millpond Road is renowned for its executive homes and tranquil setting, all within walking distance to Ravine Vineyard Estate Winery, boutique cafés, restaurants, and the picturesque village of St. Davids. Just minutes from historic Old Town Niagara-on-the-Lake, championship golf courses, the Shaw Festival Theatre, Queen Street's renowned shopping and dining, the Outlet Collection at Niagara, White Oaks Resort, and countless world-class wineries, this location also offers convenient highway access for commuting throughout the Niagara Region, including Niagara Falls and St. Catharines. An outstanding opportunity to own a meticulously crafted home in one of Niagara's most desirable and prestigious neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Range - Gas"
4 => "Dishwasher"
5 => "Wine Fridge"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T19:02:12.887362+00:00"
+"Directions": "York Rd to Four Mile Creek Rd to Millpond Rd"
+"ExteriorFeatures": array:3 [
0 => "Stucco"
1 => "Vinyl siding"
2 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524404"
+"ListOfficeKey": "284635"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T17:59:19Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T23:58:42Z"
+"Stories": "1.0"
+"StreetName": "MILLPOND"
+"StreetNumber": "75"
+"StreetSuffix": "Road"
+"SubdivisionName": "105 - St. Davids"
+"TaxAnnualAmount": "7157.27"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019f3d2f-68b5-7396-ae80-067f734a4581"
+"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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30012434/75-millpond-road-niagara-on-the-lake"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "RD-17"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 1387
+"BelowGradeFinishedArea": 1293
+"OriginalEntryTimestamp": "2026-07-09T17:59:19.18Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1101491"
+"ListOfficeNationalAssociationId": "1344652"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30012434')"
+"ID": "1611612"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25424
+post_id: "1609210"
+post_author: 1
+"ListingKey": "30010790"
+"ListingId": "X13542818"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T15:15:08Z"
+"RFModificationTimestamp": "2026-07-09T15:43:39Z"
+"ListPrice": 934900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara Falls (Stamford)"
+"PostalCode": "L2E6S4"
+"UnparsedAddress": "6398 MOUNTAIN ROAD, Niagara Falls (Stamford), Ontario L2E6S4"
+"Coordinates": array:2 [
0 => -79.103945
1 => 43.136271
]
+"Latitude": 43.136271
+"Longitude": -79.103945
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Rare opportunities like this do not come up often in the heart of Stamford. Set on an impressive 0.81-acre lot with 80 feet of frontage and an incredible 463.70 feet of depth, this meticulously maintained 3-bedroom brick bungalow offers over 1,100 sq. ft. of main floor living, along with the space, privacy, and potential that are becoming increasingly difficult to find. Whether you're a first-time buyer, looking for room to grow, or searching for a smart long-term investment, this property checks all the boxes. The warm and functional layout is move-in ready while offering plenty of opportunity to update and personalize over time. The basement features a bathroom that is nearly complete, providing the future potential for 2 full bathrooms and 3 bedrooms, adding even greater flexibility for additional living space or family needs. Step outside and discover what truly sets this property apart. The expansive lot provides endless possibilities for entertaining, gardening, recreation, or simply enjoying the peaceful surroundings. Tucked away on the property is a charming greenhouse retreat paired with a hot tub, creating the perfect place to relax and unwind. A 1.5-car garage adds everyday convenience with ample storage. Properties offering this much land, this much frontage, and this much potential in one of Stamford's most sought-after locations are few and far between. Move in and enjoy it today, renovate to match your vision, or hold it as a valuable long-term investment. Opportunities like this don't come around often. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T15:43:34.125687+00:00"
+"Directions": "Cross Streets: ST. PAUL. ** Directions: ST.PAUL-MOUNTAIN."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Radiant heat"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2021039"
+"ListOfficeKey": "300053"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "80 x 463.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T15:05:50Z"
+"PhotosCount": 44
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T15:05:50Z"
+"Stories": "1.0"
+"StreetName": "Mountain"
+"StreetNumber": "6398"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "5771.33"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"TaxYear": 2025
+"CityRegion": "206 - Stamford"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/30010790/6398-mountain-road-niagara-falls-stamford-206-stamford"
+"ParkingTotal": 7
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2022523"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283409"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 80.0
+"OriginalEntryTimestamp": "2026-07-09T15:05:50.44Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1300859"
+"ListOfficeNationalAssociationId": "1482107"
+"CoListAgentNationalAssociationId": "1302254"
+"CoListOfficeNationalAssociationId": "1328620"
+"Media": array:44 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30010790')"
+"ID": "1609210"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25422
+post_id: "1607790"
+post_author: 1
+"ListingKey": "30009192"
+"ListingId": "40846544"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T23:05:21Z"
+"RFModificationTimestamp": "2026-07-10T23:06:47Z"
+"ListPrice": 975000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2504.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1J0"
+"UnparsedAddress": "326 CONCESSION 3 Road, Niagara-on-the-Lake, Ontario L0S1J0"
+"Coordinates": array:2 [
0 => -79.0959017
1 => 43.162498
]
+"Latitude": 43.162498
+"Longitude": -79.0959017
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This one-of-a-kind home offers breathtaking vineyard and Escarpment views and a rare opportunity to live in the heart of Niagara-on-the-Lake, renowned for its wineries, dining, golf courses, scenic trails, and exceptional lifestyle. Offering over 2,500 sq. ft. above grade, this beautifully upgraded home showcases quality craftsmanship throughout.Step inside through the grand double front doors to a bright, open-concept layout featuring vintage oak engineered hardwood, porcelain tile, smooth ceilings, oversized baseboards, upgraded trim, custom lighting with pot lights, and oak staircases. The inviting living room boasts coffered ceilings and a gas fireplace, while the spacious dining area is perfect for entertaining. The chef-inspired kitchen features Caesarstone quartz countertops, a large island with breakfast bar, custom ceiling-height cabinetry with crown moulding, upgraded built-in stainless steel appliances, a stylish backsplash, and garden doors leading to the private backyard.The second-floor family room opens to a covered balcony with glass railings, creating the perfect place to enjoy the picturesque views. The primary suite offers a sitting area, dual closets, and a luxurious 5-piece ensuite with a freestanding soaker tub and frameless glass shower. Two additional bedrooms feature upgraded Berber carpet and share a full bath, while an open flex space is ideal for a home office.The basement is insulated, drywalled, wired, and includes a second gas fireplace, offering incredible potential for additional living space or an in-law suite with its separate garage entrance. Outside, enjoy a professionally landscaped front entrance, composite deck with privacy panels, fenced yard, upgraded window coverings, UV-protective rear window film, central vacuum, alarm system, double-car garage, two-car driveway, and main-floor laundry. A truly exceptional home in one of Niagara-on-the-Lake's most sought-after vineyard communities. (id:62650)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-09T04:45:08.985515+00:00"
+"Directions": "YORK ROAD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1738832"
+"ListOfficeKey": "299401"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T02:18:11Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T22:58:57Z"
+"Stories": "2.0"
+"StreetName": "CONCESSION 3"
+"StreetNumber": "326"
+"StreetSuffix": "Road"
+"SubdivisionName": "105 - St. Davids"
+"TaxAnnualAmount": "6488.32"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/uE9zuVfQUT0?feature=share"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30009192/326-concession-3-road-niagara-on-the-lake"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-17"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 2504
+"OriginalEntryTimestamp": "2026-07-09T02:18:11.14Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1178468"
+"ListOfficeNationalAssociationId": "1472476"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30009192')"
+"ID": "1607790"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25417
+post_id: "1605953"
+post_author: 1
+"ListingKey": "30005111"
+"ListingId": "X13537442"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T15:50:07Z"
+"RFModificationTimestamp": "2026-07-08T16:10:20Z"
+"ListPrice": 1999999.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara Falls (Stamford)"
+"PostalCode": "L2J4J4"
+"UnparsedAddress": "6496 JANUARY DRIVE, Niagara Falls (Stamford), Ontario L2J4J4"
+"Coordinates": array:2 [
0 => -79.105596
1 => 43.13786
]
+"Latitude": 43.13786
+"Longitude": -79.105596
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 6496 January Drive - a luxurious estate home nestled on a massive lot in one of Niagara's most prestigious and picturesque Calaguiro Estates. Built by Frank Costantino of Costantino Construction Ltd.-a trusted name in Niagara homebuilding since 1976-this timeless 2-storey brick residence has been lovingly maintained by its original owners and showcases a rare combination of scale, craftsmanship, and pride of ownership.Perfectly perched along the Niagara Escarpment, this stately property offers both privacy and grandeur. The home's striking curb appeal is matched by nearly 4,300 sq ft of refined living space, designed for elegant entertaining and comfortable family living. Rich hardwood floors, fireplaces, crown mouldings, and custom finishes create a warm, sophisticated atmosphere throughout.Inside, you'll find multiple gathering areas, a modern kitchen, private office, solarium, and a separate entrance leading to a fully finished lower level with a second kitchen, living/dining room, family room, bedroom, and cantina-ideal for multi-generational living or long-term guests. With five spacious bedrooms, abundant storage, and seamless indoor-outdoor flow, the layout is both functional and flexible. Walls are all plaster, solid wood doors, windows replaced, newer roof, newer garage doors.Set on a beautifully landscaped, pool-sized lot surrounded by mature trees, this is more than just a home-it's an address. Located in a neighborhood known for its winding streets, breathtaking views, and custom homes, and just moments from a nearby golf course, 6496 January Drive offers a rare opportunity to own a piece of enduring Niagara luxury. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Central Vacuum"
2 => "Dishwasher"
3 => "Oven"
4 => "Dryer"
5 => "Cooktop"
6 => "Two stoves"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Two Refrigerators"
]
+"Basement": array:2 [
0 => "Separate entrance"
1 => "N/A"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-08T16:10:05.758969+00:00"
+"Directions": "MOUNTAIN ROAD & JANUARY DRIVE"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1888427"
+"ListOfficeKey": "50929"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "121.4 x 182.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-08T15:42:19Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-08T15:42:19Z"
+"Stories": "2.0"
+"StreetName": "January"
+"StreetNumber": "6496"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "14231.4"
+"VirtualTourURLUnbranded": "https://tours.vision360tours.ca/6496-january-drive-niagara-falls/nb/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"CityRegion": "206 - Stamford"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/30005111/6496-january-drive-niagara-falls-stamford-206-stamford"
+"ParkingTotal": 12
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 121.4
+"OriginalEntryTimestamp": "2026-07-08T15:42:18.99Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1210246"
+"ListOfficeNationalAssociationId": "1003013"
+"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": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30005111')"
+"ID": "1605953"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23483
+post_id: "1601549"
+post_author: 1
+"ListingKey": "30001831"
+"ListingId": "40845678"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-10T22:15:46Z"
+"RFModificationTimestamp": "2026-07-10T22:20:22Z"
+"ListPrice": 1089000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3377.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1J1"
+"UnparsedAddress": "965 LINE 9 Road, Niagara-on-the-Lake, Ontario L0S1J1"
+"Coordinates": array:2 [
0 => -79.0978049
1 => 43.1657154
]
+"Latitude": 43.1657154
+"Longitude": -79.0978049
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully maintained stone and brick two-storey home, with over 3300 sq ft of finished living space making it the largest home in the complex. Situated across from picturesque views, offering complete serenity and the perfect setting to enjoy your morning coffee from the inviting front porch. Featuring a spacious double-car garage and oversized driveway, this impressive residence combines style, comfort, and functionality for a large single family or multi-generational family living. Inside, a generous formal dining room provides an elegant space for entertaining, while the bright open-concept layout is designed for modern living. The eat-in kitchen offers abundant cabinetry, ample workspace, a butler's pantry and seamless access to the back deck, creating the ideal indoor-outdoor flow for family gatherings and summer entertaining. Expansive windows throughout the home fill the space with natural light.The upper level boasts four spacious bedrooms, including a luxurious primary retreat complete with dual walk-in closets and a spa-inspired ensuite featuring a relaxing soaker tub. Three additional bedrooms offer exceptional convenience, each with either a private ensuite or direct access to a bathroom, making this home ideal for growing families and guests alike.The fully finished basement extends the living space even more with a large recreation room, an additional bedroom, and a 3-piece bathroom, providing ample flexibility. Step outside to enjoy the fully fenced backyard oasis, complete with a deck, hot tub, and mature trees that provide privacy and a tranquil setting for relaxing or entertaining. Offering generous living space, thoughtful design, and an exceptional location close to St. Davids Public School, which is Top Rated in Ontario, this home is a rare opportunity not to be missed. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T22:56:07.450004+00:00"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2020021"
+"ListOfficeKey": "283153"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T23:48:09Z"
+"PhotosCount": 42
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-10T21:59:15Z"
+"Stories": "2.0"
+"StreetName": "LINE 9"
+"StreetNumber": "965"
+"StreetSuffix": "Road"
+"SubdivisionName": "105 - St. Davids"
+"TaxAnnualAmount": "6512.89"
+"VirtualTourURLUnbranded": "https://youtu.be/f1TqGrMu-o4"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30001831/965-line-9-road-niagara-on-the-lake"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-17"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 36.0
+"AboveGradeFinishedArea": 2602
+"BelowGradeFinishedArea": 775
+"OriginalEntryTimestamp": "2026-07-07T20:48:41.79Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1300782"
+"ListOfficeNationalAssociationId": "1325050"
+"Media": array:42 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001831')"
+"ID": "1601549"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25425
+post_id: "1595553"
+post_author: 1
+"ListingKey": "29992366"
+"ListingId": "X13525692"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-09T23:00:01Z"
+"RFModificationTimestamp": "2026-07-09T23:01:58Z"
+"ListPrice": 1948888.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Niagara Falls (Stamford)"
+"PostalCode": "L2J4L5"
+"UnparsedAddress": "6775 DOMENIC CRESCENT, Niagara Falls (Stamford), Ontario L2J4L5"
+"Coordinates": array:2 [
0 => -79.110545
1 => 43.1424
]
+"Latitude": 43.1424
+"Longitude": -79.110545
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Niagara Association of REALTORS®"
+"PublicRemarks": "Welcome to an extraordinary property in Calaguiro Estates, one of Niagara Falls' most prestigious and sought-after neighbourhoods. Set in the desirable north end with convenient access to the QEW, shopping, dining, and everyday amenities, this remarkable residence sits on an impressive 118 x 200 ft lot backing directly onto the escarpment with no rear neighbours, offering an exceptional sense of privacy and natural beauty. Boasting over 6,000 sq. ft. of finished living space, the home is designed with scale, elegance, and functionality in mind. Soaring ceilings and expansive windows fill the interior with natural light, creating a bright and refined atmosphere throughout. The main level features a dramatic living room, formal dining area, private office, and a custom kitchen with French doors leading to a stunning backyard retreat. The main-floor primary suite offers a luxurious escape with a spa-inspired ensuite and custom walk-in closet, while the upper level includes three spacious bedrooms with private and shared ensuite access.The finished lower level adds exceptional versatility with an in-law suite, ideal for extended family, guests, or multi-generational living. Outside, the beautifully landscaped grounds feature natural armour stone, mature greenery, and a breathtaking escarpment backdrop. Complete with a rare five-car garage, this is a truly distinguished estate offering luxury, privacy, and presence in one of Niagara's most exclusive communities. Luxury Certified. (id:62650)"
+"Basement": array:1 [
0 => "Full"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-06T16:14:54.609295+00:00"
+"Directions": "Cross Streets: Dorchester/Mountain/Calaguiro Dr. ** Directions: Dorchester Road - Calaguiro Dr - Domenic Crescent."
+"ExteriorFeatures": array:2 [
0 => "Stucco"
1 => "Brick Facing"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2086848"
+"ListOfficeKey": "271450"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "118.1 x 200.1 FT ; 200.49 ft x 118.37 x 200.49 x 118.37 ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-09T22:52:59Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-09T22:52:59Z"
+"Stories": "2.0"
+"StreetName": "Domenic"
+"StreetNumber": "6775"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "15963"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/-_XR_fwpri4?si=-w4qaPpvCByyhy2J"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:25 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
]
+"ListAOR": "Niagara"
+"CityRegion": "206 - Stamford"
+"ListAORKey": "114"
+"ListingURL": "www.realtor.ca/real-estate/29992366/6775-domenic-crescent-niagara-falls-stamford-206-stamford"
+"ParkingTotal": 11
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 3500
+"LivingAreaMinimum": 3000
+"ZoningDescription": "R1A"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 118.1
+"OriginalEntryTimestamp": "2026-07-06T14:04:50.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1360156"
+"ListOfficeNationalAssociationId": "1239071"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29992366')"
+"ID": "1595553"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25426
+post_id: "1585734"
+post_author: 1
+"ListingKey": "29978637"
+"ListingId": "40844450"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T16:20:15Z"
+"RFModificationTimestamp": "2026-07-02T19:45:12Z"
+"ListPrice": 875000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2643.0
+"BuildingAreaTotal": 0
+"City": "Niagara-on-the-Lake"
+"PostalCode": "L0S1P0"
+"UnparsedAddress": "302 CONCESSION 3RD Road, Niagara-on-the-Lake, Ontario L0S1P0"
+"Coordinates": array:2 [
0 => -79.0957863
1 => 43.1609375
]
+"Latitude": 43.1609375
+"Longitude": -79.0957863
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautifully updated home in the heart of St. Davids, where timeless design meets modern comfort in one of Niagara-on-the Lake’s most sought-after communities. Perfectly positioned with breathtaking views overlooking a tranquil vineyard, this exceptional residence offers a rare blend of privacy, beauty, and refined wine country living—just minutes from world-class wineries, golf courses, Old Town Niagara-on-the-Lake, and the Niagara Parkway. From the moment you arrive, the home exudes quiet sophistication. Thoughtfully curated updates, elegant finishes, and a seamless flow of living spaces create an atmosphere that is both inviting and effortlessly luxurious, designed for everyday comfort and elevated entertaining. Step into your private backyard oasis, or unwind on the elegant covered front porch with sweeping vineyard views. Both offer unforgettable mornings, golden sunsets, and peaceful evenings under the stars. It is a setting that feels like a retreat—serene, intimate, and truly special. Recent upgrades provide peace of mind and lasting value, including a 200-amp upgraded electrical panel, an insulated and heated garage, a steel roof (2023), and a whole-home water purification system. Every improvement has been carefully selected to enhance both comfort and long-term quality. Whether you're seeking a full-time residence or a refined getaway in wine country, this home delivers a lifestyle defined by elegance, comfort, and connection to one of Niagara’s most desirable settings. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Dryer"
7 => "Window Coverings"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:45:01.767536+00:00"
+"Directions": "QEW to York Road, North on Concession Road 3, NOTL"
+"ExteriorFeatures": array:2 [
0 => "Concrete"
1 => "Brick"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2128977"
+"ListOfficeKey": "229734"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T16:11:33Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T16:11:33Z"
+"Stories": "2.0"
+"StreetName": "CONCESSION 3RD"
+"StreetNumber": "302"
+"StreetSuffix": "Road"
+"SubdivisionName": "105 - St. Davids"
+"TaxAnnualAmount": "5736.06"
+"VirtualTourURLUnbranded": "https://vlotours.aryeo.com/videos/019f1b7e-1c07-72f3-a09b-68b043810fc7"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29978637/302-concession-3rd-road-niagara-on-the-lake"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1-17"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 38.0
+"AboveGradeFinishedArea": 1485
+"BelowGradeFinishedArea": 1158
+"OriginalEntryTimestamp": "2026-07-02T16:11:33.49Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Listing Brokerage"
+"BelowGradeFinishedAreaSource": "Listing Brokerage"
+"ListAgentNationalAssociationId": "1382040"
+"ListOfficeNationalAssociationId": "1201977"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29978637')"
+"ID": "1585734"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 54
+after_key: ""
}
"RF Response Time" => "0.36 seconds"
]
]