array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29879971 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23360
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23362
+post_id: "1513608"
+post_author: 1
+"ListingKey": "29879971"
+"ListingId": "NB140617"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T00:35:50Z"
+"RFModificationTimestamp": "2026-06-10T00:47:59Z"
+"ListPrice": 539900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 6.0
+"LotSizeArea": 725.0
+"LivingArea": 2786.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0B1"
+"UnparsedAddress": "17-19 Katrina Drive, Fredericton, New Brunswick E3G0B1"
+"Coordinates": array:2 [
0 => -66.711951
1 => 45.979824
]
+"Latitude": 45.979824
+"Longitude": -66.711951
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Both units included in sale! Together, the property boasts a grand total of six generously sized bedrooms, two full bathrooms, and two convenient half-baths, ensuring that space and privacy are never compromised. Each unit has its own laundry, hydro metre, driveway, and balcony overlooking the backyard. This side-by-side duplex in Fredericton boasts great potential! Designed to cater to a variety of lifestyles, this property is equally enticing as an addition to your investment portfolio, an ideal setup for multigenerational living, or a savvy homeowner who lives on one side while the tenant pays your mortgage from the other side. Spanning a total of over 2700 square feet of living space, the building is thoughtfully divided into two symmetrical units that each offer over 1,300 square feet of comfortable, independent living. The main floors of #17 and #19 each host an eat-in kitchen with balcony access, a spacious living room, powder bathroom, and a utility closet. Meanwhile, the finished lower levels each offer three bedrooms, a full bathroom, and the laundry closet. This smart design keeps the lively social spaces completely separate from the sleeping quarters, offering a peaceful environment for children, roommates, or tenants alike. Additionally, 17-19 Katrina Drive is ideally situated in Gilridge Estates. This popular neighbourhood is close to schools, the Brookside Mall, dining options, and main travel routes. Overall, its a popular community for families of all ages, especially with the nearby walking trails and park. With Route 105 closeby, you are minutes from the Westmorland Bridge and Frederictons southside amenities. This location is optimal whether you are living here yourself or renting the property! Whether you are looking to secure a solid investment property or seeking a spacious, flexible home that offers financial freedom, this Fredericton duplex for sale is ready to turn your real estate goals into reality. (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"BathroomsPartial": 2
+"CreationDate": "2026-06-10T00:47:51.293996+00:00"
+"Directions": "Clements to Gardiner to Katrina"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Carpeted"
1 => "Ceramic"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1755837"
+"ListOfficeKey": "65184"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "725"
+"ParcelNumber": "75383067"
+"PhotosChangeTimestamp": "2026-06-10T00:28:51Z"
+"PhotosCount": 44
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T00:28:51Z"
+"TaxAnnualAmount": "8513.01"
+"VirtualTourURLUnbranded": "https://youtube.com/shorts/kUpe9zhB9aE"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29879971/17-19-katrina-drive-fredericton"
+"StructureType": array:1 [
0 => "Multi-Family"
]
+"CoListAgentKey": "2071693"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2008610"
+"CoListOfficeKey": "65184"
+"GeocodeManualYN": false
+"RoadSurfaceType": array:1 [
0 => "Paved road"
]
+"CoListOfficeKey2": "65184"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 6
+"AboveGradeFinishedArea": 1410
+"OriginalEntryTimestamp": "2026-06-10T00:28:51.15Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1211835"
+"ListOfficeNationalAssociationId": "1007004"
+"CoListAgentNationalAssociationId": "1346891"
+"CoListAgentNationalAssociationId2": "1323383"
+"CoListOfficeNationalAssociationId": "1007004"
+"CoListOfficeNationalAssociationId2": "1007004"
+"Media": array:44 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29879971_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/70f43bb650f2f2f6b19f8601b500c887.webp"
"MediaSize" => 164741
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-70f43bb650f2f2f6b19f8601b500c887.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29879971_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/d02a70e6f81b27e8f1138c453464ab00.webp"
"MediaSize" => 60162
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-d02a70e6f81b27e8f1138c453464ab00.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29879971_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/d9ad132ac50c6f798ed1d81991e83912.webp"
"MediaSize" => 57101
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-d9ad132ac50c6f798ed1d81991e83912.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29879971_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/12740ba50d1129a8c5eb8a13b83fe4db.webp"
"MediaSize" => 56852
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-12740ba50d1129a8c5eb8a13b83fe4db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29879971_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/98267b262b0753cc6ca3b297542bbe16.webp"
"MediaSize" => 58420
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-98267b262b0753cc6ca3b297542bbe16.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29879971_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/32c45c4fdc7d98916d55cb44589a0d25.webp"
"MediaSize" => 45441
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-32c45c4fdc7d98916d55cb44589a0d25.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29879971_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/99cae4b4d3d30f0a5a0f8647e09ac509.webp"
"MediaSize" => 50800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-99cae4b4d3d30f0a5a0f8647e09ac509.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29879971_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/e6a027b21c9aeec46ea6e7c16a1e1678.webp"
"MediaSize" => 82990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-e6a027b21c9aeec46ea6e7c16a1e1678.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29879971_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/b614010964d059a1e07263659a1c36f7.webp"
"MediaSize" => 72114
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-b614010964d059a1e07263659a1c36f7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29879971_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/7c3a37babaa0c27c6507e85979b6753e.webp"
"MediaSize" => 81235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-7c3a37babaa0c27c6507e85979b6753e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29879971_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/2984bdcbf41760e0d9ba0080132349b5.webp"
"MediaSize" => 56967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-2984bdcbf41760e0d9ba0080132349b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29879971_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/3901c866ac42912ab832bd6b6bdb59cf.webp"
"MediaSize" => 65300
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-3901c866ac42912ab832bd6b6bdb59cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29879971_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/533ab0035c18437b9d2e48d15a989fbd.webp"
"MediaSize" => 82933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-533ab0035c18437b9d2e48d15a989fbd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29879971_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/9525d03aff9348af4e5b2f38da4d1f96.webp"
"MediaSize" => 65172
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-9525d03aff9348af4e5b2f38da4d1f96.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29879971_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/439b16590b1713ef95841a739c7ebb7f.webp"
"MediaSize" => 68097
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-439b16590b1713ef95841a739c7ebb7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29879971_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/002d517ce71b74f3111ce8f3db692609.webp"
"MediaSize" => 79432
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-002d517ce71b74f3111ce8f3db692609.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29879971_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/42734facf270bd40856bf41ed4a92b7d.webp"
"MediaSize" => 80595
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-42734facf270bd40856bf41ed4a92b7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29879971_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/e26df910c3c33a733b99c5127352b464.webp"
"MediaSize" => 49671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-e26df910c3c33a733b99c5127352b464.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29879971_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/1ad58c7d9d3e660f6cc1da558edf545d.webp"
"MediaSize" => 64995
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-1ad58c7d9d3e660f6cc1da558edf545d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29879971_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/9c57a9254fe7851593d0a86ae65a7a69.webp"
"MediaSize" => 70663
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-9c57a9254fe7851593d0a86ae65a7a69.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29879971_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/1c4686242fcb5c8b3d064f9e23431499.webp"
"MediaSize" => 147026
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-1c4686242fcb5c8b3d064f9e23431499.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29879971_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/ac9cd564c2425e08ed8ef6d08e0ba674.webp"
"MediaSize" => 84067
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-ac9cd564c2425e08ed8ef6d08e0ba674.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29879971_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/93540b6d776adf2f117cba977cec51e8.webp"
"MediaSize" => 73260
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-93540b6d776adf2f117cba977cec51e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29879971_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/66aa068b3b3da188589c9fa9fdb43ff7.webp"
"MediaSize" => 79029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-66aa068b3b3da188589c9fa9fdb43ff7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29879971_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/81a1a3d6c151f557fa0f43d158e00dbb.webp"
"MediaSize" => 123317
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-81a1a3d6c151f557fa0f43d158e00dbb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29879971_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/08d38793dbe27c85e8b83e539577360a.webp"
"MediaSize" => 170757
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-08d38793dbe27c85e8b83e539577360a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29879971_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/2f9a05b565c0e2b3f7e7442897e889d0.webp"
"MediaSize" => 75227
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-2f9a05b565c0e2b3f7e7442897e889d0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29879971_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/9e8b7020c6c87b0c2eab7268c517ec7f.webp"
"MediaSize" => 82675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-9e8b7020c6c87b0c2eab7268c517ec7f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29879971_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/c18f9596aa5a04156dcfd8679d3dc60c.webp"
"MediaSize" => 92840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-c18f9596aa5a04156dcfd8679d3dc60c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29879971_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/405d89460d6eb142d689b18de3555b63.webp"
"MediaSize" => 71526
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-405d89460d6eb142d689b18de3555b63.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29879971_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/f8e55999c60aff4c7c12ecdd071f0f43.webp"
"MediaSize" => 65740
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-f8e55999c60aff4c7c12ecdd071f0f43.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29879971_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/573cdbc6d864effee507494b154f24a6.webp"
"MediaSize" => 60958
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-573cdbc6d864effee507494b154f24a6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29879971_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/e29ac2c66f7ef2e17b667e54dfe862d3.webp"
"MediaSize" => 50383
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-e29ac2c66f7ef2e17b667e54dfe862d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29879971_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/95477152ef44ec7f7ead01436d159dce.webp"
"MediaSize" => 44952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-95477152ef44ec7f7ead01436d159dce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29879971_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/cf1756aefa1db46940c3ddcb97cb15a5.webp"
"MediaSize" => 78342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-cf1756aefa1db46940c3ddcb97cb15a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29879971_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/370df0146f4fe543681d390224058a94.webp"
"MediaSize" => 74750
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-370df0146f4fe543681d390224058a94.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29879971_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/7923f746b745260e9cca8761f38f303a.webp"
"MediaSize" => 49427
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-7923f746b745260e9cca8761f38f303a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29879971_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/1edd427177783c06cd1cec2afe1a7b31.webp"
"MediaSize" => 69920
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-1edd427177783c06cd1cec2afe1a7b31.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29879971_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/1b178322aa1820f6596417cd4a9db823.webp"
"MediaSize" => 70620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-1b178322aa1820f6596417cd4a9db823.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29879971_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/038334c1075a34c844f6133b6c80529d.webp"
"MediaSize" => 52600
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-038334c1075a34c844f6133b6c80529d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29879971_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/fd75ce1464222d0fcff56df7bd0dd187.webp"
"MediaSize" => 56780
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-fd75ce1464222d0fcff56df7bd0dd187.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29879971_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/01ac13e674e3b007820ffeca8d8eac0e.webp"
"MediaSize" => 169983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-01ac13e674e3b007820ffeca8d8eac0e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29879971_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/daa80aeb9e5b1921775c1c2776ce2083.webp"
"MediaSize" => 185991
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-daa80aeb9e5b1921775c1c2776ce2083.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29879971_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29879971/29d0965d847c264b3ac28d840ccab90e.webp"
"MediaSize" => 191450
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29879971/thumbnail-29d0965d847c264b3ac28d840ccab90e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140617"
"ResourceRecordKey" => "29879971"
"ModificationTimestamp" => "2026-06-10T00:28:51.16Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29879971')"
+"ID": "1513608"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.24 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 65184" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24808
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1755837" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24781
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29879971'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25126
+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 '29879971'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25142
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29879971' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-66.711951 45.979824)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25215
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1525725"
+post_author: 1
+"ListingKey": "29894610"
+"ListingId": "NB141760"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T14:40:15Z"
+"RFModificationTimestamp": "2026-06-12T20:06:49Z"
+"ListPrice": 559900.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 2
+"BedroomsTotal": 5.0
+"LotSizeArea": 885.0
+"LivingArea": 3451.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G9Y1"
+"UnparsedAddress": "91 Maclean Court, Fredericton, New Brunswick E3G9Y1"
+"Coordinates": array:2 [
0 => -66.703668
1 => 45.982183
]
+"Latitude": 45.982183
+"Longitude": -66.703668
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Spacious Family Home in Sought-After Regiment Creek! Welcome to this beautifully raised bungalow, ideally situated on a large, private lot at the end of a quiet cul-de-sac in the highly desirable Regiment Creek neighborhood. This exceptional family home offers outstanding curb appeal with a double paved driveway, attached double-car garage, and a private backyard perfect for relaxing or entertaining. Step inside to discover a bright and inviting interior featuring hardwood floors. The spacious living room showcases elegant tray ceilings, unique accent lighting, and a patio door leading to a private deck overlooking a fenced in back yard for your animals to play. The well-designed kitchen is sure to impress with plenty of cabinets and countertop space, a raised breakfast bar, large walk-in pantry, and all major appliances included. Adjacent to the kitchen, the sunny dining area offers beautiful backyard views, while French doors lead to a formal dining room for special occasions and family gatherings. The main level features 3 generously sized bedrooms, including a spacious primary suite complete with a full ensuite bath and direct access to the deck. A second full bathroom provides added convenience for family and guests. The lower level offers access to the true double-car garage, a convenient half bath with laundry area, a large mudroom, a great family room perfect for movie nights or entertaining, and ample storage space. Two more bedrooms each having their own bath, and a bonus room that would be perfect for a kitchenette. Comfort is ensured year-round with an efficient heat pump system. Located in one of Fredericton's most family-friendly neighborhoods, this home offers the perfect setting for growing families, where quiet streets, friendly neighbors, and conveniently close to the city. A rare opportunity to own a spacious, move-in-ready family home in one of the city's most desirable subdivisions! (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Raised bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 2
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-12T20:06:45.311616+00:00"
+"Directions": "Rote 105 to Regiment Creek Ave. then right onto Maclean Court and drive until the end of the court, civic 91."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Ceramic"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2058872"
+"ListOfficeKey": "289196"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "885"
+"ParcelNumber": "75388686"
+"ParkingFeatures": array:1 [
0 => "Integrated Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T14:32:08Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-12T14:32:07Z"
+"TaxAnnualAmount": "5945.45"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [
"RoomKey" => "1657717604"
"RoomType" => "Foyer"
"ListingId" => "NB141760"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "4'11'' x 18'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:07.99Z"
]
1 => array:11 [
"RoomKey" => "1657717605"
"RoomType" => "Utility room"
"ListingId" => "NB141760"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "8'4'' x 14'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:07.99Z"
]
2 => array:11 [
"RoomKey" => "1657717606"
"RoomType" => "3pc Ensuite bath"
"ListingId" => "NB141760"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "5'4'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:07.99Z"
]
3 => array:11 [
"RoomKey" => "1657717607"
"RoomType" => "Laundry room"
"ListingId" => "NB141760"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:07.99Z"
]
4 => array:11 [
"RoomKey" => "1657717608"
"RoomType" => "Hobby room"
"ListingId" => "NB141760"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 11'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:07.99Z"
]
5 => array:11 [
"RoomKey" => "1657717609"
"RoomType" => "Bedroom"
"ListingId" => "NB141760"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 13'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:07.99Z"
]
6 => array:11 [
"RoomKey" => "1657717610"
"RoomType" => "Bedroom"
"ListingId" => "NB141760"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 11'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:07.99Z"
]
7 => array:11 [
"RoomKey" => "1657717611"
"RoomType" => "Family room"
"ListingId" => "NB141760"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "13'4'' x 21'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:07.99Z"
]
8 => array:11 [
"RoomKey" => "1657717612"
"RoomType" => "Bedroom"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "11' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:07.99Z"
]
9 => array:11 [
"RoomKey" => "1657717613"
"RoomType" => "Foyer"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "7'10'' x 8'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
10 => array:11 [
"RoomKey" => "1657717614"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "6'11'' x 9'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
11 => array:11 [
"RoomKey" => "1657717615"
"RoomType" => "2pc Bathroom"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "3'8'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
12 => array:11 [
"RoomKey" => "1657717616"
"RoomType" => "Office"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "11'8'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
13 => array:11 [
"RoomKey" => "1657717617"
"RoomType" => "Bedroom"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 9'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
14 => array:11 [
"RoomKey" => "1657717618"
"RoomType" => "Bedroom"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
15 => array:11 [
"RoomKey" => "1657717619"
"RoomType" => "Living room"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "18'6'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
16 => array:11 [
"RoomKey" => "1657717620"
"RoomType" => "Dining room"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "11'10'' x 7'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
17 => array:11 [
"RoomKey" => "1657717621"
"RoomType" => "Dining room"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 14'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
18 => array:11 [
"RoomKey" => "1657717622"
"RoomType" => "Kitchen"
"ListingId" => "NB141760"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29894610"
"RoomLength" => null
"RoomDimensions" => "12' x 13'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-12T14:32:08Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29894610/91-maclean-court-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2005765"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1986675"
+"CoListOfficeKey": "289196"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "289196"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1986
+"OriginalEntryTimestamp": "2026-06-12T14:32:07.95Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1334434"
+"ListOfficeNationalAssociationId": "1375426"
+"CoListAgentNationalAssociationId": "1288160"
+"CoListAgentNationalAssociationId2": "1271082"
+"CoListOfficeNationalAssociationId": "1375426"
+"CoListOfficeNationalAssociationId2": "1375426"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29894610_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/7e46bccdc3e8df971b9fd026b4264c88.webp"
"MediaSize" => 143349
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-7e46bccdc3e8df971b9fd026b4264c88.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29894610_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/0a84ef4889342b80528eba19dc6ff5c4.webp"
"MediaSize" => 154990
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-0a84ef4889342b80528eba19dc6ff5c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29894610_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/047ef0e32eb6c46a1fc171912f6717f9.webp"
"MediaSize" => 153976
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-047ef0e32eb6c46a1fc171912f6717f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29894610_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/cba08a65ae7d800223d7af023d345031.webp"
"MediaSize" => 146157
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-cba08a65ae7d800223d7af023d345031.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29894610_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/56407a5b039b63177fc3641d7e5db83e.webp"
"MediaSize" => 71800
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-56407a5b039b63177fc3641d7e5db83e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29894610_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/d91aa85310b208b87d3c30a7c2c7f969.webp"
"MediaSize" => 73009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-d91aa85310b208b87d3c30a7c2c7f969.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29894610_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/83e6c4d323ff367438bf0feca1e278af.webp"
"MediaSize" => 77499
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-83e6c4d323ff367438bf0feca1e278af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29894610_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/2aa6713afddbe369b9962a0d6ef08be2.webp"
"MediaSize" => 75645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-2aa6713afddbe369b9962a0d6ef08be2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29894610_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/5f33ce9d01873cf1fe7efbd901d4794a.webp"
"MediaSize" => 81794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-5f33ce9d01873cf1fe7efbd901d4794a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29894610_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/6fb7c11f977adb9f26ad050c20c72ac8.webp"
"MediaSize" => 84428
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-6fb7c11f977adb9f26ad050c20c72ac8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29894610_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/e32fb76ea197e41ecc5e4cfe1eb08834.webp"
"MediaSize" => 86464
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-e32fb76ea197e41ecc5e4cfe1eb08834.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29894610_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/434d2c3a38da9435384a24c30b3eeda6.webp"
"MediaSize" => 89610
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-434d2c3a38da9435384a24c30b3eeda6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29894610_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29894610/bf2eca979950f0f65d7c354150528a84.webp"
"MediaSize" => 95562
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29894610/thumbnail-bf2eca979950f0f65d7c354150528a84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141760"
"ResourceRecordKey" => "29894610"
"ModificationTimestamp" => "2026-06-12T14:32:07.95Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29894610_4890_14"
…11
]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29894610')"
+"ID": "1525725"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1525726"
+post_author: 1
+"ListingKey": "29896430"
+"ListingId": "NB141782"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T17:50:06Z"
+"RFModificationTimestamp": "2026-06-12T18:07:22Z"
+"ListPrice": 644900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 1115.0
+"LivingArea": 1482.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0K8"
+"UnparsedAddress": "7 Geyssen Court, Fredericton, New Brunswick E3G0K8"
+"Coordinates": array:2 [
0 => -66.705868
1 => 45.981418
]
+"Latitude": 45.981418
+"Longitude": -66.705868
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "This newly constructed, modern 3 bedroom executive walk-out bungalow features an open concept living area with premium finishes, a beautiful kitchen island, and a spacious rear deck. The home is brand new and offers a contemporary layout perfect for comfortable living and entertaining, featuring light flooring, elegant pendant lighting, and a cozy fireplace focal point. This stunning property is move-in ready and waiting for its first residents to call it home. (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-12T18:07:11.296952+00:00"
+"Directions": "Clements Drive to Route 105 toRegiment Creek to Gilridge to Geyssen Court"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Insulated Concrete Forms"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1435111"
+"ListOfficeKey": "52787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Golf course/parkland"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1115"
+"ParcelNumber": "75571331"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-12T17:42:07Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-12T17:42:07Z"
+"TaxAnnualAmount": "22168.98"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/7_geyssen_ct_fredericton_nb/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29896430/7-geyssen-court-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1482
+"OriginalEntryTimestamp": "2026-06-12T17:42:07.79Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1096293"
+"ListOfficeNationalAssociationId": "1007091"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29896430')"
+"ID": "1525726"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+post_id: "1518330"
+post_author: 1
+"ListingKey": "29881879"
+"ListingId": "NB141322"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-13T16:20:01Z"
+"RFModificationTimestamp": "2026-06-13T16:21:28Z"
+"ListPrice": 374900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 715.0
+"LivingArea": 2032.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3A1A2"
+"UnparsedAddress": "99 Sunset Drive, Fredericton, New Brunswick E3A1A2"
+"Coordinates": array:2 [
0 => -66.686992
1 => 45.978193
]
+"Latitude": 45.978193
+"Longitude": -66.686992
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "One of Sunset Acres' most iconic addresses... Picture this: morning coffee on the side deck, your kids playing safely in the fully fenced backyard, neighbours who become lifelong friends, and a community that feels like family. This is the Sunset Acres lifestyle, and this home is your gateway to it. The moment you arrive, you'll feel it too. This is a true family home, thoughtfully upgraded and anything but cookie-cutter. Dual access entries and a well-designed kitchen with new appliances make everyday life smoother. Three bedrooms, two full bathrooms, and a south-facing bay window filled with light create a warm, welcoming space. Year-round comfort with newer ductless heat pumps keeps your family cozy. But here's what truly matters: the lower level is where childhood memories are made. A massive recreation space becomes your kids' jungle gym while you're upstairs cooking dinner. A second bathroom means no morning battles. Grandma has her own bedroom for weekend visits. This is the space where families actually live and thrive. The backyard is pure magic. A fully fenced, expansive space where you can watch your kids from the dinner table, where birthday celebrations happen, where neighborhood kids gather. This is where your family's best days unfold. And the neighborhood? This is Sunset Acres at its finest. A 2-minute walk to Sunset U-Pick means summer mornings picking berries for pancakes. Kent Street wading pool is steps away for hot summer days. The brand new Sunset Acres Elementary is a walk away. Your kids grow up with the same families, building friendships that last a lifetime. This is community. This is home. View the property book and book your showing today! (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-10T22:27:40.002595+00:00"
+"Directions": "From Main Street or Route 105/Ring Road, turn onto Sunset Drive and continue to civic #99. Home is located directly across from York Care Centre. A sign is up at the property."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2210414"
+"ListOfficeKey": "270874"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Level lot"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "715"
+"ParcelNumber": "01414481"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T15:15:23Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-13T16:14:20Z"
+"TaxAnnualAmount": "3165.95"
+"VirtualTourURLUnbranded": "https://drive.google.com/file/d/18pwbPK3xybnO9PNR-D5UO7mIJgec-PjU/view?usp=sharing"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29881879/99-sunset-drive-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1019
+"OriginalEntryTimestamp": "2026-06-10T15:15:23.51Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1456320"
+"ListOfficeNationalAssociationId": "1237075"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881879')"
+"ID": "1518330"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25212
+post_id: "1495634"
+post_author: 1
+"ListingKey": "29844952"
+"ListingId": "NB140712"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T19:20:47Z"
+"RFModificationTimestamp": "2026-06-07T19:37:33Z"
+"ListPrice": 514900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 1486.0
+"LivingArea": 2626.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G7V5"
+"UnparsedAddress": "126 McGregor Street, Fredericton, New Brunswick E3G7V5"
+"Coordinates": array:2 [
0 => -66.719581
1 => 45.980118
]
+"Latitude": 45.980118
+"Longitude": -66.719581
+"YearBuilt": 1981
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 126 McGregor, a spectacular 4-level split with an expansive (38x24) 3-bay garage, just minutes from downtown Fredericton! Step inside through the garage or front door, and be greeted by an entry space featuring built-ins for coats and shoes, a spacious flex area with a cozy WETT certified wood stove for chilly evenings. This level has a half bath/laundry and access to the lower level, where you'll discover a finished family room, utility room, and storage space. Move up a half level to a beautiful, open-plan great room and kitchen. Large windows provide stunning views of the tree-lined backyard and newly built pergola. The kitchen is a dream for both hosting and staying in the heart of the action with a new glass cooktop, new dishwasher, new stove and new fridge! The large island is perfect for meal prep and cooking, offering plenty of cabinets and counter space. This level also has a ductless heat pump perfectly placed for efficiency! Progress another half level to find three spacious bedrooms and a modern family bathroom with a double vanity and a convenient cheater door to the primary bedroom. The yard was recently fenced in - perfect for families with children and fur babies! The garage roof was replaced in 2021. Outside, a low-maintenance composite deck offers serene views of the private backyard. The property provides direct access to the walking trail system, and a city park is on the same street, making it ideal for families! Don't miss this fantastic opportunity! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "4 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-03T15:47:05.554960+00:00"
+"Directions": "Clements Drive, right on McGregor, home is on the right."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:4 [
0 => "Laminate"
1 => "Ceramic"
2 => "Vinyl"
3 => "Wood"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Slab"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Stove"
3 => "Electric"
4 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2110088"
+"ListOfficeKey": "270874"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1486"
+"ParcelNumber": "75356139"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T12:43:35Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-07T19:13:33Z"
+"TaxAnnualAmount": "4657.3"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=jxSamZ6wtAP"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29844952/126-mcgregor-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2098
+"OriginalEntryTimestamp": "2026-06-03T12:43:35.69Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1378671"
+"ListOfficeNationalAssociationId": "1237075"
+"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": 10
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29844952')"
+"ID": "1495634"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25190
+post_id: "1487352"
+post_author: 1
+"ListingKey": "29831563"
+"ListingId": "NB140767"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T13:20:17Z"
+"RFModificationTimestamp": "2026-06-09T13:22:58Z"
+"ListPrice": 449000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 2.47
+"LivingArea": 2002.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G7T7"
+"UnparsedAddress": "152 Claudie Road, Fredericton, New Brunswick E3G7T7"
+"Coordinates": array:2 [
0 => -66.700434
1 => 45.982272
]
+"Latitude": 45.982272
+"Longitude": -66.700434
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Nestled on a private 2.47-acre elevated lot, this bright, spacious split-entry home offers space, privacy, and exceptional versatility. A long driveway leads to the home, surrounded by landscaped grounds and mature trees creating your own peaceful retreat. The bright and spacious main level with two min-splits features an open-concept living room, kitchen, and dining area perfect for everyday living and entertaining. Patio doors lead to a large deck complete with gazebo, overlooking the beautifully private treed backyard. The main floor also offers 3 bedrooms, a generous bathroom with convenient access from both the primary bedroom and hallway, with potential to convert back to two full baths if desired. A spacious foyer welcomes you inside, while the lower level boasts a large sun-filled family room, laundry area with half bath, plus utility and storage space. Car enthusiasts, hobbyists, or business owners will appreciate both the attached garage and the impressive detached garage/workshop featuring a hoist. With room to work, play, and enjoy nature, this property offers a rare combination of comfort, privacy, and functionality. (Note the geothermal heat pump is not functioning and is sold as is) (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Split entry bungalow"
]
+"BathroomsPartial": 1
+"Cooling": array:3 [
0 => "Air exchanger"
1 => "Heat Pump"
2 => "Air Conditioned"
]
+"CreationDate": "2026-06-01T18:11:54.553397+00:00"
+"Directions": "Take the ring road west to Claudie road. On Claudie Road driveway is on the right. Driveway is long and between homes that are close to the road."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
3 => "Geo Thermal"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160709"
+"ListOfficeKey": "52796"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "2.47"
+"ParcelNumber": "75396499"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Detached Garage"
2 => "Heated Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T13:01:55Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-09T13:14:48Z"
+"TaxAnnualAmount": "5008.66"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
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]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29831563/152-claudie-road-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1568563"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "52796"
+"GeocodeManualYN": false
+"RoadSurfaceType": array:1 [
0 => "Paved road"
]
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1400
+"OriginalEntryTimestamp": "2026-06-01T12:43:36.28Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1411814"
+"ListOfficeNationalAssociationId": "1007101"
+"CoListAgentNationalAssociationId": "1150290"
+"CoListOfficeNationalAssociationId": "1007101"
+"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": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29831563')"
+"ID": "1487352"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25185
+post_id: "1476088"
+post_author: 1
+"ListingKey": "29817450"
+"ListingId": "NB138854"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-11T15:00:09Z"
+"RFModificationTimestamp": "2026-06-11T15:04:02Z"
+"ListPrice": 668000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 767.0
+"LivingArea": 3000.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3C1L5"
+"UnparsedAddress": "16 Mayflower Street, Fredericton, New Brunswick E3C1L5"
+"Coordinates": array:2 [
0 => -66.724178
1 => 45.965586
]
+"Latitude": 45.965586
+"Longitude": -66.724178
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "THE BUILDER ALSO BUILT THE HOME NEXT DOOR, WHICH IS AVAILABLE FOR VIEWINGS UNTIL JULY 10TH. THIS CURRENT BUILD WILL BE COMPLETE IN AUGUST! THE EXTERIOR COLOURS WILL BE THE SAME AS THE SIMULATED PHOTO! This newly constructed split entry home boasts an elegant and contemporary design, optimized for both comfort and style. The main floor encompasses a primary bedroom with ensuite, 2 more spacious bedrooms and full bathroom, and main floor laundry. A custom Wildwood kitchen with stainless steel appliances, serves as the heart of the home, flowing seamlessly into the dining room and living room ideal for entertaining or relaxing with family. From the kitchen leads to your back 16x12 composite deck overlooking your backyard. Main floor has 9ft ceilings. On the lower level, a large family room perfect for gatherings or leisure activities, along with an extra bedroom and bathroom offering privacy and convenience for guests or older children seeking more independence. These well-considered elements reflect meticulous attention to detail while providing functional spaces that meet diverse lifestyle requirements in today's modern living environment. Lower level gives you access to your attached oversized 1 car garage. Driveway will be crush rock and yard will be hydroseed. *LUX Home Warranty. *HST Rebate back to the vendor. Some photos have been simulated. (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-28T15:30:07.648223+00:00"
+"Directions": "Fredericton South to Woodstock Rd to Monteith Drive, to Mayflower St."
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1779773"
+"ListOfficeKey": "52805"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "767"
+"ParcelNumber": "75575845"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-11T14:50:57Z"
+"PhotosCount": 11
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-11T14:50:57Z"
+"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/29817450/16-mayflower-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 2150
+"OriginalEntryTimestamp": "2026-05-28T14:53:20.11Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1187594"
+"ListOfficeNationalAssociationId": "1094072"
+"Media": array:11 [
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]
]
+"DaysOnMarket": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29817450')"
+"ID": "1476088"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23374
+post_id: "1437473"
+post_author: 1
+"ListingKey": "29770658"
+"ListingId": "NB139790"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-24T19:20:13Z"
+"RFModificationTimestamp": "2026-05-24T19:24:42Z"
+"ListPrice": 474900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 5830.81
+"LivingArea": 2254.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G9W2"
+"UnparsedAddress": "42 Regiment Creek Avenue, Fredericton, New Brunswick E3G9W2"
+"Coordinates": array:2 [
0 => -66.702793
1 => 45.979597
]
+"Latitude": 45.979597
+"Longitude": -66.702793
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "This beautiful two-storey home offers everything a growing family could want, all nestled in a welcoming, family-friendly neighbourhood. The current owners have especially loved the close proximity to walking trails, ATV trails, parks, and surrounding wooded areas, perfect for enjoying the outdoors year-round. 42 Regiment makes a warm and inviting first impression from the moment you arrive. The oversized paved driveway offers ample parking for multiple vehicles and even has space for an RV or boat. The attached garage is an added bonus, complete with a recently installed heat pump for year-round comfort. Inside, The kitchen offers excellent functionality and flows seamlessly into the dining room, creating the perfect space for family meals and entertaining. This level also features a convenient half bath and main floor laundry. For added efficiency and comfort, the home includes two additional heat pumps inside the house. Upstairs, youll find three generously sized bedrooms. The spacious main bathroom features a corner soaker tub, separate shower, and cheater ensuite access to the oversized primary bedroom. The fully finished lower level adds even more living space with a large rec room complete with new built-in cabinetry, a fourth bedroom, rough-in for a third bathroom, and ample storage throughout. Step through the new french patio doors onto a beautiful back deck featuring convenient under-deck storage and a tasteful privacy wall, creating the perfect outdoor retreat. To top it all off, the property also includes an above-ground pool, ideal for enjoying summer days with family and friends. (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-19T19:04:28.853323+00:00"
+"Directions": "Take the 105 (Clements Drive) turn right onto Regiment Creek Ave and the property will be on the right. Civic # 42. Sign is up!"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2160583"
+"ListOfficeKey": "270874"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "5830.81"
+"ParcelNumber": "75380741"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Heated Garage"
]
+"PhotosChangeTimestamp": "2026-05-19T17:41:54Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-24T19:14:21Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "4305.37"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=nudr2JSn8Yx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29770658/42-regiment-creek-avenue-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1435139"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2204845"
+"CoListAgentKey3": "2189911"
+"CoListOfficeKey": "270874"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "270874"
+"CoListOfficeKey3": "270874"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1504
+"OriginalEntryTimestamp": "2026-05-19T17:41:53.79Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1411691"
+"ListOfficeNationalAssociationId": "1237075"
+"CoListAgentNationalAssociationId": "1086061"
+"CoListAgentNationalAssociationId2": "1457736"
+"CoListAgentNationalAssociationId3": "1439018"
+"CoListOfficeNationalAssociationId": "1237075"
+"CoListOfficeNationalAssociationId2": "1237075"
+"CoListOfficeNationalAssociationId3": "1237075"
+"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": 25
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29770658')"
+"ID": "1437473"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1425696"
+post_author: 1
+"ListingKey": "29754161"
+"ListingId": "NB139211"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-14T19:30:47Z"
+"RFModificationTimestamp": "2026-05-14T22:38:14Z"
+"ListPrice": 799900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 7064.0
+"LivingArea": 4667.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G9Y1"
+"UnparsedAddress": "90 MacLean Court, Fredericton, New Brunswick E3G9Y1"
+"Coordinates": array:2 [
0 => -66.703213
1 => 45.982211
]
+"Latitude": 45.982211
+"Longitude": -66.703213
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "A rare offering within the city limits of Fredericton: this sprawling ranch-style bungalow was originally custom built by the builder/developer for their own family and showcases an exceptional combination of scale, privacy & lifestyle rarely found so close to downtown. Nestled on 1.75 acres at the end of a quiet cul-de-sac, this property offers the kind of setting where children still play safely on the court with virtually no through traffic, all while being just 5 minutes to Brookside Mall and only 10 minutes to downtown. Backing onto Regiment Creek, it feels like a private nature retreat complete with a swimming hole in summer, approx. 50 maple trees ready for tapping, and even annual fiddlehead harvests reportedly reaching 40 lbs! Endless wooded surroundings connect to nearby hiking, snowshoeing, ATV and snowmobile trails, while close access to paved trails allows you to bike, scooter or walk right into town. The landscaped grounds not only offer secure privacy but also a brand new stone patio, covered screened-in porch, expansive fenced in area, and ample room for a pool. The paved driveway accommodates multiple vehicles with ease. Inside, the scale of the home is immediately impressive. The entire main levelincluding cabinetry, trim, and doorshas been freshly painted and is designed for comfortable single-level living. The layout features a massive open concept space connecting living, dining, office, chef's kitchen seamlessly & invitingly, with access to the garage via a newly refreshed laundry room. The spacious primary suite includes a luxurious ensuite with soaker tub & 2 person shower, while a separate wing offers two additional bedrooms and full bath. The walkout lower level opens the door to countless possibilities including an in-law suite, apartment, or Airbnb income opportunity, while still leaving abundant storage & recreation space including a finished fitness room. A truly unique opportunity to own your own private retreat in the capital of NB! (id:62783)"
+"ArchitecturalStyle": array:3 [
0 => "Bungalow"
1 => "Ranch"
2 => "2 Level"
]
+"Basement": array:3 [
0 => "Partially finished"
1 => "Full"
2 => "Walk out"
]
+"Cooling": array:3 [
0 => "Air exchanger"
1 => "Heat Pump"
2 => "Air Conditioned"
]
+"CreationDate": "2026-05-14T22:36:37.244718+00:00"
+"Directions": "Route 105 to Regiment Creek Ave then Right on MacLean Crt. At the end of the court civic #90. Sign will be posted."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Carpeted"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Forced air"
3 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1753487"
+"ListOfficeKey": "285230"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Treed"
2 => "Wheelchair access"
]
+"LotSizeDimensions": "7064"
+"ParcelNumber": "75396192"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-14T19:22:36Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-14T19:22:36Z"
+"TaxAnnualAmount": "8442.95"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/90_maclean_ct_fredericton_nb/"
+"WaterBodyName": "Regiment Creek"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29754161/90-maclean-court-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"WaterfrontFeatures": array:1 [
0 => "Waterfront"
]
+"AboveGradeFinishedArea": 2510
+"OriginalEntryTimestamp": "2026-05-14T19:22:36.6Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1182902"
+"ListOfficeNationalAssociationId": "1349077"
+"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": 30
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29754161')"
+"ID": "1425696"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1405706"
+post_author: 1
+"ListingKey": "29723969"
+"ListingId": "NB138862"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-08T18:41:13Z"
+"RFModificationTimestamp": "2026-05-08T18:54:21Z"
+"ListPrice": 574900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 718.0
+"LivingArea": 2210.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0G3"
+"UnparsedAddress": "141 Regiment Creek Avenue, Fredericton, New Brunswick E3G0G3"
+"Coordinates": array:2 [
0 => -66.705008
1 => 45.982016
]
+"Latitude": 45.982016
+"Longitude": -66.705008
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Brand new and beautifully crafted! This elevated design comes with home warranty and all major appliances. The yard is landscaped and this location is incredibly convenient to Frederictons amenities while being set within a growing family-friendly neighbourhood that is also close to schools, parks, and ATV trails! From the moment you arrive, the clean architectural lines and inviting curb appeal create an immediate sense of style and sophistication. Inside, the bright open-concept main living area is designed for both everyday comfort and effortless entertaining. Natural light pours through the space, highlighting the seamless flow between the living room, dining area, and stunning contemporary kitchen. Featuring sleek cabinetry, soft-close drawers, solid surface countertops, and a large center island, this kitchen is as practical as it is beautiful. The main level also offers three spacious bedrooms, including a serene primary suite complete with a private ensuite bath. A second full bathroom provides added convenience for family and guests alike. Downstairs, the bright fully finished lower level expands your living space with a generous family room ideal for movie nights, a home gym, playroom, or entertaining area. A fourth bedroom and third bathroom with integrated laundry add flexibility for growing families, guests, or work-from-home needs. Direct access to the attached garage ensures convenience in every season. Stylish, functional, and completely move-in ready, this home offers the perfect balance of comfort and contemporary design for todays modern lifestyle. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-08T18:53:55.729746+00:00"
+"Directions": "Clements Drive to Regiment Creek Ave. (Corner of Regiment Creek and GILRIDGE)"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"FoundationDetails": array:2 [
0 => "Concrete"
1 => "Slab"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1643263"
+"ListOfficeKey": "289196"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "718"
+"ParcelNumber": "75536417"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-08T18:31:21Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-08T18:31:21Z"
+"TaxAnnualAmount": "5288.1"
+"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/29723969/141-regiment-creek-avenue-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2042989"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "1910852"
+"CoListOfficeKey": "289196"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "289196"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2210
+"OriginalEntryTimestamp": "2026-05-08T18:22:55.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1190423"
+"ListOfficeNationalAssociationId": "1375426"
+"CoListAgentNationalAssociationId": "1318852"
+"CoListAgentNationalAssociationId2": "1276005"
+"CoListOfficeNationalAssociationId": "1375426"
+"CoListOfficeNationalAssociationId2": "1375426"
+"Media": array:41 [
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]
]
+"DaysOnMarket": 36
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29723969')"
+"ID": "1405706"
}
]
+success: true
+page_size: 9
+page_count: 2
+count: 16
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]