array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29905235 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: "1533386"
+post_author: 1
+"ListingKey": "29905235"
+"ListingId": "NB138268"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T02:50:08Z"
+"RFModificationTimestamp": "2026-06-18T02:52:54Z"
+"ListPrice": 624900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 726.0
+"LivingArea": 2850.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1K0A3"
+"UnparsedAddress": "19 Le Guerne Court, Moncton, New Brunswick E1K0A3"
+"Coordinates": array:2 [
0 => -64.736426
1 => 46.11752
]
+"Latitude": 46.11752
+"Longitude": -64.736426
+"YearBuilt": 2024
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "BUNGALOW WITH IN-LAW SUITE! Welcome to 19 Le Guerne Court, a stunning bungalow that offers income potential. The main level includes 3 bedrooms and 1 full bathroom, with a functional layout for everyday living. The kitchen features a walk-in pantry. Situated on a slope side lot, the lower level offers a convenient walk-out in-law suite with its own separate entrance, that includes 2 bedrooms and 1 full bathroom. Conveniently located near Shediac Road and Harrisville Blvd, this home offers quick access to highways and downtown. It is also close to Ecole Champlain. With a total of 5 bedrooms and two full bathrooms, this home is perfect for buyers looking for space and potential additional income in a desirable neighbourhood. *Seller is a licensed real estate Salesperson in the Province of New Brunswick* (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-15T18:51:03.147285+00:00"
+"Directions": "From Shediac Road turn onto Glengrove Road, then turn onto Ripplewood Road, then turn right onto Le Guerne Court."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Hardwood"
2 => "Laminate"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2217152"
+"ListOfficeKey": "289807"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "726"
+"ParcelNumber": "70678453"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T18:21:48Z"
+"PhotosCount": 30
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-18T02:44:58Z"
+"TaxAnnualAmount": "8506.18"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
0 => array:11 [
"RoomKey" => "1661768698"
"RoomType" => "Recreation room"
"ListingId" => "NB138268"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29905235"
"RoomLength" => null
"RoomDimensions" => "15'11'' x 18'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T02:44:58.54Z"
]
1 => array:11 [
"RoomKey" => "1661768699"
"RoomType" => "5pc Bathroom"
"ListingId" => "NB138268"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905235"
"RoomLength" => null
"RoomDimensions" => "9' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T02:44:58.54Z"
]
2 => array:11 [
"RoomKey" => "1661768700"
"RoomType" => "Bedroom"
"ListingId" => "NB138268"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905235"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T02:44:58.54Z"
]
3 => array:11 [
"RoomKey" => "1661768701"
"RoomType" => "Bedroom"
"ListingId" => "NB138268"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905235"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T02:44:58.54Z"
]
4 => array:11 [
"RoomKey" => "1661768702"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB138268"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905235"
"RoomLength" => null
"RoomDimensions" => "13' x 14'"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T02:44:58.55Z"
]
5 => array:11 [
"RoomKey" => "1661768703"
"RoomType" => "Living room"
"ListingId" => "NB138268"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905235"
"RoomLength" => null
"RoomDimensions" => "15'3'' x 16'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T02:44:58.55Z"
]
6 => array:11 [
"RoomKey" => "1661768704"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "NB138268"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29905235"
"RoomLength" => null
"RoomDimensions" => "11' x 20'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-18T02:44:58.55Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29905235/19-le-guerne-court-moncton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1425
+"OriginalEntryTimestamp": "2026-06-15T18:15:39.38Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1462853"
+"ListOfficeNationalAssociationId": "1381422"
+"Media": array:30 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29905235_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/25d3614adf0c83b1f7c23a835a09fa7d.webp"
"MediaSize" => 92442
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-25d3614adf0c83b1f7c23a835a09fa7d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.36Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29905235_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/bce8166918bbedf03e322f47f106c53e.webp"
"MediaSize" => 156908
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-bce8166918bbedf03e322f47f106c53e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.06Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29905235_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/c47773150552ceee90bc698493bda53f.webp"
"MediaSize" => 97611
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-c47773150552ceee90bc698493bda53f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:46.23Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29905235_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/6f761f7eee7633a567d4bc03e898bd9f.webp"
"MediaSize" => 46004
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-6f761f7eee7633a567d4bc03e898bd9f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.22Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29905235_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/ed347db28ffe3b0ab8b7acd21dd42d75.webp"
"MediaSize" => 50037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-ed347db28ffe3b0ab8b7acd21dd42d75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.05Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29905235_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/29605cc7ad59fd43ab65af0538a5a917.webp"
"MediaSize" => 59880
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-29605cc7ad59fd43ab65af0538a5a917.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.05Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29905235_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/02ca0f9d17a12003c38ab9b70e6e20db.webp"
"MediaSize" => 55027
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-02ca0f9d17a12003c38ab9b70e6e20db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.23Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29905235_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/b77d02bde91df6e1bafd1d501f79d1fb.webp"
"MediaSize" => 61145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-b77d02bde91df6e1bafd1d501f79d1fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.36Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29905235_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/bd15c1c124b4f3a099bf0ecbf00fd47e.webp"
"MediaSize" => 64993
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-bd15c1c124b4f3a099bf0ecbf00fd47e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.36Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29905235_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/14eb1106cc3060645a2c6029388e368c.webp"
"MediaSize" => 70937
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-14eb1106cc3060645a2c6029388e368c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.37Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29905235_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/de62745e82d93c8e51a21f183e5cb26d.webp"
"MediaSize" => 70346
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-de62745e82d93c8e51a21f183e5cb26d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.39Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29905235_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/c58cd7547fd0c8a5387bd6af239ea53f.webp"
"MediaSize" => 61894
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-c58cd7547fd0c8a5387bd6af239ea53f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.37Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29905235_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/2c7b744c65bb674fa016b324b75cf556.webp"
"MediaSize" => 56565
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-2c7b744c65bb674fa016b324b75cf556.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.36Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29905235_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/dec43401aeef46341a215bd8cc64967f.webp"
"MediaSize" => 30379
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-dec43401aeef46341a215bd8cc64967f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.38Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29905235_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/437cb625cd246635f2e0318c93fb0b74.webp"
"MediaSize" => 65422
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-437cb625cd246635f2e0318c93fb0b74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.05Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29905235_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/e648f9c6661c49d881e7a39d56994a37.webp"
"MediaSize" => 55254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-e648f9c6661c49d881e7a39d56994a37.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.37Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29905235_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/2abad1e61772a7530e4faf03e5c1274a.webp"
"MediaSize" => 95139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-2abad1e61772a7530e4faf03e5c1274a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.05Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29905235_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/f60846f720d50802421fea8d1c7b8a49.webp"
"MediaSize" => 64529
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-f60846f720d50802421fea8d1c7b8a49.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.06Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29905235_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/76ae2db1a942cd1ca0942c918b265f54.webp"
"MediaSize" => 64283
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-76ae2db1a942cd1ca0942c918b265f54.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.91Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29905235_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/78b7fd9d05ff24433935c4e3282368e5.webp"
"MediaSize" => 49912
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-78b7fd9d05ff24433935c4e3282368e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:46.23Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29905235_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/ada8a4be670c6069619dba4f3d365278.webp"
"MediaSize" => 55815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-ada8a4be670c6069619dba4f3d365278.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.06Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29905235_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/ff53baf925fc06a68187556a26dca202.webp"
"MediaSize" => 63840
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-ff53baf925fc06a68187556a26dca202.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.22Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29905235_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/43a337ce43699196effaa4b7464e88fb.webp"
"MediaSize" => 45135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-43a337ce43699196effaa4b7464e88fb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:43.92Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29905235_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/b86facd06a53838a16e529afd2b5e41c.webp"
"MediaSize" => 45009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-b86facd06a53838a16e529afd2b5e41c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.06Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29905235_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/6553db24c34ca4c052dfed8796aa2b8c.webp"
"MediaSize" => 61719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-6553db24c34ca4c052dfed8796aa2b8c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.66Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29905235_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/10aef8f98dd29181eb2bcff4dd3acf85.webp"
"MediaSize" => 98587
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-10aef8f98dd29181eb2bcff4dd3acf85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:48.04Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29905235_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/76c35ac75b89e39172a08bdbd9093787.webp"
"MediaSize" => 148509
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-76c35ac75b89e39172a08bdbd9093787.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:45.61Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29905235_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/fbe49c14467d668747476cab31584188.webp"
"MediaSize" => 113596
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-fbe49c14467d668747476cab31584188.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.23Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29905235_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/092f36cd320648578dff15495a9231bc.webp"
"MediaSize" => 127570
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-092f36cd320648578dff15495a9231bc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.06Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29905235_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29905235/71f119916666bd09d94ff47bcb8c98b0.webp"
"MediaSize" => 134933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29905235/thumbnail-71f119916666bd09d94ff47bcb8c98b0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB138268"
"ResourceRecordKey" => "29905235"
"ModificationTimestamp" => "2026-06-15T18:21:44.06Z"
]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29905235')"
+"ID": "1533386"
}
]
+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 289807" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24837
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2217152" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24810
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29905235'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25141
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29905235'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25159
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25157
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31525184"
+"ListingKey": "29905235"
+"ListingId": "NB138268"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-06-20"
+"OpenHouseStartTime": "2026-06-20T11:00:00Z"
+"OpenHouseEndTime": "2026-06-20T13:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-18T15:47:11Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31525184')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29905235' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-64.736426 46.11752)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25212
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25206
+post_id: "1539352"
+post_author: 1
+"ListingKey": "29916018"
+"ListingId": "NB142111"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T16:25:15Z"
+"RFModificationTimestamp": "2026-06-17T16:33:05Z"
+"ListPrice": 619900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 1003.0
+"LivingArea": 2100.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1A5T3"
+"UnparsedAddress": "29 Warner Street, Moncton, New Brunswick E1A5T3"
+"Coordinates": array:2 [
0 => -64.726938
1 => 46.108535
]
+"Latitude": 46.108535
+"Longitude": -64.726938
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "IMPRESSIVE CLIMATE CONTROLLED EXECUTIVE BUNGALOW WITH EXCEPTIONAL CURB APPEAL! Upon entering the covered front porch you will be impressed as you enter the foyer and take notice to the upscale finishes and attention to detail throughout. situated on on a meticulously manicured fenced in lot with a private backyard designed for both relaxation and entertaining! From the moment you arrive, youll appreciate the pride of ownership and meticulous attention to detail found throughout this beautifully maintained 4-bedroom home. Hardwood and ceramic flooring flow throughout the main level, a warm and inviting living room is highlighted by cathedral ceilings and a natural gas fireplace. A chefs dream kitchen featuring an abundance of rich stained cabinetry, 8 foot island, quartz countertops, and a gas stove. The bright dining area flows seamlessly into a beautiful 3-season sunroom with access to the custom back deck overlooking the fenced backyard with mature landscapingyour own private oasis for morning coffee, summer gatherings, or peaceful evenings.The luxurious primary suite is sure to impress with tray ceilings, a walk-in closet, and a spa-inspired 5-piece ensuite featuring a custom shower, soaker tub, and dual quartz vanity.Two additional bedrooms, a stylish family bath and a thoughtfully designed laundry room with quartz counters and exceptional storage complete the main level. The lower level offers so much potential featuring a spacious family room, fourth bedroom, and an unfinished area already configured for a full bath and future in-law suite with separate entranceproviding incredible flexibility and value.Located in one of the areas most desirable neighbourhoods, close to French and English schools,daycares, walking trails, highways, and all amenities.New heat pump 2025,,fenced replaced in 2020 with post tech, 3 season sunroom,large storage shed and separate entrance leading to complete set up for in law suite add to the value of this gorgeous home! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Cooling": array:1 [
0 => "Air Conditioned"
]
+"CreationDate": "2026-06-17T16:32:56.092082+00:00"
+"Directions": "Shediac Road to"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"FireplaceFeatures": array:2 [
0 => "Gas"
1 => "Unknown"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Hardwood"
1 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Stove"
1 => "Forced air"
2 => "Natural gas"
3 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1503438"
+"ListOfficeKey": "76972"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1003"
+"ParcelNumber": "70530894"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T16:15:07Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T16:15:07Z"
+"TaxAnnualAmount": "6724.5"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/29_warner_st_moncton_nb/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [
"RoomKey" => "1661252421"
"RoomType" => "Utility room"
"ListingId" => "NB142111"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "X"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.74Z"
]
1 => array:11 [
"RoomKey" => "1661252422"
"RoomType" => "Other"
"ListingId" => "NB142111"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "X"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.74Z"
]
2 => array:11 [
"RoomKey" => "1661252423"
"RoomType" => "Bedroom"
"ListingId" => "NB142111"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.74Z"
]
3 => array:11 [
"RoomKey" => "1661252424"
"RoomType" => "Family room"
"ListingId" => "NB142111"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "18'0'' x 18'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.74Z"
]
4 => array:11 [
"RoomKey" => "1661252425"
"RoomType" => "Sunroom"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "11'5'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.74Z"
]
5 => array:11 [
"RoomKey" => "1661252426"
"RoomType" => "Laundry room"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "6'9'' x 9'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.75Z"
]
6 => array:11 [
"RoomKey" => "1661252427"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "8'2'' x 4'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.75Z"
]
7 => array:11 [
"RoomKey" => "1661252428"
"RoomType" => "Bedroom"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "9'1'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.75Z"
]
8 => array:11 [
"RoomKey" => "1661252429"
"RoomType" => "Bedroom"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 11'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.75Z"
]
9 => array:11 [
"RoomKey" => "1661252430"
"RoomType" => "5pc Bathroom"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "11'2'' x 8'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.75Z"
]
10 => array:11 [
"RoomKey" => "1661252431"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "19'8'' x 12'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.75Z"
]
11 => array:11 [
"RoomKey" => "1661252432"
"RoomType" => "Kitchen"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.76Z"
]
12 => array:11 [
"RoomKey" => "1661252433"
"RoomType" => "Dining room"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "13'10'' x 9'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.76Z"
]
13 => array:11 [
"RoomKey" => "1661252434"
"RoomType" => "Living room"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "16'1'' x 15'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.76Z"
]
14 => array:11 [
"RoomKey" => "1661252435"
"RoomType" => "Foyer"
"ListingId" => "NB142111"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29916018"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 7'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T16:15:07.77Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29916018/29-warner-street-moncton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1578
+"OriginalEntryTimestamp": "2026-06-17T16:15:07.69Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1129059"
+"ListOfficeNationalAssociationId": "1007036"
+"Media": array:48 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29916018_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/f07e87e6ca1760b44f579ae2705f5c78.webp"
"MediaSize" => 152809
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-f07e87e6ca1760b44f579ae2705f5c78.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29916018_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/3bdddcc6d687d8f4bf65a9c7c672bf8a.webp"
"MediaSize" => 148786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-3bdddcc6d687d8f4bf65a9c7c672bf8a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29916018_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/00bf45a8448d67beaa718f07d17614df.webp"
"MediaSize" => 110411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-00bf45a8448d67beaa718f07d17614df.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29916018_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/794f2ff3d19b2716c5c2b4e7e2c33a0a.webp"
"MediaSize" => 135827
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-794f2ff3d19b2716c5c2b4e7e2c33a0a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29916018_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/d6f222a8082a0546933afd4e90242551.webp"
"MediaSize" => 133018
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-d6f222a8082a0546933afd4e90242551.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29916018_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/eff9fa08cec147bffd70762b2ae859ae.webp"
"MediaSize" => 64681
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-eff9fa08cec147bffd70762b2ae859ae.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Main level floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29916018_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/3b135a77997a0c6de14fe7e1a008c586.webp"
"MediaSize" => 67485
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-3b135a77997a0c6de14fe7e1a008c586.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29916018_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/fa031e2ac8cd331a2493e2044ea3e134.webp"
"MediaSize" => 85017
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-fa031e2ac8cd331a2493e2044ea3e134.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29916018_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/790bf71da6aeb68c6042ec46a69d34e3.webp"
"MediaSize" => 79271
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-790bf71da6aeb68c6042ec46a69d34e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29916018_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/3a0e3c3967a73c3f4de970d1d1aab563.webp"
"MediaSize" => 77718
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-3a0e3c3967a73c3f4de970d1d1aab563.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29916018_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/4ac31925ed8aa715c81ae567fc341360.webp"
"MediaSize" => 80500
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-4ac31925ed8aa715c81ae567fc341360.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29916018_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/1888185b47148289465c18f54b6352c3.webp"
"MediaSize" => 77345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-1888185b47148289465c18f54b6352c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29916018_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/e8268f2bd16bc67c6d436534560b48a1.webp"
"MediaSize" => 77946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-e8268f2bd16bc67c6d436534560b48a1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29916018_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/5a4341eedd5d06600e5f9dc258528d5f.webp"
"MediaSize" => 91719
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-5a4341eedd5d06600e5f9dc258528d5f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29916018_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/f7553793c1c85803e4f4398d4fa3a511.webp"
"MediaSize" => 101821
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-f7553793c1c85803e4f4398d4fa3a511.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29916018_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/7e7ef904cd21990e3172f31c82f36be5.webp"
"MediaSize" => 84664
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-7e7ef904cd21990e3172f31c82f36be5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29916018_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/130de940e4cc0e6ead5ce958871d9063.webp"
"MediaSize" => 95804
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-130de940e4cc0e6ead5ce958871d9063.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29916018_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/5795d193afa9c02f3f2888d2f3773584.webp"
"MediaSize" => 97917
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-5795d193afa9c02f3f2888d2f3773584.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29916018_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/2d69ecddf1f1b16b5aa79c937d1d5e35.webp"
"MediaSize" => 118440
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-2d69ecddf1f1b16b5aa79c937d1d5e35.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Sunroom"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29916018_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/43ce7a929e2c47e75e8ead94566ffc1b.webp"
"MediaSize" => 75938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-43ce7a929e2c47e75e8ead94566ffc1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29916018_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/c70f69251edb0bcf8ef24d2b58287981.webp"
"MediaSize" => 92126
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-c70f69251edb0bcf8ef24d2b58287981.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29916018_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/3596c4649a6deeb1df5a28f3f1cfa590.webp"
"MediaSize" => 72338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-3596c4649a6deeb1df5a28f3f1cfa590.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Primary"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29916018_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/afa6871c47b6d3be4ebafd6757fc1507.webp"
"MediaSize" => 72030
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-afa6871c47b6d3be4ebafd6757fc1507.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Ensuite"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29916018_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/1dff4db34c64f328caada13931154732.webp"
"MediaSize" => 72608
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-1dff4db34c64f328caada13931154732.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Tile shoer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29916018_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/d8390f041fef0669a60354b56678a41b.webp"
"MediaSize" => 100939
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-d8390f041fef0669a60354b56678a41b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Walk in closet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29916018_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/0f270b234ca8d62cd5a7477e101b870f.webp"
"MediaSize" => 33944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-0f270b234ca8d62cd5a7477e101b870f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 2"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29916018_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/9cac867db39638c5ab0130868246bc06.webp"
"MediaSize" => 57626
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-9cac867db39638c5ab0130868246bc06.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 2 staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29916018_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/c8ccfae59ed34d432899004e169c8199.webp"
"MediaSize" => 33145
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-c8ccfae59ed34d432899004e169c8199.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 3"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29916018_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/6bfd081198739d078737cf2cb5dac8f3.webp"
"MediaSize" => 41232
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-6bfd081198739d078737cf2cb5dac8f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom 3 staged"
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB142111"
"ResourceRecordKey" => "29916018"
"ModificationTimestamp" => "2026-06-17T16:15:07.71Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29916018_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29916018/2be14ba7b15450e5114a33040c2b213e.webp"
"MediaSize" => 73433
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29916018/thumbnail-2be14ba7b15450e5114a33040c2b213e.webp"
"ResourceName" => "Property"
…6
]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29916018')"
+"ID": "1539352"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25208
+post_id: "1538650"
+post_author: 1
+"ListingKey": "29915565"
+"ListingId": "NB141973"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T18:00:13Z"
+"RFModificationTimestamp": "2026-06-17T18:01:58Z"
+"ListPrice": 615000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 855.0
+"LivingArea": 2693.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1A4L6"
+"UnparsedAddress": "23 Vista Drive, Moncton, New Brunswick E1A4L6"
+"Coordinates": array:2 [
0 => -64.754834
1 => 46.106049
]
+"Latitude": 46.106049
+"Longitude": -64.754834
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "If you've been searching for a home where all the work has already been done, your search ends here. Offering over 2,600 sq. ft. of beautifully updated living space, this stunning 4-bedroom, 2.5-bathroom home combines style, comfort, and functionality in a sought-after family-friendly neighbourhood. Thoughtfully updated both inside and out, this home showcases the care and attention that has gone into every improvement, resulting in a stunning, move-in-ready property you'll be proud to call home. The beautifully renovated kitchen is the heart of the home, featuring new cabinetry, a spacious pantry with shelving and pull-out drawers, quartz countertops, and a stylish tile backsplash. The extensive updates continue throughout the home with new flooring installed throughout, fresh paint on every surface, updated light fixtures, new door hardware, a new front door, smart thermostats, built-in laundry storage, and a custom IKEA closet system in the primary bedroom. Every improvement has been carefully selected to create a fresh, modern feel from room to room. Outside, the transformation is equally impressive. The front and backyard have been beautifully landscaped, the yard has been fully fenced to provide privacy and security for children and pets, and a storage shed adds valuable storage space. Whether you're hosting summer gatherings, enjoying family time, or simply relaxing outdoors, this backyard is ready to enjoy. With multiple levels of living space, generous-sized bedrooms, and room for the entire family to spread out, this home offers the perfect balance of style and function. The separate side entrance also provides excellent potential for an in-law suite or multi-generational living setup. Located in a quiet, family-oriented neighbourhood close to schools, parks, shopping, and everyday amenities, this property truly checks all the boxes. Simply move in, unpack, and start making memories in a home where the work has already been done for you. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "4 Level"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-06-17T15:54:23.879265+00:00"
+"Directions": "Off Shediac Rd turn right onto Vista, across from Five O's Corner Store."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl"
]
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Laminate"
2 => "Carpeted"
3 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Propane"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105034"
+"ListOfficeKey": "301078"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "855"
+"ParcelNumber": "00807156"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Heated Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T15:23:59Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-17T17:53:43Z"
+"TaxAnnualAmount": "5195.95"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=CPzMjV23YLQ&mls=1"
+"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/29915565/23-vista-drive-moncton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1821
+"OriginalEntryTimestamp": "2026-06-17T15:23:58.68Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1374296"
+"ListOfficeNationalAssociationId": "1496910"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29915565')"
+"ID": "1538650"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25205
+post_id: "1533385"
+post_author: 1
+"ListingKey": "29904385"
+"ListingId": "NB141913"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T16:55:09Z"
+"RFModificationTimestamp": "2026-06-15T21:32:24Z"
+"ListPrice": 345000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 669.0
+"LivingArea": 1650.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1A4J5"
+"UnparsedAddress": "17 Hazelton Avenue, Moncton, New Brunswick E1A4J5"
+"Coordinates": array:2 [
0 => -64.751658
1 => 46.103824
]
+"Latitude": 46.103824
+"Longitude": -64.751658
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 17 Hazelton Avenue, a well-maintained bungalow in one of Monctons most desirable neighborhoods, offered for sale for the first time on MLS! This charming home combines comfort, convenience, and pride of ownership. Ideally located near Champlain Place, schools, daycares, shopping, restaurants, and public transit, this property offers exceptional accessibility while enjoying a peaceful residential setting. The beautifully landscaped backyard provides the perfect space to relax, entertain, or enjoy time outdoors. Inside, you'll find a bright and functional single-level layout featuring hardwood floors that were professionally sanded and varnished in 2013. Recent updates include a 2024 mini-split heat pump for efficient year-round comfort and a durable asphalt shingle roof replaced in 2018. The hot water tank (rental) was also recently replaced in 2026. The partially finished basement adds valuable living space and includes a non-conforming bedroom, a second bathroom with shower and sink, and a convenient cold room for additional storage. Additional features include a detached garage (roof also completed in 2018) with ample storage throughout. Whether you're a first-time buyer, or downsizer, this move-in-ready home offers EXCEPTIONAL value in a highly sought-after location. Do not miss your opportunity to own this lovingly cared-for property at 17 Hazelton Avenue! (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-15T21:32:17.566751+00:00"
+"Directions": "Turn onto Kenmore from Shediac Road, take a right onto Wynwood and your first left onto Hazelton."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2167860"
+"ListOfficeKey": "289807"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "669"
+"ParcelNumber": "00807347"
+"ParkingFeatures": array:1 [
0 => "Detached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T16:52:51Z"
+"PhotosCount": 41
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-15T16:52:51Z"
+"TaxAnnualAmount": "2939.72"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29904385/17-hazelton-avenue-moncton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1048
+"OriginalEntryTimestamp": "2026-06-15T16:45:21.84Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1418572"
+"ListOfficeNationalAssociationId": "1381422"
+"Media": array:41 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29904385')"
+"ID": "1533385"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25209
+post_id: "1514622"
+post_author: 1
+"ListingKey": "29881012"
+"ListingId": "NB141246"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T13:56:26Z"
+"RFModificationTimestamp": "2026-06-10T14:03:54Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 570.0
+"LivingArea": 2529.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1A9R9"
+"UnparsedAddress": "181 O'Neill Street, Moncton, New Brunswick E1A9R9"
+"Coordinates": array:2 [
0 => -64.734123
1 => 46.120038
]
+"Latitude": 46.120038
+"Longitude": -64.734123
+"YearBuilt": 2018
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this modern 2-storey home filled with natural light and featuring energy-efficient geothermal heating and cooling. The inviting main level offers a spacious front entry, convenient mudroom with direct access to the attached garage, a half bath, and a bright living room and dining room area highlighted by an electric fireplace. The open-concept layout is ideal for entertaining, featuring a beautifully designed kitchen with a propane range and a pantry. Patio doors lead to a private patio overlooking a peaceful walking trail. Upstairs, the open-to-below design enhances the home's bright and airy feel. The spacious primary bedroom features a walk-in closet with access to a 5-piece bath complete with a soaker tub. A second bedroom and convenient laundry area complete this level. The finished walkout basement offers exceptional flexibility with a large family room and dedicated home office space, warmed by a cozy propane stove and providing access to a lower deck. This level also includes a third bedroom and a 4-piece bath, making it ideal for guests, extended family, or a growing household. Additional features include central vacuum, ample storage, and modern finishes throughout. Recent upgrades include a propane range, propane stove, a new patio and a storage shed. Enjoy affordable utility costs and year-round comfort with the geothermal heating and cooling system. Combining style, comfort, efficiency, and a desirable location, this beautiful home is ready for its next owners. Contact your REALTOR® today to book your private viewing! (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Heat Pump"
]
+"CreationDate": "2026-06-10T14:03:48.054912+00:00"
+"Directions": "From Shediac Rd turn left onto Glengrove Rd, then left onto O'Neill St."
+"ExteriorFeatures": array:3 [
0 => "Stone"
1 => "Vinyl"
2 => "Aluminum siding"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:1 [
0 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2054696"
+"ListOfficeKey": "77079"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "570"
+"ParcelNumber": "70626056"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T13:14:46Z"
+"PhotosCount": 48
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T13:14:46Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "8178.48"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/181_o_neill_st_moncton_nb"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29881012/181-oneill-street-moncton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1769
+"OriginalEntryTimestamp": "2026-06-10T13:14:46.75Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1329947"
+"ListOfficeNationalAssociationId": "1096424"
+"Media": array:48 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29881012')"
+"ID": "1514622"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25207
+post_id: "1498095"
+post_author: 1
+"ListingKey": "29852075"
+"ListingId": "NB141091"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T13:50:53Z"
+"RFModificationTimestamp": "2026-06-04T17:43:13Z"
+"ListPrice": 454900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 363.1
+"LivingArea": 2274.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1A5T3"
+"UnparsedAddress": "59 Warner, Moncton, New Brunswick E1A5T3"
+"Coordinates": array:2 [
0 => -64.725583
1 => 46.108848
]
+"Latitude": 46.108848
+"Longitude": -64.725583
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome home! Start creating lasting family memories in this beautiful semi-detached home, ideally located in the growing and highly sought-after Moncton East, close to schools, shopping, restaurants, and all amenities. Step inside through the spacious foyer and immediately appreciate the thoughtful design and welcoming atmosphere that sets this home apart. A convenient 2-piece powder room is located off the entrance, leading into the bright open-concept main living area featuring a spacious living room, dining area, and modern kitchenperfect for everyday living and entertaining family and friends during holidays and special occasions. Patio doors provide easy access to the backyard patio, creating the ideal space to relax, barbecue, or enjoy outdoor gatherings. Upstairs, you'll find a stunning primary suite complete with a walk-in closet and private 4-piece ensuite, offering the perfect retreat at the end of the day. Two additional bedrooms and a well-appointed 4-piece main bathroom complete the upper level. The fully finished basement adds valuable living space, featuring a large family room and a 3-piece bathroomperfect for movie nights, a playroom, home office, or accommodating guests. This move-in-ready gem offers space, comfort, and a fantastic location. Don't miss your opportunity to make it yourscontact your REALTOR® today to schedule your private viewing! (id:62650)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-04T17:43:09.323798+00:00"
+"Directions": "Shediac Rd to Camelot Dr- Take a Right at the end of rd onto warner"
+"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": "2015879"
+"ListOfficeKey": "77079"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "363.1"
+"ParcelNumber": "70663661"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T13:44:21Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-04T13:44:21Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "4696.1"
+"VirtualTourURLUnbranded": "https://youriguide.com/59_warner_st_moncton_nb/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29852075/59-warner-moncton"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1619
+"OriginalEntryTimestamp": "2026-06-04T13:44:21Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1297138"
+"ListOfficeNationalAssociationId": "1096424"
+"Media": array:46 [
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]
]
+"DaysOnMarket": 14
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29852075')"
+"ID": "1498095"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
+post_id: "1483865"
+post_author: 1
+"ListingKey": "29839508"
+"ListingId": "NB140925"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T15:36:02Z"
+"RFModificationTimestamp": "2026-06-06T15:55:28Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 382.0
+"LivingArea": 2132.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1A9S1"
+"UnparsedAddress": "199 Erinvale Drive, Moncton, New Brunswick E1A9S1"
+"Coordinates": array:2 [
0 => -64.736715
1 => 46.118994
]
+"Latitude": 46.118994
+"Longitude": -64.736715
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this immaculate, turn-key semi-detached bungalow in Monctons highly desirable Grove Hamlet neighborhood, perfectly situated right across from the school! From the moment you arrive, youll love the beautiful curb appeal, highlighted by professional landscaping and stone accents. The main floor boasts a bright, open-concept design featuring a spacious living room centered around a stunning stone electric fireplace. The refreshed kitchen showcases newly updated cabinets, a center island, stainless steel appliances and newly installed pristine quartz countertops which also feature in the master ensuite. Single-level convenience is at its best here with the primary master suite hosting a luxurious 5-piece ensuite bath and 2 double closets, alongside a main-floor laundry room/half bath and a second bedroom. Step outside to your private, covered back deck to enjoy total peace and quiet. The fully finished lower level significantly expands your living space, offering a massive family room, a third bedroom, a nonconforming bedroom ideal for an office working from home, a full bathroom, and a generous storage room. An attached garage completes this incredible package. With the entire home freshly painted and two mini-split heat pumps newly installed in 2026 for year-round comfort and energy efficiency, this property shows like a model home. Don't miss out! (id:62783)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-02T16:28:04.654200+00:00"
+"Directions": "From Shediac Road, turn onto Glengrove, take a left on Ripplewood and then turn right on Erinvale"
+"ExteriorFeatures": array:2 [
0 => "Stone"
1 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Laminate"
2 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1993357"
+"ListOfficeKey": "268122"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Golf course/parkland"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "382"
+"ParcelNumber": "70586250"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T15:45:22Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-06T15:29:40Z"
+"TaxAnnualAmount": "4000"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=jUthBGRARyu"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29839508/199-erinvale-drive-moncton"
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1225
+"OriginalEntryTimestamp": "2026-06-02T15:45:22.61Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1276486"
+"ListOfficeNationalAssociationId": "1242438"
+"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": 16
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29839508')"
+"ID": "1483865"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1472661"
+post_author: 1
+"ListingKey": "29819082"
+"ListingId": "NB140599"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-28T18:00:29Z"
+"RFModificationTimestamp": "2026-05-28T18:36:52Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 775.0
+"LivingArea": 1600.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1A4C6"
+"UnparsedAddress": "9 Winchester Avenue, Moncton, New Brunswick E1A4C6"
+"Coordinates": array:2 [
0 => -64.758933
1 => 46.108866
]
+"Latitude": 46.108866
+"Longitude": -64.758933
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this well cared for bungalow nestled in a family-friendly neighbourhood, close to parks, schools, shopping, and all major amenities. Offered for sale for the very first time, this home has been carefully maintained over the years and is ready for its next chapter. Affordable homeownership is within reach with this solid property priced under $300K. The main level offers 2 bedrooms plus an additional non-conforming bedroom downstairs, along with 1 full bath and a convenient half bath. A mini split heat pump provides efficient year-round comfort. Outside, enjoy a private backyard perfect for relaxing, gardening, or entertaining, complete with a large storage shed for all your tools and seasonal items. Add your own modern touches and this bungalow is an excellent opportunity for first-time buyers, downsizers, or investors looking for value in a desirable location. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Heat Pump"
1 => "Air Conditioned"
]
+"CreationDate": "2026-05-28T18:36:48.065235+00:00"
+"Directions": "Shediac Rd to Milroth, left on Storey and right on Winchester"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Oil"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1940886"
+"ListOfficeKey": "277394"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "775"
+"ParcelNumber": "00785840"
+"PhotosChangeTimestamp": "2026-05-28T17:52:10Z"
+"PhotosCount": 29
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-28T17:52:09Z"
+"TaxAnnualAmount": "2825.11"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29819082/9-winchester-avenue-moncton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 960
+"OriginalEntryTimestamp": "2026-05-28T17:52:09.71Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1238148"
+"ListOfficeNationalAssociationId": "1282568"
+"Media": array:29 [
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]
]
+"DaysOnMarket": 20
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29819082')"
+"ID": "1472661"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25210
+post_id: "1470081"
+post_author: 1
+"ListingKey": "29817549"
+"ListingId": "NB140546"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-01T18:51:01Z"
+"RFModificationTimestamp": "2026-06-01T18:54:02Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 750.0
+"LivingArea": 3300.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1K0A6"
+"UnparsedAddress": "40 Navigateurs, Moncton, New Brunswick E1K0A6"
+"Coordinates": array:2 [
0 => -64.737186
1 => 46.115167
]
+"Latitude": 46.115167
+"Longitude": -64.737186
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 40 Navigateurs, Moncton a stunning 2025 new build offering modern design, quality finishes, and an ideal family-friendly location. This spacious home features approximately 3,300 square feet of fully finished living space, thoughtfully designed to maximize comfort and functionality. With 5 generously sized bedrooms and 2.5 bathrooms, there is ample room for the entire family. The main level offers bright, open-concept living areas perfect for entertaining and everyday living, while the finished basement adds valuable extra space that can be used as a family room, recreation area, home gym, or office. Situated in a desirable area close to Champlain School, this home is perfect for families looking for convenience, community, and access to nearby amenities. The private backyard provides a peaceful outdoor retreat, ideal for relaxing, hosting, or enjoying time with family. A rare opportunity to own a brand-new home in a growing neighbourhoodmodern, spacious, and move-in ready. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Heat Pump"
1 => "Air Conditioned"
]
+"CreationDate": "2026-05-28T17:12:56.738657+00:00"
+"Directions": "From Shediac Road, turn left onto Grengrove Road, turn left onto Ripplewood Road and turn left onto Navigateurs Street."
+"ExteriorFeatures": array:3 [
0 => "Wood"
1 => "Brick"
2 => "Vinyl"
]
+"Flooring": array:3 [
0 => "Hardwood"
1 => "Ceramic"
2 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2185898"
+"ListOfficeKey": "77079"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "750"
+"ParcelNumber": "70693361"
+"PhotosChangeTimestamp": "2026-05-28T15:12:57Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-01T18:43:24Z"
+"TaxAnnualAmount": "8063.88"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29817549/40-navigateurs-moncton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2335
+"OriginalEntryTimestamp": "2026-05-28T15:12:57.79Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1435471"
+"ListOfficeNationalAssociationId": "1096424"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 21
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29817549')"
+"ID": "1470081"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25211
+post_id: "1456314"
+post_author: 1
+"ListingKey": "29798551"
+"ListingId": "NB140222"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T23:50:01Z"
+"RFModificationTimestamp": "2026-06-15T23:51:42Z"
+"ListPrice": 599900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 761.0
+"LivingArea": 2120.0
+"BuildingAreaTotal": 0
+"City": "Moncton"
+"PostalCode": "E1A5R2"
+"UnparsedAddress": "40 Tamarack Terrace, Moncton, New Brunswick E1A5R2"
+"Coordinates": array:2 [
0 => -64.729811
1 => 46.117318
]
+"Latitude": 46.117318
+"Longitude": -64.729811
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this BEAUTIFULLY MAINTAINED, truly TURNKEY two-storey family home located in a HIGHLY DESIRABLE Moncton neighbourhood. Immaculately cared for from top to bottom, this home shows PRIDE OF OWNERSHIP throughout and is in EXCELLENT CONDITION. Perfectly situated for convenience, it is just minutes to the airport, hospital, golf course, and nearby park, which has access straight from the cul-de-sac. First, you are welcomed by a COVERED FRONT DECK, which has three sides enclosed, perfect for enjoying the outdoors while staying sheltered from the weather. Step inside to a SPACIOUS AND INVITING FRONT FOYER featuring a convenient WALK-IN CLOSET, offering both function and elegance upon entry. The main level offers a thoughtful layout with both a BRIGHT LIVING ROOM and a COMFORTABLE FAMILY ROOM, ideal for entertaining or relaxing. WARM WOOD HEAT adds a cozy atmosphere, with the CHIMNEY AND FIREPLACE INSPECTED IN 2025 for peace of mind. The home features 4 GENEROUS BEDROOMS, 2 FULL BATHROOMS, and 1 HALF BATHROOM. The primary bedroom includes a LARGE WALK-IN CLOSET, while additional bedrooms are bright and well-proportioned. Flooring includes HARDWOOD AND TILE for durability and style. Major updates include a ROOF (2023), NEW DECK, and FULLY FENCED BACKYARD (2024). The exterior features BRICK FRONTAGE, MATURE LANDSCAPING, and a PRIVATE BACKYARD OASIS ideal for relaxing or entertaining. Additional highlights include a 200-AMP PANEL, UNDERGROUND WIRING, VINYL WINDOWS, and a 1194 sq ft BASEMENT READY FOR FUTURE DEVELOPMENT. Located on a quiet street with STREETLIGHTS, NEARBY SCHOOLS, and easy access to amenities, this home offers both comfort and convenience in one of Monctons most sought-after areas. A rare opportunity, BOOK YOUR SHOWING TODAY. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-05-25T17:04:30.110292+00:00"
+"Directions": "From Shediac Road, turn onto Glen Grove Road. Continue along Glen Grove Road, then turn onto Tamarack Terrace. Follow Tamarack Terrace into the cul-de-sac; #40 will be ahead on your left."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Colour Loc"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"Flooring": array:2 [
0 => "Tile"
1 => "Hardwood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Baseboard heaters"
1 => "Electric"
2 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2193892"
+"ListOfficeKey": "77090"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Level lot"
2 => "Golf course/parkland"
3 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "761"
+"ParcelNumber": "70130745"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-05-25T12:43:21Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-15T23:43:42Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "5114.49"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=Amfp6SrLrbc&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29798551/40-tamarack-terrace-moncton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2120
+"OriginalEntryTimestamp": "2026-05-25T12:43:21.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1442754"
+"ListOfficeNationalAssociationId": "1121994"
+"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": 24
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29798551')"
+"ID": "1456314"
}
]
+success: true
+page_size: 9
+page_count: 5
+count: 45
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]