Gorgeous marina and ocean views are enjoyed from this tastefully updated one-bedroom suite in the heart of downtown Sidney. The bright, open-concept floor plan features a stylish new kitchen with stainless steel appliances, a spa-inspired bathroom with a walk-in shower, vinyl flooring throughout, in-suite laundry, and a generous balcony that’s perfect for taking in the beautiful waterfront outlook. The sought-after
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as a part of their Mere Posting ComFree Listing Contract and in partnership with Zubic Law.
I acknowledge I can only access these forms as a ComFree customer under contract.
These forms are provided to ComFree’s Unrepresented Sellers as part of their Mere Posting ComFree Listing Contract and in partnership with Imperium LLP – Rocky Kim.
I acknowledge I can only access these forms as a ComFree customer under contract.
1. Purchase Your Package
2. We Ship Your ‘For Sale’ Sign
3. Book Your VR Tour
4. Complete Listing Input Forms
5. We Make Your Listing Live
6. Get Support 7 Days a Week
7. iSOLD!
array:6 [ "RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29988411 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23443 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23445 +post_id: "1592231" +post_author: 1 +"ListingKey": "29988411" +"ListingId": "1042288" +"PropertyType": "Residential" +"PropertySubType": "Single Family" +"StandardStatus": "Active" +"ModificationTimestamp": "2026-07-04T00:25:22Z" +"RFModificationTimestamp": "2026-07-04T00:44:47Z" +"ListPrice": 589000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 1.0 +"LotSizeArea": 949.0 +"LivingArea": 806.0 +"BuildingAreaTotal": 0 +"City": "Sidney" +"PostalCode": "V8L4T9" +"UnparsedAddress": "409 9805 Second St, Sidney, British Columbia V8L4T9" +"Coordinates": array:2 [ 0 => -123.3957636 1 => 48.6494049 ] +"Latitude": 48.6494049 +"Longitude": -123.3957636 +"YearBuilt": 1982 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"OriginatingSystemName": "Victoria Real Estate Board" +"PublicRemarks": "Gorgeous marina and ocean views are enjoyed from this tastefully updated one-bedroom suite in the heart of downtown Sidney. The bright, open-concept floor plan features a stylish new kitchen with stainless steel appliances, a spa-inspired bathroom with a walk-in shower, vinyl flooring throughout, in-suite laundry, and a generous balcony that's perfect for taking in the beautiful waterfront outlook. The sought-after Landmark is a well-maintained steel and concrete building offering a guest suite, secure underground parking, a residents' lounge, storage locker, and an on-site caretaker. Ideally located just steps from the waterfront promenade, restaurants, pubs, shopping, and Sidney's many popular community events. With no age restrictions and full rental flexibility, this is an outstanding home or investment opportunity. (id:62650)" +"AssociationFee": "377" +"AssociationFeeFrequency": "Monthly" +"CommunityFeatures": array:2 [ 0 => "Family Oriented" 1 => "Pets not Allowed" ] +"Cooling": array:1 [ 0 => "None" ] +"CreationDate": "2026-07-04T00:44:42.855172+00:00" +"Heating": array:2 [ 0 => "Baseboard heaters" 1 => "Electric" ] +"InternetEntireListingDisplayYN": true +"ListAgentKey": "1632451" +"ListOfficeKey": "53143" +"LivingAreaUnits": "square feet" +"LotFeatures": array:1 [ 0 => "Rectangular" ] +"LotSizeDimensions": "949" +"ParcelNumber": "000-946-451" +"ParkingFeatures": array:1 [ 0 => "Underground" ] +"PhotosChangeTimestamp": "2026-07-04T00:03:58Z" +"PhotosCount": 31 +"PropertyAttachedYN": true +"StateOrProvince": "British Columbia" +"StatusChangeTimestamp": "2026-07-04T00:15:46Z" +"StreetName": "Second" +"StreetNumber": "9805" +"StreetSuffix": "Street" +"TaxAnnualAmount": "2536" +"View": "Mountain view,Ocean view" +"Zoning": "Residential/Commercial" +"Rooms": array:8 [ 0 => array:11 [ "RoomKey" => "1674553099" "RoomType" => "Bathroom" "ListingId" => "1042288" "RoomLevel" => "Main level" "RoomWidth" => 6.0 "ListingKey" => "29988411" "RoomLength" => 12.0 "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => "feet" "ModificationTimestamp" => "2026-07-04T00:15:46.44Z" ] 1 => array:11 [ "RoomKey" => "1674553100" "RoomType" => "Laundry room" "ListingId" => "1042288" "RoomLevel" => "Main level" "RoomWidth" => 4.0 "ListingKey" => "29988411" "RoomLength" => 5.0 "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => "feet" "ModificationTimestamp" => "2026-07-04T00:15:46.44Z" ] 2 => array:11 [ "RoomKey" => "1674553101" "RoomType" => "Balcony" "ListingId" => "1042288" "RoomLevel" => "Main level" "RoomWidth" => 6.0 "ListingKey" => "29988411" "RoomLength" => 23.0 "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => "feet" "ModificationTimestamp" => "2026-07-04T00:15:46.44Z" ] 3 => array:11 [ "RoomKey" => "1674553102" "RoomType" => "Primary Bedroom" "ListingId" => "1042288" "RoomLevel" => "Main level" "RoomWidth" => 11.0 "ListingKey" => "29988411" "RoomLength" => 15.0 "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => "feet" "ModificationTimestamp" => "2026-07-04T00:15:46.44Z" ] 4 => array:11 [ "RoomKey" => "1674553103" "RoomType" => "Kitchen" "ListingId" => "1042288" "RoomLevel" => "Main level" "RoomWidth" => 8.0 "ListingKey" => "29988411" "RoomLength" => 13.0 "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => "feet" "ModificationTimestamp" => "2026-07-04T00:15:46.45Z" ] 5 => array:11 [ "RoomKey" => "1674553104" "RoomType" => "Dining room" "ListingId" => "1042288" "RoomLevel" => "Main level" "RoomWidth" => 7.0 "ListingKey" => "29988411" "RoomLength" => 11.0 "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => "feet" "ModificationTimestamp" => "2026-07-04T00:15:46.45Z" ] 6 => array:11 [ "RoomKey" => "1674553105" "RoomType" => "Living room" "ListingId" => "1042288" "RoomLevel" => "Main level" "RoomWidth" => 11.0 "ListingKey" => "29988411" "RoomLength" => 14.0 "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => "feet" "ModificationTimestamp" => "2026-07-04T00:15:46.45Z" ] 7 => array:11 [ "RoomKey" => "1674553106" "RoomType" => "Entrance" "ListingId" => "1042288" "RoomLevel" => "Main level" "RoomWidth" => 4.0 "ListingKey" => "29988411" "RoomLength" => 6.0 "RoomDimensions" => null "RoomDescription" => null "RoomLengthWidthUnits" => "feet" "ModificationTimestamp" => "2026-07-04T00:15:46.45Z" ] ] +"TaxLot": "60" +"ListAOR": "Victoria" +"CityRegion": "Sidney North-East" +"ListAORKey": "3" +"ListingURL": "www.realtor.ca/real-estate/29988411/409-9805-second-st-sidney-sidney-north-east" +"ParkingTotal": 1 +"StructureType": array:1 [ 0 => "Apartment" ] +"CommonInterest": "Condo/Strata" +"GeocodeManualYN": true +"LeaseAmountFrequency": "Monthly" +"OriginalEntryTimestamp": "2026-07-04T00:03:58.54Z" +"ListAgentNationalAssociationId": "1030537" +"ListOfficeNationalAssociationId": "1006572" +"Media": array:31 [ 0 => array:13 [ "Order" => 1 "MediaKey" => "29988411_4890_1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/f873f094071bb6a105e7b8a38b608280.webp" "MediaSize" => 349657 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-f873f094071bb6a105e7b8a38b608280.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => true "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 1 => array:13 [ "Order" => 2 "MediaKey" => "29988411_4890_2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/02d864fe9ec72880f0cbcf9ad2f96c7d.webp" "MediaSize" => 144291 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-02d864fe9ec72880f0cbcf9ad2f96c7d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 2 => array:13 [ "Order" => 3 "MediaKey" => "29988411_4890_3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/51d2cca562d5b6b28257eec70ff2a7b6.webp" "MediaSize" => 136960 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-51d2cca562d5b6b28257eec70ff2a7b6.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 3 => array:13 [ "Order" => 4 "MediaKey" => "29988411_4890_4" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/d14dc5a7b7e1af7aaf6d4fc93ccba93d.webp" "MediaSize" => 144082 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-d14dc5a7b7e1af7aaf6d4fc93ccba93d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 4 => array:13 [ "Order" => 5 "MediaKey" => "29988411_4890_5" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/205707e91a8f26643724f30ceecf5503.webp" "MediaSize" => 157399 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-205707e91a8f26643724f30ceecf5503.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 5 => array:13 [ "Order" => 6 "MediaKey" => "29988411_4890_6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/340f0432790055342a4709d376b9bfcd.webp" "MediaSize" => 127590 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-340f0432790055342a4709d376b9bfcd.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 6 => array:13 [ "Order" => 7 "MediaKey" => "29988411_4890_7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/736c1766316e9bf3ae930d7c62749916.webp" "MediaSize" => 126539 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-736c1766316e9bf3ae930d7c62749916.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 7 => array:13 [ "Order" => 8 "MediaKey" => "29988411_4890_8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/bf8105d30f0360c730018ff9baac786e.webp" "MediaSize" => 130854 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-bf8105d30f0360c730018ff9baac786e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 8 => array:13 [ "Order" => 9 "MediaKey" => "29988411_4890_9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/e80461fde5a2dc9551983d172d4f0731.webp" "MediaSize" => 148857 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-e80461fde5a2dc9551983d172d4f0731.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 9 => array:13 [ "Order" => 10 "MediaKey" => "29988411_4890_10" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/ceb99448a4822de67b3d0590429d1c99.webp" "MediaSize" => 170432 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-ceb99448a4822de67b3d0590429d1c99.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 10 => array:13 [ "Order" => 11 "MediaKey" => "29988411_4890_11" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/2b61c22e9aee6f980a1269cc67553ee4.webp" "MediaSize" => 118224 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-2b61c22e9aee6f980a1269cc67553ee4.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 11 => array:13 [ "Order" => 12 "MediaKey" => "29988411_4890_12" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/bcc58743912ebd7ec7c0e824d7db593b.webp" "MediaSize" => 75271 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-bcc58743912ebd7ec7c0e824d7db593b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 12 => array:13 [ "Order" => 13 "MediaKey" => "29988411_4890_13" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/6e8da01fbbb6ef83e2467daf01046d16.webp" "MediaSize" => 158150 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-6e8da01fbbb6ef83e2467daf01046d16.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 13 => array:13 [ "Order" => 14 "MediaKey" => "29988411_4890_14" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/9070764f302f02568512bddb8b62ddcc.webp" "MediaSize" => 139140 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-9070764f302f02568512bddb8b62ddcc.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 14 => array:13 [ "Order" => 15 "MediaKey" => "29988411_4890_15" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/4cef221356a05ae54f7995d7ad1b3a66.webp" "MediaSize" => 103326 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-4cef221356a05ae54f7995d7ad1b3a66.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 15 => array:13 [ "Order" => 16 "MediaKey" => "29988411_4890_16" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/fce6a000b7d64e37892d4de27da063ad.webp" "MediaSize" => 77117 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-fce6a000b7d64e37892d4de27da063ad.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 16 => array:13 [ "Order" => 17 "MediaKey" => "29988411_4890_17" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/030dfc0a9be0b0eed39292a09f600aed.webp" "MediaSize" => 100354 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-030dfc0a9be0b0eed39292a09f600aed.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 17 => array:13 [ "Order" => 18 "MediaKey" => "29988411_4890_18" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/e03be5bb0041bfd67f584903cec57c1b.webp" "MediaSize" => 194471 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-e03be5bb0041bfd67f584903cec57c1b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 18 => array:13 [ "Order" => 19 "MediaKey" => "29988411_4890_19" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/889613956452beb35ec1ba8daa26826a.webp" "MediaSize" => 191551 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-889613956452beb35ec1ba8daa26826a.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 19 => array:13 [ "Order" => 20 "MediaKey" => "29988411_4890_20" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/d8bcd08d6ac31f1d58581a6d1d8d707d.webp" "MediaSize" => 169871 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-d8bcd08d6ac31f1d58581a6d1d8d707d.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 20 => array:13 [ "Order" => 21 "MediaKey" => "29988411_4890_21" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/c480a58d149a90f2712a7c497d979e2b.webp" "MediaSize" => 100040 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-c480a58d149a90f2712a7c497d979e2b.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 21 => array:13 [ "Order" => 22 "MediaKey" => "29988411_4890_22" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/3939426ade67807f2a53a461b3ca8e62.webp" "MediaSize" => 267677 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-3939426ade67807f2a53a461b3ca8e62.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 22 => array:13 [ "Order" => 23 "MediaKey" => "29988411_4890_23" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/07728f5b5663559a18bc94ed724d8c7f.webp" "MediaSize" => 368247 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-07728f5b5663559a18bc94ed724d8c7f.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 23 => array:13 [ "Order" => 24 "MediaKey" => "29988411_4890_24" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/82c49a3c74c34bc7ab0b82fed755eef3.webp" "MediaSize" => 209630 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-82c49a3c74c34bc7ab0b82fed755eef3.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 24 => array:13 [ "Order" => 25 "MediaKey" => "29988411_4890_25" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/cb207c7beac365e49b071b497c4230ac.webp" "MediaSize" => 343419 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-cb207c7beac365e49b071b497c4230ac.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 25 => array:13 [ "Order" => 26 "MediaKey" => "29988411_4890_26" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/93ba3898a637efddb92f58289180f9b8.webp" "MediaSize" => 367245 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-93ba3898a637efddb92f58289180f9b8.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 26 => array:13 [ "Order" => 27 "MediaKey" => "29988411_4890_27" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/a57c6e5fc1bcc79be1583b65b706557e.webp" "MediaSize" => 256693 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-a57c6e5fc1bcc79be1583b65b706557e.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 27 => array:13 [ "Order" => 28 "MediaKey" => "29988411_4890_28" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/9dc536d2736718893ff668dd7ee54e20.webp" "MediaSize" => 537898 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-9dc536d2736718893ff668dd7ee54e20.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 28 => array:13 [ "Order" => 29 "MediaKey" => "29988411_4890_29" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/f3ee09c39e606f3e08158c0f97c7dc83.webp" "MediaSize" => 296912 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-f3ee09c39e606f3e08158c0f97c7dc83.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 29 => array:13 [ "Order" => 30 "MediaKey" => "29988411_4890_30" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/d8862eb4a9e4de4449b22580375ebea7.webp" "MediaSize" => 150707 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-d8862eb4a9e4de4449b22580375ebea7.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] 30 => array:13 [ "Order" => 31 "MediaKey" => "29988411_4890_31" "MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29988411/b2fb08b3ea511880703f92e4e8d5c2e5.webp" "MediaSize" => 213438 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29988411/thumbnail-b2fb08b3ea511880703f92e4e8d5c2e5.webp" "ResourceName" => "Property" "MediaCategory" => "Property Photo" "LongDescription" => null "PreferredPhotoYN" => false "ResourceRecordId" => "1042288" "ResourceRecordKey" => "29988411" "ModificationTimestamp" => "2026-07-04T00:03:58.55Z" ] ] +"DaysOnMarket": 0 +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29988411')" +"ID": "1592231" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.12 seconds" ] "RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 53143" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24880 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1632451" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24942 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#24838 +post_id: ? mixed +post_author: ? mixed +"MemberMlsId": "1632451" +"ModificationTimestamp": "2024-10-12T06:49:36Z" +"OriginatingSystemName": "CREA" +"MemberKey": "1632451" +"MemberPreferredPhoneExt": null +"MemberMlsSecurityClass": null +"MemberNationalAssociationId": null +"MemberAddress1": null +"MemberType": null +"MemberDesignation": null +"MemberCity": null +"MemberStateOrProvince": null +"MemberPostalCode": null +"OriginalEntryTimestamp": null +"MemberOfficePhone": null +"MemberOfficePhoneExt": null +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Member('1632451')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.11 seconds" ] "RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29988411'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25227 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.1 seconds" ] "RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29988411'" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25245 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25243 +post_id: ? mixed +post_author: ? mixed +"OpenHouseKey": "31785220" +"ListingKey": "29988411" +"ListingId": "1042288" +"OpenHouseStatus": "Active" +"OpenHouseType": "Open House" +"OpenHouseDate": "2026-07-04" +"OpenHouseStartTime": "2026-07-04T14:00:00Z" +"OpenHouseEndTime": "2026-07-04T16:00:00Z" +"OpenHouseRemarks": "Tastefully updated one-bedroom suite with beautiful marina and ocean views in the heart of downtown Sidney. Featuring a stylish new kitchen, spa-inspired bathroom, in-suite laundry, and a generous balcony in the sought-after Landmark, a steel and concrete building. Just steps to the waterfront, shops, restaurants, and all that Sidney has to offer." +"OriginatingSystemName": "CREA" +"ModificationTimestamp": "2026-07-04T08:54:17Z" +"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31785220')" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.09 seconds" ] "RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29988411' AND (PropertyType eq 'Residential Lease' OR PropertyType eq 'Commercial Lease' OR PropertyType eq 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-123.3957636 48.6494049)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25292 +items: [] +success: true +page_size: 0 +page_count: 0 +count: 0 +after_key: "" } "RF Response Time" => "0.26 seconds" ] ]