array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29914456 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1538715"
+post_author: 1
+"ListingKey": "29914456"
+"ListingId": "NB142054"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T13:20:04Z"
+"RFModificationTimestamp": "2026-06-17T13:34:29Z"
+"ListPrice": 159900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1088.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0S3"
+"UnparsedAddress": "94 Glenmar Drive, Fredericton, New Brunswick E3G0S3"
+"Coordinates": array:2 [
0 => -66.640346
1 => 46.009636
]
+"Latitude": 46.009636
+"Longitude": -66.640346
+"YearBuilt": 2006
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this one owner mini home located in desired Heron Springs onthe Northside of Fredericton. A double width driveway will lead you to the 16' x 10.6' deck complete with gazebo. The entrance c/w double closet takes you to the kitchen/eating area with oak cupboards and a double window that gives in great natural light. To the right there is a small hallway with a pantry and washer/dryer plus the primary bedroom. To the left of the kitchen is a good sized living room again with another large window, down the hall to 2 more bedrooms and the full bathroom. Cushion flooring throughout makes for easy cleaning. Included is also a storage barn. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Air exchanger"
]
+"CreationDate": "2026-06-17T13:34:18.968683+00:00"
+"Directions": "Brookside Drive to Glenmar"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Wood/Piers"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1559591"
+"ListOfficeKey": "270874"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "PAN05789722"
+"PhotosChangeTimestamp": "2026-06-17T12:32:58Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T13:12:00Z"
+"TaxAnnualAmount": "1247.97"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1661085528"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB142054"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914456"
"RoomLength" => null
"RoomDimensions" => "5'5'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:12:00.99Z"
]
1 => array:11 [
"RoomKey" => "1661085529"
"RoomType" => "Bedroom"
"ListingId" => "NB142054"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914456"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:12:00.99Z"
]
2 => array:11 [
"RoomKey" => "1661085530"
"RoomType" => "Bedroom"
"ListingId" => "NB142054"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914456"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 11'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:12:00.99Z"
]
3 => array:11 [
"RoomKey" => "1661085531"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB142054"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914456"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 12'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:12:00.99Z"
]
4 => array:11 [
"RoomKey" => "1661085532"
"RoomType" => "Living room"
"ListingId" => "NB142054"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914456"
"RoomLength" => null
"RoomDimensions" => "13'6'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:12:00.99Z"
]
5 => array:11 [
"RoomKey" => "1661085533"
"RoomType" => "Kitchen"
"ListingId" => "NB142054"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29914456"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 14'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T13:12:00.99Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29914456/94-glenmar-drive-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1662104"
+"CommonInterest": "Leasehold"
+"CoListOfficeKey": "270874"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1088
+"OriginalEntryTimestamp": "2026-06-17T12:32:58.47Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1146649"
+"ListOfficeNationalAssociationId": "1237075"
+"CoListAgentNationalAssociationId": "1168170"
+"CoListOfficeNationalAssociationId": "1237075"
+"Media": array:32 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29914456_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/f02ef9b8fbe7385cabb7520eb76994e8.webp"
"MediaSize" => 158935
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-f02ef9b8fbe7385cabb7520eb76994e8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29914456_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/365037d355b1b9fc5607a4c5adaa98bc.webp"
"MediaSize" => 163073
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-365037d355b1b9fc5607a4c5adaa98bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29914456_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/22823666124d67f624fe4db535c6e680.webp"
"MediaSize" => 73468
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-22823666124d67f624fe4db535c6e680.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29914456_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/e9e8ccefc0c62297789f2b222b07de82.webp"
"MediaSize" => 84812
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-e9e8ccefc0c62297789f2b222b07de82.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29914456_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/8ee9abb68ed9cc8edd20b8a736cd1f6d.webp"
"MediaSize" => 75886
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-8ee9abb68ed9cc8edd20b8a736cd1f6d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29914456_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/7da2e43642f57f5fb3fa5306e7c2e373.webp"
"MediaSize" => 90113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-7da2e43642f57f5fb3fa5306e7c2e373.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29914456_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/8e778644eedc4cff65137e90339734ad.webp"
"MediaSize" => 82605
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-8e778644eedc4cff65137e90339734ad.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29914456_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/324d6848bd67e1e5c171debb0e074a0b.webp"
"MediaSize" => 77212
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-324d6848bd67e1e5c171debb0e074a0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29914456_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/bfacab5d90533f343ea5704306e52424.webp"
"MediaSize" => 91516
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-bfacab5d90533f343ea5704306e52424.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29914456_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/526778ea5a5a715755911ccf053a7134.webp"
"MediaSize" => 80580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-526778ea5a5a715755911ccf053a7134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29914456_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/bee6ecbea8ae7764863ec2721969855f.webp"
"MediaSize" => 76354
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-bee6ecbea8ae7764863ec2721969855f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29914456_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/69c4892046c33b1a43e106a06ad37b8d.webp"
"MediaSize" => 72586
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-69c4892046c33b1a43e106a06ad37b8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29914456_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/97da564ad0062bd8a7173c67d6b6a486.webp"
"MediaSize" => 80517
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-97da564ad0062bd8a7173c67d6b6a486.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29914456_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/e7f8d1502f21acc545afe7db77537051.webp"
"MediaSize" => 78394
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-e7f8d1502f21acc545afe7db77537051.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29914456_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/98499bb8b3e8c5e0f8c45701fd611932.webp"
"MediaSize" => 64950
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-98499bb8b3e8c5e0f8c45701fd611932.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29914456_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/6282fb415f0f35b159db0258df6c3de9.webp"
"MediaSize" => 96155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-6282fb415f0f35b159db0258df6c3de9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29914456_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/d04d0528fa7f6d9e8deaf08e3636155e.webp"
"MediaSize" => 94854
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-d04d0528fa7f6d9e8deaf08e3636155e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29914456_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/d1d02049ef0f2b7512f7f27360ea7877.webp"
"MediaSize" => 74642
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-d1d02049ef0f2b7512f7f27360ea7877.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29914456_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/c853850c81d923c699b3f620a12aba9e.webp"
"MediaSize" => 78769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-c853850c81d923c699b3f620a12aba9e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29914456_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/304d79c643c50eff3d8c2aa38eb2d245.webp"
"MediaSize" => 71287
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-304d79c643c50eff3d8c2aa38eb2d245.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29914456_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/e648d6e4fcde61f8958081e4fb61a0ea.webp"
"MediaSize" => 51946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-e648d6e4fcde61f8958081e4fb61a0ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29914456_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/e4df193c1f5aa0f00e16fc99bc62cb52.webp"
"MediaSize" => 93668
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-e4df193c1f5aa0f00e16fc99bc62cb52.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29914456_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/8a40750110d832067dbfed7638f25773.webp"
"MediaSize" => 60503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-8a40750110d832067dbfed7638f25773.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29914456_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/da8148a9ea48aacff09acf4ae13ca28a.webp"
"MediaSize" => 148393
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-da8148a9ea48aacff09acf4ae13ca28a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29914456_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/581bfbf7cf9a0b3cb9393071539b758f.webp"
"MediaSize" => 155253
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-581bfbf7cf9a0b3cb9393071539b758f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29914456_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/d2cfcf026b2545ad06e7558bc7bc0026.webp"
"MediaSize" => 156183
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-d2cfcf026b2545ad06e7558bc7bc0026.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29914456_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/489e34ca608774f9f44a0c7824bb0b13.webp"
"MediaSize" => 134504
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-489e34ca608774f9f44a0c7824bb0b13.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29914456_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/bda5a65edb87ae1b4375102e2420094f.webp"
"MediaSize" => 141679
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-bda5a65edb87ae1b4375102e2420094f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29914456_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/1427e51b40a2420396d5ad0be9c6d72c.webp"
"MediaSize" => 163840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-1427e51b40a2420396d5ad0be9c6d72c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29914456_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/0ec7b5f1a0979281a61394844cd642a7.webp"
"MediaSize" => 141235
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-0ec7b5f1a0979281a61394844cd642a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29914456_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/8173d08b80edecbf33d6506ea70f7908.webp"
"MediaSize" => 142029
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-8173d08b80edecbf33d6506ea70f7908.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29914456_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29914456/125006fd4f74d949b93db0fec58a4985.webp"
"MediaSize" => 118957
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29914456/thumbnail-125006fd4f74d949b93db0fec58a4985.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142054"
"ResourceRecordKey" => "29914456"
"ModificationTimestamp" => "2026-06-17T12:32:58.48Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914456')"
+"ID": "1538715"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 270874" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24755
+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 1559591" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24840
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29914456'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25149
+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 '29914456'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25167
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25165
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31512786"
+"ListingKey": "29914456"
+"ListingId": "NB142054"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-18"
+"OpenHouseStartTime": "2026-06-18T17:00:00Z"
+"OpenHouseEndTime": "2026-06-18T19:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-18T06:34:48Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31512786')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29914456' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-66.640346 46.009636)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25220
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25214
+post_id: "1539521"
+post_author: 1
+"ListingKey": "29915345"
+"ListingId": "NB142113"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:50:09Z"
+"RFModificationTimestamp": "2026-06-17T21:11:08Z"
+"ListPrice": 329900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 495.0
+"LivingArea": 1027.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B5V6"
+"UnparsedAddress": "85 Stairs Street, Fredericton, New Brunswick E3B5V6"
+"Coordinates": array:2 [
0 => -66.653464
1 => 45.996615
]
+"Latitude": 45.996615
+"Longitude": -66.653464
+"YearBuilt": 1990
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "ONE-LEVEL LIVING, ENDLESS POSSIBILITIES! Welcome to this meticulously maintained bungalow, proudly cared for by only its second owner. Homes like this don't come along often that offers the perfect blend of comfort, convenience, and long-term value in a location buyers love. From the moment you step inside, you'll appreciate the bright, functional layout designed for easy everyday living. The spacious kitchen features timeless oak cabinetry, abundant storage, and a sunny dining area that flows effortlessly into the welcoming living roomperfect for gathering with family and friends. Three generous bedrooms provide plenty of space, while the convenient main-floor laundry eliminates the need for stairs. Step outside and discover a backyard designed for summer enjoyment. Cool off on hot summer days in your own pool, then unwind in the evenings with family and friends, creating memories under the stars. The impressive storage barn with electricity offers incredible flexibility for hobbies, projects, storage, or a future workshop. Located just minutes from shopping, restaurants, schools, medical services, and public transit, you'll enjoy the convenience of having everything you need close at hand. Whether you're a first-time buyer, downsizer, or investor, this move-in-ready home offers the ease of one-level living combined with outdoor features that are sure to be enjoyed for years to come. Well-maintained, lovingly cared for, and offering exceptional value, this is the kind of property buyers wait for, and one that won't last long. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Crawl space"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-17T16:23:18.609748+00:00"
+"Directions": "Brookside drive to Terrance, left to Stairs street #85."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2095483"
+"ListOfficeKey": "52796"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "495"
+"ParcelNumber": "75281626"
+"PhotosChangeTimestamp": "2026-06-17T20:41:16Z"
+"PhotosCount": 31
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T20:41:16Z"
+"TaxAnnualAmount": "3013.23"
+"VirtualTourURLUnbranded": "https://youriguide.com/85_stairs_st_fredericton_nb/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1661470364"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB142113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915345"
"RoomLength" => null
"RoomDimensions" => "5'1'' x 7'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:40:56.1Z"
]
1 => array:11 [
"RoomKey" => "1661470365"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB142113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915345"
"RoomLength" => null
"RoomDimensions" => "11'9'' x 14'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:40:56.1Z"
]
2 => array:11 [
"RoomKey" => "1661470366"
"RoomType" => "Bedroom"
"ListingId" => "NB142113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915345"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:40:56.1Z"
]
3 => array:11 [
"RoomKey" => "1661470367"
"RoomType" => "Bedroom"
"ListingId" => "NB142113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915345"
"RoomLength" => null
"RoomDimensions" => "8'9'' x 10'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:40:56.1Z"
]
4 => array:11 [
"RoomKey" => "1661470368"
"RoomType" => "Living room"
"ListingId" => "NB142113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915345"
"RoomLength" => null
"RoomDimensions" => "12'1'' x 19'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:40:56.1Z"
]
5 => array:11 [
"RoomKey" => "1661470369"
"RoomType" => "Dining room"
"ListingId" => "NB142113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915345"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:40:56.1Z"
]
6 => array:11 [
"RoomKey" => "1661470370"
"RoomType" => "Kitchen"
"ListingId" => "NB142113"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29915345"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 11'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:40:56.11Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29915345/85-stairs-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1027
+"OriginalEntryTimestamp": "2026-06-17T14:53:25.77Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1367629"
+"ListOfficeNationalAssociationId": "1007101"
+"Media": array:31 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29915345_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/9a359e44b89fd2c90dcc2be3e1be9ad0.webp"
"MediaSize" => 139421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-9a359e44b89fd2c90dcc2be3e1be9ad0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.72Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29915345_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/1e63a8925334fc0c7cb8f8f45ad0c076.webp"
"MediaSize" => 149883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-1e63a8925334fc0c7cb8f8f45ad0c076.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:19.33Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29915345_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/58871586127abb016bd7380481968228.webp"
"MediaSize" => 45656
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-58871586127abb016bd7380481968228.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.74Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29915345_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/a21fbe24520eac6b0a797d4de74ffe0b.webp"
"MediaSize" => 47436
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-a21fbe24520eac6b0a797d4de74ffe0b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:19.33Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29915345_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/df60fd1e7fc578f17f533fc35e963d7b.webp"
"MediaSize" => 106049
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-df60fd1e7fc578f17f533fc35e963d7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.73Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29915345_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/8388963a9dd2efd750d447a33cf34df5.webp"
"MediaSize" => 109531
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-8388963a9dd2efd750d447a33cf34df5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:17.59Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29915345_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/1cc80dffb4f668f637b693a24cf66779.webp"
"MediaSize" => 87811
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-1cc80dffb4f668f637b693a24cf66779.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.74Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29915345_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/2620e847ba358285a91b89906b354051.webp"
"MediaSize" => 86612
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-2620e847ba358285a91b89906b354051.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.75Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29915345_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/8982c471a02e3f5e067afbdc6e243bbf.webp"
"MediaSize" => 51347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-8982c471a02e3f5e067afbdc6e243bbf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:17.59Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29915345_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/255526e1ad8fc4935ce883148a4af251.webp"
"MediaSize" => 93655
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-255526e1ad8fc4935ce883148a4af251.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.74Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29915345_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/40b0be21cbec29ce1e36163bdfe25b90.webp"
"MediaSize" => 92228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-40b0be21cbec29ce1e36163bdfe25b90.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:17.65Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29915345_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/d9e9852c42b64c6bd64101de47bad1f8.webp"
"MediaSize" => 49821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-d9e9852c42b64c6bd64101de47bad1f8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:17.58Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29915345_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/598eacb1b1403427789bc9c5d8417f1d.webp"
"MediaSize" => 56519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-598eacb1b1403427789bc9c5d8417f1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.73Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29915345_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/b6b77811ac53bd62f425c10f756f39b4.webp"
"MediaSize" => 89986
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-b6b77811ac53bd62f425c10f756f39b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.72Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29915345_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/68ed1ff698f8454cadbd7549d513eeed.webp"
"MediaSize" => 81366
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-68ed1ff698f8454cadbd7549d513eeed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.75Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29915345_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/26eb601b41b2b55aaaf608d78763d631.webp"
"MediaSize" => 91465
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-26eb601b41b2b55aaaf608d78763d631.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.72Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29915345_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/01a6d8b57c1891d07e570b8b3348dc55.webp"
"MediaSize" => 90382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-01a6d8b57c1891d07e570b8b3348dc55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:19.36Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29915345_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/83c798e23f9fe7a9acce904e6cd8d9be.webp"
"MediaSize" => 134881
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-83c798e23f9fe7a9acce904e6cd8d9be.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.73Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29915345_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/e285e56de2ede77caddd8f4df3652361.webp"
"MediaSize" => 154987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-e285e56de2ede77caddd8f4df3652361.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.72Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29915345_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/539690c9e0386c15cb33f7c7a0b6091f.webp"
"MediaSize" => 135213
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-539690c9e0386c15cb33f7c7a0b6091f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:19.33Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29915345_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/918f7be755dee70f38607075446d1a04.webp"
"MediaSize" => 116883
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-918f7be755dee70f38607075446d1a04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.72Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29915345_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/ed841179fcd9ebf16236171efbbadde6.webp"
"MediaSize" => 179670
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-ed841179fcd9ebf16236171efbbadde6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.73Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29915345_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/3e7e64cfecf2bbfd867bff9f193f46f2.webp"
"MediaSize" => 195231
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-3e7e64cfecf2bbfd867bff9f193f46f2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.75Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29915345_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/1c70d6e3a07a1c9ef609a891bba9373a.webp"
"MediaSize" => 163966
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-1c70d6e3a07a1c9ef609a891bba9373a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:19.33Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29915345_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/2493f86bc9857f9aa9a03c2b641051cd.webp"
"MediaSize" => 179492
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-2493f86bc9857f9aa9a03c2b641051cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T15:02:18.73Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29915345_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/c1b4fea73278c735b4cb94ca7fe3eb55.webp"
"MediaSize" => 51265
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-c1b4fea73278c735b4cb94ca7fe3eb55.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T20:41:08.33Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29915345_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/914c939cd70cddb1e8fc363ee05eae37.webp"
"MediaSize" => 54113
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-914c939cd70cddb1e8fc363ee05eae37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T20:41:08.33Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29915345_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/5bfb2865cf1f0fc83e5f3201b1521489.webp"
"MediaSize" => 63251
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-5bfb2865cf1f0fc83e5f3201b1521489.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T20:41:07.89Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29915345_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/c6a6e2a0a9c3c40b22b974d812b183d9.webp"
"MediaSize" => 54480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-c6a6e2a0a9c3c40b22b974d812b183d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T20:41:08.32Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29915345_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/e11e9da09eb641f35b332ae4d67b1846.webp"
"MediaSize" => 56188
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-e11e9da09eb641f35b332ae4d67b1846.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T20:41:09.35Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29915345_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29915345/66922a3d0bc71eee93efc0ee4897799f.webp"
"MediaSize" => 63776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29915345/thumbnail-66922a3d0bc71eee93efc0ee4897799f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142113"
"ResourceRecordKey" => "29915345"
"ModificationTimestamp" => "2026-06-17T20:41:08.33Z"
]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915345')"
+"ID": "1539521"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25216
+post_id: "1516041"
+post_author: 1
+"ListingKey": "29884429"
+"ListingId": "NB141281"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T21:20:04Z"
+"RFModificationTimestamp": "2026-06-10T21:39:03Z"
+"ListPrice": 174500.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 960.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0S3"
+"UnparsedAddress": "185 Glenmar Drive, Fredericton, New Brunswick E3G0S3"
+"Coordinates": array:2 [
0 => -66.644455
1 => 46.010854
]
+"Latitude": 46.010854
+"Longitude": -66.644455
+"YearBuilt": 2008
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 185 Glenmar Drive, a charming and affordable one-level mini home located in the sought-after Heron Springs community on Frederictons North Side. This well-maintained home offers a thoughtful layout with two spacious bedrooms positioned at opposite ends of the home, providing excellent privacy for family members, guests, or a home office setup. The bright and inviting interior has been refreshed with updated paint and features comfortable living spaces designed for easy everyday living. The primary bedroom includes its own convenient two-piece ensuite, while the main bathroom serves the remainder of the home. A mini-split heat pump installed in 2022 provides energy-efficient heating and cooling for year-round comfort. Outside, youll appreciate the homes attractive curb appeal, double-wide driveway with plenty of parking space, and recent exterior improvements including a new front deck and new rear entry steps. Whether youre enjoying your morning coffee or welcoming guests, these upgrades add both function and charm. Located just minutes from Killarney Lake Park and Lodge, youll have easy access to walking trails, swimming, paddling, and year-round outdoor recreation. Grocery stores, shopping, restaurants, and other everyday amenities are only about seven minutes away, offering the perfect balance of peaceful community living and convenient city access. Whether youre a first-time buyer, downsizer, or someone seeking low-maintenance one-level living, 185 Glenmar Drive is a wonderful place to call home. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-10T21:38:55.773583+00:00"
+"Directions": "Take Brookside Drive to Glenmar Drive to civic #185 on the right"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Wood/Piers"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Baseboard heaters"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1435184"
+"ListOfficeKey": "52805"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "PAN: 05968627"
+"PhotosChangeTimestamp": "2026-06-10T19:15:44Z"
+"PhotosCount": 33
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T21:14:08Z"
+"TaxAnnualAmount": "1233.26"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1656525385"
"RoomType" => "Laundry room"
"ListingId" => "NB141281"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884429"
"RoomLength" => null
"RoomDimensions" => "5'6'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:14:08.8Z"
]
1 => array:11 [
"RoomKey" => "1656525386"
"RoomType" => "2pc Ensuite bath"
…9
]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29884429/185-glenmar-drive-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": false
+"RoadSurfaceType": array:1 [
0 => "Paved road"
]
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 960
+"OriginalEntryTimestamp": "2026-06-10T19:15:43.77Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1121533"
+"ListOfficeNationalAssociationId": "1094072"
+"Media": array:33 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884429')"
+"ID": "1516041"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25213
+post_id: "1514964"
+post_author: 1
+"ListingKey": "29880823"
+"ListingId": "NB141572"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T19:20:06Z"
+"RFModificationTimestamp": "2026-06-14T19:20:52Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 793.0
+"LivingArea": 3404.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0L3"
+"UnparsedAddress": "7 Aurora Street, Fredericton, New Brunswick E3G0L3"
+"Coordinates": array:2 [
0 => -66.651638
1 => 46.006241
]
+"Latitude": 46.006241
+"Longitude": -66.651638
+"YearBuilt": 2023
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 7 Aurora Street, a beautifully designed home on a desirable corner lot in sought-after Brookside West. Offering 6 bedrooms, 3.5 bathrooms, an unfinished bonus room above the garage, and an additional flex space ideal for a home office, den, nursery, or extra bedroom, this home provides exceptional space for modern family living. The bright, open-concept layout features high ceilings, large living spaces, and stylish modern finishes throughout. The kitchen, dining, and living areas flow seamlessly together, making the home perfect for both everyday living and entertaining. An oversized kitchen island provides ample space for meal preparation, casual dining, and gathering with family and friends. Built with comfort and efficiency in mind, the home features an ICF basement, a full forced-air heat pump system, a dedicated 240-volt circuit for a level 2 EV charging station, generator hookup, and an energy-efficient 8-person hot tub. Enjoy added luxury with heated floors in all three full bathrooms, while the convenience of two laundry hookups (one on the second floor and one in the basement) offers flexibility for busy households. Step outside to a fully fenced backyard, perfect for children, pets, and outdoor entertaining. Located in the popular Brookside West community, you'll enjoy easy access to parks, walking trails, schools, shopping, and recreation. Combining space, quality, versatility, and energy-efficient features, this is a home you'll be proud to call your own. (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-10T13:41:17.991246+00:00"
+"Directions": "Take Westmorland St, Rte 105 N/NB-105 N and Brookside Dr to Heron Dr. Follow Heron to Aurora."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Concrete"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Insulated Concrete Forms"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1914735"
+"ListOfficeKey": "283841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Golf course/parkland"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "793"
+"ParcelNumber": "75552075"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T12:30:53Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-14T19:14:25Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "7446.1"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=z34DdagygPg"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29880823/7-aurora-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2255427"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283841"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 3404
+"OriginalEntryTimestamp": "2026-06-10T12:29:41.67Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1224172"
+"ListOfficeNationalAssociationId": "1335718"
+"CoListAgentNationalAssociationId": "1494457"
+"CoListOfficeNationalAssociationId": "1335718"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880823')"
+"ID": "1514964"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25217
+post_id: "1514965"
+post_author: 1
+"ListingKey": "29880899"
+"ListingId": "NB141561"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-12T22:20:24Z"
+"RFModificationTimestamp": "2026-06-12T22:25:35Z"
+"ListPrice": 388000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 515.0
+"LivingArea": 1375.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G4C8"
+"UnparsedAddress": "114 Aiden Street, Fredericton, New Brunswick E3G4C8"
+"Coordinates": array:2 [
0 => -66.635462
1 => 46.013735
]
+"Latitude": 46.013735
+"Longitude": -66.635462
+"YearBuilt": 2026
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Looking for an affordable new construction home close to nature and city amenities? This could be the one you've been waiting for! Welcome to this brand-new semi-detached home located at 114 Aiden Street. Offering the perfect blend of comfort, style, and low-maintenance living. Built in 2026 and situated on a spacious 515 sq. m. lot, this thoughtfully designed home features approximately 1,400 sq. ft. of finished living space and is an excellent opportunity for first-time buyers looking to enter the market. The bright, open-concept main level is sure to impress, featuring vaulted ceilings that create a spacious and inviting atmosphere. The living, dining, and kitchen areas flow seamlessly together, making everyday living and entertaining easy, while a convenient half bath completes the upper level. Downstairs, you'll find two comfortable bedrooms, a full bathroom, laundry area, and mechanical room, offering a practical layout that makes the most of the space. Enjoy year-round comfort with an energy-efficient mini-split heat pump in the living room, and appreciate the added value of all major appliances being included. Located just a short walk from Killarney Lake Park, you'll love having access to scenic trails, swimming, paddling, and year-round outdoor recreation. West Hills Golf, or other major amenities are also within minutes of your door step. Whether you're starting out, downsizing, or simply looking for a move-in-ready home in a great location, this property is one you won't want to miss. Note - Vendor is a Licensed REALTOR® in the Province of New Brunswick. 8 Year Lux New Home Warranty is also included. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-10T13:35:54.769406+00:00"
+"Directions": "Brookside Drive to Glennorth to Aiden Street"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1986544"
+"ListOfficeKey": "52805"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "515"
+"ParcelNumber": "75574020"
+"PhotosChangeTimestamp": "2026-06-10T13:01:58Z"
+"PhotosCount": 32
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-12T22:12:00Z"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Crczrrsn6L9&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29880899/114-aiden-street-fredericton"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 710
+"OriginalEntryTimestamp": "2026-06-10T12:59:47.14Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1270950"
+"ListOfficeNationalAssociationId": "1094072"
+"Media": array:32 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29880899')"
+"ID": "1514965"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25215
+post_id: "1410014"
+post_author: 1
+"ListingKey": "29732453"
+"ListingId": "NB139218"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-05T12:40:53Z"
+"RFModificationTimestamp": "2026-06-05T12:46:03Z"
+"ListPrice": 574900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 653.0
+"LivingArea": 1985.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0A6"
+"UnparsedAddress": "104 Glennorth Street, Fredericton, New Brunswick E3G0A6"
+"Coordinates": array:2 [
0 => -66.635855
1 => 46.012991
]
+"Latitude": 46.012991
+"Longitude": -66.635855
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Brand new, beautifully designed, and built for real life, this is the kind of home that just makes sense the moment you walk in. Step into this thoughtfully crafted split-entry home where modern style meets everyday functionality, featuring a bright, open-concept main level that seamlessly connects the living room, dining area, and kitchenperfect for both relaxed living and entertaining - completed with brand new appliances for a truly move-in ready experience. Just off the dining space, a patio door leads to the back deck, creating an easy indoor-outdoor flow. This level also offers three generously sized bedrooms, including a comfortable primary bedroom with its own private ensuite, along with an additional full bathroom for family or guests. The lower level expands your options with versatile living space, a fourth bedroom, another full bathroom with a dedicated laundry area, while direct access to the attached garage adds everyday convenience. The lawn will be seeded in the coming weeks for a nice start on that summer lawn! Located in a growing, family-friendly neighbourhood close to parks and local amenities, this home is a fantastic opportunity to settle into a fresh, modern space designed to fit your lifestyle. (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-11T19:00:08.191846+00:00"
+"Directions": "From Brookside Drive, turn left onto Glennorth Street, house is on the right."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182259"
+"ListOfficeKey": "283841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "653"
+"ParcelNumber": "75568535"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-29T11:51:04Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-05T12:32:02Z"
+"TaxAnnualAmount": "4507.23"
+"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/29732453/104-glennorth-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1230
+"OriginalEntryTimestamp": "2026-05-11T17:16:10.57Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1432070"
+"ListOfficeNationalAssociationId": "1335718"
+"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": 37
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29732453')"
+"ID": "1410014"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1390710"
+post_author: 1
+"ListingKey": "29706619"
+"ListingId": "NB138566"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-14T19:25:01Z"
+"RFModificationTimestamp": "2026-06-14T19:26:33Z"
+"ListPrice": 729900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 760.0
+"LivingArea": 2527.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0B8"
+"UnparsedAddress": "188 Mitchell Wayne Drive, Fredericton, New Brunswick E3G0B8"
+"Coordinates": array:2 [
0 => -66.647955
1 => 46.005187
]
+"Latitude": 46.005187
+"Longitude": -66.647955
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this stunning executive bungalow in the highly sought-after Brookside West communitywhere style, space, and thoughtful design come together. From the moment you arrive, the curb appeal stands out with a paved driveway, triple car garage, stone walkway, and a charming covered front porch. Step inside to a spacious, welcoming entryway that sets the tone for the rest of the home. The main level features an open-concept layout with 9-foot ceilings and engineered hardwood throughout. The kitchen is the heart of the home, showcasing an oversized island with sink and dishwasher, ample cabinetry, and a walk-in pantryperfect for both everyday living and entertaining. The kitchen flows seamlessly into the dining and living areas, creating a bright and inviting space. Patio doors off the dining room lead to a large back deck with privacy panels, overlooking a beautifully landscaped yard complete with a French drain for added peace of mind. Designed with functionality in mind, the mudroom entry off the garage offers the perfect drop zone for coats and shoes, with a conveniently located laundry room just beyond. The main floor includes three bedrooms, thoughtfully laid out for privacy. Two bedrooms are situated on one side of the home with a full bathroom in between, while the primary suite is tucked away on the opposite side. The primary retreat features a walk-in closet and a well-appointed ensuite with double sinks and an oversized shower. Downstairs, youll find a partially finished lower level offering even more living space, including a large rec room and an additional bedroom. The basement is also plumbed for a future bathroom, with plenty of room remaining to customize and expand to suit your needs. With quality finishes, a functional layout, and room to grow, this home is the perfect blend of comfort and executive living in one of the citys most desirable neighborhoods. (id:62783)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-05-06T15:01:24.838516+00:00"
+"Directions": "Follow Brookside Dr and Heron Dr to Mitchell Wayne Drive"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Heat Pump"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1914735"
+"ListOfficeKey": "283841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "760"
+"ParcelNumber": "75542126"
+"ParkingFeatures": array:1 [
0 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-06T12:28:26Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-14T19:15:18Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "6446.11"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ftWTnQzQ62z"
+"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/29706619/188-mitchell-wayne-drive-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2134828"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283841"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1657
+"OriginalEntryTimestamp": "2026-05-06T12:28:26.12Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1224172"
+"ListOfficeNationalAssociationId": "1335718"
+"CoListAgentNationalAssociationId": "1387175"
+"CoListOfficeNationalAssociationId": "1335718"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 42
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29706619')"
+"ID": "1390710"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1358626"
+post_author: 1
+"ListingKey": "29661665"
+"ListingId": "NB137966"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-04-27T21:10:49Z"
+"RFModificationTimestamp": "2026-04-27T21:15:10Z"
+"ListPrice": 879900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 847.0
+"LivingArea": 4586.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0W2"
+"UnparsedAddress": "22 Emma Court, Fredericton, New Brunswick E3G0W2"
+"Coordinates": array:2 [
0 => -66.642332
1 => 46.002214
]
+"Latitude": 46.002214
+"Longitude": -66.642332
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Spectacular family home in the sought-after Brookside West subdivision, tucked away on a quiet cul-de-sac and close to West Hills Golf Course! This impressive property offers oversized rooms throughout the main floor, creating a bright and spacious feel. Off the front foyer, enjoy a versatile room perfect for a formal dining area, home office, or playroomtailored to your lifestyle. The heart of the home features an open-concept layout with a stunning kitchen complete with a large island and granite countertops, flowing seamlessly into the dining area with breakfast nook and the inviting living room with gas fireplace. A convenient half bath and a separate laundry/mudroom with access to the garage complete this level. Upstairs, youll find the rare bonus of 5 bedrooms on one level! The primary suite boasts a walk-in closet and a private ensuite with a slate walk-in shower. Three additional bedrooms, a full bath, and a flexible bonus room (with closet) offer space for growing families or guests. The lower level expands your living options with an additional bedroom, office, full bath, plus a media room and gymperfect for entertaining and everyday living. Loaded with extras including smart home technology, ducted heat pump, concrete driveway, charming front porch, and a large backyard with a two-tier deck and gazebo. A must-see home offering space, style, and functionality! (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Heat Pump"
]
+"CreationDate": "2026-04-27T18:45:33.274259+00:00"
+"Directions": "Brookside drive, left on Heron, right on Alex, right on Emma"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Vinyl"
2 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Stove"
2 => "Electric"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1972627"
+"ListOfficeKey": "289196"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "847"
+"ParcelNumber": "75436345"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-04-27T21:09:13Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-04-27T21:09:13Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "8681"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=SrLdgwFGn4K&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:19 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29661665/22-emma-court-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 5
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 3145
+"OriginalEntryTimestamp": "2026-04-27T18:12:18.1Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1259910"
+"ListOfficeNationalAssociationId": "1375426"
+"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": 51
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29661665')"
+"ID": "1358626"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25218
+post_id: "1338706"
+post_author: 1
+"ListingKey": "29633275"
+"ListingId": "NB137594"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T18:50:01Z"
+"RFModificationTimestamp": "2026-06-16T19:50:18Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 5.0
+"BathroomsHalf": 3
+"BedroomsTotal": 5.0
+"LotSizeArea": 1630.0
+"LivingArea": 4033.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0W2"
+"UnparsedAddress": "10 Emma Court, Fredericton, New Brunswick E3G0W2"
+"Coordinates": array:2 [
0 => -66.642821
1 => 46.002418
]
+"Latitude": 46.002418
+"Longitude": -66.642821
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Executive 2-storey set on rare double city lot, offering approximately 3,100 sq. ft. well-designed living space. Home delivers right balance of scale, function, and refined finishes throughout. Step inside to bright, welcoming foyer that leads to spacious living room with rich hardwood floors, tray ceilings, and natural gas fireplace that anchors space. Kitchen is both polished and practical, Quartz counters, elegant cabinetry, island, and layout that works effortlessly for everyday living and entertaining. Butlers pantry connects to formal dining room adding that extra level of function and flow. Dining nook is filled with natural light, leads directly to backyard deck & 2023 above-ground pool with heater. Off attached double garage, mudroom is designed for real life - complete with half bath and second pantry, (option for main floor laundry). Office/den with Murphy bed offers flexibility for guests or work-from-home, plus additional half bath. Upstairs, youll find four bedrooms, main bath & separate laundry area. Standout Primary suite, featuring its own heat pump, large walk-in closet, and well-appointed ensuite double sink vanity, soaker tub, and custom tile shower. Bonus room provides ideal second living space or playroom. Lower level extends living space with huge rec room, 5th bedroom, 3rd half bath, and multiple storage areas. Comfort and efficiency are covered with forced air heating and central air, along with added convenience of electric vehicle charging plug. Outside, separate fenced yard is built for enjoyment and peace of mind. Detached double garage with loft - perfect for storage, hobbies, or workshop space. Roof shingles replaced in 2025. This home delivers. (id:62650)"
+"BathroomsPartial": 3
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Heat Pump"
]
+"CreationDate": "2026-04-21T13:48:48.162317+00:00"
+"Directions": "Brookside drive to Heron, Right on Alex, Right on Emma"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:3 [
0 => "Laminate"
1 => "Ceramic"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Stove"
2 => "Electric"
3 => "Natural gas"
4 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878816"
+"ListOfficeKey": "52796"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1630"
+"ParcelNumber": "75457010"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Detached Garage"
2 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T18:40:54Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-16T18:40:54Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "11461.97"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:25 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
22 => array:11 [ …11]
23 => array:11 [ …11]
24 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29633275/10-emma-court-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"RoadSurfaceType": array:1 [
0 => "Paved road"
]
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 3226
+"OriginalEntryTimestamp": "2026-04-21T12:59:02.56Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1205259"
+"ListOfficeNationalAssociationId": "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": 57
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29633275')"
+"ID": "1338706"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25219
+post_id: "1334884"
+post_author: 1
+"ListingKey": "29627321"
+"ListingId": "NB137488"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T13:50:50Z"
+"RFModificationTimestamp": "2026-06-04T13:56:25Z"
+"ListPrice": 925000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 924.0
+"LivingArea": 4182.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3G0C5"
+"UnparsedAddress": "241 Summerhill Row, Fredericton, New Brunswick E3G0C5"
+"Coordinates": array:2 [
0 => -66.64365
1 => 45.996918
]
+"Latitude": 45.996918
+"Longitude": -66.64365
+"YearBuilt": 2004
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Nestled in the highly sought-after West Hills subdivision, 241 Summerhill Row is an expansive property that offers exceptional versatility and comfort for growing families or those who love to entertain. The main level features three generously sized bedrooms, with the potential for a fourth, while the lower level adds an additional three bedrooms; perfect for extended family, guests, or flexible living arrangements. With three well-appointed bathrooms and recent updates to the master bath, main bath, mudroom, and stairway, this home blends modern touches with everyday functionality. Step outside to your private backyard oasis, complete with a newly added saltwater pool with ambient lighting and a fully fenced yard. Whether you're enjoying a quiet evening on the enclosed patio, listening to music under the stars, or hosting summer gatherings, this outdoor space is designed to impress. Located in a safe, family-friendly neighbourhood with underground power infrastructure, youll enjoy added peace of mind and fewer service interruptions. For golf enthusiasts, this location is truly ideal, just moments from the green and close to all essential amenities. This is more than just a house; its a home filled with warmth, care, and room to grow. Dont miss your chance to make it yours! (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Air Conditioned"
]
+"CreationDate": "2026-04-20T17:49:00.073124+00:00"
+"Directions": "Brookside Dr to Summerhill Row #241"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:4 [
0 => "Tile"
1 => "Carpeted"
2 => "Vinyl"
3 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Stove"
1 => "Forced air"
2 => "Natural gas"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1960039"
+"ListOfficeKey": "52805"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Level lot"
1 => "Treed"
2 => "Golf course/parkland"
3 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "924"
+"ParcelNumber": "75399261"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T13:41:17Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-04T13:41:17Z"
+"TaxAnnualAmount": "10152"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=x3mFY2KKBDZ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
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]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29627321/241-summerhill-row-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"AboveGradeFinishedArea": 2154
+"OriginalEntryTimestamp": "2026-04-20T12:31:37.83Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1250341"
+"ListOfficeNationalAssociationId": "1094072"
+"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": 58
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29627321')"
+"ID": "1334884"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 49
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]