array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29838439 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23338
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23340
+post_id: "1487351"
+post_author: 1
+"ListingKey": "29838439"
+"ListingId": "NB140875"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T13:51:04Z"
+"RFModificationTimestamp": "2026-06-02T14:08:34Z"
+"ListPrice": 674900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 1424.0
+"LivingArea": 2700.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B5M2"
+"UnparsedAddress": "79 Colonial Heights Street, Fredericton, New Brunswick E3B5M2"
+"Coordinates": array:2 [
0 => -66.677739
1 => 45.960288
]
+"Latitude": 45.960288
+"Longitude": -66.677739
+"YearBuilt": 1973
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "You really have to visit this home to appreciate the quality of the renovation, the absolutely beautiful property and the lifestyle this home provides. Located in one of Frederictons most desirable neighbourhoods near the golf course and in the Garden Creek School zone, this large bungalow with garage offers almost 3000 square feet of living space. The main floor was completely renovated a few years ago, offering beautiful wide hardwood, all new windows, and a modern aesthetic. Enter into the mudroom and then the huge livingroom which offers two seating areas, a working wood fireplace, and gorgeous front window. The kitchen is modern and features quartz counters, a walk-in pantry, dining area and an amazing orange Bertazzoni stove. The extension at the back of the home provides access to the deck and private backyard. You'll enjoy the newly installed hottub, two tier deck and firepit area while listening to 'Phyllis' -the babbling brook at the back of the property! The main floor also offers two lovely bedrooms with the primary offering a two piece ensuite and another beautiful bathroom. The lower level offers two more large bedrooms with egress windows, a 3rd bathroom, laundry and yet another familyroom. A ducted heat pump offers year round comfort. This home is a truly rare find. (id:62783)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-02T14:08:23.736937+00:00"
+"Directions": "Golf club rd... left on to Colonial Heights St... 79 is on the right."
+"ExteriorFeatures": array:1 [
0 => "Colour Loc"
]
+"Flooring": array:4 [
0 => "Laminate"
1 => "Ceramic"
2 => "Linoleum"
3 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:4 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
3 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1471504"
+"ListOfficeKey": "289196"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Golf course/parkland"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1424"
+"ParcelNumber": "01478254"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-02T13:15:31Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-02T13:44:28Z"
+"TaxAnnualAmount": "6127.39"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=XHVHsjpgV9a"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1649532046"
"RoomType" => "4pc Bathroom"
"ListingId" => "NB140875"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "7'4'' x 4'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.49Z"
]
1 => array:11 [
"RoomKey" => "1649532047"
"RoomType" => "Storage"
"ListingId" => "NB140875"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 4'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
2 => array:11 [
"RoomKey" => "1649532048"
"RoomType" => "Bedroom"
"ListingId" => "NB140875"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 10'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
3 => array:11 [
"RoomKey" => "1649532049"
"RoomType" => "Bedroom"
"ListingId" => "NB140875"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "15'1'' x 13'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
4 => array:11 [
"RoomKey" => "1649532050"
"RoomType" => "Laundry room"
"ListingId" => "NB140875"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "17'3'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
5 => array:11 [
"RoomKey" => "1649532051"
"RoomType" => "Living room"
"ListingId" => "NB140875"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "36'6'' x 24'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
6 => array:11 [
"RoomKey" => "1649532052"
"RoomType" => "Bedroom"
"ListingId" => "NB140875"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "10'1'' x 12'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
7 => array:11 [
"RoomKey" => "1649532053"
"RoomType" => "2pc Ensuite bath"
"ListingId" => "NB140875"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "5'9'' x 4'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
8 => array:11 [
"RoomKey" => "1649532054"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB140875"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 15'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
9 => array:11 [
"RoomKey" => "1649532055"
"RoomType" => "Family room"
"ListingId" => "NB140875"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "12'2'' x 27'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
10 => array:11 [
"RoomKey" => "1649532056"
"RoomType" => "Pantry"
"ListingId" => "NB140875"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "4'9'' x 8'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.5Z"
]
11 => array:11 [
"RoomKey" => "1649532057"
"RoomType" => "Kitchen/Dining room"
"ListingId" => "NB140875"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "18'8'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.51Z"
]
12 => array:11 [
"RoomKey" => "1649532058"
"RoomType" => "Living room"
"ListingId" => "NB140875"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "36' x 13'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.51Z"
]
13 => array:11 [
"RoomKey" => "1649532059"
"RoomType" => "Foyer"
"ListingId" => "NB140875"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29838439"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 4'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-02T13:44:28.51Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29838439/79-colonial-heights-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"RoadSurfaceType": array:1 [
0 => "Paved road"
]
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1500
+"OriginalEntryTimestamp": "2026-06-02T13:15:30.77Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1128041"
+"ListOfficeNationalAssociationId": "1375426"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29838439_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/bbd4039879ffc9c772b468eadf2f9eaa.webp"
"MediaSize" => 189868
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-bbd4039879ffc9c772b468eadf2f9eaa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29838439_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/28c1fbea1ce94b7fb741cf3ebf27f344.webp"
"MediaSize" => 188449
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-28c1fbea1ce94b7fb741cf3ebf27f344.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29838439_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/6e7e2c4d9deaef7c5f6aef5630d2d135.webp"
"MediaSize" => 199134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-6e7e2c4d9deaef7c5f6aef5630d2d135.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29838439_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/85370777f652c9206fae750270635731.webp"
"MediaSize" => 176480
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-85370777f652c9206fae750270635731.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29838439_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/9c6dfa9bf23405f2e85cb1f6f53cb3b5.webp"
"MediaSize" => 72675
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-9c6dfa9bf23405f2e85cb1f6f53cb3b5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29838439_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/13deb7502d50cc2089cac867a2470d1b.webp"
"MediaSize" => 85545
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-13deb7502d50cc2089cac867a2470d1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29838439_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/c7882122211f8b43fbe6befe9ea683f3.webp"
"MediaSize" => 85338
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-c7882122211f8b43fbe6befe9ea683f3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29838439_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/ecbcb9aeecea5f2da89a77b1751f43f1.webp"
"MediaSize" => 101345
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-ecbcb9aeecea5f2da89a77b1751f43f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29838439_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/963035d0a066f859e32310c7b134ef84.webp"
"MediaSize" => 98041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-963035d0a066f859e32310c7b134ef84.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29838439_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/2ba985115f3b639ee282a6ded5cceff5.webp"
"MediaSize" => 77142
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-2ba985115f3b639ee282a6ded5cceff5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29838439_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/29182b52c06506d5abef81e2017895c0.webp"
"MediaSize" => 69831
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-29182b52c06506d5abef81e2017895c0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29838439_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/6360337522a556650ca5630e65ad1b1b.webp"
"MediaSize" => 68503
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-6360337522a556650ca5630e65ad1b1b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29838439_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/30bb60217f85c937daea71a9b51c7fb3.webp"
"MediaSize" => 120987
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-30bb60217f85c937daea71a9b51c7fb3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29838439_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/37138991442dfbd307faba58087faffa.webp"
"MediaSize" => 100417
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-37138991442dfbd307faba58087faffa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29838439_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/fb317f6661064d548cf848829f9e34a9.webp"
"MediaSize" => 95155
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-fb317f6661064d548cf848829f9e34a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29838439_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/39da21dbe89a7559aa4014c1462dc423.webp"
"MediaSize" => 91866
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-39da21dbe89a7559aa4014c1462dc423.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29838439_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/913c279984bd2d5ee6561c5b78f98292.webp"
"MediaSize" => 90766
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-913c279984bd2d5ee6561c5b78f98292.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29838439_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/65295485c8164dfd2faeefb7b1cbef9d.webp"
"MediaSize" => 51598
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-65295485c8164dfd2faeefb7b1cbef9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29838439_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/9662d26895b9bc6fd2156f246d84135e.webp"
"MediaSize" => 98592
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-9662d26895b9bc6fd2156f246d84135e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29838439_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/4a1ea0e440e13c81548ba43509850267.webp"
"MediaSize" => 56216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-4a1ea0e440e13c81548ba43509850267.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29838439_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/675d0fad4a8f710d883aad5ab9da4c72.webp"
"MediaSize" => 110401
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-675d0fad4a8f710d883aad5ab9da4c72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29838439_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/3fe2e3ab7d8293a5ff0666106d7c2181.webp"
"MediaSize" => 86662
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-3fe2e3ab7d8293a5ff0666106d7c2181.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29838439_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/8c9c906707b769fd8ac8fac8498798bb.webp"
"MediaSize" => 108299
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-8c9c906707b769fd8ac8fac8498798bb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29838439_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/52fe582295bfb9555d4760de9b080f10.webp"
"MediaSize" => 99376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-52fe582295bfb9555d4760de9b080f10.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29838439_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/5dc34cdd1f174167c5a3e657a7e4deda.webp"
"MediaSize" => 90932
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-5dc34cdd1f174167c5a3e657a7e4deda.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29838439_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/bceb3e9948e4772a419b99548696a952.webp"
"MediaSize" => 93369
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-bceb3e9948e4772a419b99548696a952.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29838439_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/eae5eb3e019cefb4406a708f517c3245.webp"
"MediaSize" => 91998
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-eae5eb3e019cefb4406a708f517c3245.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29838439_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/952d787cdfb0cc84b1e3e848029ac046.webp"
"MediaSize" => 141041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-952d787cdfb0cc84b1e3e848029ac046.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29838439_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/9fccde39f7927e40db07033d653e0065.webp"
"MediaSize" => 159228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-9fccde39f7927e40db07033d653e0065.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29838439_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/352dcd713a81a087743a8f621dd0dff0.webp"
"MediaSize" => 171645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-352dcd713a81a087743a8f621dd0dff0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29838439_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/e6927fb1b9dc9b2b6ce57c8f2310bb9b.webp"
"MediaSize" => 166244
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-e6927fb1b9dc9b2b6ce57c8f2310bb9b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29838439_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/f2f33ccd7817fb1a39b0bdd5a675da5d.webp"
"MediaSize" => 186472
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-f2f33ccd7817fb1a39b0bdd5a675da5d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29838439_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/6e95c336c6345d08768fc79807792f04.webp"
"MediaSize" => 195578
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-6e95c336c6345d08768fc79807792f04.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29838439_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/3c78fe2f44376183afc045c9d65b95dc.webp"
"MediaSize" => 157704
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-3c78fe2f44376183afc045c9d65b95dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29838439_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/42358088cc2e7a041acea8ab56ae67b7.webp"
"MediaSize" => 160038
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-42358088cc2e7a041acea8ab56ae67b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29838439_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/7bb6151e6e6bd5c4f29cb98fecd9923c.webp"
"MediaSize" => 210736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-7bb6151e6e6bd5c4f29cb98fecd9923c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29838439_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/c69033a7f74788201f9c57708d759178.webp"
"MediaSize" => 156197
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-c69033a7f74788201f9c57708d759178.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29838439_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29838439/db3a34b235b383bbb06da99aecc13c1a.webp"
"MediaSize" => 147857
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29838439/thumbnail-db3a34b235b383bbb06da99aecc13c1a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB140875"
"ResourceRecordKey" => "29838439"
"ModificationTimestamp" => "2026-06-02T13:15:30.78Z"
]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29838439')"
+"ID": "1487351"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289196" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24696
+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 1471504" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24689
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.25 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29838439'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25095
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29838439'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25111
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29838439' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-66.677739 45.960288)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25184
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25158
+post_id: "1516026"
+post_author: 1
+"ListingKey": "29884642"
+"ListingId": "NB141484"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T21:10:15Z"
+"RFModificationTimestamp": "2026-06-10T21:20:15Z"
+"ListPrice": 678000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 1245.0
+"LivingArea": 2037.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B2W5"
+"UnparsedAddress": "170 Oxford Street, Fredericton, New Brunswick E3B2W5"
+"Coordinates": array:2 [
0 => -66.661289
1 => 45.949845
]
+"Latitude": 45.949845
+"Longitude": -66.661289
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to your very own Oasis On The Hill! Enter the front door to a bright and open living room, dining room and kitchen, perfect for entertaining or family gatherings. The living room has a wood burning insert, perfect for those cold winter days. The home also has a ductless heat pump for those hot summer days. From the dining room are patio doors leading to your private backyard oasis, with pool, spacious deck, privacy and green space creating the perfect place to relax and entertain. Upstairs is the Primary bedroom with ensuite with double vanity and glass and tile shower. Two more good size bedrooms and full bath complete this level. Downstairs there is a family room, 4th bedroom, den/office, laundry room and bathroom. Upstairs off the dining room is a large mudroom leading to your attached garage. Don't wait, this home won't last long! (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "3 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-10T20:07:17.929366+00:00"
+"Directions": "Fredericton South to Smythe St, to Eglinton St to Oxford St"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Vinyl"
1 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:5 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Stove"
3 => "Electric"
4 => "Wood"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1779773"
+"ListOfficeKey": "52805"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1245"
+"ParcelNumber": "01479567"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-10T19:41:09Z"
+"PhotosCount": 42
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T21:00:32Z"
+"TaxAnnualAmount": "9005.35"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=8LmUFTmwiAm"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1656520536"
"RoomType" => "Laundry room"
"ListingId" => "NB141484"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "15'0'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.57Z"
]
1 => array:11 [
"RoomKey" => "1656520537"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB141484"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "4'10'' x 5'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.57Z"
]
2 => array:11 [
"RoomKey" => "1656520538"
"RoomType" => "Office"
"ListingId" => "NB141484"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "8'10'' x 7'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.58Z"
]
3 => array:11 [
"RoomKey" => "1656520539"
"RoomType" => "Bedroom"
"ListingId" => "NB141484"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "13'11'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.58Z"
]
4 => array:11 [
"RoomKey" => "1656520540"
"RoomType" => "Family room"
"ListingId" => "NB141484"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "12'4'' x 13'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.59Z"
]
5 => array:11 [
"RoomKey" => "1656520541"
"RoomType" => "Bath (# pieces 1-6)"
"ListingId" => "NB141484"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.59Z"
]
6 => array:11 [
"RoomKey" => "1656520542"
"RoomType" => "Bedroom"
"ListingId" => "NB141484"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "11'6'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.6Z"
]
7 => array:11 [
"RoomKey" => "1656520543"
"RoomType" => "Bedroom"
"ListingId" => "NB141484"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "9'8'' x 9'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.6Z"
]
8 => array:11 [
"RoomKey" => "1656520544"
"RoomType" => "Ensuite"
"ListingId" => "NB141484"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "11'1'' x 4'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.61Z"
]
9 => array:11 [
"RoomKey" => "1656520545"
"RoomType" => "Primary Bedroom"
"ListingId" => "NB141484"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "12'11'' x 10'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.61Z"
]
10 => array:11 [
"RoomKey" => "1656520546"
"RoomType" => "Mud room"
"ListingId" => "NB141484"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "8'11'' x 14'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.62Z"
]
11 => array:11 [
"RoomKey" => "1656520547"
"RoomType" => "Dining room"
"ListingId" => "NB141484"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 9'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.62Z"
]
12 => array:11 [
"RoomKey" => "1656520548"
"RoomType" => "Kitchen"
"ListingId" => "NB141484"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "11'7'' x 17'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.63Z"
]
13 => array:11 [
"RoomKey" => "1656520549"
"RoomType" => "Living room"
"ListingId" => "NB141484"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29884642"
"RoomLength" => null
"RoomDimensions" => "12'6'' x 24'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-10T21:00:32.63Z"
]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29884642/170-oxford-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1443
+"OriginalEntryTimestamp": "2026-06-10T19:41:09.44Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1187594"
+"ListOfficeNationalAssociationId": "1094072"
+"Media": array:42 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29884642_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/496b146f4d744f0aef7b9ee1480b297f.webp"
"MediaSize" => 212020
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-496b146f4d744f0aef7b9ee1480b297f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29884642_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/452f36067ec53047590fa59d869768a7.webp"
"MediaSize" => 83080
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-452f36067ec53047590fa59d869768a7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29884642_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/97cd2b2f2ac3ac4844a67e6b3fa93248.webp"
"MediaSize" => 70177
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-97cd2b2f2ac3ac4844a67e6b3fa93248.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29884642_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/2be18bcdc77b03c5c8384865e233a245.webp"
"MediaSize" => 79374
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-2be18bcdc77b03c5c8384865e233a245.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29884642_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/0d4e13f2b434105b42cc401489464c1d.webp"
"MediaSize" => 85938
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-0d4e13f2b434105b42cc401489464c1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29884642_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/39045520a25c900ec35fbf0d23d31826.webp"
"MediaSize" => 83123
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-39045520a25c900ec35fbf0d23d31826.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29884642_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/26cb5a192a52f2438e1d18cd019d7e85.webp"
"MediaSize" => 78669
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-26cb5a192a52f2438e1d18cd019d7e85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29884642_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/f0c7832d801e0c54962108c22cf28238.webp"
"MediaSize" => 81041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-f0c7832d801e0c54962108c22cf28238.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29884642_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/bad9c47895075fcda4cf801c96df4b24.webp"
"MediaSize" => 89412
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-bad9c47895075fcda4cf801c96df4b24.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29884642_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/4ee949d4dd6fda9b97ffaeda8c982bf1.webp"
"MediaSize" => 81199
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-4ee949d4dd6fda9b97ffaeda8c982bf1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29884642_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/dfc5486e25f2ea4b199ab01561ab0027.webp"
"MediaSize" => 89221
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-dfc5486e25f2ea4b199ab01561ab0027.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29884642_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/75b8bb8aad849fa7551785d9dab41a68.webp"
"MediaSize" => 72736
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-75b8bb8aad849fa7551785d9dab41a68.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29884642_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/b98f7bf0e95665aacd6ea28aa2d5fe02.webp"
"MediaSize" => 59084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29884642/thumbnail-b98f7bf0e95665aacd6ea28aa2d5fe02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "NB141484"
"ResourceRecordKey" => "29884642"
"ModificationTimestamp" => "2026-06-10T19:41:09.45Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29884642_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29884642/e3fab5c805b944b7e351c27f5a60778d.webp"
…10
]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29884642')"
+"ID": "1516026"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25179
+post_id: "1514649"
+post_author: 1
+"ListingKey": "29882443"
+"ListingId": "NB141395"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T16:20:11Z"
+"RFModificationTimestamp": "2026-06-10T16:36:33Z"
+"ListPrice": 299900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1119.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B9K7"
+"UnparsedAddress": "158 Hanwell Road Unit# 309, Fredericton, New Brunswick E3B9K7"
+"Coordinates": array:2 [
0 => -66.668724
1 => 45.960085
]
+"Latitude": 45.960085
+"Longitude": -66.668724
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to Sunshine Terrace, ideally located in Fredericton's highly sought-after Sunshine Gardens neighbourhood. This rare 2-bedroom, 2-bathroom corner unit offers over 1,100 sq. ft. of bright, thoughtfully designed living space and is one of only a few units in the building featuring this desirable layout. Constructed with solid concrete, the building provides exceptional soundproofing and energy efficiency for comfortable, low-maintenance living year-round. The open-concept design is perfect for both everyday living and entertaining. The spacious kitchen features an abundance of cabinetry and storage, ample counter space, and a full-size island with breakfast bar seating, all overlooking the dining and living areas. The sun-filled living room offers patio door access to a private balcony, while a walk-in pantry/storage room off the front foyer provides additional convenience and functionality. The primary bedroom features a double closet and private ensuite bath. The second bedroom is generously sized, also offering a double closet and easy access to the main bathroom. As a third-floor corner unit, the condo benefits from additional windows and an abundance of natural light throughout. Located directly across from Odell Park and its 400+ acres of walking trails and green space, this property offers the perfect blend of nature and convenience. Shopping, dining, recreation facilities, universities, and downtown Fredericton are all just minutes away. Residents also enjoy a secure elevator building, an exclusive parking space, and a community room. A rare opportunity to own a spacious, bright, and well-located condo in one of Fredericton's most desirable areas. Book your private showing today. (id:62783)"
+"AssociationFee": "465"
+"AssociationFeeFrequency": "Monthly"
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-10T16:36:15.756893+00:00"
+"Directions": "Hanwell road to #158 (Corner of Hanwell Road and Waggoner's Lane) Can access driveway on Hanwell or Waggoner's Lane."
+"ExteriorFeatures": array:1 [
0 => "Stucco"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Carpeted"
2 => "Ceramic"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1873924"
+"ListOfficeKey": "270874"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Level lot"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "75433722"
+"PhotosChangeTimestamp": "2026-06-10T16:14:54Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T16:14:53Z"
+"TaxAnnualAmount": "3173.92"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=M79D5MEsD5A"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29882443/158-hanwell-road-unit-309-fredericton"
+"StructureType": array:1 [
0 => "Apartment"
]
+"CoListAgentKey": "1435139"
+"CommonInterest": "Condo/Strata"
+"CoListAgentKey2": "2193891"
+"CoListAgentKey3": "2189911"
+"CoListOfficeKey": "270874"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "270874"
+"CoListOfficeKey3": "270874"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1119
+"OriginalEntryTimestamp": "2026-06-10T16:14:53.84Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1203867"
+"ListOfficeNationalAssociationId": "1237075"
+"CoListAgentNationalAssociationId": "1086061"
+"CoListAgentNationalAssociationId2": "1442753"
+"CoListAgentNationalAssociationId3": "1439018"
+"CoListOfficeNationalAssociationId": "1237075"
+"CoListOfficeNationalAssociationId2": "1237075"
+"CoListOfficeNationalAssociationId3": "1237075"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29882443')"
+"ID": "1514649"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25157
+post_id: "1513623"
+post_author: 1
+"ListingKey": "29878179"
+"ListingId": "NB141532"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-10T22:20:04Z"
+"RFModificationTimestamp": "2026-06-10T22:37:10Z"
+"ListPrice": 639900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 783.0
+"LivingArea": 2103.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B7A6"
+"UnparsedAddress": "140 Coburn Court, Fredericton, New Brunswick E3B7A6"
+"Coordinates": array:2 [
0 => -66.69641
1 => 45.963932
]
+"Latitude": 45.963932
+"Longitude": -66.69641
+"YearBuilt": 2005
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "The owner wasnt house hunting that day. She was simply driving through the neighbourhood when something made her slow down. It was the trees. Streets that curved beneath a canopy of mature growth.A neighbourhood that felt discovered, not developed. It didnt feel flat. It didnt feel characterless. It felt established. And then, she saw the For Sale sign. Mins from downtown & uptown, yet it feels entirely removed from both. And years later, thats still what the owners love most! Inside, extensive updates are immediately evident incl beautifully renovated eat-in kitchen w/ premium leathered granite stone tops, updated baths w/ heated floors (incl a complete ""to the studs"" rebuild of the primary), new windows & roof shingles with a 50yr warranty. 4bdrms, 2.5 bath & an oversized 2-car garage w/ separate storage room. But what truly sets this property apart happens behind the house. Step outside the wall to wall glass patio doors and you'll feel transported. The lush, moss-covered bank feels like a private nature retreat where the city disappears. Fully fenced, this courtyard-style outdoor space was designed for slowing down. Premium stonework, a two-tier patio, pergola, hot tub, mature landscaping, and rare privacy for an urban city property. And thats before you even discover the staircase. At the top of the bank is one of the propertys best-kept secrets. A private perch overlooking the city below. A place to gather thoughts & take in the panoramic view. And behind that view sits protected generational family land owned. Horse stables & paddocks, with the occasional neighing of horses drifting across the breeze. Its a property that reminds you why location matters. Where kids ride bikes to the city-owned playground at the end of the cul-de-sac, and Garden Creek School is an easy walk away.Because while kitchens can be renovated & finishes can be changed, its impossible to recreate a neighbourhood that simply feels right. And thats exactly what 140 Coburn offers (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Split entry bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Heat Pump"
1 => "Air Conditioned"
]
+"CreationDate": "2026-06-09T20:12:57.551904+00:00"
+"Directions": "Woodstock Road to Brentwood to Coburn Court, home is on the right hand side (or, from Garden Creek School, take Kingswood Drive to Coburn Drive, which becomes Coburn Court)"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Carpeted"
2 => "Stone"
3 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Insulated Concrete Forms"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933114"
+"ListOfficeKey": "52787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Cul-de-sac"
1 => "Treed"
2 => "Sloping"
]
+"LotSizeDimensions": "783"
+"ParcelNumber": "75286781"
+"ParkingFeatures": array:4 [
0 => "Integrated Garage"
1 => "Garage"
2 => "Garage"
3 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-09T19:41:03Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-10T22:14:00Z"
+"TaxAnnualAmount": "5588.23"
+"View": "River view"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/140_coburn_dr_fredericton_nb/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29878179/140-coburn-court-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"ZoningDescription": "R1 Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1421
+"OriginalEntryTimestamp": "2026-06-09T19:41:03.83Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1233276"
+"ListOfficeNationalAssociationId": "1007091"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29878179')"
+"ID": "1513623"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25181
+post_id: "1510985"
+post_author: 1
+"ListingKey": "29874670"
+"ListingId": "NB141130"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-09T12:35:35Z"
+"RFModificationTimestamp": "2026-06-09T17:45:21Z"
+"ListPrice": 449900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 766.0
+"LivingArea": 1089.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B1W1"
+"UnparsedAddress": "138 Victoria Street, Fredericton, New Brunswick E3B1W1"
+"Coordinates": array:2 [
0 => -66.65551
1 => 45.957887
]
+"Latitude": 45.957887
+"Longitude": -66.65551
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to this charming and well-maintained 3-bedroom home, ideally situated in one of downtown's most convenient and sought-after neighbourhoods. Just steps from Superstore, Wilmot Park, walking trails, schools, shopping, and a wide range of amenities, this property offers an exceptional lifestyle with everything you need close at hand. Inside, you'll find bright and inviting living spaces that blend comfort and character. The thoughtfully updated bathroom features modern finishes while complementing the home's timeless appeal. Whether you're relaxing with family or entertaining guests, the functional layout provides a warm and welcoming atmosphere throughout. A standout feature of this property is the oversized backyardan increasingly rare offering in the downtown core. With ample space for gardening, outdoor entertaining, children's play areas, or simply enjoying the outdoors, this expansive lot provides endless opportunities to suit your lifestyle. Perfect for first-time home buyers, downsizers, or anyone seeking the convenience of downtown living combined with exceptional outdoor space, this property presents a unique opportunity in a highly desirable location. (id:62783)"
+"Cooling": array:1 [
0 => "Air Conditioned"
]
+"CreationDate": "2026-06-09T17:43:55.636603+00:00"
+"Directions": "Smythe to Victoria, house on right."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:1 [
0 => "Laminate"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2151159"
+"ListOfficeKey": "283841"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "766"
+"ParcelNumber": "01442292"
+"PhotosChangeTimestamp": "2026-06-09T12:28:44Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-09T12:28:44Z"
+"Stories": "1.5"
+"TaxAnnualAmount": "3296.1"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=LxihBgBevKj"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29874670/138-victoria-street-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2195141"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "283841"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1089
+"OriginalEntryTimestamp": "2026-06-09T12:28:44.54Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1401951"
+"ListOfficeNationalAssociationId": "1335718"
+"CoListAgentNationalAssociationId": "1443762"
+"CoListOfficeNationalAssociationId": "1335718"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29874670')"
+"ID": "1510985"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25159
+post_id: "1502094"
+post_author: 1
+"ListingKey": "29859674"
+"ListingId": "NB140769"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-07T19:20:47Z"
+"RFModificationTimestamp": "2026-06-07T19:37:32Z"
+"ListPrice": 149900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 976.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B7K9"
+"UnparsedAddress": "304 Governor Lane, Fredericton, New Brunswick E3B7K9"
+"Coordinates": array:2 [
0 => -66.689969
1 => 45.954478
]
+"Latitude": 45.954478
+"Longitude": -66.689969
+"YearBuilt": 1985
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Welcome to 304 Governor Lane, a cozy and private 2-bedroom, 1-bath mini home located in Kelly's Community Park just off Hanwell Road. Surrounded by mature trees and nature, this property offers a peaceful setting with extra privacy, added outdoor space, and a more tucked-away feel than you typically find in a mini home community. Inside, the layout is comfortable, open, and efficient, with a heat pump to help keep heating and cooling costs manageable year-round. The home also offers added versatility with multiple access points, including entrances through the second bedroom, the front kitchen, and a side entry leading into a practical mudroom/storage area - providing flexibility for everyday living, guests, or bringing in groceries and outdoor gear. This home offers a dedicated laundry and storage room as well for an added bonus. Whether you're a first-time buyer, downsizing, or looking for an affordable low-maintenance option close to Fredericton, this home offers great value in a convenient location. Enjoy the quiet, natural surroundings while still being just a short drive to Hanwell amenities, schools, recreation, and the city. With tree cover, privacy, and room to enjoy the outdoors, 304 Governor Lane is a great option for anyone wanting affordability without giving up a sense of space and calm. (id:62650)"
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-05T15:21:22.676969+00:00"
+"Directions": "From Hanwell Road, turn onto Osmond Lane, first right then first left and continue straight to Governor Lane. Home is near the end of the street on the left civic #304"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Carpeted"
1 => "Vinyl"
]
+"FoundationDetails": array:2 [
0 => "Block"
1 => "Pillars & Posts"
]
+"Heating": array:2 [
0 => "Heat Pump"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2148606"
+"ListOfficeKey": "52805"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Sloping"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0"
+"ParcelNumber": "PAN# 00608167"
+"PhotosChangeTimestamp": "2026-06-05T14:54:49Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-07T19:13:31Z"
+"TaxAnnualAmount": "495.95"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=94ktoAdERAr&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29859674/304-governor-lane-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Leasehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 976
+"OriginalEntryTimestamp": "2026-06-05T14:54:49.14Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1399591"
+"ListOfficeNationalAssociationId": "1094072"
+"Media": array:49 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29859674')"
+"ID": "1502094"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25154
+post_id: "1490308"
+post_author: 1
+"ListingKey": "29846972"
+"ListingId": "NB140983"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T16:50:16Z"
+"RFModificationTimestamp": "2026-06-03T17:14:26Z"
+"ListPrice": 549900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 906.0
+"LivingArea": 2161.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B3G6"
+"UnparsedAddress": "807 Smythe, Fredericton, New Brunswick E3B3G6"
+"Coordinates": array:2 [
0 => -66.66235
1 => 45.951539
]
+"Latitude": 45.951539
+"Longitude": -66.66235
+"YearBuilt": 1964
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Ideally situated on Fredericton's sought-after southside, this beautifully updated two-storey home offers exceptional convenience just minutes from schools, universities, walking trails, O'Dell Park, shopping, and everyday amenities. Over the years, the property has undergone extensive renovations, including updated siding, windows, kitchen, bathrooms, and a new roof in 2022, providing peace of mind for years to come. Step inside through the practical mudroomperfect for organizing seasonal gear and outdoor essentials. A French door leads into the heart of the home, where porcelain tile flooring transitions into a stylishly renovated kitchen featuring stainless steel appliances, a tiled backsplash, soft-close cabinetry, and thoughtfully designed pull-out storage. The bright dining area is enhanced by a charming bay window and flows seamlessly into the inviting living room, both accented by beautiful hardwood flooring. A convenient half bath and access to the rear deck complete the main level, making it ideal for both everyday living and entertaining. Upstairs, you'll find three spacious bedrooms and a renovated full bathroom. A standout feature is the covered balcony, complete with privacy roller shades and a television hookupan ideal space to relax and unwind. The lower level presents so much versatility. Excellent mortgage-helper, inlaw suite or investment opportunity with a self-contained studio apartment on its own electrical meter. The apartment shares access to a laundry area and storage room while maintaining excellent separation from the main living space. Whether you're looking for a family home with modern updates or a property that offers additional income potential, this versatile southside residence is one you won't want to miss. (id:62783)"
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Heat Pump"
]
+"CreationDate": "2026-06-03T17:14:19.376842+00:00"
+"Directions": "Drive up Smythe and open your eyes and you will see it"
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"Flooring": array:3 [
0 => "Laminate"
1 => "Ceramic"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1986675"
+"ListOfficeKey": "289196"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "906"
+"ParcelNumber": "01441245"
+"PhotosChangeTimestamp": "2026-06-03T16:43:34Z"
+"PhotosCount": 46
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-03T16:43:34Z"
+"Stories": "2.0"
+"TaxAnnualAmount": "8640.95"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29846972/807-smythe-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2005765"
+"CommonInterest": "Freehold"
+"CoListAgentKey2": "2058872"
+"CoListOfficeKey": "289196"
+"GeocodeManualYN": false
+"CoListOfficeKey2": "289196"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1552
+"OriginalEntryTimestamp": "2026-06-03T16:43:34.75Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1271082"
+"ListOfficeNationalAssociationId": "1375426"
+"CoListAgentNationalAssociationId": "1288160"
+"CoListAgentNationalAssociationId2": "1334434"
+"CoListOfficeNationalAssociationId": "1375426"
+"CoListOfficeNationalAssociationId2": "1375426"
+"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": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29846972')"
+"ID": "1490308"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23352
+post_id: "1487350"
+post_author: 1
+"ListingKey": "29841967"
+"ListingId": "NB135635"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-08T18:55:07Z"
+"RFModificationTimestamp": "2026-06-08T18:59:02Z"
+"ListPrice": 324900.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 929.0
+"LivingArea": 840.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B7T2"
+"UnparsedAddress": "330 Rainsford Lane, Fredericton, New Brunswick E3B7T2"
+"Coordinates": array:2 [
0 => -66.69798
1 => 45.953638
]
+"Latitude": 45.953638
+"Longitude": -66.69798
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "Beautifully refreshed and move-in ready, this charming one-level home offers comfort, style, and easy living in a coveted neighbourhood just minutes from both uptown and downtown. Set on a large lot with mature maple trees, the property offers a lovely outdoor setting with space to enjoy, garden, entertain, or simply relax. The home has seen many thoughtful updates in recent years, including exterior improvements such as roof shingles, siding, windows, an air exchanger, and a spacious 12' x 16' deck, perfect for barbecues, outdoor dining, or quiet evenings outside. Inside, the updated kitchen features dark cabinetry, light granite countertops, tiled flooring, a stylish backsplash, and an undermount sink. Updated gray-toned flooring flows throughout the home, giving it a clean, modern feel. The main level offers two comfortable-sized bedrooms, a full bathroom with laundry area, and a practical layout that makes this an excellent option for downsizers, first-time buyers, or anyone looking for convenient one-level living. With many important updates already completed, this home is ready for its next owner and can accommodate a quick closing. (id:62650)"
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:1 [
0 => "Crawl space"
]
+"CreationDate": "2026-06-02T20:27:35.626294+00:00"
+"Directions": "From Prospect Street: Head toward Hanwell Road / NB 640 South. At the roundabout take the 2nd exit onto Patience Lane. Turn left onto Rainsford Lane. The house is on the right."
+"ExteriorFeatures": array:1 [
0 => "Vinyl"
]
+"Flooring": array:2 [
0 => "Laminate"
1 => "Porcelain Tile"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2091660"
+"ListOfficeKey": "52805"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "929"
+"ParcelNumber": "01499680"
+"PhotosChangeTimestamp": "2026-06-02T19:44:27Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-08T18:45:55Z"
+"TaxAnnualAmount": "4403.82"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=FQ7DcmddEuH&mls=1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29841967/330-rainsford-lane-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"RoadSurfaceType": array:1 [
0 => "Paved road"
]
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 840
+"OriginalEntryTimestamp": "2026-06-02T19:44:27.2Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1364229"
+"ListOfficeNationalAssociationId": "1094072"
+"Media": array:34 [
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]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29841967')"
+"ID": "1487350"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25182
+post_id: "1480739"
+post_author: 1
+"ListingKey": "29834689"
+"ListingId": "NB140760"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-02T22:20:17Z"
+"RFModificationTimestamp": "2026-06-02T22:24:17Z"
+"ListPrice": 519900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 1285.0
+"LivingArea": 1827.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B2S4"
+"UnparsedAddress": "10 Shamrock Terrace, Fredericton, New Brunswick E3B2S4"
+"Coordinates": array:2 [
0 => -66.661438
1 => 45.954251
]
+"Latitude": 45.954251
+"Longitude": -66.661438
+"YearBuilt": 1955
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "There's ""The Hill"", and then there's the terraces. Some neighbourhoods in Fredericton have a reputation for a reason. And homes beside ODell Park are one of them!10 Shamrock Terrace sits perched at the end of a quiet court directly beside O'Dell. A lifestyle location where you can finish work and be walking through the woods (or teeing off at your favourite course!) five minutes later. Where downtown dinners, Boyce Farmers Market mornings, grocery runs, schools, universities & nature trails all exist within the same small radius of your life. And where despite being this connected...it still feels as peaceful as the country. The home has already gone through extensive updates over the years, apparent immediately from the composite front deck entry & mudroom addition.The space inside feels warm, functional, and well thought out, with a level of efficiency that makes every square foot count. Natural light pours through the main level, while the living rooms wood-burning fireplace heats the whole space. Kitchen is ergonomically planned and connects the spaces beautifully between the oversized dining room & living rooms. Three bedrooms & full bath complete the upper level, while downstairs gives you the flexibility of a 4th bedroom, oversized family/games room, half bath & storage. Outside, the pie-shaped lot has been meticulously maintained w/ mature landscaping, manicured lawns, detached garage, workshop & paved driveway. You won't know you're in the city when you sit on your back patio, with nothing but mature trees and the sounds of birds chirping surrounding you. Tons of upgrades throughout but truthfully, if you ask the current owners what theyll miss most, its not a feature inside the house. Its the proximity, the park and the lifestyle that comes with it. Locals wait for a home on ""The Terraces'. And once you live here, youll understand exactly why. (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Bungalow"
1 => "2 Level"
]
+"BathroomsPartial": 1
+"Cooling": array:2 [
0 => "Heat Pump"
1 => "Air Conditioned"
]
+"CreationDate": "2026-06-01T19:30:30.307101+00:00"
+"Directions": "The terraces backing onto Odell! Smythe Street from the Superstore, right onto Shamrock, #10 is the last home at the very top of the court"
+"ExteriorFeatures": array:2 [
0 => "Vinyl"
1 => "Other"
]
+"Flooring": array:3 [
0 => "Tile"
1 => "Laminate"
2 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Block"
]
+"Heating": array:6 [
0 => "Heat Pump"
1 => "Stove"
2 => "Electric"
3 => "Natural gas"
4 => "Wood"
5 => "Hot Water"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1933114"
+"ListOfficeKey": "52787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Cul-de-sac"
1 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "1285"
+"ParcelNumber": "01441062"
+"ParkingFeatures": array:2 [
0 => "Detached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T18:43:20Z"
+"PhotosCount": 43
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-06-02T22:14:39Z"
+"TaxAnnualAmount": "4701.12"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "New Brunswick"
+"ListAORKey": "84"
+"ListingURL": "www.realtor.ca/real-estate/29834689/10-shamrock-terrace-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 1237
+"OriginalEntryTimestamp": "2026-06-01T18:43:20.08Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1233276"
+"ListOfficeNationalAssociationId": "1007091"
+"Media": array:43 [
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]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29834689')"
+"ID": "1480739"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25183
+post_id: "1476087"
+post_author: 1
+"ListingKey": "29825727"
+"ListingId": "NB139901"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-05-31T20:50:16Z"
+"RFModificationTimestamp": "2026-05-31T20:54:04Z"
+"ListPrice": 694900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.28
+"LivingArea": 3639.0
+"BuildingAreaTotal": 0
+"City": "Fredericton"
+"PostalCode": "E3B7A6"
+"UnparsedAddress": "215 Coburn Court, Fredericton, New Brunswick E3B7A6"
+"Coordinates": array:2 [
0 => -66.694468
1 => 45.964314
]
+"Latitude": 45.964314
+"Longitude": -66.694468
+"YearBuilt": 1992
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "New Brunswick REALTORS®"
+"PublicRemarks": "River Views & Parkside Living in Fredericton South! Tucked away at the very end of a quiet cul-de-sac is a home way larger than it looks! With over 3,000 square feet of finished living space, 215 Coburn Court offers the rare combination of architectural warmth and modern functionality that is ideal for todays growing family. And yes, youre within walking distance to Garden Creek Elementary. Clad in timeless cedar siding, the homes immediate charm is found on the expansive wraparound porch. Its the ultimate setting for sunrise coffees (or sunset cocktails) paired with peekaboo views of the Saint John River. The main level has key features for a growing family including; a large entry with storage from the garage, a huge eat-in kitchen with a large pantry and sightlines into the living room, and a primary bedroom with large ensuite bath (1 of 3 full bathrooms in the house!). The walk-out lower level is a masterclass in versatility. It features a generous secondary living space anchored by a WETT-certified wood stove and two additional bedrooms, including a newly added fourth bedroom with a proper egress window. Stay comfortable year-round with newly installed ductless heat pumps and enjoy the seamless functionality of bi-level interior access to the attached double-car garage. Backing directly onto a lush residential park, the yard becomes a gateway to endless play. Quick access to the trail and Frederictons downtown give this home the ideal Fredericton South lifestyle. Welcome to the court! (id:62650)"
+"ArchitecturalStyle": array:2 [
0 => "Ranch"
1 => "2 Level"
]
+"Cooling": array:2 [
0 => "Heat Pump"
1 => "Air Conditioned"
]
+"CreationDate": "2026-05-29T18:36:33.866605+00:00"
+"Directions": "Woodstock Road to Brentwood Dr to Coburn Court."
+"ExteriorFeatures": array:2 [
0 => "Cedar shingles"
1 => "Wood"
]
+"Flooring": array:4 [
0 => "Tile"
1 => "Laminate"
2 => "Stone"
3 => "Wood"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Baseboard heaters"
2 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1999423"
+"ListOfficeKey": "52787"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Balcony/Deck/Patio"
]
+"LotSizeDimensions": "0.28"
+"ParcelNumber": "75287177"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-05-29T18:15:02Z"
+"PhotosCount": 39
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "New Brunswick"
+"StatusChangeTimestamp": "2026-05-31T20:43:09Z"
+"TaxAnnualAmount": "6156.61"
+"View": "River view"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=ixFVVuVAj3u"
+"WaterBodyName": "Saint John River"
+"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/29825727/215-coburn-court-fredericton"
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1933114"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "52787"
+"GeocodeManualYN": false
+"RoadSurfaceType": array:1 [
0 => "Paved road"
]
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 2
+"AboveGradeFinishedArea": 1803
+"OriginalEntryTimestamp": "2026-05-29T18:15:02.47Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"ListAgentNationalAssociationId": "1288161"
+"ListOfficeNationalAssociationId": "1007091"
+"CoListAgentNationalAssociationId": "1233276"
+"CoListOfficeNationalAssociationId": "1007091"
+"Media": array:39 [
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]
]
+"DaysOnMarket": 12
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29825727')"
+"ID": "1476087"
}
]
+success: true
+page_size: 9
+page_count: 4
+count: 32
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]