array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29825143 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23333
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23335
+post_id: "1478519"
+post_author: 1
+"ListingKey": "29825143"
+"ListingId": "NB140490"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T21:25:18Z"
+"RFModificationTimestamp": "2026-06-03T21:34:42Z"
+"ListPrice": 279000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E5V1"
+"UnparsedAddress": "2865 Rothesay Road Unit# 41, Rothesay, New Brunswick E2E5V1"
+"Coordinates": array:2 [
0 => -66.001471
1 => 45.378384
]
+"Latitude": 45.378384
+"Longitude": -66.001471
+"YearBuilt": 1966
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to Low Wood Estates, one of Rothesay's most established and sought-after condominium communities. This beautifully maintained top-floor, 2-bedroom condo offers the perfect combination of privacy, comfort, and spectacular Kennebecasis River views from your private balcony. Set among mature trees and beautifully landscaped grounds, Low Wood Estates feels more like a riverside retreat than a condominium complex. Residents enjoy elevator access, secure entry, extensive storage options, and a peaceful, park-like setting just minutes from shopping, restaurants, golf, walking trails, and everyday amenities. Inside, the bright and spacious layout offers two generous bedrooms, a large living and dining area, in-unit laundry, and the convenience of single-level living. Additional amenities include a private storage unit, dedicated storage for bicycles and seasonal tires, and access to a free common laundry room. The monthly condo fee of $795 includes heat, lights, lawn care, snow removal, water and sewer, and common area maintenance, lots of free parking for you and your guests, providing a truly low-maintenance lifestyle. Whether you're downsizing, retiring, looking for a lock-and-leave home, or simply seeking an affordable opportunity to enjoy the Rothesay lifestyle, this condo delivers exceptional value in a location that's difficult to match. Enjoy top-floor privacy, beautiful river views, and worry-free living in the heart of the Kennebecasis Valley. Book your private showing today! (id:62650)"
+"AssociationFee": "795.76"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-29T18:13:16.752309+00:00"
+"Directions": "Rothesay Road https://maps.app.goo.gl/Jez7LFf8aoEG4eR9A"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Ceramic"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2148616"
+"ListOfficeKey": "94518"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Golf course/parkland"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "30033914"
+"PhotosChangeTimestamp": "2026-06-02T13:44:31Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-03T21:15:29Z"
+"TaxAnnualAmount": "3179.27"
+"View": "River view"
+"VirtualTourURLUnbranded": "https://youtu.be/NuqKXRYhgCg?si=zueG7jyQ68tLPqUS"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1651015804"
"RoomType" => "Foyer"
"ListingId" => "NB140490"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29825143"
"RoomLength" => null
"RoomDimensions" => "4'8'' x 6'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T21:15:29.63Z"
]
1 => array:11 [
"RoomKey" => "1651015805"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB140490"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29825143"
"RoomLength" => null
"RoomDimensions" => "6'9'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T21:15:29.63Z"
]
2 => array:11 [
"RoomKey" => "1651015806"
"RoomType" => "Bedroom"
"ListingId" => "NB140490"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29825143"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T21:15:29.63Z"
]
3 => array:11 [
"RoomKey" => "1651015807"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB140490"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29825143"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 13'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T21:15:29.63Z"
]
4 => array:11 [
"RoomKey" => "1651015808"
"RoomType" => "Living room/Dining room"
"ListingId" => "NB140490"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29825143"
"RoomLength" => null
"RoomDimensions" => "19'6'' x 20'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T21:15:29.64Z"
]
5 => array:11 [
"RoomKey" => "1651015809"
"RoomType" => "Kitchen"
"ListingId" => "NB140490"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29825143"
"RoomLength" => null
"RoomDimensions" => "X"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-03T21:15:29.64Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29825143/2865-rothesay-road-unit-41-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-05-29T17:12:51.37Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1399601"
+"ListOfficeNationalAssociationId": "1159552"
+"Media": array:34 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29825143_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/07e124691c717af9bf9853340d2efa03.webp"
"MediaSize" => 61309
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-07e124691c717af9bf9853340d2efa03.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-05-29T17:50:49.58Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29825143_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/50ba5002c4e70091ce1668aeeaf99da1.webp"
"MediaSize" => 112469
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-50ba5002c4e70091ce1668aeeaf99da1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:08.42Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29825143_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/6e591b698128f246e170c18c1a99c38f.webp"
"MediaSize" => 67653
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-6e591b698128f246e170c18c1a99c38f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:07.25Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29825143_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/623a2ddad4788717a5387d65f5ca90a6.webp"
"MediaSize" => 79870
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-623a2ddad4788717a5387d65f5ca90a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:09.36Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29825143_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/a6ecefe83cba6236fb7e7c816697f063.webp"
"MediaSize" => 69751
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-a6ecefe83cba6236fb7e7c816697f063.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:10.55Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29825143_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/02db37f6299bb58c1672d49aa5375e14.webp"
"MediaSize" => 72820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-02db37f6299bb58c1672d49aa5375e14.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:07.23Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29825143_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/e9c44f82e48e4a9d8e5659467b29aa87.webp"
"MediaSize" => 56191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-e9c44f82e48e4a9d8e5659467b29aa87.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:05.57Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29825143_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/1122b9aa9ad690ca717657fe2eb4f18e.webp"
"MediaSize" => 52214
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-1122b9aa9ad690ca717657fe2eb4f18e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:12.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29825143_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/47426cc2a77e8ed3e4394c4539352dd1.webp"
"MediaSize" => 45749
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-47426cc2a77e8ed3e4394c4539352dd1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:07.23Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29825143_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/a804169dc5f29f4fea02794c76247496.webp"
"MediaSize" => 53932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-a804169dc5f29f4fea02794c76247496.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:07.23Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29825143_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/9d3180ade52567fd611c4832995180bd.webp"
"MediaSize" => 62114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-9d3180ade52567fd611c4832995180bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:10.52Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29825143_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/981048ea9fc4d666474d46e2f33cf2bd.webp"
"MediaSize" => 55758
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-981048ea9fc4d666474d46e2f33cf2bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:08.37Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29825143_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/148d125558f34571c4eedf69ba9285f4.webp"
"MediaSize" => 59826
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-148d125558f34571c4eedf69ba9285f4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:11.29Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29825143_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/c40abd6584f8f66d11fb00749211f2a4.webp"
"MediaSize" => 55164
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-c40abd6584f8f66d11fb00749211f2a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:08.37Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29825143_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/4c84154bbb081d5f8d7a6207d924583a.webp"
"MediaSize" => 42648
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-4c84154bbb081d5f8d7a6207d924583a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:05.57Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29825143_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/46ea45540241eac62d06f192736e34cd.webp"
"MediaSize" => 56535
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-46ea45540241eac62d06f192736e34cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Second Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:06.42Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29825143_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/d0887d135d371b7d3702b9f26983ddce.webp"
"MediaSize" => 53911
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-d0887d135d371b7d3702b9f26983ddce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Second Bedroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:08.36Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29825143_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/0bf4aff2f89344c93677919c17321730.webp"
"MediaSize" => 45066
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-0bf4aff2f89344c93677919c17321730.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Convenient laundry in the unit! Additional free laundry in the lower level!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:08.37Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29825143_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/27704aeaf8e7d3f8c3f0b2b6ddbf2b0e.webp"
"MediaSize" => 72973
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-27704aeaf8e7d3f8c3f0b2b6ddbf2b0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Enjoy Sunsets on the Balcony!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:09.36Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29825143_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/51a97727aa6802bd9e7441f059ef5f18.webp"
"MediaSize" => 152891
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-51a97727aa6802bd9e7441f059ef5f18.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Great balcony!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:08.36Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29825143_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/7ffa39cd9afb948c477d2f5d08a5e627.webp"
"MediaSize" => 145456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-7ffa39cd9afb948c477d2f5d08a5e627.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Storage included!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:06.42Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29825143_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/d16ee6d4e1ebb13e141f1aacab699499.webp"
"MediaSize" => 97979
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-d16ee6d4e1ebb13e141f1aacab699499.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "River View from the beautiful grounds!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:05.57Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29825143_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/0b387482fbd0d9c4db1a0b37f123d950.webp"
"MediaSize" => 161572
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-0b387482fbd0d9c4db1a0b37f123d950.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Beautiful Grounds!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:12.46Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29825143_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/73a5d179cb9fa6591b06b5574055a947.webp"
"MediaSize" => 166411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-73a5d179cb9fa6591b06b5574055a947.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Beautiful grounds!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:11.29Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29825143_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/d4e648d3c3d7247185034e8becd38551.webp"
"MediaSize" => 153372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-d4e648d3c3d7247185034e8becd38551.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "River view from the balcony and the grounds!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:07.25Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29825143_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/97782ba6cf7dee97dd9cb8b50cedfe0b.webp"
"MediaSize" => 121717
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-97782ba6cf7dee97dd9cb8b50cedfe0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Well maintained and managed property!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:07.67Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29825143_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/8abb6a49999f8302c7e97631cd444ba3.webp"
"MediaSize" => 155467
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-8abb6a49999f8302c7e97631cd444ba3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Plenty of parking for owners and guests!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:12.44Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29825143_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/02d7b76bd8ad36d42d8157f4986bd803.webp"
"MediaSize" => 85075
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-02d7b76bd8ad36d42d8157f4986bd803.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Beautiful lobby with sitting area!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:10.59Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29825143_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/04e795ab0794011816886f764ee63b64.webp"
"MediaSize" => 59907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-04e795ab0794011816886f764ee63b64.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Beautiful lobby with sitting area!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:08.37Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29825143_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/3c206b818a7eb464828dcb51488c8fa1.webp"
"MediaSize" => 151375
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-3c206b818a7eb464828dcb51488c8fa1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:08.37Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29825143_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/a140d129cfd4f6f0e5e656ed19077dd2.webp"
"MediaSize" => 78232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-a140d129cfd4f6f0e5e656ed19077dd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Nearby Park"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:10.52Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29825143_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/7d6e6a6f47a8805d816301f4d7d7b946.webp"
"MediaSize" => 142597
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-7d6e6a6f47a8805d816301f4d7d7b946.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Nearby Park"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:12.46Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29825143_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/ef2f9eef58381147cd5bec322ea5dc3b.webp"
"MediaSize" => 89348
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-ef2f9eef58381147cd5bec322ea5dc3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Nearby River Views!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:10.53Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29825143_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29825143/fa4a2e86318847083f7c9a2c50853e4e.webp"
"MediaSize" => 137125
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29825143/thumbnail-fa4a2e86318847083f7c9a2c50853e4e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Rothesay Living at a bargain!"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140490"
"ResourceRecordKey" => "29825143"
"ModificationTimestamp" => "2026-06-02T13:31:11.29Z"
]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29825143')"
+"ID": "1478519"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 94518" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24676
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2148616" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24761
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29825143'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25075
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.09 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29825143'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25092
+items: array:4 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25091
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31226553"
+"ListingKey": "29825143"
+"ListingId": "NB140490"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-30T23:41:15Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31226553')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25093
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31251066"
+"ListingKey": "29825143"
+"ListingId": "NB140490"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-05-31"
+"OpenHouseStartTime": "2026-05-31T14:00:00Z"
+"OpenHouseEndTime": "2026-05-31T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-05-31T17:50:26Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31251066')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25090
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31271776"
+"ListingKey": "29825143"
+"ListingId": "NB140490"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-03"
+"OpenHouseStartTime": "2026-06-03T16:00:00Z"
+"OpenHouseEndTime": "2026-06-03T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-02T10:53:49Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31271776')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25094
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31278832"
+"ListingKey": "29825143"
+"ListingId": "NB140490"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-03"
+"OpenHouseStartTime": "2026-06-03T16:00:00Z"
+"OpenHouseEndTime": "2026-06-03T18:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-03T19:05:14Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31278832')"
}
]
+success: true
+page_size: 4
+page_count: 1
+count: 4
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29825143' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-66.001471 45.378384)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25172
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25146
+post_id: "1493584"
+post_author: 1
+"ListingKey": "29851941"
+"ListingId": "NB137889"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T13:25:38Z"
+"RFModificationTimestamp": "2026-06-04T14:36:22Z"
+"ListPrice": 1595000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 3.7
+"LivingArea": 5444.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E5K2"
+"UnparsedAddress": "48 GONDOLA POINT Road, Rothesay, New Brunswick E2E5K2"
+"Coordinates": array:2 [
0 => -65.996159
1 => 45.392655
]
+"Latitude": 45.392655
+"Longitude": -65.996159
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Known as the Birchwood proudly offered for the first time in nearly three decades, this exceptional estate presents a rare opportunity to own an impressive residence combining space, privacy and timeless appeal. Nestled on a serene 3.7 acre parcel in a highly sought after area of Rothesay, this property offers an extraordinary lifestyle surrounded by irreplaceable mature landscaping, gardens and expansive grounds. Offering over 5000 sq ft of thoughtfully designed living space, the home features 6 generous bedrooms (some with fireplaces), beautiful built-ins, sunroom, 3 full bathrooms plus a powder room (on main level), main level laundry, butlers pantry off kitchen linking to formal dining, 2 separate living rooms each with fireplaces & access to outdoor patio/deck spaces, in floor heating in kitchen, plus rec room and games area in basement-overall providing exceptional flexibility for large families or those who simply appreciate room to grow and entertain. This iconic and picturesque property is highlighted by meticulously maintained grounds, sprawling lawn areas and a peaceful wooded section along a brook that adds natural beauty and year round enjoyment. Whether hosting gatherings, enjoying outdoor recreation, or simply taking in the beautiful surroundings, this estate offers endless possibilities with privacy. Adding further value is the detached oversized 3-bay garage, complete with a functional loft space; ideal for a workshop, hobby area, studio, storage, or future customization to suit your needs. This is a rare combination of character and charm with substantial living space, acreage, location and pride of ownership, this exceptional property offers the opportunity to create lasting memories for generations to come. Walking distance to Rothesay Boat Club & Rothesay Commons Park. Exceptional estate living on a private 3.7 acres conveniently located. Call to book your private viewing of the Birchwood today! (id:62783)"
+"Basement": array:3 [
0 => "Partially finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Fishing"
]
+"CreationDate": "2026-06-04T14:36:15.826759+00:00"
+"Directions": "from ROTHESAY RD TO GONDOLA PT (passing the Rothesay Commons & Almon Lane - house is located on your right - behind large cedar hedge)"
+"ExteriorFeatures": array:3 [
0 => "Cedar shingles"
1 => "Wood"
2 => "Wood shingles"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Tile"
1 => "Wood"
]
+"FoundationDetails": array:2 [
0 => "Stone"
1 => "Concrete"
]
+"Heating": array:6 [
0 => "Radiant heat"
1 => "Stove"
2 => "Electric"
3 => "Propane"
4 => "Wood"
5 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1786681"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Treed"
1 => "Golf course/parkland"
2 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "3.7"
+"ParcelNumber": "00256875"
+"ParkingFeatures": array:3 [
0 => "Detached Garage"
1 => "Garage"
2 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T13:17:05Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-04T13:17:05Z"
+"Stories": "3.0"
+"TaxAnnualAmount": "7628.54"
+"View": "River view"
+"VirtualTourURLUnbranded": "https://youtu.be/zoibkPgiVy8"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [
"RoomKey" => "1651447206"
"RoomType" => "Games room"
"ListingId" => "NB137889"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "20'1'' x 15'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.89Z"
]
1 => array:11 [
"RoomKey" => "1651447207"
"RoomType" => "Great room"
"ListingId" => "NB137889"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "17'0'' x 25'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.89Z"
]
2 => array:11 [
"RoomKey" => "1651447208"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB137889"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "7'2'' x 6'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.89Z"
]
3 => array:11 [
"RoomKey" => "1651447209"
"RoomType" => "Bedroom"
"ListingId" => "NB137889"
"RoomLevel" => "Third level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.89Z"
]
4 => array:11 [
"RoomKey" => "1651447210"
"RoomType" => "Sunroom"
"ListingId" => "NB137889"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 9'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.89Z"
]
5 => array:11 [
"RoomKey" => "1651447211"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB137889"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "7'8'' x 5'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.89Z"
]
6 => array:11 [
"RoomKey" => "1651447212"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB137889"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.89Z"
]
7 => array:11 [
"RoomKey" => "1651447213"
"RoomType" => "Bedroom"
"ListingId" => "NB137889"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 18'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.89Z"
]
8 => array:11 [
"RoomKey" => "1651447214"
"RoomType" => "Bedroom"
"ListingId" => "NB137889"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 16'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
9 => array:11 [
"RoomKey" => "1651447215"
"RoomType" => "Bedroom"
"ListingId" => "NB137889"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 19'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
10 => array:11 [
"RoomKey" => "1651447216"
"RoomType" => "Bedroom"
"ListingId" => "NB137889"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "14'1'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
11 => array:11 [
"RoomKey" => "1651447217"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB137889"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "17'1'' x 23'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
12 => array:11 [
"RoomKey" => "1651447218"
"RoomType" => "Laundry room"
"ListingId" => "NB137889"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 13'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
13 => array:11 [
"RoomKey" => "1651447219"
"RoomType" => "Family room"
"ListingId" => "NB137889"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 22'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
14 => array:11 [
"RoomKey" => "1651447220"
"RoomType" => "Living room"
"ListingId" => "NB137889"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "18'1'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
15 => array:11 [
"RoomKey" => "1651447221"
"RoomType" => "Pantry"
"ListingId" => "NB137889"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "16'5'' x 6'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
16 => array:11 [
"RoomKey" => "1651447222"
"RoomType" => "Dining room"
"ListingId" => "NB137889"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "15'4'' x 17'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
17 => array:11 [
"RoomKey" => "1651447223"
"RoomType" => "Kitchen"
"ListingId" => "NB137889"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29851941"
"RoomLength" => null
"RoomDimensions" => "20'8'' x 22'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T13:17:05.9Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29851941/48-gondola-point-road-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 6
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 4612
+"OriginalEntryTimestamp": "2026-06-04T13:17:05.86Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1189100"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:49 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29851941_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/5cc14d6b8f63cd29e7945ea8c91abca5.webp"
"MediaSize" => 179691
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-5cc14d6b8f63cd29e7945ea8c91abca5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29851941_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/d42b20251fd6f4b8e592088385d09740.webp"
"MediaSize" => 202730
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-d42b20251fd6f4b8e592088385d09740.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29851941_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/515ccbcad87bac2e1cc4797f410e9318.webp"
"MediaSize" => 177735
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-515ccbcad87bac2e1cc4797f410e9318.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29851941_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/3a4a742f84625f1a8375eb1804e3f46b.webp"
"MediaSize" => 167265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-3a4a742f84625f1a8375eb1804e3f46b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front Yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29851941_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/1c9cbe59b8cc950d844aeedc6e558404.webp"
"MediaSize" => 135659
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-1c9cbe59b8cc950d844aeedc6e558404.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back View"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29851941_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/f7bdb23a399ed13c0a8e770724c8e0b6.webp"
"MediaSize" => 177343
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-f7bdb23a399ed13c0a8e770724c8e0b6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29851941_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/d6790d6c9f72623c2b423482a7f36d39.webp"
"MediaSize" => 178277
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-d6790d6c9f72623c2b423482a7f36d39.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Back Yard"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29851941_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/7a3d5901de9e00ce9afcf6ba8131984b.webp"
"MediaSize" => 144024
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-7a3d5901de9e00ce9afcf6ba8131984b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View from Front Stairs"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29851941_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/aad077cd3f236e3565672e583bbc30c3.webp"
"MediaSize" => 147719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-aad077cd3f236e3565672e583bbc30c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29851941_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/c16b5a676c7c3f893587fd04edc44976.webp"
"MediaSize" => 107647
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-c16b5a676c7c3f893587fd04edc44976.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Center Staircase"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29851941_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/291100aff457c3c7708fbf9d5575a1c3.webp"
"MediaSize" => 100371
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-291100aff457c3c7708fbf9d5575a1c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Formal Living Room"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29851941_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/e32f6ddec11000bebe252d717bcd853a.webp"
"MediaSize" => 133887
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-e32f6ddec11000bebe252d717bcd853a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Formal Dining"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29851941_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/328ea427f09fc7fadb84132113821a51.webp"
"MediaSize" => 127429
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-328ea427f09fc7fadb84132113821a51.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Formal Dining"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29851941_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/8bf7d580f6de36692ffdc91ab2710984.webp"
"MediaSize" => 67249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-8bf7d580f6de36692ffdc91ab2710984.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29851941_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/ff4d7b459243be72f417758ed4db21c9.webp"
"MediaSize" => 64351
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-ff4d7b459243be72f417758ed4db21c9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29851941_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/6afe4670ae8f7fd1f01a266183cef9e5.webp"
"MediaSize" => 95833
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-6afe4670ae8f7fd1f01a266183cef9e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Pantry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29851941_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/d53263c57b8681b5b688b47b2e3375a7.webp"
"MediaSize" => 72081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-d53263c57b8681b5b688b47b2e3375a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29851941_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29851941/f426e6ddc8b05b27d679d0fcc66f6357.webp"
"MediaSize" => 81234
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29851941/thumbnail-f426e6ddc8b05b27d679d0fcc66f6357.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB137889"
"ResourceRecordKey" => "29851941"
"ModificationTimestamp" => "2026-06-04T13:17:05.87Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29851941_4890_19"
…11
]
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": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29851941')"
+"ID": "1493584"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25168
+post_id: "1457140"
+post_author: 1
+"ListingKey": "29800227"
+"ListingId": "NB140146"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-25T16:50:12Z"
+"RFModificationTimestamp": "2026-05-25T19:06:04Z"
+"ListPrice": 500000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 10.0
+"LotSizeArea": 0.85
+"LivingArea": 4500.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E5L2"
+"UnparsedAddress": "26 Hampton Road, Rothesay, New Brunswick E2E5L2"
+"Coordinates": array:2 [
0 => -65.993078
1 => 45.389312
]
+"Latitude": 45.389312
+"Longitude": -65.993078
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 26 Hampton Road, Rothesay, a rare opportunity packed with space, potential, and endless possibilities. Situated on a private lot in the heart of Rothesay, this expansive property offers over 4,500 sq. ft. of living space, with 10 bedrooms, 3 bathrooms, and ample room for future expansion or customization. Outside, enjoy the in-ground pool and spacious yard, perfect for entertaining or creating your own private retreat. Whether you are looking to restore it into a stunning forever home, explore income potential, or convert it into a special care home or multi-unit investment, the options here are truly endless. While the property could benefit from some TLC, the size, layout, and location make it an incredible opportunity for the right buyer with vision. Call today for full details or to book your private viewing. (id:62650)"
+"CreationDate": "2026-05-25T19:05:41.705244+00:00"
+"Directions": "Near the corner of Grove and Hampton Road."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:4 [
0 => "Laminate"
1 => "Carpeted"
2 => "Ceramic"
3 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1834886"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "0.85"
+"ParcelNumber": "00256560"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-25T16:43:01Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-25T16:43:01Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "7509.87"
+"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": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29800227/26-hampton-road-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 10
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 4500
+"OriginalEntryTimestamp": "2026-05-25T16:43:01.37Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1196834"
+"ListOfficeNationalAssociationId": "1007064"
+"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": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29800227')"
+"ID": "1457140"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25145
+post_id: "1439639"
+post_author: 1
+"ListingKey": "29775100"
+"ListingId": "NB138686"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-20T13:11:03Z"
+"RFModificationTimestamp": "2026-05-20T18:24:57Z"
+"ListPrice": 699000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 4363.0
+"LivingArea": 1450.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E5L2"
+"UnparsedAddress": "50 Hampton Road, Rothesay, New Brunswick E2E5L2"
+"Coordinates": array:2 [
0 => -65.98928
1 => 45.391827
]
+"Latitude": 45.391827
+"Longitude": -65.98928
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this fully renovated, move-in ready home, thoughtfully updated just two years ago and designed for comfortable, modern living. From the moment you arrive, the large covered front veranda offers a warm and inviting first impressionperfect for relaxing outdoors in any season. Inside, the home features bright, refreshed interiors with an open feel, highlighted by generous living spaces and a cozy fireplace that anchors the main living area. The eat-in kitchen is both stylish and functional, complete with a central island, ample workspace, and a charming dining area ideal for everyday meals or entertaining. Step outside to enjoy a beautiful back deck overlooking a spacious, mature backyard- perfect for gatherings, gardening, or simply unwinding in your own private outdoor retreat. One of the standout features of this property is the detached double car garage, offering plenty of room for vehicles, storage, or a workshop setup. With its extensive recent renovations, inviting indoor spaces, and exceptional outdoor featuresincluding a large front veranda, expansive backyard, and versatile garagethis home offers the perfect blend of comfort, style, and practicality in a highly walkable Rothesay location. (id:62783)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-20T18:23:16.560575+00:00"
+"Directions": "Marr road to Hampton Road"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Stove"
2 => "Electric"
3 => "Natural gas"
4 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1659486"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "4363"
+"ParcelNumber": "00255984"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-20T13:00:16Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-20T13:00:16Z"
+"Stories": "1.5"
+"TaxAnnualAmount": "7277.98"
+"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": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29775100/50-hampton-road-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1450
+"OriginalEntryTimestamp": "2026-05-20T13:00:16.2Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1167464"
+"ListOfficeNationalAssociationId": "1007064"
+"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": 20
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29775100')"
+"ID": "1439639"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25169
+post_id: "1424470"
+post_author: 1
+"ListingKey": "29750347"
+"ListingId": "NB138223"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-20T19:30:53Z"
+"RFModificationTimestamp": "2026-05-20T23:06:58Z"
+"ListPrice": 1365000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 19504.0
+"LivingArea": 5286.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E5V3"
+"UnparsedAddress": "3161 Rothesay Road, Rothesay, New Brunswick E2E5V3"
+"Coordinates": array:2 [
0 => -65.997268
1 => 45.384932
]
+"Latitude": 45.384932
+"Longitude": -65.997268
+"YearBuilt": 1906
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "This distinguished historic residence is one of Rothesays most recognizable homes, gracefully positioned along the Rothesay Road, where long summer evenings are defined by golden sunsets and relaxed outdoor living. Rich in character and timeless elegance, this grand 3-storey home showcases exquisite craftsmanship throughout, from intricate wood detailing and classic wainscoting to an abundance of French doors that invite light and flow into every space. The stately entrance and grand foyer feature soaring 9-foot ceilings and a stunning wood staircase that anchors the centre of the home. Hardwood floors extend across all levels, complementing 5 bedrooms, 3.5 bathrooms, and ample living space, including a fully finished basement a wonderful space for growing families. Throughout the home you will find meticulous details and generously scaled rooms including a well-appointed kitchen, formal dining room, and an inviting living area designed for both everyday comfort and entertaining. The primary suite is a private retreat, complete with dual walk-in closets and a spacious ensuite featuring double vanities, allowing for dedicated personal space. Outdoors, the property truly shines. The private backyard is an entertainers dream, featuring a multi-level deck with two covered lounging areas overlooking a heated in-ground pool, all framed by mature trees. With both sun-drenched and shaded spaces, its an ideal setting for hosting or unwinding in complete serenity. Backing directly onto the Rothesay Tennis Club, you can step from your backyard to the courts in moments - an unmatched lifestyle convenience. Set within one of the regions most prestigious communities, this home offers proximity to top-rated schools, and beloved local destinations including Shadow Lawn Inn, Rothesay Yacht Club, and Riverside Country Club. A rare offering where vintage charm and grand scale meet a home built to create enduring family memories - on one of Rothesays most coveted addresses. (id:62783)"
+"Basement": array:3 [
0 => "Partially finished"
1 => "Full"
2 => "Walk out"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-05-14T14:04:06.606011+00:00"
+"Directions": "Rothesay Road."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Baseboard heaters"
1 => "Oil"
2 => "Electric"
3 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1735040"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Treed"
1 => "Golf course/parkland"
2 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "19504"
+"ParcelNumber": "00257337"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-20T19:21:07Z"
+"PhotosCount": 42
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-20T19:22:20Z"
+"Stories": "3.0"
+"TaxAnnualAmount": "11041.2"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29750347/3161-rothesay-road-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 4159
+"OriginalEntryTimestamp": "2026-05-14T12:10:47.56Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1177797"
+"ListOfficeNationalAssociationId": "1007064"
+"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": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29750347')"
+"ID": "1424470"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25166
+post_id: "1424467"
+post_author: 1
+"ListingKey": "29750344"
+"ListingId": "NB139101"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-14T13:20:56Z"
+"RFModificationTimestamp": "2026-05-14T13:43:26Z"
+"ListPrice": 1650000.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 50924.0
+"LivingArea": 5799.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E5K3"
+"UnparsedAddress": "6 Grove Avenue, Rothesay, New Brunswick E2E5K3"
+"Coordinates": array:2 [
0 => -65.992515
1 => 45.388626
]
+"Latitude": 45.388626
+"Longitude": -65.992515
+"YearBuilt": 1953
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Set on 1.17 private acres in the heart of Rothesay, this extensively updated cedar shake home blends timeless design with modern functionality, creating an exceptional family estate built for both everyday living and entertaining. Recent upgrades include a Generac generator, upgraded HVAC servicing the main and upper floors, 2 new furnaces for improved efficiency, and a new fireplace that enhances the main living space. A paved horseshoe driveway winds through mature trees with uplighting, offering a striking and welcoming approach. Surrounded by lush greenery, the property feels private, serene, and truly estate-like while remaining close to community amenities. The heart of the home is a beautifully detailed kitchen featuring custom millwork, decorative columns, glass-front inset cabinetry, open shelving, premium Thermador appliances, and an oversized island designed for both family life and hosting. The main level is an entertainers dream with a dedicated bar area, cozy stone-clad den, and home theatre - perfect for gatherings, celebrations, and family movie nights. The upper level features a spacious primary suite with 2 walk-in closets and a 5-piece ensuite, as well as 5 bedrooms and 4 full bathrooms, with 3 of the bedrooms offering private ensuites, ideal for comfortable family living and hosting guests. Above the oversized triple-car garage, a loft-style space with sound insulation adds flexibility for a media room, playroom, or guest suite. The finished lower level includes a sauna for wellness and relaxation. The front verandah provides the perfect place to unwind and enjoy evening sunsets, adding to the homes warm and inviting character. Just a 5-minute walk to the Rothesay Common and close to cafés, wine bar, creperie, fitness studio, yacht club, and more, this home offers a rare blend of estate-like privacy and everyday access to Rothesays charming community core. (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:3 [
0 => "Central air conditioning"
1 => "Heat Pump"
2 => "Air Conditioned"
]
+"CreationDate": "2026-05-14T13:42:53.459165+00:00"
+"Directions": "From Saint John- Highway 1 East towards Sussex. Take exit 137 B towards Rothesay and Quispamsis. Left at the Fire Station on Campbell Dr and right onto Grove Ave for 1.3km. 6 Grove Ave is on the right."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Wood shingles"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Stove"
2 => "Natural gas"
3 => "See remarks"
4 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1821628"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Treed"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "50924"
+"ParcelNumber": "30337042"
+"ParkingFeatures": array:4 [
0 => "Integrated Garage"
1 => "Garage"
2 => "Garage"
3 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-05-14T12:10:38Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-14T13:12:17Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "13026.31"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:24 [
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]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29750344/6-grove-avenue-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1735040"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "51407"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 5237
+"OriginalEntryTimestamp": "2026-05-14T12:10:38.04Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1193799"
+"ListOfficeNationalAssociationId": "1007064"
+"CoListAgentNationalAssociationId": "1177797"
+"CoListOfficeNationalAssociationId": "1007064"
+"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": 26
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29750344')"
+"ID": "1424467"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25142
+post_id: "1416240"
+post_author: 1
+"ListingKey": "29744687"
+"ListingId": "NB139030"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-13T15:01:14Z"
+"RFModificationTimestamp": "2026-05-13T15:06:24Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1200.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E0V5"
+"UnparsedAddress": "54 Hampton Road Unit# 206, Rothesay, New Brunswick E2E0V5"
+"Coordinates": array:2 [
0 => -65.988802
1 => 45.392369
]
+"Latitude": 45.392369
+"Longitude": -65.988802
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Experience upscale condo living in the heart of Rothesay. This mint condition 2-bedroom, 2-bath residence combines elegance, comfort, and convenience with premium finishes and exceptional amenities throughout. Designed with sophistication in mind, this beautifully maintained condo features 9-foot ceilings, ceramic tile, quartz countertops, and a bright open-concept layout perfect for entertaining or relaxing in style. The spacious primary bedroom offers a walk-in closet and a lovely 5 piece ensuite bath. Additional premium features include: power blinds, covered sun deck, large kitchen pantry, laundry room, underground parking with gated storage plus an additional above-ground parking space. Residents enjoy access to outstanding building amenities including: swimming pool, fully equipped exercise/weight room, a wonderful common room for social gatherings and entertaining, Monthly condo fees of $500 include snow removal, water & garbage disposal allowing for effortless, low-maintenance luxury living. Ideally located close to shopping, dining, walking trails, and all major amenities, this exceptional condo offers the perfect blend of style, comfort, and convenience. Move-in ready and waiting for you to enjoy the lifestyle you deserve. (id:62650)"
+"AssociationFee": "500"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "Full"
]
+"Cooling": array:2 [
0 => "Air exchanger"
1 => "Heat Pump"
]
+"CreationDate": "2026-05-13T15:06:17.163839+00:00"
+"Directions": "Hampton Road to Hillcrest Drive to Balmoral Blvd into parking lot."
+"ExteriorFeatures": array:2 [
0 => "Wood"
1 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2132512"
+"ListOfficeKey": "94518"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Wheelchair access"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "30345961"
+"ParkingFeatures": array:1 [
0 => "Underground"
]
+"PhotosChangeTimestamp": "2026-05-13T14:51:04Z"
+"PhotosCount": 28
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-13T14:51:04Z"
+"TaxAnnualAmount": "4779.01"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29744687/54-hampton-road-unit-206-rothesay"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": false
+"RoadSurfaceType": array:1 [
0 => "Paved road"
]
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1200
+"OriginalEntryTimestamp": "2026-05-13T14:43:57.16Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1385188"
+"ListOfficeNationalAssociationId": "1159552"
+"Media": array:28 [
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]
]
+"DaysOnMarket": 27
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29744687')"
+"ID": "1416240"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23347
+post_id: "1350385"
+post_author: 1
+"ListingKey": "29641311"
+"ListingId": "NB137636"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T19:20:44Z"
+"RFModificationTimestamp": "2026-06-07T19:37:38Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.47
+"LivingArea": 2600.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2H1T1"
+"UnparsedAddress": "88 Green Road, Rothesay, New Brunswick E2H1T1"
+"Coordinates": array:2 [
0 => -66.001199
1 => 45.375269
]
+"Latitude": 45.375269
+"Longitude": -66.001199
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Located midway up the Green Road, this iconic two-storey home embodies the ultimate Rothesay lifestyle! Gracious and charming, this vintage home features 9 foot ceilings, crown mouldings, numerous unique built-in cabinets, bookcases & wainscotting, multiple French doors, 2 fireplaces, original stained glass, a stunning staircase, expansive rooms & an abundance of windows. In the mid-1980s, the current owners added a two-storey extension, introducing a spacious Family Room & a Primary Bedroom up. The property also boasts an oversized double garage with loft. The home is set on an absolutely gorgeous, oversized lot with mature trees & gardens, flagstone pathways, 2 decorative ponds and a stone patio. The backyard offers plenty of grassy space perfect for childrens play. The wraparound verandah leads to the front door, opening into a gracious foyer with French doors revealing an expansive Living Room with a dark oak fireplace and bay window. The Dining Room features charming built-in corner cabinets. Evenings can be enjoyed on the verandah, while sunny winter afternoons are perfect in the delightful Sunroom. The Family Room showcases a raised hearth wood-burning fireplace & garden doors provide access to the stone patio & gardens. A sweet country kitchen with large island & a half bath complete the main level. Upstairs are 4 well-sized bedrooms. The Primary Bedroom offers a walk-in closet with great potential for an ensuite bath. The 2nd bedroom opens onto a roof deck, while the 3rd bedroom features a charming window seat. The 4th bedroom is equally delightful. The main Bathroom includes a large walk-in shower and separate claw foot tub. A staircase leads to the attic with loads of potential. This lovely home is perfectly situated just up the road from East Riverside Kingshurst Park and the nearby Riverside Golf and Country Club. It has been cherished and owned by the same family for 50 years, reflecting its endearing appeal and amazing family-friendly features! (id:62650)"
+"Basement": array:7 [
0 => "Unfinished"
1 => "Unfinished"
2 => "Full"
3 => "Partial"
4 => "Crawl space"
5 => "Walk out"
6 => "Walk out"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-04-22T19:49:27.208107+00:00"
+"Directions": "Rothesay Rd past Riverside Kingshurst Park turn right onto Green Road. Located on the right half way up the Green Road on the corner of Carol Lane."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:4 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
3 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:7 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Stove"
3 => "Electric"
4 => "Wood"
5 => "Radiator"
6 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1871815"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Level lot"
1 => "Treed"
2 => "Corner Site"
3 => "Golf course/parkland"
4 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0.47"
+"ParcelNumber": "00238097"
+"ParkingFeatures": array:3 [
0 => "Detached Garage"
1 => "Garage"
2 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-25T01:31:43Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-07T19:14:06Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "5732.91"
+"View": "River view"
+"VirtualTourURLUnbranded": "https://youtu.be/iKpavfT8wmM"
+"WaterSource": array:2 [
0 => "Drilled Well"
1 => "Well"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29641311/88-green-road-rothesay"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2600
+"OriginalEntryTimestamp": "2026-04-22T17:44:13.47Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1203250"
+"ListOfficeNationalAssociationId": "1007064"
+"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": 48
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29641311')"
+"ID": "1350385"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25170
+post_id: "1286141"
+post_author: 1
+"ListingKey": "29531450"
+"ListingId": "NB135786"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T12:35:12Z"
+"RFModificationTimestamp": "2026-06-02T13:44:43Z"
+"ListPrice": 263500.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 8.38
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E5V1"
+"UnparsedAddress": "2865 Rothesay Road Unit# 25, Rothesay, New Brunswick E2E5V1"
+"Coordinates": array:2 [
0 => -66.001471
1 => 45.378384
]
+"Latitude": 45.378384
+"Longitude": -66.001471
+"YearBuilt": 1963
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "AVAILABLE - Welcome to Suite 25 at Low Wood Estates, a highly desirable condo community in the heart of Rothesay. This beautifully updated second floor corner unit offers the perfect blend of modern style, low-maintenance living and walkability to top local amenities. Bright and inviting, the open concept layout is filled with natural light and features 2 bedrooms, including a spacious primary with walk-in closet and convenient dedicated laundry. Extensively renovated, this condo feels like new with upgrades including new electrical, plumbing upgrades, recessed and dimmable lighting, new baseboard electric heaters, new thermostats, new stainless steel appliances, a redesigned kitchen, upgraded bathroom and a fresh contemporary paint throughout. The stylish kitchen is both functional and eye-catching, featuring clean white soft close cabinetry, quality quartz countertops, modern fixtures & large island; ideal for everyday living and entertaining. Enjoy this prime location just a short walk from Riverside Country Club and Rothesay Tennis Club, also with access to local walking trails along the river. Additional features include a dedicated parking space, visitor parking, dedicated storage locker, additional laundry facilities, elevator access & a common lobby with shared library and occasional resident gatherings. Turn-key, pet-friendly & beautifully finished, this is an excellent opportunity to own in one of Rothesays most established condo communities. CONDO Fee $795.76 per month (includes electricity, water & sewer fee, building maintenance & grounds keeping year round). Current taxes reflect non-owner occupancy - property taxes for owner occupancy would be approx $3000 (id:62650)"
+"AssociationFee": "795.76"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "Full"
]
+"CreationDate": "2026-03-30T17:59:51.063412+00:00"
+"Directions": "ROTHESAY ROAD to LOW WOOD Estates"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1786681"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Treed"
1 => "Golf course/parkland"
]
+"LotSizeDimensions": "8.38"
+"ParcelNumber": "30032102"
+"PhotosChangeTimestamp": "2026-03-30T14:14:59Z"
+"PhotosCount": 18
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-02T12:29:05Z"
+"TaxAnnualAmount": "4315.68"
+"View": "River view"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=W3MvFXDLkc7"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:4 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29531450/2865-rothesay-road-unit-25-rothesay"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-03-30T14:14:59.3Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1189100"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:18 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
]
+"DaysOnMarket": 71
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29531450')"
+"ID": "1286141"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25171
+post_id: "1228239"
+post_author: 1
+"ListingKey": "29450925"
+"ListingId": "NB134756"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T17:50:08Z"
+"RFModificationTimestamp": "2026-06-01T17:59:54Z"
+"ListPrice": 295000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 8.38
+"LivingArea": 900.0
+"BuildingAreaTotal": 0
+"City": "Rothesay"
+"PostalCode": "E2E5V1"
+"UnparsedAddress": "2865 Rothesay Road Unit# 5, Rothesay, New Brunswick E2E5V1"
+"Coordinates": array:2 [
0 => -66.001471
1 => 45.378384
]
+"Latitude": 45.378384
+"Longitude": -66.001471
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Framed by the flats of Rothesay, this ground-level corner condo offers an appealing blend of walkability, comfort, and refined living. A coveted two-bedroom unit within the building, this immaculate one-bathroom condo feels elegant and serene. Unlike many modern layouts, the thoughtfully designed floor plan is not open-concept, allowing each room to feel distinct while creating a greater sense of space and functionality. The beautiful white kitchen is finished with sleek black quartz countertops, offering a timeless contrast. Refined touches throughout, including California shutters, reflect the care and organization that make this home feel polished and inviting. The corner positioning welcomes natural light and is complemented by blooming hydrangeas surrounding the patio, enhancing the setting. Step outside and enjoy one of Rothesays most walkable neighbourhoods, just moments from Riverside Country Club, Rothesay Tennis Club, Rothesay Netherwood School, Rothesay Park Middle School, nearby cafés, restaurants and a beloved crêperie. Practical features add even more appeal, including a dedicated parking space, visitor parking, in-unit laundry, a storage unit, elevator access and a welcoming lobby with a library. Residents also host occasional social gatherings in the lobby, contributing to the buildings friendly, sociable atmosphere. Elegant, immaculate and perfectly situated, this condo feels less like an apartment and more like a luxurious retreat in the heart of Rothesay. (id:62650)"
+"AssociationFee": "795.76"
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:1 [
0 => "Full"
]
+"CreationDate": "2026-03-10T17:04:15.650943+00:00"
+"Directions": "Old Rothesay Road."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1735040"
+"ListOfficeKey": "51407"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Treed"
1 => "Golf course/parkland"
]
+"LotSizeDimensions": "8.38"
+"ParcelNumber": "30034052"
+"PhotosChangeTimestamp": "2026-06-01T17:43:57Z"
+"PhotosCount": 32
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-01T17:43:57Z"
+"TaxAnnualAmount": "2482.28"
+"View": "River view"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29450925/2865-rothesay-road-unit-5-rothesay"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 900
+"OriginalEntryTimestamp": "2026-03-10T16:10:38.33Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1177797"
+"ListOfficeNationalAssociationId": "1007064"
+"Media": array:32 [
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]
]
+"DaysOnMarket": 91
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29450925')"
+"ID": "1228239"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 10
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
]